Business Data Model Data Model

Entity

Business Data Model Data Model

Entity Goal Note

Description

A note that relates to a goal within a care plan.

For example:
Goal assessment outcome note
Goal status explanation note

Attributes
Comment Source
Comment Type
Detail Seq
Goal Note Txt

Relationship
Goal Note_Goal_FK

Dependencies
NONE

Reverse Dependencies

Attribute Details

Description	Indicates the source of comment.
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

Description	Indicates the type of comment. For example: Patient Instructions Ancillary Instructions General Instructions Primary Reason Secondary Reason General Reason Remark Duplicate/Interaction Reason
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

Description	Indicates the sequence number of the goal note being recorded.
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

Description	Textual description of the recorded goal.
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

Relationship Details

Goal Note_Goal_FK

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

Entity

Business Data Model Data Model