HRS_APP_APLC_V2

(SQL View)
 Index Back

My Applications

Applicant's Applications on Home page

SELECT DISTINCT A.HRS_PERSON_ID , A.HRS_PROFILE_SEQ , A.HRS_RCMNT_ID , A.HRS_JOB_OPENING_ID , C.BUSINESS_UNIT , C.POSTING_TITLE , C.LOCATION , A.HRS_STATUS_DT , A.STATUS_CODE , A.HRS_WITHDRAWN_DTTM , A.HRS_LOGICAL_DELETE , D.HRS_WITHDRAW_IND , D.DESCR , D.DESCRSHORT , CASE WHEN A.HRS_SUBMIT_SOURCE = 'C' THEN E.HRS_SUBMITTED_DTTM WHEN A.HRS_SUBMIT_SOURCE = 'T' THEN A.HRS_ROW_ADD_DTTM ELSE E.HRS_ROW_ADD_DTTM END , D.HRS_DRFT_STS_IND , A.ENTRY_SOURCE , A.HRS_SUBMIT_SOURCE , A.HRS_ROW_ADD_DTTM FROM PS_HRS_RCMNT_I A ,PS_HRS_JO_I C , PS_HRS_STS_REC_I D , PS_HRS_APP_PROFILE E WHERE A.HRS_JOB_OPENING_ID=C.HRS_JOB_OPENING_ID AND A.STATUS_CODE=D.STATUS_CODE AND A.HRS_PERSON_ID= E.HRS_PERSON_ID AND A.HRS_PROFILE_SEQ = E.HRS_PROFILE_SEQ

  • Related Language Record: HRS_APP_APL_LV2

    • # 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_RCMNT_ID Number(15,0) DECIMAL(15) NOT NULL App Tracking Recruitment ID
    4 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
    5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    6 POSTING_TITLE Character(200) VARCHAR2(200) NOT NULL Job posting title
    7 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
    8 STATUS_DT Date(10) DATE Status Date

    Default Value: %date

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

    Prompt Table: HRS_STS_REC_I

    10 HRS_WITHDRAWN_DTTM DateTime(26) TIMESTAMP Date time stamp when the candidate's application was withdrawn.
    11 HRS_LOGICAL_DELETE Character(1) VARCHAR2(1) NOT NULL Indicates row has been logically deleted.
    12 HRS_WITHDRAW_IND Character(1) VARCHAR2(1) NOT NULL Indicates applicant can withdraw an application in the given status.
    13 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    14 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    15 HRS_SUBMITTED_DTTM DateTime(26) TIMESTAMP Submitted Date Time
    16 HRS_DRFT_STS_IND Character(1) VARCHAR2(1) NOT NULL Draft Status Indicator
    17 ENTRY_SOURCE Character(1) VARCHAR2(1) NOT NULL Entry Source
    A=Application
    O=Organization
    18 HRS_SUBMIT_SOURCE Character(1) VARCHAR2(1) NOT NULL field used to identify where this application was submitted from: C- Candidate Gateway, T- TAM
    C=Candidate Gateway
    T=TAM
    19 HRS_APP_CREATED_DT DateTime(26) TIMESTAMP date application created