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)
branch_id int(10)
component_code varchar(50) utf8mb4_unicode_ci
component_name varchar(120) utf8mb4_unicode_ci
component_type enum('EARNING', 'DEDUCTION', 'EMPLOYER_CONTRIBUTION', 'INFORMATION') utf8mb4_unicode_ci
calculation_method enum('FIXED', 'PERCENTAGE', 'FORMULA', 'MANUAL') utf8mb4_unicode_ci
basis_code varchar(50) utf8mb4_unicode_ci
default_amount decimal(18,2)
default_rate decimal(9,4)
formula_expression varchar(500) utf8mb4_unicode_ci
proration_policy enum('PRORATE_WITH_PAYABLE_DAYS', 'NO_PRORATION', 'PAYROLL_POLICY') utf8mb4_unicode_ci
is_taxable tinyint(1)
affects_gross tinyint(1)
affects_net tinyint(1)
is_statutory tinyint(1)
display_order smallint(5)
is_active tinyint(1)
delete_status tinyint(1)
created_by bigint(20)
updated_by bigint(20)
created_at datetime
updated_at datetime