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

Intergy Version: 22.00.00.00

RxExtMessage

Table Definition  Parent Tables  Child Tables

Table Definition

Description: Create new table to support Patient Medication History, Eligibility etc from external sources

Field Datatype Default Null Option Comment
RxExtMessageSID INTEGER ?   MANDATORY PK. Uses sequence for RxExtMessage.
MessageType CHARACTER(6) Set_To_Empty_String   MANDATORY The type of outbound request as defined by the RxExtMessage lookupType.
Version CHAR(10)   OPTIONAL Outbound message version. For example 10.6
Request CLOB   OPTIONAL Raw message data sent to source. This field is used as of version 10.6.
Response CLOB   OPTIONAL Raw message data received from source. This field is used as of version 10.6
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.

Parent Tables
Parent TableJoin PhraseWhen deleting parent record...

Child Tables
Child TableJoin PhraseWhen deleting RxExtMessage record...
RxEligMedHistRequest RxEligMedHistRequest.RxExtMessageSID = RxExtMessage.RxExtMessageSID CASCADE if RxEligMedHistRequest exists
RxEligRequest RxEligRequest.RxExtMessageSID = RxExtMessage.RxExtMessageSID CASCADE if RxEligRequest exists