Target Billing Rate field on Resource Properties Financial subpage

book

Article ID: 194795

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

There is a field called  "Target Billing Rate" on the Resource Properties -> Financial subpage -> "Rates and Costs" section in Classic UI, 

Where is that in the database?  

Is it in the data warehouse?

 

Environment

Release : All

 

Resolution

The field is contained in table PAC_MNT_RESOURCES

It is called targetbillrate

For use in query it would be PAC_MNT_RESOURCES.targetbillrate

If you want to join this back to the resource (SRM_RESROUCES) table then:

 

PAC_MNT_RESOURCES.id = SRM_RESOURCES.id

 

Note: This field is not currently included in the Data Warehouse.