enterprise fields in PS database

[Jesse]

initially posted on the developer thread.
I have some custom fields and custom outline codes in my enterprise global
template. I'd like to run a query on the PS 2003 SQL database involving the
custom fields. I'm looking at the data reference for PJDB and PJSVRDB but I
cannot locate the custom fields in the SQL database. Can someone please point
me to the tables that contain the fields.

 

[Jonathan Yong]

For custom field, it is in:
MSP_DATE_FIELDS
MSP_DURATION_FIELDS
MSP_FLAG_FIELDS
MSP_NUMBER_FIELDS
MSP_TEXT_FIELDS

For outline it is in :
MSP_CODE_FIELDS

The definition for the outline code is in :
MSP_OUTLINE_CODES


Each custom field and outline code has a unique ID associate with it.
You can refer to the Project Server SDK to get hold of these ID.

 

[Jesse]

Thanks Jonathan!
--
Jesse

For custom field, it is in:
MSP_DATE_FIELDS
MSP_DURATION_FIELDS
MSP_FLAG_FIELDS
MSP_NUMBER_FIELDS
MSP_TEXT_FIELDS

For outline it is in :
MSP_CODE_FIELDS

The definition for the outline code is in :
MSP_OUTLINE_CODES


Each custom field and outline code has a unique ID associate with it.
You can refer to the Project Server SDK to get hold of these ID.