td_start

A

Andre.quitta

I am using MS Project 2002 standard and am using MSP_TIMEPHASED_DATA.
What I am not understanding is the TD_START_DATE.

For the TD_UNIT = 3 (unit of measure = "w" or week), I would expect
the TD_START_DATE to be a Sunday (the first day of the week) each
time, but its not. Its just as often a Tuesday or Thursday.

Would someone explain to me the meaning of
MSP_TIMEPHASED_DATA.TD_START_DATE?

My working query is below. Any help is appreciated.
Thanks
André Q

SELECT DISTINCT
MSP_ASSIGNMENTS.TASK_UID,
MSP_TASKS.TASK_NAME,
MSP_TASKS.TASK_START_DATE,
MSP_TASKS.TASK_FINISH_DATE,
MSP_RESOURCES.RES_NAME,
MSP_RESOURCES.RES_INITIALS,
MSP_TIMEPHASED_DATA.TD_REF_UID,
StrTypeCategory.STRING_TYPE,
ConvCategory.CONV_STRING,
StrTypeUnits.STRING_TYPE,
ConvUnits.CONV_STRING,
MSP_TIMEPHASED_DATA.TD_START,
MSP_TIMEPHASED_DATA.TD_FINISH,
Format([TD_VALUE1]/60000,"Standard") AS Week1,
Format([TD_VALUE2]/60000,"Standard") AS Week2,
Format([TD_VALUE3]/60000,"Standard") AS Week3,
Format([TD_VALUE4]/60000,"Standard") AS Week4,
Format([TD_VALUE5]/60000,"Standard") AS Week5,
Format([TD_VALUE6]/60000,"Standard") AS Week6,
Format([TD_VALUE7]/60000,"Standard") AS Week7,
MSP_TIMEPHASED_DATA.TD_UNITS
FROM MSP_TIMEPHASED_DATA
INNER JOIN MSP_CONVERSIONS AS ConvCategory
ON MSP_TIMEPHASED_DATA.TD_CATEGORY = ConvCategory.CONV_VALUE
INNER JOIN MSP_STRING_TYPES AS StrTypeCategory
ON ConvCategory.STRING_TYPE_ID = StrTypeCategory.STRING_TYPE_ID
INNER JOIN MSP_CONVERSIONS AS ConvUnits
ON MSP_TIMEPHASED_DATA.TD_UNITS = ConvUnits.CONV_VALUE
INNER JOIN MSP_STRING_TYPES AS StrTypeUnits
ON ConvUnits.STRING_TYPE_ID = StrTypeUnits.STRING_TYPE_ID
INNER JOIN MSP_ASSIGNMENTS
ON MSP_TIMEPHASED_DATA.TD_REF_UID = MSP_ASSIGNMENTS.ASSN_UID
INNER JOIN MSP_TASKS
ON MSP_ASSIGNMENTS.TASK_UID = MSP_TASKS.TASK_UID
INNER JOIN MSP_RESOURCES
ON MSP_ASSIGNMENTS.ImportKeyID = MSP_RESOURCES.ImportKeyID
AND MSP_ASSIGNMENTS.RES_UID = MSP_RESOURCES.RES_UID
WHERE MSP_TIMEPHASED_DATA.TD_REF_UID = 60249
AND ConvCategory.CONV_STRING = "Assignment"
AND ConvUnits.CONV_STRING = "w"
AND ConvCategory.STRING_TYPE_ID = 100
AND ConvUnits.STRING_TYPE_ID = 108
ORDER BY MSP_TIMEPHASED_DATA.TD_REF_UID,
MSP_TIMEPHASED_DATA.TD_START
 
R

Rod Gill

The prjdb.htm file in one of your program folders has the definitive
meaning, but from memory it is simply the date the data series starts on.
So, if you have a two and a half week task you are likely to get two
records, on weekly with two weekly values and one daily with the days in the
third week. TD_Start for the second record would be for the start of the
third week.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com



I am using MS Project 2002 standard and am using MSP_TIMEPHASED_DATA.
What I am not understanding is the TD_START_DATE.

