Dimensional Warehouse Model Data Model

Entity

Entity Formulary Dimension

Description

A catalog of medications that has been approved for use within a facility.

Attributes
AWM Load Info Sk
Challenge Information Txt
Charge Active Ind
Charge Contract Num
Charge Desc
Charge Description Override Ind
Charge Full Desc
Charge Generic Relative Value Unit Qty
Charge Generic Relative Value Unit UOM Cd
Charge Generic Relative Value Unit UOM Code Descr
Charge Generic Relative Value Unit UOM Code Sk
Charge Num
Charge Room Fee Charge Ind
Confidentiality Level Cd
Confidentiality Level Code Descr
Confidentiality Level Code Sk
Conversion Factor
Currency Cd
Currency Code Descr
Currency Code Sk
Current Ind
DWM Load Info Sk
Effective From Dt
Effective To Dt
Formulary Barcode
Formulary Bk
Formulary Descr
Formulary Dimension Dk
Formulary Entry Compound Ind
Formulary Entry Co-Payment Amt
Formulary Entry Co-Payment Pct
Formulary Entry Effective Date and Tm
Formulary Entry Fee Amt
Formulary Nm
Formulary Sk
Formulary Tier Descr
Formulary Tier Level
Formulary Tier Nm
Imaging Modality Cd
Imaging Modality Code Descr
Imaging Modality Code Sk
Item Cd
Item Code Descr
Item Code Sk
Item Descr
Manufacturer Labeler Identification Cd
Manufacturer Labeler Identification Code Descr
Manufacturer Labeler Identification Code Sk
Nature Of Service Cd
Nature Of Service Code Descr
Nature Of Service Code Sk
Number Of Tiers
Observation Desc
Observation Quantity Type Cd
Observation Quantity Type Code Descr
Observation Quantity Type Code Sk
Orderability Ind
Orderable Item Type Cd
Orderable Item Type Code Descr
Orderable Item Type Code Sk
Order Item Seq
Order Master Date and Tm
Order Master Modification Date and Tm
Order Master Status Cd
Order Master Status Code Descr
Order Master Status Code Sk
Order Master Status Date and Tm
Order Master Status Reason Cd
Order Master Status Reason Code Descr
Order Master Status Reason Code Sk
Order Set Ind
Outside Site Phone Num
Patient Chargeable Ind
Permitted Data Type Cd
Permitted Data Type Code Descr
Permitted Data Type Code Sk
Point Vs Interval Cd
Point Vs Interval Code Descr
Point Vs Interval Code Sk
Portable Device Ind
Preferred Observation Long Nm
Preferred Observation Report Nm
Preferred Observation Short Nm
Procedure Medication Cd
Procedure Medication Code Descr
Procedure Medication Code Sk
Processing Time Minutes Cnt
Product Dosage Form Cd
Product Dosage Form Code Descr
Product Dosage Form Code Sk
Reflex Test Trigger Txt
Relationship Modifier Cd
Relationship Modifier Code Descr
Relationship Modifier Code Sk
Report Display Seq
Report Sub Header Txt
Responsible Phone Num
Route Type Cd
Route Type Code Descr
Route Type Code Sk
Source Cd
Source Code Descr
Source Code Sk
Specimen Required Ind
Standard Formulary Co-Payment Amt
Standard Formulary Co-Payment Pct
Standard Formulary Tier Co-Payment Amt
Standard Formulary Tier Co-Payment Pct
Stocked Item Ind
Strength Qty
Strength Volume UOM Cd
Strength Volume UOM Code Descr
Strength Volume UOM Code Sk
Target Anatomic Test Site Cd
Target Anatomic Test Site Code Descr
Target Anatomic Test Site Code Sk
Taxable Item Ind
Tenant Sk
Test Method Desc
Track Department Usage Ind
Typical Turn Around Time Minutes Cnt
UPC Cd
UPC Code Descr
UPC Code Sk
Valid From Ts
Valid To Ts

