Appendix 1. Edit specifications for acute coronary care data

Quality Assessment of Acute Coronary Care Data in the WHO MONICA Project

Appendix 1. Edit specifications for acute coronary care data

Form 02
Version 6
Edit Specifications version 3, 26-Aug-1993

General

The MONICA Data Centre (MDC) checks all Acute Coronary Care data received from the MONICA Collaborating Centres (MCC) according to these edit specifications at the time when the data are included into the MONICA database. All possible inconsistencies revealed in the data are reported to the MCC using Form H: Computer Generated Error Correction Form, or by other means if the number of possible errors in the data is very large.

Explanations for the edit specifications:

Every record entered into the MDC database is subjected to the constraints listed below. If the data do not meet the conditions of the constraint, an error message will be generated. Such error messages are printed on a Computer Generated Error Correction Form (Form: H)

Data values which do not meet the conditions of a constraint, are either incorrect or unusual. All data values printed on the Computer Generated Error Correction Form should be checked from the source of the data. However, such values should not be changed unless they can be shown to be incorrect.

Items MANAGE, SURVIV, ECG, NUMECG, ENZYME, ESTST and THROMBD used in these edit specifications refer to the Coronary Event record (Form 01) with the same SERIAL number as in the record being checked.

CORONARY_EVENT_MISSING_2: The same serial number must be found from
Coronary Events data.
DBIRTH_MISMATCH_2: DBIRTH must be same as DBIRTH in Coronary Event record.
TIME_LIMITS_2: Accepted values for TIME are 1 to 9.
TIME_MANAGE_2: if MANAGE is 1,2,3 or 5 then 1 < TIME < 7 or TIME = 9.
TIME_EIGHT_CHECK__2: If TIME=8 then should be ACTIME=88888, INITC=1,6 or 8 and MANAGE=4.
ACTIME_LIMITS_2: ACTIME hours = 0:672,888,999 and mins = 0:59,88,99
ACTIME_TIME_2: If TIME=1 then 0 < ACTIME < 5 or ACTIME=99999 or 00099
If TIME=2 then 6 < ACTIME < 99 or ACTIME=99999
If TIME=3 then 100 < ACTIME < 199 or ACTIME=99999
If TIME=4 then 200 < ACTIME < 399 or ACTIME=99999
If TIME=5 then 400 < ACTIME < 2399 or ACTIME=99999
If TIME=6 then 2400 < ACTIME < 67199 or ACTIME=99999
If TIME=7 then ACTIME = 99 or ACTIME=99999
If TIME=9 then ACTIME = 99999.
INITC_LIMITS_2: Accepted values for INITC are 1 to 6, 8 and 9.
INITC_MANAGE_2: If MANAGE = 1,2,3 or 5 then 1 < INITC < 6 or INITC = 9.
CAROUT_LIMITS_2: Accepted values for CAROUT are 1, 2, 8 and 9.
CAROUT_RESOUT_2: If RESOUT=1 then CAROUT = 1
If CAROUT=2 or 8 then RESOUT = 8
If CAROUT=1 or 9 then RESOUT = 1,2 or 9
CAROUT_RESARR_2: If RESARR=1 then CAROUT = 1.
CAROUT_SURVIV_CHECK_2: If CAROUT=1 and RESOUT=2 and RESARR=2 then
SURVIV = 2.
MANAGE_CAROUT_2: If MANAGE=4 then CAROUT=1.
RESOUT_LIMITS_2: Accepted values for RESOUT are 1, 2, 8 and 9.
RESARR_LIMITS_2: Accepted values for RESARR are 1, 2, 8 and 9.
CARIN_LIMITS_2: Accepted values for CARIN are 1, 2, 8 and 9.
CARIN_RESIN_2: If RESIN=1 then CARIN=1.
If CARIN=2 or 8 then RESIN=8.
If CARIN=1 then RESIN=1,2 or 9.
CARIN_MANAGE_2: If MANAGE=2,3,4,5 or 9 then CARIN=2,8 or 9.
CARIN_SURVIV_CHECK_2: If CARIN=1 and RESIN=2 then SURVIV=2 must be 2.
RESIN_LIMITS_2: Accepted values for RESIN are 1, 2, 8 and 9.
SYSBP_LIMITS_2: Accepted values for SYSBP are 0, 30 to 270,888 and 999.
SYSBP_SURVIV_CHECK_2: If SYSBP=0 and RESOUT=2 or 8 and RESARR=2 or 8 and
RESIN=2 or 8 then SURVIV must be 2.
PULSE_LIMITS_2: Accepted values for PULSE are 0,20:300,888 and 999.
PULSE_SURVIV_CHECK_2: If PULSE=0 and RESOUT=2 or 8 and RESARR=2 or 8 and
RESIN=2 or 8 then SURVIV must be 2.
ECGSTE_LIMITS_2: Accepted values for ECGSTE are 1, 2, 8 and 9.
ECGSTD_LIMITS_2: Accepted values for ECGSTD are 1, 2, 8 and 9.
ECGEVO_LIMITS_2: Accepted values for ECGEVO are 1, 2, 8 and 9.
ECGANT_LIMITS_2: Accepted values for ECGANT are 1, 2, 8 and 9.
ECG_MISSING_OR_UNCODABLE_2: ECGSTE = 8 or 9 and ECGSTD=8 or 9 and ECGEVO=8 or 9 and
ECGANT=8,9 exactly when ECG=5 or 9.
ECG_DEFINITE_2: If ECG=1 then must be (ECGSTE=1 or ECGSTD=1 or
ECGEVO=1).
ECG_OTHER_2: If ECG=4 then must be (ECGSTE=2 and ECGSTD=2 and
ECGEVO=2 and ECGANT=2).
ECGSTE_NUMECG_2: If NUMECG=0 then must be ECGSTE=8 or 9.
ECGSTD_NUMECG_2: If NUMECG=0 then must be ECGSTD=8 or 9.
ECGEVO_NUMECG_2: If NUMECG=0 or 1 then must be ECGEVO=2,8 or 9.
ECGANT_NUMECG_2: If NUMECG=0 or 1 then must be ECGANT=2,8 or 9.
ECGEVO_ECG_2: If ECG=2 or 3 then must be ECGEVO=2,8 or 9.
ECGANT_ECG_2: If ECG = 3 then must be ECGANT=2,8 or 9.
CPK_LIMITS_2: Accepted values for CPK are 1 to 9999.
ENZYME_LEVEL_CHECK_2: If ( CPK > 199 or AST > 199 or HBD > 199 ) then ENZYME must
be 1,3 or 5. If ENZYME=1 or 3 then must be
( CPK > 199 or AST > 199 or HBD > 199 ).
ENZYME_EQUIVOCAL_2: If ENZYME=2 then must be
( 100< CPK <200 ) or (100< AST <200 ) or ( 100< HBD <200 )
AST_LIMITS_2: Accepted values for AST are 1 to 9999.
HBD_LIMITS_2: Accepted values for HBD are 1 to 9999.
SMOKE_LIMITS_2: Accepted values for SMOKE are 1,2 and 9.
CUNIT_LIMITS_2: Accepted values for CUNIT are 1,2,8 and 9
CSTAY_LIMITS_2: Accepted values for CSTAY are 0 TO 28 or 88 or 99
CUNIT_MANAGE_2: If 2 < MANAGE < 5 or MANAGE=9 then CUNIT should be 2,8 or
9.
CUNIT_TIME_2: If TIME=8 then CUNIT=2,8 or 9.
CUNIT_INITC_2: If INITC=8 then CUNIT=8.
CUNIT_CSTAY_2: If CSTAY=88 then CUNIT=2,8 or 9.
If CSTAY=99 then CUNIT=1 or 9.
If CUNIT=2 or 8 then CSTAY=88

