Legal Consultant Jobs

   
<< Previous
 
Next >>
 

HR Business Partner
Location: Colorado
$100,000 to $200,000
Posted by:
Recruiter
Summary: $500m manufacturing division of much larger corporation. This position will drive the business, strong in employee relations, people development, succession planning and OD. Will oversee areas of manufacturing, marketing, sales, finance and
 
LIFE SCIENCE CLIENT PARTNER
Location: New York City
$200,000 to $400,000
Posted by:
Recruiter
Summary: LIFE SCIENCE CLIENT PARTNER Our client is a major Tier One management consulting firm seeking to identify and recruit Client Partners for one of its key Life Science (Pharma) accounts. Candidates MUST have ‘Big Four’ or large-scale management
 
Legal Consultant - home
 
<< Previous
 
Next >>
 







What is Custom Career Service?What is Custom Career Service?
Frequently Asked QuestionsFrequently Asked Questions
Users CommentsUsers' Comments
Executive Sign UpExecutive Sign-Up
Employer / Recruiter RegisterEmployer - Recruiters Registration
Executive JobsJobs Database
Executive ResumesResumes Database
People FinderScan for People
Executive Search FirmsSearch Firms that are Rites-Honored
Privacy PolicyPrivacy Policy
Contact RiteSiteContact RiteSite
RiteSite StoreRiteSite Store
Rites Of Passage Book Cover
Rites Of Passage Book Cover

Queries

GET_SITEMAP_GROUP (Records=1, Time=0ms)
SQL = 
SELECT SMGROUP_ID, SMGroup_Name, SMGroup_URL, SMGroup_Index_Page, SMGroup_html_page_title_tag, SMGroup_meta_description, SMGroup_meta_keywords, SMGroup_meta_Author, SMGroup_meta_robots, SMGroup_html_page_heading_H1, SMGroup_SQL_Query, SMGroup_SQL_JobID_Query, SMGroup_Preferred_Function FROM SITEMAP_Groups WHERE (SMGROUP_ID = 49)

 (Records=0, Time=0ms)
SQL = 
SelectNamesByIDs

 (Records=0, Time=0ms)
SQL = 
SelectNamesByIDs

 (Records=0, Time=0ms)
SQL = 
SelectNamesByIDs

 (Records=0, Time=0ms)
SQL = 
SelectNamesByIDs

 (Records=0, Time=0ms)
SQL = 
SelectNamesByIDs

 (Records=0, Time=0ms)
SQL = 
SelectNamesByIDs

rsSearchForJob (Records=2, Time=16ms)
SQL = 
SELECT DISTINCT j.JobID, j.UniqueKey, j.Title, LocConf, j.DatePosted, j.DateUpdated, j.summary, isnull(j.IsReferral, 0) as IsReferral, cmp.Compensation, ur.Description, c.CityID, c.CityName, s.State, s.StateName, r.RegionID, r.Region, dbo.SITEMAP_Temporary_Title_Group_InKeyOrder.KeyPriority, dbo.SITEMAP_Temporary_Title_Group_InKeyOrder.TitleExpanded, dbo.SITEMAP_Temporary_Title_Group_InKeyOrder.KeyUsed FROM tblJob j INNER JOIN lutCompensation cmp ON j.CompensationID = cmp.CompensationID INNER JOIN tblUser u ON j.UserID = u.UserID INNER JOIN tblUrights ur ON u.Urights = ur.UrightsID INNER JOIN jntJobIndPosCmp jipc ON j.JobID = jipc.JobID INNER JOIN jntIndustryPosition indPos ON jipc.IndustryPositionID = indpos.IndustryPositionID INNER JOIN jntCityStateRegion csr ON j.CityStateRegionID = csr.CityStateRegionID INNER JOIN lutRegion r ON csr.Region = r.RegionID INNER JOIN lutCity c ON csr.CityID = c.CityID INNER JOIN lutState s ON csr.State = s.State INNER JOIN dbo.SITEMAP_Temporary_Title_Group_InKeyOrder ON j.JobID = dbo.SITEMAP_Temporary_Title_Group_InKeyOrder.Jobid WHERE j.JobID IN ( SELECT DISTINCT JobID FROM SITEMAP_Temporary_Title_Group_InKeyOrder ) AND j.DateInactive IS NULL AND j.DateDeleted IS NULL AND j.DateExpired > GETDATE() AND j.iJobSource = 6 AND j.DatePosted IS NOT NULL AND ISNULL(j.Frozen, 0) = 0 ORDER BY dbo.SITEMAP_Temporary_Title_Group_InKeyOrder.KeyPriority, dbo.SITEMAP_Temporary_Title_Group_InKeyOrder.TitleExpanded, dbo.SITEMAP_Temporary_Title_Group_InKeyOrder.KeyUsed

GET_Page_INFO (Records=1, Time=15ms)
SQL = 
SELECT PageID, JobSearchID, JobID, PageFileName, PageType, DiskPath, URL_Index_Page, LastMOD, ChangeFreq_sitemap, PagePriority FROM SITEMAP_Pages WHERE JobID = 639983

GET_Page_INFO (Records=1, Time=16ms)
SQL = 
SELECT PageID, JobSearchID, JobID, PageFileName, PageType, DiskPath, URL_Index_Page, LastMOD, ChangeFreq_sitemap, PagePriority FROM SITEMAP_Pages WHERE JobID = 629046

Execution Time

63 milliseconds

Parameters
URL Parameters:

CITY=
CITYNAME=
COMPENSATION=
COMPENSATIONNAME=
CREATEFILE=1
FUNCTIONID=1234
GEOPREFERENCE=1
INDUSTRYID=0
PAGE=enter
REGION=
REGIONNAME=
REQUESTTIMEOUT=999999
SHOWHIDE=1
SITEMAPFUNCTIONNAME=Consulting
SMGROUP_ID=49
START=1
STATE=
STATENAME=

CGI Variables:

AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\inetpub\wwwroot\ritesite.com\JobDatabase\SiteMapping_specific_index.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
GATEWAY_INTERFACE=CGI/1.1
HTTP_HOST=www.ritesite.com
HTTP_REFERER=http://www.ritesite.com/
HTTP_USER_AGENT=ColdFusion
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
PATH_INFO=/JobDatabase/SiteMapping_specific_index.cfm
PATH_TRANSLATED=D:\inetpub\wwwroot\ritesite.com\JobDatabase\SiteMapping_specific_index.cfm
QUERY_STRING=page=enter&IndustryID=0&FunctionID=1234&geoPreference=1&city=&state=®ion=&cityName=&stateName=®ionName=&compensation=&compensationName=&start=1&createfile=1&showhide=1&SiteMapFunctionName=Consulting&SMGROUP_ID=49&RequestTimeout=999999
REMOTE_ADDR=192.168.1.49
REMOTE_HOST=192.168.1.49
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/JobDatabase/SiteMapping_specific_index.cfm
SERVER_NAME=www.ritesite.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.0
SERVER_SOFTWARE=Microsoft-IIS/6.0
WEB_SERVER_API=ISAPI