Dimensional Warehouse Model Data Model

Entity

Entity Procedure Event Dimension

Description

A healthcare event that is performed as part of an encounter, which usually involves an action by a practitioner treating a patient.

For example:
Major surgery
Minor surgery
Eye refraction
Wart removal
Ear lavage

Attributes
Ambulance Transport Reason Code Sk
Anesthesia Code Sk
Anesthesia Minutes Val
Associated Diagnosis Code Sk
AWM Load Info Sk
Birthing Environment Cd
Birthing Environment Code Descr
Birthing Environment Code Sk
Certification Revision Dt
Clinical Significance Cd
Clinical Significance Code Descr
Clinical Significance Code Sk
Consent Code Sk
Current Ind
Delivery Dt
Delivery Pattern Time Code Sk
Derived Ind
Duration Of Visits Ct
Duration Of Visits Unit Code Sk
DWM Load Info Sk
Effective From Dt
Effective To Dt
Emergency Ind
Frequency Ct
Image Id Num
Last Certification Dt
Last Service Dt
Locale Country Code Sk
Locale Language Code Sk
Medical Effect Expected End Dt
Medical Effect Expected Start Dt
Method Code Sk
Newborn Living Status Cd
Newborn Living Status Code Descr
Newborn Living Status Code Sk
Number of Neonatal Delivered
Oral Cavity Designation Cd
Oral Cavity Designation Code Descr
Oral Cavity Designation Code Sk
Orthodontic Banding Dt
Orthodontic Treatment Ind
Oxygen Delivery Type Cd
Oxygen Delivery Type Code Descr
Oxygen Delivery Type Code Sk
Oxygen Flow Rate Qty
Oxygen Flow Rate UOM Code Sk
Prior Placement Dt
Procedure Code Descr
Procedure Code Dk
Procedure Code Family Cd
Procedure Code Family Code Descr
Procedure Code Family Code Sk
Procedure Code Sk
Procedure Coding Method Code Sk
Procedure Event Bk
Procedure Event Dk
Procedure Event Sk
Procedure Functional Type Code Sk
Procedure Minutes Qty
Procedure Num
Procedure Outcome Cd
Procedure Outcome Code Descr
Procedure Outcome Code Sk
Procedure Priority Code Sk
Procedure Ts
Prosthesis Crown or Inlay Cd
Prosthesis Crown or Inlay Code Descr
Prosthesis Crown or Inlay Code Sk
Prosthesis Replacement Dt
Reason Code Sk
Responsivity Status Cd
Responsivity Status Code Descr
Responsivity Status Code Sk
Round Trip Purpose Descr
Service Delivery Pattern Code Sk
Side Effect Cd
Side Effect Code Descr
Side Effect Code Sk
Source Cd
Source Code Descr
Source Code Sk
Status Code Sk
Stretcher Purpose Descr
Surgery Type Cd
Surgery Type Code Descr
Surgery Type Code Sk
Tenant Sk
Tooth Cd
Tooth Code Descr
Tooth Code Sk
Tooth Num
Tooth Status Cd
Tooth Status Code Descr
Tooth Status Code Sk
Tooth Surface Cd
Tooth Surface Code Descr
Tooth Surface Code Sk
Translated Procedure Cd
Translated Procedure Code Descr
Translated Procedure Code Family Cd
Translated Procedure Code Family Code Descr
Translated Procedure Code Family Code Sk
Translated Procedure Code Sk
Translation Dt
Translation Rule Applied
Translation Rule Descr
Transport Distance Qty
Transport Distance UOM Code Sk
Valid From Ts
Valid To Ts
Visit Ct
X-Ray Availability Ind

Relationship
Procedure Event Dimension_Procedure Code Dimension_FK

Primary Key
Procedure Event Dimension PK

Dependencies

Reverse Dependencies

Attribute Details

Ambulance Transport Reason Code Sk

Description	Indicates the reason for an ambulance transport.
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

Anesthesia Code Sk

Description	Identifies the anesthesia used during the procedure.
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

Anesthesia Minutes Val

Description	The length of time expressed in minutes that the anesthesia was administered.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Associated Diagnosis Code Sk

Description	Identifies the diagnosis that is the primary reason this procedure was performed. Diagnosis codes are generally recorded using the International Classification of Diseases ICD-9 or ICD-10 coding systems. For example: In the US, Medicare wants to know for which diagnosis this procedure is submitted for inclusion on CMS 1500 form.
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

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

Birthing Environment Cd

