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_FUND_MESSAGE_RULE

Description Contains information that displays the links between financial aid messages and specific funds and then displays the related messages provided to financial aid applicants..
Key & Frequency One row per aid year per fund per message per pidm

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
ACTIVITY_DATE Activity Date Date record was inserted or updated. DATE  

RFRMESG

RFRMESG_ACTIVITY_DATE

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

RFRMESG

RFRMESG_AIDY_CODE

AID_YEAR_DESC Financial Aid Year Description Financial aid year name. VARCHAR2(30)  

ROBINST

ROBINST_AIDY_DESC

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

RFRMESG

RFRMESG_LETR_CODE

COMMUNICATION_DESC Communication Description Communication description. VARCHAR2(30)  

GTVLETR

GTVLETR_DESC

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

NA

SYSDATE

DOMAIN_VALUE Domain Value Domain column for future use, not currently populated. VARCHAR2(6)  

NA

NA

FUND Fund Financial Aid Fund code to be associated with information in this record. VARCHAR2(6)  

RFRMESG

RFRMESG_FUND_CODE

FUND_TITLE Fund Title Full title of the financial aid fund code. VARCHAR2(30)  

RFRBASE

RFRBASE_FUND_TITLE

MESSAGE Message Code associated with the particular message. VARCHAR2(4)  

RFRMESG

RFRMESG_MESG_CODE

MESSAGE_ACCESS_IND Message Access Indicator Allows the information for this message code to be accessed via Voice Response, Banner Web and similar methods. VARCHAR2(1)  

RTVMESG

RTVMESG_INFO_ACCESS_IND

MESSAGE_DESC Message Description Message description. VARCHAR2(2000)  

RTVMESG

RTVMESG_MESG_DESC

MIF_DESC MIF Description The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(30)  

NA

NA

MIF_VALUE MIF Value The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(6)  

NA

NA

ZONE_VALUE Zone Value Zone column for future use, not currently populated. VARCHAR2(6)  

NA

NA



Ver: