     PR4    P/R Employee Earn/Ded Summary File (PR4_EmployeeEarningDeduction)        Level: 4.40
            Record Type: 1    P/R Employee Earnings Summary File                     08/28/2009

     File Type: Direct   Key Size: 12   Rec Len: 155     Min Len: 27     Define: Y

     Field Description                       Crystal/SQL/ALE/Column Name   Data Type   Pos/Len   Mask

     Department Number . . . . . . . . . . . Department. . . . . . . . . . Zero-Filled *(1,2)
     Employee Number . . . . . . . . . . . . EmployeeNumber. . . . . . . . Account     *(3,7)
     Record Type (E/D) E = Earnings. . . . . RecordType. . . . . . . . . . String      *(10,1)
     Earnings Code . . . . . . . . . . . . . EarningsDeductionCode . . . . String      *(11,2)
     Type Of Earnings (R/O/V/S/B/M/F/X). . . TypeOfEarnings. . . . . . . . String      (13,1)
       Regular, Overtime, Vacation pay . . . . . . . . . . . . . . . . . . Memo
       Sick pay, Benefit, Misc., Fringe. . . . . . . . . . . . . . . . . . Memo
       eXcluded from tip calculation . . . . . . . . . . . . . . . . . . . Memo
     Unused In Earnings Codes. . . . . . . . UnusedinEarningsCodes . . . . String      (14,1)
     Description . . . . . . . . . . . . . . EarningsCodeDescription . . . String      (15,13)
     Qtd Earnings Amount . . . . . . . . . . QtdEarningsAmount . . . . . . Number      [0]       9.2
     Qtd Earnings Hours. . . . . . . . . . . QtdEarningsHours. . . . . . . Number      [1]       6.2
     Ytd Earnings Amount . . . . . . . . . . YtdEarningsAmount . . . . . . Number      [2]       9.2
     Ytd Earnings Hours. . . . . . . . . . . YtdEarningsHours. . . . . . . Number      [3]       6.2
     Month 1 Earning Amount. . . . . . . . . Month1EarningAmount . . . . . Number      [4]       9.2
     Month 1 Earning Hours . . . . . . . . . Month1EarningHours. . . . . . Number      [5]       6.2
     Month 2 Earning Amount. . . . . . . . . Month2EarningAmount . . . . . Number      [6]       9.2
     Month 2 Earning Hours . . . . . . . . . Month2EarningHours. . . . . . Number      [7]       6.2
     Month 3 Earning Amount. . . . . . . . . Month3EarningAmount . . . . . Number      [8]       9.2
     Month 3 Earning Hours . . . . . . . . . Month3EarningHours. . . . . . Number      [9]       6.2
                                                                                       ________
                                                                          Total Bytes  154

     PR4    P/R Employee Earn/Ded Summary File (PR4_EmployeeEarningDeduction)        Level: 4.40
            Record Type: 2    P/R Employee Deduction Summary File                    08/28/2009

     File Type: Direct   Key Size: 12   Rec Len: 155     Min Len: 27     Define: Y

     Field Description                       Crystal/SQL/ALE/Column Name   Data Type   Pos/Len   Mask

     Department Number . . . . . . . . . . . Department. . . . . . . . . . Zero-Filled *(1,2)
     Employee Number . . . . . . . . . . . . EmployeeNumber. . . . . . . . String      *(3,7)
     Record Type (E/D) D = Deduction . . . . RecordType. . . . . . . . . . String      *(10,1)
     Deduction Code. . . . . . . . . . . . . EarningsDeductionCode . . . . String      *(11,2)
     Calculation Method (A/P/R/H/N/E). . . . CalculationMethod . . . . . . String      (13,1)
       fixed Amount, Prcnt of gross wages. . . . . . . . . . . . . . . . . Memo
       Reg hrs x amount, total Hrs x amount. . . . . . . . . . . . . . . . Memo
       prcnt of Net (gross - tax deds) . . . . . . . . . . . . . . . . . . Memo
       (E = ded amt matches selected earnings. . . . . . . . . . . . . . . Memo
       code amts; C&P ded codes excepted . . . . . . . . . . . . . . . . . Memo
       Not available for Auto Deductions). . . . . . . . . . . . . . . . . Memo
     Deduction Type (S/P/C/E). . . . . . . . DeductionType . . . . . . . . String      (14,1)
       Standard, qual. Pension plan (401k) . . . . . . . . . . . . . . . . Memo
       qual. Cafeteria plan, Emplyr contrib. . . . . . . . . . . . . . . . Memo
     Description . . . . . . . . . . . . . . DeductionCodeDescription. . . String      (15,13)
     Deduction An Auto Deduction? (Y/N). . . DeductionAnAutoDeduction. . . Yes/No      (28,1)
     Qtd Deduction Amount. . . . . . . . . . QtdDeductionAmount. . . . . . Number      [0]       9.2
     Ytd Deduction Amount. . . . . . . . . . YtdDeductionAmount. . . . . . Number      [1]       9.2
     Deduction Rate/Amount . . . . . . . . . DeductionRateAmount . . . . . Number      [2]       5.3
     Ytd Deduction Goal. . . . . . . . . . . YtdDeductionGoal. . . . . . . Number      [3]       9.2
     Balance . . . . . . . . . . . . . . . . Balance . . . . . . . . . . . Number      [4]       9.2
     Month 1 Deduction Amount. . . . . . . . Month1DeductionAmount . . . . Number      [5]       9.2
     Month 2 Deduction Amount. . . . . . . . Month2DeductionAmount . . . . Number      [6]       9.2
     Month 3 Deduction Amount. . . . . . . . Month3DeductionAmount . . . . Number      [7]       9.2
     Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [8]       0.
     Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [9]       0.
                                                                                       ________
                                                                          Total Bytes  141