HRS_APP_PROF_I

(SQL View)
 Index Back

Applicant Profile Interface

This Interface view is to retrieve all the applicant profiles.

SELECT HRS_PERSON_ID ,HRS_PROFILE_SEQ ,HRS_SUBMITTED_BY ,HRS_SUBMITTED_DTTM ,HRS_RESUME_ID ,HRS_AL_LOG_ID ,APPLIC_PURGE_DT ,HIGHEST_EDUC_LVL ,%subrec(HRS_PERSFED_SBR,A) ,LANG_CD ,YEARS_OF_EXP ,HRS_REPORT_DEFN_ID ,HRS_REPORT_TMPL_ID ,LETTER_PRINTED_DT ,TRAVELLING ,RELOCATE ,UNION_CD ,DESIRED_HOURS ,MIN_RATE ,CURRENCY_CD ,PAY_FREQ_ABBRV ,DESIRED_START_DT ,DESIRED_FULL_PART ,DESIRED_REG_TEMP ,DESIRED_SHIFT ,MON ,TUES ,WED ,THURS ,FRI ,SAT ,SUN ,BUSINESS_UNIT ,HRS_DES_LOC1 ,HRS_DES_LOC2 ,HRS_TRAVEL_PERCENT , PREV_EMPL_BY_COMPY , PREV_TERM_DT ,%subrec(HRS_AUDIT_SBR,A) ,GEOG_PREFER FROM PS_HRS_APP_PROFILE A

  • Parent record: HRS_APPLICANT

    • # 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_SUBMITTED_BY Character(15) VARCHAR2(15) NOT NULL submitted by
    4 HRS_SUBMITTED_DTTM DateTime(26) TIMESTAMP Submitted Date Time
    5 HRS_RESUME_ID Number(15,0) DECIMAL(15) NOT NULL Resume id
    6 HRS_AL_LOG_ID Number(15,0) DECIMAL(15) NOT NULL Resume Extraction Queue ID
    7 APPLIC_PURGE_DT Date(10) DATE Store date by which applicant records are to be deleted as part of the applicant purge process
    8 HIGHEST_EDUC_LVL Character(2) VARCHAR2(2) NOT NULL Highest Education Level

    Default Value: A

    9 GVT_CRED_MIL_SVCE Character(4) VARCHAR2(4) NOT NULL Creditable Military Service
    10 GVT_MILITARY_COMP Character(1) VARCHAR2(1) NOT NULL Uniformed Service
    A=Air Force
    C=Coast Guard
    M=Marines
    N=Navy
    R=Army
    11 GVT_MIL_GRADE Character(3) VARCHAR2(3) NOT NULL Military Grade
    E1=E1
    E2=E2
    E3=E3
    E4=E4
    E5=E5
    E6=E6
    E7=E7
    E8=E8
    E9=E9
    O1=O1
    O10=O10
    O2=O2
    O3=O3
    O4=O4
    O5=O5
    O6=O6
    O7=O7
    O8=O8
    O9=O9
    W1=W1
    W2=W2
    W3=W3
    W4=W4
    12 GVT_MIL_RESRVE_CAT Character(1) VARCHAR2(1) NOT NULL Reserve Category
    A=IMA - Air Force
    B=IMA - Army
    C=IMA - Coast Guard
    D=IMA - Marines
    E=IMA - Navy
    F=Selected Reserve - Air Force
    G=Selected Reserve - Army
    H=Selected Reserve - Coast Guard
    I=Selected Reserve - Marine Corp
    J=Selected Reserves - Navy
    K=Air National Guard
    L=Army National Guard
    M=IRR - Air Force
    N=IRR - Army
    O=IRR - Coast Guard
    P=IRR - Marine Corps
    Q=IRR - Navy
    S=Standby Reserve - Air Force
    T=Standby Reserve - Army
    U=Standby Reserve - Coast Guard
    V=Standby Reserve - Marine Corps
    W=Standby Reserve - Navy
    X=Navy Reserve - Merchant Marine
    Y=Draft Eligible
    Z=Not Applicable
    13 GVT_MIL_SEP_RET Character(1) VARCHAR2(1) NOT NULL Military Separation Status
    R=Retired
    S=Separated
    Z=Not Applicable
    14 GVT_MIL_SVCE_END Date(10) DATE Military Service End Date
    15 GVT_MIL_SVCE_START Date(10) DATE Military Service Start Date
    16 GVT_MIL_VERIFY Character(1) VARCHAR2(1) NOT NULL Military Service Verified

    Y/N Table Edit

    17 GVT_PAR_NBR_LAST Number(6,0) INTEGER NOT NULL Last Personnel Action Reqst #
    18 GVT_UNIF_SVC_CTR Character(1) VARCHAR2(1) NOT NULL Notify Military Pay Center

    Y/N Table Edit

    19 GVT_VET_PREF_APPT Character(1) VARCHAR2(1) NOT NULL Veterans Preference

    Default Value: 1

    Prompt Table: HRS_G_VTPRF_TBL

    20 GVT_VET_PREF_RIF Character(1) VARCHAR2(1) NOT NULL Veterans Preference RIF

    Y/N Table Edit

    Default Value: N

    21 GVT_CHANGE_FLAG Character(1) VARCHAR2(1) NOT NULL Change Flag
    22 GVT_DRAFT_STATUS Character(1) VARCHAR2(1) NOT NULL Draft Status
    N=Not Yet Registered
    R=Registered
    X=Not Applicable
    23 GVT_YR_ATTAINED Date(10) DATE Year Attained
    24 DISABLED_VET Character(1) VARCHAR2(1) NOT NULL Disabled Veteran
    25 DISABLED Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) a dependent is a disabled.

    Default Value: N

    Prompt Table: GVT_HANDICP_TBL

    26 GVT_DISABILITY_CD Character(2) VARCHAR2(2) NOT NULL Disability Code

    Default Value: 05

    Prompt Table: GVT_HANDICP_TBL

    27 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade

    Prompt Table: %SAL_GRD_PRMPT1

    28 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan

    Default Value: 0000

    Prompt Table: SAL_PLAN_TBL

    29 GVT_CURR_AGCY_EMPL Character(1) VARCHAR2(1) NOT NULL Current Agency Employee

    Y/N Table Edit

    Default Value: N

    30 GVT_CURR_FED_EMPL Character(1) VARCHAR2(1) NOT NULL Current Federal Employee

    Y/N Table Edit

    Default Value: N

    31 GVT_HIGH_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Highest Pay Plan

    Prompt Table: GVT_PAY_PLAN

    32 GVT_HIGH_GRADE Character(3) VARCHAR2(3) NOT NULL Highest Grade

    Prompt Table: %SAL_GRD_PRMPT3

    33 GVT_PREV_AGCY_EMPL Character(1) VARCHAR2(1) NOT NULL Previous Agency Employee

    Y/N Table Edit

    Default Value: N

    34 GVT_PREV_FED_EMPL Character(1) VARCHAR2(1) NOT NULL Previous Federal Employee

    Y/N Table Edit

    Default Value: N

    35 GVT_SEP_INCENTIVE Character(1) VARCHAR2(1) NOT NULL Separation Incentive
    B=Buyout/VSIP
    E=Early Retirement
    O=Other Incentive
    36 GVT_SEP_INCENT_DT Date(10) DATE Separation Incentive Date
    37 GVT_TENURE Character(1) VARCHAR2(1) NOT NULL Highest Career Tenure
    0=None
    1=Permanent
    2=Conditional
    3=Indefinite
    38 GVT_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Pay Plan

    Prompt Table: GVT_PAY_PLAN

    39 BARG_UNIT Character(4) VARCHAR2(4) NOT NULL Bargaining Unit
    1=Bargaining Unit 1
    2=Bargaining Unit 2
    40 LANG_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    CFR=Canadian French
    DAN=Danish
    DUT=Dutch
    ENG=English
    ESP=Spanish
    FRA=French
    GER=German
    GRK=Greek
    INE=International English
    ITA=Italian
    JPN=Japanese
    KOR=Korean
    POR=Portuguese
    SVE=Swedish
    THA=Thai
    ZHS=Simplified Chinese
    ZHT=Traditional Chinese

    Prompt Table: LANGUAGE_CD_VW

    41 YEARS_OF_EXP Number(5,1) DECIMAL(4,1) NOT NULL Years of Work Experience

    Default Value: 0

    42 HRS_REPORT_DEFN_ID Character(12) VARCHAR2(12) NOT NULL The Fusion Publisher Report Definition ID used by Recruiting
    43 HRS_REPORT_TMPL_ID Character(30) VARCHAR2(30) NOT NULL The Fusion publisher Report template ID used by RS.
    44 LETTER_PRINTED_DT Date(10) DATE Date letter was printed
    45 TRAVELLING Character(1) VARCHAR2(1) NOT NULL Willing to Travel

    Y/N Table Edit

    Default Value: N

    46 RELOCATE Character(1) VARCHAR2(1) NOT NULL Willing to Relocate

    Y/N Table Edit

    Default Value: N

    47 UNION_CD Character(3) VARCHAR2(3) NOT NULL Union Code
    48 DESIRED_HOURS Number(4,1) DECIMAL(3,1) NOT NULL Desired Hours Per Week
    49 MIN_RATE Number(19,6) DECIMAL(18,6) NOT NULL Minimum Acceptable Pay Rate
    50 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    51 PAY_FREQ_ABBRV Character(1) VARCHAR2(1) NOT NULL Pay Frequency
    A=Annual
    B=Bi-weeky
    H=Hour
    M=Month
    Y=Year
    52 DESIRED_START_DT Date(10) DATE Desired Start Date
    53 DESIRED_FULL_PART Character(1) VARCHAR2(1) NOT NULL Full/Part-Time
    E=Either
    F=Full-Time
    P=Part-Time
    54 DESIRED_REG_TEMP Character(1) VARCHAR2(1) NOT NULL Regular/Temporary
    E=Either
    R=Regular
    T=Temporary
    55 DESIRED_SHIFT Character(1) VARCHAR2(1) NOT NULL Desired Shift
    1=1
    2=2
    3=3
    A=Any
    C=Compressed
    N=Not Applicable
    R=Rotating
    56 MON Character(1) VARCHAR2(1) NOT NULL Monday

    Default Value: Y

    57 TUES Character(1) VARCHAR2(1) NOT NULL Tuesday

    Default Value: Y

    58 WED Character(1) VARCHAR2(1) NOT NULL Wednesday

    Default Value: Y

    59 THURS Character(1) VARCHAR2(1) NOT NULL Thursday

    Default Value: Y

    60 FRI Character(1) VARCHAR2(1) NOT NULL Friday

    Default Value: Y

    61 SAT Character(1) VARCHAR2(1) NOT NULL Saturday
    62 SUN Character(1) VARCHAR2(1) NOT NULL Sunday
    63 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT

    Prompt Table: HRS_BS_UNT_HR_I

    64 HRS_DES_LOC1 Number(15,0) DECIMAL(15) NOT NULL Desired Location 1

    Prompt Table: HRS_LOC_I

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

    Prompt Table: HRS_LOC_I

    66 HRS_TRAVEL_PERCENT Character(1) VARCHAR2(1) NOT NULL Travel percent
    0=None
    1=<= 25%
    2=26 - 50 %
    3=51 - 75 %
    4=76 - 100 %
    67 PREV_EMPL_BY_COMPY Character(1) VARCHAR2(1) NOT NULL Previously Employed by Company
    68 PREV_TERM_DT Date(10) DATE Previous Termination Date
    69 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    70 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    71 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    72 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id
    73 GEOG_PREFER Long Character CLOB Geographic Preference