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

Banner Operational Data Store
Reporting View Target: GRANT_FUND_SLOT

Description Uses data from the GRANT_FUND reporting view. Displays up to 10 fund codes assigned to a grant listed in order of descending termination date.
Key & Frequency One row per grant ID.
Recommended Search Columns GRANT_ID
ACTIVITY_DATE

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

NA

SYSDATE

NO

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

NA

NA

NO

NO
CHART_OF_ACCOUNTS1 Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)

FTVFUND

FTVFUND_COAS_CODE

NO

NO
CHART_OF_ACCOUNTS10 Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)

FTVFUND

FTVFUND_COAS_CODE

NO

NO
CHART_OF_ACCOUNTS2 Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)

FTVFUND

FTVFUND_COAS_CODE

NO

NO
CHART_OF_ACCOUNTS3 Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)

FTVFUND

FTVFUND_COAS_CODE

NO

NO
CHART_OF_ACCOUNTS4 Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)

FTVFUND

FTVFUND_COAS_CODE

NO

NO
CHART_OF_ACCOUNTS5 Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)

FTVFUND

FTVFUND_COAS_CODE

NO

NO
CHART_OF_ACCOUNTS6 Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)

FTVFUND

FTVFUND_COAS_CODE

NO

NO
CHART_OF_ACCOUNTS7 Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)

FTVFUND

FTVFUND_COAS_CODE

NO

NO
CHART_OF_ACCOUNTS8 Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)

FTVFUND

FTVFUND_COAS_CODE

NO

NO
CHART_OF_ACCOUNTS9 Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)

FTVFUND

FTVFUND_COAS_CODE

NO

NO
CHART_OF_ACCOUNTS_DESC1 Chart of accounts code description or title. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

NO

NO
CHART_OF_ACCOUNTS_DESC10 Chart of accounts code description or title. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

NO

NO
CHART_OF_ACCOUNTS_DESC2 Chart of accounts code description or title. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

NO

NO
CHART_OF_ACCOUNTS_DESC3 Chart of accounts code description or title. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

NO

NO
CHART_OF_ACCOUNTS_DESC4 Chart of accounts code description or title. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

NO

NO
CHART_OF_ACCOUNTS_DESC5 Chart of accounts code description or title. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

NO

NO
CHART_OF_ACCOUNTS_DESC6 Chart of accounts code description or title. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

NO

NO
CHART_OF_ACCOUNTS_DESC7 Chart of accounts code description or title. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

NO

NO
CHART_OF_ACCOUNTS_DESC8 Chart of accounts code description or title. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

NO

NO
CHART_OF_ACCOUNTS_DESC9 Chart of accounts code description or title. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

NO

NO
FUND1 Unique fiscal entity code. VARCHAR2(63)

FTVFUND

FTVFUND_FUND_CODE

NO

NO
FUND10 Unique fiscal entity code. VARCHAR2(63)

FTVFUND

FTVFUND_FUND_CODE

NO

NO
FUND2 Unique fiscal entity code. VARCHAR2(63)

FTVFUND

FTVFUND_FUND_CODE

NO

NO
FUND3 Unique fiscal entity code. VARCHAR2(63)

FTVFUND

FTVFUND_FUND_CODE

NO

NO
FUND4 Unique fiscal entity code. VARCHAR2(63)

FTVFUND

FTVFUND_FUND_CODE

NO

NO
FUND5 Unique fiscal entity code. VARCHAR2(63)

FTVFUND

FTVFUND_FUND_CODE

NO

NO
FUND6 Unique fiscal entity code. VARCHAR2(63)

FTVFUND

FTVFUND_FUND_CODE

NO

NO
FUND7 Unique fiscal entity code. VARCHAR2(63)

FTVFUND

FTVFUND_FUND_CODE

NO

NO
FUND8 Unique fiscal entity code. VARCHAR2(63)

FTVFUND

FTVFUND_FUND_CODE

NO

NO
FUND9 Unique fiscal entity code. VARCHAR2(63)

FTVFUND

FTVFUND_FUND_CODE

NO

NO
FUND_DESC1 Fund code description or title. VARCHAR2(255)

FTVFUND

FTVFUND_TITLE

NO

NO
FUND_DESC10 Fund code description or title. VARCHAR2(255)

FTVFUND

FTVFUND_TITLE

NO

NO
FUND_DESC2 Fund code description or title. VARCHAR2(255)

FTVFUND

FTVFUND_TITLE

NO

NO
FUND_DESC3 Fund code description or title. VARCHAR2(255)

FTVFUND

