Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
NcpdpInboundMessageOID | BIGINT | NOT NULL | NCPDP(National Council for Prescription Drug Programs) Inbound Message Id(Primary key) |
NcpdpMessage | VARCHAR(MAX) | NOT NULL | NCPDP(National Council for Prescription Drug Programs)message text |
NcpdpMessageType | VARCHAR(10) | NULL | NCPDP(National Council for Prescription Drug Programs)Type of message(Allowable values: CANRES, RXCHG, RXFILL, REFREQ, STATUS, ERROR, VERIFY) |
NcpdpMessageSubType | VARCHAR(15) | NULL | NCPDP(National Council for Prescription Drug Programs)Sub-Type of message( Allowable values: Generic, Therapeutic, PriorAuth) |
SoarianReceivedDateTime | DATETIME | NOT NULL | Local time the message was received by Soarian from HDX(Health care date exchange) |
ProcessingStatus | CHAR(1) | NOT NULL | Processing status of the inbound message(u-unprocessed, p-processed, f-failure) |
HdxCorrelationId | VARCHAR(35) | NOT NULL | Transaction id for this message in the HDX(Health care date exchange) system |
HdxTransactionDateTime | DATETIME | NULL | Local time the message was received by HDX(Health care date exchange) from Surescripts |
ReceivedDataFormat | VARCHAR(3) | NULL | NCPDP data format(Allowable values: xml, edi = edifact) |
ProcessingOutcomeCode | VARCHAR(35) | NULL | Code for describing state of message after inbound processing |
| | | WorklistAllOptions: message accepted, user can prescribe or deny |
| | | DenyOnlyPonNotFound: message accepted, PON(Prescriber Order Number) not found, user can only deny |
| | | DenyOnlyPonDeactivated: message accepted, PON(Prescriber Order Number) no longer active, user can only deny |
| | | PtSearchPonNotFound: message accepted, user can deny or search for a patient |
| | | RxFailureEventIndicated: a prescription failure event should be raised |
| | | RxFailureEventRaised: a prescription failure event was successfully raised |
| | | MessageFailed: message failed with NCPDP Status code 6xx |
| | | MessageRejected: message rejected with NCPDP Status code 900 |
ProcessingMessages | VARCHAR(4000) | NULL | Descriptive errors and warnings from processing the message |
PrescriberOrderNumber | VARCHAR(35) | NULL | Prescriber Order number |
MessageID | VARCHAR(35) | NULL | MessageId from Pharmacy |
NcpdpOutboundMessageOID | BIGINT | NULL | Identifier of previous message.(This is the message identifier of the previous message as seen by the receiving pharmacy) |
HdxRelatesToMessageId | VARCHAR(35) | NULL | Identifier of previous message |
NotUsed_BatchId | VARCHAR(35) | NULL | Deprecated column. The BatchId used in pulling eRenews from HDX(Health data Exchange). This is no longer used once the new push model processing is used. |
RxReferenceNumber | VARCHAR(35) | NULL | The prescription number assigned by the pharmacy |
PrescriberSPI | VARCHAR(35) | NULL | Receiving prescriber's Surescripts Provider Identifier(SPI) |
PrescriberStaffOID | INT | NULL | Prescriber's staff Identification number |
ForwardedStaffOID | INT | NULL | Staff id for forwarded provider used when a Soarian Clinicals user forwards the message to another prescriber |
PatientOID | INT | NULL | Patient identifier determined by Prescriber Order Number lookup to determine the subject of this message, or by manually identifying the patient |
PatientOIDResolvingUserOID | INT | NULL | This is the user who manually resolved patient or confirmed name discrepancy |
PatientOIDResolvingUserName | VARCHAR(12) | NULL | User name of person who manually resolved patient |
PatientOIDResolvingDateTime | DATETIME | NULL | Date time the patient was resolved either by PON(Prescriber Order Number) or manually |
PatientFirstNameInMessage | VARCHAR(35) | NULL | First name of patient in incoming NCPDP Message, used in secondary patient verification check |
PatientLastNameInMessage | VARCHAR(35) | NULL | Last name of patient in incoming NCPDP Message for secondary check |
PatientMiddleNameInMessage | VARCHAR(35) | NULL | Middle name of patient in incoming NCPDP Message for secondary check |
PatientDateOfBirthInMessage | DATETIME | NULL | Patient date of birth |
PatientGenderInMessage | VARCHAR(3) | NULL | Patient gender in incoming NCPDP Message.(Allowable values M = Male, F = Female, U = Unknown ) |
PrescriberLastNameInMessage | VARCHAR(35) | NULL | Prescriber's last name |
PrescriberFirstNameInMessage | VARCHAR(35) | NULL | Prescriber's first name |
PrescriberMiddleNameInMessage | VARCHAR(35) | NULL | Prescriber's middle name |
PrescriberNpiInMessage | VARCHAR(35) | NULL | Prescriber's NPI(National Provider Identifier) in message |
PrescriberDeaInMessage | VARCHAR(35) | NULL | Prescriber's DEA(Drug Enforcement Administration) in message |
PrescribedDrugDescription | VARCHAR(105) | NULL | Drug description |
PatientNameConfirmation | VARCHAR(8) | NULL | SUCCESS: name mismatch accepted by user in secondary check, RESOLVED: patient oid resolved by user, FAILED: name mismatch rejected by user in secondary check, NULL: name not explicitly confirmed, run secondary checks |
SendingPharmacyNcpdpId | VARCHAR(7) | NULL | Unique identifier of sending United States pharmacy |
SendingPharmacyNpi | VARCHAR(35) | NULL | NPI(National Provider Identifier) of sending United State pharmacy |
SendingPharmacyType | VARCHAR(8) | NULL | Sending pharmacy type: MAIL, RETAIL; NULL is unidentified |
SendingPharmacySupportsEpcs | SMALLINT | NULL | Indicates if Pharmacy supports ePrescrption of controlled substance( Allowable values: 1- sending pharmacy supports electronic prescription of controlled substances; 0- does not support; NULL- unknown ) |
RoutedMedScui | VARCHAR(32) | NULL | KDI(Knowledge Data Infrastructure) scui(concept unique identifier) for the routed med(part of triplet + brand) |
StrengthScui | VARCHAR(32) | NULL | KDI(Knowledge Data Infrastructure) scui(concept unique identifier) for the med strength(part of triplet + brand) |
DoseFormScui | VARCHAR(32) | NULL | KDI(Knowledge Data Infrastructure) scui(concept unique identifier) for the med dose form(part of triplet + brand) |
BrandNameScui | VARCHAR(32) | NULL | KDI(Knowledge Data Infrastructure) scui(concept unique identifier) for the med brand name(part of triplet + brand). Only present if med in NCPDP message is a branded med. |
PatientPrescriptionHistoryOID | INT | NULL | Foreign key to PatientPrescriptionHistory if Prescriber Order Number lookup succeeds |
PrescribedUnitDescription | VARCHAR(255) | NULL | Translated FMT(Federal Medication Terminologies) Potency Unit Code |
DispensedUnitDescription | VARCHAR(255) | NULL | Translated FMT(Federal Medication Terminologies) Potency Unit Code |
MrcMedicationOID | BIGINT | NULL | Foreign key medication identifier of the originally prescribed medication as determined by Prescriber Order Number lookup |
PrescriptionVisitOID | INT | NULL | Foreign key to the visit of the originally prescribed medication as determined by Prescriber Order Number lookup |
SentenceID | VARCHAR(25) | NULL | SentenceID of the originally prescribed medication as determined by Prescriber Order Number lookup |
ResponseStatus | VARCHAR(3) | NULL | Indicated whether the pharmacy accepted or rejected the request(A: approved, D: denied; null: unknown) |
ResponseReasonCode | VARCHAR(3) | NULL | Coded reason given by the pharmacy for the response |
ResponseNote | VARCHAR(70) | NULL | Free text response note from the pharmacy |
XmlDocStorageOID | INT | NULL | The originating XmlDocStorage med list as determined by PrescriberOrderNumber lookup |
LastCngDTime | DATETIME | NOT NULL | Last Updated Date Time( EA/DSS(UTC) - Current Universal Time Coordinate or Greenwich Mean Time) |
LastCngSeqNo | INT | NOT NULL | Last change sequence number |
RecievedDataNcpdpVersion | VARCHAR(10) | NULL | NCPDP(National Council for Prescription Drug Programs) Version of Message received |
SoarianSynchronousResponseCode | VARCHAR(10) | NULL | Code indicating initial synchronous response to HDX(Health Data Exchange) |
FollowUpRequestCount | SMALLINT | NULL | Follow Up Request Count indicating that this message is a follow-up to a previously received message |
PrescriberAuthorizationCodes | VARCHAR(32) | NULL | Used in Prescription Change Request transactions. Contains comma delimited list of up to 10 digit codes |
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). |
|