digi-gov.com / 127.0.0.1 / humanresource / department_pmdbkp

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 (202 total, Query took 0.0032 seconds.)

SELECT * FROM `department_pmdbkp`

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

Filter rows:

			SysPK_Dept	CODE	DeptCode_Full	DeptCode_Dept	Services_Dept	prefix	pay_jo_prio	pay_jo_supp_prefix	pay_jo_supp_id	pay_jo_pos	short_desc	short_desc1	sortby	inspectorate	sort_inspectorate	memorandum	Name_Dept	Plantilla_Name	Head_Dept	AssistantHead_Dept	type	main_dept_id	Remarks_Dept	title_id	project_id	international	local	tel_no	status	date_save	Location_Dept	Email_Dept	Website_Dept	hotline	fax_no	cell_no	REFCODE	Include	isHRD	isPayGp	isRespCnter	esig_depthead	function	project_activity	subsec_plantilla	ir_head
Edit	Copy	Delete DELETE FROM department_pmdbkp WHERE `department_pmdbkp`.`SysPK_Dept` = 1 AND `department_pmdbkp`.`DeptCode_Dept` = '1011*5-02-01'	1	1011*5-02-01	07-2234-010	1011*5-02-01	General Services	City	0		25	Mayors	Mayors	MO	1	True	0	True	Office of the City Mayor	Office of the City Mayor	2	1111	False	0		1	1	DEPARTMENT	106	142/143	Active	2018-07-28 23:47:10	NULL	NULL	NULL	NULL	NULL	NULL	01	True	True	False	True	NULL	General Services	Over-all Supervision of City Affairs	False	NULL
Edit	Copy	Delete DELETE FROM department_pmdbkp WHERE `department_pmdbkp`.`SysPK_Dept` = 2 AND `department_pmdbkp`.`DeptCode_Dept` = '1031'	2	1031	07-2234-030	1031	General Services	City	0		182	Administrators	Administrators	ADMIN	3	False	0	False	Office of the City Administrator	Office of the City Administrator	182	10	False	0		1	1	DEPARTMENT	146	(032) 489-4284	Active	2018-07-28 23:47:10	NULL	NULL	NULL	NULL	NULL	NULL	03	True	True	True	True	NULL	General Services	Delivery of Administrative Support Services	False	NULL
Edit	Copy	Delete DELETE FROM department_pmdbkp WHERE `department_pmdbkp`.`SysPK_Dept` = 3 AND `department_pmdbkp`.`DeptCode_Dept` = '0003'	3	0003	07-2234	0003	Other Services	City	0		63	Vice-Mayors	Vice-Mayors	VMO	47	False	0	False	Office of the City Vice Mayor	Office of the City Vice Mayor	63	74	False	0		1	1	DEPARTMENT	146	(032) 489-4284	Active	2018-07-28 23:47:10	NULL	NULL	NULL	NULL	NULL	NULL	1002	False	True	True	True	NULL			False	NULL
Edit	Copy	Delete DELETE FROM department_pmdbkp WHERE `department_pmdbkp`.`SysPK_Dept` = 4 AND `department_pmdbkp`.`DeptCode_Dept` = '1081'	4	1081	07-2234-080	1081	General Services	City	0		103	Accounting	Accounting	ACCTNG	8	False	0	False	Office of the City Accountant	Office of the City Accountant	103	104	False	0		1	1	DEPARTMENT	108/134/163	(032) 272-6651	Active	2018-07-28 23:47:10	NULL	NULL	NULL	NULL	NULL	NULL	02	True	True	True	True	NULL	General Services	Accounting and Internal Audit Services	False	NULL
Edit	Copy	Delete DELETE FROM department_pmdbkp WHERE `department_pmdbkp`.`SysPK_Dept` = 5 AND `department_pmdbkp`.`DeptCode_Dept` = '1071'	5	1071	07-2234-070	1071	General Services	City	0		206	Budget	Budget	BDGT	7	False	0	False	Office of the Budget Officer	Office of the Budget Officer	206	100	False	0		1	1	DEPARTMENT	102/132/137	(032) 273-6688	Active	2018-07-28 23:47:10	NULL	NULL	NULL	NULL	NULL	NULL	04	True	True	True	True	NULL	General Services	Budgetary Services, Formulation of Budget	False	NULL
Edit	Copy	Delete DELETE FROM department_pmdbkp WHERE `department_pmdbkp`.`SysPK_Dept` = 6 AND `department_pmdbkp`.`DeptCode_Dept` = '1091'	6	1091	07-2234-090	1091	General Services	City	0		3	Treasurers Office	Treasurers Office	CTA	9	True	7	False	Office of the City Treasurer	Office of the City Treasurer	3	91	False	0		1	1	DEPARTMENT	110/149/160/157	159	Active	2018-07-28 23:47:10	NULL	NULL	NULL	NULL	NULL	NULL	012	True	True	True	True	NULL	General Services	Collection of Taxes, Disbursement of Funds	False	NULL
Edit	Copy	Delete DELETE FROM department_pmdbkp WHERE `department_pmdbkp`.`SysPK_Dept` = 7 AND `department_pmdbkp`.`DeptCode_Dept` = '1101'	7	1101	07-2234-100	1101	General Services	City	0		1089	Assessors Office	Assessors Office	CAO	10	True	5	False	Office of the City Assessor	Office of the City Assessor	1089	92	False	0		1	1	DEPARTMENT	145	153	Active	2018-07-28 23:47:10	NULL	NULL	NULL	NULL	NULL	NULL	1101	True	True	True	True	NULL	General Services	Appraisal and Assessment of Real Properties	False	NULL
Edit	Copy	Delete DELETE FROM department_pmdbkp WHERE `department_pmdbkp`.`SysPK_Dept` = 8 AND `department_pmdbkp`.`DeptCode_Dept` = '1011-11'	8	1011-11	07-2234-010	1011-11	General Services (Operation)	City	0		1111	BPLO	BPLO	BPLO	34	True	0	True	Business Permits And Licensing Officer	Business Permits And Licensing Officer	1111	40	True	1	BPLO	1	1	SECTION	103	(032) 273-4022	Active	2018-07-28 23:47:10	NULL	NULL	NULL	NULL	NULL	NULL	001	True	True	False	True	NULL			False	NULL
Edit	Copy	Delete DELETE FROM department_pmdbkp WHERE `department_pmdbkp`.`SysPK_Dept` = 9 AND `department_pmdbkp`.`DeptCode_Dept` = '1041'	9	1041	07-2234-040	1041	General Services	City	0		1093	Planning and Development Office	CPDC	CPDC	4	True	2	False	Office of the City Planning and Development Coordi...	Office of the City Planning and Development Coordi...	1093	78	False	0		1	1	DEPARTMENT	140/141/148	(032) 489-8399	Active	2018-07-28 23:47:10	NULL	NULL	NULL	NULL	NULL	NULL	011	True	True	True	True	NULL	General Services	Local Planning, Development & Coordination	False	NULL
Edit	Copy	Delete DELETE FROM department_pmdbkp WHERE `department_pmdbkp`.`SysPK_Dept` = 10 AND `department_pmdbkp`.`DeptCode_Dept` = '8751'	10	8751	07-2234-08	8751	Economic Services	City	0		7	City Engineer	Engineers Office	CEO	25	False	0	False	Office of the City Engineer	Office of the City Engineer	7	140	False	0		1	1	DEPARTMENT	144		Active	2018-07-28 23:47:10	NULL	NULL	NULL	NULL	NULL	NULL	08	True	True	True	True	NULL		Implementation of Infra Projects & Monitoring	False	NULL
Edit	Copy	Delete DELETE FROM department_pmdbkp WHERE `department_pmdbkp`.`SysPK_Dept` = 11 AND `department_pmdbkp`.`DeptCode_Dept` = '8751-1'	11	8751-1	07-2234-08	8751-1	Economic Services (Operation)	City	0		116	OBO	OBO	OBO	39	True	4	True	Office of the Building Official	Office of the Building Official	116	118	False	0	OBO	1	1	DEPARTMENT	152		Active	2018-07-28 23:47:10	NULL	NULL	NULL	NULL	NULL	NULL	87511	True	True	True	True	NULL			False	NULL
Edit	Copy	Delete DELETE FROM department_pmdbkp WHERE `department_pmdbkp`.`SysPK_Dept` = 12 AND `department_pmdbkp`.`DeptCode_Dept` = '1061'	12	1061	07-2234-060	1061	General Services	City	0		105	CGSO-Designate	General Services	GSO	6	False	0	False	City General Services Office	City General Services Office	105	105	False	0		1	1	DEPARTMENT	156/105/133	(032) 273-1427 / (032) 273-6512	Active	2018-07-28 23:47:10	NULL	NULL	NULL	NULL	NULL	NULL	05	True	True	True	True	NULL	General Services	Management of Supplies & Properties	False	NULL
Edit	Copy	Delete DELETE FROM department_pmdbkp WHERE `department_pmdbkp`.`SysPK_Dept` = 13 AND `department_pmdbkp`.`DeptCode_Dept` = '0004'	13	0004	07-2234	0004	Other Services	City	0		189	HRD	HRD	HRD	48	False	0	False	Human Resource Management Division	Human Resource Management Division	189	189	True	2		1	1	DEPARTMENT	121	120/135	Active	2018-07-28 23:47:10	NULL	[email protected]	NULL	NULL	NULL	NULL	001	False	True	True	True	NULL			True	NULL
Edit	Copy	Delete DELETE FROM department_pmdbkp WHERE `department_pmdbkp`.`SysPK_Dept` = 14 AND `department_pmdbkp`.`DeptCode_Dept` = '0005'	14	0005	07-2234	0005	Other Services	City	0		202	CICRO	SPP	SPP	49	False	0	False	Special Programs and Projects	Special Programs and Projects	202	203	True	75	Project Evaluation Officer	1	1	DEPARTMENT	158	155	Active	2018-07-28 23:47:10	NULL	NULL	NULL	NULL	NULL	NULL	004	False	True	False	True	NULL			False	NULL
Edit	Copy	Delete DELETE FROM department_pmdbkp WHERE `department_pmdbkp`.`SysPK_Dept` = 15 AND `department_pmdbkp`.`DeptCode_Dept` = '0006'	15	0006	07-2234	0006	Other Services	City	0		206	Motorpool	Motorpool	MTPL	50	False	0	False	Motorpool	Motorpool	206	141	True	12	Supervisor	1	1	SECTION	125	(032) 273-1427	Active	2018-07-28 23:47:10	NULL	NULL	NULL	NULL	NULL	NULL	003	False	True	False	True	NULL			False	NULL
Edit	Copy	Delete DELETE FROM department_pmdbkp WHERE `department_pmdbkp`.`SysPK_Dept` = 16 AND `department_pmdbkp`.`DeptCode_Dept` = '1051'	16	1051	07-2234-050	1051	General Services	City	0		18	Civil Registrar	Civil Registrar	LCR	5	False	0	False	Office of the City Civil Registrar	Office of the City Civil Registrar	18	19	False	0		1	1	DEPARTMENT	107	153	Active	2018-07-28 23:47:10	NULL	NULL	NULL	NULL	NULL	NULL	07	True	True	True	True	NULL	General Services	Local Civil Registration Program	False	NULL
Edit	Copy	Delete DELETE FROM department_pmdbkp WHERE `department_pmdbkp`.`SysPK_Dept` = 17 AND `department_pmdbkp`.`DeptCode_Dept` = '1131'	17	1131	07-2234-102	1131	General Services	City	0		1375	Legal Office	Legal Office	CLO	13	False	0	False	Office of the City Legal Officer	Office of the City Legal Officer	1375	200	False	0	Legal Officer	1	1	DEPARTMENT	118		Active	2018-07-28 23:47:10	NULL	NULL	NULL	NULL	NULL	NULL	010	True	True	True	True	NULL		Legal Services	False	NULL
Edit	Copy	Delete DELETE FROM department_pmdbkp WHERE `department_pmdbkp`.`SysPK_Dept` = 18 AND `department_pmdbkp`.`DeptCode_Dept` = '0007'	18	0007	07-2234	0007	Other Services	City	0			CSC	CSC	CSC	51	False	0	False	Civil Service Commission	Civil Service Commission			False	0		1	1	DEPARTMENT	131		ACTIVE	2018-07-28 23:47:10	NULL	NULL	NULL	NULL	NULL	NULL	4017	False	False	False	False	NULL			False	NULL
Edit	Copy	Delete DELETE FROM department_pmdbkp WHERE `department_pmdbkp`.`SysPK_Dept` = 19 AND `department_pmdbkp`.`DeptCode_Dept` = '0017'	19	0017	07-2234	0017	Social Services	City	0		150	RHU	RHU	RHU	62	False	0	False	Lying-In	Lying-In	150		False	28	CENRO	1	1	DEPARTMENT	150		Active	2018-07-28 23:47:10	NULL	NULL	NULL	NULL	NULL	NULL	3038	False	False	False	False	NULL			False	NULL
Edit	Copy	Delete DELETE FROM department_pmdbkp WHERE `department_pmdbkp`.`SysPK_Dept` = 20 AND `department_pmdbkp`.`DeptCode_Dept` = '8721'	20	8721	07-2234-08	8721	Economic Services	City	0		196	Veterinary Services	Veterinary Services	VET	23	True	6	False	Office of the City Veterinarian	Office of the City Veterinarian	196	194	False	0	Veterinarian	1	1	DEPARTMENT			Active	2018-07-28 23:47:10	NULL	NULL	NULL	NULL	NULL	NULL	016	True	True	True	True	NULL		Veterinary Services	False	NULL
Edit	Copy	Delete DELETE FROM department_pmdbkp WHERE `department_pmdbkp`.`SysPK_Dept` = 21 AND `department_pmdbkp`.`DeptCode_Dept` = '8812'	21	8812	07-2234-08	8812	Local Economic Enterprise	City	0		196	Abattoir	Abattoir	ABATTOIR	43	False	0	False	Operation of Slaughterhouse	Operation of Slaughterhouse	196		True	20	Slaughterhouse	1	1	SECTION	145	(032) 489-9251	Active	2018-07-28 23:47:10	NULL	NULL	NULL	NULL	NULL	NULL	3012	True	True	True	True	NULL		Operation & Maintenance of Slaughterhouse	False	NULL
Edit	Copy	Delete DELETE FROM department_pmdbkp WHERE `department_pmdbkp`.`SysPK_Dept` = 22 AND `department_pmdbkp`.`DeptCode_Dept` = '1011-17'	22	1011-17	07-2234-010	1011-17	General Services (Operation)	City	0		57	IAS	IAS	ISA	37	False	0	False	Internal Audit Services	Internal Audit Services	57	57	False	0	IAS	1	1	SECTION	160		Active	2018-07-28 23:47:10	NULL	NULL	NULL	NULL	NULL	NULL	3013	True	True	False	True	NULL			False	NULL
Edit	Copy	Delete DELETE FROM department_pmdbkp WHERE `department_pmdbkp`.`SysPK_Dept` = 23 AND `department_pmdbkp`.`DeptCode_Dept` = '1011-4'	23	1011-4	07-2234-010	1011-4	General Services (Operation)	City	0		1117	PESO	PESO	PERO	31	False	0	False	Public Employment Services Office	Public Employment Services Office	1117	845	True	1		1	1	DEPARTMENT	145		Active	2018-07-28 23:47:10	NULL	NULL	NULL	NULL	NULL	NULL	008	True	True	False	True	NULL			False	NULL
Edit	Copy	Delete DELETE FROM department_pmdbkp WHERE `department_pmdbkp`.`SysPK_Dept` = 24 AND `department_pmdbkp`.`DeptCode_Dept` = '0008'	24	0008	07-2234	0008	Other Services	City	0		182	PACD	PACD	PACD	53	False	0	False	PACD	PACD	182		True	2	Operator	1	1	SECTION	101/201		ACTIVE	2018-07-28 23:47:10	NULL	NULL	NULL	NULL	NULL	NULL	002	False	True	False	True	NULL			False	NULL
Edit	Copy	Delete DELETE FROM department_pmdbkp WHERE `department_pmdbkp`.`SysPK_Dept` = 25 AND `department_pmdbkp`.`DeptCode_Dept` = '1021'	25	1021	07-2234-020	1021	General Services	City	0		63	SP Secretary	SP Secretary	SP	2	False	0	False	Office of the Sangguniang Panlungsod	Office of the Sangguniang Panlungsod	74	74	False	0		1	1	DEPARTMENT	215	(032)489-5384	Active	2018-07-28 23:47:10	NULL	NULL	NULL	NULL	NULL	NULL	017	True	True	True	True	NULL	General Services	Local Legislation	False	NULL

Check all With selected:

Filter rows:

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.