PR_EarningsDeduction P/R Earnings/Deduction Master File Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: N/A SQL Def: Y SysDB: N "MAS_"+%C$+"/PR"+%C$+"/PR_EarningsDeduction.M4T"
KPRIMARY: RecordType+DeductionCode+EarningsCode
Fld Column Name M/L TUR Description/Notes Class
1 RecordType. . . . . . . . . . 1 SYY Record Type . . . . . . . . . . Valid:D,E Notes: E=Earnings, D=Deductions 2 DeductionCode . . . . . . . . 2 SYY Deduction Code. . . . . . . . . 3 EarningsCode. . . . . . . . . 2 SYY Earnings Code . . . . . . . . . 4 EarningsDeductionDesc . . . . 30 SNN Earnings Deduction Description.DESCRIPTION 5 ExpenseAcctKey. . . . . . . . 9 SYN Expense Account Key (E) . . . .ACCOUNT 6 TypeOfEarnings. . . . . . . . 1 SYN Type Of Earnings (E). . . . . . Valid:R,S,O,V,B,M,X,F 7 MethodOfEntry . . . . . . . . 1 SYN Method Of Entry (E) . . . . . . Valid:S,F,A 8 UsePayRate1Or2. . . . . . . . 1 SYN Use Pay Rate 1 or 2 (E) . . . . Valid:1,2 9 PostEarningsExpenseByDept . . 1 SYN Post Earnings Expense By DepartYESNO DfltVal:N Valid:Y,N 10 ECSubjectToFedWithholding . . 1 SYN Subject To Federal Withholding DfltVal:N Valid:Y,N,S 11 ECSubjectToEmployeeFica . . . 1 SYN Subject To Employee Fica Yes/NoYESNO DfltVal:N Valid:Y,N 12 ECSubjectToEmployerFica . . . 1 SYN Subject To Employer Fica Yes/NoYESNO DfltVal:N 13 ECSubjectToFedUnemployment. . 1 SYN Subject To Federal UnemploymentYESNO DfltVal:N Valid:Y,N 14 ECSubjectToStateWithholding . 1 SYN Subject To State Withholding Ye DfltVal:N Valid:Y,N,S 15 ECSubjectToStateSdi . . . . . 1 SYN Subject To State SDI Yes/No (E)YESNO DfltVal:N Valid:Y,N 16 ECSubjectToStateUnemployment. 1 SYN Subject To State Unemployment YYESNO DfltVal:N Valid:Y,N 17 ECSubjectToLocalWithholding . 1 SYN Subject To Local Withholding Ye DfltVal:N Valid:Y,N,S 18 ECSubjectToLocalLdi . . . . . 1 SYN Subject To Local LDI Yes/No (E)YESNO DfltVal:N Valid:Y,N 19 ECSubjectToLocalUnemployment. 1 SYN Subject To Local Unemployment YYESNO DfltVal:N Valid:Y,N 20 ECSubjectToEmployeeMedicare . 1 SYN Subject To Employee Medicare YeYESNO DfltVal:N Valid:Y,N 21 ECSubjectToEmployerMedicare . 1 SYN Subject To Employer Medicare YeYESNO DfltVal:N Valid:Y,N 22 ECBenefitTypesToAccrue. . . . 3 SYN Benefit Types To Accrue (Vacati 23 ECSubjectToOtherLocal . . . . 1 SYN Subject To Other Local Yes/No (YESNO DfltVal:N Valid:Y,N 24 ECSubjectToEmployeeSui. . . . 1 SYN Subject To Employee SUI Yes/No YESNO DfltVal:N Valid:Y,N 25 ECSubjToWorkersCompensation . 1 SYN Subject To Workers CompensationYESNO DfltVal:N Valid:Y,N 26 DeductionAcctKey. . . . . . . 9 SYN Deduction Account Key (D) . . .ACCOUNT 27 CalculationMethod . . . . . . 1 SYN Calculation Method (D). . . . . Valid:A,P,R,H,N,E 28 EqualToEarningsCode1. . . . . 2 SYN Equal To Earnings Code 1 (D). . 29 EqualToEarningsCode2. . . . . 2 SYN Equal To Earnings Code 2 (D). . 30 EqualToEarningsCode3. . . . . 2 SYN Equal To Earnings Code 3 (D). . 31 FrequencyOfDeduction. . . . . 1 SYN Frequency Of Deduction (D). . . Valid:1,2,3,4,5 32 AutoEarningsAsEarningsCode. . 2 SYN Make Automatic Earnings As Earn 33 DeductionType . . . . . . . . 1 SYN Deduction Type. . . . . . . . . Valid:S,P,C,E 34 AccrualAcctKeyForContribution 9 SYN Accrual Account Key For ContribACCOUNT 35 DCSubjectToFedWithholding . . 1 SYN Subject To Federal Withholding YESNO DfltVal:N Valid:Y,N 36 DCSubjectToEmployeeFica . . . 1 SYN Subject To Employee Fica Yes/NoYESNO DfltVal:N Valid:Y,N 37 DCSubjectToEmployerFica . . . 1 SYN Subject To Employer Fica Yes/NoYESNO DfltVal:N Valid:Y,N 38 DCSubjectToFederalUnemployment 1 SYN Subject To Federal UnemploymentYESNO DfltVal:N Valid:Y,N 39 DCSubjectToStateWithholding . 1 SYN Subject To State Withholding YeYESNO DfltVal:N Valid:Y,N 40 DCSubjectToStateSdi . . . . . 1 SYN Subject To State SDI Yes/No (D)YESNO DfltVal:N Valid:Y,N 41 DCSubjectToStateUnemployment. 1 SYN Subject To State Unemployment YYESNO DfltVal:N Valid:Y,N 42 DCSubjectToLocalWithholding . 1 SYN Subject To Local Withholding YeYESNO DfltVal:N Valid:Y,N 43 DCSubjectToLocalLdi . . . . . 1 SYN Subject To Local LDI Yes/No (D)YESNO DfltVal:N Valid:Y,N 44 DCSubjectToLocalUnemployment. 1 SYN Subject To Local Unemployment YYESNO DfltVal:N Valid:Y,N 45 DCSubjectToEmployeeMedicare . 1 SYN Subject To Employee Medicare YeYESNO DfltVal:N Valid:Y,N 46 DCSubjectToEmployerMedicare . 1 SYN Subject To Employer Medicare YeYESNO DfltVal:N Valid:Y,N 47 DCSubjectToOtherLocal . . . . 1 SYN Subject To Other Local Yes/No (YESNO DfltVal:N Valid:Y,N 48 DCSubjectToEmployeeSui. . . . 1 SYN Subject To Employee SUI Yes/No YESNO DfltVal:N Valid:Y,N 49 W2Label . . . . . . . . . . . 2 SNN W2 Label (box 12) (D) . . . . . 50 RetainResetAtEndOfYear. . . . 1 SYN Retain Reset At End Of Year YesYESNO DfltVal:N Valid:Y,N 51 StandardAmount. . . . . . . . 6.3 NNN Standard Amount (E) . . . . . . Mask:######.000 52 PayRateMultiplier . . . . . . 2.2 NNN Pay Rate Multiplier (E) . . . . Mask:##.00 53 DCStdAmountOrRate . . . . . . 6.3 NNN Standard Amount Or Rate (D) . . Mask:######.000 54 StandardLimit . . . . . . . . 10.2 NNN Standard Limit (D). . . . . . . Mask:########.00 55 DateCreated . . . . . . . . . 8 SNY Date Created. . . . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 56 TimeCreated . . . . . . . . . 8 SNY Time Created. . . . . . . . . . Read Only:Y 57 UserCreatedKey. . . . . . . . 10 SYY User Created Key. . . . . . . .USER Read Only:Y Mask:0000000000 58 DateUpdated . . . . . . . . . 8 SNN Date Updated. . . . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 59 TimeUpdated . . . . . . . . . 8 SNN Time Updated. . . . . . . . . . Read Only:Y 60 UserUpdatedKey. . . . . . . . 10 SNN User Updated Key. . . . . . . .USER Read Only:Y Mask:0000000000