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