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_ATTRIBUTES

Description Contains a list of all the set codes, attribute types, attribute values, and attribute values begin and end date associated with an account.
Key & Frequency One row per chart of accounts per account code per attribute type per attribute value per set code.
Recommended Search Columns VALUE
CHART_OF_ACCOUNTS, ACCOUNT, ATTRIBUTE_TYPE, ATTRIBUTE_VALUE
ATTRIBUTE_TYPE, ATTRIBUTE_VALUE, CHART_OF_ACCOUNTS

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

FTRACTA_ACCT_CODE

ACCOUNT_DESC Account code description or title. VARCHAR2(255)
FTVACCT

FTVACCT_TITLE

ACCOUNT_STATUS Status of the account. VARCHAR2(63)
FTVACCT

FTVACCT_STATUS_IND

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

NA

ATTRIBUTE_TYPE Set code that the attribute types are associated with. VARCHAR2(63)
FTRACTA

FTRACTA_ATTT_CODE

ATTRIBUTE_TYPE_DESC Attribute type description associated with the set. VARCHAR2(255)
FTVATTT

FTVATTT_DESC

ATTRIBUTE_TYPE_STATUS Attribute type status associated with the set. VARCHAR2(63)
FTVATTT

FTVATTT_STATUS_IND

ATTRIBUTE_TYPE_STATUS_DESC Activity status description of the attribute type. Active, or Inactive. VARCHAR2(255)
CALCULATION

DECODE(FTVATTT_STATUS_IND)

ATTRIBUTE_VALUE Code representing one of the values of the attribute type. VARCHAR2(63)
FTRACTA

FTRACTA_ATTV_CODE

ATTRIBUTE_VALUE_BEGIN_DATE Date from which this attribute value is valid. DATE
FTRATTV

FTRATTV_BEGIN_DATE

ATTRIBUTE_VALUE_DESC Attribute type value description. VARCHAR2(255)
FTRATTV

FTRATTV_DESC

ATTRIBUTE_VALUE_END_DATE Date after which this attribute value is not longer valid. DATE
FTRATTV

FTRATTV_END_DATE

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

FTRACTA_COAS_CODE

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

FTVCOAS_TITLE

CHART_OF_ACCOUNTS_STATUS Status of the chart of accounts. VARCHAR2(100)
FTVCOAS

FTVCOAS_STATUS_IND

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

NA

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

NA

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

NA

SET_CODE Code defining the set with which the attribute types are associated. VARCHAR2(63)
CALCULATION

NVL(FTRACTA_ATTS_CODE,'NONE')

SET_CODE_DESC Set code description. VARCHAR2(255)
FTVATTS

FTVATTS_DESC

Ver: 8.5

Description	Contains a list of all the set codes, attribute types, attribute values, and attribute values begin and end date associated with an account.
Key & Frequency	One row per chart of accounts per account code per attribute type per attribute value per set code.
Recommended Search Columns	VALUE CHART_OF_ACCOUNTS, ACCOUNT, ATTRIBUTE_TYPE, ATTRIBUTE_VALUE ATTRIBUTE_TYPE, ATTRIBUTE_VALUE, CHART_OF_ACCOUNTS

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(63)	FTRACTA	FTRACTA_ACCT_CODE
ACCOUNT_DESC	Account code description or title.	VARCHAR2(255)	FTVACCT	FTVACCT_TITLE
ACCOUNT_STATUS	Status of the account.	VARCHAR2(63)	FTVACCT	FTVACCT_STATUS_IND
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
ATTRIBUTE_TYPE	Set code that the attribute types are associated with.	VARCHAR2(63)	FTRACTA	FTRACTA_ATTT_CODE
ATTRIBUTE_TYPE_DESC	Attribute type description associated with the set.	VARCHAR2(255)	FTVATTT	FTVATTT_DESC
ATTRIBUTE_TYPE_STATUS	Attribute type status associated with the set.	VARCHAR2(63)	FTVATTT	FTVATTT_STATUS_IND
ATTRIBUTE_TYPE_STATUS_DESC	Activity status description of the attribute type. Active, or Inactive.	VARCHAR2(255)	CALCULATION	DECODE(FTVATTT_STATUS_IND)
ATTRIBUTE_VALUE	Code representing one of the values of the attribute type.	VARCHAR2(63)	FTRACTA	FTRACTA_ATTV_CODE
ATTRIBUTE_VALUE_BEGIN_DATE	Date from which this attribute value is valid.	DATE	FTRATTV	FTRATTV_BEGIN_DATE
ATTRIBUTE_VALUE_DESC	Attribute type value description.	VARCHAR2(255)	FTRATTV	FTRATTV_DESC
ATTRIBUTE_VALUE_END_DATE	Date after which this attribute value is not longer valid.	DATE	FTRATTV	FTRATTV_END_DATE
CHART_OF_ACCOUNTS	Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(63)	FTRACTA	FTRACTA_COAS_CODE
CHART_OF_ACCOUNTS_DESC	Chart of accounts code description or title.	VARCHAR2(255)	FTVCOAS	FTVCOAS_TITLE
CHART_OF_ACCOUNTS_STATUS	Status of the chart of accounts.	VARCHAR2(100)	FTVCOAS	FTVCOAS_STATUS_IND
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
SET_CODE	Code defining the set with which the attribute types are associated.	VARCHAR2(63)	CALCULATION	NVL(FTRACTA_ATTS_CODE,'NONE')
SET_CODE_DESC	Set code description.	VARCHAR2(255)	FTVATTS	FTVATTS_DESC