EMPL_LBR_ESP_VW

(SQL View)
 Index Back

Employee Labor Agreemnt VW ESP


SELECT A.EMPLID , A.EFFDT , A.CONTRACT_NUM , B.SETID , A.LABOR_AGREEMENT , B.DESCR FROM PS_JOB A , PS_HR_LABOR_AGRMNT B WHERE A.SETID_LBR_AGRMNT = B.SETID AND A.LABOR_AGREEMENT = B.LABOR_AGREEMENT AND B.EFFDT = ( SELECT MAX (ED.EFFDT) FROM PS_HR_LABOR_AGRMNT ED WHERE A.SETID_LBR_AGRMNT = ED.SETID AND A.LABOR_AGREEMENT = ED.LABOR_AGREEMENT AND ED.EFFDT <= A.EFFDT) AND A.EFFSEQ= ( SELECT MAX(A_ED.EFFSEQ) FROM PS_JOB A_ED WHERE A.EMPLID=A_ED.EMPLID AND A.EFFDT=A_ED.EFFDT AND A.CONTRACT_NUM=A_ED.CONTRACT_NUM)

  • Parent record: EMPL_CTG_L2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number
    4 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_HR.SETID

    Prompt Table: SETID_TBL

    5 LABOR_AGREEMENT Character(6) VARCHAR2(6) NOT NULL Labor Agreement

    Prompt Table: EMPL_CTG

    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description