HRS_OVR_SCH_LN

(SQL View)
 Index Back

Related Language Record

Related Language Record for HRS_OVR_SCH_VW

SELECT A.HRS_PERSON_ID , A.EMPLID , B.LANGUAGE_CD , B.NAME , C.NAME_DISPLAY FROM PS_HRS_EE_REFERRAL A , PS_HRS_APP_NAME_LN B , PS_HRS_PERSON_NM_L C WHERE A.EMPLID <> ' ' AND A.HRS_PERSON_ID = B.HRS_PERSON_ID AND A.EMPLID = C.EMPLID AND B.LANGUAGE_CD = C.LANGUAGE_CD UNION SELECT A.HRS_PERSON_ID , A.EMPLID , B.LANGUAGE_CD , B.NAME , C.NAME_DISPLAY FROM PS_HRS_EE_REFERRAL A , PS_HRS_APP_NAME_LN B , PS_HRS_PERSON_NM_I C WHERE A.EMPLID <> ' ' AND A.HRS_PERSON_ID = B.HRS_PERSON_ID AND A.EMPLID = C.EMPLID AND NOT EXISTS ( SELECT 'X' FROM PS_HRS_PERSON_NM_L C1 WHERE C1.EMPLID = C.EMPLID AND C1.LANGUAGE_CD = B.LANGUAGE_CD) UNION SELECT A.HRS_PERSON_ID , A.EMPLID , C.LANGUAGE_CD , B.NAME , C.NAME_DISPLAY FROM PS_HRS_EE_REFERRAL A , PS_HRS_APP_NAME_I B , PS_HRS_PERSON_NM_L C WHERE A.EMPLID <> ' ' AND A.HRS_PERSON_ID = B.HRS_PERSON_ID AND A.EMPLID = C.EMPLID AND NOT EXISTS ( SELECT 'X' FROM PS_HRS_APP_NAME_LN B1 WHERE B1.HRS_PERSON_ID = B.HRS_PERSON_ID AND B1.LANGUAGE_CD = C.LANGUAGE_CD)

  • Related Language Record for HRS_OVR_SCH_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 NAME Character(50) VARCHAR2(50) NOT NULL Name
    5 EMPL_NAME Character(50) VARCHAR2(50) NOT NULL Employee Name