Record date/time a Custom Project Outline Code is changed

M

Mike

I'm having a bit of trouble getting some reliable data from the Project
Server database and I'm hoping someone can point me in the right
direction. We have setup a Custom Project Outline Code to define a
project's status. I'm needing a solution that will record the
date/time when a PM sets a project's status to 'implemented' which, in
our system, is CODE_UID: 12. I understand that Enterprise Project
Dates are stored in the table MSP_DATE_FIELDS where DATE_CATEGORY = 0
AND DATE_REF_UID = 0. I have setup Enterprise Project Date 1 to be
this 'Implemented Date.' I have identified the CODE_FIELD_ID and the
DATE_FIELD_ID and written a trigger on the table MSP_CODE_FIELDS to
update this date field when the CODE_UID is changed to a 12. I've made
sure to set the bit flags PROJ_EXT_EDITED and PROJ_EXT_EDITED_DATE both
to a 1 within MSP_PROJECTS. Here's my confusion. If I manually change
these 2 bit fields back to 0, the date field as viewed from within
Project Pro > Project Information displays a date completely different
from the date that is stored in MSP_DATE_FIELDS. My question is where
is this other date being stored in the database? I can not find it
anywhere and I thought the MSP_DATE_FIELDS table was the only place
these were stored. Maybe a better question would be, is there a better
way to do this? An even better question would be, has anyone done this
before and what did you do? :)
Regards,
Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top