Skip to main content
Skip table of contents

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.
JavaScript errors detected

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

If this problem persists, please contact our support.