04-07-25, 07:26 PM
This database is used to support administrative and personnel management systems within the government environment. It contains employee information, attendance records, performance targets, electronic documents, and various supporting data. Some data is organized by year or specific locations. The system also includes internal databases for server management and monitoring.
semarangkab.go.id
Code:
Absen.sql, Absen_New.sql, cscdb.sql, db_nonasn.sql, dnt_efile.sql, dnt_efile2017.sql,
dnt_simpeg2017.sql, dnt_simpeg2018.sql, dnt_simpegungaran.sql, dnt_skp.sql,
dnt_skp2017.sql, dnt_skp_old.sql, gateway.sql, information_schema.sql,
mysql.sql, performance_schema.sql, sib_db.sql, test.sqlPHP Code:
id, nik, gdp, nama, gdb, tmlhr, tglhr, idjenkel, idagama, sts_marital,
alamat, no_kontak, nobpjs, idtkpendid, idjenjurusan, namasekolah, kdunit,
idjabjbt, nosk_pengangkatan, tglsk_pengangkatan, tmtsk_pengangkatan,
pejmen_pengangkatan, nosk_kontrak_akhir, tglsk_kontrak_akhir, tmtsk_kontrak_akhir,
pejmen_kontrak, tgl_berakhir, sts_nonasn, sbiaya, gaji, kategori_gaji,
sts_data, tmt_non_aktif, keterangan, email, nokk, nopeserta, ijazah,
bukti_bayar, kode_rek_anggaran, stsverif, ketverif, th_pemetaan, id_stsseleksi
---------------------------------------------------------------------------------
(5215, '3322192407940003', ' ', 'ERIXS IBRAHIM', ' S.H.', '330177', '1994-07-24', 1, 1, 4, 'Jl. Brigjend Katamso 27 RT 04 Rw 03 Kel. Susukan Ungaran Timur', '0858 6777 3768', '18005676798', '08', '0800204', 'UNDARIS', '27.03.02', 'E076', '814/033/2017', '2017-12-29', '2017-12-29', '0924', '814/042/2022', '2022-01-03', '2022-01-03', '0428', '2022-12-31', '2', '2', 2302800, '', 1, '0000-00-00', '', 'eriixsibrahim24@gmail.com', '3322191410190009', '', '3322192407940003_ijazah.pdf', '3322192407940003_gaji.pdf', ' 1.05.1.05.0.00.0.00.03.00.02.2.02.02.5.1.02.02.01.0017.', 1, ' Dapat Melakukan Pendaftaran pada Aplikasi BKN', '2022', 0),
(5216, '3373022809960001', ' ', 'FAJAR AJI PANGESTU', ' ', '330176', '1996-09-28', 1, 1, 2, 'Timo Kerep RT 05 RW 06 Desa Ngajaran Kec. Tuntang', '0858 6579 1013', '15037874540', '03', '0300313', 'SMK N 3 Salatiga', '27.01.01', 'E106', '814/034/2017', '2017-12-29', '2017-12-29', '0924', '814/043/2022', '2022-01-03', '2022-01-03', '0428', '2022-12-31', '2', '2', 2302800, '', 1, '0000-00-00', '', 'fajar07aji@gmail.com', '3322062303210001', '', '3373022809960001_ijazah.pdf', '3373022809960001_gaji.pdf', '1.05.1.05.0.00.0.00.03.00.02.2.02.02.5.1.02.02.01.0017.', 1, ' Dapat Melakukan Pendaftaran pada Aplikasi BKN', '2022', 0),
(5217, '3322021601970003', ' ', 'FAJAR UTOMO', ' ', '330177', '1997-01-16', 1, 1, 1, 'Dsn. Rekasan RT 020 RW 006 Desa Tegalwaton Tengaran ', '0831 7451 7488', '18005677127', '03', '0300309', 'SMK Telekomunikasi Tunas Harapan', '27.02.02', 'E184', '814/035/2017', '2017-12-29', '2017-12-29', '0100', '814/044/2022', '2022-01-03', '2022-01-03', '0428', '2022-12-31', '2', '2', 2302800, '', 1, '0000-00-00', '', 'utamafajar11@gmail.com', '3322023008088084', '', '3322021601970003_ijazah.pdf', '3322021601970003_gaji.pdf', '1.05.1.05.0.00.0.00.03.00.04.2.01.02.5.1.02.02.01.0018.', 1, ' Dapat Melakukan Pendaftaran pada Aplikasi BKN', '2022', 0),
(5218, '3322112511940002', ' ', 'FANDI FIRMANSYAH', ' ', '330177', '1994-11-25', 1, 1, 2, 'Ngrawan Lor RT 04 RW 05 Bawen Kec. Bawen', '0856 0002 305', '18005676806', '03', '0300103', 'SMA Islam Sudirman ', '27.03.02', 'E026', '814/036/2017', '2017-12-29', '2017-12-29', '0924', '814/045/2022', '2021-01-03', '2022-01-03', '0428', '2022-12-31', '2', '2', 2302800, '', 1, '0000-00-00', '', 'fandi2577@gmail.com', '3322112712180001', '', '3322112511940002_ijazah.pdf', '3322112511940002_gaji.pdf', '1.05.1.05.0.00.0.00.03.00.02.2.01.01.5.1.02.02.01.0017.', 1, ' Dapat Melakukan Pendaftaran pada Aplikasi BKN', '2022', 0),
(5219, '3322132812940001', ' ', 'FERY AFANDI', ' ', '330177', '1994-12-28', 1, 1, 2, 'Dsn. Siroto RT 01 RW 05 Ds. Pagersari ', '0838 3609 2555', '18005676814', '03', '0300104', 'SMA Islam Sudirman ', '27.02.02', 'E184', '814/037/2017', '2017-12-29', '2017-12-29', '0100', '814/046/2022', '2022-01-03', '2022-01-03', '0428', '2022-12-31', '2', '2', 2302800, '', 1, '0000-00-00', '', 'feryafan15@gmail.com', '3322193108220011', '', '3322132812940001_ijazah.pdf', '3322132812940001_gaji.pdf', '1.05.1.05.0.00.0.00.03.00.04.2.01.02.5.1.02.02.01.0018.', 1, ' Dapat Melakukan Pendaftaran pada Aplikasi BKN', '2022', 0),
(5220, '3322152205890003', ' ', 'FINDA ROSSRIA PUTRA', ' ', '330177', '1989-05-22', 1, 1, 2, 'Klepu RT 07 RW 01 Kec. Pringapus', '0856 4098 2771', '18005676822', '03', '0300103', 'PKBM Wancana Mulya', '27.03.01', 'E106', '814/038/2017', '2017-12-29', '2017-12-29', '0924', '814/047/2022', '2022-01-03', '2022-01-03', '0428', '2022-12-31', '2', '2', 2302800, '', 1, '0000-00-00', '', 'briliantairlanggaairlangga@gmail.com', '3322152908084965', '', '3322152205890003_ijazah.pdf', '3322152205890003_gaji.pdf', '1.05.1.05.0.00.0.00.03.00.02.2.01.01.5.1.02.02.01.0017.', 1, ' Dapat Melakukan Pendaftaran pada Aplikasi BKN', '2022', 0),
(5221, '3322075912960002', ' ', 'INDAH YOSAN KRISTI', ' S.H.', '330177', '1996-12-19', 2, 1, 2, 'Dsn. Krajan RT 04 RW 02 Ds. Banyubiru Kec. Banyubiru', '0895 4155 43768', '17047886860', '08', '0800204', 'UNDARIS', '27.01.01', 'E076', '814/039/2017', '2017-12-29', '2017-12-29', '0924', '814/048/2022', '2022-01-03', '2022-01-03', '0428', '2022-12-31', '2', '2', 2302800, '', 6, '2023-07-01', 'Diterima sebagai PPPK', 'indahyosan00@gmail.com', '3322070401220002', '', '3322075912960002_ijazah.pdf', '3322075912960002_gaji.pdf', ' 1.05.1.05.0.00.0.00.03.00.02.2.02.02.5.1.02.02.01.0017.', 1, ' Dapat Melakukan Pendaftaran pada Aplikasi BKN', '2022', 0),
(5222, '3322186704890005', ' ', 'INNA LESTARI', 'A.Md.', '330177', '1989-04-27', 2, 1, 2, 'Jl. Setenan 288 RT 007 RW 004 Kel. Ungaran - Ungaran Barat', '0856 4070 1005', '14029609808', '06', '0600701', 'Polines', '27.01.01', 'E076', '814/040/2017', '2017-12-29', '2017-12-29', '0924', '814/049/2022', '2022-01-03', '2022-01-03', '0428', '2022-12-31', '2', '2', 2302800, '', 6, '2023-07-01', 'Diterima sebagai PPPK', 'Alexinalest@gmal.com', '3322182806160006', '', '3322186704890005_ijazah.pdf', '3322186704890005_gaji.pdf', ' 1.05.1.05.0.00.0.00.03.00.02.2.02.02.5.1.02.02.01.0017.', 1, ' Dapat Melakukan Pendaftaran pada Aplikasi BKN', '2022', 0),
(5223, '3322012610950001', ' ', 'JATIK', ' ', '330177', '1995-10-26', 1, 1, 2, 'Ngelo RT 5 RW 02 Ds. Getasan Kec. Getasan', '0857 2608 7377', '18005676830', '03', '0300312', 'SMK Saraswati', '27.03.01', 'E123', '814/041/2017', '2017-12-29', '2017-12-29', '0100', '814/050/2022', '2022-01-03', '2022-01-03', '0428', '2022-12-31', '2', '2', 2302800, '', 1, '0000-00-00', '', 'jatikviro@gmail.com', '3322011308190005', '', '3322012610950001_ijazah.pdf', '3322012610950001_gaji.pdf', '1.05.1.05.0.00.0.00.03.00.02.2.01.01.5.1.02.02.01.0017.', 1, ' Dapat Melakukan Pendaftaran pada Aplikasi BKN', '2022', 0),
(5224, '3322060105880003', ' ', 'JOKO NURYANTO', ' ', '330177', '1988-05-01', 1, 1, 2, 'Jl Merak No.1 Pengilon Kel. Mangunsari Kec. Sidomukti Salatiga', '0857 4240 8980', '18021084043', '03', '0300302', 'SMK Saraswati', '27.03.02', 'E026', '814/042/2017', '2017-12-29', '2017-12-29', '0924', '814/051/2022', '2022-01-03', '2022-01-03', '0428', '2022-12-31', '2', '2', 2302800, '', 1, '0000-00-00', '', 'jokonuryanto4545@gmail.com', '3373041207170001', '', '3322060105880003_ijazah.pdf', '3322060105880003_gaji.pdf', '1.05.1.05.0.00.0.00.03.00.02.2.01.01.5.1.02.02.01.0017.', 1, ' Dapat Melakukan Pendaftaran pada Aplikasi BKN', '2022', 0),
(5225, '3322011606940001', ' ', 'KRISTIYANTO', ' ', '330177', '1994-06-16', 1, 2, 2, 'Dsn. Kenteng RT 01 RW 05 Desa Sumowage Getasan', '0857 1055 8753', '18005676848', '03', '0300321', 'SMK N 2 Salatiga', '27.02.02', 'E184', '814/043/2017', '2017-12-29', '2017-12-29', '0100', '814/052/2022', '2022-01-03', '2022-01-03', '0428', '2022-12-31', '2', '2', 2302800, '', 1, '0000-00-00', '', 'christiantosmith@gmail.com', '3322010212200003', '', '3322011606940001_ijazah.pdf', '3322011606940001_gaji.pdf', '', 1, ' Dapat Melakukan Pendaftaran pada Aplikasi BKN', '2022', 0),
(5226, '3322040305900002', ' ', 'KUNFUADI', ' ', '330177', '1990-05-03', 1, 1, 2, 'Dsn. Ngemplak RT 11 RW 04 Desa Ketanggi Kec. Suruh', '0856 4349 1114', '15016762609', '03', '0300103', 'PKBM', '27.02.02', 'E184', '814/007/2014', '2014-02-28', '2014-02-28', '0487', '814/053/2022', '2022-01-03', '2022-01-03', '0428', '2022-12-31', '2', '2', 2302800, '', 1, '0000-00-00', '', 'kunfuadi@gmail.com', '3322043007200003', '', '3322040305900002_ijazah.pdf', '3322040305900002_gaji.pdf', '1.05.1.05.0.00.0.00.03.00.04.2.01.02.5.1.02.02.01.0018.', 1, ' Dapat Melakukan Pendaftaran pada Aplikasi BKN', '2022', 0),
(5227, '3322183010940001', ' ', 'LATIEF MAULANA', 'S.E.', '330177', '1994-10-30', 1, 1, 2, 'Manggihan RT 02 Rw 09 Beji Ungaran Timur', '0812 3371 9239', '17043214190', '08', '0800101', 'UNTAG Semarang', '27.01.02', 'E076', '814/044/2017', '2017-12-29', '2017-12-29', '0100', '814/054/2022', '2022-01-03', '2022-01-03', '0428', '2022-12-31', '2', '2', 2302800, '', 1, '0000-00-00', '', 'latiefmaulana19@gmail.com', '3322191812116477', '', '3322183010940001_ijazah.pdf', '3322183010940001_gaji.pdf', '1.05.1.05.0.00.0.00.03.00.02.2.02.02.5.1.02.02.01.0017.', 1, ' Dapat Melakukan Pendaftaran pada Aplikasi BKN', '2022', 0),
(5228, '3322036003910001', ' ', 'MARISA TRI HANTARI', 'S.E.', '330177', '1991-03-20', 2, 1, 2, 'Petet RT 02 RW 01 Desa Tuntang Kecamatan Tuntang', '0838 3883 7440', '17039785294', '08', '0800101', 'UMS', '27.03.02', 'E026', '814/045/2017', '2017-12-29', '2017-12-29', '0924', '814/055/2022', '2022-01-03', '2022-01-03', '0428', '2022-12-31', '2', '2', 2302800, '', 1, '0000-00-00', '', 'Marisatrihantari@gmail.com', '3322060204190009', '', '3322036003910001_ijazah.pdf', '3322036003910001_gaji.pdf', '1.05.1.05.0.00.0.00.03.00.02.2.01.01.5.1.02.02.01.0017.', 1, ' Dapat Melakukan Pendaftaran pada Aplikasi BKN', '2022', 0),
(5229, '3322110108850002', ' ', 'MARKUS TRI NUGROHO', ' ', '330177', '1985-08-01', 1, 3, 2, 'Dsn. Watugimbal 03 RW 02 Kel. Rembes Kec. Bringin', '0838 3846 2426', '15016762617', '03', '0203311', ' SMK T', '27.02.02', 'E184', '814/008/2014', '2014-02-28', '2014-02-28', '0100', '814/056/2022', '2022-01-03', '2022-01-03', '0428', '2022-12-31', '2', '2', 2302800, '', 1, '0000-00-00', '', 'nugrohotri284@gmail.com', '3322120806150003', '', '3322110108850002_ijazah.pdf', '3322110108850002_gaji.pdf', '1.05.1.05.0.00.0.00.03.00.04.2.01.02.5.1.02.02.01.0018.', 1, ' Dapat Melakukan Pendaftaran pada Aplikasi BKN', '2022', 0),
(5230, '3322181004910001', ' ', 'MOKHAMMAD EKO ESTIARNO', ' ', '330177', '1991-04-10', 1, 1, 2, 'Sitalang RW 06 RW 08 Kel. Susukan Kec. Ungaran Timur', '0898 5726 665', '15016762625', '03', '0300321', 'SMK N 11 Semarang', '27.02.02', 'E184', '814/149/2014', '2014-02-28', '2014-02-28', '0487', '814/057/2022', '2022-01-03', '2022-01-03', '0428', '2022-12-31', '2', '2', 2302800, '', 1, '0000-00-00', '', 'ekoestiarnodamkar@gmail.com', '3322191811160002', '', '3322181004910001_ijazah.pdf', '3322181004910001_gaji.pdf', '1.05.1.05.0.00.0.00.03.00.04.2.01.02.5.1.02.02.01.0018.', 1, ' Dapat Melakukan Pendaftaran pada Aplikasi BKN', '2022', 0),
(5231, '3322162702970001', ' ', 'MUHAMAD AKBAR ROFIQ', ' ', '330177', '1997-02-27', 1, 1, 2, 'Ds. Ngentak RT 01 RW 13 Desa Bancak Kec. Bancak', '0858 0361 8586', '18005677168', '03', '0300312', 'SMK NU Tunas Bangsa', '27.02.02', 'E184', '814/046/2017', '2017-12-29', '2017-12-29', '0100', '814/058/2022', '2022-01-03', '2022-01-03', '0428', '2022-12-31', '2', '2', 2302800, '', 1, '0000-00-00', '', 'akbarrofiq027@gmail.com', '3322073007200003', '', '3322162702970001_ijazah.pdf', '3322162702970001_gaji.pdf', '', 1, ' Dapat Melakukan Pendaftaran pada Aplikasi BKN', '2022', 0),
DOWNLOADS : https://fileport.io/ykwKnDk8t57w