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