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_I A ,PS_HRS_APP_PROF_I B ,PS_HRS_STS_REC_I C WHERE A.HRS_PERSON_ID = B.HRS_PERSON_ID AND A.HRS_PROFILE_SEQ = B.HRS_PROFILE_SEQ AND A.STATUS_CODE = C.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_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

    Y/N Table Edit

    Default Value: N

    16 HRS_TRAVEL_PERCENT Character(1) VARCHAR2(1) NOT NULL Travel percent
    0=None
    1=<= 25%
    2=26 - 50 %
    3=51 - 75 %
    4=76 - 100 %
    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 Keywords Matched
    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-Review
    2=2-Applied
    3=3-Screen
    4=4-Route
    5=5-Interview
    6=6-Offer
    7=7-Hire
    8=8-Reject