* id ref_id employee_id first_name last_name gender ssn_num nic_num other_id work_email joined_date confirmation_date supervisor department termination_date notes data

* id name description attachment created updated

* id employee in_time out_time note image_in image_out map_lat map_lng map_snapshot map_out_lat map_out_lng map_out_snapshot in_ip out_ip

* id time user ip type employee details

* id name description

* id name details first_contact_date created address contact_number contact_email company_url status

* id code type attachment employee department description created updated

* id name details valid_until status notify_employees attachment share_departments share_employees share_userlevel

* id name details

* id title description address type country parent timezone heads

* id message type attachment employee target created updated timeint

* id employee status seen_at

* id code namecap name iso3 numcode

* id code name description coordinator trainer trainer_info paymentType currency cost status created updated

* id name class lastrun frequency time type status

* id code name

* id type name data display created updated field_type field_label field_validation field_options display_order display_section

* id type name object_id value updated created

* id tableType data

* id name dataType details columns updated created objectType

* id name data_import_definition status file details updated created

* id name description

* id name componentType component payrollColumn rangeAmounts deduction_group

* id name details expire_notification expire_notification_month expire_notification_week expire_notification_day sign sign_label created updated share_with_employee

* id name description

* id subject toEmail body cclist bcclist created updated status

* id subject toEmail template params cclist bcclist error created updated status

* id employee name relationship home_phone work_phone mobile_phone

* id type element approver level status active created updated

* id employee date_start date_end status

* id employee job_title employment_status department supervisor date_start date_end details created updated

* id certification_id employee institute date_start date_end

* id employee loan start_date last_installment_date period_months currency amount monthly_installment status details

* id type employee field old_value new_value description user updated created

* id employee name relationship dob id_number

* id employee document date_added valid_until status details attachment signature expire_notification_last visible_to hidden

* id education_id employee institute date_start date_end

* id employee ethnicity

* id employee expense_date payment_method transaction_no payee category notes amount currency attachment1 attachment2 attachment3 created updated status

* id employee form status created updated

* id employee review status title description manager_rating manager_feedback employee_rating employee_feedback created updated

* id employee document documentname valid_until status details attachment1 attachment2 attachment3 created updated

* id employee status

* id language_id employee reading speaking writing understanding

* id employee_leave leave_date leave_type

* id employee_leave user_id data status_from status_to created

* id employee leave_type leave_period date_start date_end details status attachment

* id employee start_time end_time category project notes created updated status

* id employee project date_start date_end status details

* id employee_id first_name middle_name last_name nationality birthday gender marital_status ssn_num nic_num other_id driving_license driving_license_exp_date employment_status job_title pay_grade work_station_id address1 address2 city country province postal_code home_phone mobile_phone work_phone work_email private_email joined_date confirmation_date supervisor indirect_supervisors department name_preferred name_pronunciation pronouns custom4 custom5 custom6 custom7 custom8 custom9 custom10 termination_date notes status ethnicity immigration_status approver1 approver2 approver3 tax_id health_insurance timezone

* id employee component pay_frequency currency amount details

* id skill_id employee details

* id employee status feeling message status_date

* id team member role

* id name description lead department

* id project employee timesheet details created date_start time_start date_end time_end status

* id employee date_start date_end status

* id employee trainingSession feedBack status proof

* id employee type purpose travel_from travel_to travel_date return_date details funding currency attachment1 attachment2 attachment3 created updated status

* id name description

* id name

* id name created updated pre_approve

* id name created updated

* id type name textOrig textMapped display created updated

* id name filename employee file_group size size_text

* id name description items created updated

* id name dateh status country

* id name details required alert_on_missing alert_before_expiry alert_before_day_number created updated

* id name

* id code name description specification

* id name description

* id employee leave_group created updated

* id name details created updated

* id name date_start date_end status country

* id leave_type job_title employment_status employee supervisor_leave_assign employee_can_apply apply_beyond_current leave_accrue carried_forward default_per_year carried_forward_percentage carried_forward_leave_availability propotionate_on_joined_date leave_group max_carried_forward_amount exp_days leave_period department employee_leave_period

* id leave_type employee leave_period amount note created updated

* id name supervisor_leave_assign employee_can_apply apply_beyond_current leave_accrue carried_forward default_per_year carried_forward_percentage carried_forward_leave_availability propotionate_on_joined_date send_notification_emails leave_group leave_color max_carried_forward_amount employee_leave_period

* id file version created updated status last_error

* id menu name label icon mod_group mod_order status version update_path user_levels user_roles user_roles_blacklist

* id name

* id time fromUser fromEmployee toUser image message action type status employee

