Skip to content

SPRS Reports
Exception Transaction Listing
(SPRR000-01, SPRR001-01, SPRR210-01, SPRR240-01, SPRR530-01, SPRR999-01, SPRR000-02)

Updated: March 15, 2013 – View Changes

This report is divided into two sections, personnel and payroll. Use the personnel report to identify personnel transactions rejected in SPRS processing as well as transactions generating warning messages. The report also lists total rows submitted and total transactions, and total accepted and rejected transactions. The report is broken by record type 001, 200, 210, 220, 230, 240, 250, and 999.

Use the payroll section, along with the Payment Record Exception and Balancing report (SPRPWPF-01) to identify payroll transactions rejected in SPRS processing as well as transactions generating warning messages. The report lists total records sent, total accepted, and total rejected by record type 001, 510, 520, 530, 540, 550, 560, and 999.

Click on an item to jump to a specific report:

Batch Summary Listing (SPRR000-01)

                     AGY#
REPORT: SPRR000-01                          STATE OF TEXAS                                 RUN DATE: 07/10/2003
                            STANDARDIZED PAYROLL/PERSONNEL REPORTING SYSTEM                RUN TIME: 16:46:40
                         EXCEPTION TRANSACTION LISTING - BATCH SUMMARY LISTING             PAGE:     1

AGENCY:  AGY#  AGENCY NAME                                      BATCH/DOC NUMBER: ABCDE999

                                                                   ROWS           TOTAL
           RECORD TYPE                                             SUBMITTED      TRANSACTIONS
           ---------------------------------------------------     ----------     ------------
           001 - BATCH/DOCUMENT HEADER:                                     1                1

           200 - SOCIAL SECURITY CHANGE:                                    0                0
           210 - EMPLOYEE DESCRIPTIVE INFORMATION:                          0                0
           220 - EMPLOYEE JOB INFORMATION:                                  0                0
           230 - EMPLOYEE ENTITLEMENT INFORMATION:                          0                0
           240 - EMPLOYEE DEDUCTION INFORMATION:                            7               15
           250 - EMPLOYEE DIRECT DEPOSIT INFORMATION:                       0                0

           510 - SUMMARY PAYMENT TRANSACTION:                               0                0
           520 - ENTITLEMENT TRANSACTION:                                   0                0
           530 - BENEFIT TRANSACTION:                                       1                1
           540 - NET PAY TRANSACTION:                                       0                0
           550 - DEDUCTION TRANSACTION:                                     0                0
           560 - STATE MATCH TRANSACTION:                                   0                0
           590 - REPLACEMENT PAYMENT TRANSACTION:                           0                0

           690 - CANCELLATION TRANSACTION:                                  0                0
           691 - CALLBACK/RETURN FROM BANK FOR DIRECT DEPOSIT:              0                0

           999 - BATCH/DOCUMENT TRAILER:                                    1                1

           OTH - OTHER RECORDS RECEIVED:                                    0                0
                                                                   ----------       ----------
                                             COUNT:                        10               18

                                     TRAILER COUNT:                        10

Back to Top

001 - Batch/Document Header (SPRR001-01)

                     AGY#
REPORT: SPRR001-01                         STATE OF TEXAS                                 RUN DATE: 07/10/2003
                            STANDARDIZED PAYROLL/PERSONNEL REPORTING SYSTEM               RUN TIME: 16:46:40
                       EXCEPTION TRANSACTION LISTING - (001) BATCH/DOCUMENT HEADER        PAGE:     1

AGENCY:  AGY#  AGENCY NAME                                      BATCH/DOC NUMBER: ABCDE999

  1  SPRS TRAN NO    AGY NO           BATCH/DOC NO     REC ID       BATCH TYPE      BATCH NAME     AGY DT
  2  PMT DT          PAY PER END      TAX DEP DT       USAS IND

          TOTAL RECS SENT:      1           TOTAL ACCEPTED:        1       TOTAL REJECTED:      0

Back to Top

210 – Exception Transaction Listing (SPRR210-01)

    REPORT: SPRR210-01                                          STATE OF TEXAS                                     RUN DATE: 11/23/9999 
                                           STANDARDIZED PAYROLL/PERSONNEL REPORTING SYSTEM                      RUN TIME: 19:42:54   
                                EXCEPTION TRANSACTION LISTING - (210) EMPLOYEE DESCRIPTIVE INFORMATION              PAGE:      1     
