RETURN TO COMPOSITE VIEW REPORTS LIST
Common Composite View Reports

SGHE Operational Data Store
Composite View Target: AG_COMMUNICATION

Description Source composite view contains person mailing/communication information.

Target Column Business Definition Database Data Type Source Name Source Column
ACADEMIC_PERIOD Academic period or time frame associated with the communication or material sent to the person. VARCHAR2(6)

GURMAIL

GURMAIL_TERM_CODE

ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

ACADEMIC_YEAR Academic year associated with the academic period on this record. VARCHAR2(4)

STVTERM

STVTERM_ACYR_CODE

ACADEMIC_YEAR_DESC Academic year description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

ACTIVITY_DATE Date the record was created or last updated. DATE

GURMAIL

GURMAIL_ACTIVITY_DATE

AID_YEAR Aid year associated with this record. For example, aid year 0304 or aid year 0405. VARCHAR2(4)

GURMAIL

GURMAIL_AIDY_CODE

AID_YEAR_DESC Financial aid year name. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

APPLICATION_NUMBER Application number for the admission application record for a specific academic period. NUMBER(2)

GURMAIL

GURMAIL_ADMIN_IDENTIFIER

COMMUNICATION Letter, email, web notice or material, etc. communication type associated with this record. VARCHAR2(15)

GURMAIL

GURMAIL_LETR_CODE

COMMUNICATION_DESC Communication description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

COMMUNICATION_PLAN Communication plan used to add the communication material or letter. VARCHAR2(4)

GURMAIL

GURMAIL_CPLN_CODE

COMMUNICATION_PLAN_DESC Communication plan description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

COMMUNICATION_SOURCE Department or office responsible for performing, scheduling and/or sending this communication. VARCHAR2(1)

GURMAIL

GURMAIL_MODULE_CODE

COMMUNICATION_SOURCE_DESC Communication source description. VARCHAR2(30)    
COMMUNICATION_TYPE Type of communication represented in this record. It may be a pre-printed, published material or a generated material or action, etc. VARCHAR2(1)

GURMAIL

GURMAIL_PUB_GEN

COMMUNICATION_TYPE_DESC Communication type description. VARCHAR2(40)

CALCULATION

DECODE(GURMAIL_PUB_GEN,'P','PRE-PRINTED OR PUBLISHED MATERIAL','G','GENERATED MATERIAL')

CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

DATE_INITIATED Date the communication or material was initiated or scheduled. DATE

GURMAIL

GURMAIL_DATE_INIT

DATE_PRINTED Date the communication or material was completed. DATE

GURMAIL

GURMAIL_DATE_PRINTED

DATE_SENT Date the communication or material was sent. DATE

CALCULATION

DECODE(GURMAIL_MISC_DATE,NULL,GURMAIL_DATE_PRINTED)

DEGREE Degree or award code associated with the academic study. VARCHAR2(0)

NA

NA

DEGREE_DESC Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc. VARCHAR2(0)

NA

NA

DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

MAJOR Major for the curriculum associated with the communication material. VARCHAR2(0)

NA

NA

MAJOR_DESC Major or subject area description. VARCHAR2(0)

NA

NA

MATERIAL Material code (if any) associated with the communication material. VARCHAR2(4)

GURMAIL

GURMAIL_MATL_CODE_MOD

MATERIAL_DESC Material code description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

MIF_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)

NA

NA

PENDING_LETTER_IND Indicates whether the communication material is pending or it has been completed. VARCHAR2(1)

CALCULATION

DECODE(GURMAIL_DATE_PRINTED,NULL,'Y','N')

PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER(8)

GURMAIL

GURMAIL_PIDM

PROGRAM Curriculum program associated with the communication material. VARCHAR2(0)

NA

NA

PROGRAM_DESC Curriculum program description. VARCHAR2(0)

NA

NA

QUANTITY Quantity of materials, letters or other correspondence tracked. NUMBER(3)

GURMAIL

GURMAIL_QTY

SUB_ACADEMIC_PERIOD A session, portion or part of the academic period. VARCHAR2(0)

NA

NA

SUB_ACADEMIC_PERIOD_DESC Sub academic period description. VARCHAR2(0)

NA

NA

SYSTEM Business area that initiated the communication or material to be sent to the person. VARCHAR2(2)

GURMAIL

GURMAIL_SYSTEM_IND

SYSTEM_DESC System initating communication description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA



Ver: 3.1