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 Health  REPORT = #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)

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

3200704000006  22 ACCIDENT          Y   ENLOE MEDICAL CENTER ESPLANADE CHICO

 107A:MULTIPLE TRAUMA

 107B:MOTOR VEHICLE COLLISION

 

3200704000049  1  ACCIDENT          Y   OROVILLE HOSPITAL           OROVILLE

 107A:MULTIPLE TRAUMA

 107B:MOTOR VEHICLE COLLISION

 

3200727000013  63 ACCIDENT          Y   ROADWAY                     MARINA

 107A:MULTIPLE BLUNT FORCE INJURIES

 107B:MOTOR VEHICLE-PEDESTRIAN COLLISION

 

3200727000065  59 SUICIDE           Y   RESIDENCE                   MARINA

 107A:ASPHYXIATION

 107B:INHALATION OF AUTOMOBILE EXHAUST

 

3200733000186  31 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