日期:2014-05-16  浏览次数:20500 次

工资计算公式
insert into PAY.FORMULA_DESC (BASE_UID, CODE, CODE_DESC, CODE_NAME, FORMULA_CAL, FORMULA_DESC, DATE_CREATE, DATE_UPDATE, USER_CREATE, USER_UPDATE, VERSION)
values ('000000000013', '105', '考勤处罚', '01', '', '迟到+签卡*2+缺卡*5+考勤/2*(基本工资合计+固定工资)/月制度工作/8', to_date('10-09-2012 17:16:54', 'dd-mm-yyyy hh24:mi:ss'), to_date('21-10-2012 14:27:02', 'dd-mm-yyyy hh24:mi:ss'), '000000001224', '000000001224', 4);

insert into PAY.FORMULA_DESC (BASE_UID, CODE, CODE_DESC, CODE_NAME, FORMULA_CAL, FORMULA_DESC, DATE_CREATE, DATE_UPDATE, USER_CREATE, USER_UPDATE, VERSION)
values ('000000000001', '101', '绩效奖惩', '01', 'O9*0.5*(Y9-1)/Q9*(Q9-(R9+Y9+U9)/8-X9)', '固定工资*0.3*(绩效系数-1)/月制度工作*(月制度工作-(事假+病假+旷工)/8-其它)', to_date('08-09-2012 09:02:09', 'dd-mm-yyyy hh24:mi:ss'), to_date('08-09-2012 11:59:07', 'dd-mm-yyyy hh24:mi:ss'), '000000001224', '000000001224', 4);

insert into PAY.FORMULA_DESC (BASE_UID, CODE, CODE_DESC, CODE_NAME, FORMULA_CAL, FORMULA_DESC, DATE_CREATE, DATE_UPDATE, USER_CREATE, USER_UPDATE, VERSION)
values ('000000000002', '101', '绩效奖惩', '02', 'O9*0.5*(Y9-1)/Q9*(Q9-(R9+Y9+U9)/8-X9)', '底薪工资*0.5*(绩效系数-1)/月制度工作*(月制度工作-(事假+病假+旷工)/8-其它)', to_date('08-09-2012 09:16:57', 'dd-mm-yyyy hh24:mi:ss'), to_date('09-09-2012 19:49:44', 'dd-mm-yyyy hh24:mi:ss'), '000000001224', '000000001224', 6);

insert into PAY.FORMULA_DESC (BASE_UID, CODE, CODE_DESC, CODE_NAME, FORMULA_CAL, FORMULA_DESC, DATE_CREATE, DATE_UPDATE, USER_CREATE, USER_UPDATE, VERSION)
values ('000000000017', '110', '基本工资合计', '01', '', '基本底薪+岗位津贴+技能工资', to_date('11-10-2012 08:42:31', 'dd-mm-yyyy hh24:mi:ss'), to_date('11-10-2012 08:42:31', 'dd-mm-yyyy hh24:mi:ss'), '000000001224', '000000001224', 1);

insert into PAY.FORMULA_DESC (BASE_UID, CODE, CODE_DESC, CODE_NAME, FORMULA_CAL, FORMULA_DESC, DATE_CREATE, DATE_UPDATE, USER_CREATE, USER_UPDATE, VERSION)
values ('000000000011', '102', '加班工资', '02', '', '底薪工资/21.75/8*(1.5*星期壹~伍+2*星期六日+3*节日壹~日)', to_date('09-09-2012 19:50:22', 'dd-mm-yyyy hh24:mi:ss'), to_date('09-09-2012 19:50:22', 'dd-mm-yyyy hh24:mi:ss'), '000000001224', '000000001224', 1);

insert into PAY.FORMULA_DESC (BASE_UID, CODE, CODE_DESC, CODE_NAME, FORMULA_CAL, FORMULA_DESC, DATE_CREATE, DATE_UPDATE, USER_CREATE, USER_UPDATE, VERSION)
values ('000000000012', '109', '实发工资', '01', '', '应发合计-应扣合计-崇达爱心基金-所得税', to_date('09-09-2012 20:02:32', 'dd-mm-yyyy hh24:mi:ss'), to_date('09-09-2012 20:02:32', 'dd-mm-yyyy hh24:mi:ss'), '000000001224', '000000001224', 1);

insert into PAY.FORMULA_DESC (BASE_UID, CODE, CODE_DESC, CODE_NAME, FORMULA_CAL, FORMULA_DESC, DATE_CREATE, DATE_UPDATE, USER_CREATE, USER_UPDATE, VERSION)
values ('000000000016', '103', '基本工资', '03', '', '(固定工资*(0.7+0.3*绩效系数)/月制度工作*(月制度工作-(事假+病假+旷工)/8-其它)+绩效奖惩)', to_date('21-09-2012 11:33:59', 'dd-mm-yyyy hh24:mi:ss'), to_date('21-09-2012 13:13:17', 'dd-mm-yyyy hh24:mi:ss'), '000000001224', '000000001224', 4);

insert into PAY.FORMULA_DESC (BASE_UID, CODE, CODE_DESC, CODE_NAME, FORMULA_CAL, FORMULA_DESC, DATE_CREATE, DATE_UPDATE, USER_CREATE, USER_UPDATE, VERSION)
values ('000000000018', '112', '职称津贴', '01', '', '职称津贴*(1-其它/月制度工作)', to_date('12-10-2012 11:01:35', 'dd-mm-yyyy hh24:mi:ss'), to_date('12-10-2012 14:40:29', 'dd-mm-yyyy hh24:mi:ss'), '000000001224', '000000001224', 2);

insert into PAY.FORMULA_DESC (BASE_UID, CODE, CODE_DESC, CODE_NAME, FORMULA_CAL, FORMULA_DESC, DATE_CREATE, DATE_UPDATE, USER_CREATE, USER_UPDATE, VERSION)
values ('000000000019', '113', '学历津贴', '01', '', '学历津贴*(1-其它/月制度工作)', to_date('12-10-2012 11:02:02', 'dd-mm-yyyy hh24:mi:ss'), to_date('12-10-2012 14:40:39', 'dd-mm-yyyy hh24:mi:ss'), '000000001224', '000000001224', 2);

insert into PAY.FORMULA_DESC (BASE_UID, CODE, CODE_DESC, CODE_NAME, FORMULA_CAL, FORMULA_DESC, DATE_CREATE, DATE_UPDATE, USER_CREATE, USER_UPDATE, VERSION)
values ('000000000020', '114', '高温津贴', '01', '', '发放标准/21.75*(21.75-(事假+病假+旷工)/8-其它)', to_date('12-10-2012 11:30:35', 'dd-mm-yyyy hh24:mi:ss'), to_date('12-10-2012 11:46:25', 'dd-mm-yyy