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 DESIGNATION
DESG_TYPE
DESG_GROUP
DESIGNATION, FINANCIAL_AID_FUND
FINANCIAL_AID_FUND, DESIGNATION
FUND_SOURCE

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
ACTIVITY_DATE Activity Date Date information for this record in the table was entered or last updated. DATE  

ADRFUND

ADRFUND_ACTIVITY_DATE

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

NA

NA

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

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

ATVDGRP

ATVDGRP_DESC

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

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

ATVDSTP

ATVDSTP_DESC

DESIGNATION Designation User defined code for a designation. VARCHAR2(63)  

ADRFUND

ADRFUND_DESG

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

DESIGNATION_NAME Designation Name Designation name. VARCHAR2(255)  

ADBDESG

ADBDESG_NAME

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

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

ADRFUND

ADRFUND_FA_FUND_CODE

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

RFRBASE

RFRBASE_FUND_TITLE_LONG

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

RFRBASE

RFRBASE_FUND_TITLE

FINANCIAL_AID_TYPE Financial Financial Aid Type Type of financial aid being offered. VARCHAR2(63)  

RTVFTYP

RTVFTYP_IND

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

CALCULATION

DECODE(RTVFTYP_IND)

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

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

TBBDETC

TBBDETC_DESC

FUND_SOURCE Fund Source Financial aid funding source. VARCHAR2(63)  

RFRBASE

RFRBASE_FRSC_CODE

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

RTVFSRC

RTVFSRC_DESC

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

RTVFSRC

RTVFSRC_IND

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

CALCULATION

DECODE(RTVFSRC_IND)

FUND_TYPE Fund Type Financial aid funding type. VARCHAR2(63)  

RFRBASE

RFRBASE_FTYP_CODE

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

RTVFTYP

RTVFTYP_DESC

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

NA

NA

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

NA

NA

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

NA

NA



Ver: 9.0