PharmaNet Data Checklist - British Columbia



Submit this completed form to the email address: HealthDataCentral@gov.bc.caQuestions about the request process or any part of this application may be directed to the email address above.PHARMANET DATA CHECKLISTMINISTRY OF HEALTH USE ONLYFile NumberDate Received FORMTEXT ????? FORMTEXT ?????ISP Appendix FORMTEXT ?????PROJECT TITLE FORMTEXT ?????APPLIES TO COHORT(S) FORMTEXT ?????DATE RANGEFrom (yyyy/mm/dd)To (yyyy/mm/dd) FORMTEXT ????? FORMTEXT ????? OTHER DATE RANGE AND FILTERING CRITERIA FORMTEXT ?????PHARMANET DATA (January 1, 1996 to present)PharmaNet data includes records of all medications dispensed from community pharmacies in BC. PharmaNet dispense data is available from two files: dispensing history and claims history. Dispensing history contains records for all dispenses in BC regardless of who pays for the claim. Claims history contains product dispensing and financial information except for individuals who are known to be federally insured (Veterans, RCMP, Armed Forces and beneficiaries of Non-Insured Health Benefits). PharmaNet does not capture:Antiretroviral medications dispensed from the Centre of Excellence in HIV / Aids at St. Paul’s HospitalChemotherapy agents dispensed by the BC Cancer AgencyExpensive Drugs for Rare Diseases (EDRD)Medications from the Provincial Retinal Disease Treatment Program Medications administered to hospital in-patientsMedication samples dispensed at a physician’s office (some may be entered by physicians with PharmaNet access)Third party paid amountsFinancial information for federally insured individuals (Veterans, RCMP, Armed Forces and beneficiaries of Non-Insured Health Benefits)Medications purchased without a prescription may not be on PharmaNet (e.g. over the counter medications, herbal products, vitamins)Due to data sensitivity, Plan W claims and abortion medication records are not be provided.The data dictionary for the PharmaNet variables in this checklist is available at purpose of this checklist is to request dispensing/claims information. Therefore, at least one variable must be checked off in the Dispensing/Claims Information table below. The associated data variables from the Drug, Patient, Pharmacy, and/or Practitioner Information tables below can be requested as needed. DISPENSING/CLAIMS INFORMATIONDATA VARIABLEVARIABLE NAMEREASON FOR REQUEST FORMCHECKBOX Date of Service (date of dispense)SRV_DATE FORMTEXT ????? FORMCHECKBOX PharmaCare Plan ID (PharmaCare plan under which claim was adjudicated)PCARE_PLAN_LABEL FORMTEXT ????? FORMCHECKBOX PharmaCare Plan Description (PharmaCare plan under which claim was adjudicated)PCARE_PLAN FORMTEXT ????? FORMCHECKBOX Dispensed QuantityDSPD_QTY FORMTEXT ????? FORMCHECKBOX Accepted Quantity (pro-rated based on days supply accepted for payment by PharmaCare)ACPT_QTY FORMTEXT ????? FORMCHECKBOX Dispensed Days Supply (estimated number of days of prescription treatment)DSPD_DAYS_SPLY FORMTEXT ????? FORMCHECKBOX Accepted Days Supply (submitted amount may be reduced if greater than Special Authority, plan or DINPIN amount)ACPT_DAYS_SPLY FORMTEXT ????? FORMCHECKBOX Billed Product Cost (product cost claimed by pharmacist)BLD_PROD_COST FORMTEXT ????? FORMCHECKBOX Accepted Product Cost (product cost accepted by PharmaCare)ACPT_PROD_COST FORMTEXT ????? FORMCHECKBOX Paid Product Cost (product cost paid by PharmaCare)PD_PROD_COST FORMTEXT ????? FORMCHECKBOX Billed Professional Fee (dispensing fee claimed by pharmacist)BLD_PROF_FEE FORMTEXT ????? FORMCHECKBOX Accepted Professional Fee (dispensing fee amount accepted by PharmaCare)ACPT_PROF_FEE FORMTEXT ????? FORMCHECKBOX Paid Professional Fee (dispensing fee amount paid by PharmaCare)PD_PROF_FEE FORMTEXT ????? FORMCHECKBOX Total Client Paid Amount (calculated as Billed Ingredient Cost + Billed Professional Fee - Paid Ingredient Cost - Paid Professional Fee. This is the difference between claimed and paid costs. Note that this is the assumed amount paid by the client.)TOT_CLNT_PD_AMT FORMTEXT ????? FORMCHECKBOX Total PharmaCare Paid Amount (amount paid by PharmaCare for product cost and professional fee)TOT_PCARE_PD_AMT FORMTEXT ????? FORMCHECKBOX Special Authority Flag (Y/N)SPEC_AUTHY_FLG FORMTEXT ????? FORMCHECKBOX Accumulated Expenditure Amount (first included in 2000)ACUM_EXP_AMT FORMTEXT ????? FORMCHECKBOX Claim Status (P = Paid, U = Unpaid)PCARE_PMT_STS_LABEL FORMTEXT ????? FORMCHECKBOX Intervention Type CodePROF_SRV_1_LABELPROF_SRV_2_LABEL FORMTEXT ????? FORMCHECKBOX Intervention Type DescriptionPROF_SRV_1PROF_SRV_2 FORMTEXT ????? FORMCHECKBOX Additional PharmaCare variablesPlease provide a detailed list of variables, description and rationale in the ADDITIONAL INFORMATION/COMMENTS section below. The Ministry will assess the availability upon request.RECORDS REQUESTED FOR (Choose one of the following) FORMCHECKBOX All medications. Rationale describing why all medications are required must be supplied. The rationale must clearly and specifically align with the stated project objectives and research methodology before it will be considered for release. FORMTEXT ????? FORMCHECKBOX Medications for drugs listed in drug file provided by applicant. Please, attach drug list to this form. FORMTEXT ????? FORMCHECKBOX Multiple drug lists provided. Please describe drug list use by cohort (i.e. use drug list 1 for cohort 1). FORMTEXT ?????DRUG INFORMATIONDATA VARIABLEVARIABLE NAMEREASON FOR REQUEST FORMCHECKBOX DINPIN (Drug Information Number/Product Identification Number, mandatory field)DIN_PIN FORMTEXT ????? FORMCHECKBOX Canadian Brand NameDRUG_BRAND_NM FORMTEXT ????? FORMCHECKBOX Generic Drug NameGEN_DRUG FORMTEXT ????? FORMCHECKBOX Drug StrengthGEN_DRUG_STRGTH FORMTEXT ????? FORMCHECKBOX Dosage Form Description (e.g., aerosol, tablet, capsule, liquid)GEN_DSG_FORM FORMTEXT ?????PATIENT INFORMATIONDATA VARIABLEVARIABLE NAMEREASON FOR REQUEST FORMCHECKBOX Client Label (Replaced by project-specific patient identification number)CLNT_LABEL FORMTEXT ????? FORMCHECKBOX GenderCLNT_GENDER _LABEL FORMTEXT ????? FORMCHECKBOX Date of Birth (YYYYMM)MRG_CLNT_BRTH_MTH FORMTEXT ????? FORMCHECKBOX Age CLNT_AGE_LABEL FORMTEXT ????? FORMCHECKBOX Health Authority (HA) CodeCLNT_HA_AREA_CD FORMTEXT ????? FORMCHECKBOX Health Authority (HA) DescriptionCLNT_HA_AREA FORMTEXT ????? FORMCHECKBOX Health Services Delivery Area (HSDA) CodeCLNT_HSDA_CD FORMTEXT ????? FORMCHECKBOX Health Services Delivery Area (HSDA) DescriptionCLNT_HSDA FORMTEXT ????? FORMCHECKBOX Local Health Area (LHA) CodeCLNT_LHA_CD FORMTEXT ????? FORMCHECKBOX Local Health Area (LHA) DescriptionCLNT_LHA FORMTEXT ????? FORMCHECKBOX Community Health Service Area (CHSA) CodeCLNT_CHSA_CD FORMTEXT ????? FORMCHECKBOX Community Health Service Area (CHSA) DescriptionCLNT_CHSA FORMTEXT ????? FORMCHECKBOX Forward Sortation Area (FSA, first 3 characters of the postal code)CLNT_FRWRD_SORT_AREA FORMTEXT ?????PHARMACY INFORMATIONDATA VARIABLEVARIABLE NAMEREASON FOR REQUEST FORMCHECKBOX Pharmacy Identification Number(Replaced by project-specific pharmacy identification number)FCTY_IDNT FORMTEXT ????? FORMCHECKBOX Health Authority (HA) CodeFCTY_HA_AREA_CD FORMTEXT ????? FORMCHECKBOX Health Authority (HA) DescriptionFCTY_HA_AREA FORMTEXT ????? FORMCHECKBOX Health Services Delivery Area (HSDA) CodeFCTY_HSDA_CD FORMTEXT ????? FORMCHECKBOX Health Services Delivery Area (HSDA) DescriptionFCTY_HSDA FORMTEXT ????? FORMCHECKBOX Local Health Area (LHA) CodeFCTY_LHA_CD FORMTEXT ????? FORMCHECKBOX Local Health Area (LHA) DescriptionFCTY_LHA FORMTEXT ????? FORMCHECKBOX Community Health Service Area (CHSA) CodeFCTY_CHSA_CD FORMTEXT ????? FORMCHECKBOX Community Health Service Area (CHSA) DescriptionFCTY_CHSA FORMTEXT ????? FORMCHECKBOX Forward Sortation Area (FSA, first 3 characters of the postal code)FCTY_FRWRD_SORT_AREA FORMTEXT ?????PRACTITIONER INFORMATIONDATA VARIABLEVARIABLE NAMEREASON FOR REQUEST FORMCHECKBOX Practitioner label(Replaced by project-specific practitioner identification number)PRSCR_PRAC_LABEL FORMTEXT ????? FORMCHECKBOX Health Authority (HA) CodeBEST_AVL_HA_AREA_CD FORMTEXT ????? FORMCHECKBOX Health Authority (HA) DescriptionBEST_AVL_HA_AREA FORMTEXT ????? FORMCHECKBOX Health Services Delivery Area (HSDA) CodeBEST_AVL_HSDA_CD FORMTEXT ????? FORMCHECKBOX Health Services Delivery Area (HSDA) DescriptionBEST_AVL_HSDA FORMTEXT ????? FORMCHECKBOX Local Health Area (LHA) Code BEST_AVL_LHA_CD FORMTEXT ????? FORMCHECKBOX Local Health Area (LHA) DescriptionBEST_AVL_LHA FORMTEXT ????? FORMCHECKBOX Community Health Service Area (CHSA) CodeBEST_AVL_CHSA_CD FORMTEXT ????? FORMCHECKBOX Community Health Service Area (CHSA) DescriptionBEST_AVL_CHSA FORMTEXT ????? FORMCHECKBOX Forward Sortation Area (FSA, first 3 characters of the postal code)BEST_AVL_FRWRD_SORT_AREA FORMTEXT ????? FORMCHECKBOX Practitioner’s Governing Body Identification (code identifying the governing body from which practitioner receives license)PRSCR_PRAC_LIC_BODY_IDNT FORMTEXT ????? FORMCHECKBOX Practitioner’s Governing Body DescriptionPRSCR_PRAC_LIC_BODY FORMTEXT ????? FORMCHECKBOX Practitioner Type (e.g., physician, dentist, nurse practitioner, podiatrist, midwife, veterinarian, pharmacist)PRSCR_PRAC_PROF FORMTEXT ????? FORMCHECKBOX Recent MSP Billing Practitioner Specialty Description (e.g. ophthalmology, general practice, nephrology, rheumatology)RCNT_BLLG_SPTY_1RCNT_BLLG_SPTY_2 FORMTEXT ????? FORMCHECKBOX Recent College Practitioner Specialty Description (e.g., cardiology, neurology, pediatrics, urology)RCNT_CLG_SPTY_1RCNT_CLG_SPTY_2 FORMTEXT ?????ADDITIONAL INFORMATION/COMMENTS FORMTEXT ????? ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download