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 APPL_DATA_CURR APPL_DATA_EFFDT EDUC_AREA_STUDY FO_APP_ACCOMPS FO_APP_CM_EVALS FO_APP_EDU_VW FO_APP_ED_AREA FO_APP_EMAIL_AD FO_APP_HON_VW FO_APP_JOB_DATA FO_APP_LANG_VW FO_APP_LIC_VW FO_APP_MEM_VW FO_APP_NID FO_APP_PHONE FO_APP_PREF_PHN FO_APP_PRF_EML FO_APP_PRIWRK FO_APP_REF FO_APP_RESUME FO_APP_TEST_VW FO_EMP_EDU_VW FO_EMP_HON_VW FO_EMP_LANG_VW FO_EMP_LIC_VW FO_EMP_MEM_VW FO_EMP_PRIWRK FO_EMP_REF FO_EMP_TEST_VW FO_PNDG_ORD_TBL

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

    Default Value: A

    3 SEX Character(1) VARCHAR2(1) NOT NULL Gender
    F=Female
    M=Male
    U=Unknown
    4 BIRTHDATE Date(10) DATE Date of Birth
    5 BIRTHPLACE Character(30) VARCHAR2(30) NOT NULL Birth Location
    6 BIRTHCOUNTRY Character(3) VARCHAR2(3) NOT NULL Birth Country

    Prompt Table: COUNTRY_TBL

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

    Prompt Table: STATE_TBL

    8 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    9 APP_STATUS_CODE Character(1) VARCHAR2(1) NOT NULL Status Code
    A=Active
    D=Hired
    H=Hire Pending
    I=Applicant Invalid
    P=Applicant Pending
    10 STATUS_REASON Character(3) VARCHAR2(3) NOT NULL Identifies a reason associated with a particular status.
    11 STATUS_DT Date(10) DATE Status Date

    Default Value: %date