Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Financial Aid Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AR_FINAID_MESSAGE

Description Contains message information provided to financial aid applicants.
Key & Frequency One row per Aid Year per person per message code

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ACTIVITY_DATE Date record was inserted or updated.    

RORMESG

RORMESG_ACTIVITY_DATE

 
AID_YEAR Aid year associated with this record. For example, aid year 0304 (2003 to 2004) or aid year 0405 (2004 to 2005).    

RORMESG

RORMESG_AIDY_CODE

 
AID_YEAR_DESC Financial aid year name.    

ROBINST

ROBINST_AIDY_DESC

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

NA

SYSDATE

 
DOMAIN_VALUE Domain column for future use, not currently populated.    

NA

NA

 
MESSAGE Code associated with the particular message.    

RORMESG

RORMESG_MESG_CODE

 
MESSAGE_ACCESS_IND Allows the information for this message code to be accessed via Voice Response, Banner Web and similar methods.    

RTVMESG

RTVMESG_INFO_ACCESS_IND

 
MESSAGE_DESC Message description.    

RTVMESG

RTVMESG_MESG_DESC

 
MESSAGE_EXPIRATION_DATE Message expiration date.    

RORMESG

RORMESG_EXPIRATION_DATE

 
MESSAGE_FULL_DESCRIPTION Free-form, personalized message written by a Financial Aid Counselor.    

RORMESG

RORMESG_FULL_DESC

 
MESSAGE_SHORT_DESCRIPTION Message short description.    

RORMESG

RORMESG_SHORT_DESC

 
MESSAGE_USER_ID Unique identification code of the user who entered or last updated the message.    

RORMESG

RORMESG_USER_ID

 
MIF_DESC The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column.    

NA

NA

 
MIF_VALUE The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column.    

NA

NA

 
PERSON_UID System generated, unique, internal identification number assigned to this person.    

RORMESG

RORMESG_PIDM

 
ZONE_VALUE Zone column for future use, not currently populated.    

NA

NA

 


Ver: 8.3