“This query is used to get the person number of employees who are eligible in a compensation workforce plan.”
This query selects the PERSON_NUMBER from the CMP_CWB_PERSON_INFO table for individuals included in a...
“This query is used to get the display name of the line manager assigned to an employee.”
This query selects the DISPLAY_NAME of a manager from PER_PERSON_NAMES_F who is assigned as...
This query is used to get the rounded rate amount of a salary pay component for an active employee assignment.”
This query selects the RATE_AMOUNT from CMP_SALARY_PAY_COMPONENTS and rounds the value to two decimal places using...
“This query is used to get the value of the fifty percent field from the market composites table in character format.”
This query selects the FIFTY_PERCENT column from the CMP_MKT_COMPOSITES table and converts the value...