The MORGAM Data Centre (MDC) checks all data received from the MORGAM Participating Centres (MPC) according to these edit specifications at the time when the data are included into the MORGAM data base. All possible inconsistencies revealed in the data are reported to the MPC using Computer Generated Error Correction Form, or by other means if the number of possible errors in the data is very large.
Every record entered into the MDC data base 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.
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.
Special checks |
| Constraint name | Description |
|---|
| DUPLICATE_EVENT_78 | Duplicate Key1 and event (Centre + Runit + Cohort + Serial and event) found in data file.
|
|---|
| DUPLICATE_KEY1_78 | Duplicate Key1 (Centre + Runit + Cohort + Serial) found in data file.
|
|---|
| EVENT_DAYS27_22_78 | Check: difference between 2 events should be more than 27 days.
|
|---|
| EVENT_DAYS27_23_78 | Check: difference between 2 events should be more than 27 days.
|
|---|
| ILLEGAL_KEY1_78 | Illegal Key1 (Centre + Runit + Cohort + Serial) found in data file.
This Key1 does not exist in Form 25 data.
|
|---|
| DFIBR_DEXAM20_77 | DFIBR should be a date DDMMYYYY or 99MMYYYY or 9999YYYY or 99999999.
If DFIBR < 99999999 it should be between DEXAM (in Form 20) and 31.12.2011
Note the following interpretations:
If DFIBR = 99MMYYYY then DFIBR = 28MMYYYY
If DFIBR = 9999YYYY then DFIBR = 3112YYYY |
|---|
| DTRIGL_DEXAM20_77 | DTRIGL should be a date DDMMYYYY or 99MMYYYY or 9999YYYY or 99999999.
If DTRIGL < 99999999 it should be between DEXAM (in Form 20) and 31.12.2011
Note the following interpretations:
If DTRIGL = 99MMYYYY then DTRIGL = 28MMYYYY
If DTRIGL = 9999YYYY then DTRIGL = 3112YYYY |
|---|
| DUPLICATE_KEY1R_77 | Duplicate Key1R (Centre + Runit + Cohort + Serial + Rounds) found in data file.
|
|---|
| EVDATE22_EXDATE25_77 | If SURVIV=2 then EVDATE(of form 22) <= EXDATE(of form 25) |
|---|
| EVDATE22_EXDATEC27_77 | If SURVIV=1,8 then EVDATE(of form 22) <= EXDATEC(of form 27) |
|---|
| EVDATE23_EXDATE25_77 | If SURV28=2 then EVDATE(of form 23) <= EXDATE(of form 25) |
|---|
| EVDATE23_EXDATES28_77 | If SURV28=1 then EVDATE(of form 23) <= EXDATES(of form 28) |
|---|
| EVENT22_COREV27_77 | COREV of form27 does not match with number of forms in form22
|
|---|
| EVENT23_STROKES28_77 | STROKES of form28 does not match with number of forms in form23
|
|---|
| EXDATEC27_EXDATE25_77 | If EXDATEC (of form 27) <>88888888 then
EXDATEC (of form 27) <= EXDATE (of form 25) |
|---|
| EXDATEC27_EXREASC27_EXDATE25_77 | If EXDATE(of form 25) = EXDATEC (of form 27) then EXREASC=8
If EXREASC=8 then EXDATE (of form 25) = EXDATEC (of form 27) or
EXDATEC (of form 27) = 88888888 |
|---|
| EXDATES28_EXDATE25_77 | If EXDATES (of form 28) <>88888888 then
EXDATES (of form 28) <= EXDATE (of form 25) |
|---|
| EXDATES28_EXREASS28_EXDATE25_77 | If EXDATE(of form 25) = EXDATES (of form 28) then EXREASS=8
If EXREASS=8 then EXDATE (of form 25) = EXDATES (of form 28) or EXDATES (of Form 28) = 88888888 |
|---|
| ILLEGAL_KEY1R_77 | Illegal Key1R (Centre + Runit + Cohort + Serial + Rounds) found in data file.
This Key1R does not exist in Form 20 data.
|
|---|
| MBIRTH20_MBIRTH21_77 | Check between MBIRTH of Form 21 and Form 20.
MBIRTH(of form 21)=MBIRTH(of form 20) |
|---|
| MBIRTH20_MBIRTH22_77 | Check between MBIRTH of Form 22 and Form 20.
MBIRTH(of form 22)=MBIRTH(of form 20) |
|---|
| MBIRTH20_MBIRTH23_77 | Check between MBIRTH of Form 23 and Form 20.
MBIRTH(of form 23)=MBIRTH(of form 20) |
|---|
| MBIRTH20_MBIRTH25_77 | Check between MBIRTH of Form 25 and Form 20.
MBIRTH(of form 25)=MBIRTH(of form 20) |
|---|
| MBIRTH20_MBIRTH27_77 | Check between MBIRTH of Form 27 and Form 20.
MBIRTH(of form 27)=MBIRTH(of form 20) |
|---|
| MBIRTH20_MBIRTH28_77 | Check between MBIRTH of Form 28 and Form 20.
MBIRTH(of form 28)=MBIRTH(of form 20) |
|---|
| MBIRTH20_MBIRTH30_77 | Check between MBIRTH of Form 30 and Form 20.
MBIRTH(of form 30)=MBIRTH(of form 20) |
|---|
| MBIRTH20_MBIRTH32_77 | Check between MBIRTH of Form 32 and Form 20.
MBIRTH(of form 32)=MBIRTH(of form 20) |
|---|
| MBIRTH20_MBIRTH81_77 | Check between MBIRTH of Form 81 and Form 20.
MBIRTH(of form 81)=MBIRTH(of form 20) |
|---|
| MBIRTH20_MBIRTH82_77 | Check between MBIRTH of Form 82 and Form 20.
MBIRTH(of form 82)=MBIRTH(of form 20) |
|---|
| MBIRTH20_MBIRTH83_77 | Check between MBIRTH of Form 83 and Form 20.
MBIRTH(of form 83)=MBIRTH(of form 20) |
|---|
| MBIRTH20_MBIRTH84_77 | Check between MBIRTH of Form 84 and Form 20.
MBIRTH(of form 84)=MBIRTH(of form 20) |
|---|
| MBIRTH20_MBIRTH85_77 | Check between MBIRTH of Form 85 and Form 20.
MBIRTH(of form 85)=MBIRTH(of form 20) |
|---|
| MBIRTH20_MBIRTH86_77 | Check between MBIRTH of Form 86 and Form 20.
MBIRTH(of form 86)=MBIRTH(of form 20) |
|---|
| NECSUM_SURVIV_EVTYP22_NECP25_77 | If NECSUM (of form 22)=8 then
SURVIV(of form 22)=1 or NECP(of form 25)=2, 8 or 9 or EVTYPE(of form 22)=1, 2 |
|---|
| NF_CORONARY_DURING_28DAYS_A_77 | Non-fatal event recorded within 28 days of DEATH
In case of more than one event for a person
if (EXREAS of Form25) = 1 and DEATHDU (of Form25) not in (NNN,888)
and SURVIV (of Form22) = 1 then ((EXDATE of Form25) - EVDATE (of Form22)) > 27
|
|---|
| NF_STROKES_DURING_28DAYS_A_77 | Non-fatal event recorded within 28 days of DEATH
In case of more than one event for a person
if (EXREAS of Form25) = 1 and DEATHDU (of Form25) not in (NNN,888)
and SURV28 (of Form23) = 1 then ((EXDATE of Form25) - EVDATE (of Form23)) > 27
|
|---|
| REMENOP21_MENOP20_77 | Check between REMENOP of form 21 and MENOP of form 20
MENOP (of form 20) = 1 or 2 or 8 <=> REMENOP (of form 21)=8 |
|---|
| ROUNDS20_ROUNDS21_77 | Check between ROUNDS of Form 20 and Form 21.
ROUNDS(of form 20)=ROUNDS(of form 21) |
|---|
| ROUNDS20_ROUNDS30_77 | Check between ROUNDS of Form 20 and Form 30.
ROUNDS(of form 20)=ROUNDS(of form 30) |
|---|
| ROUNDS20_ROUNDS32_77 | Check between ROUNDS of Form 20 and Form 32.
ROUNDS(of form 20)=ROUNDS(of form 32) |
|---|
| SEX20_SEX21_77 | Check between SEX of Form 20 and Form 21.
SEX(of form 20) = SEX(of form 21) |
|---|
| SEX20_SEX22_77 | Check between SEX of Form 20 and Form 22.
SEX(of form 20) = SEX(of form 22) |
|---|
| SEX20_SEX23_77 | Check between SEX of Form 20 and Form 23.
SEX(of form 20) = SEX(of form 23) |
|---|
| SEX20_SEX25_77 | Check between SEX of Form 20 and Form 25.
SEX(of form 20) = SEX(of form 25) |
|---|
| SEX20_SEX27_77 | Check between SEX of Form 20 and Form 27.
SEX(of form 20) = SEX(of form 27) |
|---|
| SEX20_SEX28_77 | Check between SEX of Form 20 and Form 28.
SEX(of form 20) = SEX(of form 28) |
|---|
| SEX20_SEX30_77 | Check between SEX of Form 20 and Form 30.
SEX(of form 20) = SEX(of form 21) |
|---|
| SURV28_EXREAS25_77 | SURV28 in Form23 = 2, but exit reason (EXREAS in Form25) is not 1 (death)
|
|---|
| SURVIV22_EXREAS25_77 | SURVIV in Form22 = 2, but exit reason (EXREAS in Form25) is not 1 (death)
|
|---|
| SURVIV22_ICDVER_DEATHD25_77 | If SURVIV (of Form 22) = 2 and DSOUR1 (of Form 22) = 2 and DSOUR2 (of Form 22) = 2
then DEATHDU or DEATHDA or DEATHDB or DEATHDC or DEATHDO (of Form 25)
should be:
410 to 414 or 795 if ICDVERD (of Form 25) = 1
410 to 414 or 798 if ICDVERD (of Form 25) = 2
I20 to I25 or I46, R96, R98, R99 if ICDVERD (of Form 25) = 3 |
|---|
| SURVIV22_NECP25_NECSUM22_77 | if NECP (of Form25) = 1 then NECSUM (of Form22) should not be = 8
|
|---|
| SURVIV22_NECSUM22_NECP25_77 | if NECSUM (of Form22) = 8 then NECP (of Form 25) should be 2,8,9
|
|---|
| SURVIV23_ICDVER_DEATHD25_77 | If (SURV7 (of Form 23) = 2 or SURV28 (of Form 23) = 2) and DGSOUR1 (of Form 23) = 2 and DGSOUR2 (of Form 23) = 2
then DEATHDU or DEATHDA or DEATHDB or DEATHDC or DEATHDO (of Form 25)
should be:
430 to 438 if ICDVERD (of Form 25) = 1 or 2
I60 to I67 or I69 if ICDVER (of Form 25) = 3 |
|---|
