HRS_PSN_APP_RTE

(SQL View)
 Index Back

Position Applied For - Route

Dispositions of position applied for in route status.

SELECT A.HRS_PERSON_ID ,A.HRS_PROFILE_SEQ ,A.HRS_JOB_OPENING_ID ,A.STATUS_CODE ,A.STATUS_REASON ,A.HRS_STATUS_DT FROM PS_HRS_RCMNT A , PS_HRS_RCM_STS_I B WHERE A.HRS_PROFILE_SEQ = ( SELECT MAX(D.HRS_PROFILE_SEQ) FROM PS_HRS_RCMNT D WHERE D.HRS_PERSON_ID = A.HRS_PERSON_ID AND D.HRS_JOB_OPENING_ID = A.HRS_JOB_OPENING_ID) AND A.STATUS_CODE = B.STATUS_CODE

  • Parent record: HRS_APP_PROFILE

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    2 HRS_PROFILE_SEQ Number(3,0) SMALLINT NOT NULL Profile sequece
    3 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone

    Prompt Table: HRS_JOB_OPENING

    4 STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Identifies a status.

    Prompt Table: HRS_STS_REC_I

    5 STATUS_REASON Character(3) VARCHAR2(3) NOT NULL Identifies a reason associated with a particular status.

    Prompt Table: HRS_RSN_REC_I

    6 HRS_STATUS_DT Date(10) DATE Recruiting Solutions Status Date field