Open topic with navigation

Load Prospect Address Correction File

After the batch process has been run through Intelligent Search Technology, Ltd, the next step in this process is to load the corrected batch into CAMS. As part of this load process, CAMS will create a new entry for the previously designated address type, marking the original entry as Inactive and the new entry as Active. If the prospect also has a student record and/or a development record then the corrected address is displayed in those modules as well provided that a link has been established through the Student Load or Constituent Transfer processes.

To load Address correction file:

  1. Return to the CAMS Enterprise Prospect Address Validation screen (Admissions >Prospects >Address Correction) and click the Load tab.
  2. Navigate to the location of the returned file. The path must be in UNC format (cannot be a C:\ type path).
  3. Click Load Batch File. The list of names and the corrected address information display.
  4. Click the Insert tab to map the new address record fields into Prospect records in CAMS. New address record fields will only need to be mapped once to include all Prospects in the import file.
  5. Select the import file field name in the Select Options drop-down then select the CAMS field in the Field drop-down. Click Append to add that import field to the CAMS field.
  6. Multiple import fields can be linked or merged into one CAMS field by simply selecting another import field then click Append to merge the additional field(s) into the same CAMS field. In the example above, the Street Number and Street Name have been linked into the CAMS Address 1 field and the import file Apt Name and Apt Number have been linked into the CAMS Address 2 field.
  7. If an incorrect import field is appended, you can highlight and delete any of the appended fields scroll box to clear the data.
  8. Click Build SQL. CAMS will build the SQL statement to merge the fields and display the Process tab.
  9. The Process Results page displays with the SQL script that will run to enter the verified addresses into CAMS Enterprise.
  10. Click Execute SQL. The corrected addresses are inserted into the prospects’ records.

Note: If the file to be loaded contains a large amount of addresses certain timeout settings should be changed to ensure that the file is completely loaded into CAMS Enterprise.

Related Topics Link IconRelated Topics