INF_CV_MILITARIES
Back to current versionRestore this version

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 nameData Type / SizeDomainMand.Notes
IDNumber(10)ID
PERSON_CODEVarchar2(16)CODEY
MILITARY_BRANCHVarchar2(30)VARCHAR30Y
ENLISTED_DATEDate()DATEY
DESCRIPTIONVarchar2(50)DESCRIPTION
MILITARY_STATUSVarchar2(30)VARCHAR30
MILITARY_RANKVarchar2(30)VARCHAR30
DISCHARGED_DATEDate()DATE
DISCHARGE_TYPEVarchar2(30)VARCHAR30
SECURITY_CLEARANCEVarchar2(30)VARCHAR30
CREATE_DATEDate()DATE
CREATE_USERVarchar2(30)VARCHAR30
CHANGE_DATEDate()DATE
CHANGE_USERVarchar2(30)VARCHAR30