Reporting View Target: ACCOUNT

Go To View:	RETURN TO BANNER ODS META DATA REPORTS LIST
	Finance Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: ACCOUNT_INDEX

Description Contains a list of all account index codes with their associated chart of accounts, effective dates, next change dates, fund codes, organization codes, account codes, program codes, activity codes, location codes, and override indicators.
Key & Frequency One row per chart of accounts per account index per effective date per next change date.
Recommended Search Columns CHART_OF_ACCOUNTS, ACCOUNT_INDEX, EFFECTIVE_DATE, NEXT_CHANGE_DATE
CHART_OF_ACCOUNTS, FUND
CHART_OF_ACCOUNTS, LOCATION
CHART_OF_ACCOUNTS, ORGANIZATION_CODE
CHART_OF_ACCOUNTS, PROGRAM

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(63)
FTVACCI

FTVACCI_ACCT_CODE

ACCOUNT_DESC Account Description Account code description or title. VARCHAR2(255)
FUNCTION

F_GET_FINANCE_DESC

ACCOUNT_INDEX Account INDEX Account Index is used as a short cut method to the data entry of an accounting distribution. It may contain any or all of the account distribution columns. VARCHAR2(63)
FTVACCI

FTVACCI_ACCI_CODE

ACCOUNT_INDEX_DESC Account INDEX Description Account index description. VARCHAR2(255)
FTVACCI

FTVACCI_TITLE

ACCOUNT_INDEX_STATUS Account INDEX Status Current status of the associated account index. VARCHAR2(63)
FTVACCI

FTVACCI_STATUS_IND

ACCOUNT_OVERRIDE Account Override Specifies whether the user may choose the defaulted account index or override it at data entry. VARCHAR2(63)
FTVACCI

FTVACCI_ACCT_OVERRIDE

ACCOUNT_STATUS Account Status Current status of the associated account. VARCHAR2(63)
FUNCTION

F_GET_FINANCE_STATUS

ACTIVITY Activity Code used to identify accounting data by activity. VARCHAR2(63)
FTVACCI

FTVACCI_ACTV_CODE

ACTIVITY_DESC Activity Description Activity code title or description. VARCHAR2(255)
FTVACTV

FTVACTV_TITLE

ACTIVITY_OVERRIDE Activity Override Indicator to allow the user to choose the default activity from the account index or data enter another value. VARCHAR2(63)
FTVACCI

FTVACCI_ACTV_OVERRIDE

ACTIVITY_STATUS Activity Status Extracted current status of the associated activity. VARCHAR2(63)
FTVACTV

FTVACTV_STATUS_IND

ADMINISTRATIVE_GROUP Administrative Group Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

CHART_OF_ACCOUNTS Chart Of Accounts Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)
FTVACCI

FTVACCI_COAS_CODE

CHART_OF_ACCOUNTS_DESC Chart Of Accounts Description Chart of accounts code description or title. VARCHAR2(255)
FTVCOAS

FTVCOAS_TITLE

CHART_OF_ACCOUNTS_STATUS Chart Of Accounts Status Extracted current status of the associated chart of accounts. VARCHAR2(63)
FTVCOAS

FTVCOAS_STATUS_IND

EFFECTIVE_DATE Effective Date Record effective date. DATE
FTVACCI

FTVACCI_EFF_DATE

FUND Fund Unique fiscal entity code. VARCHAR2(63)
FTVACCI

FTVACCI_FUND_CODE

FUND_DESC Fund Description Description or title of the associated fund. VARCHAR2(255)
FUNCTION

F_GET_FINANCE_DESC

FUND_OVERRIDE Fund Override Allows users to choose the defaulted account index or another value. VARCHAR2(63)
FTVACCI

FTVACCI_FUND_OVERRIDE

FUND_STATUS Fund Status Extracted current status of the associated fund. VARCHAR2(63)
FUNCTION

F_GET_FINANCE_STATUS

LOCATION Location Accounting identification code of the physical location to which the grant has been assigned. VARCHAR2(63)
FTVACCI

FTVACCI_LOCN_CODE

