digi-gov.com / 127.0.0.1 / lgis_dum_app / employees

There are no favorite tables.

New
accounting
bac_lgu
budget
cenro
dbfederation
db_meter_readings
documenttracker
el_laravue
general
humanresource
information_schema
lgis
- lgis_app
- lgis_dum_app
lgu_repository
mysql
online_hr
performance
- performance_management
- performance_schema
qpsii
queue
repository
service_request_db

Customize appearance of the navigation panel.

Navigation panel

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customize the navigation tree.

Navigation tree

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Servers display options.

Servers

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Databases display options.

Databases

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables display options.

Tables

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken :

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme

Collapse Expand Requery Edit Explain Profiling Query failed Database : Queried time :

Browse mode

Customize browse mode.

Browse mode

Table navigation bar Use only icons, only text or both.
How to display various action links Use only icons, only text or both.
Allow to display all the rows Whether a user should be displayed a "show all (rows)" button.
Maximum number of rows to display Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Default sorting order `SMART` - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Highlight pointer Highlight row pointed by the mouse cursor.
Row marker Highlight selected rows.
Grid editing: trigger action
Grid editing: save all edited cells at once
Repeat headers Repeat the headers every X cells, `0` deactivates this feature.
Limit column characters Maximum number of characters shown in any non-numeric column on browse view.
Where to show the table row links These are Edit, Copy and Delete links.
Show row links anyway Whether to show row links even in the absence of a unique key.
Primary key default sort order Default sort order for tables with a primary key.
Remember table's sorting When browsing tables, the sorting of each table is remembered.
Relational display For display Options

Showing rows 0 - 24 (1742 total, Query took 0.0043 seconds.)

SELECT * FROM `employees`

[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]

Filter rows:

