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