{"id":1656,"date":"2017-03-30T10:51:47","date_gmt":"2017-03-30T02:51:47","guid":{"rendered":"http:\/\/nukasrama.com\/?p=1656"},"modified":"2017-03-30T11:04:23","modified_gmt":"2017-03-30T03:04:23","slug":"kumpulan-query-sql-simda-keuangan-selama-pemeriksaan-bpk","status":"publish","type":"post","link":"https:\/\/blog.nukasrama.com\/index.php\/kerjaan\/simda-keuangan\/kumpulan-query-sql-simda-keuangan-selama-pemeriksaan-bpk\/","title":{"rendered":"Kumpulan Query SQL SIMDA Keuangan Selama Pemeriksaan BPK"},"content":{"rendered":"<p>Selama pemeriksaan Laporan Keuangan Pemerintah Daerah oleh BPK, saya sering dimintai berbagai jenis data. Pemeriksa dari BPK menyiapkan format yang\u00a0dan saya sebagai admin SIMDA\u00a0Keuangan yang kebetulan mengerti <em>query<\/em> SQL harus memutar otak untuk merangkai <em>query<\/em> SQL sesuai permintaan. Beberapa query SQL yang paling sering diminta adalah Register SPP, SPM, SP2D, lengkap dengan rincian belanjanya. Kemudian ada register STS, register pengembalian belanja, yang semua itu akan digunakan untuk menguji angka di dalam Laporan Realisasi Anggaran (LRA). Sayangnya di dalam SIMDA Keuangan laporan yang seperti itu tidak ada. Maka dari itu diperlukanlah query SQL untuk mengambil data tersebut. Namun data yang diambil menggunakan <em>query<\/em> SQL\u00a0kadang memerlukan pengolah kembali menggunakan <em>Excel<\/em>, misalnya menggunakan <em>pivot table<\/em> agar format tabel sesuai dengan yang diinginkan.<\/p>\n<p>Beberapa query yang saya gunakan selama pemeriksaan BPK adalah sebagai berikut:<\/p>\n<ol>\n<li>Register STS per SKPD dengan kode akun pendapatan sampai dengan rincian obyek.<\/li>\n<li>Register SPP, SPM, SP2D per SKPD dengan kode akun belanja sampai dengan rincian obyek.<\/li>\n<li>Jumlah SP2D per SKPD, per Jenis SP2D, dilengkapi dengan jumlah pengembalian belanja, setoran sisa UP, setoran sisa TU.<\/li>\n<\/ol>\n<p>Query-query tersebut\u00a0dapat saya jelaskan sebagai berikut:<!--more--><\/p>\n<p><strong>1. Register STS per SKPD dengan kode akun pendapatan sampai dengan rincian obyek.<\/strong><\/p>\n<pre>SELECT A.Tahun, \r\n CAST(A.Kd_Urusan AS VARCHAR) +'.'+ RIGHT('0'+CAST(A.Kd_Bidang AS VARCHAR),2) +'.'+ RIGHT('0'+CAST(A.Kd_Unit AS VARCHAR),2) +'.'+ RIGHT('0'+CAST(A.Kd_Sub AS VARCHAR),2) + ' - ' + C.Nm_Sub_Unit AS Sub_Unit,\r\n CAST(A.Kd_Rek_1 AS VARCHAR) +'.'+ CAST(A.Kd_Rek_2 AS VARCHAR) + ' - ' + H.Nm_Rek_2 AS Rekening_2,\r\n CAST(A.Kd_Rek_1 AS VARCHAR) +'.'+ CAST(A.Kd_Rek_2 AS VARCHAR) +'.'+ CAST(A.Kd_Rek_3 AS VARCHAR) + ' - ' + G.Nm_Rek_3 AS Rekening_3,\r\n CAST(A.Kd_Rek_1 AS VARCHAR) +'.'+ CAST(A.Kd_Rek_2 AS VARCHAR) +'.'+ CAST(A.Kd_Rek_3 AS VARCHAR) + '.' + RIGHT('0'+CAST(A.Kd_Rek_4 AS VARCHAR),2) +' - ' + F.Nm_Rek_4 AS Rekening_4,\r\n CAST(A.Kd_Rek_1 AS VARCHAR) +'.'+ CAST(A.Kd_Rek_2 AS VARCHAR) +'.'+ CAST(A.Kd_Rek_3 AS VARCHAR) + '.' + RIGHT('0'+CAST(A.Kd_Rek_4 AS VARCHAR),2) +'.'+ RIGHT('0'+CAST(A.Kd_Rek_5 AS VARCHAR),2) + ' - ' + D.Nm_Rek_5 AS Rekening_5, \r\n B.No_STS, B.Tgl_STS, B.Keterangan,\r\n SUM(A.Nilai) AS Nilai_STS\r\nFROM Ta_STS_Rinc A INNER JOIN\r\n Ta_STS B ON A.Tahun = B.Tahun AND A.No_STS = B.No_STS\r\n INNER JOIN Ref_Sub_Unit C ON A.Kd_Urusan = C.Kd_Urusan AND A.Kd_Bidang = C.Kd_Bidang AND A.Kd_Unit = C.Kd_Unit AND A.Kd_Sub = C.Kd_Sub\r\n INNER JOIN Ref_Rek_5 D ON A.Kd_Rek_1 = D.Kd_Rek_1 AND A.Kd_Rek_2 = D.Kd_Rek_2 AND A.Kd_Rek_3 = D.Kd_Rek_3 AND A.Kd_Rek_4 = D.Kd_Rek_4 AND A.Kd_Rek_5 = D.Kd_Rek_5\r\n INNER JOIN Ref_Rek_4 F ON A.Kd_Rek_1 = F.Kd_Rek_1 AND A.Kd_Rek_2 = F.Kd_Rek_2 AND A.Kd_Rek_3 = F.Kd_Rek_3 AND A.Kd_Rek_4 = F.Kd_Rek_4\r\n INNER JOIN Ref_Rek_3 G ON A.Kd_Rek_1 = G.Kd_Rek_1 AND A.Kd_Rek_2 = G.Kd_Rek_2 AND A.Kd_Rek_3 = G.Kd_Rek_3\r\n INNER JOIN Ref_Rek_2 H ON A.Kd_Rek_1 = H.Kd_Rek_1 AND A.Kd_Rek_2 = H.Kd_Rek_2\r\nGROUP BY A.Tahun, A.Kd_Urusan, A.Kd_Bidang, A.Kd_Unit, A.Kd_Sub, C.Nm_Sub_Unit, A.Kd_Rek_1, A.Kd_Rek_2, A.Kd_Rek_3, A.Kd_Rek_4, A.Kd_Rek_5, H.Nm_Rek_2, G.Nm_Rek_3, F.Nm_Rek_4, D.Nm_Rek_5, \r\n B.No_STS, B.Tgl_STS, B.Keterangan<\/pre>\n<p>&nbsp;<\/p>\n<p><strong>2. Register SPP, SPM, SP2D per SKPD dengan kode akun belanja sampai dengan rincian obyek.<\/strong><\/p>\n<pre>SELECT A.Tahun, \r\n CAST(A.Kd_Urusan AS VARCHAR) +'.'+ RIGHT('0'+CAST(A.Kd_Bidang AS VARCHAR),2) +'.'+ RIGHT('0'+CAST(A.Kd_Unit AS VARCHAR),2) +'.'+ RIGHT('0'+CAST(A.Kd_Sub AS VARCHAR),2) + ' - ' + C.Nm_Sub_Unit AS Sub_Unit,\r\n CAST(A.Kd_Rek_1 AS VARCHAR) +'.'+ CAST(A.Kd_Rek_2 AS VARCHAR) + ' - ' + H.Nm_Rek_2 AS Rekening_2,\r\n CAST(A.Kd_Rek_1 AS VARCHAR) +'.'+ CAST(A.Kd_Rek_2 AS VARCHAR) +'.'+ CAST(A.Kd_Rek_3 AS VARCHAR) + ' - ' + G.Nm_Rek_3 AS Rekening_3,\r\n CAST(A.Kd_Rek_1 AS VARCHAR) +'.'+ CAST(A.Kd_Rek_2 AS VARCHAR) +'.'+ CAST(A.Kd_Rek_3 AS VARCHAR) + '.' + RIGHT('0'+CAST(A.Kd_Rek_4 AS VARCHAR),2) +' - ' + F.Nm_Rek_4 AS Rekening_4,\r\n CAST(A.Kd_Rek_1 AS VARCHAR) +'.'+ CAST(A.Kd_Rek_2 AS VARCHAR) +'.'+ CAST(A.Kd_Rek_3 AS VARCHAR) + '.' + RIGHT('0'+CAST(A.Kd_Rek_4 AS VARCHAR),2) +'.'+ RIGHT('0'+CAST(A.Kd_Rek_5 AS VARCHAR),2) + ' - ' + D.Nm_Rek_5 AS Rekening_5,\r\n CASE A.Jn_SPM\r\n WHEN 1 THEN 'UP'\r\n WHEN 2 THEN 'GU'\r\n WHEN 3 THEN 'LS'\r\n WHEN 4 THEN 'TU'\r\n WHEN 5 THEN 'NIHIL'\r\n END AS Jn_SPM, A.Uraian, A.Tgl_SPM, A.No_SPM, B.Tgl_SP2D, B.No_SP2D, \r\n A.Nilai,\r\n A.Nm_Penerima, A.Rek_Penerima, A.NPWP, A.Bank_Penerima\r\nFROM\r\n (\r\n SELECT A.Tahun, A.Kd_Urusan, A.Kd_Bidang, A.Kd_Unit, A.Kd_Sub,\r\n A.Kd_Rek_1, A.Kd_Rek_2, A.Kd_Rek_3, A.Kd_Rek_4, A.Kd_Rek_5,\r\n B.No_SPM, B.Tgl_SPM, B.Jn_SPM, B.Uraian,\r\n SUM(ROUND(A.Nilai,2)) AS Nilai,\r\n B.Bank_Penerima, B.NPWP, B.Nm_Penerima, B.Rek_Penerima\r\n FROM Ta_SPM_Rinc A INNER JOIN\r\n Ta_SPM B ON A.Tahun = B.Tahun AND A.No_SPM = B.No_SPM\r\n GROUP BY A.Tahun, A.Kd_Urusan, A.Kd_Bidang, A.Kd_Unit, A.Kd_Sub, \r\n A.Kd_Rek_1, A.Kd_Rek_2, A.Kd_Rek_3, A.Kd_Rek_4, A.Kd_Rek_5,\r\n B.No_SPM, B.Tgl_SPM, B.Jn_SPM, B.Uraian,\r\n B.Bank_Penerima, B.NPWP, B.Nm_Penerima, B.Rek_Penerima\r\n ) A \r\nINNER JOIN Ta_SP2D B ON A.Tahun = B.Tahun AND A.No_SPM = B.No_SPM\r\nINNER JOIN Ref_Sub_Unit C ON A.Kd_Urusan = C.Kd_Urusan AND A.Kd_Bidang = C.Kd_Bidang AND A.Kd_Unit = C.Kd_Unit AND A.Kd_Sub = C.Kd_Sub\r\nINNER JOIN Ref_Rek_5 D ON A.Kd_Rek_1 = D.Kd_Rek_1 AND A.Kd_Rek_2 = D.Kd_Rek_2 AND A.Kd_Rek_3 = D.Kd_Rek_3 AND A.Kd_Rek_4 = D.Kd_Rek_4 AND A.Kd_Rek_5 = D.Kd_Rek_5\r\nINNER JOIN Ref_Rek_4 F ON A.Kd_Rek_1 = F.Kd_Rek_1 AND A.Kd_Rek_2 = F.Kd_Rek_2 AND A.Kd_Rek_3 = F.Kd_Rek_3 AND A.Kd_Rek_4 = F.Kd_Rek_4\r\nINNER JOIN Ref_Rek_3 G ON A.Kd_Rek_1 = G.Kd_Rek_1 AND A.Kd_Rek_2 = G.Kd_Rek_2 AND A.Kd_Rek_3 = G.Kd_Rek_3\r\nINNER JOIN Ref_Rek_2 H ON A.Kd_Rek_1 = H.Kd_Rek_1 AND A.Kd_Rek_2 = H.Kd_Rek_2\r\nORDER BY A.Tahun, A.Kd_Urusan, A.Kd_Bidang, A.Kd_Unit, A.Kd_Sub, B.Tgl_SP2D, B.No_SP2D<\/pre>\n<p>&nbsp;<\/p>\n<p><strong>3. Jumlah SP2D per SKPD, per Jenis SP2D, dilengkapi dengan jumlah pengembalian belanja, setoran sisa UP, setoran sisa TU.<\/strong><\/p>\n<pre>SELECT A.*, ISNULL(B.Nilai,0) AS UP, ISNULL(C.Nilai,0) AS GU, ISNULL(D.Nilai,0) AS LS, ISNULL(E.Nilai,0) AS TU, ISNULL(F.Nilai,0) AS NIHIL, \r\n ISNULL(G.Nilai,0) AS CP, ISNULL(H.Nilai,0) AS SUP, ISNULL(I.Nilai,0) AS STU, ISNULL(J.Nilai,0) AS CPJ\r\nFROM Ref_Sub_Unit A\r\nLEFT JOIN (\r\n SELECT A.Tahun, A.Kd_Urusan, A.Kd_Bidang, A.Kd_Unit, A.Kd_Sub, SUM(A.Nilai_SPM) AS Nilai\r\n FROM\r\n (\r\n SELECT A.Tahun, A.Kd_Urusan, A.Kd_Bidang, A.Kd_Unit, A.Kd_Sub, \r\n B.No_SPM, SUM(ROUND(A.Nilai,2)) AS Nilai_SPM\r\n FROM Ta_SPM_Rinc A INNER JOIN\r\n Ta_SPM B ON A.Tahun = B.Tahun AND A.No_SPM = B.No_SPM\r\n WHERE B.Jn_SPM = 1\r\n GROUP BY A.Tahun, A.Kd_Urusan, A.Kd_Bidang, A.Kd_Unit, A.Kd_Sub, \r\n B.No_SPM, B.Tgl_SPM, B.Jn_SPM, B.Uraian\r\n ) A\r\n INNER JOIN Ta_SP2D B ON A.Tahun = B.Tahun AND A.No_SPM = B.No_SPM\r\n GROUP BY A.Tahun, A.Kd_Urusan, A.Kd_Bidang, A.Kd_Unit, A.Kd_Sub\r\n ) B ON A.Kd_Urusan = B.Kd_Urusan AND A.Kd_Bidang = B.Kd_Bidang AND A.Kd_Unit = B.Kd_Unit AND A.Kd_Sub = B.Kd_Sub\r\n\r\nLEFT JOIN (\r\n SELECT A.Tahun, A.Kd_Urusan, A.Kd_Bidang, A.Kd_Unit, A.Kd_Sub, SUM(A.Nilai_SPM) AS Nilai\r\n FROM\r\n (\r\n SELECT A.Tahun, A.Kd_Urusan, A.Kd_Bidang, A.Kd_Unit, A.Kd_Sub, \r\n B.No_SPM, SUM(ROUND(A.Nilai,2)) AS Nilai_SPM\r\n FROM Ta_SPM_Rinc A INNER JOIN\r\n Ta_SPM B ON A.Tahun = B.Tahun AND A.No_SPM = B.No_SPM\r\n WHERE B.Jn_SPM = 2\r\n GROUP BY A.Tahun, A.Kd_Urusan, A.Kd_Bidang, A.Kd_Unit, A.Kd_Sub, \r\n B.No_SPM, B.Tgl_SPM, B.Jn_SPM, B.Uraian\r\n ) A\r\n INNER JOIN Ta_SP2D B ON A.Tahun = B.Tahun AND A.No_SPM = B.No_SPM\r\n GROUP BY A.Tahun, A.Kd_Urusan, A.Kd_Bidang, A.Kd_Unit, A.Kd_Sub\r\n ) C ON A.Kd_Urusan = C.Kd_Urusan AND A.Kd_Bidang = C.Kd_Bidang AND A.Kd_Unit = C.Kd_Unit AND A.Kd_Sub = C.Kd_Sub\r\n\r\nLEFT JOIN (\r\n SELECT A.Tahun, A.Kd_Urusan, A.Kd_Bidang, A.Kd_Unit, A.Kd_Sub, SUM(A.Nilai_SPM) AS Nilai\r\n FROM\r\n (\r\n SELECT A.Tahun, A.Kd_Urusan, A.Kd_Bidang, A.Kd_Unit, A.Kd_Sub, \r\n B.No_SPM, SUM(ROUND(A.Nilai,2)) AS Nilai_SPM\r\n FROM Ta_SPM_Rinc A INNER JOIN\r\n Ta_SPM B ON A.Tahun = B.Tahun AND A.No_SPM = B.No_SPM\r\n WHERE B.Jn_SPM = 3\r\n GROUP BY A.Tahun, A.Kd_Urusan, A.Kd_Bidang, A.Kd_Unit, A.Kd_Sub, \r\n B.No_SPM, B.Tgl_SPM, B.Jn_SPM, B.Uraian\r\n ) A\r\n INNER JOIN Ta_SP2D B ON A.Tahun = B.Tahun AND A.No_SPM = B.No_SPM\r\n GROUP BY A.Tahun, A.Kd_Urusan, A.Kd_Bidang, A.Kd_Unit, A.Kd_Sub\r\n ) D ON A.Kd_Urusan = D.Kd_Urusan AND A.Kd_Bidang = D.Kd_Bidang AND A.Kd_Unit = D.Kd_Unit AND A.Kd_Sub = D.Kd_Sub\r\n \r\nLEFT JOIN (\r\n SELECT A.Tahun, A.Kd_Urusan, A.Kd_Bidang, A.Kd_Unit, A.Kd_Sub, SUM(A.Nilai_SPM) AS Nilai\r\n FROM\r\n (\r\n SELECT A.Tahun, A.Kd_Urusan, A.Kd_Bidang, A.Kd_Unit, A.Kd_Sub, \r\n B.No_SPM, SUM(ROUND(A.Nilai,2)) AS Nilai_SPM\r\n FROM Ta_SPM_Rinc A INNER JOIN\r\n Ta_SPM B ON A.Tahun = B.Tahun AND A.No_SPM = B.No_SPM\r\n WHERE B.Jn_SPM = 4\r\n GROUP BY A.Tahun, A.Kd_Urusan, A.Kd_Bidang, A.Kd_Unit, A.Kd_Sub, \r\n B.No_SPM, B.Tgl_SPM, B.Jn_SPM, B.Uraian\r\n ) A\r\n INNER JOIN Ta_SP2D B ON A.Tahun = B.Tahun AND A.No_SPM = B.No_SPM\r\n GROUP BY A.Tahun, A.Kd_Urusan, A.Kd_Bidang, A.Kd_Unit, A.Kd_Sub\r\n ) E ON A.Kd_Urusan = E.Kd_Urusan AND A.Kd_Bidang = E.Kd_Bidang AND A.Kd_Unit = E.Kd_Unit AND A.Kd_Sub = E.Kd_Sub\r\n\r\nLEFT JOIN (\r\n SELECT A.Tahun, A.Kd_Urusan, A.Kd_Bidang, A.Kd_Unit, A.Kd_Sub, SUM(A.Nilai_SPM) AS Nilai\r\n FROM\r\n (\r\n SELECT A.Tahun, A.Kd_Urusan, A.Kd_Bidang, A.Kd_Unit, A.Kd_Sub, \r\n B.No_SPM, SUM(ROUND(A.Nilai,2)) AS Nilai_SPM\r\n FROM Ta_SPM_Rinc A INNER JOIN\r\n Ta_SPM B ON A.Tahun = B.Tahun AND A.No_SPM = B.No_SPM\r\n WHERE B.Jn_SPM = 5\r\n GROUP BY A.Tahun, A.Kd_Urusan, A.Kd_Bidang, A.Kd_Unit, A.Kd_Sub, \r\n B.No_SPM, B.Tgl_SPM, B.Jn_SPM, B.Uraian\r\n ) A\r\n INNER JOIN Ta_SP2D B ON A.Tahun = B.Tahun AND A.No_SPM = B.No_SPM\r\n GROUP BY A.Tahun, A.Kd_Urusan, A.Kd_Bidang, A.Kd_Unit, A.Kd_Sub\r\n ) F ON A.Kd_Urusan = F.Kd_Urusan AND A.Kd_Bidang = F.Kd_Bidang AND A.Kd_Unit = F.Kd_Unit AND A.Kd_Sub = F.Kd_Sub\r\n\r\nLEFT JOIN (\r\n SELECT A.Tahun, B.Kd_Urusan, B.Kd_Bidang, B.Kd_Unit, B.Kd_Sub, SUM(ROUND(A.Nilai,2)) AS Nilai\r\n FROM Ta_Penyesuaian_Rinc A INNER JOIN\r\n Ta_Penyesuaian B ON A.Tahun = B.Tahun AND A.No_Bukti = B.No_Bukti\r\n WHERE (B.Jns_P1 = 1) AND (B.Jns_P2 = 3)\r\n GROUP BY A.Tahun, B.Kd_Urusan, B.Kd_Bidang, B.Kd_Unit, B.Kd_Sub\r\n ) G ON A.Kd_Urusan = G.Kd_Urusan AND A.Kd_Bidang = G.Kd_Bidang AND A.Kd_Unit = G.Kd_Unit AND A.Kd_Sub = G.Kd_Sub\r\n \r\nLEFT JOIN (\r\n SELECT A.Tahun, A.Kd_Urusan, A.Kd_Bidang, A.Kd_Unit, A.Kd_Sub, SUM(ROUND(A.Nilai,2)) AS Nilai\r\n FROM Ta_S3UP A\r\n GROUP BY A.Tahun, A.Kd_Urusan, A.Kd_Bidang, A.Kd_Unit, A.Kd_Sub\r\n ) H ON A.Kd_Urusan = H.Kd_Urusan AND A.Kd_Bidang = H.Kd_Bidang AND A.Kd_Unit = H.Kd_Unit AND A.Kd_Sub = H.Kd_Sub\r\n \r\nLEFT JOIN (\r\n SELECT A.Tahun, B.Kd_Urusan, B.Kd_Bidang, B.Kd_Unit, B.Kd_Sub, SUM(ROUND(A.Nilai,2)) AS Nilai\r\n FROM Ta_SPJ_Sisa A INNER JOIN\r\n Ta_SPJ B ON A.Tahun = B.Tahun AND A.No_SPJ = B.No_SPJ\r\n WHERE (B.Jn_SPJ = 4)\r\n GROUP BY A.Tahun, B.Kd_Urusan, B.Kd_Bidang, B.Kd_Unit, B.Kd_Sub\r\n ) I ON A.Kd_Urusan = I.Kd_Urusan AND A.Kd_Bidang = I.Kd_Bidang AND A.Kd_Unit = I.Kd_Unit AND A.Kd_Sub = I.Kd_Sub\r\n \r\nLEFT JOIN (\r\n SELECT A.Tahun, B.Kd_Urusan, B.Kd_Bidang, B.Kd_Unit, B.Kd_Sub, SUM(ROUND(A.Nilai,2)) AS Nilai\r\n FROM Ta_Jurnal_Rinc A INNER JOIN\r\n Ta_Jurnal B ON A.Tahun = B.Tahun AND A.No_Bukti = B.No_Bukti\r\n WHERE (A.Kd_Rek_1 = 5) AND (A.D_K = 'K') AND (A.No_Bukti NOT LIKE '%PENUTUP%')\r\n GROUP BY A.Tahun, B.Kd_Urusan, B.Kd_Bidang, B.Kd_Unit, B.Kd_Sub\r\n ) J ON A.Kd_Urusan = J.Kd_Urusan AND A.Kd_Bidang = J.Kd_Bidang AND A.Kd_Unit = J.Kd_Unit AND A.Kd_Sub = J.Kd_Sub<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Selama pemeriksaan Laporan Keuangan Pemerintah Daerah oleh BPK, saya sering dimintai berbagai jenis data. Pemeriksa dari BPK menyiapkan format yang\u00a0dan saya sebagai admin SIMDA\u00a0Keuangan yang kebetulan mengerti query SQL harus memutar otak untuk merangkai query SQL sesuai permintaan. Beberapa query SQL yang paling sering diminta adalah Register SPP, SPM, SP2D, lengkap dengan rincian belanjanya. Kemudian &#8230; <a title=\"Kumpulan Query SQL SIMDA Keuangan Selama Pemeriksaan BPK\" class=\"read-more\" href=\"https:\/\/blog.nukasrama.com\/index.php\/kerjaan\/simda-keuangan\/kumpulan-query-sql-simda-keuangan-selama-pemeriksaan-bpk\/\" aria-label=\"Baca selengkapnya tentang Kumpulan Query SQL SIMDA Keuangan Selama Pemeriksaan BPK\">Baca Selengkapnya<\/a><\/p>\n","protected":false},"author":1,"featured_media":1696,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":true,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[103],"tags":[118,84,94],"class_list":["post-1656","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-simda-keuangan","tag-query","tag-simda","tag-sql"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/blog.nukasrama.com\/wp-content\/uploads\/2017\/03\/excel-pivot.jpg?fit=785%2C545&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p3MFVG-qI","jetpack-related-posts":[{"id":915,"url":"https:\/\/blog.nukasrama.com\/index.php\/kerjaan\/simda-keuangan\/apa-yang-terjadi-di-dalam-database-simda-keuangan-part-1\/","url_meta":{"origin":1656,"position":0},"title":"Apa yang Terjadi di Dalam Database SIMDA Keuangan? Part 1","author":"noekaz","date":"20 Mei 2016","format":false,"excerpt":"Tulisan ini saya tulis hanya ingin\u00a0berbagi kepada\u00a0para administrator yang baru\u00a0berkecimpung dalam dunia per-SIMDA-an. Pengetahuan saya tentang apa yang terjadi di balik database SIMDA masih belum lengkap, masih perlu banyak belajar lagi.\u00a0Apa saja yang akan saya bahas di sini? Sesuai judulnya, saya akan membedah proses yang terjadi pada database SIMDA terutama\u2026","rel":"","context":"dalam &quot;SIMDA Keuangan&quot;","block_context":{"text":"SIMDA Keuangan","link":"https:\/\/blog.nukasrama.com\/index.php\/category\/kerjaan\/simda-keuangan\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/blog.nukasrama.com\/wp-content\/uploads\/2016\/05\/simdakeu.jpg?fit=1200%2C656&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/blog.nukasrama.com\/wp-content\/uploads\/2016\/05\/simdakeu.jpg?fit=1200%2C656&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/blog.nukasrama.com\/wp-content\/uploads\/2016\/05\/simdakeu.jpg?fit=1200%2C656&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/blog.nukasrama.com\/wp-content\/uploads\/2016\/05\/simdakeu.jpg?fit=1200%2C656&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/blog.nukasrama.com\/wp-content\/uploads\/2016\/05\/simdakeu.jpg?fit=1200%2C656&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":1725,"url":"https:\/\/blog.nukasrama.com\/index.php\/kerjaan\/simda-keuangan\/cara-lain-input-saldo-awal-simda-keuangan-dan-mapping-opd-lama-ke-opd-baru\/","url_meta":{"origin":1656,"position":1},"title":"Cara Lain Input Saldo Awal SIMDA Keuangan dan Mapping OPD Lama ke OPD Baru","author":"noekaz","date":"30 Juli 2017","format":false,"excerpt":"Menginput saldo awal pada SIMDA Keuangan merupakan rutinitas tahunan yang jika dikerjakan secara manual membutuhkan waktu yang lumayan lama. Apalagi kalau dikerjakan ketika hati sedang galau karena cicilan utang belum lunas. Memang SIMDA Keuangan sudah menyediakan menu untuk export-import saldo awal. Namun saya sendiri tidak pernah menggunakannya. Saya lebih suka\u2026","rel":"","context":"dalam &quot;SIMDA Keuangan&quot;","block_context":{"text":"SIMDA Keuangan","link":"https:\/\/blog.nukasrama.com\/index.php\/category\/kerjaan\/simda-keuangan\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":685,"url":"https:\/\/blog.nukasrama.com\/index.php\/kerjaan\/simda-keuangan\/mengolah-data-simda-keuangan-menggunakan-pivot-table-pada-excel\/","url_meta":{"origin":1656,"position":2},"title":"Mengolah Data SIMDA Keuangan Menggunakan Pivot Table pada Excel","author":"noekaz","date":"19 Mei 2016","format":false,"excerpt":"Sebagai pengguna SIMDA Keuangan BPKP, pada saat-saat tertentu\u00a0saya sering merasa kesulitan dalam\u00a0menghasilkan data\u00a0dengan format tertentu langsung dari preview report SIMDA. Hal ini sering terjadi saat pemeriksaan BPK. Misalnya, pemeriksan meminta Laporan Operasional yang sampai dengan rincian obyek. Di SIMDA laporan ini tidak tersedia, jika pun mau bersusah-susah data tersebut sudah\u2026","rel":"","context":"dalam &quot;SIMDA Keuangan&quot;","block_context":{"text":"SIMDA Keuangan","link":"https:\/\/blog.nukasrama.com\/index.php\/category\/kerjaan\/simda-keuangan\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/blog.nukasrama.com\/wp-content\/uploads\/2016\/05\/msms.png?fit=1116%2C921&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/blog.nukasrama.com\/wp-content\/uploads\/2016\/05\/msms.png?fit=1116%2C921&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/blog.nukasrama.com\/wp-content\/uploads\/2016\/05\/msms.png?fit=1116%2C921&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/blog.nukasrama.com\/wp-content\/uploads\/2016\/05\/msms.png?fit=1116%2C921&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/blog.nukasrama.com\/wp-content\/uploads\/2016\/05\/msms.png?fit=1116%2C921&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":1266,"url":"https:\/\/blog.nukasrama.com\/index.php\/kerjaan\/personal-project\/simda-bmd-berbasis-web\/","url_meta":{"origin":1656,"position":3},"title":"Personal Project: SIMDA BMD Berbasis Web","author":"noekaz","date":"27 Mei 2016","format":false,"excerpt":"Kembali lagi dengan proyek iseng saya yang lain. Kali ini saya\u00a0membuat web interface untuk SIMDA BMD. Tulisan ini masih terkait dengan\u00a0tulisan saya sebelumnya. Di sana dijelaskan kenapa saya menyukai web based application. Saya merasa web based application memiliki lebih banyak keunggulannya, entah pendapat saya ini benar atau tidak. Karena tulisan\u2026","rel":"","context":"dalam &quot;Personal Project&quot;","block_context":{"text":"Personal Project","link":"https:\/\/blog.nukasrama.com\/index.php\/category\/kerjaan\/personal-project\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/blog.nukasrama.com\/wp-content\/uploads\/2016\/05\/bmdweb-1024x451.png?fit=640%2C282&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/blog.nukasrama.com\/wp-content\/uploads\/2016\/05\/bmdweb-1024x451.png?fit=640%2C282&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/blog.nukasrama.com\/wp-content\/uploads\/2016\/05\/bmdweb-1024x451.png?fit=640%2C282&ssl=1&resize=525%2C300 1.5x"},"classes":[]},{"id":25,"url":"https:\/\/blog.nukasrama.com\/index.php\/kerjaan\/personal-project\/simda-keuangan-berbasis-web\/","url_meta":{"origin":1656,"position":4},"title":"Personal Project: SIMDA Keuangan Berbasis Web","author":"noekaz","date":"30 April 2016","format":false,"excerpt":"Sebagai seorang web programmer, jika dihadapkan pada sebuah pilihan, antara\u00a0desktop application atau web based application, tentu saja saya lebih memilih web based application. Dengan keunggulan\u00a0bisa diakses dari mana saja (PC, laptop, tablet, smartphone) lewat browser\u00a0selama ada koneksi internet. Hal ini mengingatkan saya pada\u00a0aplikasi yang setiap hari saya tangani di kantor,\u2026","rel":"","context":"dalam &quot;Personal Project&quot;","block_context":{"text":"Personal Project","link":"https:\/\/blog.nukasrama.com\/index.php\/category\/kerjaan\/personal-project\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/blog.nukasrama.com\/wp-content\/uploads\/2016\/04\/simdakeuweb.png?fit=1200%2C557&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/blog.nukasrama.com\/wp-content\/uploads\/2016\/04\/simdakeuweb.png?fit=1200%2C557&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/blog.nukasrama.com\/wp-content\/uploads\/2016\/04\/simdakeuweb.png?fit=1200%2C557&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/blog.nukasrama.com\/wp-content\/uploads\/2016\/04\/simdakeuweb.png?fit=1200%2C557&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/blog.nukasrama.com\/wp-content\/uploads\/2016\/04\/simdakeuweb.png?fit=1200%2C557&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":27,"url":"https:\/\/blog.nukasrama.com\/index.php\/kerjaan\/ocehan\/perlu-nggak-sih-bagan-akun-standar-yang-sama-antara-penganggaran-penatausahaan-dan-pelaporan\/","url_meta":{"origin":1656,"position":5},"title":"Perlu Nggak Sih Bagan Akun Standar yang Sama dari Penganggaran, Penatausahaan, sampai dengan Pelaporan?","author":"noekaz","date":"28 April 2016","format":false,"excerpt":"Seharusnya tulisan ini saya tulis di akhir tahun 2014\u00a0yang lalu ketika Pemerintah Daerah bersiap-siap untuk menerapkan Standar Akuntansi Berbasis Akrual di tahun 2015. (Meskipun setahu saya\u00a0beberapa daerah sudah melaksanakan selama beberapa tahun) Tapi tak apalah, toh isi dari tulisan ini masih relevan untuk saya bahas. Namun dengan satu catatan penting\u2026","rel":"","context":"dalam &quot;Ocehan&quot;","block_context":{"text":"Ocehan","link":"https:\/\/blog.nukasrama.com\/index.php\/category\/kerjaan\/ocehan\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/blog.nukasrama.com\/wp-content\/uploads\/2016\/04\/Permendagri_No._64_Tahun_2013.jpg?fit=424%2C600&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/blog.nukasrama.com\/index.php\/wp-json\/wp\/v2\/posts\/1656","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.nukasrama.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.nukasrama.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.nukasrama.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.nukasrama.com\/index.php\/wp-json\/wp\/v2\/comments?post=1656"}],"version-history":[{"count":0,"href":"https:\/\/blog.nukasrama.com\/index.php\/wp-json\/wp\/v2\/posts\/1656\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.nukasrama.com\/index.php\/wp-json\/wp\/v2\/media\/1696"}],"wp:attachment":[{"href":"https:\/\/blog.nukasrama.com\/index.php\/wp-json\/wp\/v2\/media?parent=1656"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.nukasrama.com\/index.php\/wp-json\/wp\/v2\/categories?post=1656"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.nukasrama.com\/index.php\/wp-json\/wp\/v2\/tags?post=1656"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}