Tables [dbo].[ECR_Reportability_Response_Details]
Individual data elements present in the eCR Reportability Response XML
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_dbo.ECR_Reportability_Response_Details: IDIDbigint8NOT NULL1 - 1Key to the ECR_Reportability_Response_Details table
Indexes NIX_ECR_Reportability_Response_Details_PatientIDForeign Keys FK_ECR_Reportability_Response_Details_PatientID: [dbo].[Person].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Link to Person.ID
SubmittingProviderID[dbo].[uniqueid]9NOT NULLSubmitting Provider. Link to Person.ID
Foreign Keys FK_ECR_Reportability_Response_Details_ReportabilityPriorityID: [dbo].[ECR_Reportability_Priority_DE].ReportabilityPriorityIDReportabilityPriorityID[dbo].[dict_id]5NOT NULLPriority. Link to ECR_Reportability_Priority_DE.ID
Foreign Keys FK_ECR_Reportability_Response_Details_DetermineReportabilityID: [dbo].[ECR_Determine_Reportability_DE].DetermineReportabilityIDDetermineReportabilityID[dbo].[dict_id]5NOT NULLDetermine Reportability. Link to ECR_Determine_Reportability_DE.ID
Indexes NIX_ECR_Reportability_Response_Details_DocumentIDForeign Keys FK_ECR_Reportability_Response_Details_DocumentID: [dbo].[Document].DocumentIDDocumentID[dbo].[uniqueid]9NULL allowedDocument. Link to Document.DocumentID
CreatedDTTMdatetime8NOT NULL(getdate())Create time