HRS_JO_PSTDSB_I

(SQL View)
 Index Back

Job Opening Int/Ext Pst Dest

Job opening internal and external posting destinations.

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 FROM PS_HRS_JO_PST_DST A WHERE A.HRS_JO_PST_TYPE = 'I' OR A.HRS_JO_PST_TYPE = 'E'

  • 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_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_MV_VW_I

    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