Tables [dbo].[Problem_Link_Alert]
Problem Linkage Alerts
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Primary Key PK_Problem_Link_Alert_ID: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Problem_Link_Alert table
Cluster Key CIX_Problem_Link_Alert_ItemChildID_ItemType: ItemChildID\ItemTypeItemChildID[dbo].[uniqueid]9NOT NULLOrder instance
Cluster Key CIX_Problem_Link_Alert_ItemChildID_ItemType: ItemChildID\ItemTypeItemTypechar(2)2NOT NULLItem Type. PL - Order
OIDDE[dbo].[dict_id]5NOT NULLOrderable Item. Link to QO_Classification_DE.ID
Foreign Keys FK_Problem_Link_Alert_AlertTypeDE_Alert_Type_DE_ID: [dbo].[Alert_Type_DE].AlertTypeDEAlertTypeDE[dbo].[dict_id]5NOT NULLAlert Type. Link to Alert_Type_DE.ID
Indexes NIX_problem_link_alert_PatientIDForeign Keys FK_Problem_Link_Alert_PatientID_Person_ID: [dbo].[Person].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatietn. Link to Person.ID
Foreign Keys FK_Problem_Link_Alert_UserID_IDX_User_ID: [dbo].[IDX_User].UserIDUserID[dbo].[uniqueid]9NOT NULLUser. Link to IDX_User.ID
Indexes NIX_Problem_Link_Alert_EncounterID, TWstat_Problem_Link_Alert_EncounterID(2)Foreign Keys FK_Problem_Link_Alert_EncounterID_Encounter_ID: [dbo].[Encounter].EncounterIDEncounterID[dbo].[uniqueid]9NOT NULLEncounter. Link to Encounter.ID
AlertDTTMdatetime8NULL allowed(getdate())Alert time