Dimensional Warehouse Model Data Model

Entity

Entity Readmission Prediction Snapshot

Description

A snapshot fact table which consists of measures, indicators and timestamps related to hospital admissions, discharges and subsequent readmissions.

Attributes
Calendar Dk
Condition Dk
Index Admission Allergy Ind
Index Admission Blood Infection Ind
Index Admission Cancer Ind
Index Admission CHF Ind
Index Admission Cholesterol Ind
Index Admission Chronic Condition Ind
Index Admission COPD Ind
Index Admission Diabetes Ind
Index Admission Diagnosis Group Dk
Index Admission Dk
Index Admission Drug Use Ind
Index Admission Fall Risk Ind
Index Admission Hypertension Ind
Index Admission Is Readmission Ind
Index Admission Obesity Ind
Index Admission Planned Ind
Index Admission Renal Ind
Index Admission Respiratory Ind
Index Admission Smoking Ind
Index Admission Source Cd
Index Admission SSI Infection Ind
Index Admission Surgery Ind
Index Admission Ts
Index Admitting Practitioner Dk
Index Discharge Diagnosis Group Dk
Index Discharge Disposition Cd
Index Discharge Teaching Provider Ind
Index Discharge Ts
Index Discharging Practitioner Dk
Index Living Arrangement Cd
Index Point Of Care Facility Dk
Load Info Sk
Patient Dk
Readmission Admitting Practitioner Dk
Readmission Allergy Ind
Readmission Blood Infection Ind
Readmission Cancer Ind
Readmission CHF Ind
Readmission Cholesterol Ind
Readmission Chronic Condition Ind
Readmission COPD Ind
Readmission Diabetes Ind
Readmission Diagnosis Group Dk
Readmission Discharge Ts
Readmission Dk
Readmission Drug Use Ind
Readmission Fall Risk Ind
Readmission Hypertension Ind
Readmission Living Arrangement Cd
Readmission Obesity Ind
Readmission Planned Ind
Readmission Point Of Care Facility Dk
Readmission Renal Ind
Readmission Respiratory Ind
Readmission Risk Score Ind
Readmission Smoking Ind
Readmission Source Cd
Readmission SSI Infection Ind
Readmission Surgery Ind
Readmission Ts
Related Cause Ind
Risk Adjustment Method Descr
Same Cause Ind
Same POC Facility Ind
Tenant Sk

Relationship
Readmission Prediction Snapshot_Index Admission_FK
Readmission Prediction Snapshot_Index Admitting Practitioner_FK
Readmission Prediction Snapshot_Index Point Of Care Facility_FK
Readmission Prediction Snapshot_Index Discharge Diagnosis Group_FK
Readmission Prediction Snapshot_Index Discharging Practitioner_FK
Readmission Prediction Snapshot_Readmission_FK
Readmission Prediction Snapshot_Readmission Admitting Practitioner_FK
Readmission Prediction Snapshot_Readmission Diagnosis Group_FK
Readmission Prediction Snapshot_Readmission Point Of Care Facility_FK
Readmission Prediction Snapshot_Index Admission Diagnosis Group_FK
Readmission Prediction Snapshot_Patient Dimension_FK
Readmission Prediction Snapshot_Condition Dimension_FK
Readmission Prediction Snapshot_Calendar Dimension_FK

Primary Key
Readmission Prediction Snapshot PK

Dependencies
NONE

Reverse Dependencies

Attribute Details

Calendar 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

Condition 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

Index Admission Allergy Ind

Description	This field indicates whether or not an index admission was related to an allergy. Yes/no Indicator for valid values. Y the index admission was related to an allergy N the index admission was not related to an allergy
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

Index Admission Blood Infection Ind

Description	This field indicates whether or not an index admission was related to a blood infection. Yes/no Indicator for valid values. Y the index admission was related to a blood infection N the index admission was not related to a blood infection
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

Index Admission Cancer Ind

Description	This field indicates whether or not an index admission was related to cancer. Yes/no Indicator for valid values. Y the index admission was related to cancer N the index admission was not related to cancer
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

Index Admission CHF Ind

