Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Description |
---|
 | ID | [dbo].[uniqueid] | 9 | NOT NULL | 1 - 1 | Key to the ePA_Transaction table. |
 | ItemID | [dbo].[uniqueid] | 9 | NOT NULL | | Link to the Item level table |
| ItemChildID | [dbo].[uniqueid] | 9 | NOT NULL | | Link to the specific version of the order |
 ![Foreign Keys FK_ePA_Transaction_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID Foreign Keys FK_ePA_Transaction_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID](../../../../Images/fk.png) | PatientID | [dbo].[uniqueid] | 9 | NOT NULL | | Patient. Link to Person.ID. |
| TxnType | varchar(255) | 255 | NOT NULL | | Transaction Type of the record (ex: PAInitiation; PAResponse; etc) |
| TxnData | varchar(255) | 255 | NOT NULL | | The actual action of the transaction (ex: Initiation Requested; Initiation Verified; etc) |
| UserID | [dbo].[uniqueid] | 9 | NOT NULL | | User Initiating transaction. Link to IDX_User.ID. |
| RecordedDTTM | datetime | 8 | NOT NULL | | Original Recorded time |
| LastUpdatedDTTM | datetime | 8 | NOT NULL | | Last Updated time |
| IsInbound | [dbo].[BOOL] | 1 | NOT NULL | | Is this an inbound transaction (Y/N)? |
| Comments | varchar(max) | max | NOT NULL | | Comments |
| MessageID | varchar(50) | 50 | NULL allowed | | ID of the message from the hub. |
| AuthNo | varchar(50) | 50 | NULL allowed | | Authorization Number |
 | TxnControlID | varchar(50) | 50 | NULL allowed | | Link to ID of the outgoing message from TW. |
| ExpirationDTTM | datetime | 8 | NULL allowed | | When would the transaction expire. |
| PANote | varchar(2000) | 2000 | NULL allowed | | Any notes we may receive from hub about PA |
| IsAttachmentInboundFLAG | [dbo].[BOOL] | 1 | NOT NULL | | To check if there are any attachments for inbound messages. |