Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Finance Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AF_GENERAL_LEDGER

Description Source composite view contains general ledger information.

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ACCOUNT Code representing an account, such as assets, liability, control, fund balance, revenue, labor, expenditure or transfer.    

FGBGENL

FGBGENL_ACCT_CODE

 
ACCOUNT_DESC Account code description or title.    

FUNCTION

F_GET_FINANCE_DESC

 
ACCOUNT_STATUS Current status of the associated account.    

FUNCTION

F_GET_FINANCE_STATUS

 
BEGINNING_BALANCE Calculated beginning balance amount for general ledger.    

FUNCTION

FOKODSF.F_CALC_GL_ACTIVITY

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

FGBGENL

FGBGENL_COAS_CODE

 
CHART_OF_ACCOUNTS_DESC Chart of accounts code description or title.    

FUNCTION

F_GET_FINANCE_DESC

 
CHART_OF_ACCOUNTS_STATUS Extracted current status of the associated chart of accounts.    

FUNCTION

F_GET_FINANCE_STATUS

 
CURRENT_ACTUAL Calculated current general ledger actual amount.    

CALCULATION

FGBGENL_SUM_PERIODIC_DR-FGBGENL_SUM_PERIODIC_CR

 
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

 
ENDING_BALANCE Calculated ending balance amount for general ledger.    

FUNCTION

FOKODSF.F_CALC_GL_ACTIVITY

 
FISCAL_PERIOD Unique identifier for a period within a fiscal year. Generally a fiscal period would be a value between 00 and 14.    

FGBGENL

FGBGENL_PERIOD

 
FISCAL_YEAR Unique identifier or code for the fiscal year.    

FUNCTION

FOFYCNV

 
FUND Unique fiscal entity code.    

FGBGENL

FGBGENL_FUND_CODE

 
FUND_DESC Description or title of the associated fund.    

FUNCTION

F_GET_FINANCE_DESC

 
FUND_STATUS Extracted current status of the associated fund.    

FUNCTION

F_GET_FINANCE_STATUS

 
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

 
SUM_PERIODIC_CREDITS Sum of all general ledger credit transactions for a given period of time.    

FGBGENL

FGBGENL_SUM_PERIODIC_CR

 
SUM_PERIODIC_DEBITS Sum of all general ledger debit transactions for a given period of time.    

FGBGENL

FGBGENL_SUM_PERIODIC_DR

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

NA

NA

 


Ver: 8.3