Database Tables - TD_Value calculation

[Traci B]

I am trying to determine how TD_VALUE1-7 values are stored. I found this
information in the pjdb.html file:

TD_UNITS Indicates the unit of time to which the specified values in
TD_VALUE1 - TD_VALUE7 apply: 0-m, 1-h, 2-d, etc…
TD_VALUE1 - TD_VALUE7 The value of the work, percent complete or cost for
the first through seventh time periods in the units specified in the TD_UNITS
column during the date range specified in the TD_START and TD_FINISH columns;
only values that fall between the specified start and finish dates will apply.

Here is sample data from table. Do other fields affect TD_VALUE1? If so,
which ones and how? How is this calculating the values I am getting in
TD_VALUE1?

MSP_TIMEPHASED_DATA
TD_UNITS TD_VALUE1
2 647142.857142857
2 1285460.19198193

 

[Rod Gill]

Value1 comes from the timephased fields you see in the Resource and Task
usage views. If you enter a value of work for a week, then the units for
that date range is 3. If you enter daily values, then 2 and so on.

Units aren't calculated they're governed by what you enter. So, no other
fields affect them. PJDB.htm tells you what the value1 field represents, I
think it's work in minutes*6000 or something similar.

 

[Traci B]

Thanks Again. I had looked in the pjdb (becoming very familiar w/ that
document), but couldn't find what it was multiplying by.