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 bigint(20)
payroll_run_id bigint(20)
employee_id int(10)
employee_code varchar(50) utf8mb4_unicode_ci
employee_name varchar(120) utf8mb4_unicode_ci
designation varchar(120) utf8mb4_unicode_ci
attendance_employee_snapshot_id bigint(20)
attendance_employee_row_hash char(64) ascii_bin
scheduled_workdays decimal(8,2)
present_days decimal(8,2)
absent_days decimal(8,2)
weekly_off_days decimal(8,2)
holiday_days decimal(8,2)
approved_leave_days decimal(8,2)
payable_attendance_days decimal(8,2)
payable_attendance_days_status varchar(40) ascii_bin
total_worked_minutes decimal(12,2)
approved_overtime_minutes int(10)
late_count int(10)
early_out_count int(10)
short_hours_count int(10)
attendance_exception_count int(10)
salary_assignment_id bigint(20)
salary_assignment_version int(10)
structure_version_id bigint(20)
salary_assignment_effective_from date
salary_assignment_effective_to date
reference_monthly_gross decimal(18,2)
reference_monthly_ctc decimal(18,2)
input_hash char(64) ascii_bin
calculation_status varchar(32) ascii_bin
gross_amount decimal(18,2)
deduction_amount decimal(18,2)
employer_contribution_amount decimal(18,2)
net_amount decimal(18,2)
created_at datetime
updated_at datetime