Overview Top Package Entity

Dimensional Warehouse Model Data Model

---

Entity Population Medical Selection Criterion Array

Description

A population selection criterion that is used to include or exclude individuals based on their state of health and any diagnosed conditions. For example: Diabetic individuals People with no chronic conditions diagnosed Asthmatic individuals

Attributes

Accommodation Cd

Accommodation Code Sk

Accommodation Descr

Acuity Cd

Acuity Code Sk

Acuity Descr

Admission Day Num

Admission Month Num

Admission Type Cd

Admission Type Code Sk

Admission Type Descr

Admission Year Num

Admit Reason Cd

Admit Reason Code Sk

Admit Reason Descr

AWM Load Info Sk

Current Ind

Discharge Day Num

Discharge Month Num

Discharge Status Cd

Discharge Status Code Sk

Discharge Status Descr

Discharge Year Num

DWM Load Info Sk

Effective From Dt

Effective To Dt

Maximum Admission Weight UOM Cd

Maximum Admission Weight UOM Code Sk

Maximum Admission Weight UOM Descr

Maximum Admission Weight Val

Medical Condition Cd

Medical Condition Code Sk

Medical Condition Descr

Minimum Admission Weight UOM Cd

Minimum Admission Weight UOM Code Sk

Minimum Admission Weight UOM Descr

Minimum Admission Weight Val

Newborn Baby Ind

Patient Condition Cd

Patient Condition Code Sk

Patient Condition Descr

Patient Status Cd

Patient Status Code Sk

Patient Status Descr

Selection Criterion Dk

Selection Criterion Sk

Source Code Sk

Tenant Sk

Tobacco Use Ind

Valid From Ts

Valid To Ts

Visit Type Cd

Visit Type Code Sk

Visit Type Descr

Relationship

Medical Selection Citerion_Selection Criteria_FK

Primary Key

Population Medical Selection Criterion Array PK

Dependencies

Reverse Dependencies

Attribute Details

 Accommodation Cd

Description	Indicates the specific patient accommodation for this visit.
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

---

 Accommodation Code Sk

Description	Indicates the specific patient accommodation for this visit.
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

---

 Accommodation Descr

Description	Indicates the specific patient accommodation for this visit.
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

---

 Acuity Cd

Description	Denotes the level of care or the urgency of a persons condition or treatment ordered or given. For example: Acute Chronic Emergency
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

---

 Acuity Code Sk

Description	Denotes the level of care or the urgency of a persons condition or treatment ordered or given. For example: Acute Chronic Emergency
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

---

 Acuity Descr

Description	Denotes the level of care or the urgency of a persons condition or treatment ordered or given. For example: Acute Chronic Emergency
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

---

 Admission Day Num

Description	Indicates the day of month for the admission.
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

---

 Admission Month Num

Description	Indicates the month of year for the admission.
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

---

 Admission Type Cd

Description	Indicates the circumstances under which the patient was or will be admitted  For example: Accident Routine Emergency
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

---

 Admission Type Code Sk

Description	Indicates the circumstances under which the patient was or will be admitted  For example: Accident Routine Emergency
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

---

 Admission Type Descr

Description	Indicates the circumstances under which the patient was or will be admitted  For example: Accident Routine Emergency
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

---

 Admission Year Num

Description	Indicates the year of the admission.
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

---

 Admit Reason Cd

Description	Indicates the reason for a patient's admission.
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

---

 Admit Reason Code Sk

Description	Indicates the reason for a patient's admission.
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

---

 Admit Reason Descr

Description	Indicates the reason for a patient's admission.
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

---

 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

---

 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

---

 Discharge Day Num

Description	Indicates the day of month for the discharge.
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

---

 Discharge Month Num

Description	Indicates the month of year for the discharge.
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

---

 Discharge Status Cd

Description	Indicates the disposition of the patient at time of discharge. For example: Discharged to home Expired
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

---

 Discharge Status Code Sk

Description	Indicates the disposition of the patient at time of discharge. For example: Discharged to home Expired
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

---

 Discharge Status Descr

Description	Indicates the disposition of the patient at time of discharge. For example: Discharged to home Expired
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

---

 Discharge Year Num

Description	Indicates the year of discharge.
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

---

 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

---

 Maximum Admission Weight UOM Cd

Description	Indicates the unit of measure for maximum weight.
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

---

 Maximum Admission Weight UOM Code Sk

Description	Indicates the unit of measure for maximum weight.
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

---

 Maximum Admission Weight UOM Descr

Description	Indicates the unit of measure for maximum weight.
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

---

 Maximum Admission Weight Val

Description	Indicates the maximum weight of patient at time of admission.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Float [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Medical Condition Cd

Description	Indicates a disease or medical condition that a patient has.
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

---

 Medical Condition Code Sk

Description	Indicates a disease or medical condition that a patient has.
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 Condition Descr

Description	Indicates a disease or medical condition that a patient has.
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

---

 Minimum Admission Weight UOM Cd

Description	Indicates the unit of measure for minimum weight.
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

---

 Minimum Admission Weight UOM Code Sk

Description	Indicates the unit of measure for minimum weight.
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

---

 Minimum Admission Weight UOM Descr

Description	Indicates the unit of measure for minimum weight.
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

---

 Minimum Admission Weight Val

Description	Indicates the minimum weight of patient at time of admission.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Float [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Newborn Baby Ind

Description	Indicates whether the patient is a newborn baby or not.
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

---

 Patient Condition Cd

Description	Indicates a disease or medical condition that a patient has.
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

---

 Patient Condition Code Sk

Description	Indicates a disease or medical condition that a patient has.
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

---

 Patient Condition Descr

Description	Indicates a disease or medical condition that a patient has.
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

---

 Patient Status Cd

Description	Contains the status of a patient in relation to an episode of care or other event. For example: Inpatient Active Inpatient Discharged Outpatient Active
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

---

 Patient Status Code Sk

Description	Contains the status of a patient in relation to an episode of care or other event. For example: Inpatient Active Inpatient Discharged Outpatient Active
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

---

 Patient Status Descr

Description	Contains the status of a patient in relation to an episode of care or other event. For example: Inpatient Active Inpatient Discharged Outpatient Active
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

---

 Selection Criterion 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	false

---

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

---

 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

---

 Tobacco Use Ind

Description	An indication of whether the Tobacco is used or not.
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

---

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

Description	Indicates whether the information is at Account Level (applies to multiple visits) or at current Visit Level (single visit).
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

---

 Visit Type Code Sk

Description	Indicates whether the information is at Account Level (applies to multiple visits) or at current Visit Level (single visit).
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

---

 Visit Type Descr

Description	Indicates whether the information is at Account Level (applies to multiple visits) or at current Visit Level (single visit).
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

Relationship Details

 Medical Selection Citerion_Selection Criteria_FK

Is Identifying Relationship	true
Child Table	Population Medical Selection Criterion Array
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	Population Selection Criterion 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

 Population Medical Selection Criterion Array PK

Key Attribute	Selection Criterion Dk
Key Attribute	Valid From Ts

---

Overview Top Package Entity

Dimensional Warehouse Model Data Model