Understanding the Who's Who Batch Upload Program

An address book number must exist in the Address Book Master table before you can upload converted external who's who information. Enter the address book number in the Address Book field of the Batch Who's Who Information table (F0111Z1) when you run the Who's Who Batch Upload program.

The Who's Who Batch Upload program accesses the processed address book records, retrieves the corresponding who's who information in the F0111Z1 table, and uploads it to these tables:

• Address Book - Who's Who (F0111).

• Related Person (F01112).

• Address Book - Phone Numbers (F0115).

• Electronic Address (F01151).

• Alternate Address (F01161).

After the Who's Who Batch Upload program successfully processes a who's who record, the program searches for who's who information in the F01161Z1, F01151Z1, F0115Z1, and F01112Z1 tables using the batch number, transaction number, and user ID from the F0111Z1 table. When the program finds records with values that match those in the Batch Who's Who Information table, it selects those that have not been successfully processed in this order:

1. F01161Z1

2. F01151Z1

3. F01112Z1

4. F0115Z1

When processing phone information, the program uses additional data selection to process phone numbers for related person records first. Then the program processes phone numbers for who's who records. The program uses the value in the EDI Line Number (EDLN) field in the F01112Z1 table to determine whether a phone number record is for a related person or who's who record. The value in the EDLN field is 0 when the phone number record is for a who's who record.

If errors occur on the child records (phone numbers, electronic addresses, and so on) when you run the Who's Who Batch Upload program, you can reprocess them after correcting the errors. The Who's Who Batch Upload report prints both successfully and unsuccessfully processed records.