P 2 K_SH_HEALTH_RECORDS
Back to current versionRestore this version

Alias:HHR#

Unique Keys:
Child Table:
Parent Table:

This table contains health records for an employee or a candidate.

Table Columns#

Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
RCA_IDNumber(10)IDYLink to P2K_RE_CANDIDATES
ECT_IDNumber(10)IDIdLink to P2K_HR_CONTACTS
HEALTH_AS_OF_DATEDate()DATEY
HEALTH_STATUSVarchar2(2)(Lexicon)Y
BLOOD_TYPEVarchar2(2)(Lexicon)
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