Description	This field indicates whether or not an index admission was related to chronic heart failure. Yes/no Indicator for valid values. Y the index admission was related to chronic heart failure N the index admission was not related to chronic heart failure
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

Index Admission Cholesterol Ind

Description	This field indicates whether or not an index admission was related to cholesterol. Yes/no Indicator for valid values. Y the index admission was related to cholesterol N the index admission was not related to cholesterol
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

Index Admission Chronic Condition Ind

Description	This field indicates whether or not an index admission was related to a chronic condition. Yes/no Indicator for valid values. Y the index admission was related to a chronic condition N the index admission was not related to a chronic condition
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

Index Admission COPD Ind

Description	This field indicates whether or not an index admission was related to chronic obstructive pulmonary disease (COPD). Yes/no Indicator for valid values. Y the index admission was related to COPD N the index admission was not related to COPD
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

Index Admission Diabetes Ind

Description	This field indicates whether or not an index admission was related to diabetes. Yes/no Indicator for valid values. Y the index admission was related to diabetes N the index admission was not related to diabetes
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

Index Admission Diagnosis Group 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

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

Index Admission Drug Use Ind

Description	This field indicates whether or not an index admission was related to drug use. Yes/no Indicator for valid values. Y the index admission was related to drug use N the index admission was not related to drug use
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

Index Admission Fall Risk Ind

Description	This field indicates whether or not an index admission involves a patient who is at risk of falling. Yes/no Indicator for valid values. Y the index admission involves a patient who is at risk of falling N the index admission does not involve a patient who is at risk of falling
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

Index Admission Hypertension Ind

Description	This field indicates whether or not an index admission was related to hypertension. Yes/no Indicator for valid values. Y the index admission was related to hypertension N the index admission was not related to hypertension
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

Index Admission Is Readmission Ind

Description	This field indicates whether or not an index admission is itself a readmission of a previous admission. Yes/no Indicator for valid values. Y the index admission is also a readmission N the index admission is not a readmission
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

Index Admission Obesity Ind

Description	This field indicates whether or not an index admission was related to obesity. Yes/no Indicator for valid values. Y the index admission was related to obesity N the index admission was not related to obesity
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

Index Admission Planned Ind

Description	This field indicates whether or not an admission was planned. Yes/no Indicator for valid values. Y the admission was planned N the admission was not planned
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

Index Admission Renal Ind

Description	This field indicates whether or not an index admission was related to a renal condition. Yes/no Indicator for valid values. Y the index admission was related to a renal condition N the index admission was not related to a renal condition
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

Index Admission Respiratory Ind

Description	This field indicates whether or not an index admission was related to a respiratory condition. Yes/no Indicator for valid values. Y the index admission was related to a respiratory condition N the index admission was not related to a respiratory condition
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

Index Admission Smoking Ind

Description	This field indicates whether or not an index admission was related to smoking. Yes/no Indicator for valid values. Y the index admission was related to smoking N the index admission was not related to smoking
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

Index Admission Source Cd

Description	The way a patient came to be admitted to the facility as an inpatient. e.g.: Via Emergency Department PCP Referral Transfer
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

Index Admission SSI Infection Ind

Description	This field indicates whether or not an index admission was related to a Surgical Site Infection (SSI). Yes/No Indicator for valid values. Y the index admission was related to an SSI infection N the index admission was not related to an SSI infection
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

Index Admission Surgery Ind

Description	This field indicates whether or not an index admission involved or required a surgery. Yes/no Indicator for valid values. Y the index admission involved or required surgery N the index admission did not involve or require surgery
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

Index Admission Ts

Description	The admit date and time of the index admission.
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

Index Admitting Practitioner 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

Index Discharge Diagnosis Group 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

Index Discharge Disposition Cd

Description	A code that identifies what the patient's disposition is expected to be upon index discharge e.g. Home, Hospice, Acute Care Facility
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

Index Discharge Teaching Provider Ind

Description	Indicates that the provider responsible for the prior discharge (discharge of the index admission) was a teaching provider.
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

Index Discharge Ts

Description	The discharge date and time of the index discharge
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

Index Discharging Practitioner 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

Index Living Arrangement Cd

Description	At the time of index admission, the situation in which the patient lives at his residential address. Examples might include Alone, Family, Relatives, Institution, etc.
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

