Tables [dbo].[Intervention_ActionTaken]
Capture events (or) action taken on various intervention types (AUC, CareGuide, POCR and Normative GrowthChart)
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_Intervention_ActionTaken: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Intervention_ActionTaken table
Indexes NIX_Intervention_ActionTaken_InterventionTypeDEForeign Keys FK_Intervention_ActionTaken_InterventionTypeDE: [dbo].[Intervention_Type_DE].InterventionTypeDEInterventionTypeDE[dbo].[dict_id]5NOT NULLType. Link to Intervention_Type_DE.ID
Interventionvarchar(1000)1000NOT NULLIntervention Name on which the actions were performed
ActionTakenvarchar(max)maxNOT NULLType of Action Taken on Intervention by user
ActionDetailvarchar(max)maxNULL allowedAdditional details regarding ActionTaken
ActionTakenDTTMdatetime8NOT NULLDate and time when action taken by user on Intervention
Indexes NIX_Intervention_ActionTaken_UserIDForeign Keys FK_Intervention_ActionTaken_UserID: [dbo].[IDX_User].UserIDUserID[dbo].[uniqueid]9NOT NULLUser. Link to IDX_User.ID
Indexes NIX_Intervention_ActionTaken_SiteDEForeign Keys FK_Intervention_ActionTaken_SiteDE: [dbo].[Site_DE].SiteDESiteDE[dbo].[dict_id]5NOT NULLSite. Link to Site_DE.ID
Indexes NIX_Intervention_ActionTaken_CreatedDTTMCreatedDTTMdatetime8NOT NULL(getdate())Date/Time Record was Created