| 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 |
|
string |
-
|
| CONTRACTOR_INACTIVE_DATE |
|
string |
-
|
| INTEGRATED_CARE_BOARD_CODE |
|
string |
-
|
| INTEGRATED_CARE_BOARD_NAME |
|
string |
-
|
| NUMBER_TOTAL_FORMS |
|
any |
-
|
| NUMBER_STANDARD_PX |
|
integer |
-
|
| NUMBER_DND_PX |
|
string |
-
|
| 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 |
|
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 |
|
any |
-
|
| FLU_REIMBURSEMENT_ADJ |
|
integer |
-
|
| FLU_REMUNERATION_FEE |
|
number |
-
|
| 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 |
-
|
| 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 |
|
year |
-
|
| PF_INITIAL_FIXED_PAYMENT_ADJ |
|
integer |
-
|