PWPROD SELECT to_char(last_mod_dttm,'mm/dd') as postdate, order_id orderid, order_web_job_title webjobtitle, order_web_city webcity, order_web_state, org_unit_id officeid, job_category_description as jobcategory, order_type_description as assignmenttype, industry_type_description description, SUBSTR(org_unit_attr_value_dept, 1, 5), order_web_base_min webbasemin, order_web_base_max webbasemax FROM SYSADM.fo_job_board_order WHERE job_board_url = 'http://www.pacioli.com' AND Lower(job_board_order_status) in ('posted', 'post pending', 'resubmit pending', 'resubmitted') AND Lower(order_status_description) in ('open', 'hold', 'recurring', 'recruiting', 'active') ORDER BY last_mod_dttm DESC, order_web_state, order_web_city
Professional Staffing Solutions in Accounting, Finance and Information Technology | Pacioli Companies
To View Job Details: Click its title.
To Apply: Check the box(es) next to the job(s) you want to apply to, and use the "Apply to Selected Jobs " button below, or use the "Apply Now" button at the bottom of a job's details page.
To Resort Job Search Results: Click the column title.
Begin a New Search: Click here