RETURN TO REPORTING VIEW REPORTS LIST
Composite View Source: GURMAIL Common Reporting View Meta Data Reports
SGHE Operational Data Store Reporting View Source: GURMAIL

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_PLAN5

COMMUNICATION_PLAN2

COMMUNICATION_PLAN4

COMMUNICATION_PLAN3

NA
GURMAIL_DATE_INIT AUAMAIL FUAMAIL, PUAMAIL, RUAMAIL, SUAMAIL

REPORTING VIEW

COMMUNICATION_SLOT

COMMUNICATION_SLOT

COMMUNICATION_SLOT

COMMUNICATION_SLOT

COMMUNICATION_SLOT

COMMUNICATION

DATE_INITIATED4

DATE_INITIATED1

DATE_INITIATED3

DATE_INITIATED5

DATE_INITIATED2

DATE_INITIATED

NA
GURMAIL_DATE_PRINTED AUAMAIL, FUAMAIL, PUAMAIL, RUAMAIL, SUAMAIL

REPORTING VIEW

COMMUNICATION_SLOT

COMMUNICATION

COMMUNICATION_SLOT

COMMUNICATION_SLOT

COMMUNICATION_SLOT

COMMUNICATION_SLOT

DATE_PRINTED3

DATE_PRINTED

DATE_PRINTED2

DATE_PRINTED4

DATE_PRINTED1

DATE_PRINTED5

NA
GURMAIL_LETR_CODE AUAMAIL FUAMAIL, PUAMAIL, RUAMAIL, SUAMAIL

REPORTING VIEW

COMMUNICATION_SLOT

COMMUNICATION_SLOT

COMMUNICATION

COMMUNICATION_SLOT

COMMUNICATION_SLOT

COMMUNICATION_SLOT

COMMUNICATION1

COMMUNICATION3

COMMUNICATION

COMMUNICATION2

COMMUNICATION5

COMMUNICATION4

NA
GURMAIL_MATL_CODE_MOD SUAMAIL, RUAMAIL

REPORTING VIEW

COMMUNICATION_SLOT

COMMUNICATION_SLOT

COMMUNICATION_SLOT

COMMUNICATION

COMMUNICATION_SLOT

COMMUNICATION_SLOT

MATERIAL3

MATERIAL4

MATERIAL5

MATERIAL

MATERIAL1

MATERIAL2

NA
GURMAIL_MODULE_CODE AUAMAIL, RUAMAIL, SUAMAIL

REPORTING VIEW

COMMUNICATION

COMMUNICATION_SLOT

COMMUNICATION_SLOT

COMMUNICATION_SLOT

COMMUNICATION_SLOT

COMMUNICATION_SLOT

COMMUNICATION_SOURCE

COMMUNICATION_SOURCE2

COMMUNICATION_SOURCE4

COMMUNICATION_SOURCE1

COMMUNICATION_SOURCE5

COMMUNICATION_SOURCE3

NA
GURMAIL_PIDM NA

REPORTING VIEW

COMMUNICATION_SLOT

COMMUNICATION

PERSON_UID

PERSON_UID

NA
GURMAIL_PUB_GEN AUAMAIL, FUAMAIL, PUAMAIL, RUAMAIL, SUAMAIL

REPORTING VIEW

COMMUNICATION_SLOT

COMMUNICATION_SLOT

COMMUNICATION_SLOT

COMMUNICATION_SLOT

COMMUNICATION

COMMUNICATION_SLOT

COMMUNICATION_TYPE4

COMMUNICATION_TYPE3

COMMUNICATION_TYPE2

COMMUNICATION_TYPE5

COMMUNICATION_TYPE

COMMUNICATION_TYPE1

NA
GURMAIL_QTY GUAMAIL

REPORTING VIEW

COMMUNICATION

QUANTITY

NA
GURMAIL_SYSTEM_IND SUAMAIL,RUAMAIL,AUAMAIL,PUAMAIL,FUAMAIL

REPORTING VIEW

COMMUNICATION_SLOT

COMMUNICATION_SLOT

COMMUNICATION

COMMUNICATION_SLOT

COMMUNICATION_SLOT

COMMUNICATION_SLOT

SYSTEM4

SYSTEM5

SYSTEM

SYSTEM3

SYSTEM2

SYSTEM1

NA
GURMAIL_TERM_CODE SUAMAIL, RUAMAIL

REPORTING VIEW

COMMUNICATION

ACADEMIC_PERIOD

NA


Ver: 3.1