USPS Reports Guide –
USPS Reports by Number –
Report 074 Period-End Clear Control Totals
This report processes the period-end reports and clears for the month, quarter, and year. It performs the following functions:
- During Month-End and Quarter-End Report requests, reports marked on HPRPT for that particular period-end are generated.
- During Month-End Reports, imputed income is generated for any eligible employee who did not have imputed income applied during the current payroll month. An H0H record is created and all appropriate accumulators are updated.
- During Month-End Clears, month-to-date fields are cleared, and Report 571 Generated State Paid Insurance/Skip transactions. This generates manual paysets on H0ZUC deduction amounts and frequencies are updated from the HNY sub-deduction screens. Additionally, the H0CUS CURR PAYROLL MONTH is moved forward to the next processing month and Report 674 is generated when applicable.
- During Calendar Year-End Payroll/Clears, the year-to-date fields are cleared, charity deduction frequencies are turned off, FICA status is set to 1 for deceased employees, future charity amounts are rolled to a new year, and all the HNYU4 information is cleared, all HN1UA deferred compensation catch-up indicators and override amounts are cleared. The employee HNCU1 +49 field is updated and the H0CUS current month flag is set to A. At Calendar Year-End split with November clears, Report 074 will create an HNCU1 row for the new deferred comp plan year and current quarter flag is set to 1.
- During Month-End Clears for August, the CORPORAL PAY FISCAL YEAR TO DATE fields are cleared, in addition to the normal Month-End Clears process. After each biennium, the PRODUCTIVITY BONUS YEAR TO DATE fields will also be cleared.
- Optional life premiums and imputed income are set to recalculate if table 855 value is equal to the new current month flag set by Report 74. This is identical to the functions performed by Report 545. Table 855 should always have an "A" in it so that premiums and imputed income are recalculated each January.
Report Criteria
| Category | Payroll Administration, Benefits, Leave Accounting |
|---|---|
| Distribution | Agency |
| Frequency | Monthly, Quarterly, Annually |
| Form | 111 |
| Sort Sequence | |
| Page Break | |
| Parameters | HNKU3 – MTD END DATE, QTD END DATE, YTD END DATE |
| Databases Used | H0B, H0A, H0Z, HNY, HN1, H10, HM8, H0I, HNK |
| Selection Criteria | All employee records with month-to-date, prior quarter-to-date, or year-to-date, depending on request. |
| Produce Output? | Yes |
| Request Screen | Not requestable by the agencies. Requested monthly by USPS personnel at Month-End, Quarter-End, and Calendar Year-End. |
| Posting Report? | Yes |
| Additional Notes | Call your USPS representative when ready to run period-end reports or clears. Report 674 (Month End Clear H0Z Change Listing) will be generated during month end clears when a change occurs to H0Z. |
Report Headings
- AS OF DERIVED
- Displays the effective date of the clears.
- TABLE
- Displays the database.
- EMPLOYEES PROCESS DERIVED
- Displays the total number of employees with records processed per database.
- ROWS CLEARED DERIVED
- Displays total number of records cleared per database.
Sample Report
REPORT: 74 UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM PAGE: 1
AGENCY: 116 SUNSET ADVISORY COMMISSION RUN DATE: XX/XX/20XX
PERIOD END CLEAR CONTROL TOTALS RUN TIME: 21:51:33
AS OF JANUARY
TABLE EMPLOYEES PROCESSED ROWS CLEARED
H0B 0 0
DEA 0 0
H0A 0 0
H0A (ZERO RECORD DELETES) 0 0
H0Z 0 0
H10 0 0
HNY 0 0
HN1 0 0
HM8 0 0