DBO.EQ_STD_COMP_DATA_REPOSITORY_AMOUNT_GET(Parameter1, Parameter2, Parameter3, Parameter4)
This function will retrieve any value from the Compensation Data Repository (CDR). It can be used in any user report, regardless of the tables included in the report type. This is especially useful when building data sources for merge documents.
It is important to wrap this function in a CASE statement to handle the scenario where a CDR entry does not exist.
The function will search for a CDR value based on the variables provided. If it cannot find a value the function will return the amount 123456789. The amount from the CDR can be returned in any currency if an exchange rate is available. If an exchange rate is not available the function will return a 0.
Note: '123456789' is to used to denote a NULL CDR entry.
Parameter(s)
Parameter1: [Assignment: ID]
Parameter2: Date - e.g. [Cost Estimate: Effective Date], [All Cost Estimate Types (view): Effective Date]
Parameter3: CDR Line Item Name, e.g. 'Car Allowance', ' Actual Rent'
Parameter4: Three letter currency code you would like the function to return the value in e.g. 'USD', [All Cost Estimate Types (view): Base Currency] or [UT: Currency]
Example(s)
Example 1: Retrieve values from the Compensation Data Repository (CDR) to be used in the CE or CC calculations.
CASE
WHEN DBO.EQ_STD_COMP_DATA_REPOSITORY_AMOUNT_GET([Assignment: ID], [Cost Estimate: Effective Date], 'Car Allowance', 'USD') <> 123456789
THEN DBO.EQ_STD_COMP_DATA_REPOSITORY_AMOUNT_GET([Assignment: ID], [Cost Estimate: Effective Date], 'Car Allowance', 'USD')
ELSE 0
END