AGGREGATE FACT TABLE
WAT_MANAGE_PROSPECT_PIPELINE
ACTIVE_PROGRAM_PROSPECT_COUNT
NO
ACTIVE_PROPOSAL_COUNT
ACTIVE_PROSPECT_COUNT
FACT TABLE
WFT_ADDRESS
ADDRESS_COUNT
ADDRESS_GROUP_KEY
ADDRESS
ADVANCEMENT_ACTIVITY_GROUP_KEY
ADVANCEMENT_DEGREE_GROUP_KEY
ADVANCEMENT_PROGRAM_KEY
ADVANCEMENT_PROGRAM_YEAR_KEY
AFFILIATION_GROUP_KEY
AWARD_HONOR_GROUP_KEY
CE_TYPE_GROUP_KEY
CLEARANCE_START_DATE
CLEARANCE_STOP_DATE
COMMITTEE_GROUP_KEY
CONSTITUENT_ENTITY_ATTRIB_KEY
CONSTITUENT_EVAL_GROUP_KEY
CONSTITUENT_INTEREST_GROUP_KEY
CONSTITUENT_PROFILE_GROUP_KEY
CONST_EMPLOYMENT_GROUP_KEY
CONT_REP_PROSPECT_GROUP_KEY
CURRENT_ADDRESS_COUNT
CURRENT_ADDRESS_IND
CURRENT_GIVING_TOTAL_KEY
CURRENT_SEASONAL_ADDRESS_COUNT
CURRENT_SP_GIVING_TOTAL_KEY
DEMOGRAPHIC_KEY
EMAIL_GROUP_KEY
ENTITY_ID
EXCLUSION_GROUP_KEY
FIRST_PROPOSAL_RESULT_DATE
WAT_MANAGE_PROSPECT_PIPELINE_B
FIRST_PROP_PURPOSE_RESULT_DATE
WFT_MATCHING_CLAIM
GIFT_DATE_OF_RECORD
GIFT_RECEIPT_DATE
GIFT_SOCIETY_GROUP_KEY
LAST_ENT_CRPT_ATTRIB_KEY
LAST_ENT_CRPT_AUTH_STAFF_KEY
LAST_ENT_CRPT_KEY
LAST_PROPOSAL_PURPOSE_ASK_DATE
LAST_PROS_CRPT_ATTRIB_KEY
LAST_PROS_CRPT_AUTH_STAFF_KEY
LAST_PROS_CRPT_KEY
LATEST_ENTITY_CONTACT_DATE
LATEST_PROPOSAL_ASK_AMOUNT
LATEST_PROSPECT_CONTACT_DATE
WFT_CONTACT_REPORT
LATEST_VISIT_IND
LG_HARD_GIVING_TOTAL_KEY
LG_HARD_SP_GIVING_TOTAL_KEY
LG_SOFT_GIVING_TOTAL_KEY
LG_SOFT_SP_GIVING_TOTAL_KEY
MAILING_HISTORY_GROUP_KEY
MAILING_LIST_GROUP_KEY
MAIL_TRACKING_GROUP_KEY
MEMBERSHIP_GROUP_KEY
PGM_PROSPECT_EVAL_GROUP_KEY
PGM_PROSPECT_SHARED_ATTRIB_KEY
PGM_PROSPECT_STAGE_START_DATE
PHONE_GROUP_KEY
PREFERRED_ADDRESS_IND
PREFERRED_ADDRESS_TYPE_KEY
PREFERRED_CLASS_SCHOOL_KEY
PREFERRED_POSTAL_KEY
PREFERRED_STREET_LINE_KEY
PRIMARY_ASSIGNMENT_ENTITY_KEY
PRIMARY_ASSIGNMENT_ENTITY_UID
PRIMARY_ASSIGNMENT_KEY
PRIMARY_ASSIGNMENT_OFFICE_KEY
PRIMARY_ASSIGNMENT_STAFF_KEY
PRIMARY_ASSIGNMENT_UNIT_KEY
PRIMARY_CE_TYPE_KEY
PRIMARY_PROSPECT_ENTITY_COUNT
PROGRAM_ASSIGNMENT_GROUP_KEY
PROGRAM_PROSPECT_ASSIGNED_IND
PROGRAM_PROSPECT_ATTRIBUTE_KEY
PROGRAM_PROSPECT_COUNT
PROGRAM_PROSPECT_RATED_AMOUNT
PROGRAM_PROSPECT_RESULT_AMOUNT
PROGRAM_PROSPECT_RESULT_DATE
PROGRAM_PROSPECT_STAGE_KEY
PROGRAM_PROSPECT_START_DATE
PROGRAM_PROSPECT_STOP_DATE
PROGRAM_PROSPECT_TARGET_DATE
PROGRAM_PROSPECT_UNIT_KEY
PROPOSAL_ASK_AMOUNT
PROPOSAL_ASK_DATE
PROPOSAL_ASK_MADE_IND
PROPOSAL_ASSIGNED_IND
PROPOSAL_ASSIGNMENT_GROUP_KEY
PROPOSAL_ATTRIBUTE_KEY
PROPOSAL_CAMPAIGN_KEY
PROPOSAL_COUNT
PROPOSAL_DURATION
PROPOSAL_GRANTED_AMOUNT
PROPOSAL_GRANTED_IND
PROPOSAL_INIT_CONTRIB_AMOUNT
PROPOSAL_INIT_CONTRIB_DATE
PROPOSAL_KEY
PROPOSAL_ORIGINAL_ASK_AMOUNT
PROPOSAL_PURPOSE_ACTIVE_IND
PROPOSAL_PURPOSE_ASK_MADE_IND
PROPOSAL_PURPOSE_END_DATE
PROPOSAL_PURPOSE_GRANTED_IND
PROPOSAL_PURPOSE_RESULT_IND
PROPOSAL_PURPOSE_STAGE_DATE
PROPOSAL_PURPOSE_START_DATE
PROPOSAL_PURPOSE_TARGET_DATE
PROPOSAL_RESULT_IND
PROPOSAL_STAGE_KEY
PROPOSAL_STAGE_START_DATE
PROPOSAL_START_DATE
PROPOSAL_STOP_DATE
PROPOSAL_TARGET_AMOUNT
PROPOSAL_TARGET_DATE
PROPOSAL_TOTAL_RESULT_AMOUNT
PROPOSAL_UNIT_KEY
PROSPECT_ASSIGNED_IND
PROSPECT_ASSIGNMENT_GROUP_KEY
PROSPECT_ATTRIBUTE_KEY
PROSPECT_CAMPAIGN_KEY
PROSPECT_CATEGORY_GROUP_KEY
PROSPECT_COUNT
PROSPECT_ENTITY_COUNT
PROSPECT_EVAL_GROUP_KEY
PROSPECT_KEY
PROSPECT_PIPELINE_GROUP_A_KEY
PROSPECT_PIPELINE_GROUP_B_KEY
PROSPECT_RATED_AMOUNT
PROSPECT_RATE_ENTRY_DATE
PROSPECT_RESULT_AMOUNT
PROSPECT_RESULT_DATE
PROSPECT_SHARED_ATTRIBUTE_KEY
PROSPECT_STAGE_KEY
PROSPECT_STAGE_START_DATE
PROSPECT_START_DATE
PROSPECT_STOP_DATE
PROSPECT_TARGET_DATE
PROSPECT_UNIT_KEY
PROS_INT_MEASURE_FILTER_IND
RELATIONSHIP_GROUP_KEY
SEASONAL_ADDRESS_EXISTS_IND
SPECIAL_PURPOSE_GROUP_KEY
SPORT_GROUP_KEY
SPOUSE_ENTITY_KEY
SPOUSE_NON_ENTITY_KEY
SPOUSE_UID
STUDENT_ACTIVITY_GROUP_KEY
VARIABLE_PURPOSE_GROUP_KEY