Loading...
 

DegreeWorks.bannerextract.config

NOTE:After changing the bannerextract.config file you must run daprestrat and webrestart in putty for the changes to take correctly.

The Course Link popup box was showing all class sections regardless of whether the section was active or not.
The change had to be made in the SSBSECT section of the bannerextract.config file.

The original code was:
################### SSBSECT - SCHEDULE (ban40) ########################

# SSBSECT must be a; AND is required at the end of the WHERE # The following SQL will be added to the WHERE clause by ban40 for the # specific cases below. You may add additional WHERE requirements here. SSBSECT-from: FROM SSBSECT a SSBSECT-where: WHERE

The modified code is:
################### SSBSECT - SCHEDULE (ban40) ########################

# SSBSECT must be a; AND is required at the end of the WHERE # The following SQL will be added to the WHERE clause by ban40 for the # specific cases below. You may add additional WHERE requirements here. SSBSECT-from: FROM SSBSECT a SSBSECT-where: WHERE a.SSBSECT_SSTS_CODE = 'A' AND

Student Attribute

In order to exclude the attribute codes of WDWD, CSON, and NSSN, the following original section of the bannerextract.config file had to be modified.

################### SGRSATT - STUDENT ATTRIBUTES (ban40) ##############

# SGRSATT must be a; AND is required at the end of the WHERE SGRSATT-from: FROM SGRSATT a SGRSATT-where: WHERE a.SGRSATT_TERM_CODE_EFF = SGRSATT-where: (SELECT MAX(b.SGRSATT_TERM_CODE_EFF) SGRSATT-where: FROM SGRSATT b SGRSATT-where: WHERE b.SGRSATT_PIDM = a.SGRSATT_PIDM) SGRSATT-where: AND # a.SGRSATT_PIDM = <students-pidm>

This is the modified section of the bannerextract.config file:

################### SGRSATT - STUDENT ATTRIBUTES (ban40) ##############

# SGRSATT must be a; AND is required at the end of the WHERE SGRSATT-from: FROM SGRSATT a SGRSATT-where: WHERE a.SGRSATT_ATTS_CODE not in SGRSATT-where: ('WDWD','CSON','NSSN') AND SGRSATT-where: a.SGRSATT_TERM_CODE_EFF = SGRSATT-where: (SELECT MAX(b.SGRSATT_TERM_CODE_EFF) SGRSATT-where: FROM SGRSATT b SGRSATT-where: WHERE b.SGRSATT_PIDM = a.SGRSATT_PIDM) SGRSATT-where: AND # a.SGRSATT_PIDM = <students-pidm>

Locate the bannerextract.config in PROD at:(FIRST USE THE DWTEST FILE TO TEST!!)