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

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

ADRFUND

ADRFUND_ACTIVITY_DATE

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

NA

NA

DESG_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. VARCHAR2(255)

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. VARCHAR2(63)

ADBDESG

ADBDESG_DSTP_CODE

DESG_TYPE_DESC Designation type description. VARCHAR2(255)

ATVDSTP

ATVDSTP_DESC

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

ADRFUND

ADRFUND_DESG

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. VARCHAR2(255)

ADBDESG

ADBDESG_NAME

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 aid fund code. VARCHAR2(63)

ADRFUND

ADRFUND_FA_FUND_CODE

FINANCIAL_AID_FUND_LONG_TITLE Full description of the fund code. VARCHAR2(255)

RFRBASE

RFRBASE_FUND_TITLE_LONG

FINANCIAL_AID_FUND_TITLE Full title of the financial aid fund code. VARCHAR2(255)

RFRBASE

RFRBASE_FUND_TITLE

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

FINANCIAL_AID_TYPE_DESC Financial aid type description. VARCHAR2(255)

CALCULATION

DECODE(RTVFTYP_IND)

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 Detail code description. VARCHAR2(255)

TBBDETC

TBBDETC_DESC

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

RFRBASE

RFRBASE_FRSC_CODE

FUND_SOURCE_DESC Financial aid funding source description. VARCHAR2(255)

RTVFSRC

RTVFSRC_DESC

FUND_SOURCE_TYPE Financial aid funding source type. VARCHAR2(63)

RTVFSRC

RTVFSRC_IND

FUND_SOURCE_TYPE_DESC Financial aid funding source type description. VARCHAR2(255)

CALCULATION

DECODE(RTVFSRC_IND)

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

RFRBASE

RFRBASE_FTYP_CODE

FUND_TYPE_DESC Financial aid funding type description. VARCHAR2(255)

RTVFTYP

RTVFTYP_DESC

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

NA

NA

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

NA

NA

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

NA

NA



Ver: 8.5