A Appendix: Dimensions and their Mapping
The following table lists the details of RPD including dimensions, Fact tables and their joins:
Table A-1 Dimensions and their Mapping
Dimension | Presentation Layer Tree View | JOIN in Physical Layer | WHERE clause to be used in BMM Layer | Join Table Name | Join Column Name |
---|---|---|---|---|---|
Dim_ACTION_TAKEN |
Product > Product Information > Action Taken |
"Dim_ACTION_TAKEN"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_DRUG"."ACTIONDRUG" AND "Dim_ACTION_TAKEN"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_DRUG"."ENTERPRISE_ID" |
Code_list_id = ‘ACTION_TAKEN' and decode_context = <lang_code> |
RM_RPT_AGG_DRUG |
ACTIONDRUG |
Dim_ADHOC1_CS_FLAG |
Reports > Case Series Flags > Adhoc Line Listing 1 |
"Dim_ADHOC1_CS_FLAG"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_CASE"."SEC9ADHOC1FLAG" AND "Dim_ADHOC1_CS_FLAG"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_CASE"."ENTERPRISE_ID" |
"Code_list_id = ‘STATE_2' and decode_context = ‘EN_ABBRV'" |
RM_RPT_AGG_CASE |
SEC9ADHOC1FLAG |
Dim_ADHOC2_CS_FLAG |
Reports > Case Series Flags > Adhoc Line Listing 2 |
"Dim_ADHOC2_CS_FLAG"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_CASE"."SEC9ADHOC2FLAG" AND "Dim_ADHOC2_CS_FLAG"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_CASE"."ENTERPRISE_ID" |
"Code_list_id = ‘STATE_2' and decode_context = ‘EN_ABBRV'" |
RM_RPT_AGG_CASE |
SEC9ADHOC2FLAG |
Dim_ADHOC3_CS_FLAG |
Reports > Case Series Flags > Adhoc Line Listing 3 |
"Dim_ADHOC3_CS_FLAG"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_CASE"."SEC9ADHOC3FLAG" AND "Dim_ADHOC3_CS_FLAG"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_CASE"."ENTERPRISE_ID" |
"Code_list_id = ‘STATE_2' and decode_context = ‘EN_ABBRV'" |
RM_RPT_AGG_CASE |
SEC9ADHOC3FLAG |
Dim_ADHOC4_CS_FLAG |
Reports > Case Series Flags > Adhoc Line Listing 4 |
"Dim_ADHOC4_CS_FLAG"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_CASE"."SEC9ADHOC4FLAG" AND "Dim_ADHOC4_CS_FLAG"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_CASE"."ENTERPRISE_ID" |
"Code_list_id = ‘STATE_2' and decode_context = ‘EN_ABBRV'" |
RM_RPT_AGG_CASE |
SEC9ADHOC4FLAG |
Dim_AGE_GROUP |
Patient > Patient Information > Age Group |
"Dim_AGE_GROUP"".""DISPLAY_VALUE"" = FACT_RM_RPT_AGG_CASE"".""PATIENTAGEGROUPTEXT"" AND Dim_AGE_GROUP"".""ENTERPRISE_ID"" = ""FACT_RM_RPT_AGG_CASE"".""ENTERPRISE_ID""" |
"Code_list_id = ‘AGE_GROUPS' and decode_context = <lang_code> " |
RM_RPT_AGG_CASE |
PATIENTAGEGROUPTEXT |
Dim_BREAST_FEEDING_FLAG |
Patient > Patient Information > Breastfeeding |
"Dim_BREAST_FEEDING_FLAG"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_CASE"."SEC9LACTATIONFLAG" AND "Dim_BREAST_FEEDING_FLAG"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_CASE"."ENTERPRISE_ID" |
"Code_list_id = ‘STATE_2' and decode_context = ‘EN_ABBRV'" |
RM_RPT_AGG_CASE |
SEC9LACTATIONFLAG |
Dim_CASE_EXPEDITED_PRV |
Reports > Case Series Flags > Case Expedited Previously |
"Dim_CASE_EXPEDITED_PRV"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_CASE"."EXPEDITEDFLAG" AND "Dim_CASE_EXPEDITED_PRV"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_CASE"."ENTERPRISE_ID" |
"Code_list_id = ‘STATE_2' and decode_context = ‘EN_ABBRV'" |
RM_RPT_AGG_CASE |
EXPEDITEDFLAG |
Dim_CASE_LISTEDNESS |
Analysis > Case Assessment > Case Listedness |
"Dim_CASE_LISTEDNESS"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_CASE"."CASEUNLABELEDNESSTEXT" AND "Dim_CASE_LISTEDNESS"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_CASE"."ENTERPRISE_ID" |
"Code_list_id = ‘LISTEDNESS' and decode_context = <lang_code>" |
RM_RPT_AGG_CASE |
CASEUNLABELEDNESSTEXT |
Dim_CASE_LOCKED_FLAG |
Activities > Case Lock Information > Case Locked |
"Dim_CASE_LOCKED_FLAG"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_CASE"."CASE_LOCKED_FLAG" AND "Dim_CASE_LOCKED_FLAG"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_CASE"."ENTERPRISE_ID" |
"Code_list_id = ‘STATE_2' and decode_context = ‘EN_ABBRV'" |
RM_RPT_AGG_CASE |
CASE_LOCKED_FLAG |
Dim_CASE_OUTCOME |
Analysis > Case Assessment > Case Outcome |
"Dim_CASE_OUTCOME"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_CASE"."OUTCOMETEXT" AND "Dim_CASE_OUTCOME"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_CASE"."ENTERPRISE_ID" |
Code_list_id = ‘EVENT_OUTCOME' and decode_context = <lang_code> |
RM_RPT_AGG_CASE |
OUTCOMETEXT |
Dim_CASE_SERIOUSNESS |
Analysis > Case Assessment > Case Seriousness |
Dim_CASE_SERIOUSNESS."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_CASE"."CASESERIOUSTEXT" AND "Dim_CASE_SERIOUSNESS"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_CASE"."ENTERPRISE_ID" |
Code_list_id = ‘SERIOUSNESS' and decode_context = <lang_code> |
RM_RPT_AGG_CASE |
CASESERIOUSTEXT |
Dim_CASE_TYPE |
General > General Information > Case Type |
"Dim_CASE_TYPE. ENTERPRISE_ID = FACT_RM_RPT_AGG_CASE.ENTERPRISE_ID AND Dim_CASE_TYPE. DISPLAY_VALUE = FACT_RM_RPT_AGG_CASE.CASETYPETEXT" |
Code_list_id = ‘REPORT_TYPE' and decode_context = ‘CASETYPETEXT' |
RM_RPT_AGG_CASE |
CASETYPETEXT |
Dim_CAUSE_OF_DEATH_VER_FLAG |
Event > Event Information > Cause of Death Verified |
"Dim_CAUSE_OF_DEATH_VER_FLAG"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_CASE"."CAUSEOFDEATHVERIFIED" AND "Dim_CAUSE_OF_DEATH_VER_FLAG"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_CASE"."ENTERPRISE_ID" |
"Code_list_id = ‘STATE_2' and decode_context = ‘EN_ABBRV'" |
RM_RPT_AGG_CASE |
CAUSEOFDEATHVERIFIED |
Dim_CLINICAL_TRAIL_FLAG |
Reports > Case Series Flags > Clinical Trial Case |
"Dim_CLINICAL_TRAIL_FLAG"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_CASE"."SEC7FLAG" AND "Dim_CLINICAL_TRAIL_FLAG"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_CASE"."ENTERPRISE_ID" |
"Code_list_id = ‘STATE_2' and decode_context = ‘EN_ABBRV'" |
RM_RPT_AGG_CASE |
SEC7FLAG |
Dim_CLINICALDRUGROLE |
Event > Event Information > Clinical Drug Role |
"Dim_CLINICALDRUGROLE"."DRUG_ROLE_NUM" = "FACT_RM_RPT_AGG_CASE"."CLINICALDRUGROLE" AND "Dim_CLINICALDRUGROLE"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_CASE"."ENTERPRISE_ID" |
N/A |
RM_RPT_AGG_CASE |
CLINICALDRUGROLE |
Dim_COMP_AGENT_CAUSAL |
Analysis > Case Assessment > Company Agent Causal |
"Dim_COMP_AGENT_CAUSAL"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_CASE"."CASECORELATEDTEXT" AND "Dim_COMP_AGENT_CAUSAL"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_CASE"."ENTERPRISE_ID" |
"Code_list_id = ‘STATE_3' and decode_context = <lang_code>" |
RM_RPT_AGG_CASE |
CASECORELATEDTEXT |
Dim_COMPANY_PROD_FLAG |
Product > Product Information > Is Company Product |
"Dim_COMPANY_PROD_FLAG"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_DRUG"."COMPANYDRUGFLAG" AND "Dim_COMPANY_PROD_FLAG"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_DRUG"."ENTERPRISE_ID" |
"Code_list_id = ‘STATE_2' and decode_context = ‘EN_ABBRV'" |
RM_RPT_AGG_DRUG |
COMPANYDRUGFLAG |
Dim_COUNTRY |
General > General Information > Country of Incidence |
Dim_COUNTRY"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_CASE"."OCCURCOUNTRYTEXT" AND "Dim_COUNTRY"."ENTERPRISE_ID" = .FACT_RM_RPT_AGG_CASE"."ENTERPRISE_ID |
"Code_list_id = ‘COUNTRY' and decode_context = <lang_code>" |
RM_RPT_AGG_CASE |
OCCURCOUNTRYTEXT |
Dim_CUM_CS_FLAG |
Reports > Case Series Flags > Cumulative Case |
"Dim_CUM_CS_FLAG"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_CASE"."SEC6CUMMFLAG" AND "Dim_CUM_CS_FLAG"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_CASE"."ENTERPRISE_ID" |
"Code_list_id = ‘STATE_2' and decode_context = ‘EN_ABBRV'" |
RM_RPT_AGG_CASE |
SEC6CUMMFLAG |
Dim_DEATH_DATE |
Event > Event Information > Death Date |
"Dim_DEATH_DATE"."ROW_WID" = "FACT_RM_RPT_AGG_CASE"."PATIENTDEATHDATE_WID" |
N/A |
RM_RPT_AGG_CASE |
PATIENTDEATHDATE_WID |
Dim_DECHALL_RESULT |
Product > Product Details > Dechallenge Results |
"Dim_DECHALL_RESULT"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_DRUG"."DECHALLENGETEXT" AND "Dim_DECHALL_RESULT"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_DRUG"."ENTERPRISE_ID" |
"Code_list_id = ‘STATE_POS_NEG' and decode_context = <lang_code>" |
RM_RPT_AGG_DRUG |
DECHALLENGETEXT |
Dim_DIAG_SYMPT_FLAG |
Event > Event Information > Diagnosis/Symptoms |
"Dim_DIAG_SYMPT_FLAG"."DIAG_SYMPT_FLAG" = "FACT_RM_RPT_AGG_EVENT"."TERMTYPEFLAG" AND "Dim_DIAG_SYMPT_FLAG"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_EVENT"."ENTERPRISE_ID" |
N/A |
RM_RPT_AGG_EVENT |
TERMTYPEFLAG |
Dim_DRUG_ABUSE_FLAG |
Product > Product Information > Drug Abuse |
"Dim_DRUG_ABUSE_FLAG"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_CASE"."SEC9DRUGABUSEFLAG" AND "Dim_DRUG_ABUSE_FLAG"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_CASE"."ENTERPRISE_ID" |
"Code_list_id = ‘STATE_2' and decode_context = ‘EN_ABBRV'" |
RM_RPT_AGG_CASE |
SEC9DRUGABUSEFLAG |
Dim_DRUG_OVERDOSE_FLAG |
Product > Product Information > Drug Overdose |
"Dim_DRUG_OVERDOSE_FLAG"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_CASE"."SEC9OVERDOSEFLAG" AND "Dim_DRUG_OVERDOSE_FLAG"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_CASE"."ENTERPRISE_ID" |
"Code_list_id = ‘STATE_2' and decode_context = ‘EN_ABBRV'" |
RM_RPT_AGG_CASE |
SEC9OVERDOSEFLAG |
Dim_ENTERPRISE_ID |
Facts > Common > Enterprise_Id |
"""AI81_SRC""."""".""AI81OBIEE"".""Dim_ENTERPRISE_ID"".""ENTERPRISE_ID"" = ""AI81_SRC""."""".""AI81OBIEE"".""FACT_RM_RPT_AGG_CASE"".""ENTERPRISE_ID""---""AI81_SRC""."""".""AI81OBIEE"".""Dim_ENTERPRISE_ID"".""ENTERPRISE_ID"" = ""AI81_SRC""."""".""AI81OBIEE"".""FACT_RM_RPT_AGG_EVENT"".""ENTERPRISE_ID""---""AI81_SRC""."""".""AI81OBIEE"".""Dim_ENTERPRISE_ID"".""ENTERPRISE_ID"" = ""AI81_SRC""."""".""AI81OBIEE"".""FACT_RM_RPT_AGG_DRUG"".""ENTERPRISE_ID""---""AI81_SRC""."""".""AI81OBIEE"".""Dim_ENTERPRISE_ID"".""ENTERPRISE_ID"" = ""AI81_SRC""."""".""AI81OBIEE"".""FACT_RM_RPT_AGG_EV2DRUG"".""ENTERPRISE_ID""" |
N/A |
-- | -- |
Dim_EUDRACT_ID |
General > Study Information > EUDRACT ID |
"Dim_EUDRACT_ID"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_CASE"."ENTERPRISE_ID" AND "Dim_EUDRACT_ID"."REF_TYPE_DESC" = "FACT_RM_RPT_AGG_CASE"."EUDRACTID" |
ref_type_id = 4 and deleted IS NULL |
RM_RPT_AGG_CASE |
EUDRACTID |
Dim_EVENT_DEATH |
Event > Event Information > Event Death |
"Dim_EVENT_DEATH"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_EVENT"."DIEDFLAG" AND "Dim_EVENT_DEATH"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_EVENT"."ENTERPRISE_ID" |
"Code_list_id = ‘STATE_2' and decode_context = ‘EN_ABBRV'" |
RM_RPT_AGG_EVENT |
DIEDFLAG |
Dim_EVENT_LISTEDNESS |
Event > Event Assessment > Event Listedness |
"Dim_EVENT_LISTEDNESS"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_EVENT"."EVENTUNLABELEDNESSTEXT" AND "Dim_EVENT_LISTEDNESS"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_EVENT"."ENTERPRISE_ID" |
"Code_list_id = ‘LISTEDNESS' and decode_context = <lang_code>" |
RM_RPT_AGG_EVENT |
EVENTUNLABELEDNESSTEXT |
Dim_EVENT_OUTCOME |
Event > Event Information > Event Outcome |
"Dim_EVENT_OUTCOME"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_EVENT"."EVENTOUTCOMELIST" AND "Dim_EVENT_OUTCOME"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_EVENT"."ENTERPRISE_ID" |
Code_list_id = ‘EVENT_OUTCOME' and decode_context = <lang_code> |
RM_RPT_AGG_EVENT |
EVENTOUTCOMELIST |
Dim_EVENT_REACTION |
Event > Event Information > Event Reported |
"Dim_EVENT_REACTION"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_EVENT"."ENTERPRISE_ID" AND "Dim_EVENT_REACTION"."REACTION" = "FACT_RM_RPT_AGG_EVENT"."REACTION" |
N/A |
RM_RPT_AGG_EVENT |
REACTION |
Dim_EVENT_SERIOUSNESS |
Event > Event Information > Event Seriousness |
"Dim_EVENT_SERIOUSNESS"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_EVENT"."EVENTSERIOUSTEXT" AND "Dim_EVENT_SERIOUSNESS"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_EVENT"."ENTERPRISE_ID" |
Code_list_id = ‘SERIOUSNESS' and decode_context = <lang_code> |
RM_RPT_AGG_EVENT |
EVENTSERIOUSTEXT |
Dim_EVENT_SOC |
Event > Event Information > Event SOC |
"Dim_EVENT_SOC"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_EVENT"."SOC" AND "Dim_EVENT_SOC"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_EVENT"."ENTERPRISE_ID" |
"Code_list_id = ‘SOC_DISPLAY_ORDER' and decode_context = ‘SOC'" |
RM_RPT_AGG_EVENT |
SOC |
Dim_EVT_DET_CAUSALITY |
Event > Event Assessment > As Determined Causality |
"Dim_EVT_DET_CAUSALITY"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_EVENT"."EVENTCORELATEDTEXT" AND "Dim_EVT_DET_CAUSALITY"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_EVENT"."ENTERPRISE_ID" |
"Code_list_id = ‘STATE_2' and decode_context = ‘CAUSAL'" |
RM_RPT_AGG_EVENT |
EVENTCORELATEDTEXT |
Dim_EVT_PRIM_DIAG |
Event > Event Information > Primary Diagnosis Event |
"Dim_EVT_PRIM_DIAG"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_EVENT"."PRIMARYDIAGNOSISFLAG" AND "Dim_EVT_PRIM_DIAG"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_EVENT"."ENTERPRISE_ID" |
"Code_list_id = ‘STATE_2' and decode_context = ‘EN_ABBRV'" |
RM_RPT_AGG_EVENT |
PRIMARYDIAGNOSISFLAG |
Dim_EVT_RPT_CAUSALITY |
Event > Event Assessment > As Reported Causality |
"Dim_EVT_RPT_CAUSALITY"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_EVENT"."EVENTRPTRELATEDTEXT" AND "Dim_EVT_RPT_CAUSALITY"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_EVENT"."ENTERPRISE_ID" |
"Code_list_id = ‘CAUSALITY' and decode_context = <lang_code>" |
RM_RPT_AGG_EVENT |
EVENTRPTRELATEDTEXT |
Dim_FATAL_LIST_FLAG |
Reports > Case Series Flags > Fatal Listing Case |
"Dim_FATAL_LIST_FLAG"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_CASE"."SEC6FATALFLAG" AND "Dim_FATAL_LIST_FLAG"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_CASE"."ENTERPRISE_ID" |
"Code_list_id = ‘STATE_2' and decode_context = ‘EN_ABBRV'" |
RM_RPT_AGG_CASE |
SEC6FATALFLAG |
Dim_FOLLOWUP |
Reports > Case Series Flags > Initial/Follow-up |
"Dim_FOLLOWUP"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_CASE"."PSURFOLLOWUPTEXT" AND "Dim_FOLLOWUP"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_CASE"."ENTERPRISE_ID" |
Code_list_id = ‘STATE_2' and decode_context = ‘FOLLOWUPTEXT' |
RM_RPT_AGG_CASE |
PSURFOLLOWUPTEXT |
Dim_Gender |
Patient > Patient Information > Gender |
Dim_GENDER"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_CASE"."PATIENTSEXTEXT" AND "Dim_GENDER"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_CASE"."ENTERPRISE_ID" |
"Code_list_id = ‘GENDER' andDecode_context = <lang_code>" |
RM_RPT_AGG_CASE |
PATIENTSEXTEXT |
Dim_GERIATRIC_CASE_FLAG |
Reports > Case Series Flags > Geriatric Case |
"Dim_GERIATRIC_CASE_FLAG"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_CASE"."SEC9SPLGERIATICFLAG" AND "Dim_GERIATRIC_CASE_FLAG"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_CASE"."ENTERPRISE_ID" |
"Code_list_id = ‘STATE_2' and decode_context = ‘EN_ABBRV'" |
RM_RPT_AGG_CASE |
SEC9SPLGERIATICFLAG |
Dim_HEALTH_AUTH_NUM |
Additional Information > References > Health Authority Number |
"Dim_HEALTH_AUTH_NUM"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_CASE"."ENTERPRISE_ID" AND "Dim_HEALTH_AUTH_NUM"."TYPE_DESC" = "FACT_RM_RPT_AGG_CASE"."HEALTHAUTHORITYNBRLIST" |
Deleted IS NULL |
RM_RPT_AGG_CASE |
HEALTHAUTHORITYNBRLIST |
Dim_HEALTH_CARE_PROF |
General > Reporter Information > Health Care Professional |
"Dim_HEALTH_CARE_PROF"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_CASE"."CASEMEDICALLYCONFIRMFLAG" AND "Dim_HEALTH_CARE_PROF"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_CASE"."ENTERPRISE_ID" |
"Code_list_id = ‘STATE_2' and decode_context = ‘EN_ABBRV'" |
RM_RPT_AGG_CASE |
CASEMEDICALLYCONFIRMFLAG |
Dim_INIT_RCPT_DATE |
General > General Information > Initial Receipt Date |
"Dim_INIT_RCPT_DATE"."ROW_WID" = "FACT_RM_RPT_AGG_CASE"."INITRCPTDATE_WID" |
N/A |
RM_RPT_AGG_CASE |
INITRCPTDATE_WID |
Dim_INTERACTION_FLAG |
Product > Product Information > Interaction |
"Dim_INTERACTION_FLAG"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_CASE"."SEC9INTERACTIONSFLAG" AND "Dim_INTERACTION_FLAG"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_CASE"."ENTERPRISE_ID" |
"Code_list_id = ‘STATE_2' and decode_context = ‘EN_ABBRV'" |
RM_RPT_AGG_CASE |
SEC9INTERACTIONSFLAG |
Dim_LACK_EFFICACY_FLAG |
Product > Product Information > Lack of Efficacy |
"Dim_LACK_EFFICACY_FLAG"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_CASE"."SEC8LACKOFEFFICACYFLAG" AND "Dim_LACK_EFFICACY_FLAG"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_CASE"."ENTERPRISE_ID" |
"Code_list_id = ‘STATE_2' and decode_context = ‘EN_ABBRV'" |
RM_RPT_AGG_CASE |
SEC8LACKOFEFFICACYFLAG |
Dim_MAIN_CS_FLAG |
Reports > Case Series Flags > Main Case Series Case |
"Dim_MAIN_CS_FLAG"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_CASE"."SEC61FLAG" AND "Dim_MAIN_CS_FLAG"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_CASE"."ENTERPRISE_ID" |
"Code_list_id = ‘STATE_2' and decode_context = ‘EN_ABBRV'" |
RM_RPT_AGG_CASE |
SEC61FLAG |
Dim_ORGAN_IMPAIRED_FLAG |
Reports > Case Series Flags > Organ Impaired |
"Dim_ORGAN_IMPAIRED_FLAG"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_CASE"."SEC9SPLIMPAIREDFLAG" AND "Dim_ORGAN_IMPAIRED_FLAG"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_CASE"."ENTERPRISE_ID" |
"Code_list_id = ‘STATE_2' and decode_context = ‘EN_ABBRV'" |
RM_RPT_AGG_CASE |
SEC9SPLIMPAIREDFLAG |
Dim_PBRER62_CUM_CS_FLAG |
Reports > Case Series Flags > PBRER 62 Cumulative Case |
"Dim_PBRER62_CUM_CS_FLAG"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_CASE"."SEC62CUMFLAG" AND "Dim_PBRER62_CUM_CS_FLAG"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_CASE"."ENTERPRISE_ID" |
"Code_list_id = ‘STATE_2' and decode_context = ‘EN_ABBRV'" |
RM_RPT_AGG_CASE |
SEC62CUMFLAG |
Dim_PBRER63_CUM_CS_FLAG |
Reports > Case Series Flags > PBRER 63 Cumulative Case |
"Dim_PBRER63_CUM_CS_FLAG"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_CASE"."SEC63CUMFLAG" AND "Dim_PBRER63_CUM_CS_FLAG"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_CASE"."ENTERPRISE_ID" |
"Code_list_id = ‘STATE_2' and decode_context = ‘EN_ABBRV'" |
RM_RPT_AGG_CASE |
SEC63CUMFLAG |
Dim_PBRER63_MAIN_CS_FLAG |
Reports > Case Series Flags > PBRER 63 Main Case Series Case |
"Dim_PBRER63_MAIN_CS_FLAG"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_CASE"."SEC63MAINFLAG" AND "Dim_PBRER63_MAIN_CS_FLAG"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_CASE"."ENTERPRISE_ID" |
"Code_list_id = ‘STATE_2' and decode_context = ‘EN_ABBRV'" |
RM_RPT_AGG_CASE |
SEC63MAINFLAG |
Dim_PBRER63_NONINT_CS_FLAG |
Reports > Case Series Flags > PBRER 63 Non Interventional Case |
"Dim_PBRER63_NONINT_CS_FLAG"."DISPLAY_VALUE" ="FACT_RM_RPT_AGG_CASE"."SEC63NONINTMAINFLAG" AND "Dim_PBRER63_NONINT_CS_FLAG"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_CASE"."ENTERPRISE_ID" |
"Code_list_id = ‘STATE_2' and decode_context = ‘EN_ABBRV'" |
RM_RPT_AGG_CASE |
SEC63NONINTMAINFLAG |
Dim_PBRER63_NONINT_MAIN_CS_FLAG |
Reports > Case Series Flags > PBRER 63 Non Interventional Cumulative Case |
"Dim_PBRER63_NONINT_CUM_CS_FLAG"."DISPLAY_VALUE" ="FACT_RM_RPT_AGG_CASE"."SEC63NONINTCUMFLAG" AND "Dim_PBRER63_NONINT_CUM_CS_FLAG"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_CASE"."ENTERPRISE_ID" |
"Code_list_id = ‘STATE_2' and decode_context = ‘EN_ABBRV'" |
RM_RPT_AGG_CASE |
SEC63NONINTCUMFLAG |
Dim_PEDIATRIC_CASE_FLAG |
Reports > Case Series Flags > Pediatric Case |
"Dim_PEDIATRIC_CASE_FLAG"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_CASE"."SEC9SPLPEDFLAG" AND "Dim_PEDIATRIC_CASE_FLAG"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_CASE"."ENTERPRISE_ID" |
"Code_list_id = ‘STATE_2' and decode_context = ‘EN_ABBRV'" |
RM_RPT_AGG_CASE |
SEC9SPLPEDFLAG |
Dim_PREG_EXPO |
Patient > Pregnancy Information > Pregnancy Exposure Status |
"Dim_PREG_EXPO"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_CASE"."PREGEXPOSURECASESTATUSTEXT" AND "Dim_PREG_EXPO"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_CASE"."ENTERPRISE_ID" |
"Code_list_id= ‘PROSPECTIVE_STATUS'and decode_context = <lang_code>" |
RM_RPT_AGG_CASE |
PREGEXPOSURECASESTATUSTEXT |
Dim_PREG_OUTCOME |
Patient > Pregnancy Information > Pregnancy Outcome |
"Dim_PREG_OUTCOME"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_CASE"."PREGNANCYOUTCOMETEXT" AND "Dim_PREG_OUTCOME"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_CASE"."ENTERPRISE_ID" |
Code_list_id = ‘FETAL_OUTCOME' and decode_context = <lang_code> |
RM_RPT_AGG_CASE |
PREGNANCYOUTCOMETEXT |
Dim_PREGNANCY_FLAG |
Patient > Patient Information > Pregnancy Flag |
"Dim_PREGNANCY_FLAG"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_CASE"."SEC9PREGNANCYFLAG" AND "Dim_PREGNANCY_FLAG"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_CASE"."ENTERPRISE_ID" |
"Code_list_id = ‘STATE_2' and decode_context = ‘EN_ABBRV'" |
RM_RPT_AGG_CASE |
SEC9PREGNANCYFLAG |
Dim_PRIM_STUDY_PROD |
General > Study Information > Primary Study Product |
"Dim_PRIM_STUDY_PROD"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_CASE"."ENTERPRISE_ID" AND "Dim_PRIM_STUDY_PROD"."PROJECT_DRUG" = "FACT_RM_RPT_AGG_CASE"."PROJECTDRUG" |
N/A |
RM_RPT_AGG_CASE |
PROJECTDRUG |
Dim_PRIMARY_SOC |
Event > Event Information > Primary SOC |
"Dim_PRIMARY_SOC"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_CASE"."PRIMARYCASESOC" AND "Dim_PRIMARY_SOC"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_CASE"."ENTERPRISE_ID" |
"Code_list_id = ‘SOC_DISPLAY_ORDER' and decode_context = ‘SOC'" |
RM_RPT_AGG_CASE |
PRIMARYCASESOC |
Dim_PRODUCT_NAME |
Product > Product Information > Product Name |
"Dim_PRODUCT_NAME"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_DRUG"."ENTERPRISE_ID" AND "Dim_PRODUCT_NAME"."PRODUCT_NAME" = "FACT_RM_RPT_AGG_DRUG"."DRUGNAME" |
N/A |
RM_RPT_AGG_DRUG |
DRUGNAME |
Dim_PROLONGED_EXPO |
Reports > Case Series Flags > Prolonged Exposure |
"Dim_PROLONGED_EXPO"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_CASE"."SEC9PROLONGFLAG" AND "Dim_PROLONGED_EXPO"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_CASE"."ENTERPRISE_ID" |
"Code_list_id = ‘STATE_2' and decode_context = ‘EN_ABBRV'" |
RM_RPT_AGG_CASE |
SEC9PROLONGFLAG |
Dim_RECHALL_OUTCOME |
Product > Product Details > Rechallenge Outcome |
"Dim_RECHALL_OUTCOME"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_DRUG"."ENTERPRISE_ID" AND "Dim_RECHALL_OUTCOME"."CODE" = "FACT_RM_RPT_AGG_DRUG"."RECHALLENGEOUTCOME" |
"Code_list_id = ‘RECHALLENGE_OUTCOME'and decode_context = <lang_code>" |
RM_RPT_AGG_DRUG |
RECHALLENGEOUTCOME |
Dim_RECHALL_RESULT |
Product > Product Details > Rechallenge Results |
"Dim_RECHALL_RESULT"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_DRUG"."RECHALLENGETEXT" AND "Dim_RECHALL_RESULT"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_DRUG"."ENTERPRISE_ID" |
"Code_list_id = ‘STATE_POS_NEG' and decode_context = <lang_code>" |
RM_RPT_AGG_DRUG |
RECHALLENGETEXT |
Dim_REPORT_FORM_ID |
Facts > Common > Aggregate Configuration Name |
"""AI81_SRC""."""".""AI81OBIEE"".""Dim_REPORT_FORM_ID"".""ENTERPRISE_ID"" = ""AI81_SRC""."""".""AI81OBIEE"".""FACT_RM_RPT_AGG_EVENT"".""ENTERPRISE_ID"" AND ""AI81_SRC""."""".""AI81OBIEE"".""Dim_REPORT_FORM_ID"".""REG_REPORT_ID"" = ""AI81_SRC""."""".""AI81OBIEE"".""FACT_RM_RPT_AGG_EVENT"".""REG_REPORT_ID""---""AI81_SRC""."""".""AI81OBIEE"".""Dim_REPORT_FORM_ID"".""ENTERPRISE_ID"" = ""AI81_SRC""."""".""AI81OBIEE"".""FACT_RM_RPT_AGG_CASE"".""ENTERPRISE_ID"" AND ""AI81_SRC""."""".""AI81OBIEE"".""Dim_REPORT_FORM_ID"".""REG_REPORT_ID"" = ""AI81_SRC""."""".""AI81OBIEE"".""FACT_RM_RPT_AGG_CASE"".""REG_REPORT_ID""---""AI81_SRC""."""".""AI81OBIEE"".""Dim_REPORT_FORM_ID"".""ENTERPRISE_ID"" = ""AI81_SRC""."""".""AI81OBIEE"".""FACT_RM_RPT_AGG_DRUG"".""ENTERPRISE_ID"" AND ""AI81_SRC""."""".""AI81OBIEE"".""Dim_REPORT_FORM_ID"".""REG_REPORT_ID"" = ""AI81_SRC""."""".""AI81OBIEE"".""FACT_RM_RPT_AGG_DRUG"".""REG_REPORT_ID""---""AI81_SRC""."""".""AI81OBIEE"".""Dim_REPORT_FORM_ID"".""ENTERPRISE_ID"" = ""AI81_SRC""."""".""AI81OBIEE"".""FACT_RM_RPT_AGG_EV2DRUG"".""ENTERPRISE_ID"" AND ""AI81_SRC""."""".""AI81OBIEE"".""Dim_REPORT_FORM_ID"".""REG_REPORT_ID"" = ""AI81_SRC""."""".""AI81OBIEE"".""FACT_RM_RPT_AGG_EV2DRUG"".""REG_REPORT_ID""" |
N/A |
-- | -- |
Dim_REPORT_TEMPLATE |
Facts > Common > Report Form Name |
"""AI81_SRC""."""".""AI81OBIEE"".""Dim_REPORT_TEMPLATE"".""ENTERPRISE_ID"" = ""AI81_SRC""."""".""AI81OBIEE"".""FACT_RM_RPT_AGG_EVENT"".""ENTERPRISE_ID"" AND ""AI81_SRC""."""".""AI81OBIEE"".""Dim_REPORT_TEMPLATE"".""REG_REPORT_ID"" = ""AI81_SRC""."""".""AI81OBIEE"".""FACT_RM_RPT_AGG_EVENT"".""REG_REPORT_ID""-----""AI81_SRC""."""".""AI81OBIEE"".""Dim_REPORT_TEMPLATE"".""ENTERPRISE_ID"" = ""AI81_SRC""."""".""AI81OBIEE"".""FACT_RM_RPT_AGG_CASE"".""ENTERPRISE_ID"" AND ""AI81_SRC""."""".""AI81OBIEE"".""Dim_REPORT_TEMPLATE"".""REG_REPORT_ID"" = ""AI81_SRC""."""".""AI81OBIEE"".""FACT_RM_RPT_AGG_CASE"".""REG_REPORT_ID""------""AI81_SRC""."""".""AI81OBIEE"".""Dim_REPORT_TEMPLATE"".""ENTERPRISE_ID"" = ""AI81_SRC""."""".""AI81OBIEE"".""FACT_RM_RPT_AGG_DRUG"".""ENTERPRISE_ID"" AND ""AI81_SRC""."""".""AI81OBIEE"".""Dim_REPORT_TEMPLATE"".""REG_REPORT_ID"" = ""AI81_SRC""."""".""AI81OBIEE"".""FACT_RM_RPT_AGG_DRUG"".""REG_REPORT_ID""------""AI81_SRC""."""".""AI81OBIEE"".""Dim_REPORT_TEMPLATE"".""ENTERPRISE_ID"" = ""AI81_SRC""."""".""AI81OBIEE"".""FACT_RM_RPT_AGG_EV2DRUG"".""ENTERPRISE_ID"" AND ""AI81_SRC""."""".""AI81OBIEE"".""Dim_REPORT_TEMPLATE"".""REG_REPORT_ID"" = ""AI81_SRC""."""".""AI81OBIEE"".""FACT_RM_RPT_AGG_EV2DRUG"".""REG_REPORT_ID""" |
N/A |
-- | -- |
Dim_REPORT_TYPE |
General > General Information > ReportType |
"Dim_REPORT_TYPE"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_CASE"."REPORTTYPE" AND "Dim_REPORT_TYPE"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_CASE"."ENTERPRISE_ID" |
"Code_list_id = ‘REPORT_TYPE' and decode_context = ‘REPTYPECODE'" |
RM_RPT_AGG_CASE |
REPORTTYPE |
Dim_REPORT_TYPE |
General > General Information > Report Type |
"Dim_REPORT_TYPE"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_CASE"."REPORTTYPE" AND "Dim_REPORT_TYPE"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_CASE"."ENTERPRISE_ID" |
"Code_list_id = ‘REPORT_TYPE' and decode_context = ‘REPTYPECODE'" |
RM_RPT_AGG_CASE |
REPORTTYPE |
Dim_REPORT_TYPE_GRP |
General > General Information > ReportType Group |
"Dim_REPORT_TYPE_GRP"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_CASE"."REPORTTYPETEXT" AND "Dim_REPORT_TYPE_GRP"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_CASE"."ENTERPRISE_ID" |
Code_list_id = ‘REPORT_TYPE' and decode_context = ‘REPTYPEGRP' |
RM_RPT_AGG_CASE |
REPORTTYPETEXT |
Dim_SPL_INT_EVENT |
Event > Event Information > Special Interest Event |
"Dim_SPL_INT_EVENT"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_EVENT"."EVENTSPLINTRSTSYMBOL" AND "Dim_SPL_INT_EVENT"."ENTERPRISE_ID" = "AI81_SRC".""."AI81OBIEE"."FACT_RM_RPT_AGG_EVENT"."ENTERPRISE_ID" |
"Code_list_id = ‘STATE_2' and decode_context = ‘EN_ABBRV'" |
RM_RPT_AGG_EVENT |
EVENTSPLINTRSTSYMBOL |
Dim_STUDY_ID |
General > Study Information > Study ID |
"Dim_STUDY_ID"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_CASE"."ENTERPRISE_ID" AND "Dim_STUDY_ID"."STUDY_NUM" = "FACT_RM_RPT_AGG_CASE"."SPONSORSTUDYNUMB" |
N/A |
RM_RPT_AGG_CASE |
SPONSORSTUDYNUMB |
Dim_STUDY_NAME |
General > Study Information > Study Name |
"Dim_STUDY_NAME"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_CASE"."ENTERPRISE_ID" AND "Dim_STUDY_NAME"."STUDY_NAME" = "FACT_RM_RPT_AGG_CASE"."STUDYNAME" |
N/A |
RM_RPT_AGG_CASE |
STUDYNAME |
Dim_SUSAR_FLAG |
Event > Event Information > SUSAR Event |
"Dim_SUSAR_FLAG"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_EVENT"."EVENTSUSARSYMBOL" AND "Dim_SUSAR_FLAG"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_EVENT"."ENTERPRISE_ID" |
"Code_list_id = ‘STATE_2' and decode_context = ‘EN_ABBRV'" |
RM_RPT_AGG_EVENT |
EVENTSUSARSYMBOL |
Dim_TREATMENT_LIST |
Product > Product Information > Treatment list |
"Dim_TREATMENT_LIST"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_CASE"."ENTERPRISE_ID" AND "Dim_TREATMENT_LIST"."TREATMENT_LIST" = "FACT_RM_RPT_AGG_CASE"."TREATMENTLIST" |
N/A |
RM_RPT_AGG_CASE |
TREATMENTLIST |
Dim_TRIMER_EXPO |
Patient > Pregnancy Information > Trimester of Exposure |
"Dim_TRIMER_EXPO"."DISPLAY_VALUE" = "FACT_RM_RPT_AGG_CASE"."PREGDRUGEXPOSURECODE" AND "Dim_TRIMER_EXPO"."ENTERPRISE_ID" = "FACT_RM_RPT_AGG_CASE"."ENTERPRISE_ID" |
Code_list_id = ‘TRIMESTER_STATUS' and decode_context = <lang_code> |
RM_RPT_AGG_CASE |
PREGDRUGEXPOSURECODE |