The MORGAM Data Centre (MDC) checks the data of forms 22, 23, 25, 27 and 28 received from the MORGAM Participating Centres (MPC) according to these constraint specifications before the data will be imported into the MORGAM data base.
If there are inconsistencies in the data these are reported to the MPC by using Computer generated checking reports or by other means if the number of errors in the data is very large.
Data values which do not meet the conditions of a constraint, are either incorrect or unusual. The values printed on the Computer Generated Checking Report should be checked from the source of the data.
However, such values should not be changed unless they really are incorrect.
| Constraint name |
Description |
| DUPLICATE_KEY1_78 |
Duplicate Key1 (CENTRE + RUNIT + COHORT + SERIAL) found in data file. |
| DUPLICATE_EVENT_78 |
Duplicate Key1 (CENTRE + RUNIT + COHORT + SERIAL) and EVENT 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. |
| EVDATE22_EXDATE25_78 |
If SURVIV=2 then EVDATE(of form 22) <= EXDATE(of form 25) |
| EVDATE22_EXDATEC27_78 |
If SURVIV=1,8 then EVDATE(of form 22) <= EXDATEC(of form 27) |
| EVDATE23_EXDATE25_78 |
If SURV28=2 then EVDATE(of form 23) <= EXDATE(of form 25) |
| EVDATE23_EXDATES28_78 |
If SURV28=1 then EVDATE(of form 23) <= EXDATES(of form 28) |
| EVENT22_COREV27_78 |
COREV of form27 does not match with number of forms in form22 |
| EVENT23_STROKES28_78 |
STROKES of form28 does not match with number of forms in form23 |
| EXDATEC27_EXDATE25_78 |
If EXDATEC (of form 27) <>88888888 then EXDATEC (of form 27) <= EXDATE (of form 25) |
| EXDATEC27_EXREASC27_EXDATE25_78 |
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_78 |
If EXDATES (of form 28) <>88888888 then EXDATES (of form 28) <= EXDATE (of form 25) |
| EXDATES28_EXREASS28_EXDATE25_78 |
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_KEY1_78 |
Illegal Key1 (CENTRE + RUNIT + COHORT + SERIAL) found in data file:
This Key1 does not exist in Form 25 data. |
| NECSUM_SURVIV_EVTYP22_NECP25_78 |
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_78 |
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_78 |
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 |
| SURV28_EXREAS25_78 |
SURV28 in Form23 = 2, but exit reason (EXREAS in Form25) is not 1 (death) |
| SURVIV22_EXREAS25_78 |
SURVIV in Form22 = 2, but exit reason (EXREAS in Form25) is not 1 (death) |
| SURVIV22_ICDVER_DEATHD25_78 |
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_78 |
if NECP (of Form25) = 1 then NECSUM (of Form22) should not be = 8 |
| SURVIV23_ICDVER_DEATHD25_78 |
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 |
| SURVIV22_NECSUM22_NECP25_78 |
if NECSUM (of Form22) = 8 then NECP (of Form 25) should be 2,8,9 |