0AGENCY:  AGENCY NAME                                 BATCH NUMBER:     ABCDEF                   
0   1    SPRS TRAN NO    AGY NO          BATCH NO        REC ID      SSN             PROC SEQ ID     EFFECTIVE DT    RSN CD          
    2    REV IND         LWOP IND        DATA REL IND    BIRTH DT    RACE            SEX             CMPTRL NO IND   VET IND         
    3    VET PREF IND    CITIZEN STATUS  CITIZEN CNTRY               CPO IND         RETIREMENT CD   FICA EXEMPT     BRP ELIG IND    
    4    STATUS ATTR     AGY TRN FROM    AGY TRN TO      EFF SVC DT  6 CNT SVC IND   PAY RAISE ELIG                                  
    5    ADDRESS 1                                                   CITY                            STATE                           
    6    ADDRESS 2                                                   ZIP CD                          CNTRY/ZONE                      
    7    ADDR RLSE       HOME PH RLSE    SSN RLSE        FAM RLSE    EMER RLSE                       CMPTRL NO IND   VET IND         
 ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0----+----1----+----2----+----3--
 SSN         LAST NAME                           FIRST NAME           MIDDLE NAME                                                    
 ----------- ----------------------------------- -------------------- --------------------                                           
XXX-XX-XXXX LAST NAME                             FIRST               MI                                                              
    1         3,473      AGY ###           ABCDEF        210         XXX-XX-XXXX     002             10/20/9999     038             
    2                    Y                                                                                                           
    3                                                                                                                                
    4                                                                                                                                
    5                                                                                                                                
    6                                                                                                                                
    7                                                                                                                                
  2383W - LWOP IND ON FILE AND ON TRANSACTION MUST NOT BE THE SAME                                                                   
  2279F - TRANSACTION DOES NOT REFLECT A CHANGE TO INFORMATION ON FILE                                                               
XXX-XX-XXXX LAST NAME                              FIRST               MI                                                                                          
    1         3,514      AGY ###          ABCDEF         210         XXX-XX-XXXX     001             11/14/9999      010             
    2                                                    09/12/9999  W               F               N               N               
    3    N                                                           N               N               N               W               
    4    N                                               11/14/9999                                                                  
    5    ADDRESS 1                                                   CITY                          STATE                             
    6                                                                000000000                       USA                             
    7    N               N               N               N           N                                                               
  2000W - SSN ALREADY EXISTS FOR ANOTHER EMPLOYEE                                                                                    
XXX-XX-XXXX LAST NAME                               FIRST               MI                                                                                         
    1         3,588      AGY ###          ABCDEF          210         XXX-XX-XXXX     001             11/14/9999      010             
    02/25/9999 B               F               N               N               
    3    N                                                           N               N               N               W               
    4    N                                               08/24/9999                                                                  
    5    ADDRESS 1                                                   CITY                          STATE                             
    6                                                                000000000                       USA                             
    7    N               N               N               N           N                                                               
  2319I - CPO IND CHANGED TO 'Y'; EMPLOYEE IS OR WAS A PEACE OFFICER 

    

Back to Top

240 - Employee Deduction Information (SPRR240-01)

                     AGY#
REPORT: SPRR240-01                         STATE OF TEXAS                                 RUN DATE: 07/10/2003
                            STANDARDIZED PAYROLL/PERSONNEL REPORTING SYSTEM               RUN TIME: 16:46:40
                 EXCEPTION TRANSACTION LISTING - (240) EMPLOYEE DEDUCTION INFORMATION     PAGE:     1

