* aspect_id aspect_code aspect_name insert_date insert_by update_date update_by delete_date delete_by is_deleted

* comp_id comp_code comp_name comp_group_id comp_readers_id insert_date insert_by update_date update_by delete_date delete_by is_deleted

* compmap_id compmap_comp_id compmap_div_id compmap_loc_id compmap_lob_id insert_date insert_by update_date update_by delete_date delete_by is_deleted

* cc_id cc_code cc_name cc_pic1_nik cc_pic2_nik cc_head1_nik cc_head2_nik cc_head3_nik cc_head4_nik insert_date insert_by update_date update_by delete_date delete_by is_deleted

* div_id div_code div_name insert_date insert_by update_date update_by delete_date delete_by is_deleted

* emp_id emp_nik emp_name emp_email emp_position_id emp_position emp_gender emp_birthdate emp_grade emp_jobfamily emp_level emp_direct_nik emp_direct_name emp_direct_email emp_direct_position_id emp_direct_position emp_indirect_nik emp_indirect_name emp_indirect_email emp_indirect_position_id emp_indirect_position emp_lokper_code emp_lokper emp_costcenter_code emp_costcenter emp_joindate insert_date insert_by update_date update_by delete_date delete_by is_deleted

* grade_id grade_code grade_name insert_date insert_by update_date update_by delete_date delete_by is_deleted

* heads_id heads_companymapping_id heads_head_id insert_date insert_by update_date update_by delete_date delete_by is_deleted

* jobfamily_id jobfamily_code jobfamily_name insert_date insert_by update_date update_by delete_date delete_by is_deleted

* level_id level_code level_name insert_date insert_by update_date update_by delete_date delete_by is_deleted

* lob_id lob_code lob_name insert_date insert_by update_date update_by delete_date delete_by is_deleted

* loc_id loc_code loc_name insert_date insert_by update_date update_by delete_date delete_by is_deleted

* periode_id periode_code periode_name periode_status ipp_startdate ipp_enddate myr_startdate myr_enddate ypa_startdate ypa_enddate insert_date insert_by update_date update_by delete_date delete_by is_deleted periode_order is_active_periode

* pichc_id pichc_companymapping_id pichc_pichc_id insert_date insert_by update_date update_by delete_date delete_by is_deleted

* pos_id pos_code pos_name insert_date insert_by update_date update_by delete_date delete_by is_deleted

* soft_id soft_code soft_name soft_definition soft_order insert_date insert_by update_date update_by delete_date delete_by is_deleted

* softdepth_id softdepth_soft_id softdepth_depth softdepth_definition insert_date insert_by update_date update_by delete_date delete_by is_deleted

* softmap_id softmap_softdepth_id softmap_grade_id insert_date insert_by update_date update_by delete_date delete_by is_deleted

* ipp_id ipp_emp_id ipp_periode ipp_nik ipp_name ipp_email ipp_grade ipp_position ipp_jobfamily ipp_level ipp_direct_name ipp_direct_email ipp_direct_position ipp_indirect_name ipp_indirect_email ipp_indirect_position ipp_lokper ipp_costcenter last_approval_position status

* kpi_id kpi_ipp_id kpi_aspect_id kpi_order kpi_item kpi_bobot kpi_target6 kpi_target12 kpi_uom kpi_definisi kpi_tatacara kpi_acuan insert_date insert_by update_date update_by delete_date delete_by is_deleted

* rating_id rating_kpi_id rating_order rating_hasil6bulan rating_hasil12bulan rating_keterangan insert_date insert_by update_date update_by delete_date delete_by is_deleted

select table pmsa_m_aspek_kpi pmsa_m_company pmsa_m_companymapping pmsa_m_cost_center pmsa_m_division pmsa_m_employee pmsa_m_grade pmsa_m_heads pmsa_m_jobfamily pmsa_m_level pmsa_m_lob pmsa_m_location pmsa_m_periode pmsa_m_pichc pmsa_m_position pmsa_m_softcompetency pmsa_m_softcompetencydepth pmsa_m_softcompetencymapping pmsa_t_ipp pmsa_t_ipp_kpi pmsa_t_ipp_kpi_rating . select column
Show

criteria

Sort	Ascending	Descending
Add as	AND	OR
Op	= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL REGEXP REGEXP ^...$ NOT REGEXP	Text Another column
	select table pmsa_m_aspek_kpi pmsa_m_company pmsa_m_companymapping pmsa_m_cost_center pmsa_m_division pmsa_m_employee pmsa_m_grade pmsa_m_heads pmsa_m_jobfamily pmsa_m_level pmsa_m_lob pmsa_m_location pmsa_m_periode pmsa_m_pichc pmsa_m_position pmsa_m_softcompetency pmsa_m_softcompetencydepth pmsa_m_softcompetencymapping pmsa_t_ipp pmsa_t_ipp_kpi pmsa_t_ipp_kpi_rating .	select column