| id |
int(11)
|
|
|
|
| period_month |
date
|
|
|
|
| employee_id |
int(11)
|
|
|
|
| employee_code |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| employee_name_raw |
varchar(160)
|
utf8mb4_general_ci
|
|
|
| sss_payroll_15 |
decimal(12,2)
|
|
|
|
| sss_payroll_30 |
decimal(12,2)
|
|
|
|
| sss_monthly_total |
decimal(12,2)
|
|
|
|
| sss_er_ee_total |
decimal(12,2)
|
|
|
|
| sss_employee_share |
decimal(12,2)
|
|
|
|
| sss_employer_share |
decimal(12,2)
|
|
|
|
| sss_ec_er |
decimal(12,2)
|
|
|
|
| sss_remittance_total |
decimal(12,2)
|
|
|
|
| sss_loan_total |
decimal(12,2)
|
|
|
|
| philhealth_payroll_15 |
decimal(12,2)
|
|
|
|
| philhealth_payroll_30 |
decimal(12,2)
|
|
|
|
| philhealth_monthly_total |
decimal(12,2)
|
|
|
|
| philhealth_employee_share |
decimal(12,2)
|
|
|
|
| philhealth_employer_share |
decimal(12,2)
|
|
|
|
| pagibig_payroll_15 |
decimal(12,2)
|
|
|
|
| pagibig_payroll_30 |
decimal(12,2)
|
|
|
|
| pagibig_monthly_total |
decimal(12,2)
|
|
|
|
| pagibig_employee_share |
decimal(12,2)
|
|
|
|
| pagibig_employer_share |
decimal(12,2)
|
|
|
|
| hdmf_loan_total |
decimal(12,2)
|
|
|
|
| source_files |
text
|
utf8mb4_general_ci
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|