This table holds the mapping between columns in the applicant 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 Applicant Master Mapping, complete the following steps in Solution Configuration Manager.
| Parameter | Description |
|---|---|
| ID | This is the capture ASE column name denoting the applicant
ID. For SIS systems where an applicant at a unique address is represented by a combination of the applicant ID and the site ID, the formula for the ID column must be set to the following. Applicant ID * 1000000 + Site ID If the applicant ID or site ID is alphanumeric, the set the formula to the following. ApplicantID~SiteID The delimiter (~ in the above example) is configurable using the Alph Num Site Separator parameter in the BRWAPT 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 BRWSRA table, and the applicant ID stem must be mapped to EXTERNALID. If the SIS uses an external applicant ID, map this value to EXTERNALID and the internal applicant ID stem can remain unmapped. However, the applicant ID stem component of the ID field is the internal SIS applicant ID. |
| First Name | This is the Capture column name denoting the applicant's first name. |
| Middle Name | This is the Capture ASE column name denoting the applicant's middle name. |
| Last Name | This is the Capture ASE column name denoting the applicant's last name. |
| Address1 | This is the Capture ASE column name denoting the first line of the applicant's address. |
| Address2 | This is the Capture ASE column name denoting the second line of the applicant's address. |
| City | This is the Capture ASE column name denoting the applicant's city of origin. |
| State | This is the Capture ASE column name denoting the applicant's state. |
| Zip | This is the Capture ASE column name denoting the applicant's zip/postal code. |
| Country | This is the Capture ASE column name denoting the applicant's country of origin. |
| Tel No | This is the Capture ASE column name denoting the applicant's telephone number. |
| Date of Birth | This is the Capture ASE column name denoting the applicant's date of birth. |
| Social Security Number | This is the Capture ASE column name denoting the applicant's social security number. |
| App Identifier | This is the Capture ASE column name that represents a unique applicant identifier. For example, SSN. |
| Partition ID | This is the Capture ASE column name that represents the applicant's partition ID. |
| Site ID | This is the Capture ASE column name denoting the applicant
site ID. This should only be mapped if the site ID forms part of the ID column above. |
| External ID | This is the Capture ASE column name denoting the applicant's
external ID . If no external applicant ID is used by the SIS but the combination of an applicant ID and a site ID is used to identify a unique applicant address, this column must be mapped to the applicant ID stem. |
| Custom1 | This is the Capture ASE column name denoting the custom value that can contain additional information about the applicant. |
| Custom2 | This is the Capture ASE column name denoting the custom value that can contain additional information about the applicant. |
| Custom3 | This is the Capture ASE column name denoting the custom value that can contain additional information about the applicant. |
| Custom4 | This is the Capture ASE column name denoting the custom value that can contain additional information about the applicant. |
| Custom5 | This is the Capture ASE column name denoting the custom value that can contain additional information about the applicant. |