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