Composite View Target: AE

Go To View:	RETURN TO BANNER COMP META DATA REPORTS LIST
	Neu Schedule Data Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AE_ACCOUNTING

Description Contains general expense authorization accounting data including, fiscal year/period, accounting distribution, and approved amount. Additional reporting can be by financial manager or the various hierarchy levels of the fund, organization code, account, program, and location.
Key & Frequency One row per accounting key.

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column

ACCOUNT Account Code representing an account, such as assets, liability, control, fund balance, revenue, labor, expenditure or transfer. VARCHAR2(6)
FTCRACTG

ACCT_CODE

ACCOUNTING_KEY Accounting KEY Unique internal identification number of the accounting record. NUMBER(19)
FTCRACTG

ID

ACCOUNT_INDEX Account INDEX Account Index used to default an accounting distribution. VARCHAR2(6)
FTCRACTG

ACCI_CODE

ACCOUNT_INDEX_DESC Account INDEX Description Account index description. VARCHAR2(35)
FUNCTION

FOKODSF.F_GET_FINANCE_DESC

ACTIVITY Activity Code used to identify accounting data by activity. VARCHAR2(6)
FTCRACTG

ACTV_CODE

AMOUNT Amount Amount entered on the funding source to be used for the expense. The total of amount and percent (if any) must be equal to 100 percent for the expense item at final approval. NUMBER(17,2)
FTCRACTG

AMOUNT

BANK Bank Official banking institution. VARCHAR2(2)
FTCRACTG

BANK_CODE

BANK_DESC Bank Description Official banking institution name. VARCHAR2(35)
GXVBANK

GXVBANK_ACCT_NAME

BANK_UID Bank UID Internal identification number of the bank used at the time the transaction occurred. NUMBER(8)
GXVBANK

GXVBANK_BANK_CODE_PIDM

CALCULATED_AMOUNT_NO_TAX Calculated Amount Number Tax NUMBER

CHART_OF_ACCOUNTS Chart Of Accounts Represents a systematic classification of accounts. Identifies a separate and distinct entity-accounting relationship within a multi-chart environment. VARCHAR2(1)
FTCRACTG

COAS_CODE

CHART_OF_ACCOUNTS_DESC Chart Of Accounts Description Chart of accounts description. VARCHAR2(35)
FUNCTION

FOKODSF.F_GET_FINANCE_DESC

CURRENT_DATE Current Date SYSDATE DATE
FUNCTION

SYSDATE

DISTRIBUTION_PERCENT Distribution Percent Percentage of the transaction total amount assigned to this accounting distribution. NUMBER(8,5)
FTCRACTG

PERCENT_OF_TOTAL

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

NA

EXPENSE_ITEM_KEY Expense Item KEY Unique internal identification number of the expense item record. NUMBER(19)
FTCRACTG

FTPREXPS_ID

FINANCE_SECURITY_ID Finance Security ID Oracle user ID linked to the expense owner PIDM when it is available. Used for fund organization security checking in the event a finance profile exists for the expense owner. VARCHAR2(30)
FTCRACTG

ORACLE_ID

FUND Fund Unique fiscal entity code. A fund can be restricted (e.g. grants) or unrestricted (e.g. general). VARCHAR2(6)
FTCRACTG

FUND_CODE

FUNDING_ACTIVITY_DATE Funding Activity Date Date information for this record in the table was entered or last updated. DATE
FTCRACTG

ACTIVITY_DATE

FUNDING_CREATE_DATE Funding Create Date Date and time when the new expense detail record was created. DATE
FTCRACTG

CREATE_DATE

FUNDING_CREATE_SOURCE Funding Create Source Source system that created the data. VARCHAR2(30)
FTCRACTG

CREATE_SOURCE

FUNDING_CREATE_USER Funding Create User Banner ID of the person who created this new record. VARCHAR2(30)
FTCRACTG

CREATE_USER

FUNDING_DATA_ORIGIN Funding Data Origin Source system that created or updated the data. VARCHAR2(30)
FTCRACTG

DATA_ORIGIN

FUNDING_USER_ID Funding User ID Unique identification code of the user who entered or last touched the transaction. VARCHAR2(30)
FTCRACTG

USER_ID

LOCATION Location Identification accounting code of a physical location, used in fixed assets to define the location a fixed asset has been assigned to. VARCHAR2(6)
FTCRACTG

LOCN_CODE

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

NA

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

NA

ORGANIZATION_CODE Organization Code Identification accounting code designating a department within the institution. VARCHAR2(6)
FTCRACTG

ORGN_CODE

PAY_CURRENCY_AMOUNT Pay Currency Amount NUMBER

PAY_CURRENCY_AMOUNT_NO_TAX Pay Currency Amount Number Tax NUMBER

PORTFOLIO_KEY Portfolio KEY Unique internal identification number of the portfolio record. NUMBER(19)
FTCRACTG

FTPBPORT_ID

PROFILE_KEY Profile KEY Unique internal identification number of the profile record. NUMBER(19)
FTCRACTG

FTOBPROF_ID

PROGRAM Program Identification accounting code used to identify the program classification structure or a subset of that structure as defined by the national council of higher education management systems. VARCHAR2(6)
FTCRACTG

PROG_CODE

PROJECT Project Identification code for a project defined in cost accounting. VARCHAR2(8)
FTCRACTG

PROJ_CODE

PROJECT_DESC Project Description Project description. VARCHAR2(35)
FUNCTION

FOKODSF.F_GET_FINANCE_DESC

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

NA

Ver:

