Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Composite View Source: GURMAIL Common Reporting View Meta Data Reports
Banner Operational Data Store Reporting View Source: GURMAIL - NULL

Source Column Source Form Local Source Target Type Target Target Column Local Target Calculation Formula
GURMAIL_ACTIVITY_DATE NA NO

REPORTING VIEW

COMMUNICATION

ACTIVITY_DATE

NO

 
GURMAIL_ADMIN_IDENTIFIER SUAMAIL NO

REPORTING VIEW

COMMUNICATION

APPLICATION_NUMBER

NO

NA
GURMAIL_AIDY_CODE RUAMAIL NO

REPORTING VIEW

COMMUNICATION

AID_YEAR

NO

NA
GURMAIL_CPLN_CODE SUAMAIL NO

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

NO

NO

NO

NO

NO

NO

NA
GURMAIL_DATE_INIT AUAMAIL FUAMAIL, PUAMAIL, RUAMAIL, SUAMAIL NO

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

NO

NO

NO

NO

NO

NO

NA
GURMAIL_DATE_PRINTED AUAMAIL, FUAMAIL, PUAMAIL, RUAMAIL, SUAMAIL NO

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

NO

NO

NO

NO

NO

NO

NA
GURMAIL_LETR_CODE AUAMAIL FUAMAIL, PUAMAIL, RUAMAIL, SUAMAIL NO

REPORTING VIEW

COMMUNICATION_SLOT

COMMUNICATION_SLOT

COMMUNICATION_SLOT

COMMUNICATION_SLOT

COMMUNICATION_SLOT

COMMUNICATION

COMMUNICATION1

COMMUNICATION3

COMMUNICATION2

COMMUNICATION4

COMMUNICATION5

COMMUNICATION

NO

NO

NO

NO

NO

NO

NA
GURMAIL_MATL_CODE_MOD SUAMAIL, RUAMAIL NO

REPORTING VIEW

COMMUNICATION_SLOT

COMMUNICATION_SLOT

COMMUNICATION_SLOT

COMMUNICATION

COMMUNICATION_SLOT

COMMUNICATION_SLOT

MATERIAL3

MATERIAL2

MATERIAL4

MATERIAL

MATERIAL5

MATERIAL1

NO

NO

NO

NO

NO

NO

NA
GURMAIL_MODULE_CODE AUAMAIL, RUAMAIL, SUAMAIL NO

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

NO

NO

NO

NO

NO

NO

NA
GURMAIL_PIDM NA NO

REPORTING VIEW

COMMUNICATION

COMMUNICATION_SLOT

PERSON_UID

PERSON_UID

NO

NO

NA
GURMAIL_PUB_GEN AUAMAIL, FUAMAIL, PUAMAIL, RUAMAIL, SUAMAIL NO

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

NO

NO

NO

NO

NO

NO

NA
GURMAIL_QTY GUAMAIL NO

REPORTING VIEW

COMMUNICATION

QUANTITY

NO

NA
GURMAIL_SYSTEM_IND SUAMAIL,RUAMAIL,AUAMAIL,PUAMAIL,FUAMAIL NO

REPORTING VIEW

COMMUNICATION

COMMUNICATION_SLOT

COMMUNICATION_SLOT

COMMUNICATION_SLOT

COMMUNICATION_SLOT

COMMUNICATION_SLOT

SYSTEM

SYSTEM2

SYSTEM3

SYSTEM5

SYSTEM4

SYSTEM1

NO

NO

NO

NO

NO

NO

NA
GURMAIL_TERM_CODE SUAMAIL, RUAMAIL NO

REPORTING VIEW

COMMUNICATION

ACADEMIC_PERIOD

NO

NA


Ver: 9.2