Municipality Data
The 118 Inquiry Service requires that all Telephone Subscriptions sent in the XML files to 118 contains Municipality Data. Municipality Numbers and Street Numbers are retrieved from CPR's website and saved in the STREET_REGISTER table. When the 118 Export is processing each address linked to a Telephone Subscription is looked up in the STREET_REGISTER table and if matched the Data is saved in the XML file.
If Municipality Data and Street Number Data is missing from the XML entities there is a high propability that the missing data is caused by a typo.
To investigate the missing data try to look for USERS entries with a missing match in STREET_REGISTER.
SELECT u.*
FROM SERVICE s, SUBSCRIPTION su, USERS u,ZIP_CODE z, SERVICE_OPTION so, PRODUCT_OPTION po, EXTRACT118_CONF ec
WHERE s.SUBSCRIPTION_ID = su.ID
AND su.OWNER_ID = u.ID
AND su.ACCOUNT_ID = u.ACCOUNT_ID
AND su.STATUS_ID = 2
AND s.CODE = ec.CODE
AND u.zip = z.zip
AND s.id = so.service_id
AND po.id = so.product_option_id
AND po.option_key in (select option_key from EXTRACT118_CONF where is_option_key_field = 'Y')
and not exists
(select 1 from STREET_REGISTER sr where upper(sr.streetname) = upper(u.street) and sr.zipcode = u.zip);
;
The result should be the USERS which would be grabbed for 118 Export where the Street name and Zip code would not render a match in the Street Register table.
Examples
Below are examples of Street names and Zip code pairs that will cause missing Municipality Data in the XML files.
| Example street | Example ZIP | Fix | Description |
|---|---|---|---|
| Kai Lindbergsgade | 7730 | Change street to 'Kai Lindbergs Gade' | Here the STREET_REGISTER table will tell you that the street has been spelled wrong, which will cause no match to be found in the STREET_REGISTER table. |
| Lautrupbjerg 12 | 2750 | Change street to 'Lautrupbjerg' and put 45 in Street Number. | Here the Street field in the USERS entry contains a Street number which will cause no match to be found in the STREET_REGISTER table. |
| Lautrupbjerg | 2800 | Change ZIP code to 2750 | Here the ZIP code field in the USERS entry contains the wrong ZIP code for the address, which will cause no match to be found in the STREET_REGISTER table. |