----------------------------------------------------------------------------------------------------
-- SCRIPT INFORMATION
----------------------------------------------------------------------------------------------------
--
-- REGION:		NORTH CENTRAL
-- FILE NAME:		TMPT39016020161012.SQL
--
-- CREATED BY:		CLEAL
-- DATE:		11/28/2016
-- TABLES:		MON_DEFL_TEMP_DEPTHS, MON_DEFL_TEMP_VALUES
--
-- REVIEWED BY:		CLEAL
--
-- EXECUTED BY:		CLEAL
--
----------------------------------------------------------------------------------------------------
-- SCRIPT DISCRIPTION
----------------------------------------------------------------------------------------------------
/*
THIS IS A SCRIPT TO UPDATE DATA IN TABLES MON_DEFL_TEMP_DEPTHS, MON_DEFL_TEMP_VALUES FOR THE NORTH CENTRAL REGION.
*/
----------------------------------------------------------------------------------------------------
-- ORIGINAL CONDITION
----------------------------------------------------------------------------------------------------
--
-- DEPTHS
--
SELECT * FROM MON_DEFL_TEMP_DEPTHS WHERE STATE_CODE=39 AND SHRP_ID='0160' AND TEST_DATE='10/12/2016';
--
-- VALUES
--
SELECT * FROM MON_DEFL_TEMP_VALUES WHERE STATE_CODE=39 AND SHRP_ID='0160' AND TEST_DATE='10/12/2016';
--
----------------------------------------------------------------------------------------------------
-- CHANGE - DELETE
----------------------------------------------------------------------------------------------------
--
-- DEPTHS
--
DELETE MON_DEFL_TEMP_DEPTHS WHERE STATE_CODE=39 AND SHRP_ID='0160' AND TEST_DATE='10/12/2016';
--
-- VALUES
--
DELETE MON_DEFL_TEMP_VALUES WHERE STATE_CODE=39 AND SHRP_ID='0160' AND TEST_DATE='10/12/2016';
--
----------------------------------------------------------------------------------------------------
-- CHANGE - INSERT
----------------------------------------------------------------------------------------------------
--
-- DEPTHS
--
-- APPROACH
--
INSERT INTO MON_DEFL_TEMP_DEPTHS (STATE_CODE,SHRP_ID,TEST_DATE,POINT_LOC,RECORD_STATUS,CONSTRUCTION_NO,LAYER_TEMP_DEPTH_1,LAYER_TEMP_DEPTH_2,LAYER_TEMP_DEPTH_3,LAYER_TEMP_DEPTH_4,LAYER_TEMP_DEPTH_5) VALUES ('39','0160','10/12/2016','-3.05','A','1','28','54','99','198','300');
--
-- LEAVE
--
INSERT INTO MON_DEFL_TEMP_DEPTHS (STATE_CODE,SHRP_ID,TEST_DATE,POINT_LOC,RECORD_STATUS,CONSTRUCTION_NO,LAYER_TEMP_DEPTH_1,LAYER_TEMP_DEPTH_2,LAYER_TEMP_DEPTH_3,LAYER_TEMP_DEPTH_4,LAYER_TEMP_DEPTH_5) VALUES ('39','0160','10/12/2016','155.45','A','1','25','49','100','97','297');
--
-- VALUES
--
-- APPROACH
--
INSERT INTO MON_DEFL_TEMP_VALUES (STATE_CODE,SHRP_ID,TEST_DATE,POINT_LOC,TIME_LAYER_TEMP,RECORD_STATUS,CONSTRUCTION_NO,LAYER_TEMPERATURE_1,LAYER_TEMPERATURE_2,LAYER_TEMPERATURE_3,LAYER_TEMPERATURE_4,LAYER_TEMPERATURE_5,WEATHER_CONDITION,SURFACE_TEMPERATURE) VALUES ('39','0160','10/12/2016','-3.05','0925','A','1','15.01','14.31','14.42','15.84','17.36','SUNNY','16.91');
--
INSERT INTO MON_DEFL_TEMP_VALUES (STATE_CODE,SHRP_ID,TEST_DATE,POINT_LOC,TIME_LAYER_TEMP,RECORD_STATUS,CONSTRUCTION_NO,LAYER_TEMPERATURE_1,LAYER_TEMPERATURE_2,LAYER_TEMPERATURE_3,LAYER_TEMPERATURE_4,LAYER_TEMPERATURE_5,WEATHER_CONDITION,SURFACE_TEMPERATURE) VALUES ('39','0160','10/12/2016','-3.05','0930','A','1','15.14','14.4','14.35','15.76','17.27','SUNNY','17.21');
--
INSERT INTO MON_DEFL_TEMP_VALUES (STATE_CODE,SHRP_ID,TEST_DATE,POINT_LOC,TIME_LAYER_TEMP,RECORD_STATUS,CONSTRUCTION_NO,LAYER_TEMPERATURE_1,LAYER_TEMPERATURE_2,LAYER_TEMPERATURE_3,LAYER_TEMPERATURE_4,LAYER_TEMPERATURE_5,WEATHER_CONDITION,SURFACE_TEMPERATURE) VALUES ('39','0160','10/12/2016','-3.05','0933','A','1','15.23','14.44','14.35','15.72','17.21','SUNNY','17.23');
--
INSERT INTO MON_DEFL_TEMP_VALUES (STATE_CODE,SHRP_ID,TEST_DATE,POINT_LOC,TIME_LAYER_TEMP,RECORD_STATUS,CONSTRUCTION_NO,LAYER_TEMPERATURE_1,LAYER_TEMPERATURE_2,LAYER_TEMPERATURE_3,LAYER_TEMPERATURE_4,LAYER_TEMPERATURE_5,WEATHER_CONDITION,SURFACE_TEMPERATURE) VALUES ('39','0160','10/12/2016','-3.05','0936','A','1','15.34','14.49','14.36','15.62','17.13','SUNNY','17.35');
--
INSERT INTO MON_DEFL_TEMP_VALUES (STATE_CODE,SHRP_ID,TEST_DATE,POINT_LOC,TIME_LAYER_TEMP,RECORD_STATUS,CONSTRUCTION_NO,LAYER_TEMPERATURE_1,LAYER_TEMPERATURE_2,LAYER_TEMPERATURE_3,LAYER_TEMPERATURE_4,LAYER_TEMPERATURE_5,WEATHER_CONDITION,SURFACE_TEMPERATURE) VALUES ('39','0160','10/12/2016','-3.05','0939','A','1','15.43','14.57','14.37','15.57','17.07','SUNNY','17.33');
--
INSERT INTO MON_DEFL_TEMP_VALUES (STATE_CODE,SHRP_ID,TEST_DATE,POINT_LOC,TIME_LAYER_TEMP,RECORD_STATUS,CONSTRUCTION_NO,LAYER_TEMPERATURE_1,LAYER_TEMPERATURE_2,LAYER_TEMPERATURE_3,LAYER_TEMPERATURE_4,LAYER_TEMPERATURE_5,WEATHER_CONDITION,SURFACE_TEMPERATURE) VALUES ('39','0160','10/12/2016','-3.05','0943','A','1','15.55','14.67','14.39','15.51','17','SUNNY','17.54');
--
INSERT INTO MON_DEFL_TEMP_VALUES (STATE_CODE,SHRP_ID,TEST_DATE,POINT_LOC,TIME_LAYER_TEMP,RECORD_STATUS,CONSTRUCTION_NO,LAYER_TEMPERATURE_1,LAYER_TEMPERATURE_2,LAYER_TEMPERATURE_3,LAYER_TEMPERATURE_4,LAYER_TEMPERATURE_5,WEATHER_CONDITION,SURFACE_TEMPERATURE) VALUES ('39','0160','10/12/2016','-3.05','0945','A','1','15.7','14.76','14.39','15.49','16.97','SUNNY','17.76');
--
INSERT INTO MON_DEFL_TEMP_VALUES (STATE_CODE,SHRP_ID,TEST_DATE,POINT_LOC,TIME_LAYER_TEMP,RECORD_STATUS,CONSTRUCTION_NO,LAYER_TEMPERATURE_1,LAYER_TEMPERATURE_2,LAYER_TEMPERATURE_3,LAYER_TEMPERATURE_4,LAYER_TEMPERATURE_5,WEATHER_CONDITION,SURFACE_TEMPERATURE) VALUES ('39','0160','10/12/2016','-3.05','0948','A','1','15.77','14.82','14.39','15.46','16.91','SUNNY','17.59');
--
INSERT INTO MON_DEFL_TEMP_VALUES (STATE_CODE,SHRP_ID,TEST_DATE,POINT_LOC,TIME_LAYER_TEMP,RECORD_STATUS,CONSTRUCTION_NO,LAYER_TEMPERATURE_1,LAYER_TEMPERATURE_2,LAYER_TEMPERATURE_3,LAYER_TEMPERATURE_4,LAYER_TEMPERATURE_5,WEATHER_CONDITION,SURFACE_TEMPERATURE) VALUES ('39','0160','10/12/2016','-3.05','0951','A','1','15.94','14.96','14.44','15.47','16.85','SUNNY','17.94');
--
INSERT INTO MON_DEFL_TEMP_VALUES (STATE_CODE,SHRP_ID,TEST_DATE,POINT_LOC,TIME_LAYER_TEMP,RECORD_STATUS,CONSTRUCTION_NO,LAYER_TEMPERATURE_1,LAYER_TEMPERATURE_2,LAYER_TEMPERATURE_3,LAYER_TEMPERATURE_4,LAYER_TEMPERATURE_5,WEATHER_CONDITION,SURFACE_TEMPERATURE) VALUES ('39','0160','10/12/2016','-3.05','0955','A','1','16.22','15.15','14.53','15.49','16.81','SUNNY','18.2');
--
INSERT INTO MON_DEFL_TEMP_VALUES (STATE_CODE,SHRP_ID,TEST_DATE,POINT_LOC,TIME_LAYER_TEMP,RECORD_STATUS,CONSTRUCTION_NO,LAYER_TEMPERATURE_1,LAYER_TEMPERATURE_2,LAYER_TEMPERATURE_3,LAYER_TEMPERATURE_4,LAYER_TEMPERATURE_5,WEATHER_CONDITION,SURFACE_TEMPERATURE) VALUES ('39','0160','10/12/2016','-3.05','0957','A','1','16.28','15.21','14.54','15.5','16.8','SUNNY','18.23');
--
-- LEAVE
--
INSERT INTO MON_DEFL_TEMP_VALUES (STATE_CODE,SHRP_ID,TEST_DATE,POINT_LOC,TIME_LAYER_TEMP,RECORD_STATUS,CONSTRUCTION_NO,LAYER_TEMPERATURE_1,LAYER_TEMPERATURE_2,LAYER_TEMPERATURE_3,LAYER_TEMPERATURE_4,LAYER_TEMPERATURE_5,WEATHER_CONDITION,SURFACE_TEMPERATURE) VALUES ('39','0160','10/12/2016','155.45','1000','A','1','16.45','15.36','14.62','15.48','16.76','SUNNY','18.34');
--
INSERT INTO MON_DEFL_TEMP_VALUES (STATE_CODE,SHRP_ID,TEST_DATE,POINT_LOC,TIME_LAYER_TEMP,RECORD_STATUS,CONSTRUCTION_NO,LAYER_TEMPERATURE_1,LAYER_TEMPERATURE_2,LAYER_TEMPERATURE_3,LAYER_TEMPERATURE_4,LAYER_TEMPERATURE_5,WEATHER_CONDITION,SURFACE_TEMPERATURE) VALUES ('39','0160','10/12/2016','155.45','1003','A','1','16.59','15.48','14.67','15.48','16.71','SUNNY','18.52');
--
INSERT INTO MON_DEFL_TEMP_VALUES (STATE_CODE,SHRP_ID,TEST_DATE,POINT_LOC,TIME_LAYER_TEMP,RECORD_STATUS,CONSTRUCTION_NO,LAYER_TEMPERATURE_1,LAYER_TEMPERATURE_2,LAYER_TEMPERATURE_3,LAYER_TEMPERATURE_4,LAYER_TEMPERATURE_5,WEATHER_CONDITION,SURFACE_TEMPERATURE) VALUES ('39','0160','10/12/2016','155.45','1005','A','1','16.74','15.55','14.7','15.52','16.71','SUNNY','18.66');
--
INSERT INTO MON_DEFL_TEMP_VALUES (STATE_CODE,SHRP_ID,TEST_DATE,POINT_LOC,TIME_LAYER_TEMP,RECORD_STATUS,CONSTRUCTION_NO,LAYER_TEMPERATURE_1,LAYER_TEMPERATURE_2,LAYER_TEMPERATURE_3,LAYER_TEMPERATURE_4,LAYER_TEMPERATURE_5,WEATHER_CONDITION,SURFACE_TEMPERATURE) VALUES ('39','0160','10/12/2016','155.45','1009','A','1','16.94','15.72','14.76','15.47','16.64','SUNNY','18.94');
--
INSERT INTO MON_DEFL_TEMP_VALUES (STATE_CODE,SHRP_ID,TEST_DATE,POINT_LOC,TIME_LAYER_TEMP,RECORD_STATUS,CONSTRUCTION_NO,LAYER_TEMPERATURE_1,LAYER_TEMPERATURE_2,LAYER_TEMPERATURE_3,LAYER_TEMPERATURE_4,LAYER_TEMPERATURE_5,WEATHER_CONDITION,SURFACE_TEMPERATURE) VALUES ('39','0160','10/12/2016','155.45','1011','A','1','17.08','15.81','14.81','15.49','16.62','SUNNY','19.16');
--
INSERT INTO MON_DEFL_TEMP_VALUES (STATE_CODE,SHRP_ID,TEST_DATE,POINT_LOC,TIME_LAYER_TEMP,RECORD_STATUS,CONSTRUCTION_NO,LAYER_TEMPERATURE_1,LAYER_TEMPERATURE_2,LAYER_TEMPERATURE_3,LAYER_TEMPERATURE_4,LAYER_TEMPERATURE_5,WEATHER_CONDITION,SURFACE_TEMPERATURE) VALUES ('39','0160','10/12/2016','155.45','1015','A','1','17.23','15.95','14.86','15.46','16.64','SUNNY','19.26');
--
INSERT INTO MON_DEFL_TEMP_VALUES (STATE_CODE,SHRP_ID,TEST_DATE,POINT_LOC,TIME_LAYER_TEMP,RECORD_STATUS,CONSTRUCTION_NO,LAYER_TEMPERATURE_1,LAYER_TEMPERATURE_2,LAYER_TEMPERATURE_3,LAYER_TEMPERATURE_4,LAYER_TEMPERATURE_5,WEATHER_CONDITION,SURFACE_TEMPERATURE) VALUES ('39','0160','10/12/2016','155.45','1017','A','1','17.38','16.04','14.9','15.46','16.67','SUNNY','19.47');
--
INSERT INTO MON_DEFL_TEMP_VALUES (STATE_CODE,SHRP_ID,TEST_DATE,POINT_LOC,TIME_LAYER_TEMP,RECORD_STATUS,CONSTRUCTION_NO,LAYER_TEMPERATURE_1,LAYER_TEMPERATURE_2,LAYER_TEMPERATURE_3,LAYER_TEMPERATURE_4,LAYER_TEMPERATURE_5,WEATHER_CONDITION,SURFACE_TEMPERATURE) VALUES ('39','0160','10/12/2016','155.45','1020','A','1','17.56','16.19','14.97','15.46','16.68','SUNNY','19.48');
--
INSERT INTO MON_DEFL_TEMP_VALUES (STATE_CODE,SHRP_ID,TEST_DATE,POINT_LOC,TIME_LAYER_TEMP,RECORD_STATUS,CONSTRUCTION_NO,LAYER_TEMPERATURE_1,LAYER_TEMPERATURE_2,LAYER_TEMPERATURE_3,LAYER_TEMPERATURE_4,LAYER_TEMPERATURE_5,WEATHER_CONDITION,SURFACE_TEMPERATURE) VALUES ('39','0160','10/12/2016','155.45','1022','A','1','17.88','16.39','14.94','15.27','16.37','SUNNY','18.81');
--
INSERT INTO MON_DEFL_TEMP_VALUES (STATE_CODE,SHRP_ID,TEST_DATE,POINT_LOC,TIME_LAYER_TEMP,RECORD_STATUS,CONSTRUCTION_NO,LAYER_TEMPERATURE_1,LAYER_TEMPERATURE_2,LAYER_TEMPERATURE_3,LAYER_TEMPERATURE_4,LAYER_TEMPERATURE_5,WEATHER_CONDITION,SURFACE_TEMPERATURE) VALUES ('39','0160','10/12/2016','155.45','1025','A','1','17.88','16.52','14.98','15.26','16.44','SUNNY','18.04');
--
-- APPROACH
--
INSERT INTO MON_DEFL_TEMP_VALUES (STATE_CODE,SHRP_ID,TEST_DATE,POINT_LOC,TIME_LAYER_TEMP,RECORD_STATUS,CONSTRUCTION_NO,LAYER_TEMPERATURE_1,LAYER_TEMPERATURE_2,LAYER_TEMPERATURE_3,LAYER_TEMPERATURE_4,LAYER_TEMPERATURE_5,WEATHER_CONDITION,SURFACE_TEMPERATURE) VALUES ('39','0160','10/12/2016','-3.05','1041','A','1','18.84','16.99','15.21','15.16','16.38','SUNNY','21.58');
--
INSERT INTO MON_DEFL_TEMP_VALUES (STATE_CODE,SHRP_ID,TEST_DATE,POINT_LOC,TIME_LAYER_TEMP,RECORD_STATUS,CONSTRUCTION_NO,LAYER_TEMPERATURE_1,LAYER_TEMPERATURE_2,LAYER_TEMPERATURE_3,LAYER_TEMPERATURE_4,LAYER_TEMPERATURE_5,WEATHER_CONDITION,SURFACE_TEMPERATURE) VALUES ('39','0160','10/12/2016','-3.05','1045','A','1','18.89','17.1','15.18','15.05','16.22','SUNNY','21.3');
--
INSERT INTO MON_DEFL_TEMP_VALUES (STATE_CODE,SHRP_ID,TEST_DATE,POINT_LOC,TIME_LAYER_TEMP,RECORD_STATUS,CONSTRUCTION_NO,LAYER_TEMPERATURE_1,LAYER_TEMPERATURE_2,LAYER_TEMPERATURE_3,LAYER_TEMPERATURE_4,LAYER_TEMPERATURE_5,WEATHER_CONDITION,SURFACE_TEMPERATURE) VALUES ('39','0160','10/12/2016','-3.05','1048','A','1','19.05','17.25','15.24','15.11','16.21','SUNNY','21.22');
--
INSERT INTO MON_DEFL_TEMP_VALUES (STATE_CODE,SHRP_ID,TEST_DATE,POINT_LOC,TIME_LAYER_TEMP,RECORD_STATUS,CONSTRUCTION_NO,LAYER_TEMPERATURE_1,LAYER_TEMPERATURE_2,LAYER_TEMPERATURE_3,LAYER_TEMPERATURE_4,LAYER_TEMPERATURE_5,WEATHER_CONDITION,SURFACE_TEMPERATURE) VALUES ('39','0160','10/12/2016','-3.05','1054','A','1','19.37','17.59','15.47','15.1','16.21','SUNNY','21.81');
--
INSERT INTO MON_DEFL_TEMP_VALUES (STATE_CODE,SHRP_ID,TEST_DATE,POINT_LOC,TIME_LAYER_TEMP,RECORD_STATUS,CONSTRUCTION_NO,LAYER_TEMPERATURE_1,LAYER_TEMPERATURE_2,LAYER_TEMPERATURE_3,LAYER_TEMPERATURE_4,LAYER_TEMPERATURE_5,WEATHER_CONDITION,SURFACE_TEMPERATURE) VALUES ('39','0160','10/12/2016','-3.05','1056','A','1','19.46','17.66','15.51','15.12','16.16','SUNNY','21.67');
--
INSERT INTO MON_DEFL_TEMP_VALUES (STATE_CODE,SHRP_ID,TEST_DATE,POINT_LOC,TIME_LAYER_TEMP,RECORD_STATUS,CONSTRUCTION_NO,LAYER_TEMPERATURE_1,LAYER_TEMPERATURE_2,LAYER_TEMPERATURE_3,LAYER_TEMPERATURE_4,LAYER_TEMPERATURE_5,WEATHER_CONDITION,SURFACE_TEMPERATURE) VALUES ('39','0160','10/12/2016','-3.05','1059','A','1','19.64','17.86','15.65','15.2','16.24','SUNNY','21.67');
--
INSERT INTO MON_DEFL_TEMP_VALUES (STATE_CODE,SHRP_ID,TEST_DATE,POINT_LOC,TIME_LAYER_TEMP,RECORD_STATUS,CONSTRUCTION_NO,LAYER_TEMPERATURE_1,LAYER_TEMPERATURE_2,LAYER_TEMPERATURE_3,LAYER_TEMPERATURE_4,LAYER_TEMPERATURE_5,WEATHER_CONDITION,SURFACE_TEMPERATURE) VALUES ('39','0160','10/12/2016','-3.05','1102','A','1','19.81','18.07','15.78','15.17','16.18','SUNNY','22.05');
--
INSERT INTO MON_DEFL_TEMP_VALUES (STATE_CODE,SHRP_ID,TEST_DATE,POINT_LOC,TIME_LAYER_TEMP,RECORD_STATUS,CONSTRUCTION_NO,LAYER_TEMPERATURE_1,LAYER_TEMPERATURE_2,LAYER_TEMPERATURE_3,LAYER_TEMPERATURE_4,LAYER_TEMPERATURE_5,WEATHER_CONDITION,SURFACE_TEMPERATURE) VALUES ('39','0160','10/12/2016','-3.05','1105','A','1','20.04','18.28','15.93','15.23','16.2','SUNNY','22.24');
--
INSERT INTO MON_DEFL_TEMP_VALUES (STATE_CODE,SHRP_ID,TEST_DATE,POINT_LOC,TIME_LAYER_TEMP,RECORD_STATUS,CONSTRUCTION_NO,LAYER_TEMPERATURE_1,LAYER_TEMPERATURE_2,LAYER_TEMPERATURE_3,LAYER_TEMPERATURE_4,LAYER_TEMPERATURE_5,WEATHER_CONDITION,SURFACE_TEMPERATURE) VALUES ('39','0160','10/12/2016','-3.05','1108','A','1','20.25','18.42','16.06','15.28','16.22','SUNNY','22.33');
--
INSERT INTO MON_DEFL_TEMP_VALUES (STATE_CODE,SHRP_ID,TEST_DATE,POINT_LOC,TIME_LAYER_TEMP,RECORD_STATUS,CONSTRUCTION_NO,LAYER_TEMPERATURE_1,LAYER_TEMPERATURE_2,LAYER_TEMPERATURE_3,LAYER_TEMPERATURE_4,LAYER_TEMPERATURE_5,WEATHER_CONDITION,SURFACE_TEMPERATURE) VALUES ('39','0160','10/12/2016','-3.05','1110','A','1','20.34','18.52','16.11','15.32','16.26','SUNNY','22.57');
--
INSERT INTO MON_DEFL_TEMP_VALUES (STATE_CODE,SHRP_ID,TEST_DATE,POINT_LOC,TIME_LAYER_TEMP,RECORD_STATUS,CONSTRUCTION_NO,LAYER_TEMPERATURE_1,LAYER_TEMPERATURE_2,LAYER_TEMPERATURE_3,LAYER_TEMPERATURE_4,LAYER_TEMPERATURE_5,WEATHER_CONDITION,SURFACE_TEMPERATURE) VALUES ('39','0160','10/12/2016','-3.05','1114','A','1','20.61','18.73','16.29','15.38','16.25','SUNNY','22.65');
--
-- LEAVE
--
INSERT INTO MON_DEFL_TEMP_VALUES (STATE_CODE,SHRP_ID,TEST_DATE,POINT_LOC,TIME_LAYER_TEMP,RECORD_STATUS,CONSTRUCTION_NO,LAYER_TEMPERATURE_1,LAYER_TEMPERATURE_2,LAYER_TEMPERATURE_3,LAYER_TEMPERATURE_4,LAYER_TEMPERATURE_5,WEATHER_CONDITION,SURFACE_TEMPERATURE) VALUES ('39','0160','10/12/2016','155.45','1117','A','1','20.61','18.51','15.71','14.92','15.49','SUNNY','21.94');
--
INSERT INTO MON_DEFL_TEMP_VALUES (STATE_CODE,SHRP_ID,TEST_DATE,POINT_LOC,TIME_LAYER_TEMP,RECORD_STATUS,CONSTRUCTION_NO,LAYER_TEMPERATURE_1,LAYER_TEMPERATURE_2,LAYER_TEMPERATURE_3,LAYER_TEMPERATURE_4,LAYER_TEMPERATURE_5,WEATHER_CONDITION,SURFACE_TEMPERATURE) VALUES ('39','0160','10/12/2016','155.45','1119','A','1','20.71','18.6','15.74','14.89','15.46','SUNNY','21.96');
--
INSERT INTO MON_DEFL_TEMP_VALUES (STATE_CODE,SHRP_ID,TEST_DATE,POINT_LOC,TIME_LAYER_TEMP,RECORD_STATUS,CONSTRUCTION_NO,LAYER_TEMPERATURE_1,LAYER_TEMPERATURE_2,LAYER_TEMPERATURE_3,LAYER_TEMPERATURE_4,LAYER_TEMPERATURE_5,WEATHER_CONDITION,SURFACE_TEMPERATURE) VALUES ('39','0160','10/12/2016','155.45','1122','A','1','20.89','18.79','15.85','14.95','15.5','SUNNY','22.17');
--
INSERT INTO MON_DEFL_TEMP_VALUES (STATE_CODE,SHRP_ID,TEST_DATE,POINT_LOC,TIME_LAYER_TEMP,RECORD_STATUS,CONSTRUCTION_NO,LAYER_TEMPERATURE_1,LAYER_TEMPERATURE_2,LAYER_TEMPERATURE_3,LAYER_TEMPERATURE_4,LAYER_TEMPERATURE_5,WEATHER_CONDITION,SURFACE_TEMPERATURE) VALUES ('39','0160','10/12/2016','155.45','1130','A','1','21.45','19.26','16.13','14.96','15.37','SUNNY','22.82');
--
INSERT INTO MON_DEFL_TEMP_VALUES (STATE_CODE,SHRP_ID,TEST_DATE,POINT_LOC,TIME_LAYER_TEMP,RECORD_STATUS,CONSTRUCTION_NO,LAYER_TEMPERATURE_1,LAYER_TEMPERATURE_2,LAYER_TEMPERATURE_3,LAYER_TEMPERATURE_4,LAYER_TEMPERATURE_5,WEATHER_CONDITION,SURFACE_TEMPERATURE) VALUES ('39','0160','10/12/2016','155.45','1133','A','1','21.67','19.41','16.18','14.95','15.34','SUNNY','23.09');
--
INSERT INTO MON_DEFL_TEMP_VALUES (STATE_CODE,SHRP_ID,TEST_DATE,POINT_LOC,TIME_LAYER_TEMP,RECORD_STATUS,CONSTRUCTION_NO,LAYER_TEMPERATURE_1,LAYER_TEMPERATURE_2,LAYER_TEMPERATURE_3,LAYER_TEMPERATURE_4,LAYER_TEMPERATURE_5,WEATHER_CONDITION,SURFACE_TEMPERATURE) VALUES ('39','0160','10/12/2016','155.45','1137','A','1','21.84','19.6','16.3','14.91','15.15','SUNNY','23.35');
--
INSERT INTO MON_DEFL_TEMP_VALUES (STATE_CODE,SHRP_ID,TEST_DATE,POINT_LOC,TIME_LAYER_TEMP,RECORD_STATUS,CONSTRUCTION_NO,LAYER_TEMPERATURE_1,LAYER_TEMPERATURE_2,LAYER_TEMPERATURE_3,LAYER_TEMPERATURE_4,LAYER_TEMPERATURE_5,WEATHER_CONDITION,SURFACE_TEMPERATURE) VALUES ('39','0160','10/12/2016','155.45','1139','A','1','22.01','19.75','16.4','14.97','15.22','SUNNY','23.41');
--
INSERT INTO MON_DEFL_TEMP_VALUES (STATE_CODE,SHRP_ID,TEST_DATE,POINT_LOC,TIME_LAYER_TEMP,RECORD_STATUS,CONSTRUCTION_NO,LAYER_TEMPERATURE_1,LAYER_TEMPERATURE_2,LAYER_TEMPERATURE_3,LAYER_TEMPERATURE_4,LAYER_TEMPERATURE_5,WEATHER_CONDITION,SURFACE_TEMPERATURE) VALUES ('39','0160','10/12/2016','155.45','1142','A','1','22.21','19.89','16.48','14.95','15.16','SUNNY','23.72');
--
INSERT INTO MON_DEFL_TEMP_VALUES (STATE_CODE,SHRP_ID,TEST_DATE,POINT_LOC,TIME_LAYER_TEMP,RECORD_STATUS,CONSTRUCTION_NO,LAYER_TEMPERATURE_1,LAYER_TEMPERATURE_2,LAYER_TEMPERATURE_3,LAYER_TEMPERATURE_4,LAYER_TEMPERATURE_5,WEATHER_CONDITION,SURFACE_TEMPERATURE) VALUES ('39','0160','10/12/2016','155.45','1146','A','1','22.53','20.15','16.59','14.93','15.08','SUNNY','24');
--
INSERT INTO MON_DEFL_TEMP_VALUES (STATE_CODE,SHRP_ID,TEST_DATE,POINT_LOC,TIME_LAYER_TEMP,RECORD_STATUS,CONSTRUCTION_NO,LAYER_TEMPERATURE_1,LAYER_TEMPERATURE_2,LAYER_TEMPERATURE_3,LAYER_TEMPERATURE_4,LAYER_TEMPERATURE_5,WEATHER_CONDITION,SURFACE_TEMPERATURE) VALUES ('39','0160','10/12/2016','155.45','1159','A','1','23.28','20.93','17.51','15.29','15.66','SUNNY','25.55');
--
----------------------------------------------------------------------------------------------------
-- VERIFY CHANGE
----------------------------------------------------------------------------------------------------
--
-- DEPTHS
--
SELECT * FROM MON_DEFL_TEMP_DEPTHS WHERE STATE_CODE=39 AND SHRP_ID='0160' AND TEST_DATE='10/12/2016';
--
-- VALUES
--
SELECT * FROM MON_DEFL_TEMP_VALUES WHERE STATE_CODE=39 AND SHRP_ID='0160' AND TEST_DATE='10/12/2016';
--
----------------------------------------------------------------------------------------------------
-- ROLLBACK
----------------------------------------------------------------------------------------------------
--
ROLLBACK;
--
----------------------------------------------------------------------------------------------------
