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.

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
ACCOUNT   Code representing an account, such as assets, liability, control, fund balance, revenue, labor, expenditure or transfer. VARCHAR2(6)  

FGBGENL

FGBGENL_ACCT_CODE

ACCOUNT_DESC   Account code description or title. VARCHAR2(35)  

FUNCTION

F_GET_FINANCE_DESC

ACCOUNT_STATUS   Current status of the associated account. VARCHAR2(1)  

FUNCTION

F_GET_FINANCE_STATUS

BEGINNING_BALANCE   Calculated beginning balance amount for general ledger. NUMBER  

FUNCTION

FOKODSF.F_CALC_GL_ACTIVITY

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

FGBGENL

FGBGENL_COAS_CODE

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

FUNCTION

F_GET_FINANCE_DESC

CHART_OF_ACCOUNTS_STATUS   Extracted current status of the associated chart of accounts. VARCHAR2(1)  

FUNCTION

F_GET_FINANCE_STATUS

CURRENT_ACTUAL   Calculated current general ledger actual amount. NUMBER  

CALCULATION

FGBGENL_SUM_PERIODIC_DR-FGBGENL_SUM_PERIODIC_CR

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

ENDING_BALANCE   Calculated ending balance amount for general ledger. NUMBER  

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. VARCHAR2(2)  

FGBGENL

FGBGENL_PERIOD

FISCAL_YEAR   Unique identifier or code for the fiscal year. VARCHAR2(4)  

FUNCTION

FOFYCNV

FUND   Unique fiscal entity code. VARCHAR2(6)  

FGBGENL

FGBGENL_FUND_CODE

FUND_DESC   Description or title of the associated fund. VARCHAR2(35)  

FUNCTION

F_GET_FINANCE_DESC

FUND_STATUS   Extracted current status of the associated fund. VARCHAR2(1)  

FUNCTION

F_GET_FINANCE_STATUS

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

SUM_PERIODIC_CREDITS Sum Periodic Credits Sum of all general ledger credit transactions for a given period of time. NUMBER(17,2)  

FGBGENL

FGBGENL_SUM_PERIODIC_CR

SUM_PERIODIC_DEBITS Sum Periodic Debits Sum of all general ledger debit transactions for a given period of time. NUMBER(17,2)  

FGBGENL

FGBGENL_SUM_PERIODIC_DR

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

NA

NA



Ver: