custom FIELD_IDs and names

[NJS]

Good day All,
I need to update (renamed) custom field data, but do not know which field is
which (from the custom FIELD_IDs). Is there some way/property to ascertain
(renamed) names of custom fields from the system assigned FIELD_ID, so that I
can address them by their new (or default) name?
thank you.

 

[JackD]

Just going from memory, but I think that the MSP_CONVERSIONS table is used
to map field names to field ID's. Not sure where the new name of the field
is stored though.

-Jack

 

[NJS]

Thanks Jack,
that is the problem (not knowing which FIELD_ID applies to which renamed
custom field). In the conversions table the original name (e.g. Task Cost1)
exists, with a CONV_VALUE that maps to fields in the other custom tables -
Anyway, by using the above, it is possible to ascertain the field IDs and
populate accordingly. so problem solved.

 

[Big John]

The Information you are looking for is on the MSP_Outline_Codes table

I setup a sql View to extract the value list for the global project (e.g.
Max ProjID) and then link to the view to obtain the name and fully qualified
name data for reporting

John Purvis, PMP MCP
Portfolio PM
www.PortfolioPM.com

 

[NJS]

Thanks John, much obliged.

The Information you are looking for is on the MSP_Outline_Codes table

I setup a sql View to extract the value list for the global project (e.g.
Max ProjID) and then link to the view to obtain the name and fully qualified
name data for reporting

John Purvis, PMP MCP
Portfolio PM
www.PortfolioPM.com