Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Finance Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AF_GRANT_FUND

Description Source composite view contains funds assigned to grants and their associated information.

Target Column Business Definition Database Data Type Source Name Source Column
BILLED_AR_ACCOUNT User defined account code to hold billing receivables once the granting agency is billed. VARCHAR2(6)

FRVFUND

FRVFUND_BILLED_AR_ACCT_CODE

BILLED_AR_ACCOUNT_DESC Retrieved description or title of the associated account. VARCHAR2(35)

FUNCTION

F_GET_FINANCE_DESC

BUDGET_PERIOD_END_DATE End date of the budget for this fund and grant. DATE

FRVFUND

FRVFUND_BUDG_PRD_END_DATE

BUDGET_PERIOD_START_DATE Start date of the budget for this fund and grant. DATE

FRVFUND

FRVFUND_BUDG_PRD_START_DATE

CASH_RECEIPT_BANK User defined bank code used on all cash transactions in grant billing. VARCHAR2(2)

FTVFUND

FTVFUND_CASH_RECEIPT_BANK_CODE

CASH_RECEIPT_BANK_DESC Name of the cash receipt bank code used for grant billing. VARCHAR2(35)

GXVBANK

GXVBANK_ACCT_NAME

CASH_RECEIPT_BANK_UID The internal identification number of the cash receipt bank for this fund. NUMBER(8)

GXVBANK

GXVBANK_BANK_CODE_PIDM

CHART_OF_ACCOUNTS Identifies the chart from other charts in a multi-chart environment. VARCHAR2(1)

FTVFUND

FTVFUND_COAS_CODE

CHART_OF_ACCOUNTS_DESC Chart of accounts code description or title. VARCHAR2(35)

FUNCTION

F_GET_FINANCE_DESC

CONSTRUCTION_PLANT_FUND User identified fund where the asset resulting from the construction project is capitalized. Information only. VARCHAR2(6)

FTVFUND

FTVFUND_FUND_CODE_PLANT_CONP

CONSTRUCTION_PLANT_FUND_DESC Retrieved description or title of the associated fund. VARCHAR2(35)

FUNCTION

F_GET_FINANCE_DESC

CONSTR_IN_PROGR_ACCOUNT User defined account where the construction in progress is capitalized. Informational only. VARCHAR2(6)

FTVFUND

FTVFUND_ACCT_CODE_CIP

CONSTR_IN_PROGR_ACCOUNT_DESC Retrieved description or title of the associated account. VARCHAR2(35)

FUNCTION

F_GET_FINANCE_DESC

CONSTR_PROJECT_COMPLETE_DATE Construction project completion date. Informational only. DATE

FTVFUND

FTVFUND_PROJ_COMPLETE_DATE

CONSTR_PROJECT_DESC Construction project description. VARCHAR2(35)

FTVFUND

FTVFUND_PROJ_DESC

CONSTR_PROJECT_END_DATE Construction project end date. Informational only. DATE

FTVFUND

FTVFUND_PROJ_END_DATE_CONP

CONSTR_PROJECT_FMGR_UID Internally generated by the system to uniquely identify the person or entity. NUMBER(8)

FTVFUND

FTVFUND_FMGR_CODE_PIDM_CONP

CONSTR_PROJECT_NUMBER User defined number assigned to a construction project. VARCHAR2(15)

FTVFUND

FTVFUND_CONP_PROJ_NUM

CONSTR_PROJECT_START_DATE Construction project start date. Informational only. DATE

FTVFUND

FTVFUND_PROJ_START_DATE_CONP

CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

ESTIMATED_CUM_COST_AMOUNT Value of the estimated total cost of the construction project. NUMBER(17,2)

FTVFUND

FTVFUND_CUM_COST_AMT

FUND Unique fiscal entity code. VARCHAR2(6)

FTVFUND

FTVFUND_FUND_CODE

FUND_BANK User-defined value which is used for identification purposes on all cash transactions. VARCHAR2(2)

FTVFUND

FTVFUND_BANK_CODE

FUND_BANK_DESC The name of the banking institution where the installment has accounts.  

GXVBANK

GXVBANK_ACCT_NAME

FUND_BANK_UID The internal identification number of the bank where the installment has accounts.  

GXVBANK

GXVBANK_BANK_CODE_PIDM

FUND_COST_SHARE_BASE Code defines the base information for cost share calculations. VARCHAR2(6)

FRVFUND

FRVFUND_BASI_CODE_CS

FUND_COST_SHARE_BASE_DESC Cost share code extracted description. VARCHAR2(35)

FUNCTION

GOKODSF.F_GET_DESC

FUND_COST_SHARE_CHARGE Code defines account's and percentage of the charge. VARCHAR2(6)

FRVFUND

FRVFUND_CSTA_CODE_CHARGE

FUND_COST_SHARE_CHARGE_DESC Cost share credit code description. VARCHAR2(35)

FUNCTION

GOKODSF.F_GET_DESC

FUND_COST_SHARE_DISTRIB Code defines the account distribution for indirect cost. VARCHAR2(6)

FRVFUND

FRVFUND_CSTD_CODE_DISTR

FUND_COST_SHARE_DISTRIB_DESC Cost share distribution code extracted description. VARCHAR2(35)

FUNCTION

GOKODSF.F_GET_DESC

FUND_COST_SHARE_RATE Cost chart rate for this grant fund. VARCHAR2(6)

FRVFUND

FRVFUND_CSTR_CODE_RATE

