Banner EDW Source: ATVPRST

RETURN TO BANNER EDW META DATA REPORTS LIST

**SGHE Enterprise Data Warehouse**
Source Column	Local Source	Target Type	Target	Target Column	Star Name	Local Target
ATVPRST_ACTIVE_IND	NO	REPORTING VIEW	PROSPECT_PROPOSAL_RESULT PROSPECT_PROPOSAL_MASTER PROSPECT_PROPOSAL PROSPECT_PROPOSAL_PROJECT PROJECT_INTEREST PROSPECT_INFO PROSPECT_PROPOSAL_RESULT PROSPECT_PROPOSAL_PROJECT	PROPOSAL_ACTIVE_IND PROPOSAL_ACTIVE_IND PROPOSAL_ACTIVE_IND PROPOSAL_PROJECT_ACTIVE_IND ACTIVE_PROJECT_IND ACTIVE_PROSPECT_IND PROPOSAL_PROJECT_ACTIVE_IND PROPOSAL_ACTIVE_IND	NA NA NA NA NA NA NA NA	NO NO NO NO NO NO NO NO
ATVPRST_CODE	NO	DIMENSION TABLE	WDT_STAGE	STAGE	MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, PROPOSAL, PROPOSAL PURPOSE, PROPOSAL PURPOSE STAGE, PROPOSAL STAGE, PROSPECT, PROSPECT INTEREST, PROSPECT STAGE	NO
ATVPRST_DESC	NO	DIMENSION TABLE REPORTING VIEW	WDT_STAGE WDT_STAGE PROSPECT_INFO	STAGE_LD STAGE_SD PROSPECT_STATUS_DESC	MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, PROPOSAL, PROPOSAL PURPOSE, PROPOSAL PURPOSE STAGE, PROPOSAL STAGE, PROSPECT, PROSPECT INTEREST, PROSPECT STAGE MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, PROPOSAL, PROPOSAL PURPOSE, PROPOSAL PURPOSE STAGE, PROPOSAL STAGE, PROSPECT, PROSPECT INTEREST, PROSPECT STAGE NA	NO NO NO

Ver: 9.0