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