Atomic Warehouse Model Data Model

Entity

Entity Patient Detail

Description

An individual that is awaiting or is already under medical care and treatment.

Attributes
Advanced Directive Code Sk
APGAR1 Score Num
APGAR5 Score Num
Baby Mother Patient Num
Birth Order Seq
Birth Place Descr
Birth State Code Sk
Birth Ts
Blood Type Code Sk
Comfort Measures Only Ind
County Nm
Deactivate Dt
Death Ts
Disability Status Code Sk
Driver License Issues State Code Sk
Driver License Num
Duplicate Patient Descr
Education Code Sk
Effective From Dt
Effective To Dt
Employment Status Code Sk
Gestation Week Cnt
Identity Reliability Code Sk
Identity Unknown Ind
Immunization Registry Status Code Sk
Immunization Registry Status Effective Dt
Language Code Sk
Last Contact Dt
Literacy Code Sk
Living Arrangement Code Sk
Living Status Code Sk
Living Will Code Sk
Load Info Sk
Majority Dt
Marital Status Code Sk
Medicaid Num
Medical Record Num
Medicare Num
Military Branch Code Sk
Military Rank Code Sk
Military Status Code Sk
Mother Maiden Nm
Multiple Birth Ind
Nationality Country Code Sk
Necropsy Ind
Occupation Code Sk
Organ Donor Code Sk
Patient Death Ind
Patient Sk
Place Of Worship Descr
Protection Code Effective Dt
Protection Code Sk
Publicity Code Dt
Publicity Code Sk
Registration Ts
Religion Code Sk
Separate Bill Code Sk
Sex Code Sk
SMPI Num
Social Security Num
Source Code Sk
Student Status Code Sk
Tenant Sk
UMPI Num
Valid From Ts
Valid To Ts
VIP Code Sk

Relationship
is Anchor

Primary Key
Patient Detail PK

Dependencies

Reverse Dependencies

Attribute Details

Advanced Directive Code Sk

Description	Identifies instructions to the healthcare facility that the patient has put in place.
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

APGAR1 Score Num

Description	APGAR score 1 minute after delivery. The APGAR scale is used to evaluate a baby's health immediately after birth using five criteria, Appearance, Pulse, Grimace (reflex irritability), Activity and Respiration.
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

APGAR5 Score Num

Description	APGAR score 5 minutes after delivery. The APGAR scale is used to evaluate a baby's health immediately after birth using five criteria, Appearance, Pulse, Grimace (reflex irritability), Activity and Respiration.
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Baby Mother Patient Num

Description	An identification number for the mother of a baby patient.
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Birth Order Seq

