Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.EncounterPortalInstruction
Touchworks 25.2
[dbo].[EncounterPortalInstruction]
MS_Description
Patient portal opt-in instructions that have been provided to patient for every encounter.
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Description
ID
[dbo].[uniqueid]
9
NOT NULL
1 - 1
Key to the EncounterPortalInstruction table
EncounterID
[dbo].[uniqueid]
9
NOT NULL
Encounter. Link to Encounter.ID.
PortalInstructionStatusID
[dbo].[dict_id]
5
NOT NULL
Portal Instruction Status. Link to Portal_Registration_Stauts_DE.ID. It will have only two status info provided or info not provided.
InstructionDTTM
datetime
8
NOT NULL
Idate&time values when user selected the portal access instruction for the patient.
ModifiedByID
[dbo].[uniqueid]
9
NOT NULL
Logged in user. Link to IDX_User.ID.
ModifiedDTTM
datetime
8
NOT NULL
Modified date&time for selected portal access instruction.