Step definitions for specifying authority relationships
# language: en @integratie @stap-documentatie Feature: Step definitions for specifying authority relationships Rule: Parents are added to the person as persoon_type '1' and '2' respectively, and the person is added to the parents as persoon_type 'K' @integratie Scenario: has '{naam}' as parent # if no date of birth of the person is known yet, 'gisteren - 17 jaar' is recorded in familie_betrek_start_datum in the parent relationship Given 'Nederland', born yesterday 45 years ago in 'P1', with citizen service number '000000012' And 'Nederland', born yesterday 17 years ago in 'P2', with citizen service number '000000036' * has 'P1' as parent When the SQL statements generated from the Given steps have been executed Then person 'P1' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | P1 | 0 | And person 'P1' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_land_code | akte_nr | | P1 | P | 0 | 0 | 000000012 | P1 | 6030 | 1_A____ | | P1 | K | 0 | 0 | 000000036 | P2 | | 1_A____ | And person 'P2' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | P2 | 0 | And person 'P2' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_land_code | akte_nr | familie_betrek_start_datum | | P2 | P | 0 | 0 | 000000036 | P2 | 6030 | 1_A____ | | | P2 | 1 | 0 | 0 | 000000012 | P1 | | 1_A____ | gisteren - 17 jaar | @integratie Scenario Outline: carry over the date of birth of the minor: has '{naam}' as parent # the date of birth is carried over to the child relationship on the PL of the parent # and familie_betrek_start_datum is filled with the date of birth Given 'Nederland', born yesterday 45 years ago in 'P1', with citizen service number '000000012' And 'Nederland', born <geboortedatum> in 'P2', with citizen service number '000000036' * has 'P1' as parent When the SQL statements generated from the Given steps have been executed Then person 'P1' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | P1 | 0 | And person 'P1' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_datum | geboorte_land_code | akte_nr | | P1 | P | 0 | 0 | 000000012 | P1 | | 6030 | 1_A____ | | P1 | K | 0 | 0 | 000000036 | P2 | <datum> | | 1_A____ | And person 'P2' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | P2 | 0 | And person 'P2' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_datum | geboorte_land_code | akte_nr | familie_betrek_start_datum | | P2 | P | 0 | 0 | 000000036 | P2 | <datum> | 6030 | 1_A____ | | | P2 | 1 | 0 | 0 | 000000012 | P1 | gisteren - 45 jaar | | 1_A____ | <datum> | Examples: | eigenschap kind | geboortedatum | datum | | is meerderjarig | gisteren 45 jaar geleden | gisteren - 45 jaar | | is minderjarig | gisteren 17 jaar geleden | gisteren - 17 jaar | | is geboren op 5-8-1998 | op 5 augustus 1998 | 19980805 | @integratie Scenario: carry over the date of birth of the parent: has '{naam}' as parent Given 'Nederland', born <geboortedatum> in 'P1', with citizen service number '000000012' And 'Nederland', born yesterday 17 years ago in 'P2', with citizen service number '000000036' * has 'P1' as parent When the SQL statements generated from the Given steps have been executed Then person 'P1' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | P1 | 0 | And person 'P1' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_datum | geboorte_land_code | akte_nr | | P1 | P | 0 | 0 | 000000012 | P1 | <datum> | 6030 | 1_A____ | | P1 | K | 0 | 0 | 000000036 | P2 | | | 1_A____ | And person 'P2' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | P2 | 0 | And person 'P2' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_datum | geboorte_land_code | akte_nr | familie_betrek_start_datum | | P2 | P | 0 | 0 | 000000036 | P2 | | 6030 | 1_A____ | | | P2 | 1 | 0 | 0 | 000000012 | P1 | <datum> | | 1_A____ | gisteren - 17 jaar | Examples: | eigenschap ouder | geboortedatum | datum | | is meerderjarig | gisteren 45 jaar geleden | gisteren - 45 jaar | | is minderjarig | gisteren 17 jaar geleden | gisteren - 17 jaar | | is geboren op 5-8-1998 | op 5 augustus 1998 | 19980805 | @integratie Scenario: carry over the geslacht of the parent: has '{naam}' as parent Given the <geslacht> 'Nederland', born yesterday 45 years ago in 'P1', with citizen service number '000000012' And 'Nederland', born yesterday 17 years ago in 'P2', with citizen service number '000000036' * has 'P1' as parent When the SQL statements generated from the Given steps have been executed Then person 'P1' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | P1 | 0 | And person 'P1' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_land_code | akte_nr | geslachts_aand | | P1 | P | 0 | 0 | 000000012 | P1 | 6030 | 1_A____ | <geslachtsaanduiding> | | P1 | K | 0 | 0 | 000000036 | P2 | | 1_A____ | | And person 'P2' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | P2 | 0 | And person 'P2' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_land_code | akte_nr | familie_betrek_start_datum | geslachts_aand | | P2 | P | 0 | 0 | 000000036 | P2 | 6030 | 1_A____ | | | | P2 | 1 | 0 | 0 | 000000012 | P1 | | 1_A____ | gisteren - 17 jaar | <geslachtsaanduiding> | Examples: | eigenschap ouder | geslacht | geslachtsaanduiding | | is een vrouw | vrouw | V | | is een man | man | M | @integratie Scenario: has '{naam1}' and '{naam2}' as parents # if no date of birth of the person is known yet, 'gisteren - 17 jaar' is recorded by default in familie_betrek_start_datum in the parent relationship Given 'Nederland', born yesterday 45 years ago in 'P1', with citizen service number '000000012' And 'Nederland', born tomorrow 40 years ago in 'P2', with citizen service number '000000024' And 'Nederland', born yesterday 17 years ago in 'P3', with citizen service number '000000036' * has 'P1' and 'P2' as parents When the SQL statements generated from the Given steps have been executed Then person 'P1' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | P1 | 0 | And person 'P1' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_land_code | akte_nr | | P1 | P | 0 | 0 | 000000012 | P1 | 6030 | 1_A____ | | P1 | K | 0 | 0 | 000000036 | P3 | | 1_A____ | And person 'P2' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | P2 | 0 | And person 'P2' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_land_code | akte_nr | | P2 | P | 0 | 0 | 000000024 | P2 | 6030 | 1_A____ | | P2 | K | 0 | 0 | 000000036 | P3 | | 1_A____ | And person 'P3' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | P3 | 0 | And person 'P3' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_land_code | akte_nr | familie_betrek_start_datum | | P3 | P | 0 | 0 | 000000036 | P3 | 6030 | 1_A____ | | | P3 | 1 | 0 | 0 | 000000012 | P1 | | 1_A____ | gisteren - 17 jaar | | P3 | 2 | 0 | 0 | 000000024 | P2 | | 1_A____ | gisteren - 17 jaar | @integratie Scenario: carrying over data of parents and child: has '{naam1}' and '{naam2}' as parents # the date of birth of the child is carried over to the child relationship on the PL of the parent, and familie_betrek_start_datum is filled with the date of birth # the date of birth and gender of the parent are carried over to the parent relationship on the PL of the person Given the man 'Nederland', born yesterday 45 years ago in 'P1', with citizen service number '000000012' And the woman 'Nederland', born on 05 August 1988 in 'P2', with citizen service number '000000024' And 'Nederland', born 2 years ago in 'P3', with citizen service number '000000036' * has 'P1' and 'P2' as parents When the SQL statements generated from the Given steps have been executed Then person 'P1' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | P1 | 0 | And person 'P1' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_datum | geboorte_land_code | geslachts_aand | akte_nr | | P1 | P | 0 | 0 | 000000012 | P1 | gisteren - 45 jaar | 6030 | M | 1_A____ | | P1 | K | 0 | 0 | 000000036 | P3 | 2 jaar geleden | | | 1_A____ | And person 'P2' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | P2 | 0 | And person 'P2' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_datum | geboorte_land_code | geslachts_aand | akte_nr | | P2 | P | 0 | 0 | 000000024 | P2 | 19880805 | 6030 | V | 1_A____ | | P2 | K | 0 | 0 | 000000036 | P3 | 2 jaar geleden | | | 1_A____ | And person 'P3' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | P3 | 0 | And person 'P3' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_datum | geboorte_land_code | geslachts_aand | akte_nr | familie_betrek_start_datum | | P3 | P | 0 | 0 | 000000036 | P3 | 2 jaar geleden | 6030 | | 1_A____ | | | P3 | 1 | 0 | 0 | 000000012 | P1 | gisteren - 45 jaar | | M | 1_A____ | 2 jaar geleden | | P3 | 2 | 0 | 0 | 000000024 | P2 | 19880805 | | V | 1_A____ | 2 jaar geleden | @integratie Scenario: has '{naam}' as a parent who is not registered in the BRP with a citizen service number # the date of birth of the non-resident parent is filled by default as of full age (yesterday minus 45 years) # we may add other variants later (a parent who is a minor) or add extra data (given names, place of birth, country of birth, etc.?) # if no date of birth of the person is known yet, 'gisteren - 17 jaar' is recorded in familie_betrek_start_datum in the parent relationship Given the man 'Nederland', born yesterday 45 years ago in 'P1', with citizen service number '000000012' And the adult woman 'P3' without a citizen service number And the man 'Nederland', born yesterday 17 years ago in 'P2', with citizen service number '000000036' * has 'P1' and 'P3' as parents When the SQL statements generated from the Given steps have been executed Then person 'P1' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | P1 | 0 | And person 'P1' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_land_code | akte_nr | | P1 | P | 0 | 0 | 000000012 | P1 | 6030 | 1_A____ | | P1 | K | 0 | 0 | 000000036 | P2 | | 1_A____ | And person 'P2' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | P2 | 0 | And person 'P2' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_datum | geboorte_land_code | akte_nr | familie_betrek_start_datum | | P2 | P | 0 | 0 | 000000036 | P2 | | 6030 | 1_A____ | | | P2 | 1 | 0 | 0 | 000000012 | P1 | gisteren - 45 jaar | | 1_A____ | gisteren - 17 jaar | | P2 | 2 | 0 | 0 | | P3 | gisteren - 45 jaar | | 1_A____ | gisteren - 17 jaar | @integratie Scenario: '{naam}' was acknowledged by '{naam}' on {datum} Given the man 'Nederland', born yesterday 45 years ago in 'P1', with citizen service number '000000012' And the woman 'Nederland', born yesterday 45 years ago in 'P2', with citizen service number '000000024' And 'Nederland', born yesterday 17 years ago in 'P3', with citizen service number '000000036' * has 'P2' as parent And 'P3' was acknowledged by 'P1' on 16-5-2021 When the SQL statements generated from the Given steps have been executed Then person 'P1' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | P1 | 0 | And person 'P1' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geboorte_datum | geslachts_naam | geboorte_land_code | akte_nr | | P1 | P | 0 | 0 | 000000012 | gisteren - 45 jaar | P1 | 6030 | 1_A____ | | P1 | K | 0 | 0 | 000000036 | gisteren - 17 jaar | P3 | | 1_C____ | And person 'P2' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | P2 | 0 | And person 'P2' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geboorte_datum | geslachts_naam | geboorte_land_code | akte_nr | | P2 | P | 0 | 0 | 000000024 | gisteren - 45 jaar | P2 | 6030 | 1_A____ | | P2 | K | 0 | 0 | 000000036 | gisteren - 17 jaar | P3 | | 1_A____ | And person 'P3' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | P3 | 0 | And person 'P3' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_datum | geboorte_land_code | akte_nr | familie_betrek_start_datum | | P3 | P | 0 | 0 | 000000036 | P3 | gisteren - 17 jaar | 6030 | 1_C____ | | | P3 | 1 | 0 | 0 | 000000024 | P2 | gisteren - 45 jaar | | 1_A____ | gisteren - 17 jaar | | P3 | 2 | 0 | 0 | 000000012 | P1 | gisteren - 45 jaar | | 1_C____ | 20210516 | @integratie Scenario: carrying over data of parent and child: '{naam}' was acknowledged by '{naam}' on {datum} Given the man 'Nederland', born yesterday 45 years ago in 'P1', with citizen service number '000000012' And the woman 'Nederland', born yesterday 45 years ago in 'P2', with citizen service number '000000024' And 'Nederland', born yesterday 17 years ago in 'P3', with citizen service number '000000036' * has 'P2' as parent And 'P3' was acknowledged by 'P1' on 16-5-2021 When the SQL statements generated from the Given steps have been executed Then person 'P1' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | P1 | 0 | And person 'P1' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geboorte_datum | geslachts_naam | geboorte_land_code | geslachts_aand | akte_nr | | P1 | P | 0 | 0 | 000000012 | gisteren - 45 jaar | P1 | 6030 | M | 1_A____ | | P1 | K | 0 | 0 | 000000036 | gisteren - 17 jaar | P3 | | | 1_C____ | And person 'P2' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | P2 | 0 | And person 'P2' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geboorte_datum | geslachts_naam | geboorte_land_code | akte_nr | | P2 | P | 0 | 0 | 000000024 | | P2 | 6030 | 1_A____ | | P2 | K | 0 | 0 | 000000036 | gisteren - 17 jaar | P3 | | 1_A____ | And person 'P3' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | P3 | 0 | And person 'P3' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_datum | geboorte_land_code | geslachts_aand | akte_nr | familie_betrek_start_datum | | P3 | P | 0 | 0 | 000000036 | P3 | gisteren - 17 jaar | 6030 | | 1_C____ | | | P3 | 1 | 0 | 0 | 000000024 | P2 | gisteren - 45 jaar | | | 1_A____ | gisteren - 17 jaar | | P3 | 2 | 0 | 0 | 000000012 | P1 | gisteren - 45 jaar | | M | 1_C____ | 20210516 | Rule: A judicial ruling is recorded in the gezagsverhouding @integratie Scenario: <stapdefinitie> Given 'Nederland', born yesterday 45 years ago in 'P1', with citizen service number '000000012' And 'Nederland', born tomorrow 40 years ago in 'P2', with citizen service number '000000024' And 'Nederland', born yesterday 17 years ago in 'P3', with citizen service number '000000036' * has 'P1' and 'P2' as parents And in a judicial ruling <gezag uitspraak> When the SQL statements generated from the Given steps have been executed Then person 'P1' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | P1 | 0 | And person 'P1' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_land_code | akte_nr | | P1 | P | 0 | 0 | 000000012 | P1 | 6030 | 1_A____ | | P1 | K | 0 | 0 | 000000036 | P3 | | 1_A____ | And person 'P2' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | P2 | 0 | And person 'P2' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_land_code | akte_nr | | P2 | P | 0 | 0 | 000000024 | P2 | 6030 | 1_A____ | | P2 | K | 0 | 0 | 000000036 | P3 | | 1_A____ | And person 'P3' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | P3 | 0 | And person 'P3' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_land_code | akte_nr | familie_betrek_start_datum | | P3 | P | 0 | 0 | 000000036 | P3 | 6030 | 1_A____ | | | P3 | 1 | 0 | 0 | 000000012 | P1 | | 1_A____ | gisteren - 17 jaar | | P3 | 2 | 0 | 0 | 000000024 | P2 | | 1_A____ | gisteren - 17 jaar | And person 'P3' has the following rows in table 'lo3_pl_gezagsverhouding' | pl_id | volg_nr | minderjarig_gezag_ind | geldigheid_start_datum | | P3 | 0 | <indicatie gezag> | gisteren - 1 jaar | Examples: | gezag uitspraak | indicatie gezag | stapdefinitie | | het gezag toegewezen aan 'P1' | 1 | in een gerechtelijke uitspraak is het gezag toegewezen aan '{naam}' | | het gezag toegewezen aan 'P2' | 2 | in een gerechtelijke uitspraak is het gezag toegewezen aan '{naam}' | | het gezag toegewezen aan beide ouders | 12 | in een gerechtelijke uitspraak is het gezag toegewezen aan beide ouders | | een voogdijinstelling tot voogd benoemd | D | in een gerechtelijke uitspraak is een voogdijinstelling tot voogd benoemd | | een derde tot voogd benoemd | D | in een gerechtelijke uitspraak is een derde tot voogd benoemd | | het gezag toegewezen aan 'P1' en een derde | 1D | in een gerechtelijke uitspraak is het gezag toegewezen aan '{naam}' en een derde | | het gezag toegewezen aan 'P2' en een derde | 2D | in een gerechtelijke uitspraak is het gezag toegewezen aan '{naam}' en een derde | @integratie Scenario: {relatieve datum} '{naam}' denied parenthood Given 'Nederland', born yesterday 45 years ago in 'P1', with citizen service number '000000012' And 'Nederland', born yesterday 45 years ago in 'P2', with citizen service number '000000024' And 'Nederland', born yesterday 17 years ago in 'P3', with citizen service number '000000036' * has 'P1' and 'P2' as parents And 4 years ago 'P1' denied parenthood When the SQL statements generated from the Given steps have been executed Then person 'P1' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | P1 | 0 | And person 'P1' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_datum | geboorte_land_code | akte_nr | | P1 | P | 0 | 0 | 000000012 | P1 | | 6030 | 1_A____ | | P1 | K | 0 | 1 | 000000036 | P3 | gisteren - 17 jaar | | 1_A____ | | P1 | K | 0 | 0 | | | | | 1AE0100 | And person 'P2' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | P2 | 0 | And person 'P2' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_datum | geboorte_land_code | akte_nr | | P2 | P | 0 | 0 | 000000024 | P2 | | 6030 | 1_A____ | | P2 | K | 0 | 0 | 000000036 | P3 | gisteren - 17 jaar | | 1_A____ | And person 'P3' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | P3 | 0 | And person 'P3' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_datum | geboorte_land_code | akte_nr | familie_betrek_start_datum | geldigheid_start_datum | onjuist_ind | | P3 | P | 0 | 0 | 000000036 | P3 | gisteren - 17 jaar | 6030 | 1_A____ | | | | | P3 | 1 | 0 | 1 | 000000012 | P1 | gisteren - 45 jaar | | 1_A____ | gisteren - 17 jaar | | O | | P3 | 1 | 0 | 0 | | | | | 1AE0100 | | 4 jaar geleden | | | P3 | 2 | 0 | 0 | 000000024 | P2 | gisteren - 45 jaar | | 1_A____ | gisteren - 17 jaar | | | @integratie Scenario: '{naam}' has denied being the father of '{naam}' Given 'Nederland', born yesterday 45 years ago in 'P1', with citizen service number '000000012' And 'Nederland', born yesterday 45 years ago in 'P2', with citizen service number '000000024' And 'Nederland', born yesterday 17 years ago in 'P3', with citizen service number '000000036' * has 'P1' and 'P2' as parents And 'P1' has denied being the father of 'P3' When the SQL statements generated from the Given steps have been executed Then person 'P1' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | P1 | 0 | And person 'P1' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_datum | geboorte_land_code | akte_nr | | P1 | P | 0 | 0 | 000000012 | P1 | | 6030 | 1_A____ | | P1 | K | 0 | 1 | 000000036 | P3 | gisteren - 17 jaar | | 1_A____ | | P1 | K | 0 | 0 | | | | | 1AE0100 | And person 'P2' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | P2 | 0 | And person 'P2' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_datum | geboorte_land_code | akte_nr | | P2 | P | 0 | 0 | 000000024 | P2 | | 6030 | 1_A____ | | P2 | K | 0 | 0 | 000000036 | P3 | gisteren - 17 jaar | | 1_A____ | And person 'P3' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | P3 | 0 | And person 'P3' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_datum | geboorte_land_code | akte_nr | familie_betrek_start_datum | geldigheid_start_datum | onjuist_ind | | P3 | P | 0 | 0 | 000000036 | P3 | gisteren - 17 jaar | 6030 | 1_A____ | | | | | P3 | 1 | 0 | 1 | 000000012 | P1 | gisteren - 45 jaar | | 1_A____ | gisteren - 17 jaar | | O | | P3 | 1 | 0 | 0 | | | | | 1AE0100 | | gisteren - 17 jaar | | | P3 | 2 | 0 | 0 | 000000024 | P2 | gisteren - 45 jaar | | 1_A____ | gisteren - 17 jaar | | | @integratie Scenario: has '{naam}' as parent from the date of birth # this step is completely identical to step "heeft '{naam}' als ouder" # the addition is only meant to stress to the reader that the parent is named on the birth certificate and that the family-law relationship equals the date of birth Given 'Nederland', born yesterday 45 years ago in 'P1', with citizen service number '000000012' And 'Nederland', born yesterday 17 years ago in 'P2', with citizen service number '000000036' * has 'P1' as parent from the date of birth When the SQL statements generated from the Given steps have been executed Then person 'P1' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | P1 | 0 | And person 'P1' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_land_code | akte_nr | | P1 | P | 0 | 0 | 000000012 | P1 | 6030 | 1_A____ | | P1 | K | 0 | 0 | 000000036 | P2 | | 1_A____ | And person 'P2' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | P2 | 0 | And person 'P2' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_land_code | akte_nr | familie_betrek_start_datum | | P2 | P | 0 | 0 | 000000036 | P2 | 6030 | 1_A____ | | | P2 | 1 | 0 | 0 | 000000012 | P1 | | 1_A____ | gisteren - 17 jaar | @integratie Scenario: has '{naam1}' and '{naam2}' as parents from the date of birth # this step is completely identical to step "heeft '{naam1}' en '{naam2}' als ouders" # the addition is only meant to stress to the reader that the parent is named on the birth certificate and that the family-law relationship equals the date of birth Given 'Nederland', born yesterday 45 years ago in 'P1', with citizen service number '000000012' And 'Nederland', born tomorrow 40 years ago in 'P3', with citizen service number '000000024' And 'Nederland', born yesterday 17 years ago in 'P2', with citizen service number '000000036' * has 'P1' and 'P3' as parents from the date of birth When the SQL statements generated from the Given steps have been executed Then person 'P1' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | P1 | 0 | And person 'P1' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_land_code | akte_nr | | P1 | P | 0 | 0 | 000000012 | P1 | 6030 | 1_A____ | | P1 | K | 0 | 0 | 000000036 | P2 | | 1_A____ | And person 'P3' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | P3 | 0 | And person 'P3' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_land_code | akte_nr | | P3 | P | 0 | 0 | 000000024 | P3 | 6030 | 1_A____ | | P3 | K | 0 | 0 | 000000036 | P2 | | 1_A____ | And person 'P2' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | P2 | 0 | And person 'P2' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_land_code | akte_nr | familie_betrek_start_datum | | P2 | P | 0 | 0 | 000000036 | P2 | 6030 | 1_A____ | | | P2 | 1 | 0 | 0 | 000000012 | P1 | | 1_A____ | gisteren - 17 jaar | | P2 | 2 | 0 | 0 | 000000024 | P3 | | 1_A____ | gisteren - 17 jaar | @integratie Scenario: '{naam}' has denied being the father of '{naam}' Given 'Nederland', born yesterday 45 years ago in 'P1', with citizen service number '000000012' And 'Nederland', born tomorrow 40 years ago in 'P2', with citizen service number '000000024' And 'Nederland', born yesterday 17 years ago in 'P3', with citizen service number '000000036' * has 'P1' and 'P2' as parents And 'P1' has denied being the father of 'P3' When the SQL statements generated from the Given steps have been executed Then person 'P1' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | P1 | 0 | And person 'P1' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_datum | geboorte_land_code | akte_nr | | P1 | P | 0 | 0 | 000000012 | P1 | | 6030 | 1_A____ | | P1 | K | 0 | 1 | 000000036 | P3 | gisteren - 17 jaar | | 1_A____ | | P1 | K | 0 | 0 | | | | | 1AE0100 | And person 'P2' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | P2 | 0 | And person 'P2' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_datum | geboorte_land_code | akte_nr | | P2 | P | 0 | 0 | 000000024 | P2 | | 6030 | 1_A____ | | P2 | K | 0 | 0 | 000000036 | P3 | gisteren - 17 jaar | | 1_A____ | And person 'P3' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | P3 | 0 | And person 'P3' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_datum | geboorte_land_code | akte_nr | familie_betrek_start_datum | | P3 | P | 0 | 0 | 000000036 | P3 | gisteren - 17 jaar | 6030 | 1_A____ | | | P3 | 1 | 0 | 1 | 000000012 | P1 | | | 1_A____ | gisteren - 17 jaar | | P3 | 1 | 0 | 0 | | | | | 1AE0100 | | | P3 | 2 | 0 | 0 | 000000024 | P2 | | | 1_A____ | gisteren - 17 jaar | @integratie Scenario: {relatieve datum} '{naam}' denied parenthood Given 'Nederland', born yesterday 45 years ago in 'P1', with citizen service number '000000012' And 'Nederland', born tomorrow 40 years ago in 'P2', with citizen service number '000000024' And 'Nederland', born yesterday 17 years ago in 'P3', with citizen service number '000000036' * has 'P1' and 'P2' as parents And 4 years ago 'P1' denied parenthood When the SQL statements generated from the Given steps have been executed Then person 'P1' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | P1 | 0 | And person 'P1' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_datum | geboorte_land_code | akte_nr | | P1 | P | 0 | 0 | 000000012 | P1 | | 6030 | 1_A____ | | P1 | K | 0 | 1 | 000000036 | P3 | gisteren - 17 jaar | | 1_A____ | | P1 | K | 0 | 0 | | | | | 1AE0100 | And person 'P2' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | P2 | 0 | And person 'P2' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_datum | geboorte_land_code | akte_nr | | P2 | P | 0 | 0 | 000000024 | P2 | | 6030 | 1_A____ | | P2 | K | 0 | 0 | 000000036 | P3 | gisteren - 17 jaar | | 1_A____ | And person 'P3' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | P3 | 0 | And person 'P3' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_datum | geboorte_land_code | akte_nr | familie_betrek_start_datum | geldigheid_start_datum | | P3 | P | 0 | 0 | 000000036 | P3 | gisteren - 17 jaar | 6030 | 1_A____ | | | | P3 | 1 | 0 | 1 | 000000012 | P1 | | | 1_A____ | gisteren - 17 jaar | | | P3 | 1 | 0 | 0 | | | | | 1AE0100 | | 4 jaar geleden | | P3 | 2 | 0 | 0 | 000000024 | P2 | | | 1_A____ | gisteren - 17 jaar | | @integratie Scenario Outline: {relatievedatum} authority was awarded in a judicial ruling to <gezaghebbende in stapdefinitie> Given 'Nederland', born yesterday 45 years ago in 'P1', with citizen service number '000000012' And 'Nederland', born tomorrow 40 years ago in 'P2', with citizen service number '000000024' And 'Nederland', born yesterday 17 years ago in 'P3', with citizen service number '000000036' * has 'P1' and 'P2' as parents And <relatieve datum> a judicial ruling awarded authority to <gezaghebbende> When the SQL statements generated from the Given steps have been executed Then person 'P1' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | P1 | 0 | And person 'P1' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_land_code | akte_nr | | P1 | P | 0 | 0 | 000000012 | P1 | 6030 | 1_A____ | | P1 | K | 0 | 0 | 000000036 | P3 | | 1_A____ | And person 'P2' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | P2 | 0 | And person 'P2' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_land_code | akte_nr | | P2 | P | 0 | 0 | 000000024 | P2 | 6030 | 1_A____ | | P2 | K | 0 | 0 | 000000036 | P3 | | 1_A____ | And person 'P3' has the following row in table 'lo3_pl' | pl_id | geheim_ind | | P3 | 0 | And person 'P3' has the following rows in table 'lo3_pl_persoon' | pl_id | persoon_type | stapel_nr | volg_nr | burger_service_nr | geslachts_naam | geboorte_land_code | akte_nr | familie_betrek_start_datum | | P3 | P | 0 | 0 | 000000036 | P3 | 6030 | 1_A____ | | | P3 | 1 | 0 | 0 | 000000012 | P1 | | 1_A____ | gisteren - 17 jaar | | P3 | 2 | 0 | 0 | 000000024 | P2 | | 1_A____ | gisteren - 17 jaar | And person 'P3' has the following rows in table 'lo3_pl_gezagsverhouding' | pl_id | volg_nr | minderjarig_gezag_ind | geldigheid_start_datum | | P3 | 0 | <indicatie gezag> | <relatieve datum> | Examples: | relatieve datum | gezaghebbende | indicatie gezag | gezaghebbende in stapdefinitie | | 6 jaar geleden | 'P1' | 1 | '{naam}' | | vorige maand | 'P2' | 2 | '{naam}' | | gisteren - 5 jaar | een voogdijinstelling | D | een voogdijinstelling | | gisteren - 4 jaar | een derde | D | een derde | | 2 jaar geleden | beide ouders | 12 | beide ouders | | 2 jaar geleden | 'P1' en een derde | 1D | '{naam}' en een derde | | 2 jaar geleden | 'P2' en een derde | 2D | '{naam}' en een derde |