FUND_COST_SHARE_RATE_DESC Cost share rate code description. VARCHAR2(35)

FUNCTION

GOKODSF.F_GET_DESC

FUND_DESC Fund code description or title. VARCHAR2(35)

FTVFUND

FTVFUND_TITLE

FUND_EXPENDITURE_END_DATE Ending period date for expenditure activity. DATE

FTVFUND

FTVFUND_EXPEND_END_DATE

FUND_INDIRECT_COST_BASE Code used to define indirect cost calculations. VARCHAR2(6)

FRVFUND

FRVFUND_BASI_CODE_IC

FUND_INDIRECT_COST_BASE_DESC Indirect cost base code description. VARCHAR2(35)

FUNCTION

GOKODSF.F_GET_DESC

FUND_INDIRECT_COST_CHARGE Code identifies the account's and the percentage of the charge. VARCHAR2(6)

FRVFUND

FRVFUND_INDA_CODE_CHARGE

FUND_INDIRECT_COST_CHARGE_DESC Indirect cost charge code description. VARCHAR2(35)

FUNCTION

GOKODSF.F_GET_DESC

FUND_INDIRECT_COST_DISTRI Code identifies the accounting distribution for indirect cost. VARCHAR2(6)

FRVFUND

FRVFUND_INDD_CODE_DISTR

FUND_INDIRECT_COST_DISTRI_DESC Indirect cost distribution description. VARCHAR2(35)

FUNCTION

GOKODSF.F_GET_DESC

FUND_INDIRECT_COST_RATE Indirect cost rate percentage for the grant fund. VARCHAR2(6)

FRVFUND

FRVFUND_INDR_CODE_RATE

FUND_INDIRECT_COST_RATE_DESC Indirect cost rate code description. VARCHAR2(35)

FUNCTION

GOKODSF.F_GET_DESC

FUND_PREDECESSOR Next prior level fund associated with the fund code used to build a hierarchy. VARCHAR2(6)

FTVFUND

FTVFUND_FUND_CODE_PRED

FUND_PREDECESSOR_DESC Associated fund description or title. VARCHAR2(35)

FUNCTION

F_GET_FINANCE_DESC

FUND_STATUS Current status of the associated fund. VARCHAR2(1)

FTVFUND

FTVFUND_STATUS_IND

FUND_TERMINATION_DATE Date when the fund is no longer in effect. DATE

FTVFUND

FTVFUND_TERM_DATE

FUND_TYPE Code that classifies a fiscal entity. VARCHAR2(2)

FTVFUND

FTVFUND_FTYP_CODE

FUND_TYPE_DESC Fund type code description or title. VARCHAR2(35)

FTVFTYP

FTVFTYP_TITLE

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

FTVFUND

FTVFUND_GRNT_CODE

MAXIMUM_CONSTR_PROJECT_AMOUNT Value of estimated funding for this construction project. NUMBER(17,2)

FTVFUND

FTVFUND_MAX_CONSTR_AMT

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

NA

NA

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

NA

NA

PROJECT_CLOSE_IND Determines if the construction project is closed. Informational only. VARCHAR2(1)

FTVFUND

FTVFUND_CLOSE_PROJ_IND

PROPOSAL Proposal submitted to the agency that has now been awarded this grant. VARCHAR2(9)

FTVFUND

FTVFUND_PROP_CODE

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

FRBPROP

FRBPROP_LONG_TITLE

PROPOSAL_SHORT_TITLE Short description or title of the grant proposal. VARCHAR2(35)

FRBPROP

FRBPROP_TITLE

REVENUE_ACCRUAL_ACCOUNT Revenue account code for this fund used for revenue recognition. VARCHAR2(6)

FTVFUND

FTVFUND_ACCT_CODE_REV

REVENUE_ACCRUAL_ACCOUNT_DESC Retrieved description or title of the associated account. VARCHAR2(35)

FUNCTION

F_GET_FINANCE_DESC

SOURCE_FUND Identification of the source of funds for the construction project. Informational only. VARCHAR2(6)

FTVFUND

FTVFUND_FUND_CODE_SOURCE

SOURCE_FUND_DESC Retrieves description or title of the associated fund. VARCHAR2(35)

FUNCTION

F_GET_FINANCE_DESC

UNBILLED_ACCRUAL_ACCOUNT Unbilled accrual account for this fund used for revenue recognition. VARCHAR2(6)

FTVFUND

FTVFUND_ACCT_CODE_ACCR

UNBILLED_ACCRUAL_ACCOUNT_DESC Retrieved description or title of the associated account. VARCHAR2(35)

FUNCTION

F_GET_FINANCE_DESC

WITHHOLDING_AMOUNT Amount to withhold from the billed agency. NUMBER(17,2)

FRVFUND

FRVFUND_WITHHOLDING_AMT

WITHHOLDING_AR_ACCOUNT User defined account code to hold withholding billing receivables once the granting agency is billed. VARCHAR2(6)

FRVFUND

FRVFUND_WHOLDING_AR_ACCT_CODE

WITHHOLDING_AR_ACCOUNT_DESC Retrieved description or title of the associated account. VARCHAR2(35)

FUNCTION

F_GET_FINANCE_DESC

WITHHOLDING_PERCENT Percent of the amount to be debited to the withholding receivable account for each bill generated. NUMBER(7, 4)

FRVFUND

FRVFUND_WITHHOLDING_PERCENT

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

NA

NA



Ver: 8.0