!!!Alias: EMT
(P2K_HR_MILITARIES)

Unique Keys: ___\\
Child Table: ___\\
Parent Table: ___\\
\\
Provides a military history for any given identity

!!Table Columns
\\
||Column name||Data Type / Size||Domain||Mand.||Notes
|[ID]|Number(10)|[ID]|Y|
|[EID_ID]|Number(10)|[ID]|Y|link to [P2K_HR_IDENTITIES]
|[MILITARY_BRANCH]|Varchar2(2)|[X_MILITARY_BRANCH]|Y|
|[ENLISTED_DATE]|Date()|[DATE]|Y|
|[CREATE_DATE]|Date()|[DATE]|Y|
|[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[CHANGE_DATE]|Date()|[DATE]|Y|
|[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[DESCRIPTION]|Varchar2(50)|[DESCRIPTION]| |
|[MILITARY_STATUS]|Varchar2(2)|[X_MILITARY_STATUS]| |
|[MILITARY_RANK]|Varchar2(2)|[X_MILITARY_RANK]| |
|[DISCHARGED_DATE]|Date()|[DATE]| |
|[DISCHARGE_TYPE]|Varchar2(2)|[X_MILITARY_DISCH_TYPE]| |
|[SECURITY_CLEARANCE]|Varchar2(2)|[X_SECURITY_CLEARANCE]| |

User Fields: Allowed\\
Audit Logging: Allowed\\