Reporting View Target: ENDOWMENT

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

SGHE Banner Operational Data Store
Reporting View Target: ENDOWMENT_ATTRIBUTES

Description Contains endowment user defined attributes assigned to an endowment fund used to meet external and or internal reporting requirements.
Key & Frequency One row per chart of accounts per endowment fund per attribute table per attribute value.
Recommended Search Columns CHART_OF_ACCOUNTS, FUND

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

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

NA

ATTRIBUTE_DATA Attribute Data Additional user defined data values. VARCHAR2(255)
FNVSDAT

FNVSDAT_DATA

ATTRIBUTE_DESC Attribute Description Endowment fund attribute value description. VARCHAR2(255)
FNVSDAT

FNVSDAT_TITLE

ATTRIBUTE_SHORT_DESC Attribute Short Description Short description for the endowment fund attribute value. VARCHAR2(255)
FNVSDAT

FNVSDAT_SHORT_TITLE

ATTRIBUTE_TABLE Attribute Table User defined table used for ad-hoc reporting purposes. VARCHAR2(63)
FNREUSN

FNREUSN_SDAT_CODE_ATTR

ATTRIBUTE_TABLE_VALUE Attribute Table Value User defined attribute value used for ad-hoc reporting purposes. VARCHAR2(63)
FNREUSN

FNREUSN_SDAT_CODE_OPT1

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

FNREUSN_COAS_CODE

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

F_GET_FINANCE_DESC

CHART_OF_ACCOUNTS_STATUS Chart Of Accounts Status Status of the chart of accounts. VARCHAR2(63)
FTVCOAS

FTVCOAS_STATUS_IND

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

FNREUSN_FUND_CODE

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

F_GET_FINANCE_DESC

FUND_STATUS Fund Status Current status of the associated fund. VARCHAR2(63)
FTVFUND

FTVFUND_STATUS_IND

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 when the optional multi-institution facility feature has been applied. VARCHAR2(255)
NA

NA

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

NA

Ver: 9.0

Description	Contains endowment user defined attributes assigned to an endowment fund used to meet external and or internal reporting requirements.
Key & Frequency	One row per chart of accounts per endowment fund per attribute table per attribute value.
Recommended Search Columns	CHART_OF_ACCOUNTS, FUND

Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ADMINISTRATIVE_GROUP	Administrative Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
ATTRIBUTE_DATA	Attribute Data	Additional user defined data values.	VARCHAR2(255)	FNVSDAT	FNVSDAT_DATA
ATTRIBUTE_DESC	Attribute Description	Endowment fund attribute value description.	VARCHAR2(255)	FNVSDAT	FNVSDAT_TITLE
ATTRIBUTE_SHORT_DESC	Attribute Short Description	Short description for the endowment fund attribute value.	VARCHAR2(255)	FNVSDAT	FNVSDAT_SHORT_TITLE
ATTRIBUTE_TABLE	Attribute Table	User defined table used for ad-hoc reporting purposes.	VARCHAR2(63)	FNREUSN	FNREUSN_SDAT_CODE_ATTR
ATTRIBUTE_TABLE_VALUE	Attribute Table Value	User defined attribute value used for ad-hoc reporting purposes.	VARCHAR2(63)	FNREUSN	FNREUSN_SDAT_CODE_OPT1
CHART_OF_ACCOUNTS	Chart Of Accounts	Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(63)	FNREUSN	FNREUSN_COAS_CODE
CHART_OF_ACCOUNTS_DESC	Chart Of Accounts Description	Chart of accounts code description or title.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
CHART_OF_ACCOUNTS_STATUS	Chart Of Accounts Status	Status of the chart of accounts.	VARCHAR2(63)	FTVCOAS	FTVCOAS_STATUS_IND
FUND	Fund	Unique fiscal entity code.	VARCHAR2(63)	FNREUSN	FNREUSN_FUND_CODE
FUND_DESC	Fund Description	Description or title of the associated fund.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
FUND_STATUS	Fund Status	Current status of the associated fund.	VARCHAR2(63)	FTVFUND	FTVFUND_STATUS_IND
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 when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA