Tables [dbo].[Case_Registry_Details]
Case registry details
Note: SubmittingFor value for either problem/order/result will be stored in RegistryHeader table
Note: ReportConfidentiality value will be stored in RegisterHeader table
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDescription
Cluster Primary Key PK_Case_Registry_Details_ID: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Case_Registry_Details table.
Indexes NIX_Case_Registry_Details_RegistryHeaderID_ItemTypeForeign Keys FK_Case_Registry_Details_RegistryHeaderID: [dbo].[RegistryHeader].RegistryHeaderIDRegistryHeaderID[dbo].[dict_id]5NOT NULLRegistry header. Link to RegistryHeader.ID.
StartDatedatetime8NULL allowedStart date
EndDatedatetime8NULL allowedEnd date
Indexes NIX_Case_Registry_Details_RegistryHeaderID_ItemTypeSubmittingProviderByID[dbo].[uniqueid]9NOT NULLSubmitting provider. Link to Provider.ID.
Indexes NIX_Case_Registry_Details_RegistryHeaderID_ItemTypeItemTypevarchar(10)10NULL allowedItem type I,e either  Problem/Order/OrdResult
If problem is selected – store as Problem
If Order is selected – store as Order
If Result is selected – store as OrdResult ( as Results are associated with orders )
RFVCommentsvarchar(7000)7000NULL allowedReason for visit
HPIDetailsvarchar(7000)7000NULL allowedHistory of present Illness
IsPatientPregnantvarchar(3)3NULL allowedIf Patient pregnant
ExpectedDeliveryDTTMdatetime8NULL allowedExpected delivery date time
DischargeDisposition[dbo].[dict_id]5NOT NULLDischarge disposition. Link to Discharge_Disposition_DE.ID.
DispositionDTTMdatetime8NULL allowedDisposition date time
TravelHistoryvarchar(max)maxNULL allowedFreetext Travel History
ReasonForManualRptvarchar(100)100NULL allowedReason for Manual generation of the report
SpecifyReasonvarchar(7000)7000NULL allowedReason for manual generation
Foreign Keys FK_Case_Registry_Details_ItemFindingID: [dbo].[Item_Finding].ItemFindingIDItemFindingID[dbo].[uniqueid]9NULL allowedPregnancy status finding. Link to Item_Finding.ID