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='1A74B338'
Teacher
Marlene Meyerson JCC Manhattan
334 Amsterdam Ave
New York, NY 10023
$20-24K
The Marlene Meyerson JCC Manhattan imagines Jewish life that is diverse and engages meaningfully with its values, culture, and ideas in everyday lives.
We're committed to redefining what Jewish life means today
We're dedicated to the well-being of everyone in our community.
We have a broad and inclusive view of Jewish life and family.
We feel a sense of responsibility for one another.
We take pride in our culture
We believe in accessibility.
We are deeply connected to Israel.
This position is part of Jewish Journeys, an innovative education program that offers a two-year Bar/Bat Mitzvah learning program for largely unaffiliated families.