240 lines
20 KiB
SQL
240 lines
20 KiB
SQL
PROMPT Inserting DWH Basic Data
|
|
set feedback off
|
|
set define off
|
|
|
|
prompt Loading EXTERNAL_DATA_TAB...
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('A0BS00', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('A0BSRF', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('A0CY', 'N', 'AB2', null, null, 'CYSTAT=''0''');
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('A0HO', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('A0MO', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('A0WI', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('A1AO', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('A1BS', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('A1EC', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('A1FA', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('A1GL', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('A1ID', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('A1IN', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('A1LO', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('A1OW', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('A2AT', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('A2BR', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('A2DE', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('A2IS', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('A2KU', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('A2NE', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('A2TR', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('A3FI', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('A3FU', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('AFRCU', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('AHASL', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('AKERJ', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('BSL03P', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('D5DO', 'N', 'AB2', 'DODTEP', 'N', 'DOSTAT=''0''');
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('D6DD', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('D6KOL', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('D8DH', 'N', 'AB2', 'DHDTPO', 'N', null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('D8PJM', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('DLOAN', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('FCADKHU', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('FCADKRT', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('FCADUMU', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('FCADURT', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('GLBAL', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('GLHST', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('GLPLR', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('H7KU', 'N', 'AB2', 'KUDTVL', 'N', null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('H8AR', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('H8DU', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('H8PO', 'N', 'AB2', 'PODTPO', 'N', null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('LCLCD', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('LCOMN', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('LCOMS', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('LCPAP', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('LFACU', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('LFCMS', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('LFCTY', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('LFSBI', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('LGAIK', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('LGTPA', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('LHFAC', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('LHLON', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('LHPDU', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('LLNTY', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('LLOAN', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('LLONBG', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('LMCOM', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('LMECOM', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('LSABI', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('LTLON', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('M4CU', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('M4CUBI', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('M4CUC', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('M4CUFR', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('M4CUG', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('M4CUI', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('M4CULT', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('M4CURL', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('M5PJ', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('M5RE', 'N', 'AB2', 'REDTEN', 'N', 'RESTAT=''0''');
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('M5REPRK', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('M6HI', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('M6IB', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('M6SB', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('M6SI', 'N', 'AB2', 'SIDTEX', 'N', null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('R6KOL', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('RLOAN', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('T6DT', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('TFGEN', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('THGEN', 'N', 'AB2', null, null, null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('X9XCG', 'N', 'AB2', 'XGFDLT', 'N', null);
|
|
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('FX', 'N', 'TSY', 'TRANS_DATE', 'D', null);
|
|
insert into EXTERNAL_DATA_TAB (TAB_NAME, PURGING_TYPE, MODUL, PURGING_FIELD, PURGING_DATA_TYPE, PURGING_FILTER)
|
|
values ('MM', 'N', 'TSY', 'TRANS_DATE', 'D', null);
|
|
commit;
|
|
prompt 84 records loaded
|
|
|
|
prompt Loading PRM_SYSTEM...
|
|
insert into PRM_SYSTEM (PARAMID, PARAMDESC, PARAMVALUE, UPDATEABLE, USER_UPDATE, TGL_UPDATE, FLAG_OTO, USER_OTO, TGL_OTO, PARAMTYPE)
|
|
values ('TOP_RANK', 'Top Rank Laporan', '10', '1', 'SYSTEM', to_date('03-12-2009 12:15:04', 'dd-mm-yyyy hh24:mi:ss'), 'O', 'SYSTEM', to_date('03-12-2009 12:15:04', 'dd-mm-yyyy hh24:mi:ss'), 'I');
|
|
insert into PRM_SYSTEM (PARAMID, PARAMDESC, PARAMVALUE, UPDATEABLE, USER_UPDATE, TGL_UPDATE, FLAG_OTO, USER_OTO, TGL_OTO, PARAMTYPE)
|
|
values ('APPSID', 'Application Code', 'DWH', '0', 'SYSTEM', to_date('03-12-2009 12:14:58', 'dd-mm-yyyy hh24:mi:ss'), 'O', 'SYSTEM', to_date('03-12-2009 12:14:58', 'dd-mm-yyyy hh24:mi:ss'), 'S');
|
|
insert into PRM_SYSTEM (PARAMID, PARAMDESC, PARAMVALUE, UPDATEABLE, USER_UPDATE, TGL_UPDATE, FLAG_OTO, USER_OTO, TGL_OTO, PARAMTYPE)
|
|
values ('BACKUP_RETENSION', 'Backup Retension (days)', '30', '1', 'SYSTEM', to_date('03-12-2009 12:14:58', 'dd-mm-yyyy hh24:mi:ss'), 'O', 'SYSTEM', to_date('03-12-2009 12:14:58', 'dd-mm-yyyy hh24:mi:ss'), 'I');
|
|
insert into PRM_SYSTEM (PARAMID, PARAMDESC, PARAMVALUE, UPDATEABLE, USER_UPDATE, TGL_UPDATE, FLAG_OTO, USER_OTO, TGL_OTO, PARAMTYPE)
|
|
values ('DECIMAL_POINT', 'Decimal point', '0', '1', 'SYSTEM', to_date('03-12-2009 12:14:58', 'dd-mm-yyyy hh24:mi:ss'), 'O', 'SYSTEM', to_date('03-12-2009 12:14:58', 'dd-mm-yyyy hh24:mi:ss'), 'I');
|
|
insert into PRM_SYSTEM (PARAMID, PARAMDESC, PARAMVALUE, UPDATEABLE, USER_UPDATE, TGL_UPDATE, FLAG_OTO, USER_OTO, TGL_OTO, PARAMTYPE)
|
|
values ('DECIMAL_SEP', 'Decimal Separator', ',', '1', 'SYSTEM', to_date('03-12-2009 12:14:58', 'dd-mm-yyyy hh24:mi:ss'), 'O', 'SYSTEM', to_date('03-12-2009 12:14:58', 'dd-mm-yyyy hh24:mi:ss'), 'S');
|
|
insert into PRM_SYSTEM (PARAMID, PARAMDESC, PARAMVALUE, UPDATEABLE, USER_UPDATE, TGL_UPDATE, FLAG_OTO, USER_OTO, TGL_OTO, PARAMTYPE)
|
|
values ('KEEP_AUDIT', 'Keep Audit Trail (month)', '12', '1', 'SYSTEM', to_date('03-12-2009 12:14:58', 'dd-mm-yyyy hh24:mi:ss'), 'O', 'SYSTEM', to_date('03-12-2009 12:14:58', 'dd-mm-yyyy hh24:mi:ss'), 'I');
|
|
insert into PRM_SYSTEM (PARAMID, PARAMDESC, PARAMVALUE, UPDATEABLE, USER_UPDATE, TGL_UPDATE, FLAG_OTO, USER_OTO, TGL_OTO, PARAMTYPE)
|
|
values ('KEEP_REPORT', 'Keep Report Archive (days)', '1', '1', 'SYSTEM', to_date('03-12-2009 12:14:58', 'dd-mm-yyyy hh24:mi:ss'), 'O', 'SYSTEM', to_date('03-12-2009 12:14:58', 'dd-mm-yyyy hh24:mi:ss'), 'I');
|
|
insert into PRM_SYSTEM (PARAMID, PARAMDESC, PARAMVALUE, UPDATEABLE, USER_UPDATE, TGL_UPDATE, FLAG_OTO, USER_OTO, TGL_OTO, PARAMTYPE)
|
|
values ('REP_LINES', 'Lines in Reports Page', '20', '1', 'SYSTEM', to_date('03-12-2009 12:14:58', 'dd-mm-yyyy hh24:mi:ss'), 'O', 'SYSTEM', to_date('03-12-2009 12:14:58', 'dd-mm-yyyy hh24:mi:ss'), 'I');
|
|
insert into PRM_SYSTEM (PARAMID, PARAMDESC, PARAMVALUE, UPDATEABLE, USER_UPDATE, TGL_UPDATE, FLAG_OTO, USER_OTO, TGL_OTO, PARAMTYPE)
|
|
values ('SESSION_LENGTH', 'Session Length (seconds)', '7200', '1', 'SYSTEM', to_date('03-12-2009 12:14:58', 'dd-mm-yyyy hh24:mi:ss'), 'O', 'SYSTEM', to_date('03-12-2009 12:14:58', 'dd-mm-yyyy hh24:mi:ss'), 'I');
|
|
insert into PRM_SYSTEM (PARAMID, PARAMDESC, PARAMVALUE, UPDATEABLE, USER_UPDATE, TGL_UPDATE, FLAG_OTO, USER_OTO, TGL_OTO, PARAMTYPE)
|
|
values ('THOUSAND_SEP', 'Thousand Separator', '.', '1', 'SYSTEM', to_date('03-12-2009 12:14:58', 'dd-mm-yyyy hh24:mi:ss'), 'O', 'SYSTEM', to_date('03-12-2009 12:14:58', 'dd-mm-yyyy hh24:mi:ss'), 'S');
|
|
insert into PRM_SYSTEM (PARAMID, PARAMDESC, PARAMVALUE, UPDATEABLE, USER_UPDATE, TGL_UPDATE, FLAG_OTO, USER_OTO, TGL_OTO, PARAMTYPE)
|
|
values ('USERMANAGERIP', 'User Manager IP Address', '10.0.10.68', '0', 'SYSTEM', to_date('03-12-2009 12:15:03', 'dd-mm-yyyy hh24:mi:ss'), 'O', 'SYSTEM', to_date('03-12-2009 12:15:03', 'dd-mm-yyyy hh24:mi:ss'), 'S');
|
|
insert into PRM_SYSTEM (PARAMID, PARAMDESC, PARAMVALUE, UPDATEABLE, USER_UPDATE, TGL_UPDATE, FLAG_OTO, USER_OTO, TGL_OTO, PARAMTYPE)
|
|
values ('USERMANAGERPORT', 'User Manager Port', '81', '0', 'SYSTEM', to_date('03-12-2009 12:15:04', 'dd-mm-yyyy hh24:mi:ss'), 'O', 'SYSTEM', to_date('03-12-2009 12:15:04', 'dd-mm-yyyy hh24:mi:ss'), 'I');
|
|
insert into PRM_SYSTEM (PARAMID, PARAMDESC, PARAMVALUE, UPDATEABLE, USER_UPDATE, TGL_UPDATE, FLAG_OTO, USER_OTO, TGL_OTO, PARAMTYPE)
|
|
values ('LAST_ODS', 'Tanggal Proses ODS-MIS', '20090228060000', '0', 'SYSTEM', to_date('03-12-2009 12:15:04', 'dd-mm-yyyy hh24:mi:ss'), 'O', 'SYSTEM', to_date('03-12-2009 12:15:04', 'dd-mm-yyyy hh24:mi:ss'), 'S');
|
|
insert into PRM_SYSTEM (PARAMID, PARAMDESC, PARAMVALUE, UPDATEABLE, USER_UPDATE, TGL_UPDATE, FLAG_OTO, USER_OTO, TGL_OTO, PARAMTYPE)
|
|
values ('LH_FOLDER', 'Folder Laporan Harian', '/usr/local/apache2/htdocs/mis/Data', '0', 'SYSTEM', to_date('03-12-2009 12:15:04', 'dd-mm-yyyy hh24:mi:ss'), 'O', 'SYSTEM', to_date('03-12-2009 12:15:04', 'dd-mm-yyyy hh24:mi:ss'), 'S');
|
|
insert into PRM_SYSTEM (PARAMID, PARAMDESC, PARAMVALUE, UPDATEABLE, USER_UPDATE, TGL_UPDATE, FLAG_OTO, USER_OTO, TGL_OTO, PARAMTYPE)
|
|
values ('APPS_VERSION', 'Versi Aplikasi', 'Beta R3', '0', 'SYSTEM', to_date('03-12-2009 12:15:04', 'dd-mm-yyyy hh24:mi:ss'), 'O', 'SYSTEM', to_date('03-12-2009 12:15:04', 'dd-mm-yyyy hh24:mi:ss'), 'S');
|
|
insert into PRM_SYSTEM (PARAMID, PARAMDESC, PARAMVALUE, UPDATEABLE, USER_UPDATE, TGL_UPDATE, FLAG_OTO, USER_OTO, TGL_OTO, PARAMTYPE)
|
|
values ('LAST_HIST_SALDO', 'Tanggal Terakhir History Saldo', '20070101', '0', 'SYSTEM', to_date('03-12-2009 12:15:04', 'dd-mm-yyyy hh24:mi:ss'), 'O', 'SYSTEM', to_date('03-12-2009 12:15:04', 'dd-mm-yyyy hh24:mi:ss'), 'S');
|
|
commit;
|
|
prompt 14 records loaded
|
|
|
|
prompt Loading TRANSACTION_ID_TAB...
|
|
insert into TRANSACTION_ID_TAB (PROCESS_ID, PROCESS_NAME, PROCESS_INTERVAL, PROCESS_DESC)
|
|
values ('01', 'MAP_DWH.POST_AB2_TRANSACTION', 'D', 'Posting AB2 to Staging');
|
|
insert into TRANSACTION_ID_TAB (PROCESS_ID, PROCESS_NAME, PROCESS_INTERVAL, PROCESS_DESC)
|
|
values ('02', 'MAP_DWH.POST_TREASURY_TRANSACTION', 'D', 'Posting Treasury Data to Staging');
|
|
insert into TRANSACTION_ID_TAB (PROCESS_ID, PROCESS_NAME, PROCESS_INTERVAL, PROCESS_DESC)
|
|
values ('03', 'MAP_DWH.POST_PURGING_DWH', 'Y', 'Purging Data Warehouse');
|
|
insert into TRANSACTION_ID_TAB (PROCESS_ID, PROCESS_NAME, PROCESS_INTERVAL, PROCESS_DESC)
|
|
values ('04', 'MAP_DWH.POST_GL_TRANSACTION', 'Y', 'Posting GL AB2 to Staging');
|
|
insert into TRANSACTION_ID_TAB (PROCESS_ID, PROCESS_NAME, PROCESS_INTERVAL, PROCESS_DESC)
|
|
values ('05', 'MAP_DWH.POST_KREDIT', 'Y', 'Posting Data Kredit DDKK to Staging');
|
|
|
|
commit;
|
|
prompt 3 records loaded
|
|
|
|
set feedback on
|
|
set define on
|
|
prompt Done.
|