Key | Name | Data Type | Max Length (Bytes) | Nullability | Description |
---|
 | ID | [dbo].[uniqueid] | 9 | NOT NULL | Key to the Act_Hdr_Goal table |
 ![Foreign Keys FK_Act_HDR_Goal_PatientID: [dbo].[Patient_Member].PatientID Foreign Keys FK_Act_HDR_Goal_PatientID: [dbo].[Patient_Member].PatientID](../../../../Images/fk.png) | PatientID | [dbo].[uniqueid] | 9 | NOT NULL | Patient. Link to Person.ID |
 ![Foreign Keys FK_Act_HDR_Goal_VisitID: [dbo].[Visit].VisitID Foreign Keys FK_Act_HDR_Goal_VisitID: [dbo].[Visit].VisitID](../../../../Images/fk.png) | VisitID | [dbo].[uniqueid] | 9 | NOT NULL | Visit. Link to Visit.ID. |
 | CurrentID | numeric(16,0) | 9 | NOT NULL | Current Activity. Link to Act_Goal.ID. |
| DocFolderID | numeric(16,0) | 9 | NOT NULL | Not used. Always 0. |
| CreateDTTM | datetime | 8 | NOT NULL | Date entry was added. |
| LastUpdateDTTM | datetime | 8 | NOT NULL | Date entry was last modified. |
![Check Constraints CK_Act_Hdr_Goal_HasSecurityFLAG_Yes_Or_No : ([HasSecurityFLAG]='N' OR [HasSecurityFLAG]='Y') Check Constraints CK_Act_Hdr_Goal_HasSecurityFLAG_Yes_Or_No : ([HasSecurityFLAG]='N' OR [HasSecurityFLAG]='Y')](../../../../Images/c-constraint.png) | HasSecurityFLAG | [dbo].[BOOL] | 1 | NOT NULL | No longer used. Always N. |
![Check Constraints CK_Act_Hdr_Goal_IsCorrectedFLAG_Yes_Or_No : ([IsCorrectedFLAG]='N' OR [IsCorrectedFLAG]='Y') Check Constraints CK_Act_Hdr_Goal_IsCorrectedFLAG_Yes_Or_No : ([IsCorrectedFLAG]='N' OR [IsCorrectedFLAG]='Y')](../../../../Images/c-constraint.png) | IsCorrectedFLAG | [dbo].[BOOL] | 1 | NOT NULL | No Longer Used. Always N. |
![Check Constraints CK_Act_Hdr_Goal_HasAnnotationFLAG_Yes_Or_No : ([HasAnnotationFLAG]='N' OR [HasAnnotationFLAG]='Y') Check Constraints CK_Act_Hdr_Goal_HasAnnotationFLAG_Yes_Or_No : ([HasAnnotationFLAG]='N' OR [HasAnnotationFLAG]='Y')](../../../../Images/c-constraint.png) | HasAnnotationFLAG | [dbo].[BOOL] | 1 | NOT NULL | Is there an Annotation? (Y/N) |
![Check Constraints CK_Act_Hdr_Goal_SignatureRequiredFLAG_Yes_Or_No : ([SignatureRequiredFLAG]='N' OR [SignatureRequiredFLAG]='Y') Check Constraints CK_Act_Hdr_Goal_SignatureRequiredFLAG_Yes_Or_No : ([SignatureRequiredFLAG]='N' OR [SignatureRequiredFLAG]='Y')](../../../../Images/c-constraint.png) | SignatureRequiredFLAG | [dbo].[BOOL] | 1 | NOT NULL | Determines whether a signature is required or not. Always N |
![Check Constraints CK_Act_Hdr_Goal_AcknowledgementReqFLAG_Yes_Or_No : ([AcknowledgementReqFLAG]='N' OR [AcknowledgementReqFLAG]='Y') Check Constraints CK_Act_Hdr_Goal_AcknowledgementReqFLAG_Yes_Or_No : ([AcknowledgementReqFLAG]='N' OR [AcknowledgementReqFLAG]='Y')](../../../../Images/c-constraint.png) | AcknowledgementReqFLAG | [dbo].[BOOL] | 1 | NOT NULL | Determines whether acknowledgement is required or not. Always N |
| SignedByProviderID | [dbo].[uniqueid] | 9 | NOT NULL | Signing Provider. Link to Provider.ID. |
| AckByProviderID | [dbo].[uniqueid] | 9 | NOT NULL | Acknowlegeing Provider. Link to Provider.ID. Always 0. |
| NakByProviderID | [dbo].[uniqueid] | 9 | NOT NULL | Rejecting Provider. Link to Provider.ID. Always 0 |
| ActivityType | char(10) | 10 | NOT NULL | GL - Goal |
 ![Foreign Keys FK_Act_HDR_Goal_EncounterID: [dbo].[Encounter].EncounterID Foreign Keys FK_Act_HDR_Goal_EncounterID: [dbo].[Encounter].EncounterID](../../../../Images/fk.png) | EncounterID | [dbo].[uniqueid] | 9 | NOT NULL | Encounter. Link to Encounter.ID |
| ResultStage | char(2) | 2 | NOT NULL | Result Stage. F - Final for goals |
| ParentID | [dbo].[uniqueid] | 9 | NOT NULL | Not Used. Always 0. |
| QOClassificationDE | [dbo].[dict_id] | 5 | NOT NULL | Orderable Item. Link to QO_Classification_DE.ID. Always 0. |
![Check Constraints CK_Act_Hdr_Goal_HasProblemFLAG_Yes_Or_No : ([HasProblemFLAG]='N' OR [HasProblemFLAG]='Y') Check Constraints CK_Act_Hdr_Goal_HasProblemFLAG_Yes_Or_No : ([HasProblemFLAG]='N' OR [HasProblemFLAG]='Y')](../../../../Images/c-constraint.png) | HasProblemFLAG | [dbo].[BOOL] | 1 | NOT NULL | Has a linked Problem (Y/N). Always N. |
| ActivityTypeDE | [dbo].[dict_id] | 5 | NOT NULL | Activity Type. Link to Activity_Type_DE.ID. Always 0. |
| FormDE | [dbo].[dict_id] | 5 | NOT NULL | Form. Link to Form_DE.ID, Always 0. |
| CompletionStatus | char(10) | 10 | NOT NULL | Status of Goal. 'Complete' |
| CMSVersion | smallint | 2 | NOT NULL | Clinical Management System Version. Currently 4. |