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