RETURN TO BANNER EDW META DATA REPORTS LIST


Designation Attribute Star Report

Target Reports:

WDT_DESIGNATION - Designation Dimension
Designation Dimension table provides information regarding the reasons a gift was given to the institution. This information includes the type, intended receiving college, purpose, etc. It uses the cleansing rules in the EDW for the short and long descriptions.
WDT_DESIGNATION_ATTRIBUTE - Designation Attribute Dimension
Designation Attribute dimension table identifies the set of attributes assigned to a designation that may be used to group and report of sets of designations.
WDT_DESIGNATION_DETAIL - Designation Detail Dimension
Designation detail dimension table provides information about a designation, including name, type, status and purpose. It uses the cleansing rules in the EDW for the short and long descriptions.
WDT_MULTI_SOURCE - Multi Source Dimension
Multi Source Dimension table provides an institution source value when the optional multi-source feature has been applied. Institution source VALUES have a short and long description. Data in this dimension may optionally include a process-oriented identifier and an administrative-oriented identifier for the record used to determine access authorization to this record. The cleansing rules are used in the EDW for the short and long descriptions.

WFT_DESIGNATION_ATTRIBUTE - Designation Attribute Fact Table
Designation attribute fact table provides measures for attributes associated to a designation.

Source Reports:

ADBDESG
ATVCFAE
ATVDATR
ATVDGRP
ATVDGRP
ATVDSTA
ATVDSTP
CLN_DESIGNATION
CLN_DESIGNATION_ATTRIBUTE
CLN_DESIGNATION_DETAIL
CLN_MULTI_SOURCE
CLN_MULTI_SOURCE
CONSTANT
CONSTANT
CONSTANT
DESIGNATION_ACCOUNT
EXPRESSION
EXPRESSION
No Source
STVCOLL
STVCOLL
STVDEPT
STVDEPT
SYSTEM_LOAD_PROCESS
WCV_DEFAULT_VALUES


Ver: 9.0