TL_EARNINGS_VW

(SQL View)
 Index Back

T&L Earnings Codes View

The Earnings Table is the basis for how earnings are calculated and taxed.

SELECT ERNCD ,EFFDT ,EFF_STATUS ,DESCR ,DESCRSHORT ,ERN_SEQUENCE ,MAINTAIN_BALANCES ,BUDGET_EFFECT ,ALLOW_EMPLTYPE ,PAYMENT_TYPE ,HRLY_RT_MAXIMUM ,PERUNIT_OVR_RT ,EARN_FLAT_AMT ,ADD_GROSS ,SUBJECT_FWT ,SUBJECT_FICA ,SUBJECT_FUT ,SUBJECT_CIT ,SUBJECT_CUI ,SUBJECT_CUI_HOURS ,SUBJECT_CPP ,SUBJECT_QIT ,SUBJECT_QPP ,SUBJECT_TRUE_T4GRS ,SUBJECT_TRUE_RVGRS ,SUBJECT_PAY_TAX ,SUBJECT_REG ,WITHHOLD_FWT ,HRS_ONLY ,SHIFT_DIFF_ELIG ,TAX_GRS_COMPNT ,SPEC_CALC_RTN ,FACTOR_MULT ,FACTOR_RATE_ADJ ,FACTOR_HRS_ADJ ,FACTOR_ERN_ADJ ,GL_EXPENSE ,SUBTRACT_EARNS ,DEDCD_PAYBACK ,TAX_METHOD ,EARN_YTD_MAX ,BASED_ON_TYPE ,BASED_ON_ERNCD ,BASED_ON_ACC_ERNCD ,AMT_OR_HOURS ,ELIG_FOR_RETROPAY ,USED_TO_PAY_RETRO ,EFFECT_ON_FLSA ,FLSA_CATEGORY ,REG_PAY_INCLUDED FROM PS_EARNINGS_TBL

  • Related Language Record: EARNINGS_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 ERN_SEQUENCE Number(3,0) SMALLINT NOT NULL Earnings Calculation Sequence

    Default Value: 500

    7 MAINTAIN_BALANCES Character(1) VARCHAR2(1) NOT NULL Maintain Earnings Balances

    Y/N Table Edit

    Default Value: Y

    8 BUDGET_EFFECT Character(1) VARCHAR2(1) NOT NULL Budget Effect
    N=Nonproductive
    O=Overtime
    R=Regular
    X=No Effect

    Default Value: R

    9 ALLOW_EMPLTYPE Character(1) VARCHAR2(1) NOT NULL Allowable Employee Types
    A=All Types Allowable
    H=Hourly and Exception Hourly
    S=Salaried

    Default Value: A

    10 PAYMENT_TYPE Character(1) VARCHAR2(1) NOT NULL Payment Type
    A=Amounts Only
    B=Both Hours and Amount OK
    E=Either Hours or Amount OK
    F=Flat Amount
    H=Hours Only
    S=Defined by Salary System
    U=Unit/Override Rate

    Default Value: E

    11 HRLY_RT_MAXIMUM Number(19,6) DECIMAL(18,6) NOT NULL Maximum Hourly Rate
    12 PERUNIT_OVR_RT Number(19,6) DECIMAL(18,6) NOT NULL Unit/Override Rate
    13 EARN_FLAT_AMT Number(11,2) DECIMAL(10,2) NOT NULL Flat Amount
    14 ADD_GROSS Character(1) VARCHAR2(1) NOT NULL Add to Gross Pay
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: Y

    15 SUBJECT_FWT Character(1) VARCHAR2(1) NOT NULL Subject to FWT.

    Y/N Table Edit

    Default Value: Y

    16 SUBJECT_FICA Character(1) VARCHAR2(1) NOT NULL Subject to FICA.

    Y/N Table Edit

    Default Value: Y

    17 SUBJECT_FUT Character(1) VARCHAR2(1) NOT NULL Subject to FUT

    Y/N Table Edit

    Default Value: Y

    18 SUBJECT_CIT Character(1) VARCHAR2(1) NOT NULL Subject to CIT indicator.

    Y/N Table Edit

    Default Value: Y

    19 SUBJECT_CUI Character(1) VARCHAR2(1) NOT NULL Subject to EI earnings indicator.

    Y/N Table Edit

    Default Value: Y

    20 SUBJECT_CUI_HOURS Character(1) VARCHAR2(1) NOT NULL Subject to EI hours indicator.

    Y/N Table Edit

    Default Value: Y

    21 SUBJECT_CPP Character(1) VARCHAR2(1) NOT NULL Subject to CPP indicator.

    Y/N Table Edit

    Default Value: Y

    22 SUBJECT_QIT Character(1) VARCHAR2(1) NOT NULL Subject to QIT indicator.

    Y/N Table Edit

    Default Value: Y

    23 SUBJECT_QPP Character(1) VARCHAR2(1) NOT NULL Subject to QPP indicator.

    Y/N Table Edit

    Default Value: Y

    24 SUBJECT_TRUE_T4GRS Character(1) VARCHAR2(1) NOT NULL Subject to true T4 indicator.

    Y/N Table Edit

    Default Value: Y

    25 SUBJECT_TRUE_RVGRS Character(1) VARCHAR2(1) NOT NULL Subject to true RL indicator.

    Y/N Table Edit

    Default Value: Y

    26 SUBJECT_PAY_TAX Character(1) VARCHAR2(1) NOT NULL Subject to Payroll Tax

    Y/N Table Edit

    Default Value: Y

    27 SUBJECT_REG Character(1) VARCHAR2(1) NOT NULL Subject to Regular Rate

    Y/N Table Edit

    Default Value: Y

    28 WITHHOLD_FWT Character(1) VARCHAR2(1) NOT NULL Withhold FWT

    Y/N Table Edit

    Default Value: Y

    29 HRS_ONLY Character(1) VARCHAR2(1) NOT NULL Hours Only

    Y/N Table Edit

    Default Value: N

    30 SHIFT_DIFF_ELIG Character(1) VARCHAR2(1) NOT NULL Elig. for Shift Differential

    Y/N Table Edit

    Default Value: Y

    31 TAX_GRS_COMPNT Character(5) VARCHAR2(5) NOT NULL Taxable gross component ID.

    Prompt Table: TAXGR_CMPNT_VW

    32 SPEC_CALC_RTN Character(1) VARCHAR2(1) NOT NULL Special Calculation Routine

    Y/N Table Edit

    33 FACTOR_MULT Signed Number(11,4) DECIMAL(9,4) NOT NULL Multiplication Factor
    34 FACTOR_RATE_ADJ Signed Number(11,4) DECIMAL(9,4) NOT NULL Rate Adjustment Factor
    35 FACTOR_HRS_ADJ Signed Number(11,4) DECIMAL(9,4) NOT NULL Hours Adjustment Factor
    36 FACTOR_ERN_ADJ Signed Number(11,4) DECIMAL(9,4) NOT NULL Earnings Adjustment Factor
    37 GL_EXPENSE Character(35) VARCHAR2(35) NOT NULL GL Account #-Expense
    38 SUBTRACT_EARNS Character(1) VARCHAR2(1) NOT NULL Subtract from this Draw

    Y/N Table Edit

    Default Value: N

    39 DEDCD_PAYBACK Character(6) VARCHAR2(6) NOT NULL Payback Deduction Code

    Prompt Table: DED_TBL_GENL_VW

    40 TAX_METHOD Character(1) VARCHAR2(1) NOT NULL Tax method.
    A=Annualized
    B=Bonus
    C=Cumulative
    G=Aggregate
    L=Lump Sum
    M=Commission
    P=Specified on Paysheet
    S=Supplemental
    X=Special Supplemental

    Default Value: P

    41 EARN_YTD_MAX Number(11,2) DECIMAL(10,2) NOT NULL Maximum Yearly Earnings
    42 BASED_ON_TYPE Character(1) VARCHAR2(1) NOT NULL Based on Type
    A=Special Accumulator
    N=Not Based On Another Earnings
    S=Single Earnings

    Default Value: N

    43 BASED_ON_ERNCD Character(3) VARCHAR2(3) NOT NULL Based On Single Earnings Code

    Prompt Table: EARNINGS_TBL

    44 BASED_ON_ACC_ERNCD Character(3) VARCHAR2(3) NOT NULL Special Accumulator Code

    Prompt Table: SPCL_EARNS_TBL

    45 AMT_OR_HOURS Character(1) VARCHAR2(1) NOT NULL Based On Amount or Hours
    E=Amount
    H=Hours
    N=None

    Default Value: N

    46 ELIG_FOR_RETROPAY Character(1) VARCHAR2(1) NOT NULL Eligible for Retro Pay

    Y/N Table Edit

    Default Value: N

    47 USED_TO_PAY_RETRO Character(1) VARCHAR2(1) NOT NULL Used to Pay Retro

    Y/N Table Edit

    Default Value: N

    48 EFFECT_ON_FLSA Character(1) VARCHAR2(1) NOT NULL Effect on FLSA
    A=Amounts Only
    B=Both Hours and Amount
    H=Hours Only
    N=None

    Default Value: N

    49 FLSA_CATEGORY Character(1) VARCHAR2(1) NOT NULL FLSA Category
    O=Overtime
    R=Regular
    X=Excluded

    Default Value: X

    50 REG_PAY_INCLUDED Character(1) VARCHAR2(1) NOT NULL Regular Pay Included?

    Y/N Table Edit

    Default Value: N