
/*
delete from msgroupumur;
insert into msgroupumur values (1,'0-4');
insert into msgroupumur values (2,'5-9');
insert into msgroupumur values (3,'10-14');
insert into msgroupumur values (4,'15-19');
insert into msgroupumur values (5,'20-24');
insert into msgroupumur values (6,'25-29');
insert into msgroupumur values (7,'30-34');
insert into msgroupumur values (8,'35-39');
insert into msgroupumur values (9,'40-44');
insert into msgroupumur values (10,'45-49');
insert into msgroupumur values (11,'50-54');
insert into msgroupumur values (12,'55-59');
insert into msgroupumur values (13,'60-64');
insert into msgroupumur values (14,'65-69');
insert into msgroupumur values (15,'70-74');
insert into msgroupumur values (16,'>75');

delete from mspendidikan;
insert into mspendidikan values (1,'Tidak Tamat SD');
insert into mspendidikan values (2,'SD');
insert into mspendidikan values (3,'SLTP');
insert into mspendidikan values (4,'SLTA');
insert into mspendidikan values (5,'Perguruan Tinggi');
*/



//------------------------------------------------------------------------------//

delete from rpreport;

--(kode instansi,judul laporan,nama file asal, nama tabel tujuan, no urut,jumlah kolom)

--Adminduk 001-199 --
insert into rpreport values('I001','Distribusi penduduk menurut wilayah',
       'xpenduduk.xml','rp1penduduk',1,
       'select rp.tahun, ms.nama, rp.laki, rp.perempuan from rp1penduduk rp, 
        mspropinsi ms where rp.propinsi=ms.kode');

insert into rpreport values('I001','Distribusi penduduk menurut umur tunggal',
       'xumurtunggal.xml','rp1umurtunggal',2,
       'select rp.tahun, ms.nama, rp.lu1, rp.pu1, 
        rp.lu2, rp.pu2, rp.lu3, rp.pu3
        from rp1umurtunggal rp, mspropinsi ms 
        where rp.propinsi=ms.kode');

insert into rpreport values('I001','Distribusi penduduk menurut kelompok umur',
       'xkelompokumur.xml','rp1kelompokumur',3,
       'select * from rp1kelompokumur');

insert into rpreport values('I001','Distribusi penduduk usia 10 tahun keatas menurut status perkawinan',
       'xkawin.xml','rp1kawin',4,
       'select * from rp1kawin');

insert into rpreport values('I001','Distribusi penduduk menurut status kewarganegaraan',
       'xstatuswn.xml','rp1statuswn',5,
       'select * from rp1statuswn');

insert into rpreport values('I001','Distribusi penduduk menurut golongan darah',
       'xdarah.xml','rp1darah',6,
       'select * from rp1darah');

insert into rpreport values('I001','Distribusi penduduk menurut keluarga',
       'xkeluarga.xml','rp1keluarga',7,
       'select * from rp1keluarga');

insert into rpreport values('I001','Distribusi penduduk menurut agama',
       'xagama.xml','rp1agama',8,
       'select * from rp1agama');

insert into rpreport values('I001','Distribusi penduduk menurut tenaga Kerja',
       'xtenagakerja.xml','rp1tenagakerja',9,
       'select * from rp1tenagakerja');

insert into rpreport values('I001','Distribusi penduduk menurut pekerjaan',
       'xpekerjaan.xml','rp1pekerjaan',10,
       'select * from rp1pekerjaan');

--Depkes
delete from rpreport where urutan=201;
insert into rpreport values('I002','Kematian Bayi dan Kelahiran Hidup',
       'xbayimatihidup.xml','rp2bayimatihidup',201,
       'select * from rp2bayimatihidup');

delete from rpreport where urutan=202;
insert into rpreport values('I002','Kematian Ibu Maternal',
       'xmaternalIbu.xml','rp2maternalIbu',202,
       'select * from rp2maternalIbu');

delete from rpreport where urutan=203;
insert into rpreport values('I002','Kematian di RS',
       'xmatiRS.xml','rp2matiRS',203,
       'select * from rp2matiRS');

delete from rpreport where urutan=204;
insert into rpreport values('I002','Penyakit Penyebab Kematian',
       'xpenyakitUtama.xml','rp2penyakitUtama',204,
       'select * from rp2penyakitUtama');

delete from rpreport where urutan=205;
insert into rpreport values('I002','Penyakit Pasien Rawat Jalan',
       'xpenyakitRJ.xml','rp2penyakitRJ',205,
       'select * from rp2penyakitRJ');

delete from rpreport where urutan=206;
insert into rpreport values('I002','Penyakit Pasien Rawat Inap',
       'xpenyakitRI.xml','rp2penyakitRI',206,
       'select * from rp2penyakitRI');

delete from rpreport where urutan=207;
insert into rpreport values('I002','Ragam Penyakit',
       'xragamPenyakit.xml','rp2ragamPenyakit',207,
       'select * from rp2ragamPenyakit');




--BPS 300-399  --
delete from rpreport where urutan=301;
insert into rpreport values('I003','Jumlah Daerah Administrasi di Indonesia',
       'xdaerahadministrasi.xml','rp3daerahadministrasi',301,
       'select * from rp3daerahadministrasi');

delete from rpreport where urutan=302;
insert into rpreport values('I003','Daerah Administrasi Menurut Propinsi',
       'xdaerahPropinsi.xml','rp3daerahPropinsi',302,
       'select rp.tahun, ms.nama, rp.kabupaten, rp.kota,rp.kecamatan, rp.desa
        from rp3daerahpropinsi rp, mspropinsi ms 
        where rp.propinsi=ms.kode');

delete from rpreport where urutan=303;
insert into rpreport values('I003','Luas Daerah di Indonesia',
       'xluasIndonesia.xml','rp3luasIndonesia',303,
       'select rp.tahun, ms.nama, rp.luas
        from rp3luasindonesia rp, mspropinsi ms 
        where rp.propinsi=ms.kode');

delete from rpreport where urutan=304;
insert into rpreport values('I003','Daerah Administrasi Menurut Propinsi',
       'xpendudukBps.xml','rp3penduduk',304,
       'select rp.tahun, rp.penduduk from rp3penduduk rp');

delete from rpreport where urutan=305;
insert into rpreport values('I003','Luas Daerah di Indonesia',
       'xkepadatan.xml','rp3kepadatan',305,
       'select * from rp3kepadatan');













