btn-mdw-ace-server-local/mwapp/migration/000.MWAPP_INITDB.sql

INSERT INTO MWAPP."ATTRIBUTE" (TYPE, NAME, DESCRIPTION, MODIFIED_BY, TIMESTAMP) VALUES
    ('DEVICE_TELLER_GROUP', 'ibb', 'IBB', CURRENT USER, CURRENT TIMESTAMP),
    ('Type', 'TEST123456', 'Description', CURRENT USER, CURRENT TIMESTAMP),
    ('ROLE_TYPE', 'MWUI', 'Role Type for MWUI Application', CURRENT USER, CURRENT TIMESTAMP),
    ('ROLE_TYPE', 'REKON', 'Role Type for Rekon Application', CURRENT USER, CURRENT TIMESTAMP),
    ('DEVICE_TELLER_GROUP', 'itm', 'ATM', CURRENT USER, CURRENT TIMESTAMP),
    ('DEVICE_TELLER_GROUP', 'sms', 'SMS', CURRENT USER, CURRENT TIMESTAMP),
    ('DEVICE_TELLER_GROUP', 'pos', 'POS', CURRENT USER, CURRENT TIMESTAMP),
    ('rekon', 'TEST', 'test rekon', CURRENT USER, CURRENT TIMESTAMP),
    ('DEVICE_TELLER_GROUP', 'cdm', 'CDM', CURRENT USER, CURRENT TIMESTAMP),
    ('print_type', '3', 'JReport Type', CURRENT USER, CURRENT TIMESTAMP),
    ('ftp_type', '3', 'Download FTP ZIP FILE', CURRENT USER, CURRENT TIMESTAMP),
    ('updatedb_type', '1', 'Query to Query', CURRENT USER, CURRENT TIMESTAMP),
    ('updatedb_type', '2', 'Custom', CURRENT USER, CURRENT TIMESTAMP),
    ('col_type', '3', 'Velocity and Fixed', CURRENT USER, CURRENT TIMESTAMP),
    ('print_type', '1', 'Velocity Type', CURRENT USER, CURRENT TIMESTAMP),
    ('print_type', '2', 'Jasper Type', CURRENT USER, CURRENT TIMESTAMP),
    ('schedule_type', '1', 'Daily', CURRENT USER, CURRENT TIMESTAMP),
    ('schedule_type', '2', 'Custom', CURRENT USER, CURRENT TIMESTAMP),
    ('compare_type', '1', 'Compare to database', CURRENT USER, CURRENT TIMESTAMP),
    ('compare_type', '2', 'Compare to file', CURRENT USER, CURRENT TIMESTAMP),
    ('report_type', '1', 'Daily', CURRENT USER, CURRENT TIMESTAMP),
    ('report_type', '2', 'Monthly', CURRENT USER, CURRENT TIMESTAMP),
    ('recon_type', '1', 'FTP', CURRENT USER, CURRENT TIMESTAMP),
    ('recon_type', '2', 'File2DB', CURRENT USER, CURRENT TIMESTAMP),
    ('recon_type', '3', 'JoinFile', CURRENT USER, CURRENT TIMESTAMP),
    ('recon_type', '4', 'CompareFile', CURRENT USER, CURRENT TIMESTAMP),
    ('recon_type', '5', 'PrintText', CURRENT USER, CURRENT TIMESTAMP),
    ('recon_type', '6', 'UpdateDB', CURRENT USER, CURRENT TIMESTAMP),
    ('recon_type', '7', 'FileBlob', CURRENT USER, CURRENT TIMESTAMP),
    ('recon_type', '8', 'FTPS', CURRENT USER, CURRENT TIMESTAMP),
    ('IREKON', 'CMS', ' TYPE = "iso-8583-cms" AND DIR = "I" ', CURRENT USER, CURRENT TIMESTAMP),
    ('ftp_type', '1', 'Download FTP', CURRENT USER, CURRENT TIMESTAMP),
    ('ftp_type', '2', 'Upload FTP', CURRENT USER, CURRENT TIMESTAMP),
    ('col_type', '1', 'Fixed Length', CURRENT USER, CURRENT TIMESTAMP),
    ('col_type', '2', 'Comma Separated', CURRENT USER, CURRENT TIMESTAMP),
    ('compare_type', '1', 'Compare to database', CURRENT USER, CURRENT TIMESTAMP),
    ('compare_type', '2', 'Compare to file', CURRENT USER, CURRENT TIMESTAMP),
    ('IREKON', 'BDS', ' TYPE = "dsp-abcs-request" AND source LIKE "bds-%" AND DIR = "I" ', CURRENT USER, CURRENT TIMESTAMP),
    ('IREKON', 'DMS', ' TYPE = "http://*" AND (CODE LIKE "%los%" OR CODE LIKE "%crms%" OR CODE LIKE "%dokpok%") AND DIR = "I" ', CURRENT USER, CURRENT TIMESTAMP),
    ('IREKON', 'EVA', ' TYPE = "iso-8583-eva" AND DIR = "I" ', CURRENT USER, CURRENT TIMESTAMP),
    ('IREKON', 'IVR', ' TYPE = "iso-8583-ivr" AND DIR = "I" ', CURRENT USER, CURRENT TIMESTAMP),
    ('IREKON', 'POS', ' TYPE = "iso-8583-pos-abcs" AND DIR = "I" ', CURRENT USER, CURRENT TIMESTAMP),
    ('IREKON', 'PPO', ' TYPE = "iso-8583-ppo" AND DIR = "I" ', CURRENT USER, CURRENT TIMESTAMP),
    ('IREKON', 'SMS', ' TYPE = "iso-8583-sms" AND DIR = "I" ', CURRENT USER, CURRENT TIMESTAMP),
    ('IREKON', 'WEB', ' TYPE = "iso-8583-wb" AND DIR = "I" ', CURRENT USER, CURRENT TIMESTAMP),
    ('IREKON', 'WES', ' SOURCE LIKE "%WS_GENERIC%" AND DIR = "I" ', CURRENT USER, CURRENT TIMESTAMP),
    ('IREKON', 'PGD', ' TYPE = "iso-8583-wb" AND DIR = "I" ', CURRENT USER, CURRENT TIMESTAMP),
    ('IREKON', 'ITM', ' TYPE = "iso-8583-itm" AND DIR = "I" ', CURRENT USER, CURRENT TIMESTAMP);

INSERT INTO MWAPP.EOD_CONFIG (CODE, EOD_STATUS, MODIFIED_BY, MODIFIED_DATE) VALUES
    ('EOD', 0, CURRENT USER, CURRENT TIMESTAMP);


