Tables [dbo].[Medication_Fill_History]
History of medication fulfillments from a pharmacy.
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_Medication_Fill_History: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Medication_Fill_History table
Indexes NIX_MedicationFillHistory_ItemId, NIX_Medication_Fill_History_Patientid_MedDictDE, NIX_Medication_Fill_History_PatientID_PatPBMUniqueID_MedDictDE(3)Foreign Keys FK_Medication_Fill_History#NEW#_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientIDForeign Keys FK_Medication_Fill_History_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NULL allowedPatient. Link to Person.ID
Indexes NIX_Medication_Fill_History_Patientid_MedDictDE, NIX_Medication_Fill_History_PatientID_PatPBMUniqueID_MedDictDE(2)MedDictDE[dbo].[dict_id]5NULL allowedMedication. Link to Medication_DE.ID
Indexes NIX_Medication_Fill_History_FillDttmFillDTTMdatetime8NULL allowedDate filled
Quantityvarchar(20)20NULL allowedNumber of pills
DaysSupplyint4NULL allowedHow many days will medication last you
DaysFromLastFillint4NULL allowedHow many days since last filled
FillSourcevarchar(100)100NULL allowedSource
SIGvarchar(1000)1000NULL allowedThe SIG used in the prescription (ie take 1 pill daily).
PrescriberNamevarchar(100)100NULL allowedPrescriber Name
NABPvarchar(35)35NULL allowedNABP number. Link to Pharmacy_de.pharmacynabp
ClinicNmvarchar(35)35NULL allowedClinic Name
Indexes NIX_Medication_Fill_History_PatientID_PatPBMUniqueID_MedDictDE, NIX_MedicationFillHistory_PatPBMUniqueID(2)PatPBMUniqueIDvarchar(80)80NULL allowedPatient identifier given by PBM
NDCchar(12)12NULL allowedNDC code of the medication given
MAIFillDescvarchar(255)255NOT NULL('')Perscription Fill Description
MAIFillDaysLateint4NOT NULL((0))Perscription Fill - Number of Days Late
MAIFillIndchar(15)15NOT NULL('')Perscription Fill Index
RxFillIDvarchar(255)255NOT NULL('')Perscription Fill Identifier
UnverifiedItemID[dbo].[uniqueid]9NULL allowedUnverified Item. link to Unverified_Item.ID
Indexes NIX_MedicationFillHistory_ItemIdImportedDrugDescriptionvarchar(255)255NULL allowed('')Drug Description
Indexes NIX_MedicationFillHistory_ItemIdItemId[dbo].[uniqueid]9NOT NULL((0))Item. Link to item_medication.id
FillStatusvarchar(255)255NULL allowedFill Status Text
FillCommentsvarchar(255)255NULL allowed