P 2 K_SH_HEALTH_RECORDS

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 nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
RCA_IDNumber(10)IDYFor P2K_RE_CANDIDATES
ECT_IDNumber(10)IDIdFamily Doctor is P2K_HR_CONTACTS
HEALTH_AS_OF_DATEDate()DATEY
HEALTH_STATUSVarchar2(2)X_HEALTH_STATUSY
BLOOD_TYPEVarchar2(2)X_BLOOD_TYPE
BLOOD_DONORVarchar2(1)TOGGLE
SMOKERVarchar2(1)TOGGLE
STATE_OF_HEALTHVarchar2(4000)VARCHAR4000
WEIGHTVarchar2(16)VARCHAR16
HEIGHTVarchar2(16)VARCHAR16
EYE_SIGHTVarchar2(16)VARCHAR16
HEARINGVarchar2(16)VARCHAR16
POSTUREVarchar2(16)VARCHAR16
BLOOD_PRESSUREVarchar2(16)VARCHAR16
ALLERGY_LISTVarchar2(4000)VARCHAR4000
INSURANCE_NUMBERVarchar2(16)VARCHAR16
HEALTH_CARE_NUMBERVarchar2(16)VARCHAR16
WC_CLEARANCE_OBTAINEDVarchar2(1)TOGGLE
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y

User Fields: Allowed
Audit Logging: Allowed


Notes #

Click to create a new notes page