Description	Indicates whether the birth took place at home or in a birthing center or otherwise.
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

Birthing Environment Code Descr

Description	Indicates whether the birth took place at home or in a birthing center or otherwise.
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

Birthing Environment Code Sk

Description	Indicates whether the birth took place at home or in a birthing center or otherwise.
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

Certification Revision Dt

Description	The date upon which the certification for the procedure was revised.
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

Clinical Significance Cd

Description	A code identifying the importance or severity level of the procedure.
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

Clinical Significance Code Descr

Description	A code identifying the importance or severity level of the procedure.
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

Clinical Significance Code Sk

Description	A code identifying the importance or severity level of the procedure.
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

Consent Code Sk

Description	Indicates the type of consent that was obtained for permission to treat the patient.
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

Delivery Dt

Description	The actual date upon which the newborn is delivered.
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

Delivery Pattern Time Code Sk

Description	Indicates the time delivery pattern of the services. For example: A.M. P.M. As Directed
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

Derived Ind

Description	Indicates whether the Procedure was submitted or derived.
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

Duration Of Visits Ct

Description	The number of units (month, week, etc.) over which home health visits occur. For example: 1 visit every 3 days for 21 days. This element indicates the number of units, in this case - 21 days.
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

Duration Of Visits Unit Code Sk

Description	The type of unit (month, week, etc.) used to measure the duration of visits. For example: 1 visit every 3 days for 21 days. This element indicates the type of units, in this case - days.
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

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

Emergency Ind

Description	Indicates whether emergency care was rendered in response to the sudden and unexpected onset of a medical condition, a severe injury, or an acute exacerbation of a chronic condition which was threatening to life, limb or sight.
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

Frequency Ct

Description	The count of the frequency units of home health visits. For example: 1 visit every 3 days for 21 days. This element indicates the frequency, in this case - 3 day intervals.
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

Image Id Num

Description	A reference pointer to an image file stored on an external system.
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

Last Certification Dt

Description	The date upon which the most recent certification for a procedure was completed.
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

Last Service Dt

Description	The date upon which a procedure was most recently carried out.
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

Locale Country Code Sk

Description	Indicates the country where the event has occurred. This can be used in determining aspects of the event that are locale specific.
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

Locale Language Code Sk

Description	Identifies the primary language of the event. All text fields contained in the event are assumed to be in this language.
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

Medical Effect Expected End Dt

Description	The date upon which the treatment is expected to become medically ineffective. For example: A vaccination administered on July 01, 2008 will cease to be effective in protecting the patient from July 01, 2011 (i.e. three years from administration)
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

Medical Effect Expected Start Dt

Description	The date upon which the treatment is expected to become medically effective. For example: A vaccination administered on July 01, 2008 will become effective in protecting the patient from July 15, 2008 (i.e. 15 days from administration) A chemotherapy cancer treatment administered from January 10, 2008 to January 31, 2008 is expected to become effective (for example, reducing cancer cell counts by more than 10%) from February 15, 2008
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

Method Code Sk

Description	Identifies the technique that is used for the procedure. For example: Finger stick Veni puncture Abdominal/ ascites effusion Biopsy Bronchial alveolar lavage (BAL) Open Laparoscopic
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

Newborn Living Status Cd

Description	Indicates whether the newborn(s) is alive at the time of birth.
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

Newborn Living Status Code Descr

Description	Indicates whether the newborn(s) is alive at the time of birth.
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

Newborn Living Status Code Sk

Description	Indicates whether the newborn(s) is alive at the time of birth.
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 Neonatal Delivered

Description	The number of babies delivered.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Oral Cavity Designation Cd

Description	Identifies an oral cavity involved in the treatment.
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

Oral Cavity Designation Code Descr

Description	Identifies an oral cavity involved in the treatment.
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

Oral Cavity Designation Code Sk

Description	Identifies an oral cavity involved in the treatment.
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

Orthodontic Banding Dt

Description	The date upon which orthodontic bands were applied.
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

Orthodontic Treatment Ind

Description	Indicates that reported treatment was for orthodontic purposes.
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

Oxygen Delivery Type Cd

Description	Indicates the method used in the administration of oxygen.
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

Oxygen Delivery Type Code Descr

Description	Indicates the method used in the administration of oxygen.
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

Oxygen Delivery Type Code Sk

Description	Indicates the method used in the administration of oxygen.
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

Oxygen Flow Rate Qty

Description	The oxygen flow rate typically expressed in liters per minute.
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

