Select
case
when
salaryrange like '%Under%'
or salaryrange like '%over%'
then
replace(replace(salaryrange,'Under ','Under $'),'Over ','Over $')
when
len(isnull(salaryrange,''))>0
then
'$'+replace(salaryrange,'- ','- $')
end as salaryrange,
(
select top 1
PositionCategoryID
from
jccworks.dbo.tbl_PositionDesired
where
positionid=p.positionid
order by
case
when PositionCategoryID='3E73' then 1 else 0
end desc
) as PositionCategoryID,
convert(varchar,dateentered,101) as dateentered,
p.*,
replace(j.jccname,'Not-Yet-Affiliated','') as jccname,
ja.address,
ja.address2,
ja.city,
ja.state,
ja.zip,
m.firstname,
m.lastname,
m.email,
m.jccid
from
jccworks.dbo.tbl_positions p
left join
jcca.dbo.tbl_jcc j on
p.jccid=j.jccid
left join
jcca.dbo.tbl_jccaddress ja on
j.jccid=ja.jccid
left join
jcca.dbo.vw_jccmasterfile3 m on
p.masterid=m.masterid
where
p.positionid='611CFCA9'
Driver
Surprise Lake Camp
382 Lake Surprise Road
Cold Spring, NY 10516
The position runs roughly from early June through September 6 days per week. Pre-camp and post-camp work is also available.
Site Assistants live full time at camp, and camp provides full room and board. (Housing and 3 meals a day).
Responsibilities
Under $25,000
Since 1902, Surprise Lake Camp has provided a haven for children in the beautiful mountains of Cold Spring, NY. What makes SLC the best is the beauty of the site, the richness of the people and the program, the sense of history and tradition, and the magic we create when the whole thing comes together. ?We blend a commitment to traditional, rustic camp experiences with state of the art recreational facilities and are particularly proud of our open, inclusive community that is sensitive to the needs of interfaith and diverse families.