tblREFILL - Prescription refill data


holds information on prescription refills

Core Fields

Note: Fields marked bold form the unique identifier for a record of the table.
Field name
Format
Description
PATIENT
character (or numeric if possible)
Code to identify patient (Cohort Patient ID)
REFILL_D
yyyy-mm-dd
Date of the prescription refill
DRUG_ID
character. see coding table for valid codings.
Drug which was prescribed
SUPPLY
numeric
How many days supply of the drug was supplied

QA Checks


TableCrosstableError CodeDescriptionStudy specificHICDEP?
AllTablesCrossTableATC001any date in database after DEATH_D in tblLTFU Yes
AllTablesCrossTableATC002any date in database after DROP_D in tblLTFU Yes
AllTablesCrossTableATC003any date in database before BIRTH_D in tblBAS Yes
AllTablesCrossTableATC004any date in database in the future Yes
AllTablesCrossTableATC005patients submitted previously who have been missed out Yes
AllTablesCrossTableATC006Any fields not coded as coding lists on table definition Yes
tblREFILLCrossTablePRC001Patient doesn't have a record in BAS Yes
tblREFILLWithinTablePRW002Missing PATIENT Yes
tblREFILLWithinTablePRW003Missing REFILL_D Yes
tblREFILLWithinTablePRW004Missing DRUG_ID Yes
tblREFILLWithinTablePRW005Missing SUPPLY Yes
tblREFILLWithinTablePRW006SUPPLY < 1 Yes