Tables [dbo].[ePA_Transaction]
ePA (Electronic Prior Authorization) transactions including requests and responses between ESI and  Touchworks transactions, requests and responses between ESI and Touchworks
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDescription
Primary Key PK_ePA_Transaction_ID: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the ePA_Transaction table.
Indexes NIX_ePA_Transaction_ItemIDItemID[dbo].[uniqueid]9NOT NULLLink to the Item level table
ItemChildID[dbo].[uniqueid]9NOT NULLLink to the specific version of the order
Cluster Key CIX_ePA_Transaction_PatientID: PatientIDForeign Keys FK_ePA_Transaction_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Link to Person.ID.
TxnTypevarchar(255)255NOT NULLTransaction Type of the record (ex: PAInitiation; PAResponse; etc)
TxnDatavarchar(255)255NOT NULLThe actual action of the transaction (ex: Initiation Requested; Initiation Verified; etc)
UserID[dbo].[uniqueid]9NOT NULLUser Initiating transaction. Link to IDX_User.ID.
RecordedDTTMdatetime8NOT NULLOriginal Recorded time
LastUpdatedDTTMdatetime8NOT NULLLast Updated time
IsInbound[dbo].[BOOL]1NOT NULLIs this an inbound transaction (Y/N)?
Commentsvarchar(max)maxNOT NULLComments
MessageIDvarchar(50)50NULL allowedID of the message from the hub.
AuthNovarchar(50)50NULL allowedAuthorization Number
Indexes NIX_ePA_Transaction_TxnControlIDTxnControlIDvarchar(50)50NULL allowedLink to ID of the outgoing message from TW.
ExpirationDTTMdatetime8NULL allowedWhen would the transaction expire.
PANotevarchar(2000)2000NULL allowedAny notes we may receive from hub about PA
IsAttachmentInboundFLAG[dbo].[BOOL]1NOT NULLTo check if there are any attachments for inbound messages.