Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
NcpdpOutboundMessageOID | BIGINT | NOT NULL | Primary key for this table |
SoarianOutboundMessageType | VARCHAR(20) | NOT NULL | Indicates the type of outbound message(Renew: APPROV, CHANGE, DENIED, DNTFD, DNTFN; Change CHG_APPROV, CHG_CHANGE, CHG_DENY, CHG_DCN_DENY, CHG_DCN_CANRX, CHG_DCN_NEWRX; Cancel: CANRX; Other: NEWRX) |
NcpdpMessage | VARCHAR(MAX) | NOT NULL | NCPDP(National Council for Prescription Drug Programs) outbound message |
NcpdpMessageType | VARCHAR(6) | NULL | NCPDP(National Council for Prescription Drug Programs) outbound type in NCPDP terminology |
TransmissionSentDateTime | DATETIME | NOT NULL | Local time when the message was sent out by Soarian Clinicals |
TransmissionSequenceOID | BIGINT | NULL | Identifies sequences of one or more messages(a single NEWRX has one row with this oid; a DENY-CANCEL-NEW sequence has three) |
TransactionDurationMs | INT | NULL | Time(in milliseconds) it takes to send transaction to HDX(Healthcare Data Exchange) |
HdxOutboundTransactionId | VARCHAR(20) | NULL | Transaction id of this transmission via HDX(Healthcare Data Exchange) |
TransmissionStatus | VARCHAR(7) | NOT NULL | Transmission status of the outbound message(Sent in transit, Success received by ultimate receiver, Failed) |
TransmissionStatusCode | VARCHAR(20) | NULL | Last Status code from hdx or surescripts(HDX: HXERX000-HXERXnnn; surescripts 000, 010, 6xx, 900 STS status codes ) |
TransmissionStatusUpdateDateTime | DATETIME | NULL | Most recent time when system processed a status/error/verify message for this outbound message. |
TransmissionFailureInformation | VARCHAR(4000) | NULL | Descriptive errors from transmitting the message |
TransmittedDataFormat | VARCHAR(3) | NULL | NCPDP(National Council for Prescription Drug Programs) data format(xml, edi = edifact) |
SendingProviderSPI | VARCHAR(35) | NOT NULL | SPI Number(Surescripts Prescriber ID) for sending provider within ncpdp transaction. In proxy case, it will be original request provider spi |
StaffOID | INT | NOT NULL | ObjectId of staff who generated this outbound transaction |
StaffName | VARCHAR(187) | NOT NULL | Name of staff who generated this outbound transaction |
UserOID | INT | NOT NULL | ObjectId of user who generated this outbound transaction |
UserName | VARCHAR(12) | NOT NULL | Username of user who generated this outbound transaction |
EntityOID | INT | NULL | EnitiyOID of the user who produced this outbound transaction |
PatientOID | INT | NULL | Patient object id - identified by looking up the PrescriberOrderNumber to find the patient that is the subject of this message, or by manually identifying the patient. Can be null if patient is unknown. |
PatientVisitOID | INT | NULL | Patient visit object id, References to HPatienvisit table |
NcpdpInboundMessageOID | BIGINT | NULL | Foreign key to InboundNCPDPMessage table |
InboundMsgPrescriberStaffOID | INT | NULL | Prescriber staff oid for related ncpdp inbound message |
InboundMsgHdxCorrelationId | VARCHAR(35) | NULL | CorrelationId in transaction sent to HDX(echo the inbound msg correlation id for response sequences; otherwise leave null) |
HdxRelatesToMessageId | VARCHAR(35) | NULL | The hdxTransactionId of the previous message in a sequence |
InboundMsgRxReferenceNumber | VARCHAR(35) | NULL | The prescription number assigned by the pharmacy from UIH-020(EdiFact reference), carried over from ncdp inbound message |
PrescriberOrderNumber | VARCHAR(35) | NULL | Prescriber ordering transactions sent to HDX |
PrescriberOrderNumberStatus | TINYINT | NULL | Status of prescriber order number(0 inactive, 1 active) |
PonDeactivatedDateTime | DATETIME | NULL | Local time when prescriber order number was deactivated |
PonDeactivatedNcpdpOutboundMessageOID | BIGINT | NULL | Foreign key of the outbound message that deactivated the PON(Prescriber Order Number). Null if the eRx was simply removed with no cancel message. |
PonDeactivatedUserOID | INT | NULL | User OID of user who deactivated the PON(Prescriber Order Number) |
SoarianToHDXRequestId | VARCHAR(20) | NULL | Request id from soarian to hdx, part of web service context, not in ncpdp |
SoarianTransientMessageID | VARCHAR(35) | NULL | Message ID used in ncpdp outbound msg for traceability. Not globally unique, therefore HDX replaces this field with hdxTransactionId in the message to surescripts. |
PrescriptionSignatureOID | BIGINT | NULL | Reference oid for NCPDP response message's signature signed by private key |
EPrescriberSAMLSignature | XML | NULL | Column holding the digital signature in case this document contains electronically prescribed controlled substances |
DenyReason | VARCHAR(70) | NULL | Reason for Denied or DNTF(Denied New To Follow) |
DenyReasonCode | VARCHAR(3) | NULL | Reason code for Denied or DNTF(Denied New To Follow)( Allowable values: AE,AO,AM,AB,AC,AF,AA,AN,AP) |
WorklistDocumentXmlType | VARCHAR(20) | NULL | Type of document xml from worklist. Null if not a worklist Rx. Erenew: UsePML, NewMed. TBD for RXCHG: UseReqMedRxC, NewMedRxC |
WorklistDocumentXml | XML | NULL | Widget xml for ncpdp outbound message created in the Pharmacy worklist |
WorklistItemRemovedDateTime | DATETIME | NULL | Local time the item was removed from the worklist |
WorklistItemRemovedUserOid | INT | NULL | User who removed the item from the worklist |
WorklistItemRemovedNote | VARCHAR(400) | NULL | Comments entered by the user when removing the item from the worklist |
XmlDocStorageOID | INT | NULL | Foreign key to the XmlDocStorage med list that was displayed when this message was sent |
PharmacyOID | INT | NULL | Pharmacy table object id |
RecipientNcpdpIdInMessage | VARCHAR(35) | NULL | Ncpdp ID of the pharmacy |
PharmacyRole | VARCHAR(6) | NULL | Allowable value: MAIL, RETAIL |
Quantity | VARCHAR(300) | NULL | Prescription quantity |
Refills | VARCHAR(300) | NULL | Refills quantity |
DispensingUnitFmtCode | VARCHAR(10) | NULL | National Cancer Institute Thesaurus code(NCIt code; formerly known as Federal Medication Terminologies(FMT) code) for the prescription quantity unit of measure(QUOM) |
DispensingUnitFmtDesc | VARCHAR(50) | NULL | National Cancer Institute Thesaurus(NCIt) description for the prescription quantity unit of measure(QUOM) |
DrugDescription | VARCHAR(105) | NULL | Name, strength, and dose form of the prescribed medication |
TransmittedViaApiVersion | VARCHAR(10) | NULL | The HDX api that was used to transmit the message( 'MU2' = sendPrescriptionService, sendPrescriptionRenewalResponse; 'MU3' = outboundMessage for edifact e-prescritpions, 'HDX2017' = outboundMessage for xml e-prescriptions) |
LastCngDTime | DATETIME | NOT NULL | Last Updated Date Time EA/DSS(UTC) |
LastCngSeqNo | INT | NOT NULL | Last change sequence number, starts at 1; used for optimistic updates |
DaysSupply | SMALLINT | NULL | Days Supply for a medication(e.g. '1') |
NcpdpMessageVersion | VARCHAR(10) | NULL | Version of eRx being used, 10.6, 2017 071 |
SentenceID | VARCHAR(25) | NULL | SentenceID of any new prescription in this message |
ResponseTypeProcessingMessages | VARCHAR(4000) | NULL | Change Response/Refill Response: Human readable Messages that show why the response is an Approve or Approve with Changes |
PharmacyNcpdpVersion | VARCHAR(10) | NULL | Ncpdp Version of target Pharmacy at time of message being sent |
HdxSynchronousResponseCode | VARCHAR(10) | NULL | Code indicating the initial synchronous response from HDX(Healthcare Data Exchange) |
RealWorldTestingTransactionStatus | VARCHAR(10) | NULL | Allowable values Success, Failure, Unknown. |
RealWorldTestingTransactionInformation | VARCHAR(max) | NULL | Transaction, exception, and processing information from HDX and Surescripts related to the success or failure of a transaction. |
VisitTypeCode | VARCHAR(30) | NULL | Internal code of the visit type. Allowable values IP(Inpatient), OP(Outpatient), EOP(Emergency Outpatient). |
|