We will provision email lists to a SQL table, and have a job to pull those memberships and populate lists in listserv.
Associate a group with an email list
Tables
Groups
Users
Memberships
View for integration
CREATE VIEW listserv_integration_emails_v as SELECT lig.EMAIL_LIST_NAME, liu.EMAIL FROM LISTSERV_INTEGRATION_GROUPS lig , LISTSERV_INTEGRATION_USERS liu , LISTSERV_INTEGRATION_MSHIPS lim WHERE lig.GROUP_UUID = lim.GROUP_UUID AND liu.PENN_ID = lim.PENN_ID AND liu.EMAIL IS NOT NULL