| ODS Column |
ODS Business Definition |
ODS Calculation Formula |
ODS Data Type |
Banner Source Name |
Banner Source Column |
Banner Form Name |
|
ACADEMIC_PERIOD
|
Academic period or time frame associated with the communication or material sent to the person.
|
|
|
GURMAIL
|
GURMAIL_TERM_CODE
|
|
|
ACADEMIC_PERIOD_DESC
|
Academic period description.
|
|
|
STVTERM
|
STVTERM_DESC
|
|
|
ACADEMIC_YEAR
|
Academic year associated with the academic period on this record.
|
|
|
STVTERM
|
STVTERM_ACYR_CODE
|
|
|
ACADEMIC_YEAR_DESC
|
Academic year description.
|
|
|
STVACYR
|
STVACYR_DESC
|
|
|
ACTIVITY_DATE
|
Date the record was created or last updated.
|
|
|
GURMAIL
|
GURMAIL_ACTIVITY_DATE
|
|
|
AID_YEAR
|
Aid year associated with this record. For example, aid year 0304 or aid year 0405.
|
|
|
GURMAIL
|
GURMAIL_AIDY_CODE
|
|
|
AID_YEAR_DESC
|
Financial aid year name.
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
|
APPLICATION_NUMBER
|
Application number for the admission application record for a specific academic period.
|
|
|
GURMAIL
|
GURMAIL_ADMIN_IDENTIFIER
|
|
|
COMMUNICATION
|
Letter, email, web notice or material, etc. communication type associated with this record.
|
|
|
GURMAIL
|
GURMAIL_LETR_CODE
|
|
|
COMMUNICATION_DESC
|
Communication description.
|
|
|
GTVLETR
|
GTVLETR_DESC
|
|
|
COMMUNICATION_PLAN
|
Communication plan used to add the communication material or letter.
|
|
|
GURMAIL
|
GURMAIL_CPLN_CODE
|
|
|
COMMUNICATION_PLAN_DESC
|
Communication plan description.
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
|
COMMUNICATION_SOURCE
|
Department or office responsible for performing, scheduling and/or sending this communication.
|
|
|
GURMAIL
|
GURMAIL_MODULE_CODE
|
|
|
COMMUNICATION_SOURCE_DESC
|
Communication source description.
|
|
|
GURMAIL
|
GURMAIL_MODULE_CODE
|
|
|
COMMUNICATION_TYPE
|
Type of communication represented in this record. It may be a pre-printed, published material or a generated material or action, etc.
|
|
|
GURMAIL
|
GURMAIL_PUB_GEN
|
|
|
COMMUNICATION_TYPE_DESC
|
Communication type description.
|
|
|
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.
|
|
|
NA
|
SYSDATE
|
|
|
DATE_INITIATED
|
Date the communication or material was initiated or scheduled.
|
|
|
GURMAIL
|
GURMAIL_DATE_INIT
|
|
|
DATE_PRINTED
|
Date the communication or material was completed.
|
|
|
GURMAIL
|
GURMAIL_DATE_PRINTED
|
|
|
DATE_SENT
|
Date the communication or material was sent.
|
|
|
CALCULATION
|
DECODE(GURMAIL_MISC_DATE,NULL,GURMAIL_DATE_PRINTED)
|
|
|
DEGREE
|
Degree or award code associated with the academic study.
|
|
|
NA
|
NA
|
|
|
DEGREE_DESC
|
Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc.
|
|
|
NA
|
NA
|
|
|
DOMAIN_VALUE
|
Organization-oriented identifier for the record used to determine access authorization. Institution defined.
|
|
|
NA
|
NA
|
|
|
MAJOR
|
Major for the curriculum associated with the communication material.
|
|
|
NA
|
NA
|
|
|
MAJOR_DESC
|
Major or subject area description.
|
|
|
NA
|
NA
|
|
|
MATERIAL
|
Material code (if any) associated with the communication material.
|
|
|
GURMAIL
|
GURMAIL_MATL_CODE_MOD
|
|
|
MATERIAL_DESC
|
Material code description.
|
|
|
STVMATL
|
STVMATL_DESC
|
|
|
MIF_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
|
|
NA
|
NA
|
|
|
MIF_VALUE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
|
|
NA
|
NA
|
|
|
PENDING_LETTER_IND
|
Indicates whether the communication material is pending or it has been completed.
|
|
|
CALCULATION
|
DECODE(GURMAIL_DATE_PRINTED,NULL,'Y','N')
|
|
|
PERSON_UID
|
System generated, unique, internal identification number assigned to this person.
|
|
|
GURMAIL
|
GURMAIL_PIDM
|
|
|
PROGRAM
|
Curriculum program associated with the communication material.
|
|
|
NA
|
NA
|
|
|
PROGRAM_DESC
|
Curriculum program description.
|
|
|
NA
|
NA
|
|
|
QUANTITY
|
Quantity of materials, letters or other correspondence tracked.
|
|
|
GURMAIL
|
GURMAIL_QTY
|
|
|
SUB_ACADEMIC_PERIOD
|
A session, portion or part of the academic period.
|
|
|
NA
|
NA
|
|
|
SUB_ACADEMIC_PERIOD_DESC
|
Sub academic period description.
|
|
|
NA
|
NA
|
|
|
SYSTEM
|
Business area that initiated the communication or material to be sent to the person.
|
|
|
GURMAIL
|
GURMAIL_SYSTEM_IND
|
|
|
SYSTEM_DESC
|
System initating communication description.
|
|
|
GTVSYSI
|
GTVSYSI_DESC
|
|
|
ZONE_VALUE
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
|
|
NA
|
NA
|
|