* id title content scope department status created_by created_by_name approved_by approved_by_name reject_reason published_at expires_at created_at updated_at

* document_id applicant_id document_type file_name original_name uploaded_by uploaded_at

* field_id field_key label field_type options placeholder is_required sort_order is_active created_at

* setting_key setting_value

* attendance_id employee_id date time_in time_out late_minutes time_in_latitude time_in_longitude time_in_accuracy_meters time_in_address corrected_by correction_reason corrected_at encoded_by undertime_minutes overtime_minutes status shift_id

* request_id requester_name requester_email request_type request_details status admin_notes reviewed_by reviewed_at identity_verified_at response_filename response_original_name response_expires_at submitted_at updated_at

* code_id code generated_by_employee_id generated_by_name status used_by_cashier_id used_by_employee_id discount_type created_at expires_at used_at

* employee_id employee_code first_name last_name middle_name birthdate place_of_birth sex civil_status highest_educational_attainment year_graduated character_references address contact_number email sss_number philhealth_number pagibig_number tin_number department position employment_type schedule_type date_hired basic_salary bank_name bank_account_number bank_account_name payment_method status offboarded_at created_at suspension_start_date suspension_end_date suspension_reason

* document_id employee_id document_type file_name original_name uploaded_by uploaded_at notes

* log_id employee_id action old_status new_status details performed_by logged_at

* id employee_id day_of_week shift_id

* holiday_id holiday_date name created_by created_at

* id module record_id action details user_id user_name created_at

* id reference_no template_id employee_id applicant_id created_by recipient_name recipient_email letter_type contract_start_date contract_end_date contract_duration_label subject body_html status rejection_reason approved_by approved_at sent_at responded_at response_note recipient_signature recipient_signature_at access_token signed_file signed_original_name created_at updated_at

* id letter_id recipient_email subject status error_message sent_at

* id letter_id event_type actor_id details created_at

* id letter_id reminder_type due_at sent_at attempts created_at

* id name letter_type subject body_html is_active created_by created_at updated_at

* applicant_id first_name last_name date_of_birth place_of_birth sex civil_status home_address email contact_number position_applied employment_type highest_educational_attainment year_graduated character_references privacy_consent privacy_notice_version privacy_consent_at resume_filename resume_original_name cover_note custom_responses status initial_interview_date final_interview_date requirements_deadline requirements_token reviewed_by decided_by orientation_date applied_at updated_at

* log_id applicant_id action performed_by reason logged_at

* request_id employee_id request_date requested_time requested_shift_id reason status approved_by decided_at requested_at

* credit_id employee_id leave_type year allocated_days used_days

* leave_id employee_id leave_type date_from date_to reason status approved_by decided_at requested_at

* log_id leave_id action performed_by notes logged_at

* id ip_address attempted_at

* ob_id employee_id ob_date time_from time_to purpose destination status approved_by decided_at requested_at ob_latitude ob_longitude proof_file

* ot_id employee_id ot_date hours_requested reason status approved_by decided_at requested_at

* log_id payroll_id action performed_by notes logged_at

* payroll_id employee_id pay_period_start pay_period_end payout_date basic_pay overtime_pay allowances gross_pay sss_deduction philhealth_deduction pagibig_deduction tax_deduction other_deductions net_pay approval_status approved_by approved_at payment_status payment_reference_number payment_processed_by payment_processed_at paid_at cash_ack_file cash_ack_original_name cash_ack_note cash_ack_uploaded_by cash_ack_uploaded_at generated_by generated_at

* perf_id employee_id rated_by record_type period_label rating comments created_at

* history_id employee_id old_position new_position old_department new_department changed_by changed_at

* shift_id shift_name shift_type start_time end_time is_active created_at

* swap_id swap_date covering_employee_id original_employee_id shift_id reason status requested_by processed_by processed_at created_at

* id supervisor_employee_id member_employee_id assigned_by assigned_at

* id employee_id username password failed_attempts locked_until full_name profile_picture role force_logout is_active created_at two_factor_enabled two_factor_email two_factor_backup_codes two_factor_failed_attempts two_factor_locked_until

select table announcements applicant_documents application_form_fields app_settings attendance data_subject_requests discount_approval_codes employees employee_documents employee_status_logs employee_weekly_shifts holidays hr_audit_log hr_letters hr_letter_email_log hr_letter_events hr_letter_reminders hr_letter_templates job_applicants job_applicant_logs late_timein_requests leave_credits leave_requests leave_request_logs login_ip_throttle official_business_requests overtime_requests payroll_logs payroll_records performance_records position_history shifts shift_swaps supervisor_teams users . 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 announcements applicant_documents application_form_fields app_settings attendance data_subject_requests discount_approval_codes employees employee_documents employee_status_logs employee_weekly_shifts holidays hr_audit_log hr_letters hr_letter_email_log hr_letter_events hr_letter_reminders hr_letter_templates job_applicants job_applicant_logs late_timein_requests leave_credits leave_requests leave_request_logs login_ip_throttle official_business_requests overtime_requests payroll_logs payroll_records performance_records position_history shifts shift_swaps supervisor_teams users .	select column