Sept 21 MIS - Pharmacy.csv
Additional Info
| Field | Value |
|---|---|
| Data last updated | 17 December 2021 |
| Metadata last updated | 17 December 2021 |
| Created | 17 December 2021 |
| Format | text/csv |
| Licence | OGL-UK-2.0 |
Data Dictionary
| Column | Title | Type | Description |
|---|---|---|---|
| Contractor | string | ||
| Address_1 | string | ||
| Address_2 | string | ||
| Address_3 | string | ||
| Address_4 | string | ||
| Postcode | string | ||
| Start Date | string | ||
| End Date | string | ||
| STP | string | ||
| TOTAL FORMS | integer | ||
| TOT STDR PXS | integer | ||
| TOT ZDR PXS | integer | ||
| RETD BACK FORMS | integer | ||
| RETD BACK ITEMS | integer | ||
| CHGS CURR RATE | integer | ||
| CHGS PREV RATE | integer | ||
| ELHOSE ITEMS | integer | ||
| ADVANCE ITEMS | integer | ||
| ADVANCE CHARGES | integer | ||
| EXPENSIVE PX FEE | integer | ||
| MED USE REVIEWS | integer | ||
| DISPENSING STAFF | integer | ||
| FP57 REF FORMS | integer | ||
| AVG ITEM VALUE | number | ||
| ETP FORMS | integer | ||
| ETP ITEMS | integer | ||
| AUR HOME NUM | integer | ||
| AUR PREM NUM | integer | ||
| NMS NUM | integer | ||
| NMS NUM ITEMS | integer | ||
| string | |||
| BASIC PRICE STDR | number | ||
| DISCOUNT | number | ||
| BASIC PRICE ZDR | number | ||
| OUT OF POCKET EX | integer | ||
| PAYMT CONSUMABLE | number | ||
| ADVANCE PAY REM | number | ||
| ADVANCE PAY DRG | number | ||
| REC PAY REM | number | ||
| REC PAY DRG | number | ||
| LATE REG ADV REM | integer | ||
| LATE REG ADV DRG | integer | ||
| REC ADV PAY REM | integer | ||
| REC ADV PAY DRG | integer | ||
| PAY CONTAINERS | number | ||
| NMS FEE | integer | ||
| string | |||
| BASIC DISP FEE | number | ||
| TRANSITION PAYMT | integer | ||
| REPEAT DISP FEE | integer | ||
| PRACTICE PAYMENT | integer | ||
| ADD FEE-2A | integer | ||
| ADD-FEE-2B-MF | integer | ||
| ADD-FEE-2B-HD | number | ||
| METHADONE PAYMT | string | ||
| string | |||
| ADD FEE-2E | string | ||
| ADD FEE-2F | number | ||
| MANUALLY PRICED | integer | ||
| ESTAB PAYMENT | integer | ||
| MED USE REVIEWS | integer | ||
| PXS CHGS CURR | number | ||
| PXS CHGS PREV | integer | ||
| ELASTIC HOSIERY | integer | ||
| FP57 REFUNDS | integer | ||
| AUR HOME FEE | integer | ||
| AUR PREM FEE | integer | ||
| STOMA CUST FEE | integer | ||
| PREREG TRAINEE | integer | ||
| TOP UP PROT/ESTB | integer | ||
| H.C. DRG ADV | integer | ||
| H.C. DRG ADV REC | integer | ||
| NEEDLE EXCHANGE | integer | ||
| LOCAL SCHEME 1 | integer | ||
| LOCAL SCHEME 2 | integer | ||
| LOCAL SCHEME 3 | integer | ||
| LOCAL SCHEME 4 | integer | ||
| BOTTLE STORAGE | integer | ||
| ADD PH ACC SERV | integer | ||
| ADVICE CARE HOME | integer | ||
| string | |||
| PRACTICE PAY ADJ | integer | ||
| MED USE REV ADJ | integer | ||
| REPEAT DISP ADJ | integer | ||
| string | |||
| BREACH SERV FINE | integer | ||
| COLL UNUSED DRG | integer | ||
| WELFARE MILK | integer | ||
| FORMULARY DEVT | integer | ||
| LPC VOL LEVY | integer | ||
| LPC STAT LEVY | number | ||
| VOL LEVY ADJ | integer | ||
| STAT LEVY ADJ | integer | ||
| LPS | integer | ||
| E S P SCHEME | integer | ||
| E S P SCHEME ADJ | integer | ||
| string | |||
| string | |||
| OXY THER-SERVICE | integer | ||
| OXY COMPENSATION | integer | ||
| LOCAL SCHEME 5 | integer | ||
| LOCAL SCHEME 6 | integer | ||
| LOCAL SCHEME 7 | integer | ||
| LOCAL SCHEME 8 | integer | ||
| LOCAL SCHEME 9 | integer | ||
| LOCAL SCHEME 10 | integer | ||
| AUR ADJUSTMENT | integer | ||
| STOMA CUST ADJ | integer | ||
| NMS FEE ADJ | integer | ||
| NMS IMPL PAY ADJ | integer | ||
| string | |||
| 12 MTH PPC CURR | integer | ||
| 3 MTH PPC CURR | integer | ||
| 12 MTH PPC PREV | integer | ||
| 3 MTH PPC PREV | integer | ||
| string | |||
| string | |||
| CIP COMPENSATION | integer | ||
| PH REWARD SCHEME | integer | ||
| COPY SCHED CHGE | integer | ||
| ADJUSTMENT DRUGS | integer | ||
| ADJUSTMENT FEES | integer | ||
| ADD_ADV_PAY | integer | ||
| ADD_ADV_PAY_REC | integer | ||
| TMP_SAFE_PAY | integer | ||
| AMENDMENT_ALLOW | integer | ||
| LOCAL SCHEME 11 | integer | ||
| LOCAL SCHEME 12 | integer | ||
| LOCAL SCHEME 13 | integer | ||
| LOCAL SCHEME 14 | integer | ||
| LOCAL SCHEME 15 | integer | ||
| FLU REIMB | number | ||
| FLU REIMB ADJ | integer | ||
| FLU REMUN | number | ||
| FLU REMUN ADJ | integer | ||
| SUMM CARE REC | integer | ||
| UMS DRUGS | integer | ||
| UMS DRUGS ADJ | integer | ||
| UMS FEES | integer | ||
| UMS FEES ADJ | integer | ||
| UMS CHARGES | integer | ||
| UMS CHARGES ADJ | integer | ||
| PAS FEES | integer | ||
| PAS FEES ADJ | integer | ||
| QPS FEES | integer | ||
| QPS FEES ADJ | integer | ||
| SSP REMUN | integer | ||
| SSP REIMB | integer | ||
| SSP REMUN ADJ | integer | ||
| SSP REIMB ADJ | integer | ||
| LATE ADJ | integer | ||
| LATE FEE | integer | ||
| CPCS DRUGS | any | ||
| CPCS DRUGS ADJ | integer | ||
| CPCS FEES | integer | ||
| CPCS FEES ADJ | integer | ||
| CPCS CHARGES | integer | ||
| CPCS CHARGES ADJ | integer | ||
| CPCS SIGN-UP | integer | ||
| PQS FEES | number | ||
| PQS FEES ADJ | integer | ||
| OOPE ADJ | integer | ||
| PREREG ADJ | integer | ||
| TRAN PAY | number | ||
| TRAN PAY ADJ | integer | ||
| HEP C SRVCE | integer | ||
| HEP C SRVCE ADJ | integer | ||
| HEP C KIT | integer | ||
| HEP C KIT ADJ | integer | ||
| PPE CLAIMS | integer | ||
| PPE CLAIM ADJ | integer | ||
| FLU PREM | integer | ||
| FLU PREM ADJ | integer | ||
| DISC MED REV | integer | ||
| DISC MED REV ADJ | integer | ||
| LOCAL SCHEME 16 | integer | ||
| LOCAL SCHEME 17 | integer | ||
| string | |||
| LOCAL SCHEME 19 | integer | ||
| string | |||
| string | |||
| string | |||
| string | |||
| string | |||
| string | |||
| GP REF PATH | integer | ||
| GP REF PATH ADJ | integer | ||
| COVID_VACC | integer | ||
| COVID_VACC_ADJ | integer | ||
| COVID_PREM | integer | ||
| COVID_PREM_ADJ | integer | ||
| COVID_TEST | number | ||
| COVID_TEST_ADJ | integer | ||
| CAP_SUPP | integer | ||
| CAP_SUPP_ADJ | integer | ||
| string | |||
| string | |||
| string | |||
| string | |||
| string | |||
| string | |||
| string | |||
| string | |||
| string | |||
| string | |||
| string | |||
| string | |||
| string | |||
| string | |||
| string | |||
| COVID_TEST_REG | integer | ||
| COVID_TEST_SET | integer | ||
| COVID_COSTS | integer | ||
| COVID_COSTS_ADJ | integer | ||
| COVID_ADV_RCRY | number | ||
| string | |||
| HYP_SET_UP | integer | ||
| HYP_SET_ADJ | integer | ||
| HYP_ABPM | integer | ||
| HYP_ABPM_ADJ | integer | ||
| HYP_INCTV | integer | ||
| HYP_INCTV_ADJ | integer | ||
| REC_EARLY_PAY | integer | ||
| EARLY_PAY_ACC | integer | ||
| PEPS_TRNS_REC | any |