Atomic Warehouse Model Data Model

Entity

Entity Person Detail

Description

An individual human being whether living or dead.

Attributes
Advanced Directive Id
Birth State Code Sk
Blood Type Code Sk
Citizenship Country Code Sk
Comfort Measures Only Ind
County Nm
Current Employer Nm
Date Of Birth Ts
Date Of Death Ts
Disability Status Code Sk
Disposable Income
Driver License Issues State Code Sk
Driver License Num
Education Level Code Sk
Effective From Dt
Effective To Dt
Employment Status Code Sk
Employment Time Commitment Type Code Sk
Ethnic Group Code Sk
Gender Code Sk
Graduation Dt
Gross Income
Health Rating Code Sk
Identity Reliability Code Sk
Identity Unknown Ind
Immunization Registry Code Dt
Immunization Registry Code Sk
Language Code Sk
Last Contact Dt
Literacy Code Sk
Living Arrangement Code Sk
Living Status Code Sk
Living Will Code Sk
Load Info Sk
Marital Status Code
Marital Status Code Sk
Medicaid Num
Mother Maiden Nm
Nationality Country Code Sk
Number Of Dependent Adults
Number Of Dependent Children
Occupation Code Sk
Organ Donor Code Sk
Party Introduction Method Code Sk
Passport Num
Person Death Ind
Person Education Status Code Sk
Person Mental Health Status Code Sk
Person Sk
Physical Health Status Code Sk
Place Of Worship Id
Preferred Payment Method Code Sk
Preferred Written Language
Previous Employer Nm
Previous Refusal Ind
Primary Occupation Code Sk
Primary Role Code Sk
Protection Code Effective Dt
Protection Code Sk
Race Code Sk
Religion Code Sk
Requires Interpreter Ind
Self Employed Status Code Sk
Social Security Num
Source Code Sk
Student Status Code Sk
Tenant Sk
Unemployment Reason Code Sk
Valid From Ts
Valid To Ts

Relationship
Person Detail_Person_FK

Primary Key
Person Detail PK

Dependencies

Reverse Dependencies

Attribute Details

Advanced Directive Id

Description	Identifies instructions to the healthcare facility that the patient has put in place.
Data Type	Standards - Data Domains.ddm/Data Domains/Identifier [VARCHAR(80)]
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 person 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

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

Citizenship Country Code Sk

Description	Indicates the current citizenship 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

Comfort Measures Only Ind

Description	Indicates if the person'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

Current Employer Nm

Description	The name of the current employer of the person.
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

Date Of Birth Ts

Description	The date and time person 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

Date Of Death Ts

Description	The date and time a person 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

Disposable Income

Description	The amount of money that a person can spend after having paid all the fixed expenses such as rent, mortgage repayment and so on.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
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	A person'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

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

Employment Time Commitment Type Code Sk

Description	Indicates the degree of time the person commits to earning a living through work.
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

Ethnic Group Code Sk

Description	The individual's ethnic group.
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

Gender 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

Graduation Dt

Description	The date upon which the a person completed education.
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

Gross Income

Description	The most recent known gross monetary earnings of a person.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Health Rating Code Sk

Description	Indicates the general level of healthiness that applies to the party where the party is a person. For an organization, this may be an overall rating based on the individual Health Ratings of the organization's members.
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 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 Code 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

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

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

Marital Status Code

Description	Indicates the current marital status of an individual. For example: Married Single Divorced Widow
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
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 person's Medicaid 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

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

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

Number Of Dependent Adults

Description	The declared number of adults that are dependent on the person.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Dependent Children

Description	The declared number of children who are dependent on the person.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [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

Party Introduction Method Code Sk

Description	Indicates the manner in which the party is first introduced to the modeled organization. For example: Advertisement Business partner Mailshot campaign Newspaper Personal recommendation Television advertisement
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

Passport Num

Description	The number which uniquely identifies the person's passport.
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

Person Death Ind

Description	Indicates if the person 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

Person Education Status Code Sk

Description	Indicates the level of formal education that the member is currently undertaking.
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

Person Mental Health Status Code Sk

Description	Indicates the general mental health status held by a person. For example: Excellent Good Poor
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

Person Sk

Description	Anchor surrogate key for the Person 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

Physical Health Status Code Sk

Description	Indicates the general physical health held by a person. For example: Excellent Good Poor
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

Place Of Worship Id

Description	Identifies the patient's place of worship. For example: The First Baptist Church of Atlanta.
Data Type	Standards - Data Domains.ddm/Data Domains/Identifier [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Preferred Payment Method Code Sk

Description	Indicates the preferred method of payment of the party. For example: Cash Credit card Direct debit Standing order Transfer Check
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

Preferred Written Language

Description	The language which the person wishes all written communication to be conducted in.
Data Type	Standards - Data Domains.ddm/Data Domains/Text Medium [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Previous Employer Nm

Description	The name of the previous employer of the person.
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

Previous Refusal Ind

Description	Indicates whether (1) or not (0) the party has been refused a relationship with the modeled organization in the past. For example, a person may have been refused insurance or has had a policy cancelled or special terms imposed by a health insurance organization.
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 Occupation Code Sk

Description	The principal activity that a person does to earn money.
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

Primary Role Code Sk

Description	Indicates the main purpose of the party in relation to the modeled organization. For example: Intermediary Member Premium payer Solicitor Subscriber
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

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 person's protection that determines, in turn, whether access to information about this person should be kept from users who do not have adequate authority for the 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

Race Code Sk

Description	Indicates the race 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

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

Requires Interpreter Ind

Description	Indicates that the person requires an interpreter.
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Self Employed Status Code Sk

Description	Self-employed Status classifies persons based on the fact that they have a self-employed business. For example: Not Self-Employed Self-Employed
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

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

Unemployment Reason Code Sk

Description	Indicates why an individual is not working.
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

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

Relationship Details

Person Detail_Person_FK

Is Identifying Relationship	true
Child Table	Person Detail
Child Role Name	is anchor for
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	Person
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Primary Key Details

Person Detail PK

Key Attribute	Person Sk
Key Attribute	Valid From Ts

Overview

Top

Package

Entity

Atomic Warehouse Model Data Model