Page Comparison

...

Addresses that were successfully bulk-loaded will have a date in the field load_tms and a NULL value in the field exception_text.

Code Block

language	sql

SELECT-- Count recordsSELECT *
FROM   bulkloader.address_extract
WHERE  NOT(load_tms IS NULL)
       AND (exception_text IS NULL); -- Successfully bulk-loaded.

The presence of exception text indicates a problem with the source data.

Code Block

language	sql

SELECT *
FROM   bulkloader.address_extract
WHERE  NOT(exception_text IS NULL); -- Bulk-load exception.

To rectify bulk-load exceptions, do not correct any exception records in the output table bulkloader.address_extract. Instead, correct the corresponding records in the source data and then re-run the Bulk Loader.

If block and lot values were included in the input data, a value should be found in the field address_x_parcel_id.

Code Block

language	sql

SELECT *
FROM   bulkloader.address_extract
WHERE  NOT(address_x_parcel_id IS NULL); -- Block and lot values were included in the input data.

SELECT *
FROM   bulkloader.address_extract
WHERE  (address_x_parcel_id IS NULL); -- Block and lot values were *not* included in the input data

Base addresses that were submitted by the Bulk Loader but were already in the EAS are indicated by values in the fields address_base_id and load_tms, and NULL values in the fields street_segment, zone_id or exception_text.

Code Block

language	sql

SELECT *
FROM   bulkloader.address_extract
WHERE  NOT(address_base_id IS NULL)
        AND NOT(load_tms IS NULL)
        AND (street_segment_id IS NULL)
        AND (zone_id IS NULL)
        AND (exception_text IS NULL); -- Base addresses that were already in the EAS.

...

Versions Compared

Old Version 5

New Version 6

Key