select * from jccworks.dbo.tbl_positionregion

select * from jccworks.dbo.tbl_PositionCategory order by positioncategoryname

        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='164C2E05'
    

Location and Job Title:

TEST
JCC Association
520 8th Ave
4th Floor
New York, NY 10018

Principal Responsibilities:

TEST - This is not an active job posting.

Minimum Qualifications:

TEST - This is not an active job posting.

Salary:

Under $25,000

Agency Information:

JCC Association of North America leads and connects the JCC Movement, advancing and enriching North American Jewish life. With 1.5 million people walking through the doors of more than 170 Jewish Community Centers and Jewish Community Camps (JCCs) each week, the JCC Movement is the largest platform for Jewish engagement on the continent. JCC Association, the convening organization of this dynamic network, partners with JCCs to bring together the collective power and knowledge of the entire JCC Movement, including 12,000 full-time and 41,000 part-time and seasonal professionals. By supporting them, together we enhance and strengthen Jewish life throughout North America. Learn more at JCCA.org or on Facebook, Instagram, and Twitter.