Tables [dbo].[EncounterPortalInstruction]
Patient portal opt-in instructions that have been provided to patient for every encounter.
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDescription
Cluster Primary Key PK_EncounterPortalInstruction_ID: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the EncounterPortalInstruction table
Indexes NIX_EncounterPortalInstruction_EncounterIDForeign Keys FK_EncounterPortalInstruction_EncounterID: [dbo].[Encounter].EncounterIDEncounterID[dbo].[uniqueid]9NOT NULLEncounter. Link to Encounter.ID.
Foreign Keys FK_EncounterPortalInstruction_PortalInstructionStatusID: [dbo].[Portal_Registration_Status_DE].PortalInstructionStatusIDPortalInstructionStatusID[dbo].[dict_id]5NOT NULLPortal Instruction Status. Link to Portal_Registration_Stauts_DE.ID. It will have only two status info provided or info not provided.
InstructionDTTMdatetime8NOT NULLIdate&time values when user selected the portal access instruction for the patient.
Foreign Keys FK_EncounterPortalInstruction_ModifiedByID: [dbo].[IDX_User].ModifiedByIDModifiedByID[dbo].[uniqueid]9NOT NULLLogged in user. Link to IDX_User.ID.
ModifiedDTTMdatetime8NOT NULLModified date&time for selected portal access instruction.