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