MILIT_SITN_FRA(SQL Table) |
Index Back |
|---|---|
Military Situation - FRAThis table is used to track the military situation of an employee. |
| # | 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 |
| 4 | END_DT_FRA | Date(10) | DATE | End Date |
| 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 th 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 | Notitfy 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 |