Where Timesheet custom field in the Reporting DB?

[Smugliy]

Hi, I created Timesheet custom field and submit it

My question is where this custom field saved in the Reporting DB .
In the Published DB I found it in the Timesheet_Custom_field_values Tbl but
I can not find it in the Reporting DB

Please, help me to figure it out

Thanks
Smugliy

 

[Marc Soester [MVP]]

Hi Smugliy,

Can you tell me what you mean with Timsheet custom fields? Project Server
has Project, Task or Resource Custom fields but no timesheet customfields.

Thanks

 

[Paul Conroy]

The schema for the RDB is detailed in the SDK. Alternatively you can create
a data model from within Visio 2007 by directly attaching the the RDB.

 

[Smugliy]

Hi,Marc
I can explain

I created Enterprise Custom Field (with Type Task) ,after that I created New
Timesheet View and added this custom field to the view.After that I created
timesheet and sumbitted it ,when it already include my custom field.

Now I want to know where custom field data is saved in the Reporting DB .In
the Published DB it's saved in the dbo.MSP_TIMESHEET_CUSTOM_FIELD_VALUES

thanks,
smugliy

 

[Paul Conroy]

Someone maybe able to provide an authorative answer, but after having a look
I don't believe it is stored in relation to other timesheet info in the RDB.

You could extract the same info from the assignment tables/views.

 

[winzigm]

Hi Problem is that there is really week relationship between Project
plan & Timesheets.
There is no guarantee that this task exist- when this task haven't
protected work task can be removed from DB and relationship is broken :
(

MSP_Timesheet_Line -> MSP_TimeSheetTask -> MSP_EpmTask_UserView

 

[Smugliy]

Timesheet updates are not saved in the MSP_EpmTask_UserView table