Import Staff File

TSDS > Utilities > Import Staff File

This utility is for Student-only districts.

This utility imports basic staff demographic data to be used for the TSDS PEIMS Staff Interchange records (i.e., to join the unique staff ID with a a teacher/staff record). This is for districts that do not maintain business data in TxEIS. The utility accepts data from a comma-delimited text or CSV file (e.g., provided by a third-party business application vendor) and inserts the records into BHR_EMP_DEMO which allows you to maintain this data in the TxEIS TSDS application.

File layout

The utility accepts data from a comma-delimited text or CSV file (e.g., provided by a third-party business application vendor) and inserts the records into HR tables which allows you to maintain this data in the ASCENDER TSDS application.

The values must be inserted in this order:

Field	Validation
Unique staff ID	Must be ten digits.
Staff ID/SSN	Must be nine digits. Required. First character must be S or 0-8. First three characters must not be 000. Middle characters (3rd-4th digit) must not be 00. Last four characters must not be 0000. First seven characters must not be the same.
Last Name	Required
First Name	Required
Middle Name	Required
Gender	One character (M or F)
Legal Generation	One character 1 = Jr 2 = Sr 3 = II 4 = III 5 = IV 6 = V 7 = VI 8 = VII 9 = VIII A = I B = IX C = X
DOB	Required; format YYYYMMDD
Hispanic Ethnicity	One character (Y or N)
Race American	One character (Y or N) At least one race indicator is required.
Race Asian	One character (Y or N)
Race Black	One character (Y or N)
Race Native Hawaiian Pacific Islander	One character (Y or N)
Race White	One character (Y or N)
Highest Degree	One character 0 = No Bachelor's 1 = Bachelor's 2 = Master's 3 = Doctorate
Prior Teach Experience	Two characters, values 0-99
Original Emp Date	Format YYYYMMDD
Term Date	Format YYYYMMDD

Example:

0133884198,422514579,Bacon,Jason,Donald,M,1,19801023,N,Y,N,N,N,Y,1,10,20150801,20200101
0133884199,422514563,Hannover,Renee,Keen,F,1,19601024,N,Y,N,N,N,Y,1,12,20150801,20200104
0133884189,422514549,Nimitz,Clark,Mason,M,1,19701022,N,Y,N,N,N,Y,1,15,20150801,20200105
0133884179,422514769,Hernandez,Joe,Lee,M,1,19811028,N,Y,N,N,N,Y,1,10,20150801,20200106

Import data:

Field	Description
File	Click Browse to locate and select the file to import.

Click Import.

The results of the import are displayed, including a count of records with errors, and total records read, updated, and imported.

Other functions and features:

Print Report

Print the error report.

State Reporting

Sidebar

Table of Contents

Import Staff File

Import data:

Other functions and features:

Americans with Disabilities Act (ADA) and Web Accessibility

State Reporting

User Tools

Site Tools

Sidebar

Table of Contents

Import Staff File

Import data:

Other functions and features:

Page Tools

Americans with Disabilities Act (ADA) and Web Accessibility