This query selects the FIFTY_PERCENT column from the CMP_MKT_COMPOSITES table and converts the value to a character format using the TO_CHAR function. The CMP_MKT_COMPOSITES table typically stores market composite compensation data, and the FIFTY_PERCENT column represents the 50th percentile (median) value within the market compensation range. The query returns this value as a formatted character string.
SQL Query Section
SELECT
to_char(FIFTY_PERCENT)
FROM
CMP_MKT_COMPOSITES
--WHERE
--JOB_ID = :{PARAMETER.JOB_ID}
--and COUNTRY_CODE = :{PARAMETER.COUNTRY_CODE} Output Results
