SELECT DISTINCT Name, BaseView.StatusCode, CASE BaseView.StatusCode WHEN 'I' THEN 1 ELSE 0 END AS StatusCodeRowOrder, BaseView.CountryID AS FieldID, Name AS FieldDescription, 'Active' AS StatusGroupDescShort FROM AnagCountry_VW AS BaseView WITH(NOLOCK) WHERE (BaseView.StatusCode<>'I') AND SetID IN (0, 19) AND (ReadLanguage='IT') ORDER BY Name

SELECT DISTINCT Name, BaseView.StatusCode, CASE BaseView.StatusCode WHEN 'I' THEN 1 ELSE 0 END AS StatusCodeRowOrder, BaseView.StateID AS FieldID, Name AS FieldDescription, 'Active' AS StatusGroupDescShort FROM AnagState_VW AS BaseView WITH(NOLOCK) WHERE (BaseView.StatusCode<>'I') AND SetID IN (0, 19) AND (ReadLanguage='IT') ORDER BY Name

SELECT DISTINCT RowOrder, DefaultCompany, CompanyCode, BaseView.DescShort, BaseView.StatusCode, CASE BaseView.StatusCode WHEN 'I' THEN 1 ELSE 0 END AS StatusCodeRowOrder, BaseView.CompanyID AS FieldID, DescShort AS FieldDescription, 'Active' AS StatusGroupDescShort FROM AnagCompany_VW AS BaseView WITH(NOLOCK) WHERE BaseView.EffDate=(SELECT MAX(B0.EffDate) FROM AnagCompany_VW AS B0 WITH (NOLOCK) WHERE B0.CompanyID=BaseView.CompanyID AND EffDate<='20211022') AND (BaseView.StatusCode<>'I') AND SetID IN (0, 19) AND (ReadLanguage='IT') ORDER BY RowOrder, DefaultCompany DESC, CompanyCode, DESCShort

SELECT DISTINCT Name, BaseView.StatusCode, CASE BaseView.StatusCode WHEN 'I' THEN 1 ELSE 0 END AS StatusCodeRowOrder, BaseView.ApplyLocationID AS FieldID, Name AS FieldDescription, 'Active' AS StatusGroupDescShort FROM AnagLocation_VW AS BaseView WITH(NOLOCK) WHERE EnableHire=1 AND (''='' OR CompanyCode='') AND (ApplyCompanyID='0') AND BaseView.EffDate=(SELECT MAX(B0.EffDate) FROM AnagLocation_VW AS B0 WITH (NOLOCK) WHERE B0.CompanyID=BaseView.CompanyID AND B0.LocationID=BaseView.LocationID AND B0.ApplyCompanyID=BaseView.ApplyCompanyID AND EffDate<='20211022') AND (BaseView.StatusCode<>'I') AND SetID IN (0, 19) AND (ReadLanguage='IT') ORDER BY Name

SELECT DISTINCT BaseView.StatusCode, CASE BaseView.StatusCode WHEN 'I' THEN 1 ELSE 0 END AS StatusCodeRowOrder, BaseView.JobRequisitionID AS FieldID, JobRequisitionDescComplete AS FieldDescription, 'Active' AS StatusGroupDescShort FROM AnagJobRequisition_VW AS BaseView WITH(NOLOCK) WHERE ExpectedExternalSelfApplication=1 AND (''='' OR CompanyCode='') AND (BaseView.StatusCode<>'I') AND SetID IN (0, 19) AND (ReadLanguage='IT') ORDER BY JobRequisitionID DESC

SELECT DISTINCT RowOrder, BaseView.DescShort, BaseView.StatusCode, CASE BaseView.StatusCode WHEN 'I' THEN 1 ELSE 0 END AS StatusCodeRowOrder, BaseView.CVSourceID AS FieldID, DescShort AS FieldDescription, 'Active' AS StatusGroupDescShort FROM AN_CVSource_VW AS BaseView WITH(NOLOCK) WHERE (BaseView.StatusCode<>'I') AND SetID IN (0, 19) AND (ReadLanguage='IT') ORDER BY RowOrder, DESCShort