| id |
int(11)
|
|
|
|
| cutoff_id |
int(11)
|
|
|
|
| employee_id |
int(11)
|
|
|
|
| monthly_salary |
decimal(12,2)
|
|
|
|
| semi_monthly_basic |
decimal(12,2)
|
|
|
|
| daily_rate |
decimal(12,2)
|
|
|
|
| hourly_rate |
decimal(12,4)
|
|
|
|
| minute_rate |
decimal(12,6)
|
|
|
|
| paid_days |
decimal(8,2)
|
|
|
|
| absent_days |
decimal(8,2)
|
|
|
|
| absence_deduction |
decimal(12,2)
|
|
|
|
| late_undertime_hours |
decimal(10,4)
|
|
|
|
| late_undertime_minutes |
decimal(10,2)
|
|
|
|
| late_undertime_deduction |
decimal(12,2)
|
|
|
|
| leave_with_pay_days |
decimal(8,2)
|
|
|
|
| leave_with_pay_pay |
decimal(12,2)
|
|
|
|
| leave_without_pay_days |
decimal(8,2)
|
|
|
|
| leave_without_pay_deduction |
decimal(12,2)
|
|
|
|
| regular_ot_hours |
decimal(10,4)
|
|
|
|
| regular_ot_pay |
decimal(12,2)
|
|
|
|
| night_diff_hours |
decimal(10,4)
|
|
|
|
| night_diff_pay |
decimal(12,2)
|
|
|
|
| rest_day_hours |
decimal(10,4)
|
|
|
|
| rest_day_pay |
decimal(12,2)
|
|
|
|
| rest_day_ot_hours |
decimal(10,4)
|
|
|
|
| rest_day_ot_pay |
decimal(12,2)
|
|
|
|
| legal_holiday_hours |
decimal(10,4)
|
|
|
|
| legal_holiday_pay |
decimal(12,2)
|
|
|
|
| special_holiday_hours |
decimal(10,4)
|
|
|
|
| special_holiday_pay |
decimal(12,2)
|
|
|
|
| overtime |
decimal(12,2)
|
|
|
|
| allowance |
decimal(12,2)
|
|
|
|
| de_minimis |
decimal(12,2)
|
|
|
|
| incentive |
decimal(12,2)
|
|
|
|
| adjustment |
decimal(12,2)
|
|
|
|
| basic_pay |
decimal(12,2)
|
|
|
|
| gross_pay |
decimal(12,2)
|
|
|
|
| sss_ee |
decimal(12,2)
|
|
|
|
| philhealth_ee |
decimal(12,2)
|
|
|
|
| pagibig_ee |
decimal(12,2)
|
|
|
|
| statutory_total |
decimal(12,2)
|
|
|
|
| sss_loan |
decimal(12,2)
|
|
|
|
| sss_cal_loan |
decimal(12,2)
|
|
|
|
| hdmf_loan |
decimal(12,2)
|
|
|
|
| hdmf_cal_loan |
decimal(12,2)
|
|
|
|
| cash_advance |
decimal(12,2)
|
|
|
|
| charges |
decimal(12,2)
|
|
|
|
| withholding_tax |
decimal(12,2)
|
|
|
|
| deduction |
decimal(12,2)
|
|
|
|
| total_deductions |
decimal(12,2)
|
|
|
|
| net_pay |
decimal(12,2)
|
|
|
|
| sss_er |
decimal(12,2)
|
|
|
|
| sss_ec |
decimal(12,2)
|
|
|
|
| philhealth_er |
decimal(12,2)
|
|
|
|
| pagibig_er |
decimal(12,2)
|
|
|
|
| remarks |
text
|
utf8mb4_general_ci
|
|
|
| encoded_by |
int(11)
|
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|