Description	Contains general expense authorization accounting data including, fiscal year/period, accounting distribution, and approved amount. Additional reporting can be by financial manager or the various hierarchy levels of the fund, organization code, account, program, and location.
Key & Frequency	One row per accounting key.

Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ACCOUNT	Account	Code representing an account, such as assets, liability, control, fund balance, revenue, labor, expenditure or transfer.	VARCHAR2(6)	FTCRACTG	ACCT_CODE
ACCOUNTING_KEY	Accounting KEY	Unique internal identification number of the accounting record.	NUMBER(19)	FTCRACTG	ID
ACCOUNT_INDEX	Account INDEX	Account Index used to default an accounting distribution.	VARCHAR2(6)	FTCRACTG	ACCI_CODE
ACCOUNT_INDEX_DESC	Account INDEX Description	Account index description.	VARCHAR2(35)	FUNCTION	FOKODSF.F_GET_FINANCE_DESC
ACTIVITY	Activity	Code used to identify accounting data by activity.	VARCHAR2(6)	FTCRACTG	ACTV_CODE
AMOUNT	Amount	Amount entered on the funding source to be used for the expense. The total of amount and percent (if any) must be equal to 100 percent for the expense item at final approval.	NUMBER(17,2)	FTCRACTG	AMOUNT
BANK	Bank	Official banking institution.	VARCHAR2(2)	FTCRACTG	BANK_CODE
BANK_DESC	Bank Description	Official banking institution name.	VARCHAR2(35)	GXVBANK	GXVBANK_ACCT_NAME
BANK_UID	Bank UID	Internal identification number of the bank used at the time the transaction occurred.	NUMBER(8)	GXVBANK	GXVBANK_BANK_CODE_PIDM
CALCULATED_AMOUNT_NO_TAX	Calculated Amount Number Tax		NUMBER
CHART_OF_ACCOUNTS	Chart Of Accounts	Represents a systematic classification of accounts. Identifies a separate and distinct entity-accounting relationship within a multi-chart environment.	VARCHAR2(1)	FTCRACTG	COAS_CODE
CHART_OF_ACCOUNTS_DESC	Chart Of Accounts Description	Chart of accounts description.	VARCHAR2(35)	FUNCTION	FOKODSF.F_GET_FINANCE_DESC
CURRENT_DATE	Current Date	SYSDATE	DATE	FUNCTION	SYSDATE
DISTRIBUTION_PERCENT	Distribution Percent	Percentage of the transaction total amount assigned to this accounting distribution.	NUMBER(8,5)	FTCRACTG	PERCENT_OF_TOTAL
DOMAIN_VALUE	Domain Value	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA
EXPENSE_ITEM_KEY	Expense Item KEY	Unique internal identification number of the expense item record.	NUMBER(19)	FTCRACTG	FTPREXPS_ID
FINANCE_SECURITY_ID	Finance Security ID	Oracle user ID linked to the expense owner PIDM when it is available. Used for fund organization security checking in the event a finance profile exists for the expense owner.	VARCHAR2(30)	FTCRACTG	ORACLE_ID
FUND	Fund	Unique fiscal entity code. A fund can be restricted (e.g. grants) or unrestricted (e.g. general).	VARCHAR2(6)	FTCRACTG	FUND_CODE
FUNDING_ACTIVITY_DATE	Funding Activity Date	Date information for this record in the table was entered or last updated.	DATE	FTCRACTG	ACTIVITY_DATE
FUNDING_CREATE_DATE	Funding Create Date	Date and time when the new expense detail record was created.	DATE	FTCRACTG	CREATE_DATE
FUNDING_CREATE_SOURCE	Funding Create Source	Source system that created the data.	VARCHAR2(30)	FTCRACTG	CREATE_SOURCE
FUNDING_CREATE_USER	Funding Create User	Banner ID of the person who created this new record.	VARCHAR2(30)	FTCRACTG	CREATE_USER
FUNDING_DATA_ORIGIN	Funding Data Origin	Source system that created or updated the data.	VARCHAR2(30)	FTCRACTG	DATA_ORIGIN
FUNDING_USER_ID	Funding User ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)	FTCRACTG	USER_ID
LOCATION	Location	Identification accounting code of a physical location, used in fixed assets to define the location a fixed asset has been assigned to.	VARCHAR2(6)	FTCRACTG	LOCN_CODE
MIF_DESC	MIF Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA
MIF_VALUE	MIF Value	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA
ORGANIZATION_CODE	Organization Code	Identification accounting code designating a department within the institution.	VARCHAR2(6)	FTCRACTG	ORGN_CODE
PAY_CURRENCY_AMOUNT	Pay Currency Amount		NUMBER
PAY_CURRENCY_AMOUNT_NO_TAX	Pay Currency Amount Number Tax		NUMBER
PORTFOLIO_KEY	Portfolio KEY	Unique internal identification number of the portfolio record.	NUMBER(19)	FTCRACTG	FTPBPORT_ID
PROFILE_KEY	Profile KEY	Unique internal identification number of the profile record.	NUMBER(19)	FTCRACTG	FTOBPROF_ID
PROGRAM	Program	Identification accounting code used to identify the program classification structure or a subset of that structure as defined by the national council of higher education management systems.	VARCHAR2(6)	FTCRACTG	PROG_CODE
PROJECT	Project	Identification code for a project defined in cost accounting.	VARCHAR2(8)	FTCRACTG	PROJ_CODE
PROJECT_DESC	Project Description	Project description.	VARCHAR2(35)	FUNCTION	FOKODSF.F_GET_FINANCE_DESC
ZONE_VALUE	Zone Value	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA