Alias: HMD#

(P2K_SH_MEDICATIONS)

Unique Keys: None
Parent Table: P2K_RE_CANDIDATES
ERD: ERD-SH60


This table contains information on medications for employees or candidates.

Table Columns#

Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
RCA_IDNumber(10)IDYFor P2K_RE_CANDIDATES
HME_IDNumber(10)ID The result of P2K_SH_MEDICAL_EXAMS
PRESCRIPTION_DATEDate()DATE
ECT_IDNumber(10)ID Prescribed by P2K_HR_CONTACTS
MEDICATION_TYPEVarchar2(2)X_MEDICATION_TYPEY
MEDICATION_QUANTITYVarchar2(16)VARCHAR16
DESCRIPTIONVarchar2(50)DESCRIPTION
PRSCRIPTION_REFERENCEVarchar2(16)VARCHAR16
DATE_MEDICATION_STARTEDDate()DATE
DATE_MEDICATION_ENDEDDate()DATE
MEDICATION_TEXTVarchar2(4000)VARCHAR4000
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