Step definitions for specifying authority relationships
# language: en @integratie @stap-documentatie Feature: Step definitions for specifying authority relationships Rule: Registration, immigration and emigration are recorded in the verblijfplaats @integratie Scenario: is registered in a Dutch municipality Given the person 'P1' with citizen service number '000000012' * is registered in a Dutch municipality 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 | 1AA0100 | And person 'P1' has the following rows in table 'lo3_pl_verblijfplaats' | pl_id | volg_nr | inschrijving_gemeente_code | | P1 | 0 | 0518 | @integratie Scenario: is registered as a non-resident with a place of residence in Belgium Given the person 'P1' with citizen service number '000000012' * is registered as a non-resident with a place of residence in Belgium 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 | 1AA0100 | And person 'P1' has the following rows in table 'lo3_pl_verblijfplaats' | pl_id | volg_nr | inschrijving_gemeente_code | vertrek_land_code | | P1 | 0 | 1999 | 5010 | @integratie Scenario: is registered as a non-resident with an entirely unknown place of residence Given the person 'P1' with citizen service number '000000012' * is registered as a non-resident with a completely unknown place of residence 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 | 1AA0100 | And person 'P1' has the following rows in table 'lo3_pl_verblijfplaats' | pl_id | volg_nr | inschrijving_gemeente_code | vertrek_land_code | | P1 | 0 | 1999 | 0000 | @integratie Scenario: the municipality has established that the minor does not reside at the address Given the person 'P1' with citizen service number '000000012' * is registered in a Dutch municipality * the municipality has established that the minor does not reside at the address 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 | 1AA0100 | And person 'P1' has the following rows in table 'lo3_pl_verblijfplaats' | pl_id | volg_nr | inschrijving_gemeente_code | onderzoek_gegevens_aand | | P1 | 0 | 0518 | 089999 | @integratie Scenario: immigrated on {datum} # the date has the format d-m-y, where d and m have 1 or 2 digits and y has 4 digits Given the person 'P1' with citizen service number '000000012' * was born in Belgium And immigrated on <immigratiedatum> 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 | | P1 | P | 0 | 0 | 000000012 | P1 | 5010 | And person 'P1' has the following rows in table 'lo3_pl_verblijfplaats' | pl_id | volg_nr | inschrijving_gemeente_code | vestiging_datum | | P1 | 0 | 0518 | <vestiging datum> | Examples: | immigratiedatum | vestiging datum | | 15-5-2022 | 20220515 | | 3-11-2023 | 20231103 | @integratie Scenario: '{naam}' immigrated to the Netherlands {relatievedatum} Given the person 'P1' with citizen service number '000000012' And 'P1' immigrated to the Netherlands <relatieve datum> 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 | | P1 | P | 0 | 0 | 000000012 | P1 | And person 'P1' has the following rows in table 'lo3_pl_verblijfplaats' | pl_id | volg_nr | inschrijving_gemeente_code | vestiging_datum | | P1 | 0 | 0518 | <relatieve datum> | Examples: | relatieve datum | | gisteren | | 2 jaar geleden | | vorige maand | @integratie Scenario: '{naam}' emigrated to {landnaam} {relatievedatum} Given the person 'P1' with citizen service number '000000012' And 'P1' emigrated to <relatieve datum> <land naam> 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 | bijhouding_opschort_datum | bijhouding_opschort_reden | | P1 | 0 | <relatieve datum> | E | 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 | | P1 | P | 0 | 0 | 000000012 | P1 | And person 'P1' has the following rows in table 'lo3_pl_verblijfplaats' | pl_id | volg_nr | inschrijving_gemeente_code | vertrek_datum | vertrek_land_code | | P1 | 0 | 1999 | <relatieve datum> | <land code> | Examples: | relatieve datum | land naam | land code | | vorige maand | België | 5010 | | 2 jaar geleden | Spanje | 6037 | | 2 jaar geleden | Duitsland | 6029 | | 2 jaar geleden | Afghanistan | 6023 | @integratie Scenario: carry over the country of the previous verblijfplaats: '{naam}' immigrated to the Netherlands {relatievedatum} Given the person 'P1' with citizen service number '000000012' And 'P1' emigrated to <land naam> 2 years ago And 'P1' immigrated to the Netherlands 1 years ago 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 | bijhouding_opschort_datum | bijhouding_opschort_reden | | 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 | | P1 | P | 0 | 0 | 000000012 | P1 | And person 'P1' has the following rows in table 'lo3_pl_verblijfplaats' | pl_id | volg_nr | inschrijving_gemeente_code | vertrek_datum | vertrek_land_code | vestiging_datum | vestiging_land_code | | P1 | 0 | 0518 | | | 1 jaar geleden | <land code> | | P1 | 1 | 1999 | 2 jaar geleden | <land code> | | | Examples: | land naam | land code | | België | 5010 | | Spanje | 6037 | | Duitsland | 6029 | | Afghanistan | 6023 | @integratie Scenario: {vandaag, gisteren of morgen x jaar geleden} it was established that {aanduiding} belongs to the category NATO military personnel Given the person 'P1' with citizen service number '000000012' And 2 years ago it was established that 'P1' belongs to the category NATO military personnel 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 | bijhouding_opschort_datum | bijhouding_opschort_reden | | P1 | 0 | 2 jaar geleden | M | 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 | | P1 | P | 0 | 0 | 000000012 | P1 | And person 'P1' has the following rows in table 'lo3_pl_verblijfplaats' | pl_id | volg_nr | inschrijving_gemeente_code | vertrek_datum | vertrek_land_code | aangifte_adreshouding_oms | | P1 | 0 | 0518 | 2 jaar geleden | 0000 | B |