RETURN TO BANNER EDW META DATA REPORTS LIST


Mail Tracking Star Report

Target Reports:

WDT_ADDRESS_TYPE - Address Type Dimension
Address type dimension table contains attributes for all addresses including type, status and descriptions. 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_MAIL_CODE - Mail Code Dimension
Mail code dimension table identifies the mailing or solicitation code and description. 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_MAIL_TRACKING - Mail Tracking Fact Table
Mail Tracking fact table provides measures for all mailings and solicitations a constituent should receive.

Source Reports:

AOBORGN
APBCONS_1
APRMAIL
ATVSICC
ATVSICC
CONFIDENTIALITY_IND_EXPRESSION
CONSTANT
CONSTANT
CONSTANT
CONSTITUENT_IND_EXPRESSION
EXPRESSION
EXPRESSION
EXP_GET_TO_DT
EXP_TRUNC_CREATE_DT
FULL_NAME_EXPRESSION
GOREMAL
GTVMAIL
HBS_EXPRESSIONS
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