Tables [dbo].[Query]
Patient Query. This data is created in conjunction with the creation of Patient Access List scripts. The number at the end of the Query Name represents the ID in the Patient_List. The Query is also associated to Patient Alerts (Patient_Alert and Patient_Alert_Deferral). No Longer Used.
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDescription
Cluster Primary Key PK_Query_ID: IDIndexes TWstat_Query_Description_IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Query table
Namevarchar(60)60NOT NULLQuery Name
Indexes TWstat_Query_Description_IDDescriptionvarchar(255)255NOT NULLDescription for the Query
Foreign Keys FK_Query_IDXUserID_IDX_User_ID: [dbo].[IDX_User].IDXUserIDIDXUserID[dbo].[uniqueid]9NULL allowedUser. Link to IDX_User.ID
OrganizationID[dbo].[dict_id]5NOT NULLOrganization. Link to Organization.ID
Check Constraints CK_Query_HMAQueryFLAG_Yes_Or_No : ([HMAQueryFLAG]='N' OR [HMAQueryFLAG]='Y')HMAQueryFLAG[dbo].[BOOL]1NOT NULLHealth Maintmenace Alert (Y/N)?
AlertTextvarchar(100)100NOT NULLAlert Text