Go To View:  RETURN TO BANNER COMP META DATA 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.

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
BILLED_AR_ACCOUNT User defined account code to hold billing receivables once the granting agency is billed.    

FRVFUND

FRVFUND_BILLED_AR_ACCT_CODE

 
BILLED_AR_ACCOUNT_DESC Retrieved description or title of the associated account.    

FUNCTION

F_GET_FINANCE_DESC

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

FRVFUND

FRVFUND_BUDG_PRD_END_DATE

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

FRVFUND

FRVFUND_BUDG_PRD_START_DATE

 
CASH_RECEIPT_BANK User defined bank code used on all cash transactions in grant billing.    

FTVFUND

FTVFUND_CASH_RECEIPT_BANK_CODE

 
CASH_RECEIPT_BANK_DESC Name of the cash receipt bank code used for grant billing.    

GXVBANK

GXVBANK_ACCT_NAME

 
CASH_RECEIPT_BANK_UID The internal identification number of the cash receipt bank for this fund.    

GXVBANK

GXVBANK_BANK_CODE_PIDM

 
CHART_OF_ACCOUNTS Identifies the chart from other charts in a multi-chart environment.    

FTVFUND

FTVFUND_COAS_CODE

 
CHART_OF_ACCOUNTS_DESC Chart of accounts code description or title.    

FUNCTION

F_GET_FINANCE_DESC

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

FTVFUND

FTVFUND_FUND_CODE_PLANT_CONP

 
CONSTRUCTION_PLANT_FUND_DESC Retrieved description or title of the associated fund.    

FUNCTION

F_GET_FINANCE_DESC

 
CONSTR_IN_PROGR_ACCOUNT User defined account where the construction in progress is capitalized. Informational only.    

FTVFUND

FTVFUND_ACCT_CODE_CIP

 
CONSTR_IN_PROGR_ACCOUNT_DESC Retrieved description or title of the associated account.    

FUNCTION

F_GET_FINANCE_DESC

 
CONSTR_PROJECT_COMPLETE_DATE Construction project completion date. Informational only.    

FTVFUND

FTVFUND_PROJ_COMPLETE_DATE

 
CONSTR_PROJECT_DESC Construction project description.    

FTVFUND

FTVFUND_PROJ_DESC

 
CONSTR_PROJECT_END_DATE Construction project end date. Informational only.    

FTVFUND

FTVFUND_PROJ_END_DATE_CONP

 
CONSTR_PROJECT_FMGR_UID Internally generated by the system to uniquely identify the person or entity.    

FTVFUND

FTVFUND_FMGR_CODE_PIDM_CONP

 
CONSTR_PROJECT_NUMBER User defined number assigned to a construction project.    

FTVFUND

FTVFUND_CONP_PROJ_NUM

 
CONSTR_PROJECT_START_DATE Construction project start date. Informational only.    

FTVFUND

FTVFUND_PROJ_START_DATE_CONP

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

NA

SYSDATE

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

NA

NA

 
ESTIMATED_CUM_COST_AMOUNT Value of the estimated total cost of the construction project.    

FTVFUND

FTVFUND_CUM_COST_AMT

 
FUND Unique fiscal entity code.    

FTVFUND

FTVFUND_FUND_CODE

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

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.    

FRVFUND

FRVFUND_BASI_CODE_CS

 
FUND_COST_SHARE_BASE_DESC Cost share code extracted description.    

FUNCTION

GOKODSF.F_GET_DESC

 
FUND_COST_SHARE_CHARGE Code defines account's and percentage of the charge.    

FRVFUND

FRVFUND_CSTA_CODE_CHARGE

 
FUND_COST_SHARE_CHARGE_DESC Cost share credit code description.    

FUNCTION

GOKODSF.F_GET_DESC

 
FUND_COST_SHARE_DISTRIB Code defines the account distribution for indirect cost.    

FRVFUND

FRVFUND_CSTD_CODE_DISTR

 
FUND_COST_SHARE_DISTRIB_DESC Cost share distribution code extracted description.    

FUNCTION

GOKODSF.F_GET_DESC

 
FUND_COST_SHARE_RATE Cost chart rate for this grant fund.    

FRVFUND

FRVFUND_CSTR_CODE_RATE

 
FUND_COST_SHARE_RATE_DESC Cost share rate code description.    

FUNCTION

GOKODSF.F_GET_DESC

 
FUND_DESC Fund code description or title.    

FTVFUND

FTVFUND_TITLE

 
FUND_EXPENDITURE_END_DATE Ending period date for expenditure activity.    

FTVFUND

FTVFUND_EXPEND_END_DATE

 
FUND_INDIRECT_COST_BASE Code used to define indirect cost calculations.    

