British Columbia



VITAL STATISTICSDEATH DATA CHECKLISTSubmit this completed form to the email address: HealthDataCentral@gov.bc.ca.Questions about the request process or any part of this application may be directed to the email address above.Vital Statistics Death (VSD) data contains any death that was registered in the province of BC regardless of the deceased’s jurisdiction of usual residence, which includes deaths certified by physicians, nurse practitioners, and coroners. The VSD data goes back to January 1, 1986. The data dictionary for the VSD data variables in this checklist is available at TITLE FORMTEXT ?????DATE RANGEFrom (yyyy/mm/dd)To (yyyy/mm/dd) FORMTEXT ????? FORMTEXT ????? DATASET REQUESTThere are two datasets available: death event (‘Event Data’)medical coding for cause of death (‘Medical Coding Data’). Event Data includes information of the deceased such as biological sex recorded on the death certificate, age, marital status, and the address at death. It also contains fields that summarize a death event; for example, it includes the date and location of death, ICD codes for the underlying cause of death and the nature of injury, and several flags that indicate some conditions such as having an organ transplant and an autopsy being held. Medical Coding Data includes detailed information of the cause of death in ICD codes such as immediate, antecedent, and contributing causes of death, and lifestyle/ environmental exposure. This data does not include the information of the deceased other than an identification that allows to link to other data, and can be used to supplement Event Data when detailed information of the cause of death is desired.Please select the data that you want: FORMCHECKBOX Event Data FORMCHECKBOX Event Data and Medical Coding DataEVENT DATAIn this data one record represents one client.DATA FIELDVARIABLE NAME (MOH INTERNAL USE ONLY) FORMCHECKBOX Client study IDIf you are requesting PHNs instead of study IDs, please provide the reason below. FORMTEXT ?????CLNT_STUDY_ID FORMCHECKBOX Death year and monthIf you are requesting year, month, and day of death, please provide the reason below. FORMTEXT ?????EVT_DATE_LABEL FORMCHECKBOX Registration year and monthIf you are requesting year, month, and day of registration, please provide the reason below. FORMTEXT ?????RGSTN_DATE FORMCHECKBOX Time of deathTM_OF_DTH FORMCHECKBOX Deceased’s age at deathDCSD_AGE_LABEL FORMCHECKBOX Deceased’s sex (biological sex as documented on death certificate)DCSD_GENDER_LABEL FORMCHECKBOX Deceased’s marital statusDCSD_MRTL_STATUS FORMCHECKBOX Deceased’s birthplace - city DCSD_BRTH_ADDR_CITY FORMCHECKBOX Deceased’s birthplace - provinceDCSD_BRTH_ADDR_PROV FORMCHECKBOX Deceased’s birthplace - countryBRTH_PLC_COUNTRY FORMCHECKBOX Deceased’s residence - cityDSCD_RSDC_TMF_CMTY_NM FORMCHECKBOX Deceased’s residence – provinceDSCD_RSDC_PROV_CD FORMCHECKBOX Deceased’s residence - countryDSCD_RSDC_COUNTRY FORMCHECKBOX Deceased’s residence – Forward Sortation Area (FSA - first three characters of the postal code)If you are requesting six-digit postal codes, please provide the reason below. FORMTEXT ?????DSCD_RSDC_FRWRD_SORT_AREA FORMCHECKBOX Deceased’s residence – HADSCD_RSDC_HA_AREA_CD FORMCHECKBOX Deceased’s residence – HSDADSCD_RSDC_HSDA_CD FORMCHECKBOX Deceased’s residence – LHADSCD_RSDC_LHA_CD FORMCHECKBOX Deceased’s residence – CHSADSCD_RSDC_CHSA_CD FORMCHECKBOX Death place – cityDTH_PLC_TMF_CMTY_NM FORMCHECKBOX Death place – provinceDTH_PLC_PROV_CD FORMCHECKBOX Death place – countryDTH_PLC_COUNTRY FORMCHECKBOX Death place – FSA (first three characters of the postal code)If you are requesting six-digit postal codes, please provide the reason below. FORMTEXT ?????DTH_PLC_FRWRD_SORT_AREA FORMCHECKBOX Death place – HADTH_PLC_HA_AREA_CD FORMCHECKBOX Death place – HSDADTH_PLC_HSDA_CD FORMCHECKBOX Death place – LHADTH_PLC_LSA_CD FORMCHECKBOX Death place – CHSADTH_PLC_CHSA_CD FORMCHECKBOX Mother’s birthplace – cityMTHR_BRTH_ADDR_CITY FORMCHECKBOX Mother’s birthplace – provinceMTHR_BRTH_ADDR_PROV FORMCHECKBOX Mother’s birthplace – countryMTHR_BRTH_ADDR_COUNTRY FORMCHECKBOX Father’s birthplace – cityFTHR_BRTH_ADDR_CITY FORMCHECKBOX Father’s birthplace – provinceFTHR_BRTH_ADDR_PROV FORMCHECKBOX Father’s birthplace – countryFTHR_BRTH_ADDR_COUNTRY FORMCHECKBOX Deceased’s occupationDCSD_OCCPN FORMCHECKBOX Deceased’s industryDCSD_INDTRY FORMCHECKBOX Deceased’s work yearsDCSD_WORK_YRS FORMCHECKBOX Underlying cause of death code and ICD versionUCOD_LABEL, UCOD_TYDF_CODE FORMCHECKBOX Nature of injury code and ICD versionNTUR_OF_INJ_LABEL,NTUR_OF_INJ_TYDF_CODE FORMCHECKBOX Illicit drug causeILLCT_DRUG_CS_LABEL FORMCHECKBOX Manner of deathDTH_MNNR_LABEL FORMCHECKBOX Death place type (e.g. home, street, healthcare facility)DTH_PLC_TP_LABEL FORMCHECKBOX End of life care place type (e.g. home, hospital)EOL_CARE_PLC_TP_LABEL FORMCHECKBOX Hospital of death study IDIf you are requesting identifiable hospital codes, please provide the reason below. FORMTEXT ?????HOSP_STUDY_ID FORMCHECKBOX Accidental death activity (e.g. work for income, leisure, sports)ACDNTL_DTH_ACTVY_LABEL FORMCHECKBOX Accident or violence placeACDNT_VLNC_PLC_LABEL FORMCHECKBOX Accident or violence year and monthIf you are requesting year, month, and day of accident or violence, please provide the reason below. FORMTEXT ?????ACDNT_VLNC_DATE FORMCHECKBOX Final illness year and monthIf you are requesting year, month, and day of final illness, please provide the reason below. FORMTEXT ?????FNL_ILLNS_DATE FORMCHECKBOX Recent surgery flag (within four weeks of death)RCNT_SURG_FLG FORMCHECKBOX Recent surgery year and monthIf you are requesting year, month, and day of recent surgery, please provide the reason below. FORMTEXT ?????SURG_DATE FORMCHECKBOX Postpartum death flag (43 days to one year postpartum)DTH_42_DAYS_TO_1_YR_PSTPRTM FORMCHECKBOX Postpartum death flag (up to 42 days postpartum)DTH_UP_TO_42_DAYS_PSTPRTM FORMCHECKBOX Death during pregnancy flagDTH_DURING_PRGCY_FLG FORMCHECKBOX Coroner notified flagCRNR_NOTFD_FLG FORMCHECKBOX Coroner waived flagCRNR_WAIVED_CASE_FLG FORMCHECKBOX Coroner viewed body flagVIEWED_BODY_FLG FORMCHECKBOX Autopsy being held flagATPSY_BEING_HELD_FLG FORMCHECKBOX Result from autopsy flagCAUSE_FROM_ATPSY_FLG FORMCHECKBOX Further information was available following autopsy flagFURTHER_INF_FLG FORMCHECKBOX Environmental or lifestyle flagENVMNTL_OR_LFSTYL_FLG FORMCHECKBOX Coronary bypass flagCRNRY_BYPASS_FLG FORMCHECKBOX Heart valve replaced flagHRT_VALVE_RPLCD_FLG FORMCHECKBOX Organ transplant recipient flagORGAN_TRNSPLT_RECIP_FLG FORMCHECKBOX Alcohol related flagALCL_REL_FLG FORMCHECKBOX Drug related flagDRUG_REL_FLGMEDICAL CODING DATAIn this data, one record represents one cause of death. Therefore, clients associated with multiple causes of death have multiple records.DATA FIELDVARIABLE NAME (MOH INTERNAL USE ONLY) FORMCHECKBOX Client study IDIf you are requesting PHNs instead of study IDs, please provide the reason below. FORMTEXT ?????CLNT_STUDY_ID FORMCHECKBOX Cause of death code with ICD version and cause type (immediate, antecedent, contributing, and lifestyle/ environmental exposure)ICD_DISS_CLS_LABEL,ICD_DISS_CLS_TYDF_CODE,CDG_SCTN_LABEL FORMCHECKBOX Record axis code (row and column number)ICD_PLC_ROW,MATRIX_COL_NUMOTHER INSTRUCTIONSPlease state other instructions if there are any. FORMTEXT ????? ................
................

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

Google Online Preview   Download