HRS_APPLICANT

(SQL Table)
 Index Back

Search Vw-Applicant/EE

The APPLICANT_DATA view is a search record used in Recruitment to access applicant records (employees and outside applicants).

  • Parent Record Of HRS_APPADDR_WRK HRS_APPVPLN_HST HRS_APP_ACMRQST HRS_APP_ADDRESS HRS_APP_ADDR_I HRS_APP_ADD_HST HRS_APP_ATTACH HRS_APP_BNKACCT HRS_APP_CAN HRS_APP_CAN_I HRS_APP_CHE HRS_APP_CITSHIP HRS_APP_CNTRACT HRS_APP_CNTRC_I HRS_APP_CTR_HST HRS_APP_DIS_AUD HRS_APP_DIV HRS_APP_DIV_HST HRS_APP_DIV_I HRS_APP_EDT_WRK HRS_APP_EFFDT HRS_APP_EFFDT_I HRS_APP_EFF_WRK HRS_APP_EMAIL HRS_APP_EMAIL_I HRS_APP_ESP HRS_APP_ESP_HST HRS_APP_ESP_I HRS_APP_E_PHONE HRS_APP_FRA HRS_APP_FRA_HST HRS_APP_FRA_I HRS_APP_GER HRS_APP_GER_HST HRS_APP_GER_I HRS_APP_ITA HRS_APP_ITA_HST HRS_APP_ITA_I HRS_APP_JPN HRS_APP_JPN_HST HRS_APP_JPN_I HRS_APP_NAMES HRS_APP_NAT_GER HRS_APP_NID HRS_APP_NID_HST HRS_APP_NID_I HRS_APP_NO_STS HRS_APP_ORIG_CH HRS_APP_PHONE HRS_APP_PHONE_I HRS_APP_PROFILE HRS_APP_PROF_I HRS_APP_PRO_TAO HRS_APP_RTE2_VW HRS_APP_STS HRS_APP_STS_HST HRS_APP_STS_VW HRS_APP_TRAIN HRS_APP_USA HRS_APP_USA_HST HRS_APP_USA_I HRS_APP_USA_WRK HRS_APP_VPM_LNG HRS_APP_VP_LN_I HRS_APP_VSADT_I HRS_APP_VSA_DAT HRS_APP_VS_DA_I HRS_APP_VS_DA_W HRS_DIV_HST HRS_DUP_APP_SET HRS_EFFDT_HST HRS_EMAIL_HST HRS_HIRE_APPESP HRS_HIRE_APPFRA HRS_HIRE_APPGER HRS_HIRE_APPITA HRS_HIRE_APPJPN HRS_HIRE_APPUSA HRS_HIRE_AP_DIV HRS_HIRE_CNTRC HRS_HIRE_CTYPE HRS_HIRE_NID HRS_HIRE_NT_GER HRS_HIRE_ORG_CH HRS_HIRE_PHONE HRS_NAMES_HST HRS_NAT_GER_HST HRS_NAT_GER_WRK HRS_ORIG_CH_HST HRS_PHONE_HST HRS_PROFILE_HST HRS_PROF_SEC_VW HRS_PROF_TAO HRS_RCMNT HRS_RCMNT_CNTJO HRS_RCMNT_HST HRS_TRAIN_HST HRS_VSA_DAT_HST UPG_PROF_TAO

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    2 APPLID Character(11) VARCHAR2(11) NOT NULL External Job Applicant ID
    3 APP_PER_STATUS Character(1) VARCHAR2(1) NOT NULL Identifies the type of applicant - External Applicant, Employee or Non-Employee
    A=External Applicant
    E=Employee
    N=Non-Employee

    Default Value: A

    4 SEX Character(1) VARCHAR2(1) NOT NULL Gender
    F=Female
    M=Male
    U=Unknown
    X=Indeterminate/Intersex/Unspec

    Default Value: U

    5 BIRTHDATE Date(10) DATE Date of Birth
    6 BIRTHPLACE Character(30) VARCHAR2(30) NOT NULL Birth Location
    7 BIRTHCOUNTRY Character(3) VARCHAR2(3) NOT NULL Birth Country

    Prompt Table: BIRTHCOUNTRY_VW

    8 BIRTHSTATE Character(6) VARCHAR2(6) NOT NULL Birth State

    Prompt Table: BIRTHSTATE_VW

    9 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: HRS_PERSON_NM_I

    10 HRS_APP_PREF_CONT Character(1) VARCHAR2(1) NOT NULL Preferred Method of Contact
    E=EMail
    M=Mail
    N=Not Specified
    P=Phone

    Default Value: N

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

    Prompt Table: HRS_STS_APP_I

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

    Prompt Table: HRS_RSN_APP_I

    13 STATUS_DT Date(10) DATE Status Date

    Default Value: %date

    14 HRS_EXT_TRN Character(1) VARCHAR2(1) NOT NULL Applicant - External Trainee Flag

    Default Value: N

    15 POI_TYPE Character(5) VARCHAR2(5) NOT NULL Defines the Transactional usage of POIs in HRMS.

    Default Value: 00000

    16 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    17 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    18 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    19 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id