HRS_JO_PSTDST_I

(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 , %subrec(HRS_AUDIT_SBR, A) , A.COMMENTS FROM PS_HRS_JO_PST_DST A

  • Related Language Record: HRS_JOPSTDS_LNG

  • 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_PST_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
    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_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    11 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    12 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    13 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id
    14 COMMENTS Long Character CLOB Comment