PR8 P/R Payroll Data Entry Tax Summary File (PR8_PayrollDataEntryTax) Level: 4.40
Record Type: 1 P/R Payroll Data Entry Tax Summary File 08/28/2009
File Type: Direct Key Size: 16 Rec Len: 440 Min Len: 16 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)
Check Entry Number. . . . . . . . . . . CheckEntryNumber. . . . . . . String *(10,1)
State Code (Spaces For Federal) . . . . StateCodeFederalBlank . . . . String *(11,3)
Local Code (Spaces For Federal) . . . . LocalCodeFederalBlank . . . . String *(14,3)
Gross Wages . . . . . . . . . . . . . . GrossWages. . . . . . . . . . Number [0] 9.2
Wages Subject To Regular W/H. . . . . . WagesSubjectToRegularWH . . . Number [1] 9.2
Wages Subject To Supplemental W/H . . . WagesSubjectToSupplementalWH. Number [2] 9.2
Wages Subject To Employee FICA. . . . . WagesSubjEmplFICASDILDI . . . Number [3] 9.2
State=SDI, Local=LDI. . . . . . . . . . . . . . . . . . . . . . . . Memo
Wages Subject To Employer FICA. . . . . SubjEmprFICAEMPSUIOthrLOC . . Number [4] 9.2
State=Employer SUI, Local=Other Local . . . . . . . . . . . . . . . Memo
Wages Subject To Unemployment . . . . . WagesSubjectToUnemployment. . Number [5] 9.2
Fed=FUTA, State=Employee SUI. . . . . . . . . . . . . . . . . . . . Memo
Taxable Tips Reported . . . . . . . . . TaxableTipsReported . . . . . Number [6] 9.2
Tips Deemed To Be Wages . . . . . . . . TipsDeemedToBeWages . . . . . Number [7] 9.2
Earned Income Credit. . . . . . . . . . EarnedIncomeCredit. . . . . . Number [8] 9.2
Withholding Tax . . . . . . . . . . . . WithholdingTax. . . . . . . . Number [9] 9.2
Employee FICA/SDI/LDI Tax . . . . . . . EmployeeFicaSdiLdi. . . . . . Number [10] 9.2
Employer FICA/SUI/Other Local Tax . . . EmplrFICAEmplSUIOthrLOC . . . Number [11] 9.2
Unemployment Tax. . . . . . . . . . . . UnemploymentTax . . . . . . . Number [12] 9.2
Fed=FUTA, State/Local=Employee SUI/OL . . . . . . . . . . . . . . . Memo
No. Days Worked . . . . . . . . . . . . NumberDaysWorked. . . . . . . Number [13] 4.2
No. Weeks Worked. . . . . . . . . . . . NumberWeeksWorked . . . . . . Number [14] 4.2
Hours Used In Tips Calculation. . . . . HoursUsedInTipsCalc . . . . . Number [15] 5.2
Non-Tip Earning Amts Used In Tip Calc.. NontipEarningAmtUsedInTipCalc Number [16] 9.2
Total Reg & O/T Hours Worked. . . . . . TotRegAndOTHrsWorked. . . . . Number [17] 6.2
Pension/Cafeteria Deduction Amount. . . PCDeductionAmount . . . . . . Number [18] 9.2
Employee Medicare Tax . . . . . . . . . EmployeeMedicare. . . . . . . Number [19] 6.2
Employer Medicare Tax . . . . . . . . . EmployerMedicare. . . . . . . Number [20] 6.2
Wages Subject To Employee Medicare. . . WagesSubjToEmployeeMedicare . Number [21] 9.2
Wages Subject To Employer Medicare. . . WagesSubjToEmployerMedicare . Number [22] 9.2
Tips Subject to Employee FICA . . . . . TipsSubjToEmployeeFica. . . . Number [23] 9.2
Tips Subject to Employer FICA . . . . . TipsSubjectToEmployerFica . . Number [24] 9.2
Employee FICA Tip Tax . . . . . . . . . EmployeeFicaTipTax. . . . . . Number [25] 9.2
Employer FICA Tip Tax . . . . . . . . . EmployerFicaTipTax. . . . . . Number [26] 9.2
Employee PC Deduction Not Applied . . . EmployeePCDeductionNotApplied Number [27] 9.2
Employer PC Deduction Not Applied . . . EmployerPCDeductionNotApplied Number [28] 9.2
Employee PC Deduction from Wages. . . . EmployeePCDeductionFromWages. Number [29] 9.2
Employer PC Deduction from Wages. . . . EmployerPCDeductionFromWages. Number [30] 9.2
________
Total Bytes 429
PR8 P/R Payroll Data Entry Tax Summary File (PR8_PayrollDataEntryTax) Level: 4.40
Record Type: 2 Posting Restart Record 08/28/2009
File Type: Direct Key Size: 16 Rec Len: 440 Min Len: 16 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
r1s1. . . . . . . . . . . . . . . . . . r1s1. . . . . . . . . . . . . String *(1,16)
r1n1. . . . . . . . . . . . . . . . . . r1n1. . . . . . . . . . . . . Number [0] 8.3
r1n2. . . . . . . . . . . . . . . . . . r1n2. . . . . . . . . . . . . Number [1] 8.3
r1n3. . . . . . . . . . . . . . . . . . r1n3. . . . . . . . . . . . . Number [2] 8.3
________
Total Bytes 60