RETURN TO BANNER EDW META DATA REPORTS LIST


Exclusion 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_EXCLUSION - Exclusion Dimension
Exclusion dimension table provides information about exclusions. It uses the cleansing rules in the EDW for the short and long descriptions.
WDT_EXCLUSION_COMMENT - Exclusion Comment Dimension
Exclusion comment dimension table provides comments about an exclusion associated with 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_EXCLUSION - Exclusion Fact Table
Exclusion fact table provides measures for each active, inactive or pending exclusion associated with a constituent.

Source Reports:

AOBORGN
APBCONS_1
APREXCL
ATVEXCL
ATVSICC
ATVSICC
CLN_ENTITY
CLN_ENTITY
CLN_EXCLUSION
CLN_EXCLUSION_COMMENT
CLN_MULTI_SOURCE
CLN_MULTI_SOURCE
CONFIDENTIALITY_IND_EXPRESSION
CONSTANT
CONSTANT
CONSTANT
CONSTITUENT_IND_EXPRESSION
EXPRESSION
EXPRESSION
EXPRESSION_0
EXP_GET_TO_DT
EXP_TRUNC_CREATE_DT
FULL_NAME_EXPRESSION
GOREMAL
GROUP_COUNT_EXPRESSIONS
LKP_EXPRESSION
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