Dimensional Warehouse Model Data Model

Entity

Entity Procedures Utilization Snapshot

Description

A snapshot fact table which consists of measures, indicators and timestamps related to utilization of tests and procedures of particular interest to the healthcare organization.

Attributes
Abdominal Hysterectomy Procedure Ind
Abdominal Hysterectomy Procedure Ts
Acute Treatment Ind
Admission Ts
Alcohol Use Ind
Antibiotic Prescription Ind
Antibiotic Prescription Ts
Antibiotics of Concern Prescription Ind
Antibiotics of Concern Prescription Ts
Asthma Diagnosis Ts
Asthma Ind
Back Surgery Ind
Back Surgery Ts
Bariatric Weight Loss Surgery Procedure Ind
Bariatric Weight Loss Surgery Procedure Ts
CAD Diagnostic Test Ind
CAD Diagnostic Test Ts
Calendar Dk
Cardiac Catheterization Procedure Ind
Cardiac Catheterization Procedure Ts
Cardiac Computed Tomography Scan Ind
Cardiac Computed Tomography Scan Ts
Cardiovascular Disease Diagnosis Ts
Cardiovascular Disease Ind
Carotid Artery Stenosis Diagnostic Test Ind
Carotid Artery Stenosis Diagnostic Test Ts
Carotid Endarterectomy Procedure Ind
Carotid Endarterectomy Procedure Ts
Chemical Dependency Service Ind
Chemical Dependency Service Ts
Condition Dk
COPD Diagnosis Ts
COPD Ind
Coronary Artery Bypass Graft Ind
Coronary Artery Bypass Graft Ts
Diabetes Diagnosis Ts
Diabetes Ind
Discharge Ts
ED Visit Ind
ED Visit Ts
Geographic Area Dk
Hypertension Diagnosis Ts
Hypertension Ind
Inpatient Ind
Laparoscopic Cholecystectomy Procedure Ind
Laparoscopic Cholecystectomy Procedure Ts
Live Birth Ind
Load Info Sk
Lumpectomy Procedure Ind
Lumpectomy Procedure Ts
Mastectomy Procedure Ind
Mastectomy Procedure Ts
Maternity Ind
Medical Benefits Plan Ind
Medical Treatment Ind
Mental Health Service Ind
Mental Health Service Ts
Nonacute Treatment Ind
Open Cholecystectomy Procedure Ind
Open Cholecystectomy Procedure Ts
Outpatient Ind
Patient Dk
PCI Procedure Ind
PCI Procedure Ts
Pharmacy Benefits Plan Ind
Practitioner Dk
Prenatal Visit Ind
Primary Care Practitioner Visit Ind
Primary Care Practitioner Visit Ts
Prostatectomy Procedure Ind
Prostatectomy Procedure Ts
Provider Dk
Readmission Ind
Readmission Ts
Recreational Drug Use Ind
Surgical Treatment Ind
Tenant Sk
Tonsillectomy Procedure Ind
Tonsillectomy Procedure Ts
Total Hip Replacement Procedure Ind
Total Hip Replacement Procedure Ts
Total Knee Replacement Procedure Ind
Total Knee Replacement Procedure Ts
Vaginal Hysterectomy Procedure Ind
Vaginal Hysterectomy Procedure Ts
Well Child Visit Ind
Well Child Visit Ts

Relationship
Procedures Utilization Snapshot_Practitioner Dimension_FK
Procedures Utilization Snapshot_Provider Dimension_FK
Procedures Utilization Snapshot_Calendar Dimension_FK
Procedures Utilization Snapshot_Geographic Area Dimension_FK
Procedures Utilization Snapshot_Condition Dimension_FK
Procedures Utilization Snapshot_Patient Dimension_FK

Primary Key
Procedures Utilization Snapshot PK

Dependencies
NONE

Reverse Dependencies

Attribute Details

Abdominal Hysterectomy Procedure Ind

Description	Indicator to identify that an Abdominal Hysterectomy procedure has been performed on 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

Abdominal Hysterectomy Procedure Ts

Description	Date and time when the Abdominal Hysterectomy 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

Acute Treatment Ind

Description	Indicator to identify a patient stay for acute treatment.
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

Admission Ts

Description	The date and time a patient was admitted to a healthcare facility, usually as an inpatient. It may also be used to reflect the date and time of an out-patient or emergency patient registration.
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

Alcohol Use Ind

Description	Indicator to show if the patient is an Alcohol user.
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

Antibiotic Prescription Ind

Description	Indicator to show whether the patient was prescribed antibiotics.
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

Antibiotic Prescription Ts

Description	Date and time that the patient was most recently prescribed antibiotics.
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

Antibiotics of Concern Prescription Ind

Description	Indicator to show whether the patient was prescribed antibiotics of concern.
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

