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