Alias: IVEMT#
(INF_CV_MILITARIES)The INF_CV_MILITARIES table is used to import employee military records into the software data structures. This table is used for employees who have performed prior military service or have current military commitments.
Tables loaded: P2K_HR_MILITARIES
- Enlisted as of
- This field shows the date the employee was enlisted or commissioned. Enlisted_Date is a mandatory date field.
- Branch
- This field displays the branch of the military in which an employee has service.
- Army
- Navy
- Airforce
- Marines
- Military_Branch is a mandatory fixed lexicon (X_MILITARY_BRANCH).
- Description
- Description is used to specify rank, occupation or specialization information for the employee. Description is a 50-character alphanumeric optional field.
- Rank
- This field indicates whether the employee was enlisted or commissioned in a service branch.
- Army - Enlisted Airforce – Enlisted
- Army – Commissioned Airforce – Commissioned
- Navy – Enlisted Marine – Enlisted
- Navy – Commissioned Marine – Commissioned
- Military_Rank is an optional fixed lexicon (X_MILITARY_RANK).
- Status
- This field indicates current military status (i.e. Active Reserve).
- Not Specified National Guard
- Active Reserve Inactive Reserve
- Suppl. Reserve Retired
- Military_Status is an optional fixed lexicon (X_MILITARY_STATUS).
- Security Clearance
- This field displays the level of security clearance the employee received. Security_Clearance is an optional fixed lexicon (X_SECURITY_CLEARANCE).
- Discharged on
- This is the date the employee was discharged. Discharged_Date is an optional date field.
- Discharge Type
- This field displays the type of discharge from military service the employee received.
- Not Discharged
- Medical Honorable
- Disciplinary
- Discharge_Type is an optional fixed lexicon (X_MILITARY_DISCH_TYPE).
