You can configure the settings for the validation options available for the course number field for College transcripts. Although these settings are optional, it is recommended that you configure these settings. A table with the coursework information is needed in order to configure this. To configure college coursework settings, complete the following steps in Solution Configuration Manager.
| Parameter | Description |
|---|---|
| Validate From DB | This is the flag to denote whether the course number is validated against course numbers from the same institution in a database table. |
| SQL Connection Group | This is the SQL connection group specifying the course
number validation database connection string as set in the SQL section.
If no connection group is specified, the system uses group 01. Note: This
field is displayed only if Validate From DB check box is selected.
|
| Update DB Export | If selected, the system updates the course number validation table with new course numbers from the current document at the point of document export. If it is not enabled, the BFT solution will not update the course validation table. |
| Course Table | This is the name of the course validation database table. Note: This
field is displayed only if Validate From DB check box is selected.
|
| Inst ID Column | This is a column in the database table that holds the
institution ID. This setting is mandatory. Note: This field is displayed
only if Validate From DB check box is selected.
|
| Site ID Column | This is a column in the database table that holds the
external institution's site ID if applicable. Note: This field
is displayed only if Validate From DB check box is selected.
|
| Course ID Column | This is a column in the database table that holds the
course ID. This column must be a combination of the course subject
and course number, for example MTH101. Note: This field is displayed
only if Validate From DB check box is selected.
|
| Desc Column | This column in the database table that holds the course
description. Note: This field is displayed only if Validate
From DB check box is selected.
|
| Subject Column | This column is mapped from the course subject field in
the coursework validation database table. Note: This field is displayed
only if Validate From DB check box is selected.
|
| Course Number Column | This is a column in the database table that holds the
course number. Note: This field is displayed only if Validate
From DB check box is selected.
|
| Use Internal Inst ID | This is a flag to denote whether the internal SIS institution
ID is used when validating the course number. Note: This field
is displayed only if Validate From DB check box is selected.For
more information, refer to About
configuring the Institution ID and Applicant ID fields without using
a partition
|
| Include Site | This is a flag to denote whether the institution's Site
ID is used when validating the course number. Note: This field
is displayed only if Validate From DB check box is selected.
|
| Remove Inst Lead Zeros | This is a flag to denote whether leading zeros is removed
from the institution ID when validating the course number. Note: This
field is displayed only if Validate From DB check box is selected.
|
| Max Course Number Compare Distance | This is the maximum valid compare distance for the course
number Note: This field is displayed only if Validate From DB check
box is selected. It is recommended not to modify this field unless
necessary.
|
| Max Description Compare Distance | This is the maximum valid compare distance for the course
description. Note: This field is displayed only if Validate
From DB check box is selected. It is recommended not to modify
this field unless necessary.
|