wiki:Hicdep_1.70/TableRefill

tblREFILL - Prescription refill data

holds drug, refill date and supply of prescriptions

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

Table Crosstable Error Code Description Study specific HICDEP?
AllTablesCrossTableATC001any date in database after DEATH_D in tblLTFUYES
AllTablesCrossTableATC002any date in database after DROP_D in tblLTFUYES
AllTablesCrossTableATC003any date in database before BIRTH_D in tblBASYES
AllTablesCrossTableATC004any date in database in the futureYES
AllTablesCrossTableATC005patients submitted previously who have been missed outYES
AllTablesCrossTableATC006Any fields not coded as coding lists on table definitionYES
tblREFILLCrossTablePRC001Patient doesn't have a record in BASYES
tblREFILLWithinTablePRW002Missing PATIENTYES
tblREFILLWithinTablePRW003Missing REFILL_DYES
tblREFILLWithinTablePRW004Missing DRUG_IDYES
tblREFILLWithinTablePRW005Missing SUPPLYYES
tblREFILLWithinTablePRW006SUPPLY < 1YES
Last modified 5 years ago Last modified on 11/16/12 14:08:17