Where Timesheet custom field in the Reporting DB?

[Smugliy]

Hi ,
I created timesheet with enterprise custom fields and submit it .
Now I want to know where it's saved in the Reporting DB?
I know where it saved in the Published
DB(dbo.MSP_TIMESHEET_CUSTOM_FIELD_VALUES) but there is nothing in the
Reporting Database .I have looked everywhere ,I didn't find it ,no in the
Tables ,not in the views
Please help me to figure it out

Thanks,Smugliy

 

[Jonathan Sofer]

You already figured it out. It does not exist in the Reporting Database.

You will need to run a cross database query to pull that data.

Jonathan

 

[Smugliy]

Sorry,I put my question in two sections ,my mistake

Smugliy

I put my question

 

[JBG]

See my reply to Jonathan about this information.

Sorry,I put my question in two sections ,my mistake

Smugliy

I put my question

 

[JBG]

Hi Jonathan

Not quite true. Tgere is tables, obviosuly not the most common names, with
the names msp_epm_cppjr01, msp_epm_cppprjstr, etc. for assignmenst, projects,
tasks.

The msp_epm_cppjr01 table contains the field project_uid and also some
generic field. Each of these fields is linked to the various custom field
information. There is another table (cannot remember the name) that contains
the mapping of the generic fields with the custom fields.

By using this table and the appropriate field you are then able to extract
the custom field information.

If you need more information, I have some sql queries qwhich I use in my
reporting database.