HR_LBR_FAC_VW

(SQL View)
 Index Back

Labor Agreement Facility View


SELECT A.SETID , A.LABOR_AGREEMENT , A.EFFDT , A.LABOR_FACILITY_ID , B.DESCR FROM PS_HR_LBR_FACILITY A , PS_HR_LBR_FAC_TBL B WHERE A.LABOR_FACILITY_ID = B.LABOR_FACILITY_ID AND B.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_HR_LBR_FAC_TBL D WHERE D.LABOR_FACILITY_ID = B.LABOR_FACILITY_ID AND D.EFFDT <=A.EFFDT) AND B.EFF_STATUS = 'A'

  • Related Language Record: HR_LBRFACVW_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 LABOR_AGREEMENT Character(6) VARCHAR2(6) NOT NULL Labor Agreement
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 LABOR_FACILITY_ID Character(10) VARCHAR2(10) NOT NULL Labor Facility ID

    Prompt Table: HR_LBR_FAC_TBL

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