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