PRC P/R Department Master File (PRC_DepartmentMaster) Level: 4.40 Record Type: 1 P/R Department Master File 08/28/2009 File Type: Direct Key Size: 2 Rec Len: 264 Min Len: 262 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Department Number . . . . . . . . . . . DepartmentNumber. . . . . . . String *(1,2) Description . . . . . . . . . . . . . . Description . . . . . . . . . String (3,30) Payroll Expense . . . . . . . . . . . . PayrollExpenseGLAcct. . . . . G/L Account (33,9) Employer Fica . . . . . . . . . . . . . EmployerFicaGLAcct. . . . . . G/L Account (42,9) Federal Unemployment Insurance. . . . . FedUnempInsuranceGLAcct . . . G/L Account (51,9) Worker'S Compensation . . . . . . . . . WorkerCompensationGLAcct. . . G/L Account (60,9) Earnings 01 Account . . . . . . . . . . Earnings01GLAcct. . . . . . . G/L Account (69,9) Earnings 02 Account . . . . . . . . . . Earnings02GLAcct. . . . . . . G/L Account (78,9) Earnings 03 Account . . . . . . . . . . Earnings03GLAcct. . . . . . . G/L Account (87,9) Earnings 04 Account . . . . . . . . . . Earnings04GLAcct. . . . . . . G/L Account (96,9) Earnings 05 Account . . . . . . . . . . Earnings05GLAcct. . . . . . . G/L Account (105,9) Earnings 06 Account . . . . . . . . . . Earnings06GLAcct. . . . . . . G/L Account (114,9) Earnings 07 Account . . . . . . . . . . Earnings07GLAcct. . . . . . . G/L Account (123,9) Earnings 08 Account . . . . . . . . . . Earnings08GLAcct. . . . . . . G/L Account (132,9) Earnings 09 Account . . . . . . . . . . Earnings09GLAcct. . . . . . . G/L Account (141,9) Earnings 10 Account . . . . . . . . . . Earnings10GLAcct. . . . . . . G/L Account (150,9) Earnings Code 01. . . . . . . . . . . . EarningsCode01. . . . . . . . String (159,2) Earnings Code 02. . . . . . . . . . . . EarningsCode02. . . . . . . . String (161,2) Earnings Code 03. . . . . . . . . . . . EarningsCode03. . . . . . . . String (163,2) Earnings Code 04. . . . . . . . . . . . EarningsCode04. . . . . . . . String (165,2) Earnings Code 05. . . . . . . . . . . . EarningsCode05. . . . . . . . String (167,2) Earnings Code 06. . . . . . . . . . . . EarningsCode06. . . . . . . . String (169,2) Earnings Code 07. . . . . . . . . . . . EarningsCode07. . . . . . . . String (171,2) Earnings Code 08. . . . . . . . . . . . EarningsCode08. . . . . . . . String (173,2) Earnings Code 09. . . . . . . . . . . . EarningsCode09. . . . . . . . String (175,2) Earnings Code 10. . . . . . . . . . . . EarningsCode10. . . . . . . . String (177,2) State Unemployment Insurance. . . . . . StateUnemploymentInsurance. . G/L Account (179,9) Employer Medicare . . . . . . . . . . . EmployerMedicare. . . . . . . G/L Account (188,9) Accrue Wage Expense?. . . . . . . . . . AccrueWageExpense . . . . . . Yes/No (197,1) Accrue Tax Expense? . . . . . . . . . . AccrueTaxExpense. . . . . . . Yes/No (198,1) Accrue Tax Accruals?. . . . . . . . . . AccrueTaxAccruals . . . . . . Yes/No (199,1) Accrual Account . . . . . . . . . . . . AccrualGLAcct . . . . . . . . G/L Account (200,9) Vacation Liability Account. . . . . . . VacLiabilityAcct. . . . . . . G/L Account (209,9) Vacation Expense Account. . . . . . . . VacExpenseAcct. . . . . . . . G/L Account (218,9) Sick Liability Account. . . . . . . . . SickLiabilityAcct . . . . . . G/L Account (227,9) Sick Expense Account. . . . . . . . . . SickExpenseAcct . . . . . . . G/L Account (236,9) Other Liability Account . . . . . . . . OtherLiabilityAcct. . . . . . G/L Account (245,9) Other Expense Account . . . . . . . . . OtherExpenseAcct. . . . . . . G/L Account (254,9) ________ Total Bytes 264