v_current_performance_config

v_current_performance_config 视图 · 13 字段

VIEW

视图定义

CREATE ALGORITHM=UNDEFINED DEFINER=`neuron_new`@`%` SQL SECURITY DEFINER VIEW `v_current_performance_config` AS select `xhs_performance_config`.`department` AS `department`,`xhs_performance_config`.`member_name` AS `member_name`,`xhs_performance_config`.`member_role` AS `member_role`,`xhs_performance_config`.`indicator_name` AS `indicator_name`,`xhs_performance_config`.`indicator_code` AS `indicator_code`,`xhs_performance_config`.`weight` AS `weight`,`xhs_performance_config`.`target_value` AS `target_value`,`xhs_performance_config`.`is_race` AS `is_race`,`xhs_performance_config`.`calculation_formula` AS `calculation_formula`,`xhs_performance_config`.`db_field` AS `db_field`,`xhs_performance_config`.`display_order` AS `display_order`,`xhs_performance_config`.`base_salary` AS `base_salary`,`xhs_performance_config`.`performance_base` AS `performance_base` from `xhs_performance_config` where ((`xhs_performance_config`.`is_active` = 1) and (isnull(`xhs_performance_config`.`valid_from`) or (`xhs_performance_config`.`valid_from` <= curdate())) and (isnull(`xhs_performance_config`.`valid_to`) or (`xhs_performance_config`.`valid_to` >= curdate()))) order by `xhs_performance_config`.`member_name`,`xhs_performance_config`.`display_order`

字段信息

字段名	类型	必填	说明	关联关系
department	varchar(50)	是	所属部门	-
member_name	varchar(50)	否	成员姓名	-
member_role	varchar(50)	否	岗位名称	-
indicator_name	varchar(50)	否	指标名称（中文）	-
indicator_code	varchar(50)	否	指标代码（用于计算）	-
weight	decimal(5,2)	否	权重（%）	-
target_value	decimal(10,2)	是	月度目标值	-
is_race	tinyint(4)	是	是否赛马指标（1=是，0=否）	-
calculation_formula	text	是	计算公式	-
db_field	varchar(100)	是	对应数据库字段	-
display_order	int(11)	是	显示顺序	-
base_salary	decimal(10,2)	是	基础工资	-
performance_base	decimal(10,2)	是	绩效工资基数	-

索引信息

无索引