Banner Operational Data Store
Reporting View Source: GURMAIL - NULL
| Source Column |
Source Form |
Target Type |
Target |
Target Column |
Calculation Formula |
| GURMAIL_ACTIVITY_DATE |
NA |
REPORTING VIEW |
COMMUNICATION |
ACTIVITY_DATE |
|
| GURMAIL_ADMIN_IDENTIFIER |
SUAMAIL |
REPORTING VIEW |
COMMUNICATION |
APPLICATION_NUMBER |
NA |
| GURMAIL_AIDY_CODE |
RUAMAIL |
REPORTING VIEW |
COMMUNICATION |
AID_YEAR |
NA |
| GURMAIL_CPLN_CODE |
SUAMAIL |
REPORTING VIEW |
COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION COMMUNICATION_SLOT |
COMMUNICATION_PLAN1 COMMUNICATION_PLAN2 COMMUNICATION_PLAN4 COMMUNICATION_PLAN3 COMMUNICATION_PLAN COMMUNICATION_PLAN5 |
NA |
| GURMAIL_DATE_INIT |
AUAMAIL FUAMAIL, PUAMAIL, RUAMAIL, SUAMAIL |
REPORTING VIEW |
COMMUNICATION_SLOT COMMUNICATION COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT |
DATE_INITIATED4 DATE_INITIATED DATE_INITIATED1 DATE_INITIATED2 DATE_INITIATED3 DATE_INITIATED5 |
NA |
| GURMAIL_DATE_PRINTED |
AUAMAIL, FUAMAIL, PUAMAIL, RUAMAIL, SUAMAIL |
REPORTING VIEW |
COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT |
DATE_PRINTED4 DATE_PRINTED2 DATE_PRINTED DATE_PRINTED1 DATE_PRINTED3 DATE_PRINTED5 |
NA |
| GURMAIL_LETR_CODE |
|
REPORTING VIEW
REPORTING VIEW |
COMMUNICATION COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT |
COMMUNICATION COMMUNICATION4 COMMUNICATION1 COMMUNICATION2 COMMUNICATION3 COMMUNICATION5 COMMUNICATION COMMUNICATION4 COMMUNICATION1 COMMUNICATION2 COMMUNICATION3 COMMUNICATION5 |
|
| GURMAIL_MATL_CODE_MOD |
SUAMAIL, RUAMAIL |
REPORTING VIEW |
COMMUNICATION_SLOT COMMUNICATION COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT |
MATERIAL1 MATERIAL MATERIAL2 MATERIAL4 MATERIAL5 MATERIAL3 |
NA |
| GURMAIL_MODULE_CODE |
AUAMAIL, RUAMAIL, SUAMAIL |
REPORTING VIEW |
COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT |
COMMUNICATION_SOURCE5 COMMUNICATION_SOURCE4 COMMUNICATION_SOURCE COMMUNICATION_SOURCE2 COMMUNICATION_SOURCE3 COMMUNICATION_SOURCE1 |
NA |
| GURMAIL_PIDM |
NA |
REPORTING VIEW |
COMMUNICATION_SLOT COMMUNICATION |
PERSON_UID PERSON_UID |
NA |
| GURMAIL_PUB_GEN |
AUAMAIL, FUAMAIL, PUAMAIL, RUAMAIL, SUAMAIL |
REPORTING VIEW |
COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT |
COMMUNICATION_TYPE3 COMMUNICATION_TYPE5 COMMUNICATION_TYPE COMMUNICATION_TYPE2 COMMUNICATION_TYPE4 COMMUNICATION_TYPE1 |
NA |
| GURMAIL_QTY |
GUAMAIL |
REPORTING VIEW |
COMMUNICATION |
QUANTITY |
NA |
| GURMAIL_SYSTEM_IND |
|
REPORTING VIEW
REPORTING VIEW |
COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION_SLOT COMMUNICATION |
SYSTEM1 SYSTEM3 SYSTEM2 SYSTEM4 SYSTEM5 SYSTEM SYSTEM1 SYSTEM3 SYSTEM2 SYSTEM4 SYSTEM5 SYSTEM |
|
| GURMAIL_TERM_CODE |
SUAMAIL, RUAMAIL |
REPORTING VIEW |
COMMUNICATION |
ACADEMIC_PERIOD |
NA |