Oxygen Flow Rate UOM Code Sk

Description	Identifies the units in which the Oxygen Flow Rate is measured. Common Units are Liters per Minute.
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

Prior Placement Dt

Description	The date upon which a prosthesis, crown or inlay was previously installed if this service is a replacement.
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

Procedure Code Descr

Description	A textual description of the procedure or service.
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 Code 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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Procedure Code Family Cd

Description	The code set or standard coding reference that was used for specifying the procedure code. For example: Current Dental Terminology (CDT) Current Procedural Terminology (CPT) Healthcare Common Procedural Coding System (HCPCS) International Classification of Diseases (ICD9 or ICD10) Procedure Logical Observation Identifiers Names and Codes (LOINC) Systematized Nomenclature of Medicine Clinical Terms (SNOMED CT) UB Revenue
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 Code Family Code Descr

Description	The code set or standard coding reference that was used for specifying the procedure code. For example: Current Dental Terminology (CDT) Current Procedural Terminology (CPT) Healthcare Common Procedural Coding System (HCPCS) International Classification of Diseases (ICD9 or ICD10) Procedure Logical Observation Identifiers Names and Codes (LOINC) Systematized Nomenclature of Medicine Clinical Terms (SNOMED CT) UB Revenue
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 Code Family Code Sk

Description	The code set or standard coding reference that was used for specifying the procedure code. For example: Current Dental Terminology (CDT) Current Procedural Terminology (CPT) Healthcare Common Procedural Coding System (HCPCS) International Classification of Diseases (ICD9 or ICD10) Procedure Logical Observation Identifiers Names and Codes (LOINC) Systematized Nomenclature of Medicine Clinical Terms (SNOMED CT) UB Revenue
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

Procedure Code Sk

Description	The generated unique key for a Procedure.
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

Procedure Coding Method Code Sk

Description	Identifies the code set or standardized to identify the procedure. For example: CPT ICD10-PCS UB Revenue Codes
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

Procedure Event 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

Procedure Event 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

Procedure Event 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

Procedure Functional Type Code Sk

Description	Indicates the functional nature of the procedure. For example: Anesthesia Procedure for treatment (therapeutic, including operations) Surgical Procedure Invasive procedure not classified elsewhere (for example, IV, catheter, etc.) Diagnostic procedure
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

Procedure Minutes Qty

Description	The length of time expressed in whole minutes that the procedure took to complete.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Procedure Num

Description	Uniquely identifies a single procedure for an encounter. It is unique across all segments and messages for an encounter.
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

Procedure Outcome Cd

Description	Indicates how the procedure has affected the patient in relation to the primary condition being addressed. For example: Full recovery Improvement No Improvement Worsening condition
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 Outcome Code Descr

Description	Indicates how the procedure has affected the patient in relation to the primary condition being addressed. For example: Full recovery Improvement No Improvement Worsening condition
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 Outcome Code Sk

Description	Indicates how the procedure has affected the patient in relation to the primary condition being addressed. For example: Full recovery Improvement No Improvement Worsening condition
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

Procedure Priority Code Sk

Description	Identifies the significance or priority of a procedure.
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

Procedure Ts

Description	The date and time that the procedure was performed.
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

Prosthesis Crown or Inlay Cd

Description	Identifies the placement status for the dental work involving an appliance or prosthesis.
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

Prosthesis Crown or Inlay Code Descr

Description	Identifies the placement status for the dental work involving an appliance or prosthesis.
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

Prosthesis Crown or Inlay Code Sk

Description	Identifies the placement status for the dental work involving an appliance or prosthesis.
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

Prosthesis Replacement Dt

Description	The date upon which an appliance or prosthesis was replaced.
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

Reason Code Sk

Description	Indicates the reason for a procedure being carried out. A procedure can be triggered at a patient's or practitioner's request and is normally done on the basis of medical need.
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

Responsivity Status Cd

Description	Indicates how the patient is responding to the procedure performed.
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

Responsivity Status Code Descr

Description	Indicates how the patient is responding to the procedure performed.
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

Responsivity Status Code Sk

Description	Indicates how the patient is responding to the procedure performed.
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

Round Trip Purpose Descr

Description	A free form description of the purpose of the ambulance transport round trip.
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

Service Delivery Pattern Code Sk

Description	Indicates the delivery schedule pattern of the services. For example: 1st Week of the Month 1st & 3rd Weeks of the Month Monday through Friday Tuesday through Saturday Whenever Necessary
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

Side Effect Cd

