| Business Data Model Data Model |
Description | A catalog of all materials or services that can be ordered. |
Relationship | |
![]() |
|
![]() |
|
![]() |
Dependencies | |
![]() |
Reverse Dependencies | |
![]() |
Attribute Details |
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 |
Description | The level of security, sensitivity or both 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 |
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 |
Description | The type of equipment required to complete imaging procedure. For Example: X-ray 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 |
Description | Identifies the order master item. |
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 |
Description | A textual description of 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 |
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 |
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 |
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 |
Description | The underlying property represented by this observation that distinguishes, for example, concentrations from total amounts, molar concentrations from mass concentrations, partial pressures from colors (see 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 is classed as a mass concentration. A sodium is 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 is 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 and 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 |
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 |
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/Enumeration [VARCHAR(20)] |
Is Part Of PrimaryKey | false |
Is Required | true |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the placement of this order 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 |
Description | The date and time when an order master item is available for ordering. |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
Description | An indicator that shows whether a portable device can be used for the service, test or observation. For example: A portable x-ray 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 |
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 |
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 |
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 |
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 |
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 |
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 |
Description | Indicates the relationship category of the observation to a subject. |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
Description | Identifies the universal product code for the item in the order master. |
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 |
Relationship Details |
Is Identifying Relationship | false |
Child Table | Order Master |
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 | Organization |
Parent Multiplicity | ZERO_TO_ONE |
Parent Referential Integrity: On Delete | NONE |
Parent Referential Integrity: On Insert | NONE |
Parent Referential Integrity: On Update | NONE |
Is Identifying Relationship | false |
Child Table | Order Master |
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 | Charge Master |
Parent Multiplicity | ZERO_TO_MANY |
Parent Referential Integrity: On Delete | NONE |
Parent Referential Integrity: On Insert | NONE |
Parent Referential Integrity: On Update | NONE |
Is Identifying Relationship | false |
Child Table | Order Master |
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 | Medication |
Parent Multiplicity | ZERO_TO_MANY |
Parent Referential Integrity: On Delete | NONE |
Parent Referential Integrity: On Insert | NONE |
Parent Referential Integrity: On Update | NONE |
| Business Data Model Data Model |