begin;
--insert
CREATE table mstr.m_commission_20200225 AS (
    SELECT * from mstr.m_commission
);

INSERT INTO mstr.tt_migrasi_master_commission(session_id, ou_code_alias, product_code, role_name, year_month_start, year_month_end, acc_amount, tindakan_1_amount, tindakan_2_amount, tindakan_3_amount) VALUES
('sts123_2020022516', '', 'TMIN025', 'DOKTER', '202002', '300012', 0, 12000, 0, 0),
('sts123_2020022516', '', 'TMIN026', 'DOKTER', '202002', '300012', 0, 16000, 0, 0),
('sts123_2020022516', '', 'TMIN027', 'DOKTER', '202002', '300012', 0, 12000, 0, 0),
('sts123_2020022516', '', 'TMIN028', 'DOKTER', '202002', '300012', 0, 16000, 0, 0),
('sts123_2020022516', '', 'TMCA005', 'DOKTER', '202002', '300012', 0, 40000, 0, 0),
('sts123_2020022516', '', 'TMCA006', 'DOKTER', '202002', '300012', 0, 45000, 0, 0),
('sts123_2020022516', '', 'TMIN025', 'NONDOKTER', '202002', '300012', 0, 0, 0, 0),
('sts123_2020022516', '', 'TMIN026', 'NONDOKTER', '202002', '300012', 0, 0, 0, 0),
('sts123_2020022516', '', 'TMIN027', 'NONDOKTER', '202002', '300012', 0, 0, 0, 0),
('sts123_2020022516', '', 'TMIN028', 'NONDOKTER', '202002', '300012', 0, 0, 0, 0),
('sts123_2020022516', '', 'TMCA005', 'NONDOKTER', '202002', '300012', 0, 0, 0, 5000),
('sts123_2020022516', '', 'TMCA006', 'NONDOKTER', '202002', '300012', 0, 0, 0, 5000);

select f_migrate_master_commission('sts123_2020022516',-2,'20200225150000');

end;