Entity Order Master Detail

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

Attributes
Challenge Information TxtChallenge Information Txt
Confidentiality Code SkConfidentiality Code Sk
Conversion RtConversion Rt
Effective DttmEffective Dttm
Effective From DtEffective From Dt
Effective To DtEffective To Dt
Imaging Measurement Modality Code SkImaging Measurement Modality Code Sk
Item Code SkItem Code Sk
Load Info SkLoad Info Sk
Manufacturer Labeler Identification NumManufacturer Labeler Identification Num
Modification DttmModification Dttm
Nature Of Service Code SkNature Of Service Code Sk
Observation DescObservation Desc
Observation Quantity Type Code SkObservation Quantity Type Code Sk
Orderability IndOrderability Ind
Orderable Item Code SkOrderable Item Code Sk
Orderable Item Type Code SkOrderable Item Type Code Sk
Order Master SkOrder Master Sk
Order Master Status CdOrder Master Status Cd
Order Master Status DtOrder Master Status Dt
Order Master Status Reason CdOrder Master Status Reason Cd
Order Set IndOrder Set Ind
Outside Site Phone NumOutside Site Phone Num
Patient Chargeable IndPatient Chargeable Ind
Permitted Data Type Code SkPermitted Data Type Code Sk
Point Vs Interval Code SkPoint Vs Interval Code Sk
Portable Device IndPortable Device Ind
Preferred Observation Long NmPreferred Observation Long Nm
Preferred Observation Report NmPreferred Observation Report Nm
Preferred Observation Short NmPreferred Observation Short Nm
Procedure Medication Code SkProcedure Medication Code Sk
Processing Time Minutes CntProcessing Time Minutes Cnt
Reflex Test Trigger TxtReflex Test Trigger Txt
Relationship Modifier Code SkRelationship Modifier Code Sk
Report Display SeqReport Display Seq
Report Sub Header TxtReport Sub Header Txt
Responsible Phone NumResponsible Phone Num
Source Code SkSource Code Sk
Specimen Required IndSpecimen Required Ind
Stocked Item IndStocked Item Ind
Target Anatomic Test Site Code SkTarget Anatomic Test Site Code Sk
Taxable Item IndTaxable Item Ind
Tenant SkTenant Sk
Test Method DescTest Method Desc
Track Department Usage IndTrack Department Usage Ind
Typical Turn Around Time Minutes CntTypical Turn Around Time Minutes Cnt
UPC CdUPC Cd
Valid From TsValid From Ts
Valid To TsValid To Ts

Relationship
Orderable Item Detail_Orderable Item_FKOrderable Item Detail_Orderable Item_FK

Primary Key
Order Master Detail PKOrder Master Detail PK

Dependencies
 
 

Reverse Dependencies
 

Attribute Details

 Challenge Information Txt
DescriptionDescriptive text providing information about the challenge component of a test.

