PAY_CONTDTL_VW

(SQL View)
 Index Back

Contract pay details view

PAY_CONTDTL_VW is a paycheck contract detail view that sum up of the earnings group by emplid, contract number, contract sequence, original pay end date, off cycle and separate check.

SELECT B.EMPLID , B.HP_CONTRACT_NUM , B.HP_CONTRACT_SEQ , B.PAY_END_DT , B.OFF_CYCLE , B.SEPCHK , SUM(B.HP_ACTUAL_CRG) , SUM(B.HP_ACTUAL_PNE) , SUM(B.HP_ACTUAL_ENP) , SUM(B.HP_PAID_LEAVE) , SUM(B.HP_UNPAID_LEAVE) FROM PS_PAY_CHECK A , PS_PAY_CNTRACT_DTL 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.PAYCHECK_STATUS IN ('A','F','R') GROUP BY B.EMPLID, B.HP_CONTRACT_NUM, B.HP_CONTRACT_SEQ, B.PAY_END_DT, B.OFF_CYCLE, B.SEPCHK

  • Parent record: PAY_CHECK

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 HP_CONTRACT_NUM Number(7,0) INTEGER NOT NULL Contract Number
    3 HP_CONTRACT_SEQ Number(3,0) SMALLINT NOT NULL Contract Sequence
    4 PAY_END_DT Date(10) DATE Pay Period End Date
    5 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?

    Y/N Table Edit

    6 SEPCHK Number(2,0) SMALLINT NOT NULL Separate check number.
    7 HP_ACTUAL_CRG Signed Number(13,2) DECIMAL(11,2) NOT NULL Actual Contract Regular
    8 HP_ACTUAL_PNE Signed Number(13,2) DECIMAL(11,2) NOT NULL Actual Paid not Earned
    9 HP_ACTUAL_ENP Signed Number(13,2) DECIMAL(11,2) NOT NULL Actual Earned not Paid
    10 HP_PAID_LEAVE Signed Number(13,2) DECIMAL(11,2) NOT NULL Actual Paid Leave
    11 HP_UNPAID_LEAVE Signed Number(13,2) DECIMAL(11,2) NOT NULL Actual Unpaid Leave