HRS_HIRE_APPFRA (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).

HRS_HIRE_APPFRA

(SQL View)

Search Vw-Applicant/EE

The APPLICANT_DATA view is a search record used in Recruitment to access applicant records (employees and outside applicants).

SELECT A.HRS_PERSON_ID , %subrec(PERS_DTFRA_SBR, A) FROM PS_HRS_APP_FRA A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_HRS_APP_FRA B WHERE B.HRS_PERSON_ID = A.HRS_PERSON_ID AND B.EFFDT <= %CurrentDateIn)

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 ENTRY_DT_FRA Date(10) DATE Date of First Entry in France

3 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

4 CPAMID Character(6) VARCHAR2(6) NOT NULL CPAM ID
Prompt Table: CPAM_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HRS_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	Person Id
2	ENTRY_DT_FRA	Date(10)	DATE	Date of First Entry in France
3	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
4	CPAMID	Character(6)	VARCHAR2(6) NOT NULL	CPAM ID Prompt Table: CPAM_TBL