Recent
`documenttracker`.`documentstraker_category`
`information_schema`.`CLIENT_STATISTICS`
`humanresource`.`hr_tbl_computation_amnt_setup`
`general`.`systemforms`
`accounting`.`classification_setup`
`documenttracker`.`flowsetupemployees`
`service_request_db`.`project_configs`
`documenttracker`.`it_preventive_printer_functions`
Favorites
There are no favorite tables.
New
accounting
bac_lgu
budget
cenro
dbfederation
db_meter_readings
documenttracker
el_laravue
general
humanresource
information_schema
lgis
lgis_app
lgis_dum_app
lgu_repository
mysql
online_hr
performance
performance_management
performance_schema
qpsii
qpsii_lguengineering
qpsii_lguprocurement
qpsii_lgusystem
qpsii_waterworks
queue
repository
service_request_db
Navigation panel
Navigation tree
Servers
Databases
Tables
Navigation panel
Customize appearance of the navigation panel.
Navigation panel
Show databases navigation as tree
In the navigation panel, replaces the database tree with a selector
Link with main panel
Link with main panel by highlighting the current database or table.
Display logo
Show logo in navigation panel.
Logo link URL
URL where logo in the navigation panel will point to.
Logo link target
Open the linked page in the main window (
main
) or in a new one (
new
).
main
new
Enable highlighting
Highlight server under the mouse cursor.
Maximum items on first level
The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box
Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables
Maximum number of recently used tables; set 0 to disable.
Favorite tables
Maximum number of favorite tables; set 0 to disable.
Navigation panel width
Set to 0 to collapse navigation panel.
Navigation tree
Customize the navigation tree.
Navigation tree
Maximum items in branch
The number of items that can be displayed on each page of the navigation tree.
Group items in the tree
Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion
Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree
Whether to show tables under database in the navigation tree
Show views in tree
Whether to show views under database in the navigation tree
Show functions in tree
Whether to show functions under database in the navigation tree
Show procedures in tree
Whether to show procedures under database in the navigation tree
Show events in tree
Whether to show events under database in the navigation tree
Expand single database
Whether to expand single database in the navigation tree automatically.
Servers
Servers display options.
Servers
Display servers selection
Display server choice at the top of the navigation panel.
Display servers as a list
Show server listing as a list instead of a drop down.
Databases
Databases display options.
Databases
Minimum number of databases to display the database filter box
Database tree separator
String that separates databases into different tree levels.
Tables
Tables display options.
Tables
Target for quick access icon
Structure
SQL
Search
Insert
Browse
Target for second quick access icon
Structure
SQL
Search
Insert
Browse
Table tree separator
String that separates tables into different tree levels.
Maximum table tree depth
Drop files here
SQL upload (
0
)
x
-
Show hidden navigation tree items.
Create view
Your browser has phpMyAdmin configuration for this domain. Would you like to import it for current session?
Yes
/
No
/
Delete settings
Javascript must be enabled past this point!
Server: 127.0.0.1
Database: humanresource
Structure
SQL
Search
Query
(current)
Export
Import
Operations
Privileges
Routines
Events
Triggers
Designer
Console
Clear
History
Options
Debug SQL
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 :
Options
Set default
Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme
Collapse
Expand
Requery
Edit
Explain
Profiling
Query failed
Database :
Queried time :
Loading
ENUM/SET editor
Create view
Multi-table query
Query by example
Query window
*
id
payroll_details
account_id
subsidiary_type
subsidiary
subsidiary_id
status
*
id
acctg_particulars
emp_id
emp_name
acctg_remarks
acctg_status
acctg_trans_date
ts
*
id
emp_id
reason
user_id
ts
*
id
emp_id
emp_name
dateFrom
dateTo
negative_time
positive_time
record_status
recommending_status
final_status
ts
requestor
modified_time
modified_by
*
ID
AgendaName
*
allowance_id
allowance_name
allowance_status
account_id
allowance_type
*
allowance_entry_id
empId_allowance
empname_allowance
dept_allowance
id_allowance
name_allowance
amount_allowance
status_allowance
datefrom
dateto
allowance_type
date_saved
*
allowance_entry_id
empId_allowance
empname_allowance
dept_allowance
id_allowance
name_allowance
amount_allowance
status_allowance
allowance_type
date_saved
*
allowance_id
allowance_name
allowance_status
account_id
allowance_type
*
applicant_id
applicant_FirstName
applicant_MiddleName
applicant_LastName
applicant_Address
applicant_Birthdate
applicant_Gender
applicant_Status
applicant_Weight
applicant_Height
applicant_ContactNo
applicant_ContactAddress
applicant_EmailAddress
applicant_EducationBackground
applicant_PositionApplied
applicant_InitialInterview
applicant_Exam
applicant_FinalInterview
applicant_DateApplied
date_saved
applicant_remarks
applicant_skills1
applicant_skills2
applicant_skills3
applicant_skills4
*
applicantskills_id
applicants_no
applicantskills
*
overtime_id
employee_number
overtime_hrs_from
overtime_hrs_to
overtime_date
overtime_status
*
ID
AppGUID
DocumentName
DocumentType
_Data
*
ID
AppGuid
UID
UserFullName
DepartmentID
DepartmentName
TS
*
ID
SchedType
SubType
Type
Start
End
AllDay
Subject
LocationID
Location
Description
Status
Label
OrigOccurenceStart
OrigOccurenceEnd
ResourceID
ResourceIDs
ReminderInfo
RecurrenceInfo
TimeZoneId
id_User
GUID
*
id
trans_id
transaction_type
codex
signatory
uids
ts
*
SysPK_Emp
UserID_Empl
Name_Empl
Department
Group
OvertimeDate
modifiedby
modifieddate
*
OT_ID
SysPK_emp_attendance
employee_number
dtr_date
OT_Hours
remarks
Time_Start
Time_End
OT_status
dept_code
approved_date
*
bank_id
bank_name
status
*
brgyid
brgyname
*
id
bill_date
bill_ref
client_name
fee_description
qty
unit
fee_amount
addon
total_without_tax
total_with_tax
*
Employee_ID
Employee_Name
*
id
bpaid
docid
img
status
remarks
datetime
*
id
emp_id
dept_id
status
*
id
emp_id
dept_id
Fund
status
*
id
days
*
datefield
*
id
mainId
bp_no
lastName
firstName
middleName
prefix
appelation
birthdate
CRN
basic_monthly_salary
effectivity_date
PS
GS
EC
conso_loan
ecard_plus
salary_loan
cash_adv
EMRGYLN
educ_asst
ELA
SOS
PLREG
PLOPT
REL
lch_dcs
stock_purchase
opt_life
CEAP
edu_child
genesis
gen_plus
gen_flexi
gen_spcl
help
GFAL
MPL
CPL
GEL
status
*
id
ts
status
*
id
date
sysPK_Empl
Adjustment
OtherAddOns
company_id
project_id
Remarks
*
CLRFNumber
CLEmpName
CLProjCode
CLProjName
CLLocation
CLDate
CLAmount
CLPeriodfrom
CLPeriodto
CLGrossAmount
sss
phic
hdmf
cassd
metrobank
bdo
wtax
sssloan
pagibigloan
CLCompany
*
CLdtlRFNo
CLdtlProjCode
CLdtlProjName
CLdtlAmount
sss
phic
hdmf
cassd
metrobank
bdo
wtax
sssloan
pagibigloan
*
SysPK_CshAdv
SysFK_Empl_CshAdv
UserCode_CshAdv
Name_CshAdv
DateTrans_CshAdv
Amount_CshAdv
Balance_CshAdv
Terms_CshAdv
AmortAmount_CshAdv
Remarks_CshAdv
DeductionId
Description_CshAdv
CompanyCode
ProjectCode
PriorityNo
JID
JE_status
GROUPNAME
from_Procurement
approved_by
date_saved
incr
loan_status
DEDUCTION_ACCOUNT_ID
*
SysPK_CshAdv_details_id
SysFK_Empl_CshAdv
UserCode_CshAdv
Name_CshAdv
DateTrans_CshAdv
Amount_CshAdv
Balance_CshAdv
Terms_CshAdv
AmortAmount_CshAdv
Remarks_CshAdv
Description_CshAdv
CompanyCode
ProjectCode
PriorityNo
JID
JE_status
DeductionId
GROUPNAME
from_Procurement
status_cashadvance
date_from
date_to
CA_debreAmount
SysPK_PaySlip
id_cashadvance
*
ID
DATE
EMP_ID
NAME
AMOUNT
STATUS
PAYEDTYPE
*
id
emp_id
emp_name
attached_image
clearance_status
ts
*
id
emp_id
emp_name
comment
comment_status
ts
*
ID
APPGUID
Data
*
ID
ComitteeID
EmpID
EmployeeName
ComitteePosition
Email
ContactNum
*
ID
Types
DocName
TemplateFormat
*
ID
DepartmentID
DepartmentName
CommitteeName
Note
Status
UID
TS
*
ID
AgendaID
AgendaName
Remarks
CommitteeID
AppGUID
StartDate
EndDate
*
ID
AppGUID
ReferenceType
ReferenceID
*
ID
CommitteeID
AppGUID
StartDate
EndDate
UserID
UserFullName
*
id
td_id
tax_year
period
assessed_value
improvemnets
basic_tax
SEF_Tax
basic_penalty
SEF_penalty
basic_discount
SEF_discount
basic_provincial_share
basic_municipal_share
basic_brgy_share
SEF_provincial_share
SEF_municipal_share
Total_amount
total_assessedValue
employee_id
Status
main_id
or_number
or_date
transaction_type
ts
or_id
GUID
UID
*
cur_id
cur_country
cur_currency
cur_status
*
id
main_id
group_id
setup_id
*
id
main_group
main
description
*
id
Department
Rate_time
ref_no
Ratings
uid
done_survey
status
*
id
date
empId
EmpName
amount
deductionType
position
*
status_deduct_id
empl_number
SSS
sss_deductype
sss_manual_amount
PHILHEALTH
philhealth_deductype
philhealt_manual_amount
PAGIBIG
pagibig_deductype
pagibig_manual_amount
TAX
tax_deductype
tax_manual_amount
*
Id
EmpId
datefrom
dateto
amount
remarks
company_id
department_id
*
id
name
*
govt_dduct_id
empl_id
project_site_code
payroll_datefrom
payroll_dateto
sss_amt
plhealth_amt
pgibig_amt
wtax_amt
cashadvance_amt
agrivet_amt
food_amt
PGIBIG_LOAN_amt
SSS_LOAN_amt
current_date
*
id
ca_id
dateFrom
dateTo
emp_id
deduction_amount
reason
status
ts
*
id
SSS
PHIC
WTAX
HDMF
SALARY_TYPE
*
SysPK_Dept
order_no
CODE
DeptCode_Full
DeptCode_Dept
Services_Dept
prefix
short_desc
sortby
inspectorate
sort_inspectorate
memorandum
Name_Dept
Plantilla_Name
Head_Dept
AssistantHead_Dept
type
main_dept_id
Remarks_Dept
title_id
project_id
international
local
tel_no
status
date_save
Location_Dept
Email_Dept
Website_Dept
hotline
fax_no
cell_no
REFCODE
Include
isHRD
isPayGp
isRespCnter
esig_depthead
function
project_activity
subsec_plantilla
ir_head
pay_jo_prio
pay_jo_supp_prefix
pay_jo_supp_id
pay_jo_pos
*
ID
DEPID
DIV_COD
DIVISION_NAME
STATUS
TSTAMP
DEPARMENT_NAME
*
SysPK_Dept
CODE
DeptCode_Full
DeptCode_Dept
Services_Dept
prefix
pay_jo_prio
pay_jo_supp_prefix
pay_jo_supp_id
pay_jo_pos
short_desc
short_desc1
sortby
inspectorate
sort_inspectorate
memorandum
Name_Dept
Plantilla_Name
Head_Dept
AssistantHead_Dept
type
main_dept_id
Remarks_Dept
title_id
project_id
international
local
tel_no
status
date_save
Location_Dept
Email_Dept
Website_Dept
hotline
fax_no
cell_no
REFCODE
Include
isHRD
isPayGp
isRespCnter
esig_depthead
function
project_activity
subsec_plantilla
ir_head
*
SysPK_Dept
CODE
DeptCode_Full
DeptCode_Dept
Services_Dept
prefix
pay_jo_prio
pay_jo_supp_prefix
pay_jo_supp_id
pay_jo_pos
short_desc
short_desc1
sortby
inspectorate
sort_inspectorate
memorandum
Name_Dept
Plantilla_Name
Head_Dept
AssistantHead_Dept
type
main_dept_id
Remarks_Dept
title_id
project_id
international
local
tel_no
status
date_save
Location_Dept
Email_Dept
Website_Dept
hotline
fax_no
cell_no
REFCODE
Include
isHRD
isPayGp
isRespCnter
esig_depthead
function
project_activity
subsec_plantilla
ir_head
*
id
dept_code
change_date
status
*
id
developer_mode
date_modified
password_dev
*
id
CVNo
Paid_To
Amount
DatePeriod
Address
DateTrans
Company
Particular
Remarks
*
ID
Dis_id
Particular
Amount
Type
*
SysPK_Division
Div_code
Division_Name
Division_Head
division_Title
*
division_id
division_code
division_name
company_id
division_status
*
name
fname
id
*
UserID_Empl1
Name_Empl
equipment
*
SysPK_DTR
SysFK_Empl_DTR
DateTimeLog
Login_DTR
Logout_DTR
RegularHours_DTR
OverTimeHours_DTR
UnderTimeHours_DTR
Remarks_DTR
SysSeq_DTR
Name_DTR
*
id
emp_id
date_from
date_to
app_by
date_time_app
*
id
emp_id
app_by
*
id
emp_id
date_from
date_to
app_by
tss
payroll_makerid
*
DTR_ID
AM_IN
AM_OUT
PM_IN
PM_OUT
REMARKS
DATE_SAVED
*
_date
*
id
emp_id
trans_date
ref_no
*
id
*
id
cluster_id
member_id
type
status
remarks
date_created
user_id
*
pdp_id
pdp_apdate
pdp_applicant_id
pdp_cert_no
pdp_seriesno
pdp_purpose
pdp_issued_date
pdp_valid_until
pdp_note
pdp_cc
pdp_brgy
pdp_brgy_id
pdp_address
pdp_type
pdp_permit_id
pdp_permit_name
status
resolution
series_year
pdp_mayor
ctc_no
tin_no
permit_name
*
id
type_
timestamp
*
travel_id
travel_no
application_date
official_station
place
purpose
inclusive_from
inclusive_to
remarks
purpose_text
instructions
status
approved_by
recom_by
recom_pos
TravelType
TotalCost
category
*
dtl_id
travel_id
dept_id
employee_name
position
pass_slip_no
pass_slip_id
empl_id
*
id
purpose
type_
status
*
id
name
*
SysPK_Empl
old_personId
person_id
status_update
priority
AccountNo_Empl
Emp_no
trans_date
Name_Empl
FirstName_Empl
MiddleName_Empl
LastName_Empl
SuffixName_Empl
PrefixName_Empl
nickname
Address_Empl
empl_contactno
email_address
BirthDate_Empl
weight
height
gender
civilStatus
dependent
GSIS_Empl
SSS_Empl
TIN_Empl
philhealth_no
pagibig_no
with_atm
bankname_Empl
bankaccount_Empl
BloodType_Empl
EmergencyName_Empl
EmergencyAdd_Empl
EmergencyTelNo_Empl
Position_Empl
count
Department_Empl
shift_code
RateBasis
RatePerDay_Empls
BasicSalary_Empls
DateHired_Empl
DateEffectivity_Empl
DatTerminated_Empl
DateRetired
Status_Empl
Type_Empl
office_location
payroll_group
with_bio
with_contract
pertrip
title_id
branch_id
time_stamp
RHouse_No
RSubd_Village
RCity_Mun
RZipcode
RStreet
brgyid
RBrgy
RProvince
PHouse_No
PSubd_Village
PCity_Mun
PZipcode
PStreet
PBrgy
PProvince
sal_grade_id
recruitment_id
birthplace
government_ID
ID_License_Passport
Date_Place_Issuance
privilege
Appoint_Status
jo_group_no
with_pds
level
indigenous_group
person_disablity
solo_parent
bp_number
designate_dept
designate_pos
designate_count
item_no
authorized
date_promotion
level_csc
inactive_date
shift_type
payrollType
group_pm
lc_earn_start_date_casual
lc_earn_start_date
jo_wtax
citizen
agency_no
period_from
period_to
old_emp_id
*
id
emp_number
allowance_id
payroll_type
amount
status
*
SysPK_ID
transDate_Empl
person_id
Name_Empl
Position_id
Position_Empl
Department_Empl
designate_dept
designate_pos
designate_count
Status_Empl
ts
*
SysPK_Empl
old_personId
person_id
status_update
priority
AccountNo_Empl
Emp_no
trans_date
Name_Empl
FirstName_Empl
MiddleName_Empl
LastName_Empl
SuffixName_Empl
PrefixName_Empl
nickname
Address_Empl
empl_contactno
email_address
BirthDate_Empl
weight
height
gender
civilStatus
dependent
GSIS_Empl
SSS_Empl
TIN_Empl
philhealth_no
pagibig_no
with_atm
bankname_Empl
bankaccount_Empl
BloodType_Empl
EmergencyName_Empl
EmergencyAdd_Empl
EmergencyTelNo_Empl
Position_Empl
count
Department_Empl
shift_code
RateBasis
RatePerDay_Empls
BasicSalary_Empls
DateHired_Empl
DateEffectivity_Empl
DatTerminated_Empl
DateRetired
Status_Empl
Type_Empl
office_location
payroll_group
with_bio
with_contract
pertrip
title_id
branch_id
time_stamp
RHouse_No
RSubd_Village
RCity_Mun
RZipcode
RStreet
brgyid
RBrgy
RProvince
PHouse_No
PSubd_Village
PCity_Mun
PZipcode
PStreet
PBrgy
PProvince
sal_grade_id
recruitment_id
birthplace
government_ID
ID_License_Passport
Date_Place_Issuance
privilege
Appoint_Status
jo_group_no
with_pds
level
indigenous_group
person_disablity
solo_parent
bp_number
designate_dept
designate_pos
designate_count
item_no
authorized
date_promotion
level_csc
inactive_date
shift_type
payrollType
group_pm
lc_earn_start_date_casual
lc_earn_start_date
jo_wtax
citizen
agency_no
period_from
period_to
old_emp_id
*
id
emp_id
shift_id
trans_date
date_save
status
pos_id
_rate
*
id
emp_number
cse_careerservice
cse_dateofexam
cse_placeofexam
cse_rating
cse_licenseno
cse_datereleased
date_timestamp
civil_statx
*
SysPK_Empl
old_personId
person_id
status_update
priority
AccountNo_Empl
Emp_no
trans_date
Name_Empl
FirstName_Empl
MiddleName_Empl
LastName_Empl
SuffixName_Empl
PrefixName_Empl
nickname
Address_Empl
empl_contactno
email_address
BirthDate_Empl
weight
height
gender
civilStatus
dependent
GSIS_Empl
SSS_Empl
TIN_Empl
philhealth_no
pagibig_no
with_atm
bankname_Empl
bankaccount_Empl
BloodType_Empl
EmergencyName_Empl
EmergencyAdd_Empl
EmergencyTelNo_Empl
Position_Empl
count
Department_Empl
shift_code
RateBasis
RatePerDay_Empls
BasicSalary_Empls
DateHired_Empl
DateEffectivity_Empl
DatTerminated_Empl
DateRetired
Status_Empl
Type_Empl
office_location
payroll_group
with_bio
with_contract
pertrip
title_id
branch_id
time_stamp
RHouse_No
RSubd_Village
RCity_Mun
RZipcode
RStreet
brgyid
RBrgy
RProvince
PHouse_No
PSubd_Village
PCity_Mun
PZipcode
PStreet
PBrgy
PProvince
sal_grade_id
recruitment_id
birthplace
government_ID
ID_License_Passport
Date_Place_Issuance
privilege
Appoint_Status
jo_group_no
with_pds
level
indigenous_group
person_disablity
solo_parent
bp_number
designate_dept
designate_pos
designate_count
item_no
authorized
date_promotion
level_csc
inactive_date
shift_type
payrollType
group_pm
lc_earn_start_date_casual
lc_earn_start_date
jo_wtax
citizen
agency_no
*
SysPK_Empl
old_personId
person_id
status_update
priority
AccountNo_Empl
Emp_no
trans_date
Name_Empl
FirstName_Empl
MiddleName_Empl
LastName_Empl
SuffixName_Empl
PrefixName_Empl
nickname
Address_Empl
empl_contactno
email_address
BirthDate_Empl
weight
height
gender
civilStatus
dependent
GSIS_Empl
SSS_Empl
TIN_Empl
philhealth_no
pagibig_no
with_atm
bankname_Empl
bankaccount_Empl
BloodType_Empl
EmergencyName_Empl
EmergencyAdd_Empl
EmergencyTelNo_Empl
Position_Empl
count
Department_Empl
shift_code
RateBasis
RatePerDay_Empls
BasicSalary_Empls
DateHired_Empl
DateEffectivity_Empl
DatTerminated_Empl
DateRetired
Status_Empl
Type_Empl
office_location
payroll_group
with_bio
with_contract
pertrip
title_id
branch_id
RHouse_No
RSubd_Village
RCity_Mun
RZipcode
RStreet
RBrgy
RProvince
PHouse_No
PSubd_Village
PCity_Mun
PZipcode
PStreet
PBrgy
PProvince
sal_grade_id
recruitment_id
birthplace
government_ID
ID_License_Passport
Date_Place_Issuance
privilege
Appoint_Status
jo_group_no
with_pds
level
indigenous_group
person_disablity
solo_parent
bp_number
designate_dept
designate_pos
designate_count
item_no
authorized
date_promotion
level_csc
inactive_date
*
id
SysPK_Empl
dependentName
birthdate
relation
status
*
id
emp_id
position_title
designation
office_Unit
immediate_supervisor
agency_org
reference_no
dated
date_started
date_ended
capacity
accomplishment_list
duties_list
*
id_edu
emp_number
edu_level
edu_schoolname
edu_degree
edu_highgrade
edu_honor
edu_yeargraduated
edu_inclusivedatefrom
edu_inclusivedateto
remarks
date_timestamp
status
*
id
emp_number
spouse_surname
spouse_firstname
spouse_middlename
spouse_ext
spouse_occupation
spouse_employer
spouse_employeradd
spouse_Telno
father_surname
father_firstname
father_middlename
father_ext
mother_surname
mother_firstname
mother_middlename
datetimestamp
*
id
SysPK_Empl
UserID_Empl
Name_Empl
FirstName_Empl
MiddleName_Empl
LastName_Empl
Present_Address_Empl
Home_Address_Empl
Position_Empl
Department_Empl
Hiring_Entity
SSS_Empl
TIN_Empl
BloodType_Empl
EmergencyName_Empl
EmergencyAdd_Empl
EmergencyTelNo_Empl
AccountNo_Empl
TimeStart_Empl
TimeEnd_Empl
DoleRate_Empl
PhotoPath_Empl
BirthDate_Empl
RatePerDay_Empls
DeductCashBond_Empl
CashCard_Empl
DateHired_Empl
DatTerminated_Empl
Status_Empl
Type_Empl
Remarks_Empl
BasicSalary_Empls
Branch_Empl
Honorarium_Empl
Group_Empl
deduction_effectivity
withHolding_effectivity
Allowance
Restday
Restday2
philhealth_no
pagibig_no
weight
height
gender
resident_certificate_no
civilStatus
dependent
bankname_Empl
UserID_Empl1
schedule
branchCode
formType
cola
evaluated
pertrip
empl_contactno
app_id
Photo
sss_payee
phic_payee
hdmf_payee
wtax_payee
auto_overtime
payroll_numdays
evaluation_result
date_regularization
provincial_address
remarks_endContract
remarks_endSeason
pay_card_number
pin_number
pay_type
dependent_rel1
dependent_rel2
dependent_rel3
dependent_rel4
snack_time_in
lunch_time_in
emp_prefix
snack_time_out
lunch_time_out
termination_type
final_approval
password
wtax_selected
religion
salary_type
Address_Empl
schedule_id
cola_taxable
allowance_taxable
user_id
ts
email_add
*
id
emp_number
leave_type_id
credit
month_year
status
entry_type
*
limit_id
emp_position
Position_Empl
department_name
Position_Description
Position_Code
emp_limit
*
id
emp_number
otherinfo_1A
otherinfo_1B
otherinfo_1BDesc
otherinfo_2A
otherinfo_2ADESC
otherinfo_2B
otherinfo_2BDatefile
otherinfo_2BDesc
otherinfo_3
otherinfo_3Desc
otherinfo_4
otherinfo_4Desc
otherinfo_5A
otherinfo_5ADesc
otherinfo_5B
otherinfo_5BDesc
otherinfo_6
otherinfo_6Desc
otherinfo_7A
otherinfo_7ADesc
otherinfo_7B
otherinfo_7BDesc
otherinfo_7C
otherinfo_7CDesc
date_timestamp
*
SysPK_ID
transDate_Empl
person_id
Name_Empl
Position_id
Position_Empl
Department_Empl
designate_dept
designate_pos
designate_count
Status_Empl
ts
*
id
include
auto_comp
SysPK_Empl
premium_id
employee_deduction
employee_share_1st
employee_share_2nd
employeer_deduction
employer_share_1st
employer_share_2nd
*
id
TITLE_ID
Group_Empl
Department_Empl
Position_Empl
Short_desc
dolerate_check
DoleRate_Empl
emprate_check
RatePerDay_Empl
BasicSalary_Empl
Honorarium_Empl
Location_Empl
Position_Code
status
doleRate_status
currency
category
education
training
experience
eligibility
competency
date_save
*
id
TITLE_ID
Group_Empl
Department_Empl
Position_Empl
Short_desc
dolerate_check
DoleRate_Empl
emprate_check
RatePerDay_Empl
BasicSalary_Empl
Honorarium_Empl
Location_Empl
Position_Code
status
doleRate_status
currency
category
education
training
experience
eligibility
competency
date_save
*
id
emp_number
reference_name
occupation
address
tel_no
mobile_no
date_timestamp
status
*
empl_sec_id
empl_id
clientcode
position_id
section_id
section_code
status
remarks
ts
*
id
emp_number
skills_hobbies
distinction_recognition
membership_org
date_timestamp
status
*
shiftcode
description
shift_type
timeFrom
timeTo
breakTime
firstIn
firstOut
Temp1
secondIn
Temp2
secondOut
Temp3
timeAllowanceFirst
timeAllowanceSecond
allowance_a
allowance_b
req_hours
declare_overtime
log_in_cnt
direct_overtime
ovetime_start
differential
night_diff_from
night_diff_to
status
random
date_save
time_interval
in_interval
out_interval
first_no_hrs
second_no_hrs
no_hrs
view_asis
is_shifting
*
shiftcode
description
shift_type
timeFrom
timeTo
breakTime
firstIn
firstOut
Temp1
secondIn
Temp2
secondOut
Temp3
timeAllowanceFirst
timeAllowanceSecond
allowance_a
allowance_b
req_hours
declare_overtime
log_in_cnt
direct_overtime
ovetime_start
differential
night_diff_from
night_diff_to
status
random
date_save
time_interval
in_interval
out_interval
*
id
emp_number
title_of_seminar
no_of_hour
conducted
type_of_LD
date_from
date_to
date_timestamp
status
*
id
emp_number
title_of_seminar
no_of_hour
conducted
type_of_LD
date_from
date_to
date_timestamp
status
*
id
emp_number
Name_address_org
No_ofHours
position
datefrom
dateto
date_timestamp
status
*
workexpID
idinfo
emp_number
workexp_position
workexp_company
workexp_govser
workexp_monthlysal
workexp_salgrade
workexp_statofemployment
workexp_startdate
workexp_enddate
date_timestamp
workexp_cmpnyadd
workexp_city
workexp_province
workexp_startsalary
workexp_lastsalary
workexp_sprname
workexp_sprtitle
workexp_telNo
workexp_reason
status
*
id
emp_number
emp_type
date_from
date_to
status
*
id
emp_id
employee_name
attachment_title
attachment_location
status
ts
userid
*
attachmentId
empId
attachmentType
attachmentStatus
*
emp_blocked
emp_number
date_blocked
blocked
remarks
savedate
user_modified
datemodified
*
empl_status_Id
empl_number
empl_name
empl_status
user_modified
date_modified
*
bloodtype_id
blood_type
*
id
ec_number
trans_date
branch
department
emp_id
emp_name
record_status
ts
*
deducstatus_id
empl_number
empl_name
SSS
PhilHealth
PagIbig
Tax
*
id_edu
emp_number
edu_nmeadd
edu_degree
edu_yearinclsve
edu_honorsrcvd
remarks
*
entity_id
emp_hiring_entity
*
PPID
DEPARTMENT
POSITION
NAME
GENDER
DATEHIRED
USERID
DEPID
POSID
EMP TYPE
GROUP
Selected
short
HEAD
Head_Dept
Head_Dept_asign1
Head_Dept_asign
headId
ir_head
AssistantHead_Dept
main_dept_id
rateHour
*
PPID
DEPARTMENT
POSITION
NAME
GENDER
DATEHIRED
USERID
DEPID
POSID
EMP TYPE
GROUP
Selected
short
HEAD
Head_Dept
Head_Dept2
headId
ir_head
AssistantHead_Dept
main_dept_id
*
*
*
*
*
*
mdcal_id
mdcal_code
mdcal_cntrolno
empl_number
empl_name
empl_address
empl_age
empl_gender
empl_civilstatus
empl_agesex
empl_bday
empl_religion
empl_position
empl_department
empl_philhealthno
empl_sssno
empl_pagibigno
empl_tinno
empl_company
mdcal_typeexam
mdcal_examdate
mdcal_symtoms
mdcal_remarks
mdcal_fmlymdcalhstory
mdcal_accedenthstory
mdcal_surgcalhstory
alergies_code
mdcal_allergies
mdcal_mentrualcycle
mdcal_LMP_duration
mdcal_nulligravida
mdcal_gravida
mdcal_para
tobacco_code
mdcal_tobacco_use
alcohol_code
mdcal_alcohol_use
mdcal_nameclinic
mdcal_addclinic
PhotoPath_Empl
examdate_expiry
status
retrieve_data
save_date
*
labresult_id
mdcal_id
lab_name
lab_age
lab_gender
lab_date
lab_company
lab_bc_Hemoglobin
lab_bc_Hct
lab_bc_RBCcount
lab_bc_Plateletcount
lab_bc_WBCcount
lab_bc_Segmenters
lab_bc_Lymphocytes
lab_bc_Mid
lab_bc_others
lab_ur_Urinecolor
lab_ur_Transparency
lab_ur_pH
lab_ur_SpecificGrabvit
lab_ur_Sugar
lab_ur_Protein
lab_ur_Puscells
lab_ur_RBC
lab_ur_Epithelialcells
lab_ur_Mucusthreads
lab_ur_Amorpsubs
lab_ur_Crystals
lab_ur_Bacteria
lab_se_Color
lab_se_Consistency
lab_se_Puscells
lab_se_Redbloodcells
lab_se_Ovalparasites
lab_dt_Methamphetamine
lab_dt_Marijuana
lab_others_hepatitis
lab_others_VDRL
lab_others_Pregnancytest
lab_rmrks_chestxray_findings
lab_rmrks_ECG_findings
lab_rmrks_diagnosis
lab_checktype_clsfction
lab_rmrks_recomendation
*
pastillness_id
mdcal_id
pastillness_code
illnesses
*
pe_findings_id
mdcal_id
pe_findings_code
pe_findings
pe_code
*
physcalexam_id
mdcal_id
physcl_height
physcl_weight
physcl_BMI
physcl_pulse
physcl_BP_se
physcl_mmHg
physcl_cnvrstn_hearing
dstnt_OD_uncrct
dstnt_OS_uncrct
dstnt_OD_crct
dstnt_OS_crct
near_OD_uncrct
near_OS_uncrct
near_OD_crct
near_OS_crct
*
status_id
empl_number
empl_name
status
*
empl_info_id
empl_number
empl_name
empl_city
empl_prov
empl_zipcode
empl_religion
empl_placeofbirth
*
emp_id
pic
*
ref_id
ref_code
empl_number
ref_name
ref_address
ref_occupation
ref_yearsknown
*
sal_type_id
salary_type
*
id
filename
img
ext
path
empid
ts
*
Skills_id
Skills_code
emp_number
skl_opermchine
skl_opercmpter
skl_operfaxmchine
skl_opetypwriter
skl_others
skl_restcode
skl_language
skl_softknowlegde
*
Skills_Ref_id
Skills_Refcode
emp_number
sklref_city
sklref_prov
sklref_zip
sklref_relegion
sklref_opermchine
sklref_opercmpter
sklref_operfaxmchine
sklref_opetypwriter
sklref_others
sklref_restcode
sklref_language
sklref_softknowlegde
sklref_refname
sklref_refaddress
sklref_refoccupation
sklref_refyears
*
id
emp_id
emp_name
skill_id
skill_name
skill_level
ts
*
emp_stat_id
emp_stat
*
emp_type_id
emp_type
remarks
Status
emp_order
emp_sal
payroll_cat
is_permanent
*
workexpID
idinfo
emp_number
workexp_position
workexp_company
workexp_cmpnyadd
workexp_city
workexp_province
workexp_startdate
workexp_enddate
workexp_startsalary
workexp_lastsalary
workexp_sprname
workexp_sprtitle
workexp_telNo
workexp_reason
*
SyspkServiceRecord
ref_num
sr_empno
history_id
sr_department_id
sr_company_id
sr_position_name
sr_rate
sr_effective_datefrom
sr_effective_dateto
status
*
id
ref_num
title_id
project_id
from_dept_id
to_dept_id
date_transferred
save_date
status
*
id
main_id
emp_id
position
rate
*
id
no_units
type
trans_date
*
Id
EventID
DepartmentID
_Date
*
flog
emp_num
emp_name
log_datetime
status
save_date
*
allowance_entry_id
empId_allowance
empname_allowance
dept_allowance
id_allowance
name_allowance
amount_allowance
status_allowance
currency_allowance
payroll_from
payroll_to
company
branch
taxable
*
id
name
description
*
id
name
description
*
status_id
empl_number
empl_name
empl_position
Status_Empl
user_modified
status_remarks
date_modified
*
empl_status_Id
empl_number
empl_name
empl_status
date_modified
user_modified
save_date
*
pos_id
empl_number
empl_name
empl_deptcode
empl_position
user_modified
date_modify
*
id
hr_particulars
emp_id
emp_name
hr_remarks
hr_status
hr_trans_date
ts
*
id
employee_id
Form_Remarks
ts
*
id
emp_id
reason
date_effectivity
lwop
date_from
date_to
status
ts
*
id
correction_pk
emp_id
description_id
from_
to_
status
ts
approve_date
*
id
description
*
id
emp_id
main_id
logDate
time_log
mode_id
mode_type
device_id
ip_address
date_created
type
*
id
emp_id
time_log
mode_id
mode_type
device_id
ip_address
date_created
*
id
from_date
to_date
inserted_rows
skipped
ip_add
device_id
count
date_requested
*
id
from_date
to_date
inserted_rows
skipped
ip_add
device_id
count
date_requested
*
id
emp_id
time_log
mode_id
mode_type
device_id
ip_address
date_created
*
SysPK
ipAddress
userName
passWordt
useStat
*
id
emp_id
state
card_no
password
finger_index
iflag
biometric_data
privelage
*
id
machine_id
emp_id
state
card_no
password
finger_index
iflag
biometric_data
privelage
*
id
certificate_name
datax
*
id
certificate_detail
fields_id
datafield
*
id
certificate_name
field_id
data_field_id
status
*
id
table
fields
description
datax
order
*
id
employeeID
datex
timex
companyx
tel_no
addressx
status
*
id
trans_date
agenda_name
*
dtl_id
agenda_id
emp_id
com_set_member_id
status
*
id
trans_date
Agenda_id
Agenda_Name
Metting_content
Remarks
status
*
id
metting_id
emp_id
agenda_attendee_id
*
id
trans_Date
minutes_id
Data_content
title_description
Remark
status
*
id
decription
status
*
id
Com_id
emp_id
Position
status
TS_TIMESTAMP
*
emp_number
person_profile_no
employee_id
emp_status
emp_position_id
department_id
emp_position
department_code
sal_grd_code
step
joined_date
emp_email
terminated_date
termination_reason
record_status
emp_remarks
current_assignDept
increment_date
levelof_position
bp_number
Photo
in_ot
out_ot
ac_pera
Restday
ot
account_id
account_description
Exemption
BARCODE
multiplePosition
BUDGET_POSITION
BUDGET_RATE
division_id
*
emp_id
emp_fp
file_size
ff_type
*
empl_ass_proj_id
empl_number
empl_name
projectsite_id
date_effective
date_save
*
SysPK_emp_attendance
attendance_id
employee_number
employee_fullName
dtr_date
in_am
out_am
am_note
in_pm
out_pm
pm_note
late
undertime
total_hours_worked
status
att_remarks
note_am_in
note_am_out
note_pm_in
note_pm_out
OB_notes
modify_user
overtime
in_ot
out_ot
modifiedby
modifieddate
total_hours_worked_new
leave_status
dept_code
machine_id
*
SysPK_emp_attendance
attendance_id
employee_number
employee_fullName
dtr_date
in_am
out_am
am_note
in_pm
out_pm
pm_note
late
undertime
total_hours_worked
status
att_remarks
note_am_in
note_am_out
note_pm_in
note_pm_out
OB_notes
modify_user
overtime
in_ot
out_ot
modifiedby
modifieddate
total_hours_worked_new
leave_status
dept_code
*
SysPK_emp_attendance
attendance_id
employee_number
employee_fullName
dtr_date
in_am
out_am
am_note
in_pm
out_pm
pm_note
late
undertime
total_hours_worked
status
att_remarks
note_am_in
note_am_out
note_pm_in
note_pm_out
OB_notes
modify_user
overtime
in_ot
out_ot
modifiedby
modifieddate
total_hours_worked_new
leave_status
dept_code
machine_id
*
id
Empl_Id
Empl_name
Empl_projectsite
projectsite_datefrom
projectsite_dateto
projectsite_WrkngHrs
projectsite_WrkngPay
projectsite_OTHrs
projectsite_OTPay
user_modified
date_saved
*
othersite_id
empl_number
othersite_date
othersite_amIN
othersite_amOUT
othersite_pmIN
othersite_pmOUT
othersite_otIN
othersite_otOUT
othersite_projectcode
*
typeEmpl_id
employee_type
remarks
date_save
status
limit
*
leave_id
leave_date
leave_date_applied
leave_length_days
leave_type_id
employee_id
start_time
end_time
leave_status
leave_remarks
leave_pay_type
leave_rem_vl
leave_rem_sl
leave_applied
leave_contactperson
leave_contactno
leave_addresswol
guid
ts
icon_name
*
id
Emp_id
Particular
dateFrom
dateTo
ACTION
SickEarn
SickLeave
VacationEarn
VacationLeave
TSTAMP
ATTID
COUNT
UNDERTIME
COUNTUNDER
Type
date_TU
*
id
Emp_id
dateFrom
PERIOD
PARTICULARS
VACATIONEARN
VABSENTUNDERTIMEWPAY
VBALANCE
VABSENTUNDERTIMEWOPAY
SICKEARN
SABSENTUNDERTIMEWPAY
SBALANCE
SABSENTUNDERTIMEWOPAY
SPEARNED
SP
SPBAL
ACTION
TYPE
TSTAMP
ordr
*
id
Emp_id
Particular
dateFrom
dateTo
ACTION
SickEarn
SickLeave
VacationEarn
VacationLeave
TSTAMP
ATTID
COUNT
UNDERTIME
COUNTUNDER
*
emp_leave_credit_number
emp_number
leave_number
no_of_days_allotted
leave_taken
year
Entry_Type
*
leave_number
leave_type
leave_description
leave_code
withPay
stat
with_credit
leave_limit
isLimited
date_save
*
leavecredits_id
empl_number
VL_credits
SL_credits
VL_taken
SL_taken
VL_balance
SL_balance
date_hired
remarks
date_saved
served_year
credits_year
*
projectsite_id
project_site
remarks
date_save
*
service_rec_no
emp_number
inc_date_from
inc_date_to
emp_position
emp_status
emp_basic_sal
isMonthly
official_station
leave_without_pay
separation_cause
separation_date
*
emp_number
timeIn
timeOut
amIN
amOUT
pmIN
pmOUT
shiftcode
*
holiday_id
description
ctype
holiday_date
holidaytype
holiday_code
holiday_year
holidayisFixed
stat
applicable
date_save
duty_type
*
special_id
holiday_id
holiday_code
special_name
special_date
special_dept
*
jobStatusNumber
jobStatusCode
jobStatusName
*
id
leave_type
status
default_leave_credit
*
ed_pp_code
ed_seqno
ed_name
ed_relationship
ed_date_of_birth
*
SysPK_EDBG
education_syscode
education_pp_code
education_level
education_School
education_DegreeCourse
education_yearGraduated
education_date_from
education_date_to
education_grades
education_honors_etc
*
SysPK_eligibility
eligibility_pp_code
eligibility_career
eligibility_dateofExam
eligibility_placeofExam
eligibility_rating
eligibility_license_no
eligibility_license_rel_date
*
SysPK_PPFBG
pp_fbg_pp_code
pp_fbg_spousecode
pp_fbg_spousename
PP_fbg_spouse_surname
PP_fbg_spouse_firstname
PP_fbg_spouse_middlename
pp_fbg_spouse_occupation
pp_fbg_sp_Employer
pp_fbg_sp_EmpAddress
pp_fbg_sp_Contact
pp_fbg_fathercode
pp_fbg_fathers_surname
pp_fbg_fathers_fisrtname
pp_fbg_fathers_middle
pp_fbg_fathersname
pp_fbg_mothercode
pp_fbg_mothers_surname
pp_fbg_mothers_firstname
pp_fbg_mothers_middlename
pp_fbg_mothersname
PP_fbg_bd
TSTAMP
*
otherInfo_pp_code
otherInfo_ans1A
otherInfo_desc1A
otherInfo_ans1B
otherInfo_desc1B
otherInfo_ans2A
otherInfo_desc2A
otherInfo_ans2B
otherInfo_desc2B
otherInfo_ans3
otherInfo_desc3
otherInfo_ans4
otherInfo_descr4
otherInfo_ans5
otherInfo_descr5
otherInfo_ans6A
otherInfo_descr6A
otherInfo_ans6B
otherInfo_descr6B
otherInfo_ans6C
otherInfo_descr6C
*
SysPK_PP
pp_person_code
pp_prefix
pp_lastname
pp_firstname
pp_middlename
pp_suffix
pp_fullname
pp_dob
pp_birthplace
pp_sex
pp_civilstatus
pp_citizenship
pp_height
pp_weight
pp_bloodType
pp_GSIS_no
pp_PAGIBIG_no
pp_PHILHEALTH_no
pp_SSS_no
pp_TIN
pp_Address1
pp_zipcode1
pp_Tel_no1
pp_Address2
pp_zipcode2
pp_Tel_no2
pp_email
pp_cell_no
pp_cell_no2
pp_agency_employee_no
pp_religion
pp_birthplace_id
pp_Address1_id
pp_Address2_id
pp_Department_id
pp_SaveUser
pp_SaveDate
pp_ModifiedUser
pp_ModifiedDate
pp_NickName
pp_address1_st
pp_Profession
pp_Priority
APP_STATUS
applicant_InitialInterview
applicant_Exam
applicant_FinalInterview
applicant_DateApplied
applicant_remarks
POS_ID
POS_NAME
*
ref_pp_code
ref_name
ref_position
ref_address
ref_telno
ref_mobileno
ref_SysNum
*
skills_pp_code
skills_name
skills_recognition
skills_membership
skills_SysNum
*
SysPK_training
training_pp_code
training_training_name
training_dateFrom
training_dateTo
training_Hours
training_sponsors
*
SysPK_VWork
voluntary_ppcode
voluntary_dateFrom
voluntary_dateTo
voluntary_Hours
voluntary_Position
voluntary_Organization
*
SysPK_work_xp
wexp_pp_code
wexp_dateFrom
wexp_dateTo
wexp_Position
wexp_Agency
wexp_monthly_sal
wexp_salarygrade
wexp_status
wexp_govtservice
*
id
appdate
dept_id
issued
Chk
*
id
appdate
dept_id
empid
issued
chk
*
id
appdate
refno
agency_id
agency_name
purpose
other
period_from
period_to
office_id
office_name
employee_id
emp_name
position
supervisor_id
supervisor_name
HeadOffice_id
HeadOffice_name
1a_stat
1a_official_id
1b_stat
1b_official_id
1c_stat
1c_official_id
2a_stat
2a_official_id
2b_stat
2b_official_id
3a_stat
3a_official_id
3b_stat
3b_official_id
3c_stat
3c_official_id
4a_stat
4a_official_id
pending_stat
pending_clear
pending_official_id
verification
head_agency_id
status
TS
*
id
type
amount
*
id
refno
appdate
officeid
empid
position
emptype
salary
no_of_days
stat
TS
*
id
refno
appdate
deptid
deptname
empid
employee
empno
emp_type
gender
cvilstat
date_taken
result
remarks
pa_status
pa_remarks
stat
TS
dt_date
dt_place
dt_time
*
PK
formId
formName
deptid
empid
ara_type
agency_from
agency_to
trasfer_date
reason
effectivity_date
lwop_from
lwop_to
timestamp
status
date_modified
*
id
appdate
refno
deptid
empid
admin_charges
penalty
mode_separation
salary_rem
designation
placeofwork
volumeofwork
natureofwork
nature_remarks
reason
famissuerem
reason_remarks
explaination
respond_remarks
r_honest
r_wholesome
r_lacks_team
r_lacks_interest
r_hostile
r_intrigued
r_impersonal
r_apathetis
r_unapproachable
r_incompetent
r_others
r_othersremark
super_remarks
stat
timestamp
*
id
appdate
refno
empid
empname
empno
yrs
salary
date_increment
step1
step2
step3
status
TS
*
Pk
amount
effectivity
type
*
id
range_from
range_to
loyalty
type
*
id
main_id
particular_id
particular
remarks
1st_frequency
2nd_frequency
3rd_frequency
TS
freq
penalty_type
days_count
final_penalty
final_day_count
*
id
ref_no
appdate
deptid
deptname
emp_id
emp_name
emp_pos
emp_type
I_datetime
Iplace
status
TS
issued_date
issued_by
received_by
received_date
date_agreed
period
*
id
type_id
type
category_id
Particular
1stpenalty
2ndpenalty
3rdpenalty
stat
*
id
type
*
id
category
*
id
refno
appdate
parentid
parentname
p_remarks
p_pos
childid
childname
c_remarks
c_pos
status
TS
*
id
appdate
dept_id
issued
Chk
empid
*
id
emp_id
TS
attachment_path
*
id
Category
first_level_form_A
first_level_form_B
second_level_form_A
second_level_form_B
*
id
rate_id
Description
Points
*
id
type
age_from
age_to
*
id
deptid
empid
address
frm_name
frm_id
logs_type
timestamp
*
id
batch_id
ref_no
appdate
dept_id
emp_id
Category
oldGradeid
oldSalary
old_effictivity
newGradeId
amount
effictivity
status
TS
issued
*
id
batch_id
ref_no
appdate
dept_id
emp_id
type_id
Category
oldGradeid
oldSalary
old_effictivity
newGradeId
amount
pos_id
pod_id_new
effictivity
status
issued
type
days
nature_of_appoinment
TS
*
id
batch_id
ref_no
appdate
dept_id
emp_id
type_id
Category
oldGradeid
oldSalary
old_effictivity
newGradeId
amount
pos_id
pod_id_new
effictivity
status
issued
type
days
TS
*
id
section_name
*
id
refno
appdate
deptid
empid
position
emptype
stat
rated
*
id
particular
TS
*
id
client_id
centre_no
date
candid_no
candid_id
scheme_code
region_origin
country_nationality
first_language
*
employee_id
reason
remarks
date_effective
company_id
project_id
modifiedby
modifieddate
*
SysPK_CshAdv
SysFK_Empl_CshAdv
UserCode_CshAdv
Name_CshAdv
DateTrans_CshAdv
Amount_CshAdv
Balance_CshAdv
Terms_CshAdv
AmortAmount_CshAdv
Remarks_CshAdv
Description_CshAdv
CompanyCode
ProjectCode
Type
date_period
*
id
emp_number
incident_subject
incident_date
incident_time
incident_details
incident_classification
incident_frequency
incident_remarks
incident_noted
department_approved
incident_approved
noted_forAction
date_reported
memo_noted
offic_approved
status
am_in_note
am_out_note
pm_in_note
pm_out_note
*
id
EmpName
datex
office_Leave
int_depart
int_arrival
Within_office
Purpose
Reason
Actual_Depart
Actual_Arrival
Approved_by
status
*
id
first_IN
first_OUT
second_IN
Second_OUT
third_IN
third_OUT
fourth_IN
fourth_OUT
time_display
logcount
is_status
shift_type
*
id
it_particulars
emp_id
emp_name
it_remarks
it_status
it_trans_date
ts
*
position_code
dole_rate
rate_per_day
basic_salary
hononarium
*
position_id
position_code
position_description
*
Cutoff_15from
Cutoff_15to
Cutoff_30from
Cutoff_30to
LateAllowance
*
id
user
action
date_created
subject
voterid
leaderid
*
id
ip_address
login
time
*
ID
Modified
Status
EventID
DeptID
EMPID
PresentDate
EmployeeName
*
id
draft_iden
draft_reference
reference
request_date
hiring_date
date_needed
dept_id
department_name
pos_id
position_name
hiring_type
qty
purpose
status
UID
fname
lname
department
reporting_manager
position
ts
GUID
comments
*
id
mm_particulars
emp_id
emp_name
mm_remarks
mm_status
mm_trans_date
ts
*
id
prefix
test
*
id
prefix
name
barangay
*
loc_id
loc_branchid
title_id
loc_name
loc_status
date_save
*
ID
amount
OFFSET_GID
ENTRY_GID
*
id
emp_id
emp_name
requirement
remarks
complied
date_complied
record_status
ts
*
id
checklist_name
remarks
ts
status
*
id
position
emp_id
emp_name
head_id
_loc
*
id
originating_particular
emp_id
emp_name
originating_remarks
originating_status
originating_trans_date
ts
*
OD_ID
OD_Name
OD_PriorityNo
OD_Status
OD_DateSaved
Deduction_Type
OD_Category
OD_AccountId
OD_PayeeId
OD_PayeeName
OD_PayrollType
OD_Schedule
*
ODE_DtlsID
ODE_DeductionID
ODE_DeductionName
ODE_DeducionPriorityNo
ODE_DeductionAmt
*
ODE_Id
ODE_EmplNo
ODE_Company
ODE_Department
ODE_DateSaved
ODE_DateFrom
ODE_DateTo
ODE_DeductionId
ODE_DeductionName
ODE_DeductionAmount
ODE_DeductionPriorityNo
JID
STATUS
GROUPNAME
ODE_PayrollType
ODE_PaygroupID
*
OD_ID
OD_Name
OD_PriorityNo
OD_Status
OD_DateSaved
Deduction_Type
OD_AccountId
OD_PayeeId
*
id
emp_id
deduction_id
deduction_name
datefrom
dateto
actualdeduction_amount
deduction_amount
balance_amount
dept_id
paygroup_id
payroll_type
odb_status
*
allowance_entry_id
empId_allowance
empname_allowance
dept_allowance
id_allowance
name_allowance
amount_allowance
status_allowance
currency_allowance
payroll_from
payroll_to
company
branch
taxable
*
SysPK_OTHER
SysFK_Empl_OTHER
UserCode_OTHER
Name
DateTrans
Amount
Balance
Terms
AmortAmount
Remarks
Description
CompanyCode
ProjectCode
*
id
date_application
effectivity_date
ref_no
emp_id
emp_name
emp_dept
time_in
time_out
num_hours
purpose
status
date_saved
type
approved_by
date_approved
*
id
transNo
date
sysPK_Empl
description
amount
terms
amortization
balance
remarks
company_id
project_id
date_started
*
pagibig_details_id
transNo
date_from
date_to
sysPK_Empl
description
amount
terms
amortization
balance
remarks
company_id
project_id
date_started
status_pagibig_loan
pagibig_debreAmount
SysPK_PaySlip
id_pagibigloan
*
PAGIBIG_ID
Gross_From
Gross_To
Multiplier_Employee
Multiplier_Employer
status
date_save
*
itempakyaw_id
item_description
item_price
full_description
emp_id
client_code
type_rate
ts
item_status
*
paygroup_id
title_id
department_id
department_name
paygroup_accountcode
paygroup_name
paygroup_status
ts
emp_type1
head_sig
sub_dept_id
*
id
RestDay
OT_WorkingDay
OT_RestDay
LegalHoliday_WorkingDay
SpecialHoliday_WorkingDay
LegalHoliday_RestDay
SpecialHoliday_RestDay
OT_Legal_WorkingDay
OT_Special_WorkingDay
OT_Legal_RestDay
OT_Special_RestDay
Night_Differential
ts
user_id
*
PyrllDductHstory_Id
Pyroll_SysPK_id
Empl_num
Project_code
DateFrom
DateTo
sss
plhealth
pagibig
wtax
sssloan
pagibigloan
cashadv
agrivet
food
Gross
TotalDeduct
BalDeduction
NetPay
status_dduct
date_save
*
id
project_id
project_name
payrollmaker_id
payrollmaker_name
pm_status
group_pm
*
id
regular
overtime
night_diff
shop_rate
remarks
add_on
*
SysPK_PaySlip
Employee_Id
DateProcess_PaySlip
DateFrom_PaySlip
DateTo_PaySlip
DepartmentName_Payslip
Name_PaySlip
Position
Rate_perDay
Regular_DaysWork_PaySlip
Regular_DaysAmount_PaySlip
PERA_Amount
Gross_Amount
Wtax_Amount
MedicarePS_Amount
MedicareGS_Amount
GsisPS_Amount
GsisGS_Amount
HdmfPS_Amount
HdmfGS_Amount
StateInsurance_Amount
NetPay
Dept_Id
Company_Code
modified_user
date_saved
Payslip_Status
Payroll_Status
Payroll_Type
*
ID
EMP_ID
BASIC
DATE_FROM
DATE_TO
DEPARTMENT
DAYCOUNT
EMP_POSITION
NAME
OT
COLA
HOLIDAY
OTHERS
TOTAL_ERNINGS
LATE
ABSENT
C_A
COMPANYLOAN
PO
CASHBOND
COMPANY_OTHERS
TOTAL_COMPANY_DEDUCTION
GROSS
GOV_LOANS
SSS
PhilHealth
HDMF
TAX
TOTAL_GOV_DEDUCTION
NET_PAT
COMPANY
UNDERTIME
MEATSHOP
PRINTED
A_R
*
p_allowanceID
SysPK_PaySlip
p_allowance_datefrom
p_allowance_dateto
p_allowance_empID
p_allowance_nameID
p_allowance_name
p_allowance_amount
p_allowance_deptID
p_allowance_paygroupid
p_allowance_payrollType
p_allowance_companyID
p_allowance_status
*
p_allowanceID
SysPK_PaySlip
p_allowance_datefrom
p_allowance_dateto
p_allowance_empID
p_allowance_nameID
p_allowance_name
p_allowance_amount
p_allowance_deptID
p_allowance_paygroupid
p_allowance_payrollType
p_allowance_companyID
p_allowance_status
*
SysPK_PaySlip
SysFK_Empl_PaySlip
DateProcess_PaySlip
DateFrom_PaySlip
DateTo_PaySlip
Name_PaySlip
EmpID_No
Designation
BasicPay_PaySlip
RatePerDay_PaySlip
HourPay_Payslip
Hrs_work
Hrs_work_OT
reg_reg_hrs
reg_ot
reg_nightdiff
res_reg_hrs
res_ot
res_nightdiff
leg_reg_hrs
leg_ot
leg_nightdiff
spe_reg_hrs
spe_ot
spe_nightdiff
GrossPay_PaySlip
TotalDeducstions_PaySlip
NetPay_PaySlip
SSS_PaySlip
Pagibig_PaySlip
PhilHealth_PaySlip
philhealth_id
sss_loan
sss_id
pagibig_loan
pagibig_id
Tax_PaySlip
CashAdvance_PaySlip
department_code
group_code
emp_code
salary_type
Remarks_PaySlip
*
PaySlipDetls_ID
SysPK_PaySlip
datefrom
dateto
PaySlipDetls_EmpID
PaySlipDetls_PriorityNo
DeductionID
PaySlipDetls_DeductionName
PaySlipDetls_DeductionAmount
deptID
paygroupID
payroll_type
*
PaySlipDetls_ID
SysPK_PaySlip
datefrom
dateto
PaySlipDetls_EmpID
PaySlipDetls_PriorityNo
DeductionID
PaySlipDetls_DeductionName
PaySlipDetls_DeductionAmount
deptID
paygroupID
payroll_type
*
SysPK_PaySlip
SysFK_Empl_PaySlip
DateProcess_PaySlip
DateFrom_PaySlip
DateTo_PaySlip
Name_PaySlip
Rate_perDay
Regular_DaysWork_PaySlip
Regular_DaysAmount_PaySlip
Rest_DaysWork_Payslip
Rest_DaysAmount_Payslip
Legal_DaysWork_Payslip
Legal_DaysAmount_Payslip
Special_DaysWork_Payslip
Special_DaysAmount_Payslip
Regular_OTHrs_PaySlip
Regular_OTAmount_PaySlip
Restday_OTHrs_PaySlip
Restday_OTAmount_PaySlip
Legalday_OTHrs_PaySlip
Legalday_OTAmount_PaySlip
Specialday_OTHrs_PaySlip
Specialday_OTAmount_PaySlip
NightDifferentialHrs_Payslip
NightDifferentialAmount_Payslip
Adjustment_Payslip
Incentives_Payslip
RiceAllowance_PaySlip
Others_Payslip
Gross_Payslip
SSS_Payslip
PagIbig_Payslip
Philhealth_Payslip
Wtax_Payslip
CashAdvance_Payslip
Uniform_Payslip
OBmeals_Payslip
SSSLoan_Payslip
PagIbigLoan_Payslip
OtherDeduction_Payslip
TotalDeduction_Payslip
NetPay_Payslip
department_code
group_code
designation
emp_code
salary_type
modified_user
date_saved
*
payslip_id
dtr_date
AM_IN
AM_OUT
PM_IN
PM_OUT
HRS_WORK
LATE
UNDERTIME
OVERTIME
employee_number
remarks
SysPK_PaySlip
*
SysPK_PaySlip
Employee_Id
DateProcess_PaySlip
DateFrom_PaySlip
DateTo_PaySlip
DepartmentName_Payslip
Name_PaySlip
Position
day1_Payslip
day2_Payslip
day3_Payslip
day4_Payslip
day5_Payslip
day6_Payslip
day7_Payslip
day8_Payslip
day9_Payslip
day10_Payslip
day11_Payslip
day12_Payslip
day13_Payslip
day14_Payslip
day15_Payslip
day16_Payslip
Rate_perDay
Regular_DaysWork_PaySlip
Regular_DaysAmount_PaySlip
Holiday_DaysWork_Payslip
Holiday_DaysAmount_Payslip
Regular_OTHrs_PaySlip
Regular_OTAmount_PaySlip
NightDifferentialHrs_Payslip
NightDifferentialAmount_Payslip
Gross_Amount
SSS_Amount
PHIC_Amount
HDMF_Amount
WTax_Amount
Late_Hrs
Late_Amount
UT_Hrs
UT_Amount
NetPay
Dept_Id
Paygroup_Id
Company_Code
modified_user
date_saved
Payslip_Status
Payroll_Status
Payroll_Type
*
id
SysPK_PaySlip
datefrom
dateto
employee_id
paygroup_id
holiday_days
holiday_rate
holiday_amount
day1
day2
day3
day4
day5
day6
day7
day8
day9
day10
day11
day12
day13
day14
day15
day16
pjh_status
*
id
SysPK_PaySlip
datefrom
dateto
employee_id
paygroup_id
overtime_hours
overtime_rate
overtime_amount
day1
day2
day3
day4
day5
day6
day7
day8
day9
day10
day11
day12
day13
day14
day15
day16
pjh_status
*
pagibig_id
amortization
sysPK_Empl
sysPK_Payslip
*
pakyaw_id
comp_code
client_code
post_id
empl_id
empl_name
date_from
date_to
GROSSPAY
LateUT_HRS
LateUT_AMT
SSS
PHIC
HDMF
uniform
insurance
iou
other_dductions
total_dductions
NETPAY
rgular_daysWRK
rgular_daysAMT
rest_daysWRK
rest_daysAMT
lgal_daysWRk
lgal_daysAMT
spcl_daysWRK
spcl_daysAMT
nyt_diffHRS
nyt_diffAMT
pakyaw_code
modified_user
status
date_process
date_saved
Rate
lgal_daysOT
lgal_daysOTAMT
spcl_daysOT
spcl_daysOTAMT
section
*
pakyaw_detail_id
pakyaw_code
empl_id
days_WRk
output
item_discription
price_pack
amount
client_code
status
ts
datefrom
dateto
*
pertrip_Id
pertrip_EmpId
pertrip_Empname
pertrip_datefrom
pertrip_dateto
pertrip_amount
pertrip_retention
pertrip_deptcode
pertrip_companycode
dateSaved
*
sss_id
amortization
sysPK_Empl
sysPK_Payslip
*
philhealth_id
year_id
Salary_Bracket
Salary_Range_from
Salary_Range_To
Salary_Base
Total_MonthlyPremium
Employee_Share
Employer_Share
status
date_save
*
SysPK_PO
SysFK_Empl_PO
UserCode_PO
Name
DateTrans
Amount
Balance
Terms
AmortAmount
Remarks
Description
CompanyCode
ProjectCode
*
id
name
barangay
type
status
date_created
*
id
sysPK_Empl
Datefrom
Dateto
BasicAmount
company_id
project_id
DateAdded
*
id
type
*
id
SysPK_Dept
GroupName_Dept
DeptCode_Dept
Name_Dept
Head_Dept
Location_Dept
Position_Dept
Type_Dept
Status_Dept
Remarks_Dept
Message_Dept
AssistantHead_Dept
AssistPosition_Dept
WorkerType_Dept
ProjectStart
ProjectEnd
sss_rate
dole_rate
status
minimum_wage
contract_price
project_cost
project_id
projecthead_id
projectAhead_id
service_charge
*
projectID
projectNo
project
projectname
projectlocation
*
title_id
title_name
title_desc1
title_desc2
title_logo1
title_logo2
stats
logo_img
Photo
lguname
headername
*
id
DEPARTMENT
NAME
TYPE
grouping
NUMBER
prizes
status
generated_number
*
id
DEPARTMENT
NAME
TYPE
NUMBER
prizes
status
*
id
department_name
grouping
*
id
price_name
winner_count
typez
*
id
raffle_name_id
price_id
*
id
emp_id
department
prpred_by
Flag_date
presentx
status
*
id
category
catgry_resp
status
*
ID
NAME
*
id
requirement_name
status
ts
default
default_remarks
*
ID
Description
Color
*
id
branch
dept
emp_id
cut_off_from
cut_off_to
restday_dayname
restday_date
approve_status
approved_by_id
ts_modified
data_status
restday_original
restday_original_name
*
id
emp_id
emp_name
restday_dayname
restday_dayname2
date_start
ts_modified
restday_date
approve_status
company
branch
dept
cut_off_from
cut_off_to
approved_by_id
data_status
restday_original
restday_original_name
*
id
RFCS_ID
emp_id
emp_name
date_from
date_to
time_in
time_out
purpose
initiator
ts
approve_status
record_status
GUID
*
id
RFCS_ID
RFCS_MAIN_ID
emp_id
emp_name
dtr_date
time_in
time_out
*
id
DRAFT_NUM
REQREF
UID
FNAME
LNAME
TS
GUID
DEPT
REPORTING_MANAGER
*
year_id
sal_grade
step1
step2
step3
step4
step5
step6
step7
step8
*
ID
ip
port
device_name
status
commkey
*
id
privilege
*
id
fnctn_type
description
status
*
id
fnctngroup_id
MFO_dscrptn
status
*
project_id
project
project_name
project_location
date_saved
title_id
project_no
project_agency
project_amount
project_duration
project_effectivity
project_expiry
status
*
id
MFO_id
description
status
*
id
MFO_id
description
status
*
id
MFO_id
description
status
*
id
MFO_id
description
status
*
id
mfo_id
descrption
status
*
id
company_type
branches
status
project_type
*
F1
*
F1
*
id
shop_rate
remarks
*
log_id
form_id
form_name
bns_id
pp_id
user_id
head_id
head_name
head_position
mayor_id
mayor_name
mayor_position
brgy_cap_id
brgy_cap_name
brgy_cap_pos
Chief_of_pol_id
Chief_of_pol_name
Chief_of_pol_pos
date_save
date_update
timestamp
*
id
department
designation
emp_id
emp_name
date_created
Status
branch
approval_emp_id
approval_emp_name
*
id
skill_name
max_level
status
ts
*
id
site_name
host_site
username
password
*
sms_id
cellphone_no
msg
date_created
*
special_id
description
special_date
regular_percentage
restday_percentage
overtime_percentage
*
sss_gsis
*
id
transNo
date
sysPK_Empl
description
amount
terms
amortization
balance
remarks
company_id
project_id
date_started
deduction_effectivity
*
sss_details_id
transNo
date_from
date_to
sysPK_Empl
description
amount
terms
amortization
balance
remarks
company_id
project_id
date_started
deduction_effectivity
status_sss_loan
sss_debreAmount
SysPK_PaySlip
id_sssloan
*
sss_id
range_from
range_to
monthly_salary
EC
ER
EE
Total
*
SysPK_Subject
Subject_Code
Subject_Name
Subject_Unit
*
id
mainID
description1
kind
exactLoc
assessedValue
CurrentFair
AcquisitionYear
AcquisitionMode
AcquisitionCost
Description2
YearAcquired
AcquisitionCostamount
status
*
id
mainID
Description2
YearAcquired
AcquisitionCostamount
status
*
id
mainID
BusinessBox
NameEntity
BusinessAddress
NatureBusiness
DateAcqInt
status
*
id
mainID
nature
NameCreditor
Ounstandingbalance
status
*
id
mainID
relativeBox
NameRelative
Relationship
Position1
NameAgency
status
*
sig_id
mainID
Dec_govID
CoDec_govID
Dec_IDno
CoDec_IDno
Dec_dateIssue
CoDec_dateIssue
SubSworn_date
*
id
emp_id
dateAsOf
jointFiling
Sfiling
NApplicable
BusinessBox
relativeBox
Fname
Firstname
MName
address
position
AOffice
OAddress
spouse
Sposition
SAOffice
SOAddress
status
spouse_lname
spouse_mname
spouse_fname
*
id
mainID
Fullname
birthdate
age
status
*
ID
APPID
Status
Task
*
id
emp_id
ar_record
ar_date
*
id
type
count
*
id
ref_no
trans_date
emp_id
effectivity_date
adjustment_type
amount
remarks
status
timstamp
payroll_mainID
payroll_genID
*
id
rangefrom
rangeto
*
ID
ALLOWANCE_NAME
cas_prot_days
cas_deduction_day
acct_id
acct_desc
STATUS
*
id
pre_eval_id
level_position
emp_id
dept_id
position
date
edu_minreq_2
edu_coldeg2_9
edu_39units
edu_1018units
edu_1927units
edu_2836units
edu_masterdegree
edu_1315units
edu_1630units
edu_3145units
edu_46aboveunits
edu_doctoral
train_minreq
train_816hrs
train_1732hrs
train_33abovehrs
exp_minreq
exp_12yrs
exp_34yrs
exp_5yrsabove
Examination
status
date_save
*
id
main_id
formed_used
1_
2_
3_
4_
total
interviewer
total_average
*
id
pre_eval_id
level_position
emp_id
dept_id
position
date
edu_minreq_2
edu_coldeg2_9
edu_39units
edu_1018units
edu_1927units
edu_2836units
edu_masterdegree
edu_1315units
edu_1630units
edu_3145units
edu_46aboveunits
edu_doctoral
train_minreq
train_816hrs
train_1732hrs
train_33abovehrs
exp_minreq
exp_12yrs
exp_34yrs
exp_5yrsabove
Examination
status
date_save
*
id
main_id
formed_used
1_
2_
3_
4_
total
interviewer
total_average
*
id
pre_eval_id
level_position
emp_id
dept_id
position
date
edu_minreq_2
edu_coldeg2_9
edu_39units
edu_1018units
edu_1927units
edu_2836units
edu_masterdegree
edu_1315units
edu_1630units
edu_3145units
edu_46aboveunits
edu_doctoral
train_minreq
train_816hrs
train_1732hrs
train_33abovehrs
exp_minreq
exp_12yrs
exp_34yrs
exp_5yrsabove
Examination
status
date_save
*
id
main_id
formed_used
1_
2_
3_
4_
total
interviewer
total_average
*
id
pre_eval_id
level_position
emp_id
dept_id
position
date
edu_minreq_2
edu_coldeg2_9
edu_39units
edu_1018units
edu_1927units
edu_2836units
edu_masterdegree
edu_1315units
edu_1630units
edu_3145units
edu_46aboveunits
edu_doctoral
train_minreq
train_816hrs
train_1732hrs
train_33abovehrs
exp_minreq
exp_12yrs
exp_34yrs
exp_5yrsabove
point_score1
point_score2
adj_rating1
adj_rating2
out_accomp1_2
out_accomp3_4
out_accomp5_6
out_accomp7_8
out_accomp9_more
Examination
status
date_save
*
id
main_id
formed_used
1_
2_
3_
4_
total
interviewer
total_average
*
id
form
data_id
path
user_id
timestamp
description
*
id
module
form_id
form_name
function
user_id
user_name
trans_date
save_date
*
bill_ref
*
id
description
*
id
transaction_no
transaction_date
aggrieved_party
date_filed
committed_on
finalaction_taken
grievance_chairman
date_acted
ts
status
*
id
area
desc
*
id
ref_no
recruitment_id
Applicant_name
gender
eligibility
residence
course
edu_rawscore
edu_30
workexp_rawscore
workexp_20
training_rawscore
training_20
personality_rawscore
personality_20
exam_rawscore
exam_10
trans_date
main_eligibility
main_education
main_training
main_experience
chairman
hrmo
al_rep
dept_head
status
save_date
rating_table
*
id
transaction_no
trasaction_date
incident_subject
date_incident
place_incident
person_involved
position_involved
office_involved
narration_of_complaint
full_name
address_complete
contact_numbers
citizenship
civilstatus
ts
status
withcase
issued_by
issued_date
received_by
received_date
date_agreed
case_status
*
id
code
desc
regular_formula1
regular_formula2
resday_formula1
resday_formula2
regular_double_formula1
regular_double_formula2
restday_double_formula1
restday_double_formula2
*
id
code
desc
regular_days
rest_days
*
id
code
desc
regular_days
rest_days
*
id
ref_no
dept_id
applicant_id
trans_date
correction_type
from
to
status
datesave
*
id
main_id
correction_type
from
to
*
id
count
*
id
ref_id
ref_type
date_from
date_to
time_start
time_end
no_days
remarks
*
id
leave_id
days_count_filling
credits
icon
color
_cat
employment_year
Description
Eligibility
*
id
desc
*
id
cto_id
date_cto
cto_from
cto_to
app_cto_from
app_cto_to
cto_charge
memo
status
app_hrs
*
cto_id
cto_application_no
cto_application_date
emp_id
remarks
approved_by
approved_date
comment
status
position_id
position_name
*
id
emp_id
accumulated
used
balance
*
dtl_id
emp_id
ref_id
type
accumulated
used
balance
date
status
tmstamp
used_remarks
entry_type
main_idx
grp
*
id
_date_save
*
id
day_name
*
id
day
equiv
*
id
ref_no
trans_date
emp_id
deduction_id
amort_type
amort_startDate
amort_endDate
amort_terms
principal
interest
total_amount
amortization
remarks
status
timstamp
pay_type
*
dtl_id
deduc_id
amortization
semi_monthly
type
charge
date_amortized
payroll_id
status
prev_id
*
id
cv_number
employee_name
deduction_name
amount
terms
amortization
balance
terms_paid
*
doc_id
document_name
document_location
dept_id
date_attached
*
id
place
stat
*
id
emp_id
shift_id
date
first_in
first_out
first_late
first_undertime
first_notes
second_in
second_out
second_late
second_undertime
second_notes
ot_in
ot_out
late
undertime
overtime
diferential
cto
no_of_hrs
holiday
is_rest_day
direct_overtime
status
trans_id
type
lock_status
modified_by
modified_date
tmstamp
rate_per_day
pos_id
*
ir_id
ref_no
ref_date
subject
rep_by
rep_date
date_incident
time_incident
dtl_incident
w_pres_period
l_pres_period
remarks
dept_app_by
dept_app_dateTime
dept_app_status
dept_not_by
dept_not_dateTime
noted_action
mayor_autho_by
mayor_app_by
mayor_app_status
status
timstamp
form_id
date_approved
approval_comment
validatedby
date_validated
action_id
action_datetime
action_status
am_in_note
am_out_note
pm_in_note
pm_out_note
hr_notes
deduction_id
entry_type
*
id
description
mins_deducted
*
id
emp_id
shift_id
date
first_in
first_out
first_late
first_undertime
first_notes
second_in
second_out
second_late
second_undertime
second_notes
ot_in
ot_out
late
undertime
overtime
diferential
cto
no_of_hrs
holiday
is_rest_day
direct_overtime
status
trans_id
type
lock_status
modified_by
modified_date
tmstamp
rate_per_day
pos_id
*
id
emp_id
shift_id
date
first_in
first_out
first_late
first_undertime
firstin_notes
first_notes
second_in
second_out
second_late
second_undertime
secondin_notes
second_notes
third_in
third_out
third_late
third_undertime
thirdin_notes
third_notes
fourth_in
fourth_out
fourth_late
fourth_undertime
fourthin_notes
fourth_notes
ot_in
ot_out
late
undertime
ot_dtl_id
ot_breakhrs
ot_earnedhrs
overtime
diferential
cto
no_of_hrs
holiday
is_rest_day
direct_overtime
status
trans_id
type
lock_status
modified_by
modified_date
tmstamp
rate_per_day
pos_id
paygroup_id
manual_ut
manual_late
isIL
*
id
emp_id
shift_id
date
first_in
first_out
first_late
first_undertime
first_notes
second_in
second_out
second_late
second_undertime
second_notes
third_in
third_out
third_late
third_undertime
third_notes
fourth_in
fourth_out
fourth_late
fourth_undertime
fourth_notes
ot_in
ot_out
late
undertime
overtime
diferential
cto
no_of_hrs
holiday
is_rest_day
direct_overtime
status
trans_id
type
lock_status
modified_by
modified_date
tmstamp
rate_per_day
pos_id
paygroup_id
*
id
emp_id
shift_id
date
first_in
first_out
first_late
first_undertime
firstin_notes
first_notes
second_in
second_out
second_late
second_undertime
secondin_notes
second_notes
third_in
third_out
third_late
third_undertime
thirdin_notes
third_notes
fourth_in
fourth_out
fourth_late
fourth_undertime
fourthin_notes
fourth_notes
ot_in
ot_out
late
undertime
overtime
diferential
cto
no_of_hrs
holiday
is_rest_day
direct_overtime
status
trans_id
type
lock_status
modified_by
modified_date
tmstamp
rate_per_day
pos_id
paygroup_id
*
id
emp_id
shift_id
date
first_in
first_out
first_late
first_undertime
first_notes
second_in
second_out
second_late
second_undertime
second_notes
third_in
third_out
third_late
third_undertime
third_notes
fourth_in
fourth_out
fourth_late
fourth_undertime
fourth_notes
ot_in
ot_out
late
undertime
overtime
diferential
cto
no_of_hrs
holiday
is_rest_day
direct_overtime
status
trans_id
type
lock_status
modified_by
modified_date
tmstamp
rate_per_day
pos_id
paygroup_id
*
id
emp_id
dte
lock_stat
*
SysPK_emp_attendance
attendance_id
newempId
employee_number
employee_fullName
dtr_date
in_am
out_am
am_note
in_pm
out_pm
pm_note
late
undertime
total_hours_worked
status
att_remarks
note_am_in
note_am_out
note_pm_in
note_pm_out
OB_notes
modify_user
latecount
UTcount
*
SysPK_emp_attendance
attendance_id
newempID
employee_number
employee_fullName
dtr_date
in_am
out_am
am_note
in_pm
out_pm
pm_note
late
undertime
total_hours_worked
status
att_remarks
note_am_in
note_am_out
note_pm_in
note_pm_out
OB_notes
modify_user
*
id
emp_id
shift_id
date
first_in
first_out
first_notes
second_in
second_out
second_notes
ot_in
ot_out
trans_id
type
tmstamp
rate_per_day
pos_id
*
id
emp_id
shift_id
date
first_in
first_out
first_notes
second_in
second_out
second_notes
ot_in
ot_out
trans_id
type
tmstamp
rate_per_day
pos_id
*
id
emp_id
shift_id
date
first_in
first_out
first_notes
second_in
second_out
second_notes
ot_in
ot_out
trans_id
type
tmstamp
rate_per_day
pos_id
*
id
emp_id
shift_id
date
first_in
first_out
firstin_notes
first_notes
second_in
second_out
secondin_notes
second_notes
third_in
third_out
third_notes
fourth_in
fourth_out
fourth_notes
ot_in
ot_out
trans_id
type
tmstamp
rate_per_day
pos_id
paygroup_id
lock_status
*
id
emp_id
off_BhouseNo
off_Building
off_Street
off_Village
off_Bargy
off_City_Mun
off_Prov
off_faxNum
off_telNum
res_telnum
off_religion
off_partyAff
off_ChkNM
off_ChkR_E
off_ChkReturn
off_specify
ChkSuccess
ChkElection
date_assmp
date_accmp
DILG
elec_region
elec_province
elec_prov_Dis
elec_City_Mun
elec_City_Loc
elec_votes
*
subject
body
*
id
emp_id
date_from
date_to
position_title
designation
reference_no
dated
capacity
office_Unit
immediate_supervisor
item_no
*
id
emp_id
shift_id
date
first_in
first_out
firstin_notes
first_notes
second_in
second_out
secondin_notes
second_notes
third_in
third_out
thirdin_notes
third_notes
fourth_in
fourth_out
fourthin_notes
fourth_notes
ot_in
ot_out
undertime_passlip
trans_id
type
rate_per_day
pos_id
paygroup_id
tmstamp
pundertime
plate
passslip_type
disregard
stat
*
id
emp_id
shift_id
date
first_in
first_out
firstin_notes
first_notes
second_in
second_out
secondin_notes
second_notes
third_in
third_out
thirdin_notes
third_notes
fourth_in
fourth_out
fourthin_notes
fourth_notes
ot_in
ot_out
undertime_passlip
trans_id
type
rate_per_day
pos_id
paygroup_id
tmstamp
pundertime
passslip_type
stat
*
id
emp_id
shift_id
date
first_in
first_out
firstin_notes
first_notes
second_in
second_out
secondin_notes
second_notes
third_in
third_out
thirdin_notes
third_notes
fourth_in
fourth_out
fourthin_notes
fourth_notes
ot_in
ot_out
undertime_passlip
trans_id
type
rate_per_day
pos_id
paygroup_id
tmstamp
pundertime
passslip_type
stat
*
ID
poscode
posname
payrollcode
emp_id
dayswork
dailyrate
othrs
otratehrs
tstamp
ACCOUNTCODE
ACCOUNTID
TOTAL
isMonthly
date_from
date_to
*
id
emp_id
restday
*
id
seq_no
syspk_no
emp_ID
emp_name
dept_id
emptype_id
*
id
emp_id
employee
emp_status
position_title
date_of_birth
present_office
acc_no
acc_date
office_address
inc_from
inc_to
name_of_office
basic_salary
leave_without_pay
cause
sep_date
sal_grade_id
position_id
*
ID
EventName
Remarks
Status
UID
Ts
*
ID
EventID
OfficeID
OfficeName
*
id
description
*
id
field
*
id
vacant_id
ref_no
shortlisted_id
trans_date
recruitment_id
status
qualified
*
ID
GUID
OfficeID
OfficeName
EmployeeID
EmployeeName
R1
R2
R3
R4
R5
R6
RT1
RT2
RT3
RT4
RT5
RT6
PreparedName
CertifiedName
Mnt
YR
EncoderUID
TS
*
PERA_Allowed_Days
mig_conn
*
gen_id
generation
ParentGen_id
year_from
year_to
*
id
ref_no
app_date
yr
group_id
payroll_type
status
ts
*
id
grat_id
emp_id
gratuity
no_months
total
*
id
transaction_no
transaction_date
date_file
nameof_aggrieved
positionof_aggrived
departmentof_aggrieved
supervisorof_aggrieved
nature_subjectof_grievance
action_desired
ts
status
issued_by
issued_date
received_by
received_date
date_agreed
*
id
transaction_no
transaction_date
griev_id
nameofparties
natureof_grievance
stepstoward_settlement
agreement_reached
chairman_grievance
ts
status
date_filed
*
id
employe_share
employer_share
effectivity_date
*
id
hrs
equiv
*
id
group_name
savedate
status
*
id
main_id
profile_id
profile_name
group_id
group_name
core_function
success_indicator
actual_accomplishment
q
e
t
remarks
status
savedate
*
id
emp_id
emp_name
dept_id
dept_name
pos_id
pos_name
profile_id
profile_name
period_from
period_to
savedate
status
*
id
min_
max_
numerical
adjectival
Remarks
*
id
profile
savedate
status
*
id
profile_id
profile_name
group_id
group_name
mfo
succs_ind_time
savedate
status
*
id
group_name
savedate
status
*
id
main_id
profile_id
profile_name
group_id
group_name
core_function
success_indicator
actual_accomplishment
q
e
t
remarks
status
savedate
*
id
emp_id
emp_name
dept_id
dept_name
pos_id
pos_name
profile_id
profile_name
period_from
period_to
savedate
status
*
id
profile
savedate
status
*
id
profile_id
profile_name
group_id
group_name
mfo
succs_ind_time
savedate
status
*
id
transaction_no
transaction_date
date_reported
incident_subject
placeof_incident
dateandtimeof_incident
detailsof_incident
remedial_actions
corrective_actions
reportedby_name
notedby_name
receivedby_name
ts
status
issued_by
date_issued
received_by
date_received
date_agreed
*
id
empl_id
employee
dept_id
department
Position
pos_id
Salary_grade
trans_date
years_in_LGU
years_in_the_position
Supervisor_name
Sup_id
years_required
training_course
training_course_id
attend
ref_no
status_
type_
acomp_date
accomp_remarks
remarks
division
division_id
ts
*
id
main_id
development_target
performance_goals
objectives
*
id
mainid
development_activity
support_needed
planned
accomp_midyear
accomp_yearend
*
id
date_filed
control_num
branch_code
dept_code
emp_code
emp_name
from_date
to_date
purpose
base_time_left
base_time_arrived
destination_time_left
destination_time_arrived
status
time_saved
base_branch
destination_branch
traspodetails
transpo_allowance
mealallowancedetails
meal_allowance
checkedby
approvedby
*
leave_id
ref_no
asOfDate
sl_bal
vl_bal
applied_date
approved_date
approved_by
by_authority_id
employee_id
contact_person
contact_no
purpose
supervisor_comment
status
tmstamp
dept_id
position_id
commutation
incaseVLPhilCheck
incaseVLPhilText
incaseVLAbroadCheck
incaseVLAbroadText
incaseSLHospitalCheck
incaseSLHospitalText
incaseSLOutPatientCheck
incaseSLOutPatientText
incaseSpecialLeaveWomenText
incaseStudyMastersDegreeCheck
incaseStudyBARBoardCheck
MonetizationLeaveCheck
TerminalLeaveCheck
LeaveRemarks
recommended_by
recommended_date
certify_by
certify_date
wherespent
declined_remarks
declined_remarks_approval
isWebApp
dateSelected
isposted
*
id
leave_id
leave_type_id
leave_date
leave_dateto
leave_for
hrs_leave
payment_mode
deductLeave
status
status_rec
status_cert
status_approved
leave_others
*
ID
NAME
COUNT
*
id
type
emp_id
acumulated
used
trans_date
date_from
date_to
save_date
*
id
desc
*
id
description
code
*
id
Level_Pos
Position_desc
*
id
dept_id
description
log_status
date_saved
*
id
app_date
dept_id
old_dept_id
position_title
position_id
old_pos_id
manpower_needs
no_employees
no_emp_approved
hiring_condition
target_date
for_reassignment
employee_ID
reassignment
date_transfer
job_desc
remarks_reason
prepared_by
approved_by
checked_by
hr_division
cleared_by
confirm_by
status
date_save
pos_level
*
id
min
equiv
*
id
consequence
status
*
id
txt_month
qrter
sample_date
*
ID
EMP_ID
DEPARTMENT_ID
DEPARTMENT_NAME
POSITION_ID
POSITION_NAME
RATE
ACCOUNTCODE
ACCOUNTNAME
ACCOUNTID
*
id
recruitment_id
manpower_id
ref_no
trans_date
applicant_id
applicant_name
position_id
position_name
dept_id
dept_name
count
d_pos_id
d_pos_name
d_dept_id
d_dept_name
d_count
gender
address
newwork_assignment
prev_sup
new_sup
effective_date
job_desc
remarks
approved_by
confirmed_by
status
date_save
*
ob_id
travel_id
type
empName
emp_id
trvl_from
ob_no
ob_date
ob_type
ob_purpose
ob_remarks
ob_comments
ob_agency
ob_address
ob_tel_no
ob_recommended_date
ob_recom_by
ob_approved_date
ob_approved_by
status
timstamp
attended_by
*
id
ob_id
dtr_date
type
ob_off_timedept
ob_off_timearr
ob_off_verdept
ob_off_ver_arr
ob_dest_timedept
ob_dest_timearr
ob_dest_ver_dept
ob_dest_ver_arr
ob_remarks
am_in_note
am_out_note
pm_in_note
pm_out_note
timstamp
*
id
descriprion
*
overtime_id
ov_application_no
project_name
purpose
office
office_id
emp_id
remarks
comment
status
position_id
position_name
req_by
ov_application_date
recom_by
recom_date
recom_status
budgetCntrl_by
budgetCntrl_date
budgetCntrl_status
as_app
as_app_date
as_app_status
as_fund
as_fund_date
as_fund_status
approved_by
approved_date
mayor_app_status
mayor_autho_by
cert_id
cert_date
save_date
*
id
category
*
id
ref_no
ref_date
office_id
office_name
project_name
remarks
req_by
recom_by
as_app
as_fund
app_by
status
savedate
*
id
cert_id
emp_id
responsibilty
date
overtime_from
overtime_to
app_hrs
excempt
entry_type
memo
status
*
overtime_id
ov_application_no
project_name
purpose
office
office_id
emp_id
remarks
comment
status
position_id
position_name
req_by
ov_application_date
recom_by
recom_date
recom_status
as_app
as_app_date
as_app_status
as_fund
as_fund_date
as_fund_status
approved_by
approved_date
mayor_app_status
mayor_autho_by
cert_id
cert_date
save_date
*
id
emp_id
overtime_id
date_overtime
overtime_from
overtime_to
app_ot_from
app_ot_to
rate_per_hr
overtime_charge
memo
remarks
status
app_hrs
entry_type
excempt
auto_compute
is_wholed_day
date_issued
date_valid
cert_id
cert_date
*
id
emp_id
overtime_id
date_overtime
overtime_from
overtime_to
app_ot_from
app_ot_to
overtime_charge
memo
remarks
status
app_hrs
entry_type
excempt
auto_compute
is_wholed_day
date_issued
date_valid
cert_id
cert_date
*
id
overtime_id
memoto
memodate
Subject
*
id
category_id
category_name
category_description
rate
*
id
group_name
emp_id
effectivity
save_date
*
id
main_id
emp_name
position
department
employee_type
rate_basis
salary_from
salary_to
yes
*
id
ref_no
ref_date
department
employee_type
date_from
date_to
transdate
status
trans_status
effectivity_date
*
id
project_id
project_name
payrollmaker_id
payrollmaker_name
pm_status
group_pm
position_id
position_name
*
id
gen_id
emp_id
adj_id
amount
*
id
gen_id
emp_id
allowance_id
amount
*
id
gen_id
emp_id
dtl_id
deduction_id
amount
*
id
gen_id
emp_id
premium_id
amount
ref_master
amount_gs
*
id
main_id
payroll_master
emp_id
no_of_days
basic_pay
reg_pay
daily_rate
hourly_rate
ot_hrs
ot
rd_ot_hrs
rd_ot
differential_hrs
differential
holiday_days
holiday
late_hrs
late
undertime_hrs
undertime
absent_il_hrs
absent_il
lwop_days
lwop_amount
gross_pay
total_allowance
total_deductions
adjustment
adjustment_neg
net_pay
*
id
emp_id
gen_id
Absent
Absent_Amount
Late
Late_Amount
Undertime
Undertime_Amount
Reg_Day_Comp
Reg_Day_Comp_Amount
Reg_SH_Comp
Reg_SH_Comp_Amount
Reg_LH_Comp
Reg_LH_Comp_Amount
Rest_Day_Comp
Rest_Day_Comp_Amount
Rest_SH_Comp
Rest_SH_Comp_Amount
Rest_LH_Comp
Rest_LH_Comp_Amount
Reg_Day_Overtime
Reg_Day_Overtime_Amount
Reg_SH_Overtime
Reg_SH_Overtime_Amount
Reg_LH_Overtime
Reg_LH_Overtime_Amount
Rest_Day_Overtime
Rest_Day_Overtime_Amount
Rest_SH_Overtime
Rest_SH_Overtime_Amount
Rest_LH_Overtime
Rest_LH_Overtime_Amount
Reg_Day_Night_Diff
Reg_Day_Night_Diff_Amount
Reg_SH_Night_Diff
Reg_SH_Night_Diff_Amount
Reg_LH_Night_Diff
Reg_LH_Night_Diff_Amount
Rest_Day_Night_Diff
Rest_Day_Night_Diff_Amount
Rest_SH_Night_Diff
Rest_SH_Night_Diff_Amount
Rest_LH_Night_Diff
Rest_LH_Night_Diff_Amount
*
id
ref_no
trans_date
payroll_from
payroll_to
payroll_generation
covered
patroll_month
memo
generated_by
status
timstamp
pay_type
dept_idx
jo_no
*
id
ref_no
trans_date
payroll_from
payroll_to
payroll_generation
covered
patroll_month
memo
generated_by
status
timstamp
pay_type
dept_idx
jo_no
*
id
gen_id
emp_id
dtl_id
deduction_id
amount
*
id
_DATE
first1
first2
second1
second2
status
*
id
penalty_type
remarks
pt_status
*
personnel_id
dept_id
dept_name
program
project_activity
calendar_year
*
personnel_id
item_old
item_new
position_title
incumbent_name
currentyear_sgstep
currentyear_amount
budgetyear_sgstep
budgetyear_amount
increasedecrease
*
id
range_from
range_to
type
fixed
percentage
status
*
ID
EMP_ID
Photo
*
id
No1
No2
Department
Position
Emp_Name
SGStep1
amount
SGStep2
amount2
increase_decrease
current_year
budget_year
date_save
status
*
id
item_no
d_dept_id
d_position_id
d_count
a_dept_id
a_position_id
a_count
sal_grade_id
authorized_sal
actual_sal
step
code
type
level
syspk_emp
lastname
firstname
middlename
date_birth
edu_attain
eligibility
date_orig_appoint
date_last_promotion
status
pe_from
pe_to
remarks
date_save
*
id
item_no
d_dept_id
d_position_id
d_count
a_dept_id
a_position_id
a_count
sal_grade_id
authorized_sal
actual_sal
step
code
type
level
syspk_emp
lastname
firstname
middlename
date_birth
edu_attain
eligibility
date_orig_appoint
date_last_promotion
status
pe_from
pe_to
remarks
priority_no1
group_cat
date_save
priority_no
category
sec_id
step_ar
sal_grade_id_ar
budgt_sal_id
budgt_sal_amount
*
id
item_no
d_dept_id
d_position_id
d_count
a_dept_id
a_position_id
a_count
sal_grade_id
authorized_sal
actual_sal
step
code
type
level
syspk_emp
lastname
firstname
middlename
date_birth
edu_attain
eligibility
date_orig_appoint
date_last_promotion
status
pe_from
pe_to
priority_no
group_cat
remarks
date_save
*
id
item_no
d_dept_id
d_position_id
d_count
a_dept_id
a_position_id
a_count
sal_grade_id
authorized_sal
actual_sal
step
code
type
level
syspk_emp
lastname
firstname
middlename
date_birth
edu_attain
eligibility
date_orig_appoint
date_last_promotion
status
pe_from
pe_to
priority_no
group_cat
remarks
date_save
*
id
item_no
d_dept_id
d_position_id
d_count
a_dept_id
a_position_id
a_count
sal_grade_id
authorized_sal
actual_sal
step
code
type
level
syspk_emp
lastname
firstname
middlename
date_birth
edu_attain
eligibility
date_orig_appoint
date_last_promotion
status
pe_from
pe_to
remarks
date_save
priority_no
*
id
item_no
d_dept_id
d_position_id
d_count
a_dept_id
a_position_id
a_count
sal_grade_id
authorized_sal
actual_sal
step
code
type
level
syspk_emp
lastname
firstname
middlename
date_birth
edu_attain
eligibility
date_orig_appoint
date_last_promotion
status
pe_from
pe_to
remarks
priority_no1
group_cat
date_save
priority_no
*
id
item_no
d_dept_id
d_position_id
d_count
a_dept_id
a_position_id
a_count
sal_grade_id
authorized_sal
actual_sal
step
code
type
level
syspk_emp
lastname
firstname
middlename
date_birth
edu_attain
eligibility
date_orig_appoint
date_last_promotion
status
pe_from
pe_to
remarks
priority_no1
group_cat
date_save
priority_no
category
sec_id
*
id
desc
*
id
trans_date
position_titleID
applicant_id
item_no
sal_gradeID
gov_unit
gov_class
dept_corp_agency
bureau_officeID
bureau_officename
dept_branch_divID
dept_branch_name
workstation
present_appropact
previous_appropact
salary_authorize
other_compensation
immediate_supID
immediate_sup
high_supID
high_supname
machine_equip
a_internalEXEC
a_internalSUP
a_internalNON
a_internalStaff
b_externalGENPUB
b_externalOTHER
other_spec
office_work
field_work
others_wc
brief_desc
brief_desc_genfunc
education
experience
training
eligibility
core_comp
core_complevel
leader_comp
leader_complevel
percent_worktime
duties_respon
duties_respon_complevel
supervisor
date_save
status
*
dtl_id
main_id
position_title
item_no
*
id
description
PS
GS
prio_no
status
*
id
activity
_datefrom
_dateTo
remarks_
status_
ts
purpose_
*
doc_id
document_name
document_location
date_attached
*
id
main_id
No_
questions
*
id
description
rate
*
id
recruitment_id
position_id
final_appointment_id
step
area
date_start
date_end
qualified
not_qualified
mode
applicant
action_taken
no_of_days
cost
remarks
ta_time_noofdays
ta_time_cost
ta_time_remarks
status
date_save
*
id
recruitment_id
fa_id
applicant_name
qualified
not_qualified
action_taken
no_of_days
cost
remarks
date_save
status
*
id
checklist_id
dtl_id
area
criteria
yes
no
status
remarks
*
id
ref_no
vacant_id
rec_main_id
guid
ts
group_status
*
id
ref_no
rec_group_id
vacant_id
rec_main_id
guid
date_evaluated
ts
status
*
id
trans_date
recruitment_id
vacant_id
signatory_id
form_desc
notice_desc
remarks
step
group
status
date_posted
date_save
*
main_id
tbl_vacant_id
positions
emp_position
applicant_id
firstname
middlename
lastname
contactno
ref_no
transdate
gender
address
department
course
status
date_appointed
date_saved
remarks
emp_type
eligibility
*
id
sched
*
id
restday
*
id
SalaryGrade
step
amount
max_amount
personnel_type
sal_grd_code
tstamp_time
status
*
id
SalaryGrade
step
amount
max_amount
personnel_type
sal_grd_code
tstamp_time
status
*
id
SalaryGrade
step
prev_amount
prev_max
amount
max_amount
personnel_type
sal_grd_code
tstamp_time
status
*
id
SalaryGrade
step
amount
max_amount
personnel_type
sal_grd_code
tstamp_time
status
*
id
SalaryGrade
step
amount
max_amount
personnel_type
sal_grd_code
tstamp_time
status
*
dtl_id
emp_num
main_id
from
to
position_title
employment_status
official_station
basic_salary
leave_without_pay
cause
separation_date
sal_grade_id
position_id
remarks
isMonthly
*
dtl_id
main_id
from
to
position_title
employment_status
official_station
basic_salary
leave_without_pay
cause
separation_date
sal_grade_id
position_id
remarks
*
id
emp_id
date
*
id
emp_id
employee
dateofbirth
present_office
acc_no
account_date
office_address
status
birthplace
*
id
emp_id
employee
dateofbirth
present_office
acc_no
account_date
office_address
status
birthplace
*
dtl_id
emp_num
main_id
from
to
position_title
employment_status
official_station
basic_salary
leave_without_pay
cause
separation_date
sal_grade_id
position_id
remarks
isMonthly
mode_adj
branch
govservice
*
dtl_id
emp_num
main_id
from
to
position_title
employment_status
official_station
basic_salary
leave_without_pay
cause
separation_date
sal_grade_id
position_id
remarks
isMonthly
mode_adj
branch
*
dtl_id
emp_num
main_id
from
to
position_title
employment_status
official_station
basic_salary
leave_without_pay
cause
separation_date
effectivity_date
sal_grade_id
position_id
remarks
isMonthly
*
dtl_id
emp_num
main_id
from
to
position_title
employment_status
official_station
basic_salary
leave_without_pay
cause
separation_date
sal_grade_id
position_id
remarks
isMonthly
*
dtl_id
emp_num
notes_new
leave_absenece
*
id
profile_id
profile_name
group_id
group_name
core_function
success_indicator
actual_accomplishment
status
savedate
*
id
recruitment_id
rating_id
rating_tbl
Applicant_name
gender
eligibility
residence
course
edu_rawscore
edu_perc
relevanttraining_rawscore
relevanttraining_perc
relevantwork_rawscore
relevantwork_perc
personalitytraits_rawscore
personalitytraits_perc
performanceraiting_rawscore
performanceraiting_perc
outstandingaccom_rawscore
outstandingaccom_perc
examination_rawscore
examination_perc
trans_date
chairman
hrmo
al_rep
dept_head
status
levelPosition
save_date
*
id
vacant_id
rating_tbl
ref_no
rating_id
trans_date
recruitment_id
status
date_posted
date_deliberated
date_submitted
date_save
*
id
emp_id
or_number
ordate
or_amount
mun_order
save_date
type
*
sss_id
range_from
range_to
monthly_salary
EC
ER
EE
Total
status
date_save
*
id
emp_id
guid
date_from
date_to
*
id
emp_id
setup_for
type
sched
timeshift
period_type
period_shed
change_shift
status
timestamp
*
id
emp_id
setup_for
type
sched
timeshift
period_type
period_shed
timestamp
*
id
ref_no
PersonName
p_code
Deptcode
post_id
position
department
trans_date
date_accomplished
Activity
remarks
status
ts
*
id
main_id
questions
_5
_4
_3
_2
_1
Other_answers
*
id
training_program
program_id
location
_dateFrom
_dateTo
no_of_hours_days
remarks
inclusive_date
type_
quarter_
status
ts
custom
*
id
main_id
Child
Parent
facilitator
Schedule
Remarks
Description
*
id
training_reg_id
emp_id
months
Years
type_
*
id
training_program
training_prog_id
training_location
remarks
inclusive_dates
date_from
date_to
empl_id
employee
pos_id
position_
department
dept_id
type_
attend
attendance_remarks
guid
status_
attend_dateFrm
attend_dateTo
ts
*
pk_id
form_id
title_id
proj_id
user_id
allow
save
update
cancel
print
ProfileID
*
id
vacant_id
ref_num
office
email
*
id
ref_num
trans_date
level_of_Position
position_title
position_id
pos_level
plantilla_no
salary_grade_ID
step
basic_monthly
annual_salary
education
training
experience
eligibility
competency
place_of_assignment_id
place_of_assignment
brief_desc
propose_smethod
strategy
individ_responsible
target_date
manpower_id
date_save
date_published
date_posted
remarks
status
main_status
plantilla_id
*
id
ref_no
ref_date
vacant_id
guid
ts
status
*
dtl_id
area_id
area
criteria
yes
no
remarks
status
*
id
emp_id
termination_type
reason
termination_date
user_id
ts
*
tc_id
tc_empno
tc_employeename
tc_deptcode
tc_paygroup_id
tc_datefrom
tc_dateto
tc_regulardayshrs
tc_OThrs
tc_Holidays
tc_nightdifferentialhrs
tc_LateHrs
tc_UTHrs
tc_status
tc_ts
*
tc_id
tc_empno
tc_employeename
tc_deptcode
tc_payrolltype
tc_datefrom
tc_dateto
tc_regulardayshrs
tc_Absent
tc_leave_WOP
tc_OThrs
tc_Holidays
tc_nightdifferentialhrs
tc_LateHrs
tc_UTHrs
tc_remaining
tc_status
tc_ts
*
ts_id
date_sched
empID
firstIN
firstOUT
secondIN
secondOUT
thirdIN
thirdOUT
fourthIN
fourthOUT
logCount
type
ts_status
shiftType
time_interval
in_interval
out_interval
change_shift
*
ts_id
date_sched
empID
firstIN
firstOUT
secondIN
secondOUT
thirdIN
thirdOUT
fourthIN
fourthOUT
logCount
ts_status
*
Id
dated
amIn
amOut
pmIn
pmOut
company_id
department_id
*
timeA_id
timeA_companyid
timeA_deptid
timeA_amIn
timeA_pmIn
timeA_OT
timeA_status
*
syspk_attendance
transaction_type
emp_id
emp_name
am_in
am_out
pm_in
pm_out
in_ot
out_ot
modifiedby
modifiedby_id
ts
*
ts_id
EmpNo
timeIn
timeOut
amIN
amOUT
pmIN
pmOUT
shiftcode
date_sched
*
id
emp_number
cse_careerservice
cse_dateofexam
cse_placeofexam
cse_rating
cse_licenseno
cse_datereleased
*
id_edu
emp_number
edu_level
edu_schoolname
edu_degree
edu_highgrade
edu_honor
edu_yeargraduated
edu_inclusivedatefrom
edu_inclusivedateto
remarks
*
id
emp_number
spouse_surname
spouse_firstname
spouse_middlename
spouse_ext
spouse_occupation
spouse_employer
spouse_employeradd
spouse_Telno
father_surname
father_firstname
father_middlename
father_ext
mother_surname
mother_firstname
mother_middlename
*
id
emp_number
otherinfo_1A
otherinfo_1B
otherinfo_1BDesc
otherinfo_2A
otherinfo_2ADESC
otherinfo_2B
otherinfo_2BDatefile
otherinfo_2BDesc
otherinfo_3
otherinfo_3Desc
otherinfo_4
otherinfo_4Desc
otherinfo_5A
otherinfo_5ADesc
otherinfo_5B
otherinfo_5BDesc
otherinfo_6
otherinfo_6Desc
otherinfo_7A
otherinfo_7ADesc
otherinfo_7B
otherinfo_7BDesc
otherinfo_7C
otherinfo_7CDesc
*
id
emp_number
reference_name
occupation
address
tel_no
mobile_no
*
id
emp_number
skills_hobbies
distinction_recognition
membership_org
*
id
emp_number
title_of_seminar
no_of_hour
conducted
type_of_LD
date_from
date_to
*
id
emp_number
Name_address_org
No_ofHours
position
datefrom
dateto
*
workexpID
emp_number
workexp_position
workexp_company
workexp_govser
workexp_monthlysal
workexp_salgrade
workexp_statofemployment
workexp_startdate
workexp_enddate
workexp_cmpnyadd
workexp_city
workexp_province
workexp_startsalary
workexp_lastsalary
workexp_sprname
workexp_sprtitle
workexp_telNo
workexp_reason
*
id
emp_id
shift_id
date
first_in
first_out
first_late
first_undertime
firstin_notes
first_notes
second_in
second_out
second_late
second_undertime
secondin_notes
second_notes
third_in
third_out
third_late
third_undertime
thirdin_notes
third_notes
fourth_in
fourth_out
fourth_late
fourth_undertime
fourthin_notes
fourth_notes
ot_in
ot_out
late
undertime
overtime
diferential
cto
no_of_hrs
holiday
is_rest_day
direct_overtime
status
trans_id
type
lock_status
modified_by
modified_date
rate_per_day
pos_id
paygroup_id
*
emp_number
new_emp_id
*
id
emp_id
training_id
status
ts
requestor
*
id
training_id
date_from
date_to
type
cost
purpose
attendees
venue
facilitator_id
approval_status
initiator
record_status
ts
*
id
training_id
requirement
requirement_description
record_status
ts
initiator
*
id
ref_no
ref_date
office_id
office_name
project_name
remarks
date_from
date_to
req_by
recom_by
as_app
as_fund
app_by
status
savedate
uid
typex
*
id
cert_id
emp_id
responsibilty
date
overtime_from
overtime_to
app_hrs
excempt
entry_type
memo
status
*
id
training_title
date_from
date_to
type
cost
purpose
attendees
record_status
approval_status
requestor
ts
venue
facilitator_id
*
SysPK_Trans
UserName
Date_Trans
Trans_Name
Tras_type
Action_type
Remarks
TransType_date
*
travel_id
date_filed
empl_number
Pos_id
Dept_id
datefrom
dateto
noOfdays
destination
purpose
objecttive
RecomendedBy
ApprovedBy
airplane
Land
Boat
CompanyVehicle
others
carier
Flightdestination
flightno
ETD
ETA
TERMINALFEES
CHTERMINALFEES
TAXIFEE
CHTAXIFEE
HOTEL
HOTELCHARGES
MEALS
CHMEALS
INCIDENTALS
CHINCIDENTALS
TOTAL
CHTOTAL
PROCESSEDBY
REVIEWEDBY
*
ID
JID
utility_type
PROPID
UNITID
bill_date
DueDate
DatePaid
previousRD
currentRD
ActualCons
Pcvrd
waterCost
powerCost
maintenance
ORNUM
Remarks
BillStatus
RecordStatus
GRP
*
bill_id
trans_date
bill_date
period_covered
data_entry_id
type
meter_no
prev_reading
prev_vol
curr_reading
curr_vol
previous_amount
bill_amount
penalty
advance
bill_status
date_saved
remarks
due_date
balance
project_id
is_pnalty
temp_1
temp_2
*
id
proj_id
penalty_rate
reconnection_fee
transfer_fee
has_elect
electricity
has_dues
dues
*
id
proj_id
code
minimum_consumption
maximum_consumption
rate_per_cubic
*
id
data_entry_id
account_no
account_name
property
block
lot
extension
meter_no
status
date_saved
remarks
installed_date
*
web_delay
delay_id
delay_type
equipment_id
sba_from
sba_to
sba_date
employee_id
type
time_total
*
id
employee_name
equipment_name
equipment_category
remarks
assign_status
assign_time
employee_id
equipment_id
shift
date
date_created
status
*
id
equipment_name
equipment_id
delay_id
delay_title
shift
date
date_created
status
*
id
UserID_Empl1
username
password
firstname
lastname
position
department
date_created
status
*
withdraw_details_id
withdraw_main_id
item_no
item_description
withdrawn_quantity
item_cost
inventory_id
date_withdrawn
tstamp
division
account
remarks
item_code
equipment_id
project_location_id
title_id
mat_consumption_identifier
status
db_equipment_id
charge_emp
*
withdraw_id
withdraw_no
division
account_code
withdraw_person_id
withdraw_person_incharge
date_withdrawn
status
remarks
location
equipment_id
trip_ticket
title_id
mat_consumption_identifier
journal_id
tstamp
withdraw_receive_by
db_equipment_id
pay_item
existing_smr
ref_no
mrs_id
jo_id
charge_emp
delivery_note
*
withholding_id
lower_limit
upper_limit
addl_2022_down
percent_2022_down
addl_2023_up
percent_2023_up
*
id
working_hours
*
id
SysPK_Grp
GroupCode_Grp
GroupName_Grp
Description_Grp
Remarks_Grp
Type_Grp
Status_Grp
SSS
PHIC
TIN
branchCode
PAGIBIG
Title_Id
Main_Id
*
id
version_time
*
DynSetup_ID
empl_id
empl_posid
empl_poscode
empl_deptid
empl_deptcode
empl_compid
empl_compcode
pyroll_deductionlimit_amt
monthly_allocated_days
late_graceperiod
UT_limit
*
DYNAMIC_CLEINT_ID
dy_client_code
dy_client_name
dy_client_position_code
dy_client_salarytype
dy_client_monthly_allocated_days
dy_client_deduction_limitAmt
dy_client_late_allowances
dy_client_Auto_OTApproved
dy_Regular_Overtime
dy_Regular_Overtime_byDefault
dy_Regular_LegalHoliday
dy_Regular_LegalHoliday_byDefault
dy_Regular_LegalHoliday_OT
dy_Regular_LegalHoliday_OT_byDefault
dy_Regular_SpecialHoliday
dy_Regular_SpecialHoliday_byDefault
dy_Regular_SpecialHoliday_OT
dy_Regular_SpecialHoliday_OT_byDefault
dy_RestDay
dy_RestDay_byDefault
dy_RestDay_OverTime
dy_RestDay_OverTime_byDefalut
dy_RestDay_LegalHoliday
dy_RestDay_LegalHoliday_byDefault
dy_RestDay_LegalHoliday_OT
dy_RestDay_LegalHoliday_OT_byDefault
dy_RestDay_SpecialHoliday
dy_RestDay_SpecialHoliday_byDefault
dy_RestDay_SpecialHoliday_OT
dy_RestDay_SpecialHoliday_OT_byDefault
dy_NightDifferential
dy_NightDifferential_byDefault
dy_NightDifferential_OT
dy_NightDifferential_OT_byDefault
dy_status
dy_timestamp
*
login_id
nameoffunction
typeoflogin
deptcode
compcode
*
id_AR
AR_Emplnme_id
AR_EmplPos_id
AR_EmplDept_code
AR_date_received
AR_date_close
AR_status
AR_remarks
AR_ts
*
id_EC
EC_Emplname_id
EC_Emplpos
EC_date_lastday
EC_rsonofexit
EC_EmplDepat_code
EC_particular
EC_immediate_head
EC_CTC
EC_placedate_issue
EC_date
EC_receivedby
EC_date_received
EC_status
EC_remarks
EC_ts
*
id_ECD
ECD_EmplID
ECD_department
ECD_particular
ECD_head
ECD_date_received
ECD_status
ECD_ts
*
id_EI
EI_empl_nme_id
EI_date_resign
EI_date_effective
EI_reason_text
EI_chance_text
EI_misscomp_text
EI_lastwords_text
EI_learned_text
EI_date_signature
EI_empl_nme
EI_empl_add
EI_empl_contactNo
EI_IntSig_nme
EI_sig_dsgntion
EI_date_interview
EI_ts
EI_status
*
id_PE
PE_Emplname_id
PE_Deptname
PE_Position
PE_date_hired
PE_date_evaluation
PE_dh_comm_S
PE_dh_comm_W
PE_empl_comm
PE_actionplan
PE_overallrating
PE_status
PE_remarks
PE_ts
*
id_PE_details
id_PE
PED_standard
PED_defination
PED_ratings
PED_allratings
PED_ts
*
id_PR
PR_definitions
PR_ratins
*
id_PRO
PRO_Empl_id
PRO_Empl_pos
PRO_promote_position_id
PRO_amount_rendered
PRO_date_effective
PRO_date_save
PRO_status
PRO_remarks
PRO_ts
*
id_RA
RA_Empl_id
RA_Emplpos
RA_date_effective
RA_service_effective
RA_date
RA_status
*
id_RWQ
RWQ_Emplname_id
RWQ_Emplname
RWQ_Empladd
RWQ_compensation
RWQ_date
RWQ_status
RWQ_ts
*
id_SD
SD_standard
SD_definition
*
our_company_id
our_company_license
our_company_year
our_company_name
select table
accounting_setup
acctg_action
activation_status
adjustment_entry
agendasetup
allowances
allowances_entry
allowances_fixed
allowances_jo
applicants
applicant_skills
application_ot
appointmentdocument
appointmentparticipant
appointments
approved_email_logs
approved_employee_ot
approved_ot
bank_setup
barangay
billing
bio_employees
bplo_attatchment
budget_controller
budget_controller_jo
caldays
calendar
cao_business_list
cao_business_list_main
cashadvacewalkin
cashliquidation
cashliquidation_detail
cash_advances
cash_advances_details
cash_advance_payed
clearance_attachments
clearance_comment
committeecreatedminutes
committeemembers
committeeminutetemplates
committees
committee_agenda
committee_attachmentlinks
committee_attendees
cto_rpt_payments_advance
currency
dash_assistance_survey
dash_assistance_survey_setup
dash_rating
deduction
deductions_status_employee
deductionto_atm_amount
deductiontype
deduction_details
deduction_pause
deduction_schedule
department
department_division
department_pmd
department_pmdbkp
department_shift
developer
disbursement
disbursement_dtls
division
division_setup
dmmy
drivers_equipment
dtr
dtr_approved_head
dtr_approved_head_setup
dtr_approved_payrollmaker
dtr_rules_setup
dummy_date
dummy_employee
dummy_t
duplicate_history
ebplo_other_certificates_form
ebplo_other_certificates_type
ecswd_travel_order
ecswd_travel_order_dtail
ecswd_travel_order_purpose
employeedepartment
employees
employees_allowances
employees_assignment
employees_bkp
employees_change_timeshift
employees_civilserviceeligibility
employees_copy
employees_copy_copy
employees_dependent
employees_designation_history
employees_eduback
employees_familybackground
employees_history
employees_leave_credits
employees_limit
employees_otherinfos
employees_position
employees_premiums
employees_rate
employees_rate_bkp
employees_reference
employees_section
employees_skillshobbies
employees_timeshift
employees_timeshift_copy
employees_trainingprogram
employees_trainingprogram1
employees_voluntarilywork
employees_workexperience
employees_work_history_ledger
employee_attachment
employee_attachments
employee_blocked
employee_blocked_byhr
employee_bloodtype
employee_clearance
employee_deduction_status
employee_eduback
employee_hiring_entity
employee_information
employee_information1
employee_information2
employee_information3
employee_information4
employee_information5
employee_informationupdated
employee_medicalreport
employee_medical_laboratoryresult
employee_medical_pastillness
employee_medical_pe_findings
employee_medical_physicalexamination
employee_medical_status
employee_otherinfo
employee_profile_pic
employee_references
employee_sal_type
employee_signatory
employee_skills
employee_skillsandreference
employee_skillset
employee_status
employee_type
employee_workexperience
emp_service_record
emp_transfer_dept_history
emp_transfer_dept_history_detail
equip
eventcalendarrange
finger_logs
fixed_other_allowances
gender
groups
history_active_inactive
history_blocked_byhr
history_position
hr_action
hr_ara_form_a
hr_ara_form_d
hr_ara_form_e
hr_ara_form_e_setup
hr_biometric_logs
hr_biometric_logs_dummy
hr_biometric_logs_history
hr_biometric_logs_history_transcient
hr_biometric_logs_transcient
hr_biometric_terminal
hr_biometric_user_data
hr_biometric_user_info
hr_certificate_data
hr_certificate_data_details
hr_certificate_setup
hr_certificate_table_template
hr_cert_of_appearance
hr_committee_agenda
hr_committee_agenda_attendee
hr_committee_metting
hr_committee_metting_attendance
hr_committee_resolution
hr_committee_setup
hr_committee_setup_member
hr_employee
hr_emp_afingerprint
hr_emp_assigning_projectsite
hr_emp_attendance
hr_emp_attendance_copy
hr_emp_attendance_jo
hr_emp_attendance_manualentry
hr_emp_attendance_othersite
hr_emp_empltype
hr_emp_leaves
hr_emp_leave_accumulatation
hr_emp_leave_accumulatation_history
hr_emp_leave_accumulate_ranz
hr_emp_leave_credits
hr_emp_leave_type
hr_emp_private_leavecredit
hr_emp_projectsite
hr_emp_service_records
hr_emp_shift
hr_holidays
hr_holidays_special
hr_job_status
hr_leave_type
hr_person_dependents
hr_person_educational_bg
hr_person_eligibility
hr_person_family_bg
hr_person_other_info
hr_person_profile
hr_person_reference
hr_person_skills
hr_person_training
hr_person_voluntary_work
hr_person_work_exp
hr_tbl_best_department
hr_tbl_best_employee
hr_tbl_clearance
hr_tbl_computation_amnt_setup
hr_tbl_computation_terminal_leave
hr_tbl_drugselectionlist
hr_tbl_emp_update_logs
hr_tbl_exit_interview
hr_tbl_increment_sched
hr_tbl_loyalty_bonus
hr_tbl_loyalty_setup
hr_tbl_memos_and_violations_dtl
hr_tbl_memos_and_violations_main
hr_tbl_offenses
hr_tbl_offenses_type
hr_tbl_offense_category
hr_tbl_organizational_setup
hr_tbl_perfect_attendance
hr_tbl_pre_retirement
hr_tbl_rating_setup
hr_tbl_rating_setup_details
hr_tbl_retirement_setup
hr_tbl_retire_separate_logs
hr_tbl_salary_adjustment
hr_tbl_salary_adjustment_bkp
hr_tbl_salary_adjustment_copy
hr_tbl_section_setup
hr_tbl_separation
hr_tbl_setup_rated
ielts_detail
inactive_active_history
incentives
incident_report
individualpass
irregular_shift
it_action
job_position_rate_setup
job_position_setup
late_cutoff_setup
log
login_attempts
mandatoryattendance
manpower_request
mm_action
myitems
nickname
office_location
offsetted_trans_record
onboarding_checklist_entry
on_boarding_checklist_setup
organizational_chart
originating_action
otherdeductions
otherdeductionsentry_details
otherdeductionsentry_main
otherdeductions_jo
otherdeduction_balances
other_addons
other_deduction
overtime_request
pagibig_loan
pagibig_loan_details
pagibig_setup
pakyaw_itemsetupp
paygroup_setup
payroll_computation
payroll_deduction_history
payroll_maker
payroll_rate
payslip
payslip2
payslip_allowance
payslip_allowance_jo
payslip_copy
payslip_details
payslip_details_jo
payslip_dole
payslip_dtr
payslip_jo
payslip_jo_holiday
payslip_jo_overtime
payslip_pagibig
payslip_pakyaw
payslip_pakyaw_detail
payslip_pertrip
payslip_sss
philhealth_setup
po
position
previous_basicpay
program_title
projects
project_list
project_title
raffle_name
raffle_name_copy
raffle_position
raffle_price
raffle_winner
ranz_tbl_flagceremony
repairform_setup
reports
requirement_setup
resources
restday_request
restday_request_permanent
rfcs_detail
rfcs_detail_breakdown
rfcs_main
salary_grade
setup_biometric
setup_biometric_privilege
setup_corefnctiongroup
setup_mfopap
setup_project
setup_ratings_efficiency_plantilla
setup_ratings_oath
setup_ratings_quality_plantilla
setup_ratings_timeliness_servicecards
setup_sccess_indctor
set_up_company
sheet2$
sheet3$
shop_rate
signatory_logs
signatory_portal
skill_setup
sms_config
sms_text
special_holiday
sss_gsis
sss_loan
sss_loan_details
sss_setup
subject
sworn_assets
sworn_assetsb
sworn_businessinterest
sworn_liabilities
sworn_relatives
sworn_signatory
sworn_table
sworn_unmarried
task
tbl_achievement_record_new
tbl_active
tbl_adjustment
tbl_age_gap
tbl_alowance_setup
tbl_applicantrating_1stlevela1
tbl_applicantrating_1stlevela1_4
tbl_applicantrating_1stlevelb2
tbl_applicantrating_1stlevelb2_dtl
tbl_applicantrating_2ndlevela1
tbl_applicantrating_2ndlevela1_dtl
tbl_applicantrating_2ndlevelb2
tbl_applicantrating_2ndlevelb2_dtl
tbl_attachedfile
tbl_audit_trail
tbl_bill_ref
tbl_category_position
tbl_certificateoffinalaction_grievance
tbl_checklist_area
tbl_comparative
tbl_complaint
tbl_computation_night_diff
tbl_computation_normal_days
tbl_computation_overtime
tbl_correction
tbl_correction_detail
tbl_count
tbl_covered_days
tbl_credit_dtl
tbl_csecarreerservice
tbl_ctoentry_dtl
tbl_ctoentry_main
tbl_cto_balance
tbl_cto_balance_dtl
tbl_date
tbl_dayname
tbl_day_sked
tbl_deductions
tbl_deductions_dtl
tbl_deduction_dtl
tbl_documents_attached
tbl_drugtestplace_setup
tbl_dtr1
tbl_dtr_incident_report
tbl_dtr_incident_report_deduction
tbl_dtr_incomplete_logs
tbl_dtr_jo
tbl_dtr_jo_01_03
tbl_dtr_jo_01052022
tbl_dtr_jo_2021
tbl_dtr_locked_status
tbl_dtr_old
tbl_dtr_old_jo
tbl_dtr_temp
tbl_dtr_temp_batch
tbl_dtr_temp_bkp
tbl_dtr_temp_jo
tbl_elective_employee_other_information_new
tbl_email
tbl_employee_period
tbl_emp_passlip
tbl_emp_passlip1
tbl_emp_passlipxxxxxxxxxxxxxx
tbl_emp_payroll_salary
tbl_emp_restday
tbl_emp_sequencer
tbl_emp_service_record
tbl_events
tbl_events_offices
tbl_excel
tbl_fields
tbl_final_appointment
tbl_flagceremonyattendance
tbl_general_settings
tbl_generation_setup
tbl_gratuity
tbl_gratuity_dtl
tbl_grievance
tbl_grievance_agreement
tbl_gsis
tbl_hours_sked
tbl_hr_group_ipcr
tbl_hr_ipcr_detail
tbl_hr_ipcr_main
tbl_hr_ipcr_rating_scale
tbl_hr_profile_ipcr
tbl_hr_setup_ipcr
tbl_humanresourcegroup_ipcr
tbl_humanresourceipcr_detail
tbl_humanresourceipcr_main
tbl_humanresourceprofile_ipcr
tbl_humanresourcesetup_ipcr
tbl_incident_report_administrative
tbl_individual_dev_plan
tbl_individual_dev_plan_dtl
tbl_individual_dev_plan_dtl1
tbl_itinerary
tbl_leaves
tbl_leaves_dtl
tbl_leave_count
tbl_leave_credits
tbl_level
tbl_level_csc
tbl_level_position
tbl_logs
tbl_manpowerrequest
tbl_minutes_sked
tbl_missing_attendance
tbl_month
tbl_multiple_department
tbl_officeorder
tbl_official_business
tbl_official_business_dtl
tbl_order_personnel
tbl_overtime
tbl_overtime_category
tbl_overtime_cert
tbl_overtime_cert_dtl
tbl_overtime_copy
tbl_overtime_dtl
tbl_overtime_dtl_copy
tbl_overtime_memo
tbl_overtime_rate
tbl_paygroup_setup
tbl_payrollchange_dtl
tbl_payrollchange_main
tbl_payrollmaker
tbl_payroll_adjustment
tbl_payroll_allowances
tbl_payroll_ca_loans
tbl_payroll_contributions
tbl_payroll_general
tbl_payroll_logs_computation
tbl_payroll_main
tbl_payroll_main_copy
tbl_payroll_other_deductions
tbl_payrol_period
tbl_penaltytype
tbl_personnelschedule
tbl_personnelschedule_dtls
tbl_philhealth
tbl_pic
tbl_plantilla_personnel
tbl_plantilla_personnel_csc
tbl_plantilla_personnel_csc_new
tbl_plantilla_personnel_csc_new_1
tbl_plantilla_personnel_csc_new_2
tbl_plantilla_personnel_csc_new_3
tbl_plantilla_personnel_csc_new_4
tbl_plantilla_personnel_csc_new_5
tbl_position_category
tbl_position_desc
tbl_position_desc_detail
tbl_premium_setup
tbl_question
tbl_questionnaire_documents_attached
tbl_questions_dtl
tbl_rate
tbl_recruitment_checklist
tbl_recruitment_checklist_dtl
tbl_recruitment_detail
tbl_recruitment_group
tbl_recruitment_group_preliminary
tbl_recruitment_logs
tbl_recruitment_main
tbl_regularazation_sched
tbl_restday
tbl_salary_grade
tbl_salary_grade_bkp
tbl_salary_grade_copy1
tbl_salary_grade_old
tbl_salary_grade_rhu
tbl_service_record_dtl
tbl_service_record_dtl_bkp
tbl_service_record_issuance
tbl_service_record_main
tbl_service_record_main_bkp
tbl_service_record_new
tbl_service_record_new12-21-23
tbl_service_record_new_06-06-2023
tbl_service_record_new_bkp
tbl_service_record_new_main
tbl_setup_ipcr_data
tbl_shortlistedselection
tbl_short_listed
tbl_srorinput
tbl_sss
tbl_temp_dtr_list
tbl_timeshift_setup_main
tbl_timeshift_setup_main_copy
tbl_trainingneeds
tbl_trainingneeds_dtl
tbl_training_course
tbl_training_course_dtl
tbl_training_months
tbl_training_registration
tbl_user_restrictions
tbl_vacant_detail_info
tbl_vacant_pos
tbl_vacant_pos_group
tb_appointment_checklist
termination_details
timecard_summary
timecard_summary_permanent
timesheet
timesheet_jo
timeshiftdept
time_allowance
time_logs_history
time_sheet
tmp_employees_civilserviceeligibility
tmp_employees_eduback
tmp_employees_familybackground
tmp_employees_otherinfos
tmp_employees_reference
tmp_employees_skillshobbies
tmp_employees_trainingprogram
tmp_employees_voluntarilywork
tmp_employees_workexperience
tmp_generate_dtr_printing
tmp_olddtr_mig
training_attendees
training_details
training_requirements
training_schedule
training_schedule_dtls
training_setup
transaction_log
travel_order
utilitybill
utility_billing
utility_billing_rate_ed
utility_billing_rate_water
utility_bill_profile
web_dispatch_delay
web_dispatch_main
web_dispatch_standby
web_users
withdraw_details
withdraw_main
withholding_setup
working_hours
work_group
_aversiontime
_hr_dynamic_setup
_hr_dynamic_setup_client
_login_type
_tbl_acceptance_resignation
_tbl_exit_clearance
_tbl_exit_clearance_details
_tbl_exit_interview
_tbl_performance_evaluation
_tbl_performance_evaluation_detail
_tbl_performance_ratings
_tbl_promotion
_tbl_regular_appointment
_tbl_release_waiver
_tbl_standard_definition
_template
.
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
accounting_setup
acctg_action
activation_status
adjustment_entry
agendasetup
allowances
allowances_entry
allowances_fixed
allowances_jo
applicants
applicant_skills
application_ot
appointmentdocument
appointmentparticipant
appointments
approved_email_logs
approved_employee_ot
approved_ot
bank_setup
barangay
billing
bio_employees
bplo_attatchment
budget_controller
budget_controller_jo
caldays
calendar
cao_business_list
cao_business_list_main
cashadvacewalkin
cashliquidation
cashliquidation_detail
cash_advances
cash_advances_details
cash_advance_payed
clearance_attachments
clearance_comment
committeecreatedminutes
committeemembers
committeeminutetemplates
committees
committee_agenda
committee_attachmentlinks
committee_attendees
cto_rpt_payments_advance
currency
dash_assistance_survey
dash_assistance_survey_setup
dash_rating
deduction
deductions_status_employee
deductionto_atm_amount
deductiontype
deduction_details
deduction_pause
deduction_schedule
department
department_division
department_pmd
department_pmdbkp
department_shift
developer
disbursement
disbursement_dtls
division
division_setup
dmmy
drivers_equipment
dtr
dtr_approved_head
dtr_approved_head_setup
dtr_approved_payrollmaker
dtr_rules_setup
dummy_date
dummy_employee
dummy_t
duplicate_history
ebplo_other_certificates_form
ebplo_other_certificates_type
ecswd_travel_order
ecswd_travel_order_dtail
ecswd_travel_order_purpose
employeedepartment
employees
employees_allowances
employees_assignment
employees_bkp
employees_change_timeshift
employees_civilserviceeligibility
employees_copy
employees_copy_copy
employees_dependent
employees_designation_history
employees_eduback
employees_familybackground
employees_history
employees_leave_credits
employees_limit
employees_otherinfos
employees_position
employees_premiums
employees_rate
employees_rate_bkp
employees_reference
employees_section
employees_skillshobbies
employees_timeshift
employees_timeshift_copy
employees_trainingprogram
employees_trainingprogram1
employees_voluntarilywork
employees_workexperience
employees_work_history_ledger
employee_attachment
employee_attachments
employee_blocked
employee_blocked_byhr
employee_bloodtype
employee_clearance
employee_deduction_status
employee_eduback
employee_hiring_entity
employee_information
employee_information1
employee_information2
employee_information3
employee_information4
employee_information5
employee_informationupdated
employee_medicalreport
employee_medical_laboratoryresult
employee_medical_pastillness
employee_medical_pe_findings
employee_medical_physicalexamination
employee_medical_status
employee_otherinfo
employee_profile_pic
employee_references
employee_sal_type
employee_signatory
employee_skills
employee_skillsandreference
employee_skillset
employee_status
employee_type
employee_workexperience
emp_service_record
emp_transfer_dept_history
emp_transfer_dept_history_detail
equip
eventcalendarrange
finger_logs
fixed_other_allowances
gender
groups
history_active_inactive
history_blocked_byhr
history_position
hr_action
hr_ara_form_a
hr_ara_form_d
hr_ara_form_e
hr_ara_form_e_setup
hr_biometric_logs
hr_biometric_logs_dummy
hr_biometric_logs_history
hr_biometric_logs_history_transcient
hr_biometric_logs_transcient
hr_biometric_terminal
hr_biometric_user_data
hr_biometric_user_info
hr_certificate_data
hr_certificate_data_details
hr_certificate_setup
hr_certificate_table_template
hr_cert_of_appearance
hr_committee_agenda
hr_committee_agenda_attendee
hr_committee_metting
hr_committee_metting_attendance
hr_committee_resolution
hr_committee_setup
hr_committee_setup_member
hr_employee
hr_emp_afingerprint
hr_emp_assigning_projectsite
hr_emp_attendance
hr_emp_attendance_copy
hr_emp_attendance_jo
hr_emp_attendance_manualentry
hr_emp_attendance_othersite
hr_emp_empltype
hr_emp_leaves
hr_emp_leave_accumulatation
hr_emp_leave_accumulatation_history
hr_emp_leave_accumulate_ranz
hr_emp_leave_credits
hr_emp_leave_type
hr_emp_private_leavecredit
hr_emp_projectsite
hr_emp_service_records
hr_emp_shift
hr_holidays
hr_holidays_special
hr_job_status
hr_leave_type
hr_person_dependents
hr_person_educational_bg
hr_person_eligibility
hr_person_family_bg
hr_person_other_info
hr_person_profile
hr_person_reference
hr_person_skills
hr_person_training
hr_person_voluntary_work
hr_person_work_exp
hr_tbl_best_department
hr_tbl_best_employee
hr_tbl_clearance
hr_tbl_computation_amnt_setup
hr_tbl_computation_terminal_leave
hr_tbl_drugselectionlist
hr_tbl_emp_update_logs
hr_tbl_exit_interview
hr_tbl_increment_sched
hr_tbl_loyalty_bonus
hr_tbl_loyalty_setup
hr_tbl_memos_and_violations_dtl
hr_tbl_memos_and_violations_main
hr_tbl_offenses
hr_tbl_offenses_type
hr_tbl_offense_category
hr_tbl_organizational_setup
hr_tbl_perfect_attendance
hr_tbl_pre_retirement
hr_tbl_rating_setup
hr_tbl_rating_setup_details
hr_tbl_retirement_setup
hr_tbl_retire_separate_logs
hr_tbl_salary_adjustment
hr_tbl_salary_adjustment_bkp
hr_tbl_salary_adjustment_copy
hr_tbl_section_setup
hr_tbl_separation
hr_tbl_setup_rated
ielts_detail
inactive_active_history
incentives
incident_report
individualpass
irregular_shift
it_action
job_position_rate_setup
job_position_setup
late_cutoff_setup
log
login_attempts
mandatoryattendance
manpower_request
mm_action
myitems
nickname
office_location
offsetted_trans_record
onboarding_checklist_entry
on_boarding_checklist_setup
organizational_chart
originating_action
otherdeductions
otherdeductionsentry_details
otherdeductionsentry_main
otherdeductions_jo
otherdeduction_balances
other_addons
other_deduction
overtime_request
pagibig_loan
pagibig_loan_details
pagibig_setup
pakyaw_itemsetupp
paygroup_setup
payroll_computation
payroll_deduction_history
payroll_maker
payroll_rate
payslip
payslip2
payslip_allowance
payslip_allowance_jo
payslip_copy
payslip_details
payslip_details_jo
payslip_dole
payslip_dtr
payslip_jo
payslip_jo_holiday
payslip_jo_overtime
payslip_pagibig
payslip_pakyaw
payslip_pakyaw_detail
payslip_pertrip
payslip_sss
philhealth_setup
po
position
previous_basicpay
program_title
projects
project_list
project_title
raffle_name
raffle_name_copy
raffle_position
raffle_price
raffle_winner
ranz_tbl_flagceremony
repairform_setup
reports
requirement_setup
resources
restday_request
restday_request_permanent
rfcs_detail
rfcs_detail_breakdown
rfcs_main
salary_grade
setup_biometric
setup_biometric_privilege
setup_corefnctiongroup
setup_mfopap
setup_project
setup_ratings_efficiency_plantilla
setup_ratings_oath
setup_ratings_quality_plantilla
setup_ratings_timeliness_servicecards
setup_sccess_indctor
set_up_company
sheet2$
sheet3$
shop_rate
signatory_logs
signatory_portal
skill_setup
sms_config
sms_text
special_holiday
sss_gsis
sss_loan
sss_loan_details
sss_setup
subject
sworn_assets
sworn_assetsb
sworn_businessinterest
sworn_liabilities
sworn_relatives
sworn_signatory
sworn_table
sworn_unmarried
task
tbl_achievement_record_new
tbl_active
tbl_adjustment
tbl_age_gap
tbl_alowance_setup
tbl_applicantrating_1stlevela1
tbl_applicantrating_1stlevela1_4
tbl_applicantrating_1stlevelb2
tbl_applicantrating_1stlevelb2_dtl
tbl_applicantrating_2ndlevela1
tbl_applicantrating_2ndlevela1_dtl
tbl_applicantrating_2ndlevelb2
tbl_applicantrating_2ndlevelb2_dtl
tbl_attachedfile
tbl_audit_trail
tbl_bill_ref
tbl_category_position
tbl_certificateoffinalaction_grievance
tbl_checklist_area
tbl_comparative
tbl_complaint
tbl_computation_night_diff
tbl_computation_normal_days
tbl_computation_overtime
tbl_correction
tbl_correction_detail
tbl_count
tbl_covered_days
tbl_credit_dtl
tbl_csecarreerservice
tbl_ctoentry_dtl
tbl_ctoentry_main
tbl_cto_balance
tbl_cto_balance_dtl
tbl_date
tbl_dayname
tbl_day_sked
tbl_deductions
tbl_deductions_dtl
tbl_deduction_dtl
tbl_documents_attached
tbl_drugtestplace_setup
tbl_dtr1
tbl_dtr_incident_report
tbl_dtr_incident_report_deduction
tbl_dtr_incomplete_logs
tbl_dtr_jo
tbl_dtr_jo_01_03
tbl_dtr_jo_01052022
tbl_dtr_jo_2021
tbl_dtr_locked_status
tbl_dtr_old
tbl_dtr_old_jo
tbl_dtr_temp
tbl_dtr_temp_batch
tbl_dtr_temp_bkp
tbl_dtr_temp_jo
tbl_elective_employee_other_information_new
tbl_email
tbl_employee_period
tbl_emp_passlip
tbl_emp_passlip1
tbl_emp_passlipxxxxxxxxxxxxxx
tbl_emp_payroll_salary
tbl_emp_restday
tbl_emp_sequencer
tbl_emp_service_record
tbl_events
tbl_events_offices
tbl_excel
tbl_fields
tbl_final_appointment
tbl_flagceremonyattendance
tbl_general_settings
tbl_generation_setup
tbl_gratuity
tbl_gratuity_dtl
tbl_grievance
tbl_grievance_agreement
tbl_gsis
tbl_hours_sked
tbl_hr_group_ipcr
tbl_hr_ipcr_detail
tbl_hr_ipcr_main
tbl_hr_ipcr_rating_scale
tbl_hr_profile_ipcr
tbl_hr_setup_ipcr
tbl_humanresourcegroup_ipcr
tbl_humanresourceipcr_detail
tbl_humanresourceipcr_main
tbl_humanresourceprofile_ipcr
tbl_humanresourcesetup_ipcr
tbl_incident_report_administrative
tbl_individual_dev_plan
tbl_individual_dev_plan_dtl
tbl_individual_dev_plan_dtl1
tbl_itinerary
tbl_leaves
tbl_leaves_dtl
tbl_leave_count
tbl_leave_credits
tbl_level
tbl_level_csc
tbl_level_position
tbl_logs
tbl_manpowerrequest
tbl_minutes_sked
tbl_missing_attendance
tbl_month
tbl_multiple_department
tbl_officeorder
tbl_official_business
tbl_official_business_dtl
tbl_order_personnel
tbl_overtime
tbl_overtime_category
tbl_overtime_cert
tbl_overtime_cert_dtl
tbl_overtime_copy
tbl_overtime_dtl
tbl_overtime_dtl_copy
tbl_overtime_memo
tbl_overtime_rate
tbl_paygroup_setup
tbl_payrollchange_dtl
tbl_payrollchange_main
tbl_payrollmaker
tbl_payroll_adjustment
tbl_payroll_allowances
tbl_payroll_ca_loans
tbl_payroll_contributions
tbl_payroll_general
tbl_payroll_logs_computation
tbl_payroll_main
tbl_payroll_main_copy
tbl_payroll_other_deductions
tbl_payrol_period
tbl_penaltytype
tbl_personnelschedule
tbl_personnelschedule_dtls
tbl_philhealth
tbl_pic
tbl_plantilla_personnel
tbl_plantilla_personnel_csc
tbl_plantilla_personnel_csc_new
tbl_plantilla_personnel_csc_new_1
tbl_plantilla_personnel_csc_new_2
tbl_plantilla_personnel_csc_new_3
tbl_plantilla_personnel_csc_new_4
tbl_plantilla_personnel_csc_new_5
tbl_position_category
tbl_position_desc
tbl_position_desc_detail
tbl_premium_setup
tbl_question
tbl_questionnaire_documents_attached
tbl_questions_dtl
tbl_rate
tbl_recruitment_checklist
tbl_recruitment_checklist_dtl
tbl_recruitment_detail
tbl_recruitment_group
tbl_recruitment_group_preliminary
tbl_recruitment_logs
tbl_recruitment_main
tbl_regularazation_sched
tbl_restday
tbl_salary_grade
tbl_salary_grade_bkp
tbl_salary_grade_copy1
tbl_salary_grade_old
tbl_salary_grade_rhu
tbl_service_record_dtl
tbl_service_record_dtl_bkp
tbl_service_record_issuance
tbl_service_record_main
tbl_service_record_main_bkp
tbl_service_record_new
tbl_service_record_new12-21-23
tbl_service_record_new_06-06-2023
tbl_service_record_new_bkp
tbl_service_record_new_main
tbl_setup_ipcr_data
tbl_shortlistedselection
tbl_short_listed
tbl_srorinput
tbl_sss
tbl_temp_dtr_list
tbl_timeshift_setup_main
tbl_timeshift_setup_main_copy
tbl_trainingneeds
tbl_trainingneeds_dtl
tbl_training_course
tbl_training_course_dtl
tbl_training_months
tbl_training_registration
tbl_user_restrictions
tbl_vacant_detail_info
tbl_vacant_pos
tbl_vacant_pos_group
tb_appointment_checklist
termination_details
timecard_summary
timecard_summary_permanent
timesheet
timesheet_jo
timeshiftdept
time_allowance
time_logs_history
time_sheet
tmp_employees_civilserviceeligibility
tmp_employees_eduback
tmp_employees_familybackground
tmp_employees_otherinfos
tmp_employees_reference
tmp_employees_skillshobbies
tmp_employees_trainingprogram
tmp_employees_voluntarilywork
tmp_employees_workexperience
tmp_generate_dtr_printing
tmp_olddtr_mig
training_attendees
training_details
training_requirements
training_schedule
training_schedule_dtls
training_setup
transaction_log
travel_order
utilitybill
utility_billing
utility_billing_rate_ed
utility_billing_rate_water
utility_bill_profile
web_dispatch_delay
web_dispatch_main
web_dispatch_standby
web_users
withdraw_details
withdraw_main
withholding_setup
working_hours
work_group
_aversiontime
_hr_dynamic_setup
_hr_dynamic_setup_client
_login_type
_tbl_acceptance_resignation
_tbl_exit_clearance
_tbl_exit_clearance_details
_tbl_exit_interview
_tbl_performance_evaluation
_tbl_performance_evaluation_detail
_tbl_performance_ratings
_tbl_promotion
_tbl_regular_appointment
_tbl_release_waiver
_tbl_standard_definition
_template
.
select column
select table
accounting_setup
acctg_action
activation_status
adjustment_entry
agendasetup
allowances
allowances_entry
allowances_fixed
allowances_jo
applicants
applicant_skills
application_ot
appointmentdocument
appointmentparticipant
appointments
approved_email_logs
approved_employee_ot
approved_ot
bank_setup
barangay
billing
bio_employees
bplo_attatchment
budget_controller
budget_controller_jo
caldays
calendar
cao_business_list
cao_business_list_main
cashadvacewalkin
cashliquidation
cashliquidation_detail
cash_advances
cash_advances_details
cash_advance_payed
clearance_attachments
clearance_comment
committeecreatedminutes
committeemembers
committeeminutetemplates
committees
committee_agenda
committee_attachmentlinks
committee_attendees
cto_rpt_payments_advance
currency
dash_assistance_survey
dash_assistance_survey_setup
dash_rating
deduction
deductions_status_employee
deductionto_atm_amount
deductiontype
deduction_details
deduction_pause
deduction_schedule
department
department_division
department_pmd
department_pmdbkp
department_shift
developer
disbursement
disbursement_dtls
division
division_setup
dmmy
drivers_equipment
dtr
dtr_approved_head
dtr_approved_head_setup
dtr_approved_payrollmaker
dtr_rules_setup
dummy_date
dummy_employee
dummy_t
duplicate_history
ebplo_other_certificates_form
ebplo_other_certificates_type
ecswd_travel_order
ecswd_travel_order_dtail
ecswd_travel_order_purpose
employeedepartment
employees
employees_allowances
employees_assignment
employees_bkp
employees_change_timeshift
employees_civilserviceeligibility
employees_copy
employees_copy_copy
employees_dependent
employees_designation_history
employees_eduback
employees_familybackground
employees_history
employees_leave_credits
employees_limit
employees_otherinfos
employees_position
employees_premiums
employees_rate
employees_rate_bkp
employees_reference
employees_section
employees_skillshobbies
employees_timeshift
employees_timeshift_copy
employees_trainingprogram
employees_trainingprogram1
employees_voluntarilywork
employees_workexperience
employees_work_history_ledger
employee_attachment
employee_attachments
employee_blocked
employee_blocked_byhr
employee_bloodtype
employee_clearance
employee_deduction_status
employee_eduback
employee_hiring_entity
employee_information
employee_information1
employee_information2
employee_information3
employee_information4
employee_information5
employee_informationupdated
employee_medicalreport
employee_medical_laboratoryresult
employee_medical_pastillness
employee_medical_pe_findings
employee_medical_physicalexamination
employee_medical_status
employee_otherinfo
employee_profile_pic
employee_references
employee_sal_type
employee_signatory
employee_skills
employee_skillsandreference
employee_skillset
employee_status
employee_type
employee_workexperience
emp_service_record
emp_transfer_dept_history
emp_transfer_dept_history_detail
equip
eventcalendarrange
finger_logs
fixed_other_allowances
gender
groups
history_active_inactive
history_blocked_byhr
history_position
hr_action
hr_ara_form_a
hr_ara_form_d
hr_ara_form_e
hr_ara_form_e_setup
hr_biometric_logs
hr_biometric_logs_dummy
hr_biometric_logs_history
hr_biometric_logs_history_transcient
hr_biometric_logs_transcient
hr_biometric_terminal
hr_biometric_user_data
hr_biometric_user_info
hr_certificate_data
hr_certificate_data_details
hr_certificate_setup
hr_certificate_table_template
hr_cert_of_appearance
hr_committee_agenda
hr_committee_agenda_attendee
hr_committee_metting
hr_committee_metting_attendance
hr_committee_resolution
hr_committee_setup
hr_committee_setup_member
hr_employee
hr_emp_afingerprint
hr_emp_assigning_projectsite
hr_emp_attendance
hr_emp_attendance_copy
hr_emp_attendance_jo
hr_emp_attendance_manualentry
hr_emp_attendance_othersite
hr_emp_empltype
hr_emp_leaves
hr_emp_leave_accumulatation
hr_emp_leave_accumulatation_history
hr_emp_leave_accumulate_ranz
hr_emp_leave_credits
hr_emp_leave_type
hr_emp_private_leavecredit
hr_emp_projectsite
hr_emp_service_records
hr_emp_shift
hr_holidays
hr_holidays_special
hr_job_status
hr_leave_type
hr_person_dependents
hr_person_educational_bg
hr_person_eligibility
hr_person_family_bg
hr_person_other_info
hr_person_profile
hr_person_reference
hr_person_skills
hr_person_training
hr_person_voluntary_work
hr_person_work_exp
hr_tbl_best_department
hr_tbl_best_employee
hr_tbl_clearance
hr_tbl_computation_amnt_setup
hr_tbl_computation_terminal_leave
hr_tbl_drugselectionlist
hr_tbl_emp_update_logs
hr_tbl_exit_interview
hr_tbl_increment_sched
hr_tbl_loyalty_bonus
hr_tbl_loyalty_setup
hr_tbl_memos_and_violations_dtl
hr_tbl_memos_and_violations_main
hr_tbl_offenses
hr_tbl_offenses_type
hr_tbl_offense_category
hr_tbl_organizational_setup
hr_tbl_perfect_attendance
hr_tbl_pre_retirement
hr_tbl_rating_setup
hr_tbl_rating_setup_details
hr_tbl_retirement_setup
hr_tbl_retire_separate_logs
hr_tbl_salary_adjustment
hr_tbl_salary_adjustment_bkp
hr_tbl_salary_adjustment_copy
hr_tbl_section_setup
hr_tbl_separation
hr_tbl_setup_rated
ielts_detail
inactive_active_history
incentives
incident_report
individualpass
irregular_shift
it_action
job_position_rate_setup
job_position_setup
late_cutoff_setup
log
login_attempts
mandatoryattendance
manpower_request
mm_action
myitems
nickname
office_location
offsetted_trans_record
onboarding_checklist_entry
on_boarding_checklist_setup
organizational_chart
originating_action
otherdeductions
otherdeductionsentry_details
otherdeductionsentry_main
otherdeductions_jo
otherdeduction_balances
other_addons
other_deduction
overtime_request
pagibig_loan
pagibig_loan_details
pagibig_setup
pakyaw_itemsetupp
paygroup_setup
payroll_computation
payroll_deduction_history
payroll_maker
payroll_rate
payslip
payslip2
payslip_allowance
payslip_allowance_jo
payslip_copy
payslip_details
payslip_details_jo
payslip_dole
payslip_dtr
payslip_jo
payslip_jo_holiday
payslip_jo_overtime
payslip_pagibig
payslip_pakyaw
payslip_pakyaw_detail
payslip_pertrip
payslip_sss
philhealth_setup
po
position
previous_basicpay
program_title
projects
project_list
project_title
raffle_name
raffle_name_copy
raffle_position
raffle_price
raffle_winner
ranz_tbl_flagceremony
repairform_setup
reports
requirement_setup
resources
restday_request
restday_request_permanent
rfcs_detail
rfcs_detail_breakdown
rfcs_main
salary_grade
setup_biometric
setup_biometric_privilege
setup_corefnctiongroup
setup_mfopap
setup_project
setup_ratings_efficiency_plantilla
setup_ratings_oath
setup_ratings_quality_plantilla
setup_ratings_timeliness_servicecards
setup_sccess_indctor
set_up_company
sheet2$
sheet3$
shop_rate
signatory_logs
signatory_portal
skill_setup
sms_config
sms_text
special_holiday
sss_gsis
sss_loan
sss_loan_details
sss_setup
subject
sworn_assets
sworn_assetsb
sworn_businessinterest
sworn_liabilities
sworn_relatives
sworn_signatory
sworn_table
sworn_unmarried
task
tbl_achievement_record_new
tbl_active
tbl_adjustment
tbl_age_gap
tbl_alowance_setup
tbl_applicantrating_1stlevela1
tbl_applicantrating_1stlevela1_4
tbl_applicantrating_1stlevelb2
tbl_applicantrating_1stlevelb2_dtl
tbl_applicantrating_2ndlevela1
tbl_applicantrating_2ndlevela1_dtl
tbl_applicantrating_2ndlevelb2
tbl_applicantrating_2ndlevelb2_dtl
tbl_attachedfile
tbl_audit_trail
tbl_bill_ref
tbl_category_position
tbl_certificateoffinalaction_grievance
tbl_checklist_area
tbl_comparative
tbl_complaint
tbl_computation_night_diff
tbl_computation_normal_days
tbl_computation_overtime
tbl_correction
tbl_correction_detail
tbl_count
tbl_covered_days
tbl_credit_dtl
tbl_csecarreerservice
tbl_ctoentry_dtl
tbl_ctoentry_main
tbl_cto_balance
tbl_cto_balance_dtl
tbl_date
tbl_dayname
tbl_day_sked
tbl_deductions
tbl_deductions_dtl
tbl_deduction_dtl
tbl_documents_attached
tbl_drugtestplace_setup
tbl_dtr1
tbl_dtr_incident_report
tbl_dtr_incident_report_deduction
tbl_dtr_incomplete_logs
tbl_dtr_jo
tbl_dtr_jo_01_03
tbl_dtr_jo_01052022
tbl_dtr_jo_2021
tbl_dtr_locked_status
tbl_dtr_old
tbl_dtr_old_jo
tbl_dtr_temp
tbl_dtr_temp_batch
tbl_dtr_temp_bkp
tbl_dtr_temp_jo
tbl_elective_employee_other_information_new
tbl_email
tbl_employee_period
tbl_emp_passlip
tbl_emp_passlip1
tbl_emp_passlipxxxxxxxxxxxxxx
tbl_emp_payroll_salary
tbl_emp_restday
tbl_emp_sequencer
tbl_emp_service_record
tbl_events
tbl_events_offices
tbl_excel
tbl_fields
tbl_final_appointment
tbl_flagceremonyattendance
tbl_general_settings
tbl_generation_setup
tbl_gratuity
tbl_gratuity_dtl
tbl_grievance
tbl_grievance_agreement
tbl_gsis
tbl_hours_sked
tbl_hr_group_ipcr
tbl_hr_ipcr_detail
tbl_hr_ipcr_main
tbl_hr_ipcr_rating_scale
tbl_hr_profile_ipcr
tbl_hr_setup_ipcr
tbl_humanresourcegroup_ipcr
tbl_humanresourceipcr_detail
tbl_humanresourceipcr_main
tbl_humanresourceprofile_ipcr
tbl_humanresourcesetup_ipcr
tbl_incident_report_administrative
tbl_individual_dev_plan
tbl_individual_dev_plan_dtl
tbl_individual_dev_plan_dtl1
tbl_itinerary
tbl_leaves
tbl_leaves_dtl
tbl_leave_count
tbl_leave_credits
tbl_level
tbl_level_csc
tbl_level_position
tbl_logs
tbl_manpowerrequest
tbl_minutes_sked
tbl_missing_attendance
tbl_month
tbl_multiple_department
tbl_officeorder
tbl_official_business
tbl_official_business_dtl
tbl_order_personnel
tbl_overtime
tbl_overtime_category
tbl_overtime_cert
tbl_overtime_cert_dtl
tbl_overtime_copy
tbl_overtime_dtl
tbl_overtime_dtl_copy
tbl_overtime_memo
tbl_overtime_rate
tbl_paygroup_setup
tbl_payrollchange_dtl
tbl_payrollchange_main
tbl_payrollmaker
tbl_payroll_adjustment
tbl_payroll_allowances
tbl_payroll_ca_loans
tbl_payroll_contributions
tbl_payroll_general
tbl_payroll_logs_computation
tbl_payroll_main
tbl_payroll_main_copy
tbl_payroll_other_deductions
tbl_payrol_period
tbl_penaltytype
tbl_personnelschedule
tbl_personnelschedule_dtls
tbl_philhealth
tbl_pic
tbl_plantilla_personnel
tbl_plantilla_personnel_csc
tbl_plantilla_personnel_csc_new
tbl_plantilla_personnel_csc_new_1
tbl_plantilla_personnel_csc_new_2
tbl_plantilla_personnel_csc_new_3
tbl_plantilla_personnel_csc_new_4
tbl_plantilla_personnel_csc_new_5
tbl_position_category
tbl_position_desc
tbl_position_desc_detail
tbl_premium_setup
tbl_question
tbl_questionnaire_documents_attached
tbl_questions_dtl
tbl_rate
tbl_recruitment_checklist
tbl_recruitment_checklist_dtl
tbl_recruitment_detail
tbl_recruitment_group
tbl_recruitment_group_preliminary
tbl_recruitment_logs
tbl_recruitment_main
tbl_regularazation_sched
tbl_restday
tbl_salary_grade
tbl_salary_grade_bkp
tbl_salary_grade_copy1
tbl_salary_grade_old
tbl_salary_grade_rhu
tbl_service_record_dtl
tbl_service_record_dtl_bkp
tbl_service_record_issuance
tbl_service_record_main
tbl_service_record_main_bkp
tbl_service_record_new
tbl_service_record_new12-21-23
tbl_service_record_new_06-06-2023
tbl_service_record_new_bkp
tbl_service_record_new_main
tbl_setup_ipcr_data
tbl_shortlistedselection
tbl_short_listed
tbl_srorinput
tbl_sss
tbl_temp_dtr_list
tbl_timeshift_setup_main
tbl_timeshift_setup_main_copy
tbl_trainingneeds
tbl_trainingneeds_dtl
tbl_training_course
tbl_training_course_dtl
tbl_training_months
tbl_training_registration
tbl_user_restrictions
tbl_vacant_detail_info
tbl_vacant_pos
tbl_vacant_pos_group
tb_appointment_checklist
termination_details
timecard_summary
timecard_summary_permanent
timesheet
timesheet_jo
timeshiftdept
time_allowance
time_logs_history
time_sheet
tmp_employees_civilserviceeligibility
tmp_employees_eduback
tmp_employees_familybackground
tmp_employees_otherinfos
tmp_employees_reference
tmp_employees_skillshobbies
tmp_employees_trainingprogram
tmp_employees_voluntarilywork
tmp_employees_workexperience
tmp_generate_dtr_printing
tmp_olddtr_mig
training_attendees
training_details
training_requirements
training_schedule
training_schedule_dtls
training_setup
transaction_log
travel_order
utilitybill
utility_billing
utility_billing_rate_ed
utility_billing_rate_water
utility_bill_profile
web_dispatch_delay
web_dispatch_main
web_dispatch_standby
web_users
withdraw_details
withdraw_main
withholding_setup
working_hours
work_group
_aversiontime
_hr_dynamic_setup
_hr_dynamic_setup_client
_login_type
_tbl_acceptance_resignation
_tbl_exit_clearance
_tbl_exit_clearance_details
_tbl_exit_interview
_tbl_performance_evaluation
_tbl_performance_evaluation_detail
_tbl_performance_ratings
_tbl_promotion
_tbl_regular_appointment
_tbl_release_waiver
_tbl_standard_definition
_template
.
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
accounting_setup
acctg_action
activation_status
adjustment_entry
agendasetup
allowances
allowances_entry
allowances_fixed
allowances_jo
applicants
applicant_skills
application_ot
appointmentdocument
appointmentparticipant
appointments
approved_email_logs
approved_employee_ot
approved_ot
bank_setup
barangay
billing
bio_employees
bplo_attatchment
budget_controller
budget_controller_jo
caldays
calendar
cao_business_list
cao_business_list_main
cashadvacewalkin
cashliquidation
cashliquidation_detail
cash_advances
cash_advances_details
cash_advance_payed
clearance_attachments
clearance_comment
committeecreatedminutes
committeemembers
committeeminutetemplates
committees
committee_agenda
committee_attachmentlinks
committee_attendees
cto_rpt_payments_advance
currency
dash_assistance_survey
dash_assistance_survey_setup
dash_rating
deduction
deductions_status_employee
deductionto_atm_amount
deductiontype
deduction_details
deduction_pause
deduction_schedule
department
department_division
department_pmd
department_pmdbkp
department_shift
developer
disbursement
disbursement_dtls
division
division_setup
dmmy
drivers_equipment
dtr
dtr_approved_head
dtr_approved_head_setup
dtr_approved_payrollmaker
dtr_rules_setup
dummy_date
dummy_employee
dummy_t
duplicate_history
ebplo_other_certificates_form
ebplo_other_certificates_type
ecswd_travel_order
ecswd_travel_order_dtail
ecswd_travel_order_purpose
employeedepartment
employees
employees_allowances
employees_assignment
employees_bkp
employees_change_timeshift
employees_civilserviceeligibility
employees_copy
employees_copy_copy
employees_dependent
employees_designation_history
employees_eduback
employees_familybackground
employees_history
employees_leave_credits
employees_limit
employees_otherinfos
employees_position
employees_premiums
employees_rate
employees_rate_bkp
employees_reference
employees_section
employees_skillshobbies
employees_timeshift
employees_timeshift_copy
employees_trainingprogram
employees_trainingprogram1
employees_voluntarilywork
employees_workexperience
employees_work_history_ledger
employee_attachment
employee_attachments
employee_blocked
employee_blocked_byhr
employee_bloodtype
employee_clearance
employee_deduction_status
employee_eduback
employee_hiring_entity
employee_information
employee_information1
employee_information2
employee_information3
employee_information4
employee_information5
employee_informationupdated
employee_medicalreport
employee_medical_laboratoryresult
employee_medical_pastillness
employee_medical_pe_findings
employee_medical_physicalexamination
employee_medical_status
employee_otherinfo
employee_profile_pic
employee_references
employee_sal_type
employee_signatory
employee_skills
employee_skillsandreference
employee_skillset
employee_status
employee_type
employee_workexperience
emp_service_record
emp_transfer_dept_history
emp_transfer_dept_history_detail
equip
eventcalendarrange
finger_logs
fixed_other_allowances
gender
groups
history_active_inactive
history_blocked_byhr
history_position
hr_action
hr_ara_form_a
hr_ara_form_d
hr_ara_form_e
hr_ara_form_e_setup
hr_biometric_logs
hr_biometric_logs_dummy
hr_biometric_logs_history
hr_biometric_logs_history_transcient
hr_biometric_logs_transcient
hr_biometric_terminal
hr_biometric_user_data
hr_biometric_user_info
hr_certificate_data
hr_certificate_data_details
hr_certificate_setup
hr_certificate_table_template
hr_cert_of_appearance
hr_committee_agenda
hr_committee_agenda_attendee
hr_committee_metting
hr_committee_metting_attendance
hr_committee_resolution
hr_committee_setup
hr_committee_setup_member
hr_employee
hr_emp_afingerprint
hr_emp_assigning_projectsite
hr_emp_attendance
hr_emp_attendance_copy
hr_emp_attendance_jo
hr_emp_attendance_manualentry
hr_emp_attendance_othersite
hr_emp_empltype
hr_emp_leaves
hr_emp_leave_accumulatation
hr_emp_leave_accumulatation_history
hr_emp_leave_accumulate_ranz
hr_emp_leave_credits
hr_emp_leave_type
hr_emp_private_leavecredit
hr_emp_projectsite
hr_emp_service_records
hr_emp_shift
hr_holidays
hr_holidays_special
hr_job_status
hr_leave_type
hr_person_dependents
hr_person_educational_bg
hr_person_eligibility
hr_person_family_bg
hr_person_other_info
hr_person_profile
hr_person_reference
hr_person_skills
hr_person_training
hr_person_voluntary_work
hr_person_work_exp
hr_tbl_best_department
hr_tbl_best_employee
hr_tbl_clearance
hr_tbl_computation_amnt_setup
hr_tbl_computation_terminal_leave
hr_tbl_drugselectionlist
hr_tbl_emp_update_logs
hr_tbl_exit_interview
hr_tbl_increment_sched
hr_tbl_loyalty_bonus
hr_tbl_loyalty_setup
hr_tbl_memos_and_violations_dtl
hr_tbl_memos_and_violations_main
hr_tbl_offenses
hr_tbl_offenses_type
hr_tbl_offense_category
hr_tbl_organizational_setup
hr_tbl_perfect_attendance
hr_tbl_pre_retirement
hr_tbl_rating_setup
hr_tbl_rating_setup_details
hr_tbl_retirement_setup
hr_tbl_retire_separate_logs
hr_tbl_salary_adjustment
hr_tbl_salary_adjustment_bkp
hr_tbl_salary_adjustment_copy
hr_tbl_section_setup
hr_tbl_separation
hr_tbl_setup_rated
ielts_detail
inactive_active_history
incentives
incident_report
individualpass
irregular_shift
it_action
job_position_rate_setup
job_position_setup
late_cutoff_setup
log
login_attempts
mandatoryattendance
manpower_request
mm_action
myitems
nickname
office_location
offsetted_trans_record
onboarding_checklist_entry
on_boarding_checklist_setup
organizational_chart
originating_action
otherdeductions
otherdeductionsentry_details
otherdeductionsentry_main
otherdeductions_jo
otherdeduction_balances
other_addons
other_deduction
overtime_request
pagibig_loan
pagibig_loan_details
pagibig_setup
pakyaw_itemsetupp
paygroup_setup
payroll_computation
payroll_deduction_history
payroll_maker
payroll_rate
payslip
payslip2
payslip_allowance
payslip_allowance_jo
payslip_copy
payslip_details
payslip_details_jo
payslip_dole
payslip_dtr
payslip_jo
payslip_jo_holiday
payslip_jo_overtime
payslip_pagibig
payslip_pakyaw
payslip_pakyaw_detail
payslip_pertrip
payslip_sss
philhealth_setup
po
position
previous_basicpay
program_title
projects
project_list
project_title
raffle_name
raffle_name_copy
raffle_position
raffle_price
raffle_winner
ranz_tbl_flagceremony
repairform_setup
reports
requirement_setup
resources
restday_request
restday_request_permanent
rfcs_detail
rfcs_detail_breakdown
rfcs_main
salary_grade
setup_biometric
setup_biometric_privilege
setup_corefnctiongroup
setup_mfopap
setup_project
setup_ratings_efficiency_plantilla
setup_ratings_oath
setup_ratings_quality_plantilla
setup_ratings_timeliness_servicecards
setup_sccess_indctor
set_up_company
sheet2$
sheet3$
shop_rate
signatory_logs
signatory_portal
skill_setup
sms_config
sms_text
special_holiday
sss_gsis
sss_loan
sss_loan_details
sss_setup
subject
sworn_assets
sworn_assetsb
sworn_businessinterest
sworn_liabilities
sworn_relatives
sworn_signatory
sworn_table
sworn_unmarried
task
tbl_achievement_record_new
tbl_active
tbl_adjustment
tbl_age_gap
tbl_alowance_setup
tbl_applicantrating_1stlevela1
tbl_applicantrating_1stlevela1_4
tbl_applicantrating_1stlevelb2
tbl_applicantrating_1stlevelb2_dtl
tbl_applicantrating_2ndlevela1
tbl_applicantrating_2ndlevela1_dtl
tbl_applicantrating_2ndlevelb2
tbl_applicantrating_2ndlevelb2_dtl
tbl_attachedfile
tbl_audit_trail
tbl_bill_ref
tbl_category_position
tbl_certificateoffinalaction_grievance
tbl_checklist_area
tbl_comparative
tbl_complaint
tbl_computation_night_diff
tbl_computation_normal_days
tbl_computation_overtime
tbl_correction
tbl_correction_detail
tbl_count
tbl_covered_days
tbl_credit_dtl
tbl_csecarreerservice
tbl_ctoentry_dtl
tbl_ctoentry_main
tbl_cto_balance
tbl_cto_balance_dtl
tbl_date
tbl_dayname
tbl_day_sked
tbl_deductions
tbl_deductions_dtl
tbl_deduction_dtl
tbl_documents_attached
tbl_drugtestplace_setup
tbl_dtr1
tbl_dtr_incident_report
tbl_dtr_incident_report_deduction
tbl_dtr_incomplete_logs
tbl_dtr_jo
tbl_dtr_jo_01_03
tbl_dtr_jo_01052022
tbl_dtr_jo_2021
tbl_dtr_locked_status
tbl_dtr_old
tbl_dtr_old_jo
tbl_dtr_temp
tbl_dtr_temp_batch
tbl_dtr_temp_bkp
tbl_dtr_temp_jo
tbl_elective_employee_other_information_new
tbl_email
tbl_employee_period
tbl_emp_passlip
tbl_emp_passlip1
tbl_emp_passlipxxxxxxxxxxxxxx
tbl_emp_payroll_salary
tbl_emp_restday
tbl_emp_sequencer
tbl_emp_service_record
tbl_events
tbl_events_offices
tbl_excel
tbl_fields
tbl_final_appointment
tbl_flagceremonyattendance
tbl_general_settings
tbl_generation_setup
tbl_gratuity
tbl_gratuity_dtl
tbl_grievance
tbl_grievance_agreement
tbl_gsis
tbl_hours_sked
tbl_hr_group_ipcr
tbl_hr_ipcr_detail
tbl_hr_ipcr_main
tbl_hr_ipcr_rating_scale
tbl_hr_profile_ipcr
tbl_hr_setup_ipcr
tbl_humanresourcegroup_ipcr
tbl_humanresourceipcr_detail
tbl_humanresourceipcr_main
tbl_humanresourceprofile_ipcr
tbl_humanresourcesetup_ipcr
tbl_incident_report_administrative
tbl_individual_dev_plan
tbl_individual_dev_plan_dtl
tbl_individual_dev_plan_dtl1
tbl_itinerary
tbl_leaves
tbl_leaves_dtl
tbl_leave_count
tbl_leave_credits
tbl_level
tbl_level_csc
tbl_level_position
tbl_logs
tbl_manpowerrequest
tbl_minutes_sked
tbl_missing_attendance
tbl_month
tbl_multiple_department
tbl_officeorder
tbl_official_business
tbl_official_business_dtl
tbl_order_personnel
tbl_overtime
tbl_overtime_category
tbl_overtime_cert
tbl_overtime_cert_dtl
tbl_overtime_copy
tbl_overtime_dtl
tbl_overtime_dtl_copy
tbl_overtime_memo
tbl_overtime_rate
tbl_paygroup_setup
tbl_payrollchange_dtl
tbl_payrollchange_main
tbl_payrollmaker
tbl_payroll_adjustment
tbl_payroll_allowances
tbl_payroll_ca_loans
tbl_payroll_contributions
tbl_payroll_general
tbl_payroll_logs_computation
tbl_payroll_main
tbl_payroll_main_copy
tbl_payroll_other_deductions
tbl_payrol_period
tbl_penaltytype
tbl_personnelschedule
tbl_personnelschedule_dtls
tbl_philhealth
tbl_pic
tbl_plantilla_personnel
tbl_plantilla_personnel_csc
tbl_plantilla_personnel_csc_new
tbl_plantilla_personnel_csc_new_1
tbl_plantilla_personnel_csc_new_2
tbl_plantilla_personnel_csc_new_3
tbl_plantilla_personnel_csc_new_4
tbl_plantilla_personnel_csc_new_5
tbl_position_category
tbl_position_desc
tbl_position_desc_detail
tbl_premium_setup
tbl_question
tbl_questionnaire_documents_attached
tbl_questions_dtl
tbl_rate
tbl_recruitment_checklist
tbl_recruitment_checklist_dtl
tbl_recruitment_detail
tbl_recruitment_group
tbl_recruitment_group_preliminary
tbl_recruitment_logs
tbl_recruitment_main
tbl_regularazation_sched
tbl_restday
tbl_salary_grade
tbl_salary_grade_bkp
tbl_salary_grade_copy1
tbl_salary_grade_old
tbl_salary_grade_rhu
tbl_service_record_dtl
tbl_service_record_dtl_bkp
tbl_service_record_issuance
tbl_service_record_main
tbl_service_record_main_bkp
tbl_service_record_new
tbl_service_record_new12-21-23
tbl_service_record_new_06-06-2023
tbl_service_record_new_bkp
tbl_service_record_new_main
tbl_setup_ipcr_data
tbl_shortlistedselection
tbl_short_listed
tbl_srorinput
tbl_sss
tbl_temp_dtr_list
tbl_timeshift_setup_main
tbl_timeshift_setup_main_copy
tbl_trainingneeds
tbl_trainingneeds_dtl
tbl_training_course
tbl_training_course_dtl
tbl_training_months
tbl_training_registration
tbl_user_restrictions
tbl_vacant_detail_info
tbl_vacant_pos
tbl_vacant_pos_group
tb_appointment_checklist
termination_details
timecard_summary
timecard_summary_permanent
timesheet
timesheet_jo
timeshiftdept
time_allowance
time_logs_history
time_sheet
tmp_employees_civilserviceeligibility
tmp_employees_eduback
tmp_employees_familybackground
tmp_employees_otherinfos
tmp_employees_reference
tmp_employees_skillshobbies
tmp_employees_trainingprogram
tmp_employees_voluntarilywork
tmp_employees_workexperience
tmp_generate_dtr_printing
tmp_olddtr_mig
training_attendees
training_details
training_requirements
training_schedule
training_schedule_dtls
training_setup
transaction_log
travel_order
utilitybill
utility_billing
utility_billing_rate_ed
utility_billing_rate_water
utility_bill_profile
web_dispatch_delay
web_dispatch_main
web_dispatch_standby
web_users
withdraw_details
withdraw_main
withholding_setup
working_hours
work_group
_aversiontime
_hr_dynamic_setup
_hr_dynamic_setup_client
_login_type
_tbl_acceptance_resignation
_tbl_exit_clearance
_tbl_exit_clearance_details
_tbl_exit_interview
_tbl_performance_evaluation
_tbl_performance_evaluation_detail
_tbl_performance_ratings
_tbl_promotion
_tbl_regular_appointment
_tbl_release_waiver
_tbl_standard_definition
_template
.
select column
select table
accounting_setup
acctg_action
activation_status
adjustment_entry
agendasetup
allowances
allowances_entry
allowances_fixed
allowances_jo
applicants
applicant_skills
application_ot
appointmentdocument
appointmentparticipant
appointments
approved_email_logs
approved_employee_ot
approved_ot
bank_setup
barangay
billing
bio_employees
bplo_attatchment
budget_controller
budget_controller_jo
caldays
calendar
cao_business_list
cao_business_list_main
cashadvacewalkin
cashliquidation
cashliquidation_detail
cash_advances
cash_advances_details
cash_advance_payed
clearance_attachments
clearance_comment
committeecreatedminutes
committeemembers
committeeminutetemplates
committees
committee_agenda
committee_attachmentlinks
committee_attendees
cto_rpt_payments_advance
currency
dash_assistance_survey
dash_assistance_survey_setup
dash_rating
deduction
deductions_status_employee
deductionto_atm_amount
deductiontype
deduction_details
deduction_pause
deduction_schedule
department
department_division
department_pmd
department_pmdbkp
department_shift
developer
disbursement
disbursement_dtls
division
division_setup
dmmy
drivers_equipment
dtr
dtr_approved_head
dtr_approved_head_setup
dtr_approved_payrollmaker
dtr_rules_setup
dummy_date
dummy_employee
dummy_t
duplicate_history
ebplo_other_certificates_form
ebplo_other_certificates_type
ecswd_travel_order
ecswd_travel_order_dtail
ecswd_travel_order_purpose
employeedepartment
employees
employees_allowances
employees_assignment
employees_bkp
employees_change_timeshift
employees_civilserviceeligibility
employees_copy
employees_copy_copy
employees_dependent
employees_designation_history
employees_eduback
employees_familybackground
employees_history
employees_leave_credits
employees_limit
employees_otherinfos
employees_position
employees_premiums
employees_rate
employees_rate_bkp
employees_reference
employees_section
employees_skillshobbies
employees_timeshift
employees_timeshift_copy
employees_trainingprogram
employees_trainingprogram1
employees_voluntarilywork
employees_workexperience
employees_work_history_ledger
employee_attachment
employee_attachments
employee_blocked
employee_blocked_byhr
employee_bloodtype
employee_clearance
employee_deduction_status
employee_eduback
employee_hiring_entity
employee_information
employee_information1
employee_information2
employee_information3
employee_information4
employee_information5
employee_informationupdated
employee_medicalreport
employee_medical_laboratoryresult
employee_medical_pastillness
employee_medical_pe_findings
employee_medical_physicalexamination
employee_medical_status
employee_otherinfo
employee_profile_pic
employee_references
employee_sal_type
employee_signatory
employee_skills
employee_skillsandreference
employee_skillset
employee_status
employee_type
employee_workexperience
emp_service_record
emp_transfer_dept_history
emp_transfer_dept_history_detail
equip
eventcalendarrange
finger_logs
fixed_other_allowances
gender
groups
history_active_inactive
history_blocked_byhr
history_position
hr_action
hr_ara_form_a
hr_ara_form_d
hr_ara_form_e
hr_ara_form_e_setup
hr_biometric_logs
hr_biometric_logs_dummy
hr_biometric_logs_history
hr_biometric_logs_history_transcient
hr_biometric_logs_transcient
hr_biometric_terminal
hr_biometric_user_data
hr_biometric_user_info
hr_certificate_data
hr_certificate_data_details
hr_certificate_setup
hr_certificate_table_template
hr_cert_of_appearance
hr_committee_agenda
hr_committee_agenda_attendee
hr_committee_metting
hr_committee_metting_attendance
hr_committee_resolution
hr_committee_setup
hr_committee_setup_member
hr_employee
hr_emp_afingerprint
hr_emp_assigning_projectsite
hr_emp_attendance
hr_emp_attendance_copy
hr_emp_attendance_jo
hr_emp_attendance_manualentry
hr_emp_attendance_othersite
hr_emp_empltype
hr_emp_leaves
hr_emp_leave_accumulatation
hr_emp_leave_accumulatation_history
hr_emp_leave_accumulate_ranz
hr_emp_leave_credits
hr_emp_leave_type
hr_emp_private_leavecredit
hr_emp_projectsite
hr_emp_service_records
hr_emp_shift
hr_holidays
hr_holidays_special
hr_job_status
hr_leave_type
hr_person_dependents
hr_person_educational_bg
hr_person_eligibility
hr_person_family_bg
hr_person_other_info
hr_person_profile
hr_person_reference
hr_person_skills
hr_person_training
hr_person_voluntary_work
hr_person_work_exp
hr_tbl_best_department
hr_tbl_best_employee
hr_tbl_clearance
hr_tbl_computation_amnt_setup
hr_tbl_computation_terminal_leave
hr_tbl_drugselectionlist
hr_tbl_emp_update_logs
hr_tbl_exit_interview
hr_tbl_increment_sched
hr_tbl_loyalty_bonus
hr_tbl_loyalty_setup
hr_tbl_memos_and_violations_dtl
hr_tbl_memos_and_violations_main
hr_tbl_offenses
hr_tbl_offenses_type
hr_tbl_offense_category
hr_tbl_organizational_setup
hr_tbl_perfect_attendance
hr_tbl_pre_retirement
hr_tbl_rating_setup
hr_tbl_rating_setup_details
hr_tbl_retirement_setup
hr_tbl_retire_separate_logs
hr_tbl_salary_adjustment
hr_tbl_salary_adjustment_bkp
hr_tbl_salary_adjustment_copy
hr_tbl_section_setup
hr_tbl_separation
hr_tbl_setup_rated
ielts_detail
inactive_active_history
incentives
incident_report
individualpass
irregular_shift
it_action
job_position_rate_setup
job_position_setup
late_cutoff_setup
log
login_attempts
mandatoryattendance
manpower_request
mm_action
myitems
nickname
office_location
offsetted_trans_record
onboarding_checklist_entry
on_boarding_checklist_setup
organizational_chart
originating_action
otherdeductions
otherdeductionsentry_details
otherdeductionsentry_main
otherdeductions_jo
otherdeduction_balances
other_addons
other_deduction
overtime_request
pagibig_loan
pagibig_loan_details
pagibig_setup
pakyaw_itemsetupp
paygroup_setup
payroll_computation
payroll_deduction_history
payroll_maker
payroll_rate
payslip
payslip2
payslip_allowance
payslip_allowance_jo
payslip_copy
payslip_details
payslip_details_jo
payslip_dole
payslip_dtr
payslip_jo
payslip_jo_holiday
payslip_jo_overtime
payslip_pagibig
payslip_pakyaw
payslip_pakyaw_detail
payslip_pertrip
payslip_sss
philhealth_setup
po
position
previous_basicpay
program_title
projects
project_list
project_title
raffle_name
raffle_name_copy
raffle_position
raffle_price
raffle_winner
ranz_tbl_flagceremony
repairform_setup
reports
requirement_setup
resources
restday_request
restday_request_permanent
rfcs_detail
rfcs_detail_breakdown
rfcs_main
salary_grade
setup_biometric
setup_biometric_privilege
setup_corefnctiongroup
setup_mfopap
setup_project
setup_ratings_efficiency_plantilla
setup_ratings_oath
setup_ratings_quality_plantilla
setup_ratings_timeliness_servicecards
setup_sccess_indctor
set_up_company
sheet2$
sheet3$
shop_rate
signatory_logs
signatory_portal
skill_setup
sms_config
sms_text
special_holiday
sss_gsis
sss_loan
sss_loan_details
sss_setup
subject
sworn_assets
sworn_assetsb
sworn_businessinterest
sworn_liabilities
sworn_relatives
sworn_signatory
sworn_table
sworn_unmarried
task
tbl_achievement_record_new
tbl_active
tbl_adjustment
tbl_age_gap
tbl_alowance_setup
tbl_applicantrating_1stlevela1
tbl_applicantrating_1stlevela1_4
tbl_applicantrating_1stlevelb2
tbl_applicantrating_1stlevelb2_dtl
tbl_applicantrating_2ndlevela1
tbl_applicantrating_2ndlevela1_dtl
tbl_applicantrating_2ndlevelb2
tbl_applicantrating_2ndlevelb2_dtl
tbl_attachedfile
tbl_audit_trail
tbl_bill_ref
tbl_category_position
tbl_certificateoffinalaction_grievance
tbl_checklist_area
tbl_comparative
tbl_complaint
tbl_computation_night_diff
tbl_computation_normal_days
tbl_computation_overtime
tbl_correction
tbl_correction_detail
tbl_count
tbl_covered_days
tbl_credit_dtl
tbl_csecarreerservice
tbl_ctoentry_dtl
tbl_ctoentry_main
tbl_cto_balance
tbl_cto_balance_dtl
tbl_date
tbl_dayname
tbl_day_sked
tbl_deductions
tbl_deductions_dtl
tbl_deduction_dtl
tbl_documents_attached
tbl_drugtestplace_setup
tbl_dtr1
tbl_dtr_incident_report
tbl_dtr_incident_report_deduction
tbl_dtr_incomplete_logs
tbl_dtr_jo
tbl_dtr_jo_01_03
tbl_dtr_jo_01052022
tbl_dtr_jo_2021
tbl_dtr_locked_status
tbl_dtr_old
tbl_dtr_old_jo
tbl_dtr_temp
tbl_dtr_temp_batch
tbl_dtr_temp_bkp
tbl_dtr_temp_jo
tbl_elective_employee_other_information_new
tbl_email
tbl_employee_period
tbl_emp_passlip
tbl_emp_passlip1
tbl_emp_passlipxxxxxxxxxxxxxx
tbl_emp_payroll_salary
tbl_emp_restday
tbl_emp_sequencer
tbl_emp_service_record
tbl_events
tbl_events_offices
tbl_excel
tbl_fields
tbl_final_appointment
tbl_flagceremonyattendance
tbl_general_settings
tbl_generation_setup
tbl_gratuity
tbl_gratuity_dtl
tbl_grievance
tbl_grievance_agreement
tbl_gsis
tbl_hours_sked
tbl_hr_group_ipcr
tbl_hr_ipcr_detail
tbl_hr_ipcr_main
tbl_hr_ipcr_rating_scale
tbl_hr_profile_ipcr
tbl_hr_setup_ipcr
tbl_humanresourcegroup_ipcr
tbl_humanresourceipcr_detail
tbl_humanresourceipcr_main
tbl_humanresourceprofile_ipcr
tbl_humanresourcesetup_ipcr
tbl_incident_report_administrative
tbl_individual_dev_plan
tbl_individual_dev_plan_dtl
tbl_individual_dev_plan_dtl1
tbl_itinerary
tbl_leaves
tbl_leaves_dtl
tbl_leave_count
tbl_leave_credits
tbl_level
tbl_level_csc
tbl_level_position
tbl_logs
tbl_manpowerrequest
tbl_minutes_sked
tbl_missing_attendance
tbl_month
tbl_multiple_department
tbl_officeorder
tbl_official_business
tbl_official_business_dtl
tbl_order_personnel
tbl_overtime
tbl_overtime_category
tbl_overtime_cert
tbl_overtime_cert_dtl
tbl_overtime_copy
tbl_overtime_dtl
tbl_overtime_dtl_copy
tbl_overtime_memo
tbl_overtime_rate
tbl_paygroup_setup
tbl_payrollchange_dtl
tbl_payrollchange_main
tbl_payrollmaker
tbl_payroll_adjustment
tbl_payroll_allowances
tbl_payroll_ca_loans
tbl_payroll_contributions
tbl_payroll_general
tbl_payroll_logs_computation
tbl_payroll_main
tbl_payroll_main_copy
tbl_payroll_other_deductions
tbl_payrol_period
tbl_penaltytype
tbl_personnelschedule
tbl_personnelschedule_dtls
tbl_philhealth
tbl_pic
tbl_plantilla_personnel
tbl_plantilla_personnel_csc
tbl_plantilla_personnel_csc_new
tbl_plantilla_personnel_csc_new_1
tbl_plantilla_personnel_csc_new_2
tbl_plantilla_personnel_csc_new_3
tbl_plantilla_personnel_csc_new_4
tbl_plantilla_personnel_csc_new_5
tbl_position_category
tbl_position_desc
tbl_position_desc_detail
tbl_premium_setup
tbl_question
tbl_questionnaire_documents_attached
tbl_questions_dtl
tbl_rate
tbl_recruitment_checklist
tbl_recruitment_checklist_dtl
tbl_recruitment_detail
tbl_recruitment_group
tbl_recruitment_group_preliminary
tbl_recruitment_logs
tbl_recruitment_main
tbl_regularazation_sched
tbl_restday
tbl_salary_grade
tbl_salary_grade_bkp
tbl_salary_grade_copy1
tbl_salary_grade_old
tbl_salary_grade_rhu
tbl_service_record_dtl
tbl_service_record_dtl_bkp
tbl_service_record_issuance
tbl_service_record_main
tbl_service_record_main_bkp
tbl_service_record_new
tbl_service_record_new12-21-23
tbl_service_record_new_06-06-2023
tbl_service_record_new_bkp
tbl_service_record_new_main
tbl_setup_ipcr_data
tbl_shortlistedselection
tbl_short_listed
tbl_srorinput
tbl_sss
tbl_temp_dtr_list
tbl_timeshift_setup_main
tbl_timeshift_setup_main_copy
tbl_trainingneeds
tbl_trainingneeds_dtl
tbl_training_course
tbl_training_course_dtl
tbl_training_months
tbl_training_registration
tbl_user_restrictions
tbl_vacant_detail_info
tbl_vacant_pos
tbl_vacant_pos_group
tb_appointment_checklist
termination_details
timecard_summary
timecard_summary_permanent
timesheet
timesheet_jo
timeshiftdept
time_allowance
time_logs_history
time_sheet
tmp_employees_civilserviceeligibility
tmp_employees_eduback
tmp_employees_familybackground
tmp_employees_otherinfos
tmp_employees_reference
tmp_employees_skillshobbies
tmp_employees_trainingprogram
tmp_employees_voluntarilywork
tmp_employees_workexperience
tmp_generate_dtr_printing
tmp_olddtr_mig
training_attendees
training_details
training_requirements
training_schedule
training_schedule_dtls
training_setup
transaction_log
travel_order
utilitybill
utility_billing
utility_billing_rate_ed
utility_billing_rate_water
utility_bill_profile
web_dispatch_delay
web_dispatch_main
web_dispatch_standby
web_users
withdraw_details
withdraw_main
withholding_setup
working_hours
work_group
_aversiontime
_hr_dynamic_setup
_hr_dynamic_setup_client
_login_type
_tbl_acceptance_resignation
_tbl_exit_clearance
_tbl_exit_clearance_details
_tbl_exit_interview
_tbl_performance_evaluation
_tbl_performance_evaluation_detail
_tbl_performance_ratings
_tbl_promotion
_tbl_regular_appointment
_tbl_release_waiver
_tbl_standard_definition
_template
.
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
accounting_setup
acctg_action
activation_status
adjustment_entry
agendasetup
allowances
allowances_entry
allowances_fixed
allowances_jo
applicants
applicant_skills
application_ot
appointmentdocument
appointmentparticipant
appointments
approved_email_logs
approved_employee_ot
approved_ot
bank_setup
barangay
billing
bio_employees
bplo_attatchment
budget_controller
budget_controller_jo
caldays
calendar
cao_business_list
cao_business_list_main
cashadvacewalkin
cashliquidation
cashliquidation_detail
cash_advances
cash_advances_details
cash_advance_payed
clearance_attachments
clearance_comment
committeecreatedminutes
committeemembers
committeeminutetemplates
committees
committee_agenda
committee_attachmentlinks
committee_attendees
cto_rpt_payments_advance
currency
dash_assistance_survey
dash_assistance_survey_setup
dash_rating
deduction
deductions_status_employee
deductionto_atm_amount
deductiontype
deduction_details
deduction_pause
deduction_schedule
department
department_division
department_pmd
department_pmdbkp
department_shift
developer
disbursement
disbursement_dtls
division
division_setup
dmmy
drivers_equipment
dtr
dtr_approved_head
dtr_approved_head_setup
dtr_approved_payrollmaker
dtr_rules_setup
dummy_date
dummy_employee
dummy_t
duplicate_history
ebplo_other_certificates_form
ebplo_other_certificates_type
ecswd_travel_order
ecswd_travel_order_dtail
ecswd_travel_order_purpose
employeedepartment
employees
employees_allowances
employees_assignment
employees_bkp
employees_change_timeshift
employees_civilserviceeligibility
employees_copy
employees_copy_copy
employees_dependent
employees_designation_history
employees_eduback
employees_familybackground
employees_history
employees_leave_credits
employees_limit
employees_otherinfos
employees_position
employees_premiums
employees_rate
employees_rate_bkp
employees_reference
employees_section
employees_skillshobbies
employees_timeshift
employees_timeshift_copy
employees_trainingprogram
employees_trainingprogram1
employees_voluntarilywork
employees_workexperience
employees_work_history_ledger
employee_attachment
employee_attachments
employee_blocked
employee_blocked_byhr
employee_bloodtype
employee_clearance
employee_deduction_status
employee_eduback
employee_hiring_entity
employee_information
employee_information1
employee_information2
employee_information3
employee_information4
employee_information5
employee_informationupdated
employee_medicalreport
employee_medical_laboratoryresult
employee_medical_pastillness
employee_medical_pe_findings
employee_medical_physicalexamination
employee_medical_status
employee_otherinfo
employee_profile_pic
employee_references
employee_sal_type
employee_signatory
employee_skills
employee_skillsandreference
employee_skillset
employee_status
employee_type
employee_workexperience
emp_service_record
emp_transfer_dept_history
emp_transfer_dept_history_detail
equip
eventcalendarrange
finger_logs
fixed_other_allowances
gender
groups
history_active_inactive
history_blocked_byhr
history_position
hr_action
hr_ara_form_a
hr_ara_form_d
hr_ara_form_e
hr_ara_form_e_setup
hr_biometric_logs
hr_biometric_logs_dummy
hr_biometric_logs_history
hr_biometric_logs_history_transcient
hr_biometric_logs_transcient
hr_biometric_terminal
hr_biometric_user_data
hr_biometric_user_info
hr_certificate_data
hr_certificate_data_details
hr_certificate_setup
hr_certificate_table_template
hr_cert_of_appearance
hr_committee_agenda
hr_committee_agenda_attendee
hr_committee_metting
hr_committee_metting_attendance
hr_committee_resolution
hr_committee_setup
hr_committee_setup_member
hr_employee
hr_emp_afingerprint
hr_emp_assigning_projectsite
hr_emp_attendance
hr_emp_attendance_copy
hr_emp_attendance_jo
hr_emp_attendance_manualentry
hr_emp_attendance_othersite
hr_emp_empltype
hr_emp_leaves
hr_emp_leave_accumulatation
hr_emp_leave_accumulatation_history
hr_emp_leave_accumulate_ranz
hr_emp_leave_credits
hr_emp_leave_type
hr_emp_private_leavecredit
hr_emp_projectsite
hr_emp_service_records
hr_emp_shift
hr_holidays
hr_holidays_special
hr_job_status
hr_leave_type
hr_person_dependents
hr_person_educational_bg
hr_person_eligibility
hr_person_family_bg
hr_person_other_info
hr_person_profile
hr_person_reference
hr_person_skills
hr_person_training
hr_person_voluntary_work
hr_person_work_exp
hr_tbl_best_department
hr_tbl_best_employee
hr_tbl_clearance
hr_tbl_computation_amnt_setup
hr_tbl_computation_terminal_leave
hr_tbl_drugselectionlist
hr_tbl_emp_update_logs
hr_tbl_exit_interview
hr_tbl_increment_sched
hr_tbl_loyalty_bonus
hr_tbl_loyalty_setup
hr_tbl_memos_and_violations_dtl
hr_tbl_memos_and_violations_main
hr_tbl_offenses
hr_tbl_offenses_type
hr_tbl_offense_category
hr_tbl_organizational_setup
hr_tbl_perfect_attendance
hr_tbl_pre_retirement
hr_tbl_rating_setup
hr_tbl_rating_setup_details
hr_tbl_retirement_setup
hr_tbl_retire_separate_logs
hr_tbl_salary_adjustment
hr_tbl_salary_adjustment_bkp
hr_tbl_salary_adjustment_copy
hr_tbl_section_setup
hr_tbl_separation
hr_tbl_setup_rated
ielts_detail
inactive_active_history
incentives
incident_report
individualpass
irregular_shift
it_action
job_position_rate_setup
job_position_setup
late_cutoff_setup
log
login_attempts
mandatoryattendance
manpower_request
mm_action
myitems
nickname
office_location
offsetted_trans_record
onboarding_checklist_entry
on_boarding_checklist_setup
organizational_chart
originating_action
otherdeductions
otherdeductionsentry_details
otherdeductionsentry_main
otherdeductions_jo
otherdeduction_balances
other_addons
other_deduction
overtime_request
pagibig_loan
pagibig_loan_details
pagibig_setup
pakyaw_itemsetupp
paygroup_setup
payroll_computation
payroll_deduction_history
payroll_maker
payroll_rate
payslip
payslip2
payslip_allowance
payslip_allowance_jo
payslip_copy
payslip_details
payslip_details_jo
payslip_dole
payslip_dtr
payslip_jo
payslip_jo_holiday
payslip_jo_overtime
payslip_pagibig
payslip_pakyaw
payslip_pakyaw_detail
payslip_pertrip
payslip_sss
philhealth_setup
po
position
previous_basicpay
program_title
projects
project_list
project_title
raffle_name
raffle_name_copy
raffle_position
raffle_price
raffle_winner
ranz_tbl_flagceremony
repairform_setup
reports
requirement_setup
resources
restday_request
restday_request_permanent
rfcs_detail
rfcs_detail_breakdown
rfcs_main
salary_grade
setup_biometric
setup_biometric_privilege
setup_corefnctiongroup
setup_mfopap
setup_project
setup_ratings_efficiency_plantilla
setup_ratings_oath
setup_ratings_quality_plantilla
setup_ratings_timeliness_servicecards
setup_sccess_indctor
set_up_company
sheet2$
sheet3$
shop_rate
signatory_logs
signatory_portal
skill_setup
sms_config
sms_text
special_holiday
sss_gsis
sss_loan
sss_loan_details
sss_setup
subject
sworn_assets
sworn_assetsb
sworn_businessinterest
sworn_liabilities
sworn_relatives
sworn_signatory
sworn_table
sworn_unmarried
task
tbl_achievement_record_new
tbl_active
tbl_adjustment
tbl_age_gap
tbl_alowance_setup
tbl_applicantrating_1stlevela1
tbl_applicantrating_1stlevela1_4
tbl_applicantrating_1stlevelb2
tbl_applicantrating_1stlevelb2_dtl
tbl_applicantrating_2ndlevela1
tbl_applicantrating_2ndlevela1_dtl
tbl_applicantrating_2ndlevelb2
tbl_applicantrating_2ndlevelb2_dtl
tbl_attachedfile
tbl_audit_trail
tbl_bill_ref
tbl_category_position
tbl_certificateoffinalaction_grievance
tbl_checklist_area
tbl_comparative
tbl_complaint
tbl_computation_night_diff
tbl_computation_normal_days
tbl_computation_overtime
tbl_correction
tbl_correction_detail
tbl_count
tbl_covered_days
tbl_credit_dtl
tbl_csecarreerservice
tbl_ctoentry_dtl
tbl_ctoentry_main
tbl_cto_balance
tbl_cto_balance_dtl
tbl_date
tbl_dayname
tbl_day_sked
tbl_deductions
tbl_deductions_dtl
tbl_deduction_dtl
tbl_documents_attached
tbl_drugtestplace_setup
tbl_dtr1
tbl_dtr_incident_report
tbl_dtr_incident_report_deduction
tbl_dtr_incomplete_logs
tbl_dtr_jo
tbl_dtr_jo_01_03
tbl_dtr_jo_01052022
tbl_dtr_jo_2021
tbl_dtr_locked_status
tbl_dtr_old
tbl_dtr_old_jo
tbl_dtr_temp
tbl_dtr_temp_batch
tbl_dtr_temp_bkp
tbl_dtr_temp_jo
tbl_elective_employee_other_information_new
tbl_email
tbl_employee_period
tbl_emp_passlip
tbl_emp_passlip1
tbl_emp_passlipxxxxxxxxxxxxxx
tbl_emp_payroll_salary
tbl_emp_restday
tbl_emp_sequencer
tbl_emp_service_record
tbl_events
tbl_events_offices
tbl_excel
tbl_fields
tbl_final_appointment
tbl_flagceremonyattendance
tbl_general_settings
tbl_generation_setup
tbl_gratuity
tbl_gratuity_dtl
tbl_grievance
tbl_grievance_agreement
tbl_gsis
tbl_hours_sked
tbl_hr_group_ipcr
tbl_hr_ipcr_detail
tbl_hr_ipcr_main
tbl_hr_ipcr_rating_scale
tbl_hr_profile_ipcr
tbl_hr_setup_ipcr
tbl_humanresourcegroup_ipcr
tbl_humanresourceipcr_detail
tbl_humanresourceipcr_main
tbl_humanresourceprofile_ipcr
tbl_humanresourcesetup_ipcr
tbl_incident_report_administrative
tbl_individual_dev_plan
tbl_individual_dev_plan_dtl
tbl_individual_dev_plan_dtl1
tbl_itinerary
tbl_leaves
tbl_leaves_dtl
tbl_leave_count
tbl_leave_credits
tbl_level
tbl_level_csc
tbl_level_position
tbl_logs
tbl_manpowerrequest
tbl_minutes_sked
tbl_missing_attendance
tbl_month
tbl_multiple_department
tbl_officeorder
tbl_official_business
tbl_official_business_dtl
tbl_order_personnel
tbl_overtime
tbl_overtime_category
tbl_overtime_cert
tbl_overtime_cert_dtl
tbl_overtime_copy
tbl_overtime_dtl
tbl_overtime_dtl_copy
tbl_overtime_memo
tbl_overtime_rate
tbl_paygroup_setup
tbl_payrollchange_dtl
tbl_payrollchange_main
tbl_payrollmaker
tbl_payroll_adjustment
tbl_payroll_allowances
tbl_payroll_ca_loans
tbl_payroll_contributions
tbl_payroll_general
tbl_payroll_logs_computation
tbl_payroll_main
tbl_payroll_main_copy
tbl_payroll_other_deductions
tbl_payrol_period
tbl_penaltytype
tbl_personnelschedule
tbl_personnelschedule_dtls
tbl_philhealth
tbl_pic
tbl_plantilla_personnel
tbl_plantilla_personnel_csc
tbl_plantilla_personnel_csc_new
tbl_plantilla_personnel_csc_new_1
tbl_plantilla_personnel_csc_new_2
tbl_plantilla_personnel_csc_new_3
tbl_plantilla_personnel_csc_new_4
tbl_plantilla_personnel_csc_new_5
tbl_position_category
tbl_position_desc
tbl_position_desc_detail
tbl_premium_setup
tbl_question
tbl_questionnaire_documents_attached
tbl_questions_dtl
tbl_rate
tbl_recruitment_checklist
tbl_recruitment_checklist_dtl
tbl_recruitment_detail
tbl_recruitment_group
tbl_recruitment_group_preliminary
tbl_recruitment_logs
tbl_recruitment_main
tbl_regularazation_sched
tbl_restday
tbl_salary_grade
tbl_salary_grade_bkp
tbl_salary_grade_copy1
tbl_salary_grade_old
tbl_salary_grade_rhu
tbl_service_record_dtl
tbl_service_record_dtl_bkp
tbl_service_record_issuance
tbl_service_record_main
tbl_service_record_main_bkp
tbl_service_record_new
tbl_service_record_new12-21-23
tbl_service_record_new_06-06-2023
tbl_service_record_new_bkp
tbl_service_record_new_main
tbl_setup_ipcr_data
tbl_shortlistedselection
tbl_short_listed
tbl_srorinput
tbl_sss
tbl_temp_dtr_list
tbl_timeshift_setup_main
tbl_timeshift_setup_main_copy
tbl_trainingneeds
tbl_trainingneeds_dtl
tbl_training_course
tbl_training_course_dtl
tbl_training_months
tbl_training_registration
tbl_user_restrictions
tbl_vacant_detail_info
tbl_vacant_pos
tbl_vacant_pos_group
tb_appointment_checklist
termination_details
timecard_summary
timecard_summary_permanent
timesheet
timesheet_jo
timeshiftdept
time_allowance
time_logs_history
time_sheet
tmp_employees_civilserviceeligibility
tmp_employees_eduback
tmp_employees_familybackground
tmp_employees_otherinfos
tmp_employees_reference
tmp_employees_skillshobbies
tmp_employees_trainingprogram
tmp_employees_voluntarilywork
tmp_employees_workexperience
tmp_generate_dtr_printing
tmp_olddtr_mig
training_attendees
training_details
training_requirements
training_schedule
training_schedule_dtls
training_setup
transaction_log
travel_order
utilitybill
utility_billing
utility_billing_rate_ed
utility_billing_rate_water
utility_bill_profile
web_dispatch_delay
web_dispatch_main
web_dispatch_standby
web_users
withdraw_details
withdraw_main
withholding_setup
working_hours
work_group
_aversiontime
_hr_dynamic_setup
_hr_dynamic_setup_client
_login_type
_tbl_acceptance_resignation
_tbl_exit_clearance
_tbl_exit_clearance_details
_tbl_exit_interview
_tbl_performance_evaluation
_tbl_performance_evaluation_detail
_tbl_performance_ratings
_tbl_promotion
_tbl_regular_appointment
_tbl_release_waiver
_tbl_standard_definition
_template
.
select column
select table
accounting_setup
acctg_action
activation_status
adjustment_entry
agendasetup
allowances
allowances_entry
allowances_fixed
allowances_jo
applicants
applicant_skills
application_ot
appointmentdocument
appointmentparticipant
appointments
approved_email_logs
approved_employee_ot
approved_ot
bank_setup
barangay
billing
bio_employees
bplo_attatchment
budget_controller
budget_controller_jo
caldays
calendar
cao_business_list
cao_business_list_main
cashadvacewalkin
cashliquidation
cashliquidation_detail
cash_advances
cash_advances_details
cash_advance_payed
clearance_attachments
clearance_comment
committeecreatedminutes
committeemembers
committeeminutetemplates
committees
committee_agenda
committee_attachmentlinks
committee_attendees
cto_rpt_payments_advance
currency
dash_assistance_survey
dash_assistance_survey_setup
dash_rating
deduction
deductions_status_employee
deductionto_atm_amount
deductiontype
deduction_details
deduction_pause
deduction_schedule
department
department_division
department_pmd
department_pmdbkp
department_shift
developer
disbursement
disbursement_dtls
division
division_setup
dmmy
drivers_equipment
dtr
dtr_approved_head
dtr_approved_head_setup
dtr_approved_payrollmaker
dtr_rules_setup
dummy_date
dummy_employee
dummy_t
duplicate_history
ebplo_other_certificates_form
ebplo_other_certificates_type
ecswd_travel_order
ecswd_travel_order_dtail
ecswd_travel_order_purpose
employeedepartment
employees
employees_allowances
employees_assignment
employees_bkp
employees_change_timeshift
employees_civilserviceeligibility
employees_copy
employees_copy_copy
employees_dependent
employees_designation_history
employees_eduback
employees_familybackground
employees_history
employees_leave_credits
employees_limit
employees_otherinfos
employees_position
employees_premiums
employees_rate
employees_rate_bkp
employees_reference
employees_section
employees_skillshobbies
employees_timeshift
employees_timeshift_copy
employees_trainingprogram
employees_trainingprogram1
employees_voluntarilywork
employees_workexperience
employees_work_history_ledger
employee_attachment
employee_attachments
employee_blocked
employee_blocked_byhr
employee_bloodtype
employee_clearance
employee_deduction_status
employee_eduback
employee_hiring_entity
employee_information
employee_information1
employee_information2
employee_information3
employee_information4
employee_information5
employee_informationupdated
employee_medicalreport
employee_medical_laboratoryresult
employee_medical_pastillness
employee_medical_pe_findings
employee_medical_physicalexamination
employee_medical_status
employee_otherinfo
employee_profile_pic
employee_references
employee_sal_type
employee_signatory
employee_skills
employee_skillsandreference
employee_skillset
employee_status
employee_type
employee_workexperience
emp_service_record
emp_transfer_dept_history
emp_transfer_dept_history_detail
equip
eventcalendarrange
finger_logs
fixed_other_allowances
gender
groups
history_active_inactive
history_blocked_byhr
history_position
hr_action
hr_ara_form_a
hr_ara_form_d
hr_ara_form_e
hr_ara_form_e_setup
hr_biometric_logs
hr_biometric_logs_dummy
hr_biometric_logs_history
hr_biometric_logs_history_transcient
hr_biometric_logs_transcient
hr_biometric_terminal
hr_biometric_user_data
hr_biometric_user_info
hr_certificate_data
hr_certificate_data_details
hr_certificate_setup
hr_certificate_table_template
hr_cert_of_appearance
hr_committee_agenda
hr_committee_agenda_attendee
hr_committee_metting
hr_committee_metting_attendance
hr_committee_resolution
hr_committee_setup
hr_committee_setup_member
hr_employee
hr_emp_afingerprint
hr_emp_assigning_projectsite
hr_emp_attendance
hr_emp_attendance_copy
hr_emp_attendance_jo
hr_emp_attendance_manualentry
hr_emp_attendance_othersite
hr_emp_empltype
hr_emp_leaves
hr_emp_leave_accumulatation
hr_emp_leave_accumulatation_history
hr_emp_leave_accumulate_ranz
hr_emp_leave_credits
hr_emp_leave_type
hr_emp_private_leavecredit
hr_emp_projectsite
hr_emp_service_records
hr_emp_shift
hr_holidays
hr_holidays_special
hr_job_status
hr_leave_type
hr_person_dependents
hr_person_educational_bg
hr_person_eligibility
hr_person_family_bg
hr_person_other_info
hr_person_profile
hr_person_reference
hr_person_skills
hr_person_training
hr_person_voluntary_work
hr_person_work_exp
hr_tbl_best_department
hr_tbl_best_employee
hr_tbl_clearance
hr_tbl_computation_amnt_setup
hr_tbl_computation_terminal_leave
hr_tbl_drugselectionlist
hr_tbl_emp_update_logs
hr_tbl_exit_interview
hr_tbl_increment_sched
hr_tbl_loyalty_bonus
hr_tbl_loyalty_setup
hr_tbl_memos_and_violations_dtl
hr_tbl_memos_and_violations_main
hr_tbl_offenses
hr_tbl_offenses_type
hr_tbl_offense_category
hr_tbl_organizational_setup
hr_tbl_perfect_attendance
hr_tbl_pre_retirement
hr_tbl_rating_setup
hr_tbl_rating_setup_details
hr_tbl_retirement_setup
hr_tbl_retire_separate_logs
hr_tbl_salary_adjustment
hr_tbl_salary_adjustment_bkp
hr_tbl_salary_adjustment_copy
hr_tbl_section_setup
hr_tbl_separation
hr_tbl_setup_rated
ielts_detail
inactive_active_history
incentives
incident_report
individualpass
irregular_shift
it_action
job_position_rate_setup
job_position_setup
late_cutoff_setup
log
login_attempts
mandatoryattendance
manpower_request
mm_action
myitems
nickname
office_location
offsetted_trans_record
onboarding_checklist_entry
on_boarding_checklist_setup
organizational_chart
originating_action
otherdeductions
otherdeductionsentry_details
otherdeductionsentry_main
otherdeductions_jo
otherdeduction_balances
other_addons
other_deduction
overtime_request
pagibig_loan
pagibig_loan_details
pagibig_setup
pakyaw_itemsetupp
paygroup_setup
payroll_computation
payroll_deduction_history
payroll_maker
payroll_rate
payslip
payslip2
payslip_allowance
payslip_allowance_jo
payslip_copy
payslip_details
payslip_details_jo
payslip_dole
payslip_dtr
payslip_jo
payslip_jo_holiday
payslip_jo_overtime
payslip_pagibig
payslip_pakyaw
payslip_pakyaw_detail
payslip_pertrip
payslip_sss
philhealth_setup
po
position
previous_basicpay
program_title
projects
project_list
project_title
raffle_name
raffle_name_copy
raffle_position
raffle_price
raffle_winner
ranz_tbl_flagceremony
repairform_setup
reports
requirement_setup
resources
restday_request
restday_request_permanent
rfcs_detail
rfcs_detail_breakdown
rfcs_main
salary_grade
setup_biometric
setup_biometric_privilege
setup_corefnctiongroup
setup_mfopap
setup_project
setup_ratings_efficiency_plantilla
setup_ratings_oath
setup_ratings_quality_plantilla
setup_ratings_timeliness_servicecards
setup_sccess_indctor
set_up_company
sheet2$
sheet3$
shop_rate
signatory_logs
signatory_portal
skill_setup
sms_config
sms_text
special_holiday
sss_gsis
sss_loan
sss_loan_details
sss_setup
subject
sworn_assets
sworn_assetsb
sworn_businessinterest
sworn_liabilities
sworn_relatives
sworn_signatory
sworn_table
sworn_unmarried
task
tbl_achievement_record_new
tbl_active
tbl_adjustment
tbl_age_gap
tbl_alowance_setup
tbl_applicantrating_1stlevela1
tbl_applicantrating_1stlevela1_4
tbl_applicantrating_1stlevelb2
tbl_applicantrating_1stlevelb2_dtl
tbl_applicantrating_2ndlevela1
tbl_applicantrating_2ndlevela1_dtl
tbl_applicantrating_2ndlevelb2
tbl_applicantrating_2ndlevelb2_dtl
tbl_attachedfile
tbl_audit_trail
tbl_bill_ref
tbl_category_position
tbl_certificateoffinalaction_grievance
tbl_checklist_area
tbl_comparative
tbl_complaint
tbl_computation_night_diff
tbl_computation_normal_days
tbl_computation_overtime
tbl_correction
tbl_correction_detail
tbl_count
tbl_covered_days
tbl_credit_dtl
tbl_csecarreerservice
tbl_ctoentry_dtl
tbl_ctoentry_main
tbl_cto_balance
tbl_cto_balance_dtl
tbl_date
tbl_dayname
tbl_day_sked
tbl_deductions
tbl_deductions_dtl
tbl_deduction_dtl
tbl_documents_attached
tbl_drugtestplace_setup
tbl_dtr1
tbl_dtr_incident_report
tbl_dtr_incident_report_deduction
tbl_dtr_incomplete_logs
tbl_dtr_jo
tbl_dtr_jo_01_03
tbl_dtr_jo_01052022
tbl_dtr_jo_2021
tbl_dtr_locked_status
tbl_dtr_old
tbl_dtr_old_jo
tbl_dtr_temp
tbl_dtr_temp_batch
tbl_dtr_temp_bkp
tbl_dtr_temp_jo
tbl_elective_employee_other_information_new
tbl_email
tbl_employee_period
tbl_emp_passlip
tbl_emp_passlip1
tbl_emp_passlipxxxxxxxxxxxxxx
tbl_emp_payroll_salary
tbl_emp_restday
tbl_emp_sequencer
tbl_emp_service_record
tbl_events
tbl_events_offices
tbl_excel
tbl_fields
tbl_final_appointment
tbl_flagceremonyattendance
tbl_general_settings
tbl_generation_setup
tbl_gratuity
tbl_gratuity_dtl
tbl_grievance
tbl_grievance_agreement
tbl_gsis
tbl_hours_sked
tbl_hr_group_ipcr
tbl_hr_ipcr_detail
tbl_hr_ipcr_main
tbl_hr_ipcr_rating_scale
tbl_hr_profile_ipcr
tbl_hr_setup_ipcr
tbl_humanresourcegroup_ipcr
tbl_humanresourceipcr_detail
tbl_humanresourceipcr_main
tbl_humanresourceprofile_ipcr
tbl_humanresourcesetup_ipcr
tbl_incident_report_administrative
tbl_individual_dev_plan
tbl_individual_dev_plan_dtl
tbl_individual_dev_plan_dtl1
tbl_itinerary
tbl_leaves
tbl_leaves_dtl
tbl_leave_count
tbl_leave_credits
tbl_level
tbl_level_csc
tbl_level_position
tbl_logs
tbl_manpowerrequest
tbl_minutes_sked
tbl_missing_attendance
tbl_month
tbl_multiple_department
tbl_officeorder
tbl_official_business
tbl_official_business_dtl
tbl_order_personnel
tbl_overtime
tbl_overtime_category
tbl_overtime_cert
tbl_overtime_cert_dtl
tbl_overtime_copy
tbl_overtime_dtl
tbl_overtime_dtl_copy
tbl_overtime_memo
tbl_overtime_rate
tbl_paygroup_setup
tbl_payrollchange_dtl
tbl_payrollchange_main
tbl_payrollmaker
tbl_payroll_adjustment
tbl_payroll_allowances
tbl_payroll_ca_loans
tbl_payroll_contributions
tbl_payroll_general
tbl_payroll_logs_computation
tbl_payroll_main
tbl_payroll_main_copy
tbl_payroll_other_deductions
tbl_payrol_period
tbl_penaltytype
tbl_personnelschedule
tbl_personnelschedule_dtls
tbl_philhealth
tbl_pic
tbl_plantilla_personnel
tbl_plantilla_personnel_csc
tbl_plantilla_personnel_csc_new
tbl_plantilla_personnel_csc_new_1
tbl_plantilla_personnel_csc_new_2
tbl_plantilla_personnel_csc_new_3
tbl_plantilla_personnel_csc_new_4
tbl_plantilla_personnel_csc_new_5
tbl_position_category
tbl_position_desc
tbl_position_desc_detail
tbl_premium_setup
tbl_question
tbl_questionnaire_documents_attached
tbl_questions_dtl
tbl_rate
tbl_recruitment_checklist
tbl_recruitment_checklist_dtl
tbl_recruitment_detail
tbl_recruitment_group
tbl_recruitment_group_preliminary
tbl_recruitment_logs
tbl_recruitment_main
tbl_regularazation_sched
tbl_restday
tbl_salary_grade
tbl_salary_grade_bkp
tbl_salary_grade_copy1
tbl_salary_grade_old
tbl_salary_grade_rhu
tbl_service_record_dtl
tbl_service_record_dtl_bkp
tbl_service_record_issuance
tbl_service_record_main
tbl_service_record_main_bkp
tbl_service_record_new
tbl_service_record_new12-21-23
tbl_service_record_new_06-06-2023
tbl_service_record_new_bkp
tbl_service_record_new_main
tbl_setup_ipcr_data
tbl_shortlistedselection
tbl_short_listed
tbl_srorinput
tbl_sss
tbl_temp_dtr_list
tbl_timeshift_setup_main
tbl_timeshift_setup_main_copy
tbl_trainingneeds
tbl_trainingneeds_dtl
tbl_training_course
tbl_training_course_dtl
tbl_training_months
tbl_training_registration
tbl_user_restrictions
tbl_vacant_detail_info
tbl_vacant_pos
tbl_vacant_pos_group
tb_appointment_checklist
termination_details
timecard_summary
timecard_summary_permanent
timesheet
timesheet_jo
timeshiftdept
time_allowance
time_logs_history
time_sheet
tmp_employees_civilserviceeligibility
tmp_employees_eduback
tmp_employees_familybackground
tmp_employees_otherinfos
tmp_employees_reference
tmp_employees_skillshobbies
tmp_employees_trainingprogram
tmp_employees_voluntarilywork
tmp_employees_workexperience
tmp_generate_dtr_printing
tmp_olddtr_mig
training_attendees
training_details
training_requirements
training_schedule
training_schedule_dtls
training_setup
transaction_log
travel_order
utilitybill
utility_billing
utility_billing_rate_ed
utility_billing_rate_water
utility_bill_profile
web_dispatch_delay
web_dispatch_main
web_dispatch_standby
web_users
withdraw_details
withdraw_main
withholding_setup
working_hours
work_group
_aversiontime
_hr_dynamic_setup
_hr_dynamic_setup_client
_login_type
_tbl_acceptance_resignation
_tbl_exit_clearance
_tbl_exit_clearance_details
_tbl_exit_interview
_tbl_performance_evaluation
_tbl_performance_evaluation_detail
_tbl_performance_ratings
_tbl_promotion
_tbl_regular_appointment
_tbl_release_waiver
_tbl_standard_definition
_template
.
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
accounting_setup
acctg_action
activation_status
adjustment_entry
agendasetup
allowances
allowances_entry
allowances_fixed
allowances_jo
applicants
applicant_skills
application_ot
appointmentdocument
appointmentparticipant
appointments
approved_email_logs
approved_employee_ot
approved_ot
bank_setup
barangay
billing
bio_employees
bplo_attatchment
budget_controller
budget_controller_jo
caldays
calendar
cao_business_list
cao_business_list_main
cashadvacewalkin
cashliquidation
cashliquidation_detail
cash_advances
cash_advances_details
cash_advance_payed
clearance_attachments
clearance_comment
committeecreatedminutes
committeemembers
committeeminutetemplates
committees
committee_agenda
committee_attachmentlinks
committee_attendees
cto_rpt_payments_advance
currency
dash_assistance_survey
dash_assistance_survey_setup
dash_rating
deduction
deductions_status_employee
deductionto_atm_amount
deductiontype
deduction_details
deduction_pause
deduction_schedule
department
department_division
department_pmd
department_pmdbkp
department_shift
developer
disbursement
disbursement_dtls
division
division_setup
dmmy
drivers_equipment
dtr
dtr_approved_head
dtr_approved_head_setup
dtr_approved_payrollmaker
dtr_rules_setup
dummy_date
dummy_employee
dummy_t
duplicate_history
ebplo_other_certificates_form
ebplo_other_certificates_type
ecswd_travel_order
ecswd_travel_order_dtail
ecswd_travel_order_purpose
employeedepartment
employees
employees_allowances
employees_assignment
employees_bkp
employees_change_timeshift
employees_civilserviceeligibility
employees_copy
employees_copy_copy
employees_dependent
employees_designation_history
employees_eduback
employees_familybackground
employees_history
employees_leave_credits
employees_limit
employees_otherinfos
employees_position
employees_premiums
employees_rate
employees_rate_bkp
employees_reference
employees_section
employees_skillshobbies
employees_timeshift
employees_timeshift_copy
employees_trainingprogram
employees_trainingprogram1
employees_voluntarilywork
employees_workexperience
employees_work_history_ledger
employee_attachment
employee_attachments
employee_blocked
employee_blocked_byhr
employee_bloodtype
employee_clearance
employee_deduction_status
employee_eduback
employee_hiring_entity
employee_information
employee_information1
employee_information2
employee_information3
employee_information4
employee_information5
employee_informationupdated
employee_medicalreport
employee_medical_laboratoryresult
employee_medical_pastillness
employee_medical_pe_findings
employee_medical_physicalexamination
employee_medical_status
employee_otherinfo
employee_profile_pic
employee_references
employee_sal_type
employee_signatory
employee_skills
employee_skillsandreference
employee_skillset
employee_status
employee_type
employee_workexperience
emp_service_record
emp_transfer_dept_history
emp_transfer_dept_history_detail
equip
eventcalendarrange
finger_logs
fixed_other_allowances
gender
groups
history_active_inactive
history_blocked_byhr
history_position
hr_action
hr_ara_form_a
hr_ara_form_d
hr_ara_form_e
hr_ara_form_e_setup
hr_biometric_logs
hr_biometric_logs_dummy
hr_biometric_logs_history
hr_biometric_logs_history_transcient
hr_biometric_logs_transcient
hr_biometric_terminal
hr_biometric_user_data
hr_biometric_user_info
hr_certificate_data
hr_certificate_data_details
hr_certificate_setup
hr_certificate_table_template
hr_cert_of_appearance
hr_committee_agenda
hr_committee_agenda_attendee
hr_committee_metting
hr_committee_metting_attendance
hr_committee_resolution
hr_committee_setup
hr_committee_setup_member
hr_employee
hr_emp_afingerprint
hr_emp_assigning_projectsite
hr_emp_attendance
hr_emp_attendance_copy
hr_emp_attendance_jo
hr_emp_attendance_manualentry
hr_emp_attendance_othersite
hr_emp_empltype
hr_emp_leaves
hr_emp_leave_accumulatation
hr_emp_leave_accumulatation_history
hr_emp_leave_accumulate_ranz
hr_emp_leave_credits
hr_emp_leave_type
hr_emp_private_leavecredit
hr_emp_projectsite
hr_emp_service_records
hr_emp_shift
hr_holidays
hr_holidays_special
hr_job_status
hr_leave_type
hr_person_dependents
hr_person_educational_bg
hr_person_eligibility
hr_person_family_bg
hr_person_other_info
hr_person_profile
hr_person_reference
hr_person_skills
hr_person_training
hr_person_voluntary_work
hr_person_work_exp
hr_tbl_best_department
hr_tbl_best_employee
hr_tbl_clearance
hr_tbl_computation_amnt_setup
hr_tbl_computation_terminal_leave
hr_tbl_drugselectionlist
hr_tbl_emp_update_logs
hr_tbl_exit_interview
hr_tbl_increment_sched
hr_tbl_loyalty_bonus
hr_tbl_loyalty_setup
hr_tbl_memos_and_violations_dtl
hr_tbl_memos_and_violations_main
hr_tbl_offenses
hr_tbl_offenses_type
hr_tbl_offense_category
hr_tbl_organizational_setup
hr_tbl_perfect_attendance
hr_tbl_pre_retirement
hr_tbl_rating_setup
hr_tbl_rating_setup_details
hr_tbl_retirement_setup
hr_tbl_retire_separate_logs
hr_tbl_salary_adjustment
hr_tbl_salary_adjustment_bkp
hr_tbl_salary_adjustment_copy
hr_tbl_section_setup
hr_tbl_separation
hr_tbl_setup_rated
ielts_detail
inactive_active_history
incentives
incident_report
individualpass
irregular_shift
it_action
job_position_rate_setup
job_position_setup
late_cutoff_setup
log
login_attempts
mandatoryattendance
manpower_request
mm_action
myitems
nickname
office_location
offsetted_trans_record
onboarding_checklist_entry
on_boarding_checklist_setup
organizational_chart
originating_action
otherdeductions
otherdeductionsentry_details
otherdeductionsentry_main
otherdeductions_jo
otherdeduction_balances
other_addons
other_deduction
overtime_request
pagibig_loan
pagibig_loan_details
pagibig_setup
pakyaw_itemsetupp
paygroup_setup
payroll_computation
payroll_deduction_history
payroll_maker
payroll_rate
payslip
payslip2
payslip_allowance
payslip_allowance_jo
payslip_copy
payslip_details
payslip_details_jo
payslip_dole
payslip_dtr
payslip_jo
payslip_jo_holiday
payslip_jo_overtime
payslip_pagibig
payslip_pakyaw
payslip_pakyaw_detail
payslip_pertrip
payslip_sss
philhealth_setup
po
position
previous_basicpay
program_title
projects
project_list
project_title
raffle_name
raffle_name_copy
raffle_position
raffle_price
raffle_winner
ranz_tbl_flagceremony
repairform_setup
reports
requirement_setup
resources
restday_request
restday_request_permanent
rfcs_detail
rfcs_detail_breakdown
rfcs_main
salary_grade
setup_biometric
setup_biometric_privilege
setup_corefnctiongroup
setup_mfopap
setup_project
setup_ratings_efficiency_plantilla
setup_ratings_oath
setup_ratings_quality_plantilla
setup_ratings_timeliness_servicecards
setup_sccess_indctor
set_up_company
sheet2$
sheet3$
shop_rate
signatory_logs
signatory_portal
skill_setup
sms_config
sms_text
special_holiday
sss_gsis
sss_loan
sss_loan_details
sss_setup
subject
sworn_assets
sworn_assetsb
sworn_businessinterest
sworn_liabilities
sworn_relatives
sworn_signatory
sworn_table
sworn_unmarried
task
tbl_achievement_record_new
tbl_active
tbl_adjustment
tbl_age_gap
tbl_alowance_setup
tbl_applicantrating_1stlevela1
tbl_applicantrating_1stlevela1_4
tbl_applicantrating_1stlevelb2
tbl_applicantrating_1stlevelb2_dtl
tbl_applicantrating_2ndlevela1
tbl_applicantrating_2ndlevela1_dtl
tbl_applicantrating_2ndlevelb2
tbl_applicantrating_2ndlevelb2_dtl
tbl_attachedfile
tbl_audit_trail
tbl_bill_ref
tbl_category_position
tbl_certificateoffinalaction_grievance
tbl_checklist_area
tbl_comparative
tbl_complaint
tbl_computation_night_diff
tbl_computation_normal_days
tbl_computation_overtime
tbl_correction
tbl_correction_detail
tbl_count
tbl_covered_days
tbl_credit_dtl
tbl_csecarreerservice
tbl_ctoentry_dtl
tbl_ctoentry_main
tbl_cto_balance
tbl_cto_balance_dtl
tbl_date
tbl_dayname
tbl_day_sked
tbl_deductions
tbl_deductions_dtl
tbl_deduction_dtl
tbl_documents_attached
tbl_drugtestplace_setup
tbl_dtr1
tbl_dtr_incident_report
tbl_dtr_incident_report_deduction
tbl_dtr_incomplete_logs
tbl_dtr_jo
tbl_dtr_jo_01_03
tbl_dtr_jo_01052022
tbl_dtr_jo_2021
tbl_dtr_locked_status
tbl_dtr_old
tbl_dtr_old_jo
tbl_dtr_temp
tbl_dtr_temp_batch
tbl_dtr_temp_bkp
tbl_dtr_temp_jo
tbl_elective_employee_other_information_new
tbl_email
tbl_employee_period
tbl_emp_passlip
tbl_emp_passlip1
tbl_emp_passlipxxxxxxxxxxxxxx
tbl_emp_payroll_salary
tbl_emp_restday
tbl_emp_sequencer
tbl_emp_service_record
tbl_events
tbl_events_offices
tbl_excel
tbl_fields
tbl_final_appointment
tbl_flagceremonyattendance
tbl_general_settings
tbl_generation_setup
tbl_gratuity
tbl_gratuity_dtl
tbl_grievance
tbl_grievance_agreement
tbl_gsis
tbl_hours_sked
tbl_hr_group_ipcr
tbl_hr_ipcr_detail
tbl_hr_ipcr_main
tbl_hr_ipcr_rating_scale
tbl_hr_profile_ipcr
tbl_hr_setup_ipcr
tbl_humanresourcegroup_ipcr
tbl_humanresourceipcr_detail
tbl_humanresourceipcr_main
tbl_humanresourceprofile_ipcr
tbl_humanresourcesetup_ipcr
tbl_incident_report_administrative
tbl_individual_dev_plan
tbl_individual_dev_plan_dtl
tbl_individual_dev_plan_dtl1
tbl_itinerary
tbl_leaves
tbl_leaves_dtl
tbl_leave_count
tbl_leave_credits
tbl_level
tbl_level_csc
tbl_level_position
tbl_logs
tbl_manpowerrequest
tbl_minutes_sked
tbl_missing_attendance
tbl_month
tbl_multiple_department
tbl_officeorder
tbl_official_business
tbl_official_business_dtl
tbl_order_personnel
tbl_overtime
tbl_overtime_category
tbl_overtime_cert
tbl_overtime_cert_dtl
tbl_overtime_copy
tbl_overtime_dtl
tbl_overtime_dtl_copy
tbl_overtime_memo
tbl_overtime_rate
tbl_paygroup_setup
tbl_payrollchange_dtl
tbl_payrollchange_main
tbl_payrollmaker
tbl_payroll_adjustment
tbl_payroll_allowances
tbl_payroll_ca_loans
tbl_payroll_contributions
tbl_payroll_general
tbl_payroll_logs_computation
tbl_payroll_main
tbl_payroll_main_copy
tbl_payroll_other_deductions
tbl_payrol_period
tbl_penaltytype
tbl_personnelschedule
tbl_personnelschedule_dtls
tbl_philhealth
tbl_pic
tbl_plantilla_personnel
tbl_plantilla_personnel_csc
tbl_plantilla_personnel_csc_new
tbl_plantilla_personnel_csc_new_1
tbl_plantilla_personnel_csc_new_2
tbl_plantilla_personnel_csc_new_3
tbl_plantilla_personnel_csc_new_4
tbl_plantilla_personnel_csc_new_5
tbl_position_category
tbl_position_desc
tbl_position_desc_detail
tbl_premium_setup
tbl_question
tbl_questionnaire_documents_attached
tbl_questions_dtl
tbl_rate
tbl_recruitment_checklist
tbl_recruitment_checklist_dtl
tbl_recruitment_detail
tbl_recruitment_group
tbl_recruitment_group_preliminary
tbl_recruitment_logs
tbl_recruitment_main
tbl_regularazation_sched
tbl_restday
tbl_salary_grade
tbl_salary_grade_bkp
tbl_salary_grade_copy1
tbl_salary_grade_old
tbl_salary_grade_rhu
tbl_service_record_dtl
tbl_service_record_dtl_bkp
tbl_service_record_issuance
tbl_service_record_main
tbl_service_record_main_bkp
tbl_service_record_new
tbl_service_record_new12-21-23
tbl_service_record_new_06-06-2023
tbl_service_record_new_bkp
tbl_service_record_new_main
tbl_setup_ipcr_data
tbl_shortlistedselection
tbl_short_listed
tbl_srorinput
tbl_sss
tbl_temp_dtr_list
tbl_timeshift_setup_main
tbl_timeshift_setup_main_copy
tbl_trainingneeds
tbl_trainingneeds_dtl
tbl_training_course
tbl_training_course_dtl
tbl_training_months
tbl_training_registration
tbl_user_restrictions
tbl_vacant_detail_info
tbl_vacant_pos
tbl_vacant_pos_group
tb_appointment_checklist
termination_details
timecard_summary
timecard_summary_permanent
timesheet
timesheet_jo
timeshiftdept
time_allowance
time_logs_history
time_sheet
tmp_employees_civilserviceeligibility
tmp_employees_eduback
tmp_employees_familybackground
tmp_employees_otherinfos
tmp_employees_reference
tmp_employees_skillshobbies
tmp_employees_trainingprogram
tmp_employees_voluntarilywork
tmp_employees_workexperience
tmp_generate_dtr_printing
tmp_olddtr_mig
training_attendees
training_details
training_requirements
training_schedule
training_schedule_dtls
training_setup
transaction_log
travel_order
utilitybill
utility_billing
utility_billing_rate_ed
utility_billing_rate_water
utility_bill_profile
web_dispatch_delay
web_dispatch_main
web_dispatch_standby
web_users
withdraw_details
withdraw_main
withholding_setup
working_hours
work_group
_aversiontime
_hr_dynamic_setup
_hr_dynamic_setup_client
_login_type
_tbl_acceptance_resignation
_tbl_exit_clearance
_tbl_exit_clearance_details
_tbl_exit_interview
_tbl_performance_evaluation
_tbl_performance_evaluation_detail
_tbl_performance_ratings
_tbl_promotion
_tbl_regular_appointment
_tbl_release_waiver
_tbl_standard_definition
_template
.
select column
mysqli::real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)
Connection for controluser as defined in your configuration failed.