For the TD_UNIT = 3 (unit of measure = "w" or week), I would expect
the TD_START_DATE to be a Sunday (the first day of the week) each
time, but its not. Its just as often a Tuesday or Thursday.

Would someone explain to me the meaning of
MSP_TIMEPHASED_DATA.TD_START_DATE?

My working query is below. Any help is appreciated.
Thanks
André Q

SELECT DISTINCT
MSP_ASSIGNMENTS.TASK_UID,
MSP_TASKS.TASK_NAME,
MSP_TASKS.TASK_START_DATE,
MSP_TASKS.TASK_FINISH_DATE,
MSP_RESOURCES.RES_NAME,
MSP_RESOURCES.RES_INITIALS,
MSP_TIMEPHASED_DATA.TD_REF_UID,
StrTypeCategory.STRING_TYPE,
ConvCategory.CONV_STRING,
StrTypeUnits.STRING_TYPE,
ConvUnits.CONV_STRING,
MSP_TIMEPHASED_DATA.TD_START,
MSP_TIMEPHASED_DATA.TD_FINISH,
Format([TD_VALUE1]/60000,"Standard") AS Week1,
Format([TD_VALUE2]/60000,"Standard") AS Week2,
Format([TD_VALUE3]/60000,"Standard") AS Week3,
Format([TD_VALUE4]/60000,"Standard") AS Week4,
Format([TD_VALUE5]/60000,"Standard") AS Week5,
Format([TD_VALUE6]/60000,"Standard") AS Week6,
Format([TD_VALUE7]/60000,"Standard") AS Week7,
MSP_TIMEPHASED_DATA.TD_UNITS
FROM MSP_TIMEPHASED_DATA
INNER JOIN MSP_CONVERSIONS AS ConvCategory
ON MSP_TIMEPHASED_DATA.TD_CATEGORY = ConvCategory.CONV_VALUE
INNER JOIN MSP_STRING_TYPES AS StrTypeCategory
ON ConvCategory.STRING_TYPE_ID = StrTypeCategory.STRING_TYPE_ID
INNER JOIN MSP_CONVERSIONS AS ConvUnits
ON MSP_TIMEPHASED_DATA.TD_UNITS = ConvUnits.CONV_VALUE
INNER JOIN MSP_STRING_TYPES AS StrTypeUnits
ON ConvUnits.STRING_TYPE_ID = StrTypeUnits.STRING_TYPE_ID
INNER JOIN MSP_ASSIGNMENTS
ON MSP_TIMEPHASED_DATA.TD_REF_UID = MSP_ASSIGNMENTS.ASSN_UID
INNER JOIN MSP_TASKS
ON MSP_ASSIGNMENTS.TASK_UID = MSP_TASKS.TASK_UID
INNER JOIN MSP_RESOURCES
ON MSP_ASSIGNMENTS.ImportKeyID = MSP_RESOURCES.ImportKeyID
AND MSP_ASSIGNMENTS.RES_UID = MSP_RESOURCES.RES_UID
WHERE MSP_TIMEPHASED_DATA.TD_REF_UID = 60249
AND ConvCategory.CONV_STRING = "Assignment"
AND ConvUnits.CONV_STRING = "w"
AND ConvCategory.STRING_TYPE_ID = 100
AND ConvUnits.STRING_TYPE_ID = 108
ORDER BY MSP_TIMEPHASED_DATA.TD_REF_UID,
MSP_TIMEPHASED_DATA.TD_START
 
A

Andre.quitta

All I have is projoledb.htm, and there is no mention of td_start.

From an initial search of the data using the method you suggest, I
didn't find that the weeks start on any given day, either the task
start day or the same week start date (e.g., Sunday). I tried you
method of summing up the different values for the duration (TD_UNIT)
and the broken out figures (TD_VALUE1 to TD_VALUE7) and they only
rarely match up.

If you see a reference for an explanation of how the table is broken
out, please forward it, because so far I've been unable to find any.

Thanks
Andre Q

