PR_40  PR Federal/State eFiling and Reporting (PR_40FederalStateEFiling)        Level: 4.40
        Record Type: 1    Federal/State eFiling and Reporting                    08/28/2009
 
 File Type: Mkeyed   Key Size: 23   Rec Len: 615     Min Len: 23     Define: Y

 Main Key (KNO=0)EmployeeDepartment(1,2)+EmployeeNumber(3,7)+CheckDate(10,6)+StateCode(16,3)+LocalCode(19,
 2nd Key (KNO=1) CheckDate(10,6)+EmployeeDepartment(1,2)+EmployeeNumber(3,7)+StateCode(16,3)+LocalCode(19,

 Field Description                       Crystal/SQL/ALE/Column Name   Data Type   Pos/Len   Mask

 Employee Department . . . . . . . . . . EmployeeDepartment. . . . . . Zero-Filled *(1,2)
 Employee Number . . . . . . . . . . . . EmployeeNumber. . . . . . . . Account     *(3,7)
 Check Date. . . . . . . . . . . . . . . CheckDate . . . . . . . . . . Date        *(10,6)
 State Code  (Blanks for Federal). . . . StateCode . . . . . . . . . . String      *(16,3)
 Local Code (Blanks for Federal) . . . . LocalCode . . . . . . . . . . String      *(19,3)
 Sequence No . . . . . . . . . . . . . . SequenceNo. . . . . . . . . . Zero-Filled *(22,2)
 Employee Hours Worked . . . . . . . . . EmployeeHoursWorked . . . . . Number      [0]       7.2
 Employee Days Worked. . . . . . . . . . EmployeeDaysWorked. . . . . . Number      [1]       4.0
 Employee Weeks Worked . . . . . . . . . EmployeeWeeksWorked . . . . . Number      [2]       3.0
 Employee Gross Earnings . . . . . . . . EmployeeGrossEarnings . . . . Number      [3]       9.2
 Employee FSL Withholding Wages and Tips EmployeeFSLWithholdingWages . Number      [4]       9.2
 FICA SDI LDI Wages PreLimit . . . . . . FICASDILDIWagesPrelimit . . . Number      [5]       9.2
   FICA is wages only  (no tips) . . . . . . . . . . . . . . . . . . . Memo
 FICA SDI LDI Wages Post Limit . . . . . FICASDILDIWagesPostlimit. . . Number      [6]       9.2
   FICA is wages only (no tips). . . . . . . . . . . . . . . . . . . . Memo
 Employee Medicare Wages and Tips. . . . EmployeeMedicareWagesTips . . Number      [7]       9.2
 Employee SUI OL Wages and Tips Pre LimitEmployeeSUIOLWagesPrelimit. . Number      [8]       9.2
 Employee SUIOL Wages and Tips Post LimitEmployeeSUIOLWagesPostLimit . Number      [9]       9.2
 Employee FSL Withholding Tips . . . . . EmployeeFSLWithholdingTips. . Number      [10]      9.2
 Employee FICA/SUI/OL Tips Pre Limit . . EmployeeFICATipsPreLimit. . . Number      [11]      9.2
 Employee FICA/SUI/OL Tips Post Limit. . EmployeeFICATipsPostLimit . . Number      [12]      9.2
 Employee Other Deductions . . . . . . . EmployeeOtherDeductions . . . Number      [13]      9.2
 Employee Net Check Amount . . . . . . . EmployeeNetCheckAmt . . . . . Number      [14]      9.2
 Company FICA Wages Pre Limit. . . . . . CoFICAWagesPreLimit . . . . . Number      [15]      9.2
 Company FICA Wages Post Limit . . . . . CoFICAWagesPostLimit. . . . . Number      [16]      9.2
 Company Medicare Wages and Tips . . . . CoMedicareWagesTips . . . . . Number      [17]      9.2
 Co FUTA SUI OL Wages and Tips Pre Limit CoFUTASUIOLWagesTipsPreLimit. Number      [18]      9.2
 Co FUTA SUI OL Wages Tips Post Limit. . CoFUTSSUIOLWagesTipsPostLimit Number      [19]      9.2
 Co. FICA/Empl SDI Tips Pre Limit. . . . CoFICATipsPreLimit. . . . . . Number      [20]      9.2
 Co. FICA/Empl SDI Tips Post Limit . . . CoFICATipsPostLimit . . . . . Number      [21]      9.2
 Employee FSL Withholding Wages Tax. . . EmployeeFSLWithholdingWagesTx Number      [22]      9.2
   Including tips tax. . . . . . . . . . . . . . . . . . . . . . . . . Memo
 Employee FICA SDI LDI Wages Tax . . . . EmployeeFICASDILDIWagesTax. . Number      [23]      9.2
   FICA tax is for wages only. . . . . . . . . . . . . . . . . . . . . Memo
 Employee Medicare Wages and Tips Tax. . EmployeeMedicareWagesTipsTax. Number      [24]      9.2
 Employee SUI OL Wages and Tips Tax. . . EmployeeSUIOLWagesTipsTax . . Number      [25]      9.2
 Employee FICA Tips Tax. . . . . . . . . EmployeeFICATipsTax . . . . . Number      [26]      9.2
 Compnay FICA Wages Tax. . . . . . . . . CoFICAWagesTax. . . . . . . . Number      [27]      9.2
 Company Medicare Wages and Tips Tax . . CoMedicareWagesTipsTax. . . . Number      [28]      9.2
 Company FUTA SUI OL Wages and Tips Tax. CoFUTASUIOLWagesTipsTax . . . Number      [29]      9.2
 Company FICA Tips Tax . . . . . . . . . CoFICATipsTax . . . . . . . . Number      [30]      9.2
 Earned Income Credit  (EIC) . . . . . . EarnedIncomeCredit. . . . . . Number      [31]      9.2
 Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [32]      0.
 Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [33]      0.
 Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [34]      0.
 Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [35]      0.
 Open Number . . . . . . . . . . . . . . _N5 . . . . . . . . . . . . . Open Number [36]      0.
 Open Number . . . . . . . . . . . . . . _N6 . . . . . . . . . . . . . Open Number [37]      0.
 Open Number . . . . . . . . . . . . . . _N7 . . . . . . . . . . . . . Open Number [38]      0.
 Open Number . . . . . . . . . . . . . . _N8 . . . . . . . . . . . . . Open Number [39]      0.
 Open Number . . . . . . . . . . . . . . _N9 . . . . . . . . . . . . . Open Number [40]      0.
                                                                                   ________
                                                                      Total Bytes  465