Menu Close

DIM_PROSPECTMGRHISTORY_PHEXT

 

ColumnsComments
PROSPECTMGRHISTORYDIMID
PROSPECTDIMIDOOB ETL package for DIM_PROSPECT grabs CONSTITUENTDIMID from DIM_CONSTITUENT but then inserts a new Primary Key to produce PROSPECTDIMID. This is NOTR the same as the constituentdimid
PROSPECTSYSTEMIDUsually same as constituent system id
FUNDRAISERCONSTITUENTDIMIDOOB ETL package for DIM_PROSPECT grabs CONSTITUENTDIMID from DIM_CONSTITUENT but then inserts a new Primary Key to produce PROSPECTDIMID
FUNDRAISERCONSTITUENTSYSTEMIDUsually same as prospect system id
DATEFROM
DATETO
COMMENTS

Leave a Reply