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='222937CC'
Full Time Preschool Teacher
Gordon JCC
801 Percy Warner Blvd
Nashville, TN 37205
Expected hours: 40.0 per week
? Vision insurance
$35,000 - $45,000
The Gordon Jewish Community Center (Gordon JCC) is at the center of Jewish life in Nashville, providing recreational, educational, social and cultural programs and services to over 1,700 member families. Located on a beautiful 52-acre campus in west Nashville, it is a place where non-Jews are welcome to join, play and learn side by side with their Jewish neighbors. Camp Davis, established in 1930s, provides a day camp experience for hundreds of school-age children each summer.