S_USR_X (ver 19.9.2.0)
This table is an extension of the [Users] table. This table is available for all states and provinces and might or might not be utilized for your state or province.
Column Name | Version | Data Type | Description |
|---|---|---|---|
UsersDCID | 19.9.2.0 | Number(10,0) | Primary Key |
Cell_Phone | 19.9.2.0 | Varchar2(20) | The staff member's cell phone number. |
DeviceAccess | 21.8.2.0 | Varchar2(5) | The Device Access is a part of Staff Digital Resource data. For example : Personal Dedicated - The device is personal and not shared, Personal Shared - The device personal but shared etc.. |
DeviceType | 21.8.2.0 | Varchar2(10) | The Device Type is a part of Staff Digital Resource data. For example : Desktop Computer, Laptop Computer etc.. |
EmploymentStatus | 20.6.2.0 | Varchar2(50) | The staff member's employment status. |
ExcludeFromEdFi | 19.11.1.0 | Number(1,0) | Indication of whether a user is excluded from EdFi Publishing. |
ExitDate | 19.9.2.0 | Date | The staff member's exit date. |
FullTimeEquivalency | 20.6.2.0 | Number(25,10) | The staff member's full time equivalency. |
GenerationCodeSuffix | 19.11.1.0 | Varchar2(10) | Denotes an individual's generation in their family, e.g. Jr., Sr., III. |
HighlyQualifiedTeacher | 19.11.1.0 | Number(1,0) | Indication of whether a teacher is classified as highly qualified for his/her assignment. |
HireDate | 19.9.2.0 | Date | The staff member's hire date. |
InternetAccess | 21.8.2.0 | Varchar2(5) | The Internet Access Type is a part of Staff Digital Resource data. For example : Fiber, Cable DSL etc.. |
InternetInResidence | 21.8.2.0 | Varchar2(5) | The Internet Access In Residence is a part of Staff Digital Resource data. Options are Yes or No. |
InternetPerformance | 21.8.2.0 | Varchar2(5) | The Internet Performance is a part of Staff Digital Resource data. For example : Yes, reliable with no issues, Yes, but not consistent etc.. |
LevelOfEducation | 19.11.1.0 | Varchar2(50) | The highest grade in school that the staff member has completed or the highest degree received - Ed-Fi descriptor. |
Name_Suffix | 21.5.2.0 | Varchar2(10) | The suffix for the Name fields in Staff. |
State_ExcludeFromReporting | 22.6.1.0 | Number(1,0) | Indication of whether a user is excluded from State Reporting. |
State_StaffNumber | 19.11.1.0 | Varchar2(30) | The staff member's state number. |
YearsPriorProfExperience | 20.6.2.0 | Number(11,0) | the staff member's years of prior professional experience. |