PR_01 P/R Employee Direct Deposit Master File (PR_01EmployeeDirectDeposit) Level: 4.40 Record Type: 1 Employee Direct Deposit Record 08/28/2009 File Type: Direct Key Size: 9 Rec Len: 630 Min Len: 420 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Department Number . . . . . . . . . . . Dept. . . . . . . . . . . . . Zero-Filled *(1,2) Employee Number . . . . . . . . . . . . EmployeeNumber. . . . . . . . Account *(3,7) Bank Account#1. . . . . . . . . . . . . BankAccount1. . . . . . . . . String (10,17) Account Description#1 . . . . . . . . . AcctDescription1. . . . . . . String (27,15) Account Type#1. . . . . . . . . . . . . AcctType1 . . . . . . . . . . Uppercase (42,1) Routing/Transit Number#1. . . . . . . . RoutingTransitNumber1 . . . . String (43,9) Pre-Note Sent?#1 (Approved/Yes/No). . . PrenoteSent1. . . . . . . . . String (52,1) Pre-Note Date Sent/Approved#1 . . . . . PrenoteDSentApproved1 . . . . Date (53,6) Amount Dist Method#1 (N/G/F). . . . . . AmountDistMethod1 . . . . . . Uppercase (59,1) Bank Account#2. . . . . . . . . . . . . BankAccount2. . . . . . . . . String (60,17) Account Description#2 . . . . . . . . . AcctDescription2. . . . . . . String (77,15) Account Type#2. . . . . . . . . . . . . AcctType2 . . . . . . . . . . Uppercase (92,1) Routing/Transit Number#2. . . . . . . . RoutingTransitNumber2 . . . . String (93,9) Pre-Note Sent?#2. . . . . . . . . . . . PrenoteSent2. . . . . . . . . String (102,1) Pre-Note Date Sent/Approved#2 . . . . . PrenoteDSentApproved2 . . . . Date (103,6) Amount Dist Method#2 (N/G/F). . . . . . AmountDistMethod2 . . . . . . Uppercase (109,1) Bank Account#3. . . . . . . . . . . . . BankAccount3. . . . . . . . . String (110,17) Account Description#3 . . . . . . . . . AcctDescription3. . . . . . . String (127,15) Account Type#3. . . . . . . . . . . . . AcctType3 . . . . . . . . . . Uppercase (142,1) Routing/Transit Number#3. . . . . . . . RoutingTransitNumber3 . . . . String (143,9) Pre-Note Sent?#3. . . . . . . . . . . . PrenoteSent3. . . . . . . . . String (152,1) Pre-Note Date Sent/Approved#3 . . . . . PrenoteDSentApproved3 . . . . Date (153,6) Amount Dist Method#3 (N/G/F). . . . . . AmountDistMethod3 . . . . . . Uppercase (159,1) Bank Account#4. . . . . . . . . . . . . BankAccount4. . . . . . . . . String (160,17) Account Description#4 . . . . . . . . . AcctDescription4. . . . . . . String (177,15) Account Type#4. . . . . . . . . . . . . AcctType4 . . . . . . . . . . Uppercase (192,1) Routing/Transit Number#4. . . . . . . . RoutingTransitNumber4 . . . . String (193,9) Pre-Note Sent?#4. . . . . . . . . . . . PrenoteSent4. . . . . . . . . String (202,1) Pre-Note Date Sent/Approved#4 . . . . . PrenoteDSentApproved4 . . . . Date (203,6) Amount Dist Method#4 (N/G/F). . . . . . AmountDistMethod4 . . . . . . Uppercase (209,1) Bank Account Number#5 . . . . . . . . . BankAcctNumber5 . . . . . . . String (210,17) Account Description#5 . . . . . . . . . AcctDescription5. . . . . . . String (227,15) Account Type#5. . . . . . . . . . . . . AcctType5 . . . . . . . . . . Uppercase (242,1) Routing/Transit Number#5. . . . . . . . RoutingTransitNumber5 . . . . String (243,9) Pre-Note Sent?#5. . . . . . . . . . . . PrenoteSent5. . . . . . . . . String (252,1) Pre-Note Date Sent/Approved#5 . . . . . PrenoteDSentApproved5 . . . . Date (253,6) Amount Dist Method#5 (N/G/F). . . . . . AmountDistMethod5 . . . . . . Uppercase (259,1) Bank Account Number#6 . . . . . . . . . BankAcctNumber6 . . . . . . . String (260,17) Account Description#6 . . . . . . . . . AcctDescription6. . . . . . . String (277,15) Account Type#6. . . . . . . . . . . . . AcctType6 . . . . . . . . . . Uppercase (292,1) Routing/Transit Number#6. . . . . . . . RoutingTransitNumber6 . . . . String (293,9) Pre-Note Sent#6 . . . . . . . . . . . . PrenoteSent6. . . . . . . . . String (302,1) Pre-Note Date Sent/Approved#6 . . . . . PrenoteDSentApproved6 . . . . Date (303,6) Amount Dist Method#6 (N/G/F). . . . . . AmountDistMethod6 . . . . . . Uppercase (309,1) Bank Account Number#7 . . . . . . . . . BankAcctNumber7 . . . . . . . String (310,17) Account Description#7 . . . . . . . . . AcctDescription7. . . . . . . String (327,15) Account Type#7. . . . . . . . . . . . . AcctType7 . . . . . . . . . . Uppercase (342,1) Routing/Transit Number#7. . . . . . . . RoutingTransitNumber7 . . . . String (343,9) Pre-Note Sent?#7. . . . . . . . . . . . PrenoteSent7. . . . . . . . . String (352,1) Pre-Note Date Sent/Approved#7 . . . . . PrenoteDSentApproved7 . . . . Date (353,6) Amount Dist Method#7 (N/G/F). . . . . . AmountDistMethod7 . . . . . . Uppercase (359,1) Bank Account Number#8 . . . . . . . . . BankAcctNumber8 . . . . . . . String (360,17) Account Description#8 . . . . . . . . . AcctDescription8. . . . . . . String (377,15) Account Type#8. . . . . . . . . . . . . AcctType8 . . . . . . . . . . Uppercase (392,1) Routing/Transit Number#8. . . . . . . . RoutingTransitNumber8 . . . . String (393,9) Pre-Note Sent?#8. . . . . . . . . . . . PrenoteSent8. . . . . . . . . String (402,1) Pre-Note Date Sent/Approved#8 . . . . . PrenoteDSentApproved8 . . . . Date (403,6) Amount Dist Method#8 (N/G/F). . . . . . AmountDistMethod8 . . . . . . Uppercase (409,1) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (410,11) Dist Amount/Percent#1 . . . . . . . . . DistributionAmountPercent1. . Number [0] 8.2 Dist Amount/Percent#2 . . . . . . . . . DistributionAmountPercent2. . Number [1] 8.2 Dist Amount/Percent#3 . . . . . . . . . DistributionAmountPercent3. . Number [2] 8.2 Dist Amount/Percent#4 . . . . . . . . . DistributionAmountPercent4. . Number [3] 8.2 Dist Amount/Percent#5 . . . . . . . . . DistributionAmountPercent5. . Number [4] 8.2 Dist Amount/Percent#6 . . . . . . . . . DistributionAmountPercent6. . Number [5] 8.2 Dist Amount/Percent#7 . . . . . . . . . DistributionAmountPercent7. . Number [6] 8.2 Dist Amount/Percent#8 . . . . . . . . . DistributionAmountPercent8. . Number [7] 8.2 Deposited Ytd #1. . . . . . . . . . . . DepositedYtd1 . . . . . . . . Number [8] 8.2 Deposited Ytd #2. . . . . . . . . . . . DepositedYtd2 . . . . . . . . Number [9] 8.2 Deposited Ytd #3. . . . . . . . . . . . DepositedYtd3 . . . . . . . . Number [10] 8.2 Deposited Ytd #4. . . . . . . . . . . . DepositedYtd4 . . . . . . . . Number [11] 8.2 Deposited Ytd #5. . . . . . . . . . . . DepositedYtd5 . . . . . . . . Number [12] 8.2 Deposited Ytd #6. . . . . . . . . . . . DepositedYtd6 . . . . . . . . Number [13] 8.2 Deposited Ytd #7. . . . . . . . . . . . DepositedYtd7 . . . . . . . . Number [14] 8.2 Deposited Ytd #8. . . . . . . . . . . . DepositedYtd8 . . . . . . . . Number [15] 8.2 ________ Total Bytes 630