Antibiotics of Concern Prescription Ts

Description	Date and time then the patient was prescribed antibiotics of concern.
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

Asthma Diagnosis Ts

Description	Date and time the patient was diagnosed with persistent asthma.
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

Asthma Ind

Description	Indicator to show if a patient has been diagnosed with persistent asthma.
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

Back Surgery Ind

Description	Indicator to identify that a Back Surgery has been performed on 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

Back Surgery Ts

Description	Date and time when the Back Surgery 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

Bariatric Weight Loss Surgery Procedure Ind

Description	Indicator to identify whether a Bariatric Weight Loss surgical procedure has been performed on 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

Bariatric Weight Loss Surgery Procedure Ts

Description	Date and time when the Bariatric Weight Loss surgical 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

CAD Diagnostic Test Ind

Description	Indicator to identify that a Coronary Artery Disease (CAD) diagnostic test has been performed.
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

CAD Diagnostic Test Ts

Description	Date and time of the latest Coronary Artery Disease (CAD) diagnosic Test.
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

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

Cardiac Catheterization Procedure Ind

Description	Indicator to identify whether a Cardiac Catheterization procedure has been performed on 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

Cardiac Catheterization Procedure Ts

Description	Date and time when the Cardiac Catheterization 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

Cardiac Computed Tomography Scan Ind

Description	Indicator to show whether the patient had a cardiac Computed Tomography (CT) scan.
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

Cardiac Computed Tomography Scan Ts

Description	Date and time of the latest cardiac Computed Tomography (CT) scan.
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

Cardiovascular Disease Diagnosis Ts

Description	Date and time the patient was diagnosed with Cardiovascular disease.
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

Cardiovascular Disease Ind

Description	Indicator to identify if the patient has been diagnosed with Cardiovascular disease.
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

Carotid Artery Stenosis Diagnostic Test Ind

Description	Indicator to identify that a Carotid Artery Stenosis Diagnostic test has been performed.
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

Carotid Artery Stenosis Diagnostic Test Ts

Description	Date and time of the latest Carotid Artery Stenosis Diagnostic test.
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

Carotid Endarterectomy Procedure Ind

Description	Indicator to identify that a Carotid Endarterectomy Procedure has been performed on 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

Carotid Endarterectomy Procedure Ts

Description	Date and time when the Carotid Endarterectomy 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

Chemical Dependency Service Ind

Description	Indicator to identify whether a patient has recieved following chemical dependency services. - Any service. - Inpatient. - Intensive outpatient or partial hospitalization. - Outpatient or ED.
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

Chemical Dependency Service Ts

Description	The date and time when the patient recieved following chemical dependency services. - Any service. - Inpatient. - Intensive outpatient or partial hospitalization. - Outpatient or ED.
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

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

COPD Diagnosis Ts

Description	Date and time the patient was diagnosed with Chronic Obstructive Pulmonary Disease (COPD).
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

COPD Ind

