!!!Alias:HHR Unique Keys: [RCA_ID] (Candidate) + [HEALTH_AS_OF_DATE]\\ Parent Table: [P2K_RE_CANDIDATES]\\ \\ This table contains health records for an employee or a candidate. !!Table Columns ||Column name||Data Type / Size||Domain||Mand.||Notes |[ID]|Number(10)|[ID]|Y| |[RCA_ID]|Number(10)|[ID]|Y|For [P2K_RE_CANDIDATES] |[ECT_ID]|Number(10)|[ID]|Id|Family Doctor is [P2K_HR_CONTACTS] |[HEALTH_AS_OF_DATE]|Date()|[DATE]|Y| |[HEALTH_STATUS]|Varchar2(2)|[X_HEALTH_STATUS]|Y| |[BLOOD_TYPE]|Varchar2(2)|[X_BLOOD_TYPE]| | |[BLOOD_DONOR]|Varchar2(1)|[TOGGLE]| | |[SMOKER]|Varchar2(1)|[TOGGLE]| | |[STATE_OF_HEALTH]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| | |[WEIGHT]|Varchar2(16)|[VARCHAR16|VARCHARnn]| | |[HEIGHT]|Varchar2(16)|[VARCHAR16|VARCHARnn]| | |[EYE_SIGHT]|Varchar2(16)|[VARCHAR16|VARCHARnn]| | |[HEARING]|Varchar2(16)|[VARCHAR16|VARCHARnn]| | |[POSTURE]|Varchar2(16)|[VARCHAR16|VARCHARnn]| | |[BLOOD_PRESSURE]|Varchar2(16)|[VARCHAR16|VARCHARnn]| | |[ALLERGY_LIST]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| | |[INSURANCE_NUMBER]|Varchar2(16)|[VARCHAR16|VARCHARnn]| | |[HEALTH_CARE_NUMBER]|Varchar2(16)|[VARCHAR16|VARCHARnn]| | |[WC_CLEARANCE_OBTAINED]|Varchar2(1)|[TOGGLE]| | |[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\\