LOCATION_DESC Location Description Extracted description or title of the associated location. VARCHAR2(255)
FUNCTION

F_GET_FINANCE_DESC

LOCATION_OVERRIDE Location Override Allows users to choose the defaulted account index or another value. VARCHAR2(63)
FTVACCI

FTVACCI_LOCN_OVERRIDE

LOCATION_STATUS Location Status Extracted current status of the associated location. VARCHAR2(63)
FUNCTION

F_GET_FINANCE_STATUS

MULTI_SOURCE Multi Source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)
NA

NA

MULTI_SOURCE_DESC Multi Source Description Institution description for the record when the optional multi-institution facility feature has been applied. VARCHAR2(255)
NA

NA

NEXT_CHANGE_DATE Next Change Date The date this record was changed, reflecting the effective date of the next record. DATE
FTVACCI

FTVACCI_NCHG_DATE

ORGANIZATION_CODE Organization Code Identification accounting code used for the department. VARCHAR2(63)
FTVACCI

FTVACCI_ORGN_CODE

ORGANIZATION_DESC Organization Description Extracted description or title associated with the organization code. VARCHAR2(255)
FUNCTION

F_GET_FINANCE_DESC

ORGANIZATION_OVERRIDE Organization Override Allows users to choose the defaulted account index or another value. VARCHAR2(63)
FTVACCI

FTVACCI_ORGN_OVERRIDE

ORGANIZATION_STATUS Organization Status Extracted current status of the associated organization. VARCHAR2(63)
FUNCTION

F_GET_FINANCE_STATUS

PROCESS_GROUP Process Group Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

PROGRAM Program Accounting identification code. Identifies the program classification structure, or a subset or that structure, as defined by the national council of higher education management systems. VARCHAR2(63)
FTVACCI

FTVACCI_PROG_CODE

PROGRAM_DESC Program Description Extracted description or title of the associated program. VARCHAR2(255)
FUNCTION

F_GET_FINANCE_DESC

PROGRAM_OVERRIDE Program Override Allows users to choose the defaulted account index or another value. VARCHAR2(63)
FTVACCI

FTVACCI_PROG_OVERRIDE

PROGRAM_STATUS Program Status Extracted current status of the associated program. VARCHAR2(63)
FUNCTION

F_GET_FINANCE_STATUS

Ver: 9.0

