SM_PAT_HIST Table
Information about the Oracle Empirica Signal configuration variables from the SM_PAT_HIST table.
Configuration Variable | Column | Description |
---|---|---|
(Patient History) Case Number |
CASE_NUM |
Case number |
(Patient History) Condition |
CONDITION |
Patient history condition |
(Patient History) Condition Continuing YN |
CONDITION_CONTINUING_VE |
Y/N: Is patient history condition ongoing |
(Patient History) Condition Indication |
CONDITION_INDICATION |
Patient history indication |
(Patient History) Condition Note |
CONDITION_NOTE |
Patient history note |
(Patient History) Condition Parent YN |
CONDITION_PARENT_YN_VE |
Y/N: Patient history condition is for parent |
(Patient History) Condition Reaction |
CONDITION_REACTION |
Patient history condition reaction |
(Patient History) Condition Sort ID |
CONDITION_SORT_ID |
Patient history condition sort order |
(Patient History) Condition Type |
CONDITION_TYPE_VE |
Condition type |
(Patient History) ValidEnd |
VALIDEND |
Valid end date |
(Patient History) ValidStart |
VALIDSTART |
Valid start date |
Parent topic: Data Mining Table Schema