Reporting View Target: GRANT_FUND

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 Name Business Definition Database Data Type Source Name Source Column

ACTIVITY_DATE Activity Date Date record was inserted or updated. DATE
NA

SYSDATE

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

NA

CHART_OF_ACCOUNTS1 Chart Of Accounts 1 Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)
FTVFUND

FTVFUND_COAS_CODE

CHART_OF_ACCOUNTS10 Chart Of Accounts 10 Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)
FTVFUND

FTVFUND_COAS_CODE

CHART_OF_ACCOUNTS2 Chart Of Accounts 2 Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)
FTVFUND

FTVFUND_COAS_CODE

CHART_OF_ACCOUNTS3 Chart Of Accounts 3 Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)
FTVFUND

FTVFUND_COAS_CODE

CHART_OF_ACCOUNTS4 Chart Of Accounts 4 Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)
FTVFUND

FTVFUND_COAS_CODE

CHART_OF_ACCOUNTS5 Chart Of Accounts 5 Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)
FTVFUND

FTVFUND_COAS_CODE

CHART_OF_ACCOUNTS6 Chart Of Accounts 6 Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)
FTVFUND

FTVFUND_COAS_CODE

CHART_OF_ACCOUNTS7 Chart Of Accounts 7 Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)
FTVFUND

FTVFUND_COAS_CODE

CHART_OF_ACCOUNTS8 Chart Of Accounts 8 Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)
FTVFUND

FTVFUND_COAS_CODE

CHART_OF_ACCOUNTS9 Chart Of Accounts 9 Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)
FTVFUND

FTVFUND_COAS_CODE

CHART_OF_ACCOUNTS_DESC1 Chart Of Accounts Description 1 Chart of accounts code description or title. VARCHAR2(255)
FUNCTION

F_GET_FINANCE_DESC

CHART_OF_ACCOUNTS_DESC10 Chart Of Accounts Description 10 Chart of accounts code description or title. VARCHAR2(255)
FUNCTION

F_GET_FINANCE_DESC

CHART_OF_ACCOUNTS_DESC2 Chart Of Accounts Description 2 Chart of accounts code description or title. VARCHAR2(255)
FUNCTION

F_GET_FINANCE_DESC

CHART_OF_ACCOUNTS_DESC3 Chart Of Accounts Description 3 Chart of accounts code description or title. VARCHAR2(255)
FUNCTION

F_GET_FINANCE_DESC

CHART_OF_ACCOUNTS_DESC4 Chart Of Accounts Description 4 Chart of accounts code description or title. VARCHAR2(255)
FUNCTION

F_GET_FINANCE_DESC

CHART_OF_ACCOUNTS_DESC5 Chart Of Accounts Description 5 Chart of accounts code description or title. VARCHAR2(255)
FUNCTION

F_GET_FINANCE_DESC

CHART_OF_ACCOUNTS_DESC6 Chart Of Accounts Description 6 Chart of accounts code description or title. VARCHAR2(255)
FUNCTION

F_GET_FINANCE_DESC

CHART_OF_ACCOUNTS_DESC7 Chart Of Accounts Description 7 Chart of accounts code description or title. VARCHAR2(255)
FUNCTION

F_GET_FINANCE_DESC

CHART_OF_ACCOUNTS_DESC8 Chart Of Accounts Description 8 Chart of accounts code description or title. VARCHAR2(255)
FUNCTION

F_GET_FINANCE_DESC

CHART_OF_ACCOUNTS_DESC9 Chart Of Accounts Description 9 Chart of accounts code description or title. VARCHAR2(255)
FUNCTION

F_GET_FINANCE_DESC

FUND1 Fund 1 Unique fiscal entity code. VARCHAR2(63)
FTVFUND

FTVFUND_FUND_CODE

FUND10 Fund 10 Unique fiscal entity code. VARCHAR2(63)
FTVFUND

FTVFUND_FUND_CODE

