Code of the Month

Current Active GSU Email Address for each Student

Posted On July 8, 2013
Categories Code of the Month

The email addresses for students are stored in the GOREMAL table.  There are several emails stored per student.  This post describes what to code for to obtain the current active “GSU” email address for each student.

 

Fields from GOREMAL table:

GOREMAL_PIDM

GOREMAL_EMAL_CODE

GOREMAL_EMAIL_ADDRESS

GOREMAL_STATUS_IND

GOREMAL_PREFERRED_IND

GOREMAL_DISP_WEB_IND

 

Parameters:

GOREMAL_EMAL_CODE = ‘GSU’

GOREMAL_STATUS_IND = ‘A’

… more »