Index Point Of Care Facility 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

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

Patient 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

Readmission Admitting Practitioner 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

Readmission Allergy Ind

Description	This field indicates whether or not a readmission was related to an allergy. Yes/no Indicator for valid values. Y the readmission was related to an allergy N the readmission was not related to an allergy
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

Readmission Blood Infection Ind

Description	This field indicates whether or not a readmission was related to a blood infection. Yes/no Indicator for valid values. Y the readmission was related to a blood infection N the readmission was not related to a blood infection
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

Readmission Cancer Ind

Description	This field indicates whether or not a readmission was related to cancer. Yes/no Indicator for valid values. Y the readmission was related to cancer N the readmission was not related to cancer
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

Readmission CHF Ind

Description	This field indicates whether or not a readmission was related to chronic heart failure. Yes/no Indicator for valid values. Y the readmission was related to chronic heart failure N the readmission was not related to chronic heart failure
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

Readmission Cholesterol Ind

Description	This field indicates whether or not a readmission was related to cholesterol. Yes/no Indicator for valid values. Y the readmission was related to cholesterol N the readmission was not related to cholesterol
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

Readmission Chronic Condition Ind

Description	This field indicates whether or not a readmission was related to a chronic condition. Yes/no Indicator for valid values. Y the readmission was related to a chronic condition N the readmission was not related to a chronic condition
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

Readmission COPD Ind

Description	This field indicates whether or not a readmission was related to chronic obstructive pulmonary disease (COPD). Yes/no Indicator for valid values. Y the readmission was related to COPD N the readmission was not related to COPD
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

Readmission Diabetes Ind

Description	This field indicates whether or not a readmission was related to diabetes. Yes/no Indicator for valid values. Y the readmission was related to diabetes N the readmission was not related to diabetes
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

Readmission Diagnosis Group 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

Readmission Discharge Ts

Description	The discharge date and time of the readmission discharge
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

Readmission 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

Readmission Drug Use Ind

Description	This field indicates whether or not a readmission was related to drug use. Yes/no Indicator for valid values. Y the readmission was related to drug use N the readmission was not related to drug use
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

Readmission Fall Risk Ind

Description	This field indicates whether or not a readmission involves a patient who is at risk of falling. Yes/no Indicator for valid values. Y the readmission involves a patient who is at risk of falling N the readmission does not involve a patient who is at risk of falling
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

Readmission Hypertension Ind

Description	This field indicates whether or not a readmission was related to hypertension. Yes/no Indicator for valid values. Y the readmission was related to hypertension N the readmission was not related to hypertension
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

Readmission Living Arrangement Cd

Description	At the time of readmission, the situation in which the patient lives at his residential address. Examples might include Alone, Family, Relatives, Institution, etc.
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

Readmission Obesity Ind

Description	This field indicates whether or not a readmission was related to obesity. Yes/no Indicator for valid values. Y the readmission was related to obesity N the readmission was not related to obesity
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

Readmission Planned Ind

Description	This field indicates whether or not a readmission was planned. Yes/no Indicator for valid values. Y the readmission was planned N the readmission was not planned
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

Readmission Point Of Care Facility 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

Readmission Renal Ind

Description	This field indicates whether or not a readmission was related to a renal condition. Yes/no Indicator for valid values. Y the readmission was related to a renal condition N the readmission was not related to a renal condition
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

Readmission Respiratory Ind

Description	This field indicates whether or not a readmission was related to a respiratory condition. Yes/no Indicator for valid values. Y the readmission was related to a respiratory condition N the readmission was not related to a respiratory condition
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

Readmission Risk Score Ind

Description	This field indicates whether or not the index admission encounter has an associated assessment and score for possible risk of readmission. Yes/no Indicator for valid values. Y the index admission has a related risk of readmission score N the index admission does not have a related risk of readmission score
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

Readmission Smoking Ind

Description	This field indicates whether or not a readmission was related to smoking. Yes/no Indicator for valid values. Y the readmission was related to smoking N the readmission was not related to smoking
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

Readmission Source Cd

Description	The way a patient came to be readmitted to the facility as an inpatient. e.g.: Via Emergency Department PCP Referral Transfer
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

