HRS_APP_USA_HST

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

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
    2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
    3 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    4 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    5 END_EFFDT Date(10) DATE End Effdt
    6 US_WORK_ELIGIBILTY Character(1) VARCHAR2(1) NOT NULL Eligible to Work in U.S.

    Y/N Table Edit

    7 MILITARY_STATUS Character(1) VARCHAR2(1) NOT NULL Veteran Status / Military Status
    1=Not indicated
    2=No Military Service
    3=Veteran of the Vietnam Era
    4=Active Duty/Campaign Badge Vet
    4=Other Protected Veteran
    5=Active Reserve
    6=Inactive Reserve
    7=Retired Military
    8=Veteran (VA Ineligible)
    9=Vietnam & Active Duty Vet
    9=Vietnam & Other Protected Vet
    A=Armed Forces Service Medal Vet
    B=Pre-Vietnam-Era Veteran
    C=Separated/Srvc Medal/Active
    C=Separated/Srvc Medal/Other Vet
    D=Protected, Not Classified
    N=Not a Vietnam-Era Veteran
    O=Service Medal & Active Duty
    O=Service Medal & Other Vet
    P=Post-Vietnam-Era Veteran
    R=Recently Separated Veteran
    S=Separated & Service Medal Vet
    T=Separated & Active Duty Vet
    T=Separated & Other Vet
    V=Vietnam-Era Veteran
    X=Not a Veteran
    X=Not a Veteran
    Z=Not a Protected Veteran

    Default Value: 1

    8 CITIZEN_PROOF1 Character(10) VARCHAR2(10) NOT NULL Citizenship (Proof 1)
    9 CITIZEN_PROOF2 Character(10) VARCHAR2(10) NOT NULL Citizenship (Proof 2)
    10 SMOKER Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) an employee or dependent is a smoker.
    N=Non Smoker
    Y=Smoker

    Y/N Table Edit

    Default Value: N

    11 MEDICARE_ENTLD_DT Date(10) DATE Date Entitled to Medicare
    12 SMOKER_DT Date(10) DATE Smoker Date