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 |
|
year |
|
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 |
|
integer |
|
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 |
|
integer |
|
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 |
|
any |
|
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 |
|
TIER1_CONTRACEPTION_SET-UP |
|
integer |
|
TIER1_CONTRACEPTION_SET-UP_ADJ |
|
integer |
|
TIER1_CONTRACEPT_CONSUL |
|
integer |
|
TIER1_CONTRACEPT_CONSULT_ADJ |
|
integer |
|
TIER1_CONTRACEPT_DRUG_COST |
|
integer |
|
TIER1_CONTRACEPT_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 |
|