PR_41 Federal W2 eFiling Summary (PR_41FederalW2EFilingSummary) Level: 4.40 Record Type: 1 Federal W2 eFiling Summary 08/28/2009 File Type: Mkeyed Key Size: 13 Rec Len: 165 Min Len: 46 Define: Y
Main Key (KNO=0)EmployeeDepartmant(1,2)+EmployeeNumber(3,7)+PayrollCalendarYear(10,4) 2nd Key (KNO=1) PayrollCalendarYear(10,4)+EmployeeDepartmant(1,2)+EmployeeNumber(3,7)
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Employee Departmant . . . . . . . . . . EmployeeDepartmant. . . . . . Zero-Filled *(1,2) Employee Number . . . . . . . . . . . . EmployeeNumber. . . . . . . . Account *(3,7) Payroll Calendar Year . . . . . . . . . PayrollCalendarYear . . . . . Zero-Filled *(10,4) End of Year Data. . . . . . . . . . . . EndOfYearData . . . . . . . . Yes/No (14,1) Data in this file may not be current, . . . . . . . . . . . . . . . Memo Unless the EndOfYearData flag is Y. . . . . . . . . . . . . . . . . Memo Deduction Code 1. . . . . . . . . . . . DeductionCode1. . . . . . . . Account (15,2) Deduction Code 2. . . . . . . . . . . . DeductionCode2. . . . . . . . Account (17,2) Deduction Code 3. . . . . . . . . . . . DeductionCode3. . . . . . . . Account (19,2) Deduction Code 4. . . . . . . . . . . . DeductionCode4. . . . . . . . Account (21,2) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (23,8) Box 12 Code 1 . . . . . . . . . . . . . Box12Code1. . . . . . . . . . String (31,2) Box 12 Code 2 . . . . . . . . . . . . . Box12Code2. . . . . . . . . . String (33,2) Box 12 Code 3 . . . . . . . . . . . . . Box12Code3. . . . . . . . . . String (35,2) Box 12 Code 4 . . . . . . . . . . . . . Box12Code4. . . . . . . . . . String (37,2) Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (39,8) Box 12 Amount 1 . . . . . . . . . . . . Box12Amount1. . . . . . . . . Number [0] 9.2 Box 12 Amount 2 . . . . . . . . . . . . Box12Amount2. . . . . . . . . Number [1] 9.2 Box 12 Amount 3 . . . . . . . . . . . . Box12Amount3. . . . . . . . . Number [2] 9.2 Box 12 Amount 4 . . . . . . . . . . . . Box12Amount4. . . . . . . . . Number [3] 9.2 Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [4] 0. Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [5] 0. Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [6] 0. Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [7] 0. Allocated Tips. . . . . . . . . . . . . AllocatedTips . . . . . . . . Number [8] 9.2 W2 Box 8. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo Dependent Care Benefits . . . . . . . . DependentCareBenefits . . . . Number [9] 9.2 W2 Box 10 - Amounts over $5000 . . . . . . . . . . . . . . . . . . Memo Also included in W2 Boxes 1,3, and 5. . . . . . . . . . . . . . . . Memo Non Qualified Plans 457(g). . . . . . . NonQualifiedPlans457. . . . . Number [10] 9.2 W2 Box 11 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo Fringe Benefits . . . . . . . . . . . . FringeBenefits. . . . . . . . Number [11] 9.2 Tracked here but already included . . . . . . . . . . . . . . . . . Memo in W2 Boxes 1,3, and 5. . . . . . . . . . . . . . . . . . . . . . . Memo ________ Total Bytes 164