HRS_APP_ITA_I

(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 HRS_PERSON_ID ,EFFDT ,END_EFFDT ,%subrec(PERS_DTITA_SBR,A) FROM PS_HRS_APP_ITA A

  • 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_ITA Character(1) VARCHAR2(1) NOT NULL Military Status Italy
    C=Completed
    E=Exempt
    M=Mandatory
    R=Revisited
    5 MILITARY_TYPE_ITA Character(2) VARCHAR2(2) NOT NULL Type of Service
    AE=Airforce
    CA=Carabinieri
    CI=Civil Service
    M=Military
    MA=Navy
    6 MILITARY_RANK_ITA Character(50) VARCHAR2(50) NOT NULL Function or Rank
    7 MILITARY_END_ITA Date(10) DATE Military End Date