S_TN_USR_X (ver 16.12.5)
This table is a extension of the Users table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| UsersDCID | 16.12.5 | Number(10,0) | The key that links to the Users table. |
| Recreate_060_YN | 16.12.5 | Varchar2(1) | Determines if the user will have the 060 extract data recreated. |
| Recreate_062_YN | 16.12.5 | Varchar2(1) | Determines if the user will have the 062 extract data recreated. |
| Recreate_063_YN | 16.12.5 | Varchar2(1) | Determines if the user will have the 063 extract data recreated. |
| NameSuffix | 16.12.5 | Varchar2(10) | Staff name suffix. |
| State_ExcludeFromReporting | 17.6.0 | Number(1,0) | Exclude from State Reporting. |
| InstructionalProgramNbr | 17.6.0 | Varchar2(2) | Instructional Program Number. |
| LicenseNumber | 17.6.0 | Varchar2(9) | License Number. |
| LicensureCheck | 17.6.0 | Varchar2(1) | Licensure Check. |
| WorkStatus | 17.6.0 | Varchar2(1) | Staff work status. |
| HireDate | 19.9.2.0 | Date | Staff hire date. |
| ExitDate | 19.9.2.0 | Date | Staff exit date. |
| Cell_Phone | 19.9.2.0 | Number(10,0) | Staff cellular phone number. |
| LIC_FNAME | 22.6.1.0 | VARCHAR2(20) | License FirstName |
| LIC_LNAME | 22.6.1.0 | VARCHAR2(20) | License LastName |
| LIC_MNAME | 22.6.1.0 | VARCHAR2(20) | License MiddleName |
| LICNAME_EDFI_YN | 22.6.1.0 | VARCHAR2(20) | Flag to use License Name field in EDFI. |