Remedy Oracle Backend Case Statements

Cases.sql

case status
	when 0 then 'New'
	when 1 then 'Assigned'
	when 2 then 'In Progress'
	when 3 then 'Pending'
	when 4 then 'Resolved'
	when 5 then 'Closed'
	when 6 then 'Cancelled'
	else to_char(status)
end status

case reported_source
	when  1000 then 'Direct Input'
	when  2000 then 'Email'
	when  3000 then 'External Escalation'
	when  4000 then 'Fax'
	when  5000 then 'Systems Management'
	when  6000 then 'Phone'
	when  7000 then 'Voice Mail'
	when  8000 then 'Walk In'
	when  9000 then 'Web'
	when 10000 then 'Other'
	else to_char(reported_source)
end reported_source

case priority
	when 0 then 'Critical'
	when 1 then 'High'
	when 2 then 'Medium'
	when 3 then 'Low'
	else to_char(priority)
end priority

case urgency
	when 1000 then '1 - Critical'
	when 2000 then '2 - High'
	when 3000 then '3 - Medium'
	when 4000 then '4 - Low'
	else to_char(urgency)
end urgency

case impact
	when 1000 then '1 - Extensive/Widespread'
	when 2000 then '2 - Significant/Large'
	when 3000 then '3 - Moderate/Limited'
	when 4000 then '4 - Minor/Localized'
	else to_char(impact)
end impact

case slm_status
	when 0 then 'No Service Target Assigned'
	when 1 then 'Within the Service Target'
	when 2 then 'Service Target Breached'
	when 3 then 'All Service Targets Breached'
	else to_char(slm_status)
end slm_status

case service_type
	when 0 then 'User Service Restoration'
	when 1 then 'User Service Request'
	when 2 then 'Infrastructure Restoration'
	when 3 then 'Infrastructure Event'
	else to_char(service_type)
end service_type