Sort by key:

			SysPK_Empl	old_personId	person_id	status_update	priority	AccountNo_Empl	Emp_no	trans_date	Name_Empl	FirstName_Empl	MiddleName_Empl	LastName_Empl	SuffixName_Empl	PrefixName_Empl	nickname	Address_Empl	empl_contactno	email_address	BirthDate_Empl	weight	height	gender	civilStatus	dependent	GSIS_Empl	SSS_Empl	TIN_Empl	philhealth_no	pagibig_no	with_atm	bankname_Empl	bankaccount_Empl	BloodType_Empl	EmergencyName_Empl	EmergencyAdd_Empl	EmergencyTelNo_Empl	Position_Empl	count	Department_Empl	shift_code	RateBasis	RatePerDay_Empls	BasicSalary_Empls	DateHired_Empl	DateEffectivity_Empl	DatTerminated_Empl	DateRetired	Status_Empl	Type_Empl	office_location	payroll_group	with_bio	with_contract	pertrip	title_id	branch_id	time_stamp	RHouse_No	RSubd_Village	RCity_Mun	RZipcode	RStreet	brgyid	RBrgy	RProvince	PHouse_No	PSubd_Village	PCity_Mun	PZipcode	PStreet	PBrgy	PProvince	sal_grade_id	recruitment_id	birthplace	government_ID	ID_License_Passport	Date_Place_Issuance	privilege	Appoint_Status	jo_group_no	with_pds	level	indigenous_group	person_disablity	solo_parent	bp_number	designate_dept	designate_pos	designate_count	item_no	authorized	date_promotion	level_csc	inactive_date	shift_type	payrollType	group_pm	lc_earn_start_date_casual	lc_earn_start_date	jo_wtax	citizen	agency_no	period_from	period_to	old_emp_id	included	compute_u_l	use_new_lv_ldger	is_email_otp
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`SysPK_Empl` = 1	1	0	814	na	NULL	01-10-0005-2019	NULL	2019-11-26	Admin A. Admin	Admin	A	Admin				City of Naga,Cebu			1980-01-19			Male	Married	0	123-456-789-000		317-987-876	111-222-333	222-333-444	No							139		6	1	Monthly	666.66	20000	2019-10-15	2019-10-15		NULL	Cancelled	3	1	0	False	True	NO	1	1	2023-10-26 11:07:59			City of Naga	9200		0	Poblacion	Cebu			City of Naga				Cebu	1	0					No	3		Yes	1st Level - Rank & File	No	No	No	NULL	2	139		1091	20000	1900-01-01	1	2021-03-01	Regular	Permanent	NULL	2019-10-15	2019-10-15	True	Filipino		2022-01-01	2022-12-31	0	0	False	False	False
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`SysPK_Empl` = 2	2	0	815	na	NULL	01-10-0005-2019	NULL	2019-11-26	Valdemar M. Chiong	Valdemar	Mendiola	Chiong		Hon.		City of Naga,Cebu	9189378671	[email protected]	1960-09-05	1.7	55	Female	Annulled	0	B60S5VMC013		903114-45-4000	120000-03-6345	70147364609	No			A+				33		1	1	Monthly	9207.18	202558	2019-07-01	2019-07-01		NULL	Active	8	1	0	False	True	NO	1	1	2024-09-03 11:34:40			City of Naga	9200		0	Poblacion	Cebu			City of Naga				Cebu	235	0					No	8		Yes	3rd Level - Top Mgt.	No	No	No	NULL	144	33		1	202558	1900-01-01	5	NULL	Regular	Permanent	NULL	2022-07-01	2022-07-01	True	Filipino		2022-01-01	2025-12-31	0	0	False	False	False
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`SysPK_Empl` = 3	3	0	86	na	NULL	01-10-0001-2019	NULL	2019-11-26	Anna Maria B. Gabilan	Anna Maria	Bacon	Gabilan				City of Naga,Cebu	09175468147/-032-4899317	[email protected]	1965-08-16	79	5`3	Female	Married	1	CM-3239493	06-20579720	136-293-271-000	12-00003656-6	1640-0003-2781	No			O+				231		6	1	Monthly	4200.95	92421	1988-05-16	1988-05-16		NULL	Inactive	3	1	0	False	True	NO	1		2024-07-03 10:39:40			City of Naga	6037		0	Poblacion	Cebu			City of Naga	6037		Poblacion	Cebu	3	0	TINA-AN,NAGA,CEBU	1988-0516-025			No	3		Yes	1st Level - Rank & File	No	No	No	001-10-0001-2019	6	231	I	1091	92421	1900-01-01	6	NULL	Regular	Permanent	NULL	1988-05-16	2006-10-16	True	Filipino	1988-0516-025	2022-01-01	2022-12-31	70	0	False	True	False
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`SysPK_Empl` = 6	6	0	633	na	NULL	1995-0717-065	NULL	2019-11-26	Certeria V. Buenavista	Certeria	Villarico	Buenavista				City of Naga,Cebu	9175468409	[email protected]	1957-11-02	63	1.57	Female	Married	3	57110202409	606-60-1777	127-199-432	120000-03-6175	1640-0003-2846	No			"O"				262		5	1	Monthly	4399	96778	1995-08-01	1995-07-17		NULL	Cancelled	3	1	0	False	True	NO	1	1	2023-10-26 11:07:59	Door 3, Villarico Apartment	Panaghiusa	City of Naga	6037		0	North Poblacion	Cebu	381		City of Naga	6037	NATALIO BACALSO SOUTH NATIONAL HIGHWAY	Central Poblacion	Cebu	197	0	City of Naga, Cebu	PRC	0056007(CPA)	11/07/1983- Manila	No	3		Yes	1st Level - Rank & File	No	No	No	001-10-0002-2019	5	262	I	1071	96778	1900-01-01	6	NULL	Regular	Permanent	NULL	1995-07-17	1995-08-01	True	Filipino	1995-0717-065	2022-01-01	2022-12-31	40	0	False	False	False
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`SysPK_Empl` = 7	7	0	607	na	NULL	1986-1117-023	NULL	2019-11-26	Ma. Alpha P. Alojado	Ma. Alpha	Pabanelas.	Alojado				City of Naga,Cebu	09477964681	[email protected]	1961-07-06	1.52 kg	50 m	Female	Married	3	006-0050-30079	06-349-5069-4	120-453-704	12-00003596-9	1640-003-1035	No			A+				289		10	1	Monthly	5457.86	120073	1992-03-19	1992-03-19		NULL	Active	3	1	0	False	True	NO	1	1	2024-08-31 15:13:55			City of Naga	6037	M. ALINGANGA ST.	0	TANGKE	Cebu			City of Naga	6037	M. ALINGANGA ST.	TANGKE	Cebu	200	0	MONTALBAN RIZAL	LGU-1986-1117-023		CITY OF NAGA CEBU	No	3		Yes	1st Level - Rank & File	No	No	No	001-10-0003-2019	10	289	I	8751	120073	1900-01-01	7	NULL	Regular	Permanent	NULL	2019-01-19	1992-03-19	True	Filipino	1986-1117-023	2022-01-01	2022-12-31	29	0	False	False	False
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`SysPK_Empl` = 9	9	30798	30798	DUPLICATE	NULL	01-10-0005-2019	NULL	2019-11-26	Flordelis L. Ababa	Flordelis	Lapining	Ababa				City of Naga,Cebu			1961-09-20			Female	Married	3	111-222-333		317-987-876	111-222-333	111-222-233	No							149		7	1	Monthly	2852.5	85575	1990-03-01	1990-03-01		NULL	Cancelled	3	1		False	True	NO	1	1	2023-10-26 11:07:59			City of Naga	9200		0	Poblacion	Cebu			City of Naga				Cebu	197	0					No	3		Yes	2nd Level - Middle Mgt.	No	No	No	001-10-0005-2019	7	24	I	708	85575	2017-02-16	4	2021-02-24	Regular	Permanent	NULL	1990-03-01	1990-03-01	True	Filipino		2022-01-01	2022-12-31	0	0	False	False	False
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`SysPK_Empl` = 10	10	0	746	na	NULL	1998-0720-004	NULL	2019-11-26	Grace S. Marquez	Grace	Sayago	Marquez				City of Naga,Cebu	09322056720	[email protected]	1969-12-13	1.625	57	Female	Married	1	2001541378	061313462-2	185-83-0999	120000-03-6760	0701-156335-11	No							340	IV	16	1	Monthly	3503.9	77086	1998-07-20	1998-07-20		NULL	Active	3	1	0	False	True	NO	1	1	2024-09-04 10:29:52			City of Naga	6037		0	Poblacion	Cebu			City of Naga	6037		Poblacion	Cebu	171	0		GSIS	CRN 000-6131-3462-2		No	3		Yes	1st Level - Rank & File	No	No	No	001-10-0006-2019	16	340	IV	1051	77086	1900-01-01	2	NULL	Regular	Permanent	NULL	1998-07-20	1998-07-20	True	Filipino		2022-01-01	2022-12-31	2	0	False	False	False
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`SysPK_Empl` = 12	12	0	80596	MERGE	NULL	EMP-10-0005-2019	NULL	2019-11-26	Vivira P. Ababa	Vivira	Pansoy	Ababa				City of Naga,Cebu	0936-4040012		1975-12-17	46kgs	1.53m	Female	Married	0		06-1418940-1	194-145-859	120502446199	121012888562	No		5-67921-735-3					242	I	6	1	Monthly	619.68	13633	2022-03-23	2022-03-23		NULL	Active	3	1	0	False	True	NO	1	1	2025-04-16 13:55:05			City of Naga	6037	Sitio Banaba	0	Alpaco	Cebu			City of Naga	6037	Sitio Banaba	Alpaco	Cebu	2	0	San Fernando	06-1418940-1			No	3		Yes	1st Level - Rank & File	No	No	No	NULL	144	242	I	1091	13633	1900-01-01	1	NULL	Irregular	Permanent	NULL	2022-03-23	2022-03-23	True	Filipino		2022-01-01	2022-12-31	0	0	False	False	False
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`SysPK_Empl` = 13	13	0	819	na	NULL	01-10-0002-2019	NULL	2019-11-26	Hanna Debb P. Chua	Hanna Debb	Plarisan	Chua				City of Naga,Cebu	09974812161/09277751197	[email protected]	1995-12-08	48	1.65 m	Female	Single	0	02004816117	NA	480-646-313-000	12-000117923-9	916029354747	No			O+				118		6	1	Monthly	880.22	19365	2016-01-19	2016-01-19		NULL	Active	3	1	0	False	True	NO	1	1	2024-08-31 14:49:55	PUROK 1	CALANGGAMAN	City of Naga	6037		0	LUTAC	Cebu	PUROK 1	CALANGGAMAN	City of Naga	6037		LUTAC	Cebu	49	0	CEBU CITY	GSIS	02004816117	CEBU CITY	No	3		No	1st Level - Rank & File	No	No	No	123-456-789	6	118		1091	19365	1900-01-01	1	NULL	Regular	Permanent	NULL	2016-01-19	2016-01-19	True	Filipino	2016-0119-301	2022-01-01	2022-12-31	303	0	False	False	False
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`SysPK_Empl` = 15	15	30802	30802	MERGE	NULL	01-10-0001-2019	NULL	2019-11-26	Letecia F. Abangan	Letecia	Felices	Abangan				City of Naga,Cebu	09223234010	N/A	1953-08-14	1.52	56	Female	Married	0	53081402414	N/A	155-453-829-000	120000851103	1640-00063863	No		5-42320-735-6					123		25	1	Monthly	5115.59	112543	2019-07-01	2019-07-01		NULL	Active	8	1	0	False	True	NO	1	1	2024-08-31 14:59:40			City of Naga	6037		0	Poblacion	Cebu			City of Naga	6037		Poblacion	Cebu	196	0					No	8		Yes	3rd Level - Top Mgt.	No	No	No	NULL	25	123		1021	112543	1900-01-01	1	NULL	Regular	Permanent	NULL	2019-07-01	2019-07-01	True	Filipino		2022-01-01	2025-12-31	12	0	False	True	False
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`SysPK_Empl` = 18	18	0	616	na	NULL	1993-0917-051	NULL	2019-11-26	Angelita C. Generale	Angelita	Camomot	Generale				City of Naga,Cebu	09267894721	[email protected]	1962-03-06	65 Kilograms	1.57	Female	Married	3	62030601845	06-1319152-6	103-731-061	12-000003650-7	1640-0002-8259	No			O+				248	I	16	1	Monthly	5283.95	116247	1993-09-17	1993-09-17		NULL	Active	3	1	0	False	True	NO	1	1	2025-03-01 10:17:12			City of Naga	6037	AGUINALDO STREET	0	WEST POBLACION	Cebu			City of Naga	6037	AGUINALDO STREET	WEST POBLACION	Cebu	198	0	CEBU CITY	1993-0917-051		CITY OF NAGA	No	3		Yes	1st Level - Rank & File	No	No	No	NULL	16	248	I	1051	116247	2007-12-18	1	NULL	Regular	Permanent	NULL	1993-09-17	1993-09-17	True	Filipino		2022-01-01	2022-12-31	76	0	False	False	False
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`SysPK_Empl` = 19	19	0	615	na	NULL		NULL	2019-11-26	Eva R. Laput	Eva	Rosales	Laput				City of Naga,Cebu	09238232636	[email protected]	1972-09-11	62	1.62	Female	Married	3	72091100763	06-1366020-6	183-621-720	12-000003674-4	070110225003	No			O+				230	III	16	1	Monthly	2300.77	50617	1994-07-01	1994-07-01		NULL	Active	3	1	0	False	True	NO	1	1	2025-03-01 13:51:58			City of Naga	6037		0	TUYAN	Cebu			City of Naga	6037		TUYAN	Cebu	140	0	NAGA CEBU	7209110763		GSIS CEBU	No	3		Yes	1st Level - Rank & File	No	No	No	NULL	16	230	III	1051	50617	2015-11-02	4	NULL	Regular	Permanent	NULL	1994-07-01	1994-07-01	True	Filipino	1994-0701-056	2022-01-01	2022-12-31	83	0	False	False	False
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`SysPK_Empl` = 20	20	0	107	na	NULL	EMP-11-0001-2019	NULL	2019-11-26	Harlem N. Alberto	Harlem	Nerosa	Alberto				City of Naga,Cebu	253-4619	[email protected]	1973-05-30	60kg	1.5m	Male	Single	0			282-031-860	12-050825095-4		No							242	I	25	1	Daily	615	13530	2017-08-04	2017-08-04		NULL	Active	1	1	0	False	True	NO	1	1	2024-09-03 14:21:16	846		City of Naga	6037	San Francisco	0	West Poblacion	Cebu	846		City of Naga	6037	San Francisco	West Poblacion	Cebu	1	0	City of Naga				No	1		Yes	1st Level - Rank & File	No	No	No	NULL	25	242	I	1021	11265	1900-01-01	1	NULL	Regular	Casual	NULL	2017-08-04	2017-07-01	True	Filipino		2022-01-01	2022-12-31	356	0	False	False	False
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`SysPK_Empl` = 21	21	0	373	na	NULL		NULL	2019-11-26	Marlon A. Alfajardo	Marlon	Atienza	Alfajardo				City of Naga,Cebu	5135849		1957-08-20	50kg	1.62m	Male	Single	0	02003516764	06-05549720	263-342-005-000	12-000089992-0	076484112307	No			A				238		39	3	Monthly	609.77	13415	2008-10-02	2022-10-03		NULL	Inactive	3	1	0	False	True	NO	1	1	2024-11-11 17:08:38	436		City of Naga	6037	National Road	0	East Poblacion	Cebu	436		City of Naga	6037	National Road	East Poblacion	Cebu	3	0	City of Naga	LGU - CITY OF NAGA	2008-1002-130	10/02/2008-CITY OF NAGA	No	3		Yes	1st Level - Rank & File	No	No	No	NULL	145	238			13415	1900-01-01	1	NULL	Regular	Permanent	NULL	2022-10-03	2022-10-03	True	Filipino	2008-1002-130	2023-01-03	2023-06-30	15	0	False	True	False
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`SysPK_Empl` = 23	23	0	374	na	NULL	EMP-11-0003-2019	NULL	2019-11-26	Minnie C. Abangan	Minnie	Cabigas	Abangan				City of Naga,Cebu	09289040546	[email protected]	1966-03-02	50	1.56	Female	Married	0	66030201257	061073275-5	136-293-407	12-000003597-7	1640-0002-9414	No		5-42292-735-7	O	Jesus Nava Abalo	Crossing Naalad, City of Naga, Cebu	09498297529	299		1	1	Monthly	1537.22	33819	1990-03-01	2019-11-19		NULL	Active	3	1	0	False	True	NO	1	1	2024-08-31 15:40:03			City of Naga	6037	Crossing	0	Naalad	Cebu			City of Naga	6037	Crossing	Naalad	Cebu	100	0	CEBU				No	3		Yes	1st Level - Rank & File	No	No	No	NULL	144	299		1011*5-02-01	33819	1900-01-01	7	NULL	Regular	Permanent	NULL	1990-03-01	1990-03-01	True	Filipino		2022-01-01	2022-12-31	8	0	False	False	False
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`SysPK_Empl` = 24	24	0	546	na	NULL	EMP-11-0004-2019	NULL	2019-11-26	Jose Ramiro P. Hilado	Jose Ramiro	Porquez	Hilado				City of Naga,Cebu			1954-08-24	1.54	95	Male	Married	0			109-350-164			No			b				124		28	1	Daily	1534.66	46040	2012-01-05	2012-01-05		NULL	Cancelled	15	1		False	True	NO	1	1	2023-10-26 11:07:59			City of Naga	9200		0	Poblacion	Cebu			City of Naga				Cebu	157	1					No	15		Yes	1st Level - Rank & File	No	No	No	NULL	28	124		0804	46040	2014-10-21	4	2021-02-24	Regular	Permanent	NULL	2012-01-05	2012-01-05	True	Filipino		2022-01-01	2022-12-31	0	0	False	False	False
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`SysPK_Empl` = 25	25	0	372	na	NULL		NULL	2019-11-26	Iris Mariani B. Algabre	Iris Mariani	Bonghanoy	Algabre				City of Naga,Cebu	09756495066	[email protected]	1996-11-13	50	1.52	Female	Single	0		06-3830623-1	330-675-789-000	12-251812798-3	1211-7937-5118	No			A+				297	II	1	1	Monthly	2051.72	45138	2018-04-18	2018-04-18		NULL	Active	15	1	0	False	True	NO	1	1	2024-08-31 15:27:03			City of Naga	6037	MOHON 2	0	BARANGAY LANGTAD	Cebu			City of Naga	6037	MOHON 2	BARANGAY LANGTAD	Cebu	129	0	CEBU CITY	PASSPORT	P4686662A	10-11-2017 DFA CEBU	No	15		Yes	1st Level - Rank & File	No	No	No	NULL	144	297	II	1011	45138	1900-01-01	1	NULL	Regular	Permanent	NULL	2018-04-18	2018-04-20	True	Filipino	2018-0418-367	2018-01-01	2025-12-31	369	0	False	False	False
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`SysPK_Empl` = 26	26	0	333	na	NULL	EMP-11-0004-2019	NULL	2019-11-26	Rodolfo A. Tomada	Rodolfo	Arquino	Tomada				City of Naga,Cebu			1947-01-01			Male	Married	3	111-222-333		317-987-876	111-222-333	111-222-111	No							126		38	1	Daily	502.73	15082	2018-07-02	2018-07-02		NULL	Cancelled	15	1		False	True	NO	1	1	2023-10-26 11:07:59			City of Naga	9200		0	Poblacion	Cebu			City of Naga				Cebu	64	1					No	15		Yes	1st Level - Rank & File	No	No	No	NULL	38	126		101117	15082	1900-01-01	1	2021-02-24	Regular	Permanent	NULL	2018-07-02	2018-07-02	True	Filipino		2022-01-01	2022-12-31	0	0	False	False	False
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`SysPK_Empl` = 27	27	0	370	na	NULL	EMP-11-0004-2019	NULL	2019-11-26	Nilo B. Alinsonorin	Nilo	Base	Alinsonorin				City of Naga,Cebu	N/A	N/A	1954-02-20	1.7	70	Male	Married	0	54022001208	N/A	228-443-801-000	19-000309666-5	1640-00063876	No							295	I	1	1	Monthly	950.36	20908	2016-09-21	2016-09-21		NULL	Active	15	1	0	False	True	NO	1	1	2024-08-31 15:29:25			City of Naga	6037		0	Poblacion	Cebu			City of Naga	6037		Poblacion	Cebu	59	0					No	15		Yes	1st Level - Rank & File	No	No	No	NULL	144	295	I	1011	20908	1900-01-01	1	NULL	Regular	Permanent	NULL	2016-09-21	2016-09-21	True	Filipino		2021-01-01	2025-12-31	25	0	False	False	False
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`SysPK_Empl` = 28	28	0	359	na	NULL	EMP-11-0004-2019	NULL	2019-11-26	Elmer Q. Lapitan	Elmer	Quiros	Lapitan				City of Naga,Cebu	09228756217	[email protected]	1951-09-26	1.8	90	Male	Married	0	54022001208	N/A	136-259-192	12-000076389-1	164-000043803	No							295	I	1	1	Monthly	941.81	20720	2018-06-29	2016-09-21		NULL	Active	15	1	0	False	True	NO	1	1	2024-09-03 14:34:38			City of Naga	6037		0	Tuyan	Cebu			City of Naga	6037		Tuyan	Cebu	58	0					No	15		Yes	1st Level - Rank & File	No	No	No	NULL	144	295	I	1011-33	20720	2018-06-29	1	NULL	Regular	Permanent	NULL	2016-09-21	2016-09-21	True	Filipino		2021-01-01	2025-12-31	81	0	False	False	False
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`SysPK_Empl` = 29	29	0	0	na	NULL	EMP-11-0004-2019	NULL	2019-11-26	Rhodelia A. Viajedor	Rhodelia	Andrin	Viajedor				City of Naga,Cebu			1969-12-19			Female	Married	3	111-222-333		317-987-876	111-222-333	111-222-333	No							61		1	1	Daily	1108.26	33248	2017-06-30	2017-06-30		NULL	Cancelled	15	1		False	True	NO	1	1	2023-10-26 11:07:59			City of Naga	9200		0	Poblacion	Cebu			City of Naga				Cebu	134	0					No	15		Yes	1st Level - Rank & File	No	No	No	NULL	1	61		1011-7	33248	2018-06-29	4	2021-02-23	Regular	Permanent	NULL	2017-06-30	2017-06-30	True	Filipino		2022-01-01	2022-12-31	0	0	False	False	False
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`SysPK_Empl` = 30	30	0	620	na	NULL	EMP-11-0004-2019	NULL	2019-11-26	Anecito G. Olmillo	Anecito	Gonesto	Olmillo				City of Naga,Cebu			1971-08-12			Male	Married	0	111-222-333		317-987-876	111-222-333	111-222-333	No							296	I	56	3	Monthly	1643.54	36158	2017-03-01	2017-03-01		NULL	Active	15	1	0	False	True	NO	1	1	2024-08-31 15:28:18			City of Naga	6037		0	Poblacion	Cebu			City of Naga	6037		Poblacion	Cebu	107	0					No	15		Yes	2nd Level - Middle Mgt.	No	No	No	NULL	144	296	I		36158	1900-01-01	1	NULL	Regular	Permanent	NULL	2017-03-01	2017-03-01	True	Filipino		2017-03-01	2025-12-31	327	0	False	False	False
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`SysPK_Empl` = 31	31	0	712	na	NULL	EMP-11-0004-2019	NULL	2019-11-26	John Richie O. Sayson	John Richie	Ouano	Sayson				City of Naga,Cebu	09176548610	[email protected]	1978-08-06	60	1.65	Male	Single	0	CRN 006-0047-3423-7	0618772047	219-327-748-000	120000-68-1429	164000050208	No			A+				184	I	9	1	Monthly	1764.09	38810	2005-01-17	2005-01-17		NULL	Active	3	1	0	False	True	NO	1	1	2025-04-16 13:32:19		Purok Lower 1	City of Naga	6037		0	Naalad	Cebu		Purok Lower 1	City of Naga	6037		Naalad	Cebu	114	0	Cebu City	LGU ID	2005-0117-104	City of Naga,Cebu	No	3		Yes	1st Level - Rank & File	No	No	No	NULL	9	184	I	1041	38810	1900-01-01	1	NULL	Regular	Permanent	NULL	2005-01-17	2005-01-17	True	Filipino	2005-0117-104	2022-01-01	2022-12-31	130	0	False	False	False
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`SysPK_Empl` = 32	32	0	512	na	NULL		NULL	2019-11-26	Bruce Constantine U. Opura	Bruce Constantine	Umbay	Opura				City of Naga,Cebu	09156268240	[email protected]	1974-08-26	86	1.67	Male	Married	2	LP-74082601132		250-670-365-000	12-000078188-1	1640-0005-7681	No			AB+				312	VI	70	1	Monthly	849.09	18680	2006-06-22	2006-06-22		NULL	Active	3	1	0	False	True	NO	1	1	2024-08-31 15:40:24	366		City of Naga	6037	Sayson St.	0	Central Poblacion	Cebu	366		City of Naga	6037	Sayson St.	Central Poblacion	Cebu	44	0	Cebu City	Employee ID		June 25,2019	No	3		Yes	2nd Level - Middle Mgt.	No	No	No	NULL	144	312	VI		18680	1900-01-01	1	NULL	Irregular	Permanent	NULL	2006-06-22	2014-10-14	True	Filipino	EMP-11-0004-2019	2022-01-01	2022-12-31	104	0	False	False	False
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`SysPK_Empl` = 33	33	0	367	na	NULL	EMP-11-0004-2019	NULL	2019-11-26	Ma. Aileen C. Cañete	Ma. Aileen	Chiong	Cañete				City of Naga,Cebu	09236161661	[email protected]	1974-02-09	1.5	55	Female	Married	3	74020900541	06-1577036-9	202-985-952	12-0000781865	070154142208	No			O				38	IV	1	1	Monthly	507.3	15219	1999-03-01	1999-03-01		NULL	Cancelled	3	1		False	True	NO	1	1	2023-10-26 11:07:59			City of Naga	9200		0	Poblacion	Cebu			City of Naga				Cebu	65	0					No	3		Yes	1st Level - Rank & File	No	No	No	NULL	1	4	II	3	15082	2015-12-08	1	2021-02-23	Regular	Permanent	NULL	1999-03-01	1999-03-01	True	Filipino		2022-01-01	2022-12-31	0	0	False	False	False

Check all With selected:

Filter rows:

Sort by key:

Query results operations

Copy to clipboard

Export

Display chart

Create view

mysqli::real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)

Connection for controluser as defined in your configuration failed.