Tables [dbo].[Encounter_CarePlan]
This holds the data about the Care Guide associated to an Encounter
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key PK_CIX_Encounter_CarePlan_EncounterID_CarePlanTemplateID: EncounterID\CarePlanTemplateIDCarePlanTemplateID[dbo].[dict_id]5NOT NULLCare Guide. Link to CarePlan_Template.ID
Indexes nix_Encounter_Careplan_PatientIDForeign Keys FK_Encounter_CarePlan_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Link to Person.ID
Indexes TWstat_Encounter_CarePlan_ProblemHeaderIDProblemHeaderID[dbo].[uniqueid]9NOT NULLProblem linking the Care Guide. Link to Problem_Header.ID
Cluster Primary Key PK_CIX_Encounter_CarePlan_EncounterID_CarePlanTemplateID: EncounterID\CarePlanTemplateIDEncounterID[dbo].[uniqueid]9NOT NULLEncounter. Link to Encounter.ID
Indexes TWstat_Encounter_CarePlan_UserIDUserID[dbo].[uniqueid]9NOT NULL(0)User. Link to IDX_User.ID
Indexes TWstat_Encounter_CarePlan_DisplayNameDisplayNamevarchar(255)255NOT NULL('')The Display Name associated to the care Plan Template