BCM User defined fields and there labels in SQL

[The Caterer]

We use UDF date fields to record the date our sales people perform various
tasks/sales stages. In a new trial database I was able to create 2 date
fields and assign them different dates and use a 3rd formulated numeric field
to determine the days between each date. However, in the Studio UDF fields
are named userfield1 userfield2 etc so in the trial it was easy to determine
which field is which. Unfortunately in our actual database we have 24 UDF’s
of which 6 are date fields that I need to identify.

I have poured over every possible solution I am aware of and I cannot find
any unique identifiers for the data fields when viewed in the Studio.

Could someone please assist me and tell me if there is any possible way to
identify which fields are which in a way that corresponds to the label/name
of the field as it is viewed in the BCM.

IN SIMPLE TERMS: The formula I am useing is
(datediff(day,[UserField1],[UserField2])) but I do not know which userfields
store the dates needed to use this formula in a third field to calculate the
difference.

THANKS IN ADVANCE

 

[Luther]

We use UDF date fields to record the date our sales people perform various
tasks/sales stages.  In a new trial database I was able to create 2 date
fields and assign them different dates and use a 3rd formulated numeric field
to determine the days between each date. However, in the Studio UDF fields
are named userfield1 userfield2 etc so in the trial it was easy to determine
which field is which. Unfortunately in our actual database we have 24 UDF’s
of which 6 are date fields that I need to identify.

I have poured over every possible solution I am aware of and I cannot find
any unique identifiers for the data fields when viewed in the Studio.

Could someone please assist me and tell me if there is any possible way to
identify which fields are which in a way that corresponds to the label/name
of the field as it is viewed in the BCM.  

IN SIMPLE TERMS: The formula I am useing is
(datediff(day,[UserField1],[UserField2])) but I do not know which userfields
store the dates needed to use this formula in a third field to calculate the
difference.

THANKS IN ADVANCE

I remember form an earlier discussion that there's a table in the
database that maps the user fields to their UI names.

 

[JanK]

Luther schreef:

We use UDF date fields to record the date our sales people perform various
tasks/sales stages. In a new trial database I was able to create 2 date
fields and assign them different dates and use a 3rd formulated numeric field
to determine the days between each date. However, in the Studio UDF fields
are named userfield1 userfield2 etc so in the trial it was easy to determine
which field is which. Unfortunately in our actual database we have 24 UDF’s
of which 6 are date fields that I need to identify.

I have poured over every possible solution I am aware of and I cannot find
any unique identifiers for the data fields when viewed in the Studio.

Could someone please assist me and tell me if there is any possible way to
identify which fields are which in a way that corresponds to the label/name
of the field as it is viewed in the BCM.

IN SIMPLE TERMS: The formula I am useing is
(datediff(day,[UserField1],[UserField2])) but I do not know which userfields
store the dates needed to use this formula in a third field to calculate the
difference.

THANKS IN ADVANCE

I remember form an earlier discussion that there's a table in the
database that maps the user fields to their UI names.

This sounds very interesting. Are you using BCM and some kind of other
software to manipulate the bcm database? How?

 

[Luther]

Luther schreef:

We use UDF date fields to record the date our sales people perform various
tasks/sales stages.  In a new trial database I was able to create 2 date
fields and assign them different dates and use a 3rd formulated numeric field
to determine the days between each date. However, in the Studio UDF fields
are named userfield1 userfield2 etc so in the trial it was easy to determine
which field is which. Unfortunately in our actual database we have 24 UDF’s
of which 6 are date fields that I need to identify.
I have poured over every possible solution I am aware of and I cannot find
any unique identifiers for the data fields when viewed in the Studio.
Could someone please assist me and tell me if there is any possible way to
identify which fields are which in a way that corresponds to the label/name
of the field as it is viewed in the BCM.  
IN SIMPLE TERMS: The formula I am useing is
(datediff(day,[UserField1],[UserField2])) but I do not know which userfields
store the dates needed to use this formula in a third field to calculate the
difference.
THANKS IN ADVANCE

I remember form an earlier discussion that there's a table in the
database that maps the user fields to their UI names.

This sounds very interesting. Are you using BCM and some kind of other
software to manipulate the bcm database? How?- Hide quoted text -

- Show quoted text -

Sql Express Management Studio is the popular tool for direct access to
the database. You can download it from microsoft.com.