For Example:
Tests that include a glucose challenge.
Data TypeStandards - Data Domains.ddm/Data Domains/Free Text [VARCHAR(1024)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Confidentiality Code Sk
DescriptionIndicates the level of security and/or sensitivity surrounding the order master item.

For Example:
Sensitive
Not Sensitive
Highly Sensitive
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Conversion Rt
DescriptionThe conversion factor used for the order master item.
Data TypeStandards - Data Domains.ddm/Data Domains/Rate Precision 9 [FLOAT(9)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Effective Dttm
DescriptionThis 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 TypeStandards - Data Domains.ddm/Data Domains/Date Time [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Effective From Dt
DescriptionEstablishes a period where a set of attributes are true according to the business.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Effective To Dt
DescriptionEnds a period of effectivity.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Imaging Measurement Modality Code Sk
DescriptionIndicates the type of equipment required to complete imaging procedure.

For Example:
XRay
Computed Tomography
Magnetic Resonance Imaging
UltraSound
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Item Code Sk
DescriptionIdentifies the order master item.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Load Info Sk
DescriptionThe surrogate key of the load information entry describing the details regarding the loading of the row.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Manufacturer Labeler Identification Num
DescriptionA number assigned to the manufacturer that manufactured the order master item.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Modification Dttm
DescriptionThe date and time that the order master is edited.
Data TypeStandards - Data Domains.ddm/Data Domains/Date Time [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Nature Of Service Code Sk
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Observation Desc
DescriptionContains a text description of the observation type.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Observation Quantity Type Code Sk
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Orderability Ind
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Orderable Item Code Sk
DescriptionIdentifies the order master item.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Orderable Item Type Code Sk
DescriptionIndicates the order category.

For Example:
Medications,
Clinical Observations
Laboratory Exams
Food
Radiology Exams
Linens
Medical Supplies
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Order Master Sk
DescriptionSurrogate key for the anchor entity.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Order Master Status Cd
DescriptionDescribes the state of the order master.

For Example:
Active
Pending Approval
Under Review
Prohibited for Use
Inactive
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Order Master Status Dt
DescriptionThe date and time when the status of the order master was changed.
Data TypeStandards - Data Domains.ddm/Data Domains/Date Time [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Order Master Status Reason Cd
DescriptionIndicates the reason for the order master status update.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Order Set Ind
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Outside Site Phone Num
DescriptionThe telephone number of the outside site.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Patient Chargeable Ind
DescriptionIndicates whether or not the order master item is chargeable to the patient.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Permitted Data Type Code Sk
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Point Vs Interval Code Sk
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Portable Device Ind
DescriptionIndicates whether or not a portable device may be used for the service/test/observation.

For Example:
A portable xray machine
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Preferred Observation Long Nm
DescriptionThe preferred long name for the observation.
Data TypeStandards - Data Domains.ddm/Data Domains/Name Long [VARCHAR(255)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Preferred Observation Report Nm
DescriptionThe preferred report name for the observation.
Data TypeStandards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Preferred Observation Short Nm
DescriptionThe preferred short name for the observation.
Data TypeStandards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Procedure Medication Code Sk
DescriptionIndicates the medications needed as part of the procedure.

For example:
Radioactive iodine for a thyroid screen
Methacholine for a methacholine spirometry challenge
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Processing Time Minutes Cnt
DescriptionIndicates the length of time between the start of a test process and its completion.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Reflex Test Trigger Txt
DescriptionThe descriptive text which contains the rules that trigger the reflex tests.
Data TypeStandards - Data Domains.ddm/Data Domains/Free Text [VARCHAR(1024)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Relationship Modifier Code Sk
DescriptionIndicates the relationship category of the observation to a subject.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Report Display Seq
DescriptionIdentifies the sort order in which this observation is presented in a standard report or display that contains the many observations.
Data TypeStandards - Data Domains.ddm/Data Domains/Sequence Number [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Report Sub Header Txt
DescriptionIdentifies the name of the sub header to be used in a report.
Data TypeStandards - Data Domains.ddm/Data Domains/Text Medium [VARCHAR(255)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Responsible Phone Num
DescriptionThe contact number of the responsible parties to ask results or advice about the use of the test.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Source Code Sk
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Specimen Required Ind
DescriptionIndicates whether or not at least one specimen is required for the service/test/observation.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Stocked Item Ind
DescriptionIndicates whether or not the order master item is stocked in any inventory location in the healthcare organization.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Target Anatomic Test Site Code Sk
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Taxable Item Ind
DescriptionIndicates whether or not the item is taxable when purchasing the item or issuing the item to patients.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Tenant Sk
DescriptionThe surrogate key of the entry identifying the legal owner of the data.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Test Method Desc
DescriptionContains the text description of the methods used to perform the text and generate the observations. Bibliographic citations may be included.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Track Department Usage Ind
DescriptionIndicates whether or not the usage figures are tracked for this order master item by a department.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Typical Turn Around Time Minutes Cnt
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 UPC Cd
DescriptionIdentifies the universal product code for the item in the order master.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Valid From Ts
DescriptionEstablishes 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 TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Valid To Ts
DescriptionEnds a period of validity.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Orderable Item Detail_Orderable Item_FK
Is Identifying Relationshiptrue
Child TableOrder Master Detail
Child Role Namehas detail for
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableOrder Master
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE

Primary Key Details

 Order Master Detail PK
Key AttributeOrder Master Sk
Key AttributeValid From Ts