HRS_EXTPST_S_VW

(SQL View)
 Index Back

External Posting History

External Posting History

SELECT B.HRS_JOB_OPENING_ID ,A.HRS_EXT_POST_ID ,A.HRS_LOG_ID ,A.HRS_TRANS_NAME ,A.HRS_EP_HIST_ACT ,B.HRS_EXT_POST_STS ,B.HRS_JO_PST_SEQ ,B.HRS_XML_ID ,D.HRS_SOURCE_ID ,D.HRS_SOURCE_NAME FROM PS_HRS_EXTPST_HIST A , PS_HRS_EXTPOST_STS B , PS_HRS_SOURCE D WHERE A.HRS_EXT_POST_ID = B.HRS_EXT_POST_ID AND B.HRS_SOURCE_ID = D.HRS_SOURCE_ID AND A.HRS_LOG_ID = ( SELECT MAX(HRS_LOG_ID) FROM PS_HRS_EXTPST_HIST X WHERE A.HRS_EXT_POST_ID = X.HRS_EXT_POST_ID) AND %CurrentDateIn BETWEEN D.EFFDT AND D.HRS_END_EFFDT AND D.HRS_SOURCE_TYPE = '10' AND D.HRS_SOURCE_ID <> 1 AND D.HRS_SOURCE_STATUS='10' AND D.HRS_SOURCE_NAME = 'Services Procurement'

  • Parent record: HRS_EXTPOST_STS

    • # 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
    2 HRS_EXT_POST_ID Number(15,0) DECIMAL(15) NOT NULL External Posting ID
    3 HRS_LOG_ID Number(15,0) DECIMAL(15) NOT NULL Integration Log ID
    4 HRS_TRANS_NAME Character(52) VARCHAR2(52) NOT NULL Transaction Name
    5 HRS_EP_HIST_ACT Character(3) VARCHAR2(3) NOT NULL External Posting Action
    10=Success
    20=Redirected
    30=Error
    40=Posted
    50=Unposted
    60=Awaiting Post
    6 HRS_EXT_POST_STS Character(3) VARCHAR2(3) NOT NULL External Posting Status
    10=New
    20=Unconfirmed Post
    30=Unconfirmed Unpost
    40=Awaiting Post
    50=Posted
    60=Unposted
    70=Error
    7 HRS_JO_PST_SEQ Number(3,0) SMALLINT NOT NULL Job opening posting sequence
    8 HRS_XML_ID Number(15,0) DECIMAL(15) NOT NULL XML ID
    9 HRS_SOURCE_ID Number(15,0) DECIMAL(15) NOT NULL Source ID
    10 HRS_SOURCE_NAME Character(30) VARCHAR2(30) NOT NULL Source Name