Primary Key
Formulary Dimension PK

Dependencies

Reverse Dependencies

Attribute Details

AWM Load Info Sk

Description	The surrogate key of the load information entry describing the details regarding the loading of the row in the atomic data warehouse.
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

Challenge Information Txt

Description	Descriptive text providing information about the challenge component of a test. For Example: Tests that include a glucose challenge.
Data Type	Standards - Data Domains.ddm/Data Domains/Free Text [VARCHAR(1024)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Charge Active Ind

Description	Indicates whether this is a usable charge master item.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Charge Contract Num

Description	The contract identifier pertaining to the charge master item. For Example: Supplier contract Service contract
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Charge Desc

Description	The short description of the charge master item.
Data Type	Standards - Data Domains.ddm/Data Domains/Description Short [VARCHAR(150)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Charge Description Override Ind

Description	Indicates whether the charge master item's description can be overridden.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Charge Full Desc

Description	The full or long text description of the charge master item.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Charge Generic Relative Value Unit Qty

Description	RVU factor defined locally for use when relative factors for the complexity of an activity are needed.
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Charge Generic Relative Value Unit UOM Cd

Description	The unit of measure associated with the General Relative Value Unit Qty.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Charge Generic Relative Value Unit UOM Code Descr

Description	The unit of measure associated with the General Relative Value Unit Qty.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Charge Generic Relative Value Unit UOM Code Sk

Description	The unit of measure associated with the General Relative Value Unit Qty.
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

Charge Num

Description	The identifier pertaining to the charge master item.
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Charge Room Fee Charge Ind

Description	Indicates the room fee for a healthcare facility.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Confidentiality Level Cd

Description	Indicates the level of security and/or sensitivity surrounding the order master item. For Example: Sensitive Not Sensitive Highly Sensitive
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Confidentiality Level Code Descr

Description	Indicates the level of security and/or sensitivity surrounding the order master item. For Example: Sensitive Not Sensitive Highly Sensitive
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Confidentiality Level Code Sk

Description	Indicates the level of security and/or sensitivity surrounding the order master item. For Example: Sensitive Not Sensitive Highly Sensitive
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

Conversion Factor

Description	The conversion factor used for the order master item.
Data Type	Standards - Data Domains.ddm/Data Domains/Ratio [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Currency Cd

Description	Indicates the currency used as the basis for all monetary amounts.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Currency Code Descr

Description	Indicates the currency used as the basis for all monetary amounts.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Currency Code Sk

Description	Indicates the currency used as the basis for all monetary amounts.
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

Current Ind

Description	Set to 'Y' if this is the most recent row of a group having the same Surrogate Key.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

DWM 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

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

Formulary Barcode

Description	The unique barcode for the formulary drug.
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Formulary Bk

Description	Concatenated values of a set of business attributes that uniquely identify the row.
Data Type	Standards - Data Domains.ddm/Data Domains/Business Key [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Formulary Descr

Description	Descriptive information about the formulary.
Data Type	Standards - Data Domains.ddm/Data Domains/Text Medium [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Formulary Dimension Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
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	true

Formulary Entry Compound Ind

Description	Indicates if the Formulary entry is a compound of other Formulary entries.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Formulary Entry Co-Payment Amt

Description	The standard specific co-payment amount applied to a drug on this Formulary.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Formulary Entry Co-Payment Pct

Description	The standard specific co-payment percentage applied to a drug on this Formulary.
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Formulary Entry Effective Date and Tm

Description	Establishes a period where the set of attributes are true according to the business. The receiving system shall assume that any values that come across under this Formulary ID are now under the new formulary after this date and take appropriate steps to distinguish the old from the new entries.
Data Type	Standards - Data Domains.ddm/Data Domains/Date Time [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Formulary Entry Fee Amt

Description	The standard amount charged for the given drug on this Formulary.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Formulary Nm

Description	The word or phrase used to identify the formulary.
Data Type	Standards - Data Domains.ddm/Data Domains/String [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Formulary Sk

Description	A numeric surrogate key used to uniquely identify entities in the atomic model.
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

Formulary Tier Descr

Description	Detailed information about the formulary tier.
Data Type	Standards - Data Domains.ddm/Data Domains/Text Medium [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Formulary Tier Level

Description	Identifies the formulary tier level within the whole formulary. For Example: First Tier Second Tier Third Tier
Data Type	Standards - Data Domains.ddm/Data Domains/Small Counter [SHORT]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Formulary Tier Nm

Description	The word or phrase used to identify the formulary tier.
Data Type	Standards - Data Domains.ddm/Data Domains/String [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Imaging Modality Cd

Description	Indicates the type of equipment required to complete imaging procedure. For Example: XRay Computed Tomography Magnetic Resonance Imaging UltraSound
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Imaging Modality Code Descr

Description	Indicates the type of equipment required to complete imaging procedure. For Example: XRay Computed Tomography Magnetic Resonance Imaging UltraSound
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Imaging Modality Code Sk

Description	Indicates the type of equipment required to complete imaging procedure. For Example: XRay Computed Tomography Magnetic Resonance Imaging UltraSound
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

Item Cd

Description	Identifies the order master item.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Item Code Descr

Description	Identifies the order master item.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Item Code Sk

Description	Identifies the order master item.
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

Item Descr

Description	Identifies the order master item.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Manufacturer Labeler Identification Cd

Description	A number assigned to the manufacturer that manufactured the order master item.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Manufacturer Labeler Identification Code Descr

Description	A number assigned to the manufacturer that manufactured the order master item.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Manufacturer Labeler Identification Code Sk

Description	A number assigned to the manufacturer that manufactured the order master item.
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

Nature Of Service Cd

Description	Indicates whether the definition entry identifies a test battery, an entire functional procedure or study, a single test value (observation), multiple test batteries or functional procedures as an orderable unit (profile), or a single test value (observation) calculated from other independent observations.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Nature Of Service Code Descr

Description	Indicates whether the definition entry identifies a test battery, an entire functional procedure or study, a single test value (observation), multiple test batteries or functional procedures as an orderable unit (profile), or a single test value (observation) calculated from other independent observations.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Nature Of Service Code Sk

Description	Indicates whether the definition entry identifies a test battery, an entire functional procedure or study, a single test value (observation), multiple test batteries or functional procedures as an orderable unit (profile), or a single test value (observation) calculated from other independent observations.
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

Number Of Tiers

Description	The total number of tiers defined for the formulary. For Example: Tier 1 has the lowest co-payment Tier 2 has a higher co-payment Tier 3 has the highest co-payment
Data Type	Standards - Data Domains.ddm/Data Domains/Small Counter [SHORT]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Observation Desc

Description	Contains a text description of the observation type.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Observation Quantity Type Cd

Description	Indicates the underlying kind of property represented by this observation. This distinguishes concentrations from total amounts, molar concentrations from mass concentrations, partial pressures from colors, and so forth. These are discussed more fully in the LOINC Users' Manual. They are derived from the approach described in 1995 edition of the IUPAC Silver Book. These distinctions are used in IUPAC and LOINC standard codes. Defined categories are listed in Kind of Quantity. For Example: A glucose would be classed as a mass concentration. A sodium would be classed as a substance concentration. Within the family, a total amount should be described as the unadorned variant; for example, the property of measure for a patient's weight would be mass, not mass content. Most chemical measures produce concentrations, as exemplified by sodium and glucose. However, a 24-hour urine protein is not a mass concentration, but a mass rate (mass per unit time). The content variants (for example, mass content, substance content) are used to reflect an amount per mass (usually) of tissue.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Observation Quantity Type Code Descr

Description	Indicates the underlying kind of property represented by this observation. This distinguishes concentrations from total amounts, molar concentrations from mass concentrations, partial pressures from colors, and so forth. These are discussed more fully in the LOINC Users' Manual. They are derived from the approach described in 1995 edition of the IUPAC Silver Book. These distinctions are used in IUPAC and LOINC standard codes. Defined categories are listed in Kind of Quantity. For Example: A glucose would be classed as a mass concentration. A sodium would be classed as a substance concentration. Within the family, a total amount should be described as the unadorned variant; for example, the property of measure for a patient's weight would be mass, not mass content. Most chemical measures produce concentrations, as exemplified by sodium and glucose. However, a 24-hour urine protein is not a mass concentration, but a mass rate (mass per unit time). The content variants (for example, mass content, substance content) are used to reflect an amount per mass (usually) of tissue.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Observation Quantity Type Code Sk

Description	Indicates the underlying kind of property represented by this observation. This distinguishes concentrations from total amounts, molar concentrations from mass concentrations, partial pressures from colors, and so forth. These are discussed more fully in the LOINC Users' Manual. They are derived from the approach described in 1995 edition of the IUPAC Silver Book. These distinctions are used in IUPAC and LOINC standard codes. Defined categories are listed in Kind of Quantity. For Example: A glucose would be classed as a mass concentration. A sodium would be classed as a substance concentration. Within the family, a total amount should be described as the unadorned variant; for example, the property of measure for a patient's weight would be mass, not mass content. Most chemical measures produce concentrations, as exemplified by sodium and glucose. However, a 24-hour urine protein is not a mass concentration, but a mass rate (mass per unit time). The content variants (for example, mass content, substance content) are used to reflect an amount per mass (usually) of tissue.
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

Orderability Ind

Description	Indicates whether or not a service/test/observation is an orderable item. For Example: A blood differential count is usually an orderable laboratory test but MCV contained within the differential count, is usually not independently orderable.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Orderable Item Type Cd

Description	Indicates the order category. For Example: Medications, Clinical Observations Laboratory Exams Food Radiology Exams Linens Medical Supplies
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Orderable Item Type Code Descr

Description	Indicates the order category. For Example: Medications, Clinical Observations Laboratory Exams Food Radiology Exams Linens Medical Supplies
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Orderable Item Type Code Sk

Description	Indicates the order category. For Example: Medications, Clinical Observations Laboratory Exams Food Radiology Exams Linens Medical Supplies
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

Order Item Seq

Description	A number indicating the placement of this order set item within the order set.
Data Type	Standards - Data Domains.ddm/Data Domains/Sequence Number [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Order Master Date and Tm

Description	The date and time when the status of the order master was changed.
Data Type	Standards - Data Domains.ddm/Data Domains/Date Time [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Order Master Modification Date and Tm

Description	The date and time that the order master is edited.
Data Type	Standards - Data Domains.ddm/Data Domains/Date Time [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Order Master Status Cd

Description	Describes the state of the order master. For Example: Active Pending Approval Under Review Prohibited for Use Inactive
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Order Master Status Code Descr

Description	Describes the state of the order master. For Example: Active Pending Approval Under Review Prohibited for Use Inactive
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Order Master Status Code Sk

Description	Describes the state of the order master. For Example: Active Pending Approval Under Review Prohibited for Use Inactive
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

Order Master Status Date and Tm

Description	The date and time when the status of the order master was changed.
Data Type	Standards - Data Domains.ddm/Data Domains/Date Time [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Order Master Status Reason Cd

Description	Indicates the reason for the order master status update.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Order Master Status Reason Code Descr

Description	Indicates the reason for the order master status update.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Order Master Status Reason Code Sk

Description	Indicates the reason for the order master status update.
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

Order Set Ind

Description	Indicates whether or not the order master item is in a set of items rather than an individual item. For Example: A set of surgical supplies
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Outside Site Phone Num

Description	The telephone number of the outside site.
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Patient Chargeable Ind

Description	Indicates whether or not the order master item is chargeable to the patient.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Permitted Data Type Cd

Description	Indicates the allowed data types for this observation. A given observation may, under different circumstances, take on different data types. Indeed, under limited circumstances, an observation can consist of one or more fragments of different data types.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Permitted Data Type Code Descr

Description	Indicates the allowed data types for this observation. A given observation may, under different circumstances, take on different data types. Indeed, under limited circumstances, an observation can consist of one or more fragments of different data types.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Permitted Data Type Code Sk

Description	Indicates the allowed data types for this observation. A given observation may, under different circumstances, take on different data types. Indeed, under limited circumstances, an observation can consist of one or more fragments of different data types.
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

Point Vs Interval Cd

Description	Indicates whether the ordered observations measuring the patient's state are done over an interval or at a point in time. For Example: Point in time type observations apply to include spot urines, random urines, serum potassium Interval type observations apply to 24-hour urines, 24-hour holter monitor
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Point Vs Interval Code Descr

Description	Indicates whether the ordered observations measuring the patient's state are done over an interval or at a point in time. For Example: Point in time type observations apply to include spot urines, random urines, serum potassium Interval type observations apply to 24-hour urines, 24-hour holter monitor
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Point Vs Interval Code Sk

Description	Indicates whether the ordered observations measuring the patient's state are done over an interval or at a point in time. For Example: Point in time type observations apply to include spot urines, random urines, serum potassium Interval type observations apply to 24-hour urines, 24-hour holter monitor
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

Portable Device Ind

Description	Indicates whether or not a portable device may be used for the service/test/observation. For Example: A portable xray machine
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Preferred Observation Long Nm

Description	The preferred long name for the observation.
Data Type	Standards - Data Domains.ddm/Data Domains/Name Long [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Preferred Observation Report Nm

Description	The preferred report name for the observation.
Data Type	Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Preferred Observation Short Nm

Description	The preferred short name for the observation.
Data Type	Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Procedure Medication Cd

Description	Indicates the medications needed as part of the procedure. For example: Radioactive iodine for a thyroid screen Methacholine for a methacholine spirometry challenge
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Procedure Medication Code Descr

Description	Indicates the medications needed as part of the procedure. For example: Radioactive iodine for a thyroid screen Methacholine for a methacholine spirometry challenge
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Procedure Medication Code Sk

Description	Indicates the medications needed as part of the procedure. For example: Radioactive iodine for a thyroid screen Methacholine for a methacholine spirometry challenge
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

Processing Time Minutes Cnt

Description	Indicates the length of time between the start of a test process and its completion.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Product Dosage Form Cd

Description	Indicates the manner in which the medication/treatment is aggregated for dispensing. For Example: Tablets Capsules Suppositories
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Product Dosage Form Code Descr

Description	Indicates the manner in which the medication/treatment is aggregated for dispensing. For Example: Tablets Capsules Suppositories
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Product Dosage Form Code Sk

Description	Indicates the manner in which the medication/treatment is aggregated for dispensing. For Example: Tablets Capsules Suppositories
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

Reflex Test Trigger Txt

Description	The descriptive text which contains the rules that trigger the reflex tests.
Data Type	Standards - Data Domains.ddm/Data Domains/Free Text [VARCHAR(1024)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Relationship Modifier Cd

Description	Indicates the relationship category of the observation to a subject.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Relationship Modifier Code Descr

Description	Indicates the relationship category of the observation to a subject.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Relationship Modifier Code Sk

Description	Indicates the relationship category of the observation to a subject.
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

Report Display Seq

Description	Identifies the sort order in which this observation is presented in a standard report or display that contains the many observations.
Data Type	Standards - Data Domains.ddm/Data Domains/Sequence Number [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Report Sub Header Txt

Description	Identifies the name of the sub header to be used in a report.
Data Type	Standards - Data Domains.ddm/Data Domains/Text Medium [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Responsible Phone Num

Description	The contact number of the responsible parties to ask results or advice about the use of the test.
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Route Type Cd

Description	Identifies the route of administration. For Example: Apply Externally Buccal Dental Intravenous Oral Intra-arterial
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Route Type Code Descr

Description	Identifies the route of administration. For Example: Apply Externally Buccal Dental Intravenous Oral Intra-arterial
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Route Type Code Sk

Description	Identifies the route of administration. For Example: Apply Externally Buccal Dental Intravenous Oral Intra-arterial
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 Cd

Description	The code that corresponds to the Source Code Sk.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Source Code Descr

Description	The description that corresponds to the Source Type Cd.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	true
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

Specimen Required Ind

Description	Indicates whether or not at least one specimen is required for the service/test/observation.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Standard Formulary Co-Payment Amt

Description	The standard specific co-payment amount applying to all medications from the Formulary if not specified for the individual medications.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Standard Formulary Co-Payment Pct

Description	The standard specific co-payment percentage applying to all medications from the Formulary if not specified for the individual medications.
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Standard Formulary Tier Co-Payment Amt

Description	The standard specific co-payment amount applying to all medications from the Formulary Tier if not specified for the individual medications.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Standard Formulary Tier Co-Payment Pct

Description	The standard specific co-payment percentage applying to all medications from the Formulary Tier if not specified for the individual medications.
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Stocked Item Ind

Description	Indicates whether or not the order master item is stocked in any inventory location in the healthcare organization.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Strength Qty

Description	The numeric part of the strength used in combination with Strength Unit of Measure. For Example: Acetaminophen 500mgs. The strength quantity is 500.
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Strength Volume UOM Cd

Description	Identifies the units in which the volume of the medication is expressed. For example: Acetaminophen 500mgs. The unit of measure is mgs.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Strength Volume UOM Code Descr

Description	Identifies the units in which the volume of the medication is expressed. For example: Acetaminophen 500mgs. The unit of measure is mgs.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Strength Volume UOM Code Sk

Description	Identifies the units in which the volume of the medication is expressed. For example: Acetaminophen 500mgs. The unit of measure is mgs.
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

Target Anatomic Test Site Cd

Description	Indicates the site on a patient's body that is the area of observation during an ordered test or exam.. For example, heart might be recorded as the target of the electrocardiogram, cardiac echo, and thallium exercise test.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Target Anatomic Test Site Code Descr

Description	Indicates the site on a patient's body that is the area of observation during an ordered test or exam.. For example, heart might be recorded as the target of the electrocardiogram, cardiac echo, and thallium exercise test.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Target Anatomic Test Site Code Sk

Description	Indicates the site on a patient's body that is the area of observation during an ordered test or exam.. For example, heart might be recorded as the target of the electrocardiogram, cardiac echo, and thallium exercise test.
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

Taxable Item Ind

Description	Indicates whether or not the item is taxable when purchasing the item or issuing the item to patients.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
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

Test Method Desc

Description	Contains the text description of the methods used to perform the text and generate the observations. Bibliographic citations may be included.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Track Department Usage Ind

Description	Indicates whether or not the usage figures are tracked for this order master item by a department.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Typical Turn Around Time Minutes Cnt

Description	Indicates the typical processing time for a single test/observation. This field indicates the time from the delivery of a specimen or transport of a patient to a diagnostic service and the completion of the study. It includes the usual waiting time.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

UPC Cd

Description	Identifies the universal product code for the item in the order master.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

UPC Code Descr

Description	Identifies the universal product code for the item in the order master.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

UPC Code Sk

Description	Identifies the universal product code for the item in the order master.
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

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	false
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

Primary Key Details

Formulary Dimension PK

Key Attribute

Formulary Dimension Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model