Alias: IVEMT#
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.Table Columns#
| Column name | Data Type / Size | Domain | Mand. | Notes |
|---|---|---|---|---|
| ID | Number(10) | ID | ||
| PERSON_CODE | Varchar2(16) | CODE | Y | |
| MILITARY_BRANCH | Varchar2(30) | VARCHAR30 | Y | |
| ENLISTED_DATE | Date() | DATE | Y | |
| DESCRIPTION | Varchar2(50) | DESCRIPTION | ||
| MILITARY_STATUS | Varchar2(30) | VARCHAR30 | ||
| MILITARY_RANK | Varchar2(30) | VARCHAR30 | ||
| DISCHARGED_DATE | Date() | DATE | ||
| DISCHARGE_TYPE | Varchar2(30) | VARCHAR30 | ||
| SECURITY_CLEARANCE | Varchar2(30) | VARCHAR30 | ||
| CREATE_DATE | Date() | DATE | ||
| CREATE_USER | Varchar2(30) | VARCHAR30 | ||
| CHANGE_DATE | Date() | DATE | ||
| CHANGE_USER | Varchar2(30) | VARCHAR30 |
