digi-gov.com / 127.0.0.1 / budget / budgetmigrationapprop

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

SELECT * FROM `budgetmigrationapprop`

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

Filter rows:

			Id	classification	subclass	AccountName	OldCode	NewCode	Mayor	SP	CPDC	CCR	Budget	Accounting	Treasury	Assessor	Health	CSWD	DA	Engineering	CityAdministrator	CityLegalOffice	Veterinary	GSO	CityCooperative	CENRO	CityInformationOffice	Architect	Population	DRRM	CEEDO	Market	Slaughterhouse	Cemetary	College
Edit	Copy	Delete DELETE FROM budgetmigrationapprop WHERE `budgetmigrationapprop`.`Id` = 1	1	Personal Services	Salaries and Wages	Regular	701	5-01-01-010	9289188.000000	17364036.000000	3374160.000000	2125716.000000	2489064.000000	3811680.000000	7986384.000000	3221604.000000	14661660.000000	2235540.000000	2791356.000000	6511188.000000	1935828.000000	2628048.000000	1410324.000000	1330164.000000	1161336.000000	1389744.000000	1124340.000000	1989144.000000	1088508.000000	1255308.000000	1088508.000000	5646960.000000	809808.000000	289596.000000	13751436.000000
Edit	Copy	Delete DELETE FROM budgetmigrationapprop WHERE `budgetmigrationapprop`.`Id` = 2	2	Personal Services	Salaries and Wages	Casual	705	5-01-01-020	13116702.720000	675892.800000	270357.120000	270357.120000	405535.680000	405535.680000	811071.360000	675892.800000	7114805.280000	811071.360000	1216607.040000	675892.800000	0.000000	0.000000	0.000000	0.000000	270357.120000	1757321.280000	0.000000	135178.560000	0.000000	0.000000	0.000000	675892.800000	540714.240000	0.000000	675892.800000
Edit	Copy	Delete DELETE FROM budgetmigrationapprop WHERE `budgetmigrationapprop`.`Id` = 3	3	Personal Services	Other Compensation	PERA	711	5-01-02-010	3024000.000000	696000.000000	168000.000000	216000.000000	216000.000000	312000.000000	864000.000000	288000.000000	1512000.000000	288000.000000	384000.000000	792000.000000	48000.000000	72000.000000	48000.000000	48000.000000	72000.000000	360000.000000	24000.000000	120000.000000	24000.000000	48000.000000	24000.000000	936000.000000	192000.000000	48000.000000	1008000.000000
Edit	Copy	Delete DELETE FROM budgetmigrationapprop WHERE `budgetmigrationapprop`.`Id` = 4	4	Personal Services	Other Compensation	Representation Allowance	713	5-01-02-020	216000.000000	1150200.000000	81000.000000	81000.000000	81000.000000	81000.000000	135000.000000	135000.000000	189000.000000	81000.000000	81000.000000	81000.000000	135000.000000	135000.000000	81000.000000	81000.000000	81000.000000	81000.000000	81000.000000	81000.000000	81000.000000	0.000000	81000.000000	0.000000	0.000000	0.000000	162000.000000
Edit	Copy	Delete DELETE FROM budgetmigrationapprop WHERE `budgetmigrationapprop`.`Id` = 5	5	Personal Services	Other Compensation	Transportation Allowance	714	5-01-02-030	216000.000000	1150200.000000	81000.000000	81000.000000	81000.000000	81000.000000	135000.000000	135000.000000	189000.000000	81000.000000	81000.000000	81000.000000	135000.000000	135000.000000	81000.000000	81000.000000	81000.000000	81000.000000	81000.000000	81000.000000	81000.000000	0.000000	81000.000000	0.000000	0.000000	0.000000	162000.000000
Edit	Copy	Delete DELETE FROM budgetmigrationapprop WHERE `budgetmigrationapprop`.`Id` = 6	6	Personal Services	Other Compensation	Clothing Allowance	715	5-01-02-040	756000.000000	174000.000000	42000.000000	54000.000000	54000.000000	78000.000000	216000.000000	72000.000000	378000.000000	72000.000000	96000.000000	198000.000000	12000.000000	18000.000000	12000.000000	12000.000000	18000.000000	90000.000000	6000.000000	30000.000000	6000.000000	12000.000000	6000.000000	234000.000000	48000.000000	12000.000000	252000.000000
Edit	Copy	Delete DELETE FROM budgetmigrationapprop WHERE `budgetmigrationapprop`.`Id` = 7	7	Personal Services	Other Compensation	Subsistence Allowance	716	5-01-02-050	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	1206000.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000
Edit	Copy	Delete DELETE FROM budgetmigrationapprop WHERE `budgetmigrationapprop`.`Id` = 8	8	Personal Services	Other Compensation	Laundry Allowance	716	5-01-02-060	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	120600.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000
Edit	Copy	Delete DELETE FROM budgetmigrationapprop WHERE `budgetmigrationapprop`.`Id` = 9	9	Personal Services	Other Compensation	Other Bonuses & Allow-Midyear Bonus	719	5-01-02-990	1867157.560000	1503327.400000	303709.760000	199672.760000	241216.640000	351434.640000	733121.280000	324791.400000	1814705.440000	253884.280000	333996.920000	598923.400000	161319.000000	219004.000000	117527.000000	110847.000000	119307.760000	262255.440000	93695.000000	177026.880000	90709.000000	104609.000000	90709.000000	526904.400000	112543.520000	24133.000000	1202277.400000
Edit	Copy	Delete DELETE FROM budgetmigrationapprop WHERE `budgetmigrationapprop`.`Id` = 10	10	Personal Services	Other Compensation	Other Bonuses & Allow-PBB	719	5-01-02-990	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000
Edit	Copy	Delete DELETE FROM budgetmigrationapprop WHERE `budgetmigrationapprop`.`Id` = 11	11	Personal Services	Other Compensation	Hazard Pay	721	5-01-02-110	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	4951530.600000	335331.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000
Edit	Copy	Delete DELETE FROM budgetmigrationapprop WHERE `budgetmigrationapprop`.`Id` = 12	12	Personal Services	Other Compensation	Overtime & Night Pay	723	5-01-02-130	2000000.000000	0.000000	0.000000	100000.000000	200000.000000	75000.000000	500000.000000	500000.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	300000.000000	150000.000000	0.000000	0.000000
Edit	Copy	Delete DELETE FROM budgetmigrationapprop WHERE `budgetmigrationapprop`.`Id` = 13	13	Personal Services	Other Compensation	Year-End Bonus	725	5-01-02-140	1867157.560000	1503327.400000	303709.760000	199672.760000	241216.640000	351434.640000	733121.280000	324791.400000	1814705.440000	253884.280000	333996.920000	598923.400000	161319.000000	219004.000000	117527.000000	110847.000000	119307.760000	262255.440000	93695.000000	177026.880000	90709.000000	104609.000000	90709.000000	526904.400000	112543.520000	24133.000000	1202277.400000
Edit	Copy	Delete DELETE FROM budgetmigrationapprop WHERE `budgetmigrationapprop`.`Id` = 14	14	Personal Services	Other Compensation	Cash Gift	724	5-01-02-150	630000.000000	145000.000000	35000.000000	45000.000000	45000.000000	65000.000000	180000.000000	60000.000000	315000.000000	60000.000000	80000.000000	165000.000000	10000.000000	15000.000000	10000.000000	10000.000000	15000.000000	75000.000000	5000.000000	25000.000000	5000.000000	10000.000000	5000.000000	195000.000000	40000.000000	10000.000000	210000.000000
Edit	Copy	Delete DELETE FROM budgetmigrationapprop WHERE `budgetmigrationapprop`.`Id` = 15	15	Personal Services	Personnel Benefits/Contributions	Retirement & Life	731	5-01-03-010	2688706.890000	2164791.460000	437342.050000	287528.770000	347351.960000	506065.880000	1055694.640000	467699.620000	2613175.830000	365593.360000	480955.560000	862449.700000	232299.360000	315365.760000	169238.880000	159619.680000	171803.170000	377647.830000	134920.800000	254918.710000	130620.960000	150636.960000	130620.960000	758742.340000	162062.670000	34751.520000	1731279.460000
Edit	Copy	Delete DELETE FROM budgetmigrationapprop WHERE `budgetmigrationapprop`.`Id` = 16	16	Personal Services	Personnel Benefits/Contributions	PAG-IBIG	732	5-01-03-020	151200.000000	34800.000000	8400.000000	10800.000000	10800.000000	15600.000000	43200.000000	14400.000000	75600.000000	14400.000000	19200.000000	39600.000000	2400.000000	3600.000000	2400.000000	2400.000000	3600.000000	18000.000000	1200.000000	6000.000000	1200.000000	2400.000000	1200.000000	46800.000000	9600.000000	2400.000000	50400.000000
Edit	Copy	Delete DELETE FROM budgetmigrationapprop WHERE `budgetmigrationapprop`.`Id` = 17	17	Personal Services	Personnel Benefits/Contributions	PHILHEALTH	733	5-01-03-030	426553.090000	315874.660000	70320.180000	44634.660000	53865.270000	80317.590000	173378.950000	75024.340000	427796.030000	58362.070000	77589.100000	139714.900000	36146.400000	49635.360000	25636.320000	24033.120000	24607.140000	60371.150000	19200.000000	39916.290000	19200.000000	25106.160000	19200.000000	126457.060000	27010.440000	5791.920000	283406.260000
Edit	Copy	Delete DELETE FROM budgetmigrationapprop WHERE `budgetmigrationapprop`.`Id` = 18	18	Personal Services	Personnel Benefits/Contributions	ECC	734	5-01-03-040	151200.000000	34800.000000	8400.000000	10800.000000	10800.000000	15600.000000	43200.000000	14400.000000	75600.000000	14400.000000	19200.000000	39600.000000	2400.000000	3600.000000	2400.000000	2400.000000	3600.000000	18000.000000	1200.000000	6000.000000	1200.000000	2400.000000	1200.000000	46800.000000	9600.000000	2400.000000	50400.000000
Edit	Copy	Delete DELETE FROM budgetmigrationapprop WHERE `budgetmigrationapprop`.`Id` = 19	19	Personal Services	Other Personnel Benefits	Terminal Leave Benefits	742	5-01-04-030	0.000000	357099.970000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	577085.050000	0.000000	0.000000	36069.820000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	33377.200000	0.000000	0.000000	0.000000
Edit	Copy	Delete DELETE FROM budgetmigrationapprop WHERE `budgetmigrationapprop`.`Id` = 20	20	Personal Services	Other Personnel Benefits	Other Personnel Benefits-PEI	749	5-01-04-990	630000.000000	145000.000000	35000.000000	45000.000000	45000.000000	65000.000000	180000.000000	60000.000000	315000.000000	60000.000000	80000.000000	165000.000000	10000.000000	15000.000000	10000.000000	10000.000000	15000.000000	75000.000000	5000.000000	25000.000000	5000.000000	10000.000000	5000.000000	195000.000000	40000.000000	10000.000000	210000.000000
Edit	Copy	Delete DELETE FROM budgetmigrationapprop WHERE `budgetmigrationapprop`.`Id` = 21	21	Personal Services	Other Personnel Benefits	Other Personnel Benefits-Monetization	749	5-01-04-990	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000
Edit	Copy	Delete DELETE FROM budgetmigrationapprop WHERE `budgetmigrationapprop`.`Id` = 22	22	Personal Services	Other Personnel Benefits	Other Personnel Benefits-Loyalty	749	5-01-04-990	55000.000000	10000.000000	0.000000	10000.000000	0.000000	0.000000	10000.000000	10000.000000	15000.000000	0.000000	5000.000000	10000.000000	0.000000	0.000000	0.000000	10000.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	10000.000000	0.000000	0.000000	0.000000
Edit	Copy	Delete DELETE FROM budgetmigrationapprop WHERE `budgetmigrationapprop`.`Id` = 23	23	MOOE	Traveling Expenses	Local	751	5-02-01-010	2000000.000000	500000.000000	40000.000000	75000.000000	15000.000000	60000.000000	100000.000000	30000.000000	100000.000000	100000.000000	200000.000000	50000.000000	20000.000000	15000.000000	30000.000000	20000.000000	50000.000000	20000.000000	15000.000000	30000.000000	5000.000000	15000.000000	65000.000000	0.000000	0.000000	0.000000	100000.000000
Edit	Copy	Delete DELETE FROM budgetmigrationapprop WHERE `budgetmigrationapprop`.`Id` = 24	24	MOOE	Traveling Expenses	Foreign	752	5-02-01-020	150000.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000
Edit	Copy	Delete DELETE FROM budgetmigrationapprop WHERE `budgetmigrationapprop`.`Id` = 25	25	MOOE	Training & Scholarship	Training Expenses	753	5-02-02-010	350000.000000	800000.000000	40000.000000	30000.000000	35000.000000	60000.000000	75000.000000	60000.000000	60000.000000	20000.000000	150000.000000	50000.000000	10000.000000	15000.000000	47000.000000	0.000000	40000.000000	20000.000000	15000.000000	50000.000000	10000.000000	10000.000000	65000.000000	0.000000	0.000000	0.000000	150000.000000

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.