Tables [dbo].[HCS_Registry_Details]
HCS (Health Care Survey) registry details
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDescription
Cluster Primary Key PK_HCS_Registry_Details_ID: IDID[dbo].[dict_id]5NOT NULL1 - 1Ket to the HCS_Registry_Details table
Indexes NIX_HCS_Registry_Details_RegistryHeaderIDForeign Keys FK_HCS_Registry_Details_RegistryHeaderID: [dbo].[RegistryHeader].RegistryHeaderIDRegistryHeaderID[dbo].[dict_id]5NOT NULLHeader. Link to RegistryHeader.ID
Indexes NIX_HCS_Registry_Details_RegistryHeaderIDSubmittingProviderByID[dbo].[uniqueid]9NOT NULLSubmitting provider. Link to Person.ID
ClinicalTypeLocationint4NULL allowedStore clinical type location
MajorRFVint4NULL allowedMajor reason for visit
RFVCommentsvarchar(7000)7000NULL allowedReason for visit comments
IsPatientAsthamavarchar(3)3NULL allowedIf Patient asthmatic
AsthmaSeverityint4NULL allowedAsthma Severity
AsthmaConditionControlint4NULL allowedAsthma Condition Control
IsPatientPregnantvarchar(3)3NULL allowedIs patient is pregnant
ExpectedDeliveryDTTMdatetime8NULL allowedExpected delivery date time
IsInitialVisitFollowUpint4NULL allowedInitial visit or follow-up
IsPatientReferralVisitvarchar(3)3NULL allowedReferred for visit
IsNewPatientvarchar(3)3NULL allowedPatient seen before
PrevVisitCountint4NULL allowedPrevious visit count
TimeWithProvidervarchar(100)100NULL allowedTime spent with provider
IsPatientPrevSurgeryvarchar(3)3NULL allowedHas Patient undergone surgery previously
SurgeryFollowUpvarchar(10)10NULL allowedSurgery follow up
FollowUpAttemptOutcomeint4NULL allowedFollow -up attempt outcome
DispositionOPDint4NULL allowedDischarge disposition
DispositionDTTMdatetime8NULL allowedDisposition date time