USPS Reports Guide –
USPS Reports by Number –
Report 576 Fiscal Year Organization Code Rollover
This report is automatically run during the organization code rollover at FYE and will display the roll results. Either a 09/01/ XXXX record will be inserted on HNORG for the new fiscal year or it will error off triggering a message which will print on the report. It also clears the inroll flag on the HMT table. That flag controls insurance rollover Report 974 to recalculate an employees' insurance salary as a result of a September 1 salary change.
Report Criteria
Category | Position Control |
---|---|
Distribution | Agency |
Frequency | Annually at Fiscal Year-End |
Form | |
Sort Sequence | Database, Organization Code |
Page Break | |
Parameters | |
Databases Used | H0C, HMQ, HNK, HNO |
Selection Criteria | All active organization codes with an effective date less than 09/01/XXXX. |
Produce Output? | Yes |
Request Screen | HMQU1: ORGANIZATION |
Posting Report? | Yes – HNORG is updated. |
Additional Notes | This report can be run as many times as needed to complete the organization code rollover. Entries can be made directly on HNORG in lieu of requesting this rollover. The main benefit of this is that a rollover request takes all night to process, where an entry online is immediate. This is helpful if time is an issue. |
Report Headings
- DATABASE
- Displays the USPS database effected with this rollover.
- ORGCODE HNO.ORGCODE
- Displays the organization code being rolled.
- EFFECTIVE DATE HNO.HIRSTORYDT
- Displays the effective date of the organization code.
- ROLLOVER RESULTS DERIVED FROM HNO
- Displays the results of the rollover. All error messages need to be researched and corrected. The message, ORG CODE ROLL IND WAS SET TO "N," indicates that the indicator in 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 effected.
Sample Report
REPORT: 576 UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM PAGE: 1 AGENCY: XXX TEXAS WATER DEVELOPMENT BOARD RUN DATE: XX/XX/20XX FISCAL YEAR ORGANIZATION CODE ROLLOVER RUN TIME: 1:30:01 ORGCODE EFFECTIVE DATE ROLLOVER RESULTS NO HNO ORG ROWS FOUND TO ROLL FOR THIS AGENCY HMQ ROWS READ = 1 HMQ ROWS UPDATED = 1 HNO ROWS READ = 0