This window allows administrators to create a customized query that will select ID Numbers for which advisor information (stored in the Faculty Master table is to be created or updated in the Advising module from information tracked in the Registration module.
Click the OK button to run the synchronization process, and click the Cancel button to close the window without running the synchronization process.
The General tab is used to select the appropriate query from the drop-down list. All queries have names beginning with q_synch_advisor_info. If you would like to customize the query, it is mandatory that you honor the naming convention; that is, the new query must begin with q_synch_advisor_info. If this is not done, it may not appear as an option in the Query drop-down list.
|
If you customize the query, note that the NameMaster table is used with the ID_NUM column selected. This table and column must remain part of the customized query for this process to function correctly. Another table may be joined to the NameMaster table on the ID_NUM column to produce different result sets. |
You can configure the advisor data to be synchronized (created/updated) by selecting additional options on the Options tab. If you do not select at least one option, the following message appears: "At least one option must be selected on the Options tab." If you receive this message, click OK to return to the Options tab to select at least one of the options (see below).
If you select the Synchronize Advisor Information with Faculty Master checkbox, the three authorization flags (Capacity, Schedule Conflict, and Requisites) on the ADVISOR_MASTER table are synchronized with the respective flags on the Faculty Master table.
You must select at least one of the following options:
Synchronize Advisor Information with Faculty Master