APPL_DATA_EFFDT

(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: APPLICANT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 APPLID Character(11) VARCHAR2(11) NOT NULL External Job Applicant ID
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 COUNTRY_NM_FORMAT Character(3) VARCHAR2(3) NOT NULL Format for Country

    Prompt Table: COUNTRY_TBL

    4 NAME Character(50) VARCHAR2(50) NOT NULL Name
    5 NAME_INITIALS Character(6) VARCHAR2(6) NOT NULL Name Initials
    6 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix
    1=Mr.
    2=Mrs.
    3=Ms.

    Prompt Table: NAME_PREFIX_TBL

    7 NAME_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Suffix

    Prompt Table: NAME_SUFFIX_TBL

    8 NAME_ROYAL_PREFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Prefix
    9 NAME_ROYAL_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Suffix
    10 NAME_TITLE Character(30) VARCHAR2(30) NOT NULL Title
    11 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
    12 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
    13 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    14 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
    15 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL Middle Name
    16 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last Name
    17 SECOND_LAST_SRCH Character(30) VARCHAR2(30) NOT NULL Second Name
    18 NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name
    19 PREF_FIRST_NAME Character(30) VARCHAR2(30) NOT NULL Preferred First Name
    20 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    21 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    22 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    23 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    24 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    25 CITY Character(30) VARCHAR2(30) NOT NULL City
    26 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    27 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    28 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat
    WW=Trailer
    29 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    30 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    31 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    32 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    33 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: %EDIT_STATE

    34 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    35 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    36 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    37 COUNTRY_OTHER Character(3) VARCHAR2(3) NOT NULL Country field for ADDR_OTR_SBR and DERIVED_ADDR_OT

    Prompt Table: COUNTRY_TBL

    38 ADDRESS1_OTHER Character(55) VARCHAR2(55) NOT NULL Address 1 Other
    39 ADDRESS2_OTHER Character(55) VARCHAR2(55) NOT NULL Address 2 Other
    40 ADDRESS3_OTHER Character(55) VARCHAR2(55) NOT NULL Address 3 Other
    41 ADDRESS4_OTHER Character(55) VARCHAR2(55) NOT NULL Address 4 Other
    42 CITY_OTHER Character(30) VARCHAR2(30) NOT NULL City Other
    43 COUNTY_OTHER Character(30) VARCHAR2(30) NOT NULL County Other
    44 STATE_OTHER Character(6) VARCHAR2(6) NOT NULL State Other

    Prompt Table: %EDIT_STATE_OTH

    45 POSTAL_OTHER Character(12) VARCHAR2(12) NOT NULL Postal Other
    46 NUM1_OTHER Character(6) VARCHAR2(6) NOT NULL Number 1 Other
    47 NUM2_OTHER Character(6) VARCHAR2(6) NOT NULL Number 2 Other
    48 HOUSE_TYPE_OTHER Character(2) VARCHAR2(2) NOT NULL House Type Other
    AB=House Boat Reference
    WW=House Trailer Reference
    49 ADDR_FIELD1_OTHER Character(2) VARCHAR2(2) NOT NULL Address Field 1 Other
    50 ADDR_FIELD2_OTHER Character(4) VARCHAR2(4) NOT NULL Address Field 2 Other
    51 ADDR_FIELD3_OTHER Character(4) VARCHAR2(4) NOT NULL Address Field 3 Other
    52 IN_CITY_LMT_OTHER Character(1) VARCHAR2(1) NOT NULL In City Limit Other
    53 GEO_CODE_OTHER Character(11) VARCHAR2(11) NOT NULL Geo Code Other
    54 ADDRESS1_AC Character(55) VARCHAR2(55) NOT NULL Alternate Character Address 1
    55 ADDRESS2_AC Character(55) VARCHAR2(55) NOT NULL Alternate Character Address 2
    56 ADDRESS3_AC Character(55) VARCHAR2(55) NOT NULL Alternate Character Address 3
    57 CITY_AC Character(30) VARCHAR2(30) NOT NULL Alternate Character City
    58 AGE_STATUS Character(1) VARCHAR2(1) NOT NULL Age 18 or Older

    Y/N Table Edit

    Default Value: Y

    59 MAR_STATUS Character(1) VARCHAR2(1) NOT NULL Marital Status
    C=Common-Law
    D=Divorced
    E=Separated
    H=Head of Household
    M=Married
    S=Single
    U=Unknown
    W=Widowed

    Default Value: U

    60 MAR_STATUS_DT Date(10) DATE Marital Status Date
    61 BILINGUALISM_CODE Character(1) VARCHAR2(1) NOT NULL Bilingualism Code
    1=Not Bilingual
    2=Bilingual
    3=Receptive Skills Only
    9=Unknown
    62 HEALTH_CARE_NBR Character(12) VARCHAR2(12) NOT NULL Health Care Number
    63 HEALTH_CARE_STATE Character(6) VARCHAR2(6) NOT NULL Health Care Province
    64 GUARDIAN_CHE Character(40) VARCHAR2(40) NOT NULL In Switzerland, it is a requirement for an employee who is 18 years of age or younger to have a guardian on record
    65 MILIT_SITUATN_ESP Character(3) VARCHAR2(3) NOT NULL Military Status
    66 SOC_SEC_AFF_DT Date(10) DATE Social Security Affilation Dt
    67 ENTRY_DT_FRA Date(10) DATE Date of First Entry in France
    68 MILIT_SITUATN_FRA Character(3) VARCHAR2(3) NOT NULL Military Status
    APA=No Country Person
    BEN=Asile Right
    DEG=Military Service Done
    ETR=Alien
    REF=Reformed (don't do milit serv)
    SER=Military Service to Come
    SUR=Military Service Delayed
    69 CPAMID Character(6) VARCHAR2(6) NOT NULL CPAM ID
    70 MILITARY_STAT_GER Character(1) VARCHAR2(1) NOT NULL Military Status
    1=Service Completed
    2=Exempt from Service
    3=Not Applicable
    4=Mandatory
    5=No Information
    71 EXPCTD_MILITARY_DT Date(10) DATE Expected Military Date
    72 HR_RESPONSIBLE_ID Character(11) VARCHAR2(11) NOT NULL HR Responsible ID

    Prompt Table: PERSONAL_DATA

    73 MILITARY_STAT_ITA Character(1) VARCHAR2(1) NOT NULL Military Status Italy
    74 MILITARY_TYPE_ITA Character(2) VARCHAR2(2) NOT NULL Type of Service
    75 MILITARY_RANK_ITA Character(50) VARCHAR2(50) NOT NULL Function or Rank
    76 MILITARY_END_ITA Date(10) DATE Military End Date
    77 HONSEKI_JPN Character(2) VARCHAR2(2) NOT NULL Honseki Prefecture
    78 US_WORK_ELIGIBILTY Character(1) VARCHAR2(1) NOT NULL Eligible to Work in U.S.

    Y/N Table Edit

    Default Value: Y

    79 MILITARY_STATUS Character(1) VARCHAR2(1) NOT NULL Military Status
    1=Not Indicated
    2=No Military Service
    3=Veteran of the Vietnam Era
    4=Other Protected Veteran
    5=Active Reserve
    6=Inactive Reserve
    7=Retired Military
    8=Veteran (VA Ineligible)
    9=Vietnam & Other Protected Vet
    B=Pre-Vietnam-Era Veteran
    N=Not a Vietnam-Era Veteran
    P=Post-Vietnam-Era Veteran
    V=Vietnam-Era Veteran
    X=Not a Veteran

    Default Value: 1

    80 CITIZEN_PROOF1 Character(10) VARCHAR2(10) NOT NULL Citizenship (Proof 1)
    81 CITIZEN_PROOF2 Character(10) VARCHAR2(10) NOT NULL Citizenship (Proof 2)
    82 SMOKER Character(1) VARCHAR2(1) NOT NULL Smoker

    Y/N Table Edit

    Default Value: N

    83 MEDICARE_ENTLD_DT Date(10) DATE Date Entitled to Medicare
    84 HIGHEST_EDUC_LVL Character(2) VARCHAR2(2) NOT NULL Highest Education Level