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 | |||