This query selects data from the CMP_EXTERNAL_WORKER_DATA table. It concatenates the VALUE1 column with the CURRENCY_CD column using a hyphen (-) as a separator. The result returns a single string in the format VALUE1-CURRENCY_CD, which typically represents an amount along with its currency code.
SQL Query Section
SELECT
value1||'-'||CURRENCY_CD
FROM
CMP_EXTERNAL_WORKER_DATA
--WHERE
--record_type_cd = 'THINKAPACE_ITI_BONUS_DATA'
--and person_id = :{PARAMETER.PERSON_ID}
--and value5 = :{PARAMETER.YEAR} Output Results
Related Posts
