IDIF Layout Information#
The IDIF definition for the file layout is found in CALPERS_NEW, and the data is presented in groups by record number as noted here.
You must update the constant value in record 240 – Employer Cal PERS ID. This is set to a default value of 1111222233
This CalPERS ID is a new unique identifier, created by the new system when an Employer is an approved Business Partner. This replaces the CalPERS Employer Code and Unit Code used in the older interface format. This CalPERS ID of the Employer who is submitting the payroll on behalf of all the employees in the file. This may be the Employer where all the employees are working, but it may also be the Employer who is authorized to send payroll for other Employers’ employees.
| Record | Section | Level | Notes |
|---|---|---|---|
| 0 | Qualification | Qualify | Checks that not running for something posted already |
| 10 | XML Header | Header | |
| 100-160 | Start of data | Header | File Header |
| 200-240 | Start of data body | Header | 240 - Employer PERS ID Constant value to be updated by the customer |
| 300-350 | Start of Report | Header | |
| 1500-2000 | Totals | Header | Note 1530 adds up several detail columns below from Record 3500 and 6000 |
| 2500-2999 | Start Participant | Pay Header BEGIN | Identifies the employee |
| 3000-4000 | Prior Period Payments | Detail | Pay Lines for purposes of prior Period Adjustments |
| 4500-4999 | Period Information | Pay Header SUMMARY | |
| 5000-5595 | Special Compensation | Pay Header SUMMARY | You may delete records not being used.... Or just not set up the CALPERS_SC lexicon |
| 6000 | Employee Totals | Pay Header SUMMARY | These are added up into 1530 above |
| 7000-8900 | Employee Wrap Up | Pay Header SUMMARY | |
| 9000-9900 | Report Wrap Up | Trailer | |
| 9999 | Update as Posted | Update | If run in Trial=No |
