Skip to main content
Skip table of contents

S_USR_X (ver 21.08.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.0Number(10,0)Primary Key

Cell_Phone

19.9.2.0

Varchar2(20)

The staff member's cell phone number.

DeviceAccess21.8.2.0Varchar2(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..
DeviceType21.8.2.0Varchar2(10)The Device Type is a part of Staff Digital Resource data. For example : Desktop Computer, Laptop Computer etc..
EmploymentStatus20.6.2.0Varchar2(50)The staff member's employment status.
ExcludeFromEdFi19.11.1.0Number(1,0)Indication of whether a user is excluded from EdFi Publishing.

ExitDate

19.9.2.0

Date

The staff member's exit date.

FullTimeEquivalency20.6.2.0Number(25,10)The staff member's full time equivalency.

GenerationCodeSuffix

19.11.1.0Varchar2(10)Denotes an individual's generation in their family, e.g. Jr., Sr., III.

HighlyQualifiedTeacher

19.11.1.0Number(1,0)Indication of whether a teacher is classified as highly qualified for his/her assignment.
HireDate19.9.2.0DateThe staff member's hire date.
InternetAccess21.8.2.0Varchar2(5)The Internet Access Type is a part of Staff Digital Resource data. For example : Fiber, Cable DSL etc..
InternetInResidence21.8.2.0Varchar2(5)The Internet Access In Residence is a part of Staff Digital Resource data. Options are Yes or No.
InternetPerformance21.8.2.0Varchar2(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.0Varchar2(50)The highest grade in school that the staff member has completed or the highest degree received - Ed-Fi descriptor.
Name_Suffix21.5.2.0Varchar2(10)The suffix for the Name fields in Staff.
State_ExcludeFromReporting22.6.1.0Number(1,0)Indication of whether a user is excluded from State Reporting.
State_StaffNumber19.11.1.0Varchar2(30)The staff member's state number.
YearsPriorProfExperience20.6.2.0Number(11,0)the staff member's years of prior professional experience.
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.