Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
PracPerson
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| PracticeID | INTEGER | ? | MANDATORY | FK |
| PersonID | INTEGER | ? | MANDATORY | FK |
| DNLastName | CHAR(35) | OPTIONAL | Denormalized for performance reasons from the Person table. Do not write to this field. The person write triggers will keep field up-to-date. | |
| DNFirstName | CHAR(35) | OPTIONAL | Denormalized for performance reasons from the Person table. Do not write to this field. The person write triggers will keep field up-to-date. | |
| DNMiddleName | CHAR(35) | OPTIONAL | Denormalized for performance reasons from the Person table. Do not write to this field. The person write triggers will keep field up-to-date. | |
| DNNameSuffix | CHARACTER(20) | OPTIONAL | Denormalized for performance reasons from the Person table. Do not write to this field. The person write triggers will keep field up-to-date. | |
| DNSSN | CHARACTER(11) | OPTIONAL | Denormalized for performance reasons from the Person table. Do not write to this field. The person write triggers will keep field up-to-date. | |
| DNDOB | DATE | OPTIONAL | Denormalized for performance reasons from the Person table. Do not write to this field. The person write triggers will keep field up-to-date. | |
| DNHomePhone | CHARACTER(20) | OPTIONAL | Denormalized for performance reasons from the Person table. Do not write to this field. The person write triggers will keep field up-to-date. | |
| DNPersonNumber | CHARACTER(14) | OPTIONAL | Denormalized for performance reasons from the Person table. Do not write to this field. The person write triggers will keep field up-to-date. | |
| DNSortPersonNumber | CHARACTER(14) | OPTIONAL | Denormalized for performance reasons from the Person table. Do not write to this field. The person write triggers will keep field up-to-date. | |
| DNHomeZip | CHARACTER(10) | OPTIONAL | Denormalized for performance reasons from the Person table. Do not write to this field. The person write triggers will keep field up-to-date. | |
| 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. |
| PracPortalPersonID | CHARACTER(40) | OPTIONAL | System entered GUID for Practice Portal External Person ID. | |
| SecureMessagingEnabled | LOGICAL | Logical_False | OPTIONAL | If the practice is using Practice Portal (Kryptiq) this field indicates whether or not Secure Messaging is enabled for the Person. |
| PortalInvitationStatus | CHAR(2) | OPTIONAL | Person's Portal invitation status as defined in by LookupType 'PortalInvitationStatus'. | |
| DNMobilePhone | CHARACTER(20) | OPTIONAL | Denormalized for performance reasons from the Person table. Do not write to this field. The person write triggers will keep field up-to-date. | |
| ApplicationAccessToken | CHAR(36) | Set_To_Empty_String | OPTIONAL | Unique identifier for Patient Application Access |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| Person | PracPerson.PersonID = Person.PersonID | CASCADE if PracPerson exists |
| Practice | PracPerson.PracticeID = Practice.PracticeID | CASCADE if PracPerson exists |
| Child Table | Join Phrase | When deleting PracPerson record... |
|---|---|---|
| PracPersonName | PracPersonName.PracticeID = PracPerson.PracticeID and PracPersonName.PersonID = PracPerson.PersonID |
CASCADE if PracPersonName exists |
| PracPersonSecureMessage | PracPersonSecureMessage.PracticeID = PracPerson.PracticeID and PracPersonSecureMessage.PersonID = PracPerson.PersonID |
CASCADE if PracPersonSecureMessage exists |