Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
NcpdpInboundRxFill This table stores the electronic prescription fill status data specifically for RXFILL inbound messages.
Column Name Column Datatype Column Null Option Column Comment
NcpdpInboundRxFillOidBIGINTNOT NULL Primary key
NcpdpInboundMessageOIDBIGINTNOT NULL Foreign key(FK) to NcpdpInboundMessage table
PatientOIDINTNULL Patient identifier
DrugDescriptionVARCHAR(105)NULL Display drug description(DRU/010/10..12 if valued, otherwise DRU/010/02)
FillStatusVARCHAR(12)NULL Indicates Medication fill status(possible values: Dispensed, Partial(Partially Dispensed), NotDispensed )
FillDateDTimeMinsSMALLDATETIMENULL Last fill date from NCPDP(National Council for Prescription Drug Programs) message in format YYYYMMDD
FilledQuantityVARCHAR(11)NULL Quantity dispensed(known as 'quantity received' DRU-020-02 in NCPDP message)
FilledUnitDescriptionVARCHAR(255)NULL Translated FMT(Federal Medication Terminologies) Potency Unit Code(DRU-020-05)
DrugDirectionsVARCHAR(140)NULL Dosage directions also known as SIG(DRU/030/02..3)
DispenseNoteFromPharmacyVARCHAR(70)NULL Comments to prescriber from response and medication segments(RES-040)
MedicationDispensedNoteVARCHAR(210)NULL Medication dispensing Note(DRU+D-090)
MedicationPrescribedNoteVARCHAR(210)NULL Medication Prescribing Note(DRU+P-090)
DaysSupplyVARCHAR(3)NULL Days supply(DRU-040-02)
PrimaryDiagnosisCodeForDisplayVARCHAR(20)NULL Prescriber assigned ICD(International Classification of Diseases) Diagnosis Code
DiagnosisDescriptionVARCHAR(255)NULL ICD(International Classification of Diseases) code description
PharmacyNcpdpIdVARCHAR(35)NULL NCPDP(National Council for Prescription Drug Programs) Id of the pharmacy(PVD-020-01)
PharmacyNameVARCHAR(70)NULL Pharmacy Name(PVD-070)
PharmacyAddress1VARCHAR(40)NULL Street address of the pharmacy(PVD-080-01)
PharmacyAddress2VARCHAR(40)NULL Pharmacy address line two(PVD-080-06)
PharmacyCityVARCHAR(35)NULL Pharmacy City(PVD-080-02)
PharmacyStateVARCHAR(9)NULL Pharmacy State(PVD-080-03)
PharmacyZipCodeVARCHAR(10)NULL Pharmacy Zip(PVD-080-04)
PharmacyPhoneVARCHAR(80)NULL Pharmacy Telephone Number(PVD-090-01)
PharmacyFaxVARCHAR(80)NULL Pharmacy FAX Number(PVD-090-01)
PrescriberSuffixVARCHAR(10)NULL Prescriber Name Suffix(PVD-050-04)
PrescriberPrefixVARCHAR(10)NULL Prescriber Name Prefix(PVD-050-05)
PrescriberPhoneVARCHAR(80)NULL Prescriber Telephone Number(PVD-090-01)
PrescriberFaxVARCHAR(80)NULL Prescriber FAX Number(PVD-090-01)

Return to Table-Index

  Soarian Clinicals Schema Documentation  
Copyright © 2023, Oracle and/or its affiliates