USPS Reports Guide –
USPS Reports by Number –
Report 580 Fiscal Year HN7 – PCA Rollover or Fiscal Year HMM – PCA Validation
This report is automatically run during the payroll tables rollover at FYE and will display the roll results. Either a 09/01/XXXX record will be inserted on HN7U1 and HMMU1, if applicable, for the new fiscal year, or it will error off triggering a message which will print on the report. HMMU1 will only be used if the Validate PCA flag is set to a Y on H0CUS.
Report Criteria
| Category | Position Control |
|---|---|
| Distribution | Agency |
| Frequency | Annually at Fiscal Year-End |
| Form | |
| Sort Sequence | Pay Number, Labor Code, Effective Date |
| Page Break | Database |
| Parameters | |
| Databases Used | H0C, HMQ, HMM, HN7, HNK, HNO |
| Selection Criteria | All active labor code overrides or validations with an effective date less than 09/01/XXXX. |
| Produce Output? | Yes |
| Request Screen | HMQU1: PAYROLL TABLES (HN7, HMM) |
| Posting Report? | Yes – HN7U1 and HMMU1 are updated |
| Additional Notes | This report can be run as many times as needed to complete the rollover. Entries can be made directly on HN7U1 and HMMU1 in lieu of requesting this rollover. The main benefit of this is that a rollover request takes overnight 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.
- PAY NO HN7.PAYNO
- Displays the special pay number that has a labor code override and is being rolled.
- PCA/INDEX HN7.LABORCODE
- Displays the labor code being overridden.
- PCA HMM.PCA
- Displays the labor code being validated by an organization code.
- EFFECTIVE DATE HN7.EFFDT, HMM.HISTORYDT
- Displays the effective date of the record.
- INACTIVE DATE HN7.NACTDT, HMM.NACTDT
- Displays the inactive date of the record.
- ROLLOVER RESULTS DERIVED
- Displays the results of the rollover. All error messages need to be researched and corrected.
Payroll Roll Ind Was Set to "N"
Refers to the indicator on HMQU1 being changed from Y.
No action is necessary. - ROLLOVER RESULTS DERIVED
- Displays the results of the rollover. All error messages need to be researched and corrected.
- TOTALS DERIVED
- Displays the total number of records read, updated, and inserted for each of the databases affected.
Sample Report
1 REPORT: 580 UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM PAGE: 3
AGENCY: XXX XXXXX XXXXX XXXXXXXXXXX XXXXX RUN DATE: XX/XX/20XX
FISCAL YEAR HN7 - PCA ROLLOVER RUN TIME: 01:35:01
0DATA PAY EFFECTIVE INACTIVE
BASE NO PCA/INDEX DATE DATE ROLLOVER RESULTS
NO HN7 ROWS FOUND TO ROLL FOR THIS AGENCY
0 HMQ ROWS READ = 1
HMQ ROWS UPDATED = 0
HN7 ROWS READ = 0
HN7 ROWS UPDATED = 0
HN7 ROWS INSERTED = 0
HMM ROWS READ = 0
HMM ROWS UPDATED = 0
HMM ROWS INSERTED = 0
1