Routine data checking criteria

MORGAM logo

Edit specifications: Additional baseline data

  • Form: 21
  • Form version: 5
  • 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
ALCAVE_LIMITS_21Accepted values for ALCAVE are: 000 to 098, 100 to 998, 888, 999
ALCPAT_LIMITS_21Accepted values for ALCPAT are: 1 to 6, 9
ALCPROB_LIMITS_21Accepted values for ALCPROB are: 000 to 100, 888, 999
ALCPROS_LIMITS_21Accepted values for ALCPROS are: 000 to 100, 888, 999
ALCPROW_LIMITS_21Accepted values for ALCPROW are: 000 to 100, 888, 999
CONSANY_LIMITS_21Accepted values for CONSANY are: 1 to 3, 8
CONSCHD_LIMITS_21Accepted values for CONSCHD are: 1 to 3, 8
CONSSTR_LIMITS_21Accepted values for CONSSTR are: 1 to 3, 8
CONSTED_LIMITS_21Accepted values for CONSTED are: 1 to 3, 8
CPAINDO_LIMITS_21Accepted values for CPAINDO are: 1, 2, 8, 9
CPAINHS_LIMITS_21Accepted values for CPAINHS are: 1, 2, 8, 9
CPAINOP_LIMITS_21Accepted values for CPAINOP are: 1, 2, 8, 9
CPAINST_LIMITS_21Accepted values for CPAINST are: 1, 2, 8, 9
CPAINUP_LIMITS_21Accepted values for CPAINUP are: 1 to 3, 8, 9
CPAIN_LIMITS_21Accepted values for CPAIN are: 1, 2, 9
CPLOC1_LIMITS_21Accepted values for CPLOC1 are: 1, 2, 8, 9
CPLOC2_LIMITS_21Accepted values for CPLOC2 are: 1, 2, 8, 9
CPLOC3_LIMITS_21Accepted values for CPLOC3 are: 1, 2, 8, 9
CPLOC4_LIMITS_21Accepted values for CPLOC4 are: 1, 2, 8, 9
CPLOC5_LIMITS_21Accepted values for CPLOC5 are: 1, 2, 8, 9
CPLOCE_LIMITS_21Accepted values for CPLOCE are: 1, 2, 8, 9
CTRY_LIMITS_21Accepted values for CTRY are: 1, 2, 9
DNAAV_LIMITS_21Accepted values for DNAAV are: 1 to 3, 8, 9
DNAREAS_LIMITS_21Accepted values for DNAREAS are: 1 to 4, 8, 9
EMPLOY_LIMITS_21Accepted values for EMPLOY are: 1 to 5, 9
ETHNIC_LIMITS_21Accepted values for ETHNIC are: 1, 2, 9
EVENT_LIMITS_21Accepted values for EVENT are: 88
FHISCHD_LIMITS_21Accepted values for FHISCHD are: 1, 2, 9
FHISSTR_LIMITS_21Accepted values for FHISSTR are: 1, 2, 9
FORM_LIMITS_21Accepted values for FORM are: 21
HISAP1_LIMITS_21Accepted values for HISAP1 are: 1, 2, 9
HISAP2_LIMITS_21Accepted values for HISAP2 are: 1, 2, 9
HISAP3_LIMITS_21Accepted values for HISAP3 are: 1, 2, 9
HISDIAB_LIMITS_21Accepted values for HISDIAB are: 1, 2, 9
HISMI1_LIMITS_21Accepted values for HISMI1 are: 1, 2, 9
HISMI2_LIMITS_21Accepted values for HISMI2 are: 1, 2, 9
HISMI3_LIMITS_21Accepted values for HISMI3 are: 1, 2, 9
HISMI4_LIMITS_21Accepted values for HISMI4 are: 1, 2, 9
HISREV1_LIMITS_21Accepted values for HISREV1 are: 1, 2, 9
HISREV2_LIMITS_21Accepted values for HISREV2 are: 1, 2, 9
HISSTR1_LIMITS_21Accepted values for HISSTR1 are: 1, 2, 9
HISSTR2_LIMITS_21Accepted values for HISSTR2 are: 1, 2, 9
HISUC_LIMITS_21Accepted values for HISUC are: 1, 2, 9
MINN1A_LIMITS_21Accepted values for MINN1A are: 100, 110 to 113, 120 to 123, 128, 130, 131, 133, 199
MINN1B_LIMITS_21Accepted values for MINN1B are: 100, 110 to 112, 114, 115, 120 to 126, 130, 131, 134 to 136, 199
MINN1C_LIMITS_21Accepted values for MINN1C are: 100, 110 to 112, 116, 117, 120 to 122, 127, 128, 130 to 132, 199
MINN1U_LIMITS_21Accepted values for MINN1U are: 100, 110 to 117, 120 to 128, 130 to 136, 188, 199
MINN2_LIMITS_21Accepted values for MINN2 are: 20 to 25, 29
MINN3_LIMITS_21Accepted values for MINN3 are: 30 to 34, 39
MINN4A_LIMITS_21Accepted values for MINN4A are: 400, 410 to 412, 420, 430, 440, 499
MINN4B_LIMITS_21Accepted values for MINN4B are: 400, 410 to 412, 420, 430, 440, 499
MINN4C_LIMITS_21Accepted values for MINN4C are: 400, 410 to 412, 420, 430, 440, 499
MINN4U_LIMITS_21Accepted values for MINN4U are: 400, 410 to 412, 420, 430, 440, 488, 499
MINN5A_LIMITS_21Accepted values for MINN5A are: 50 to 54, 59
MINN5B_LIMITS_21Accepted values for MINN5B are: 50 to 54, 59
MINN5C_LIMITS_21Accepted values for MINN5C are: 50 to 54, 59
MINN5U_LIMITS_21Accepted values for MINN5U are: 50 to 54, 58, 59
MINN6_LIMITS_21Accepted values for MINN6 are: 600, 610, 620 to 623, 630, 640 to 642, 650, 660, 680, 699
MINN7_LIMITS_21Accepted values for MINN7 are: 700, 710 to 712, 720 to 722, 730, 740, 750, 760, 770, 780, 799
MINN8_LIMITS_21Accepted values for MINN8 are: 800, 810 to 815, 820 to 824, 830 to 834, 840 to 842, 850 to 852, 860 to 864, 870, 880, 890, 899
MINN9A_LIMITS_21Accepted values for MINN9A are: 90, 92, 99
MINN9B_LIMITS_21Accepted values for MINN9B are: 90, 92, 99
MINN9C_LIMITS_21Accepted values for MINN9C are: 90, 92, 99
MINN9M_LIMITS_21Accepted values for MINN9M are: 900, 910, 930, 940 to 942, 950, 980 to 982, 999
MINN9U_LIMITS_21Accepted values for MINN9U are: 90, 92, 98, 99
NPREGNA_LIMITS_21Accepted values for NPREGNA are: 00 to 08, 10 to 19, 88, 99
PARCTRY_LIMITS_21Accepted values for PARCTRY are: 1, 2, 9
PARITY_LIMITS_21Accepted values for PARITY are: 00 to 08, 10 to 19, 88, 99
PREGNA_LIMITS_21Accepted values for PREGNA are: 1, 2, 8, 9
REMENOP_LIMITS_21Accepted values for REMENOP are: 1 to 4, 8, 9
ROUNDS_LIMITS_21Accepted values for ROUNDS are: 1 to 99
TREDIAB_LIMITS_21Accepted values for TREDIAB are: 1 to 3, 8, 9
VERSN_LIMITS_21Accepted values for VERSN are: 5
WKSET_LIMITS_21Accepted values for WKSET are: 1 to 4, 8, 9
WKTYPE_LIMITS_21Accepted values for WKTYPE are: 1 to 3, 8, 9

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
ALCPAT_ALCAVE_21 If ALCAVE = 001 to 998 then ALCPAT should be: 3 to 6, 9
ALCPROB_ALCAVE_21 If ALCAVE = 000, 999 then ALCPROB should be: 888
If ALCPROB = 888 then ALCAVE should be: 000, 999
ALCPROS_ALCAVE_21 If ALCAVE = 000, 999 then ALCPROS should be: 888
If ALCPROS = 888 then ALCAVE should be: 000, 999
ALCPROW_ALCAVE_21 If ALCAVE = 000, 999 then ALCPROW should be: 888
If ALCPROW = 888 then ALCAVE should be: 000, 999
CPAINDO_CPAINST_21 If CPAINST = 8 then CPAINDO should be: 2, 8, 9
CPAINDO_CPAIN_21 If CPAIN = 2 then CPAINDO should be: 8, 9
CPAINHS_CPAIN_21 If CPAIN = 2 then CPAINHS should be: 8, 9
CPAINHS_CPLOC1_21 If CPLOC1 = 8 then CPAINHS should be: 2, 8, 9
CPAINHS_CPLOC2_21 If CPLOC2 = 8 then CPAINHS should be: 2, 8, 9
CPAINHS_CPLOC3_21 If CPLOC3 = 8 then CPAINHS should be: 2, 8, 9
CPAINHS_CPLOC4_21 If CPLOC4 = 8 then CPAINHS should be: 2, 8, 9
CPAINHS_CPLOC5_21 If CPLOC5 = 8 then CPAINHS should be: 2, 8, 9
CPAINHS_CPLOCE_21 If CPLOCE = 8 then CPAINHS should be: 2, 8, 9
CPAINOP_CPAINDO_21 If CPAINDO = 8 then CPAINOP should be: 2, 8, 9
CPAINOP_CPAIN_21 If CPAIN = 2 then CPAINOP should be: 8, 9
CPAINST_CPAINHS_21 If CPAINHS = 8 then CPAINST should be: 2, 8, 9
CPAINST_CPAIN_21 If CPAIN = 2 then CPAINST should be: 8, 9
CPAINUP_CPAINOP_21 If CPAINOP = 8 then CPAINUP should be: 2, 8, 9
CPAINUP_CPAIN_21 If CPAIN = 2 then CPAINUP should be: 8, 9
CPAIN_CPAINUP_21 If CPAINUP = 8 then CPAIN should be: 2, 9
CPLOC1_CPAIN_21 If CPAIN = 2 then CPLOC1 should be: 8, 9
CPLOC2_CPAIN_21 If CPAIN = 2 then CPLOC2 should be: 8, 9
CPLOC3_CPAIN_21 If CPAIN = 2 then CPLOC3 should be: 8, 9
CPLOC4_CPAIN_21 If CPAIN = 2 then CPLOC4 should be: 8, 9
CPLOC5_CPAIN_21 If CPAIN = 2 then CPLOC5 should be: 8, 9
CPLOCE_CPAIN_21 If CPAIN = 2 then CPLOCE should be: 8, 9
DNAAV_CONSANY_21 If CONSANY = 8 then DNAAV should be: 2, 3, 8, 9
DNAAV_CONSCHD_21 If CONSCHD = 8 then DNAAV should be: 2, 3, 8, 9
DNAAV_CONSSTR_21 If CONSSTR = 8 then DNAAV should be: 2, 3, 8, 9
DNAAV_CONSTED_21 If CONSTED = 8 then DNAAV should be: 2, 3, 8, 9
DNAAV_DNAREAS_21 If DNAREAS = 8 then DNAAV should be: 1, 3, 8, 9
DNAREAS_DNAAV_21 If DNAAV = 1, 3, 8, 9 then DNAREAS should be: 8
MINN1A_MINN3_1_21 If MINN3 = 320 then MINN1A should be: #128
MINN1A_MINN6_21 If MINN6 = 610, 641, 680 then MINN1A should be: 100, 199
MINN1A_MINN7_1_21 If MINN7 = 711 then MINN1A should be: #123, 128
MINN1A_MINN7_2_21 If MINN7 = 721, 730 then MINN1A should be: #128
MINN1A_MINN8_21 If MINN8 = 821, 822 then MINN1A should be: 100, 199
MINN1B_MINN6_21 If MINN6 = 610, 641, 680 then MINN1B should be: 100, 199
MINN1B_MINN7_1_21 If MINN7 = 711 then MINN1B should be: #123, 136
MINN1B_MINN8_21 If MINN8 = 821, 822 then MINN1B should be: 100, 199
MINN1C_MINN3_1_21 If MINN3 = 320 then MINN1C should be: #128
MINN1C_MINN3_2_21 If MINN3 = 310 then MINN1C should be: #132
MINN1C_MINN6_21 If MINN6 = 610, 641, 680 then MINN1C should be: 100, 199
MINN1C_MINN7_1_21 If MINN7 = 711 then MINN1C should be: #127, 128, 132
MINN1C_MINN7_2_21 If MINN7 = 721, 730 then MINN1C should be: #128
MINN1C_MINN8_21 If MINN8 = 821, 822 then MINN1C should be: 100, 199
MINN1U_MINN1A_21 If MINN1A = #199 then MINN1U should be: 188
MINN1U_MINN1B_21 If MINN1B = #199 then MINN1U should be: 188
MINN1U_MINN1C_21 If MINN1C = #199 then MINN1U should be: 188
MINN1U_MINN3_1_21 If MINN3 = 320 then MINN1U should be: #128
MINN1U_MINN3_2_21 If MINN3 = 310 then MINN1U should be: #132
MINN1U_MINN6_21 If MINN6 = 610, 641, 680 then MINN1U should be: 100, 188, 199
MINN1U_MINN7_1_21 If MINN7 = 711 then MINN1U should be: #123, 127, 128, 132, 136
MINN1U_MINN7_2_21 If MINN7 = 721, 730 then MINN1U should be: #128
MINN1U_MINN8_21 If MINN8 = 821, 822 then MINN1U should be: 100, 199
MINN2_MINN6_21 If MINN6 = 610, 641, 680 then MINN2 should be: 20, 29
MINN2_MINN7_21 If MINN7 = 711, 721, 740 then MINN2 should be: 20, 29
MINN2_MINN8_21 If MINN8 = 821, 822 then MINN2 should be: 20, 29
MINN2_MINN9M_21 If MINN9M = 910 then MINN2 should be: 20, 29
MINN3_MINN6_21 If MINN6 = 610, 641, 680 then MINN3 should be: 30, 39
MINN3_MINN7_21 If MINN7 = 711, 721, 740 then MINN3 should be: 30, 39
MINN3_MINN8_21 If MINN8 = 821, 822 then MINN3 should be: 30, 39
MINN4A_MINN6_21 If MINN6 = 610, 641, 680 then MINN4A should be: 400, 499
MINN4A_MINN7_21 If MINN7 = 711, 721, 740 then MINN4A should be: 400, 499
MINN4A_MINN8_21 If MINN8 = 821, 822 then MINN4A should be: 400, 499
MINN4B_MINN6_21 If MINN6 = 610, 641, 680 then MINN4B should be: 400, 499
MINN4B_MINN7_21 If MINN7 = 711, 721, 740 then MINN4B should be: 400, 499
MINN4B_MINN8_21 If MINN8 = 821, 822 then MINN4B should be: 400, 499
MINN4C_MINN6_21 If MINN6 = 610, 641, 680 then MINN4C should be: 400, 499
MINN4C_MINN7_21 If MINN7 = 711, 721, 740 then MINN4C should be: 400, 499
MINN4C_MINN8_21 If MINN8 = 821, 822 then MINN4C should be: 400, 499
MINN4U_MINN4A_21 If MINN4A = #499 then MINN4U should be: 488
MINN4U_MINN4B_21 If MINN4B = #499 then MINN4U should be: 488
MINN4U_MINN4C_21 If MINN4C = #499 then MINN4U should be: 488
MINN4U_MINN6_21 If MINN6 = 610, 641, 680 then MINN4U should be: 400, 488, 499
MINN4U_MINN7_21 If MINN7 = 711, 721, 740 then MINN4U should be: 400, 488, 499
MINN4U_MINN8_21 If MINN8 = 821, 822 then MINN4U should be: 400, 488, 499
MINN5A_MINN6_21 If MINN6 = 610, 641, 680 then MINN5A should be: 50, 59
MINN5A_MINN7_21 If MINN7 = 711, 721, 740 then MINN5A should be: 50, 59
MINN5A_MINN8_21 If MINN8 = 821, 822 then MINN5A should be: 50, 59
MINN5B_MINN6_21 If MINN6 = 610, 641, 680 then MINN5B should be: 50, 59
MINN5B_MINN7_21 If MINN7 = 711, 721, 740 then MINN5B should be: 50, 59
MINN5B_MINN8_21 If MINN8 = 821, 822 then MINN5B should be: 50, 59
MINN5C_MINN6_21 If MINN6 = 610, 641, 680 then MINN5C should be: 50, 59
MINN5C_MINN7_21 If MINN7 = 711, 721, 740 then MINN5C should be: 50, 59
MINN5C_MINN8_21 If MINN8 = 821, 822 then MINN5C should be: 50, 59
MINN5U_MINN5A_21 If MINN5A = #59 then MINN5U should be: 58
MINN5U_MINN5B_21 If MINN5B = #59 then MINN5U should be: 58
MINN5U_MINN5C_21 If MINN5C = #59 then MINN5U should be: 58
MINN5U_MINN6_21 If MINN6 = 610, 641, 680 then MINN5U should be: 50, 58, 59
MINN5U_MINN7_21 If MINN7 = 711, 721, 740 then MINN5U should be: 50, 58, 59
MINN5U_MINN8_21 If MINN8 = 821, 822 then MINN5U should be: 50, 58, 59
MINN6_MINN8_1_21 If MINN8 = 821, 822 then MINN6 should be: 600, 699
MINN6_MINN8_2_21 If MINN8 = 841 then MINN6 should be: 600, 610, 621, 622, 623, 630, 641, 642, 660, 680, 699
MINN6_MINN8_3_21 If MINN8 = 832, 834 then MINN6 should be: #622
MINN7_MINN1A_21 If MINN1A = #100, 199 then MINN7 should be: #760
MINN7_MINN1B_21 If MINN1B = #100, 199 then MINN7 should be: #760
MINN7_MINN1C_1_21 If MINN1C = 122 then MINN7 should be: #770
MINN7_MINN1C_21 If MINN1C = #100, 199 then MINN7 should be: #760
MINN7_MINN1U_21 If MINN1U = #100, 188, 199 then MINN7 should be: #760
MINN7_MINN6_21 If MINN6 = 610, 641, 680 then MINN7 should be: 700, 799
MINN7_MINN8_1_21 If MINN8 = 821, 822 then MINN7 should be: 700, 799
MINN8_MINN6_1_21 If MINN6 = 610 then MINN8 should be: 800, 821, 822, 823, 824, 899
MINN8_MINN6_21 If MINN6 = 641, 680 then MINN8 should be: 800, 899
MINN9A_MINN6_21 If MINN6 = 610, 641, 680 then MINN9A should be: 90, 99
MINN9A_MINN7_21 If MINN7 = 711, 721, 740 then MINN9A should be: 90, 99
MINN9A_MINN8_21 If MINN8 = 821, 822 then MINN9A should be: 90, 99
MINN9B_MINN6_21 If MINN6 = 610, 641, 680 then MINN9B should be: 90, 99
MINN9B_MINN7_21 If MINN7 = 711, 721, 740 then MINN9B should be: 90, 99
MINN9B_MINN8_21 If MINN8 = 821, 822 then MINN9B should be: 90, 99
MINN9C_MINN6_21 If MINN6 = 610, 641, 680 then MINN9C should be: 90, 99
MINN9C_MINN7_21 If MINN7 = 711, 721, 740 then MINN9C should be: 90, 99
MINN9C_MINN8_21 If MINN8 = 821, 822 then MINN9C should be: 90, 99
MINN9M_MINN6_21 If MINN6 = 610, 641, 680 then MINN9M should be: 900, 999
MINN9M_MINN7_21 If MINN7 = 711, 721, 740 then MINN9M should be: #941, 942, 950
MINN9M_MINN8_1_21 If MINN8 = 814 then MINN9M should be: #930
MINN9M_MINN8_21 If MINN8 = 821, 822 then MINN9M should be: 900, 999
MINN9U_MINN6_21 If MINN6 = 610, 641, 680 then MINN9U should be: 90, 98, 99
MINN9U_MINN7_21 If MINN7 = 711, 721, 740 then MINN9U should be: 90, 98, 99
MINN9U_MINN8_21 If MINN8 = 821, 822 then MINN9U should be: 90, 98, 99
MINN9U_MINN9A_21 If MINN9A = 92 then MINN9U should be: 98
MINN9U_MINN9B_21 If MINN9B = 92 then MINN9U should be: 98
MINN9U_MINN9C_21 If MINN9C = 92 then MINN9U should be: 98
NPREGNA_PREGNA_21 If PREGNA = 1 then NPREGNA should be: 01 to 19, 99
If PREGNA = 2 then NPREGNA should be: 88, 99
PARITY_PREGNA_21 If PREGNA = 2 then PARITY should be: 88
TREDIAB_HISDIAB_21 If HISDIAB = 1 then TREDIAB should be: 1 to 3, 9
If HISDIAB = 2 then TREDIAB should be: 8
WKSET_EMPLOY_21 If EMPLOY = 1 then WKSET should be: 1 to 4, 9
WKTYPE_EMPLOY_21 If EMPLOY = 1 then WKTYPE should be: 1 to 3, 9

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
ALCPROB_ALCPROS_21If 0 <= ALCPROB <= 100 and 0 <= ALCPROS <= 100 and ALCPROW = 000,999 then
  ALCPROB + ALCPROS <= 100
ALCPROW_ALCPROB_21If 0 <= ALCPROW <= 100 and 0 <= ALCPROB <= 100 and ALCPROS = 000,999 then
  ALCPROW + ALCPROB = 100
ALCPROW_ALCPROB_ALCPROS_21If 0 <= ALCPROW <= 100 and 0 <= ALCPROB <= 100 and 0 <= ALCPROS <= 100 then
99 <= ALCPROW + ALCPROB + ALCPROS <= 101
ALCPROW_ALCPROS_21If 0 <= ALCPROW <= 100 and 0 <= ALCPROS <= 100 and ALCPROB = 000,999 then
  ALCPROW + ALCPROS = 100
PARITY_NPREGNA_21If NPREGNA # 88,99 then PARITY <= NPREGNA or PARITY=99
SEX_MALE_21If SEX = 1 then NPREGNA = 88
If SEX = 1 then REMENOP = 8
If SEX = 1 then PARITY = 88
If SEX = 1 then PREGNA = 8
If SEX = 2 then PREGNA = 1,2,9