View: dbo.STE_State_Misc_Parameter_Comprehensive_View
View definition
CREATE VIEW dbo.STE_State_Misc_Parameter_Comprehensive_View
(parameter_KEY, allowed_value_id, state_id, data_version, parameter_description, allowed_value_state_id, allowed_value_pattern, allowed_value_description, used_by_independent_contractor)
AS
SELECT
STESMP.parameter_KEY
, STESMP.allowed_value_id
, STESMPU.state_id
, STESMPU.data_version
, STESMP.parameter_description
, STEFSS.allowed_value_state_id
, STESMPAV.allowed_value_pattern
, STESMPAV.allowed_value_description
, STESMP.used_by_independent_contractor
FROM
dbo.STE_State_Misc_Parameter_Usage STESMPU
INNER JOIN
dbo.STE_State_Misc_Parameter STESMP
ON STESMPU.parameter_KEY = STESMP.parameter_KEY
INNER JOIN
dbo.STE_State_Misc_Parameter_Allowed_Value STESMPAV
ON
STESMP.allowed_value_id = STESMPAV.allowed_value_id
INNER JOIN
dbo.STE_Filing_Status_State STEFSS
ON
STESMPAV.allowed_value_user_id = STEFSS.allowed_value_user_id AND
STESMPU.data_version = STEFSS.data_version
WHERE
(allowed_value_state_id = N'LL' OR allowed_value_state_id = STESMPU.state_id)
;