NameDescriptionTypeAdditional 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.