Description	Indicates the degree to which any side effects of the procedure affect the patient.
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

Side Effect Code Descr

Description	Indicates the degree to which any side effects of the procedure affect the patient.
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

Side Effect Code Sk

Description	Indicates the degree to which any side effects of the procedure affect the patient.
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

Status Code Sk

Description	Indicates the status of the procedure.
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

Stretcher Purpose Descr

Description	A free form description of the purpose of the use of a stretcher during ambulance service.
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

Surgery Type Cd

Description	Indicates the type of any surgery involved in the dental treatment.
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

Surgery Type Code Descr

Description	Indicates the type of any surgery involved in the dental treatment.
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

Surgery Type Code Sk

Description	Indicates the type of any surgery involved in the dental treatment.
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

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

Tooth Cd

Description	An indication of the tooth on which services were performed or will be performed.
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

Tooth Code Descr

Description	An indication of the tooth on which services were performed or will be performed.
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

Tooth Code Sk

Description	An indication of the tooth on which services were performed or will be performed.
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

Tooth Num

Description	Standard identification number of a tooth.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Small [SHORT]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Tooth Status Cd

Description	Classification of the status of a tooth
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

Tooth Status Code Descr

Description	Classification of the status of a tooth
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

Tooth Status Code Sk

Description	Classification of the status of a tooth
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

Tooth Surface Cd

Description	The surface(s) of the tooth on which services were performed or will be performed.
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

Tooth Surface Code Descr

Description	The surface(s) of the tooth on which services were performed or will be performed.
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

Tooth Surface Code Sk

Description	The surface(s) of the tooth on which services were performed or will be performed.
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

Translated Procedure Cd

Description	A code identifying a procedure, product or service. The translated code is a code allocated to the procedure other than the original code supplied. This may be done in order to maintain consistency or to facilitate migration from one coding set to another.
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

Translated Procedure Code Descr

Description	A textual description of the translated procedure or service.
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

Translated Procedure Code Family Cd

Description	The code set or standard coding reference that was used for specifying the translated procedure code. For example: Current Dental Terminology (CDT) Current Procedural Terminology (CPT) Healthcare Common Procedural Coding System (HCPCS) International Classification of Diseases (ICD9 or ICD10) Procedure Logical Observation Identifiers Names and Codes (LOINC) Systematized Nomenclature of Medicine Clinical Terms (SNOMED CT) UB Revenue
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

Translated Procedure Code Family Code Descr

Description	The code set or standard coding reference that was used for specifying the translated procedure code. For example: Current Dental Terminology (CDT) Current Procedural Terminology (CPT) Healthcare Common Procedural Coding System (HCPCS) International Classification of Diseases (ICD9 or ICD10) Procedure Logical Observation Identifiers Names and Codes (LOINC) Systematized Nomenclature of Medicine Clinical Terms (SNOMED CT) UB Revenue
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

Translated Procedure Code Family Code Sk

Description	The code set or standard coding reference that was used for specifying the translated procedure code. For example: Current Dental Terminology (CDT) Current Procedural Terminology (CPT) Healthcare Common Procedural Coding System (HCPCS) International Classification of Diseases (ICD9 or ICD10) Procedure Logical Observation Identifiers Names and Codes (LOINC) Systematized Nomenclature of Medicine Clinical Terms (SNOMED CT) UB Revenue
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

Translated Procedure Code Sk

Description	A code identifying a procedure, product or service. The translated code is a code allocated to the procedure other than the original code supplied. This may be done in order to maintain consistency or to facilitate migration from one coding set to another.
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

Translation Dt

Description	The date upon which the translation was performed.
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

Translation Rule Applied

Description	The business rule used to perform the translation.
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

Translation Rule Descr

Description	A textual description of the business rule used to perform the translation.
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

Transport Distance Qty

Description	Distance traveled during the ambulance transport.
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

Transport Distance UOM Code Sk

Description	Identifies the unit of measure in which the transport distance is reported. Common Units are Miles or Kilometers.
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

Visit Ct

Description	The number of home health visits. e.g.: 1 visit every 3 days for 21 days. This element indicates the number of visits, in this case - 1 visit.
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

X-Ray Availability Ind

Description	Indicates if X-Ray images are on file for 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

Relationship Details

Procedure Event Dimension_Procedure Code Dimension_FK

Is Identifying Relationship	false
Child Table	Procedure Event Dimension
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	Procedure Code Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Primary Key Details

Procedure Event Dimension PK

Key Attribute

Procedure Event Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model