Availability of CA-EDRS Data In AVSS

 

 

AVSS is now importing death certificate data from Californiaís Electronic Death Registration System (CA-EDRS).The imports are done on a weekly basis as soon as the EDRS data are available from the Office of Vital Records (OVR). At the present time the data are available in AVSS within a few months after the date of death. It is hoped that the time lag will be reduced as EDRS is developed more fully.

 

Since EDRS is still evolving, the imported data may contain errors.The following errors are considered to be so serious that the EDR record is not imported into AVSS:

1. Year in state file number (SFN) and local file number (LFN) do not agree.

2. Date of death does not agree with year in SFN or LFN.

3. County of occurrence does not agree with LFN.

4. Record is too long or too short.

 

Rejected records are reported back to EDRS where corrections are made and the corrected records are then re-transmitted to AVSS.This ensures that key variables such as file numbers, data of death, and place of occurrence are reasonably accurate, but other EDRS variables may still be subject to significant errors. At the present time (March 2008), AVSS contains mostly complete EDRS data for 2005 and 2006, each with more than 237,000 deaths, and there are more than 180,000 death records for 2007.

 

AVSS staff in local registration districts (LRDs) may access EDRS data using the EDR Death Record Converted option or EDC record in the same manner they historically accessed AVSS death data using the Death Record (1994) or CDC record.Most of the important Death Record suboptions are now available for the EDR Death Record Converted option:

 

SYSTEM OPTION > EDR DEATH RECORD CONVERTED

EDR DEATH RECORD CONVERTED OPTION > ?

ENTER ENOUGH CHARACTERS TO IDENTIFY ONE OF THE FOLLOWING:

†††† DISPLAY CERTIFICATE

†††† ALPHA LIST OF CERTIFICATES

†††† FILING VARIABLE LIST

†††† VARIABLE DISPLAY

†††† INDEX LIST DISPLAY

†††† INDIVIDUAL INQUIRY

†††† MISSING FILE NUMBER REPORT

†††† AMENDMENT DISPLAY

†††† GENERATE EDRS TAB-DELIMITED FILE

†††† MISSING FILE NUMBER EDITOR

†††† BATCH CENSUS TRACT BY LFN RANGE

†††† BATCH CENSUS TRACT BY DATE RANGE

†††† INTERACTIVE CENSUS TRACTING OF REJECTS BY LFN

 

Similarly, LRD staff may now specify the EDC in the Query Database in the AVSS Report Generator to run reports on imported EDRS data:

SYSTEM OPTION > REPORT GENERATOR

REPORT GENERATOR OPTION > QUERY DATABASE

INITIALIZING............

FORM. SELECTION > EDC = EDR DEATH RECORD CONVERTED

 

There are also a number of AVSS standard reports that utilize the new EDC record.With the availability of cause of death data from EDC, a number of these reports are related to cause of death as shown in the example below.

REPORT GENERATOR OPTION > GENERATE REPORT

REP. REPORT > #EDC

1††† #EDCALCOHOL=ALCOHOL-RELATED DEATHS BY RESIDENCE

2††† #EDCCANCER=CANCER-RELATED CAUSE OF DEATH LISTING BY RESIDENCE

3††† #EDCCANCERB=FEMALE BREAST CANCER-RELATED CAUSE OF DEATH LISTING BY RESIDENCE

4†† #EDCCANCERL=LUNG CANCER-RELATED CAUSE OF DEATH LISTING BY RESIDENCE

5††† #EDCDIABETES=DIABETES-RELATED CAUSE OF DEATH LISTING BY RESIDENCE

6††† #EDCDRUG=DRUG-RELATED DEATHS BY RESIDENCE

7††† #EDCFIREARM=FIREARM-RELATED CAUSE OF DEATH LISTING BY RESIDENCE

8††† #EDCHOMICIDE=HOMICIDE-RELATED CAUSE OF DEATH LISTING BY RESIDENCE

9††† #EDCLST3=CAUSE OF DEATH LISTING BY LFN

10†† #EDCLST4=CAUSE OF DEATH BY DATE OF DEATH

11†† #EDCLST5=COUNTY DEATH LISTING BY NAME

12†† #EDCLST6=VS-200 LISTING: PERSONS OVER 18 YRS OF AGE

13†† #EDCLST7=VS-200 LISTING FOR ALL OCCURRENCES

14†† #EDCLST8=COUNTY DEATH LISTING BY NAME (#EDCLST5 W/O SSN)

15†† #EDCLST9=VS-200 LISTING: PERSONS OVER 18 YRS OF AGE (#EDCLST6 W/O ADDRESS)

16†† #EDCMVEHICLE=MOTOR VEHICLE-RELATED CAUSE OF DEATH LISTING BY RESIDENCE

17†† #EDCSUICIDE=SUICIDE-RELATED CAUSE OF DEATH LISTING BY RESIDENCE

18†† #EDCTOBACCO=TOBACCO-RELATED CAUSE OF DEATH LISTING BY RESIDENCE

 

SELECTION # > 16†† #EDCMVEHICLE = MOTOR VEHICLE-RELATED CAUSE OF DEATH LISTING

ENTER BEGINNING VALUE FOR DATE OF DEATH < 1/1/2007 >†† (1/1/2007)

ENTER††† ENDING VALUE FOR DATE OF DEATH < T > 1 7(1/7/2007)

 

 

††††††††††††††††† MOTOR VEHICLE-RELATED CAUSE OF DEATH LISTING BY RESIDENCE

††††††††††††††††† AVSS-OVRS California Department of HealthREPORT = #EDCMVEHICLE

DATE RANGE: 1/1/2007 TO 1/7/2007†††††††††††††††††††††† TODAY: 11/20/2007

 

LFN†††††††††† AGE MANNER†††††††††† CRNR PLACE OF DEATH†††††††††††† CITY OF DEATH

CAUSE OF DEATH (107A, 107B, 107C, 107D)

--------------------------------------------------------------------------------

320070400000622 ACCIDENT††††††††† Y†† ENLOE MEDICAL CENTER ESPLANADE CHICO

107A:MULTIPLE TRAUMA

107B:MOTOR VEHICLE COLLISION

 

32007040000491ACCIDENT††††††††† Y†† OROVILLE HOSPITAL†††††††††† OROVILLE

107A:MULTIPLE TRAUMA

107B:MOTOR VEHICLE COLLISION

 

320072700001363 ACCIDENT††††††††† Y†† ROADWAY†††††††††††††††††††† MARINA

107A:MULTIPLE BLUNT FORCE INJURIES

107B:MOTOR VEHICLE-PEDESTRIAN COLLISION

 

320072700006559 SUICIDE†††††††††† Y†† RESIDENCE††††††††††††† †††††MARINA

107A:ASPHYXIATION

107B:INHALATION OF AUTOMOBILE EXHAUST

 

320073300018631 ACCIDENT††††††††† Y†† KAISER FOUNDATION HOSP††††† RIVERSIDE

107A:OCCLUSION OF AIRWAY BY FOOD BOLUS

107B:DYSPHAGIA

107C:ANTERIOR DISCECTOMY WITH FUSION

107D:REMOTE MOTOR VEHICLE ACCIDENT WITH RESULTANT NECK INJURY

 

TOTAL NUMBER OF DEATHS:†††† 2334

TOTAL MOTOR VEHICLE-RELATED DEATHS:†††† 5(0.2%)

Return To AVSS Home Page