text: ALTER DEFINER=`ciuser`@`host` VIEW `cilisting` AS select `cilist`.`cilisting1`.`ft` AS `ft`,`cilist`.`cilisting1`.`project_number` AS `project_number`,`cilist`.`cilisting1`.`project_description` AS `project_description`,`cilist`.`cilisting1`.`owner` AS `owner`,`cilist`.`cilisting1`.`planned_timing` AS `planned_timing`,`cilist`.`cilisting1`.`revised_timing` AS `revised_timing`,`cilist`.`cilisting1`.`estimated_cost` AS `estimated_cost`,`cilist`.`cilisting1`.`savings_category` AS `savings_category`,`cilist`.`cilisting1`.`annual_savings_dollars` AS `annual_savings_dollars`,`cilist`.`cilisting1`.`percent_complete` AS `percent_complete`,`cilist`.`cilisting1`.`comments` AS `comments`,`cilist`.`cilisting1`.`originator` AS `originator`,`cilist`.`cilisting1`.`team` AS `team`,`cilist`.`cilisting1`.`documents_complete` AS `documents_complete`,`cilist`.`cilisting1`.`one_time_savings` AS `one_time_savings`,`cilist`.`cilisting1`.`hard_soft_savings` AS `hard_soft_savings`,`cilist`.`cilisting1`.`soft_dollars` AS `soft_dollars`,`cilist`.`cilisting1`.`il1_target_date` AS `il1_target_date`,`cilist`.`cilisting1`.`il2_target_date` AS `il2_target_date`,`cilist`.`cilisting1`.`il3_target_date` AS `il3_target_date`,`cilist`.`cilisting1`.`il4_target_date` AS `il4_target_date`,`cilist`.`cilisting1`.`il5_target_date` AS `il5_target_date`,`cilist`.`cilisting1`.`wc_idea_date` AS `wc_idea_date`,`cilist`.`cilisting1`.`actual_implementation_date` AS `actual_implementation_date`,`cilist`.`cilisting1`.`enter_in_wc` AS `enter_in_wc`,`cilist`.`cilisting1`.`area` AS `area`,`cilist`.`cilisting1`.`updatedtime` AS `updatedtime`,`cilist`.`cilisting1`.`id_wc` AS `id_wc`,`cilist`.`cilisting1`.`environmental` AS `environmental`,`cilist`.`cilisting1`.`ease_of_implementation` AS `ease_of_implementation`,`cilist`.`cilisting1`.`submit` AS `submit`,`cilist`.`cilisting1`.`line_num` AS `line_num`,`cilist`.`cilisting1`.`next_steps` AS `next_steps`,`cilist`.`cilisting1`.`suggestion_status` AS `suggestion_status`,`cilist`.`cilisting1`.`ci_leader_1` AS `ci_leader_1`,`cilist`.`cilisting1`.`group` AS `group`,`cilist`.`cilisting1`.`metric_impact` AS `metric_impact`,`cilist`.`cilisting1`.`gift_4_suggestion` AS `gift_4_suggestion`,`cilist`.`cilisting1`.`il_current` AS `il_current`,`cilist`.`cilisting1`.`createdtime` AS `createdtime`,`cilist`.`cilisting1`.`link` AS `link`,`cilist`.`cilisting1`.`linkmore` AS `linkmore`,`cilist`.`cilisting1`.`display` AS `display`,`cilist`.`cilisting1`.`idea_Qtr_1` AS `idea_Qtr_1`,`cilist`.`cilisting1`.`orginator_email` AS `orginator_email`,`cilist`.`cilisting1`.`ciid` AS `ciid`,`cilist`.`cilisting1`.`z-updatedtime` AS `z-updatedtime`,concat_ws('_',substr(`cilist`.`cilisting1`.`project_number`,1,9),substr(`cilist`.`cilisting1`.`originator`,1,15),substr(`cilist`.`cilisting1`.`project_description`,1,29)) AS `record_ref`,quarter(`cilist`.`cilisting1`.`wc_idea_date`) AS `idea_qtr`,`cilist`.`leader`.`fullcommonname` AS `fullcommonname`,`cilist`.`leader`.`ci_leader` AS `ci_leader` from (`cilist`.`cilisting1` left join `cilist`.`leader` on((`cilist`.`cilisting1`.`originator` = `cilist`.`leader`.`fullcommonname`)));
  ALTER DEFINER=`ciuser`@`host` VIEW `cilisting1_vw_1` AS select `cilist`.`cilisting1`.`ft` AS `ft`,`cilist`.`cilisting1`.`project_number` AS `project_number`,`cilist`.`cilisting1`.`project_description` AS `project_description`,`cilist`.`cilisting1`.`owner` AS `owner`,`cilist`.`cilisting1`.`planned_timing` AS `planned_timing`,`cilist`.`cilisting1`.`revised_timing` AS `revised_timing`,`cilist`.`cilisting1`.`estimated_cost` AS `estimated_cost`,`cilist`.`cilisting1`.`savings_category` AS `savings_category`,`cilist`.`cilisting1`.`annual_savings_dollars` AS `annual_savings_dollars`,`cilist`.`cilisting1`.`percent_complete` AS `percent_complete`,`cilist`.`cilisting1`.`comments` AS `comments`,`cilist`.`cilisting1`.`originator` AS `originator`,`cilist`.`cilisting1`.`team` AS `team`,`cilist`.`cilisting1`.`documents_complete` AS `documents_complete`,`cilist`.`cilisting1`.`one_time_savings` AS `one_time_savings`,`cilist`.`cilisting1`.`hard_soft_savings` AS `hard_soft_savings`,`cilist`.`cilisting1`.`soft_dollars` AS `soft_dollars`,`cilist`.`cilisting1`.`il1_target_date` AS `il1_target_date`,`cilist`.`cilisting1`.`il2_target_date` AS `il2_target_date`,`cilist`.`cilisting1`.`il3_target_date` AS `il3_target_date`,`cilist`.`cilisting1`.`il4_target_date` AS `il4_target_date`,`cilist`.`cilisting1`.`il5_target_date` AS `il5_target_date`,`cilist`.`cilisting1`.`wc_idea_date` AS `wc_idea_date`,`cilist`.`cilisting1`.`actual_implementation_date` AS `actual_implementation_date`,`cilist`.`cilisting1`.`enter_in_wc` AS `enter_in_wc`,`cilist`.`cilisting1`.`area` AS `area`,`cilist`.`cilisting1`.`updatedtime` AS `updatedtime`,`cilist`.`cilisting1`.`id_wc` AS `id_wc`,`cilist`.`cilisting1`.`environmental` AS `environmental`,`cilist`.`cilisting1`.`ease_of_implementation` AS `ease_of_implementation`,`cilist`.`cilisting1`.`submit` AS `submit`,`cilist`.`cilisting1`.`line_num` AS `line_num`,`cilist`.`cilisting1`.`next_steps` AS `next_steps`,`cilist`.`cilisting1`.`suggestion_status` AS `suggestion_status`,`cilist`.`cilisting1`.`ci_leader_1` AS `ci_leader_1`,`cilist`.`cilisting1`.`group` AS `group`,`cilist`.`cilisting1`.`metric_impact` AS `metric_impact`,`cilist`.`cilisting1`.`gift_4_suggestion` AS `gift_4_suggestion`,`cilist`.`cilisting1`.`il_current` AS `il_current`,`cilist`.`cilisting1`.`createdtime` AS `createdtime`,`cilist`.`cilisting1`.`link` AS `link`,`cilist`.`cilisting1`.`display` AS `display`,`cilist`.`cilisting1`.`idea_Qtr_1` AS `idea_Qtr_1`,`cilist`.`cilisting1`.`orginator_email` AS `orginator_email`,`cilist`.`cilisting1`.`ciid` AS `ciid`,`cilist`.`cilisting1`.`z-updatedtime` AS `z-updatedtime` from `cilist`.`cilisting1`;
  ALTER DEFINER=`ciuser`@`host` VIEW `cilisting_vw_2` AS select `cilisting`.`ft` AS `ft`,`cilisting`.`project_number` AS `project_number`,`cilisting`.`project_description` AS `project_description`,`cilisting`.`owner` AS `owner`,`cilisting`.`planned_timing` AS `planned_timing`,`cilisting`.`revised_timing` AS `revised_timing`,`cilisting`.`estimated_cost` AS `estimated_cost`,`cilisting`.`savings_category` AS `savings_category`,`cilisting`.`annual_savings_dollars` AS `annual_savings_dollars`,`cilisting`.`percent_complete` AS `percent_complete`,`cilisting`.`comments` AS `comments`,`cilisting`.`originator` AS `originator`,`cilisting`.`team` AS `team`,`cilisting`.`documents_complete` AS `documents_complete`,`cilisting`.`one_time_savings` AS `one_time_savings`,`cilisting`.`hard_soft_savings` AS `hard_soft_savings`,`cilisting`.`soft_dollars` AS `soft_dollars`,`cilisting`.`il1_target_date` AS `il1_target_date`,`cilisting`.`il2_target_date` AS `il2_target_date`,`cilisting`.`il3_target_date` AS `il3_target_date`,`cilisting`.`il4_target_date` AS `il4_target_date`,`cilisting`.`il5_target_date` AS `il5_target_date`,`cilisting`.`wc_idea_date` AS `wc_idea_date`,`cilisting`.`actual_implementation_date` AS `actual_implementation_date`,`cilisting`.`enter_in_wc` AS `enter_in_wc`,`cilisting`.`area` AS `area`,`cilisting`.`updatedtime` AS `updatedtime`,`cilisting`.`id_wc` AS `id_wc`,`cilisting`.`environmental` AS `environmental`,`cilisting`.`ease_of_implementation` AS `ease_of_implementation`,`cilisting`.`submit` AS `submit`,`cilisting`.`line_num` AS `line_num`,`cilisting`.`next_steps` AS `next_steps`,`cilisting`.`suggestion_status` AS `suggestion_status`,`cilisting`.`ci_leader_1` AS `ci_leader_1`,`cilisting`.`group` AS `group`,`cilisting`.`metric_impact` AS `metric_impact`,`cilisting`.`gift_4_suggestion` AS `gift_4_suggestion`,`cilisting`.`il_current` AS `il_current`,`cilisting`.`createdtime` AS `createdtime`,`cilisting`.`link` AS `link`,`cilisting`.`display` AS `display`,`cilisting`.`idea_Qtr_1` AS `idea_Qtr_1`,`cilisting`.`orginator_email` AS `orginator_email`,`cilisting`.`ciid` AS `ciid`,`cilisting`.`z-updatedtime` AS `z-updatedtime`,`cilisting`.`record_ref` AS `record_ref`,`cilisting`.`idea_qtr` AS `idea_qtr`,`cilisting`.`fullcommonname` AS `fullcommonname`,`cilisting`.`ci_leader` AS `ci_leader` from `cilist`.`cilisting`;
  ALTER DEFINER=`ciuser`@`host` VIEW `dataface__view_217a361f8504a040d643403cf13e8297` AS select `cilist`.`cilisting1`.`ft` AS `ft`,`cilist`.`cilisting1`.`project_number` AS `project_number`,`cilist`.`cilisting1`.`project_description` AS `project_description`,`cilist`.`cilisting1`.`owner` AS `owner`,`cilist`.`cilisting1`.`planned_timing` AS `planned_timing`,`cilist`.`cilisting1`.`revised_timing` AS `revised_timing`,`cilist`.`cilisting1`.`estimated_cost` AS `estimated_cost`,`cilist`.`cilisting1`.`savings_category` AS `savings_category`,`cilist`.`cilisting1`.`annual_savings_dollars` AS `annual_savings_dollars`,`cilist`.`cilisting1`.`percent_complete` AS `percent_complete`,`cilist`.`cilisting1`.`comments` AS `comments`,`cilist`.`cilisting1`.`originator` AS `originator`,`cilist`.`cilisting1`.`team` AS `team`,`cilist`.`cilisting1`.`documents_complete` AS `documents_complete`,`cilist`.`cilisting1`.`one_time_savings` AS `one_time_savings`,`cilist`.`cilisting1`.`hard_soft_savings` AS `hard_soft_savings`,`cilist`.`cilisting1`.`soft_dollars` AS `soft_dollars`,`cilist`.`cilisting1`.`il1_target_date` AS `il1_target_date`,`cilist`.`cilisting1`.`il2_target_date` AS `il2_target_date`,`cilist`.`cilisting1`.`il3_target_date` AS `il3_target_date`,`cilist`.`cilisting1`.`il4_target_date` AS `il4_target_date`,`cilist`.`cilisting1`.`il5_target_date` AS `il5_target_date`,`cilist`.`cilisting1`.`wc_idea_date` AS `wc_idea_date`,`cilist`.`cilisting1`.`actual_implementation_date` AS `actual_implementation_date`,`cilist`.`cilisting1`.`enter_in_wc` AS `enter_in_wc`,`cilist`.`cilisting1`.`area` AS `area`,`cilist`.`cilisting1`.`updatedtime` AS `updatedtime`,`cilist`.`cilisting1`.`id_wc` AS `id_wc`,`cilist`.`cilisting1`.`environmental` AS `environmental`,`cilist`.`cilisting1`.`ease_of_implementation` AS `ease_of_implementation`,`cilist`.`cilisting1`.`submit` AS `submit`,`cilist`.`cilisting1`.`next_steps` AS `next_steps`,`cilist`.`cilisting1`.`suggestion_status` AS `suggestion_status`,`cilist`.`cilisting1`.`suggestion_status_updated_at` AS `suggestion_status_updated_at`,`cilist`.`cilisting1`.`group` AS `group`,`cilist`.`cilisting1`.`metric_impact` AS `metric_impact`,`cilist`.`cilisting1`.`gift2_4_suggestion` AS `gift2_4_suggestion`,`cilist`.`cilisting1`.`gift_4_suggestion` AS `gift_4_suggestion`,`cilist`.`cilisting1`.`il_current` AS `il_current`,`cilist`.`cilisting1`.`createdtime` AS `createdtime`,`cilist`.`cilisting1`.`link` AS `link`,`cilist`.`cilisting1`.`linkmore` AS `linkmore`,`cilist`.`cilisting1`.`display` AS `display`,`cilist`.`cilisting1`.`ciid` AS `ciid`,`cilist`.`cilisting1`.`idea_Qtr_1` AS `idea_Qtr_1`,`cilist`.`cilisting1`.`ci_leader_1` AS `ci_leader_1`,`cilist`.`cilisting1`.`line_num` AS `line_num`,`cilist`.`cilisting1`.`orginator_email` AS `orginator_email`,`cilist`.`cilisting1`.`z-updatedtime` AS `z-updatedtime` from `cilist`.`cilisting1` order by `cilist`.`cilisting1`.`ciid` desc;
  ALTER DEFINER=`ciuser`@`host` VIEW `dataface__view_e01b4083d06e67e4554dbf5d4eecbac2` AS select `cilist`.`about_this_app`.`sortorder` AS `sortorder`,`cilist`.`about_this_app`.`about_fld` AS `about_fld`,`cilist`.`about_this_app`.`createdtime` AS `createdtime`,`cilist`.`about_this_app`.`updatedtime` AS `updatedtime` from `cilist`.`about_this_app` order by `cilist`.`about_this_app`.`sortorder` desc;
  ALTER DEFINER=`ciuser`@`host` VIEW `emp_enterprise` AS select `lukup`.`emp_enterprise`.`clock` AS `clock`,`lukup`.`emp_enterprise`.`name` AS `name`,`lukup`.`emp_enterprise`.`dept` AS `dept`,`lukup`.`emp_enterprise`.`company` AS `company`,`lukup`.`emp_enterprise`.`group` AS `group`,`lukup`.`emp_enterprise`.`status` AS `status`,`lukup`.`emp_enterprise`.`sch_wk1` AS `sch_wk1`,`lukup`.`emp_enterprise`.`pln_wk1` AS `pln_wk1`,`lukup`.`emp_enterprise`.`sch_wk2` AS `sch_wk2`,`lukup`.`emp_enterprise`.`pln_wk2` AS `pln_wk2`,`lukup`.`emp_enterprise`.`id_e` AS `id_e`,`lukup`.`emp_enterprise`.`updatedtime` AS `updatedtime`,`lukup`.`emp_enterprise`.`createdtime` AS `createdtime` from `lukup`.`emp_enterprise`;
  ALTER DEFINER=`ciuser`@`host` VIEW `vw_emp1` AS select `cilist`.`leader`.`fullcommonname` AS `fullcommonname`,`cilist`.`leader`.`clocknum` AS `clocknum`,`cilist`.`leader`.`ci_leader` AS `ci_leader`,`cilist`.`leader`.`comment` AS `comment`,`cilist`.`leader`.`updatedtime` AS `updatedtime`,`cilist`.`leader`.`id` AS `id`,`cilist`.`emp_enterprise`.`clock` AS `clock`,`cilist`.`emp_enterprise`.`name` AS `name`,`cilist`.`emp_enterprise`.`dept` AS `dept`,`cilist`.`emp_enterprise`.`company` AS `company`,`cilist`.`emp_enterprise`.`group` AS `group`,`cilist`.`emp_enterprise`.`status` AS `status`,`cilist`.`emp_enterprise`.`sch_wk1` AS `sch_wk1`,`cilist`.`emp_enterprise`.`pln_wk1` AS `pln_wk1`,`cilist`.`emp_enterprise`.`sch_wk2` AS `sch_wk2`,`cilist`.`emp_enterprise`.`pln_wk2` AS `pln_wk2`,`cilist`.`emp_enterprise`.`id_e` AS `id_e`,`cilist`.`emp_ceridian`.`eenum` AS `cer_eenum`,`cilist`.`emp_ceridian`.`position` AS `cer_position`,`cilist`.`emp_ceridian`.`dept` AS `cer_dept`,`cilist`.`emp_ceridian`.`name` AS `cer_name` from ((`cilist`.`leader` left join `cilist`.`emp_ceridian` on((`cilist`.`leader`.`clocknum` = `cilist`.`emp_ceridian`.`eenum`))) left join `cilist`.`emp_enterprise` on((`cilist`.`leader`.`clocknum` = `cilist`.`emp_enterprise`.`clock`)));
  ALTER DEFINER=`ciuser`@`host` VIEW `vw_enterprise_all` AS select `cilist`.`leader`.`fullcommonname` AS `fullcommonname`,`cilist`.`leader`.`clocknum` AS `clocknum`,`cilist`.`leader`.`ci_leader` AS `ci_leader`,`cilist`.`leader`.`comment` AS `comment`,`cilist`.`leader`.`updatedtime` AS `ld_updated`,`cilist`.`emp_enterprise`.`clock` AS `clock`,`cilist`.`emp_enterprise`.`name` AS `name`,`cilist`.`emp_enterprise`.`dept` AS `dept`,`cilist`.`emp_enterprise`.`company` AS `company`,`cilist`.`emp_enterprise`.`group` AS `group`,`cilist`.`emp_enterprise`.`status` AS `status`,`cilist`.`emp_enterprise`.`sch_wk1` AS `sch_wk1`,`cilist`.`emp_enterprise`.`pln_wk1` AS `pln_wk1`,`cilist`.`emp_enterprise`.`sch_wk2` AS `sch_wk2`,`cilist`.`emp_enterprise`.`pln_wk2` AS `pln_wk2`,`cilist`.`emp_enterprise`.`id_e` AS `id_e`,`cilist`.`emp_ceridian`.`eenum` AS `cer_eenum`,`cilist`.`emp_ceridian`.`position` AS `cer_position`,`cilist`.`emp_ceridian`.`dept` AS `cer_dept`,`cilist`.`emp_ceridian`.`name` AS `cer_name`,`cilist`.`emp_ceridian`.`shift` AS `cer_sh` from ((`cilist`.`emp_enterprise` left join `cilist`.`emp_ceridian` on((`cilist`.`emp_ceridian`.`eenum` = `cilist`.`emp_enterprise`.`clock`))) left join `cilist`.`leader` on((`cilist`.`emp_enterprise`.`clock` = `cilist`.`leader`.`clocknum`))) order by `cilist`.`leader`.`fullcommonname`,`cilist`.`emp_enterprise`.`name`;
  ALTER DEFINER=`ciuser`@`host` VIEW `vw_trainatt` AS select `cilist`.`trainingatt1`.`name_t` AS `name_t`,`cilist`.`trainingatt1`.`clock_t` AS `clock_t`,`cilist`.`trainingatt1`.`sugg2016a` AS `sugg2016a`,`cilist`.`trainingatt1`.`date_sugg2016a` AS `date_sugg2016a`,`cilist`.`trainingatt1`.`id_t` AS `id_t`,`cilist`.`emp_enterprise`.`clock` AS `clock`,`cilist`.`emp_enterprise`.`name` AS `name`,`cilist`.`emp_enterprise`.`dept` AS `dept`,`cilist`.`emp_enterprise`.`company` AS `company`,`cilist`.`emp_enterprise`.`group` AS `group`,`cilist`.`emp_enterprise`.`status` AS `status`,`cilist`.`emp_enterprise`.`sch_wk1` AS `sch_wk1`,`cilist`.`emp_enterprise`.`pln_wk1` AS `pln_wk1`,`cilist`.`emp_enterprise`.`sch_wk2` AS `sch_wk2`,`cilist`.`emp_enterprise`.`pln_wk2` AS `pln_wk2`,`cilist`.`emp_enterprise`.`id_e` AS `id_e`,`cilist`.`emp_enterprise`.`updatedtime` AS `updatedtime`,`cilist`.`emp_enterprise`.`createdtime` AS `createdtime`,`cilist`.`emp_ceridian`.`eenum` AS `cer_eenum`,`cilist`.`emp_ceridian`.`position` AS `cer_position`,`cilist`.`emp_ceridian`.`dept` AS `cer_dept`,`cilist`.`emp_ceridian`.`shift` AS `cer_sh` from ((`cilist`.`trainingatt1` left join `cilist`.`emp_ceridian` on((`cilist`.`trainingatt1`.`clock_t` = `cilist`.`emp_ceridian`.`eenum`))) left join `cilist`.`emp_enterprise` on((`cilist`.`trainingatt1`.`clock_t` = `cilist`.`emp_enterprise`.`clock`))) order by `cilist`.`trainingatt1`.`clock_t`,`cilist`.`trainingatt1`.`name_t`;
  