* id name created updated

* id name

* id name currency min_salary max_salary

* id name pay_period department column_template columns date_start date_end status payslipTemplate deduction_group error

* id name calculation_hook salary_components deductions add_columns sub_columns colorder editable enabled default_value calculation_columns calculation_function deduction_group function_type

* id name columns

* id payroll employee payroll_item amount

* id employee pay_frequency currency deduction_exemptions deduction_allowed deduction_group

* id name data status created updated

* id name employee coordinator attendees form status review_date review_period_start review_period_end self_assessment_due notes created updated

* id user_level module_id permission meta value

* id name client details created status

* id name code country

* id employee name attachment created

* id name details parameters query paramOrder type report_group output

* id userId hash token created updated

* id employee review subject form status dueon created updated rating

* id name description items created updated

* id name componentType details

* id code name

* id name value description meta category

* id name description

* id type element user_id data status_from status_to created

* id name description

* id name value

* id name

* id name details

* id name course description scheduled dueDate deliveryMethod deliveryLocation status attendanceType attachment created updated requireProof

* id email username first_name last_name user_level password timezone employee_id department joined_date job_title employment_status pay_grade supervisor country invitation_status created_user_id created_employee_id created updated

* id user_id meta_key meta_value created updated

* id name details parameters query paramOrder type report_group output

* id name additional_permissions

* id username email password employee default_module user_level user_roles last_login last_update created login_hash lang googleUserData wrong_password_count last_wrong_attempt_at last_password_requested_at

* id name status country

select table archivedemployees assettypes attendance auditlog certifications clients companyassets companydocuments companyloans companystructures conversations conversationuserstatus country courses crons currencytypes customfields customfieldvalues dataentrybackups dataimport dataimportfiles deductiongroup deductions documents educations emaillog emails emergencycontacts employeeapprovals employeeattendancesheets employeecareer employeecertifications employeecompanyloans employeedatahistory employeedependents employeedocuments employeeeducations employeeethnicity employeeexpenses employeeforms employeegoals employeeimmigrations employeeimmigrationstatus employeelanguages employeeleavedays employeeleavelog employeeleaves employeeovertime employeeprojects employees employeesalary employeeskills employeestatus employeeteammembers employeeteams employeetimeentry employeetimesheets employeetrainingsessions employeetravelrecords employmentstatus ethnicity expensescategories expensespaymentmethods fieldnamemappings files forms holidays immigrationdocuments immigrationstatus jobtitles languages leavegroupemployees leavegroups leaveperiods leaverules leavestartingbalance leavetypes migrations modules nationality notifications overtimecategories payfrequency paygrades payroll payrollcolumns payrollcolumntemplates payrolldata payrollemployees paysliptemplates performancereviews permissions projects province reportfiles reports restaccesstokens reviewfeedbacks reviewtemplates salarycomponent salarycomponenttype settings skills statuschangelogs supportedlanguages systemdata tags timezones trainingsessions userinvitations usermeta userreports userroles users workdays . select column
Show

criteria

Sort	Ascending	Descending
Add as	AND	OR
Op	= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL REGEXP REGEXP ^...$ NOT REGEXP	Text Another column
	select table archivedemployees assettypes attendance auditlog certifications clients companyassets companydocuments companyloans companystructures conversations conversationuserstatus country courses crons currencytypes customfields customfieldvalues dataentrybackups dataimport dataimportfiles deductiongroup deductions documents educations emaillog emails emergencycontacts employeeapprovals employeeattendancesheets employeecareer employeecertifications employeecompanyloans employeedatahistory employeedependents employeedocuments employeeeducations employeeethnicity employeeexpenses employeeforms employeegoals employeeimmigrations employeeimmigrationstatus employeelanguages employeeleavedays employeeleavelog employeeleaves employeeovertime employeeprojects employees employeesalary employeeskills employeestatus employeeteammembers employeeteams employeetimeentry employeetimesheets employeetrainingsessions employeetravelrecords employmentstatus ethnicity expensescategories expensespaymentmethods fieldnamemappings files forms holidays immigrationdocuments immigrationstatus jobtitles languages leavegroupemployees leavegroups leaveperiods leaverules leavestartingbalance leavetypes migrations modules nationality notifications overtimecategories payfrequency paygrades payroll payrollcolumns payrollcolumntemplates payrolldata payrollemployees paysliptemplates performancereviews permissions projects province reportfiles reports restaccesstokens reviewfeedbacks reviewtemplates salarycomponent salarycomponenttype settings skills statuschangelogs supportedlanguages systemdata tags timezones trainingsessions userinvitations usermeta userreports userroles users workdays .	select column