Tables [dbo].[Act_Result_Extension]
Additional activity level versioned properties for Results
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Primary Key PK_Act_Result_Extension_ActResultID: ActResultIDCluster Key CIX_Act_Result_Extension_ActResultID_ArchiveState: ActResultID\ArchiveStateActResultID[dbo].[uniqueid]9NOT NULLActivity. Link to Act_Result.ID
ResultStagechar(2)2NOT NULLRefers to the Stage field in the Order Detail window while Entering Results. Possible values are "I"- Preliminary, "A" - Amended, "C"- Corrected, "F"-Final, "P"-Pending
Foreign Keys FK_Act_Result_Extension_Result_Status_DE: [dbo].[Result_Status_DE].ResultStageDEResultStageDE[dbo].[dict_id]5NOT NULLResult Stage. Link to Result_Status_DE.ID
IsAbnormalXFLAGchar(1)1NOT NULLIndicates whether the Result has an Abnormal Flag or not. Y inidcates an Abnormal FLAG
AccessionNumbervarchar(255)255NOT NULLAssession Number
ClinicalDTTMdatetime8NOT NULLClinical Date and Time of the Result
Foreign Keys FK_Act_Result_Extension_Where_Performed_DE: [dbo].[Where_Performed_DE].WherePerformedDEWherePerformedDE[dbo].[dict_id]5NOT NULLWhere the result was performed. Link to Where_Performed_DE.ID
AckByProviderID[dbo].[uniqueid]9NOT NULLProvider ID who Acknowledged the result. Link to Provider.ID
Indexes TWstat_Act_Result_Extension_PerformingProviderIDPerformingProviderID[dbo].[uniqueid]9NOT NULLPerforming Provider. Link to Provider.ID
PerformedDTTMdatetime8NOT NULLDate and Time on which the results were Performed
Check Constraints CK_Act_Result_Extension_VerificationRequiredFLAG_Yes_Or_No : ([VerificationRequiredFLAG]='N' OR [VerificationRequiredFLAG]='Y')VerificationRequiredFLAG[dbo].[BOOL]1NOT NULLIs verification required (Y/N)
NakByProviderID[dbo].[uniqueid]9NOT NULLProvider who rejected the result. Link to Provider.ID
ClinicalSourceDE[dbo].[dict_id]5NOT NULLClinical Source. Link to Source_DE.ID
ActPerformingCommentvarchar(max)maxNULL allowedActivity level performing comment. displayed in the 'Comments From Performing Location' in the Order Detail window while Entering Result
BillingProviderID[dbo].[uniqueid]9NOT NULLBilling Provider. Link to Provider.ID
Foreign Keys FK_Act_Result_Extension_Billing_Location_DE: [dbo].[Billing_Location_DE].BillingLocationDEBillingLocationDE[dbo].[dict_id]5NOT NULLBilling Location. Link to Billing_Location_DE.ID
ResultCommunicationDEListvarchar(255)255NOT NULL('')List of communication methods to the patient for the results. Links to Result_Communication_DE.ID
ActivityHeaderID[dbo].[uniqueid]9NOT NULL((0))Activity Header. Link to Act_Hdr_Result.ID
Check Constraints CK_Act_Result_Extension_NeedsReviewFLAG_Yes_Or_No : ([NeedsReviewFLAG]='N' OR [NeedsReviewFLAG]='Y')NeedsReviewFLAG[dbo].[BOOL]1NOT NULL('N')Review required (Y/N)
ReviewedByUserID[dbo].[uniqueid]9NOT NULL((0))User who reviewed. Link to IDX_User.ID
ReviewedDTTMdatetime8NULL allowedReviewed Date and time
Check Constraints CK_Act_Result_Extension_ImageAccessibleFLAG_Yes_Or_No : ([ImageAccessibleFLAG]='N' OR [ImageAccessibleFLAG]='Y')ImageAccessibleFLAG[dbo].[BOOL]1NULL allowedIs the Image Accessible for MU Reporting (Y/N)
Check Constraints CK_Act_Result_Extension_IsResultFromInterfaceFLAG_Yes_Or_No : ([IsResultFromInterfaceFLAG]='N' OR [IsResultFromInterfaceFLAG]='Y')IsResultFromInterfaceFLAG[dbo].[BOOL]1NULL allowedWas the result was filed from Interface (Y/N)
Cluster Key CIX_Act_Result_Extension_ActResultID_ArchiveState: ActResultID\ArchiveStateArchiveStatetinyint1NOT NULL((0))0 =  Record is in Main Partition
1 = record is in Archived Partition