<?php

use Phalcon\Mvc\Model\Migration;

class UpdateSPIExt402Migration_499 extends Migration{
    public function up()
    {
        self::$connection->execute("
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 83.3333333333333 WHERE tahun = '2023' AND id_instansi = 620 AND id_provinsi = 75 AND opd ILIKE 'BADAN PENGELOLAAN KEUANGAN DAN ASET DAERAH' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 100 WHERE tahun = '2023' AND id_instansi = 620 AND id_provinsi = 75 AND opd ILIKE 'DINAS KESEHATAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 86.231884057971 WHERE tahun = '2023' AND id_instansi = 620 AND id_provinsi = 75 AND opd ILIKE 'DINAS PENANAMAN MODAL DAN PELAYANAN SATU PINTU' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 88.8888888888889 WHERE tahun = '2023' AND id_instansi = 620 AND id_provinsi = 75 AND opd ILIKE 'DINAS TENAGA KERJA DAN TRANSMIGRASI' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 82.1428571428572 WHERE tahun = '2023' AND id_instansi = 620 AND id_provinsi = 75 AND opd ILIKE 'UNIT PELAKSANA TEKNIS' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 84.1269841269841 WHERE tahun = '2023' AND id_instansi = 161 AND id_provinsi = 75 AND opd ILIKE 'BADAN PENGELOLAAN KEUANGAN DAN ASET DAERAH' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 84.0909090909091 WHERE tahun = '2023' AND id_instansi = 161 AND id_provinsi = 75 AND opd ILIKE 'DINAS KELAUTAN DAN PERIKANAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 82.4159021406728 WHERE tahun = '2023' AND id_instansi = 161 AND id_provinsi = 75 AND opd ILIKE 'DINAS KEPENDUDUKAN DAN PENCATATAN SIPIL' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 75 WHERE tahun = '2023' AND id_instansi = 161 AND id_provinsi = 75 AND opd ILIKE 'DINAS KESEHATAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 86.6666666666667 WHERE tahun = '2023' AND id_instansi = 161 AND id_provinsi = 75 AND opd ILIKE 'DINAS PENANAMAN MODAL DAN PELAYANAN SATU PINTU' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 83.3333333333333 WHERE tahun = '2023' AND id_instansi = 161 AND id_provinsi = 75 AND opd ILIKE 'DINAS PERINDUSTRIAN DAN PERDAGANGAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 66.6666666666667 WHERE tahun = '2023' AND id_instansi = 161 AND id_provinsi = 75 AND opd ILIKE 'DINAS PERTANIAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 87.5 WHERE tahun = '2023' AND id_instansi = 161 AND id_provinsi = 75 AND opd ILIKE 'DINAS PERUMAHAN DAN PERMUKIMAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 85.0877192982456 WHERE tahun = '2023' AND id_instansi = 161 AND id_provinsi = 75 AND opd ILIKE 'DINAS SOSIAL' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 85.7142857142857 WHERE tahun = '2023' AND id_instansi = 161 AND id_provinsi = 75 AND opd ILIKE 'DINAS TENAGA KERJA DAN TRANSMIGRASI' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 83.3333333333333 WHERE tahun = '2023' AND id_instansi = 161 AND id_provinsi = 75 AND opd ILIKE 'KECAMATAN/DESA' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 83.3333333333333 WHERE tahun = '2023' AND id_instansi = 161 AND id_provinsi = 75 AND opd ILIKE 'SATUAN POLISI PAMONG PRAJA' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 90.1960784313726 WHERE tahun = '2023' AND id_instansi = 206 AND id_provinsi = 75 AND opd ILIKE 'BADAN PENDAPATAN DAERAH' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 95.2380952380952 WHERE tahun = '2023' AND id_instansi = 206 AND id_provinsi = 75 AND opd ILIKE 'DINAS KELAUTAN DAN PERIKANAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 92.8571428571428 WHERE tahun = '2023' AND id_instansi = 206 AND id_provinsi = 75 AND opd ILIKE 'DINAS KESEHATAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 88.8888888888889 WHERE tahun = '2023' AND id_instansi = 206 AND id_provinsi = 75 AND opd ILIKE 'DINAS LINGKUNGAN HIDUP' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 95.8333333333333 WHERE tahun = '2023' AND id_instansi = 206 AND id_provinsi = 75 AND opd ILIKE 'DINAS PENANAMAN MODAL DAN PELAYANAN SATU PINTU' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 88.8888888888889 WHERE tahun = '2023' AND id_instansi = 206 AND id_provinsi = 75 AND opd ILIKE 'DINAS PERTANIAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 83.3333333333333 WHERE tahun = '2023' AND id_instansi = 206 AND id_provinsi = 75 AND opd ILIKE 'DINAS TENAGA KERJA DAN TRANSMIGRASI' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 87.037037037037 WHERE tahun = '2023' AND id_instansi = 206 AND id_provinsi = 75 AND opd ILIKE 'KECAMATAN/DESA' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 83.3333333333333 WHERE tahun = '2023' AND id_instansi = 407 AND id_provinsi = 75 AND opd ILIKE 'DINAS KESEHATAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 83.3333333333333 WHERE tahun = '2023' AND id_instansi = 407 AND id_provinsi = 75 AND opd ILIKE 'DINAS TENAGA KERJA DAN TRANSMIGRASI' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 83.3333333333333 WHERE tahun = '2023' AND id_instansi = 407 AND id_provinsi = 75 AND opd ILIKE 'KECAMATAN/DESA' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 100 WHERE tahun = '2023' AND id_instansi = 171 AND id_provinsi = 75 AND opd ILIKE 'BADAN PENANGGULANGAN BENCANA DAERAH' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 87.0689655172414 WHERE tahun = '2023' AND id_instansi = 171 AND id_provinsi = 75 AND opd ILIKE 'BADAN PENGELOLAAN KEUANGAN DAN ASET DAERAH' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 83.3333333333333 WHERE tahun = '2023' AND id_instansi = 171 AND id_provinsi = 75 AND opd ILIKE 'BADAN PERENCANAAN PEMBANGUNAN DAERAH' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 86.7521367521367 WHERE tahun = '2023' AND id_instansi = 171 AND id_provinsi = 75 AND opd ILIKE 'BIRO PENGADAAN BARANG DAN JASA SEKRETARIAT DAERAH' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 90 WHERE tahun = '2023' AND id_instansi = 171 AND id_provinsi = 75 AND opd ILIKE 'DINAS KELAUTAN DAN PERIKANAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 86.3636363636364 WHERE tahun = '2023' AND id_instansi = 171 AND id_provinsi = 75 AND opd ILIKE 'DINAS KEPENDUDUKAN DAN PENCATATAN SIPIL' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 86.6666666666667 WHERE tahun = '2023' AND id_instansi = 171 AND id_provinsi = 75 AND opd ILIKE 'DINAS KESEHATAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 81.9444444444445 WHERE tahun = '2023' AND id_instansi = 171 AND id_provinsi = 75 AND opd ILIKE 'DINAS PEMUDA DAN OLAHRAGA' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 89.6825396825397 WHERE tahun = '2023' AND id_instansi = 171 AND id_provinsi = 75 AND opd ILIKE 'DINAS PENANAMAN MODAL DAN PELAYANAN SATU PINTU' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 85.7142857142857 WHERE tahun = '2023' AND id_instansi = 171 AND id_provinsi = 75 AND opd ILIKE 'DINAS PERHUBUNGAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 87.1794871794872 WHERE tahun = '2023' AND id_instansi = 171 AND id_provinsi = 75 AND opd ILIKE 'DINAS SOSIAL' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 86.3636363636364 WHERE tahun = '2023' AND id_instansi = 171 AND id_provinsi = 75 AND opd ILIKE 'DINAS TANAMAN PANGAN DAN HORTIKULTURA' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 88.5416666666667 WHERE tahun = '2023' AND id_instansi = 171 AND id_provinsi = 75 AND opd ILIKE 'DINAS TENAGA KERJA DAN TRANSMIGRASI' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 83.3333333333333 WHERE tahun = '2023' AND id_instansi = 171 AND id_provinsi = 75 AND opd ILIKE 'KECAMATAN/DESA' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 100 WHERE tahun = '2023' AND id_instansi = 207 AND id_provinsi = 75 AND opd ILIKE 'BADAN PENGELOLAAN KEUANGAN DAN ASET DAERAH' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 100 WHERE tahun = '2023' AND id_instansi = 207 AND id_provinsi = 75 AND opd ILIKE 'BADAN PERENCANAAN PEMBANGUNAN DAERAH' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 85.7723577235772 WHERE tahun = '2023' AND id_instansi = 207 AND id_provinsi = 75 AND opd ILIKE 'DINAS KELAUTAN DAN PERIKANAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 83.0952380952381 WHERE tahun = '2023' AND id_instansi = 207 AND id_provinsi = 75 AND opd ILIKE 'DINAS KEPENDUDUKAN DAN PENCATATAN SIPIL' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 84.5238095238095 WHERE tahun = '2023' AND id_instansi = 207 AND id_provinsi = 75 AND opd ILIKE 'DINAS KESEHATAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 83.3333333333333 WHERE tahun = '2023' AND id_instansi = 207 AND id_provinsi = 75 AND opd ILIKE 'DINAS LINGKUNGAN HIDUP' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 88.8888888888889 WHERE tahun = '2023' AND id_instansi = 207 AND id_provinsi = 75 AND opd ILIKE 'DINAS PENANAMAN MODAL DAN PELAYANAN SATU PINTU' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 86.7924528301887 WHERE tahun = '2023' AND id_instansi = 207 AND id_provinsi = 75 AND opd ILIKE 'DINAS PERHUBUNGAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 85.9649122807018 WHERE tahun = '2023' AND id_instansi = 207 AND id_provinsi = 75 AND opd ILIKE 'DINAS SOSIAL' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 84.375 WHERE tahun = '2023' AND id_instansi = 207 AND id_provinsi = 75 AND opd ILIKE 'DINAS TENAGA KERJA DAN TRANSMIGRASI' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 83.3333333333333 WHERE tahun = '2023' AND id_instansi = 543 AND id_provinsi = 75 AND opd ILIKE 'BIRO PENGADAAN BARANG DAN JASA SEKRETARIAT DAERAH' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 78.5714285714286 WHERE tahun = '2023' AND id_instansi = 543 AND id_provinsi = 75 AND opd ILIKE 'DINAS KELAUTAN DAN PERIKANAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 82.1428571428572 WHERE tahun = '2023' AND id_instansi = 543 AND id_provinsi = 75 AND opd ILIKE 'DINAS KESEHATAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 83.3333333333333 WHERE tahun = '2023' AND id_instansi = 543 AND id_provinsi = 75 AND opd ILIKE 'DINAS KOMUNIKASI DAN INFORMATIKA' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 85.4700854700855 WHERE tahun = '2023' AND id_instansi = 543 AND id_provinsi = 75 AND opd ILIKE 'DINAS PENANAMAN MODAL DAN PELAYANAN SATU PINTU' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 33.3333333333333 WHERE tahun = '2023' AND id_instansi = 543 AND id_provinsi = 75 AND opd ILIKE 'DINAS TENAGA KERJA DAN TRANSMIGRASI' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 83.3333333333333 WHERE tahun = '2023' AND id_instansi = 543 AND id_provinsi = 75 AND opd ILIKE 'KECAMATAN/DESA' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 100 WHERE tahun = '2023' AND id_instansi = 620 AND id_provinsi = 75 AND opd ILIKE 'BIRO ADMINISTRASI PIMPINAN SEKRETARIAT DAERAH' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 83.3333333333333 WHERE tahun = '2023' AND id_instansi = 620 AND id_provinsi = 75 AND opd ILIKE 'PEMBAYARAN PAJAK MOBIL' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 83.3333333333333 WHERE tahun = '2023' AND id_instansi = 620 AND id_provinsi = 75 AND opd ILIKE 'PEMBAYARAN PAJAK MOTOR' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 83.3333333333333 WHERE tahun = '2023' AND id_instansi = 620 AND id_provinsi = 75 AND opd ILIKE 'PEMBAYARAN STNK/PLAT NOMOR' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 81.5789473684211 WHERE tahun = '2023' AND id_instansi = 620 AND id_provinsi = 75 AND opd ILIKE 'PROVINSI GORONTALO' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 83.0882352941177 WHERE tahun = '2023' AND id_instansi = 620 AND id_provinsi = 75 AND opd ILIKE 'SAMSAT' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 83.3333333333333 WHERE tahun = '2023' AND id_instansi = 620 AND id_provinsi = 75 AND opd ILIKE 'SAMSAT KOTA' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 83.3333333333333 WHERE tahun = '2023' AND id_instansi = 620 AND id_provinsi = 75 AND opd ILIKE 'SAMSAT KOTA GORONTALO' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 83.3333333333333 WHERE tahun = '2023' AND id_instansi = 161 AND id_provinsi = 75 AND opd ILIKE 'BIRO PENGADAAN BARANG DAN JASA SEKRETARIAT DAERAH' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 83.3333333333333 WHERE tahun = '2023' AND id_instansi = 161 AND id_provinsi = 75 AND opd ILIKE 'BOTUMOITO' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 83.3333333333333 WHERE tahun = '2023' AND id_instansi = 161 AND id_provinsi = 75 AND opd ILIKE 'DINAS PERHUBUNGAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 83.3333333333333 WHERE tahun = '2023' AND id_instansi = 161 AND id_provinsi = 75 AND opd ILIKE 'KABUPATEN BOALEMO' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 83.3333333333333 WHERE tahun = '2023' AND id_instansi = 161 AND id_provinsi = 75 AND opd ILIKE 'KWITANSI GAJI' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 83.3333333333333 WHERE tahun = '2023' AND id_instansi = 161 AND id_provinsi = 75 AND opd ILIKE 'PENDAMPINGAN VERIVIKASI' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 83.3333333333333 WHERE tahun = '2023' AND id_instansi = 161 AND id_provinsi = 75 AND opd ILIKE 'REKOMENDASI' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 87.8787878787879 WHERE tahun = '2023' AND id_instansi = 206 AND id_provinsi = 75 AND opd ILIKE 'BIRO PENGADAAN BARANG DAN JASA SEKRETARIAT DAERAH' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 88.9294403892944 WHERE tahun = '2023' AND id_instansi = 206 AND id_provinsi = 75 AND opd ILIKE 'DINAS KEPENDUDUKAN DAN PENCATATAN SIPIL' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 89.5833333333333 WHERE tahun = '2023' AND id_instansi = 206 AND id_provinsi = 75 AND opd ILIKE 'DINAS PERHUBUNGAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 86.9047619047619 WHERE tahun = '2023' AND id_instansi = 206 AND id_provinsi = 75 AND opd ILIKE 'DINAS SOSIAL' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 74.0740740740741 WHERE tahun = '2023' AND id_instansi = 206 AND id_provinsi = 75 AND opd ILIKE 'KABUPATEN GORONTALO' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 100 WHERE tahun = '2023' AND id_instansi = 206 AND id_provinsi = 75 AND opd ILIKE 'SAMSAT KABUPATEN GORONTALO' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 83.3333333333333 WHERE tahun = '2023' AND id_instansi = 407 AND id_provinsi = 75 AND opd ILIKE 'BADAN KEPEGAWAIAN DAERAH' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 75 WHERE tahun = '2023' AND id_instansi = 407 AND id_provinsi = 75 AND opd ILIKE 'BIRO PENGADAAN BARANG DAN JASA SEKRETARIAT DAERAH' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 83.3333333333333 WHERE tahun = '2023' AND id_instansi = 407 AND id_provinsi = 75 AND opd ILIKE 'DINAS BINA MARGA DAN PENATAAN RUANG' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 84.2424242424242 WHERE tahun = '2023' AND id_instansi = 407 AND id_provinsi = 75 AND opd ILIKE 'DINAS KEPENDUDUKAN DAN PENCATATAN SIPIL' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 80.7971014492754 WHERE tahun = '2023' AND id_instansi = 407 AND id_provinsi = 75 AND opd ILIKE 'DINAS PENANAMAN MODAL DAN PELAYANAN SATU PINTU' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 83.3333333333333 WHERE tahun = '2023' AND id_instansi = 407 AND id_provinsi = 75 AND opd ILIKE 'DINAS PERHUBUNGAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 83.3333333333333 WHERE tahun = '2023' AND id_instansi = 407 AND id_provinsi = 75 AND opd ILIKE 'DINAS PERINDUSTRIAN DAN PERDAGANGAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 83.3333333333333 WHERE tahun = '2023' AND id_instansi = 407 AND id_provinsi = 75 AND opd ILIKE 'DINAS SOSIA' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 83.3333333333333 WHERE tahun = '2023' AND id_instansi = 407 AND id_provinsi = 75 AND opd ILIKE 'DINAS SOSIAL' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 83.3333333333333 WHERE tahun = '2023' AND id_instansi = 407 AND id_provinsi = 75 AND opd ILIKE 'DUKCAPI' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 91.6666666666667 WHERE tahun = '2023' AND id_instansi = 407 AND id_provinsi = 75 AND opd ILIKE 'KABUPATEN POHUWATO' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 83.3333333333333 WHERE tahun = '2023' AND id_instansi = 407 AND id_provinsi = 75 AND opd ILIKE 'KARTU KELUARGA' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 100 WHERE tahun = '2023' AND id_instansi = 407 AND id_provinsi = 75 AND opd ILIKE 'SEKRETARIAT DAERAH' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 83.3333333333333 WHERE tahun = '2023' AND id_instansi = 171 AND id_provinsi = 75 AND opd ILIKE 'KABUPATEN BONE BOLANGO' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 83.3333333333333 WHERE tahun = '2023' AND id_instansi = 207 AND id_provinsi = 75 AND opd ILIKE 'BADAN PENDAPATAN DAERAH' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 76.1904761904762 WHERE tahun = '2023' AND id_instansi = 207 AND id_provinsi = 75 AND opd ILIKE 'KABUPATEN GORONTALO UTARA' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 94.4444444444445 WHERE tahun = '2023' AND id_instansi = 543 AND id_provinsi = 75 AND opd ILIKE 'AKTA KELAHIRAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 100 WHERE tahun = '2023' AND id_instansi = 543 AND id_provinsi = 75 AND opd ILIKE 'AKTA KEMATIAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 83.3333333333333 WHERE tahun = '2023' AND id_instansi = 543 AND id_provinsi = 75 AND opd ILIKE 'BADAN PENELITIAN DAN PENGEMBANGAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 83.3333333333333 WHERE tahun = '2023' AND id_instansi = 543 AND id_provinsi = 75 AND opd ILIKE 'BIRO KESEJAHTERAAN RAKYAT SEKRETARIAT DAERAH' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 77.7777777777778 WHERE tahun = '2023' AND id_instansi = 543 AND id_provinsi = 75 AND opd ILIKE 'DINAS KEPENDUDUKAN DAN PENCATATAN SIPIL' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 83.3333333333333 WHERE tahun = '2023' AND id_instansi = 543 AND id_provinsi = 75 AND opd ILIKE 'DINAS KOPERASI DAN USAHA KECIL' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 88.8888888888889 WHERE tahun = '2023' AND id_instansi = 543 AND id_provinsi = 75 AND opd ILIKE 'DOKUMEN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 100 WHERE tahun = '2023' AND id_instansi = 543 AND id_provinsi = 75 AND opd ILIKE 'IZIN DEPOT' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 85.7142857142857 WHERE tahun = '2023' AND id_instansi = 543 AND id_provinsi = 75 AND opd ILIKE 'KOTA GORONTALO' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 83.3333333333333 WHERE tahun = '2023' AND id_instansi = 543 AND id_provinsi = 75 AND opd ILIKE 'PEMBAYARAN PAJAK' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 83.3333333333333 WHERE tahun = '2023' AND id_instansi = 543 AND id_provinsi = 75 AND opd ILIKE 'PENGUJIAN KENDARAAN BERMOTOR' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 91.6666666666667 WHERE tahun = '2023' AND id_instansi = 543 AND id_provinsi = 75 AND opd ILIKE 'PERIZINAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 89.3939393939394 WHERE tahun = '2023' AND id_instansi = 543 AND id_provinsi = 75 AND opd ILIKE 'REGISTRASI' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 90 WHERE tahun = '2023' AND id_instansi = 543 AND id_provinsi = 75 AND opd ILIKE 'SATUAN POLISI PAMONG PRAJA' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 100 WHERE tahun = '2023' AND id_instansi = 543 AND id_provinsi = 75 AND opd ILIKE 'SURAT IZIN PRAKTEK' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 83.3333333333333 WHERE tahun = '2023' AND id_instansi = 543 AND id_provinsi = 75 AND opd ILIKE 'SURAT PENGANTAR' AND id_unit_kerja IS NULL;
        ");
    }

    public function down()
    {
        self::$connection->execute("
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.326774 WHERE tahun = '2023' AND id_instansi = 161 AND id_provinsi = 75 AND opd ILIKE 'BIRO PENGADAAN BARANG DAN JASA SEKRETARIAT DAERAH' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.326774 WHERE tahun = '2023' AND id_instansi = 161 AND id_provinsi = 75 AND opd ILIKE 'KWITANSI GAJI' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.326774 WHERE tahun = '2023' AND id_instansi = 161 AND id_provinsi = 75 AND opd ILIKE 'KECAMATAN/DESA' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.326774 WHERE tahun = '2023' AND id_instansi = 161 AND id_provinsi = 75 AND opd ILIKE 'KABUPATEN BOALEMO' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 26.050396 WHERE tahun = '2023' AND id_instansi = 161 AND id_provinsi = 75 AND opd ILIKE 'DINAS TENAGA KERJA DAN TRANSMIGRASI' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.859969 WHERE tahun = '2023' AND id_instansi = 161 AND id_provinsi = 75 AND opd ILIKE 'DINAS SOSIAL' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 26.593113 WHERE tahun = '2023' AND id_instansi = 161 AND id_provinsi = 75 AND opd ILIKE 'DINAS PERUMAHAN DAN PERMUKIMAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 20.261419 WHERE tahun = '2023' AND id_instansi = 161 AND id_provinsi = 75 AND opd ILIKE 'DINAS PERTANIAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.326774 WHERE tahun = '2023' AND id_instansi = 161 AND id_provinsi = 75 AND opd ILIKE 'DINAS PERINDUSTRIAN DAN PERDAGANGAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.326774 WHERE tahun = '2023' AND id_instansi = 161 AND id_provinsi = 75 AND opd ILIKE 'DINAS PERHUBUNGAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 26.339845 WHERE tahun = '2023' AND id_instansi = 161 AND id_provinsi = 75 AND opd ILIKE 'DINAS PENANAMAN MODAL DAN PELAYANAN SATU PINTU' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 22.794097 WHERE tahun = '2023' AND id_instansi = 161 AND id_provinsi = 75 AND opd ILIKE 'DINAS KESEHATAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.047947 WHERE tahun = '2023' AND id_instansi = 161 AND id_provinsi = 75 AND opd ILIKE 'DINAS KEPENDUDUKAN DAN PENCATATAN SIPIL' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.557017 WHERE tahun = '2023' AND id_instansi = 161 AND id_provinsi = 75 AND opd ILIKE 'DINAS KELAUTAN DAN PERIKANAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.326774 WHERE tahun = '2023' AND id_instansi = 161 AND id_provinsi = 75 AND opd ILIKE 'BOTUMOITO' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.567981 WHERE tahun = '2023' AND id_instansi = 161 AND id_provinsi = 75 AND opd ILIKE 'BADAN PENGELOLAAN KEUANGAN DAN ASET DAERAH' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.326774 WHERE tahun = '2023' AND id_instansi = 161 AND id_provinsi = 75 AND opd ILIKE 'SATUAN POLISI PAMONG PRAJA' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.326774 WHERE tahun = '2023' AND id_instansi = 161 AND id_provinsi = 75 AND opd ILIKE 'REKOMENDASI' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.326774 WHERE tahun = '2023' AND id_instansi = 161 AND id_provinsi = 75 AND opd ILIKE 'PENDAMPINGAN VERIVIKASI' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.326774 WHERE tahun = '2023' AND id_instansi = 171 AND id_provinsi = 75 AND opd ILIKE 'KECAMATAN/DESA' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.326774 WHERE tahun = '2023' AND id_instansi = 171 AND id_provinsi = 75 AND opd ILIKE 'KABUPATEN BONE BOLANGO' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 26.909697 WHERE tahun = '2023' AND id_instansi = 171 AND id_provinsi = 75 AND opd ILIKE 'DINAS TENAGA KERJA DAN TRANSMIGRASI' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 26.247748 WHERE tahun = '2023' AND id_instansi = 171 AND id_provinsi = 75 AND opd ILIKE 'DINAS TANAMAN PANGAN DAN HORTIKULTURA' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 26.495702 WHERE tahun = '2023' AND id_instansi = 171 AND id_provinsi = 75 AND opd ILIKE 'DINAS SOSIAL' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 26.050396 WHERE tahun = '2023' AND id_instansi = 171 AND id_provinsi = 75 AND opd ILIKE 'DINAS PERHUBUNGAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 27.256433 WHERE tahun = '2023' AND id_instansi = 171 AND id_provinsi = 75 AND opd ILIKE 'DINAS PENANAMAN MODAL DAN PELAYANAN SATU PINTU' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 24.904661 WHERE tahun = '2023' AND id_instansi = 171 AND id_provinsi = 75 AND opd ILIKE 'DINAS PEMUDA DAN OLAHRAGA' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 26.339845 WHERE tahun = '2023' AND id_instansi = 171 AND id_provinsi = 75 AND opd ILIKE 'DINAS KESEHATAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 26.247748 WHERE tahun = '2023' AND id_instansi = 171 AND id_provinsi = 75 AND opd ILIKE 'DINAS KEPENDUDUKAN DAN PENCATATAN SIPIL' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 27.352916 WHERE tahun = '2023' AND id_instansi = 171 AND id_provinsi = 75 AND opd ILIKE 'DINAS KELAUTAN DAN PERIKANAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 26.365821 WHERE tahun = '2023' AND id_instansi = 171 AND id_provinsi = 75 AND opd ILIKE 'BIRO PENGADAAN BARANG DAN JASA SEKRETARIAT DAERAH' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.326774 WHERE tahun = '2023' AND id_instansi = 171 AND id_provinsi = 75 AND opd ILIKE 'BADAN PERENCANAAN PEMBANGUNAN DAERAH' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 26.462112 WHERE tahun = '2023' AND id_instansi = 171 AND id_provinsi = 75 AND opd ILIKE 'BADAN PENGELOLAAN KEUANGAN DAN ASET DAERAH' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 30.392129 WHERE tahun = '2023' AND id_instansi = 171 AND id_provinsi = 75 AND opd ILIKE 'BADAN PENANGGULANGAN BENCANA DAERAH' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 27.02755 WHERE tahun = '2023' AND id_instansi = 206 AND id_provinsi = 75 AND opd ILIKE 'DINAS KEPENDUDUKAN DAN PENCATATAN SIPIL' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 27.412508 WHERE tahun = '2023' AND id_instansi = 206 AND id_provinsi = 75 AND opd ILIKE 'BADAN PENDAPATAN DAERAH' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 26.708234 WHERE tahun = '2023' AND id_instansi = 206 AND id_provinsi = 75 AND opd ILIKE 'BIRO PENGADAAN BARANG DAN JASA SEKRETARIAT DAERAH' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 28.944885 WHERE tahun = '2023' AND id_instansi = 206 AND id_provinsi = 75 AND opd ILIKE 'DINAS KELAUTAN DAN PERIKANAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 27.859451 WHERE tahun = '2023' AND id_instansi = 206 AND id_provinsi = 75 AND opd ILIKE 'DINAS KESEHATAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 27.015226 WHERE tahun = '2023' AND id_instansi = 206 AND id_provinsi = 75 AND opd ILIKE 'DINAS LINGKUNGAN HIDUP' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 29.12579 WHERE tahun = '2023' AND id_instansi = 206 AND id_provinsi = 75 AND opd ILIKE 'DINAS PENANAMAN MODAL DAN PELAYANAN SATU PINTU' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 27.226282 WHERE tahun = '2023' AND id_instansi = 206 AND id_provinsi = 75 AND opd ILIKE 'DINAS PERHUBUNGAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 27.015226 WHERE tahun = '2023' AND id_instansi = 206 AND id_provinsi = 75 AND opd ILIKE 'DINAS PERTANIAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 26.954924 WHERE tahun = '2023' AND id_instansi = 206 AND id_provinsi = 75 AND opd ILIKE 'DINAS SOSIAL' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.326774 WHERE tahun = '2023' AND id_instansi = 206 AND id_provinsi = 75 AND opd ILIKE 'DINAS TENAGA KERJA DAN TRANSMIGRASI' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 22.512688 WHERE tahun = '2023' AND id_instansi = 206 AND id_provinsi = 75 AND opd ILIKE 'KABUPATEN GORONTALO' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 27.274987 WHERE tahun = '2023' AND id_instansi = 206 AND id_provinsi = 75 AND opd ILIKE 'KECAMATAN/DESA' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 30.392129 WHERE tahun = '2023' AND id_instansi = 206 AND id_provinsi = 75 AND opd ILIKE 'SAMSAT KABUPATEN GORONTALO' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 26.068045 WHERE tahun = '2023' AND id_instansi = 207 AND id_provinsi = 75 AND opd ILIKE 'DINAS KELAUTAN DAN PERIKANAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 30.392129 WHERE tahun = '2023' AND id_instansi = 207 AND id_provinsi = 75 AND opd ILIKE 'BADAN PERENCANAAN PEMBANGUNAN DAERAH' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 30.392129 WHERE tahun = '2023' AND id_instansi = 207 AND id_provinsi = 75 AND opd ILIKE 'BADAN PENGELOLAAN KEUANGAN DAN ASET DAERAH' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.326774 WHERE tahun = '2023' AND id_instansi = 207 AND id_provinsi = 75 AND opd ILIKE 'BADAN PENDAPATAN DAERAH' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.643359 WHERE tahun = '2023' AND id_instansi = 207 AND id_provinsi = 75 AND opd ILIKE 'DINAS TENAGA KERJA DAN TRANSMIGRASI' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 23.155908 WHERE tahun = '2023' AND id_instansi = 207 AND id_provinsi = 75 AND opd ILIKE 'KABUPATEN GORONTALO UTARA' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 26.126567 WHERE tahun = '2023' AND id_instansi = 207 AND id_provinsi = 75 AND opd ILIKE 'DINAS SOSIAL' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 26.378074 WHERE tahun = '2023' AND id_instansi = 207 AND id_provinsi = 75 AND opd ILIKE 'DINAS PERHUBUNGAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 27.015226 WHERE tahun = '2023' AND id_instansi = 207 AND id_provinsi = 75 AND opd ILIKE 'DINAS PENANAMAN MODAL DAN PELAYANAN SATU PINTU' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.326774 WHERE tahun = '2023' AND id_instansi = 207 AND id_provinsi = 75 AND opd ILIKE 'DINAS LINGKUNGAN HIDUP' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.688585 WHERE tahun = '2023' AND id_instansi = 207 AND id_provinsi = 75 AND opd ILIKE 'DINAS KESEHATAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.254412 WHERE tahun = '2023' AND id_instansi = 207 AND id_provinsi = 75 AND opd ILIKE 'DINAS KEPENDUDUKAN DAN PENCATATAN SIPIL' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.326774 WHERE tahun = '2023' AND id_instansi = 407 AND id_provinsi = 75 AND opd ILIKE 'DUKCAPI' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.326774 WHERE tahun = '2023' AND id_instansi = 407 AND id_provinsi = 75 AND opd ILIKE 'DINAS TENAGA KERJA DAN TRANSMIGRASI' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.326774 WHERE tahun = '2023' AND id_instansi = 407 AND id_provinsi = 75 AND opd ILIKE 'DINAS SOSIAL' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.326774 WHERE tahun = '2023' AND id_instansi = 407 AND id_provinsi = 75 AND opd ILIKE 'DINAS PERINDUSTRIAN DAN PERDAGANGAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.326774 WHERE tahun = '2023' AND id_instansi = 407 AND id_provinsi = 75 AND opd ILIKE 'DINAS SOSIA' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.326774 WHERE tahun = '2023' AND id_instansi = 407 AND id_provinsi = 75 AND opd ILIKE 'DINAS PERHUBUNGAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 24.555959 WHERE tahun = '2023' AND id_instansi = 407 AND id_provinsi = 75 AND opd ILIKE 'DINAS PENANAMAN MODAL DAN PELAYANAN SATU PINTU' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.326774 WHERE tahun = '2023' AND id_instansi = 407 AND id_provinsi = 75 AND opd ILIKE 'BADAN KEPEGAWAIAN DAERAH' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 22.794097 WHERE tahun = '2023' AND id_instansi = 407 AND id_provinsi = 75 AND opd ILIKE 'BIRO PENGADAAN BARANG DAN JASA SEKRETARIAT DAERAH' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.326774 WHERE tahun = '2023' AND id_instansi = 407 AND id_provinsi = 75 AND opd ILIKE 'DINAS BINA MARGA DAN PENATAAN RUANG' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.603066 WHERE tahun = '2023' AND id_instansi = 407 AND id_provinsi = 75 AND opd ILIKE 'DINAS KEPENDUDUKAN DAN PENCATATAN SIPIL' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.326774 WHERE tahun = '2023' AND id_instansi = 407 AND id_provinsi = 75 AND opd ILIKE 'DINAS KESEHATAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 30.392129 WHERE tahun = '2023' AND id_instansi = 407 AND id_provinsi = 75 AND opd ILIKE 'SEKRETARIAT DAERAH' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.326774 WHERE tahun = '2023' AND id_instansi = 407 AND id_provinsi = 75 AND opd ILIKE 'KECAMATAN/DESA' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.326774 WHERE tahun = '2023' AND id_instansi = 407 AND id_provinsi = 75 AND opd ILIKE 'KARTU KELUARGA' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 27.859451 WHERE tahun = '2023' AND id_instansi = 407 AND id_provinsi = 75 AND opd ILIKE 'KABUPATEN POHUWATO' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.326774 WHERE tahun = '2023' AND id_instansi = 543 AND id_provinsi = 75 AND opd ILIKE 'SURAT PENGANTAR' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 23.638322 WHERE tahun = '2023' AND id_instansi = 543 AND id_provinsi = 75 AND opd ILIKE 'DINAS KEPENDUDUKAN DAN PENCATATAN SIPIL' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 23.87953 WHERE tahun = '2023' AND id_instansi = 543 AND id_provinsi = 75 AND opd ILIKE 'DINAS KELAUTAN DAN PERIKANAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.326774 WHERE tahun = '2023' AND id_instansi = 543 AND id_provinsi = 75 AND opd ILIKE 'BIRO PENGADAAN BARANG DAN JASA SEKRETARIAT DAERAH' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.326774 WHERE tahun = '2023' AND id_instansi = 543 AND id_provinsi = 75 AND opd ILIKE 'BIRO KESEJAHTERAAN RAKYAT SEKRETARIAT DAERAH' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.326774 WHERE tahun = '2023' AND id_instansi = 543 AND id_provinsi = 75 AND opd ILIKE 'BADAN PENELITIAN DAN PENGEMBANGAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 30.392129 WHERE tahun = '2023' AND id_instansi = 543 AND id_provinsi = 75 AND opd ILIKE 'AKTA KEMATIAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 28.703677 WHERE tahun = '2023' AND id_instansi = 543 AND id_provinsi = 75 AND opd ILIKE 'AKTA KELAHIRAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 30.392129 WHERE tahun = '2023' AND id_instansi = 543 AND id_provinsi = 75 AND opd ILIKE 'IZIN DEPOT' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 27.015226 WHERE tahun = '2023' AND id_instansi = 543 AND id_provinsi = 75 AND opd ILIKE 'DOKUMEN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.326774 WHERE tahun = '2023' AND id_instansi = 543 AND id_provinsi = 75 AND opd ILIKE 'DINAS KOMUNIKASI DAN INFORMATIKA' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.326774 WHERE tahun = '2023' AND id_instansi = 543 AND id_provinsi = 75 AND opd ILIKE 'DINAS KOPERASI DAN USAHA KECIL' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.976179 WHERE tahun = '2023' AND id_instansi = 543 AND id_provinsi = 75 AND opd ILIKE 'DINAS PENANAMAN MODAL DAN PELAYANAN SATU PINTU' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 10.13071 WHERE tahun = '2023' AND id_instansi = 543 AND id_provinsi = 75 AND opd ILIKE 'DINAS TENAGA KERJA DAN TRANSMIGRASI' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.326774 WHERE tahun = '2023' AND id_instansi = 543 AND id_provinsi = 75 AND opd ILIKE 'KECAMATAN/DESA' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 26.050396 WHERE tahun = '2023' AND id_instansi = 543 AND id_provinsi = 75 AND opd ILIKE 'KOTA GORONTALO' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.326774 WHERE tahun = '2023' AND id_instansi = 543 AND id_provinsi = 75 AND opd ILIKE 'PEMBAYARAN PAJAK' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.326774 WHERE tahun = '2023' AND id_instansi = 543 AND id_provinsi = 75 AND opd ILIKE 'PENGUJIAN KENDARAAN BERMOTOR' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 27.859451 WHERE tahun = '2023' AND id_instansi = 543 AND id_provinsi = 75 AND opd ILIKE 'PERIZINAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 27.168721 WHERE tahun = '2023' AND id_instansi = 543 AND id_provinsi = 75 AND opd ILIKE 'REGISTRASI' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 27.352916 WHERE tahun = '2023' AND id_instansi = 543 AND id_provinsi = 75 AND opd ILIKE 'SATUAN POLISI PAMONG PRAJA' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 30.392129 WHERE tahun = '2023' AND id_instansi = 543 AND id_provinsi = 75 AND opd ILIKE 'SURAT IZIN PRAKTEK' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 24.964963 WHERE tahun = '2023' AND id_instansi = 543 AND id_provinsi = 75 AND opd ILIKE 'DINAS KESEHATAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.326774 WHERE tahun = '2023' AND id_instansi = 620 AND id_provinsi = 75 AND opd ILIKE 'BADAN PENGELOLAAN KEUANGAN DAN ASET DAERAH' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 30.392129 WHERE tahun = '2023' AND id_instansi = 620 AND id_provinsi = 75 AND opd ILIKE 'BIRO ADMINISTRASI PIMPINAN SEKRETARIAT DAERAH' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 26.207705 WHERE tahun = '2023' AND id_instansi = 620 AND id_provinsi = 75 AND opd ILIKE 'DINAS PENANAMAN MODAL DAN PELAYANAN SATU PINTU' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 27.015226 WHERE tahun = '2023' AND id_instansi = 620 AND id_provinsi = 75 AND opd ILIKE 'DINAS TENAGA KERJA DAN TRANSMIGRASI' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.326774 WHERE tahun = '2023' AND id_instansi = 620 AND id_provinsi = 75 AND opd ILIKE 'PEMBAYARAN PAJAK MOBIL' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.326774 WHERE tahun = '2023' AND id_instansi = 620 AND id_provinsi = 75 AND opd ILIKE 'PEMBAYARAN PAJAK MOTOR' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.326774 WHERE tahun = '2023' AND id_instansi = 620 AND id_provinsi = 75 AND opd ILIKE 'PEMBAYARAN STNK/PLAT NOMOR' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 24.793579 WHERE tahun = '2023' AND id_instansi = 620 AND id_provinsi = 75 AND opd ILIKE 'PROVINSI GORONTALO' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 30.392129 WHERE tahun = '2023' AND id_instansi = 620 AND id_provinsi = 75 AND opd ILIKE 'DINAS KESEHATAN' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.252284 WHERE tahun = '2023' AND id_instansi = 620 AND id_provinsi = 75 AND opd ILIKE 'SAMSAT' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.326774 WHERE tahun = '2023' AND id_instansi = 620 AND id_provinsi = 75 AND opd ILIKE 'SAMSAT KOTA' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 25.326774 WHERE tahun = '2023' AND id_instansi = 620 AND id_provinsi = 75 AND opd ILIKE 'SAMSAT KOTA GORONTALO' AND id_unit_kerja IS NULL;
            UPDATE jaga.spi_external_opd_detail SET ext_402 = 24.964963 WHERE tahun = '2023' AND id_instansi = 620 AND id_provinsi = 75 AND opd ILIKE 'UNIT PELAKSANA TEKNIS' AND id_unit_kerja IS NULL;      
        ");
    }
}