Alias: IVEMT#

(INF_CV_MILITARIES)
Provides a military history for any given identity

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