query | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
RESULTSET |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
CACHED | false | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
EXECUTIONTIME | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
SQL | SELECT A.ID, A.MetroAreaID, A.Title, A.Duties, A.Requirements, A.ExternalLink, A.ShortDescription, A.DateAdded, A.DateEnding, A.DutiesIntro, B.ID AS LocationID, B.Name AS LocationName, C.Name AS MetroAreaName, C.ID AS MetroAreaID, C.Zip, C.City, C.State, A.JobsTypeID, JobsType.Name AS JobsTypeName, c.address, c.zip FROM Jobs AS A INNER JOIN JobsType ON A.JobsTypeID = JobsType.ID LEFT OUTER JOIN MetroArea AS C ON A.MetroAreaID = C.ID LEFT OUTER JOIN Locations AS B ON C.LocationID = B.ID Where a.id = ? | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
SQLPARAMETERS |
|
Are you an administrative professional looking to advance your career with a company that appreciates you, encourages your growth, and empowers their employees to succeed? We’d love to have you be part of the JWilliams Staffing team! JWilliams Staffing is the Real Estate Industry’s leading recruitment agency and provider of property management, leasing, and maintenance talent to the Apartment Industry and New Home Sales Agents to the Builder Industry. Our team is a dedicated group of people who are putting the real estate industry to work – finding and matching the best professionals with the best opportunity, one job at a time.
Our corporate office in Irvine, CA is a close-knit group of professionals who love what they do. We enjoy working in a diverse, inviting, and supportive environment where our team member’s opinions matter and there is room to grow. Our core values are at the center of everything we do: professionalism, integrity, performance-driven, gaining and sharing knowledge, and community giving. JWilliams has won multiple awards for Best Places to Work, and we continue to put a focus on a positive company culture.
Purpose of the Recruitment Assistant
The Recruitment Assistant will be trained and provided with the tools and software needed to assist the Recruitment Department from our corporate office in Irvine, CA to screen, interview, hire and orient temporary employees for the Multi-Family and New Homes division for specified area(s) in various states.
Salary: $20.00 per hour
-------------------------------------------------------
JWilliams Staffing, Inc. An Equal Opportunity Employer M/F/Disability/Veterans.
Qualified applicants with criminal histories will be considered for employment in a manner consistent with Federal, state and local laws, including but not limited to local Fair Chance Ordinances.