PY_IC_PI_OE_VW

(SQL View)
 Index Back

WEB-PayChk Rvw Other Earnings

View created to support WEB-enabled Paycheck Review. It is based on the PAY_OTH_EARNS record. It contains earnings type information for other than regular or overtime earnings. A view was created to shield the user from base-record Peoplecode getting executed. Changes made to the record PAY_OTH_EARNS would need to be analyzed and made to W3PY_CHK_OEN_VW, if necessary.

SELECT A.COMPANY , A.PAYGROUP , A.PAY_END_DT , A.OFF_CYCLE , A.PAGE_NUM , A.LINE_NUM , A.ADDL_NBR , A.ERNCD , A.SEPCHK , A.OTH_HRS , A.OTH_EARNS , A.OTH_PAY , A.COMP_RATECD , A.COMPRATE_USED , A.RATE_USED , A.HRS_DIST_SW FROM PS_PAY_OTH_EARNS A , PS_PAY_EARNINGS B 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

  • Parent record: PAY_EARNINGS

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    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(4,0) SMALLINT NOT NULL Page #
    6 LINE_NUM Number(2,0) SMALLINT NOT NULL Line #
    7 ADDL_NBR Number(3,0) SMALLINT NOT NULL Additional Pay Line #
    8 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code
    9 SEPCHK Number(1,0) SMALLINT NOT NULL Separate check number.
    10 OTH_HRS Signed Number(8,2) DECIMAL(6,2) NOT NULL Other Hours
    11 OTH_EARNS Signed Number(12,2) DECIMAL(10,2) NOT NULL Other Earnings
    12 OTH_PAY Signed Number(12,2) DECIMAL(10,2) NOT NULL Other Pay
    13 COMP_RATECD Character(6) VARCHAR2(6) NOT NULL Comp Rate Code
    14 COMPRATE_USED Number(19,6) DECIMAL(18,6) NOT NULL Comp Rate Used
    15 RATE_USED Character(1) VARCHAR2(1) NOT NULL Rate Used
    A=Alternative Rate
    F=FLSA Rate
    H=Hourly Rate
    16 HRS_DIST_SW Character(1) VARCHAR2(1) NOT NULL Hours Distribution