SQL Code to Extract Setup Grade Rates with Grade Name
Summary
SQL Code to Extract Setup Grade Rates with Grade NameContent
Team,
I have a similar requirement.
I am trying to fetch the setup data of Grade Rates with Grade name.
Navigation:
My Client Group>Work Structure> Manage Grade Rates
I was working on the below query. However, I could not join the Grade Name in this query.
Select PRFV.RATE_ID
, PRFV.EFFECTIVE_START_DATE
, PRFV.EFFECTIVE_END_DATE
, PRFV.LEGISLATION_CODE
, PRFV.RATE_TYPE
, PRFV.RATE_OBJECT_TYPE
, PRFV.RATE_UOM
, PRFV.RATE_FREQUENCY
, PRFV.ANNUALIZATION_FACTOR
, PRFV.CURRENCY_CODE
, PRFV.ACTIVE_STATUS
, PRVF.RATE_OBJECT_ID