HRS_JO_PDSC_VW

(SQL View)
 Index Back

Job Opening Posting Descr

Job opening posting descriptions.

SELECT A.HRS_JOB_OPENING_ID , A.HRS_JO_PST_SEQ , A.HRS_SEQ_NUM , A.HRS_JO_DESCR_TYP , B.HRS_SEQ_NUM , A.APP_VISIBLE , A.DESCRLONG FROM PS_HRS_JO_PST_DSCR A , PS_HRS_JO_PST_SCTN B , PS_HRS_JOB_OPENING C , PS_HRS_RCRT_TMPL D WHERE A.HRS_JOB_OPENING_ID=C.HRS_JOB_OPENING_ID AND A.HRS_JO_DESCR_TYP=B.HRS_JO_DESCR_TYP AND C.HRS_RCRT_TMPL_ID=D.HRS_RCRT_TMPL_ID AND D.HRS_PST_TMPL_ID=B.HRS_PST_TMPL_ID AND B.SELECTED='Y' AND D.EFFDT = ( SELECT MAX(X.EFFDT) FROM PS_HRS_RCRT_TMPL X WHERE D.HRS_RCRT_TMPL_ID = X.HRS_RCRT_TMPL_ID AND X.EFFDT <= %CurrentDateIn AND X.EFF_STATUS = 'A')

  • Related Language Record: HRS_JO_PDSC_LVW

  • Parent record: HRS_JO_POSTING

    • # 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

    Prompt Table: HRS_JOB_OPENING

    2 HRS_JO_PST_SEQ Number(3,0) SMALLINT NOT NULL Job opening posting sequence

    Prompt Table: HRS_JO_POSTING

    3 HRS_SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence Number
    4 HRS_JO_DESCR_TYP Character(2) VARCHAR2(2) NOT NULL Job posting description type

    Prompt Table: HRS_JO_DSC_TYP

    5 HRS_JO_DESCR_SEQ Number(3,0) SMALLINT NOT NULL Sequence Number
    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
    7 DESCRLONG Long Character CLOB Long Description