AGENCY:  AGY#  AGENCY NAME                                      BATCH/DOC NUMBER: ABCDE999

      1   SPRS TRAN NO    AGY NO      BATCH NO        REC ID          SSN
      2   ACTION CD       DED CD      DED SEQ NO      EFFECTIVE DT    DED AUTH AMT    DED AUTH RATE

   SSN         LAST NAME                        FIRST NAME              MIDDLE NAME
   ----------- -------------------------------- ----------------------- --------------------------
   999-99-9991 LAST                             FIRST                   MI
      1   2               AGY#        HCDEH430        240             999-99-9991
      2   A               401         001             04/01/2003      0.00           .10000
    2080F - DED SEQ NO AND DED CD MUST BE UNIQUE FOR EACH 'A'DD ACTION CD
   999-99-9992 LAST                             FIRST                   MI
      1   7               AGY#        HCDEH430        240             999-99-9992
      2   A               BON         001             04/01/2003                     50.00
    1023F - SSN NOT FOUND
   999-99-9992 LAST                             FIRST                   MI
      1   8               AGY#        HCDEH430        240             999-99-9992
      2   A               ORD         021             04/01/2003                     32.00
    1023F - SSN NOT FOUND
   999-99-9992 LAST                             FIRST                   MI
      1   9               AGY#        HCDEH430        240             999-99-9992
      2   A               INS         041             04/01/2003                     102.00
    1023F - SSN NOT FOUND
   999-99-9993 LAST                             FIRST                   MI
      1   10              AGY#        HCDEH430        240             999-99-9993
      2   C               INS         001             04/01/2003                     50.00
    2127F - ENT CD/DED CD NOT PREVIOUSLY ESTABLISHED

           TOTAL RECS SENT:      15         TOTAL ACCEPTED:       9        TOTAL REJECTED:      6

Back to Top

530 - Benefit Transaction (SPRR530-01)

                     AGY#
REPORT: SPRR530-01                         STATE OF TEXAS                                 RUN DATE: 07/10/2003
                            STANDARDIZED PAYROLL/PERSONNEL REPORTING SYSTEM               RUN TIME: 16:46:40
                       EXCEPTION TRANSACTION LISTING - (530) BENEFIT TRANSACTION          PAGE:     1

AGENCY:  AGY#  AGENCY NAME                                      BATCH/DOC NUMBER: ABCDE999

   1  SPRS TRAN NO   AGY NO           DOC NO         REC ID        SSN              PMT SEQ NO     PMT TRN TYPE
   2  AY             PAY PER START    PAY PER END    BENEFIT CD    BENEFIT VALUE

  SSN         LAST NAME                        FIRST NAME              MIDDLE NAME
  ----------- -------------------------------- ----------------------- ----------------------------------------
  999-99-9994 LAST                             FIRST                   MI
    1 16             AGY#             HCDEH430       530           999-99-9994
    2                TXF00120         03040100       000           0
  3003F - INVALID TRANSACTION FOR PERSONNEL BATCH TYPE

           TOTAL RECS SENT:      1          TOTAL ACCEPTED:       0        TOTAL REJECTED:      1
	

Back to Top

550 -Deduction Transaction (SPRR550-01)

REPORT: SPRR550-01                                           STATE OF TEXAS                                     RUN DATE: MM/DD/YYYY
                                           STANDARDIZED PAYROLL/PERSONNEL REPORTING SYSTEM                      RUN TIME: 10:54:12  
                                      EXCEPTION TRANSACTION LISTING - (550) DEDUCTION TRANSACTION                   PAGE:      1    

AGENCY:  123  STATE AGENCY                                                                DOCUMENT NUMBER:  89999X01                

    1   SPRS TRAN NO   AGY NO      DOC NO        REC ID          SSN                    PMT SEQ NO      PMT TRN TYPE                   
    2    DED CD        DED SEQ NO  DED VEN NAME/SDD INFO                                DED VEN ID      SORT SEQ        LOC CD         
    3    AY            PCA/INDEX   OBJECT        PAY PER START   PAY PER END            ORIG VEN ID     DED-AMT                        
 ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0----+----1----+----2----+----3-
 SSN         LAST NAME                           FIRST NAME           MIDDLE NAME                                                   
 ----------- ----------------------------------- -------------------- --------------------                                          

 XXX-XX-XXXX LAST                                FIRST                M                                                               
    1            15    123         89999X01      550             XXX-XX-XXXX            001             SP                            
    2    CHI           001         NON SDD CHILD SUPPORT DEDUCTION                      99999999999003                               
    3    13            P#####      C7###         12/01/20XX      12/31/20XX             99999999999003      7.65+                 

    

Back to Top

560 - State Match Transaction (SPRR560-01)

REPORT: SPRR560-01                                           STATE OF TEXAS                                     RUN DATE: MM/DD/YYYY
                                           STANDARDIZED PAYROLL/PERSONNEL REPORTING SYSTEM                      RUN TIME: 10:54:12  
                                      EXCEPTION TRANSACTION LISTING - (560) STATE MATCH TRANSACTION                 PAGE:      1    

