Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Advancement Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: DESIGNATION_FINAID_FUND

Description Contains information about financial aid funds associated to a designation.
Key & Frequency Multiple occurrences per designation per financial aid fund.
Recommended Search Columns FUND_SOURCE
DESIGNATION, FINANCIAL_AID_FUND
FINANCIAL_AID_FUND, DESIGNATION
DESG_TYPE
DESG_GROUP

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ACTIVITY_DATE Date information for this record in the table was entered or last updated.    

ADRFUND

ADRFUND_ACTIVITY_DATE

 
ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 
DESG_GROUP Group associated with the designation. You can group similar designations together for institutional reporting. For example, designations by campaign objectives.    

ADBDESG

ADBDESG_DGRP_CODE

 
DESG_GROUP_DESC Designation group description.    

ATVDGRP

ATVDGRP_DESC

 
DESG_TYPE Type of designation. Used to identify testamentary commitments, charitable reminder trusts, and pooled income funds in Voluntary Support of Education processing.    

ADBDESG

ADBDESG_DSTP_CODE

 
DESG_TYPE_DESC Designation type description.    

ATVDSTP

ATVDSTP_DESC

 
DESIGNATION User defined code for a designation.    

ADRFUND

ADRFUND_DESG

 
DESIGNATION_FUND_USER_ID Unique identification code of the user who entered or last touched the designation financial aid fund.    

ADRFUND

ADRFUND_USER

 
DESIGNATION_NAME Designation name.    

ADBDESG

ADBDESG_NAME

 
EXTERNAL_REFERENCE_VALUE User-defined field that enables you to cross reference IDs used for funds by another office.    

RFRBASE

RFRBASE_XREF_VALUE

 
FINANCIAL_AID_FUND Financial aid fund code.    

ADRFUND

ADRFUND_FA_FUND_CODE

 
FINANCIAL_AID_FUND_LONG_TITLE Full description of the fund code.    

RFRBASE

RFRBASE_FUND_TITLE_LONG

 
FINANCIAL_AID_FUND_TITLE Full title of the financial aid fund code.    

RFRBASE

RFRBASE_FUND_TITLE

 
FINANCIAL_AID_TYPE Type of financial aid being offered.    

RTVFTYP

RTVFTYP_IND

 
FINANCIAL_AID_TYPE_DESC Financial aid type description.    

CALCULATION

DECODE(RTVFTYP_IND)

 
FUND_DETAIL_CODE Links a financial aid fund code to an AR detail code for crediting funds to student accounts.    

RFRBASE

RFRBASE_DETAIL_CODE

 
FUND_DETAIL_CODE_DESC Detail code description.    

TBBDETC

TBBDETC_DESC

 
FUND_SOURCE Financial aid funding source.    

RFRBASE

RFRBASE_FRSC_CODE

 
FUND_SOURCE_DESC Financial aid funding source description.    

RTVFSRC

RTVFSRC_DESC

 
FUND_SOURCE_TYPE Financial aid funding source type.    

RTVFSRC

RTVFSRC_IND

 
FUND_SOURCE_TYPE_DESC Financial aid funding source type description.    

CALCULATION

DECODE(RTVFSRC_IND)

 
FUND_TYPE Financial aid funding type.    

RFRBASE

RFRBASE_FTYP_CODE

 
FUND_TYPE_DESC Financial aid funding type description.    

RTVFTYP

RTVFTYP_DESC

 
MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied.    

NA

NA

 
MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied.    

NA

NA

 
PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 


Ver: 8.3