Name | Description | Type | Additional information |
---|---|---|---|
id |
主键 |
integer |
None. |
salary_date |
工资时间 格式:201701 |
string |
None. |
d_id |
部门id |
integer |
None. |
d_name |
部门名称 |
string |
None. |
emp_id |
员工编号(主键) |
integer |
None. |
emp_name |
姓名 |
string |
None. |
add_time |
添加时间 |
date |
None. |
update_time |
更新时间 |
date |
None. |
project |
项目 |
string |
None. |
finish_num |
完成量 |
integer |
None. |
unit |
单位 |
string |
None. |
base_count |
绩效计件基数 |
decimal number |
None. |
performance |
总绩效 |
decimal number |
None. |
person_performance |
个人绩效(占比97%) |
decimal number |
None. |
auto_performance |
机动绩效(占比3%) |
decimal number |
None. |
sum_cat_performance |
安全帽总值(所以安全帽绩效总和的3%) |
decimal number |
None. |
amount_performance |
实际应得 |
decimal number |
None. |
sum_finish_num |
总完成量 |
decimal number |
None. |
sum_base_count |
总绩效计件基数 |
decimal number |
None. |
sum_performance |
总总绩效 |
decimal number |
None. |
sum_person_performance |
总个人绩效 |
decimal number |
None. |
sum_auto_performance |
总机动绩效 |
decimal number |
None. |
sum_sum_cat_performance |
总安全帽总值 |
decimal number |
None. |
sum_amount_performance |
总实际应得 |
decimal number |
None. |