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
Città*:
Provincia:
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
Indirizzo:
E-mail*:
Telefono*:
Area di interesse candidato*:
Candidatura per sede:
SELECT DISTINCT Name, BaseView.StatusCode, CASE BaseView.StatusCode WHEN 'I' THEN 1 ELSE 0 END AS StatusCodeRowOrder, BaseView.LocationID AS FieldID, Name AS FieldDescription, 'Active' AS StatusGroupDescShort FROM AnagLocation_VW AS BaseView WITH(NOLOCK) WHERE EnableHire=1 AND ('ACS'='' OR CompanyCode='ACS') AND BaseView.EffDate=(SELECT MAX(B0.EffDate) FROM AnagLocation_VW AS B0 WHERE B0.CompanyID=BaseView.CompanyID AND B0.LocationID=BaseView.LocationID AND EffDate<='20191215') AND (BaseView.StatusCode<>'I') AND SetID IN (0, 19) AND (ReadLanguage='IT') ORDER BY Name
Ricerca autocandidatura:
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 ('ACS'='' OR CompanyCode='ACS') AND (BaseView.StatusCode<>'I') AND SetID IN (0, 19) AND (ReadLanguage='IT') ORDER BY JobRequisitionID DESC
Come hai fatto a trovarci?*:
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) ORDER BY RowOrder, DESCShort