Query: ibm_kms_key_state_details

select
  'State' as label,
  case
    when state = '0' then 'Pre-activation'
    when state = '1' then 'Enabled'
    when state = '2' then 'Disabled'
    when state = '3' then 'Deactivated'
    when state = '5' then 'Deleted'
    else state end as value,
  case when state in ('1','0') then 'ok' else 'alert' end as "type"
from
  ibm_kms_key
where
  state <> '5'
  and crn = $1;