PAY_OERNS_WC_VW

(SQL View)
 Index Back

Pay Check Other Earns

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 ,C.EMPLID ,C.EMPL_RCD ,C.NAME ,C.DEPTID ,C.BUSINESS_UNIT ,A.OTH_HRS 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.PAY_LINE_STATUS IN ('C','V') 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
    2 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
    3 PAY_END_DT Date(10) DATE Pay Period End Date
    4 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?
    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
    10 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    11 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    12 NAME Character(50) VARCHAR2(50) NOT NULL Name
    13 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    14 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    15 OTH_HRS Signed Number(8,2) DECIMAL(6,2) NOT NULL Other hours.