Last Updated: 7/22/2025 8:42:49 PM

Intergy Version: 22.00.00.00

PatientPortalAccess

Table Definition  Parent Tables  Child Tables

Table Definition

Description: This table stores the access status of a person on the patient portal.

Field Datatype Default Null Option Comment
PatientPortalAccessSID INTEGER ?   MANDATORY System generated unique id using PatientPortal sequence.
PersonRelationshipSID INTEGER ?   MANDATORY System generated unique id using PatientPortal sequence.
TimeStamp CHARACTER(14)   OPTIONAL System generated date/time stamp record was last written.
LastUser INTEGER ?   OPTIONAL User ID of user that last wrote the record.
CreateStamp CHARACTER(14)   OPTIONAL System generated date/time stamp record was created.
CreateUser INTEGER ?   OPTIONAL User ID of user that created the record.
AccessGranted LOGICAL   OPTIONAL Person Relationship's access status. Whether or not Person should be able to see RelatedPerson
PracticeID INTEGER ?   MANDATORY FK

Parent Tables
Parent TableJoin PhraseWhen deleting parent record...
Practice PatientPortalAccess.PracticeID = Practice.PracticeID CASCADE if PatientPortalAccess exists
PersonRelationship PatientPortalAccess.PersonRelationshipSID = PersonRelationship.PersonRelationshipSID CASCADE if PatientPortalAccess exists

Child Tables
Child TableJoin PhraseWhen deleting PatientPortalAccess record...