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 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 (out of curiosity), 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.
Regards,
Mike
Server database and I'm hoping someone can point me in the right
direction. We have setup a custom 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 (out of curiosity), 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.
Regards,
Mike