Business Data Model Data Model

Entity

Entity Encounter

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

Relationship
Encounter_Point Of Care Location_FK2
Encounter_Point Of Care Location_FK1
Encounter_Practitioner_Admitting_FK
Encounter has Patient FK
Encounter_Provider_FK
Encounter_Practitioner_Attending_FK
Encounter_Point Of Care Location_FK3
Encounter_Point Of Care Location_FK
Encounter_Practitioner_FK
Encounter_Encounter_FK
Encounter_User_FK
Encounter_User_FK1
Encounter_User_FK2
Encounter_User_FK3
Encounter_Patient Account_FK
Encounter_Dietary Order_FK
Encounter_Point Of Care Device_FK

Dependencies
NONE

Reverse Dependencies

Attribute Details

Accident Country

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

Accident State

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

Accommodation

Description	Indicates the specific patient accommodation for this visit.
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

Account Deleted Reason

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

Account Status

Description	Indicates the current state of the account related to the encounter. For example: Preadmission Admitted Readmission Discharged
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

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 Date

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 Unit Of Measure

Description	The unit of measure for height.
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

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

Description	Indicates the acuity level assigned to the patient at the time of admission.
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

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

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/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Admission Weight Unit Of Measure

Description	The unit of measure for weight.
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

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

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

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

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/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Benefits Assignment Certification Ind

Description	An indicator that shows whether 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 Type

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

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 Schedule

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

Condition Reason

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

Courtesy Code

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

Credit Rating

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

Currency

Description	The currency that is used as the basis for all monetary amounts.
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

Current Account Balance Amt

Description	The balance due at the time of the visit or encounter.
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

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

Description	Indicates a special diet type for a patient.
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

Disability End Date

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

Disability Start Date

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

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

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/Enumeration [VARCHAR(20)]
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

Emergency Ind

Description	Indicates whether 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	true
Is Derived	false
Is Surrogate Key	false

Encounter Point Of Origin

Description	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/Enumeration [VARCHAR(20)]
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 Signature Date

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

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

Description	Indicates the type of encounter. For example: Emergency Inpatient Outpatient
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Encounter User

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/Enumeration [VARCHAR(20)]
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

Description	Indicates the patient's expected disposition at the end of the visit.
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

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 Date

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 when 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 Date

Description	The date when a related illness was first recorded. This date is used to determine whether 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 Date

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 Date

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 Date

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 Date

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 Date

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 Date

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

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/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
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 Type

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/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Military Non Available Flag

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/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Military Partnership

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/Enumeration [VARCHAR(20)]
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 Type

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/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Patient Account Deleted Date

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

Patient Charge Adjudication

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

Patient Class

Description	A categorization of patients. For Example: Emergency Inpatient Outpatient Obstetrics
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Patient Condition

Description	Indicates a disease or medical condition that a patient has.
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

Patient Death Ts

Description	The date and time of a patient's death.
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

Patient Status

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/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Patient Status Effective Date

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

Pre-Admission Encounter Num

Description	The unique number that is associated with the encounter that was assigned when a pre-admission was established, and is only recorded when it is different to 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

Description	An indicator that shows whether the patient must have pre-admission testing done to be admitted.
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

Prescription Issue Date

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 Date

Description	The date when the service for the same recurring condition previously took place. This can be a required field for billing certain illnesses, such as 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 Date

Description	The date when the patient last received treatment for a condition before the visit. In the case of an earlier 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

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 Level

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/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Purge Date

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

Purge Status

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/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Re-Admission Ind

Description	An indicator that shows whether the patient has been re-admitted to the facility.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Recurring Service

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

Related Accident Date

Description	The date when 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

Related Admission Date

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 Date

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

Description	An indicator that shows 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 Healthcare 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/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Relinquished Care Date

Description	The date upon which post-operative care was assumed by another provider or the provider ceased post-operative 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

Reporting Coding System

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

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

Similar Illness Date

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 Of Release Information

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/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Special Program

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/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Total Adjustments Amt

Description	The total adjustments of charges for the encounter.
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

Total Charges Amt

Description	The total of charges for this visit or encounter.
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

Total Payments Amt

Description	The total amount payed for this encounter.
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

Total Reimbursement Amt

Description	The total amount that will be, or has been, reimbursed for this encounter.
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

Transfer Reason

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

VIP

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/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Visit Information Type

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/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Visit Priority

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

Work Return Date

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_Point Of Care Location_FK2

Is Identifying Relationship	false
Child Table	Encounter
Child Role Name	has pending
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Point Of Care Location
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Encounter_Point Of Care Location_FK1

Is Identifying Relationship	false
Child Table	Encounter
Child Role Name	has temporary
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Point Of Care Location
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Encounter_Practitioner_Admitting_FK

Is Identifying Relationship	false
Child Table	Encounter
Child Role Name	admitting
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
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Encounter has Patient FK

Is Identifying Relationship	false
Child Table	Encounter
Child Role Name	has as subject
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

Encounter_Provider_FK

Is Identifying Relationship	false
Child Table	Encounter
Child Role Name	occurs at
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
Parent Multiplicity	ZERO_TO_MANY
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Encounter_Practitioner_Attending_FK

Is Identifying Relationship	false
Child Table	Encounter
Child Role Name	attending
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
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Encounter_Point Of Care Location_FK3

Is Identifying Relationship	false
Child Table	Encounter
Child Role Name	has discharge
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Point Of Care Location
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Encounter_Point Of Care Location_FK

Is Identifying Relationship	false
Child Table	Encounter
Child Role Name	has assigned
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Point Of Care Location
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Encounter_Practitioner_FK

Is Identifying Relationship	false
Child Table	Encounter
Child Role Name	other
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
Parent Multiplicity	ZERO_TO_MANY
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Encounter_Encounter_FK

Is Identifying Relationship	false
Child Table	Encounter
Child Role Name	is child of
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	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Encounter_User_FK

Is Identifying Relationship	false
Child Table	Encounter
Child Role Name	admitting
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	User
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Encounter_User_FK1

Is Identifying Relationship	false
Child Table	Encounter
Child Role Name	attending
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	User
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Encounter_User_FK2

Is Identifying Relationship	false
Child Table	Encounter
Child Role Name	attending
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	User
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Encounter_User_FK3

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

Encounter_Patient Account_FK

Is Identifying Relationship	false
Child Table	Encounter
Child Role Name	account 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	Patient Account
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Encounter_Dietary Order_FK

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

Encounter_Point Of Care Device_FK

Is Identifying Relationship	false
Child Table	Encounter
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Point Of Care Device
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Overview

Top

Package

Entity

Business Data Model Data Model