HRS_PSTDSC_LN_I

(SQL View)
 Index Back

Job Opening Descriptions RL

Job opening descriptions interface view related language

SELECT A.HRS_JOB_OPENING_ID , A.HRS_JO_PST_SEQ , A.HRS_SEQ_NUM , A.LANGUAGE_CD , A.DESCRLONG , B.APP_VISIBLE FROM PS_HRS_PSTDSCR_LNG A , PS_HRS_JO_PSTDSC_I B WHERE A.HRS_JOB_OPENING_ID = B.HRS_JOB_OPENING_ID AND A.HRS_JO_PST_SEQ = B.HRS_JO_PST_SEQ AND A.HRS_SEQ_NUM = B.HRS_SEQ_NUM

  • Related Language Record for HRS_JO_PSTDSC_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_SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence Number
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCRLONG Long Character CLOB Long Description
    6 APP_VISIBLE Character(1) VARCHAR2(1) NOT NULL Indicates which sections of a job requisition's posting description are visible to internal applicants. An entire posting description is made up of 5 possible sections, the Organizational Marketing Statement, Responsibilities, Qualifications, Closing and Departmental Statement
    B=Internal and External
    E=External Only
    I=Internal Only