Refers 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
ResultStageDE
[dbo].[dict_id]
5
NOT NULL
Result Stage. Link to Result_Status_DE.ID
IsAbnormalXFLAG
char(1)
1
NOT NULL
Indicates whether the Result has an Abnormal Flag or not. Y inidcates an Abnormal FLAG
AccessionNumber
varchar(255)
255
NOT NULL
Assession Number
ClinicalDTTM
datetime
8
NOT NULL
Clinical Date and Time of the Result
WherePerformedDE
[dbo].[dict_id]
5
NOT NULL
Where the result was performed. Link to Where_Performed_DE.ID
AckByProviderID
[dbo].[uniqueid]
9
NOT NULL
Provider ID who Acknowledged the result. Link to Provider.ID
PerformingProviderID
[dbo].[uniqueid]
9
NOT NULL
Performing Provider. Link to Provider.ID
PerformedDTTM
datetime
8
NOT NULL
Date and Time on which the results were Performed
VerificationRequiredFLAG
[dbo].[BOOL]
1
NOT NULL
Is verification required (Y/N)
NakByProviderID
[dbo].[uniqueid]
9
NOT NULL
Provider who rejected the result. Link to Provider.ID
ClinicalSourceDE
[dbo].[dict_id]
5
NOT NULL
Clinical Source. Link to Source_DE.ID
ActPerformingComment
varchar(max)
max
NULL allowed
Activity level performing comment. displayed in the 'Comments From Performing Location' in the Order Detail window while Entering Result
BillingProviderID
[dbo].[uniqueid]
9
NOT NULL
Billing Provider. Link to Provider.ID
BillingLocationDE
[dbo].[dict_id]
5
NOT NULL
Billing Location. Link to Billing_Location_DE.ID
ResultCommunicationDEList
varchar(255)
255
NOT NULL
('')
List of communication methods to the patient for the results. Links to Result_Communication_DE.ID
ActivityHeaderID
[dbo].[uniqueid]
9
NOT NULL
((0))
Activity Header. Link to Act_Hdr_Result.ID
NeedsReviewFLAG
[dbo].[BOOL]
1
NOT NULL
('N')
Review required (Y/N)
ReviewedByUserID
[dbo].[uniqueid]
9
NOT NULL
((0))
User who reviewed. Link to IDX_User.ID
ReviewedDTTM
datetime
8
NULL allowed
Reviewed Date and time
ImageAccessibleFLAG
[dbo].[BOOL]
1
NULL allowed
Is the Image Accessible for MU Reporting (Y/N)
IsResultFromInterfaceFLAG
[dbo].[BOOL]
1
NULL allowed
Was the result was filed from Interface (Y/N)
ArchiveState
tinyint
1
NOT NULL
((0))
0 = Record is in Main Partition 1 = record is in Archived Partition