Notes

screen

-- DATA FOR THE TEL INNER SYSTEM
DECLARE
v_iteration_key t_tel_iteration.iteration_key%TYPE;
v_source_1 t_tel_source.source_key%TYPE;
--v_source_2 t_tel_source.source_key%TYPE;
v_screen_1 t_tel_screen.screen_key%TYPE;
--v_screen_2 t_tel_screen.screen_key%TYPE;
--v_screen_3 t_tel_screen.screen_key%TYPE;

BEGIN
-- INSERTING into T_TEL_ITERATION
INSERT INTO t_tel_iteration (ITERATION_KEY,ITERATION_START_DATE,ITERATION_DURATION_PREVIEW,ITERATION_DURATION_REAL,ITERATION_NR_TESTED_LINES) values (1,SYSDATE,null,null,null) RETURNING iteration_key INTO v_iteration_key;

-- INSERTING into t_tel_source
INSERT INTO t_tel_source (SOURCE_KEY,SOURCE_TABLE_NAME,SOURCE_IS_REMOTE_DATABASE,SOURCE_FILE_NAME,SOURCE_DATABASE_NAME,SOURCE_DESCRIPTION,SOURCE_INACTIVE_PERIOD,SOURCE_DSA_TABLE,SOURCE_USUAL_EXTRACT_DAY,SOURCE_USUAL_EXTRACT_HOUR,SOURCE_OS_NAME,SOURCE_OS_VERSION,SOURCE_OS_HARDWARE,SOURCE_EXPIRED) values (1,'t_colocados','YES',null,'BDADOS','Main data source colocados',null,'t_data_colocados','MONDAY','05:00','LINUX','RED HAT 3.0','GATEWAY 3GB-DDR2/677 5TB-WESTERN DIGITAL-RAIDx2','NO') RETURNING source_key INTO v_source_1;

--INSERT INTO t_tel_source (SOURCE_KEY,SOURCE_TABLE_NAME,SOURCE_IS_REMOTE_DATABASE,SOURCE_FILE_NAME,SOURCE_DATABASE_NAME,SOURCE_DESCRIPTION,SOURCE_INACTIVE_PERIOD,SOURCE_DSA_TABLE,SOURCE_USUAL_EXTRACT_DAY,SOURCE_USUAL_EXTRACT_HOUR,SOURCE_OS_NAME,SOURCE_OS_VERSION,SOURCE_OS_HARDWARE,SOURCE_EXPIRED) values (5,'sheet lojas',null,'lojas.xls',null,'Data concerning stores','Mondays 01:00 to Saturdays 18:00','t_data_lojas','MONDAY','00:30','Windows','XP','Fujitsu Amilo 1337i','NO') RETURNING source_key INTO v_source_2;


-- INSERTING into t_tel_screen
INSERT INTO t_tel_screen (SCREEN_KEY,SCREEN_NAME,SCREEN_CLASS,SCREEN_TYPE,SCREEN_SQL_TEXT,SCREEN_ERROR_SEVERITY,SCREEN_ACTION_ON_ERROR,SCREEN_STAGE_TO_RUN,SCREEN_VERSION,SCREEN_EXPIRED,SCREEN_SOURCE_KEY)
values (1,'screen_incorrect_colocados','COMPLETUDE',NULL,'SELECT (...)',4,'PASS_REJECT','0',1,'NO', v_source_1) RETURNING screen_key INTO v_screen_1;


--INSERT INTO t_tel_screen (SCREEN_KEY,SCREEN_NAME,SCREEN_CLASS,SCREEN_TYPE,SCREEN_SQL_TEXT,SCREEN_ERROR_SEVERITY,SCREEN_ACTION_ON_ERROR,SCREEN_STAGE_TO_RUN,SCREEN_VERSION,SCREEN_EXPIRED,SCREEN_SOURCE_KEY)
--values (1,'screen_incorrect_colocados','CORREÇÃO',NULL,'SELECT (...)',4,'PASS_ACCEPT','0',1,'NO', v_source_1) RETURNING screen_key INTO v_screen_1;
--INSERT INTO t_tel_screen (SCREEN_KEY,SCREEN_NAME,SCREEN_CLASS,SCREEN_TYPE,SCREEN_SQL_TEXT,SCREEN_ERROR_SEVERITY,SCREEN_ACTION_ON_ERROR,SCREEN_STAGE_TO_RUN,SCREEN_VERSION,SCREEN_EXPIRED,SCREEN_SOURCE_KEY)
--values (2,'SCREEN_NULL_LIQ_WEIGHT','COMPLETUDE',NULL,'SELECT (...)',4,'PASS_REJECT','0',1,'NO', v_source_1) RETURNING screen_key INTO v_screen_2;
--INSERT INTO t_tel_screen (SCREEN_KEY,SCREEN_NAME,SCREEN_CLASS,SCREEN_TYPE,SCREEN_SQL_TEXT,SCREEN_ERROR_SEVERITY,SCREEN_ACTION_ON_ERROR,SCREEN_STAGE_TO_RUN,SCREEN_VERSION,SCREEN_EXPIRED,SCREEN_SOURCE_KEY)
--values (3,'SCREEN_INCORRECT_PRODUCTS','CORREÇÃO',NULL,'SELECT (...)',6,'PASS_ACCEPT','0',1,'NO', v_source_1) RETURNING screen_key INTO v_screen_3;

-- INSERTING into T_TEL_DATE
INSERT INTO t_tel_date (DATE_KEY, DATE_FULL, YEAR_NR, MONTH_NR, MONTH_NAME_FULL, MONTH_NAME_SHORT, DAY_NR)
SELECT date_key, date_full_date, date_year, date_month_nr, date_month_name, date_month_short_name, date_day_nr
FROM t_tel_ext_dates;

-- INSERTING into T_TEL_SCHEDULE
INSERT INTO t_tel_schedule (SCREEN_KEY,ITERATION_KEY,SOURCE_KEY,SCREEN_ORDER) values (v_screen_1,v_iteration_key,v_source_1,1);
--INSERT INTO t_tel_schedule (SCREEN_KEY,ITERATION_KEY,SOURCE_KEY,SCREEN_ORDER) values (v_screen_2,v_iteration_key,v_source_1,2);
--INSERT INTO t_tel_schedule (SCREEN_KEY,ITERATION_KEY,SOURCE_KEY,SCREEN_ORDER) values (v_screen_3,v_iteration_key,v_source_1,3);

COMMIT;
END;