HRS_JO_PDST_VW

(SQL View)
 Index Back

Job Opening Posting

Job Opening Posting

SELECT A.HRS_JOB_OPENING_ID , A.HRS_JO_PST_SEQ , A.HRS_SEQ_NUM , A.HRS_JO_PST_TYPE , A.HRS_SOURCE_ID , A.HRS_JO_PST_OPN_DT , A.HRS_JO_PST_CLS_DT , A.HRS_JO_PST_OPN_DFN , A.HRS_JO_PST_LENGTH , B.HRS_SOURCE_NAME FROM PS_HRS_JO_PST_DST A , PS_HRS_SRC_PST_I1 B WHERE B.HRS_SOURCE_ID = A.HRS_SOURCE_ID AND B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_HRS_SOURCE C WHERE C.HRS_SOURCE_ID = B.HRS_SOURCE_ID AND C.EFFDT <= %CurrentDateIn)

  • Related Language Record: HRS_JO_PDST_VWL

    • # 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_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
    5 HRS_SOURCE_ID Number(15,0) DECIMAL(15) NOT NULL Source ID

    Prompt Table: HRS_SRC_PST_I1

    6 HRS_JO_PST_OPN_DT Date(10) DATE Job opening posting open date
    7 HRS_JO_PST_CLS_DT Date(10) DATE Job opening post close date
    8 HRS_JO_PST_OPN_DFN Character(2) VARCHAR2(2) NOT NULL Relative Open Date
    00=0 - On Approval Date
    01=1 - One day after approval
    02=2 - Two days after approval
    03=3 - Three days after approval
    04=4 - Four days after approval
    05=5 - Five days after approval
    06=6 - Six days after approval
    07=7 - Seven days after approval
    08=8 - Eight days after approval
    09=9 - Nine days after approval
    10=10 - Ten days after approval
    9 HRS_JO_PST_LENGTH Number(3,0) SMALLINT NOT NULL Job opening posting duration
    10 HRS_SOURCE_NAME Character(30) VARCHAR2(30) NOT NULL Source Name