v_outsourcing (view)

Data license: 비공개

6,571 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Next page

CREATE VIEW v_outsourcing AS
SELECT
    contract_id, gov_code, gov_name, fiscal_year,
    dept_norm, dept_category,
    contract_name, contract_category, method, is_negotiated,
    vendor, vendor_bizno, contract_amount,
    CASE
        WHEN contract_name LIKE "%청소%"     THEN "청소"
        WHEN contract_name LIKE "%경비%"     THEN "경비·보안"
        WHEN contract_name LIKE "%돌봄%" OR contract_name LIKE "%보육%" THEN "돌봄·보육"
        WHEN contract_name LIKE "%급식%"     THEN "급식"
        WHEN contract_name LIKE "%위탁%"     THEN "위탁(기타)"
        WHEN contract_name LIKE "%운영대행%"  THEN "운영대행"
        WHEN contract_name LIKE "%시설관리%"  THEN "시설관리"
        ELSE "기타용역"
    END AS outsourcing_type,
    source_table, source_file
FROM v_chain
WHERE contract_category IN ("기술용역","일반용역")
  AND (
    contract_name LIKE "%청소%" OR contract_name LIKE "%경비%" OR
    contract_name LIKE "%돌봄%" OR contract_name LIKE "%보육%" OR
    contract_name LIKE "%급식%" OR contract_name LIKE "%위탁%" OR
    contract_name LIKE "%운영대행%" OR contract_name LIKE "%시설관리%"
  );