REM ---------------------------------------------------------
REM About Author of this Script
REM Ronney Rajapathirana
REM Created for BCD Travels
REM Project : eTravel Billing Statistics
REM ---------------------------------------------------------

REM ---------------------------------------------------------
REM Setting up the Environmental Variables
REM ---------------------------------------------------------

spool off;

insert into ke014t3_support.bcd_ict_bill_dept_stat_bkup
select * from ke014t3_support.bcd_ict_bill_dept_stat_ds;
delete from ke014t3_support.bcd_ict_bill_dept_stat_ds; 
insert into ke014t3_support.bcd_ict_bill_dept_stat_ds select 
sysdate,
DATA_OF,
PERIOD,
DOMAIN,
TARGET ,
TICKET_MODIFIED_BY ,
TKT_COUNT ,
TKT_VALUE ,
OUT_OF_TARGET ,
OUT_OF_TGT_RATIO ,
LOSS_ON_INEFFICIENCY 
from ke014t3_support.bcd_ict_bill_dept_stat;


REM ---------------------------------------------------------
REM Data File Has been Created
REM ---------------------------------------------------------


quit;