Alias: EMT#

(P2K_HR_MILITARIES)

Unique Keys: _
Child Table:
_
Parent Table: _

Provides a military history for any given identity

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
EID_IDNumber(10)IDYlink to P2K_HR_IDENTITIES
MILITARY_BRANCHVarchar2(2)X_MILITARY_BRANCHY
ENLISTED_DATEDate()DATEY
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
DESCRIPTIONVarchar2(50)DESCRIPTION
MILITARY_STATUSVarchar2(2)X_MILITARY_STATUS
MILITARY_RANKVarchar2(2)X_MILITARY_RANK
DISCHARGED_DATEDate()DATE
DISCHARGE_TYPEVarchar2(2)X_MILITARY_DISCH_TYPE
SECURITY_CLEARANCEVarchar2(2)X_SECURITY_CLEARANCE

User Fields: Allowed
Audit Logging: Allowed