Atomic Warehouse Model Data Model

Entity

Entity Procedure Detail

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
Birthing Environment Code Sk
Certification Revision Dt
Clinical Significance Code Sk
Consent Code Sk
Delivery Dt
Delivery Pattern Time Code Sk
Dental Procedure Cnt
Derived Ind
Duration Of Visits Ct
Duration Of Visits Unit Code Sk
Effective From Dt
Effective To Dt
Emergency Ind
Frequency Ct
Image Id Num
Last Certification Dt
Last Service Dt
Load Info Sk
Locale Country Code Sk
Locale Language Code Sk
Medical Effect Expected End Dt
Medical Effect Expected Start Dt
Method Code Sk
Newborn Living Status Code Sk
Number of Neonatal Delivered
Oral Cavity Designation Code Sk
Orthodontic Banding Dt
Orthodontic Treatment Ind
Orthodontic Treatment Months Cnt
Orthodontic Treatment Months Remaining Cnt
Oxygen Delivery Type Code Sk
Oxygen Flow Rate Qty
Oxygen Flow Rate UOM Code Sk
Prior Placement Dt
Procedure Code Descr
Procedure Code Family Code Sk
Procedure Coding Method Code Sk
Procedure Functional Type Code Sk
Procedure Minutes Qty
Procedure Num
Procedure Outcome Code Sk
Procedure Priority Code Sk
Procedure Sk
Procedure Ts
Prosthesis Crown or Inlay Code Sk
Prosthesis Replacement Dt
Reason Code Sk
Responsivity Status Code Sk
Round Trip Purpose Descr
Service Delivery Pattern Code Sk
Side Effect Code Sk
Source Code Sk
Status Code Sk
Stretcher Purpose Descr
Surgery Type Code Sk
Tenant Sk
Tooth Code Sk
Tooth Num
Tooth Status Code Sk
Tooth Surface Code Sk
Translated Procedure 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 Detail_Procedure_FK

Primary Key
Procedure Detail 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

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

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

Dental Procedure Cnt

Description	A count of the number of procedures involved in the dental treatment.
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

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

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

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

Locale Country Code Sk

Description	Identifies the country where the event has occurred. This can be used in determining aspects of the event that are locale specific (for example, currency).
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 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 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

Orthodontic Treatment Months Cnt

Description	The estimated number of months over which the orthodontic treatment will take place.
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

Orthodontic Treatment Months Remaining Cnt

Description	The estimated number of months remaining before the orthodontic treatment will be complete.
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

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

Description	Anchor surrogate key for the Procedure data.
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	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 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 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 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 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 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 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 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 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 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 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	true
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 Detail_Procedure_FK

Is Identifying Relationship	true
Child Table	Procedure Detail
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
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 Detail PK

Key Attribute	Procedure Sk
Key Attribute	Valid From Ts

Overview

Top

Package

Entity

Atomic Warehouse Model Data Model