| id |
int(11)
|
|
|
|
| employee_id |
int(11)
|
|
|
|
| cutoff_id |
int(11)
|
|
|
|
| week_start |
date
|
|
|
|
| week_end |
date
|
|
|
|
| days_worked |
decimal(5,2)
|
|
|
|
| paid_leave_days |
decimal(8,2)
|
|
|
|
| lwop_days |
decimal(8,2)
|
|
|
|
| regular_holiday_worked |
decimal(8,2)
|
|
|
|
| special_holiday_worked |
decimal(8,2)
|
|
|
|
| rate_per_day |
decimal(12,2)
|
|
|
|
| rate_per_min |
decimal(12,4)
|
|
|
|
| late_ut_minutes |
decimal(10,2)
|
|
|
|
| total_tardy |
decimal(12,2)
|
|
|
|
| basic_pay |
decimal(12,2)
|
|
|
|
| gross_pay |
decimal(12,2)
|
|
|
|
| holiday_pay |
decimal(12,2)
|
|
|
|
| leave_pay |
decimal(12,2)
|
|
|
|
| overtime_pay |
decimal(12,2)
|
|
|
|
| total_gp |
decimal(12,2)
|
|
|
|
| cash_advance |
decimal(12,2)
|
|
|
|
| sss_employee |
decimal(12,2)
|
|
|
|
| philhealth_employee |
decimal(12,2)
|
|
|
|
| pagibig_employee |
decimal(12,2)
|
|
|
|
| withholding_tax |
decimal(12,2)
|
|
|
|
| statutory_total |
decimal(12,2)
|
|
|
|
| taxable_income |
decimal(12,2)
|
|
|
|
| formula_version |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| payroll_breakdown_json |
longtext
|
utf8mb4_general_ci
|
|
|
| remarks |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| benefits |
decimal(12,2)
|
|
|
|
| deductions |
decimal(12,2)
|
|
|
|
| net_pay |
decimal(12,2)
|
|
|
|
| adjustment |
decimal(12,2)
|
|
|
|
| total_net |
decimal(12,2)
|
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|
| regular_overtime_hours |
decimal(10,2)
|
|
|
|
| regular_overtime_pay |
decimal(10,2)
|
|
|
|
| holiday_overtime_hours |
decimal(10,2)
|
|
|
|
| holiday_overtime_pay |
decimal(10,2)
|
|
|
|
| approved_ot_hours |
decimal(10,2)
|
|
|
|
| rest_day_hours |
decimal(10,2)
|
|
|
|
| rest_day_pay |
decimal(12,2)
|
|
|
|
| night_diff_hours |
decimal(10,2)
|
|
|
|
| night_diff_pay |
decimal(12,2)
|
|
|
|
| ob_hours |
decimal(10,2)
|
|
|
|
