Go to primary content

Oracle® Argus Insight Extensibility Guide Release 8.1 E68411-01 |
| Contents | Index

Previous | Next |

# 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 = &rsquor;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 = &rsquor;STATE_2' and decode_context = &rsquor;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 = &rsquor;STATE_2' and decode_context = &rsquor;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 = &rsquor;STATE_2' and decode_context = &rsquor;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 = &rsquor;STATE_2' and decode_context = &rsquor;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 = &rsquor;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 = &rsquor;STATE_2' and decode_context = &rsquor;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 = &rsquor;STATE_2' and decode_context = &rsquor;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 = &rsquor;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 = &rsquor;STATE_2' and decode_context = &rsquor;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 = &rsquor;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 = &rsquor;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 = &rsquor;REPORT_TYPE' and decode_context = &rsquor;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 = &rsquor;STATE_2' and decode_context = &rsquor;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 = &rsquor;STATE_2' and decode_context = &rsquor;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 = &rsquor;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 = &rsquor;STATE_2' and decode_context = &rsquor;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 = &rsquor;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 = &rsquor;STATE_2' and decode_context = &rsquor;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 = &rsquor;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 = &rsquor;STATE_2' and decode_context = &rsquor;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 = &rsquor;STATE_2' and decode_context = &rsquor;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 = &rsquor;STATE_2' and decode_context = &rsquor;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 = &rsquor;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 = &rsquor;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 = &rsquor;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 = &rsquor;SOC_DISPLAY_ORDER' and decode_context = &rsquor;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 = &rsquor;STATE_2' and decode_context = &rsquor;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 = &rsquor;STATE_2' and decode_context = &rsquor;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 = &rsquor;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 = &rsquor;STATE_2' and decode_context = &rsquor;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 = &rsquor;STATE_2' and decode_context = &rsquor;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 = &rsquor;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 = &rsquor;STATE_2' and decode_context = &rsquor;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 = &rsquor;STATE_2' and decode_context = &rsquor;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 = &rsquor;STATE_2' and decode_context = &rsquor;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 = &rsquor;STATE_2' and decode_context = &rsquor;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 = &rsquor;STATE_2' and decode_context = &rsquor;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 = &rsquor;STATE_2' and decode_context = &rsquor;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 = &rsquor;STATE_2' and decode_context = &rsquor;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 = &rsquor;STATE_2' and decode_context = &rsquor;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 = &rsquor;STATE_2' and decode_context = &rsquor;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 = &rsquor;STATE_2' and decode_context = &rsquor;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 = &rsquor;STATE_2' and decode_context = &rsquor;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 = &rsquor;STATE_2' and decode_context = &rsquor;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= &rsquor;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 = &rsquor;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 = &rsquor;STATE_2' and decode_context = &rsquor;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 = &rsquor;SOC_DISPLAY_ORDER' and decode_context = &rsquor;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 = &rsquor;STATE_2' and decode_context = &rsquor;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 = &rsquor;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 = &rsquor;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 = &rsquor;REPORT_TYPE' and decode_context = &rsquor;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 = &rsquor;REPORT_TYPE' and decode_context = &rsquor;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 = &rsquor;REPORT_TYPE' and decode_context = &rsquor;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 = &rsquor;STATE_2' and decode_context = &rsquor;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 = &rsquor;STATE_2' and decode_context = &rsquor;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 = &rsquor;TRIMESTER_STATUS' and decode_context = <lang_code> | RM_RPT_AGG_CASE | PREGDRUGEXPOSURECODE