FRVFUND

FRVFUND_BASI_CODE_IC

 
FUND_INDIRECT_COST_BASE_DESC Indirect cost base code description.    

FUNCTION

GOKODSF.F_GET_DESC

 
FUND_INDIRECT_COST_CHARGE Code identifies the account's and the percentage of the charge.    

FRVFUND

FRVFUND_INDA_CODE_CHARGE

 
FUND_INDIRECT_COST_CHARGE_DESC Indirect cost charge code description.    

FUNCTION

GOKODSF.F_GET_DESC

 
FUND_INDIRECT_COST_DISTRI Code identifies the accounting distribution for indirect cost.    

FRVFUND

FRVFUND_INDD_CODE_DISTR

 
FUND_INDIRECT_COST_DISTRI_DESC Indirect cost distribution description.    

FUNCTION

GOKODSF.F_GET_DESC

 
FUND_INDIRECT_COST_RATE Indirect cost rate percentage for the grant fund.    

FRVFUND

FRVFUND_INDR_CODE_RATE

 
FUND_INDIRECT_COST_RATE_DESC Indirect cost rate code description.    

FUNCTION

GOKODSF.F_GET_DESC

 
FUND_PREDECESSOR Next prior level fund associated with the fund code used to build a hierarchy.    

FTVFUND

FTVFUND_FUND_CODE_PRED

 
FUND_PREDECESSOR_DESC Associated fund description or title.    

FUNCTION

F_GET_FINANCE_DESC

 
FUND_STATUS Current status of the associated fund.    

FTVFUND

FTVFUND_STATUS_IND

 
FUND_TERMINATION_DATE Date when the fund is no longer in effect.    

FTVFUND

FTVFUND_TERM_DATE

 
FUND_TYPE Code that classifies a fiscal entity.    

FTVFUND

FTVFUND_FTYP_CODE

 
FUND_TYPE_DESC Fund type code description or title.    

FTVFTYP

FTVFTYP_TITLE

 
GRANT_ID Unique user defined or system generated one-up number for this grant.    

FTVFUND

FTVFUND_GRNT_CODE

 
MAXIMUM_CONSTR_PROJECT_AMOUNT Value of estimated funding for this construction project.    

FTVFUND

FTVFUND_MAX_CONSTR_AMT

 
MIF_DESC Institution description when the optional multi-institution facility feature has been applied.    

NA

NA

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

NA

NA

 
PROJECT_CLOSE_IND Determines if the construction project is closed. Informational only.    

FTVFUND

FTVFUND_CLOSE_PROJ_IND

 
PROPOSAL Proposal submitted to the agency that has now been awarded this grant.    

FTVFUND

FTVFUND_PROP_CODE

 
PROPOSAL_LONG_TITLE Long description or title of the grant proposal.    

FRBPROP

FRBPROP_LONG_TITLE

 
PROPOSAL_SHORT_TITLE Short description or title of the grant proposal.    

FRBPROP

FRBPROP_TITLE

 
REVENUE_ACCRUAL_ACCOUNT Revenue account code for this fund used for revenue recognition.    

FTVFUND

FTVFUND_ACCT_CODE_REV

 
REVENUE_ACCRUAL_ACCOUNT_DESC Retrieved description or title of the associated account.    

FUNCTION

F_GET_FINANCE_DESC

 
SOURCE_FUND Identification of the source of funds for the construction project. Informational only.    

FTVFUND

FTVFUND_FUND_CODE_SOURCE

 
SOURCE_FUND_DESC Retrieves description or title of the associated fund.    

FUNCTION

F_GET_FINANCE_DESC

 
UNBILLED_ACCRUAL_ACCOUNT Unbilled accrual account for this fund used for revenue recognition.    

FTVFUND

FTVFUND_ACCT_CODE_ACCR

 
UNBILLED_ACCRUAL_ACCOUNT_DESC Retrieved description or title of the associated account.    

FUNCTION

F_GET_FINANCE_DESC

 
WITHHOLDING_AMOUNT Amount to withhold from the billed agency.    

FRVFUND

FRVFUND_WITHHOLDING_AMT

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

FRVFUND

FRVFUND_WHOLDING_AR_ACCT_CODE

 
WITHHOLDING_AR_ACCOUNT_DESC Retrieved description or title of the associated account.    

FUNCTION

F_GET_FINANCE_DESC

 
WITHHOLDING_PERCENT Percent of the amount to be debited to the withholding receivable account for each bill generated.    

FRVFUND

FRVFUND_WITHHOLDING_PERCENT

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

NA

NA

 


Ver: 8.3