Key | Name | Data Type | Max Length (Bytes) | Nullability | Description |
---|
 | ID | [dbo].[uniqueid] | 9 | NOT NULL | Key to the Act_Goal table |
 ![Foreign Keys FK_Act_Goal_ActivityHeaderID: [dbo].[Act_Hdr_Goal].ActivityHeaderID Foreign Keys FK_Act_Goal_ActivityHeaderID: [dbo].[Act_Hdr_Goal].ActivityHeaderID](../../../../Images/fk.png) | ActivityHeaderID | [dbo].[uniqueid] | 9 | NOT NULL | Header. Link to Act_Hdr_Goal.ID |
![Foreign Keys FK_Act_Goal_OrganizationID: [dbo].[Organization].OrganizationID Foreign Keys FK_Act_Goal_OrganizationID: [dbo].[Organization].OrganizationID](../../../../Images/fk.png) | OrganizationID | numeric(8,0) | 5 | NOT NULL | Organization. Link to Organization.ID. |
| NoteTypeDE | [dbo].[dict_id] | 5 | NOT NULL | Note Type. Link to Note_Type_DE.ID. Always 0 |
| TemplateVersion | smallint | 2 | NOT NULL | Link to Note_Template_Version.TemplateVersion. Always 0 |
| EpisodeID | [dbo].[uniqueid] | 9 | NOT NULL | Unused |
| CarePlanDE | [dbo].[dict_id] | 5 | NOT NULL | Unused |
| OrderSourceDE | [dbo].[dict_id] | 5 | NOT NULL | Order Source. Link to Order_Source_DE.ID. Always 0 |
| OrderNumberEXT | varchar(20) | 20 | NOT NULL | External Order Number. Always blank |
| FUComment | [dbo].[message] | 255 | NOT NULL | Unused. Always blank |
| AccessionNumber | varchar(20) | 20 | NOT NULL | Refers to field 'Accession #' in Order Detail window while Entering Goal. |
| InterfaceSourceID | smallint | 2 | NOT NULL | Always 0. Indicates whether the result is created from TouchWorks or the external interface. |
 ![Foreign Keys FK_Act_Goal_TestingProviderID: [dbo].[Person].TestingProviderID Foreign Keys FK_Act_Goal_TestingProviderID: [dbo].[Person].TestingProviderID](../../../../Images/fk.png) | TestingProviderID | [dbo].[uniqueid] | 9 | NOT NULL | Testing Provider. Link to Person.ID. Always 0 |
| WhoForID | [dbo].[uniqueid] | 9 | NOT NULL | Provider this was entered for. Link to Provider.ID. |
| WhoDidItID | [dbo].[uniqueid] | 9 | NOT NULL | Link to IDX_User.ID. It holds the Provider ID who modified the data |
| PerformedDTTM | datetime | 8 | NOT NULL | Performed Date and Time of the Goal. |
| RecordedDTTM | datetime | 8 | NOT NULL | Recorded Date and Time of the Goal. |
![Check Constraints CK_Act_Goal_HasClinicalWarningFLAG_Yes_Or_No : ([HasClinicalWarningFLAG]='N' OR [HasClinicalWarningFLAG]='Y') Check Constraints CK_Act_Goal_HasClinicalWarningFLAG_Yes_Or_No : ([HasClinicalWarningFLAG]='N' OR [HasClinicalWarningFLAG]='Y')](../../../../Images/c-constraint.png) | HasClinicalWarningFLAG | [dbo].[BOOL] | 1 | NOT NULL | Unused. Always set to N. |
| ClinicalDTTM | datetime | 8 | NOT NULL | Date and time of when the goal was entered |
| ClinicalSourceDE | [dbo].[dict_id] | 5 | NOT NULL | Source. Link to Source_DE.ID. |
 ![Foreign Keys FK_Act_Goal_OrderingProviderID: [dbo].[Person].OrderingProviderID Foreign Keys FK_Act_Goal_OrderingProviderID: [dbo].[Person].OrderingProviderID](../../../../Images/fk.png) | OrderingProviderID | [dbo].[uniqueid] | 9 | NOT NULL | Ordering Provider. Link to Person.ID |
| OrderingProviderName | [dbo].[name] | 255 | NOT NULL | Name of the Ordering provider |
 ![Foreign Keys FK_Act_Goal_PatientID: [dbo].[Patient_Member].PatientID Foreign Keys FK_Act_Goal_PatientID: [dbo].[Patient_Member].PatientID](../../../../Images/fk.png) | PatientID | numeric(16,0) | 9 | NOT NULL | Patient. Link to Person.ID |
| ActivityType | varchar(10) | 10 | NULL allowed | Activity Type GL for Goal |