USPS Reports Guide –
USPS Reports by Number –
Report 2001 CTL List and Payroll Calculation Report
This report displays the payroll transaction run control (the HSCU1 request), employee counts, transaction counts, and number of records written. The calculation statistics including wages, taxes, and adjustment totals for the current payroll are also included.
Report Criteria
| Category | Payroll Administration |
|---|---|
| Distribution | Agency |
| Frequency | Runs with payroll. |
| Form | |
| Sort Sequence | Pay Frequency |
| Page Break | |
| Parameters | |
| Databases Used | |
| Selection Criteria | All records on the current payroll. |
| Produce Output? | Yes |
| Request Screen | Not requestable by the agencies. Automatically runs each night. |
| Posting Report? | No |
| Additional Notes | Processes in PAY040. ** EDIT/REPORT RUN ** will display in the top left corner of the report if the report was produced from a trial/edit payroll. This report will generate twice only when a final payroll is rejected. Use the latest Run Time/Date, which is found in the top right corner of the report. |
Report Headings
- BATCH NUMBER
- Displays the number assigned to the payroll request.
- PAY FREQ(1)/PAY FREQ(2)
- Displays the type of payroll that was requested.
70 Semi-monthly 90 Monthly - DED PER
- Displays the pay period of the month being processed.
1 Monthly or first half semi-monthly 2 Second-half semi-monthly - PERIOD BEGINNING DATE
- Displays the beginning date of the pay period.
- PERIOD ENDING DATE
- Displays the ending date of the pay period.
- CHECK DATE
- Displays the warrant date of pay period.
- PAY TYP
- Displays a type of payroll requested.
- HOLD SWITCH
- Displays how to process a batch if it is out of balance.
- REL SW
- Displays transactions that are to be released form the pending file.
- RCY SW
- Displays how transactions are to be added to the pending file.
- BCH SW
- Displays how transactions are to be shown, in detail or summary.
- BATCH COUNT
- Displays the number of batches processed.
- EDIT FROM DATE
- Not used.
- EDIT TO DATE
- Not used.
- LABOR POST DATE
- Not used.
- EMPLOYEE COUNTS
- Displays the number of employees processed on the payroll. No employees are actually paid on edit or trial payrolls.
- TRANSACTION COUNTS
- Displays the number of transactions processed on the payroll. No transactions are actually written on edit or trial payrolls.
- RECORDS WRITTEN
- Displays the number of records written on the payroll. No records are actually written on edit or trial payrolls.
- CALCULATION STATISTICS FOR FREQUENCIES LISTED ABOVE
- Displays the year-to-date totals prior to and after the payroll request. The current payroll totals, along with paid and non-paid update totals are also included.
Sample Report
REPORT: 2001 UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM PAGE: 1
AGENCY: XXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX RUN DATE: XX/XX/20XX
CTL LIST AND PAYROLL CALCULATION REPORT RUN TIME: 20:25:28
** EDIT/REPORT RUN **
PAY PAY PERIOD PERIOD EDIT EDIT LABOR
BATCH FREQ FREQ DED BEGINNING ENDING CHECK PAY REL RCY BCH BATCH FROM TO POST
NUMBER (1) (2) PER DATE DATE DATE TYP HOLD SWITCH SW SW SW COUNT DATE DATE DATE
0 90 90 1 09/01/20XX 09/30/20XX 10/01/20XX 5 PAY REGARDLESS 0 0 0 0
EMPLOYEE COUNTS TRANSACTION COUNTS RECORDS WRITTEN
ACTIVE 1,244 ENTERED 1,429 LABOR DETAIL 1,430
ON LEAVE 0 GENERATED (DED) 0 LABOR TOTAL 2,464
TERMINATED 58 GENERATED (TAX) 1 CURRENT PAY 2,464
PAID 1,302 * CURRENT LABOR TOTALS FOLLOW ON REPORT 2011
CALCULATION STATISTICS FOR FREQUENCIES LISTED ABOVE
YTD BEFORE CURRENT YTD AFTER PAID UPDATES NON-PAID UPDATES
GROSS PAY 50804221.29 1120563.42 51924784.71 .00 4170.97-
REGULAR PAY 43482451.05 19787.11 43502238.16 .00 3969.33-
REGULAR HRS 2244973.35 1073.20 2246046.55 .00 176.00-
OVERTIME PAY 5188937.20 632448.81 5821386.01 .00 .00
OVERTIME HRS 171386.10 20671.35 192057.45 .00 .00
VOL DEDUCTS 7691065.66 22549.09 7713614.75 .00 639.37-
FEDERAL TAX 5668180.86 274029.83 5942210.69 .00 619.11-
OASDI TAX 3008381.73 69428.19 3077809.92 .00 248.04-
HI TAX 703573.31 16237.15 719810.46 .00 58.01-
MED TAX .00 .00 .00 .00 .00
SIT TAX .00 .00 .00 .00 .00
LOCAL TAX .00 .00 .00 .00 .00
SP LOCAL TAX .00 .00 .00 .00 .00
DI TAX .00 .00 .00 .00 .00
NET PAY 33674065.54 738328.06 34412393.60 .00 2602.04-