Atomic Warehouse Model Data Model

Entity

Entity Encounter Detail

Description

An interaction between healthcare practitioners and the patient for the purpose of providing healthcare services to the patient.
The interaction can happen in various settings: within a facility where the patient can be admitted overnight (inpatient stay), as an outpatient, or as a phone consultation.

A number of healthcare events can be grouped under an encounter.

Attributes
Accident Country Code Sk
Accident Dt
Accident State Code Sk
Accommodation Code Sk
Account Deleted Code Sk
Account Deleted Dt
Actual Length Of Stay Days Cnt
Acute Manifestation Dt
Admission Complaint Txt
Admission Height UOM Code Sk
Admission Height Val
Admission Level Of Care Code Sk
Admission Ts
Admission Type Code Sk
Admission Weight UOM Code Sk
Admission Weight Val
Admit Reason Code Sk
Alternate Encounter Num
Ambulatory Patient Group Num
Arrival Mode Code Sk
Benefits Assignment Certification Ind
Billing Media Code Sk
Certification Period Projected Visit Cnt
Charge Price Code Sk
Condition Reason Code Sk
Courtesy Code Sk
Credit Rating Code Sk
Detained Baby Ind
Diet Type Code Sk
Discharge Charges Amt
Discharge Status Code Sk
Discharge Ts
Effective From Dt
Effective To Dt
Emergency Ind
Employment Illness Ind
Encounter Descr
Encounter Num
Encounter Seq
Encounter Sk
Encounter Ts
Encounter Type Code Sk
Encounter User Code Sk
Estimated Length Of Stay Days Cnt
Expected Admission Ts
Expected Discharge Disposition Code Sk
Expected Discharge Ts
Expected Leave Of Absence Return Dt
Expected Number Of Insurance Plans Cnt
Expected Pre Admission Testing Ts
Expected Surgery Ts
First Similar Illness Dt
Homebound Ind
Initial Treatment Dt
Interpreter Needed Ind
Last Menstrual Cycle Dt
Last Seen Dt
Last Worked Dt
Last X-Ray Dt
Latest Illness Occurrence Dt
Living Will Code Sk
Load Info Sk
Mammography Authorization Num
Mechanical Ventilation Days Cnt
Medicare Assignment Code Sk
Military Non Available Code Sk
Military Partnership Code Sk
Newborn Baby Ind
Organ Donor Code Sk
Patient Charge Adjudication Code Sk
Patient Class Code Sk
Patient Condition Code Sk
Patient Status Code Sk
Patient Status Effective Dt
Patient Valuables Location Txt
Point Of Origin Code Sk
Pre Admission Encounter Num
Pre Admission Test Code Sk
Prescription Issue Dt
Previous Service Dt
Previous Treatment Dt
Priority Code Sk
Protection Ind
Provider Or Supplier Signature Ind
Publicity Code Sk
Purge Status Code Sk
Purge Status Dt
Re Admission Code Sk
Recurring Service Code Sk
Related Admission Dt
Related Discharge Dt
Release Of Information Code Sk
Reported Disability End Dt
Reported Disability Start Dt
Reporting Coding System Code Sk
Retention Ind
Signature Dt
Similar Illness Dt
Source Code Sk
Source Of Release Information Code Sk
Special Program Code Sk
Tenant Sk
Transfer Reason Code Sk
Valid From Ts
Valid To Ts
VIP Code Sk
Visit Type Code Sk
Work Return Dt

Relationship
Encounter Detail_Encounter_FK

Primary Key
Encounter Detail PK

Dependencies

Reverse Dependencies

Attribute Details

Accident Country Code Sk

Description	Identifies the country where the accident occurred.
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

Accident Dt

Description	The date upon which the accident related to charges or to the patient's current condition, diagnosis, or treatment occurred.
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

Accident State Code Sk

Description	Identifies the state in which the accident occurred.
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

