S_NY_USR_X (ver 16.1.0)
This table is an extension of the [Users] table, which maintains additional user details.
Column Name | Version | Data Type | Description |
|---|---|---|---|
UsersDCID | 16.1.0 | Number(10,0) | Primary key that relates the extended table to the [Users] table. |
| DistrictExitDate | 16.1.0 | Date | The date the staff member left the employ of the district. Migrates from [Teachers]NY_Exit_Date. |
| DistrictHireDate | 16.1.0 | Date | The date the staff member was originally hired by the the district. Migrates from [Teachers]NY_Org_Hire_Date. |
| State_ExcludeFromReporting | 16.1.0 | Number(1,0) | Indicates whether or not the employee should be excluded from state reporting. Migrates from [Teachers]NY_ExcludeStaff. |
| StateStaffID | 16.1.0 | Varchar2(12) | The unique identifying number assigned by the state to the employee. Migrates from [Teachers]NY_StaffID. |
| TenureDate | 16.1.0 | Date | The date the staff member attained tenure as a teacher. Migrates from [Teachers]NY_Tenure_Date |
| YearsInDistrict | 16.1.0 | Number(11,0) | The number of years the employee has been employed in the district. Migrates from [Teachers]NY_Yrs_In_Dist. |