Skip to content

USPS Reports Guide
USPS Reports by Number

Report 026 Direct Deposit Transmission Report

This report displays totals of checking and savings deductions sent to the direct deposit subsystem. Direct deposit set-up errors also appear on this report.

Report Criteria

Category Payroll Administration
Distribution Agency
Frequency Runs with final payrolls.
Form 926
Sort Sequence
Options H0XCR Sort H0XCR Break
First character – Transaction Code, Employee Number 26 1110
Organization Code, First character – Transaction Code, Employee Number 939 9999
Page Break
Options H0XCR Break
None 1110
Organization Code 9999

Note: Sort sequence option must match the Page Break option.

Parameters  
Databases Used H0C, H0B, H0V, H0H, HID, H0M
Selection Criteria All employees with direct deposit deductions.
Produce Output? No
Request Screen HPRPT – Set up to run automatically with each final payroll.
Posting Report? No
Additional Notes  

Report Headings

ORGANIZATION CODE H0H.ORGCODE
Displays the employee's organization code. This field does not display if the Organization Code Sort option is not requested.
TRANS CODE DERIVED
Displays the system-generated transaction code used to identify loan payments, checking and savings deposits, and prenotification entries.
22Checking account deposit
23Prenotification for checking account deposit
27Checking account reversal (debit)
32Savings account deposit
33Prenotification for savings account deposit
37Savings account reversal
43Prenotification for loan payment
47Loan payment reversal
EMPLOYEE SSN H0B.EMPLOYEENO
Displays the employee's SSN.
MAIL CODE DERIVED
Displays TINS mail codes for direct deposits.
EMPLOYEE NAME HID.RPTNAME
Displays the employee's name.
DOCUMENT NUMBER H0H.ALPHACONS1
Displays the USAS document number assigned to the payroll.
DEPOSIT AMOUNT H0M.DEDAMT(69/70)
Displays the employee's direct deposit amount.
ROUTING NUMBER H0B.BANK1, H0B.BANK2
Displays the employee's bank routing number.
ACCOUNT NUMBER H0B.ACCOUNT1, H0B.ACCOUNT2
Displays the employee's bank account number.
TRACE NUMBER H0H.COMPFIELD3, H0H.COMPFIELD4
Displays the direct deposit tracing number.
ADDITIONAL NOTES
Report 26 displays the message Direct deposit interface will be created by Claims. (A summary of the direct deposit displays under this message.)

Sample Report

   REPORT:    26                             UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM                             PAGE:     1   
   AGENCY:   XXX                                XXXXXXXXXXXX  XX XXXXXXX XXXXXXXXXXX                            RUN DATE: XX/XX/20XX
                                                 DIRECT DEPOSIT TRANSMISSION REPORT                             RUN TIME: 22:28:11  
                                                                                                                                  
TRANS  EMPLOYEE    MAIL                                       DOCUMENT   DEPOSIT   ROUTING      ACCOUNT                           
CODE   SSN         CODE  EMPLOYEE NAME                        NUMBER     AMOUNT    NUMBER       NUMBER              TRACE NUMBER  
                                                                                                                                  
 32    XXX-XX-XXXX  PR2  XXXXXX, XX XXXX                      86014001     100.00  3149 7717 5  1000110071          7177320       
 32    XXX-XX-XXXX  PR2  XXXX, XXXXX XXX                      86014001   2,789.77  0210 0008 9  28234044            7177322       
 32    XXX-XX-XXXX  PR2  XXXXXXX, XXXXXXXX XXX                86014001   2,000.00  1110 0061 4  1618514952          7177340       
 32    XXX-XX-XXXX  PR1  XXXXXXXXX,XXXXXXX XX                 86014001   3,273.85  3149 7854 3  753710              7177345       
 32    XXX-XX-XXXX  PR1  XXXXX,XXXXXXXXXXX                    86014001   4,605.82  1140 0009 3  591201360           7177374       
 32    XXX-XX-XXXX  PR1  XXXXX, XXXX XXXXX                    86014001   2,367.95  3149 7740 5  900141121-0         7177375       
 32    XXX-XX-XXXX  PR2  XXXXXXX,XXXXXXXXX                    86014001   2,100.00  3149 7733 7  22463966            7177376       
 32    XXX-XX-XXXX  PR2  XXXXXXXX, XXXXXXX X                  86014001     200.00  1110 0002 5  005783340613        7177385       
 32    XXX-XX-XXXX  PR1  XXX, XXXX                            86014001   2,524.00  3119 9290 4  824675403           7177394       
 32    XXX-XX-XXXX  PR2  XXXXX, XXXXX X                       86014001   4,021.96  1130 0060 9  099909330701        7177396       
 32    XXX-XX-XXXX  PR2  XXX,XXXXXXXX                         86014001     600.00  3149 7714 6  1064                7177397       
 32    XXX-XX-XXXX  PR1  XXXXX,XXXXXXX XXXXXX                 86014001   4,162.70  3149 7719 1  1639801004          7177454       
 32    XXX-XX-XXXX  PR1  XXX,XXXXXXX X                        86014001   2,322.01  1110 0002 5  005772362819        7177464       
 32    XXX-XX-XXXX  PR1  XXX,XXXXXXX X                        86014001     392.63  1110 0002 5  005772362819        7177465       
 32    XXX-XX-XXXX  PR1  XXXXXX,XXXXXX X                      86014001   2,870.68  1130 0060 9  591076099101        7177483       
 32    XXX-XX-XXXX  PR2  XXXX,XXXXXXXXX XXX                   86014001     400.00  3149 7729 8  6713400             7177504       
 32    XXX-XX-XXXX  PR2  XXXXXXXX, XXXXXX                     86014001     500.00  3149 7066 4  4440429670          7177533