Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Options
Set default





Collapse Expand Requery Edit Explain Profiling Query failed Database : Queried time :
Browse mode
Customize browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
SELECT * FROM `hr_employee_statutory_remittances`
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts id period_month employee_id employee_code employee_name_raw sss_payroll_15 sss_payroll_30 sss_monthly_total sss_er_ee_total sss_employee_share sss_employer_share sss_ec_er sss_remittance_total sss_loan_total philhealth_payroll_15 philhealth_payroll_30 philhealth_monthly_total philhealth_employee_share philhealth_employer_share pagibig_payroll_15 pagibig_payroll_30 pagibig_monthly_total pagibig_employee_share pagibig_employer_share hdmf_loan_total source_files created_at updated_at
Edit Edit Copy Copy Delete Delete
DELETE FROM hr_employee_statutory_remittances WHERE `hr_employee_statutory_remittances`.`id` = 1
1 2026-06-01 30 240027 Arce, Nikko 1252.50 1252.50 2505.00 2475.00 825.00 1650.00 30.00 2505.00 0.00 412.50 412.50 825.00 412.50 412.50 200.00 200.00 400.00 200.00 200.00 0.00 SSS Remittance_June2026_T1MWI.xlsx; PHIC Remittanc... 2026-07-07 20:27:08 2026-07-07 20:27:08
Edit Edit Copy Copy Delete Delete
DELETE FROM hr_employee_statutory_remittances WHERE `hr_employee_statutory_remittances`.`id` = 2
2 2026-06-01 68 240067 Gamido, Jonalyn 1440.00 1440.00 2880.00 2850.00 950.00 1900.00 30.00 2880.00 0.00 475.00 475.00 950.00 475.00 475.00 200.00 200.00 400.00 200.00 200.00 0.00 SSS Remittance_June2026_T1MWI.xlsx; PHIC Remittanc... 2026-07-07 20:27:08 2026-07-07 20:27:08
Edit Edit Copy Copy Delete Delete
DELETE FROM hr_employee_statutory_remittances WHERE `hr_employee_statutory_remittances`.`id` = 3
3 2026-06-01 23 230020 Dimalanta, Razzel 1290.00 1290.00 2580.00 2550.00 850.00 1700.00 30.00 2580.00 0.00 422.50 422.50 845.00 422.50 422.50 200.00 200.00 400.00 200.00 200.00 0.00 SSS Remittance_June2026_T1MWI.xlsx; PHIC Remittanc... 2026-07-07 20:27:08 2026-07-07 20:27:08
Edit Edit Copy Copy Delete Delete
DELETE FROM hr_employee_statutory_remittances WHERE `hr_employee_statutory_remittances`.`id` = 4
4 2026-06-01 46 240044 Reyes, Reynalyn 2640.00 2640.00 5280.00 5250.00 1750.00 3500.00 30.00 5280.00 0.00 875.00 875.00 1750.00 875.00 875.00 200.00 200.00 400.00 200.00 200.00 0.00 SSS Remittance_June2026_T1MWI.xlsx; PHIC Remittanc... 2026-07-07 20:27:08 2026-07-07 20:27:08
Edit Edit Copy Copy Delete Delete
DELETE FROM hr_employee_statutory_remittances WHERE `hr_employee_statutory_remittances`.`id` = 5
5 2026-06-01 126 260130 Garces, Athea Chantal Zoe 1440.00 1440.00 2880.00 2850.00 950.00 1900.00 30.00 2880.00 0.00 475.00 475.00 950.00 475.00 475.00 200.00 200.00 400.00 200.00 200.00 0.00 SSS Remittance_June2026_T1MWI.xlsx; PHIC Remittanc... 2026-07-07 20:27:08 2026-07-07 20:27:08
Edit Edit Copy Copy Delete Delete
DELETE FROM hr_employee_statutory_remittances WHERE `hr_employee_statutory_remittances`.`id` = 6
6 2026-06-01 76 240075 Radomes, Maria Rosario C 1290.00 1290.00 2580.00 2550.00 850.00 1700.00 30.00 2580.00 1537.73 425.00 425.00 850.00 425.00 425.00 200.00 200.00 400.00 200.00 200.00 0.00 SSS Remittance_June2026_T1MWI.xlsx; PHIC Remittanc... 2026-07-07 20:27:08 2026-07-07 20:27:08
Edit Edit Copy Copy Delete Delete
DELETE FROM hr_employee_statutory_remittances WHERE `hr_employee_statutory_remittances`.`id` = 7
7 2026-06-01 138 260142 Cudiamat, Mark Jason 1290.00 1290.00 2580.00 2550.00 850.00 1700.00 30.00 2580.00 0.00 425.00 425.00 850.00 425.00 425.00 200.00 200.00 400.00 200.00 200.00 0.00 SSS Remittance_June2026_T1MWI.xlsx; PHIC Remittanc... 2026-07-07 20:27:08 2026-07-07 20:27:08
Edit Edit Copy Copy Delete Delete
DELETE FROM hr_employee_statutory_remittances WHERE `hr_employee_statutory_remittances`.`id` = 8
8 2026-06-01 110 250112 Ercia, Lorelli Zerina 1177.50 1177.50 2355.00 2325.00 775.00 1550.00 30.00 2355.00 0.00 382.50 382.50 765.00 382.50 382.50 200.00 200.00 400.00 200.00 200.00 0.00 SSS Remittance_June2026_T1MWI.xlsx; PHIC Remittanc... 2026-07-07 20:27:08 2026-07-07 20:27:08
Edit Edit Copy Copy Delete Delete
DELETE FROM hr_employee_statutory_remittances WHERE `hr_employee_statutory_remittances`.`id` = 9
9 2026-06-01 22 230019 De Lumen, John Carlo 1440.00 1440.00 2880.00 2850.00 950.00 1900.00 30.00 2880.00 0.00 475.00 475.00 950.00 475.00 475.00 200.00 200.00 400.00 200.00 200.00 0.00 SSS Remittance_June2026_T1MWI.xlsx; PHIC Remittanc... 2026-07-07 20:27:08 2026-07-07 20:27:08
Edit Edit Copy Copy Delete Delete
DELETE FROM hr_employee_statutory_remittances WHERE `hr_employee_statutory_remittances`.`id` = 10
10 2026-06-01 62 240061 Camo, Jericho 1177.50 1177.50 2355.00 2325.00 775.00 1550.00 30.00 2355.00 0.00 382.50 382.50 765.00 382.50 382.50 200.00 200.00 400.00 200.00 200.00 0.00 SSS Remittance_June2026_T1MWI.xlsx; PHIC Remittanc... 2026-07-07 20:27:08 2026-07-07 20:27:08
Edit Edit Copy Copy Delete Delete
DELETE FROM hr_employee_statutory_remittances WHERE `hr_employee_statutory_remittances`.`id` = 11
11 2026-06-01 91 250092 Lascano, Ronaldo V Jr 1177.50 1177.50 2355.00 2325.00 775.00 1550.00 30.00 2355.00 0.00 382.25 382.25 764.50 382.25 382.25 200.00 200.00 400.00 200.00 200.00 0.00 SSS Remittance_June2026_T1MWI.xlsx; PHIC Remittanc... 2026-07-07 20:27:08 2026-07-07 20:27:08
Edit Edit Copy Copy Delete Delete
DELETE FROM hr_employee_statutory_remittances WHERE `hr_employee_statutory_remittances`.`id` = 12
12 2026-06-01 128 260132 Embate, Joshua Paulo 1515.00 1515.00 3030.00 3000.00 1000.00 2000.00 30.00 3030.00 0.00 500.00 500.00 1000.00 500.00 500.00 200.00 200.00 400.00 200.00 200.00 0.00 SSS Remittance_June2026_T1MWI.xlsx; PHIC Remittanc... 2026-07-07 20:27:08 2026-07-07 20:27:08
Edit Edit Copy Copy Delete Delete
DELETE FROM hr_employee_statutory_remittances WHERE `hr_employee_statutory_remittances`.`id` = 13
13 2026-06-01 6 210003 Quindo, Augusto S 1252.50 1252.50 2505.00 2475.00 825.00 1650.00 30.00 2505.00 1430.49 417.50 417.50 835.00 417.50 417.50 200.00 200.00 400.00 200.00 200.00 0.00 SSS Remittance_June2026_T1MWI.xlsx; PHIC Remittanc... 2026-07-07 20:27:08 2026-07-07 20:27:08
Edit Edit Copy Copy Delete Delete
DELETE FROM hr_employee_statutory_remittances WHERE `hr_employee_statutory_remittances`.`id` = 14
14 2026-06-01 40 240038 Tagle, Acel Kim 1515.00 1515.00 3030.00 3000.00 1000.00 2000.00 30.00 3030.00 0.00 500.00 500.00 1000.00 500.00 500.00 200.00 200.00 400.00 200.00 200.00 340.48 SSS Remittance_June2026_T1MWI.xlsx; PHIC Remittanc... 2026-07-07 20:27:08 2026-07-07 20:27:08
Edit Edit Copy Copy Delete Delete
DELETE FROM hr_employee_statutory_remittances WHERE `hr_employee_statutory_remittances`.`id` = 15
15 2026-06-01 132 260136 Alon, Jackeri 1440.00 1440.00 2880.00 2850.00 950.00 1900.00 30.00 2880.00 0.00 475.00 475.00 950.00 475.00 475.00 200.00 200.00 400.00 200.00 200.00 0.00 SSS Remittance_June2026_T1MWI.xlsx; PHIC Remittanc... 2026-07-07 20:27:08 2026-07-07 20:27:08
Edit Edit Copy Copy Delete Delete
DELETE FROM hr_employee_statutory_remittances WHERE `hr_employee_statutory_remittances`.`id` = 16
16 2026-06-01 10 230007 Delos Reyes, John Nikko 1627.50 1627.50 3255.00 3225.00 1075.00 2150.00 30.00 3255.00 1900.49 542.50 542.50 1085.00 542.50 542.50 200.00 200.00 400.00 200.00 200.00 0.00 SSS Remittance_June2026_T1MWI.xlsx; PHIC Remittanc... 2026-07-07 20:27:08 2026-07-07 20:27:08
Edit Edit Copy Copy Delete Delete
DELETE FROM hr_employee_statutory_remittances WHERE `hr_employee_statutory_remittances`.`id` = 17
17 2026-06-01 100 250101 Giray, Maricel S 1365.00 1365.00 2730.00 2700.00 900.00 1800.00 30.00 2730.00 0.00 450.00 450.00 900.00 450.00 450.00 200.00 200.00 400.00 200.00 200.00 0.00 SSS Remittance_June2026_T1MWI.xlsx; PHIC Remittanc... 2026-07-07 20:27:08 2026-07-07 20:27:08
Edit Edit Copy Copy Delete Delete
DELETE FROM hr_employee_statutory_remittances WHERE `hr_employee_statutory_remittances`.`id` = 18
18 2026-06-01 96 250097 Diego, Angel May 1365.00 1365.00 2730.00 2700.00 900.00 1800.00 30.00 2730.00 0.00 450.00 450.00 900.00 450.00 450.00 200.00 200.00 400.00 200.00 200.00 0.00 SSS Remittance_June2026_T1MWI.xlsx; PHIC Remittanc... 2026-07-07 20:27:08 2026-07-07 20:27:08
Edit Edit Copy Copy Delete Delete
DELETE FROM hr_employee_statutory_remittances WHERE `hr_employee_statutory_remittances`.`id` = 19
19 2026-06-01 104 250105 Yu, Anjo 1177.50 1177.50 2355.00 2325.00 775.00 1550.00 30.00 2355.00 0.00 382.25 382.25 764.50 382.25 382.25 200.00 200.00 400.00 200.00 200.00 0.00 SSS Remittance_June2026_T1MWI.xlsx; PHIC Remittanc... 2026-07-07 20:27:08 2026-07-07 20:27:08
Edit Edit Copy Copy Delete Delete
DELETE FROM hr_employee_statutory_remittances WHERE `hr_employee_statutory_remittances`.`id` = 20
20 2026-06-01 12 230009 Quiambao, Kaila 1290.00 1290.00 2580.00 2550.00 850.00 1700.00 30.00 2580.00 0.00 430.00 430.00 860.00 430.00 430.00 200.00 200.00 400.00 200.00 200.00 0.00 SSS Remittance_June2026_T1MWI.xlsx; PHIC Remittanc... 2026-07-07 20:27:08 2026-07-07 20:27:08
Edit Edit Copy Copy Delete Delete
DELETE FROM hr_employee_statutory_remittances WHERE `hr_employee_statutory_remittances`.`id` = 21
21 2026-06-01 43 240041 Jose, Arlene May 1440.00 1440.00 2880.00 2850.00 950.00 1900.00 30.00 2880.00 0.00 480.00 480.00 960.00 480.00 480.00 200.00 200.00 400.00 200.00 200.00 2318.08 SSS Remittance_June2026_T1MWI.xlsx; PHIC Remittanc... 2026-07-07 20:27:08 2026-07-07 20:27:08
Edit Edit Copy Copy Delete Delete
DELETE FROM hr_employee_statutory_remittances WHERE `hr_employee_statutory_remittances`.`id` = 22
22 2026-06-01 153 260157 Menor, Hayde 1590.00 1590.00 3180.00 3150.00 1050.00 2100.00 30.00 3180.00 0.00 525.00 525.00 1050.00 525.00 525.00 200.00 200.00 400.00 200.00 200.00 0.00 SSS Remittance_June2026_T1MWI.xlsx; PHIC Remittanc... 2026-07-07 20:27:08 2026-07-07 20:27:08
Edit Edit Copy Copy Delete Delete
DELETE FROM hr_employee_statutory_remittances WHERE `hr_employee_statutory_remittances`.`id` = 23
23 2026-06-01 99 250100 Decena, Ma Crizza A 1365.00 1365.00 2730.00 2700.00 900.00 1800.00 30.00 2730.00 0.00 450.00 450.00 900.00 450.00 450.00 200.00 200.00 400.00 200.00 200.00 0.00 SSS Remittance_June2026_T1MWI.xlsx; PHIC Remittanc... 2026-07-07 20:27:08 2026-07-07 20:27:08
Edit Edit Copy Copy Delete Delete
DELETE FROM hr_employee_statutory_remittances WHERE `hr_employee_statutory_remittances`.`id` = 24
24 2026-06-01 127 260131 Macasa, Emmanuel 1290.00 1290.00 2580.00 2550.00 850.00 1700.00 30.00 2580.00 0.00 425.00 425.00 850.00 425.00 425.00 200.00 200.00 400.00 200.00 200.00 0.00 SSS Remittance_June2026_T1MWI.xlsx; PHIC Remittanc... 2026-07-07 20:27:08 2026-07-07 20:27:08
Edit Edit Copy Copy Delete Delete
DELETE FROM hr_employee_statutory_remittances WHERE `hr_employee_statutory_remittances`.`id` = 25
25 2026-06-01 77 240077 Rosales, Jona-vee 1515.00 1515.00 3030.00 3000.00 1000.00 2000.00 30.00 3030.00 2000.00 500.00 500.00 1000.00 500.00 500.00 200.00 200.00 400.00 200.00 200.00 0.00 SSS Remittance_June2026_T1MWI.xlsx; PHIC Remittanc... 2026-07-07 20:27:08 2026-07-07 20:27:08
With selected: With selected:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view