Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Default Time Approver Field Location in the Database

Highlighted
JHarris941
Regular Collector

Default Time Approver Field Location in the Database

Hello all,

 

Does anyone know what table(s)  stores "Default Time Approver" info? Specifically "Resource or Resource Group" field next to the Time approver.

 

I found the Time approver, but not the field on the left. I included a screenshot.

 

Thanks,

Jajcen 

3 REPLIES
Freddy_Madrigal
Acclaimed Contributor

Re: Default Time Approver Field Location in the Database

Hi,

 

It's in RPT_DIM_RM_RESOURCES in TM_APPROVER. Please refer to the attached data model guide in page 1158

JHarris941
Regular Collector

Re: Default Time Approver Field Location in the Database

We dont have that materialized view in our schema. Do you know what Table its located on?

Utkarsh_Mishra
Honored Contributor

Re: Default Time Approver Field Location in the Database

SELECT  tm_approver_id /*timesheet approver ID*/
        ,tm_billing_approver_id /*timesheet billing approver ID*/
        ,time_sheet_approver_sec_grp_id /*timesheet approver group ID*/
        ,billing_approver_sec_grp_id  /*timesheet billing approver group ID*/
FROM RSC_RESOURCES 

  If approver_id is NULL then it mean its using approver_sec_grp_id and vice versa (applicable for billing and time approver)

 

So Approver ID ~ Resource

and Sec Grp ID ~ Resoruce Group

 

This way u can identify the left field in ur screenshot.

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
//Add this to "OnDomLoad" event