AGENCY:  123  STATE AGENCY                                                                DOCUMENT NUMBER:  89999X01                

    1   SPRS TRAN NO   AGY NO        DOC NO        REC ID          SSN                  PMT SEQ NO       PMT TRN TYPE                   
    2    ST MCH CD     ST MCH SEQ NO ST MCH VEN NM                                      ST MCH VEN ID    SORT SEQ        LOC CD         
    3    AY            PCA/INDEX     OBJECT        PAY PER START   PAY PER END          ORIG VEN ID      ST MCH AMT                        
 ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0----+----1----+----2----+----3-
 SSN         LAST NAME                           FIRST NAME           MIDDLE NAME                                                   
 ----------- ----------------------------------- -------------------- --------------------                                          

 XXX-XX-XXXX LAST                                FIRST                M                                                               
    1         1,115    123           89999X01      560             XX-XX-XXXX          001              SP                            
    2    STF           001           EMPLOYEES RETIREMENT SYSTEM STATE CONT             99999999999026                               
    3    13            P#####        C7###         12/01/20XX      12/31/20XX           99999999999026        17.65+               
  ####F - ST MATCH CODE ERROR                                                                                                          

    

Back to Top

999 - Batch/Document Trailer (SPRR999-01)

                     AGY#
REPORT: SPRR999-01                         STATE OF TEXAS                                 RUN DATE: 07/10/2003
                            STANDARDIZED PAYROLL/PERSONNEL REPORTING SYSTEM               RUN TIME: 16:46:40
                      EXCEPTION TRANSACTION LISTING - (999) BATCH/DOCUMENT TRAILER        PAGE:     1

AGENCY:  AGY#  AGENCY NAME                                      BATCH/DOC NUMBER: ABCDE999

   1  REC SEQ NO     AGY NO           BATCH/DOC NO     REC ID           REC COUNT
   2  DOC DED TTL    DOC ENT TTL      DOC NET TTL      DOC ST MCH TL    DOC BEN TTL

        TOTAL RECS AGY SENT:     1        TOTAL RECS ACCEPTED:      1       TOTAL RECS REJECTED:     0
	

Back to Top

Processing Summary Listing (SPRR000-02)

                     AGY#
REPORT: SPRR000-02                          STATE OF TEXAS                                 RUN DATE: 07/10/2003
                            STANDARDIZED PAYROLL/PERSONNEL REPORTING SYSTEM                RUN TIME: 16:46:40
                       EXCEPTION TRANSACTION LISTING - PROCESSING SUMMARY LISTING          PAGE:     1

AGENCY:  AGY#  AGENCY NAME                                      BATCH/DOC NUMBER: ABCDE999

           RECORD TYPE                                             TTL ACCEPTED      TTL REJECTED
           ---------------------------------------------------     ------------      ------------
           001 - BATCH/DOCUMENT HEADER:                                       1                 0

           200 - SOCIAL SECURITY CHANGE:                                      0                 0
           210 - EMPLOYEE DESCRIPTIVE INFORMATION:                            0                 0
           220 - EMPLOYEE JOB INFORMATION:                                    0                 0
           230 - EMPLOYEE ENTITLEMENT INFORMATION:                            0                 0
           240 - EMPLOYEE DEDUCTION INFORMATION:                              9                 6
           250 - EMPLOYEE DIRECT DEPOSIT INFORMATION:                         0                 0

           510 - SUMMARY PAYMENT TRANSACTION:                                 0                 0
           520 - ENTITLEMENT TRANSACTION:                                     0                 0
           530 - BENEFIT TRANSACTION:                                         0                 1
           540 - NET PAY TRANSACTION:                                         0                 0
           550 - DEDUCTION TRANSACTION:                                       0                 0
           560 - STATE MATCH TRANSACTION:                                     0                 0
           590 - REPLACEMENT PAYMENT TRANSACTION:                             0                 0

           690 - CANCELLATION TRANSACTION:                                    0                 0
           691 - CALLBACK/RETURN FROM BANK FOR DIRECT DEPOSIT:                0                 0

           999 - BATCH/DOCUMENT TRAILER:                                      1                 0

           OTH - OTHER RECORDS RECEIVED:                                      0                 0
                                                                   ------------      ------------
                                            COUNT:                           11                 7
	
Changes to this Document
Date Updates
03/15/2013 Modified two Exception Transaction Listing reports (SPRR550-01 & SPRR560-01) to include original vendor ID information (ORIG VEN ID).
12/14/2011 Added Exception Transaction Listing (SPRR210-10) effective 10/01/2011.