Tables [dbo].[Act_Goal]
Activity level table for patient Goals. Derived from the Act_HDr_Goal table for every activity of the Goal
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Primary Key PK_Act_Goal_ID: IDID[dbo].[uniqueid]9NOT NULLKey to the Act_Goal table
Indexes XAct_Goal_ActHdrIDForeign Keys FK_Act_Goal_ActivityHeaderID: [dbo].[Act_Hdr_Goal].ActivityHeaderIDActivityHeaderID[dbo].[uniqueid]9NOT NULLHeader. Link to Act_Hdr_Goal.ID
Foreign Keys FK_Act_Goal_OrganizationID: [dbo].[Organization].OrganizationIDOrganizationIDnumeric(8,0)5NOT NULLOrganization. Link to Organization.ID.
NoteTypeDE[dbo].[dict_id]5NOT NULLNote Type. Link to Note_Type_DE.ID. Always 0
TemplateVersionsmallint2NOT NULLLink to Note_Template_Version.TemplateVersion. Always 0
EpisodeID[dbo].[uniqueid]9NOT NULLUnused
CarePlanDE[dbo].[dict_id]5NOT NULLUnused
OrderSourceDE[dbo].[dict_id]5NOT NULLOrder Source. Link to Order_Source_DE.ID. Always 0
OrderNumberEXTvarchar(20)20NOT NULLExternal Order Number. Always blank
FUComment[dbo].[message]255NOT NULLUnused. Always blank
AccessionNumbervarchar(20)20NOT NULLRefers to field 'Accession #' in Order Detail window while Entering Goal.
InterfaceSourceIDsmallint2NOT NULLAlways 0. Indicates whether the result is created from TouchWorks or the external interface.
Indexes NIX_Act_Goal_TestingProviderIDForeign Keys FK_Act_Goal_TestingProviderID: [dbo].[Person].TestingProviderIDTestingProviderID[dbo].[uniqueid]9NOT NULLTesting Provider. Link to Person.ID. Always 0
WhoForID[dbo].[uniqueid]9NOT NULLProvider this was entered for. Link to Provider.ID.
WhoDidItID[dbo].[uniqueid]9NOT NULLLink to IDX_User.ID. It holds the Provider ID who modified the data
PerformedDTTMdatetime8NOT NULLPerformed Date and Time of the Goal.
RecordedDTTMdatetime8NOT NULLRecorded Date and Time of the Goal.
Check Constraints CK_Act_Goal_HasClinicalWarningFLAG_Yes_Or_No : ([HasClinicalWarningFLAG]='N' OR [HasClinicalWarningFLAG]='Y')HasClinicalWarningFLAG[dbo].[BOOL]1NOT NULLUnused. Always set to N.
ClinicalDTTMdatetime8NOT NULLDate and time of when the goal was entered
ClinicalSourceDE[dbo].[dict_id]5NOT NULLSource. Link to Source_DE.ID.
Indexes NIX_Act_Goal_OrderingProviderIDForeign Keys FK_Act_Goal_OrderingProviderID: [dbo].[Person].OrderingProviderIDOrderingProviderID[dbo].[uniqueid]9NOT NULLOrdering Provider. Link to Person.ID
OrderingProviderName[dbo].[name]255NOT NULLName of the Ordering provider
Cluster Key CIXAct_Goal_PatID: PatientIDForeign Keys FK_Act_Goal_PatientID: [dbo].[Patient_Member].PatientIDPatientIDnumeric(16,0)9NOT NULLPatient. Link to Person.ID
ActivityTypevarchar(10)10NULL allowedActivity Type GL for Goal