APPL_DATA_CURR

(SQL View)
 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).

SELECT APPLID , %subrec(NAMEGBL_SBR, A) , %subrec(ADDRESS_SBR, A) , %subrec(ADDR_OTR_SBR, A) , A.ADDRESS1_AC , A.ADDRESS2_AC , A.ADDRESS3_AC , A.CITY_AC , A.AGE_STATUS , A.MAR_STATUS , A.MAR_STATUS_DT , %subrec(PERS_DTCAN_SBR,A) , %subrec(PERS_DTCHE_SBR,A) , %subrec(PERS_DTESP_SBR,A) , %subrec(PERS_DTFRA_SBR,A) , %subrec(PERS_DTGER_SBR,A) , %subrec(PERS_DTITA_SBR,A) , %subrec(PERS_DTJPN_SBR,A) , %subrec(PERS_DTUSA_SBR,A) , %subrec(FO_APP_EFF_SBR,A) FROM %Table(APPL_DATA_EFFDT) A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_APPL_DATA_EFFDT B WHERE B.APPLID = A.APPLID AND B.EFFDT <= %CurrentDateIn)

  • 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 COUNTRY_NM_FORMAT Character(3) VARCHAR2(3) NOT NULL Format for Country

    Prompt Table: COUNTRY_TBL

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

    Prompt Table: NAME_PREFIX_TBL

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

    Prompt Table: NAME_SUFFIX_TBL

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

    Prompt Table: COUNTRY_TBL

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

    Prompt Table: %EDIT_STATE

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

    Y/N Table Edit

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

    Prompt Table: COUNTRY_TBL

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

    Prompt Table: %EDIT_STATE_OTH

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

    Y/N Table Edit

    58 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
    59 MAR_STATUS_DT Date(10) DATE Marital Status Date
    60 BILINGUALISM_CODE Character(1) VARCHAR2(1) NOT NULL Bilingualism Code
    1=Not Bilingual
    2=Bilingual
    3=Receptive Skills Only
    9=Unknown
    61 HEALTH_CARE_NBR Character(12) VARCHAR2(12) NOT NULL Health Care Number
    62 HEALTH_CARE_STATE Character(6) VARCHAR2(6) NOT NULL Health Care Province
    63 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
    64 MILIT_SITUATN_ESP Character(3) VARCHAR2(3) NOT NULL Military Status
    65 SOC_SEC_AFF_DT Date(10) DATE Social Security Affilation Dt
    66 ENTRY_DT_FRA Date(10) DATE Date of First Entry in France
    67 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
    68 CPAMID Character(6) VARCHAR2(6) NOT NULL CPAM ID
    69 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
    70 EXPCTD_MILITARY_DT Date(10) DATE Expected Military Date
    71 HR_RESPONSIBLE_ID Character(11) VARCHAR2(11) NOT NULL HR Responsible ID

    Prompt Table: PERSONAL_DATA

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

    Y/N Table Edit

    Default Value: Y

    78 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

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

    Y/N Table Edit

    Default Value: N

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