RETURN TO BANNER EDW META DATA REPORTS LIST

SGHE Enterprise Data Warehouse
Fact Table Target: WFT_PROPOSAL_PURPOSE

Description Proposal purpose fact table provides measures counting proposal purposes, how many were granted and how many are active, start and end dates, if an ask was made, actual ask amount, last ask amount, last ask date, target ask date original ask, targeted, and granted amounts.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
ADVANCEMENT_PROGRAM_KEY System generated, unique, internal primary key for advancement program. NUMBER       NO
ADVANCEMENT_PROGRAM_YEAR_KEY System generated, unique, internal primary key for an advancement program year. NUMBER       NO
DESIGNATION_DETAIL_KEY System generated, unique, internal primary key for a designation detail record. NUMBER       NO
DESIGNATION_KEY System generated, unique, internal primary key for a designation. NUMBER       NO
FUNDRAISING_INITIATIVE_KEY System generated, unique, internal primary key for a proposal and proposal purpose. NUMBER       NO
MULTI_SOURCE_KEY System generated, unique, internal primary key for the multi-institution facility. NUMBER       NO
PROPOSAL_KEY System generated, unique, internal primary key for a donor proposal. NUMBER       NO
PROPOSAL_PURPOSE_ACTIVE_IND Indicates whether this proposal purpose is active. NUMBER       NO
PROPOSAL_PURPOSE_ASK_AMOUNT Proposal purpose ask amount. NUMBER       NO
PROPOSAL_PURPOSE_ASK_MADE_IND Indicates whether an ask amount was made for this proposal purpose. NUMBER       NO
PROPOSAL_PURPOSE_COUNT Number of proposal purposes. NUMBER       NO
PROPOSAL_PURPOSE_END_DATE Proposal purpose end date. DATE       NO
PROPOSAL_PURPOSE_GRANTED_AMT Proposal purpose granted amount. NUMBER       NO
PROPOSAL_PURPOSE_GRANTED_COUNT Number of granted proposal purposes. NUMBER       NO
PROPOSAL_PURPOSE_GRANTED_IND Indicates whether the proposal purpose has been granted. NUMBER       NO
PROPOSAL_PURPOSE_KEY System generated, unique, internal primary key for a proposal purpose. NUMBER       NO
PROPOSAL_PURPOSE_LATEST_ASK Last ask amount recorded for the proposal purpose. NUMBER       NO
PROPOSAL_PURPOSE_LATEST_ASK_DT Last date an ask amount was recorded for the proposal purpose. DATE       NO
PROPOSAL_PURPOSE_ORIGINAL_ASK Original requested ask amount for the proposal purpose. NUMBER       NO
PROPOSAL_PURPOSE_STAGE_KEY System generated, unique, internal primary key for the stage of a proposal purpose. NUMBER       NO
PROPOSAL_PURPOSE_START_DATE Proposal purpose start date. DATE       NO
PROPOSAL_PURPOSE_TARGET_AMOUNT Proposal purpose targeted amount. NUMBER       NO
PROPOSAL_PURPOSE_TARGET_DATE Proposal purpose target ask date. DATE       NO
PROPOSAL_PURPOSE_UNIT_KEY System generated, unique, internal primary key for the school or unit. NUMBER       NO
PROSPECT_KEY System generated, unique, internal primary key for a prospect. NUMBER       NO
SYSTEM_LOAD_PROCESS Name of the transformation that created the row during the load activity process. VARCHAR2(30)       NO
SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE       NO
USER_MEASURE_01   NUMBER       NO
USER_MEASURE_02   NUMBER       NO
USER_MEASURE_03   NUMBER       NO
USER_MEASURE_04   NUMBER       NO
USER_MEASURE_05   NUMBER       NO


Ver: 9.0