File name
Data Dictionary Prescribing Information System (PIS) Research Data Access Pathway Subset%402.0.3
Type
.XLSX
This dataset is available through the Researcher Access Service
The Prescribing Information System (PIS) is the definitive data source for all prescribing relating to all medicines and their costs that are prescribed and dispensed in the community in Scotland.
Available resource files can be downloaded below.
Data Dictionary Prescribing Information System (PIS) Research Data Access Pathway Subset%402.0.3
.XLSX
United Kingdom, Scotland
This is a secure dataset that can only be accessed by researchers from approved organisations.
Synthetic data is not yet available for this dataset.
age at paid date
month and year of birth
sex of patient
date on which prescription was processed and paid (always the last day of the month) (dd...
the actual date the prescription was prescribed (ddmmyyyy)
the actual date the prescription was dispensed (ddmmyyyy)
The dm+d description for the parent drug substance (VTM) of the Paid Item. VTM - Virtual...
The dm+d description for the parent generic VMP of the Paid Item. VMP - Virtual Medicina...
The dm+d description of the Paid Item.
The numerator part of the pharmaceutical strength of the Paid Item. For example, '25' wh...
| Variable Name | Variable Description | Data type | |
|---|---|---|---|
| AGE_IN_YEARS | age at paid date | ||
| MONTH AND YEAR OF BIRTH | month and year of birth | ||
| patient_sex | sex of patient | ||
| paid_month_end_date | date on which prescription was processed and paid (always the last day of the month) (dd... | ||
| prescribed_full_date | the actual date the prescription was prescribed (ddmmyyyy) | ||
| dispensed_full_date | the actual date the prescription was dispensed (ddmmyyyy) | ||
| substance_name | The dm+d description for the parent drug substance (VTM) of the Paid Item. VTM - Virtual... | ||
| drug_name | The dm+d description for the parent generic VMP of the Paid Item. VMP - Virtual Medicina... | ||
| product_name | The dm+d description of the Paid Item. | ||
| item_strength | The numerator part of the pharmaceutical strength of the Paid Item. For example, '25' wh... |