Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.HCS_Registry_Details
Touchworks 25.2
[dbo].[HCS_Registry_Details]
MS_Description
HCS (Health Care Survey) registry details
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Description
ID
[dbo].[dict_id]
5
NOT NULL
1 - 1
Ket to the HCS_Registry_Details table
RegistryHeaderID
[dbo].[dict_id]
5
NOT NULL
Header. Link to RegistryHeader.ID
SubmittingProviderByID
[dbo].[uniqueid]
9
NOT NULL
Submitting provider. Link to Person.ID
ClinicalTypeLocation
int
4
NULL allowed
Store clinical type location
MajorRFV
int
4
NULL allowed
Major reason for visit
RFVComments
varchar(7000)
7000
NULL allowed
Reason for visit comments
IsPatientAsthama
varchar(3)
3
NULL allowed
If Patient asthmatic
AsthmaSeverity
int
4
NULL allowed
Asthma Severity
AsthmaConditionControl
int
4
NULL allowed
Asthma Condition Control
IsPatientPregnant
varchar(3)
3
NULL allowed
Is patient is pregnant
ExpectedDeliveryDTTM
datetime
8
NULL allowed
Expected delivery date time
IsInitialVisitFollowUp
int
4
NULL allowed
Initial visit or follow-up
IsPatientReferralVisit
varchar(3)
3
NULL allowed
Referred for visit
IsNewPatient
varchar(3)
3
NULL allowed
Patient seen before
PrevVisitCount
int
4
NULL allowed
Previous visit count
TimeWithProvider
varchar(100)
100
NULL allowed
Time spent with provider
IsPatientPrevSurgery
varchar(3)
3
NULL allowed
Has Patient undergone surgery previously
SurgeryFollowUp
varchar(10)
10
NULL allowed
Surgery follow up
FollowUpAttemptOutcome
int
4
NULL allowed
Follow -up attempt outcome
DispositionOPD
int
4
NULL allowed
Discharge disposition
DispositionDTTM
datetime
8
NULL allowed
Disposition date time