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