0_Staff_Match¶

Columns¶

These are the columns used in this submission file:

Search:

Name	Description	Data Type	Length	Codeset	Definition
ADMINID	SU/SD ID	STRING	6	Issued by AOE	The VT AOE assigned unique identifier for the Supervisory Union/District that is submitting data.
DOB	Date of Birth	DATE(MM/DD/YYYY)			The month, day, and year on which an individual was born.
EDUCATORID	State Assigned Staff ID	NUMBER	10		The VT AOE assigned unique staffperson identifier. This number is distinct for each staffperson over time.
EmpOrgid	Employing Org ID	STRING	6	Issued by AOE	The VT AOE assigned unique identifier for the district employing the staffperson.
FNAME	Staff First Name	STRING	20		A name given to an individual at birth, baptism, or during another naming ceremony, or through legal change.
FORMERLAST	Staff Former Last Name	STRING	36		A former last name that may have appeared in the database previously but has changed due to marriage status or other qualifying event.
GENDER	Gender	STRING	1	Issued by AOE	A codeset value indicating a person's gender.
LNAME	Staff Last Name	STRING	36		A name borne in common by members of a family.
LOCALED_ID	Local Staff ID	STRING	15		A unique identifier assigned to the staffperson by the employing organization.
MNAME	Staff Middle Name	STRING	20		A secondary name given to an individual at birth, baptism, or during another naming ceremony, or through legal change.
POSTNAME	Staff Post Name	STRING	5		An appendage, if any, used to denote an individual's generation in family, or a professional credential.

ADMINID,EmpOrgid,LOCALED_ID,EDUCATORID,FNAME,MNAME,LNAME,POSTNAME,FORMERLAST,DOB,GENDER