| id | bigint(20) unsigned |
|
|
|
| period_key | char(7) |
|
|
|
| employee_profile_id | bigint(20) unsigned |
|
|
Menjelajahi nilai luar |
| legacy_employee_id | bigint(20) unsigned |
|
|
|
| employee_code | varchar(40) |
|
|
|
| employee_name | varchar(180) |
|
|
|
| service_type | varchar(30) |
|
|
|
| source_date_from | date |
|
|
|
| source_date_to | date |
|
|
|
| source_row_count | int(10) unsigned |
|
|
0
|
| doctor_percentage | decimal(8,2) |
|
|
0.00
|
| amount | decimal(20,2) |
|
|
0.00
|
| status | varchar(20) |
|
|
ready
|
| used_payroll_period | char(7) |
|
|
|
| payroll_gaji_id | bigint(20) unsigned |
|
|
|
| used_by | varchar(120) |
|
|
|
| used_at | datetime |
|
|
2026-10-04 20:51:13.000000
|
| filter_query | varchar(180) |
|
|
|
| created_by | varchar(120) |
|
|
|
| created_at | datetime |
|
|
2026-10-04 20:51:13.000000
|
| updated_by | varchar(120) |
|
|
|
| updated_at | datetime |
|
|
2026-10-04 20:51:13.000000
|