Import Staff File

State Reporting > 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 teacher/staff record). Districts that do not use ASCENDER Business applications can import staff demographic data to be used for the TSDS Staff Interchange records. The import adds “non-employee” data to HR that will be read by the extract, along with data from ASCENDER Grade Reporting. This utility must be run before running the staff extract.

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:

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.

Print Report

Print the error report.

State Reporting

Sidebar

Table of Contents

Import Staff File

Import data:

Americans with Disabilities Act (ADA) and Web Accessibility

State Reporting

User Tools

Site Tools

Sidebar

Table of Contents

Import Staff File

Import data:

Page Tools

Americans with Disabilities Act (ADA) and Web Accessibility