FLSA_OTHEARN_VW

(SQL View)
 Index Back

Pay Other Earns by FLSA Period

This view is used to access Pay Other Earnings within FLSA Period instead of Pay Period.

SELECT A.COMPANY ,B.EMPLID ,B.FLSA_END_DT ,A.PAYGROUP ,A.PAY_END_DT ,A.OFF_CYCLE ,A.PAGE_NUM ,A.LINE_NUM ,A.SEPCHK ,A.ADDL_NBR ,A.ERNCD ,A.RATE_USED ,A.JOB_PAY ,A.OTH_HRS ,A.OTH_PAY ,A.OTH_EARNS ,A.ADD_GROSS ,A.TAX_METHOD ,A.ADDL_SEQ ,A.COMP_RATECD ,A.COMPRATE ,A.COMPRATE_USED ,A.HRS_DIST_SW ,B.SHIFT_RT 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.FLSA_END_DT IS NOT NULL 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 AND NOT EXISTS( SELECT 'X' FROM PS_FLAT_SUM_ERNCD D WHERE D.STATE = B.STATE AND D.ERNCD = A.ERNCD)

  • 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    3 FLSA_END_DT Date(10) DATE FLSA End Date
    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

    7 PAGE_NUM Number(5,0) INTEGER NOT NULL Page Nbr
    8 LINE_NUM Number(3,0) SMALLINT NOT NULL Line Nbr
    9 SEPCHK Number(2,0) SMALLINT NOT NULL Separate check number.
    10 ADDL_NBR Number(3,0) SMALLINT NOT NULL Additional Pay Line Nbr
    11 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code
    12 RATE_USED Character(1) VARCHAR2(1) NOT NULL Rate Used
    A=Alternative Rate
    F=FLSA Rate
    H=Hourly Rate
    13 JOB_PAY Character(1) VARCHAR2(1) NOT NULL Job Pay

    Y/N Table Edit

    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
    20 COMP_RATECD Character(6) VARCHAR2(6) NOT NULL Comp Rate Code
    21 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate
    22 COMPRATE_USED Number(19,6) DECIMAL(18,6) NOT NULL Comp Rate Used
    23 HRS_DIST_SW Character(1) VARCHAR2(1) NOT NULL Hours Distribution
    24 SHIFT_RT Number(19,6) DECIMAL(18,6) NOT NULL Shift Differential Rate