Alias:HHR#
(P2K_SH_HEALTH_RECORDS)Unique Keys: RCA_ID (Candidate) + HEALTH_AS_OF_DATE
Parent Table: P2K_RE_CANDIDATES
ERD: ERD-SH50
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 | ||
| WEIGHT | Varchar2(16) | VARCHAR16 | ||
| HEIGHT | Varchar2(16) | VARCHAR16 | ||
| EYE_SIGHT | Varchar2(16) | VARCHAR16 | ||
| HEARING | Varchar2(16) | VARCHAR16 | ||
| POSTURE | Varchar2(16) | VARCHAR16 | ||
| BLOOD_PRESSURE | Varchar2(16) | VARCHAR16 | ||
| ALLERGY_LIST | Varchar2(4000) | VARCHAR4000 | ||
| INSURANCE_NUMBER | Varchar2(16) | VARCHAR16 | ||
| HEALTH_CARE_NUMBER | Varchar2(16) | VARCHAR16 | ||
| WC_CLEARANCE_OBTAINED | Varchar2(1) | TOGGLE | ||
| CREATE_DATE | Date() | DATE | Y | |
| CREATE_USER | Varchar2(30) | VARCHAR30 | Y | |
| CHANGE_DATE | Date() | DATE | Y | |
| CHANGE_USER | Varchar2(30) | VARCHAR30 | Y |
User Fields: Allowed
Audit Logging: Allowed
