Last Updated: 7/22/2025 8:42:49 PM

Intergy Version: 22.00.00.00

PatientCPGoalHistory

Table Definition  Parent Tables  Child Tables

Table Definition

Description: This table is used to store patient care plan goal history (used to display history).

Field Datatype Default Null Option Comment
PatientCPGoalHistorySID INTEGER ?   MANDATORY System generated unique number using the PatientCarePlan sequence.
PatientCPGoalSID INTEGER ?   MANDATORY FK
Description CHAR(300)   MANDATORY Goal Description
HideFromPatient LOGICAL Logical_False   MANDATORY Hide From patient
GoalStatus CHARACTER(6)   MANDATORY Lookup Type 'CarePlanGoal'
TimeStamp CHARACTER(14)   OPTIONAL System generated date/time stamp record was last written.
LastUser INTEGER ?   OPTIONAL User ID of user that last wrote the record.
CreateStamp CHARACTER(14)   OPTIONAL System generated date/time stamp record was created.
CreateUser INTEGER ?   OPTIONAL User ID of user that created the record.
MedcinID INTEGER ?   OPTIONAL Medcin Finding Reference.
Prefix CHAR(2)   OPTIONAL Medcin Finding Prefix. Defined by MedcinPrefix lookup.
AuthorType CHAR(4)   OPTIONAL User or Patient that initiated the goal. Defined by LookupType PatCPGoalAuthorType.
Source CHAR(50)   OPTIONAL The source (Intergy or otherwise) of this Goal history data.
ExternalUserLogon CHAR(30)   OPTIONAL User Logon for external user. Blank unless an external user created this Goal history data.
ExternalUserFullName CHAR(100)   OPTIONAL Full Name for external user. Blank unless an external user created this Goal history data.
Intent CHAR(20)   OPTIONAL Intent that is associated with this PatientCPGoalHistory

Parent Tables
Parent TableJoin PhraseWhen deleting parent record...
PatientCPGoal PatientCPGoalHistory.PatientCPGoalSID = PatientCPGoal.PatientCPGoalSID CASCADE if PatientCPGoalHistory exists

Child Tables
Child TableJoin PhraseWhen deleting PatientCPGoalHistory record...