The prjdb.htm file in one of your program folders has the definitive
meaning, but from memory it is simply the date the data series starts on.
So, if you have a two and a half week task you are likely to get two
records, on weekly with two weekly values and one daily with the days in the
third week.TD_Startfor the second record would be for the start of the
third week.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:http://www.projectvbabook.com


I am using MS Project 2002 standard and am using MSP_TIMEPHASED_DATA.
What I am not understanding is the TD_START_DATE.

For the TD_UNIT = 3 (unit of measure = "w" or week), I would expect
the TD_START_DATE to be a Sunday (the first day of the week) each
time, but its not. Its just as often a Tuesday or Thursday.

Would someone explain to me the meaning of
MSP_TIMEPHASED_DATA.TD_START_DATE?

My working query is below. Any help is appreciated.
Thanks
André Q

SELECT DISTINCT
    MSP_ASSIGNMENTS.TASK_UID,
    MSP_TASKS.TASK_NAME,
    MSP_TASKS.TASK_START_DATE,
    MSP_TASKS.TASK_FINISH_DATE,
    MSP_RESOURCES.RES_NAME,
    MSP_RESOURCES.RES_INITIALS,
    MSP_TIMEPHASED_DATA.TD_REF_UID,
    StrTypeCategory.STRING_TYPE,
    ConvCategory.CONV_STRING,
    StrTypeUnits.STRING_TYPE,
    ConvUnits.CONV_STRING,
    MSP_TIMEPHASED_DATA.TD_START,
    MSP_TIMEPHASED_DATA.TD_FINISH,
    Format([TD_VALUE1]/60000,"Standard") AS Week1,
    Format([TD_VALUE2]/60000,"Standard") AS Week2,
    Format([TD_VALUE3]/60000,"Standard") AS Week3,
    Format([TD_VALUE4]/60000,"Standard") AS Week4,
    Format([TD_VALUE5]/60000,"Standard") AS Week5,
    Format([TD_VALUE6]/60000,"Standard") AS Week6,
    Format([TD_VALUE7]/60000,"Standard") AS Week7,
    MSP_TIMEPHASED_DATA.TD_UNITS
FROM        MSP_TIMEPHASED_DATA
INNER JOIN  MSP_CONVERSIONS AS ConvCategory
    ON  MSP_TIMEPHASED_DATA.TD_CATEGORY = ConvCategory.CONV_VALUE
INNER JOIN  MSP_STRING_TYPES AS StrTypeCategory
    ON  ConvCategory.STRING_TYPE_ID = StrTypeCategory.STRING_TYPE_ID
INNER JOIN  MSP_CONVERSIONS AS ConvUnits
    ON  MSP_TIMEPHASED_DATA.TD_UNITS = ConvUnits.CONV_VALUE
INNER JOIN  MSP_STRING_TYPES AS StrTypeUnits
    ON  ConvUnits.STRING_TYPE_ID = StrTypeUnits.STRING_TYPE_ID
INNER JOIN  MSP_ASSIGNMENTS
    ON  MSP_TIMEPHASED_DATA.TD_REF_UID = MSP_ASSIGNMENTS.ASSN_UID
INNER JOIN  MSP_TASKS
    ON  MSP_ASSIGNMENTS.TASK_UID = MSP_TASKS.TASK_UID
INNER JOIN  MSP_RESOURCES
    ON  MSP_ASSIGNMENTS.ImportKeyID = MSP_RESOURCES.ImportKeyID
    AND MSP_ASSIGNMENTS.RES_UID = MSP_RESOURCES.RES_UID
WHERE   MSP_TIMEPHASED_DATA.TD_REF_UID = 60249
AND     ConvCategory.CONV_STRING = "Assignment"
AND     ConvUnits.CONV_STRING = "w"
AND     ConvCategory.STRING_TYPE_ID = 100
AND     ConvUnits.STRING_TYPE_ID = 108
ORDER BY MSP_TIMEPHASED_DATA.TD_REF_UID,
        MSP_TIMEPHASED_DATA.TD_START
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Example SQL query for extracting timephase data from Project datab 2

Top