Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
NcpdpInboundRxFillOid | BIGINT | NOT NULL | Primary key |
NcpdpInboundMessageOID | BIGINT | NOT NULL | Foreign key(FK) to NcpdpInboundMessage table |
PatientOID | INT | NULL | Patient identifier |
DrugDescription | VARCHAR(105) | NULL | Display drug description(DRU/010/10..12 if valued, otherwise DRU/010/02) |
FillStatus | VARCHAR(12) | NULL | Indicates Medication fill status(possible values: Dispensed, Partial(Partially Dispensed), NotDispensed ) |
FillDateDTimeMins | SMALLDATETIME | NULL | Last fill date from NCPDP(National Council for Prescription Drug Programs) message in format YYYYMMDD |
FilledQuantity | VARCHAR(11) | NULL | Quantity dispensed(known as 'quantity received' DRU-020-02 in NCPDP message) |
FilledUnitDescription | VARCHAR(255) | NULL | Translated FMT(Federal Medication Terminologies) Potency Unit Code(DRU-020-05) |
DrugDirections | VARCHAR(140) | NULL | Dosage directions also known as SIG(DRU/030/02..3) |
DispenseNoteFromPharmacy | VARCHAR(70) | NULL | Comments to prescriber from response and medication segments(RES-040) |
MedicationDispensedNote | VARCHAR(210) | NULL | Medication dispensing Note(DRU+D-090) |
MedicationPrescribedNote | VARCHAR(210) | NULL | Medication Prescribing Note(DRU+P-090) |
DaysSupply | VARCHAR(3) | NULL | Days supply(DRU-040-02) |
PrimaryDiagnosisCodeForDisplay | VARCHAR(20) | NULL | Prescriber assigned ICD(International Classification of Diseases) Diagnosis Code |
DiagnosisDescription | VARCHAR(255) | NULL | ICD(International Classification of Diseases) code description |
PharmacyNcpdpId | VARCHAR(35) | NULL | NCPDP(National Council for Prescription Drug Programs) Id of the pharmacy(PVD-020-01) |
PharmacyName | VARCHAR(70) | NULL | Pharmacy Name(PVD-070) |
PharmacyAddress1 | VARCHAR(40) | NULL | Street address of the pharmacy(PVD-080-01) |
PharmacyAddress2 | VARCHAR(40) | NULL | Pharmacy address line two(PVD-080-06) |
PharmacyCity | VARCHAR(35) | NULL | Pharmacy City(PVD-080-02) |
PharmacyState | VARCHAR(9) | NULL | Pharmacy State(PVD-080-03) |
PharmacyZipCode | VARCHAR(10) | NULL | Pharmacy Zip(PVD-080-04) |
PharmacyPhone | VARCHAR(80) | NULL | Pharmacy Telephone Number(PVD-090-01) |
PharmacyFax | VARCHAR(80) | NULL | Pharmacy FAX Number(PVD-090-01) |
PrescriberSuffix | VARCHAR(10) | NULL | Prescriber Name Suffix(PVD-050-04) |
PrescriberPrefix | VARCHAR(10) | NULL | Prescriber Name Prefix(PVD-050-05) |
PrescriberPhone | VARCHAR(80) | NULL | Prescriber Telephone Number(PVD-090-01) |
PrescriberFax | VARCHAR(80) | NULL | Prescriber FAX Number(PVD-090-01) |