FMX Home
Glenn Hegar  ·  Texas Comptroller of Public Accounts

USPS Reports Guide
Report 951 ERS Daily Input File Diagnostic

This report is the product of a program in USPS that compares data sent from the ERS Daily Insurances Change file to the prescribed format that is required for each field on that file. This process is run prior to creating Report 999, Daily Insurance Report.

If the ERS Daily Insurance Change file has any data that is not in the prescribed format for a specific field this program will produce a W – warning or an F – fail error message for that field on the report. Transactions with F messages will not be applied to Group Insurance/TexFlex Participant Information HMTU1 screen. These errors can then be worked by the agency in ERS OnLine. If ERS combines two nights Daily Insurances Change files into one file an internal file count error may occur causing this report to display 999-99-9999 in the employee SSN field. In this case, the records sent by ERS have processed, but the control totals records do not match what the USPS program totals. This does not mean that the information sent for that days file is in error, only the control totals records do not match.

ERS receives all of the agencies errors on the ERS Daily Input File Diagnostic Report 950 sent to ERS daily. This report informs ERS of any agencies errors that were reported to the agency on Report 951. This process also creates Financial Adjustment Report 572.

Report Criteria

Category Benefit Administration
Distribution Agency
Frequency Nightly
Form  
Sort Sequence
Options HØXCR
Sort/Break
Employee Number
None
Organization Code, Employee Number
0/9999
Page Break  
Parameters  
Databases Used  
Selection Criteria Transactions that do not match format for ERS Daily File.
Produce Output? Yes
Request Screen Not request able by the agencies.
Posting Report? No
Additional Notes  

Report Headings

ORGANIZATION CODE
Displays the employee's organization Code.
AS OF
Displays the effective date of the report.
EMPLOYEE NAME
Display the employee's name.
EMPLOYEE SSN
Displays the employee's SSN.
FIELD NAME
Displays the name of the field being changed.
INVALID VALUE
Displays the incorrect value that was sent on the file.
EXCEPTION REASON
Displays the reason by the record was rejected.

Sample Report

    REPORT:   951                             UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM                             PAGE:     1    
    AGENCY:   XXX                                XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX                             RUN DATE: XX/XX/20XX
                                                      ERS DAILY INPUT FILE DIAGNOSTIC                           RUN TIME: 19:15:36  
                                                          AS OF 09/08/20XX      

EMPLOYEE                   EMPLOYEE         FIELD                         INVALID          EXCEPTION                               
NAME                       SSN              NAME                          VALUE            REASON                                  
                                                                                                                                   
X                          XXX-XX-XXXX      PART SEX CODE                                  W-INVALID SEX CODE VALUE                
X                          XXX-XX-XXXX      PART BIRTH DATE                                F-INVALID BIRTH DATE FORMAT             
X                          XXX-XX-XXXX      PART FIRST ELIGIBIL DATE                       F-INVALID FIRST ELIGIBILITY DATE FORMAT 
RECORDS REJECTED:  000000010  RECORDS ACCEPTED:  000000229  RECORDS PROCESSED: 000000239 RECORDS WARNINGS: 000000001               
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