Tables [dbo].[Act_Hdr_Goal]
Activity Header Level table for Goals
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Primary Key PK_Act_Hdr_Goal_ID: IDID[dbo].[uniqueid]9NOT NULLKey to the Act_Hdr_Goal table
Cluster Key CIXAct_Hdr_Goal_PatID: PatientIDForeign Keys FK_Act_HDR_Goal_PatientID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Link to Person.ID
Indexes XAct_Hdr_Goal_VisIDForeign Keys FK_Act_HDR_Goal_VisitID: [dbo].[Visit].VisitIDVisitID[dbo].[uniqueid]9NOT NULLVisit. Link to Visit.ID.
Indexes XAct_Hdr_Goal_CurIDCurrentIDnumeric(16,0)9NOT NULLCurrent Activity. Link to Act_Goal.ID.
DocFolderIDnumeric(16,0)9NOT NULLNot used. Always 0.
CreateDTTMdatetime8NOT NULLDate entry was added.
LastUpdateDTTMdatetime8NOT NULLDate entry was last modified.
Check Constraints CK_Act_Hdr_Goal_HasSecurityFLAG_Yes_Or_No : ([HasSecurityFLAG]='N' OR [HasSecurityFLAG]='Y')HasSecurityFLAG[dbo].[BOOL]1NOT NULLNo longer used. Always N.
Check Constraints CK_Act_Hdr_Goal_IsCorrectedFLAG_Yes_Or_No : ([IsCorrectedFLAG]='N' OR [IsCorrectedFLAG]='Y')IsCorrectedFLAG[dbo].[BOOL]1NOT NULLNo Longer Used. Always N.
Check Constraints CK_Act_Hdr_Goal_HasAnnotationFLAG_Yes_Or_No : ([HasAnnotationFLAG]='N' OR [HasAnnotationFLAG]='Y')HasAnnotationFLAG[dbo].[BOOL]1NOT NULLIs there an Annotation? (Y/N)
Check Constraints CK_Act_Hdr_Goal_SignatureRequiredFLAG_Yes_Or_No : ([SignatureRequiredFLAG]='N' OR [SignatureRequiredFLAG]='Y')SignatureRequiredFLAG[dbo].[BOOL]1NOT NULLDetermines whether a signature is required or not. Always N
Check Constraints CK_Act_Hdr_Goal_AcknowledgementReqFLAG_Yes_Or_No : ([AcknowledgementReqFLAG]='N' OR [AcknowledgementReqFLAG]='Y')AcknowledgementReqFLAG[dbo].[BOOL]1NOT NULLDetermines whether acknowledgement is required or not. Always N
SignedByProviderID[dbo].[uniqueid]9NOT NULLSigning Provider. Link to Provider.ID.
AckByProviderID[dbo].[uniqueid]9NOT NULLAcknowlegeing Provider. Link to Provider.ID. Always 0.
NakByProviderID[dbo].[uniqueid]9NOT NULLRejecting Provider. Link to Provider.ID. Always 0
ActivityTypechar(10)10NOT NULLGL - Goal
Indexes XAct_Hdr_Goal_EncIDForeign Keys FK_Act_HDR_Goal_EncounterID: [dbo].[Encounter].EncounterIDEncounterID[dbo].[uniqueid]9NOT NULLEncounter. Link to Encounter.ID
ResultStagechar(2)2NOT NULLResult Stage. F - Final for goals
ParentID[dbo].[uniqueid]9NOT NULLNot Used. Always 0.
QOClassificationDE[dbo].[dict_id]5NOT NULLOrderable Item. Link to QO_Classification_DE.ID. Always 0.
Check Constraints CK_Act_Hdr_Goal_HasProblemFLAG_Yes_Or_No : ([HasProblemFLAG]='N' OR [HasProblemFLAG]='Y')HasProblemFLAG[dbo].[BOOL]1NOT NULLHas a linked Problem (Y/N). Always N.
ActivityTypeDE[dbo].[dict_id]5NOT NULLActivity Type. Link to Activity_Type_DE.ID. Always 0.
FormDE[dbo].[dict_id]5NOT NULLForm. Link to Form_DE.ID, Always 0.
CompletionStatuschar(10)10NOT NULLStatus of Goal. 'Complete'
CMSVersionsmallint2NOT NULLClinical Management System Version. Currently 4.