About configuring columns for the Institution ID, Applicant ID and Site ID fields - Brainware for Transcripts - 24.1 - 24.1 - Ready - Brainware - external - Brainware/Brainware-for-Transcripts/24.1/Brainware-for-Transcripts-User-Guide/About-Brainware-for-Transcripts-Solution-Features/About-creating-institution-and-applicant-master-partitions/Configuring-the-Institution-ID-and-Applicant-ID-fields-without-using-a-partition/About-configuring-columns-for-the-Institution-ID-Applicant-ID-and-Site-ID-fields - 2024-10-28

Intelligent Capture does not permit the use of a composite key within the Institution or Applicant file extract, so the two values need to be within a single column if you have a single institution or an applicant at a single address that is represented in the downstream SIS system by a combination of an institution and applicant ID and a site ID.

The nominated separator is specified in the AlphNumSiteSeparator field in Institution Settings for an institution and in Applicant Settings for an applicant. This must be populated and adhered to if you are using alphanumeric Institution or Applicant ID fields and a Site ID field. An error is displayed if this configuration is not followed, or more than one separator is found as part of a single unique identifier.

Therefore, in the CSV Import files for Institution ASE and Applicant ASE, the following columns are required.

• A column representing the combined unique identifier.

• A column representing the site ID.

• A column representing the institution or applicant ID.