Overview Top Package Entity

Atomic Warehouse Model Data Model

---

Entity Measure Value

Description

An association between a measure and the entities, Laboratory Test, Medication, Patient, Organization, Geographic Area, Service, Pathway, Point of Care Location, Encounter, Diagnosis , Practitioner.

Attributes

Account Sk

Charge Master Sk

Claim Sk

Denominator UOM Code Sk

Denominator Val

Diagnosis Sk

Effective From Dt

Effective To Dt

Encounter Sk

Geographic Area Sk

Group Sk

Job Sk

Laboratory Test Sk

Load Info Sk

Measure Cnt

Measure Effective From Dt

Measure Effective To Dt

Measure Rt

Measure Sk

Measure Snapshot Dt

Measure Value Sk

Medication Code Sk

Numerator UOM Code Sk

Numerator Val

Organization Sk

Other Area Measure Sk

Pathway Sk

Patient Sk

Point Of Care Location Sk

Practitioner Sk

Procedure Code Sk

Relationship Type Code Sk

Service Sk

Source Code Sk

Tenant Sk

Valid From Ts

Valid To Ts

Relationship

Measure / Other Area_Encounter_FK

Measure / Other Area_Patient_FK

Measure / Other Area_Laboratory Test_FK

Measure / Other Area_Medication_FK

Measure / Other Area_Point Of Care Location_FK

Measure / Other Area_Claim_FK

Measure / Other Area_Pathway_FK

Measure / Other Area_Service_FK

Measure / Other Area_Geographic Area_FK

Measure / Other Area_Practitioner_FK

Measure Value / Other Area_Measure_FK

Measure Value_Organization_FK

Measure Value_Charge Master_FK

Measure Value_Procedure Code_FK

Measure Value_Group_FK

Measure Value_Measure_FK

Measure Value_Job_FK

Measure Value_Account_FK

Primary Key

Measure Value PK

Dependencies

Reverse Dependencies

Attribute Details

 Account Sk

Description	Surrogate key for the entity.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Charge Master Sk

Description	Surrogate key for the entity.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Claim Sk

Description	Surrogate key for the anchor entity.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Denominator UOM Code Sk

Description	Indicates the Denominator Val's unit of measure. Example:  Val = 10 Unit Of Measure could be = ml, $, or km...
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

---

 Denominator Val

Description	The Denominator's value when the Measure Type is a Rate or Percentage.
Data Type	Standards - Data Domains.ddm/Data Domains/Measure [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Diagnosis Sk

Description	Surrogate key of a diagnosis.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
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

---

 Encounter Sk

Description	Anchor surrogate key for the Encounter data.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Geographic Area Sk

Description	Surrogate key for the entity.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Group Sk

Description	Anchor surrogate key for the Group data.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Job Sk

Description	Surrogate Key for Job.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Laboratory Test Sk

Description	The generated unique key for Common Code table.
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

---

 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

---

 Measure Cnt

Description	The value of the Measure with its unit of measure denoted by the Measure Definition Measure Type. May be obtained by dividing the numerator by the denominator for Rate or Percentage. If the Measure Type is Count, then the value is the same as the numerator. The attribute might not be persisted if the aggregation is to be performed in the BI tool.
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

---

 Measure Effective From Dt

Description	The date from which a calculated measure value is valid.
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

---

 Measure Effective To Dt

Description	The date until which a calculated measure value is valid.
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

---

 Measure Rt

Description	The value of the Measure with its unit of measure denoted by the Measure Definition Measure Type. May be obtained by dividing the numerator by the denominator for Rate or Percentage. If the Measure Type is Count, then the value is the same as the numerator. The attribute might not be persisted if the aggregation is to be performed in the BI tool.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Measure Sk

Description	Surrogate Key for Measure.
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

---

 Measure Snapshot Dt

Description	The date establishing a point in time when 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	false
Is Derived	false
Is Surrogate Key	false

---

 Measure Value Sk

Description	Surrogate Key for Measure Value.
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

---

 Medication Code Sk

Description	The generated unique key for Common Code table.
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

---

 Numerator UOM Code Sk

Description	Indicates the Numerator Val's unit of measure. Example:  Val = 10 Unit Of Measure could be = ml, $, or km...
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

---

 Numerator Val

Description	The integer recording the Numerator's value for all types of measures.
Data Type	Standards - Data Domains.ddm/Data Domains/Measure [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Organization Sk

Description	Anchor surrogate key for the Organization data
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Other Area Measure Sk

Description	Surrogate Key for Measure.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Pathway Sk

Description	Pathway anchor surrogate key.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Patient Sk

Description	Anchor surrogate key for the Patient data.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Point Of Care Location Sk

Description	Surrogate key for Point Of Care Location.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Practitioner Sk

Description	The ID assigned to uniquely identify all staff associated with provider, research, clinical care and associated users of the system.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
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	false
Is Derived	false
Is Surrogate Key	false

---

 Relationship Type Code Sk

Description	Identifies the type of the relationship as defined in the business data model.
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

---

 Service Sk

Description	Surrogate key for the anchor entity.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
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

---

 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

---

 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

Relationship Details

 Measure / Other Area_Encounter_FK

Is Identifying Relationship	false
Child Table	Measure Value
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	Encounter
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Measure / Other Area_Patient_FK

Is Identifying Relationship	false
Child Table	Measure Value
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	Patient
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Measure / Other Area_Laboratory Test_FK

Is Identifying Relationship	false
Child Table	Measure Value
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	Laboratory Test
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Measure / Other Area_Medication_FK

Is Identifying Relationship	false
Child Table	Measure Value
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Medication
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Measure / Other Area_Point Of Care Location_FK

Is Identifying Relationship	false
Child Table	Measure Value
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	Point Of Care Location
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Measure / Other Area_Claim_FK

Is Identifying Relationship	false
Child Table	Measure Value
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	Claim
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Measure / Other Area_Pathway_FK

Is Identifying Relationship	false
Child Table	Measure Value
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	Pathway
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Measure / Other Area_Service_FK

Is Identifying Relationship	false
Child Table	Measure Value
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	Service
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Measure / Other Area_Geographic Area_FK

Is Identifying Relationship	false
Child Table	Measure Value
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	Geographic Area
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Measure / Other Area_Practitioner_FK

Is Identifying Relationship	false
Child Table	Measure Value
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	Practitioner
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Measure Value / Other Area_Measure_FK

Is Identifying Relationship	false
Child Table	Measure Value
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	Measure
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Measure Value_Organization_FK

Is Identifying Relationship	false
Child Table	Measure Value
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Organization
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Measure Value_Charge Master_FK

Is Identifying Relationship	false
Child Table	Measure Value
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Charge Master
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Measure Value_Procedure Code_FK

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

---

 Measure Value_Group_FK

Is Identifying Relationship	false
Child Table	Measure Value
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	Group
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Measure Value_Measure_FK

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

---

 Measure Value_Job_FK

Is Identifying Relationship	false
Child Table	Measure Value
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	Job
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Measure Value_Account_FK

Is Identifying Relationship	false
Child Table	Measure Value
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	Account
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Primary Key Details

 Measure Value PK

Key Attribute

Measure Value Sk

---

Overview Top Package Entity

Atomic Warehouse Model Data Model