CREATE TABLE `psi_project_monitoring` (
  `prjmon_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `prj_id` bigint(20) unsigned DEFAULT '0',
  `prjmon_year` int(10) unsigned DEFAULT '2015',
  `quarter_id` int(10) unsigned DEFAULT '1',
  `sem_id` bigint(20) unsigned DEFAULT '1',
  `prjmon_total_assets_land` decimal(65,3) unsigned DEFAULT '0.000',
  `prjmon_total_assets_building` decimal(65,3) unsigned DEFAULT '0.000',
  `prjmon_total_assets_equipment` decimal(65,3) unsigned DEFAULT '0.000',
  `prjmon_total_assets_working_capital` decimal(65,3) unsigned DEFAULT '0.000',
  `prjmon_total_employment` int(10) unsigned DEFAULT '0',
  `prjmon_dir_ch_regular_male` int(10) unsigned DEFAULT '0',
  `prjmon_dir_ch_regular_female` int(10) unsigned DEFAULT '0',
  `prjmon_dir_ch_regular_pwd` int(10) unsigned DEFAULT '0',
  `prjmon_dir_ch_regular_senior` int(10) unsigned DEFAULT '0',
  `prjmon_dir_ch_part_time_male` int(10) unsigned DEFAULT '0',
  `prjmon_dir_ch_part_time_female` int(10) unsigned DEFAULT '0',
  `prjmon_dir_ch_part_time_pwd` int(10) unsigned DEFAULT '0',
  `prjmon_dir_ch_part_time_senior` int(10) unsigned DEFAULT '0',
  `prjmon_dir_sh_regular_male` int(10) unsigned DEFAULT '0',
  `prjmon_dir_sh_regular_female` int(10) unsigned DEFAULT '0',
  `prjmon_dir_sh_regular_pwd` int(10) unsigned DEFAULT '0',
  `prjmon_dir_sh_regular_senior` int(10) unsigned DEFAULT '0',
  `prjmon_dir_sh_part_time_male` int(10) unsigned DEFAULT '0',
  `prjmon_dir_sh_part_time_female` int(10) unsigned DEFAULT '0',
  `prjmon_dir_sh_part_time_pwd` int(10) unsigned DEFAULT '0',
  `prjmon_dir_sh_part_time_senior` int(10) unsigned DEFAULT '0',
  `prjmon_indir_backward_male` int(10) unsigned DEFAULT '0',
  `prjmon_indir_backward_female` int(10) unsigned DEFAULT '0',
  `prjmon_indir_backward_pwd` int(10) unsigned DEFAULT '0',
  `prjmon_indir_backward_senior` int(10) unsigned DEFAULT '0',
  `prjmon_indir_forward_male` int(10) unsigned DEFAULT '0',
  `prjmon_indir_forward_female` int(10) unsigned DEFAULT '0',
  `prjmon_indir_forward_pwd` int(10) unsigned DEFAULT '0',
  `prjmon_indir_forward_senior` int(10) unsigned DEFAULT '0',
  `prjmon_volume_production_local` decimal(65,3) DEFAULT '0.000',
  `prjmon_volume_production_export` decimal(65,3) DEFAULT '0.000',
  `prjmon_gross_sales_local` decimal(65,3) DEFAULT '0.000',
  `prjmon_gross_sales_export` decimal(65,3) DEFAULT '0.000',
  `prjmon_countries_of_destination` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prjmon_assistance_process` tinyint(1) unsigned DEFAULT '0',
  `prjmon_assistance_equipment` tinyint(1) unsigned DEFAULT '0',
  `prjmon_assistance_quality_control` tinyint(1) unsigned DEFAULT '0',
  `prjmon_assistance_packaging_labeling` tinyint(1) unsigned DEFAULT '0',
  `prjmon_assistance_post_harvest` tinyint(1) unsigned DEFAULT '0',
  `prjmon_assistance_marketing` tinyint(1) unsigned DEFAULT '0',
  `prjmon_assistance_training` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prjmon_assistance_consultancy` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prjmon_assistance_others` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prjmon_problems_met` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prjmon_actions_taken` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prjmon_improvement_action_plan` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prjmon_status_of_funds` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prjmon_reasons_for_termination` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prjmon_final_obligation` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prjmon_impact_of_intervention` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prjmon_final_recommendation` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prjmon_expected_output` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prjmon_actual_accomplishment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prjmon_output_remarks` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prjmon_liquidation_cost` decimal(65,3) unsigned DEFAULT '0.000',
  `prjmon_liquidation_used` decimal(65,3) unsigned DEFAULT '0.000',
  `prjmon_liquidation_date` date DEFAULT NULL,
  `prjmon_liquidation_remarks` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prjmon_refund_amount` decimal(65,3) unsigned DEFAULT '0.000',
  `prjmon_refund_schedule_from` date DEFAULT NULL,
  `prjmon_refund_schedule_to` date DEFAULT NULL,
  `prjmon_refund_amount_due` decimal(65,3) unsigned DEFAULT '0.000',
  `prjmon_refund_date` date DEFAULT NULL,
  `prjmon_refund_refunded` decimal(65,3) unsigned DEFAULT '0.000',
  `prjmon_refund_unsettled` decimal(65,3) unsigned DEFAULT '0.000',
  `prjmon_refund_delay_date` date DEFAULT NULL,
  `prjmon_setup_amount` decimal(65,3) unsigned DEFAULT '0.000',
  `prjmon_funds_release_date` date DEFAULT NULL,
  `prjmon_refund_period_from` date DEFAULT NULL,
  `prjmon_refund_period_to` date DEFAULT NULL,
  `prjmon_termination_date` date DEFAULT NULL,
  `prjmon_remarks` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prjmon_effectivity` date DEFAULT NULL,
  `encoder` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `date_encoded` datetime DEFAULT NULL,
  `updater` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `last_updated` datetime DEFAULT NULL,
  `prjform_id` bigint(20) unsigned DEFAULT '0',
  `prjmon_volume_product_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `prjmon_volume_of_production` decimal(65,3) unsigned DEFAULT '0.000',
  `prjmon_volume_gross_sales` decimal(65,3) unsigned DEFAULT '0.000',
  `prjmon_emp_total` bigint(20) unsigned DEFAULT '0',
  `prjmon_emp_male` bigint(20) unsigned DEFAULT '0',
  `prjmon_emp_female` bigint(20) unsigned DEFAULT '0',
  `prjmon_emp_pwd` bigint(20) unsigned DEFAULT '0',
  `prjmon_emp_indirect_forward_male` bigint(20) unsigned DEFAULT '0',
  `prjmon_emp_indirect_forward_female` bigint(20) unsigned DEFAULT '0',
  `prjmon_emp_indirect_backward_male` bigint(20) unsigned DEFAULT '0',
  `prjmon_emp_indirect_backward_female` bigint(20) unsigned DEFAULT '0',
  `prjmon_market_existing` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prjmon_market_new` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prjmon_improvement_production_efficiency` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prjmon_emp_senior` bigint(20) unsigned DEFAULT '0',
  `prjmon_emp_in_total` bigint(20) unsigned DEFAULT '0',
  `prjmon_emp_in_male` bigint(20) unsigned DEFAULT '0',
  `prjmon_emp_in_female` bigint(20) unsigned DEFAULT '0',
  `prjmon_emp_in_pwd` bigint(20) unsigned DEFAULT '0',
  `prjmon_emp_in_senior` bigint(20) unsigned DEFAULT '0',
  `prjmon_improvement_production_actual_accomplishment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prjmon_improvement_production_remarks` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `region_id` bigint(20) unsigned DEFAULT '6',
  `synched` tinyint(1) unsigned DEFAULT '0',
  `sync_date` datetime DEFAULT NULL,
  `prjmon_average_productivity` decimal(65,0) DEFAULT '0',
  PRIMARY KEY (`prjmon_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3275 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

