MILIT_SITN_FRA

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	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
3	BEGIN_DT_FRA	Date(10)	DATE	Begin Date France
4	END_DT_FRA	Date(10)	DATE	End Date France
5	MILIT_SECT_FRA	Character(3)	VARCHAR2(3) NOT NULL	Arm AIR=The Air Force MAR=The Navy TER=The Army
6	MILIT_RANK_FRA	Character(3)	VARCHAR2(3) NOT NULL	Rank ADJ=Warrant Officer COL=Colonel SRG=Sergent
7	FUNCTION_FRA	Character(15)	VARCHAR2(15) NOT NULL	Position
8	MILIT_NBR_FRA	Character(10)	VARCHAR2(10) NOT NULL	Military Number
9	MILIT_SECT_RES_FRA	Character(3)	VARCHAR2(3) NOT NULL	Arm in the Reserve AIR=The Air Force MAR=The Navy TER=The Army
10	RESERVE_RANK_FRA	Character(3)	VARCHAR2(3) NOT NULL	Rank in the Reserve ADR=Warrant Officer CLR=Colonel SGR=Sergent
11	MILIT_FUNCTION_FRA	Character(40)	VARCHAR2(40) NOT NULL	Position in the Reserve
12	MILIT_ASGN_FRA	Character(1)	VARCHAR2(1) NOT NULL	Type of Appointment (Reserve) I=Individual Appointment M=Military Appointment N=None Default Value: M
13	INDIV_FUNCTION_FRA	Character(40)	VARCHAR2(40) NOT NULL	Individual Position (Reserve)
14	NOTIF_BY_MILIT_FRA	Character(40)	VARCHAR2(40) NOT NULL	Notify by Military Reserve
15	MILIT_NOTIF_DT_FRA	Date(10)	DATE	Date of Military Notification
16	NOTIF_BY_INDIV_FRA	Character(40)	VARCHAR2(40) NOT NULL	Notify by Individual Reserve
17	INDIV_NOTIF_DT_FRA	Date(10)	DATE	Date of Indiv. Notification