USE [AJK]


DECLARE @pi_password VARCHAR(50) = '234Hci'
-------------------------------------------
DECLARE @v_password VARCHAR(50)
SELECT @v_password = SUBSTRING(sys.fn_sqlvarbasetostr(HASHBYTES('MD5',@pi_password)),3,32)

DECLARE @list_peserta TABLE ( 
								nama VARCHAR(100),
								username VARCHAR(15),
								email VARCHAR(100),
								tipe VARCHAR(50)
							)
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Isti Purwani', 'ipurwani', 'isti.purwani@homecredit.co.id','Claim Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Yessy Pratiwi', 'ypratiwi05', 'yessy.pratiwi05@homecredit.co.id','Claim Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Dewi Ambar Nur Hidayah', 'dhidayah', 'dewi.hidayah@homecredit.co.id','Claim Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Ricky Wibowo', 'rwibowo01', 'ricky.wibowo01@homecredit.co.id','Claim Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Eka Susanto', 'esusanto', 'eka.susanto@homecredit.co.id','Claim Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Muhammad Ramdani', 'mramdani02', 'muhammad.ramdani02@homecredit.co.id','Claim Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Anisah Mayasari', 'amayasari', 'anisah.mayasari@homecredit.co.id','Claim Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Kartina Nafisaty', 'knafisaty', 'kartina.nafisaty@homecredit.co.id','Claim Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Dessy Maharni Rahayu', 'drahayu', 'dessy.rahayu@homecredit.co.id','Inpayment Team')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Dewi Basa Lumban Tobing', 'dtobing', 'dewi.tobing@homecredit.co.id','Inpayment Team')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Wiwie Koeswiathie', 'wkoeswiathie', 'wiwie.koeswiathie@homecredit.co.id','Inpayment Team')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Wefni Azlen', 'wazlen', 'wefni.azlen@homecredit.co.id','Inpayment Team')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Dini Emilia', 'demilia01', 'dini.emilia02@homecredit.co.id','Inpayment Team')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Harry Yanto Gunawan', 'hgunawan', 'harry.gunawan@homecredit.co.id','Inpayment Team')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Krisma Clara Shinta', 'kshinta', 'krisma.shinta@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Eka Silvia Agustini', 'eagustini', 'eka.agustini@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Sumardi Saputro', 'ssaputro03', 'sumardi.saputro03@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Kristin Fani Manurung', 'kmanurung', 'kristin.manurung@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Ira Widya', 'iwidya', 'ira.widya@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Farah Ria Amkas', 'famkas', 'farah.amkas@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Firman Agung', 'fbutarbutar01', 'firman.agung@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Alfonso Nico Nathanael H', 'ah02', 'alfonso.h04@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Aditya Nugraha', 'anugraha14', 'aditya.nugraha14@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Astri Nurlaliasari', 'anurlaliasari', 'astri.nurlaliasari@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Anis Syahfitri', 'asyahfitri01', 'anis.syahfitri01@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Annisa Ul Khatimah', 'akhatimah01', 'annisa.khathimah@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Elia Gustimona', 'egustimona01', 'elia.gustimona01@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Harty Fitrianti', 'hfitrianti', 'harty.fitrianti@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Gading Citra Sari', 'gsari02', 'gading.sari02@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Shera Ayu Septiani', 'sseptiani', 'shera.septiani@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Wahyuning Oktaviana', 'woktaviana', 'wahyuning.oktaviana@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Hadi Maolana', 'hmaolana', 'hadi.maolana@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Hiras Andino Sinurat', 'hsinurat', 'hiras.sinurat@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Resky juliza', 'rjuliza', 'resky.juliza@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Zulfikar Ramadhan', 'zramadhan', 'zulfikar.ramadhan@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Asni Nuruddini', 'anuruddini', 'asni.nuruddini@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Gilbert Maruli Perdana Putra Sinaga', 'gsinaga', 'gilbert.sinaga@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Dinnia Amalia', 'damalia03', 'dinnia.amalia03@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Chika Nurherawati', 'cnurherawati', 'chika.nurherawati01@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Widias Putri Nurina', 'wnurina', 'widias.nurina@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Dwi Ria Wheny', 'dringo', 'dwi.ringo@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Rangga Ervani', 'rervani', 'rangga.ervani@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Evi Prasetyo', 'nmulyani', 'evi.prasetyo07@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Ninik Mulyani', 'eprasetyo07', 'ninik.mulyani@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Dahrul Mardhona', 'dmardhona', 'dahrul.mardhona@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Yeni Rahmawati', 'yrahmawati', 'yeni.rahmawati@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Radya Surya Negara', 'rnegara01', 'radya.negara01@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Murtapiah', 'murtapiah', 'murtapiah@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Henny Lestari', 'hlestari', 'henny.lestari@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Danil Rea Lesmana', 'dlesmana02', 'danil.lesmana02@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Dwi Ratna Ningsih', 'dningsih', 'dwi.ningsih@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Amrullah Azhari', 'aazhari', 'amrullah.azhari@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Erixon Hatoguan', 'ehatoguan', 'erixon.hatoguan@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Winda Puspitasari', 'wpuspitasari', 'winda.puspitasari@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Tri Jayanti', 'tjayanti01', 'tri.jayanti01@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Puput Oktavia', 'poktavia01', 'puput.oktavia01@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Siti Fauziani', 'sfauziani01', 'siti.fauziani01@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Winda Sekar Ramadhani', 'wramadhani01', 'winda.ramadhani01@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Winda Kurniasih', 'wkurniasih', 'winda.kurniasih@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Muthiarani Zahari Sinaga', 'msinaga01', 'muthiarani.sinaga01@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Muhammad Irwanda', 'mirwanda', 'muhammad.irwanda@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Yunita', 'yunita02', 'yunita02@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Yuni Kartika Dewi', 'ydewi03', 'yuni.dewi03@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Maryanti Nur Anggraeni', 'manggraeni02', 'maryanti.anggraeni02@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Saputra Anuri', 'sanuri01', 'saputra.anuri01@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Nur Sasqiati Tania', 'ntania', 'nur.tania@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Lili Indriyani', 'lindriyani01', 'lili.indriyani01@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Firda Permatasari', 'fpermatasari', 'firda.permatasari@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Vita Andriyani', 'vandriyani', 'vita.andriyani@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Nuraini Zahroh', 'nzahroh', 'nuraini.zahroh@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Imam Wahyudi', 'iwahyudi04', 'imam.wahyudi04@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Lilis Lestyaningrum', 'llestyaningrum', 'lilis.lestyaningrum@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Maulida Nur Fithryani', 'mfithryani', 'maulida.fithryani@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Rizky Saudia Martha', 'rmartha', 'rizky.martha@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Dwi Rahma Lestari', 'dlestari22', 'dwi.lestari22@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Sultan Djafar', 'sgohantara', 'sultan.gohantara@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Ireni  Mardianti', 'imardianti', 'ireni.mardianti@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Muhammad Noermansyah', 'mnoermansyah', 'muhammad.noermansyah@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Maulidya Anggraini', 'manggraini02', 'maulidya.anggraini02@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Syella Rizkiah Marda', 'smarda', 'syella.marda@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Asti Indah Perdani', 'aperdani', 'asti.perdani@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('suhaemi', 'suhaemi', 'suhaemi@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Dini Utami', 'dutami05', 'dini.utami05@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Ellen Sophia N', 'esophia', 'ellen.sophia@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Lenny Septianingsih', 'lseptianingsih', 'lenny.septianingsih@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Lylis Ma’ulizza', 'lmaulizza', 'lylis.ma''ulizza@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Rose Hidayah Sari', 'rsari26', 'rose.sari26@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Bari Abdul Aziz', 'baziz01', 'bari.aziz01@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Ummi Ulfah', 'uulfah03', 'ummi.ulfah03@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Budi Sanjaya', 'bsanjaya04', 'budi.sanjaya04@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Ninu Amalia', 'namalia08', 'ninu.amalia08@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Nova Delfita', 'ndelfita', 'nova.delfita@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Aris', 'aris', 'aris@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Retno Sri Wahyuni', 'rwahyuni06', 'retno.wahyuni06@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Feni Putriandari', 'fputriandari', 'feni.putriandari@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Miskatul Amnah', 'mamnah', 'miskatul.amnah@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Achmad Baydowi', 'abaydowi', 'achmad.baydowi@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Nurul Arisandi', 'narisandi', 'nurul.arisandi@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Mohamad Dimas Aditya', 'maditya02', 'mohamad.aditya02@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Mochamad Afrizal Firdaus Pramudia', 'mpramudia', 'mochamad.pramudia@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Muhammad Wildan', 'mwildan04', 'muhammad.wildan04@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Benny Antonius', 'bantonius', 'benny.antonius@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Riana Nola sari', 'rsari27', 'riana.sari27@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Sari Afyani', 'safyani', 'sari.afyani@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Siti Aisyah Nurjanah', 'snurjanah02', 'siti.nurjanah02@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Uud Jana Putri Nurhayyuning Haqq', 'unurhayyuning', 'uud.nurhayyuninghaqq@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('M. Sofyan Ferdiansyah', 'mferdiansyah02', 'm.ferdiansyah02@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Lita Murtiyah', 'lmurtiyah', 'lita.murtiyah@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Trisna Haswa Yuniza', 'tyuniza', 'trisna.yuniza@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Nur Wulan Ramdaniati', 'nramdaniati', 'nur.ramdaniati@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Rika Amalia', 'ramalia06', 'rika.amalia06@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Rachmadhanti', 'rachmadhanti', 'rachmadhanti@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Audiya Tuzzara', 'atuzzara', 'audiya.tuzzara@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Hanna Maulidia', 'hmaulidia', 'hanna.maulidia@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Rafi Saputra', 'rsaputra31', 'rafi.saputra31@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Rohmatika Oktaviani', 'roktaviani04', 'rohmatika.oktaviani04@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Annisa Putri Yuni', 'ayuni01', 'annisa.yuni01@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Azzahra Nur Ariestia Yohoi', 'ayohoi', 'azzahra.yohoi@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Anisa', 'anisa01', 'anisa01@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Nanda Gumirasty Ali', 'nali', 'nanda.ali@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Firda Aulia', 'faulia02', 'firda.aulia02@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Adelia Risky', 'arisky', 'adelia.risky@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Marsya Puri Ariesca', 'mariesca', 'marsya.ariesca@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Ulfa Damayanti', 'udamayanti', 'ulfa.damayanti@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Ali Talaohu', 'atalaohu', 'ali.talaohu@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Maria Pricilia Botta Maran', 'mmaran', 'maria.maran@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Miftahur Rizki', 'mrizki10', 'miftahur.rizki10@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Muhammad Sudrajat', 'msudrajat01', 'muhammad.sudrajat01@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Mona Hardiyanti Ruhiyat', 'mruhiyat', 'mona.ruhiyat@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Mustofa', 'mustofa', 'mustofa@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Nadya Amalia Mulyono', 'nmulyono01', 'nadya.mulyono01@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Saskia Aryani', 'saryani01', 'saskia.aryani01@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Nur Anggraeni', 'nanggraeni03', 'nur.anggraeni03@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Irvan Wahyu Elindra', 'ielindra', 'irvan.elindra@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Ika Mustika Wati Chairul Fasal', 'ifasal01', 'ika.fasal01@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Ade Tiya Oktafiyani', 'aoktafiyani', 'ade.oktafiyani@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Suryo Bronto', 'sbronto', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Lita Aprilia', 'laprilia', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Vydi Purwandari', 'vpurwandari', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Desti Dianwardani', 'ddianwardani', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Agung Narayana', 'anarayana', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Andre Novanda', 'anovanda', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Nurul Fajri', 'nfajri', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Derie Nurdiansyah', 'dnurdiansyah', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Setia Rini', 'srini', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Deni Aulani Firmansyah', 'dfirmansyah', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Alifia Nisa Sutedi', 'asutedi', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Rima Mariana', 'rmariana', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Rohmawati Rohmawati', 'rohmawati02', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Yenerita Yuliza', 'yyuliza', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('More Manurung', 'mmanurung', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Mahyudin', 'mahyudin01', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Irfina Maulidya lestari', 'ilestari01', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Yuda Srandi', 'ysrandi', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Melati Astuti', 'mastuti05', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Ahmad Rivai', 'arivai03', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Lusiana Retno Widowati', 'lwidowati', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Meizha Trinanda. A', 'magianti', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Hery Indar Purwanto', 'hpurwanto03', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Dipa Amarullah', 'damarullah01', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Dwi Muktiyanti', 'dmuktiyanti', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Maylani Citra Dewi', 'mdewi12', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Eky Rizky Jayadiningrat', 'ejayadiningrat', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Achmad Choirull Anam', 'aanam', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Arfiansyah Manafi', 'amanafi', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Syaripudin', 'syaripudin01', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Yanti Dianita', 'ydianita01', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Fauziah Evita Zahra', 'fzahra03', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Maulana Yusuf', 'myusuf15', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Lamhot Julyana', 'ljulyana', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('M Rizqi Nurfadillah', 'mnurfadillah01', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Putri Atya Khairia', 'pkhairia', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Intan Rizky Permatasari', 'ipermatasari01', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Nela Riana', 'nriana', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Ganda Yanuar Rahman', 'grahman03', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Ariya Purnama', 'apurnama05', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Fitria Arisandi', 'farisandi01', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Ivan Waliansyah', 'iwaliansyah01', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Berilian Ardi', 'bardi', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Yesika', 'yesika', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Putri Ratnasari', 'pratnasari01', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Faridh Kustoyo', 'fkustoyo', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Firman Hadi Sanjaya', 'fsanjaya', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('I Putu Afrizal Pahlevi', 'ipahlevi', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Muhamad Quraish Ridwan', 'mridwan12', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Fandi Prasetyo', 'fprasetyo02', NULL,'View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Libertha Lively', 'llively', 'libertha.lively@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Ricky Mardiansyah', 'rmardiansyah', 'ricky.mardiansyah@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Renietya Manik', 'rmanik01', 'renietya.manik01@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Reni Tri Apriyani', 'rapriyani01', 'reni.apriyani01@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Emi Aryanti', 'earyanti01', 'emi.aryanti01@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Windi Setiawati', 'wsetiawati02', 'windi.setiawati02@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Nisrina Amalia', ' namalia05', ' nisrina.amalia05@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Siti Fauziah', 'sfauziah07', 'siti.fauziah07@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Ira Wisudhawanti', 'iwisudhawanti', 'ira.wisudhawanti@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Yodi Septian', 'yseptian04', 'yodi.septian04@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Dewi Nuraini', 'dnuraini03', 'dewi.nuraini03@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Merinto Petrus Pratama', 'mpratama06', 'merinto.pratama06@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Iis Ratnasari', 'iratnasari01', 'iis.ratnasari01@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Arneza Wicaksono', 'awicaksono03', 'arneza.wicaksono03@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Sigit Cahyo Purnomo', 'spurnomo', 'sigit.purnomo05@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Asaduddin', 'aassadudin', 'asaduddin.assadudin@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Muhammad Yogie Alfajri', 'malfajri', 'muhammad.alfajri@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Andi Ahmad Afandi', 'aafandi04', 'andi.afandi04@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Lastri Anggraini', 'langgraini', 'lastri.anggraini@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Mita Widanti', 'mwidanti', 'mita.widanti@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Cirella Ivone Virgo Iriana', 'ciriana', 'cirella.iriana@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Riska Rosiana', 'rrosiana', 'riska.rosiana@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Lefti Arlieja', 'larlieja', 'lefti.arlieja@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Fita Azizah Ningsih', 'fningsih02', 'fita.ningsih02@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Umi Saadah', 'usaadah01', 'umi.saadah01@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Fhitria Abdul', 'fabdul', 'fhitria.abdul@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Frima Hajirin S. Pelawi', 'fpelawi', 'frima.pelawi@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Damba Pribadi Hutahuruk', 'dhutahuruk', 'damba.hutauruk@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Dian Aprianti', 'daprianti01', 'dian.aprianti01@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Yona Marliana', 'ymarliana', ' yona.marliana@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Agus Subianto', 'asubianto', ' agus.subianto@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Novrian Ikhsan Prasetyo', 'nprasetyo02 ', 'novrian.prasetyo02@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Budi Safriadi', 'bsafriadi ', 'budi.safriadi@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Icuk Trisnawan', 'itrisnawan ', 'icuk.trisnawan@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Kharina Meutia Zuhri', 'kzuhri01', 'kharina.zuhri01@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Aidha Marinda Ayu', 'aayu02', 'aidha.ayu02@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Ashwin Hendik Rusdianto', 'arusdianto', 'ashwin.rusdianto@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Muhamad Arifin', 'marifin06', 'm.arifin06@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Dian Budi Pertiwi', 'dpertiwi02', 'dian.pertiwi02@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Harum Isma', 'hisma', 'harum.isma@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Sari Wahyuni', 'swahyuni15', 'sari.wahyuni15@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Cut Farah Nabilah Ar-ann', 'car-ann01', 'cut.arann01@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Eko Jumanto', 'ejumanto', 'eko.jumanto@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Teti Maryam', 'tmaryam01', 'teti.maryam01@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Dewi Yanti', 'dyanti', 'dewi.yanti@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Nur Ani', 'nani', 'nur.ani@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Santi Lestari', 'slestari16', 'santi.lestari16@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Novi Tri Handayani', 'nhandayani07', 'nova.handayani07@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Nia Asrigianti', 'nasrigianti', 'nia.asrigianti@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Aldy Noviyan Trimaha Putra', 'aputra30', 'aldy.trimahaputra@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Farida', 'farida', 'farida@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Kristov​orus Bala Lian', 'kbala01', 'kristovorus.bala01@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Triyatul Rahma Hijar', 'thijar', 'triyatul.hijar@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Jailani', 'jailani', 'jailani@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Martono', 'martono', 'martono@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Winda Herlina', 'wherlina01', 'winda.herlina01@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Dian Utami', 'dutami', 'dian.utami@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Riyo Aryanto', 'raryanto01', 'riyo.aryanto01@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Rahmad Zaenuri', 'rzaenuri', 'rahmad.zaenuri@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Iman Pirmansyah', 'ipirmansyah01', 'iman.pirmansyah01@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Feiber Benny G', 'fg', 'feiber.g@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Achmad Afriyansyah', 'aafriyansyah', 'achmad.afriyansyah@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Dewinta Tri Lestari', 'dlestari15', 'dewinta.lestari15@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Tety Marlina', 'tmarlina', 'tety.marlina@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Yeni Agustina', 'yagustina01', 'yeni.agustina01@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Dedeh Rahmawati', 'drahmawati12', 'dedeh.rahmawati12@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Ariyanti', 'ariyanti01', 'ariyanti01@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Anisa Oktaviyani', 'aoktaviyani', 'anisa.oktaviyani@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Windiana Putri', 'wputri03', 'windiana.putri03@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Sinthiya Oktaviani', 'soktaviani05', 'sinthiya.oktaviani05@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Bunga Kasih Afriliani', 'bafriliani01', 'bunga.afriliani01@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Febrian Yuda Ibrani', 'fibrani01', 'febrian.ibrani01@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Gloria Anggela Nauli', 'gnauli01', 'gloria.nauli01@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Rina Melani', 'rmelani01', 'rina.melani01@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Putri Mustika Sari', 'psari09', 'putri.sari09@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Fenny Fadhilla', 'ffadhilla', 'fenny.fadhilla@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Seftaria Amanda', 'samanda', 'seftaria.amanda02@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Harun', 'harun', 'harun@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Maria Elizabeth Kumaat', 'mkumaat', 'maria.kumaat@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('syaifullah', 'syaifullah', 'syaifullah@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Dian Puspita Sari', 'dsari41', 'dewinta.lestari15@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Dewi Sendy Rahmadhani', 'drahmadhani01', 'dewi.rahmadhani01@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Siska Anggraini', 'sanggraini07', 'siska.anggraini07@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Sinta Bela', 'sbela01', 'sinta.bela01@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Michelle Darma Budiawan', 'mbudiawan', 'michelle.budiawan@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Estika Swara Mahardika', 'emahardika', 'estika.mahardika@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Tri Rahayu Hidayatulloh', 'thidayatulloh01', 'tri.hidayatulloh01@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Ranto Roman Parmonangan', 'rparmonangan', 'ranto.parmonangan@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Dea Pamungkas', 'dpamungkas', 'dea.pamungkas@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Freddy Parulian Siringo', 'fsiringo', 'freddy.siringo@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Wahyu Wageono', 'wwageono', 'wahyu.wageono@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Bambang Setiawan', 'bsetiawan02', 'bambang.setiawan02@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Dian Puspita Kusumaningrum', 'dkusumaningrum', 'dian.kusumaningrum01@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Susanti', 'susanti03', 'susanti03@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Ruci Febiana', 'rfebiana', 'ruci.febiana@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Teguh Abdurrahman Basir', 'tbasir', 'teguh.basir@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Rusnita', 'rusnita', 'rusnita@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Ardiansah', 'ardiansah', 'ardiansah@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Freddy Ronny Tua', 'fronny', 'freddy.tua@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Dian Ismayanti', 'dismayanti', 'dian.ismayanti@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Eduward Marsan', 'emarsan', 'eduward.marsan@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Yuli Amri', 'yamri', 'yuli.amri@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Erdawati', 'ewati04', 'erda.wati04@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Ridho Fajar Kurnia', 'rkurnia01', 'ridho.kurnia01@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Fajar Abrilian', 'fabrilian', 'fajar.abrilian@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Andrian Sabur', 'asabur', 'andrian.sabur@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Astri Dian Permata', 'apermata', 'astri.permata@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Ruseno Danu Kusworo', 'rkusworo', 'ruseno.kusworo@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Isti Sofyantika', 'iariesta', ' isty.ariesta@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Abdul Hadi', 'ahadi05', 'abdul.hadi05@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Rizki Dwi Cahyani', 'rcahyani02', 'rizki.cahyani02@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Sri Rahma Yuliana', 'syuliana', 'sri.yuliana@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Devi Rusmaningtyas', 'drusmaningtyas', 'devi.rusmaningtyas@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Dhiana A Hutapea', 'dhutapea01', 'dhiana.hutapea01@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Yogi Suciadi', 'ysuciadi', 'yogi.suciadi@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Carina Meida', 'cmeida', 'carina.meida@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Pujiati', 'pujiati01', 'pujiati01@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Purwaningsih', 'purwaningsih01', 'purwaningsih01@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Muhamad Ridwan Syah', 'msyah03', 'muhamad.syah03@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Tiara  Febriyanti', 'tfebriyanti', 'tiara.febyanti@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Muzdalifa Nurfahri', 'mnurfahri', 'muzdalifa.nurfajri@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Wisnu Hadiyanto', 'whadiyanto', 'wisnu.hadiyanto@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Tommy Novriko', 'tnovriko', 'tommy.novriko@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Yahya Ramdani', 'yramdani', 'yahya.ramdani@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Fitroh Abdillah', 'fabdillah04', 'fitroh.abdillah04@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Deliana Triadi Putri', 'dputri21', 'deliana.putri21@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Irfan Kamaludin', 'ikamaludin01', 'irfan.kamaludin01@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Achmad Zazuli', 'azazuli01', 'achmad.zazuli01@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Dwi Amin', 'dsaputro03', 'dwi.saputro03@homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Aisyah Desinta Sari', 'asari48', 'aisyah.sari48@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Muhammad Fauzi S', 'ms08', 'muhammad.s08@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Sutari Seprilianti', 'sseprilianti', 'sutari.seprilianti@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Retno Eka Dewi', 'rdewi24', 'retno.dewi24@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Desy Maryati', 'dmaryati', 'desy.maryati@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Wulan Isdiati', 'wisdiati', 'wulan.isdiati@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Sadriana Ria', 'sadriana', 'sadriana@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Ika Rusyani', 'irusyani', 'ika.rusyani@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Syifa Inayanti', 'sinayati', 'syifa.inayati@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Windi Patmania', 'wpatmania', 'windi.patmania@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Ari Ranaldo', 'aranaldo', 'ari.ranaldo@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Sadam Hasan', 'shasam', 'sadam.hasam@ext.homecredit.co.id','View Only Access')
INSERT INTO @list_peserta ( nama, username, email, tipe ) VALUES ('Sandy Supartino', 'ssupartino', 'sandy.supartino@ext.homecredit.co.id','View Only Access')

DECLARE
	@nama VARCHAR(100),
	@username VARCHAR(15),
	@email VARCHAR(100),
	@tipe VARCHAR(50)

DECLARE list_cursor CURSOR FOR  
SELECT nama, username, email, tipe
FROM @list_peserta 

OPEN list_cursor  
FETCH NEXT FROM list_cursor INTO @nama, @username, @email, @tipe

WHILE @@FETCH_STATUS = 0  
BEGIN  

	INSERT INTO [dbo].[custport_m_user]
			   ([username]
			   ,[fullname]
			   ,[email]
			   ,[user_type_code]
			   ,[password]
			   ,[created_by]
			   ,[created_date]
			   ,[modified_by]
			   ,[modified_date]
			   ,[is_active])
		 VALUES
			   (@username
			   ,@nama
			   ,@email
			   ,'up'
			   ,@v_password
			   ,'SYS'
			   ,GETDATE()
			   ,'SYS'
			   ,GETDATE()
			   ,1)
	IF LOWER(@tipe)='view only access'
		BEGIN
			INSERT INTO [dbo].[custport_m_user_group_menu]
					   ([group_menu_id]
					   ,[username]
					   ,[created_by]
					   ,[created_date]
					   ,[modified_by]
					   ,[modified_date]
					   ,[is_active])
				 VALUES
					   (4
					   ,@username
					   ,'SYS'
					   ,GETDATE()
					   ,'SYS'
					   ,GETDATE()
					   ,1)
		END
	ELSE IF LOWER(@tipe)='inpayment team'
		BEGIN
			INSERT INTO [dbo].[custport_m_user_group_menu]
					   ([group_menu_id]
					   ,[username]
					   ,[created_by]
					   ,[created_date]
					   ,[modified_by]
					   ,[modified_date]
					   ,[is_active])
				 VALUES
					   (2
					   ,@username
					   ,'SYS'
					   ,GETDATE()
					   ,'SYS'
					   ,GETDATE()
					   ,1)
		END
	ELSE IF LOWER(@tipe)='claim access'
		BEGIN
			INSERT INTO [dbo].[custport_m_user_group_menu]
					   ([group_menu_id]
					   ,[username]
					   ,[created_by]
					   ,[created_date]
					   ,[modified_by]
					   ,[modified_date]
					   ,[is_active])
				 VALUES
					   (1
					   ,@username
					   ,'SYS'
					   ,GETDATE()
					   ,'SYS'
					   ,GETDATE()
					   ,1)
			INSERT INTO [dbo].[custport_m_user_group_menu]
					   ([group_menu_id]
					   ,[username]
					   ,[created_by]
					   ,[created_date]
					   ,[modified_by]
					   ,[modified_date]
					   ,[is_active])
				 VALUES
					   (4
					   ,@username
					   ,'SYS'
					   ,GETDATE()
					   ,'SYS'
					   ,GETDATE()
					   ,1)
		END

  FETCH NEXT FROM list_cursor INTO @nama, @username, @email, @tipe
END  

CLOSE list_cursor  
DEALLOCATE list_cursor 