View: dbo.Worker_Compensation_Class_Code_Detail_View
View definition
-- This exists to create the integer state_KEY so we can filter on the state.
-- Filters can't join on non-integer keys, so we can't use ste_state_code_KEY.
create view dbo.Worker_Compensation_Class_Code_Detail_View
as
select
worker_compensation_class_code_detail_KEY = WCCCD.worker_compensation_class_code_detail_KEY
, worker_compensation_class_code_KEY = WCCCD.worker_compensation_class_code_KEY
, ste_state_code_KEY = WCCCD.ste_state_code_KEY
, state_KEY = convert(int, convert(decimal, WCCCD.ste_state_code_KEY)) -- table doesn't allow null so don't worry about it here.
,is_active = WCCCD.is_active
,is_user_entered = WCCCD.is_user_entered
,code = WCCC.code
,description = WCCC.description
from
dbo.Worker_Compensation_Class_Code_Detail WCCCD
INNER JOIN
dbo.Worker_Compensation_Class_Code AS WCCC ON WCCC.worker_compensation_class_code_KEY = WCCCD.worker_compensation_class_code_KEY