SGHE Banner Operational Data Store
Composite View Source: GURMAIL - NULL
| Source Column |
Source Form |
Target Type |
Target |
Target Column |
Calculation Formula |
| GURMAIL_ACTIVITY_DATE |
NA |
COMPOSITE VIEW |
AG_COMMUNICATION |
ACTIVITY_DATE |
|
| GURMAIL_ADMIN_IDENTIFIER |
SUAMAIL |
COMPOSITE VIEW |
AG_COMMUNICATION |
APPLICATION_NUMBER |
NA |
| GURMAIL_AIDY_CODE |
RUAMAIL |
COMPOSITE VIEW |
AG_COMMUNICATION |
AID_YEAR |
NA |
| GURMAIL_CPLN_CODE |
SUAMAIL |
COMPOSITE VIEW |
AG_COMMUNICATION |
COMMUNICATION_PLAN |
NA |
| GURMAIL_DATE_INIT |
AUAMAIL FUAMAIL, PUAMAIL, RUAMAIL, SUAMAIL |
COMPOSITE VIEW |
AG_COMMUNICATION |
DATE_INITIATED |
NA |
| GURMAIL_DATE_PRINTED |
AUAMAIL, FUAMAIL, PUAMAIL, RUAMAIL, SUAMAIL |
COMPOSITE VIEW |
AG_COMMUNICATION |
DATE_PRINTED |
NA |
| GURMAIL_LETR_CODE |
AUAMAIL FUAMAIL, PUAMAIL, RUAMAIL, SUAMAIL |
COMPOSITE VIEW |
AG_COMMUNICATION |
COMMUNICATION |
NA |
| GURMAIL_MATL_CODE_MOD |
SUAMAIL, RUAMAIL |
COMPOSITE VIEW |
AG_COMMUNICATION |
MATERIAL |
NA |
| GURMAIL_MODULE_CODE |
AUAMAIL, RUAMAIL, SUAMAIL |
COMPOSITE VIEW |
AG_COMMUNICATION AG_COMMUNICATION |
COMMUNICATION_SOURCE COMMUNICATION_SOURCE_DESC |
NA |
| GURMAIL_PIDM |
NA |
COMPOSITE VIEW |
AG_COMMUNICATION |
PERSON_UID |
NA |
| GURMAIL_PUB_GEN |
AUAMAIL, FUAMAIL, PUAMAIL, RUAMAIL, SUAMAIL |
COMPOSITE VIEW |
AG_COMMUNICATION |
COMMUNICATION_TYPE |
NA |
| GURMAIL_QTY |
GUAMAIL |
COMPOSITE VIEW |
AG_COMMUNICATION |
QUANTITY |
NA |
| GURMAIL_SYSTEM_IND |
SUAMAIL,RUAMAIL,AUAMAIL,PUAMAIL,FUAMAIL |
COMPOSITE VIEW |
AG_COMMUNICATION |
SYSTEM |
NA |
| GURMAIL_TERM_CODE |
SUAMAIL, RUAMAIL |
COMPOSITE VIEW |
AG_COMMUNICATION |
ACADEMIC_PERIOD |
NA |