Demographic report - File Layout and Data Mapping

The default file name for the Demographic report is edfi_staff_demographic.xlsx.

The following table shows the columns, column names, descriptions, and data sources or valid values for the Demographic report.

Column	Column Name	Description	Data Source or Valid Values
A	Employee Number	The employee’s identification (ID) number.	Retrieved from the Employee Number field on the Demographic tab of the Staff Information page.
B	Staff ID	The employee’s social security number, without dashes.	Retrieved from the Staff ID field on the Demographic tab of the Staff Information page.
C	First Name	The employee’s first name.	Retrieved from the First Name field on the Demographic tab of the Staff Information page.
D	Middle Name	The employee’s middle name.	Retrieved from the Middle Name field on the Demographic tab of the Staff Information page.
E	Last Name	The employee's last name.	Retrieved from the Last Name field on the Demographic tab of the Staff Information page.
F	Generation	The employee’s generation suffix.	Retrieved from the Generation field on the Demographic tab of the Staff Information page.
G	Gender	The employee’s gender.	Valid values: Male Female Retrieved from the Gender field on the Demographic tab of the Staff Information page.
H	Date of Birth	The employee’s birth date.	Retrieved from the Date of Birth field on the Demographic tab of the Staff Information page.
I	Hire Date	The employee’s hire date.	Retrieved from the Hire Date field on the Demographic tab of the Staff Information page.
J	End Date	The employee’s last pay day or last worked date.	Retrieved from the End Date field on the Demographic tab of the Staff Information page.
K	Highest Education Level	The employee’s highest degree.	Valid values: 0 - NO BACHELOR'S DEGREE OR HIGHER 1 - BACHELOR'S 2 - MASTER'S 3 - DOCTORATE Retrieved from the Highest Degree field on the Demographic tab of the Staff Information page.
L	Ethnicity - Hispanic or Latino	The employee’s ethnicity.	If the employee’s ethnicity is Hispanic or Latino, the valid value is 1-YES. Retrieved from the Ethnicity (1997 Standard) field on the Demographic tab of the Staff Information page.
M	Race - American Indian or Alaska Native	Indicates whether the employee’s race is American Indian or Alaska Native.	If the employee’s race is American Indian or Alaska Native, the valid value is 1-YES. Retrieved from the Race field on the Demographic tab of the Staff Information page.
N	Race - Asian	Indicates whether the employee’s race is Asian.	If the employee’s race is Asian, the valid value is 1-YES. Retrieved from the Race field on the Demographic tab of the Staff Information page.
O	Race - Black or African American	Indicates whether the employee’s race is Black or African American.	If the employee’s race is Black or African American, the valid value is 1-YES. Retrieved from the Race field on the Demographic tab of the Staff Information page.
P	Race - Native Hawaiian or Other Pacific Islander	Indicates whether the employee’s race is Native Hawaiian or Other Pacific Islander.	If the employee’s race is Native Hawaiian or Other Pacific Islander, the valid value is 1-YES. Retrieved from the Race field on the Demographic tab of the Staff Information page.
Q	Race - White	Indicates whether the employee’s race is White.	If the employee’s race is White, the valid value is 1-YES. Retrieved from the Race field on the Demographic tab of the Staff Information page.
R	TX Unique Staff ID	The employee's Unique ID number provided by TEA's Texas Student Data System (TSDS) Unique ID system.	Retrieved from the TX Unique Staff ID field on the Demographic tab of the Staff Information page.
S	District ID	The six-digit district code.	Retrieved from the District ID field on the Demographic tab of the Staff Information page.
T	District Years of Experience	The employee’s total number of years of experience in the district. Used for Professional staff only.	Retrieved from the District Years of Experience field on the Demographic tab of the Staff Information page.
U	Years of Prior Teaching Experience	The employee’s prior professional years of experience.	Retrieved from the Years of Prior Teaching Experience field on the Demographic tab of the Staff Information page.
V	Total Professional Years	The employee's total number of professional years. This can include out-of-state experience.	Retrieved from the Total Professional Years field on the Demographic tab of the Staff Information page.
W	PK Teacher Requirement	The employee’s state-assigned pre-kindergarten training code.	Valid values: 01 - Certification through a training center 03 - Be employed as a PK teacher 05 - Child Development Associate credential 06 - Completion of Texas School Ready Training 07 - Has a degree in early childhood education 08 - At least 8 years experience 09 - Contract - At least 2 years and CDA credential 10 - Contract - At least 2 years and MAC certification 11 - Contract - Been employed as a PK teacher 12 - Contract - Has a degree in early childhood education 13 - Contract - At least 8 years experience 98 - PK Teacher in school district no additional HQPK Qualification 99 - PK Teacher in LEA no additional HQPK Qualification Retrieved from the PK Teacher Requirement field on the Demographic tab of the Staff Information page.
X	Creditable Year of Service	The employee’s creditable service years.	Valid values: 0-No 1-Yes Retrieved from the Creditable Year of Service field on the Demographic tab of the Staff Information page.
Y	TIA National Board Certified	Indicates whether the employee is an active Teacher Incentive Allotment (TIA) national board-certified teacher.	If the employee is an active Teacher Incentive Allotment (TIA) national board-certified teacher, the valid value is 1-Yes. Retrieved from the TIA National Board Certified field on the Demographic tab of the Staff Information page.
Z	TIA Designation	Indicates whether the employee has an active TIA designation.	If the employee has an active TIA designation, the valid value is 1-Yes. Retrieved from the TIA Designation field on the Demographic tab of the Staff Information page.
AA	TIA LEA Designation Pending	Indicates whether the employee has a TIA Local Education Agency (LEA) submitted designation pending.	If the employee has a TIA Local Education Agency (LEA) submitted designation pending, the valid value is 1-Yes. Retrieved from the TIA LEA Designation Pending field on the Demographic tab of the Staff Information page.
AB	TSDS Excluded	Indicates whether the employee is excluded from TSDS reporting.	If the employee is excluded from TSDS reporting, the valid value is 1-Yes. Retrieved from the TSDS Excluded field on the Demographic tab of the Staff Information page.