DRUGS & PROCEDURES CHECKS

..B before the onset of the event

ANTARB_LIMITS_2 - ACEB_LIMITS_2: Accepted values for items ANTARB(27)-ACEB(42) are 1,2 or 9.
HSTAY_LIMITS_2: Accepted values for HSTAY are 00 to 28 or 88 or 99.
HSTAY_CSTAY_2: If 00<=CSTAY<=28 then must be CSTAY<=HSTAY<=28 or HSTAY=99.
HSTAY_MANAGE_2: MANAGE=2,3,4 or 5 is equivalent to HSTAY=88.
If MANAGE=9 then HSTAY=99.

..D during the event

ANTARD_LIMITS_2 - HYPOTD_LIMITS_2: Accepted values for items ANTARD(45)-HYPOTD(51) are 1,2,8 or 9
INOD_LIMITS_2: Accepted values for INOD are 1 to 9.
NITRD_LIMITS_2: Accepted values for NITRD are 1 to 4 or 8 or 9.
STREPD_LIMITS_2 - ACED_LIMITS_2: Accepted values for items STREPD(54)-ACED(60) are 1,2,8 or 9.
FINTD3_LIMITS_2 - FINTD4_LIMITS_2: Accepted value for FINTD3 and FINTD4 is 8.
ANTARD_MANAGE_2 - ACED_MANAGE_2: If MANAGE=4 then items ANTARD(45)-ACED(60)=2,8 or 9.
Violation of this constraint is not logically impossible, but the coding should be checked.
ANTARD_SURVIV_2 - HYPOTD_SURVIV_2: If SURVIV=1 or 9 then items ANTARD(45)-HYPOTD(51)=1,2 or 9.
INOD_SURVIV_LIMITS_2: If SURVIV=1 or 9 then INOD=1 to 7 or 9.
NITRD_SURVIV_LIMITS_2: If SURVIV=1 or 9 then NITRD=1 to 4 or 9.
STREPD_SURVIV_2 - ACED_SURVIV_2: If SURVIV=1 or 9 items STREPD(54)-ACED(60)=1,2 or 9.
ANTARD_ESTST_2 - ACED_ESTST_2: If ESTST=1 then items ANTARD(45)-ACED(60)=2 or 8.
Violation of this constraint is not logically impossible, but the coding should be checked.
STREPD_THROMBD_2: If STREPD=1 then THROMBD=1,7 or empty.
If STREPD=2 then THROMBD=2,7 or empty.
If STREPD=8 then THROMBD=7,8 or empty.
If STREPD=9 then THROMBD=7,9 or empty.
ANTARD_MANAGE_SURVIV_2 - ACED_MANAGE_SURVIV_2: ANTARD(45)-ACED(60)=8 is equivalent to (MANAGE=4 and
SURVIV=2)

..P post-event

ANTARP_LIMITS_2 - ACEP_LIMITS_2, REHABP_LIMITS_2: Accepted values for items ANTARP(63)-ACEP(75) and REHAB(78) are 1,2,8 or 9.
FINTP3_LIMITS_2: Accepted value for FINTP3 is 8.
PLOD_LIMITS_2: Accepted values for PLOD are 1 to 9.
ANTARP_SURVIV_2 - ACEP_SURVIV_2, REHABP_SURVIV_2: If SURVIV=1 or 9 then items ANTARP(63)-ACEP(75) and REHABP(78)=1,2 or 9.
PLOD_MANAGE_2: If PLOD=5,6 or 7 then MANAGE=1.
PLOD_SURVIV_2: SURVIV=1 is equivalent to PLOD=8.
If SURVIV=9 then PLOD=9.
ANTARP_ESTST_2 - ACEP_ESTST_2, REHABP_ESTST_2: If ESTST=1,2 or 4 then items ANTARP(63)-ACEP(75) and
REHABP(78)=8.