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