INSERT INTO MWAPP.PRIVILEGE (ID, NAME, TYPE, PATH, PARENT, PRIORITY, STATUS, MODIFIED_BY, TIMESTAMP) VALUES
    ('ADAPTOR_PARAM', 'Adaptor Param', 'PRIV_TYPE_MENU', './adaptorParam.do?action=list&clear=true', 'CONFIGURATION', 10, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('ADAPTOR_PARAM_CREATE', 'Adaptor Param Create', 'PRIV_TYPE_MENU', './adaptorParam.do?action=create&clear=true', 'ADAPTOR_PARAM', 20, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('ADAPTOR_PARAM_LIST', 'Adaptor Param List', 'PRIV_TYPE_MENU', './adaptorParam.do?action=list&clear=true', 'ADAPTOR_PARAM', 10, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('ADAPTOR_PARAM_UPDATE', 'Adaptor Param Update', 'PRIV_TYPE_MENU', './adaptorParam.do?action=edit&clear=true', 'ADAPTOR_PARAM', 30, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('ADMIN', 'PLUG-IN ADMIN', 'PRIV_TYPE_MENU', './', NULL, 50, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('ADMIN_REPORT', 'Report Admin', 'PRIV_TYPE_MENU', './report.do?action=list&clear=true', 'EPAYMENT_ADMIN', 50, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('ADMIN_REPORT_CREATE', 'Admin Report Create', 'PRIV_TYPE_MENU', './report.do?action=create&clear=true', 'ADMIN_REPORT', 20, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('ADMIN_REPORT_LIST', 'Admin Report List', 'PRIV_TYPE_MENU', './report.do?action=list&clear=true', 'ADMIN_REPORT', 10, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('ADMIN_REPORT_UPDATE', 'Admin Report Update', 'PRIV_TYPE_MENU', './report.do?action=edit&clear=true', 'ADMIN_REPORT', 30, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('APP_CONFIG', 'APP CONFIG', 'PRIV_TYPE_MENU', './', NULL, 10, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('APP_SETTING', 'Application Setting', 'PRIV_TYPE_MENU', './appSetting.do?action=list&clear=true', 'EPAYMENT_ADMIN', 10, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('APP_SETTING_CREATE', 'Application Setting Create', 'PRIV_TYPE_MENU', './appSetting.do?action=create&clear=true', 'APP_SETTING', 20, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('APP_SETTING_LIST', 'Application Setting List', 'PRIV_TYPE_MENU', './appSetting.do?action=list&clear=true', 'APP_SETTING', 10, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('APP_SETTING_UPDATE', 'Application Setting Update', 'PRIV_TYPE_MENU', './appSetting.do?action=edit&clear=true', 'APP_SETTING', 30, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('APP_USER', 'Application User', 'PRIV_TYPE_MENU', './appUser.do?action=list&clear=true', 'BILLER', 10, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('APP_USER_CREATE', 'Application User Create', 'PRIV_TYPE_MENU', './appUser.do?action=create&clear=true', 'APP_USER', 20, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('APP_USER_LIST', 'Application User List', 'PRIV_TYPE_MENU', './appUser.do?action=list&clear=true', 'APP_USER', 10, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('APP_USER_UPDATE', 'Application User Update', 'PRIV_TYPE_MENU', './appUser.do?action=edit&clear=true', 'APP_USER', 30, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('ATTRIBUTE', 'Attribute', 'PRIV_TYPE_MENU', './attribute.do?action=list&clear=true', 'APP_CONFIG', 10, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('ATTRIBUTE_CREATE', 'Attribute Create', 'PRIV_TYPE_MENU', './attribute.do?action=create&clear=true', 'ATTRIBUTE', 20, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('ATTRIBUTE_LIST', 'Attribute List', 'PRIV_TYPE_MENU', './attribute.do?action=list&clear=true', 'ATTRIBUTE', 10, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('ATTRIBUTE_UPDATE', 'Attribute Update', 'PRIV_TYPE_MENU', './attribute.do?action=edit&clear=true', 'ATTRIBUTE', 30, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('BILLER', 'BILLER', 'PRIV_TYPE_MENU', './', NULL, 310, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('BILLER_CAT', 'Biller Category', 'PRIV_TYPE_MENU', './billerCategory.do?action=list&clear=true', 'EPAYMENT_ADMIN', 20, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('BILLER_CAT_CREATE', 'Biller Category Create', 'PRIV_TYPE_MENU', './billerCategory.do?action=create&clear=true', 'BILLER_CAT', 20, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('BILLER_CAT_LIST', 'Biller Category List', 'PRIV_TYPE_MENU', './billerCategory.do?action=list&clear=true', 'BILLER_CAT', 10, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('BILLER_CAT_UPDATE', 'Biller Category Update', 'PRIV_TYPE_MENU', './billerCategory.do?action=edit&clear=true', 'BILLER_CAT', 30, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('BILLER_CONFIG', 'Biller Configuration', 'PRIV_TYPE_MENU', './nhBillerConfig.do?action=list&clear=true', 'BILLER', 20, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('BILLER_CONFIG_CREATE', 'Biller Configuration Create', 'PRIV_TYPE_MENU', './nhBillerConfig.do?action=create&clear=true', 'BILLER_CONFIG', 20, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('BILLER_CONFIG_LIST', 'Biller Configuration List', 'PRIV_TYPE_MENU', './nhBillerConfig.do?action=list&clear=true', 'BILLER_CONFIG', 10, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('BILLER_CONFIG_UPDATE', 'Biller Configuration Update', 'PRIV_TYPE_MENU', './nhBillerConfig.do?action=edit&clear=true', 'BILLER_CONFIG', 30, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('BILLER_DATA', 'Biller Data', 'PRIV_TYPE_MENU', './billerData.do?action=list&clear=true', 'BILLER', 30, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('BILLER_DATA_CREATE', 'Biller Data Create', 'PRIV_TYPE_MENU', './billerData.do?action=create&clear=true', 'BILLER_DATA', 20, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('BILLER_DATA_LIST', 'Biller Data List', 'PRIV_TYPE_MENU', './billerData.do?action=list&clear=true', 'BILLER_DATA', 10, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('BILLER_DATA_UPDATE', 'Biller Data Update', 'PRIV_TYPE_MENU', './billerData.do?action=edit&clear=true', 'BILLER_DATA', 30, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('BILLER_GROUP_MAINTENANCE', ' Manage Group', 'PRIV_TYPE_MENU', './billerGroup.do?action=edit&clear=true', 'BILLER', 40, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('CHARGES', 'Charges', 'PRIV_TYPE_MENU', './charges.do?action=list&clear=true', 'CONFIGURATION', 20, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('CHARGES_LIST', 'Charges List', 'PRIV_TYPE_MENU', './charges.do?action=list&clear=true', 'CHARGES', 10, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('CHARGES_UPDATE', 'Charges Update', 'PRIV_TYPE_MENU', './charges.do?action=edit&clear=true', 'CHARGES', 30, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('CLEANER_CONFIG', 'CLEANER CONFIG', 'PRIV_TYPE_MENU', './cleaner.do?action=cleaner&clear=true', NULL, 710, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('CLIENT', 'Client', 'PRIV_TYPE_MENU', './adaptor.do?action=client_list&clear=true', 'CONFIGURATION', 30, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('CLIENT_CREATE', 'Client Create', 'PRIV_TYPE_MENU', './adaptor.do?action=client_create&clear=true', 'CLIENT', 20, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('CLIENT_LIST', 'Client List', 'PRIV_TYPE_MENU', './adaptor.do?action=client_list&clear=true', 'CLIENT', 10, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('CLIENT_UPDATE', 'Client Update', 'PRIV_TYPE_MENU', './adaptor.do?action=client_edit&clear=true', 'CLIENT', 30, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('CODEX', 'Codex', 'PRIV_TYPE_MENU', './codex.do?action=list&clear=true', 'CONFIGURATION', 40, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('CODEX_CREATE', 'Codex Create', 'PRIV_TYPE_MENU', './codex.do?action=create&clear=true', 'CODEX', 20, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('CODEX_LIST', 'Codex List', 'PRIV_TYPE_MENU', './codex.do?action=list&clear=true', 'CODEX', 10, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('CODEX_UPDATE', 'Codex Update', 'PRIV_TYPE_MENU', './codex.do?action=edit&clear=true', 'CODEX', 30, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('CONFIGURATION', 'PLUG-IN CONFIG', 'PRIV_TYPE_MENU', './', NULL, 60, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('DATABASE_CONNECTION', 'Database Connection', 'PRIV_TYPE_MENU', './databaseConnection.do?action=list&clear=true', 'REKON', 20, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('DATABASE_CONNECTION_CREATE', 'Database Connection Create', 'PRIV_TYPE_MENU', './databaseConnection.do?action=create&clear=true', 'DATABASE_CONNECTION', 20, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('DATABASE_CONNECTION_LIST', 'Database Connection List', 'PRIV_TYPE_MENU', './databaseConnection.do?action=list&clear=true', 'DATABASE_CONNECTION', 10, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('DATABASE_CONNECTION_UPDATE', 'Database Connection Update', 'PRIV_TYPE_MENU', './databaseConnection.do?action=edit&clear=true', 'DATABASE_CONNECTION', 30, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('DATA_QUERY', 'Data Query', 'PRIV_TYPE_MENU', './dataQuery.do?action=list&clear=true', 'REKON', 10, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('DATA_QUERY_CREATE', 'Data Query Create', 'PRIV_TYPE_MENU', './dataQuery.do?action=create&clear=true', 'DATA_QUERY', 20, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('DATA_QUERY_LIST', 'Data Query List', 'PRIV_TYPE_MENU', './dataQuery.do?action=list&clear=true', 'DATA_QUERY', 10, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('DATA_QUERY_UPDATE', 'Data Query Update', 'PRIV_TYPE_MENU', './dataQuery.do?action=edit&clear=true', 'DATA_QUERY', 30, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('DB_CONN', 'DB Connection', 'PRIV_TYPE_MENU', './dbconn.do?action=list&clear=true', 'CONFIGURATION', 50, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('DB_CONN_CREATE', 'DB Connection Create', 'PRIV_TYPE_MENU', './dbconn.do?action=create&clear=true', 'DB_CONN', 20, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('DB_CONN_LIST', 'DB Connection List', 'PRIV_TYPE_MENU', './dbconn.do?action=list&clear=true', 'DB_CONN', 10, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('DB_CONN_UPDATE', 'DB Connection Update', 'PRIV_TYPE_MENU', './dbconn.do?action=edit&clear=true', 'DB_CONN', 30, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('DB_QUERY', 'DB Query', 'PRIV_TYPE_MENU', './dbquery.do?action=list&clear=true', 'CONFIGURATION', 60, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('DB_QUERY_CREATE', 'DB Query Create', 'PRIV_TYPE_MENU', './dbquery.do?action=create&clear=true', 'DB_QUERY', 20, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('DB_QUERY_LIST', 'DB Query List', 'PRIV_TYPE_MENU', './dbquery.do?action=list&clear=true', 'DB_QUERY', 10, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('DB_QUERY_UPDATE', 'DB Query Update', 'PRIV_TYPE_MENU', './dbquery.do?action=edit&clear=true', 'DB_QUERY', 30, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('DEVICE_TELLER', 'Device Teller', 'PRIV_TYPE_MENU', './devTellerMap.do?action=list&clear=true', 'CONFIGURATION', 70, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('DEVICE_TELLER_CREATE', 'Device Teller Create', 'PRIV_TYPE_MENU', './devTellerMap.do?action=create&clear=true', 'DEVICE_TELLER', 20, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('DEVICE_TELLER_LIST', 'Device Teller List', 'PRIV_TYPE_MENU', './devTellerMap.do?action=list&clear=true', 'DEVICE_TELLER', 10, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('DEVICE_TELLER_UPDATE', 'Device Teller Update', 'PRIV_TYPE_MENU', './devTellerMap.do?action=edit&clear=true', 'DEVICE_TELLER', 30, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('EDC', 'EDC', 'PRIV_TYPE_MENU', './paramMap.do?action=list&clear=true', 'CONFIGURATION', 110, 'ACTIVE', 'wpsadmindev', '2023-08-22 15:20:25.517000'),
    ('ENCRYPT', 'Encrypt Password', 'PRIV_TYPE_MENU', './encryptPassword.do?&clear=true&action=encryp', 'CONFIGURATION', 990, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('EOD_CONFIG', 'EOD CONFIG', 'PRIV_TYPE_MENU', './eodConfig.do?action=status&clear=true', NULL, 20, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('EPAYMENT_ADMIN', 'EPAYMENT ADMIN', 'PRIV_TYPE_MENU', './', NULL, 320, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('EPAY_PRIVILEGE', 'Epayment Privilege', 'PRIV_TYPE_MENU', './epayPrivilege.do?action=list&clear=true', 'EPAYMENT_ADMIN', 30, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('EPAY_PRIVILEGE_CREATE', 'Epayment Privilege Create', 'PRIV_TYPE_MENU', './epayPrivilege.do?action=create&clear=true', 'EPAY_PRIVILEGE', 20, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('EPAY_PRIVILEGE_LIST', 'Epayment Privilege List', 'PRIV_TYPE_MENU', './epayPrivilege.do?action=list&clear=true', 'EPAY_PRIVILEGE', 10, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('EPAY_PRIVILEGE_UPDATE', 'Epayment Privilege Update', 'PRIV_TYPE_MENU', './epayPrivilege.do?action=edit&clear=true', 'EPAY_PRIVILEGE', 30, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('EPAY_ROLE', 'Epayment Role', 'PRIV_TYPE_MENU', './epayRole.do?action=list&clear=true', 'EPAYMENT_ADMIN', 40, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('EPAY_ROLE_CREATE', 'Epayment Role Create', 'PRIV_TYPE_MENU', './epayRole.do?action=create&clear=true', 'EPAY_ROLE', 20, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('EPAY_ROLE_LIST', 'Epayment Role List', 'PRIV_TYPE_MENU', './epayRole.do?action=list&clear=true', 'EPAY_ROLE', 10, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('EPAY_ROLE_UPDATE', 'Epayment Role Update', 'PRIV_TYPE_MENU', './epayRole.do?action=edit&clear=true', 'EPAY_ROLE', 30, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('ERROR_MAP', 'Error Map', 'PRIV_TYPE_MENU', './errorMap.do?action=list&clear=true', 'CONFIGURATION', 80, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('ERROR_MAP_CREATE', 'Error Map Create', 'PRIV_TYPE_MENU', './errorMap.do?action=create&clear=true', 'ERROR_MAP', 20, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('ERROR_MAP_LIST', 'Error Map List', 'PRIV_TYPE_MENU', './errorMap.do?action=list&clear=true', 'ERROR_MAP', 10, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('ERROR_MAP_UPDATE', 'Error Map Update', 'PRIV_TYPE_MENU', './errorMap.do?action=edit&clear=true', 'ERROR_MAP', 30, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('HOST', 'Host', 'PRIV_TYPE_MENU', './host.do?action=list&clear=true', 'CONFIGURATION', 90, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('HOST_CREATE', 'Host Create', 'PRIV_TYPE_MENU', './host.do?action=create&clear=true', 'HOST', 20, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('HOST_LIST', 'Host List', 'PRIV_TYPE_MENU', './host.do?action=list&clear=true', 'HOST', 10, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('HOST_UPDATE', 'Host Update', 'PRIV_TYPE_MENU', './host.do?action=edit&clear=true', 'HOST', 30, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('LOG_ACTIVITY', 'LOG ACTIVITY', 'PRIV_TYPE_MENU', './nhLogActivity.do?action=list&clear=true', NULL, 30, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('LOG_MESSAGE', 'LOG MESSAGE', 'PRIV_TYPE_MENU', './dlog.do?action=list&clear=true', NULL, 40, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('MAPPING', 'Mapping', 'PRIV_TYPE_MENU', './mapping.do?action=list&clear=true', 'CONFIGURATION', 100, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('MAPPING_CREATE', 'Mapping Create', 'PRIV_TYPE_MENU', './mapping.do?action=create&clear=true', 'MAPPING', 20, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('MAPPING_LIST', 'Mapping List', 'PRIV_TYPE_MENU', './mapping.do?action=list&clear=true', 'MAPPING', 10, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('MONITOR_CONFIG', 'MONITORING', 'PRIV_TYPE_MENU', './monitor.do?action=monitor&clear=true', NULL, 720, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('MONITOR_CONFIG_STATS', 'MONITORING STATS', 'PRIV_TYPE_MENU', './monitor.do?action=monitor_stats&clear=true', NULL, 730, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('PARAM_MAP', 'Param Map', 'PRIV_TYPE_MENU', './paramMap.do?action=list&clear=true', 'CONFIGURATION', 110, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('PARAM_MAP_CREATE', 'Param Map Create', 'PRIV_TYPE_MENU', './paramMap.do?action=create&clear=true', 'PARAM_MAP', 20, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('PARAM_MAP_LIST', 'Param Map List', 'PRIV_TYPE_MENU', './paramMap.do?action=list&clear=true', 'PARAM_MAP', 10, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('PARAM_MAP_UPDATE', 'Param Map Update', 'PRIV_TYPE_MENU', './paramMap.do?action=edit&clear=true', 'PARAM_MAP', 30, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('PARSER', 'Parser', 'PRIV_TYPE_MENU', './parser.do?action=list&clear=true', 'CONFIGURATION', 120, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('PARSER_CREATE', 'Parser Create', 'PRIV_TYPE_MENU', './parser.do?action=create&clear=true', 'PARSER', 20, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('PARSER_LIST', 'Parser List', 'PRIV_TYPE_MENU', './parser.do?action=list&clear=true', 'PARSER', 10, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('PARSER_UPDATE', 'Parser Update', 'PRIV_TYPE_MENU', './parser.do?action=edit&clear=true', 'PARSER', 30, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('PERTAMINA', 'PERTAMINA', 'PRIV_TYPE_MENU', './', NULL, 610, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('PERTAMINA_EBS', 'Pertamina EBS', 'PRIV_TYPE_MENU', './pertaminaAction.do?action=list&clear=true', 'PERTAMINA', 20, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('PRIMA', 'PRIMA', 'PRIV_TYPE_MENU', './', NULL, 510, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('PRIMA_RECON', 'Rekon Prima', 'PRIV_TYPE_MENU', './rekonPrima.do?action=list&clear=true', 'PRIMA', 20, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('PRIVILEGE', 'Privilege', 'PRIV_TYPE_MENU', './privilege.do?action=list&clear=true', 'ADMIN', 10, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('PRIVILEGE_CREATE', 'Privilege Create', 'PRIV_TYPE_MENU', './privilege.do?action=create&clear=true', 'PRIVILEGE', 20, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('PRIVILEGE_LIST', 'Privilege List', 'PRIV_TYPE_MENU', './privilege.do?action=list&clear=true', 'PRIVILEGE', 10, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('PRIVILEGE_UPDATE', 'Privilege Update', 'PRIV_TYPE_MENU', './privilege.do?action=edit&clear=true', 'PRIVILEGE', 30, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('RECON_DEPAG', 'DEPAG-SYARIAH', 'PRIV_TYPE_MENU', './', NULL, 490, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('RECON_DEPAG_RECON', 'Rekon Harian Syariah', 'PRIV_TYPE_MENU', './rekonDepag.do?action=list&clear=true', 'RECON_DEPAG', 20, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('RECON_KONVEN', 'DEPAG-KONVEN', 'PRIV_TYPE_MENU', './', NULL, 500, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('RECON_KONVEN_RECON', 'Rekon Harian Konven', 'PRIV_TYPE_MENU', './rekonKonven.do?action=list&clear=true', 'RECON_KONVEN', 20, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('RECON_MKM', 'MKM', 'PRIV_TYPE_MENU', './', NULL, 520, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('RECON_MKM_PLNNTL', 'PLN Non Tagihan Listrik', 'PRIV_TYPE_MENU', './rekonMkmPlnNtl.do?action=list&clear=true', 'RECON_MKM', 40, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('RECON_MKM_PLNPOS', 'PLN Postpaid', 'PRIV_TYPE_MENU', './rekonMkmPlnPos.do?action=list&clear=true', 'RECON_MKM', 30, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('RECON_MKM_PLNPRE', 'PLN Prepaid', 'PRIV_TYPE_MENU', './', 'RECON_MKM', 20, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('RECON_MKM_PLNPRE_RECON', 'Reconciliation Process', 'PRIV_TYPE_MENU', './rekonMkmPlnPre.do?action=list&clear=true', 'RECON_MKM_PLNPRE', 10, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('RECON_MKM_PLNPRE_TOKEN', 'Token Request', 'PRIV_TYPE_MENU', './tokenRequestMkmPlnPre.do?action=list&clear=true', 'RECON_MKM_PLNPRE', 20, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('RECON_SYB', 'SYB', 'PRIV_TYPE_MENU', './', NULL, 30, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('RECON_SYB_FIF', 'FIF', 'PRIV_TYPE_MENU', './rekonFIF.do?action=list&clear=true', 'RECON_SYB', 30, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('RECON_SYB_KAI', 'KAI', 'PRIV_TYPE_MENU', './rekonKAI.do?action=list&clear=true', 'RECON_SYB', 30, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('RECON_SYB_PLN_NONTAG_RECON', 'Non Tag PLN', 'PRIV_TYPE_MENU', './rekonPlnNonTag.do?action=list&clear=true', 'RECON_SYB', 40, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('RECON_SYB_POSPLN', 'PostPaid PLN', 'PRIV_TYPE_MENU', './rekonPostPaidPLN.do?action=list&clear=true', 'RECON_SYB', 30, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('RECON_SYB_PREPLN', 'PrePaid PLN', 'PRIV_TYPE_MENU', './', 'RECON_SYB', 20, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('RECON_SYB_PREPLN_RECON', 'Reconciliation Process', 'PRIV_TYPE_MENU', './rekon.do?action=list&clear=true', 'RECON_SYB_PREPLN', 10, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('RECON_SYB_PREPLN_TOKEN', 'Token Request', 'PRIV_TYPE_MENU', './tokenRequestPln.do?action=list&clear=true', 'RECON_SYB_PREPLN', 20, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('REKON', 'REKON', 'PRIV_TYPE_MENU', './', NULL, 510, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('REKON_CONFIG', 'Rekon Config', 'PRIV_TYPE_MENU', './rekonConfig.do?action=list&clear=true', 'REKON', 30, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('REKON_CONFIG_CREATE', 'Rekon Create', 'PRIV_TYPE_MENU', './rekonConfig.do?action=create&clear=true', 'REKON_CONFIG', 20, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('REKON_CONFIG_LIST', 'Rekon List', 'PRIV_TYPE_MENU', './rekonConfig.do?action=list&clear=true', 'REKON_CONFIG', 10, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('REKON_CONFIG_UPDATE', 'Rekon Update', 'PRIV_TYPE_MENU', './rekonConfig.do?action=edit&clear=true', 'REKON_CONFIG', 30, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('REKON_KONVEN_BULANAN', 'Laporan Bulanan Konven', 'PRIV_TYPE_MENU', './rekonKonven.do?action=list_monthly&clear=true', 'RECON_KONVEN', 21, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('REKON_SYARIAH_BULANAN', 'Laporan Bulanan Syariah', 'PRIV_TYPE_MENU', './', 'RECON_DEPAG', 21, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('ROLE', 'Role', 'PRIV_TYPE_MENU', './role.do?action=list&clear=true', 'ADMIN', 20, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('ROLE_CREATE', 'Role Create', 'PRIV_TYPE_MENU', './role.do?action=create&clear=true', 'ROLE', 20, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('ROLE_LIST', 'Role List', 'PRIV_TYPE_MENU', './role.do?action=list&clear=true', 'ROLE', 10, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('ROLE_UPDATE', 'Role Update', 'PRIV_TYPE_MENU', './role.do?action=edit&clear=true', 'ROLE', 30, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('ROUTING_TABLE', 'Routing Table', 'PRIV_TYPE_MENU', './routingTable.do?action=list&clear=true', 'CONFIGURATION', 130, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('ROUTING_TABLE_CREATE', 'Routing Table Create', 'PRIV_TYPE_MENU', './routingTable.do?action=create&clear=true', 'ROUTING_TABLE', 20, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('ROUTING_TABLE_LIST', 'Routing Table List', 'PRIV_TYPE_MENU', './routingTable.do?action=list&clear=true', 'ROUTING_TABLE', 10, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('ROUTING_TABLE_UPDATE', 'Routing Table Update', 'PRIV_TYPE_MENU', './routingTable.do?action=edit&clear=true', 'ROUTING_TABLE', 30, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('RPG_CALL', 'RPG Call', 'PRIV_TYPE_MENU', './rpgCall.do?action=list&clear=true', 'CONFIGURATION', 140, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('RPG_CALL_CREATE', 'RPG Call Create', 'PRIV_TYPE_MENU', './rpgCall.do?action=create&clear=true', 'RPG_CALL', 20, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('RPG_CALL_LIST', 'RPG Call List', 'PRIV_TYPE_MENU', './rpgCall.do?action=list&clear=true', 'RPG_CALL', 10, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('RPG_CALL_UPDATE', 'RPG Call Update', 'PRIV_TYPE_MENU', './rpgCall.do?action=edit&clear=true', 'RPG_CALL', 30, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SEP_ADMIN', 'Separator Admin', 'PRIV_TYPE_MENU', './', 'ADMIN', 5, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SEP_ADMIN_PLUGIN_PRIVILEGE', 'Separator Admin Plugin privilege', 'PRIV_TYPE_MENU', './', 'ADMIN', 15, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SEP_ADMIN_PLUGIN_ROLE', 'Separator Admin Plugin role', 'PRIV_TYPE_MENU', './', 'ADMIN', 25, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SEP_ADMIN_REPORT', 'Separator Administration Report', 'PRIV_TYPE_MENU', './', 'EPAYMENT_ADMIN', 55, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SEP_APP_CONFIG', 'Separator App Config', 'PRIV_TYPE_MENU', './', 'APP_CONFIG', 5, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SEP_APP_SETTING', 'Separator Application Setting', 'PRIV_TYPE_MENU', './', 'EPAYMENT_ADMIN', 15, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SEP_APP_USER', 'Separator Application User', 'PRIV_TYPE_MENU', './', 'BILLER', 15, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SEP_ATTRIBUTE', 'Separator Attribute', 'PRIV_TYPE_MENU', './', 'APP_CONFIG', 15, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SEP_BILLER', 'Separator Biller', 'PRIV_TYPE_MENU', './', 'BILLER', 5, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SEP_BILLER_CAT', 'Separator Biller Category', 'PRIV_TYPE_MENU', './', 'EPAYMENT_ADMIN', 25, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SEP_BILLER_CONFIG', 'Separator Biller Config', 'PRIV_TYPE_MENU', './', 'BILLER', 25, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SEP_BILLER_DATA', 'Separator Biller Data', 'PRIV_TYPE_MENU', './', 'BILLER', 35, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SEP_BILLER_GROUP_MAINTENANCE', 'Separator Biller Group Maintenance', 'PRIV_TYPE_MENU', './', 'BILLER', 45, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SEP_BILLER_SYNC_MON', 'Separator Biller Sync Mon', 'PRIV_TYPE_MENU', './', 'BILLER', 55, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SEP_CONFIGURATION', 'Separator Configuration', 'PRIV_TYPE_MENU', './', 'CONFIGURATION', 5, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SEP_CONFIGURATION_ADAPTOR_PARAM', 'Separator Adaptor Param', 'PRIV_TYPE_MENU', './', 'CONFIGURATION', 15, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SEP_CONFIGURATION_CHARGES', 'Separator Charges', 'PRIV_TYPE_MENU', './', 'CONFIGURATION', 25, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SEP_CONFIGURATION_CLIENT', 'Separator Client', 'PRIV_TYPE_MENU', './', 'CONFIGURATION', 35, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SEP_CONFIGURATION_CODEX', 'Separator Codex', 'PRIV_TYPE_MENU', './', 'CONFIGURATION', 45, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SEP_CONFIGURATION_DB_CONN', 'Separator Db Conn', 'PRIV_TYPE_MENU', './', 'CONFIGURATION', 55, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SEP_CONFIGURATION_DB_QUERY', 'Separator Db Query', 'PRIV_TYPE_MENU', './', 'CONFIGURATION', 65, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SEP_CONFIGURATION_DEVICE_TELLER', 'Separator Device Teller', 'PRIV_TYPE_MENU', './', 'CONFIGURATION', 75, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SEP_CONFIGURATION_ENCRYPT', 'Separator Mapping', 'PRIV_TYPE_MENU', './', 'CONFIGURATION', 995, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SEP_CONFIGURATION_ERROR_MAP', 'Separator Error Map', 'PRIV_TYPE_MENU', './', 'CONFIGURATION', 85, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SEP_CONFIGURATION_HOST', 'Separator Host', 'PRIV_TYPE_MENU', './', 'CONFIGURATION', 95, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SEP_CONFIGURATION_MAPPING', 'Separator Mapping', 'PRIV_TYPE_MENU', './', 'CONFIGURATION', 105, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SEP_CONFIGURATION_PARAM_MAP', 'Separator Param Map', 'PRIV_TYPE_MENU', './', 'CONFIGURATION', 115, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SEP_CONFIGURATION_PARSER', 'Separator Parser', 'PRIV_TYPE_MENU', './', 'CONFIGURATION', 125, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SEP_CONFIGURATION_ROUTING_TABLE', 'Separator Routing Table', 'PRIV_TYPE_MENU', './', 'CONFIGURATION', 135, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SEP_CONFIGURATION_RPG_CALL', 'Separator Host', 'PRIV_TYPE_MENU', './', 'CONFIGURATION', 145, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SEP_CONFIGURATION_SERVER_PORT', 'Separator Server Port', 'PRIV_TYPE_MENU', './', 'CONFIGURATION', 155, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SEP_DATABASE_CONNECTION', 'Separator Database Connection', 'PRIV_TYPE_MENU', './', 'REKON', 25, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SEP_DATA_QUERY', 'Separator Data Query', 'PRIV_TYPE_MENU', './', 'REKON', 15, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SEP_EPAYMENT_ADMIN', 'Separator Epayment Admin', 'PRIV_TYPE_MENU', './', 'EPAYMENT_ADMIN', 5, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SEP_EPAY_PRIVILEGE', 'Separator Epayment Privilege', 'PRIV_TYPE_MENU', './', 'EPAYMENT_ADMIN', 35, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SEP_EPAY_ROLE', 'Separator Epayment Role', 'PRIV_TYPE_MENU', './', 'EPAYMENT_ADMIN', 45, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SEP_PERTAMINA', 'Separator PERTAMINA', 'PRIV_TYPE_MENU', './', 'PERTAMINA', 10, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SEP_PRIMA', 'Separator PRIMA', 'PRIV_TYPE_MENU', './', 'PRIMA', 10, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SEP_RECON_DEPAG', 'Separator SYARIAH', 'PRIV_TYPE_MENU', './', 'RECON_DEPAG', 10, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SEP_RECON_KONVEN', 'Separator KONVEN', 'PRIV_TYPE_MENU', './', 'RECON_KONVEN', 10, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SEP_RECON_MKM', 'Separator MKM', 'PRIV_TYPE_MENU', './', 'RECON_MKM', 10, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SEP_RECON_SYB', 'Separator SYB', 'PRIV_TYPE_MENU', './', 'RECON_SYB', 10, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SEP_REKON', 'Separator Attribute', 'PRIV_TYPE_MENU', './', 'REKON', 5, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SEP_REKON_CONFIG', 'Separator Rekon Config', 'PRIV_TYPE_MENU', './', 'REKON', 35, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SEP_SERVER_CONFIG', 'Separator Server Config', 'PRIV_TYPE_MENU', './', 'EPAYMENT_ADMIN', 65, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SERVER_CONFIG', 'Sync Server Status', 'PRIV_TYPE_MENU', './nhServerConfig.do?action=list&clear=true', 'EPAYMENT_ADMIN', 60, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SERVER_PORT', 'Server Port', 'PRIV_TYPE_MENU', './adaptor.do?action=serverPort_list&clear=true', 'CONFIGURATION', 150, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SERVER_PORT_CREATE', 'Server Port Create', 'PRIV_TYPE_MENU', './adaptor.do?action=serverPort_create&clear=true', 'SERVER_PORT', 20, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SERVER_PORT_LIST', 'Server Port List', 'PRIV_TYPE_MENU', './adaptor.do?action=serverPort_list&clear=true', 'SERVER_PORT', 10, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SERVER_PORT_UPDATE', 'Server Port Update', 'PRIV_TYPE_MENU', './adaptor.do?action=serverPort_edit&clear=true', 'SERVER_PORT', 30, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('SYNC_MON', 'Synchronize Monitoring', 'PRIV_TYPE_MENU', './nhBillerConfig.do?action=list_monitoring&clear=true', 'BILLER', 50, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP);

INSERT INTO MWAPP.ROLE (ID, TYPE, NAME, STATUS, MODIFIED_BY, TIMESTAMP) VALUES
    ('EDCstaff', 'MWUI', 'EDC Staff', 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('epaymentadmin', 'MWUI', 'System Administrator Epayment', 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('epaymentstaff', 'MWUI', 'Staff Epayment', 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('mdwadmin', 'MWUI', 'System Administrator Middleware', 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('mdwhelpdesk', 'MWUI', 'MDW Helpdesk', 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('mdwstaff', 'MWUI', 'Staff Middleware', 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('reconadmin', 'REKON', 'Reconciliation Administrator', 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('reconhaji', 'REKON', 'Reconciliation Haji', 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('reconprima', 'REKON', 'Reconciliation ATM', 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('reconstaff', 'REKON', 'Reconciliation Staff', 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
    ('wsadmin', 'MWUI', 'System Administrator Middleware', 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP);

INSERT INTO MWAPP.ROLE_PRIVILEGE ("ROLE", PRIVILEGE) VALUES
    ('epaymentadmin', 'ADMIN_REPORT'),
    ('epaymentadmin', 'ADMIN_REPORT_CREATE'),
    ('epaymentadmin', 'ADMIN_REPORT_LIST'),
    ('epaymentadmin', 'ADMIN_REPORT_UPDATE'),
    ('epaymentadmin', 'APP_SETTING'),
    ('epaymentadmin', 'APP_SETTING_CREATE'),
    ('epaymentadmin', 'APP_SETTING_LIST'),
    ('epaymentadmin', 'APP_SETTING_UPDATE'),
    ('epaymentadmin', 'APP_USER'),
    ('epaymentadmin', 'APP_USER_CREATE'),
    ('epaymentadmin', 'APP_USER_LIST'),
    ('epaymentadmin', 'APP_USER_UPDATE'),
    ('epaymentadmin', 'BILLER'),
    ('epaymentadmin', 'BILLER_CAT'),
    ('epaymentadmin', 'BILLER_CAT_CREATE'),
    ('epaymentadmin', 'BILLER_CAT_LIST'),
    ('epaymentadmin', 'BILLER_CAT_UPDATE'),
    ('epaymentadmin', 'BILLER_CONFIG'),
    ('epaymentadmin', 'BILLER_CONFIG_CREATE'),
    ('epaymentadmin', 'BILLER_CONFIG_LIST'),
    ('epaymentadmin', 'BILLER_CONFIG_UPDATE'),
    ('epaymentadmin', 'BILLER_DATA'),
    ('epaymentadmin', 'BILLER_DATA_CREATE'),
    ('epaymentadmin', 'BILLER_DATA_LIST'),
    ('epaymentadmin', 'BILLER_DATA_UPDATE'),
    ('epaymentadmin', 'BILLER_GROUP_MAINTENANCE'),
    ('epaymentadmin', 'EPAYMENT_ADMIN'),
    ('epaymentadmin', 'EPAY_PRIVILEGE'),
    ('epaymentadmin', 'EPAY_PRIVILEGE_CREATE'),
    ('epaymentadmin', 'EPAY_PRIVILEGE_LIST'),
    ('epaymentadmin', 'EPAY_PRIVILEGE_UPDATE'),
    ('epaymentadmin', 'EPAY_ROLE'),
    ('epaymentadmin', 'EPAY_ROLE_CREATE'),
    ('epaymentadmin', 'EPAY_ROLE_LIST'),
    ('epaymentadmin', 'EPAY_ROLE_UPDATE'),
    ('epaymentadmin', 'SEP_ADMIN_REPORT'),
    ('epaymentadmin', 'SEP_APP_SETTING'),
    ('epaymentadmin', 'SEP_APP_USER'),
    ('epaymentadmin', 'SEP_BILLER'),
    ('epaymentadmin', 'SEP_BILLER_CAT'),
    ('epaymentadmin', 'SEP_BILLER_CONFIG'),
    ('epaymentadmin', 'SEP_BILLER_DATA'),
    ('epaymentadmin', 'SEP_BILLER_GROUP_MAINTENANCE'),
    ('epaymentadmin', 'SEP_BILLER_SYNC_MON'),
    ('epaymentadmin', 'SEP_EPAYMENT_ADMIN'),
    ('epaymentadmin', 'SEP_EPAY_PRIVILEGE'),
    ('epaymentadmin', 'SEP_EPAY_ROLE'),
    ('epaymentadmin', 'SEP_SERVER_CONFIG'),
    ('epaymentadmin', 'SERVER_CONFIG'),
    ('epaymentadmin', 'SYNC_MON'),
    ('epaymentstaff', 'ADMIN_REPORT'),
    ('epaymentstaff', 'ADMIN_REPORT_LIST'),
    ('epaymentstaff', 'APP_SETTING'),
    ('epaymentstaff', 'APP_SETTING_LIST'),
    ('epaymentstaff', 'APP_USER'),
    ('epaymentstaff', 'APP_USER_LIST'),
    ('epaymentstaff', 'BILLER'),
    ('epaymentstaff', 'BILLER_CAT'),
    ('epaymentstaff', 'BILLER_CAT_LIST'),
    ('epaymentstaff', 'BILLER_CONFIG'),
    ('epaymentstaff', 'BILLER_CONFIG_LIST'),
    ('epaymentstaff', 'BILLER_DATA'),
    ('epaymentstaff', 'BILLER_DATA_LIST'),
    ('epaymentstaff', 'EPAYMENT_ADMIN'),
    ('epaymentstaff', 'EPAY_PRIVILEGE'),
    ('epaymentstaff', 'EPAY_PRIVILEGE_LIST'),
    ('epaymentstaff', 'EPAY_ROLE'),
    ('epaymentstaff', 'EPAY_ROLE_LIST'),
    ('epaymentstaff', 'SEP_ADMIN_REPORT'),
    ('epaymentstaff', 'SEP_APP_SETTING'),
    ('epaymentstaff', 'SEP_APP_USER'),
    ('epaymentstaff', 'SEP_BILLER'),
    ('epaymentstaff', 'SEP_BILLER_CAT'),
    ('epaymentstaff', 'SEP_BILLER_CONFIG'),
    ('epaymentstaff', 'SEP_BILLER_DATA'),
    ('epaymentstaff', 'SEP_BILLER_SYNC_MON'),
    ('epaymentstaff', 'SEP_EPAYMENT_ADMIN'),
    ('epaymentstaff', 'SEP_EPAY_PRIVILEGE'),
    ('epaymentstaff', 'SEP_EPAY_ROLE'),
    ('epaymentstaff', 'SYNC_MON'),
    ('mdwadmin', 'ADAPTOR_PARAM'),
    ('mdwadmin', 'ADAPTOR_PARAM_CREATE'),
    ('mdwadmin', 'ADAPTOR_PARAM_LIST'),
    ('mdwadmin', 'ADAPTOR_PARAM_UPDATE'),
    ('mdwadmin', 'ADMIN'),
    ('mdwadmin', 'APP_CONFIG'),
    ('mdwadmin', 'ATTRIBUTE'),
    ('mdwadmin', 'ATTRIBUTE_CREATE'),
    ('mdwadmin', 'ATTRIBUTE_LIST'),
    ('mdwadmin', 'ATTRIBUTE_UPDATE'),
    ('mdwadmin', 'CHARGES'),
    ('mdwadmin', 'CHARGES_LIST'),
    ('mdwadmin', 'CHARGES_UPDATE'),
    ('mdwadmin', 'CLEANER_CONFIG'),
    ('mdwadmin', 'CLIENT'),
    ('mdwadmin', 'CLIENT_CREATE'),
    ('mdwadmin', 'CLIENT_LIST'),
    ('mdwadmin', 'CLIENT_UPDATE'),
    ('mdwadmin', 'CODEX'),
    ('mdwadmin', 'CODEX_CREATE'),
    ('mdwadmin', 'CODEX_LIST'),
    ('mdwadmin', 'CODEX_UPDATE'),
    ('mdwadmin', 'CONFIGURATION'),
    ('mdwadmin', 'DATABASE_CONNECTION'),
    ('mdwadmin', 'DATABASE_CONNECTION_CREATE'),
    ('mdwadmin', 'DATABASE_CONNECTION_LIST'),
    ('mdwadmin', 'DATABASE_CONNECTION_UPDATE'),
    ('mdwadmin', 'DATA_QUERY'),
    ('mdwadmin', 'DATA_QUERY_CREATE'),
    ('mdwadmin', 'DATA_QUERY_LIST'),
    ('mdwadmin', 'DATA_QUERY_UPDATE'),
    ('mdwadmin', 'DB_CONN'),
    ('mdwadmin', 'DB_CONN_CREATE'),
    ('mdwadmin', 'DB_CONN_LIST'),
    ('mdwadmin', 'DB_CONN_UPDATE'),
    ('mdwadmin', 'DB_QUERY'),
    ('mdwadmin', 'DB_QUERY_CREATE'),
    ('mdwadmin', 'DB_QUERY_LIST'),
    ('mdwadmin', 'DB_QUERY_UPDATE'),
    ('mdwadmin', 'DEVICE_TELLER'),
    ('mdwadmin', 'DEVICE_TELLER_CREATE'),
    ('mdwadmin', 'DEVICE_TELLER_LIST'),
    ('mdwadmin', 'DEVICE_TELLER_UPDATE'),
    ('mdwadmin', 'ENCRYPT'),
    ('mdwadmin', 'EOD_CONFIG'),
    ('mdwadmin', 'ERROR_MAP'),
    ('mdwadmin', 'ERROR_MAP_CREATE'),
    ('mdwadmin', 'ERROR_MAP_LIST'),
    ('mdwadmin', 'ERROR_MAP_UPDATE'),
    ('mdwadmin', 'HOST'),
    ('mdwadmin', 'HOST_CREATE'),
    ('mdwadmin', 'HOST_LIST'),
    ('mdwadmin', 'HOST_UPDATE'),
    ('mdwadmin', 'LOG_ACTIVITY'),
    ('mdwadmin', 'LOG_MESSAGE'),
    ('mdwadmin', 'MAPPING'),
    ('mdwadmin', 'MAPPING_CREATE'),
    ('mdwadmin', 'MAPPING_LIST'),
    ('mdwadmin', 'MONITOR_CONFIG'),
    ('mdwadmin', 'MONITOR_CONFIG_STATS'),
    ('mdwadmin', 'PARAM_MAP'),
    ('mdwadmin', 'PARAM_MAP_CREATE'),
    ('mdwadmin', 'PARAM_MAP_LIST'),
    ('mdwadmin', 'PARAM_MAP_UPDATE'),
    ('mdwadmin', 'PARSER'),
    ('mdwadmin', 'PARSER_CREATE'),
    ('mdwadmin', 'PARSER_LIST'),
    ('mdwadmin', 'PARSER_UPDATE'),
    ('mdwadmin', 'PRIVILEGE'),
    ('mdwadmin', 'PRIVILEGE_CREATE'),
    ('mdwadmin', 'PRIVILEGE_LIST'),
    ('mdwadmin', 'PRIVILEGE_UPDATE'),
    ('mdwadmin', 'REKON'),
    ('mdwadmin', 'REKON_CONFIG'),
    ('mdwadmin', 'REKON_CONFIG_CREATE'),
    ('mdwadmin', 'REKON_CONFIG_LIST'),
    ('mdwadmin', 'REKON_CONFIG_UPDATE'),
    ('mdwadmin', 'ROLE'),
    ('mdwadmin', 'ROLE_CREATE'),
    ('mdwadmin', 'ROLE_LIST'),
    ('mdwadmin', 'ROLE_UPDATE'),
    ('mdwadmin', 'ROUTING_TABLE'),
    ('mdwadmin', 'ROUTING_TABLE_CREATE'),
    ('mdwadmin', 'ROUTING_TABLE_LIST'),
    ('mdwadmin', 'ROUTING_TABLE_UPDATE'),
    ('mdwadmin', 'RPG_CALL'),
    ('mdwadmin', 'RPG_CALL_CREATE'),
    ('mdwadmin', 'RPG_CALL_LIST'),
    ('mdwadmin', 'RPG_CALL_UPDATE'),
    ('mdwadmin', 'SEP_ADMIN'),
    ('mdwadmin', 'SEP_ADMIN_PLUGIN_PRIVILEGE'),
    ('mdwadmin', 'SEP_ADMIN_PLUGIN_ROLE'),
    ('mdwadmin', 'SEP_APP_CONFIG'),
    ('mdwadmin', 'SEP_ATTRIBUTE'),
    ('mdwadmin', 'SEP_CONFIGURATION'),
    ('mdwadmin', 'SEP_CONFIGURATION_ADAPTOR_PARAM'),
    ('mdwadmin', 'SEP_CONFIGURATION_CHARGES'),
    ('mdwadmin', 'SEP_CONFIGURATION_CLIENT'),
    ('mdwadmin', 'SEP_CONFIGURATION_CODEX'),
    ('mdwadmin', 'SEP_CONFIGURATION_DB_CONN'),
    ('mdwadmin', 'SEP_CONFIGURATION_DB_QUERY'),
    ('mdwadmin', 'SEP_CONFIGURATION_DEVICE_TELLER'),
    ('mdwadmin', 'SEP_CONFIGURATION_ENCRYPT'),
    ('mdwadmin', 'SEP_CONFIGURATION_ERROR_MAP'),
    ('mdwadmin', 'SEP_CONFIGURATION_HOST'),
    ('mdwadmin', 'SEP_CONFIGURATION_MAPPING'),
    ('mdwadmin', 'SEP_CONFIGURATION_PARAM_MAP'),
    ('mdwadmin', 'SEP_CONFIGURATION_PARSER'),
    ('mdwadmin', 'SEP_CONFIGURATION_ROUTING_TABLE'),
    ('mdwadmin', 'SEP_CONFIGURATION_RPG_CALL'),
    ('mdwadmin', 'SEP_CONFIGURATION_SERVER_PORT'),
    ('mdwadmin', 'SEP_DATABASE_CONNECTION'),
    ('mdwadmin', 'SEP_DATA_QUERY'),
    ('mdwadmin', 'SERVER_PORT'),
    ('mdwadmin', 'SERVER_PORT_CREATE'),
    ('mdwadmin', 'SERVER_PORT_LIST'),
    ('mdwadmin', 'SERVER_PORT_UPDATE'),
    ('mdwhelpdesk', 'BILLER'),
    ('mdwhelpdesk', 'LOG_ACTIVITY'),
    ('mdwhelpdesk', 'LOG_MESSAGE'),
    ('mdwhelpdesk', 'SYNC_MON'),
    ('mdwstaff', 'ADAPTOR_PARAM'),
    ('mdwstaff', 'ADAPTOR_PARAM_LIST'),
    ('mdwstaff', 'ADMIN'),
    ('mdwstaff', 'APP_CONFIG'),
    ('mdwstaff', 'ATTRIBUTE'),
    ('mdwstaff', 'ATTRIBUTE_LIST'),
    ('mdwstaff', 'CHARGES'),
    ('mdwstaff', 'CHARGES_LIST'),
    ('mdwstaff', 'CLIENT'),
    ('mdwstaff', 'CLIENT_LIST'),
    ('mdwstaff', 'CODEX'),
    ('mdwstaff', 'CODEX_LIST'),
    ('mdwstaff', 'CONFIGURATION'),
    ('mdwstaff', 'DB_CONN'),
    ('mdwstaff', 'DB_CONN_LIST'),
    ('mdwstaff', 'DB_QUERY'),
    ('mdwstaff', 'DB_QUERY_LIST'),
    ('mdwstaff', 'DEVICE_TELLER'),
    ('mdwstaff', 'DEVICE_TELLER_LIST'),
    ('mdwstaff', 'ERROR_MAP'),
    ('mdwstaff', 'ERROR_MAP_LIST'),
    ('mdwstaff', 'HOST'),
    ('mdwstaff', 'HOST_LIST'),
    ('mdwstaff', 'LOG_ACTIVITY'),
    ('mdwstaff', 'LOG_MESSAGE'),
    ('mdwstaff', 'MAPPING'),
    ('mdwstaff', 'MAPPING_LIST'),
    ('mdwstaff', 'MONITOR_CONFIG'),
    ('mdwstaff', 'MONITOR_CONFIG_STATS'),
    ('mdwstaff', 'PARAM_MAP'),
    ('mdwstaff', 'PARAM_MAP_LIST'),
    ('mdwstaff', 'PARSER'),
    ('mdwstaff', 'PARSER_LIST'),
    ('mdwstaff', 'PRIVILEGE'),
    ('mdwstaff', 'PRIVILEGE_LIST'),
    ('mdwstaff', 'ROLE'),
    ('mdwstaff', 'ROLE_LIST'),
    ('mdwstaff', 'ROUTING_TABLE'),
    ('mdwstaff', 'ROUTING_TABLE_LIST'),
    ('mdwstaff', 'RPG_CALL'),
    ('mdwstaff', 'RPG_CALL_LIST'),
    ('mdwstaff', 'SEP_ADMIN'),
    ('mdwstaff', 'SEP_ADMIN_PLUGIN_PRIVILEGE'),
    ('mdwstaff', 'SEP_ADMIN_PLUGIN_ROLE'),
    ('mdwstaff', 'SEP_APP_CONFIG'),
    ('mdwstaff', 'SEP_ATTRIBUTE'),
    ('mdwstaff', 'SEP_CONFIGURATION'),
    ('mdwstaff', 'SEP_CONFIGURATION_ADAPTOR_PARAM'),
    ('mdwstaff', 'SEP_CONFIGURATION_CHARGES'),
    ('mdwstaff', 'SEP_CONFIGURATION_CLIENT'),
    ('mdwstaff', 'SEP_CONFIGURATION_CODEX'),
    ('mdwstaff', 'SEP_CONFIGURATION_DB_CONN'),
    ('mdwstaff', 'SEP_CONFIGURATION_DB_QUERY'),
    ('mdwstaff', 'SEP_CONFIGURATION_DEVICE_TELLER'),
    ('mdwstaff', 'SEP_CONFIGURATION_ERROR_MAP'),
    ('mdwstaff', 'SEP_CONFIGURATION_HOST'),
    ('mdwstaff', 'SEP_CONFIGURATION_MAPPING'),
    ('mdwstaff', 'SEP_CONFIGURATION_PARAM_MAP'),
    ('mdwstaff', 'SEP_CONFIGURATION_PARSER'),
    ('mdwstaff', 'SEP_CONFIGURATION_ROUTING_TABLE'),
    ('mdwstaff', 'SEP_CONFIGURATION_RPG_CALL'),
    ('mdwstaff', 'SEP_CONFIGURATION_SERVER_PORT'),
    ('mdwstaff', 'SERVER_PORT'),
    ('mdwstaff', 'SERVER_PORT_LIST'),
    ('reconadmin', 'DATABASE_CONNECTION'),
    ('reconadmin', 'DATABASE_CONNECTION_CREATE'),
    ('reconadmin', 'DATABASE_CONNECTION_LIST'),
    ('reconadmin', 'DATABASE_CONNECTION_UPDATE'),
    ('reconadmin', 'DATA_QUERY'),
    ('reconadmin', 'DATA_QUERY_CREATE'),
    ('reconadmin', 'DATA_QUERY_LIST'),
    ('reconadmin', 'DATA_QUERY_UPDATE'),
    ('reconhaji', 'RECON_DEPAG'),
    ('reconhaji', 'RECON_DEPAG_RECON'),
    ('reconhaji', 'RECON_KONVEN'),
    ('reconhaji', 'RECON_KONVEN_RECON'),
    ('reconhaji', 'REKON_KONVEN_BULANAN'),
    ('reconhaji', 'REKON_SYARIAH_BULANAN'),
    ('reconhaji', 'SEP_RECON_DEPAG'),
    ('reconhaji', 'SEP_RECON_KONVEN'),
    ('reconprima', 'PRIMA'),
    ('reconprima', 'PRIMA_RECON'),
    ('reconprima', 'SEP_PRIMA'),
    ('reconstaff', 'RECON_MKM'),
    ('reconstaff', 'RECON_MKM_PLNNTL'),
    ('reconstaff', 'RECON_MKM_PLNPOS'),
    ('reconstaff', 'RECON_MKM_PLNPRE'),
    ('reconstaff', 'RECON_MKM_PLNPRE_RECON'),
    ('reconstaff', 'RECON_MKM_PLNPRE_TOKEN'),
    ('reconstaff', 'RECON_SYB'),
    ('reconstaff', 'RECON_SYB_FIF'),
    ('reconstaff', 'RECON_SYB_KAI'),
    ('reconstaff', 'SEP_RECON_MKM'),
    ('reconstaff', 'SEP_RECON_SYB'),
    ('wsadmin', 'ADAPTOR_PARAM'),
    ('wsadmin', 'ADAPTOR_PARAM_CREATE'),
    ('wsadmin', 'ADAPTOR_PARAM_LIST'),
    ('wsadmin', 'ADAPTOR_PARAM_UPDATE'),
    ('wsadmin', 'ADMIN'),
    ('wsadmin', 'APP_CONFIG'),
    ('wsadmin', 'ATTRIBUTE'),
    ('wsadmin', 'ATTRIBUTE_CREATE'),
    ('wsadmin', 'ATTRIBUTE_LIST'),
    ('wsadmin', 'ATTRIBUTE_UPDATE'),
    ('wsadmin', 'CHARGES'),
    ('wsadmin', 'CHARGES_LIST'),
    ('wsadmin', 'CHARGES_UPDATE'),
    ('wsadmin', 'CLEANER_CONFIG'),
    ('wsadmin', 'CLIENT'),
    ('wsadmin', 'CLIENT_CREATE'),
    ('wsadmin', 'CLIENT_LIST'),
    ('wsadmin', 'CLIENT_UPDATE'),
    ('wsadmin', 'CODEX'),
    ('wsadmin', 'CODEX_CREATE'),
    ('wsadmin', 'CODEX_LIST'),
    ('wsadmin', 'CODEX_UPDATE'),
    ('wsadmin', 'CONFIGURATION'),
    ('wsadmin', 'DATABASE_CONNECTION'),
    ('wsadmin', 'DATABASE_CONNECTION_CREATE'),
    ('wsadmin', 'DATABASE_CONNECTION_LIST'),
    ('wsadmin', 'DATABASE_CONNECTION_UPDATE'),
    ('wsadmin', 'DATA_QUERY'),
    ('wsadmin', 'DATA_QUERY_CREATE'),
    ('wsadmin', 'DATA_QUERY_LIST'),
    ('wsadmin', 'DATA_QUERY_UPDATE'),
    ('wsadmin', 'DB_CONN'),
    ('wsadmin', 'DB_CONN_CREATE'),
    ('wsadmin', 'DB_CONN_LIST'),
    ('wsadmin', 'DB_CONN_UPDATE'),
    ('wsadmin', 'DB_QUERY'),
    ('wsadmin', 'DB_QUERY_CREATE'),
    ('wsadmin', 'DB_QUERY_LIST'),
    ('wsadmin', 'DB_QUERY_UPDATE'),
    ('wsadmin', 'DEVICE_TELLER'),
    ('wsadmin', 'DEVICE_TELLER_CREATE'),
    ('wsadmin', 'DEVICE_TELLER_LIST'),
    ('wsadmin', 'DEVICE_TELLER_UPDATE'),
    ('wsadmin', 'ENCRYPT'),
    ('wsadmin', 'EOD_CONFIG'),
    ('wsadmin', 'ERROR_MAP'),
    ('wsadmin', 'ERROR_MAP_CREATE'),
    ('wsadmin', 'ERROR_MAP_LIST'),
    ('wsadmin', 'ERROR_MAP_UPDATE'),
    ('wsadmin', 'HOST'),
    ('wsadmin', 'HOST_CREATE'),
    ('wsadmin', 'HOST_LIST'),
    ('wsadmin', 'HOST_UPDATE'),
    ('wsadmin', 'LOG_ACTIVITY'),
    ('wsadmin', 'LOG_MESSAGE'),
    ('wsadmin', 'MAPPING'),
    ('wsadmin', 'MAPPING_CREATE'),
    ('wsadmin', 'MAPPING_LIST'),
    ('wsadmin', 'MONITOR_CONFIG'),
    ('wsadmin', 'MONITOR_CONFIG_STATS'),
    ('wsadmin', 'PARAM_MAP'),
    ('wsadmin', 'PARAM_MAP_CREATE'),
    ('wsadmin', 'PARAM_MAP_LIST'),
    ('wsadmin', 'PARAM_MAP_UPDATE'),
    ('wsadmin', 'PARSER'),
    ('wsadmin', 'PARSER_CREATE'),
    ('wsadmin', 'PARSER_LIST'),
    ('wsadmin', 'PARSER_UPDATE'),
    ('wsadmin', 'PRIVILEGE'),
    ('wsadmin', 'PRIVILEGE_CREATE'),
    ('wsadmin', 'PRIVILEGE_LIST'),
    ('wsadmin', 'PRIVILEGE_UPDATE'),
    ('wsadmin', 'REKON'),
    ('wsadmin', 'REKON_CONFIG'),
    ('wsadmin', 'REKON_CONFIG_CREATE'),
    ('wsadmin', 'REKON_CONFIG_LIST'),
    ('wsadmin', 'REKON_CONFIG_UPDATE'),
    ('wsadmin', 'ROLE'),
    ('wsadmin', 'ROLE_CREATE'),
    ('wsadmin', 'ROLE_LIST'),
    ('wsadmin', 'ROLE_UPDATE'),
    ('wsadmin', 'ROUTING_TABLE'),
    ('wsadmin', 'ROUTING_TABLE_CREATE'),
    ('wsadmin', 'ROUTING_TABLE_LIST'),
    ('wsadmin', 'ROUTING_TABLE_UPDATE'),
    ('wsadmin', 'RPG_CALL'),
    ('wsadmin', 'RPG_CALL_CREATE'),
    ('wsadmin', 'RPG_CALL_LIST'),
    ('wsadmin', 'RPG_CALL_UPDATE'),
    ('wsadmin', 'SEP_ADMIN'),
    ('wsadmin', 'SEP_ADMIN_PLUGIN_PRIVILEGE'),
    ('wsadmin', 'SEP_ADMIN_PLUGIN_ROLE'),
    ('wsadmin', 'SEP_APP_CONFIG'),
    ('wsadmin', 'SEP_ATTRIBUTE'),
    ('wsadmin', 'SEP_CONFIGURATION'),
    ('wsadmin', 'SEP_CONFIGURATION_ADAPTOR_PARAM'),
    ('wsadmin', 'SEP_CONFIGURATION_CHARGES'),
    ('wsadmin', 'SEP_CONFIGURATION_CLIENT'),
    ('wsadmin', 'SEP_CONFIGURATION_CODEX'),
    ('wsadmin', 'SEP_CONFIGURATION_DB_CONN'),
    ('wsadmin', 'SEP_CONFIGURATION_DB_QUERY'),
    ('wsadmin', 'SEP_CONFIGURATION_DEVICE_TELLER'),
    ('wsadmin', 'SEP_CONFIGURATION_ENCRYPT'),
    ('wsadmin', 'SEP_CONFIGURATION_ERROR_MAP'),
    ('wsadmin', 'SEP_CONFIGURATION_HOST'),
    ('wsadmin', 'SEP_CONFIGURATION_MAPPING'),
    ('wsadmin', 'SEP_CONFIGURATION_PARAM_MAP'),
    ('wsadmin', 'SEP_CONFIGURATION_PARSER'),
    ('wsadmin', 'SEP_CONFIGURATION_ROUTING_TABLE'),
    ('wsadmin', 'SEP_CONFIGURATION_RPG_CALL'),
    ('wsadmin', 'SEP_CONFIGURATION_SERVER_PORT'),
    ('wsadmin', 'SEP_DATABASE_CONNECTION'),
    ('wsadmin', 'SEP_DATA_QUERY'),
    ('wsadmin', 'SERVER_PORT'),
    ('wsadmin', 'SERVER_PORT_CREATE'),
    ('wsadmin', 'SERVER_PORT_LIST'),
    ('wsadmin', 'SERVER_PORT_UPDATE');

INSERT INTO MWAPP.SYS_PARAM (CODE, NAME, PARAM_VALUE, DESCRIPTION, MODIFIED_BY, TIMESTAMP) VALUES
    ('/AJAIB/CORE', 'FOLDER_DELETION', 'CURRENT_TIMESTAMP+3 MONTHS', 'Delete folder file core (konven+syariah)', CURRENT USER, CURRENT TIMESTAMP),
    ('/AJAIB/DEPAG', 'FOLDER_DELETION', 'CURRENT_TIMESTAMP+3 MONTHS', 'Delete folder file download', CURRENT USER, CURRENT TIMESTAMP),
    ('/AJAIB/KONVEN', 'FOLDER_DELETION', 'CURRENT_TIMESTAMP+3 MONTHS', 'Delete folder file konven', CURRENT USER, CURRENT TIMESTAMP),
    ('/AJAIB/SYARIAH', 'FOLDER_DELETION', 'CURRENT_TIMESTAMP+3 MONTHS', 'Delete folder file syariah', CURRENT USER, CURRENT TIMESTAMP),
    ('/FIF/COREBP', 'FOLDER_DELETION', 'CURRENT_TIMESTAMP+15 DAYS', 'Delete folder', CURRENT USER, CURRENT TIMESTAMP),
    ('/FIF/SYB', 'FOLDER_DELETION', 'CURRENT_TIMESTAMP+15 DAYS', 'Delete folder', CURRENT USER, CURRENT TIMESTAMP),
    ('/KAI/COREBP', 'FOLDER_DELETION', 'CURRENT_TIMESTAMP+15 DAYS', 'Delete folder', CURRENT USER, CURRENT TIMESTAMP),
    ('/KAI/SYB', 'FOLDER_DELETION', 'CURRENT_TIMESTAMP+15 DAYS', 'Delete folder', CURRENT USER, CURRENT TIMESTAMP),
    ('/MKM_PLNNTL/COREBP', 'FOLDER_DELETION', 'CURRENT_TIMESTAMP+3 MONTHS', 'Delete folder', CURRENT USER, CURRENT TIMESTAMP),
    ('/MKM_PLNNTL/MKM', 'FOLDER_DELETION', 'CURRENT_TIMESTAMP+3 MONTHS', 'Delete folder', CURRENT USER, CURRENT TIMESTAMP),
    ('/MKM_PLNPOS/COREBP', 'FOLDER_DELETION', 'CURRENT_TIMESTAMP+15 DAYS', 'Delete folder', CURRENT USER, CURRENT TIMESTAMP),
    ('/MKM_PLNPOS/MKM', 'FOLDER_DELETION', 'CURRENT_TIMESTAMP+15 DAYS', 'Delete folder', CURRENT USER, CURRENT TIMESTAMP),
    ('/MKM_PLNPRE/COREBP', 'FOLDER_DELETION', 'CURRENT_TIMESTAMP+15 DAYS', 'Delete folder file upload', CURRENT USER, CURRENT TIMESTAMP),
    ('/MKM_PLNPRE/MKM', 'FOLDER_DELETION', 'CURRENT_TIMESTAMP+15 DAYS', 'Delete folder file download', CURRENT USER, CURRENT TIMESTAMP),
    ('/PERTAMINA/EBS', 'FOLDER_DELETION', 'CURRENT_TIMESTAMP+5 DAYS', 'Delete folder', CURRENT USER, CURRENT TIMESTAMP),
    ('/PLN/COREBP', 'FOLDER_DELETION', 'CURRENT_TIMESTAMP+3 MONTHS', 'Delete folder file upload', CURRENT USER, CURRENT TIMESTAMP),
    ('/PLN/SYB', 'FOLDER_DELETION', 'CURRENT_TIMESTAMP+3 MONTHS', 'Delete folder file download', CURRENT USER, CURRENT TIMESTAMP),
    ('/PLN_NONTAG/COREBP', 'FOLDER_DELETION', 'CURRENT_TIMESTAMP+14 DAYS', 'Delete folder', CURRENT USER, CURRENT TIMESTAMP),
    ('/PLN_NONTAG/SYB', 'FOLDER_DELETION', 'CURRENT_TIMESTAMP+14 DAYS', 'Delete folder', CURRENT USER, CURRENT TIMESTAMP),
    ('/PLN_POSTPAID/COREBP', 'FOLDER_DELETION', 'CURRENT_TIMESTAMP+15 DAYS', 'Delete folder', CURRENT USER, CURRENT TIMESTAMP),
    ('/PLN_POSTPAID/SYB', 'FOLDER_DELETION', 'CURRENT_TIMESTAMP+15 DAYS', 'Delete folder', CURRENT USER, CURRENT TIMESTAMP),
    ('MDW_AS400_SCHEMA', 'AS400 Schema that will be connected by Middleware', 'Q', 'AS400 Schema that will be connected by Middleware', CURRENT USER, CURRENT TIMESTAMP),
    ('REKON/DEPAG/DB/KONVEN', 'FOLDER_DELETION', 'CURRENT_TIMESTAMP+3 MONTHS', 'Delete folder', CURRENT USER, CURRENT TIMESTAMP),
    ('REKON/DEPAG/KONVEN', 'FOLDER_DELETION', 'CURRENT_TIMESTAMP+3 MONTHS', 'Delete folder', CURRENT USER, CURRENT TIMESTAMP),
    ('REKON/DEPAG/SYARIAH', 'FOLDER_DELETION', 'CURRENT_TIMESTAMP+3 MONTHS', 'Delete folder', CURRENT USER, CURRENT TIMESTAMP),
    ('REKON/PRIMA', 'FOLDER_DELETION', 'CURRENT_TIMESTAMP+3 MONTHS', 'Delete folder', CURRENT USER, CURRENT TIMESTAMP),
    ('REKON/PRINT/KONVEN', 'FOLDER_DELETION', 'CURRENT_TIMESTAMP+3 MONTHS', 'Delete folder', CURRENT USER, CURRENT TIMESTAMP),
    ('REKON/PRINT/SYARIAH', 'FOLDER_DELETION', 'CURRENT_TIMESTAMP+3 MONTHS', 'Delete folder', CURRENT USER, CURRENT TIMESTAMP),
    ('REKON/SYARIAH', 'FOLDER_DELETION', 'CURRENT_TIMESTAMP+3 MONTHS', 'Delete folder', CURRENT USER, CURRENT TIMESTAMP),
    ('REKON_REKENING_NUMBER', 'Rekening number for memo report', '1234567890', 'Rekening number for memo report', CURRENT USER, CURRENT TIMESTAMP),
    ('REKON_REKENING_OWNER', 'rekening owner for MEMO Report', 'BATARAX', 'Rekening owner for memo report', CURRENT USER, CURRENT TIMESTAMP),
    ('REKON_REPORT_DATE_FORMAT', 'Rekon Report Date Format', 'yyMMddHHmmss', 'Report File Name Date Format', CURRENT USER, CURRENT TIMESTAMP),
    ('REKON_REPORT_DEFAULT_TYPE', 'Rekon Report Default Type', 'PDF', 'Report File Default Type', CURRENT USER, CURRENT TIMESTAMP),
    ('REKON_REPORT_DELETION_INTERVAL', 'Rekon Report Deletion Interval', '1', 'Number of days that backup file will be kept', CURRENT USER, CURRENT TIMESTAMP),
    ('REKON_REPORT_MAX_DAYS', 'Rekon Report Max Days', '30', 'Number of days that rekon report can be generated', CURRENT USER, CURRENT TIMESTAMP),
    ('REPORT_DELETION_INTERVAL', 'Interval Report Temporary Storage Will Be Deleted', '86400000', 'Interval Report Temporary Storage Will Be Deleted', CURRENT USER, CURRENT TIMESTAMP);