HRS_JO_SEC_LN_3

(SQL View)
 Index Back

Job Opening w/Sec Rel Lang Int

Related language record for secured job opening interface view

SELECT A.HRS_JOB_OPENING_ID , B.OPRID , C.LANGUAGE_CD , C.HRS_PRM_PST_TITLE , COALESCE ((SELECT D.DESCR FROM PS_HRS_JO_LCA_LN_I D WHERE D.HRS_JOB_OPENING_ID = C.HRS_JOB_OPENING_ID AND D.HRS_LOCATION_ID = A.HRS_PRM_LOC_AREA AND D.LANGUAGE_CD = C.LANGUAGE_CD), (SELECT D.DESCR FROM PS_HRS_JO_LOC_AR_I D WHERE D.HRS_JOB_OPENING_ID = C.HRS_JOB_OPENING_ID AND D.HRS_LOCATION_ID = A.HRS_PRM_LOC_AREA), ' ') FROM PS_HRS_JOB_OPENING A , PS_HRS_JO_SEC_VW B , PS_HRS_JO_LNG C WHERE B.HRS_JOB_OPENING_ID = A.HRS_JOB_OPENING_ID AND C.HRS_JOB_OPENING_ID = A.HRS_JOB_OPENING_ID

  • Related Language Record for HRS_JO_ALL_I

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
    2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 POSTING_TITLE Character(200) VARCHAR2(200) NOT NULL Job posting title
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description