HRS_JOSITE_LN_I

(SQL View)
 Index Back

Job opening post sec RL intfc

Job opening posting interface related language interface view with security

SELECT A.HRS_JOB_OPENING_ID , A.HRS_JO_PST_SEQ , B.HRS_SITE_ID , A.LANGUAGE_CD , A.POSTING_TITLE FROM PS_HRS_JO_PST_LNG A , PS_HRS_JO_PST_DST C , PS_HRS_SOURCE_SITE B WHERE A.HRS_JOB_OPENING_ID = C.HRS_JOB_OPENING_ID AND C.HRS_SOURCE_ID = B.HRS_SOURCE_ID AND B.EFFDT=( SELECT MAX(Y.EFFDT) FROM PS_HRS_SOURCE_SITE Y WHERE Y.HRS_SOURCE_ID = B.HRS_SOURCE_ID AND Y.EFFDT <= %CurrentDateIn )

  • Related Language Record for HRS_JO_SITEXT_I HRS_JO_SITINT_I HRS_JO_SPEXT_I HRS_JO_SPINT_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 HRS_JO_PST_SEQ Number(3,0) SMALLINT NOT NULL Job opening posting sequence
    3 HRS_SITE_ID Number(15,0) DECIMAL(15) NOT NULL Site ID
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 POSTING_TITLE Character(200) VARCHAR2(200) NOT NULL Job posting title