FUND2 Fund 2 Unique fiscal entity code. VARCHAR2(63)
FTVFUND

FTVFUND_FUND_CODE

FUND3 Fund 3 Unique fiscal entity code. VARCHAR2(63)
FTVFUND

FTVFUND_FUND_CODE

FUND4 Fund 4 Unique fiscal entity code. VARCHAR2(63)
FTVFUND

FTVFUND_FUND_CODE

FUND5 Fund 5 Unique fiscal entity code. VARCHAR2(63)
FTVFUND

FTVFUND_FUND_CODE

FUND6 Fund 6 Unique fiscal entity code. VARCHAR2(63)
FTVFUND

FTVFUND_FUND_CODE

FUND7 Fund 7 Unique fiscal entity code. VARCHAR2(63)
FTVFUND

FTVFUND_FUND_CODE

FUND8 Fund 8 Unique fiscal entity code. VARCHAR2(63)
FTVFUND

FTVFUND_FUND_CODE

FUND9 Fund 9 Unique fiscal entity code. VARCHAR2(63)
FTVFUND

FTVFUND_FUND_CODE

FUND_DESC1 Fund Description 1 Fund code description or title. VARCHAR2(255)
FTVFUND

FTVFUND_TITLE

FUND_DESC10 Fund Description 10 Fund code description or title. VARCHAR2(255)
FTVFUND

FTVFUND_TITLE

FUND_DESC2 Fund Description 2 Fund code description or title. VARCHAR2(255)
FTVFUND

FTVFUND_TITLE

FUND_DESC3 Fund Description 3 Fund code description or title. VARCHAR2(255)
FTVFUND

FTVFUND_TITLE

FUND_DESC4 Fund Description 4 Fund code description or title. VARCHAR2(255)
FTVFUND

FTVFUND_TITLE

FUND_DESC5 Fund Description 5 Fund code description or title. VARCHAR2(255)
FTVFUND

FTVFUND_TITLE

FUND_DESC6 Fund Description 6 Fund code description or title. VARCHAR2(255)
FTVFUND

FTVFUND_TITLE

FUND_DESC7 Fund Description 7 Fund code description or title. VARCHAR2(255)
FTVFUND

FTVFUND_TITLE

FUND_DESC8 Fund Description 8 Fund code description or title. VARCHAR2(255)
FTVFUND

FTVFUND_TITLE

FUND_DESC9 Fund Description 9 Fund code description or title. VARCHAR2(255)
FTVFUND

FTVFUND_TITLE

FUND_STATUS1 Fund Status 1 Current status of the associated fund. VARCHAR2(63)
FTVFUND

FTVFUND_STATUS_IND

FUND_STATUS10 Fund Status 10 Current status of the associated fund. VARCHAR2(63)
FTVFUND

FTVFUND_STATUS_IND

FUND_STATUS2 Fund Status 2 Current status of the associated fund. VARCHAR2(63)
FTVFUND

FTVFUND_STATUS_IND

FUND_STATUS3 Fund Status 3 Current status of the associated fund. VARCHAR2(63)
FTVFUND

FTVFUND_STATUS_IND

FUND_STATUS4 Fund Status 4 Current status of the associated fund. VARCHAR2(63)
FTVFUND

FTVFUND_STATUS_IND

FUND_STATUS5 Fund Status 5 Current status of the associated fund. VARCHAR2(63)
FTVFUND

FTVFUND_STATUS_IND

FUND_STATUS6 Fund Status 6 Current status of the associated fund. VARCHAR2(63)
FTVFUND

FTVFUND_STATUS_IND

FUND_STATUS7 Fund Status 7 Current status of the associated fund. VARCHAR2(63)
FTVFUND

FTVFUND_STATUS_IND

FUND_STATUS8 Fund Status 8 Current status of the associated fund. VARCHAR2(63)
FTVFUND

FTVFUND_STATUS_IND

