RETURN TO BANNER EDW META DATA REPORTS LIST
Advancement Gift Star  

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_PLEDGE_RANGE

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
FINAL_INSTALL_MONTH   VARCHAR2(63)

FUNCTION

TO_CHAR(PLEDGE_INSTALLMENT_REC.INSTALLMENT_DATE,'MM')

NO

NO
FINAL_INSTALL_MONTH_LD   VARCHAR2(255)

FUNCTION

TO_CHAR(PLEDGE_INSTALLMENT_REC.INSTALLMENT_DATE,'MM')

NO

NO
FINAL_INSTALL_MONTH_SD   VARCHAR2(255)

FUNCTION

TO_CHAR(PLEDGE_INSTALLMENT_REC.INSTALLMENT_DATE,'MM')

NO

NO
FINAL_INSTALL_YEAR   VARCHAR2(63)

FUNCTION

TO_CHAR(PLEDGE_INSTALLMENT_REC.INSTALLMENT_DATE,'YYYY')

NO

NO
FINAL_INSTALL_YEAR_LD   VARCHAR2(255)

FUNCTION

TO_CHAR(PLEDGE_INSTALLMENT_REC.INSTALLMENT_DATE,'YYYY')

NO

NO
FINAL_INSTALL_YEAR_SD   VARCHAR2(255)

FUNCTION

TO_CHAR(PLEDGE_INSTALLMENT_REC.INSTALLMENT_DATE,'YYYY')

NO

NO
ORIGINAL_PLEDGE_RANGE   VARCHAR2(63)

ETL_GENERATED

NA

NO

NO ADVANCEMENT GIFT
ORIGINAL_PLEDGE_RANGE_LD   VARCHAR2(255)

ETL_GENERATED

NA

NO

NO ADVANCEMENT GIFT
ORIGINAL_PLEDGE_RANGE_SD   VARCHAR2(255)

ETL_GENERATED

NA

NO

NO ADVANCEMENT GIFT
OUTSTANDING_PLEDGE_RANGE   VARCHAR2(63)

ETL_GENERATED

NA

NO

NO ADVANCEMENT GIFT
OUTSTANDING_PLEDGE_RANGE_LD   VARCHAR2(255)

ETL_GENERATED

NA

NO

NO ADVANCEMENT GIFT
OUTSTANDING_PLEDGE_RANGE_SD   VARCHAR2(255)

ETL_GENERATED

NA

NO

NO ADVANCEMENT GIFT
PLEDGE_RANGE_KEY Key for the Pledge Range Dimension. NUMBER

ETL_GENERATED

NA

NO

NO ADVANCEMENT GIFT
SYSTEM_LOAD_PROCESS Name of the transformation that created the row during the load activity process. VARCHAR2(30)

ETL_GENERATED

NA

NO

NO ADVANCEMENT GIFT
SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE

ETL_GENERATED

NA

NO

NO ADVANCEMENT GIFT


Ver: 9.0