Institution Master Mapping - Brainware for Transcripts - 24.1 - 24.1 - Ready - Brainware - external - Brainware/Brainware-for-Transcripts/24.1/Brainware-for-Transcripts-User-Guide/Manage-Brainware-for-Transcripts-Settings/Global-Settings/Institution-Master-Mapping - 2024-10-28

Brainware for Transcripts User Guide
Platform
Brainware
Product
Brainware for Transcripts
Release
24.1
License

This table holds the mapping between columns in the institution master data table and the values used internally within the project. The table is global for the project and works independently of the client and profile. The table should only ever consist of a single row. To configure the Institution Master Mapping, complete the following steps in Solution Configuration Manager.

  1. On the Configure Project page, in the Project list, select the BFT project to be used.
  2. In the Settings drop down list, select Global Settings.
  3. Navigate to Global Settings > Search Settings > Institution Master Mapping.
    For information on specific fields, refer to the following table.
Parameter Description
ID This is the Capture ASE column name denoting the institution ID.

For SIS systems where an institution at a unique address is represented by a combination of the institution ID and the site ID, the formula for the ID column must be set to the following.

Institution ID * 1000000 + Site ID

If the institution ID or site ID is alphanumeric, the formula is the following.

InstitutionID~SiteID

The delimiter (~ in the above example) is configurable via the AlphNumSiteSeparator parameter in the BRWINS table. The system raises a configuration error if no delimiter is specified, if it is more than one character, or it does not occur, occurs more than once, or occurs as the first character in the unique ASE ID column.

The site ID must be mapped to SITEID in the BRWSRC table and the institution ID stem must be mapped to EXTERNALID. If the SIS uses an external institution ID, map this value to EXTERNALID, and the internal institution ID stem can remain unmapped. However, the institution ID stem component of the ID field is the internal SIS institution ID.
SiteID This is the Capture ASE column name denoting the institution site ID.

This should only be mapped if the site ID forms part of the ID column above.
Name This is the Capture ASE column name denoting the institution's name.
Address1 This is the Capture ASE column name denoting the first line of the institution's address.
Address2 This is the Capture ASE column name denoting the second line of the institution's address.
City This is the Capture ASE column name denoting the institution's city of origin.
State This is the Capture ASE column name denoting the institution's state.
Zip This is the Capture ASE column name denoting the institution's zip/postal code.
Country This is the Capture ASE column name denoting the institution's country of origin.
TelNo This is the Capture ASE column name denoting the institution's telephone number.
CEEB This is the Capture ASE column name denoting the institution's CEEB code.
ACT This is the Capture ASE column name denoting the institution's ACT code number.
FICE This is the Capture ASE column name denoting the institution's FICE code.
OPEID This is the Capture ASE column name denoting the institution's OPE ID.
PartitionID This is the Capture ASE column name that represents the institution's partition ID.
ExternalID This is the Capture ASE column name denoting the institution's external ID.

If no external institution ID is used by the SIS but the combination of an institution ID and a site ID is used to identify a unique institution address, this column must be mapped to the institution ID stem.