SGHE Banner Operational Data Store
Composite View Source: GURMAIL
| Banner Source Name |
Banner Source Column |
Banner Business Name |
Source Form |
Banner Business Definition |
Banner Business Acronym |
ODS Target |
ODS Target Column |
| |
GURMAIL_ACTIVITY_DATE |
|
NA |
|
|
AG_COMMUNICATION |
ACTIVITY_DATE |
| |
GURMAIL_ADMIN_IDENTIFIER |
|
SUAMAIL |
|
|
AG_COMMUNICATION |
APPLICATION_NUMBER |
| |
GURMAIL_AIDY_CODE |
|
RUAMAIL |
|
|
AG_COMMUNICATION |
AID_YEAR |
| |
GURMAIL_CPLN_CODE |
|
SUAMAIL |
|
|
AG_COMMUNICATION |
COMMUNICATION_PLAN |
| |
GURMAIL_DATE_INIT |
|
AUAMAIL FUAMAIL, PUAMAIL, RUAMAIL, SUAMAIL |
|
|
AG_COMMUNICATION |
DATE_INITIATED |
| |
GURMAIL_DATE_PRINTED |
|
AUAMAIL, FUAMAIL, PUAMAIL, RUAMAIL, SUAMAIL |
|
|
AG_COMMUNICATION |
DATE_PRINTED |
| |
GURMAIL_LETR_CODE |
|
AUAMAIL FUAMAIL, PUAMAIL, RUAMAIL, SUAMAIL |
|
|
AG_COMMUNICATION |
COMMUNICATION |
| |
GURMAIL_MATL_CODE_MOD |
|
SUAMAIL, RUAMAIL |
|
|
AG_COMMUNICATION |
MATERIAL |
| |
GURMAIL_MODULE_CODE |
|
AUAMAIL, RUAMAIL, SUAMAIL |
|
|
AG_COMMUNICATION AG_COMMUNICATION |
COMMUNICATION_SOURCE_DESC COMMUNICATION_SOURCE |
| |
GURMAIL_PIDM |
|
NA |
|
|
AG_COMMUNICATION |
PERSON_UID |
| |
GURMAIL_PUB_GEN |
|
AUAMAIL, FUAMAIL, PUAMAIL, RUAMAIL, SUAMAIL |
|
|
AG_COMMUNICATION |
COMMUNICATION_TYPE |
| |
GURMAIL_QTY |
|
GUAMAIL |
|
|
AG_COMMUNICATION |
QUANTITY |
| |
GURMAIL_SYSTEM_IND |
|
SUAMAIL,RUAMAIL,AUAMAIL,PUAMAIL,FUAMAIL |
|
|
AG_COMMUNICATION |
SYSTEM |
| |
GURMAIL_TERM_CODE |
|
SUAMAIL, RUAMAIL |
|
|
AG_COMMUNICATION |
ACADEMIC_PERIOD |