Go To View:  RETURN TO COMPOSITE VIEW 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 Definition Database Data Type 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_PERIOD_STATUS Extracted status of the accounting period which indicates ability to accept posting activity. VARCHAR2(1)

FUNCTION

F_GET_FSPD_STATUS

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 of all general ledger credit transactions for a given period of time. NUMBER(17,2)

FGBGENL

FGBGENL_SUM_PERIODIC_CR

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: 8.0