FOI 02117 Apr24 MIS Pharmacy Contractor Completed Request.csv

Report an issue

Additional Info

Field Value
Data last updated August 19, 2024
Metadata last updated August 19, 2024
Created August 19, 2024
Format CSV
License Open Government Licence 3.0 (United Kingdom)

Data Dictionary

Column Title Type Description
YEAR_MONTH integer
CONTRACTOR_ACCOUNT_TYPE string
CONTRACTOR_CODE string
CONTRACTOR_NAME string
CONTRACTOR_ADDRESS string
POSTCODE string
CONTRACTOR_START_DATE date
CONTRACTOR_INACTIVE_DATE string
INTEGRATED_CARE_BOARD_CODE string
INTEGRATED_CARE_BOARD_NAME string
NUMBER_TOTAL_FORMS integer
NUMBER_STANDARD_PX integer
NUMBER_DND_PX any
REFERRED_BACK_FORMS integer
REFERRED_BACK_ITEMS integer
NUMBER_CHARGEABLE_PX_CURRENT integer
NUMBER_CHARGEABLE_PX_PREVIOUS integer
NUMBER_ELAS_HOSIERY_PX_CHARGE integer
NUMBER_ADVANCE_ITEMS_DECLARED integer
NUMBER_ADVANCE_CHARGE_DECLARED integer
NUMBER_EXPENSIVE_PX_FEES integer
FP57_REFUND_FORMS_DECLARED integer
AVERAGE_PX_VALUE number
NUMBER_EPS_MESSAGES any
NUMBER_EPS_ITEMS integer
NUMBER_AUR_CONDUCTED_HOME integer
NUMBER_AUR_CONDUCTED_PREMISES integer
NUMBER_NEW_MED_SERV integer
TOTAL_DISPENSED_ITEMS integer
BASIC_PRICE_STANDARD_NIC number
DISCOUNT_VALUE number
BASIC_PRICE_DND_NIC number
OUT_OF_POCKET_EXPENSES integer
OUT_OF_POCKET_EXPENSES_ADJ integer
PAYMENT_CONSUMABLE number
ADVANCE_PAY_REMUNERATION number
ADVANCE_PAY_DRUGS_REIMBURSE number
RECOV_PAY_REMUNERATION number
RECOV_PAY_DRUGS_REIMBURSEMENT number
LATE_REG_ADV_PAY_REMUNERATION integer
LATE_REG_ADV_PAY_DRUGS integer
RECOV_LATE_REG_ADV_PAY_REMUN integer
RECOV_LATE_REG_ADV_PAY_DRUGS integer
PAYMENT_CONTAINERS number
NEW_MED_SERV_FEE_VALUE any
NEW_MED_SERV_FEE_ADJUSTMENT integer
NEW_MED_SERV_IMPLEMENT_PAY_ADJ integer
PROFESSIONAL_DISPENSING_FEE number
REPEAT_DISPENSING_FEE_ADJ integer
PRACTICE_PAYMENT_ADJUSTMENT integer
UNLICENSED_MEDICINE_FEE integer
APPLIANCE_MEASURED_FITTED_FEE integer
APPLIANCE_HOME_DELIVERY_FEE number
METHADONE_PAYMENT_FEE string
CONTROLLED_DRUGS_FEE_VALUE string
EXPENSIVE_PX_FEE_VALUE number
MED_USE_REVIEW_FEE_VALUE_ADJ integer
CHARGEABLE_PX_CURRENT_VALUE number
CHARGEABLE_PX_PREVIOUS_VALUE integer
CHARGEABLE_PX_ELAS_HOS_VALUE integer
FP57_REFUNDS_VALUE integer
AUR_CONDUCTED_HOME_FEE integer
AUR_CONDUCTED_PREMISES_FEE integer
AUR_CONDUCTED_FEE_ADJUSTMENT integer
STOMA_CUSTOMISATION_FEE integer
STOMA_CUSTOMISATION_FEE_ADJ integer
PRE_REGISTRATION_TRAINEE integer
PRE_REGISTRATION_TRAINEE_ADJ integer
HIGH_COST_DRUGS_ADVANCE integer
HIGH_COST_DRUGS_ADVANCE_RECOV integer
NEEDLE_SYRINGE_EXCHANGE_SCHEME integer
LOCAL_SCHEME_1 integer
LOCAL_SCHEME_2 integer
LOCAL_SCHEME_3 integer
LOCAL_SCHEME_4 integer
BOTTLE_STORAGE integer
ADDITIONAL_PHARM_ACCESS_SERV integer
ADVICE_CARE_HOME integer
BREACH_SERVICE_FINE integer
COLLECTION_UNUSED_DRUGS_VALUE integer
WELFARE_MILK integer
FORMULARY_DEVELOPMENT integer
LPC_VOLUNTARY_LEVY integer
LPC_VOLUNTARY_LEVY_ADJUSTMENT integer
LPC_STATUTORY_LEVY number
LPC_STATUTORY_LEVY_ADJUSTMENT integer
TOTAL_LPS_FEE_VALUE 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
12_MONTH_PPC_CURRENT_VALUE integer
3_MONTH_PPC_CURRENT_VALUE integer
12_MONTH_PPC_PREVIOUS_VALUE integer
3_MONTH_PPC_PREVIOUS_VALUE integer
PX_PRICING_ERRORS_PAYMENT integer
PHARMACY_REWARD_SCHEME integer
COPY_SCHEDULE_CHARGE integer
ADJUSTMENT_DRUGS integer
ADJUSTMENT_FEE integer
COVID_HOME_DELIVERY_FEE integer
COVID_HOME_DELIVERY_FEE_ADJ integer
TEMPORARY_SAFEGUARDING_PAYMENT integer
AMENDMENT_ALLOWANCE integer
LOCAL_SCHEME_11 integer
LOCAL_SCHEME_12 integer
LOCAL_SCHEME_13 integer
LOCAL_SCHEME_14 integer
LOCAL_SCHEME_15 integer
FLU_REIMBURSEMENT integer
FLU_REIMBURSEMENT_ADJ integer
FLU_REMUNERATION_FEE integer
FLU_REMUNERATION_FEE_ADJ integer
PHARMACY_ACCESS_SCHEME_FEE integer
PHARMACY_ACCESS_SCHEME_FEE_ADJ integer
SSP_FEE_VALUE integer
SSP_FEE_VALUE_ADJ integer
SSP_REIMBURSEMENT_VAT_VALUE integer
SSP_REIMBURSEMENT_VAT_ADJ integer
LATE_ADMIN_DEDUCTION_FEE integer
LATE_ADMIN_DEDUCTION_FEE_ADJ integer
CPCS_DRUGS integer
CPCS_DRUGS_ADJUSTMENT integer
CPCS_FEE integer
CPCS_FEE_ADJUSTMENT integer
CPCS_CHARGES integer
CPCS_CHARGES_ADJUSTMENT integer
PHARM_QUALITY_SCHEME_FEE integer
PHARM_QUALITY_SCHEME_FEE_ADJ integer
TRANSITIONAL_PAYMENT integer
TRANSITIONAL_PAYMENT_ADJ integer
HEP_C_PROV_OF_TEST_SERV_FEE integer
HEP_C_PROV_TEST_SERV_FEE_ADJ integer
HEP_C_TEST_KIT_REIMBURSEMENT integer
HEP_C_TEST_KIT_REIMBURSE_ADJ integer
PPE_CLAIM integer
PPE_CLAIM_ADJUSTMENT integer
FLU_PREMISES_CLAIM_ADJUSTMENT integer
DISCHARGE_MED_SERVICE_FEE integer
DISCHARGE_MED_SERVICE_FEE_ADJ integer
LOCAL_SCHEME_16 integer
LOCAL_SCHEME_17 integer
LOCAL_SCHEME_19 integer
LOCAL_SCHEME_20 integer
GP_REFERRAL_PATHWAY_FEE_ADJ integer
COVID_VACCINE_VALUE integer
COVID_VACCINE_VALUE_ADJUSTMENT integer
COVID_PREMISES_AND_REFRIG integer
COVID_PREMISES_AND_REFRIG_ADJ integer
COVID_TESTING_KIT_ADJUSTMENT integer
CAPACITY_SUPPLEMENT integer
CAPACITY_SUPPLEMENT_ADJUSTMENT integer
COVID_COSTS_REIMBURSEMENT integer
COVID_COSTS_REIMBURSEMENT_ADJ integer
HYPERTENSION_SET_UP_FEE integer
HYPERTENSION_SET_UP_FEE_ADJ integer
HYPER_CHECK_AND_ABPM_FEE integer
HYPER_CHECK_AND_ABPM_FEE_ADJ integer
HYPERTENSION_INCENTIVE_FEE integer
HYPERTENSION_INCENTIVE_FEE_ADJ integer
RECOV_EARLY_PAYMENT_ON_ACCOUNT number
EARLY_PAYMENT_ON_ACCOUNT integer
PEPS_TRANSITION_RECOVERY integer
SMOKING_CESS_SET_UP_FEE integer
SMOKING_CESS_SET_UP_FEE_ADJ integer
SMOKING_CESS_CONSUL_FEE integer
SMOKING_CESS_CONSUL_FEE_ADJ integer
SMOKING_CESS_NRT_DRUGS_COST integer
SMOKING_CESS_NRT_DRUG_COST_ADJ integer
SMOKING_CESS_NRT_CHARGES integer
SMOKING_CESS_NRT_CHARGES_ADJ integer
LOCAL_SCHEME_18 integer
EMERGENCY_BANK_HOLIDAY_DRUGS integer
EMERGENCY_BANK_HOLIDAY_FEE integer
LOCAL_SCHEME_21 integer
LOCAL_SCHEME_22 integer
LOCAL_SCHEME_23 integer
CONTRACEPTION_SET-UP integer
CONTRACEPTION_SET-UP_ADJ integer
CONTRACEPTION_CONSULTATIONS integer
CONTRACEPTION_CONSULTATION_ADJ integer
CONTRACEPTION_DRUG_COST integer
CONTRACEPTION_DRUG_COST_ADJ integer
HRT_PPC_PHARMACY_SALES integer
HRT_PPC_PHARMACY_SALES_ADJ integer
LOCAL_SCHEME_24 integer
LOCAL_SCHEME_25 integer
LOCAL_SCHEME_26 integer
FOUND_TRAINEE_PHARM_TRAINING integer
FOUND_TRAINEE_PHARM_TRAIN_ADJ integer
FP57_REFUNDS_VALUE_ADJUSTMENT integer
LFD_ELIG_PATIENT_SERV_FEE integer
LFD_ELIG_PATIENT_SERV_FEE_ADJ integer
LFD_ELIG_PATIENT_TEST_COST integer
LFD_ELIG_PATIENT_TEST_COST_ADJ integer
PTPT_EDUCATION integer
PTPT_EDUCATION_ADJUSTMENT integer
PF_INITIAL_FIXED_PAYMENT integer
PF_INITIAL_FIXED_PAYMENT_ADJ integer
PF_CP_CONSULTATION_FEE integer
PF_CP_CONSULTATION_FEE_ADJ integer
PF_CP_MONTHLY_FIXED_PAY year
PF_CP_MONTHLY_FIXED_PAY_ADJ integer
PF_CP_VAT_VALUE integer
PF_CP_VAT_VALUE_ADJ integer
LOCAL_SCHEME_27 integer
PF_UMS_DRUG_COST number
PF_UMS_DRUG_COST_ADJ integer
PF_MI_&_UMS_FEE integer
PF_MI_&_UMS_FEE_ADJ integer
PF_MI_&_UMS_CHARGES any
PF_MI_&_UMS_CHARGES_ADJ integer
PF_CP_CONSULTATION_CAP_ADJ integer
CONCESSION_TOP-UP_PAYMENT number
CONCESSION_TOP-UP_PAYMENT_ADJ integer