HRS_APP_FRA_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_DTFRA_SBR,A) FROM PS_HRS_APP_FRA 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 ENTRY_DT_FRA Date(10) DATE Date of First Entry in France
    5 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
    6 CPAMID Character(6) VARCHAR2(6) NOT NULL CPAM ID

    Prompt Table: CPAM_TBL