File layout - Contracted professional staff information

The following table lists the columns, names, and descriptions for the contracted professional staff information’s comma-delimited (.csv) file.

You must upload this file to the server by following the Upload Files to the Server procedure. You must enter this server file path and file name in the Name of File to Load field on the following pages:

Column	Name	Description
A	Staff ID	The employee’s social security number. The format is ###‐##‐#### (must include dashes).
B	First Name	The employee’s first name. Do not use periods. Do not use any punctuation other than a hyphen or a single apostrophe.
C	Middle Name	The employee’s middle name. Do not use periods. Do not use any punctuation other than a hyphen or a single apostrophe. This field may be left blank.
D	Last Name	The employee’s last name. Do not use periods. Do not use any punctuation other than a hyphen or a single apostrophe.
E	Generation Code	The employee’s generation suffix. For example, Jr., Jr, Sr. The suffix is converted to the corresponding PEIMS code during the load process.
F	Sex Code	Valid values: M = Male F = Female
G	Total Years Professional Experience	The number of verifiable years of creditable experience. Valid values are 0‐99.
H	Highest Degree Level Code	The highest post‐secondary degree the employee has earned. Valid values: 0 = No Bachelor’s degree or higher 1 = Bachelor’s degree 2 = Master’s degree 3 = Doctorate
I	Date of Birth	The employee’s date of birth. The format is MM/DD/YYYY.
J	Blank	Leave blank
K	Hispanic	Valid values: 0 = Not Hispanic 1 = Hispanic
L	Indian	Valid values: 0 = Not Indian 1 = Indian
M	Asian	Valid values: 0 = Not Asian 1 = Asian
N	Black	Valid values: 0 = Not Black 1 = Black
O	Hawaiian	Valid values: 0 = Not Hawaiian 1 = Hawaiian
P	White	Valid values: 0 = Not White 1 = White
Q	Years’ Experience in District	The number of completed years that a person has been employed in any professional position in the current district or education service center, whether or not there has been any interruption in service. Valid values are 0‐99.
R	Number Days Employed	The actual number of at‐work days within the school year a person is scheduled to work in the district. This number does not include holidays, weekends, and other days the employee is not expected to work. Valid values are 1 – 366.
S	Percent Days Employed	Enter the percentage of a standard district workday for which the employee is hired. Valid values are 1‐100.
T	TX Staff Unique ID	The employee's Unique ID number provided by TEA's Texas Student Data System (TSDS) Unique ID system.

Do not include quotes around text fields in the file. Records with invalid Social Security numbers are not loaded. If a record already exists in PEIMS for the Staff ID, the record in the comma-delimited file is skipped during the load process. Minimal error checking is performed when running the load process. Ensure that the data in the file is accurate and in the correct format.