SGHE Banner Operational Data Store
Reporting 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 |
|
|
COMMUNICATION |
ACTIVITY_DATE |
| |
GURMAIL_ADMIN_IDENTIFIER |
|
SUAMAIL |
|
|
COMMUNICATION |
APPLICATION_NUMBER |
| |
GURMAIL_AIDY_CODE |
|
RUAMAIL |
|
|
COMMUNICATION |
AID_YEAR |
| |
GURMAIL_CPLN_CODE |
|
SUAMAIL |
|
|
COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION |
COMMUNICATION_PLAN1 COMMUNICATION_PLAN4 COMMUNICATION_PLAN5 COMMUNICATION_PLAN2 COMMUNICATION_PLAN3 COMMUNICATION_PLAN |
| |
GURMAIL_DATE_INIT |
|
AUAMAIL FUAMAIL, PUAMAIL, RUAMAIL, SUAMAIL |
|
|
COMMUNICATION_SLOT COMMUNICATION COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT |
DATE_INITIATED1 DATE_INITIATED DATE_INITIATED5 DATE_INITIATED4 DATE_INITIATED3 DATE_INITIATED2 |
| |
GURMAIL_DATE_PRINTED |
|
AUAMAIL, FUAMAIL, PUAMAIL, RUAMAIL, SUAMAIL |
|
|
COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION COMMUNICATION_SLOT |
DATE_PRINTED2 DATE_PRINTED3 DATE_PRINTED1 DATE_PRINTED4 DATE_PRINTED DATE_PRINTED5 |
| |
GURMAIL_LETR_CODE |
|
AUAMAIL FUAMAIL, PUAMAIL, RUAMAIL, SUAMAIL |
|
|
COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION |
COMMUNICATION3 COMMUNICATION4 COMMUNICATION1 COMMUNICATION2 COMMUNICATION5 COMMUNICATION |
| |
GURMAIL_MATL_CODE_MOD |
|
SUAMAIL, RUAMAIL |
|
|
COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION |
MATERIAL5 MATERIAL3 MATERIAL2 MATERIAL1 MATERIAL4 MATERIAL |
| |
GURMAIL_MODULE_CODE |
|
AUAMAIL, RUAMAIL, SUAMAIL |
|
|
COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION COMMUNICATION_SLOT COMMUNICATION_SLOT |
COMMUNICATION_SOURCE2 COMMUNICATION_SOURCE5 COMMUNICATION_SOURCE1 COMMUNICATION_SOURCE COMMUNICATION_SOURCE3 COMMUNICATION_SOURCE4 |
| |
GURMAIL_PIDM |
|
NA |
|
|
COMMUNICATION COMMUNICATION_SLOT |
PERSON_UID PERSON_UID |
| |
GURMAIL_PUB_GEN |
|
AUAMAIL, FUAMAIL, PUAMAIL, RUAMAIL, SUAMAIL |
|
|
COMMUNICATION COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT |
COMMUNICATION_TYPE COMMUNICATION_TYPE2 COMMUNICATION_TYPE4 COMMUNICATION_TYPE5 COMMUNICATION_TYPE3 COMMUNICATION_TYPE1 |
| |
GURMAIL_QTY |
|
GUAMAIL |
|
|
COMMUNICATION |
QUANTITY |
| |
GURMAIL_SYSTEM_IND |
|
SUAMAIL,RUAMAIL,AUAMAIL,PUAMAIL,FUAMAIL |
|
|
COMMUNICATION_SLOT COMMUNICATION COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT |
SYSTEM4 SYSTEM SYSTEM1 SYSTEM5 SYSTEM2 SYSTEM3 |
| |
GURMAIL_TERM_CODE |
|
SUAMAIL, RUAMAIL |
|
|
COMMUNICATION |
ACADEMIC_PERIOD |