Our organization would like to request that a STARTDATE field with a data type of DATE to the BBDW.DIM_PROSPECTPLAN table in the CRM data warehouse. This will facilitate more accurate reporting and would be a valuable addition to out of box functionality. We made the change, which worked as we wanted, and suggest that the following be added to update the field in the standard BBDW job:

UPDATE BBDW.DIM_PROSPECTPLAN

SET STARTDATE = ( SELECT C.STARTDATE

FROM CRM.DBO.PROSPECTPLAN C

WHERE C.ID = PROSPECTPLANSYSTEMID)