HP_PAY_CHK_SUSP

(SQL View)
 Index Back

Pay Check

This is the summary record that contains the result of the payroll confirmation process.

SELECT DISTINCT A.COMPANY , A.PAYGROUP , A.PAY_END_DT , A.OFF_CYCLE , A.PAGE_NUM , A.LINE_NUM , A.SEPCHK , A.FORM_ID , A.PAYCHECK_NBR , A.EMPLID , A.EMPL_RCD , A.NAME , A.DEPTID , A.BUSINESS_UNIT FROM PS_PAY_CHECK A , PS_PAY_CALENDAR P WHERE A.COMPANY = P.COMPANY AND A.PAYGROUP = P.PAYGROUP AND A.PAY_END_DT = P.PAY_END_DT AND P.CA_GL_INTFC_RUN = 'N' AND (EXISTS ( SELECT B.ACCT_CD FROM PS_PAY_ERN_DIST 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 B.HP_RETDIST_STATUS = '0' AND EXISTS ( SELECT C.HP_ACCT_CD_SUSPNS FROM PS_DEPTBDGT_SUSPNS C WHERE C.DEPTID = B.DEPTID AND C.FISCAL_YEAR = B.FISCAL_YEAR AND C.HP_ACCT_CD_SUSPNS = B.ACCT_CD)) OR EXISTS ( SELECT D.ACCT_CD FROM PS_PAY_DED_DIST D WHERE A.COMPANY = D.COMPANY AND A.PAYGROUP = D.PAYGROUP AND A.PAY_END_DT = D.PAY_END_DT AND A.OFF_CYCLE = D.OFF_CYCLE AND A.PAGE_NUM = D.PAGE_NUM AND A.LINE_NUM = D.LINE_NUM AND A.SEPCHK = D.SEPCHK AND D.HP_RETDIST_STATUS = '0' AND EXISTS ( SELECT E.HP_ACCT_CD_SUSPNS FROM PS_DEPTBDGT_SUSPNS E WHERE E.DEPTID = D.DEPTID AND E.FISCAL_YEAR = D.FISCAL_YEAR AND E.HP_ACCT_CD_SUSPNS = D.ACCT_CD)) OR EXISTS ( SELECT F.ACCT_CD FROM PS_PAY_TAX_DIST F WHERE A.COMPANY = F.COMPANY AND A.PAYGROUP = F.PAYGROUP AND A.PAY_END_DT = F.PAY_END_DT AND A.OFF_CYCLE = F.OFF_CYCLE AND A.PAGE_NUM = F.PAGE_NUM AND A.LINE_NUM = F.LINE_NUM AND A.SEPCHK = F.SEPCHK AND F.HP_RETDIST_STATUS = '0' AND EXISTS ( SELECT G.HP_ACCT_CD_SUSPNS FROM PS_DEPTBDGT_SUSPNS G WHERE G.DEPTID = F.DEPTID AND G.FISCAL_YEAR = F.FISCAL_YEAR AND G.HP_ACCT_CD_SUSPNS = F.ACCT_CD)) OR EXISTS ( SELECT H.ACCT_CD FROM PS_PAY_CTX_DIST H WHERE A.COMPANY = H.COMPANY AND A.PAYGROUP = H.PAYGROUP AND A.PAY_END_DT = H.PAY_END_DT AND A.OFF_CYCLE = H.OFF_CYCLE AND A.PAGE_NUM = H.PAGE_NUM AND A.LINE_NUM = H.LINE_NUM AND A.SEPCHK = H.SEPCHK AND H.HP_RETDIST_STATUS = '0' AND EXISTS ( SELECT I.HP_ACCT_CD_SUSPNS FROM PS_DEPTBDGT_SUSPNS I WHERE I.DEPTID = H.DEPTID AND I.FISCAL_YEAR = H.FISCAL_YEAR AND I.HP_ACCT_CD_SUSPNS = H.ACCT_CD)))

  • Parent record: PAY_LINE

    • # 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(5,0) INTEGER NOT NULL Page Nbr

    Prompt Table: PAY_PAGE

    6 LINE_NUM Number(3,0) SMALLINT NOT NULL Line Nbr

    Prompt Table: PAY_LINE

    7 SEPCHK Number(2,0) SMALLINT NOT NULL Separate check number.
    8 FORM_ID Character(6) VARCHAR2(6) NOT NULL Form Identification

    Prompt Table: PAY_FORM_TBL

    9 PAYCHECK_NBR Number(15,0) DECIMAL(15) NOT NULL Paycheck number.
    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