Skip to content
Breadcrumbs

TexPayment Resource

Note: To navigate this guide on a mobile device you must use the Table of Contents.

Reversal/Reclamation Reports
Daily Reversals/Reclamations Agency Reports

Overview

Daily reports are provided when agencies process reversal and reclamation requests in the Direct Deposits — Reversals and Reclamations (DDEP) (login required) web application. These reports are available for download the business day after reversals and reclamations are processed in DDEP and are bundled with each agency’s daily reports generated from the:

  • Uniform Statewide Accounting System (USAS).
  • Texas Identification Number System (TINS).

Individual reports are created based on the different payment types. It is each agency’s responsibility to deliver these reports after download to the appropriate staff to ensure only authorized staff has access to payment and direct deposit account information. These daily DDEP agency reports include:

Purpose

These reports provide agencies with a list of reversal and reclamation transactions processed in DDEP the prior business day. The day the reports are available for download is the date the reversals and reclamations are transmitted to the automated clearing house (ACH) network. Field values such as reversal reasons that are identified as erroneous when entered in DDEP can no longer be corrected once they appear on these reports.

Frequency

Reports are produced daily when agencies have processed reversals and reclamations in DDEP on a prior business day. Reports for reversals and reclamations processed:

  • After 7 p.m. are available two business days from the processing date.
  • On weekends and holidays when a processing cycle is not scheduled are available the business day after the next processing cycle is scheduled. See the System Outages and Holidays calendar for processing cycle dates.

Sample Reports

Each report in this series has the same layout and fields, with the exception of the payroll/annuity reversal and reclamation reports, which include some different fields.

Sample SWARVSR-VN: Vendor Reversal Requests by Agency

SWARVSR-VN                         TEXAS IDENTIFICATION NUMBER SYSTEM               123
DATE MM/DD/YYYY                    VENDOR REVERSAL REQUESTS BY AGENCY                           PAGE  1

 123    STATE AGENCY NAME
--------------------------------------------------------------------------------------------------------
                                 PMT                ISSUE     ROUTING   ACCOUNT    ACCT      REV  USER
TIN / MAIL CODE  PAYEE NAME      NUM       AMOUNT    DATE     NUMBER    NUMBER     TYPE MOPN RSN   ID
--------------------------------------------------------------------------------------------------------
1XXXXXXXXX6 XXX  VENDOR PAYEE 1 XXXXXXX    XXX.XX  MM/DD/YYYY XXXXXXXXX XXXXXXXXX  CKG  LEP  XXX ABCD123
7XXXXXXXXX2 XXX  VENDOR PAYEE 2 XXXXXXX    XXX.XX  MM/DD/YYYY XXXXXXXXX XXXXX      CKG  FP   XXX ABCD123

      TOTAL AGENCY VENDOR REVERSALS COUNT                          X
      TOTAL AGENCY VENDOR REVERSALS AMOUNT                   $XXX.XX

Sample SWARVSR-TR: Travel Reversal Request by Agency

SWARVSR-TR                          TEXAS IDENTIFICATION NUMBER SYSTEM             123
DATE MM/DD/YYYY                     TRAVEL REVERSAL REQUESTS BY AGENCY                          PAGE  1

 123    STATE AGENCY NAME
--------------------------------------------------------------------------------------------------------
                                 PMT                ISSUE     ROUTING   ACCOUNT    ACCT      REV  USER
TIN / MAIL CODE  PAYEE NAME      NUM       AMOUNT    DATE     NUMBER    NUMBER     TYPE MOPN RSN   ID
--------------------------------------------------------------------------------------------------------
7XXXXXXXXX3 XXX  EMPLOYEE NAME 1 XXXXXXX   XXX.XX  MM/DD/YYYY XXXXXXXXX XXXXXXXXX  CKG  EP   XXX ABCD123
7XXXXXXXXX2 XXX  EMPLOYEE NAME 2 XXXXXXX   XXX.XX  MM/DD/YYYY XXXXXXXXX XXXXX      CKG  E    XXX ABCD123

      TOTAL AGENCY TRAVEL REVERSALS COUNT                          X
      TOTAL AGENCY TRAVEL REVERSALS AMOUNT                   $XXX.XX

Sample SWARVSR-PR: Payroll Reversal Requests by Agency

SWARVSR-PR                         TEXAS IDENTIFICATION NUMBER SYSTEM                 123
DATE MM/DD/YYYY                    PAYROLL REVERSAL REQUESTS BY AGENCY                          PAGE  1

 123    STATE AGENCY NAME
--------------------------------------------------------------------------------------------------------
                                 PMT                ISSUE     ROUTING   ACCOUNT    ACCT PMT  REV  USER
TIN / MAIL CODE  PAYEE NAME      NUM       AMOUNT    DATE     NUMBER    NUMBER     TYPE TYPE RSN   ID
--------------------------------------------------------------------------------------------------------
7XXXXXXXXX8 XXX  EMPLOYEE NAME 1 XXXXXXX   XXX.XX  MM/DD/YYYY XXXXXXXXX XXXXXXXXX  CKG   B   XXX ABCD123
7XXXXXXXXX1 XXX  EMPLOYEE NAME 2 XXXXXXX   XXX.XX  MM/DD/YYYY XXXXXXXXX XXXXX      SAV   M   XXX ABCD123

      TOTAL AGENCY COUNT                                           X
      TOTAL AGENCY AMOUNT                                    $XXX.XX

