SPRS Reports —
Payment Record Exception and Balancing
(SPRPWPF-01)
Use this report, along with the Payroll Exception Transaction Listing report (SPRR000-01–SPRR000-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