RETURN TO BANNER EDW META DATA REPORTS LIST


Mailing History Star Report

Target Reports:

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_MAILING_ATTRIBUTE - Mailing Attribute Dimension
Mailing attribute dimension table provides information about mailings sent to a constituent. 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_MAILING_HISTORY - Mailing History Fact Table
Mailing history fact table provides measures for all recorded mail correspondence with a constituent.

Source Reports:

AOBORGN
APBCONS_1
ATVSICC
ATVSICC
CLN_ENTITY
CLN_ENTITY
CLN_MAILING_ATTRIBUTE
CLN_MULTI_SOURCE
CLN_MULTI_SOURCE
CONFIDENTIALITY_IND_EXPRESSION
CONSTANT
CONSTANT
CONSTANT
CONSTITUENT_IND_EXPRESSION
EXPRESSION_0
EXP_GET_TO_DT
EXP_TRUNC_CREATE_DT
FULL_NAME_EXPRESSION
GOREMAL
GTVLETR
GTVSYSI
GURMAIL
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