Sample SWARVSR-AN: Annuity Reversal Requests by Agency

SWARVSR-AN                         TEXAS IDENTIFICATION NUMBER SYSTEM                 123
DATE MM/DD/YYYY                    ANNUITY REVERSAL REQUESTS BY AGENCY                          PAGE  1

 123    STATE RETIREMENT AGENCY NAME
--------------------------------------------------------------------------------------------------------
                                 PMT                ISSUE     ROUTING   ACCOUNT    ACCT PMT  REV  USER
TIN / MAIL CODE  PAYEE NAME      NUM      AMOUNT    DATE      NUMBER    NUMBER     TYPE TYPE RSN   ID
--------------------------------------------------------------------------------------------------------
7XXXXXXXXX8 XXX  ANNUITANT NAME 1 XXXXXXX  XXX.XX  MM/DD/YYYY XXXXXXXXX XXXXXXXXX  CKG   M   XXX ABCD123
7XXXXXXXXX1 XXX  ANNUITANT NAME 2 XXXXXXX  XXX.XX  MM/DD/YYYY XXXXXXXXX XXXXX      CKG   S   XXX ABCD123

      TOTAL AGENCY REVERSAL COUNT                                  X
      TOTAL AGENCY REVERSAL AMOUNT                           $XXX.XX

Sample SWARVSR-RL: Annuity Reclamation Requests by Agency

SWARVSR-AN                         TEXAS IDENTIFICATION NUMBER SYSTEM                 123
DATE MM/DD/YYYY                  ANNUITY RECLAMATION REQUESTS BY AGENCY                          PAGE  1

 123    STATE RETIREMENT AGENCY NAME
--------------------------------------------------------------------------------------------------------
                                  PMT                ISSUE    ROUTING   ACCOUNT  ACCT             USER
TIN / MAIL CODE  PAYEE NAME       NUM     AMOUNT     DATE     NUMBER    NUMBER   TYPE   DODN       ID
--------------------------------------------------------------------------------------------------------
7XXXXXXXXX8 XXX  ANNUITANT NAME 1 XXXXXXX  XXX.XX  MM/DD/YYYY XXXXXXXXX XXXXXXXX CKG  MM/DD/YYYY ABCD123
7XXXXXXXXX1 XXX  ANNUITANT NAME 2 XXXXXXX  XXX.XX  MM/DD/YYYY XXXXXXXXX XXXXX    SVG  MM/DD/YYYY ABCD123

      TOTAL AGENCY RECLAMATIONS COUNT                         X
      TOTAL AGENCY RECLAMATIONS AMOUNT                  $XXX.XX

Field Descriptions

REPORT ID
Displays the unique report number in the upper left corner.
SYSTEM NAME
Displays the statewide system that produces the report.
AGENCY NUMBER
Displays the three-digit agency number in the upper right corner, used as the agency destination for report downloads.
RUN DATE
Displays the date the transactions processed in the MM/DD/YYYY format.
REPORT TITLE
Displays the title of the report.
PAGE
Displays the sequential numbering of each page.
AGENCY NUMBER
Displays the three-digit agency number.
AGENCY NAME
Displays the agency name.
TIN/MAIL CODE
Displays the 11-digit TIN and three-digit mail code for the payee.
PAYEE NAME
Displays the payee name for the TIN/mail code.
PMT NUM
Displays the seven-digit direct deposit payment number.
AMOUNT
Displays the amount of the payment.
ISSUE DATE
Displays the payment issue date in the MM/DD/YYYY format.
ROUTING NUMBER
Displays the nine-digit routing number of the payee’s financial institution where the payment was transmitted.
ACCOUNT NUMBER
Displays the masked account number, with only the last four digits, where the payment was transmitted. Each agency can request that their reports display the full account numbers by emailing payment.services.dd@cpa.texas.gov with the subject “Mask/Unmask Account Numbers.”
ACCOUNT TYPE
Displays the account type as CKG=checking or SVG=savings.
MOPN
Displays one-character values for the method(s) of payee notification for the reversal, up to four characters as follows:
  • E=Email
  • F=Fax
  • L=Letter
  • P=Phone call
PMT TYPE
Displays the one-character type of payment for a payroll or annuity payment as follows:
  • S=Supplemental employee or annuity payroll
  • B=Bimonthly employee payroll
  • M=Monthly employee or annuity payroll
REV RSN
Displays the three-digit value for the reversal reason as follows:
  • 301=Incorrect payee
  • 302=Incorrect payment amount
  • 307=Duplicate payment
  • 308=Incorrect payment date
DODN
Displays the date, in the MM/DD/YYYY format, that the retirement system received notification of the annuitant’s date of death.
USER ID
Displays the seven-character user ID of the agency staff member who processed the reversal or reclamation request.
TOTAL AGENCY COUNT
Displays the total count of reversals or reclamations processed.
TOTAL AGENCY AMOUNT
Displays the total amount of the reversals or reclamations processed.