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='D9EBAE53'
Front Desk Receptionist
Shorefront YM-YWHA of Brighton Manhattan Beach
3300 Coney Island Ave
Brooklyn, NY 11235
Please email your resume to info@shorefronty.org.
$25,000 - $35,000
The Shorefront YM-YWHA of Brighton-Manhattan Beach, Inc. (SFY) builds community, strengthens families, and empowers individuals to achieve their potentials and enhance their quality their lives. Our programs and services reflect the richness of the Shorefront YM-YWHA's Community Center and Settlement House traditions. We reach out to and serve people of all backgrounds and abilities throughout their life spans.
We provide a wide range of exemplary educational, recreational, preventive, and rehabilitative health, vocational, cultural, citizenship, Jewish identity-building and human service programs to meet the evolving strengths, needs and interests of the rich mosaic of people in southern Brooklyn.