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)
- 001 - Batch/Document Header (SPRR001-01)
- 210 - Exception Transaction Listing (SPRR210-10)
- 240 - Employee Deduction Information (SPRR240-01)
- 530 - Benefit Transaction (SPRR530-01)
- 550 - Deduction Transaction (SPRR550-01)
- 560 - State Match Transaction (SPRR560-01)
- 999 - Batch/Document Trailer (SPRR999-01)
- Processing Summary Listing (SPRR000-02)
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
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
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
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
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
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+
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
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
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
| 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. |