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
| Table | Crosstable | Error Code | Description | Study specific | Is HICDEP |
|---|---|---|---|---|---|
| AllTables | CrossTable | ATC001 | any date in database after DEATH_D in tblLTFU | Yes | |
| AllTables | CrossTable | ATC002 | any date in database after DROP_D in tblLTFU | Yes | |
| AllTables | CrossTable | ATC003 | any date in database before BIRTH_D in tblBAS | Yes | |
| AllTables | CrossTable | ATC004 | any date in database in the future | Yes | |
| AllTables | CrossTable | ATC005 | patients submitted previously who have been missed out | Yes | |
| AllTables | CrossTable | ATC006 | Any fields not coded as coding lists on table definition | Yes | |
| tblREFILL | CrossTable | PRC001 | Patient doesn't have a record in BAS | Yes | |
| tblREFILL | WithinTable | PRW002 | Missing PATIENT | Yes | |
| tblREFILL | WithinTable | PRW003 | Missing REFILL_D | Yes | |
| tblREFILL | WithinTable | PRW004 | Missing DRUG_ID | Yes | |
| tblREFILL | WithinTable | PRW005 | Missing SUPPLY | Yes | |
| tblREFILL | WithinTable | PRW006 | SUPPLY < 1 | Yes |