Loading...
 

DegreeWorks.BAN080

HS_GRAD:COLUMN

SureCode BAN080 HS_GRAD:COLUMN prior to change made to look for the various codes that represent ‘NO’: See attachment below


SureCode BAN080 HS_GRAD:COLUMN after the change is made to look for the various codes that represent ‘NO’: See attachment below


NOTE: The Null portion of the decode does work. If a Null in Banner is see in DegreeWorks as a Null (blank) in the HS field than there is a space or some other issue with the field in Banner. To resolve have the field populated and then have the code removed. After that is done refresh the account and the change should be made to 'NO'.

HS_GRAD:ORDERBY

An ORDERBY had to be added to SureCode for the HS_GRAD field to allow DegreeWorks to show the most current entry in the SOAHSCH_DPLM_CODE field. See the attached file titled SureCode HS_GRAD ORDERBY for details.