RETURN TO BANNER EDW META DATA REPORTS LIST


Rqpp Yearly Des Dept Star Report

Target Reports:


WAT_RQPP_YEARLY_DES_DEPT - Rqpp Yearly Des Dept Fact Table
Research and Qualify Potential Prospects Yearly Designation Department aggregate table builds on the data relationships and core population within the Research and Qualify Potential Prospects business concept. This table contains one row per year of giving per available constituent per designation-department and contains pre-summarized donor participation metrics for each available constituent by year of giving for the designation-department in context.
WDT_DESIGNATION_DEPT - Designation Dept Dimension
Designation department dimension table includes the designation department and description for those designation departments that have yearly donor participation metrics loaded in the WAT_RQPP_YEARLY_DES_DEPT aggregate fact table. It uses the cleansing rules in the EDW for the short and long descriptions.
WDT_DONOR_SUMMARY - Donor Summary Dimension
Donor summary dimension table contains summary giving information for a donor.
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_FISCAL_DATE - Fiscal Date Dimension
The Fiscal Date Dimension table provides information on the time frame for which the rest of the associated dimension and fact tables are storing the information in the star.
WDT_GIVING_TOTAL - Giving Total Dimension
Giving total dimension table contains summary giving information for a donor by fiscal year. The columns refer to both annual and non-annual information. If the fiscal years of the allocation types (both annual and non-annual) do not match, then the information in these records will consist of overlapping calendar time periods from the same fiscal years.
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.
WDT_YEAR_OF_GIVING - Year Of Giving Dimension
Year of giving dimension table provides common attribute information for the fiscal year.

Source Reports:

AGGREGATOR
AGGREGATOR_0
AGGREGATOR_2
AOBORGN
APBCONS_1
ATVFISC
ATVSICC
ATVSICC
CLN_YEAR_OF_GIVING
CONFIDENTIALITY_IND_EXPRESSION
CONSTANT
CONSTANT
CONSTANT
CONSTITUENT_IND_EXPRESSION
EXPRESSION
EXPRESSION
EXP_3_5_7_10
EXP_DOWNGRADE_UPGRADE_CONST
EXP_GET_TO_DT
EXP_LATEST_GIVING_YR_AMT
EXP_LYBUNT_SYBUNT
EXP_LY_DOWN_UPGR_CONST
EXP_LY_RETENTION_CONDITIONS
EXP_LY_RETENTION_STATUSES
EXP_REPLACE_NULL_VALUES
EXP_RETENTION_STATUSES
EXP_SHORT_LONG_LAPSE
EXP_TRUNC_CREATE_DT
FULL_NAME_EXPRESSION
GIFT_AGGREGATOR
GOREMAL
MGKUTIL.F_GETCALENDARRECORDS
MIDDLE_INITIAL_EXPRESSION
NO SOURCE
No Source
PERSON_IND_EXPRESSION
PLEDGE_AMTS
PREFFERED_PHONE_NUMBER
SPBPERS
SPRIDEN
SYSTEM_LOAD_PROCESS
TMP_WAT_RQPP_DES_DEPT_INT
WCV_DEFAULT_VALUES
WDT_WAREHOUSE_ENTITY
WDT_WAREHOUSE_ENTITY
WDT_YEAR_OF_GIVING
WDT_YEAR_OF_GIVING


Ver: 9.0