FTVFUND_TITLE

NO

NO
FUND_DESC4 Fund code description or title. VARCHAR2(255)

FTVFUND

FTVFUND_TITLE

NO

NO
FUND_DESC5 Fund code description or title. VARCHAR2(255)

FTVFUND

FTVFUND_TITLE

NO

NO
FUND_DESC6 Fund code description or title. VARCHAR2(255)

FTVFUND

FTVFUND_TITLE

NO

NO
FUND_DESC7 Fund code description or title. VARCHAR2(255)

FTVFUND

FTVFUND_TITLE

NO

NO
FUND_DESC8 Fund code description or title. VARCHAR2(255)

FTVFUND

FTVFUND_TITLE

NO

NO
FUND_DESC9 Fund code description or title. VARCHAR2(255)

FTVFUND

FTVFUND_TITLE

NO

NO
FUND_STATUS1 Current status of the associated fund. VARCHAR2(63)

FTVFUND

FTVFUND_STATUS_IND

NO

NO
FUND_STATUS10 Current status of the associated fund. VARCHAR2(63)

FTVFUND

FTVFUND_STATUS_IND

NO

NO
FUND_STATUS2 Current status of the associated fund. VARCHAR2(63)

FTVFUND

FTVFUND_STATUS_IND

NO

NO
FUND_STATUS3 Current status of the associated fund. VARCHAR2(63)

FTVFUND

FTVFUND_STATUS_IND

NO

NO
FUND_STATUS4 Current status of the associated fund. VARCHAR2(63)

FTVFUND

FTVFUND_STATUS_IND

NO

NO
FUND_STATUS5 Current status of the associated fund. VARCHAR2(63)

FTVFUND

FTVFUND_STATUS_IND

NO

NO
FUND_STATUS6 Current status of the associated fund. VARCHAR2(63)

FTVFUND

FTVFUND_STATUS_IND

NO

NO
FUND_STATUS7 Current status of the associated fund. VARCHAR2(63)

FTVFUND

FTVFUND_STATUS_IND

NO

NO
FUND_STATUS8 Current status of the associated fund. VARCHAR2(63)

FTVFUND

FTVFUND_STATUS_IND

NO

NO
FUND_STATUS9 Current status of the associated fund. VARCHAR2(63)

FTVFUND

FTVFUND_STATUS_IND

NO

NO
FUND_TERMINATION_DATE1 Termination Date of the Fund associated with the Grant. DATE

FTVFUND

FTVFUND_TERM_DATE

NO

NO
FUND_TERMINATION_DATE10 Termination Date of the Fund associated with the Grant. DATE

FTVFUND

FTVFUND_TERM_DATE

NO

NO
FUND_TERMINATION_DATE2 Termination Date of the Fund associated with the Grant. DATE

FTVFUND

FTVFUND_TERM_DATE

NO

NO
FUND_TERMINATION_DATE3 Termination Date of the Fund associated with the Grant. DATE

FTVFUND

FTVFUND_TERM_DATE

NO

NO
FUND_TERMINATION_DATE4 Termination Date of the Fund associated with the Grant. DATE

FTVFUND

FTVFUND_TERM_DATE

NO

NO
FUND_TERMINATION_DATE5 Termination Date of the Fund associated with the Grant. DATE

FTVFUND

FTVFUND_TERM_DATE

NO

NO
FUND_TERMINATION_DATE6 Termination Date of the Fund associated with the Grant. DATE

FTVFUND

FTVFUND_TERM_DATE

NO

NO
FUND_TERMINATION_DATE7 Termination Date of the Fund associated with the Grant. DATE

FTVFUND

FTVFUND_TERM_DATE

NO

NO
FUND_TERMINATION_DATE8 Termination Date of the Fund associated with the Grant. DATE

FTVFUND

FTVFUND_TERM_DATE

NO

NO
FUND_TERMINATION_DATE9 Termination Date of the Fund associated with the Grant. DATE

FTVFUND

FTVFUND_TERM_DATE

NO

NO
GRANT_ID Unique user defined or system generated one-up number for this grant. VARCHAR2(63)

FRBGRNT

FRBGRNT_CODE

NO

NO
LONG_TITLE Long description or title of the grant proposal. VARCHAR2(256)

FRBPROP

FRBPROP_LONG_TITLE

NO

NO
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 Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

NO

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

NA

NA

NO

NO
SHORT_TITLE Short description or title of the grant proposal. VARCHAR2(255)

FRBPROP

FRBPROP_TITLE

NO

NO


Ver: 9.2