FUND_STATUS9 Fund Status 9 Current status of the associated fund. VARCHAR2(63)
FTVFUND

FTVFUND_STATUS_IND

FUND_TERMINATION_DATE1 Fund Termination Date 1 Termination Date of the Fund associated with the Grant. DATE
FTVFUND

FTVFUND_TERM_DATE

FUND_TERMINATION_DATE10 Fund Termination Date 10 Termination Date of the Fund associated with the Grant. DATE
FTVFUND

FTVFUND_TERM_DATE

FUND_TERMINATION_DATE2 Fund Termination Date 2 Termination Date of the Fund associated with the Grant. DATE
FTVFUND

FTVFUND_TERM_DATE

FUND_TERMINATION_DATE3 Fund Termination Date 3 Termination Date of the Fund associated with the Grant. DATE
FTVFUND

FTVFUND_TERM_DATE

FUND_TERMINATION_DATE4 Fund Termination Date 4 Termination Date of the Fund associated with the Grant. DATE
FTVFUND

FTVFUND_TERM_DATE

FUND_TERMINATION_DATE5 Fund Termination Date 5 Termination Date of the Fund associated with the Grant. DATE
FTVFUND

FTVFUND_TERM_DATE

FUND_TERMINATION_DATE6 Fund Termination Date 6 Termination Date of the Fund associated with the Grant. DATE
FTVFUND

FTVFUND_TERM_DATE

FUND_TERMINATION_DATE7 Fund Termination Date 7 Termination Date of the Fund associated with the Grant. DATE
FTVFUND

FTVFUND_TERM_DATE

FUND_TERMINATION_DATE8 Fund Termination Date 8 Termination Date of the Fund associated with the Grant. DATE
FTVFUND

FTVFUND_TERM_DATE

FUND_TERMINATION_DATE9 Fund Termination Date 9 Termination Date of the Fund associated with the Grant. DATE
FTVFUND

FTVFUND_TERM_DATE

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

FRBGRNT_CODE

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

FRBPROP_LONG_TITLE

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

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

FRBPROP_TITLE

