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.
Univariate checks |
| Constraint name | Description |
|---|
| CENTRE_LIMITS_88 | Accepted values for CENTRE are: 11, 12, 19, 20, 22, 26, 31, 32, 34, 35, 36, 37, 39, 45, 47, 54, 55, 57, 59, 60, 71, 72, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 99 |
|---|
| COHORT_LIMITS_88 | Accepted values for COHORT are: 01 to 03, 21 to 99 |
|---|
| RUNIT_LIMITS_88 | Accepted values for RUNIT are: 01 to 08 |
|---|
| SERIAL_LIMITS_88 | Accepted values for SERIAL are: 1 to 999999 |
|---|
| SEX_LIMITS_88 | Accepted values for SEX are: 1 to 2 |
|---|
| DIAB1_FU_LIMITS_84 | Accepted values for DIAB1_FU are: 1, 2 |
|---|
| DIAB1_STATUS_LIMITS_84 | Accepted values for DIAB1_STATUS are: 1, 2, 8 |
|---|
| DIAB2_FU_LIMITS_84 | Accepted values for DIAB2_FU are: 1, 2 |
|---|
| DIAB2_STATUS_LIMITS_84 | Accepted values for DIAB2_STATUS are: 1, 2, 8 |
|---|
| DIAB3_FU_LIMITS_84 | Accepted values for DIAB3_FU are: 1, 2 |
|---|
| DIAB3_STATUS_LIMITS_84 | Accepted values for DIAB3_STATUS are: 1, 2, 8 |
|---|
| EVENT_LIMITS_84 | Accepted values for EVENT are: 88 |
|---|
| FORM_LIMITS_84 | Accepted values for FORM are: 84 |
|---|
| VERSN_LIMITS_84 | Accepted values for VERSN are: 1 |
|---|
Multivariate checks |
| Constraint name | Description |
|---|
| COHORT_CENTRE_88 |
If CENTRE = 11 then COHORT should be: 01, 02, 03 |
| If CENTRE = 12 then COHORT should be: 01, 02, 03 |
| If CENTRE = 19 then COHORT should be: 01, 02, 03, 42, 43 |
| If CENTRE = 20 then COHORT should be: 01, 02, 03, 24, 25, 26, 34, 42, 43, 44, 45, 46, 52, 53, 54, 55, 62, 63, 64, 72, 73, 82 |
| If CENTRE = 22 then COHORT should be: 21 |
| If CENTRE = 26 then COHORT should be: 01, 02, 03, 24, 33, 34, 42, 52 |
| If CENTRE = 31 then COHORT should be: 01, 21, 22, 23, 24, 25, 42, 43 |
| If CENTRE = 32 then COHORT should be: 01, 02, 03, 21 |
| If CENTRE = 34 then COHORT should be: 21 |
| If CENTRE = 35 then COHORT should be: 01, 02, 03, 21, 42, 43 |
| If CENTRE = 36 then COHORT should be: 01, 02, 03 |
| If CENTRE = 37 then COHORT should be: 01, 02, 03, 21 |
| If CENTRE = 39 then COHORT should be: 01, 02, 03 |
| If CENTRE = 45 then COHORT should be: 01, 02, 03, 31, 32, 33, 34, 35 |
| If CENTRE = 47 then COHORT should be: 01, 02, 03, 21 |
| If CENTRE = 54 then COHORT should be: 21 |
| If CENTRE = 55 then COHORT should be: 21 |
| If CENTRE = 57 then COHORT should be: 01, 02, 03, 21 |
| If CENTRE = 59 then COHORT should be: 21 |
| If CENTRE = 60 then COHORT should be: 01, 02, 03, 24 to 26, 42 to 44, 52 to 54, 62 to 64, 72 to 74, 84 |
| If CENTRE = 71 then COHORT should be: 21 |
| If CENTRE = 72 then COHORT should be: 21, 43 |
| If CENTRE = 73 then COHORT should be: 21 |
| If CENTRE = 74 then COHORT should be: 21, 31, 42, 43 |
| If CENTRE = 75 then COHORT should be: 21 |
| If CENTRE = 76, 79 then COHORT should be: 21 |
| If CENTRE = 78 then COHORT should be: 21, 43, 45, 46 |
| If CENTRE = 83 then COHORT should be: 24, 42, 43, 44 |
| If CENTRE = 84 then COHORT should be: 21, 42, 43 |
| If CENTRE = 99 then COHORT should be: 01, 02, 03, 21 |
| RUNIT_CENTRE_88 |
If CENTRE = 12 then RUNIT should be: 01, 02 |
| If CENTRE = 19 then RUNIT should be: 01 |
| If CENTRE = 20 then RUNIT should be: 02, 03, 05, 06, 07, 08 |
| If CENTRE = 22, 37 then RUNIT should be: 01, 02, 03 |
| If CENTRE = 26 then RUNIT should be: 03 |
| If CENTRE = 31 then RUNIT should be: 01, 02, 03, 04 |
| If CENTRE = 32 then RUNIT should be: 01, 02, 03, 04, 05, 06 |
| If CENTRE = 34, 54, 55, 59 then RUNIT should be: 01 |
| If CENTRE = 35 then RUNIT should be: 01, 02, 03 |
| If CENTRE = 36 then RUNIT should be: 01, 02 |
| If CENTRE = 39 then RUNIT should be: 03 |
| If CENTRE = 45 then RUNIT should be: 01 |
| If CENTRE = 47 then RUNIT should be: 01, 03 |
| If CENTRE = 57 then RUNIT should be: 01, 02, 04, 05 |
| If CENTRE = 60 then RUNIT should be: 01, 02 |
| If CENTRE = 71, 78, 79, 80, 84 then RUNIT should be: 01 |
| If CENTRE = 72 then RUNIT should be: 01 |
| If CENTRE = 73 then RUNIT should be: 01, 02, 03 |
| If CENTRE = 74 then RUNIT should be: 01 |
| If CENTRE = 75 then RUNIT should be: 01 |
| If CENTRE = 76 then RUNIT should be: 01, 02 |
| If CENTRE = 83 then RUNIT should be: 04 |
| DIAB1_EXIT_DIAB1_FU_84 |
If DIAB1_EXIT = 88888888 then DIAB1_FU should be: 2 |
| DIAB1_STATUS_DIAB1_FU_84 |
If DIAB1_STATUS = 8 then DIAB1_FU should be: 2 |
| DIAB2_EXIT_DIAB2_FU_84 |
If DIAB2_EXIT = 88888888 then DIAB2_FU should be: 2 |
| DIAB2_STATUS_DIAB2_FU_84 |
If DIAB2_STATUS = 8 then DIAB2_FU should be: 2 |
| DIAB3_EXIT_DIAB3_FU_84 |
If DIAB3_EXIT = 88888888 then DIAB3_FU should be: 2 |
| DIAB3_STATUS_DIAB3_FU_84 |
If DIAB3_STATUS = 8 then DIAB3_FU should be: 2 |
