MORGAM logo

Edit specifications: Follow-up data

  • Form: 25
  • Form version: 4
  • Form date: 17.06.2002
  • Edit Specifications version: 1
  • Edit Specifications date: 10.05.2007

Valid HTML 4.01!

© National Institute for Health and Welfare and the MORGAM Project Investigators
Last updated: 06-06-2013
For more information, please contact Zygimantas Cepaitis (firstname.lastname@thl.fi) or Kari Kuulasmaa (firstname.lastname@thl.fi)

General

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.

Explanations for Edit Specifications

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.


Calculated variables used in Edit Specifications

VariableDescription
CORONARY_FATAL_EVENTFatal coronary events
CORONARY_FATAL_EVENT_DEATHDAFatal coronary events
STROKE_FATAL_EVENTFatal stroke events
STROKE_FATAL_EVENT_DEATHDAFatal stroke events
THROMBO_FATAL_EVENTFatal thromboembolic events
THROMBO_FATAL_EVENT_DEATHDAFatal thromboembolic events
FATAL_EVENTAny fatal event

Univariate checks

Constraint nameDescription
CENTRE_LIMITS_88Accepted 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_88Accepted values for COHORT are: 01 to 03, 21 to 99
RUNIT_LIMITS_88Accepted values for RUNIT are: 01 to 08
SERIAL_LIMITS_88Accepted values for SERIAL are: 1 to 999999
SEX_LIMITS_88Accepted values for SEX are: 1 to 2
DSOURCE_LIMITS_25Accepted values for DSOURCE are: 1, 2, 8, 9
EVENT_LIMITS_25Accepted values for EVENT are: 1 to 99
EXREAS_LIMITS_25Accepted values for EXREAS are: 1 to 5
FORM_LIMITS_25Accepted values for FORM are: 25
ICDVERD_LIMITS_25Accepted values for ICDVERD are: 1, 2, 3, 8
NECP_LIMITS_25Accepted values for NECP are: 1, 2, 8, 9
UCDSOUR_LIMITS_25Accepted values for UCDSOUR are: 1, 2, 8, 9
VERSN_LIMITS_25Accepted values for VERSN are: 4

Multivariate checks

Constraint nameDescription
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
DEATHDA_EXREAS_25 If DEATHDA = 888 then EXREAS should be: 2 to 5
If EXREAS = 2 to 5 then DEATHDA should be: 888
DEATHDB_EXREAS_25 If DEATHDB = 888 then EXREAS should be: 2 to 5
If EXREAS = 2 to 5 then DEATHDB should be: 888
DEATHDC_EXREAS_25 If DEATHDC = 888 then EXREAS should be: 2 to 5
If EXREAS = 2 to 5 then DEATHDC should be: 888
DEATHDO_EXREAS_25 If DEATHDO = 888 then EXREAS should be: 2 to 5
If EXREAS = 2 to 5 then DEATHDO should be: 888
DEATHDU_EXREAS_25 If DEATHDU = 888 then EXREAS should be: 2 to 5
If EXREAS = 2 to 5 then DEATHDU should be: 888
NECP_EXREAS_25 If EXREAS = 2 to 5 then NECP should be: 8
If NECP = 8 then EXREAS should be: 2 to 5
UCDSOUR_DEATHDU_25 If DEATHDU = 888 then UCDSOUR should be: 8
If UCDSOUR = 8 then DEATHDU should be: 888, NNN

Special checks

Constraint nameDescription
MBIRTH_LIMITS_88Month and year of birth should be between 01YYYY and 12YYYY or 99YYYY
where YYYY is between 1890 and 1990
DEATHDX_LIMITS_25Accepted values for DEATHD* (*=U, A, B, C, O) are alphabets
A to T or V to Z in the first place (if present)
and any number between 0 to 9 or NNN or 888
DSOURCE_8_DEATHDX_25If DSOURCE=8 then
DEATHDA = 888, NNN and
DEATHDB = 888, NNN and
DEATHDC = 888, NNN and
DEATHDO = 888, NNN
EXDATE_LIMITS_25EXDATE should be a date
ICDVERD_8_DEATHDX_25If ICDVERD = 8 then
DEATHDA = 888,NNN and
DEATHDB = 888,NNN and
DEATHDC = 888,NNN and
DEATHDO = 888,NNN and
DEATHDU = 888,NNN
ICDVERD_DEATHDA_25If ICDVERD = 1 then allowed values for DEATHDA are: NNN or ??? or E?? or Y??
If ICDVERD = 2 then allowed values for DEATHDA are: NNN or ??? or E?? or V??
If ICDVERD = 3 then allowed values for DEATHDA are: NNN or A?? to T?? or V?? to Z??
ICDVERD_DEATHDB_25If ICDVERD = 1 then allowed values for DEATHDB are: NNN or ??? or E?? or Y??
If ICDVERD = 2 then allowed values for DEATHDB are: NNN or ??? or E?? or V??
If ICDVERD = 3 then allowed values for DEATHDB are: NNN or A?? to T?? or V?? to Z??
ICDVERD_DEATHDC_25If ICDVERD = 1 then allowed values for DEATHDC are: NNN or ??? or E?? or Y??
If ICDVERD = 2 then allowed values for DEATHDC are: NNN or ??? or E?? or V??
If ICDVERD = 3 then allowed values for DEATHDC are: NNN or A?? to T?? or V?? to Z??
ICDVERD_DEATHDO_25If ICDVERD = 1 then allowed values for DEATHDO are: NNN or ??? or E?? or Y??
If ICDVERD = 2 then allowed values for DEATHDO are: NNN or ??? or E?? or V??
If ICDVERD = 3 then allowed values for DEATHDO are: NNN or A?? to T?? or V?? to Z??
ICDVERD_DEATHDU_25If ICDVERD = 1 then allowed values for DEATHDU are: NNN or ??? or E?? or Y??
If ICDVERD = 2 then allowed values for DEATHDU are: NNN or ??? or E?? or V??
If ICDVERD = 3 then allowed values for DEATHDU are: NNN or A?? to T?? or V?? to Z??