How to get UI Expression value for Dynamic Column in Compensation plan

4:59AM

Summary:

Step1
I executed the below SQL query:

SELECT EXPR_COND
FROM CMP_CALC_EXPRESSIONS exp
WHERE EXPRESSION_ID = 8016

Step2:
SQL Qutput
[CustomSegment3] = "Nonexempt"

Step3:

Backend Expression >> [CustomSegment3] = "Nonexempt"UI Expression >> [FLSA Status] = "Nonexempt"

Could you please guide me on how to retrieve the evaluated/display value (e.g., “FLSA Status”) as shown in the application
, instead of the backend column name (e.g., “CustomSegment3”) from the database?

My Client Groups>Compensation>Workforce Compensation>Search for Plan

Worksheet Display>Detail Table

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

How to get UI Expression value for Dynamic Column in Compensation plan

Howdy, Stranger!