Business Data Model Data Model

Entity

Entity Patient Problem

Description

The health issues that are reported by a patient observed by a practitioner or determined via empirical evidence such as a lab test result or radiology exam.

For example:
Dizziness
Reduced mobility
Loss of appetite

Attributes
Actual Problem Resolution Ts
Age At Onset Qty
Anticipated Problem Resolution Ts
Patient Problem
Patient Problem Num
Problem Annotation Txt
Problem Awareness Family
Problem Certainty
Problem Classification
Problem Confirmation Status
Problem Descr
Problem Established Ts
Problem Inactive Date
Problem Individual Awareness
Problem Life Cycle Status
Problem Life Cycle Status Ts
Problem List Priority Seq
Problem Onset Date
Problem Onset Txt
Problem Persistence
Problem Probability Num
Problem Prognosis
Problem Ranking Num
Problem Sensitivity
Problem Status
Prognosis Awareness Individual

Relationship
Patient Problem_Encounter_FK
Patient Problem_Clinical Finding_FK
Patient Problem_Care Plan_FK
Patient Problem_Practitioner_FK
Patient Problem_Patient_FK
Patient Problem_Organization_FK
Patient Problem_Plan Member_FK

Dependencies
NONE

Reverse Dependencies

Attribute Details

Actual Problem Resolution Ts

Description	The date and time upon which the problem was actually resolved.
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

Age At Onset Qty

Description	Indicates the age of the patient when the problem began. Normally expressed in years for adults and older children but maybe expressed in months, weeks or days for infants.
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Anticipated Problem Resolution Ts

Description	The estimated date and time for resolving the stated problem.
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 Problem

Description	Identifies a problem or disorder faced by a person. For example: Diabetes High Blood Pressure
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 Problem Num

Description	Identifies a record of a patient problem within the source system environment.
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

Problem Annotation Txt

Description	Describes or annotates more details about the patient's problem.
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

Problem Awareness Family

Description	Identifies the individual's family or significant other's comprehension of the actual problem/prognosis. For example: Full Marginal Partial
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

Problem Certainty

Description	Identifies the qualitative representation of the certainty of a problem. For example: HI - high LO - low ME - medium
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

Problem Classification

Description	The type of problem that can be used to categorize problems so that they may be managed and viewed independently within different applications. For example: Admission Final Post-operative Pre-operative Outpatient Discharge
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

Problem Confirmation Status

Description	Identifies the verification status of a problem. For example: Confirmed Differential Provisional Rule-out
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

Problem Descr

Description	Describes the patient problem. Free-text entry of problems when no code table is available.
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

Problem Established Ts

Description	The date and time upon which the patient problem was initially identified.
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

Problem Inactive Date

Description	The date upon which the problem was inactive.
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

Problem Individual Awareness

Description	Identifies the individual's comprehension of the problem. For example: Full Marginal Partial
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

Problem Life Cycle Status

Description	Identifies the current status of the problem. For example: Active Active-improving Active-stable Active-worsening Inactive Resolved
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

Problem Life Cycle Status Ts

Description	The effective date and time of the current problem lifecycle status.
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

Problem List Priority Seq

Description	Indicates the priority of the problem on a list that is maintained for the individual.
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

Problem Onset Date

Description	The date upon which the problem 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

Problem Onset Txt

Description	Textual description of details about the patient's problem when the problem began.
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

Problem Persistence

Description	Identifies the perseverance of an individual's problem. For example: Acute Chronic
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

Problem Probability Num

Description	Indicates a quantitative or numeric representation of the certainty that the problem exists for this patient. This field has a valid range of 0 to 1. For example, a healthcare provider may be 75% (.75) sure that the problem has been correctly identified.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Problem Prognosis

Description	Identifies the prognosis for the individual's problem. For example: Good Poor
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

Problem Ranking Num

Description	A user-defined prioritization of a problem. For example: Numeric ranking The use of words such as "primary", "secondary"
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

Problem Sensitivity

Description	The level of security, sensitivity or both surrounding the problem. For example: Highly sensitive Not sensitive Sensitive
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

Problem Status

Description	Indicates the current status of a patient problem. For example: Suspected Confirmed Resolved
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

Prognosis Awareness Individual

Description	Identifies the individual's comprehension of the prognosis for the problem. For example: Full Marginal Partial
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

Patient Problem_Encounter_FK

Is Identifying Relationship	false
Child Table	Patient Problem
Child Role Name	mapped to
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_MANY
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Patient Problem_Clinical Finding_FK

Is Identifying Relationship	false
Child Table	Patient Problem
Child Role Name	associated with
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	Clinical Finding
Parent Multiplicity	ZERO_TO_MANY
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Patient Problem_Care Plan_FK

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

Patient Problem_Practitioner_FK

Is Identifying Relationship	false
Child Table	Patient Problem
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

Patient Problem_Patient_FK

Is Identifying Relationship	true
Child Table	Patient Problem
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

Patient Problem_Organization_FK

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

Patient Problem_Plan Member_FK

Is Identifying Relationship	true
Child Table	Patient Problem
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	Plan Member
Parent Multiplicity	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