Ver: 9.2

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 Name	Business Definition	Database Data Type	Source Name	Source Column
ACTIVITY_DATE	Activity Date	Date record was inserted or updated.	DATE	NA	SYSDATE
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
CHART_OF_ACCOUNTS1	Chart Of Accounts 1	Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(63)	FTVFUND	FTVFUND_COAS_CODE
CHART_OF_ACCOUNTS10	Chart Of Accounts 10	Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(63)	FTVFUND	FTVFUND_COAS_CODE
CHART_OF_ACCOUNTS2	Chart Of Accounts 2	Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(63)	FTVFUND	FTVFUND_COAS_CODE
CHART_OF_ACCOUNTS3	Chart Of Accounts 3	Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(63)	FTVFUND	FTVFUND_COAS_CODE
CHART_OF_ACCOUNTS4	Chart Of Accounts 4	Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(63)	FTVFUND	FTVFUND_COAS_CODE
CHART_OF_ACCOUNTS5	Chart Of Accounts 5	Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(63)	FTVFUND	FTVFUND_COAS_CODE
CHART_OF_ACCOUNTS6	Chart Of Accounts 6	Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(63)	FTVFUND	FTVFUND_COAS_CODE
CHART_OF_ACCOUNTS7	Chart Of Accounts 7	Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(63)	FTVFUND	FTVFUND_COAS_CODE
CHART_OF_ACCOUNTS8	Chart Of Accounts 8	Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(63)	FTVFUND	FTVFUND_COAS_CODE
CHART_OF_ACCOUNTS9	Chart Of Accounts 9	Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(63)	FTVFUND	FTVFUND_COAS_CODE
CHART_OF_ACCOUNTS_DESC1	Chart Of Accounts Description 1	Chart of accounts code description or title.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
CHART_OF_ACCOUNTS_DESC10	Chart Of Accounts Description 10	Chart of accounts code description or title.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
CHART_OF_ACCOUNTS_DESC2	Chart Of Accounts Description 2	Chart of accounts code description or title.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
CHART_OF_ACCOUNTS_DESC3	Chart Of Accounts Description 3	Chart of accounts code description or title.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
CHART_OF_ACCOUNTS_DESC4	Chart Of Accounts Description 4	Chart of accounts code description or title.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
CHART_OF_ACCOUNTS_DESC5	Chart Of Accounts Description 5	Chart of accounts code description or title.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
CHART_OF_ACCOUNTS_DESC6	Chart Of Accounts Description 6	Chart of accounts code description or title.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
CHART_OF_ACCOUNTS_DESC7	Chart Of Accounts Description 7	Chart of accounts code description or title.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
CHART_OF_ACCOUNTS_DESC8	Chart Of Accounts Description 8	Chart of accounts code description or title.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
CHART_OF_ACCOUNTS_DESC9	Chart Of Accounts Description 9	Chart of accounts code description or title.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
FUND1	Fund 1	Unique fiscal entity code.	VARCHAR2(63)	FTVFUND	FTVFUND_FUND_CODE
FUND10	Fund 10	Unique fiscal entity code.	VARCHAR2(63)	FTVFUND	FTVFUND_FUND_CODE
FUND2	Fund 2	Unique fiscal entity code.	VARCHAR2(63)	FTVFUND	FTVFUND_FUND_CODE
FUND3	Fund 3	Unique fiscal entity code.	VARCHAR2(63)	FTVFUND	FTVFUND_FUND_CODE
FUND4	Fund 4	Unique fiscal entity code.	VARCHAR2(63)	FTVFUND	FTVFUND_FUND_CODE
FUND5	Fund 5	Unique fiscal entity code.	VARCHAR2(63)	FTVFUND	FTVFUND_FUND_CODE
FUND6	Fund 6	Unique fiscal entity code.	VARCHAR2(63)	FTVFUND	FTVFUND_FUND_CODE
FUND7	Fund 7	Unique fiscal entity code.	VARCHAR2(63)	FTVFUND	FTVFUND_FUND_CODE
FUND8	Fund 8	Unique fiscal entity code.	VARCHAR2(63)	FTVFUND	FTVFUND_FUND_CODE
FUND9	Fund 9	Unique fiscal entity code.	VARCHAR2(63)	FTVFUND	FTVFUND_FUND_CODE
FUND_DESC1	Fund Description 1	Fund code description or title.	VARCHAR2(255)	FTVFUND	FTVFUND_TITLE
FUND_DESC10	Fund Description 10	Fund code description or title.	VARCHAR2(255)	FTVFUND	FTVFUND_TITLE
FUND_DESC2	Fund Description 2	Fund code description or title.	VARCHAR2(255)	FTVFUND	FTVFUND_TITLE
FUND_DESC3	Fund Description 3	Fund code description or title.	VARCHAR2(255)	FTVFUND	FTVFUND_TITLE
FUND_DESC4	Fund Description 4	Fund code description or title.	VARCHAR2(255)	FTVFUND	FTVFUND_TITLE
FUND_DESC5	Fund Description 5	Fund code description or title.	VARCHAR2(255)	FTVFUND	FTVFUND_TITLE
FUND_DESC6	Fund Description 6	Fund code description or title.	VARCHAR2(255)	FTVFUND	FTVFUND_TITLE
FUND_DESC7	Fund Description 7	Fund code description or title.	VARCHAR2(255)	FTVFUND	FTVFUND_TITLE
FUND_DESC8	Fund Description 8	Fund code description or title.	VARCHAR2(255)	FTVFUND	FTVFUND_TITLE
FUND_DESC9	Fund Description 9	Fund code description or title.	VARCHAR2(255)	FTVFUND	FTVFUND_TITLE
FUND_STATUS1	Fund Status 1	Current status of the associated fund.	VARCHAR2(63)	FTVFUND	FTVFUND_STATUS_IND
FUND_STATUS10	Fund Status 10	Current status of the associated fund.	VARCHAR2(63)	FTVFUND	FTVFUND_STATUS_IND
FUND_STATUS2	Fund Status 2	Current status of the associated fund.	VARCHAR2(63)	FTVFUND	FTVFUND_STATUS_IND
FUND_STATUS3	Fund Status 3	Current status of the associated fund.	VARCHAR2(63)	FTVFUND	FTVFUND_STATUS_IND
FUND_STATUS4	Fund Status 4	Current status of the associated fund.	VARCHAR2(63)	FTVFUND	FTVFUND_STATUS_IND
FUND_STATUS5	Fund Status 5	Current status of the associated fund.	VARCHAR2(63)	FTVFUND	FTVFUND_STATUS_IND
FUND_STATUS6	Fund Status 6	Current status of the associated fund.	VARCHAR2(63)	FTVFUND	FTVFUND_STATUS_IND
FUND_STATUS7	Fund Status 7	Current status of the associated fund.	VARCHAR2(63)	FTVFUND	FTVFUND_STATUS_IND
FUND_STATUS8	Fund Status 8	Current status of the associated fund.	VARCHAR2(63)	FTVFUND	FTVFUND_STATUS_IND
FUND_STATUS9	Fund Status 9	Current status of the associated fund.	VARCHAR2(63)	FTVFUND	FTVFUND_STATUS_IND
FUND_TERMINATION_DATE1	Fund Termination Date 1	Termination Date of the Fund associated with the Grant.	DATE	FTVFUND	FTVFUND_TERM_DATE
FUND_TERMINATION_DATE10	Fund Termination Date 10	Termination Date of the Fund associated with the Grant.	DATE	FTVFUND	FTVFUND_TERM_DATE
FUND_TERMINATION_DATE2	Fund Termination Date 2	Termination Date of the Fund associated with the Grant.	DATE	FTVFUND	FTVFUND_TERM_DATE
FUND_TERMINATION_DATE3	Fund Termination Date 3	Termination Date of the Fund associated with the Grant.	DATE	FTVFUND	FTVFUND_TERM_DATE
FUND_TERMINATION_DATE4	Fund Termination Date 4	Termination Date of the Fund associated with the Grant.	DATE	FTVFUND	FTVFUND_TERM_DATE
FUND_TERMINATION_DATE5	Fund Termination Date 5	Termination Date of the Fund associated with the Grant.	DATE	FTVFUND	FTVFUND_TERM_DATE
FUND_TERMINATION_DATE6	Fund Termination Date 6	Termination Date of the Fund associated with the Grant.	DATE	FTVFUND	FTVFUND_TERM_DATE
FUND_TERMINATION_DATE7	Fund Termination Date 7	Termination Date of the Fund associated with the Grant.	DATE	FTVFUND	FTVFUND_TERM_DATE
FUND_TERMINATION_DATE8	Fund Termination Date 8	Termination Date of the Fund associated with the Grant.	DATE	FTVFUND	FTVFUND_TERM_DATE
FUND_TERMINATION_DATE9	Fund Termination Date 9	Termination Date of the Fund associated with the Grant.	DATE	FTVFUND	FTVFUND_TERM_DATE
GRANT_ID	Grant ID	Unique user defined or system generated one-up number for this grant.	VARCHAR2(63)	FRBGRNT	FRBGRNT_CODE
LONG_TITLE	Long Title	Long description or title of the grant proposal.	VARCHAR2(256)	FRBPROP	FRBPROP_LONG_TITLE
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
SHORT_TITLE	Short Title	Short description or title of the grant proposal.	VARCHAR2(255)	FRBPROP	FRBPROP_TITLE