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 :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Do a "query by example" (wildcard: "%")
Column Type Collation Operator Value
id int(11)
employee_id int(11)
period_start date
period_end date
pay_date date
monthly_rate decimal(10,2)
payroll_rate decimal(10,2)
days_rendered decimal(5,2)
rate_per_day decimal(10,2)
absences_days decimal(5,2)
absences_amount decimal(10,2)
lates_mins int(11)
lates_amount decimal(10,2)
undertime_mins int(11)
undertime_amount decimal(10,2)
overload_hrs decimal(5,2)
overload_amount decimal(10,2)
others_earnings decimal(10,2)
gross_pay decimal(10,2)
sss_deduction decimal(10,2)
phic_deduction decimal(10,2)
hdmf_deduction decimal(10,2)
tax_deduction decimal(10,2)
ca_installment decimal(10,2)
ca_lumpsum decimal(10,2)
sss_loan decimal(10,2)
hdmf_loan decimal(10,2)
others_deductions decimal(10,2)
total_deductions decimal(10,2)
net_pay decimal(10,2)
is_finalized tinyint(1)
created_at timestamp
updated_at timestamp
payroll_type varchar(50) utf8mb4_general_ci
rate_per_hour decimal(10,2)
hours_rendered decimal(5,2)
department_id int(11)
branch varchar(100) utf8mb4_general_ci