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
Item 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 )
RFVComments
varchar(7000)
7000
NULL allowed
Reason for visit
HPIDetails
varchar(7000)
7000
NULL allowed
History of present Illness
IsPatientPregnant
varchar(3)
3
NULL allowed
If Patient pregnant
ExpectedDeliveryDTTM
datetime
8
NULL allowed
Expected delivery date time
DischargeDisposition
[dbo].[dict_id]
5
NOT NULL
Discharge disposition. Link to Discharge_Disposition_DE.ID.