Readmission SSI Infection Ind

Description	This field indicates whether or not a readmission was related to a Surgical Site Infection (SSI). Yes/No Indicator for valid values. Y the readmission was related to an SSI infection N the readmission was not related to an SSI infection
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

Readmission Surgery Ind

Description	This field indicates whether or not a readmission involved or required a surgery. Yes/no Indicator for valid values. Y the readmission involved or required surgery N the readmission did not involve or require surgery
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

Readmission Ts

Description	The admit date and time of the readmission
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

Related Cause Ind

Description	This field indicates whether or not an index admission and the subsequent readmission share a related cause. Yes/no Indicator for valid values. Y the index admission and readmission have a related cause N the index admission and readmission do not have a related cause
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

Risk Adjustment Method Descr

Description	The method of using risk categories associated to diagnosis and procedure categories to produce the risk adjusted measures
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

Same Cause Ind

Description	This field indicates whether or not an index admission and the subsequent readmission share the same cause. Yes/no Indicator for valid values. Y the index admission and readmission have the same cause N the index admission and readmission do not have the same cause
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

Same POC Facility Ind

Description	This field indicates whether or not an index admission and the subsequent readmission were at the same point of care location. Yes/no Indicator for valid values. Y the index admission and readmission were at the same facility N the index admission and readmission were not at the same facility
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

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

Relationship Details

Readmission Prediction Snapshot_Index Admission_FK

Is Identifying Relationship	true
Child Table	Readmission Prediction Snapshot
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 Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Readmission Prediction Snapshot_Index Admitting Practitioner_FK

Is Identifying Relationship	true
Child Table	Readmission Prediction Snapshot
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 Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Readmission Prediction Snapshot_Index Point Of Care Facility_FK

Is Identifying Relationship	true
Child Table	Readmission Prediction Snapshot
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 Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Readmission Prediction Snapshot_Index Discharge Diagnosis Group_FK

Is Identifying Relationship	true
Child Table	Readmission Prediction Snapshot
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	Diagnosis Code Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Readmission Prediction Snapshot_Index Discharging Practitioner_FK

Is Identifying Relationship	true
Child Table	Readmission Prediction Snapshot
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 Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Readmission Prediction Snapshot_Readmission_FK

Is Identifying Relationship	true
Child Table	Readmission Prediction Snapshot
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 Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Readmission Prediction Snapshot_Readmission Admitting Practitioner_FK

Is Identifying Relationship	true
Child Table	Readmission Prediction Snapshot
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 Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Readmission Prediction Snapshot_Readmission Diagnosis Group_FK

Is Identifying Relationship	true
Child Table	Readmission Prediction Snapshot
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	Diagnosis Code Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Readmission Prediction Snapshot_Readmission Point Of Care Facility_FK

Is Identifying Relationship	true
Child Table	Readmission Prediction Snapshot
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 Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Readmission Prediction Snapshot_Index Admission Diagnosis Group_FK

Is Identifying Relationship	true
Child Table	Readmission Prediction Snapshot
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	Diagnosis Code Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Readmission Prediction Snapshot_Patient Dimension_FK

Is Identifying Relationship	true
Child Table	Readmission Prediction Snapshot
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 Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Readmission Prediction Snapshot_Condition Dimension_FK

Is Identifying Relationship	true
Child Table	Readmission Prediction Snapshot
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	Condition Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Readmission Prediction Snapshot_Calendar Dimension_FK

Is Identifying Relationship	true
Child Table	Readmission Prediction Snapshot
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	Calendar 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

Readmission Prediction Snapshot PK

Key Attribute	Index Admission Diagnosis Group Dk
Key Attribute	Index Admission Dk
Key Attribute	Index Admitting Practitioner Dk
Key Attribute	Index Point Of Care Facility Dk
Key Attribute	Index Discharge Diagnosis Group Dk
Key Attribute	Index Discharging Practitioner Dk
Key Attribute	Readmission Dk
Key Attribute	Readmission Admitting Practitioner Dk
Key Attribute	Readmission Diagnosis Group Dk
Key Attribute	Readmission Point Of Care Facility Dk
Key Attribute	Patient Dk
Key Attribute	Condition Dk
Key Attribute	Calendar Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model