Skip to content

SPRS Reports
Payment Record Exception and Balancing
(SPRPWPF-01)

Use this report, along with the Payroll Exception Transaction Listing report (SPRR000-01SPRR000-02) to identify payroll transactions rejected in SPRS processing. This report lists out-of-balance details by record ID, and error messages explaining overpayment errors and other relational errors (such as duplicate pay sequence, more than three charitable deduction vendors, base salary (BSY) hours exceed maximum) for rejected transactions. Document totals for entitlements, deductions, net pay, and state matching and benefits are shown as submitted on the trailer; as calculated systematically; total amount of rejected transactions; total amount of replacements; and total amount of accepted transactions.

                     AGY#
REPORT: SPRPWPF-01                          STATE OF TEXAS                                 RUN DATE: 05/16/2003
                            STANDARDIZED PAYROLL/PERSONNEL REPORTING SYSTEM                RUN TIME: 13:19:47
                                PAYMENT RECORD EXCEPTION AND BALANCING                     PAGE:     1

AGENCY:  AGY#  AGENCY NAME                                        DOCUMENT NUMBER:  83076SP3

SSN         LAST NAME                         FIRST NAME                    MIDDLE NAME
               PAY SEQ  TRANS TYPE    RECORD ID   APPROP YR     PCA    OBJECT  ENT/MC/DED  JOB/SEQ   AMOUNT
---------------------------------------------------------------------------------------------------------------
999-99-9991 LAST NAME1                        FIRST NAME1
                            SP           560          02       P80327   C7032     STR       001      150.00**
                            SP           520          02       P81001   C7002     BSY       001    2,000.00*
                     MESSAGE(S):   5153F - TOTAL PAID HOURS MUST NOT EXCEED MAXIMUM AUTHORIZED HOURS

                            SP           540          02       P81001   C7002     SP1       000    1,750.00
                            SP           550          02       P81001   C7002     FIC       001      100.00
                            SP           550          02       P81001   C7002     FIT       001      100.00
                            SP           550          02       P81001   C7002     ERS       001       50.00
                            SP           560          02       P81142   C7043     FIM       001      100.00**
                            SP           560          02       P89327   C7041     STH       001      250.00**
  > > > > > > > > > > > > >   ENTITLEMENT:     $2,000.00 - (NET: $1,750.00 + DEDUCTION: $250.00) =    $0.00
  
999-99-9992 LAST NAME2                        FIRST NAME2
                  001       SP           510                                                               **
                            SP           530          02                          IMP       000       50.00**
                            SP           560          02       P80327   C7032     STR       001      100.00**
                            SP           520          02       P81001   C7002     BSY       001    3,000.00
                            SP           540          02       P81001   C7002     SP1       000    2,085.00
                            SP           550          02       P81001   C7002     FIC       001      200.00
                            SP           550          02       P81001   C7002     FIT       001      200.00
                            SP           550          02       P81001   C7002     ORD       001        5.00*
                            SP           550          02       P81001   C7002     ORD       002       10.00*
                            SP           550          02       P81001   C7002     401       001      100.00*
                            SP           550          02       P81001   C7002     ERS       001      100.00
                            SP           550          02       P81001   C7002     INS       001      100.00
  > > > > > > > > > > > > >   ENTITLEMENT:     $3,000.00 - (NET: $2,085.00 + DEDUCTION: $715.00) =  $200.00 OOB
  
999-99-9993 LAST NAME3                        FIRST NAME3
                     MESSAGE(S):   6010F - PMT REJECTED FOR TRANSACTION ERROR(S), SEE EXCEPTION TRAN LISTING
 
999-99-9994 LAST NAME4                        FIRST NAME4
                  100       SP           520          02       P81001   C7002     BSY       001    3,000.00*
                     MESSAGE(S):   6008F - SUMMARY RECORD NOT FOUND FOR PAYMENT, PAYMENT REJECTED
 
   * = TRANSACTION(S) IN ERROR / OVERRIDDEN
  ** = TRANSACTION NOT USED FOR PAYMENT BALANCING
 *** = TRANSACTION IN ERROR AND NOT USED FOR PAYMENT BALANCING
 OOB = TRANSACTION IS OUT-OF-BALANCE