Description	Contains a list of all account index codes with their associated chart of accounts, effective dates, next change dates, fund codes, organization codes, account codes, program codes, activity codes, location codes, and override indicators.
Key & Frequency	One row per chart of accounts per account index per effective date per next change date.
Recommended Search Columns	CHART_OF_ACCOUNTS, ACCOUNT_INDEX, EFFECTIVE_DATE, NEXT_CHANGE_DATE CHART_OF_ACCOUNTS, FUND CHART_OF_ACCOUNTS, LOCATION CHART_OF_ACCOUNTS, ORGANIZATION_CODE CHART_OF_ACCOUNTS, PROGRAM

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(63)	FTVACCI	FTVACCI_ACCT_CODE
ACCOUNT_DESC	Account Description	Account code description or title.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
ACCOUNT_INDEX	Account INDEX	Account Index is used as a short cut method to the data entry of an accounting distribution. It may contain any or all of the account distribution columns.	VARCHAR2(63)	FTVACCI	FTVACCI_ACCI_CODE
ACCOUNT_INDEX_DESC	Account INDEX Description	Account index description.	VARCHAR2(255)	FTVACCI	FTVACCI_TITLE
ACCOUNT_INDEX_STATUS	Account INDEX Status	Current status of the associated account index.	VARCHAR2(63)	FTVACCI	FTVACCI_STATUS_IND
ACCOUNT_OVERRIDE	Account Override	Specifies whether the user may choose the defaulted account index or override it at data entry.	VARCHAR2(63)	FTVACCI	FTVACCI_ACCT_OVERRIDE
ACCOUNT_STATUS	Account Status	Current status of the associated account.	VARCHAR2(63)	FUNCTION	F_GET_FINANCE_STATUS
ACTIVITY	Activity	Code used to identify accounting data by activity.	VARCHAR2(63)	FTVACCI	FTVACCI_ACTV_CODE
ACTIVITY_DESC	Activity Description	Activity code title or description.	VARCHAR2(255)	FTVACTV	FTVACTV_TITLE
ACTIVITY_OVERRIDE	Activity Override	Indicator to allow the user to choose the default activity from the account index or data enter another value.	VARCHAR2(63)	FTVACCI	FTVACCI_ACTV_OVERRIDE
ACTIVITY_STATUS	Activity Status	Extracted current status of the associated activity.	VARCHAR2(63)	FTVACTV	FTVACTV_STATUS_IND
ADMINISTRATIVE_GROUP	Administrative Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
CHART_OF_ACCOUNTS	Chart Of Accounts	Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(63)	FTVACCI	FTVACCI_COAS_CODE
CHART_OF_ACCOUNTS_DESC	Chart Of Accounts Description	Chart of accounts code description or title.	VARCHAR2(255)	FTVCOAS	FTVCOAS_TITLE
CHART_OF_ACCOUNTS_STATUS	Chart Of Accounts Status	Extracted current status of the associated chart of accounts.	VARCHAR2(63)	FTVCOAS	FTVCOAS_STATUS_IND
EFFECTIVE_DATE	Effective Date	Record effective date.	DATE	FTVACCI	FTVACCI_EFF_DATE
FUND	Fund	Unique fiscal entity code.	VARCHAR2(63)	FTVACCI	FTVACCI_FUND_CODE
FUND_DESC	Fund Description	Description or title of the associated fund.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
FUND_OVERRIDE	Fund Override	Allows users to choose the defaulted account index or another value.	VARCHAR2(63)	FTVACCI	FTVACCI_FUND_OVERRIDE
FUND_STATUS	Fund Status	Extracted current status of the associated fund.	VARCHAR2(63)	FUNCTION	F_GET_FINANCE_STATUS
LOCATION	Location	Accounting identification code of the physical location to which the grant has been assigned.	VARCHAR2(63)	FTVACCI	FTVACCI_LOCN_CODE
LOCATION_DESC	Location Description	Extracted description or title of the associated location.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
LOCATION_OVERRIDE	Location Override	Allows users to choose the defaulted account index or another value.	VARCHAR2(63)	FTVACCI	FTVACCI_LOCN_OVERRIDE
LOCATION_STATUS	Location Status	Extracted current status of the associated location.	VARCHAR2(63)	FUNCTION	F_GET_FINANCE_STATUS
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NEXT_CHANGE_DATE	Next Change Date	The date this record was changed, reflecting the effective date of the next record.	DATE	FTVACCI	FTVACCI_NCHG_DATE
ORGANIZATION_CODE	Organization Code	Identification accounting code used for the department.	VARCHAR2(63)	FTVACCI	FTVACCI_ORGN_CODE
ORGANIZATION_DESC	Organization Description	Extracted description or title associated with the organization code.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
ORGANIZATION_OVERRIDE	Organization Override	Allows users to choose the defaulted account index or another value.	VARCHAR2(63)	FTVACCI	FTVACCI_ORGN_OVERRIDE
ORGANIZATION_STATUS	Organization Status	Extracted current status of the associated organization.	VARCHAR2(63)	FUNCTION	F_GET_FINANCE_STATUS
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
PROGRAM	Program	Accounting identification code. Identifies the program classification structure, or a subset or that structure, as defined by the national council of higher education management systems.	VARCHAR2(63)	FTVACCI	FTVACCI_PROG_CODE
PROGRAM_DESC	Program Description	Extracted description or title of the associated program.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
PROGRAM_OVERRIDE	Program Override	Allows users to choose the defaulted account index or another value.	VARCHAR2(63)	FTVACCI	FTVACCI_PROG_OVERRIDE
PROGRAM_STATUS	Program Status	Extracted current status of the associated program.	VARCHAR2(63)	FUNCTION	F_GET_FINANCE_STATUS