Key | Name | Data Type | Max Length (Bytes) | Nullability | Description |
---|
  | ID | [dbo].[uniqueid] | 9 | NOT NULL | Key to the Act_Hdr_Result table |
 (10)![Foreign Keys FK_Act_Hdr_Result_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID Foreign Keys FK_Act_Hdr_Result_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID](../../../../Images/fk.png) | PatientID | [dbo].[uniqueid] | 9 | NOT NULL | Patient. Link to Patient_Member.ID. |
 | VisitID | [dbo].[uniqueid] | 9 | NOT NULL | Visit Link to Visit.ID. |
(3) | CurrentID | numeric(16,0) | 9 | NOT NULL | Current activity row. Link to the current row in Act_Result.ID |
| DocFolderID | numeric(16,0) | 9 | NOT NULL | This is set to 0 by default. Not used for Results. |
 | CreateDTTM | datetime | 8 | NOT NULL | Date entry was added. |
 | LastUpdateDTTM | datetime | 8 | NOT NULL | Date entry was last modified. |
![Check Constraints CK_Act_Hdr_Result_HasSecurityFLAG_Yes_Or_No : ([HasSecurityFLAG]='N' OR [HasSecurityFLAG]='Y') Check Constraints CK_Act_Hdr_Result_HasSecurityFLAG_Yes_Or_No : ([HasSecurityFLAG]='N' OR [HasSecurityFLAG]='Y')](../../../../Images/c-constraint.png) | HasSecurityFLAG | [dbo].[BOOL] | 1 | NOT NULL | Security indicator (no longer used). Y/N. |
![Check Constraints CK_Act_Hdr_Result_IsCorrectedFLAG_Yes_Or_No : ([IsCorrectedFLAG]='N' OR [IsCorrectedFLAG]='Y') Check Constraints CK_Act_Hdr_Result_IsCorrectedFLAG_Yes_Or_No : ([IsCorrectedFLAG]='N' OR [IsCorrectedFLAG]='Y')](../../../../Images/c-constraint.png) | IsCorrectedFLAG | [dbo].[BOOL] | 1 | NOT NULL | Corrected Indicator (no longer used). Y/N. |
![Check Constraints CK_Act_Hdr_Result_HasAnnotationFLAG_Yes_Or_No : ([HasAnnotationFLAG]='N' OR [HasAnnotationFLAG]='Y') Check Constraints CK_Act_Hdr_Result_HasAnnotationFLAG_Yes_Or_No : ([HasAnnotationFLAG]='N' OR [HasAnnotationFLAG]='Y')](../../../../Images/c-constraint.png) | HasAnnotationFLAG | [dbo].[BOOL] | 1 | NOT NULL | Set to 'Y' if the activity has an annotation else set to 'N'. Y/N. |
![Check Constraints CK_Act_Hdr_Result_SignatureRequiredFLAG_Yes_Or_No : ([SignatureRequiredFLAG]='N' OR [SignatureRequiredFLAG]='Y') Check Constraints CK_Act_Hdr_Result_SignatureRequiredFLAG_Yes_Or_No : ([SignatureRequiredFLAG]='N' OR [SignatureRequiredFLAG]='Y')](../../../../Images/c-constraint.png) | SignatureRequiredFLAG | [dbo].[BOOL] | 1 | NOT NULL | Indicates whether signature is required or not. Y/N. Always N. |
(2)![Check Constraints CK_Act_Hdr_Result_AcknowledgementReqFLAG_Yes_Or_No : ([AcknowledgementReqFLAG]='N' OR [AcknowledgementReqFLAG]='Y') Check Constraints CK_Act_Hdr_Result_AcknowledgementReqFLAG_Yes_Or_No : ([AcknowledgementReqFLAG]='N' OR [AcknowledgementReqFLAG]='Y')](../../../../Images/c-constraint.png) | AcknowledgementReqFLAG | [dbo].[BOOL] | 1 | NOT NULL | Indicates whether acknowledgement is required or not. Y/N. |
 | SignedByProviderID | [dbo].[uniqueid] | 9 | NOT NULL | Signed By Provider. Link to Provider.ID. Always 0. |
(2) | AckByProviderID | [dbo].[uniqueid] | 9 | NOT NULL | Provider who acknowledged. Link to Provider.ID. |
(2) | NakByProviderID | [dbo].[uniqueid] | 9 | NOT NULL | Provider who rejected. Link to Provider.ID. |
(2)![Check Constraints CK_Act_Hdr_Result_ActivityType : ([ActivityType]='RI') Check Constraints CK_Act_Hdr_Result_ActivityType : ([ActivityType]='RI')](../../../../Images/c-constraint.png) | ActivityType | char(10) | 10 | NOT NULL | RI (Result) |
(3) | EncounterID | [dbo].[uniqueid] | 9 | NOT NULL | Encounter. Link to Encounter.ID. |
(2)![Check Constraints CK_Act_Hdr_Result_ResultStage_Result_Stage : ([ResultStage]='' OR [ResultStage]='C' OR [ResultStage]='A' OR [ResultStage]='F' OR [ResultStage]='I' OR [ResultStage]='P') Check Constraints CK_Act_Hdr_Result_ResultStage_Result_Stage : ([ResultStage]='' OR [ResultStage]='C' OR [ResultStage]='A' OR [ResultStage]='F' OR [ResultStage]='I' OR [ResultStage]='P')](../../../../Images/c-constraint.png) | ResultStage | char(2) | 2 | NOT NULL | Stage: Valid values: ' ' = 'C' =Complete 'A' =Ammended 'F' =Final 'I' =Preliminary 'P' =Pending |
| ParentID | [dbo].[uniqueid] | 9 | NOT NULL | Parent identifier (no longer used). |
(3) | QOClassificationDE | [dbo].[dict_id] | 5 | NOT NULL | Orderable Item. Link to QO_Classification_DE.ID. |
![Check Constraints CK_Act_Hdr_Result_HasProblemFLAG_Yes_Or_No : ([HasProblemFLAG]='N' OR [HasProblemFLAG]='Y') Check Constraints CK_Act_Hdr_Result_HasProblemFLAG_Yes_Or_No : ([HasProblemFLAG]='N' OR [HasProblemFLAG]='Y')](../../../../Images/c-constraint.png) | HasProblemFLAG | [dbo].[BOOL] | 1 | NOT NULL | Problem Indicator (no longer used). Y/N. |
| ActivityTypeDE | [dbo].[dict_id] | 5 | NOT NULL | Activity Type. Link to Activity_Type_DE.ID |
| FormDE | [dbo].[dict_id] | 5 | NOT NULL | Form (no longer used). Link to Form_DE.ID. |
![Check Constraints CK_Act_Hdr_Result_CompletionStatus_Note_Completion_Status : ([CompletionStatus]='CompAmend' OR [CompletionStatus]='Ammended' OR [CompletionStatus]='Complete' OR [CompletionStatus]='Incomplete') Check Constraints CK_Act_Hdr_Result_CompletionStatus_Note_Completion_Status : ([CompletionStatus]='CompAmend' OR [CompletionStatus]='Ammended' OR [CompletionStatus]='Complete' OR [CompletionStatus]='Incomplete')](../../../../Images/c-constraint.png) | CompletionStatus | char(10) | 10 | NOT NULL | Status Valid values: 'CompAmend' 'Ammended' 'Complete' 'Incomplete' |
 | CMSVersion | smallint | 2 | NOT NULL | CMS Version. Currently 4. |