The Import Utility utilizes several data, definition, and processing tables. These tables are prefixed with 'IU' to associate them with the Import Utility.
The following tables are used to temporarily hold the data to be imported during processing of data through the Import Utility:
Import Utility Table |
Corresponding J1 Master Table |
IU_ADDRESS |
AddressMaster |
IU_BIOGRAPH |
BIOGRAPH_MASTER |
IU_CANDIDACY |
CANDIDACY |
IU_CANDIDATE |
CANDIDATE |
IU_NAME |
NameMaster |
IU_SCORES_DETAIL |
TEST_SCORES_DETAIL |
IU_TEST_SCORES |
TEST_SCORES |
IU_ETHNIC_RACE_RPT |
ETHNIC_RACE_REPORT |
IU_ETHNIC_RPT_DTL |
ETHNIC_REPORT_DTL |
IU_RACE_RPT_DTL |
RACE_REPORT_DTL |
IU_MAP |
Not currently used |
IU_SOURCE_COLUMNS |
Not currently used |
IU_TEMPLATE |
Not currently used |
IU_TRANSLATE |
Not currently used |
In addition to containing all of the columns defined in the production tables, each of the above IU tables contains sequence number (SEQ) and temporary ID Number (TEMP_ID) columns, which are used by the import processes. The SEQ column and TEMP_ID must be filled when populating the IU data tables. While each sequence number needs to be unique according to the table in which the data is placed, the temporary ID Number will be the same for every occurrence that appears in the Import Utility for the same person.
|
Temporary ID Number 9 could have a sequence number of 2 on the Name tab and a sequence number of 5 on the Biography tab. This is required to ensure that all of the data in the various import tables for a particular individual is associated with the same ID Number upon import into the J1 tables. This will also make it easy to delete an entire ID Number and all of its associated information when it has been identified as a duplicate. |
The following tables are also used by the Import Utility process:
Import Utility Table |
Description |
IU_DUPLICATES |
Contains temporary ID Numbers identified as duplicates and processing options for each ID Number |
IU_ERROR_LOG |
Includes a list of errors found during the Check Database and/or Upload Data processes |
IU_UPLOAD_CRITERIA |
Defines the columns to import and to use for the duplicate checking and which are required for import |
