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