RETURN TO BANNER EDW META DATA REPORTS LIST


Constituent Profile Star Report

Target Reports:

WDT_CONSTITUENT_PROFILE - Constituent Profile Dimension
Constituent profile dimension table provides rating and attributes for all constituent profiles, including type, rating, source, level and interest. It uses the cleansing rules in the EDW for the short and long descriptions.
WDT_CONSTITUENT_PROFILE_DETAIL - Constituent Profile Detail Dimension
Constituent profile detail dimension table provides detail information for each profile. It uses the cleansing rules in the EDW for the short and long descriptions.
WDT_ENTITY - Entity Dimension
Entity dimension table provides information about a person or organization. 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_CONSTITUENT_PROFILE - Constituent Profile Fact Table
Constituent profile fact table provides measures for all constituent profiles, including profile amount, count and date.

Source Reports:

AMREXRT
AOBORGN
APBCONS_1
ATVEXRS
ATVSICC
ATVSICC
CLN_CONSTITUENT_PROFILE
CLN_CONSTITUENT_PROFILE_DETAIL
CLN_ENTITY
CLN_ENTITY
CLN_MULTI_SOURCE
CLN_MULTI_SOURCE
CONFIDENTIALITY_IND_EXPRESSION
CONSTANT
CONSTANT
CONSTANT
CONSTITUENT_IND_EXPRESSION
EXPRESSION
EXPRESSION
EXPRESSIONS
EXP_GET_TO_DT
EXP_TRUNC_CREATE_DT
FULL_NAME_EXPRESSION
GOREMAL
GROUP_COUNT_EXPRESSIONS
LOAD_PROCESS
MIDDLE_INITIAL_EXPRESSION
No Source
PERSON_IND_EXPRESSION
PREFFERED_PHONE_NUMBER
SPBPERS
SPRIDEN
SYSTEM_LOAD_PROCESS
WCV_DEFAULT_VALUES
WDT_WAREHOUSE_ENTITY
WDT_WAREHOUSE_ENTITY


Ver: 9.0