File layout - Contracted professional staff information

A

Staff ID  

The employee’s social security number.

The format is ###‐##‐#### (must include dashes).

Staff ID (tx_staff_assignment.staff_id) field on the Demographic tab of the Staff Information page.

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.

First Name (tx_staff.first_name) field on the Demographic tab of the Staff Information page.

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.

Middle Name (tx_staff.middle_name) field on the Demographic tab of the Staff Information page.

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.

Last Name (tx_staff.last_name) field on the Demographic tab of the Staff Information page.

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.

Generation (tx_staff.generation_code) field on the Demographic tab of the Staff Information page.

F

Sex Code 

The employee’s gender.

Valid values:

• M = Male

• F = Female

Gender (tx_staff.sex_code) field on the Demographic tab of the Staff Information page.

G

Total Years Professional Experience 

The employee's total number of professional years.

Valid values:

• Y

• N

Total Professional Years (tx_staff.years_prof_exp) field on the Demographic tab of the Staff Information page.

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

Highest Degree (tx_staff.education_level) field on the Demographic tab of the Staff Information page.

I

Date of Birth 

The employee’s date of birth.

The format is MM/DD/YYYY.

Date of Birth (tx_staff.birth_date) field on the Demographic tab of the Staff Information page.

J

Blank

Leave blank

Not applicable

K

Hispanic 

Valid values:

• 0 = Not Hispanic

• 1 = Hispanic

Ethnicity (1997 Standard) (tx_staff.hisp_latino) field on the Demographic tab of the Staff Information page.

L

Indian 

Valid values:

• 0 = Not Indian

• 1 = Indian

Race (tx_staff.is_american_indian) field on the Demographic tab of the Staff Information page.

M

Asian 

Valid values:

• 0 = Not Asian

• 1 = Asian

Race (tx_staff.is_asian) field on the Demographic tab of the Staff Information page.

N

Black 

Valid values:

• 0 = Not Black

• 1 = Black

Race (tx_staff.is_black) field on the Demographic tab of the Staff Information page.

O

Hawaiian 

Valid values:

• 0 = Not Hawaiian

• 1 = Hawaiian

Race (tx_staff.is_pacific_islander) field on the Demographic tab of the Staff Information page.

P

White 

Valid values:

• 0 = Not White

• 1 = White

Race (tx_staff.is_white) field on the Demographic tab of the Staff Information page.

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.

District Years of Experience (tx_staff.years_in_district) field on the Demographic tab of the Staff Information page.

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.

Number Days Employed (tx_staff_ext.field_value where staff_ext_key .entity_name= 'DaysEmployedSet' and tx_staff_ext.ext_id = staff_ext_key.ext_id and staff_ext.field_name = 'NumberDaysEmployed') field on the Demographic tab of the Staff Information page.

S

Percent Days Employed 

The percentage of a standard district workday for which the employee is hired.

Valid values are 1‐100.

Percent Days Employed (tx_staff_ext.field_value where staff_ext_key .entity_name= 'DaysEmployedSet' and tx_staff_ext.ext_id = staff_ext_key.ext_id and staff_ext.field_name = 'PercentDayEmployed') field on the Demographic tab of the Staff Information page.

T

TX Staff Unique ID

The employee's Unique ID number provided by TEA's Texas Student Data System (TSDS) Unique ID system.

TX Unique Staff ID (tx_staff.staff_uid) field on the Demographic tab of the Staff Information page.

U

Hire Date

The employee’s hire date.

The format is MM/DD/YYYY.

Hire Date (tx_staff_employment.hire_date) field on the Demographic tab of the Staff Information page.

V

District ID

The six-digit district code.

If the District ID is absent in the import file, the value is retrieved from the District ID field on the PEIMS Profile page.

District ID field on the Demographic tab of the Staff Information page.

W

End Date

The employee’s last pay day or last worked date.

The format is MM/DD/YYYY.

If the End Date is absent in the import file, the value is retrieved from the Last Day Worked field on the Terminate Employee page. If this field is blank, the value is retrieved from the Last Date to Pay field.

End Date (tx_staff_employment.end_date) field on the Demographic tab of the Staff Information page.

X

Begin Date - Number Days Employed

The beginning date of the Number Days Employed value.

The format is MM/DD/YYYY.

Begin Date (tx_staff_ext_key.begin_date where staff_ext_key.entity_name = 'DaysEmployedSet') field on the Staff Extensions tab of the Staff Information page.

Y

End Date - Number Days Employed

The ending date of the Number Days Employed value.

The format is MM/DD/YYYY.

End Date (tx_staff_ext_key.end_date where staff_ext_key.entity_name = 'DaysEmployedSet') field on the Staff Extensions tab of the Staff Information page.