HP_PAYCHKERN_SP

(SQL View)
 Index Back

Pay Check Earnings View

The PAY_CHK_EARN_VW selects information from PAY_CHECK_EARNS.

SELECT A.COMPANY , A.PAYGROUP , A.PAY_END_DT , A.OFF_CYCLE , A.PAGE_NUM , A.LINE_NUM , A.SEPCHK , A.EMPL_RCD , A.ERNCD , SUM(A.EARNINGS) , A.REVERSED , A.ADD_GROSS FROM PS_PAY_CHECK_EARNS A WHERE EXISTS ( SELECT B.COMPANY FROM PS_HP_PAY_CHK_SUSP 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 EXISTS ( SELECT E.ACCT_CD FROM PS_PAY_ERN_DIST E WHERE A.COMPANY = E.COMPANY AND A.PAYGROUP = E.PAYGROUP AND A.PAY_END_DT = E.PAY_END_DT AND A.OFF_CYCLE = E.OFF_CYCLE AND A.PAGE_NUM = E.PAGE_NUM AND A.LINE_NUM = E.LINE_NUM AND A.SEPCHK = E.SEPCHK AND A.ERNCD = E.ERNCD AND E.HP_RETDIST_STATUS = '0' AND EXISTS ( SELECT C.HP_ACCT_CD_SUSPNS FROM PS_DEPTBDGT_SUSPNS C WHERE C.DEPTID = E.DEPTID AND C.FISCAL_YEAR = E.FISCAL_YEAR AND C.HP_ACCT_CD_SUSPNS = E.ACCT_CD)) GROUP BY A.COMPANY , A.PAYGROUP , A.PAY_END_DT , A.OFF_CYCLE , A.PAGE_NUM , A.LINE_NUM , A.SEPCHK , A.EMPL_RCD , A.ERNCD , A.REVERSED , A.ADD_GROSS

  • Parent record: PAY_CHECK

    • # 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

    Prompt Table: PAYGROUP_TBL

    3 PAY_END_DT Date(10) DATE NOT NULL Pay Period End Date

    Prompt Table: PAY_CALENDAR

    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 SEPCHK Number(1,0) SMALLINT NOT NULL Separate check number.
    8 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    9 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code
    10 EARNINGS Signed Number(15,2) DECIMAL(13,2) NOT NULL Earnings
    11 REVERSED Character(1) VARCHAR2(1) NOT NULL Reversed

    Y/N Table Edit

    Default Value: N

    12 ADD_GROSS Character(1) VARCHAR2(1) NOT NULL Add to Gross Pay
    N=No
    Y=Yes