| PROSPECTMGRHISTORYDIMID | |
| PROSPECTDIMID | OOB 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 |
| PROSPECTSYSTEMID | Usually same as constituent system id |
| FUNDRAISERCONSTITUENTDIMID | OOB ETL package for DIM_PROSPECT grabs CONSTITUENTDIMID from DIM_CONSTITUENT but then inserts a new Primary Key to produce PROSPECTDIMID |
| FUNDRAISERCONSTITUENTSYSTEMID | Usually same as prospect system id |
| DATEFROM | |
| DATETO | |
| COMMENTS | |