S_VT_USR_X
Column Name | Version | Data Type | Description |
|---|---|---|---|
DCID | 16.9.2.2.0 | Integer(10,0) | Primary Key |
EmpOrgID | 16.9.2.2.0 | Varchar2(6) | State Element Name: EMPORGID State Field Desc: Employing Org ID State Definition: The VT AOE assigned unique identifier for the district employing the staff person. |
EducatorID | 16.9.2.2.0 | Integer(10,0) | State Element Name: EDUCATORID State Field Desc: State Assigned Staff ID State Definition: The VT AOE assigned unique staffperson identifier. This number is distinct for each staffperson over time. |
FormerLast | 16.9.2.2.0 | Varchar(36) | State Element Name: FORMERLAST State Field Desc: Staff Former Last Name State Definition: A former last name that may have appeared in the database previously but has changed due to marriage status or other qualifying event. |
EmpBegDate | 16.9.2.2.0 | Date | State Element Name: EMPBEGDATE State Field Desc: Employment begin date State Definition: The month, day, and year on which an individual began self-employment or employment with an organization or institution. |
EmpEndDate | 16.9.2.2.0 | Date | State Element Name: EMPENDDATE State Field Desc: Employment end date State Definition: The month, day, and year on which an individual ended self-employment or employment with an organization or institution. |
EmpStatNo | 16.9.2.2.0 | Integer(3,0) | State Element Name: EMPSTATNO State Field Desc: Employment status number (code set) State Definition: A codeset value that represents the employment status of the staffperson as it relates to the employing organization. |
PostName | 16.9.2.2.0 | Varchar2(5) | State Element Name: POSTNAME State Field Desc: Staff Post Name State Definition: An appendage, if any, used to denote an individual's generation in family, or a professional credential. |