Atomic Warehouse Model Data Model

Entity

Entity Population Medical Selection Criterion

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 Code Sk
Acuity Code Sk
Admission Day Num
Admission Month Num
Admission Type Code Sk
Admission Year Num
Admit Reason Code Sk
Discharge Day Num
Discharge Month Num
Discharge Status Code Sk
Discharge Year Num
Effective From Dt
Effective To Dt
Load Info Sk
Maximum Admission Weight UOM Code Sk
Maximum Admission Weight Val
Minimum Admission Weight UOM Code Sk
Minimum Admission Weight Val
Newborn Baby Ind
Patient Condition Code Sk
Patient Status Code Sk
Selection Criterion Sk
Source Code Sk
Tenant Sk
Tobacco Use Ind
Valid From Ts
Valid To Ts
Visit Type Code Sk

Relationship
Medical Selection Citerion_Selection Criteria_FK

Primary Key
Population Medical Selection Criterion PK

Dependencies

Reverse Dependencies

Attribute Details

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

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

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

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

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

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

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

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

Description	Describes the condition of a patient. May be used for or sourced from Claim data.
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 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

Selection Criterion Sk

Description	Surrogate key of the population selection criterion.
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

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

Relationship Details

Medical Selection Citerion_Selection Criteria_FK

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

Key Attribute	Selection Criterion Sk
Key Attribute	Valid From Ts

Overview

Top

Package

Entity

Atomic Warehouse Model Data Model