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