FMX Home
Glenn Hegar  ·  Texas Comptroller of Public Accounts

USPS Reports Guide
Report 1012 Company Diagnostics and Assumptions Listing

This report displays agency and system level transactions that caused an error during PAY020. These can include errors due to missing time card transactions or no payroll request set up.

In order for some of these transactions to process, the error needs to be corrected either by fixing the online entry or deleting the transaction from the pending file and re-entering it onto a batch if necessary.

Report Criteria

Category Payroll Administration
Distribution Agency
Frequency Runs with payroll.
Form  
Sort Sequence Batch Number, Employee Number, Sequence Number
Page Break  
Parameters  
Databases Used HØC, HØI, H1K, HSC, HUA, HUD, HUE, HUZ, T10
Selection Criteria All transactions that were processed on the payroll.
Produce Output? Yes
Request Screen Not requestable by the agencies. Automatically runs each night.
Posting Report? No
Additional Notes

Processes in PAY020.

** 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 NO
Displays the batch number assigned by the agency or the system during the processing. Batch 0 is system generated and usually made up of pending transactions, cancellations, and manual paysets.
ENTRY DATE
Displays the date the transaction was entered for processing.
SEQ NO
Displays the sequence number assigned the transaction.
CONTROL NUMBER
Displays the employee's SSN, if applicable.
TRAN CODE
Displays the code defining the type of transaction.
PHS
Displays the phase of the edit and file maintenance program.
CARD COL
Displays the column numbers of the transaction where the error occurred. See report 1001, 1003, 1017 for the transaction detail.
MSG NO
Displays the number assigned to the error message.
FIELD IN ERROR
Displays the name of field that contained an error, if applicable.
ERROR MESSAGE
Displays an error message associated with the Msg No. that describing the reason for the error.

Note: The error message: "Check date equal to date employee was last paid" will on a regular payroll send the payment transaction to the pending file.

CONTENTS
Displays the value that was in error. Numeric values represent dollar amounts, dates, or transaction codes. Decimal points will not be printed.
TOTAL NUMBER OF ERRORS
Displays the number of transactions found with errors.

CTL card missing – co. will not be paid will print when an adjustment or cancellation transaction is processed. This error can be ignored; an HSCU1 entry is not required.

Sample Report

 REPORT:  1012                             UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM                             PAGE:     1    
 AGENCY:   XXX                                   XXXXXXXXXX XX XXXXXX XXXXXXXX                                RUN DATE: XX/XX/20XX
                                          COMPANY DIAGNOSTICS AND ASSUMPTIONS LISTING                         RUN TIME: 19:34:37 
 EDIT/REPORT RUN **                                                                                                              
        BATCH NO.     0                                                                                                          
        ENTRY     SEQ    CONTROL   TRAN      CARD  MSG                                                                           
        DATE     NUMBER   NUMBER   CODE PHS  COL.  NO.  FIELD IN ERROR         ERROR MESSAGE                      ----CONTENTS---
                                                                                                                                 
      01202006           XXXXXXXXX      198         12                   EMP WILL NOT BE PAID   MISSING PAY TRAN                 
      01202006           XXXXXXXXX      198         12                   EMP WILL NOT BE PAID   MISSING PAY TRAN                 
      01202006           XXXXXXXXX      198         12                   EMP WILL NOT BE PAID   MISSING PAY TRAN                 
      01202006           XXXXXXXXX      198         12                   EMP WILL NOT BE PAID   MISSING PAY TRAN                 
      01202006           XXXXXXXXX      198         12                   EMP WILL NOT BE PAID   MISSING PAY TRAN                 
      01202006           XXXXXXXXX      198         12                   EMP WILL NOT BE PAID   MISSING PAY TRAN                 
      01202006           XXXXXXXXX      198         12                   EMP WILL NOT BE PAID   MISSING PAY TRAN                 
      01202006           XXXXXXXXX      198         12                   EMP WILL NOT BE PAID   MISSING PAY TRAN                 
      01202006           XXXXXXXXX      198         12                   EMP WILL NOT BE PAID   MISSING PAY TRAN                 
      01202006           XXXXXXXXX      198         12                   EMP WILL NOT BE PAID   MISSING PAY TRAN                 
      01202006           XXXXXXXXX      198         12                   EMP WILL NOT BE PAID   MISSING PAY TRAN                 
      01202006           XXXXXXXXX      198         12                   EMP WILL NOT BE PAID   MISSING PAY TRAN                 
      01202006           XXXXXXXXX      198         12                   EMP WILL NOT BE PAID   MISSING PAY TRAN                 
      01202006           XXXXXXXXX      198         12                   EMP WILL NOT BE PAID   MISSING PAY TRAN                 
      01202006           XXXXXXXXX      198         12                   EMP WILL NOT BE PAID   MISSING PAY TRAN                 
      01202006           XXXXXXXXX      198         12                   EMP WILL NOT BE PAID   MISSING PAY TRAN                 
Glenn Hegar
Texas Comptroller of Public Accounts
Questions? Contact statewide.accounting@cpa.texas.gov
Comptroller.Texas.Gov | FMX
FMX Sitemap | Contact FM
Accessibility Policy | Privacy and Security Policy