Business Data Model Data Model

Entity

Entity Associated Party

Description

A party that is associated to a patient or other modeled party. Primarily used to record next of kin and other specified responsible parties to whom a patient may be discharged.

Attributes
Associated Party End Date
Associated Party Num
Associated Party Start Date
Birth Place Descr
Citizenship
Contact Reason
Contact Relationship
Date Of Birth Ts
Date Of Death Ts
Death Ind
Disability Status
Disability Type
Employee Num
Employment End Date Ts
Employment Start Date Ts
Employment Status
Gender
Job Class
Job Status
Job Title
Language
Living Arrangement
Living Dependency
Marital Status
Nationality Country
Patient Relationship
Protection Ind
Publicity Level
Religion Type
Student Status
VIP

Relationship
Associated Party_Race_FK
has name
Associated Party_Party Name_FK2
Associated Party_Employer_FK

Generalization
Generalization1

Dependencies
NONE

Reverse Dependencies

Attribute Details

Associated Party End Date

Description	The date upon which the associated relationship is ended. For example: A parent's status as the patient's next of kin ended when the patient married and assigned their spouse to be next of kin.
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

Associated Party Num

Description	The primary identifier assigned to the associated party.
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

Associated Party Start Date

Description	The date upon which the associated relationship is commenced. For example: The date upon which a parent was defined the patient's next of kin.
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

Birth Place Descr

Description	A textual description of the place an individual was born.
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

Citizenship

Description	The current citizenship of an individual.
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

Contact Reason

Description	A textual description of the circumstances under which the associated party should be contacted. For example: To phone the guarantor if payments are late.
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

Contact Relationship

Description	Indicates the associated party's relationship to the patient. For example: Wife Attorney Power of attorney Child Carer
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

Date Of Birth Ts

Description	The date and time that an individual 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 that an individual 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

Death Ind

Description	Indicates whether or not the associated party is deceased. 1 the associated party is deceased 0 the associated party is living
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

Disability Status

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

Description	Indicates the nature of an individual's disability. For example: Wheelchair bound Visually impaired Deaf
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

Employee Num

Description	The associated party's employee 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

Employment End Date Ts

Description	The date and time that the employment ended.
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

Employment Start Date Ts

Description	The date and time that the employment began.
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

Employment Status

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

Gender

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

Job Class

Description	Indicates the classification of an individual's job.
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

Job Status

Description	Indicates the current status of an individual's job.
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

Job Title

Description	Descriptive name of the individual's occupation. For example: Systems Analyst Accountant
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

Language

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

Living Arrangement

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

Living Dependency

Description	Indicates any dependency that relates to an individual in their day to day lives. For example: S Spouse Dependent M Medical Supervision Required C Small Children Dependent O Other U Unknown
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

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

Nationality Country

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

Patient Relationship

Description	Indicates the nature of the relationship of an individual with the patient. For example: Parent Child
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

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

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

Religion Type

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

Student Status

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/Boolean Indicator [INTEGER]
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 ahead 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

Relationship Details

Associated Party_Race_FK

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

has name

Is Identifying Relationship	false
Child Table	Associated Party
Child Role Name	has spouse name
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	Party Name
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Associated Party_Party Name_FK2

Is Identifying Relationship	false
Child Table	Associated Party
Child Role Name	has contact name
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	Party Name
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Associated Party_Employer_FK

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

Generalization Details

Generalization1

Supertype	Party Role
Subtype	Associated Party
Transform As	TABLE

Overview

Top

Package

Entity

Business Data Model Data Model