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

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 Local Source Local Target
ACCOUNT Code representing an account, such as assets, liability, control, fund balance, revenue, labor, expenditure or transfer. VARCHAR2(6)

FGBGENL

FGBGENL_ACCT_CODE

NO

NO
ACCOUNT_DESC Account code description or title. VARCHAR2(35)

FUNCTION

F_GET_FINANCE_DESC

NO

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

FUNCTION

F_GET_FINANCE_STATUS

NO

NO
BEGINNING_BALANCE Calculated beginning balance amount for general ledger. NUMBER

FUNCTION

FOKODSF.F_CALC_GL_ACTIVITY

NO

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

FGBGENL

FGBGENL_COAS_CODE

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

FUNCTION

F_GET_FINANCE_STATUS

NO

NO
CURRENT_ACTUAL Calculated current general ledger actual amount. NUMBER

CALCULATION

FGBGENL_SUM_PERIODIC_DR-FGBGENL_SUM_PERIODIC_CR

NO

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

NA

SYSDATE

NO

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

NA

NA

NO

NO
ENDING_BALANCE Calculated ending balance amount for general ledger. NUMBER

FUNCTION

FOKODSF.F_CALC_GL_ACTIVITY

NO

NO
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

NO

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

FUNCTION

FOFYCNV

NO

NO
FUND Financial Aid Fund code to be associated with information in this record. VARCHAR2(6)

FGBGENL

FGBGENL_FUND_CODE

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

FUNCTION

F_GET_FINANCE_STATUS

NO

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

NA

NA

NO

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

NA

NA

NO

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

FGBGENL

FGBGENL_SUM_PERIODIC_CR

NO

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

FGBGENL

FGBGENL_SUM_PERIODIC_DR

NO

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

NA

NA

NO

NO


Ver: