HR_LBRFACVW_LNG

(SQL View)
 Index Back

Related Language record

Related Language record for Labor Faciliy.

SELECT A.SETID , A.LABOR_AGREEMENT , A.LABOR_FACILITY_ID , A.EFFDT , B.LANGUAGE_CD , B.DESCR FROM PS_HR_LBR_FACILITY A , PS_HR_LBR_FAC_LNG B WHERE A.LABOR_FACILITY_ID = B.LABOR_FACILITY_ID AND A.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_HR_LBR_FACILITY C WHERE C.SETID = A.SETID AND C.LABOR_AGREEMENT = A.LABOR_AGREEMENT AND C.LABOR_FACILITY_ID = A.LABOR_FACILITY_ID AND C.EFFDT <= %CurrentDateIn) 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 <= %CurrentDateIn)

  • Related Language Record for HR_LBR_FAC_VW

    • # 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 LABOR_FACILITY_ID Character(10) VARCHAR2(10) NOT NULL Labor Facility ID

    Prompt Table: HR_LBR_FAC_TBL

    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description