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 as of the date of the report.
The report is sorted by TIN and mail code.
Purpose
The purpose of the report is to allow agencies to review the direct deposit information for their employees to determine if the information is still accurate. If an employee is no longer employed with the custodial agency, the custodial agency is responsible for submitting the appropriate corrective action.
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 123456789 22 MM-DD-YY EMPLOYEE NAME B ON HOLD 7XXXXXXXXX3 PR1 9901 1234-5678-1 0000123456789 22 MM-DD-YY EMPLOYEE NAME B 7XXXXXXXXX3 PR2 9901 1234-5678-1 123456 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 for remote print distribution.
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 the employee’s account number.
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.