Description	A number indicating the baby's birth order, when a baby was part of a multiple birth.
Data Type	Standards - Data Domains.ddm/Data Domains/Sequence Number [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Birth Place Descr

Description	The location of the baby's birth. For example: St. Francis Community Hospital of Lower South Side
Data Type	Standards - Data Domains.ddm/Data Domains/Description Short [VARCHAR(150)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Birth State Code Sk

Description	Indicates the state or province where the patient was born. In U.S., the 2-letter state code, for example, IN, NY, or CA. In other countries, a locally applicable code may be used.
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

Birth Ts

Description	The date and time a patient was born.
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

Blood Type Code Sk

Description	A blood type (also called a blood group) is a classification of blood based on the presence or absence of inherited antigenic substances on the surface of red blood cells (RBCs).
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

Comfort Measures Only Ind

Description	Indicates if the patient's care is to be limited to comfort measures only.
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

County Nm

Description	The name of the county for the address.
Data Type	Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Deactivate Dt

Description	Date upon which the patient is no longer considered an active patient of the healthcare organization or facility.
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

Death Ts

Description	The date and time a patient died.
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

Disability Status Code Sk

Description	Indicates any permanent or transient handicapped conditions. Also known as ambulatory status.
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

Driver License Issues State Code Sk

Description	The state or territory issuing the driver's license
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

Driver License Num

Description	The patient's driver's license number.
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Duplicate Patient Descr

Description	Indicates that a patient is the same as, or a duplicate of, another patient found on the sending system. The intent is to be informational only and no action is required by the receiver.
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

Education Code Sk

Description	Identifies the individual's highest level of education attained.
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

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

Employment Status Code Sk

Description	Indicates the current employment status of an individual. For example: Full time employed Part time employed Self-employed, Contract, per diem Leave of absence (for example, Family leave, sabbatical, etc.) Temporarily unemployed Unemployed Retired On active military duty Other Unknown
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

Gestation Week Cnt

Description	The number of weeks after conception the baby was delivered.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Identity Reliability Code Sk

Description	Indicates the reliability of information identifying an individual. This could indicate that certain information for a given patient/person are known to be false (for example, use of default or system-generated values for Date of Birth or Social Security Number).
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

Identity Unknown Ind

Description	Indicates that the actual identity of patient cannot be determined.
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

Immunization Registry Status Code Sk

Description	Identifies the immunization registry status of the patient. This may be used to indicate the changed status of a once active patient in an immunization registry.
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

Immunization Registry Status Effective Dt

Description	The date upon which the immunization registry status is defined.
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

Language Code Sk

Description	Identifies a language an individual can speak, read and / or write. May also identify the language or dialect in which a comment or text is recorded.
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

Last Contact Dt

Description	The date upon which the last contact was made with the individual. This could be the date of death in the case of a deceased person.
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

Literacy Code Sk

Description	Indicates whether the patient has the ability to understand written correspondence.
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

Living Arrangement Code Sk

Description	Indicates the situation that an individual lives in at his/her residential address. For example: A - Alone F - Family I - Institution R - Relative U - Unknown S - Spouse Only
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

Living Status Code Sk

Description	Indicates that the person is still alive.
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

Living Will Code Sk

Description	Indicates whether or not the patient has a living will and, if so, whether a copy of the living will is on file at the healthcare facility. If the patient does not have a living will, this may indicate whether the patient was provided information on living wills.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Load Info Sk

Description	The surrogate key of the load information entry describing the details regarding the loading of the row.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Majority Dt

Description	The date from which the patient is able to legally act on their own behalf. In legal terminology this is referred to as 'reaching the age of majority'. The date a person can enter into contracts and approve medical care.
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

Marital Status Code Sk

Description	Indicates the current marital status of an individual. For example: Married Single Divorced Widow
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

Medicaid Num

Description	The Medicaid case number, defined by CMS or other regulatory agencies, which uniquely identifies a patient's Medicaid policy.
Data Type	Standards - Data Domains.ddm/Data Domains/String [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Medical Record Num

Description	The medical record number (MRN) currently used to identify the patient.
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Medicare Num

Description	The Medicare case number, defined by CMS or other regulatory agencies, which uniquely identifies a patient's Medicare policy.
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Military Branch Code Sk

Description	Identifies the Branch of Service for Military personnel.
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

Military Rank Code Sk

Description	Identifies the military rank/grade of an individual.
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

Military Status Code Sk

Description	The military status of an individual as defined by CMS or other regulatory agencies. For example: ACT Active duty RET Retired DEC Deceased
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

Mother Maiden Nm

Description	The surname before marriage of an individuals mother.
Data Type	Standards - Data Domains.ddm/Data Domains/Name Compound [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Multiple Birth Ind

Description	Indicates whether the baby was a part of a multiple birth.
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

Nationality Country Code Sk

Description	Indicates the nation or national grouping to which a person belongs. This information may be different from a person's citizenship in countries in which multiple nationalities are recognized (for example, Spain: Basque, Catalan, etc.).
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

Necropsy Ind

Description	Indicates whether the baby was delivered deceased.
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

Occupation Code Sk

Description	The primary reported occupation of a person.
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

Organ Donor Code Sk

Description	Indicates whether a person wants to donate his/her organs and whether an organ donor card or similar documentation is on file with the healthcare organization.
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 Death Ind

Description	Indicates if the patient is deceased.
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 Sk

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

Place Of Worship Descr

Description	Identifies the patient's place of worship. For example: The First Baptist Church of Atlanta.
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

Protection Code Effective Dt

Description	The date upon which a person's protection commences. This means access to the person's data is restricted to the people who do not have adequate authority.
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

Protection Code Sk

Description	Identifies the patient's protection, which determines whether or not access to information about this person should be restricted from users who do not have adequate authority. 1 restrict access 0 do not restrict access
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

Publicity Code Dt

Description	The date upon which the patient's publicity level comes into effect.
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

Publicity Code Sk

Description	Indicates what level of publicity is allowed for an individual. For example: No Publicity Family Only
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

Registration Ts

Description	The date and time of initial registration for a patient.
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

Religion Code Sk

Description	Indicates the religion practiced by an individual.
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

Separate Bill Code Sk

Description	Specifies that charges for this patient are to be billed separately from other patient bills with the same guarantor. (This bill is now a patient bill rather than a guarantor bill.)
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

Sex Code Sk

Description	Identifies the gender of an individual.
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

SMPI Num

Description	The master patient identifier, a universal identifier assigned by a subscribing facility/system.
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Social Security Num

Description	The individual's social security number.
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Source Code Sk

Description	The origin of the data identifying the actual load source, vendor, manual key entry, or context of the data in a specific row in the database.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Student Status Code Sk

Description	Indicates whether the individual is currently a student, and whether the individual is a full-time or part-time student. 1 Student 0 Not a student
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

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

UMPI Num

Description	The Universal patient identifier set in Master Data Management (MDM).
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
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

VIP Code Sk

Description	Indicates that the individual is considered a very important person (VIP) such as ahead of state or religious leader.
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

is Anchor

Is Identifying Relationship	true
Child Table	Patient Detail
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Patient
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Primary Key Details

Patient Detail PK

Key Attribute	Patient Sk
Key Attribute	Valid From Ts

Overview

Top

Package

Entity

Atomic Warehouse Model Data Model