SM_EVENT View
The SM_EVENT view on the SM_EVENT_PLUS_SMQ table is created using a SQL WHERE clause.
The SM_EVENT view on the SM_EVENT_PLUS_SMQ table is created using this SQL WHERE clause:
WHERE EVENT_TYPE = 'PT' AND INCLUDE_YN = 'Y'
Information about the Oracle Empirica Signal configuration variables from the SM_EVENT view on the SM_EVENT_PLUS_SMQ table follows.
Configuration Variable | Column | Description |
---|---|---|
(Event) Associated with Rechallenge YN |
RECHALL_RELATED_YN_VE |
Y/N: Associated with rechallenge |
(Event) Case Number |
CASE_NUM |
Case number |
(Event) Congenital Anomaly YN |
SERIOUS_CONGEN_ANOM_VE |
Y/N: Event congenital anomaly seriousness criteria |
(Event) Death YN |
SERIOUS_DEATH_VE |
Y/N: Event death seriousness criteria |
(Event) Detail |
DETAILS_LT |
Event detail |
(Event) Disability YN |
SERIOUS_DISABLE_VE |
Y/N: Event disability seriousness criteria |
(Event) Event Diagnosis YN |
EVENT_DIAGNOSIS_VE |
Y/N: Event diagnosis |
(Event) Event Outcome |
EVENT_OUTCOME_VE |
Event outcome |
(Event) Frequency |
EVT_FREQ_VE |
Event frequency |
(Event) HLGT |
EVENT_HLGT |
Event High Level Group Term |
(Event) HLT |
EVENT_HLT |
Event High Level Term |
(Event) Hospitalized YN |
SERIOUS_HOSP_VE |
Y/N: Event hospitalized seriousness criteria |
(Event) Intensity |
EVENT_INTENSITY_VE |
Event intensity |
(Event) Lack of Efficacy YN |
EFFICACY_YN_VE |
Y/N: Lack of efficacy |
(Event) Life-threatening YN |
SERIOUS_LIFE_THREAT_VE |
Y/N: Event life-threatening seriousness criteria |
(Event) LLT |
EVENT_LLT |
Event Lower Level Term |
(Event) Medically Serious YN |
MED_SERIOUS_VE |
Y/N: Medically serious event |
(Event) Onset Date |
ONSET_DATE |
Onset date of event |
(Event) Other Details |
SC_OTHER_TEXT |
Details of other seriousness criteria |
(Event) Other YN |
SERIOUS_OTHER_VE |
Y/N: Event other seriousness criteria |
(Event) Patient Prior History YNU |
PAST_HIST_VE |
Y/N/U: Patient has prior history? |
(Event) PT |
EVENT_PT |
Event Preferred term |
(Event) Req Intervention YN |
SERIOUS_INTERVENTION_VE |
Y/N: Event intervention seriousness criteria |
(Event) Sequence Number |
EVENT_SEQ_NUM |
Event sequence number |
(Event) Serious YN |
EVENT_SERIOUSNESS_VE |
Y/N: Event seriousness |
(Event) SOC |
SOC |
Event System Organ Class |
(Event) SOC Abbrev |
EVENT_SOC |
Event System Organ Class abbreviation |
(Event) Sort ID |
EVENT_SORT_ID |
Event sort order |
(Event) Treatment Received YNU |
TREATED_YNU_VE |
Y/N/U: Treatment received |
(Event) ValidEnd |
VALIDEND |
Valid end date |
(Event) ValidStart |
VALIDSTART |
Valid start date |
(Event/derived) Duration Text |
EVENT_DURATION_TEXT_DV |
Text describing duration of event. Calculated by Argus from onset date to event stop date |
(Event/derived) Onset Delay |
ONSET_DELAY_TEXT_DV |
Text describing onset delay from last dosage |
(Event/derived) Onset Latency |
ONSET_LATENCY_TEXT_DV |
Text describing onset latency from first dosage |
(Event/derived) Seriousness Criteria |
EVENT_SERIOUSNESS_TEXT_ DV |
Summary of event seriousness criteria. Combination of the letters FLMDCIHO, for fatal, life threat, med significant, disability, congen anom, intervention, hosp, other |
Parent topic: Data Mining Table Schema