Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
PracPersonSecureMessage
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| PracPersonSecureMessageSID | INTEGER | ? | MANDATORY | System Generated using the PracticePortalQueue sequence. |
| PracticeID | INTEGER | ? | MANDATORY | FK - PracPerson, Staff |
| PersonID | INTEGER | ? | MANDATORY | FK - PracPerson |
| StaffID | INTEGER | ? | OPTIONAL | FK - From Staff |
| RecordStatus | CHARACTER(1) | MANDATORY | Valid values: V - void A - Active | |
| MessageDescription | CHARACTER(60) | MANDATORY | Subject line of message but note that the user could have edited it on a save | |
| MessageType | CHAR(40) | MANDATORY | System defined. Message Type to categorize message. Note - this is sent from the message source (ie Kryptiq). (e.g. AppointmentRequest) | |
| MessageCreateDateString | CHAR(33) | OPTIONAL | Message datetime stamp string from message source. Indicates when message was created. | |
| KryptiqMessageID | CHAR(256) | MANDATORY | Unique message ID from source. This should be globally unique. | |
| ToValue | CHARACTER(20) | OPTIONAL | Delimited list of email addresses | |
| FromValue | CHARACTER(20) | OPTIONAL | Email address of sender | |
| CCValue | CHARACTER(20) | OPTIONAL | Copy email address | |
| BCCValue | CHARACTER(20) | OPTIONAL | Blind copy email address | |
| InboundOutbound | CHARACTER(1) | MANDATORY | Valid Values: I - Inbound / O - Outbound Inbound means the source message was sent from the patient to provider Outbound means provider to patient. | |
| 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. |
| SecMsgDisplayInApp | CHARACTER(1) | Flag_-_Clinical | OPTIONAL | Application where secure message saved to chart can be viewed. Possible Values: 'C' - Clinical , 'O' - Other. When 'C', a secure message saved to chart can be viewed in IEHR but not Intergy. When 'O', it is viewed in Intergy and IEHR. |
| ExternalSourceID | CHARACTER(60) | Kryptiq | MANDATORY | External ID for source of secure message (e.g. 'Kryptiq') |
| IsPatientGeneratedHealthData | LOGICAL | Logical_False | OPTIONAL | Defines whether secure message health information is generated by Patient/Person from portal. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| Staff | PracPersonSecureMessage.PracticeID = Staff.PracticeID and PracPersonSecureMessage.StaffID = Staff.StaffID |
RESTRICT if PracPersonSecureMessage exists |
| PracPerson | PracPersonSecureMessage.PracticeID = PracPerson.PracticeID and PracPersonSecureMessage.PersonID = PracPerson.PersonID |
CASCADE if PracPersonSecureMessage exists |
| Child Table | Join Phrase | When deleting PracPersonSecureMessage record... |
|---|---|---|
| PatientOrderSetResult | PatientOrderSetResult.PracPersonSecureMessageSID = PracPersonSecureMessage.PracPersonSecureMessageSID | RESTRICT if PatientOrderSetResult exists |
| PracPersonSecureMsgBlob | PracPersonSecureMsgBlob.PracPersonSecureMessageSID = PracPersonSecureMessage.PracPersonSecureMessageSID | CASCADE if PracPersonSecureMsgBlob exists |