Skip to content
Breadcrumbs

TexPayment Resource

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

Direct Deposit Reports
TINS 87200: Monthly Direct Deposit Listing – Employees (SIC 9901)

Overview

This report is an end-of-month listing of employees with direct deposit account information for the custodial agency.

The report is sorted by TIN and mail code.

Purpose

The custodial agency should review the report to determine if the agency is still the custodial agency for the employees listed on the report. If an employee is no longer employed by the custodial agency, the custodial agency is responsible for submitting the appropriate corrective action–cancel the employee’s direct deposit information or coordinate a custodial agency number change if the employee is employed by a different agency.

Frequency

Monthly

Sample

TINS87200                                 TEXAS IDENTIFICATION NUMBER SYSTEM (TINS)                           XXX        
RUN DATE MM/DD/YY                   MONTHLY DIRECT DEPOSIT LISTING – EMPLOYEES (SIC 9901)                       PAGE:    1
                                    AGENCY NUMBER:   XXX    AGENCY NAME:   NAME OF AGENCY

                                 HOLD      PAYEE      MAIL    SIC                  BANK ACCOUNT     ACCOUNT   FIRST DIRECT
  PAYEE NAME                     STATUS    NUMBER     CODE    CODE  BANK NUMBER       NUMBER          TYPE    DEPOSIT DATE

EMPLOYEE NAME A                          7XXXXXXXXX1   PR1    9901  1234-1234-9    XXXXX6789           22       MM-DD-YY

EMPLOYEE NAME B                 ON HOLD  7XXXXXXXXX3   PR1    9901  1234-5678-1    XXXXXXXXX6789       22       MM-DD-YY

EMPLOYEE NAME B                          7XXXXXXXXX3   PR2    9901  1234-5678-1    XX3456              32       MM-DD-YY

     TOTAL PAYEES AGENCY XXX:  1,234

Field Descriptions

REPORT ID
Displays the unique report number, TINS 87200.

AGENCY NUMBER
Displays the three-digit agency number.

RUN DATE
Displays the date (MM/DD/YY) the report was created.

REPORT TITLE
Displays the name of the report.

PAGE
Displays the sequential number for each page.

AGENCY NUMBER
Displays the three-digit number of the custodial agency.

AGENCY NAME
Displays the name of the custodial agency.

PAYEE NAME
Displays the name of the employee.

HOLD STATUS
Displays ON HOLD if the employee is set up with a hold status. This field will be blank if not on hold.

PAYEE NUMBER
Displays the employee’s 11-digit TIN.

MAIL CODE
Displays the employee’s three-digit mail code associated with the account information.

SIC CODE
Displays the Standard Industrial Classification code 9901 for a state employee.

BANK NUMBER
Displays the nine-digit routing number for the employee’s financial institution.

BANK ACCOUNT NUMBER
Displays only the last four digits of the payee’s account number. Both the custodial agency and paying agencies should maintain and protect payee account information in their internal records.

ACCOUNT TYPE
Displays 22 (checking) or 32 (savings) for the account type that was submitted.

FIRST DIRECT DEPOSIT DATE
Displays the date (MM-DD-YY) the direct deposit information became or will become active.

TOTAL PAYEES AGENCY
Displays the total number of employee mail codes with direct deposit information for the custodial agency.