Contributions and Earnings Report | PowerSchool ERP Compliance

The default file name for the Contributions and Earnings report is NY ERS_Contributions_Wages_<monthyear>.txt.

The file format is pipe-delimited.

The Contributions and Earnings report contains the following records:

Contribution Records

The following table shows the fields, lengths, contribution record details, data source or valid values, and whether the field is required for the Contribution records in the report.

Field	Length	Description	Data Source or Valid Values	Required or Optional
Transaction Type	1	Indicates the type of transaction.	The valid value is 3.	Required
NYSLRS ID	9	The unique identification number assigned to the employee by the New York State and Local Retirement Systems (NYSLRS) after submitting the Demographic and Job Data report for new employees.	Retrieved from the NYSLRS ID field on the Employee Information form of the NY ERS Retirement Report page. To report an employee for the first time, the valid value is New.	Required
Employment Instance	3	A number of up to three digits that determines the job to include in the report. The employment instance is assigned to the employee by the NYSLRS after the Demographic and Job Data report for new employees is submitted.	Retrieved from the Employment Instance field on the Employee Information form of the NY ERS Retirement Report page. To report an employee for the first time, the valid value is New.	Required
Social Security Number (Last Four Digits)	4	The last four digits of the employee's Social Security number.	Retrieved from the Social Security Number field on the Employee Information form of the NY ERS Retirement Report page.	Required
First Three Characters of First Name	3	The first three characters of the employee's first name.	Retrieved from the First Name field on the Employee Information form of the NY ERS Retirement Report page.	Required
Regular/Adjustment Indicator	1	Indicates if this transaction is a regular or an adjustment report.	Valid values: R = Regular A = Adjustment Retrieved from the Adjustment Contribution field on the Employee Information form of the NY ERS Retirement Report page.	Required
Payroll End Date	10	The date of the last day of the period being reported (the last day of the month). This specifies the month for which the days and contributions reported in this transaction are applicable. A reporting file can contain transactions with multiple payroll end dates.	Retrieved from the Check End Date field on the NY ERS Retirement Report - Report page.	Required
Number of Pay Cycles in Period	1	The number of payroll cycles covered based on the Pay Frequency on the Job Data tab of the Employee Information form of the NY ERS Retirement Report - Job & Demographic Data page. For example, an employee paid weekly might have received up to four or five payments in a reported month.	Valid values: If the Pay Frequency is W – Weekly, this field value is 4 or 5 If the Pay Frequency is B – Bi-Weekly, this field value is 2 or 3 If the Pay Frequency is S – Semi-Monthly, this field value is 2 If the Pay Frequency is M – Monthly, this field value is 1 Retrieved from the Pay Cycles field on the Employee Information form of the NY ERS Retirement Report page.	Required
Reported Days	3.2	The number of days worked in the period covered by the report.	The valid value is a maximum of three numbers followed by a decimal, if required, and rounded to two decimal places. The number of days worked to be reported should be calculated as the total number of hours worked during the reporting period, divided by the standard workday hours, rounded to two decimal places. If this is an Adjustment transaction, you can adjust days positively or negatively. This field value may be 0 or null if there are no days associated with the corresponding earnings. For example, for a lump sum payment, a grievance, or an arbitration award. Retrieved from the Days Worked field on the Employee Information form of the NY ERS Retirement Report page.	Optional
Reported Pre-Tax Contributions	16.2	The pre-tax contributions deducted from the employee. You cannot adjust contributions once they have been reported.	A maximum of sixteen numbers followed by a decimal, if required, and two decimal places. This field value may be 0 or null if there are no contributions associated with the corresponding earnings. Retrieved from the Pre-Tax Contributions field on the Employee Information form of the NY ERS Retirement Report page.	Optional
Reported Post-Tax Contributions	16.2	The post-tax contributions deducted from the employee. You cannot adjust contributions once they have been reported.	A maximum of sixteen numbers followed by a decimal, if required, and two decimal places. This field value may be 0 or null if there are no contributions associated with the corresponding earnings. Retrieved from the Post-Tax Contributions field on the Employee Information form of the NY ERS Retirement Report page.	Optional
Reported Loan Payments	16.2	The employee’s reported loan payment amount. You cannot adjust loan payments once they have been reported.	A maximum of sixteen numbers followed by a decimal, if required, and two decimal places. This field value may be 0 or null if there are no loan payments associated with the report. Retrieved from the Loan Payment field on the Employee Information form of the NY ERS Retirement Report page.	Optional
Pre-Tax Service Credit Payments	16.2	The employee’s pre-tax service credit purchase deduction used to complete a service credit purchase. You cannot adjust service credit payments once they have been reported.	A maximum of sixteen numbers followed by a decimal (if needed) and a maximum of two decimal places. This field value may be 0 or null if there are no pre-tax service credit payments associated with the report. Retrieved from the Pre-Tax Service Credit field on the Employee Information form of the NY ERS Retirement Report page.	Optional
Post-Tax Service Credit Payments	16.2	The employee’s post-tax service credit purchase deduction to complete a service credit purchase. You cannot adjust service credit payments once they have been reported.	A maximum of sixteen numbers followed by a decimal (if needed) and a maximum of two decimal places. This field value may be 0 or null if there are no post-tax service credit payments associated with the report. Retrieved from the Post-Tax Service Credit field on the Employee Information form of the NY ERS Retirement Report page.	Optional

