MORGAM logo

Edit specifications: Baseline Data Addition 2

  • Form: 30
  • Form version: 2
  • Form date: 17.02.2011
  • 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.


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
FASTING_LIMITS_30Accepted values for FASTING are: 1 to 3, 9
FIBRDL_LIMITS_30Accepted values for FIBRDL are: 100 to 998, 8888, 9999
FIBR_LIMITS_30Accepted values for FIBR are: 100 to 998, 8888, 9999
FORM_LIMITS_30Accepted values for FORM are: 30
ROUNDS_LIMITS_30Accepted values for ROUNDS are: 1 to 99
TRIGLDL_LIMITS_30Accepted values for TRIGLDL are: 27 to 98, 100 to 998, 1000 to 1005, 8888, 9999
TRIGL_LIMITS_30Accepted values for TRIGL are: 30 to 98, 100 to 998, 1000 to 1200, 8888, 9999
VERSN_LIMITS_30Accepted values for VERSN are: 2

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
FIBR_FIBRDL_30 If FIBR = 0 to 8887, 9999 then FIBRDL should be: 8888,9999
If FIBRDL = 0 to 8887, 9999 then FIBR should be: 8888,9999
TRIGL_TRIGLDL_30 If TRIGL = 0 to 8887, 9999 then TRIGLDL should be: 8888,9999
If TRIGLDL = 0 to 8887, 9999 then TRIGL should be: 8888,9999

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
DFIBR_LIMITS_30DFIBR should be a date DDMMYYYY or 99MMYYYY or 9999YYYY or 99999999.
where day DD is between 01 and 31 and
month MM is between 01 and 12 and
year YYYY is <= 2012
Note the following interpretations:
If DFIBR = 99MMYYYY then DFIBR = 28MMYYYY
If DFIBR = 9999YYYY then DFIBR = 3112YYYY
DTRIGL_LIMITS_30DTRIGL should be a date DDMMYYYY or 99MMYYYY or 9999YYYY or 99999999.
where day DD is between 01 and 31 and
month MM is between 01 and 12 and
year YYYY is <= 2012
Note the following interpretations:
If DTRIGL = 99MMYYYY then DTRIGL = 28MMYYYY
If DTRIGL = 9999YYYY then DTRIGL = 3112YYYY