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

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

Target Column Business Name Business Definition Database Data Type Business Data Type Domain Value Source Name Source Column Local Source Local Target
DESIGNATION Designation User defined code for a designation. VARCHAR2(63)    

ADRFUND

ADRFUND_DESG

NO

NO
DESIGNATION_NAME Designation Name Designation name. VARCHAR2(255)    

ADBDESG

ADBDESG_NAME

NO

NO
DESG_TYPE Designation Type Type of designation. Used to identify testamentary commitments, charitable reminder trusts, and pooled income funds in Voluntary Support of Education processing. VARCHAR2(63)    

ADBDESG

ADBDESG_DSTP_CODE

NO

NO
DESG_TYPE_DESC Designation Type Description Designation type description. VARCHAR2(255)    

ATVDSTP

ATVDSTP_DESC

NO

NO
DESG_GROUP Designation Group Group associated with the designation. You can group similar designations together for institutional reporting. For example, designations by campaign objectives. VARCHAR2(63)    

ADBDESG

ADBDESG_DGRP_CODE

NO

NO
DESG_GROUP_DESC Designation Group Description Designation group description. VARCHAR2(255)    

ATVDGRP

ATVDGRP_DESC

NO

NO
FINANCIAL_AID_FUND Financial Financial Aid Fund Financial aid fund code. VARCHAR2(63)    

ADRFUND

ADRFUND_FA_FUND_CODE

NO

NO
FINANCIAL_AID_FUND_TITLE Financial Financial Aid Fund Title Full title of the financial aid fund code. VARCHAR2(255)    

RFRBASE

RFRBASE_FUND_TITLE

NO

NO
FINANCIAL_AID_FUND_LONG_TITLE Financial Financial Aid Fund Long Title Full description of the fund code. VARCHAR2(255)    

RFRBASE

RFRBASE_FUND_TITLE_LONG

NO

NO
FUND_SOURCE Fund Source Fund source code to be associated with the fund as defined by the institution. VARCHAR2(63)    

RFRBASE

RFRBASE_FRSC_CODE

NO

NO
FUND_SOURCE_DESC Fund Source Description Financial aid funding source description. VARCHAR2(255)    

RTVFSRC

RTVFSRC_DESC

NO

NO
FUND_SOURCE_TYPE Fund Source Type Financial aid funding source type. VARCHAR2(63)    

RTVFSRC

RTVFSRC_IND

NO

NO
FUND_SOURCE_TYPE_DESC Fund Source Type Description Financial aid funding source type description. VARCHAR2(255)    

CALCULATION

DECODE(RTVFSRC_IND)

NO

NO
FUND_TYPE Fund Type Fund type code to be associated with the fund as defined by the institution. VARCHAR2(63)    

RFRBASE

RFRBASE_FTYP_CODE

NO

NO
FUND_TYPE_DESC Fund Type Description Financial aid funding type description. VARCHAR2(255)    

RTVFTYP

RTVFTYP_DESC

NO

NO
FINANCIAL_AID_TYPE Financial Financial Aid Type Aid fund type code defined as one of the following grant, loan, scholarship or grant for the aid fund. VARCHAR2(63)    

RTVFTYP

RTVFTYP_IND

NO

NO
FINANCIAL_AID_TYPE_DESC Financial Financial Aid Type Description Financial aid type description. VARCHAR2(255)    

CALCULATION

DECODE(RTVFTYP_IND)

NO

NO
FUND_DETAIL_CODE Fund Detail Code Links a financial aid fund code to an AR detail code for crediting funds to student accounts. VARCHAR2(63)    

RFRBASE

RFRBASE_DETAIL_CODE

NO

NO
FUND_DETAIL_CODE_DESC Fund Detail Code Description Detail code description. VARCHAR2(255)    

TBBDETC

TBBDETC_DESC

NO

NO
EXTERNAL_REFERENCE_VALUE External Reference Value User-defined field that enables you to cross reference IDs used for funds by another office. VARCHAR2(63)    

RFRBASE

RFRBASE_XREF_VALUE

NO

NO
DESIGNATION_FUND_USER_ID Designation Fund User ID Unique identification code of the user who entered or last touched the designation financial aid fund. VARCHAR2(63)    

ADRFUND

ADRFUND_USER

NO

NO
ACTIVITY_DATE Activity Date Date information for this record in the table was entered or last updated. DATE    

ADRFUND

ADRFUND_ACTIVITY_DATE

NO

NO
MULTI_SOURCE Multi Source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)    

NA

NA

NO

NO
MULTI_SOURCE_DESC Multi Source Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)    

NA

NA

NO

NO
PROCESS_GROUP Process Group Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)    

NA

NA

NO

NO
ADMINISTRATIVE_GROUP Administrative Group Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)    

NA

NA

NO

NO


Ver: 9.2