jcribb
CASE WHEN {isinactive} = 'T' THEN 'Inactive' WHEN {releasedate} IS NOT NULL THEN 'Terminated' ELSE 'Active' END