FMX Home
Glenn Hegar  ·  Texas Comptroller of Public Accounts

USPS Reports Guide
Report 547 Batch Transaction Interface Error Report

This report automatically generates when payroll batch transactions are loaded. Any transaction that did not meet the required file edits will display, along with a corresponding error message. Accepted transactions are passed on to Report 548 for additional editing and loading to online data entry screens. Entries with errors can be manually entered online with the corrected information or they can be re-loaded.

Transaction counts are also included on the report and can be used for verification of the file load. Counts will be two higher than on Report 548 due to the header and footer records.

Batch loads will be processed at 4 p.m. daily. Files not received before that time will not be processed that day.

Report Criteria

Category Payroll Administration
Distribution Agency
Frequency Runs with the time card interface.
Form  
Sort Sequence Error Code, Batch Number, Employee Number
Page Break  
Parameters Agency Payroll Interface File
Databases Used HØC
Selection Criteria All transactions on the payroll interface file.
Produce Output? Yes
Request Screen Not requestable by the agencies; automatically runs with the interface file.
Posting Report? No
Additional Notes See the USPS Interface Manual (login required) for additional information, such as the file layout.

Report Headings

AGENCY NUMBER INTERFACE FILE
Displays the agency number.
EMPLOYEE NUMBER INTERFACE FILE
Displays the employee's SSN.
TRAN CODE INTERFACE FILE
Displays the code of the errored transaction.
COLUMN FIELDS 20–80 INTERFACE FILE
Displays the transaction data fields as they were interfaced.
POS DERIVED
Displays the column number(s) in which the error occurred.
MESSAGE DERIVED
Displays an error message describing the error in the transaction.
INPUT TRANS DERIVED
Displays the number of transactions sent from the interface file.
PASSED TRANS DERIVED
Displays the number of transactions accepted from the interface file.
DROPPED TRANS DERIVED
Displays the number of transactions rejected from the interface file.

Sample Report

 REPORT:   547           UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM                           PAGE:    1
 AGENCY:   XXX                 XXXX XXXXX XXXXXXXXXXX XXXXX                               RUN DATE: XX/XX/20XX
                             BATCH TRANACTION INTERFACE ERROR REPORT                      RUN TIME: 2:00:00
                       
AGENCY		EMPLOYEE	TRANS	2         3         4         5         6         7         8                         
NUMBER		 NUMBER		CODE	0123456789012345678901234567890123456789012345678901234567890	POS	MESSAGE      
                   
				     INPUT TRANS:	  3,800	    PASSED TRANS:	 3,8000	    DROPPED TRANS:           0
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