050 STAFF DATA - EMPLOYMENT- PAYROLL SUMMARY

Input Record
Type Code

District ID

Staff ID

Years Experience in District

Number Days Employed

Percent Day Employed

Filler

E0755

E0212

E0505

E0161

E0160

E0760

 

C042

           

Columns
1 - 3

Columns
4 - 9

Columns
10 - 18

Columns
19 - 20

Columns
21 - 23

Columns
24 - 26

Columns
27 - 80

050

           

050

           

Description

The 050 Employment Payroll Summary record identifies the years of experience in the current school district along with the number of days employed and the percent of day employed.  This information is used in calculating the staff full-time equivalent (FTE) data for a person’s pay and the professional services that are provided by staff with ROLE-IDs. 

Business Rules

INPUT-RECORD-TYPE-CODE (E0755) identifies the type of data on a PEIMS data submission record.

DISTRICT-ID (E0212) indicates the district identification number registered with the Texas Education Agency.

DISTRICT-ID on the 050 Employment Payroll Summary records must match the value for DISTRICT-ID on the LEA 010 District record.

STAFF-ID (E0505) is the person's Social Security number.

YEARS-EXPERIENCE-IN-DISTRICT (E0161) indicates 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.

YEARS-EXPERIENCE-IN-DISTRICT refers to the total years of experience in the professional staff category only. All staff must report YEARS-EXPERIENCE-IN-DISTRICT.

NUMBER-DAYS-EMPLOYED (E0160) indicates the actual number of at-work days within the school year that a person is scheduled to work in the district. This number does not include holidays, weekends, and any other days the employee is not scheduled to work.

NUMBER-OF-DAYS-EMPLOYED should not exceed 261.

PERCENT-DAY-EMPLOYED (E0760) is that percentage of a standard district work day for which the employee is hired to work. For an employee on contract, the percentage may be determined directly from the contract: full-time = "100"; half-time = "050"; and so on. For an employee who is not on contract, the percentage may be determined as follows.

Example: The standard work day for the district is 7 hours. An employee is hired to work for 4 hours a day. This data element is coded as "057" for this employee because 4/7 = .571, which is rounded down.

The value reported must be a whole number. If the computed value is greater than ".##50...", use rounding to the next higher percent to avoid the use of decimals or fractions. For example, .6251 is reported as "063".

PERCENT-DAY-EMPLOYED should not exceed 100.

PERCENT-DAY-EMPLOYED refers to the percentage of the standard district work day for which the person is employed. Those employees such as cafeteria workers and bus drivers who work only a few hours each day are not to be reported as "100" in this field. Do not look at the job, but rather the number of hours worked in relation to the standard district work day.

Reporting Requirements

The 050 Employment Payroll Summary record is submitted in both Submission 1 and Submission 3. However, only staff with ROLE-IDs 047 and 087 are to be submitted in Submission 3.

If a LEA has contracted out all or part of a campus operation to a third party vendor, the LEA is still required to report the teacher’s (Role ID 087 and 047) individual employment information through the 050 Staff Employment record.  Even though the teachers are contracted through a third party vendor, the teachers are teaching at a campus in the LEA and must be reported so that the information can be included in the staff full-time equivalent (FTE) calculations for the Academic Excellence Indicator System and the Student Assessment Data Portal as required by law.  It would not be appropriate to omit a contracted teacher who is teaching at a campus in the LEA from the staff data reporting on the 050 record.

All staff employed by the ESC or LEA must be reported with a 050 Employment Payroll Summary record.  This includes those substitute teachers who are replacing teachers who have quit, died, or been fired and have not yet been permanently replaced.  Districts are generally not required to report substitute teachers who work only on an “as needed” basis as these persons do not have a regular work schedule with a predictable NUMBER-OF-DAYS-EMPLOYED or PERCENT-DAY-EMPLOYED. 

If a person does not work the same amount of days as shown on the contract, then the actual number of days the employee will work must be reported. This situation may occur when a person does not begin work at the start of the school year.

The value of the STAFF-ID on the 050 Employment Payroll Summary record must match STAFF-ID on a 040 Staff Identification-Demographic record.

Special Reporting Requirements

The Texas School for the Blind and Visually Impaired, Texas School for the Deaf, and the Texas Juvenile Justice Department schools are only required to report teachers (Role ID 087 and 047) in the summer submission (Submission 3) for the purpose of supplying the required information for the Student Assessment Data Portal.