Entity Order Master

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

Attributes
Challenge Information TxtChallenge Information Txt
Confidentiality LevelConfidentiality Level
Conversion FactorConversion Factor
Imaging ModalityImaging Modality
Item CodeItem Code
Item DescrItem Descr
Manufacturer Labeler Identification CdManufacturer Labeler Identification Cd
Nature Of ServiceNature Of Service
Observation DescObservation Desc
Observation Quantity TypeObservation Quantity Type
Orderability IndOrderability Ind
Orderable Item TypeOrderable Item Type
Order Item SeqOrder Item Seq
Order Master Date and TimeOrder Master Date and Time
Order Master Modification Date and TimeOrder Master Modification Date and Time
Order Master StatusOrder Master Status
Order Master Status Date and TimeOrder Master Status Date and Time
Order Master Status ReasonOrder Master Status Reason
Order Set IndOrder Set Ind
Outside Site Phone NumOutside Site Phone Num
Patient Chargeable IndPatient Chargeable Ind
Permitted Data TypePermitted Data Type
Point Vs IntervalPoint Vs Interval
Portable Device IndPortable Device Ind
Preferred Observation Long NamePreferred Observation Long Name
Preferred Observation Report NamePreferred Observation Report Name
Preferred Observation Short NamePreferred Observation Short Name
Procedure MedicationProcedure Medication
Processing Time Minutes CntProcessing Time Minutes Cnt
Reflex Test Trigger TxtReflex Test Trigger Txt
Relationship Modifier CodeRelationship Modifier Code
Report Display SeqReport Display Seq
Report Sub Header TxtReport Sub Header Txt
Responsible Phone NumResponsible Phone Num
Specimen Required IndSpecimen Required Ind
Stocked Item IndStocked Item Ind
Target Anatomic Test SiteTarget Anatomic Test Site
Taxable Item IndTaxable Item Ind
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

Relationship
Charge MasterCharge Master
Orderable Item_Charge Master_FKOrderable Item_Charge Master_FK
Order Master_Medication_FKOrder Master_Medication_FK

Dependencies
 NONE

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 Level
DescriptionThe level of security, sensitivity or both surrounding the order master item.

For Example:
Sensitive
Not Sensitive
Highly Sensitive
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



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



 Imaging Modality
DescriptionThe type of equipment required to complete imaging procedure.

For Example:
X-ray
Computed Tomography
Magnetic Resonance Imaging
UltraSound
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Item Code
DescriptionIdentifies the order master item.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Item Descr
DescriptionA textual description of the order master item.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Manufacturer Labeler Identification Cd
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



 Nature Of Service
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/Enumeration [VARCHAR(20)]
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
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
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 Type
DescriptionIndicates the order category.

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



 Order Item Seq
DescriptionIndicates the placement of this order item within the order set.
Data TypeStandards - Data Domains.ddm/Data Domains/Sequence Number [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Order Master Date and Time
DescriptionThe date and time when an order master item is available for ordering.
Data TypeStandards - Data Domains.ddm/Data Domains/Date Time [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Order Master Modification Date and Time
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



 Order Master Status
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 Date and Time
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
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
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/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Point Vs Interval
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/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Portable Device Ind
DescriptionAn indicator that shows whether a portable device can be used for the service, test or observation.

For example:
A portable x-ray 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 Name
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 Name
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 Name
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
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/Enumeration [VARCHAR(20)]
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
DescriptionIndicates the relationship category of the observation to a subject.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
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



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



 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

Relationship Details

 Charge Master
Is Identifying Relationshipfalse
Child TableOrder Master
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableOrganization
Parent MultiplicityZERO_TO_ONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Orderable Item_Charge Master_FK
Is Identifying Relationshipfalse
Child TableOrder Master
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableCharge Master
Parent MultiplicityZERO_TO_MANY
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Order Master_Medication_FK
Is Identifying Relationshipfalse
Child TableOrder Master
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableMedication
Parent MultiplicityZERO_TO_MANY
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE