PRD P/R Earnings/Deduction Master File (PRD_EarningsDeductionMaster) Level: 4.40
Record Type: 1 Earnings Record 08/28/2009
File Type: Direct Key Size: 3 Rec Len: 100 Min Len: 72 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Record Type (E/D) E = Earnings. . . . . RecordType. . . . . . . . . . String *(1,1)
Earnings Deduction Code . . . . . . . . EarningsDeductionCode . . . . Account *(2,2)
Description . . . . . . . . . . . . . . Description . . . . . . . . . String (4,13)
Expense G/L Account . . . . . . . . . . ExpenseGLAcct . . . . . . . . G/L Account (17,9)
Type Of Earnings (ABEFGMORSTVX) . . . . TypeOfEarnings. . . . . . . . String (26,1)
Alloc. Tips, Benefit, Exempt from tips. . . . . . . . . . . . . . . Memo
Fringe, Group life, Misc., Overtime,. . . . . . . . . . . . . . . . Memo
Regular, Sick Taxable tips. . . . . . . . . . . . . . . . . . . . . Memo
Vacation, eXclude from tips . . . . . . . . . . . . . . . . . . . . Memo
Method Of Entry (S/F/A) . . . . . . . . MethodOfEntry . . . . . . . . String (27,1)
S=Std, F=Fixed, A=Addit'L Amt . . . . . . . . . . . . . . . . . . . Memo
Use Pay Rate 1 Or 2:. . . . . . . . . . UsePayRate1Or2. . . . . . . . String (28,1)
Post Earnings Expense By Dept (Y/N) . . PostEarningsExpenseByDept . . Yes/No (29,1)
Subject To Fed Withholding (Y/N/S). . . ECSubjectToFedWithholding . . Uppercase (30,1)
S=Supplemental. . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
Subject To Employee Fica (Y/N). . . . . ECSubjectToEmployeeFica . . . Yes/No (31,1)
Subject To Employer Fica (Y/N). . . . . ECSubjectToEmployerFica . . . Yes/No (32,1)
Subject To Fed Unemployment (Y/N) . . . ECSubjectToFedUnemployment. . Yes/No (33,1)
Subject To State Withholding (Y/N/S). . ECSubjectToStateWithholding . Uppercase (34,1)
S=Suplemental . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
Subject To State Sdi (Y/N). . . . . . . ECSubjectToStateSdi . . . . . Yes/No (35,1)
Subject To State Unemployment (Y/N) . . ECSubjectToStateUnemployment. Yes/No (36,1)
Subject To Local Withholding (Y/N/S). . ECSubjectToLocalWithholding . Uppercase (37,1)
S=Supplemental. . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
Subject To Local Ldi (Y/N). . . . . . . ECSubjectToLocalLdi . . . . . Yes/No (38,1)
Subject To Local Unemployment (Y/N) . . ECSubjectToLocalUnemployment. Yes/No (39,1)
Subject To Employee Medicare (Y/N). . . ECSubjectToEmployeeMedicare . Yes/No (40,1)
Subject To Employer Medicare (Y/N). . . ECSubjectToEmployerMedicare . Yes/No (41,1)
Benefit Types To Accrue (V/S/B) . . . . ECBenefitTypesToAccrue. . . . Uppercase (42,3)
Vacation, Sick, Benefit . . . . . . . . . . . . . . . . . . . . . . Memo
(Any Combination Of These Three). . . . . . . . . . . . . . . . . . Memo
Subject To Other Local. . . . . . . . . ECSubjectToOtherLocal . . . . Yes/No (45,1)
Subject To Employee Sui . . . . . . . . ECSubjectToEmployeeSui. . . . Yes/No (46,1)
Subj To Workers Compensation (Y/N). . . ECSubjToWorkersCompensation . Yes/No (47,1)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (48,25)
Standard Amount . . . . . . . . . . . . StdAmount . . . . . . . . . . Number [0] 6.3
Pay Rate Multiplier . . . . . . . . . . PayRateMultiplier . . . . . . Number [1] 2.2
________
Total Bytes 93
PRD P/R Earnings/Deduction Master File (PRD_EarningsDeductionMaster) Level: 4.40
Record Type: 2 Deduction Record 08/28/2009
File Type: Direct Key Size: 3 Rec Len: 100 Min Len: 72 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Record Type (E/D) D = Deduction . . . . RecordType. . . . . . . . . . String *(1,1)
Earnings Deduction Code . . . . . . . . EarningsDeductionCode . . . . Account *(2,2)
Description . . . . . . . . . . . . . . Description . . . . . . . . . String (4,13)
Deduction G/L Account . . . . . . . . . DeductionGLAcct . . . . . . . G/L Account (17,9)
Calculation Method (A/P/R/H/N/E). . . . CalculationMethod . . . . . . String (26,1)
Equal To Earnings Code (1). . . . . . . EqualToEarningsCode1. . . . . String (27,2)
Equal To Earnings Code (2). . . . . . . EqualToEarningsCode2. . . . . String (29,2)
Equal To Earnings Code (3). . . . . . . EqualToEarningsCode3. . . . . String (31,2)
Frequency Of Deduction (12345). . . . . FrequencyOfDeduction. . . . . String (33,5)
Make Auto Earnings As Earnings Code . . AutoEarningsAsEarningsCode. . String (38,2)
Deduction Type (S/P/C/E). . . . . . . . DeductionType . . . . . . . . String (40,1)
Accrual G/L Account For Contribution. . AccrualGLAcctForContribution. G/L Account (41,9)
Subject To Fed Withholding (Y/N). . . . DCSubjectToFedWithholding . . Yes/No (50,1)
Subject To Employee Fica (Y/N). . . . . DCSubjectToEmployeeFica . . . Yes/No (51,1)
Subject To Employer Fica (Y/N). . . . . DCSubjectToEmployerFica . . . Yes/No (52,1)
Subject To Federal Employment (Y/N) . . DCSubjectToFederalEmployment. Yes/No (53,1)
Subject To State Withholding (Y/N). . . DCSubjectToStateWithholding . Yes/No (54,1)
Subject To State Di (Y/N) . . . . . . . DCSubjectToStateSdi . . . . . Yes/No (55,1)
Subject To State Unemployment (Y/N) . . DCSubjectToStateUnemployment. Yes/No (56,1)
Subject To Local Withholding (Y/N). . . DCSubjectToLocalWithholding . Yes/No (57,1)
Subject To Local Ldi (Y/N). . . . . . . DCSubjectToLocalLdi . . . . . Yes/No (58,1)
Subject To Local Unemployment (Y/N) . . DCSubjectToLocalUnemployment. Yes/No (59,1)
Subject To Employee Medicare (Y/N). . . DCSubjectToEmployeeMedicare . Yes/No (60,1)
Subject To Employer Medicare (Y/N). . . DCSubjectToEmployerMedicare . Yes/No (61,1)
Subject To Other Local (Y/N). . . . . . DCSubjectToOtherLocal . . . . Yes/No (62,1)
Subject To Employee Sui (Y/N) . . . . . DCSubjectToEmployeeSui. . . . Yes/No (63,1)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (64,1)
Retain Reset at End of Year . . . . . . Retain_ResetAtEndOfYear . . . Yes/No (65,1)
W2 Label (Box 12) . . . . . . . . . . . W2Label . . . . . . . . . . . String (66,2)
Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (68,5)
Standard Amount/Rate. . . . . . . . . . DCStdAmountOrRate . . . . . . Number [0] 6.3
Standard Limit. . . . . . . . . . . . . StdLimit. . . . . . . . . . . Number [1] 10.2
________
Total Bytes 101
PRD P/R Earnings/Deduction Master File (PRD_EarningsDeductionMaster) Level: 4.40
Record Type: 3 Earnings Types With Deduction "E" Codes 08/28/2009
File Type: Direct Key Size: 3 Rec Len: 100 Min Len: 72 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
D Field . . . . . . . . . . . . . . . . DField. . . . . . . . . . . . String *(1,1)
Earnings Deduction Code . . . . . . . . EarningsDeductionCode . . . . String *(2,2)
Earnings Code 1 . . . . . . . . . . . . DFieldEarningsCode1 . . . . . Uppercase (4,2)
Earnings Code 2 . . . . . . . . . . . . DFieldEarningsCode2 . . . . . Uppercase (6,2)
Earnings Code 3 . . . . . . . . . . . . DFieldEarningsCode3 . . . . . Uppercase (8,2)
Earnings Code 4 . . . . . . . . . . . . DFieldEarningsCode4 . . . . . Uppercase (10,2)
Earnings Code 5 . . . . . . . . . . . . DFieldEarningsCode5 . . . . . Uppercase (12,2)
Earnings Code 6 . . . . . . . . . . . . DFieldEarningsCode6 . . . . . Uppercase (14,2)
Earnings Code 7 . . . . . . . . . . . . DFieldEarningsCode7 . . . . . Uppercase (16,2)
Earnings Code 8 . . . . . . . . . . . . DFieldEarningsCode8 . . . . . Uppercase (18,2)
Earnings Code 9 . . . . . . . . . . . . DFieldEarningsCode9 . . . . . Uppercase (20,2)
Earnings Code 10. . . . . . . . . . . . DFieldEarningsCode10. . . . . Uppercase (22,2)
Earnings Code 11. . . . . . . . . . . . DFieldEarningsCode11. . . . . Uppercase (24,2)
Earnings Code 12. . . . . . . . . . . . DFieldEarningsCode12. . . . . Uppercase (26,2)
Earnings Code 13. . . . . . . . . . . . DFieldEarningsCode13. . . . . Uppercase (28,2)
Earnings Code 14. . . . . . . . . . . . DFieldEarningsCode14. . . . . Uppercase (30,2)
Earnings Code 15. . . . . . . . . . . . DFieldEarningsCode15. . . . . Uppercase (32,2)
Earnings Code 16. . . . . . . . . . . . DFieldEarningsCode16. . . . . Uppercase (34,2)
Earnings Code 17. . . . . . . . . . . . DFieldEarningsCode17. . . . . Uppercase (36,2)
Earnings Code 18. . . . . . . . . . . . DFieldEarningsCode18. . . . . Uppercase (38,2)
Earnings Code 19. . . . . . . . . . . . DFieldEarningsCode19. . . . . Uppercase (40,2)
Earnings Code 20. . . . . . . . . . . . DFieldEarningsCode20. . . . . Uppercase (42,2)
Rem The Record'S Length Varies. . . . . . . . . . . . . . . . . . . Memo
Depending On Codes Used, But. . . . . . . . . . . . . . . . . . . . Memo
Will Not Exceed 43. Maintained . . . . . . . . . . . . . . . . . . Memo
In Deduction Code Maint.. . . . . . . . . . . . . . . . . . . . . . Memo
________
Total Bytes 45