!!!Alias: HME Unique Keys: \\ Child Table: \\ Parent Table: \\ \\ This table contains medical examination data for employees and candidates. !!Table Columns ||Column name||Data Type / Size||Domain||Mand.||Notes |[ID]|Number(10)|[ID]|Y| |[DEN_ID]|Number(10)|[ID]|Y|Link to [P2K_CM_ENTITIES] |[HHI_ID]|Number(10)|[ID]| |Link to [P2K_SH_HEALTH_ISSUES] |[RCA_ID]|Number(10)|[ID]|Y|Link to [P2K_RE_CANDIDATES] |[HTP_ID]|Number(10)|[ID]|Y|Link to [P2K_SH_MEDICAL_EXAM_TYPES] |[ECT_ID]|Number(10)|[ID]| |Link to [P2K_HR_CONTACTS] |[ECT_ID_CONDUCTED_IN]|Number(10)|[ID]| |Link to [P2K_HR_CONTACTS] |[MEDICAL_EXAM_DATE]|Date()|[DATE]|Y| |[MEDICAL_EXAM_STATUS]|Varchar2(2)|[X_MEDIAL_EXAM_STATUS]|Y| |[DESCRIPTION]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| | |[AUTHORIZED]|Varchar2(1)|[TOGGLE]| | |[HOSPITALIZED]|Varchar2(1)|[TOGGLE]| | |[TREATMENT_SOURCE]|Varchar2(2)|[X_TREATMENT_SOURCE]| | |[MEDICAL_EXAM_REASON]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| | |[MEDICAL_EXAM_RESULTS]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| | |[NEXT_MEDICAL_EXAM_DATE]|Date()|[DATE]| | |[CREATE_DATE]|Date()|[DATE]|Y| |[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[CHANGE_DATE]|Date()|[DATE]|Y| |[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| User Fields: Allowed\\ Audit Logging: Allowed\\