MODEL_OTH_ERNVW

(SQL View)
 Index Back

Payroll Other Earnings

This record contains earnings type information for other than regular or overtime earnings.

SELECT A.PY_MOD_OPRID , A.PY_MOD_EMPLID , A.COMPANY , A.PAYGROUP , A.PAY_END_DT , A.OFF_CYCLE , A.PAGE_NUM , A.LINE_NUM , A.ADDL_NBR , A.ERNCD , A.RATE_USED , A.SEPCHK , A.JOB_PAY , A.OTH_HRS , A.OTH_PAY , A.OTH_EARNS , A.ADD_GROSS , A.TAX_METHOD , A.ADDL_SEQ , A.TL_SOURCE , A.BAS_CREDIT_SW , A.COMP_RATECD , A.COMPRATE , A.COMPRATE_USED , A.HRS_DIST_SW , A.XREF_NUM , A.EX_DOC_ID , A.EX_DOC_TYPE , A.EX_LINE_NBR , A.CURRENCY_CD , A.VC_PLAN_ID , A.VC_PAYOUT_PRD_ID , A.GB_GROUP_ID , A.APPLID , A.AWARD_DATE , A.NOTIFY_STATUS , A.EIM_KEY , A.PU_SOURCE , A.RETROPAY_SEQ_NO , C.HRS_ONLY , C.FACTOR_MULT FROM PS_MODEL_OTH_EARNS A , PS_EARNINGS_TBL C WHERE A.SEPCHK = 0 AND EXISTS ( SELECT 'Y' FROM PS_MODEL_PAY_EARNS B WHERE A.PY_MOD_OPRID = B.PY_MOD_OPRID AND A.PY_MOD_EMPLID = B.PY_MOD_EMPLID AND A.COMPANY = B.COMPANY AND A.PAYGROUP = B.PAYGROUP AND A.PAY_END_DT = B.PAY_END_DT AND A.OFF_CYCLE = B.OFF_CYCLE AND A.PAGE_NUM = B.PAGE_NUM AND A.LINE_NUM = B.LINE_NUM AND A.ADDL_NBR = B.ADDL_NBR AND B.OK_TO_PAY = 'Y' AND B.SEPCHK = 0) AND A.ERNCD = C.ERNCD AND C.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_EARNINGS_TBL D WHERE D.ERNCD = C.ERNCD AND D.EFFDT <= %CurrentDateIn)

  • Parent record: PAY_EARNINGS

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PY_MOD_OPRID Character(30) VARCHAR2(30) NOT NULL PayCheck Modeler User Id
    2 PY_MOD_EMPLID Character(11) VARCHAR2(11) NOT NULL PayCheck Modeler Employee ID
    3 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    4 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
    5 PAY_END_DT Date(10) DATE NOT NULL Pay Period End Date
    6 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?

    Y/N Table Edit

    Default Value: Y

    7 PAGE_NUM Number(5,0) INTEGER NOT NULL Page Nbr
    8 LINE_NUM Number(3,0) SMALLINT NOT NULL Line Nbr
    9 ADDL_NBR Number(3,0) SMALLINT NOT NULL Additional Pay Line Nbr
    10 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code

    Prompt Table: ERN_PROG_DESCR

    11 RATE_USED Character(1) VARCHAR2(1) NOT NULL Rate Used
    A=Alternative Rate
    F=FLSA Rate
    H=Hourly Rate

    Default Value: H

    12 SEPCHK Number(2,0) SMALLINT NOT NULL Separate check number.
    13 JOB_PAY Character(1) VARCHAR2(1) NOT NULL Job Pay

    Y/N Table Edit

    Default Value: N

    14 OTH_HRS Signed Number(8,2) DECIMAL(6,2) NOT NULL Other hours.
    15 OTH_PAY Signed Number(12,2) DECIMAL(10,2) NOT NULL Other Pay
    16 OTH_EARNS Signed Number(12,2) DECIMAL(10,2) NOT NULL Other Earnings
    17 ADD_GROSS Character(1) VARCHAR2(1) NOT NULL Add to Gross Pay
    N=No
    Y=Yes

    Y/N Table Edit

    18 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
    19 ADDL_SEQ Number(2,0) SMALLINT NOT NULL Additional Pay Sequence Number

    Prompt Table: ADDL_PAY_DATA

    20 TL_SOURCE Character(1) VARCHAR2(1) NOT NULL Time && Labor Source Flag
    T=Time and Labor Record
    U=User Updated/Created Record
    21 BAS_CREDIT_SW Character(1) VARCHAR2(1) NOT NULL Benefits Admin Credit

    Y/N Table Edit

    22 COMP_RATECD Character(6) VARCHAR2(6) NOT NULL Comp Rate Code

    Prompt Table: COMP_RT_REG_VW

    23 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate
    24 COMPRATE_USED Number(19,6) DECIMAL(18,6) NOT NULL Comp Rate Used
    25 HRS_DIST_SW Character(1) VARCHAR2(1) NOT NULL Hours Distribution
    26 XREF_NUM Number(15,0) DECIMAL(15) NOT NULL T&L Xref Num
    27 EX_DOC_ID Character(10) VARCHAR2(10) NOT NULL Expense Doc ID
    28 EX_DOC_TYPE Character(1) VARCHAR2(1) NOT NULL Expense Doc Type
    29 EX_LINE_NBR Number(5,0) INTEGER NOT NULL Expense Line #
    30 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    31 VC_PLAN_ID Character(10) VARCHAR2(10) NOT NULL VC Plan ID
    32 VC_PAYOUT_PRD_ID Character(10) VARCHAR2(10) NOT NULL Payout Period ID
    33 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.
    34 APPLID Character(11) VARCHAR2(11) NOT NULL External Job Applicant ID
    35 AWARD_DATE Date(10) DATE Award Date
    36 NOTIFY_STATUS Character(1) VARCHAR2(1) NOT NULL eRecruit Status
    N=Not Sent
    R=Reversed
    S=Sent to eRecruit

    Default Value: N

    37 EIM_KEY Character(20) VARCHAR2(20) NOT NULL SIM Sequence Number
    38 PU_SOURCE Character(2) VARCHAR2(2) NOT NULL Paysheet update source.
    AM=Absence Management
    ER=Recruiting Interface
    EX=Expense Interface
    IM=SIM Interface
    OT=Other Sources
    PL=Lifetime Balance Payout USF
    RP=Rapid Paysheets
    SP=Stock Admin - ESPP Refunds
    ST=Stock Admin - Options & ESPP
    VC=Variable Compensation
    VF=Bonus from Fusion
    WI=What-If
    39 RETROPAY_SEQ_NO Character(15) VARCHAR2(15) NOT NULL Retro Pay Sequence Number
    40 HRS_ONLY Character(1) VARCHAR2(1) NOT NULL Hours Only
    41 FACTOR_MULT Signed Number(11,4) DECIMAL(9,4) NOT NULL Multiplication Factor