HRS_PSN_APP_VW

(SQL View)
 Index Back

Position Applied For - Max Dt

Maximum position applied fors.

SELECT A.HRS_PERSON_ID ,A.HRS_RCMNT_ID ,A.HRS_JOB_OPENING_ID ,A.STATUS_CODE ,A.STATUS_REASON ,A.HRS_STATUS_DT ,A.ENTRY_SOURCE ,A.ENTRY_DATE ,B.HRS_DES_LOC1 ,B.HRS_DES_LOC2 ,B.DESIRED_REG_TEMP ,B.DESIRED_FULL_PART ,B.DESIRED_START_DT ,B.DESIRED_HOURS ,B.TRAVELLING ,B.HRS_TRAVEL_PERCENT ,B.HIGHEST_EDUC_LVL ,B.YEARS_OF_EXP ,A.KEYWORD_MATCH ,C.OPEN_STS_IND ,C.STATUS_PHASE FROM PS_HRS_RCMNT A ,PS_HRS_APP_PROFILE B ,PS_HRS_STS_TBL C WHERE B.HRS_PERSON_ID = A.HRS_PERSON_ID AND B.HRS_PROFILE_SEQ = A.HRS_PROFILE_SEQ AND C.STATUS_CODE = A.STATUS_CODE AND C.STATUS_AREA = '3'

  • 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_RCMNT_ID Number(15,0) DECIMAL(15) NOT NULL App Tracking Recruitment ID
    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
    7 ENTRY_SOURCE Character(1) VARCHAR2(1) NOT NULL Entry Source
    A=Application
    O=Organization
    8 ENTRY_DATE Date(10) DATE Date Entered
    9 HRS_DES_LOC1 Number(15,0) DECIMAL(15) NOT NULL Desired Location 1

    Prompt Table: HRS_LOC_I

    10 HRS_DES_LOC2 Number(15,0) DECIMAL(15) NOT NULL Desired Location 2

    Prompt Table: HRS_LOC_I

    11 DESIRED_REG_TEMP Character(1) VARCHAR2(1) NOT NULL Regular/Temporary
    E=Either
    R=Regular
    T=Temporary
    12 DESIRED_FULL_PART Character(1) VARCHAR2(1) NOT NULL Full/Part-Time
    E=Either
    F=Full-Time
    P=Part-Time
    13 DESIRED_START_DT Date(10) DATE Desired Start Date
    14 DESIRED_HOURS Number(4,1) DECIMAL(3,1) NOT NULL Desired Hours Per Week
    15 TRAVELLING Character(1) VARCHAR2(1) NOT NULL Willing to Travel
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    16 HRS_TRAVEL_PERCENT Character(1) VARCHAR2(1) NOT NULL Travel percent
    0=Never or rarely
    1=Up to 25% of the time
    2=Up to 50% of the time
    3=Up to 75% of the time
    4=Up to 100% of the time
    17 HIGHEST_EDUC_LVL Character(2) VARCHAR2(2) NOT NULL Highest Education Level

    Prompt Table: HIGH_EDUCLVL_VW

    18 YEARS_OF_EXP Number(5,1) DECIMAL(4,1) NOT NULL Years of Work Experience
    19 KEYWORD_MATCH Character(1) VARCHAR2(1) NOT NULL Keyword match
    20 OPEN_STS_IND Character(1) VARCHAR2(1) NOT NULL Indicates an open state.
    21 STATUS_PHASE Character(1) VARCHAR2(1) NOT NULL Identifies a phase within a status area.
    1=1-Applied
    2=2-Reviewed
    3=3-Screen
    4=4-Route
    5=5-Interview
    6=6-Offer
    7=7-Hire
    8=8-Hold
    9=9-Reject