Earnings Records

The following table shows the fields, lengths, earnings record details, data source or valid values, and whether the field is required for the Earnings records in the report.

Field	Length	Description	Data Source or Valid Values	Required or Optional
Transaction Type	1	Indicates the type of transaction.	The valid value is 4.	Required
NYSLRS ID	9	The unique identification number assigned to the employee by the New York State and Local Retirement Systems (NYSLRS) after submitting the Demographic and Job Data report for new employees.	Retrieved from the NYSLRS ID field on the Employee Information form of the NY ERS Retirement Report page. To report an employee for the first time, the valid value is New.	Required
Employment Instance	3	A number of up to three digits that determines the job to include in the report. The employment instance is assigned to the employee by the NYSLRS after the Demographic and Job Data report for new employees is submitted.	Retrieved from the Employment Instance field on the Employee Information form of the NY ERS Retirement Report page. To report an employee for the first time, the valid value is New.	Required
Social Security Number (Last Four Digits)	4	The last four digits of the employee's Social Security number.	Retrieved from the Social Security Number field on the Employee Information form of the NY ERS Retirement Report page.	Required
First Three Characters of First Name	3	The first three characters of the employee's first name.	Retrieved from the First Name field on the Employee Information form of the NY ERS Retirement Report page.	Required
Regular/Adjustment Indicator	1	Indicates if this transaction is a regular or an adjustment report.	Valid values: R = Regular A = Adjustment Retrieved from the Adjustment Contribution field on the Employee Information form of the NY ERS Retirement Report page.	Required
Payroll End Date	10	The date of the last day of the period being reported (the last day of the month). This specifies the month for which the days and contributions reported in this transaction are applicable. A reporting file can contain transactions with multiple payroll end dates.	Retrieved from the Check End Date field on the NY ERS Retirement Report - Report page.	Required
Reported Earnings Code	3	The type of ERS retirement earnings code.	Valid values: DEF = Deferred Payment EAR = Elected and Appointed Reporting GRA = Grievance/Arbitration Award HOL = Holiday Payment LON = Longevity LSV = Lump Sum Vacation MNP = Miscellaneous Non-Pensionable MPE = Miscellaneous Pensionable NOT = Non-Pensionable Overtime OVT = Regular Overtime PEO = Private Entity Overtime RBC = Retroactive Pay/Balance of Contract RBS = Recurring Bonus Payments REG = Regular Earnings ROT = Retroactive Overtime Pay SLV = Unpaid Sick Leave WCS = Workers Comp. – State Retrieved from the Earnings Code field on the Employee Information form of the NY ERS Retirement Report page.	Required
Reported Earnings Amount	16.2	The amount that was earned for the reported earnings code.	Retrieved from the Earnings Amount field on the Employee Information form of the NY ERS Retirement Report page.	Optional
Reported Earnings Hours	4.2	The hours associated with the reported earnings amount and the reported earnings code.	This field value may be 0 or null if there are no hours associated with the earnings, such as if reporting a lump sum or grievance/arbitration award. Retrieved from the Earnings Hours field on the Employee Information form of the NY ERS Retirement Report page.	Optional