supplying data with a value table
# language: en @stap-documentatie @integratie Feature: supplying data with a value table Rule: has {object soort} with the following data Scenario Outline: has <relatie> with the following data Given the person 'P1' with citizen service number '000000012' * has a <relatie> with the following data | naam | waarde | | burgerservicenummer (01.20) | 000000024 | | voornamen (02.10) | Helena | | geslachtsnaam (02.40) | Hanssen | 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 | voor_naam | geslachts_naam | | P1 | P | 0 | 0 | 000000012 | | P1 | | P1 | <persoon type> | 0 | 0 | 000000024 | Helena | Hanssen | Examples: | relatie | persoon type | | ouder 1 | 1 | | ouder 2 | 2 | Scenario Outline: has <relatie> with the following data Given the person 'P1' with citizen service number '000000012' * has a <relatie> 'P2' with the following data | naam | waarde | | burgerservicenummer (01.20) | 000000024 | | voornamen (02.10) | Helena | | geslachtsnaam (02.40) | Hanssen | 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 | voor_naam | geslachts_naam | | P1 | P | 0 | 0 | 000000012 | | P1 | | P1 | <persoon type> | 0 | 0 | 000000024 | Helena | Hanssen | Examples: | relatie | persoon type | | partner | R | | kind | K | Scenario Outline: several of the same object kind: has <relatie> with the following data Given the person 'P1' with citizen service number '000000012' * has a <relatie> 'P2' with the following data | naam | waarde | | burgerservicenummer (01.20) | 000000024 | | voornamen (02.10) | Helena | | geslachtsnaam (02.40) | Hanssen | * has a <relatie> 'P3' with the following data | naam | waarde | | voornamen (02.10) | Herman | | geslachtsnaam (02.40) | Hanssen | 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 | voor_naam | geslachts_naam | | P1 | P | 0 | 0 | 000000012 | | P1 | | P1 | <persoon type> | 0 | 0 | 000000024 | Helena | Hanssen | | P1 | <persoon type> | 1 | 0 | | Herman | Hanssen | Examples: | relatie | persoon type | | partner | R | | kind | K | Scenario Outline: several of different object kinds: has <relatie> with the following data Given the person 'P1' with citizen service number '000000012' * has a parent 1 with the following data | naam | waarde | | burgerservicenummer (01.20) | 000000024 | | voornamen (02.10) | Helena | | geslachtsnaam (02.40) | Hanssen | * has a partner 'P3' with the following data | naam | waarde | | burgerservicenummer (01.20) | 000000036 | | voornamen (02.10) | Herman | | geslachtsnaam (02.40) | Hapert | 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 | voor_naam | geslachts_naam | | P1 | P | 0 | 0 | 000000012 | | P1 | | P1 | 1 | 0 | 0 | 000000024 | Helena | Hanssen | | P1 | R | 0 | 0 | 000000036 | Herman | Hapert | Scenario: has a gezagsverhouding with the following data Given the person 'P1' with citizen service number '000000012' * has the following gezagsverhouding (authority relationship) data | naam | waarde | | indicatie gezag minderjarige (32.10) | 2 | | ingangsdatum geldigheid (85.10) | 20211001 | 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 row in table 'lo3_pl_gezagsverhouding' | pl_id | volg_nr | minderjarig_gezag_ind | geldigheid_start_datum | | P1 | 0 | 2 | 20211001 | Rule: {object soort} has been {gewijzigd of gecorrigeerd} to the following data Scenario Outline: parent <ouder type> has been <soort wijziging> to the following data Given the person 'P1' with citizen service number '000000012' * has a parent <ouder type> with the following data | naam | waarde | | voornamen (02.10) | Helena | | geslachtsnaam (02.40) | Hanssen | And parent <ouder type> has been <soort wijziging> to the following data | naam | waarde | | burgerservicenummer (01.20) | 000000024 | | voornamen (02.10) | Herman | | geslachtsnaam (02.40) | Hanssen | 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 | voor_naam | geslachts_naam | onjuist_ind | | P1 | P | 0 | 0 | 000000012 | | P1 | | | P1 | <ouder type> | 0 | 1 | | Helena | Hanssen | <onjuist> | | P1 | <ouder type> | 0 | 0 | 000000024 | Herman | Hanssen | | Examples: | ouder type | soort wijziging | onjuist | | 1 | gewijzigd | | | 1 | gecorrigeerd | O | | 2 | gewijzigd | | | 2 | gecorrigeerd | O | Scenario Outline: <object soort wijziging> has been <soort wijziging> to the following data Given the person 'P1' with citizen service number '000000012' * has a <relatie soort> 'P2' with the following data | naam | waarde | | voornamen (02.10) | Helena | | geslachtsnaam (02.40) | Hanssen | And <relatie soort> 'P2' has been <soort wijziging> to the following data | naam | waarde | | burgerservicenummer (01.20) | 000000024 | | voornamen (02.10) | Herman | | geslachtsnaam (02.40) | Hanssen | 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 | voor_naam | geslachts_naam | onjuist_ind | | P1 | P | 0 | 0 | 000000012 | | P1 | | | P1 | <persoon type> | 0 | 1 | | Helena | Hanssen | <onjuist> | | P1 | <persoon type> | 0 | 0 | 000000024 | Herman | Hanssen | | Examples: | relatie soort | persoon type | soort wijziging | onjuist | | partner | R | gewijzigd | | | partner | R | gecorrigeerd | O | | kind | K | gewijzigd | | | kind | K | gecorrigeerd | O | Scenario: several children and data of the various children is corrected Given the person 'P1' with citizen service number '000000012' * has a child 'P2' with the following data | naam | waarde | | burgerservicenummer (01.20) | 000000024 | | voornamen (02.10) | Helena | | geslachtsnaam (02.40) | Hanssen | * has a child 'P3' with the following data | naam | waarde | | voornamen (02.10) | Herman | | voorvoegsel (02.30) | van | | geslachtsnaam (02.40) | Hanssen | And child 'P3' has been corrected to the following data | naam | waarde | | burgerservicenummer (01.20) | 000000036 | | voornamen (02.10) | Herman Pieter | | geslachtsnaam (02.40) | Hanssen | * has a child 'P4' with the following data | naam | waarde | | voornamen (02.10) | Hanna | | geslachtsnaam (02.40) | Hanssen | And child 'P4' has been corrected to the following data | naam | waarde | | voornamen (02.10) | Hanna Hellen | | geslachtsnaam (02.40) | Hanssen | 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 | voor_naam | geslachts_naam_voorvoegsel | geslachts_naam | onjuist_ind | | P1 | P | 0 | 0 | 000000012 | | | P1 | | | P1 | K | 0 | 0 | 000000024 | Helena | | Hanssen | | | P1 | K | 1 | 1 | | Herman | van | Hanssen | O | | P1 | K | 1 | 0 | 000000036 | Herman Pieter | | Hanssen | | | P1 | K | 2 | 1 | | Hanna | | Hanssen | O | | P1 | K | 2 | 0 | | Hanna Hellen | | Hanssen | | Scenario: several partners with changed and corrected data Given the person 'P1' with citizen service number '000000012' * has a partner 'P2' with the following data | naam | waarde | | burgerservicenummer (01.20) | 000000024 | | voornamen (02.10) | Helena | | geslachtsnaam (02.40) | Hanssen | | datum huwelijkssluiting/aangaan geregistreerd partnerschap (06.10) | 20150316 | And partner 'P2' has been changed to the following data | naam | waarde | | burgerservicenummer (01.20) | 000000024 | | voornamen (02.10) | Helena | | geslachtsnaam (02.40) | Hanssen | | datum ontbinding huwelijk/geregistreerd partnerschap (07.10) | 20201103 | * has a partner 'P3' with the following data | naam | waarde | | voornamen (02.10) | Herman | | geslachtsnaam (02.40) | Hapert | | datum huwelijkssluiting/aangaan geregistreerd partnerschap (06.10) | 20210604 | And partner 'P3' has been corrected to the following data | naam | waarde | | burgerservicenummer (01.20) | 000000036 | | voornamen (02.10) | Herman Pieter | | geslachtsnaam (02.40) | Hapert | | datum huwelijkssluiting/aangaan geregistreerd partnerschap (06.10) | 20210604 | And partner 'P3' has been changed to the following data | naam | waarde | | burgerservicenummer (01.20) | 000000036 | | voornamen (02.10) | Herman Pieter | | geslachtsnaam (02.40) | Hapert | | datum ontbinding huwelijk/geregistreerd partnerschap (07.10) | 20240117 | * has a partner 'P4' with the following data | naam | waarde | | voornamen (02.10) | Hadewich | | geslachtsnaam (02.40) | Heijliger | | datum huwelijkssluiting/aangaan geregistreerd partnerschap (06.10) | 20250429 | And partner 'P4' has been corrected to the following data | naam | waarde | | burgerservicenummer (01.20) | 000000048 | | voornamen (02.10) | Hadewich | | geslachtsnaam (02.40) | Heijliger | | datum huwelijkssluiting/aangaan geregistreerd partnerschap (06.10) | 20250429 | 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 | voor_naam | geslachts_naam | onjuist_ind | relatie_start_datum | relatie_eind_datum | | P1 | P | 0 | 0 | 000000012 | | P1 | | | | | P1 | R | 0 | 1 | 000000024 | Helena | Hanssen | | 20150316 | | | P1 | R | 0 | 0 | 000000024 | Helena | Hanssen | | | 20201103 | | P1 | R | 1 | 2 | | Herman | Hapert | O | 20210604 | | | P1 | R | 1 | 1 | 000000036 | Herman Pieter | Hapert | | 20210604 | | | P1 | R | 1 | 0 | 000000036 | Herman Pieter | Hapert | | | 20240117 | | P1 | R | 2 | 1 | | Hadewich | Heijliger | O | 20250429 | | | P1 | R | 2 | 0 | 000000048 | Hadewich | Heijliger | | 20250429 | | Scenario: the gezagsverhouding has been changed to the following data Given the person 'P1' with citizen service number '000000012' * has the following gezagsverhouding (authority relationship) data | naam | waarde | | indicatie gezag minderjarige (32.10) | 2 | | ingangsdatum geldigheid (85.10) | 20211001 | And the authority relationship has been changed to the following data | naam | waarde | | indicatie gezag minderjarige (32.10) | 1D | | ingangsdatum geldigheid (85.10) | 20241203 | 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 row in table 'lo3_pl_gezagsverhouding' | pl_id | volg_nr | minderjarig_gezag_ind | geldigheid_start_datum | | P1 | 1 | 2 | 20211001 | And person 'P1' has the following row in table 'lo3_pl_gezagsverhouding' | pl_id | volg_nr | minderjarig_gezag_ind | geldigheid_start_datum | | P1 | 0 | 1D | 20241203 | Rule: is registered at address {string} with the following data Scenario: is registered at address {string} with the following data Given address 'A1' | gemeentecode (92.10) | straatnaam (11.10) | | 0518 | Boterdiep | And the person 'P1' with citizen service number '000000012' And is registered at address 'A1' with the following data | naam | waarde | | functie adres (10.10) | B | | datum aanvang adreshouding (10.30) | 20111101 | When the SQL statements generated from the Given steps have been executed Then person 'P1' has the following rows in table 'lo3_pl_verblijfplaats' | pl_id | adres_id | volg_nr | adres_functie | adreshouding_start_datum | | P1 | A1 | 0 | B | 20111101 | Rule: is registered at a foreign address with the following data Scenario: is registered at a foreign address with the following data Given the person 'P1' with citizen service number '000000012' And is registered at a foreign address with the following data | naam | waarde | | land (13.10) | 6039 | | datum aanvang adres buitenland (13.20) | 20111101 | When the SQL statements generated from the Given steps have been executed Then person 'P1' has the following rows in table 'lo3_pl_verblijfplaats' | pl_id | adres_id | volg_nr | vertrek_land_code | vertrek_datum | | P1 | | 0 | 6039 | 20111101 | Rule: has died, with the following data Scenario: has died, with the following data Given the person 'P1' with citizen service number '000000012' * has died, with the following data | naam | waarde | | datum overlijden (08.10) | 20230924 | | plaats overlijden (08.20) | 0518 | | land overlijden (08.30) | 6030 | When the SQL statements generated from the Given steps have been executed Then person 'P1' has the following rows in table 'lo3_pl_overlijden' | pl_id | volg_nr | overlijden_datum | overlijden_plaats | overlijden_land_code | | P1 | 0 | 20230924 | 0518 | 6030 | Rule: is registered with the following data Scenario: is registered with the following data Given the person 'P1' with citizen service number '000000012' * is registered with the following data | naam | waarde | | datum opschorting bijhouding (67.10) | 20181201 | | reden opschorting bijhouding (67.20) | E | | indicatie geheim (70.10) | 7 | 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 | bijhouding_opschort_datum | bijhouding_opschort_reden | geheim_ind | | P1 | 20181201 | E | 7 |