USPS Reports Guide –
USPS Reports by Number –
Report 578 Fiscal Year Pay Table Rollover
This report is automatically run during the pay table rollover at FYE and will display the roll results. Either a 09/01/XXXX record will be inserted on H7SLS for the new fiscal year or it will error off triggering a message which will print on the report.
Report Criteria
| Category | Position Control |
|---|---|
| Distribution | Agency |
| Frequency | Annually at Fiscal Year-End |
| Form | |
| Sort Sequence | Table Type, Pay Group, Pay Step, Effective Date |
| Page Break | |
| Parameters | |
| Databases Used | H0C, H7S, HMQ, HNK |
| Selection Criteria | All active pay tables with an effective date less than 09/01/XXXX. |
| Produce Output? | Yes |
| Request Screen | HMQU1: SALARY TABLE (H7S) |
| Posting Report? | Yes – H7SLS is updated |
| Additional Notes | This report can be run as many times as needed to complete the pay table rollover. Entries can be made directly on H7SLS in lieu of requesting this rollover. The main benefit of this is that a rollover request takes over night to process, whereas an entry online is immediate. This is helpful if time is an issue. |
Report Headings
- DATABASE
- Displays the USPS database effected with this rollover.
- TABLE TYPE H7S.STPAYTABLT
- Displays the table type of the pay table record.
02 Article VI 03 Exempt 3B Agency Defined Steps for Classified Table 1B – Optional - PAY GROUP H7S.STGRADE
- Displays the pay group of the pay table record.
- PAY STEP H7S.STSTEP
- Displays the pay step of the pay table record.
- EFFECTIVE DATE H7S.HISTORYDT
- Displays the effective date of the pay table record.
- INACTIVE DATE H7S.NACTDT
- Displays the inactive date of the pay table record.
- ROLLOVER RESULTS DERIVED FROM H7O
- Displays the results of the rollover. All error messages need to be researched and corrected.
The message PAY TABLE ROLL IND WAS SET TO "N," indicates that the indicator on HMQU1 was changed from Y. No action is necessary. - TOTALS DERIVED
- Displays the total number of records read, updated, and inserted for each of the databases affected.
Sample Report
REPORT: 578 UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM PAGE: 1
AGENCY: XXX XXXXXXXXXXXXXXXXXXX RUN DATE: XX/XX/20XX
FISCAL YEAR PAY TABLE ROLLOVER RUN TIME: 19:15:54
TABLE PAY PAY EFFECTIVE INACTIVE
TYPE GROUP STEP DATE DATE ROLLOVER RESULTS
02 00 03 09/01/20XX 08/31/20XX SUCCESSFUL UPDATE
02 00 03 09/01/20XX XX/XX/20XX SUCCESSFUL INSERT
03 00 01 11/01/20XX 08/31/20XX SUCCESSFUL UPDATE
03 00 01 09/01/20XX XX/XX/20XX SUCCESSFUL INSERT
HMQ ROWS READ = 1
HMQ ROWS UPDATED = 1
H7S ROWS READ = 2
H7S ROWS UPDATED = 2
H7S ROWS INSERTED = 2