Go To View:  RETURN TO REPORTING VIEW 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 Definition Database Data Type Source Name Source Column
ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

ATTRIBUTE_DATA Additional user defined data values. VARCHAR2(255)

FNVSDAT

FNVSDAT_DATA

ATTRIBUTE_DESC Endowment fund attribute value description. VARCHAR2(255)

FNVSDAT

FNVSDAT_TITLE

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

FNVSDAT

FNVSDAT_SHORT_TITLE

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

FNREUSN

FNREUSN_SDAT_CODE_ATTR

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

FNREUSN

FNREUSN_SDAT_CODE_OPT1

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 code description or title. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

CHART_OF_ACCOUNTS_STATUS Status of the chart of accounts. VARCHAR2(63)

FTVCOAS

FTVCOAS_STATUS_IND

FUND Unique fiscal entity code. VARCHAR2(63)

FNREUSN

FNREUSN_FUND_CODE

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

FUNCTION

F_GET_FINANCE_DESC

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

FTVFUND

FTVFUND_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 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



Ver: 8.1