HRS_APP_GER

(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 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 END_EFFDT Date(10) DATE End Effdt
    4 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
    5 EXPCTD_MILITARY_DT Date(10) DATE Expected Military Date
    6 HR_RESPONSIBLE_ID Character(11) VARCHAR2(11) NOT NULL HR Responsible ID

    Prompt Table: PERSON_NAME