Accommodation Code Sk

Description	Indicates the specific patient accommodation for this visit.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Account Deleted Code Sk

Description	Indicates the reason that the account was deleted from the file.
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

Account Deleted Dt

Description	The date upon which the patient account was deleted from the source application.
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

Actual Length Of Stay Days Cnt

Description	The number of days that a patient actually stayed as an in-patient. Also known as Length Of Stay.
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

Acute Manifestation Dt

Description	The date upon which the patient's condition was acutely manifested.
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

Admission Complaint Txt

Description	The patient's main complaint at the time of admission.
Data Type	Standards - Data Domains.ddm/Data Domains/Free Text [VARCHAR(1024)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Admission Height UOM Code Sk

Description	The unit of measure for height.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Admission Height Val

Description	The height of patient at time of admission.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal Small [DECIMAL(5,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Admission Level Of Care Code Sk

Description	Indicates the acuity level assigned to the patient at the time of admission.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Admission Ts

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

Admission Type Code Sk

Description	Indicates the circumstances under which the patient was or will be admitted For example: Accident Routine Emergency
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Admission Weight UOM Code Sk

Description	The unit of measure for weight.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Admission Weight Val

Description	The weight of patient at time of admission.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal Small [DECIMAL(5,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Admit Reason Code Sk

Description	Indicates the reason for a patient's admission.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Alternate Encounter Num

Description	The alternative, temporary, or pending optional visit ID number to be used if needed.
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

Ambulatory Patient Group Num

Description	An identifier for the Ambulatory Patient Group with which this patient is managed.
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

Arrival Mode Code Sk

Description	Identifies how the patient was brought to the healthcare facility. For example: By Ambulance Self Transported
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

Benefits Assignment Certification Ind

Description	Indicates whether or not the provider has a signed form authorizing the third party payer to pay the 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

Billing Media Code Sk

Description	Identifies the billing media to be used. For example: Paper billing Electronic billing
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

Certification Period Projected Visit Cnt

Description	The estimated number of visits to be covered by this Claim.
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

Charge Price Code Sk

Description	Indicates the price schedule to be used for room and bed charges.
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

Condition Reason Code Sk

Description	Indicates an accompanying cause for an illness, injury, or accident.
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

Courtesy Code Sk

Description	Indicates whether the patient will be extended certain special courtesies.
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

Credit Rating Code Sk

Description	User-defined rating of an individual's or organization's credit worthiness.
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

Detained Baby Ind

Description	Indicates whether or not the baby was kept in hospital after mother's discharge.
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

Diet Type Code Sk

Description	Indicates a special diet type for a patient.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Discharge Charges Amt

Description	The charges at the time of a patient discharge.
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

Discharge Status Code Sk

Description	Indicates the disposition of the patient at time of discharge. For example: Discharged to home Expired
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Discharge Ts

Description	That date and time that the patient was discharged from the medical facility.
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

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

Emergency Ind

Description	Indicates whether or not emergency care was rendered in response to the sudden and unexpected onset of a medical condition, a severe injury, or an acute exacerbation of a chronic condition which was threatening to life, limb or sight.
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

Employment Illness Ind

Description	Indicates whether or not a patient's illness is job-related.
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

Encounter Descr

Description	A brief user-defined description of the visit.
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

Encounter Num

Description	Identifies an instance of an encounter.
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

Encounter Seq

Description	Indicates the order of the encounter transactions.
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

Encounter Sk

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

Encounter Ts

Description	The date and time of the visit, admission, registration, pre-admission or arrival.
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

Encounter Type Code Sk

Description	Indicates the type of encounter. For example: Emergency Inpatient Outpatient
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

Encounter User Code Sk

Description	Further categorizes a patient's visit with respect to an individual institution's needs, and is expected to be site-specific.
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

Estimated Length Of Stay Days Cnt

Description	The estimated number of days for an in-patient stay. Also known as Expected Length Of Stay.
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

Expected Admission Ts

Description	The date and time that the patient is expected to be admitted. Also used to reflect the date/time of an outpatient/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

Expected Discharge Disposition Code Sk

Description	Indicates the patient's expected disposition at the end of the visit.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Expected Discharge Ts

Description	Date and time that the patient is expected to be discharged. This is a non-event related date used by ancillaries to determine more accurately the projected workloads. Also used to reflect the anticipated discharge date/time of an outpatient/emergency patient, or an inpatient.
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

Expected Leave Of Absence Return Dt

Description	The date upon which a patient is expected to return from a leave of absence.
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

Expected Number Of Insurance Plans Cnt

Description	The number of insurance plans that may provide coverage for this visit.
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

Expected Pre Admission Testing Ts

Description	The date and time that the patient is expected for pre-admission testing.
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

Expected Surgery Ts

Description	The date and time that the surgery is expected to occur.
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

First Similar Illness Dt

Description	The date upon which a related illness was first recorded. Used to determine if the patient has a pre-existing condition.
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

Homebound Ind

Description	Indicates whether or not a patient is homebound.
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

Initial Treatment Dt

Description	The date upon which the patient initially sought treatment for this condition.
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

Interpreter Needed Ind

Description	Indicates whether or not the Member needs an interpreter to translate the local language to the Member's language.
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

Last Menstrual Cycle Dt

Description	The date of the last menstrual period (LMP).
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

Last Seen Dt

Description	The date upon which the patient was last seen by the referring or ordering physician for a claim billed by a provider whose services require physician certification.
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

Last Worked Dt

Description	The date upon which the patient last worked.
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

Last X-Ray Dt

Description	The date upon which the patient most recently had an X-Ray.
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

Latest Illness Occurrence Dt

Description	The date upon which the patient's condition began.
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

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

Mammography Authorization Num

Description	The Certification Number of the certified mammography screening center, assigned by HCFA.
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

Mechanical Ventilation Days Cnt

Description	The number of days the patient is on a Mechanical Ventilator. This is also known as DMV days.
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

Medicare Assignment Code Sk

Description	An indication, used by Medicare or other government programs, that the provider accepted assignment. For Example: Assigned Assignment Accepted on Clinical Lab Services Only Not Assigned Patient Refuses to Assign Benefits
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 Non Available Code Sk

Description	Indicates whether or not a patient has permission to use a non-military healthcare facility for treatment.
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 Partnership Code Sk

Description	Indicates that a military healthcare facility has contracted with a non-military healthcare facility for the use of its services.
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

Newborn Baby Ind

Description	Indicates whether the patient is a newborn baby or not.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Organ Donor Code Sk

Description	Indicates whether or not a person wants to donate their organs and whether or not 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 Charge Adjudication Code Sk

Description	Describes what adjustments should be made to a patient's charges.
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 Class Code Sk

Description	A categorization of patients. For Example: Emergency Inpatient Outpatient Obstetrics
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 Condition Code Sk

Description	Describes the condition of a patient. May be used for or sourced from Claim data.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Patient Status Code Sk

Description	Indicates the status of a patient in relation to an episode of care or other event. For example: Inpatient Active Inpatient Discharged Outpatient Active
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Patient Status Effective Dt

Description	The date upon which a patient's status is effective. For example: Discharged Inpatient on 02/05/2012
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

Patient Valuables Location Txt

Description	The location of the patient's valuables.
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

Point Of Origin Code Sk

Description	Indicates the source location or method by which the patient was admitted. For example: Physician Referral Clinic Referral Transfer from a Hospital
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

Pre Admission Encounter Num

Description	The unique number associated with the Encounter that was assigned when a Pre-admission was established. Only recorded when different than the official Encounter 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

Pre Admission Test Code Sk

Description	Indicates whether the patient must have pre-admission testing done in order to be admitted.
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

Prescription Issue Dt

Description	The date upon which the prescription was issued by the prescribing practitioner.
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

Previous Service Dt

Description	The date upon which service for the same recurring condition previously took place. This may be a required field for billing certain illnesses (for example, accident related) to a third party.
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

Previous Treatment Dt

Description	The date upon which the patient last received treatment for any condition prior to this visit. In the case of a prior hospital visit, it is likely to be the previous discharge date.
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

Priority Code Sk

Description	Indicates the priority of the visit. For example: Emergency Urgent Elective
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 Ind

Description	Identifies the individual'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/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Provider Or Supplier Signature Ind

Description	Indicates that the provider of service (reported on this claim) acknowledges the performance of the service and authorizes payment, and that a signature is on file in the provider's office.
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

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

Purge Status Code Sk

Description	Indicates the purge status for the encounter information. It is used by the application program to determine purge processing.
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

Purge Status Dt

Description	The date upon which the data relating to an encounter will be purged.
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

Re Admission Code Sk

Description	Indicates whether or not the patient has been re-admitted to the facility.
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

Recurring Service Code Sk

Description	Indicates whether the treatment is continuous or ongoing.
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

Related Admission Dt

Description	For Professional Claims, the date upon which the patient was admitted for inpatient care related to current service.
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

Related Discharge Dt

Description	For Professional claims, the date upon which the patient was discharged from the inpatient care referenced in the applicable hospitalization or hospice date.
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

Release Of Information Code Sk

Description	Indicates whether or not the provider has a signed statement on file permitting the release of medical data to other organizations. For example: - Appropriate Release of Information on File at Health Care Service Provider or at Utilization Review Organization - Informed Consent to Release Medical Information for Conditions or Diagnoses Regulated by Federal Statutes - The Provider has Limited or Restricted Ability to Release Data Related to a Claim - No, Provider is Not Allowed to Release Data - On file at Payor or at Plan Sponsor - Yes, Provider has a Signed Statement Permitting Release of Medical Billing Data Related to a Claim
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

Reported Disability End Dt

Description	The date upon which the reported disability of the patient ended.
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

Reported Disability Start Dt

Description	The date upon which the reported disability of the patient began.
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

Reporting Coding System Code Sk

Description	Indicates the coding system for this encounter when including it in reports.
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

Retention Ind

Description	Allows the user to control the financial and demographic purge processes at the visit. It is used to preserve demographic and financial data on specific, high priority 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

Signature Dt

Description	The date upon which the patient's signature is obtained for administrative purposes. For example: insurance billing
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

Similar Illness Dt

Description	The date upon which a similar illness or symptom began.
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

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

Source Of Release Information Code Sk

Description	Indicates how the patient/subscriber authorization signatures were obtained and how they are being retained by the provider. For example: - Signed signature authorization form or forms for both HCFA-1500 Claim Form block 12 and block 13 are on file - Signed HCFA-1500 Claim Form on file - Signed signature authorization form for HCFA-1500 Claim Form block 13 on file - Signature generated by provider because the patient was not physically present for services - Signed signature authorization form for HCFA-1500 Claim Form block 12 on file
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

Special Program Code Sk

Description	Identifies a specific health insurance program related to a visit. May be required for healthcare reimbursement.
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

Transfer Reason Code Sk

Description	Indicates the reason for a patient's location change.
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

VIP Code Sk

Description	Indicates that the individual is considered a very important person (VIP), such as a head 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

Visit Type Code Sk

Description	Indicates whether the information is at Account Level (applies to multiple visits) or at current Visit Level (single visit).
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Work Return Dt

Description	The date upon which the patient returned to work.
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

Relationship Details

Encounter Detail_Encounter_FK

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

Primary Key Details

Encounter Detail PK

Key Attribute	Encounter Sk
Key Attribute	Valid From Ts

Overview

Top

Package

Entity

Atomic Warehouse Model Data Model