Dimensional Warehouse Model Data Model

Entity

Entity Order Master Dimension

Description

A catalog of all materials or services that can be ordered.

Attributes
AWM Load Info Sk
Challenge Information Txt
Confidentiality Cd
Confidentiality Code Descr
Confidentiality Code Sk
Confidentiality Level
Conversion Factor
Conversion Rt
Current Ind
DWM Load Info Sk
Effective Dttm
Effective From Dt
Effective To Dt
Imaging Measurement Modality Cd
Imaging Measurement Modality Code Descr
Imaging Measurement Modality Code Sk
Imaging Modality
Item Cd
Item Code Descr
Item Code Sk
Item Descr
Manufacturer Labeler Identification Cd
Manufacturer Labeler Identification Num
Modification Dttm
Nature Of Service
Nature Of Service Cd
Nature Of Service Code Descr
Nature Of Service Code Sk
Observation Desc
Observation Quantity Type
Observation Quantity Type Cd
Observation Quantity Type Code Descr
Observation Quantity Type Code Sk
Orderability Ind
Orderable Item Cd
Orderable Item Code Descr
Orderable Item Code Sk
Orderable Item Type
Orderable Item Type Cd
Orderable Item Type Code Descr
Orderable Item Type Code Sk
Orderable Item Type Descr
Order Item Seq
Order Master Dimension Bk
Order Master Dimension Dk
Order Master Dimension Sk
Order Master Status
Order Master Status Cd
Order Master Status Dt
Order Master Status Reason Cd
Order Set Ind
Outside Site Phone Num
Patient Chargeable Ind
Permitted Data Type
Permitted Data Type Cd
Permitted Data Type Code Descr
Permitted Data Type Code Sk
Point Vs Interval
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
Procedure Medication Cd
Procedure Medication Code Descr
Procedure Medication Code Sk
Processing Time Minutes Cnt
Reflex Test Trigger Txt
Relationship Modifier Cd
Relationship Modifier Code Descr
Relationship Modifier Code Sk
Relative Value Units
Report Display Seq
Report Sub Header Txt
Responsible Phone Num
Source Cd
Source Code Descr
Source Code Sk
Specimen Required Ind
Stocked Item Ind
Target Anatomic Test Site
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
Valid From Ts
Valid To Ts

Primary Key
Order Master 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

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

Confidentiality Level

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/Enumeration [VARCHAR(20)]
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

Conversion Rt

Description	The conversion factor used for the order master item.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate Precision 9 [FLOAT(9)]
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 Dttm

Description	This field contains the date and time of the last change in the test procedure that would make previous results incompatible with new results, e.g., the last time that normal reference range or units changed for a numeric test/observation. We strongly suggest that observation producers never use the same observation ID when the measurement procedures change in such a way that results produced under the new procedure are clinically different from those produced with the old procedure. Rather, the producer should try to adjust the new procedure so that its values are clinically indistinguishable from the old. Failing that, one should create a new observation ID for the observation produced under the new procedure. In the rare circumstances when a procedure change occurs and neither of the above two options is viable, this field shall be used to transmit the effective date/time of the new procedure. The receiving system shall assume that any values that come across under this observation ID are under the new procedure after this date and take appropriate steps to distinguish the old from the new observations. This number is included to provide a means of communicating with the observation producing service when they have questions about particular observations or results.
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

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

Imaging Measurement 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 Measurement 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 Measurement 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

Imaging Modality

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/Enumeration [VARCHAR(20)]
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/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Manufacturer Labeler Identification Num

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

Modification Dttm

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

Nature Of Service

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/Enumeration [VARCHAR(20)]
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

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

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/Enumeration [VARCHAR(20)]
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 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	true
Is Derived	false
Is Surrogate Key	false

Orderable 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	true
Is Derived	false
Is Surrogate Key	false

Orderable 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	true
Is Derived	false
Is Surrogate Key	false

Orderable Item Type

Description	Identifies the order master item.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	true
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

Orderable Item Type 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

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

Order Master 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

Order Master Dimension 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

Order Master Status

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/Enumeration [VARCHAR(20)]
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/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Order Master Status Dt

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/Enumeration [VARCHAR(20)]
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

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/Enumeration [VARCHAR(20)]
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

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/Enumeration [VARCHAR(20)]
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

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/Enumeration [VARCHAR(20)]
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

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

Relative Value Units

Description	A value assigned to establish a comprehensive valuation of an orderable item.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
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

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

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

Target Anatomic Test Site

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/Enumeration [VARCHAR(20)]
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

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

Order Master Dimension PK

Key Attribute

Order Master Dimension Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model