PAY_OTH_EARNS_V

(SQL View)
 Index Back

Pay Check Other Earns View

This view is used to access Pay Other Earnings information.

SELECT A.COMPANY ,A.PAYGROUP ,A.PAY_END_DT ,A.OFF_CYCLE ,A.PAGE_NUM ,A.LINE_NUM ,A.SEPCHK ,A.ADDL_NBR ,A.ERNCD ,A.JOB_PAY ,A.OTH_HRS ,A.OTH_PAY ,A.OTH_EARNS ,A.ADD_GROSS ,A.TAX_METHOD ,A.ADDL_SEQ ,A.RATE_USED ,A.COMP_RATECD ,A.COMPRATE ,A.COMPRATE_USED ,A.HRS_DIST_SW ,A.RETROPAY_SEQ_NO ,B.SHIFT_RT ,A.PU_SOURCE FROM PS_PAY_OTH_EARNS A ,PS_PAY_EARNINGS B ,PS_PAY_CHECK C WHERE 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.SEPCHK=B.SEPCHK AND A.ADDL_NBR=B.ADDL_NBR AND B.OK_TO_PAY='Y' AND A.COMPANY=C.COMPANY AND A.PAYGROUP=C.PAYGROUP AND A.PAY_END_DT=C.PAY_END_DT AND A.OFF_CYCLE=C.OFF_CYCLE AND A.PAGE_NUM=C.PAGE_NUM AND A.LINE_NUM=C.LINE_NUM AND A.SEPCHK=C.SEPCHK

  • Parent record: PAY_EARNINGS_V

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

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

    Y/N Table Edit

    5 PAGE_NUM Number(5,0) INTEGER NOT NULL Page Nbr
    6 LINE_NUM Number(3,0) SMALLINT NOT NULL Line Nbr
    7 SEPCHK Number(2,0) SMALLINT NOT NULL Separate check number.
    8 ADDL_NBR Number(3,0) SMALLINT NOT NULL Additional Pay Line Nbr
    9 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code

    Prompt Table: ERN_PROG_DESCR

    10 JOB_PAY Character(1) VARCHAR2(1) NOT NULL Job Pay

    Y/N Table Edit

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

    Y/N Table Edit

    15 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
    16 ADDL_SEQ Number(2,0) SMALLINT NOT NULL Additional Pay Sequence Number
    17 RATE_USED Character(1) VARCHAR2(1) NOT NULL Rate Used
    A=Alternative Rate
    F=FLSA Rate
    H=Hourly Rate
    18 COMP_RATECD Character(6) VARCHAR2(6) NOT NULL Comp Rate Code
    19 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate
    20 COMPRATE_USED Number(19,6) DECIMAL(18,6) NOT NULL Comp Rate Used
    21 HRS_DIST_SW Character(1) VARCHAR2(1) NOT NULL Hours Distribution
    22 RETROPAY_SEQ_NO Character(15) VARCHAR2(15) NOT NULL Retro Pay Sequence Number
    23 SHIFT_RT Number(19,6) DECIMAL(18,6) NOT NULL Shift Differential Rate
    24 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