Clinical Significance Code SkDrug Information Source IndEffective From DtEffective To DtLoad Info SkOther Pharmacy IndOther Prescriber IndReview Reason Code SkSource Code SkTenant SkTreatment Review SkValid From TsValid To Ts
| Atomic Warehouse Model Data Model |
| Description | A medical treatment review that evaluates the appropriateness of a prescribed drug therapy. Drug utilization review may be required for specific high-cost drugs or non-formulary drugs to determine compliance with clinical practice guidelines. It is also used for other situations such as therapeutic duplication, drug-disease contraindications, incorrect dosage or duration of treatment, drug allergy and clinical misuse or abuse. Retrospective drug utilization review involves ongoing and periodic examination of claims data to identify patterns of fraud, abuse, gross overuse, or medically unnecessary care and implements corrective action when needed. |
| Relationship | |
 Drug Utilization Review Detail_Treatment Review_FK |
|
| Primary Key | |
 Drug Utilization Review Detail PK |
|
| Dependencies | |
 |
|
| |
|
| Reverse Dependencies | |
 |
|
| Attribute Details |
Clinical Significance Code Sk
| Description | Code identifying the significance or severity level of a clinical event. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Drug Information Source Ind
| Description | Indicates the source of drug information for DUR processing. For Example: First Databank Medi-Span Redbook PBM |
| Data Type | Standards - Data Domains.ddm/Data Domains/Single Letter [CHAR(1)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Effective From Dt
| Description | Establishes a period where a set of attributes are true according to the business. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Effective To Dt
| Description | Ends a period of effectivity. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Load Info Sk
| Description | The surrogate key of the load information entry describing the details regarding the loading of the row. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Other Pharmacy Ind
| Description | Indicates the relationship of the pharmacy responsible for the previous event involved in the DUR conflict. For Example: Different Pharmacy Same Pharmacy Not Applicable |
| Data Type | Standards - Data Domains.ddm/Data Domains/Single Letter [CHAR(1)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Other Prescriber Ind
| Description | Indicates the relationship of the prescriber responsible for the previous event involved in the DUR conflict. For Example: Different Prescriber Same Prescriber Not Applicable |
| Data Type | Standards - Data Domains.ddm/Data Domains/Single Letter [CHAR(1)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Review Reason Code Sk
| Description | Indicates the reason for medical treatment review. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Source Code Sk
| Description | The origin of the data identifying the actual load source, vendor, manual key entry, or context of the data in a specific row in the database. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Tenant Sk
| Description | The surrogate key of the entry identifying the legal owner of the data. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Treatment Review Sk
| Description | Anchor surrogate key for the Medical Treatment Review data. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG] |
| Is Part Of PrimaryKey | true |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Valid From Ts
| Description | Establishes a period where a set of attributes are true in the source system. This would be populated with the transaction timestamp and would be used for the snapshot date. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP] |
| Is Part Of PrimaryKey | true |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Valid To Ts
| Description | Ends a period of validity. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Drug Utilization Review Detail_Treatment Review_FK
| Is Identifying Relationship | true |
| Child Table | Drug Utilization Review Detail |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Treatment Review |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Primary Key Details |
Drug Utilization Review Detail PK
| Key Attribute | Treatment Review Sk |
| Key Attribute | Valid From Ts |
| Atomic Warehouse Model Data Model |