Generate criteria for a TSDS PEIMS Payroll Record

What is the Generate looking at to create a Staff Payroll (060/30060) Record?

• Payroll

• Texas

• TX PEIMS Staff File Records

• TX TSDS Reporting 

Informational

Payroll records are selected from Employee/Job Salary records that were active on the Snapshot Date and linked to the Payroll Activity Code through the PEIMPAYACT Crosswalk.

In order for the Generate to create a Payroll record, the following information must be in place: 

• The employee’s Active Status in the Employee Master must be A – Active or I – Inactive.

• The Inactive and/or Terminated date on the Dates tab of the Employee Master must be:

  • Blank, OR

  • Greater than the defined Snapshot Date, OR

  • The Inactive Reason Code is crosswalked to Y in the PEIMSINACIN – PEIMS Inactive Reasons to Include Crosswalk Type.

• The employee has a primary base pay record in Employee Job/Salary that was effective on the defined Snapshot date.

• The Pay Effective Date in Employee Job/Salary is less than or equal to the defined Snapshot date.

• The Pay Start Date in Employee Job/Salary is less than or equal to the defined Snapshot date.

• The Pay End Date in Employee Job/Salary must be greater than the defined Snapshot date.

• The Pay code exists in the Munis Value column of the State Reporting Codes program with a Crosswalk Type PEIMPAYACT and a value in the Crosswalk Code column.

• The Pay code is not defined on the Generate screen as Excluded.

• The Annual Pay field and/or the Reference salary field is greater than $0.