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