Files
MMT/MMT_latest_version/sql/onetime/configentries/IHT_config.sql
2021-06-21 12:35:07 +05:30

102 lines
5.9 KiB
SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters
This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
insert into transactional.source_config
(file_mnemonic,file_sheet_mnemonic,block_tag,f1_modified,f1_keyword)
values
('IHTNST','IHTNST_NST','IHTNST_NST_H1','Test Request No','Test Request No'),
('IHTNST','IHTNST_NST','IHTNST_NST_Tyre_Details','Tyre Details','Tyre Details'),
('IHTNST','IHTNST_NST','IHTNST_NST_Engine_RPM_Atmos','Engine RPM','Engine RPM'),
('IHTNST','IHTNST_NST','IHTNST_NST_STAND_Noise','BY STANDERS NOISE','BY STANDERS NOISE'),
('IHTNST','IHTNST_NST','IHTNST_NST_OEL_Noise','OEL Noise without Load','OEL Noise without Load'),
('IHTNST','IHTNST_NST','IHTNST_NST_OEL_Noise_Load','OEL Noise with Load','OEL Noise with Load'),
('IHTNST','IHTNST_NST','IHTNST_NST_Footer','Prepared by','Prepared by');
insert into transactional.source_config
(file_mnemonic,file_sheet_mnemonic,block_tag,f1_modified,f1_keyword)
values
('IHTHLS','IHTHLS_HLS','IHTHLS_HLS_H1','Test Request no.','Test Request no.'),
('IHTHLS','IHTHLS_HLS','IHTHLS_HLS_Weight_Tyre','Weight Reaction','Weight Reaction'),
('IHTHLS','IHTHLS_HLS','IHTHLS_HLS_Numeric','Numerical data','Numerical data'),
('IHTHLS','IHTHLS_HLS','IHTHLS_HLS_Footer','Prepared By','Prepared By');
insert into transactional.source_config
(file_mnemonic,file_sheet_mnemonic,block_tag,f1_modified,f1_keyword)
values
('IHTBTD','IHTBTD_BTD','IHTBTD_BTD_H1','Test Request No','Test Request No'),
('IHTBTD','IHTBTD_BTD','IHTBTD_BTD_Test_Res_1','Un-Ballast cold','Un-Ballast cold'),
('IHTBTD','IHTBTD_BTD','IHTBTD_BTD_Test_Res_2','Road Ballast cold','Road Ballast cold'),
('IHTBTD','IHTBTD_BTD','IHTBTD_BTD_Test_Res_3','Road Ballast Hot','Road Ballast Hot'),
('IHTBTD','IHTBTD_BTD','IHTBTD_BTD_Test_Res_4','Max Ballast cold','Max Ballast cold'),
('IHTBTD','IHTBTD_BTD','IHTBTD_BTD_Test_Res_5','Max Ballast Hot','Max Ballast Hot'),
('IHTBTD','IHTBTD_BTD','IHTBTD_BTD_Test_Res_6','Date- 04-July-2019','Date- 04-July-2019'),
('IHTBTD','IHTBTD_BTD','IHTBTD_BTD_Weight_Tyre','Weight (kg)','Weight (kg)'),
('IHTBTD','IHTBTD_BTD','IHTBTD_BTD_Footer','Prepared by','Prepared by');
insert into transactional.source_config
(file_mnemonic,file_sheet_mnemonic,block_tag,f1_modified,f1_keyword)
values
('IHTBT50','IHTBT50_BT50','IHTBT50_BT50_H1','Test Request No','Test Request No'),
('IHTBT50','IHTBT50_BT50','IHTBT50_BT50_Test_Res_1','Un-Ballast cold','Un-Ballast cold'),
('IHTBT50','IHTBT50_BT50','IHTBT50_BT50_Test_Res_2','Ballast cold','Ballast cold'),
('IHTBT50','IHTBT50_BT50','IHTBT50_BT50_Test_Res_3','Fade Performance','Fade Performance'),
('IHTBT50','IHTBT50_BT50','IHTBT50_BT50_Test_Res_4','Recovery Performance','Recovery Performance'),
('IHTBT50','IHTBT50_BT50','IHTBT50_BT50_Weight_Tyre','Weight (kg)','Weight (kg)'),
('IHTBT50','IHTBT50_BT50','IHTBT50_BT50_Footer','Prepared by','Prepared by');
insert into transactional.source_config
(file_mnemonic,file_sheet_mnemonic,block_tag,f1_modified,f1_keyword)
values
('IHTBT30','IHTBT30_BT30','IHTBT30_BT30_H1','Test Request No','Test Request No'),
('IHTBT30','IHTBT30_BT30','IHTBT30_BT30_Test_Res_1','Un-Ballast cold','Un-Ballast cold'),
('IHTBT30','IHTBT30_BT30','IHTBT30_BT30_Test_Res_2','Ballast cold','Ballast cold'),
('IHTBT30','IHTBT30_BT30','IHTBT30_BT30_Test_Res_3','Fade Performance','Fade Performance'),
('IHTBT30','IHTBT30_BT30','IHTBT30_BT30_Test_Res_4','Recovery Performance','Recovery Performance'),
('IHTBT30','IHTBT30_BT30','IHTBT30_BT30_Weight_Tyre','Weight (kg)','Weight (kg)'),
('IHTBT30','IHTBT30_BT30','IHTBT30_BT30_Footer','Prepared by','Prepared by');
insert into transactional.source_config
(file_mnemonic,file_sheet_mnemonic,block_tag,f1_modified,f1_keyword)
values
('IHTSLL','IHTSLL_SLL','IHTSLL_SLL_H1','Test Request No','Test Request No'),
('IHTSLL','IHTSLL_SLL','IHTSLL_SLL_Weight_Tyre','Weight Reaction','Weight Reaction'),
('IHTSLL','IHTSLL_SLL','IHTSLL_SLL_Forward','K2-4WD HST EACH GEAR MAX SPEED - FORWARD','K2-4WD HST EACH GEAR MAX SPEED - FORWARD'),
('IHTSLL','IHTSLL_SLL','IHTSLL_SLL_Reverse','K2- 4WD HST EACH GEAR MAX SPEED REVERSE','K2- 4WD HST EACH GEAR MAX SPEED REVERSE'),
('IHTSLL','IHTSLL_SLL','IHTSLL_SLL_Lead_Lag','Lead / Lag Measurement on K2 4WD HST','Lead / Lag Measurement on K2 4WD HST'),
('IHTSLL','IHTSLL_SLL','IHTSLL_SLL_Footer','Prepared by','Prepared by');
insert into transactional.source_config
(file_mnemonic,file_sheet_mnemonic,block_tag,f1_modified,f1_keyword)
values
('IHTEMT','IHTEMT_EMT','IHTEMT_EMT_H1','Test Request no.','Test Request no.'),
('IHTEMT','IHTEMT_EMT','IHTEMT_EMT_Weight_Tyre','Weight Reaction','Weight Reaction'),
('IHTEMT','IHTEMT_EMT','IHTEMT_EMT_Steering','Steering effort','Steering effort'),
('IHTEMT','IHTEMT_EMT','IHTEMT_EMT_Pedal','Pedal Effort','Pedal Effort'),
('IHTEMT','IHTEMT_EMT','IHTEMT_EMT_Brake_Pedal','Brake Pedal Effort','Brake Pedal Effort'),
('IHTEMT','IHTEMT_EMT','IHTEMT_EMT_Footer','Prepared by','Prepared by');
insert into transactional.source_config
(file_mnemonic,file_sheet_mnemonic,block_tag,f1_modified,f1_keyword)
values
('IHTEMT','IHTEMT_STD','IHTEMT_STD_RAW_Data','Steering effort RAW data','Steering effort RAW data');
insert into transactional.source_config
(file_mnemonic,file_sheet_mnemonic,block_tag,f1_modified,f1_keyword)
values
('IHTCGM','IHTCGM_CGM','IHTCGM_CGM_H1','Test Request no.','Test Request no.'),
('IHTCGM','IHTCGM_CGM','IHTCGM_CGM_Weight_Tyre','Weight Reaction','Weight Reaction'),
('IHTCGM','IHTCGM_CGM','IHTCGM_CGM_Lifting','Lifting Angle & Load','Lifting Angle & Load'),
('IHTCGM','IHTCGM_CGM','IHTCGM_CGM_Footer','Prepared by','Prepared by');
insert into transactional.source_config
(file_mnemonic,file_sheet_mnemonic,block_tag,f1_modified,f1_keyword)
values
('IHTHAM','IHTHAM_HAM','IHTHAM_HAM_H1','Test Request no.','Test Request no.'),
('IHTHAM','IHTHAM_HAM','IHTHAM_HAM_Engine_Tyre_Weight','Engine (RPM)','Engine (RPM)'),
('IHTHAM','IHTHAM_HAM','IHTHAM_HAM_Atmos_Cond','Atmospheric condition','Atmospheric condition'),
('IHTHAM','IHTHAM_HAM','IHTHAM_HAM_Results','Gear','Gear'),
('IHTHAM','IHTHAM_HAM','IHTHAM_HAM_Footer','Prepared By','Prepared By');