HRS_PST_EXP_VW

(SQL View)
 Index Back

Ext and Int Job Openings

View of current and expired postings

SELECT J.HRS_JOB_OPENING_ID ,P.HRS_JO_PST_SEQ ,PD.HRS_JO_PST_TYPE ,P.POSTING_TITLE ,P.HRS_JO_PRM_PST_FLG ,PD.HRS_JO_PST_OPN_DT ,PD.HRS_JO_PST_CLS_DT FROM PS_HRS_JOB_OPENING J , PS_HRS_JO_POSTING P , PS_HRS_JO_PST_DST PD WHERE J.HRS_JOB_OPENING_ID = P.HRS_JOB_OPENING_ID AND J.HRS_JOB_OPENING_ID = PD.HRS_JOB_OPENING_ID AND P.HRS_JO_PST_SEQ = PD.HRS_JO_PST_SEQ AND (PD.HRS_JO_PST_TYPE = 'E' OR PD.HRS_JO_PST_TYPE = 'I') AND PD.HRS_JO_PST_OPN_DT <= %CurrentDateIn AND PD.HRS_JO_PST_OPN_DT IS NOT NULL

  • Related Language Record: HRS_JO_PST_LN_I

  • Parent record: HRS_JO_PST_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

    Prompt Table: HRS_JO_I

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

    Prompt Table: HRS_JO_PST_I

    3 HRS_JO_PST_TYPE Character(1) VARCHAR2(1) NOT NULL Job Opening Posting Type
    C=Contingent Workforce
    E=External Posting
    I=Internal Posting
    L=Labor Office
    R=Recruitment
    4 POSTING_TITLE Character(200) VARCHAR2(200) NOT NULL Job posting title
    5 HRS_JO_PRM_PST_FLG Character(1) VARCHAR2(1) NOT NULL Primary posting title flag

    Y/N Table Edit

    Default Value: N

    6 OPEN_DT Date(10) DATE Created
    7 CLOSE_DT Date(10) DATE Date Closed