--todo 10419

insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (601, 'Deliver', 20, 'Stop', 'Type', 1, to_date('01-04-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (602, 'Pick up', 20, 'Stop', 'Type', 1, to_date('01-04-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (603, 'Mixed', 20, 'Stop', 'Type', 1, to_date('01-04-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (604, 'Incidental', 20, 'Stop', 'Type', 1, to_date('01-04-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (610, 'Normal', 20, 'Stop', 'Status', 1, to_date('01-04-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (611, 'Cancelled', 20, 'Stop', 'Status', 1, to_date('01-04-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (612, 'Moved Out', 20, 'Stop', 'Status', 1, to_date('01-04-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (613, 'Moved In', 20, 'Stop', 'Status', 1, to_date('01-04-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (614, 'Inactive', 20, 'Stop', 'Status', 1, to_date('01-04-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (620, 'To be Visited', 20, 'Stop', 'Visit Status', 1, to_date('01-04-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (621, 'Visited', 20, 'Stop', 'Visit Status', 1, to_date('01-04-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (622, 'Undeliverable', 20, 'Stop', 'Visit Status', 1, to_date('01-04-2010', 'dd-mm-yyyy'));


insert into DWH_SETTINGSPERTABLE (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values ('WEEKLY_BUSINESS_UNIT_TARGETS', 'Y', 'N', 1, to_date('01-01-2010', 'dd-mm-yyyy'), 2);
insert into DWH_SETTINGSPERTABLE (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values ('WEEKLY_CORPORATE_TARGETS', 'Y', 'N', 1, to_date('01-01-2010', 'dd-mm-yyyy'), 2);
insert into DWH_SETTINGSPERTABLE (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values ('VISIT_HISTORY', 'Y', 'Y', 1, to_date('01-01-2010', 'dd-mm-yyyy'), 0);
