PR_03 P/R Direct Deposit Transaction File (PR_03DirectDepTransaction) Level: 4.40 Record Type: 1 Direct Deposit Transaction Header Record 08/28/2009 File Type: Direct Key Size: 16 Rec Len: 112 Min Len: 80 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Batch Number. . . . . . . . . . . . . . BatchNumber . . . . . . . . . Uppercase *(1,4) Record Type " " . . . . . . . . . . . . RecordType. . . . . . . . . . String *(5,1) Department Number (Blank If Header) . . Dept. . . . . . . . . . . . . Zero-Filled *(6,2) Employee Number (Blank If Header) . . . EmployeeNumberIf. . . . . . . String *(8,7) Sequence Number (Blank If Header) . . . SeqNumberIf . . . . . . . . . Zero-Filled *(15,2) File Transmitted? . . . . . . . . . . . FileTransmitted . . . . . . . Yes/No (17,1) Date Transmitted. . . . . . . . . . . . DateTransmitted . . . . . . . Date (18,6) Effective Date. . . . . . . . . . . . . EffectiveDate . . . . . . . . Date (24,6) Company Bank Account Number . . . . . . CompanyBankAcctNumber . . . . String (30,17) Company Account R/T Number. . . . . . . CompanyAcctRoutingTransitNo . String (47,9) Company Account Type. . . . . . . . . . CompanyAcctType . . . . . . . Uppercase (56,1) Batch Description . . . . . . . . . . . BatchDescription. . . . . . . String (57,10) Transaction Type ("PPD"). . . . . . . . TransactionType . . . . . . . String (67,3) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (70,11) Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [0] 0. Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [1] 0. Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [2] 0. Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [3] 0. Open Number . . . . . . . . . . . . . . _N5 . . . . . . . . . . . . . Open Number [4] 0. ________ Total Bytes 87
PR_03 P/R Direct Deposit Transaction File (PR_03DirectDepTransaction) Level: 4.40 Record Type: 2 Direct Deposit Transaction Detail Record 08/28/2009 File Type: Direct Key Size: 16 Rec Len: 112 Min Len: 80 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Batch Number. . . . . . . . . . . . . . BatchNumber . . . . . . . . . Uppercase *(1,4) Record Type "1" . . . . . . . . . . . . RecordType. . . . . . . . . . String *(5,1) Department Number . . . . . . . . . . . Dept. . . . . . . . . . . . . Zero-Filled *(6,2) Employee Number . . . . . . . . . . . . EmployeeNumberIf. . . . . . . String *(8,7) Sequence Number . . . . . . . . . . . . SeqNumberIf . . . . . . . . . Zero-Filled *(15,2) Employee Last Name. . . . . . . . . . . EmployeeLastName. . . . . . . String (17,15) Employee First Name . . . . . . . . . . EmployeeFirstName . . . . . . String (32,15) Bank Account. . . . . . . . . . . . . . BankAcct. . . . . . . . . . . String (47,17) Routing/Transit . . . . . . . . . . . . RoutingTransit. . . . . . . . String (64,9) Account Type. . . . . . . . . . . . . . AcctType. . . . . . . . . . . Uppercase (73,1) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (74,7) Amount. . . . . . . . . . . . . . . . . Amount. . . . . . . . . . . . Number [0] 8.2 Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [1] 0. Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [2] 0. Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [3] 0. Routing/Transit #3. . . . . . . . . . . RoutingTransit3 . . . . . . . String (1,9) Account Type#3. . . . . . . . . . . . . AccountType3. . . . . . . . . Uppercase (10,1) Bank Account #4 . . . . . . . . . . . . BankAccount4. . . . . . . . . String (11,17) Routing/Transit #4. . . . . . . . . . . RoutingTransit4 . . . . . . . String (28,9) Account Type#4. . . . . . . . . . . . . AccountType4. . . . . . . . . Uppercase (37,1) ________ Total Bytes 135
PR_03 P/R Direct Deposit Transaction File (PR_03DirectDepTransaction) Level: 4.40 Record Type: 3 Direct Deposit Transaction Pre-Note Rec 08/28/2009 File Type: Direct Key Size: 16 Rec Len: 112 Min Len: 80 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Batch Number. . . . . . . . . . . . . . BatchNumber . . . . . . . . . Uppercase *(1,4) Record Type "9" . . . . . . . . . . . . RecordType. . . . . . . . . . String *(5,1) Department Number . . . . . . . . . . . Dept. . . . . . . . . . . . . Zero-Filled *(6,2) Employee Number . . . . . . . . . . . . EmployeeNumberIf. . . . . . . String *(8,7) Sequence Number . . . . . . . . . . . . SeqNumberIf . . . . . . . . . Zero-Filled *(15,2) Employee Last Name. . . . . . . . . . . EmployeeLastName. . . . . . . String (17,15) Employee First Name . . . . . . . . . . EmployeeFirstName . . . . . . String (32,15) Bank Account Number . . . . . . . . . . BankAcct. . . . . . . . . . . String (47,17) Routing/Transit Number. . . . . . . . . RoutingTransit. . . . . . . . String (64,9) Account Type. . . . . . . . . . . . . . AcctType. . . . . . . . . . . Uppercase (73,1) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (74,7) Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [0] 0. Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [1] 0. Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [2] 0. Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [3] 0. ________ Total Bytes 86