Description	Indicator to identify if a patient has been diagnosed Chronic Obstructive Pulmonary Disease (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

Coronary Artery Bypass Graft Ind

Description	Indicator to identify that a Coronary Artery Bypass Graft Procedure has been performed on 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

Coronary Artery Bypass Graft Ts

Description	Date and time when the Coronary Artery Bypass Graft 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

Diabetes Diagnosis Ts

Description	Date and time the patient was diagnosed with Diabetes.
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

Diabetes Ind

Description	Indicator to identify if the patient has been diagnosed with 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

Discharge Ts

Description	The date and time a patient was released or discharged from a healthcare facility following an 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

ED Visit Ind

Description	Indicator to identify the patient's visit to emergency department.
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

ED Visit Ts

Description	The date and time of the patient's latest emergency department visit.
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

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

Hypertension Diagnosis Ts

Description	Date and time the patient was diagnosed with Hypertension (HTN).
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

Hypertension Ind

Description	Indicator to identify if the patient has been diagnosed with Hypertension (HTN).
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

Inpatient Ind

Description	An Indicator to Identify an Inpatient. Inpatient is a type of encounter in which the patient visits the healthcare facility and stays overnight and is assigned a bed. An encounter groups a number of healthcare events, typically commencing with an admission or transfer into the healthcare facility and ends with a discharge or transfer out.
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

Laparoscopic Cholecystectomy Procedure Ind

Description	Indicator to identify that a Laparoscopic Cholecystectomy procedure has been performed on 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

Laparoscopic Cholecystectomy Procedure Ts

Description	Date and time when the Laparoscopic Cholecystectomy 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

Live Birth Ind

Description	Indicator to identify a live birth of a baby.
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

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

Lumpectomy Procedure Ind

Description	Indicator to identify that a Lumpectomy procedure has been performed on 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

Lumpectomy Procedure Ts

Description	Date and time when the Lumpectomy 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

Mastectomy Procedure Ind

Description	Indicator to identify that a Mastectomy procedure has been performed on 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

Mastectomy Procedure Ts

Description	Date and time when the Mastectomy 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

Maternity Ind

Description	Indicator to identify a maternity 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

Medical Benefits Plan Ind

Description	Indicator to show whether the patient has membership of a Health benefits plan providing medical benefits.
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

Medical Treatment Ind

Description	Indicator to identify a patient stay for medical treatment.
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

Mental Health Service Ind

Description	Indicator to identify whether a patient has recieved mental health service. - Any service. - Inpatient. - Intensive outpatient or partial hospitalization. - Outpatient or ED.
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

Mental Health Service Ts

Description	The date and time when the patient recieved mental health services. - Any service. - Inpatient. - Intensive outpatient or partial hospitalization. - Outpatient or ED.
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

Nonacute Treatment Ind

Description	Indicator to identify a patient stay for nonacute treatment.
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

Open Cholecystectomy Procedure Ind

Description	Indicator to identify that an Open Cholecystectomy procedure has been performed on 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

Open Cholecystectomy Procedure Ts

Description	Date and time when the Open Cholecystectomy 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

Outpatient Ind

Description	An indicator to identify and Outpatient. Outpatient is a type of encounter that takes place when the patient visits the healthcare facility but does not stay overnight and it is not assigned a bed.
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 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

PCI Procedure Ind

Description	Indicator to identify that a Percutaneous Coronary Intervention (PCI) has been performed on 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

PCI Procedure Ts

Description	Date and time when the Percutaneous Coronary Intervention (PCI) 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

Pharmacy Benefits Plan Ind

Description	Indicator to show whether the patient has membership of a Health benefits plan providing pharmacy benefits.
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

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

Prenatal Visit Ind

Description	Indicator to show the patient has had one or more prenatal visits.
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

Primary Care Practitioner Visit Ind

Description	Indicator to show the patient had a visit with a Primary Care Provider (PCP).
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

Primary Care Practitioner Visit Ts

Description	The date and time of the latest visit with a Primary Care Provider (PCP).
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

Prostatectomy Procedure Ind

Description	Indicator to identify that a Prostatectomy procedure has been performed on 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

Prostatectomy Procedure Ts

Description	Date and time when the Prostatectomy 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

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

Description	Indicate that the patient was readmitted. A readmission is an admission within a predetermined interval from a discharge from a previous admission.
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

Recreational Drug Use Ind

Description	Indicator to show if the patient is an Recreational Drug user.
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

Surgical Treatment Ind

Description	Indicator to identify a patient stay for surgical treatment.
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

Tonsillectomy Procedure Ind

Description	Indicator to identify that a Tonsillectomy procedure has been performed on 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

Tonsillectomy Procedure Ts

Description	Date and time when the Tonsillectomy 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

Total Hip Replacement Procedure Ind

Description	Indicator to identify that a Total Hip Replacement procedure has been performed on 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

Total Hip Replacement Procedure Ts

Description	Date and time when the Total Hip Replacement 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

Total Knee Replacement Procedure Ind

Description	Indicator to identify that a Total Knee Replacement procedure has been performed on 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

Total Knee Replacement Procedure Ts

Description	Date and time when the Total Knee Replacement 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

Vaginal Hysterectomy Procedure Ind

Description	Indicator to identify that a Vaginal Hysterectomy procedure has been performed on 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

Vaginal Hysterectomy Procedure Ts

Description	Date and time when the Vaginal Hysterectomy 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

Well Child Visit Ind

Description	Indicator to identify the well-child visit.
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

Well Child Visit Ts

Description	The date and time of the latest well-child visit.
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

Procedures Utilization Snapshot_Practitioner Dimension_FK

Is Identifying Relationship	true
Child Table	Procedures Utilization 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

Procedures Utilization Snapshot_Provider Dimension_FK

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

Procedures Utilization Snapshot_Calendar Dimension_FK

Is Identifying Relationship	true
Child Table	Procedures Utilization 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

Procedures Utilization Snapshot_Geographic Area Dimension_FK

Is Identifying Relationship	true
Child Table	Procedures Utilization 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	Geographic Area Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Procedures Utilization Snapshot_Condition Dimension_FK

Is Identifying Relationship	true
Child Table	Procedures Utilization 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

Procedures Utilization Snapshot_Patient Dimension_FK

Is Identifying Relationship	true
Child Table	Procedures Utilization 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

Primary Key Details

Procedures Utilization Snapshot PK

Key Attribute	Geographic Area Dk
Key Attribute	Patient Dk
Key Attribute	Practitioner Dk
Key Attribute	Provider Dk
Key Attribute	Calendar Dk
Key Attribute	Condition Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model