Super Contributor.. JHarris941 Super Contributor..
Super Contributor..
505 views

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 

0 Likes
3 Replies
Absent Member.. Freddy_Madrigal Absent Member..
Absent Member..

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

0 Likes
Super Contributor.. JHarris941 Super Contributor..
Super Contributor..

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?

0 Likes
Established Member.. Utkarsh_Mishra
Established Member..

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)
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.