qt
/
weaver-hrm-salary
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
weaver-hrm-salary/resource/sqlupgrade/DM/sql202205130903.sql

2410 lines
159 KiB
MySQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

CREATE TABLE hrsa_acct_result_temp(
id NUMBER(38,0) primary key NOT NULL,
calculate_key varchar2(50) DEFAULT '',
salary_sob_id NUMBER(38,0) DEFAULT 0,
salary_acct_emp_id NUMBER(38,0) DEFAULT 0,
salary_acct_record_id NUMBER(38,0) DEFAULT 0,
employee_id NUMBER(38,0) DEFAULT 0,
tax_agent_id NUMBER(38,0) DEFAULT 0,
salary_item_id NUMBER(38,0) DEFAULT 0,
result_value varchar2(1000) DEFAULT '',
creator NUMBER(38,0) DEFAULT '0',
create_time date DEFAULT sysdate,
update_time date DEFAULT sysdate,
delete_type number DEFAULT 0,
tenant_key varchar2(10) DEFAULT ''
);
/
create sequence hrsa_acct_result_temp_id
start with 1
increment by 1
nomaxvalue
nocycle;
/
create or replace trigger hrsa_acct_result_temp_Tri
before insert on hrsa_acct_result_temp
for each row
begin
select hrsa_acct_result_temp_id.nextval into :new.id from dual;
end;
/
CREATE TABLE hrsa_add_up_deduction (
id NUMBER(38,0) PRIMARY KEY NOT NULL,
employee_id NUMBER(38,0) NOT NULL,
tax_agent_id NUMBER(38,0) NOT NULL,
declare_month DATE DEFAULT sysdate,
add_up_child_education varchar2(255) DEFAULT '',
add_up_continuing_education varchar2(255) DEFAULT '',
add_up_housing_loan_interest varchar2(255) DEFAULT '',
add_up_housing_rent varchar2(255) DEFAULT '' ,
add_up_support_elderly varchar2(255) DEFAULT '' ,
create_time date DEFAULT sysdate,
update_time date DEFAULT sysdate,
creator NUMBER(38,0) DEFAULT 0 ,
delete_type number DEFAULT 0 ,
tenant_key varchar2(10) DEFAULT ''
);
/
create sequence hrsa_add_up_deduction_id
start with 1
increment by 1
nomaxvalue
nocycle;
/
create or replace trigger hrsa_add_up_deduction_Tri
before insert on hrsa_add_up_deduction
for each row
begin
select hrsa_add_up_deduction_id.nextval into :new.id from dual;
end;
/
CREATE TABLE hrsa_add_up_situation(
id NUMBER(38,0) PRIMARY KEY NOT NULL,
employee_id NUMBER(38,0) NOT NULL,
tax_agent_id NUMBER(38,0) NOT NULL,
tax_year_month date DEFAULT sysdate,
year NUMBER(38,0) DEFAULT 0,
add_up_income varchar2(255) DEFAULT '' ,
add_up_subtraction varchar2(255) DEFAULT '' ,
add_up_social_security_total varchar2(255) DEFAULT '' ,
add_up_accumulation_fund_total varchar2(255) DEFAULT '' ,
add_up_child_education varchar2(255) DEFAULT '' ,
add_up_continuing_education varchar2(255) DEFAULT '' ,
add_up_housing_loan_interest varchar2(255) DEFAULT '' ,
add_up_housing_rent varchar2(255) DEFAULT '' ,
add_up_support_elderly varchar2(255) DEFAULT '' ,
add_up_enterprise_and_other varchar2(255) DEFAULT '',
add_up_other_deduction varchar2(255) DEFAULT '0.00000',
add_up_tax_exempt_income varchar2(255) DEFAULT '' ,
add_up_allowed_donation varchar2(255) DEFAULT '' ,
add_up_advance_tax varchar2(255) DEFAULT '' ,
create_time DATE DEFAULT sysdate,
update_time DATE DEFAULT sysdate,
creator NUMBER(38,0) DEFAULT 0 ,
delete_type number DEFAULT 0 ,
tenant_key varchar2(10) DEFAULT ''
);
/
create sequence hrsa_add_up_situation_id
start with 1
increment by 1
nomaxvalue
nocycle;
/
create or replace trigger hrsa_add_up_situation_Tri
before insert on hrsa_add_up_situation
for each row
begin
select hrsa_add_up_situation_id.nextval into :new.id from dual;
end;
/
CREATE TABLE hrsa_attend_quote(
id NUMBER(38,0) PRIMARY KEY NOT NULL,
salary_year_month date NOT NULL,
year number DEFAULT 0,
month number DEFAULT 0,
salary_sob_id NUMBER(38,0) DEFAULT '',
source_type number DEFAULT 0,
salary_accounting_status number DEFAULT 0,
attend_cycle varchar2(100) DEFAULT '' ,
salary_cycle varchar2(100) DEFAULT '' ,
description varchar2(100) DEFAULT '' ,
create_time DATE DEFAULT sysdate,
update_time DATE DEFAULT sysdate,
creator NUMBER(38,0) DEFAULT 0,
delete_type number DEFAULT 0,
tenant_key varchar2(10) DEFAULT ''
);
/
create sequence hrsa_attend_quote_id
start with 1
increment by 1
nomaxvalue
nocycle;
/
create or replace trigger hrsa_attend_quote_Tri
before insert on hrsa_attend_quote
for each row
begin
select hrsa_attend_quote_id.nextval into :new.id from dual;
end;
/
CREATE TABLE hrsa_attend_quote_data(
id NUMBER(38,0) PRIMARY KEY NOT NULL,
employee_id NUMBER(38,0) DEFAULT 0,
attend_quote_id NUMBER(38,0) DEFAULT 0,
create_time DATE DEFAULT sysdate,
update_time DATE DEFAULT sysdate,
creator NUMBER(38,0) DEFAULT 0,
delete_type number DEFAULT 0,
tenant_key varchar2(10) DEFAULT ''
);
/
CREATE TABLE hrsa_attend_quote_data_value(
id NUMBER(38,0) PRIMARY KEY NOT NULL,
employee_id NUMBER(38,0) DEFAULT 0,
attend_quote_id NUMBER(38,0) DEFAULT 0,
attend_quote_data_id NUMBER(38,0) NOT NULL,
attend_quote_field_id NUMBER(38,0) NOT NULL,
data_value varchar2(250) NOT NULL,
create_time date DEFAULT sysdate,
update_time DATE DEFAULT sysdate,
creator NUMBER(38,0) DEFAULT 0,
delete_type number DEFAULT 0,
tenant_key varchar2(10) DEFAULT ''
);
/
create sequence hrsa_attend_quote_d_v_id
start with 1
increment by 1
nomaxvalue
nocycle;
/
create or replace trigger hrsa_attend_quote_d_v_Tri
before insert on hrsa_attend_quote_data_value
for each row
begin
select hrsa_attend_quote_d_v_id.nextval into :new.id from dual;
end;
/
CREATE TABLE hrsa_attend_quote_field(
id NUMBER(38,0) PRIMARY KEY NOT NULL,
field_name varchar2(100) DEFAULT '' ,
source_type number DEFAULT 0,
field_type number DEFAULT 0,
enable_status number DEFAULT 0,
code varchar2(50) DEFAULT '' ,
description varchar2(100) DEFAULT '' ,
create_time DATE DEFAULT sysdate,
update_time DATE DEFAULT sysdate,
creator NUMBER(38,0) DEFAULT 0,
delete_type number DEFAULT 0,
tenant_key varchar2(10) DEFAULT ''
);
/
create sequence hrsa_attend_quote_field_id
start with 1
increment by 1
nomaxvalue
nocycle;
/
create or replace trigger hrsa_attend_quote_field_Tri
before insert on hrsa_attend_quote_field
for each row
begin
select hrsa_attend_quote_field_id.nextval into :new.id from dual;
end;
/
CREATE TABLE hrsa_attend_quote_sync_set(
id NUMBER(38,0) PRIMARY KEY NOT NULL,
source_type number DEFAULT 0,
current_setting_content varchar2(4000) DEFAULT '',
default_setting_content varchar2(4000) DEFAULT '' ,
create_time DATE DEFAULT sysdate,
update_time DATE DEFAULT sysdate,
creator NUMBER(38,0) DEFAULT 0,
delete_type number DEFAULT 0,
tenant_key varchar2(10) DEFAULT ''
);
/
create sequence hrsa_attend_quote_sync_set_id
start with 1
increment by 1
nomaxvalue
nocycle;
/
create or replace trigger hrsa_attend_quote_sync_set_Tri
before insert on hrsa_attend_quote_sync_set
for each row
begin
select hrsa_attend_quote_sync_set_id.nextval into :new.id from dual;
end;
/
CREATE TABLE hrsa_bill_batch(
id NUMBER(38,0) PRIMARY KEY NOT NULL,
bill_month varchar2(30) NOT NULL,
bill_status number NOT NULL,
social_num number DEFAULT 0,
fund_num number DEFAULT 0 ,
other_num number DEFAULT 0 ,
social_pay varchar2(4000) NULL,
fund_pay varchar2(4000) NULL,
other_pay varchar2(4000) NULL,
accountant varchar2(200) NOT NULL,
remarks varchar2(60) NULL,
creator NUMBER(38,0) DEFAULT 0,
create_time DATE DEFAULT sysdate,
update_time DATE DEFAULT sysdate,
delete_type number DEFAULT 0,
tenant_key varchar2(10) DEFAULT ''
);
/
create sequence hrsa_bill_batch_id
start with 1
increment by 1
nomaxvalue
nocycle;
/
create or replace trigger hrsa_bill_batch_Tri
before insert on hrsa_bill_batch
for each row
begin
select hrsa_bill_batch_id.nextval into :new.id from dual;
end;
/
CREATE TABLE hrsa_bill_batch_encdata(
id NUMBER(38,0) PRIMARY KEY NOT NULL,
tablename varchar2(50) NOT NULL,
fieldname varchar2(50) NOT NULL,
enc_value varchar2(4000) NOT NULL,
skey varchar2(4000) NOT NULL,
crc varchar2(4000) NULL,
creater NUMBER(38,0) NULL,
created varchar2(50) NULL,
MODIFIER NUMBER(38,0) NULL,
modified varchar2(50) NULL,
tenant_key varchar2(10) NULL
);
/
CREATE sequence hrsa_bill_batch_encdata_id
start with 1
increment by 1
nomaxvalue
nocycle;
/
create or replace trigger hrsa_bill_batch_encdata_Tri
before insert on hrsa_bill_batch_encdata
for each row
begin
select hrsa_bill_batch_encdata_id.nextval into :new.id from dual;
end;
/
CREATE TABLE hrsa_bill_detail(
id NUMBER(38,0) PRIMARY KEY NOT NULL,
employee_id NUMBER(38,0) NOT NULL,
bill_month varchar2(30) NOT NULL,
bill_status number NOT NULL,
payment_status number NOT NULL,
supplementary_month varchar2(50) NULL,
supplementary_projects varchar2(50) NULL,
resource_from number NOT NULL,
social_pay_org number NULL,
social_account varchar2(50) NULL,
social_scheme_id NUMBER(38,0) NULL,
social_payment_base_string varchar2(512) NULL,
fund_pay_org number NULL,
fund_account varchar2(50) NULL,
supplement_fund_account varchar2(50) NULL,
fund_scheme_id number NULL,
fund_payment_base_string varchar2(512) NULL,
other_pay_org number NULL,
other_scheme_id NUMBER(38,0) NULL,
other_payment_base_string varchar2(512) NULL,
social_per_json varchar2(512) NULL,
social_per_sum varchar2(512) NULL,
fund_per_json varchar2(512) NULL,
fund_per_sum varchar2(512) NULL,
other_per_json varchar2(512) NULL,
other_per_sum varchar2(512) NULL,
per_sum varchar2(512) NULL,
social_com_json varchar2(512) NULL,
social_com_sum varchar2(512) NULL,
fund_com_json varchar2(512) NULL,
fund_com_sum varchar2(512) NULL,
other_com_json varchar2(512) NULL,
other_com_sum varchar2(512) NULL,
com_sum varchar2(512) NULL,
social_sum varchar2(512) NULL,
fund_sum varchar2(512) NULL,
other_sum varchar2(512) NULL,
total varchar2(512) NULL,
creator NUMBER(38,0) NOT NULL,
create_time date NOT NULL,
update_time date NOT NULL,
delete_type number DEFAULT 0,
tenant_key varchar2(10) NOT NULL
);
/
CREATE sequence hrsa_bill_detail_id
start with 1
increment by 1
nomaxvalue
nocycle;
/
create or replace trigger hrsa_bill_detail_Tri
before insert on hrsa_bill_detail
for each row
begin
select hrsa_bill_detail_id.nextval into :new.id from dual;
end;
/
CREATE TABLE hrsa_bill_detail_temp(
id NUMBER(38,0) PRIMARY KEY NOT NULL,
employee_id NUMBER(38,0) NOT NULL,
bill_month varchar2(30) NOT NULL,
bill_status number NOT NULL,
payment_status number NOT NULL,
supplementary_month varchar2(50) NULL,
supplementary_projects varchar2(50) NULL,
resource_from number NOT NULL,
social_pay_org number NULL,
social_account varchar2(50) NULL,
social_scheme_id NUMBER(38,0) NULL,
social_payment_base_string varchar2(512) NULL,
fund_pay_org number NULL,
fund_account varchar2(50) NULL,
supplement_fund_account varchar2(50) NULL,
fund_scheme_id NUMBER(38,0) NULL,
fund_payment_base_string varchar2(512) NULL,
other_pay_org number NULL,
other_scheme_id number NULL,
other_payment_base_string varchar2(512) NULL,
social_per_json varchar2(512) NULL,
social_per_sum varchar2(512) NULL,
fund_per_json varchar2(512) NULL,
fund_per_sum varchar2(512) NULL,
other_per_json varchar2(512) NULL,
other_per_sum varchar2(512) NULL,
per_sum varchar2(512) NULL,
social_com_json varchar2(512) NULL,
social_com_sum varchar2(512) NULL,
fund_com_json varchar2(512) NULL,
fund_com_sum varchar2(512) NULL,
other_com_json varchar2(512) NULL,
other_com_sum varchar2(512) NULL,
com_sum varchar2(512) NULL,
social_sum varchar2(512) NULL,
fund_sum varchar2(512) NULL,
other_sum varchar2(512) NULL,
total varchar2(512) NULL,
creator NUMBER(38,0) NOT NULL,
create_time date NOT NULL,
update_time date NOT NULL,
delete_type number DEFAULT 0,
tenant_key varchar2(10) NOT NULL
);
/
CREATE sequence hrsa_bill_detail_temp_id
start with 1
increment by 1
nomaxvalue
nocycle;
/
create or replace trigger hrsa_bill_detail_temp_Tri
before insert on hrsa_bill_detail_temp
for each row
begin
select hrsa_bill_detail_temp_id.nextval into :new.id from dual;
end;
/
CREATE TABLE hrsa_bill_inspect(
id NUMBER(38,0) PRIMARY KEY NOT NULL,
employee_id NUMBER(38,0) NOT NULL,
bill_month varchar2(30) NOT NULL,
payment_status number NOT NULL,
supplementary_month varchar2(50) NULL,
supplementary_projects varchar2(50) NULL,
inspect_status number NOT NULL,
creator NUMBER(38,0) NOT NULL,
create_time date NOT NULL,
update_time date NOT NULL,
delete_type number DEFAULT 0,
tenant_key varchar2(10) NOT NULL
);
/
CREATE sequence hrsa_bill_inspect_id
start with 1
increment by 1
nomaxvalue
nocycle;
/
create or replace trigger hrsa_bill_inspect_Tri
before insert on hrsa_bill_inspect
for each row
begin
select hrsa_bill_inspect_id.nextval into :new.id from dual;
end;
/
CREATE TABLE hrsa_check_result(
id NUMBER(38,0) PRIMARY KEY NOT NULL,
salary_acct_record_id NUMBER(38,0) NOT NULL,
salary_check_rule_id NUMBER(38,0) NOT NULL,
formula_id NUMBER(38,0) NOT NULL,
ignore_type number NOT NULL,
creator NUMBER(38,0) NOT NULL,
create_time date NOT NULL,
update_time date NOT NULL,
delete_type number DEFAULT 0,
tenant_key varchar2(10) NOT NULL
);
/
CREATE sequence hrsa_check_result_id
start with 1
increment by 1
nomaxvalue
nocycle;
/
create or replace trigger hrsa_check_result_Tri
before insert on hrsa_check_result
for each row
begin
select hrsa_check_result_id.nextval into :new.id from dual;
end;
/
CREATE TABLE hrsa_check_result_record(
id NUMBER(38,0) PRIMARY KEY NOT NULL,
salary_acct_record_id NUMBER(38,0) NOT NULL,
salary_check_rule_id NUMBER(38,0) NOT NULL,
formula_id NUMBER(38,0) NOT NULL,
check_result_id NUMBER(38,0) NOT NULL,
salary_acct_emp_id NUMBER(38,0) NOT NULL,
employee_id NUMBER(38,0) NOT NULL,
creator NUMBER(38,0) NOT NULL,
create_time date NOT NULL,
update_time date NOT NULL,
delete_type number DEFAULT 0,
tenant_key varchar2(10) NOT NULL
);
/
CREATE sequence hrsa_check_result_record_id
start with 1
increment by 1
nomaxvalue
nocycle;
/
create or replace trigger hrsa_check_result_record_Tri
before insert on hrsa_check_result_record
for each row
begin
select hrsa_check_result_record_id.nextval into :new.id from dual;
end;
/
CREATE TABLE hrsa_ck_result_detail_temp(
id NUMBER(38,0) PRIMARY KEY NOT NULL,
salary_acct_emp_id NUMBER(38,0) NOT NULL,
salary_acct_record_id NUMBER(38,0) NOT NULL,
employee_id NUMBER(38,0) NOT NULL,
salary_check_rule_id NUMBER(38,0) NOT NULL,
formula_id NUMBER(38,0) NOT NULL,
creator NUMBER(38,0) NOT NULL,
create_time date NOT NULL,
update_time date NOT NULL,
delete_type number DEFAULT 0,
tenant_key varchar2(10) NOT NULL,
calculate_key varchar2(50) NOT NULL
);
/
CREATE sequence hrsa_ck_result_detail_temp_id
start with 1
increment by 1
nomaxvalue
nocycle;
/
create or replace trigger hrsa_ck_result_detail_temp_Tri
before insert on hrsa_ck_result_detail_temp
for each row
begin
select hrsa_ck_result_detail_temp_id.nextval into :new.id from dual;
end;
/
CREATE TABLE hrsa_excel_acct_result(
id NUMBER(38,0) PRIMARY KEY NOT NULL,
salary_sob_id NUMBER(38,0) NOT NULL,
salary_acct_emp_id NUMBER(38,0) NOT NULL,
salary_acct_record_id NUMBER(38,0) NOT NULL,
employee_id NUMBER(38,0) NOT NULL,
salary_item_id NUMBER(38,0) NOT NULL,
result_value varchar2(1000) NOT NULL,
creator NUMBER(38,0) NOT NULL,
create_time date NOT NULL,
update_time date NOT NULL,
delete_type number DEFAULT 0,
tenant_key varchar2(10) NOT NULL,
tax_agent_id NUMBER(38,0) NOT NULL
);
/
CREATE sequence hrsa_excel_acct_result_id
start with 1
increment by 1
nomaxvalue
nocycle;
/
create or replace trigger hrsa_excel_acct_result_Tri
before insert on hrsa_excel_acct_result
for each row
begin
select hrsa_excel_acct_result_id.nextval into :new.id from dual;
end;
/
CREATE TABLE hrsa_formula(
id NUMBER(38,0) PRIMARY KEY NOT NULL,
name varchar2(255) NOT NULL,
description varchar2(255) NULL ,
module varchar2(255) NOT NULL,
use_for varchar2(255) NULL ,
reference_type varchar2(255) NULL ,
return_type varchar2(255) NOT NULL,
validate_type varchar2(255) NOT NULL,
extend_param varchar2(255) NULL ,
formula varchar2(4000) NOT NULL,
formulaRunScript varchar2(4000) NOT NULL,
creator NUMBER(38,0) NOT NULL,
delete_type number DEFAULT 0,
create_time date NOT NULL,
update_time date NOT NULL
);
/
CREATE TABLE hrsa_formula_var(
id NUMBER(38,0) PRIMARY KEY NOT NULL,
name varchar2(255) NOT NULL,
formula_id NUMBER(38,0) NOT NULL,
field_id varchar2(255) NOT NULL,
field_name varchar2(500) NOT NULL,
field_type varchar2(255) NOT NULL,
source varchar2(255) NOT NULL,
order_index number NOT NULL,
creator NUMBER(38,0) NOT NULL,
delete_type number DEFAULT 0,
create_time date NOT NULL,
update_time date NOT NULL
);
/
CREATE TABLE hrsa_fund_archives(
id number PRIMARY KEY NOT NULL,
employee_id number NOT NULL,
non_payment number NULL,
welfare_type number NOT NULL,
fund_start_time varchar2(20) NULL,
fund_end_time varchar2(20) NULL,
fund_scheme_id number NULL,
fund_account varchar2(50) NULL,
supplement_fund_account varchar2(50) NULL,
payment_organization number NULL,
under_take number NULL,
fund_payment_base_string varchar2(4000) NULL,
create_time date NOT NULL,
update_time date NOT NULL,
creator number NOT NULL,
delete_type number DEFAULT 0,
tenant_key varchar2(10) DEFAULT ''
);
/
CREATE sequence hrsa_fund_archives_id
start with 1
increment by 1
nomaxvalue
nocycle;
/
create or replace trigger hrsa_fund_archives_Tri
before insert on hrsa_fund_archives
for each row
begin
select hrsa_fund_archives_id.nextval into :new.id from dual;
end;
/
CREATE TABLE hrsa_insurance_category(
id NUMBER(38,0) PRIMARY KEY NOT NULL,
insurance_name varchar2(50) NOT NULL,
welfare_type number NOT NULL,
is_use number DEFAULT 1,
payment_scope varchar2(10) NULL,
data_type number DEFAULT 0,
create_time DATE DEFAULT sysdate,
update_time DATE DEFAULT sysdate,
creator NUMBER(38,0) DEFAULT 0,
delete_type number DEFAULT 0,
tenant_key varchar2(10) DEFAULT ''
);
/
CREATE TABLE hrsa_other_archives(
id NUMBER(38,0) PRIMARY KEY NOT NULL,
employee_id NUMBER(38,0) NOT NULL,
non_payment number NULL,
welfare_type number NOT NULL,
other_start_time varchar2(20) NULL,
other_end_time varchar2(20) NULL,
other_scheme_id NUMBER(38,0) NULL,
payment_organization number NULL,
under_take number NULL,
other_payment_base_string varchar2(4000) NULL,
create_time date NOT NULL,
update_time date NOT NULL,
creator NUMBER(38,0) NOT NULL,
delete_type number DEFAULT 0,
tenant_key varchar2(10) DEFAULT ''
);
/
CREATE sequence hrsa_other_archives_id
start with 1
increment by 1
nomaxvalue
nocycle;
/
create or replace trigger hrsa_other_archives_Tri
before insert on hrsa_other_archives
for each row
begin
select hrsa_other_archives_id.nextval into :new.id from dual;
end;
/
CREATE TABLE hrsa_other_deduction(
id NUMBER(38,0) PRIMARY KEY NOT NULL,
employee_id NUMBER(38,0) NOT NULL,
tax_agent_id NUMBER(38,0) NOT NULL,
declare_month date DEFAULT sysdate,
business_healthy_insurance varchar2(255) DEFAULT '0.00000',
tax_delay_endowment_insurance varchar2(255) DEFAULT '',
other_deduction varchar2(255) DEFAULT '',
deduction_allowed_donation varchar2(255) DEFAULT '',
create_time DATE DEFAULT sysdate,
update_time DATE DEFAULT sysdate,
creator NUMBER(38,0) DEFAULT 0,
delete_type number DEFAULT 0,
tenant_key varchar2(10) DEFAULT ''
);
/
CREATE sequence hrsa_other_deduction_id
start with 1
increment by 1
nomaxvalue
nocycle;
/
create or replace trigger hrsa_other_deduction_Tri
before insert on hrsa_other_deduction
for each row
begin
select hrsa_other_deduction_id.nextval into :new.id from dual;
end;
/
CREATE TABLE hrsa_salary_acct_emp(
id NUMBER(38,0) PRIMARY KEY NOT NULL,
salary_acct_record_id NUMBER(38,0) DEFAULT 0,
salary_sob_id NUMBER(38,0) DEFAULT 0,
employee_id NUMBER(38,0) DEFAULT 0,
tax_agent_id NUMBER(38,0) DEFAULT 0,
salary_month DATE DEFAULT to_date('1900-01-01','YYYY-DD-mm'),
creator NUMBER(38,0) DEFAULT 0,
create_time DATE DEFAULT sysdate,
update_time DATE DEFAULT sysdate,
delete_type number DEFAULT 0,
tenant_key varchar2(10) DEFAULT ''
);
/
CREATE sequence hrsa_salary_acct_emp_id
start with 1
increment by 1
nomaxvalue
nocycle;
/
create or replace trigger hrsa_salary_acct_emp_Tri
before insert on hrsa_salary_acct_emp
for each row
begin
select hrsa_salary_acct_emp_id.nextval into :new.id from dual;
end;
/
CREATE TABLE hrsa_salary_acct_record(
id NUMBER(38,0) PRIMARY KEY NOT NULL,
salary_month DATE DEFAULT to_date('1900-01-01','YYYY-DD-mm'),
tax_cycle DATE DEFAULT to_date('1900-01-01','YYYY-DD-mm'),
salary_sob_id NUMBER(38,0) DEFAULT 0,
status number DEFAULT 1,
acct_times number DEFAULT 0,
description varchar2(100) DEFAULT '',
creator NUMBER(38,0) DEFAULT 0,
create_time DATE DEFAULT sysdate,
update_time DATE DEFAULT sysdate,
delete_type number DEFAULT 0,
tenant_key varchar2(10) DEFAULT ''
);
/
CREATE sequence hrsa_salary_acct_record_id
start with 1
increment by 1
nomaxvalue
nocycle;
/
create or replace trigger hrsa_salary_acct_record_Tri
before insert on hrsa_salary_acct_record
for each row
begin
select hrsa_salary_acct_record_id.nextval into :new.id from dual;
end;
/
CREATE TABLE hrsa_salary_acct_result(
id NUMBER(38,0) PRIMARY KEY NOT NULL,
salary_sob_id NUMBER(38,0) DEFAULT 0,
salary_acct_emp_id NUMBER(38,0) DEFAULT 0,
salary_acct_record_id NUMBER(38,0) DEFAULT 0,
employee_id NUMBER(38,0) DEFAULT 0,
tax_agent_id NUMBER(38,0) DEFAULT 0,
salary_item_id NUMBER(38,0) DEFAULT 0,
result_value varchar2(1000) DEFAULT '' ,
creator NUMBER(38,0) DEFAULT 0,
create_time DATE DEFAULT sysdate,
update_time DATE DEFAULT sysdate,
delete_type number DEFAULT 0,
tenant_key varchar2(10) DEFAULT ''
);
/
CREATE sequence hrsa_salary_acct_result_id
start with 1
increment by 1
nomaxvalue
nocycle;
/
create or replace trigger hrsa_salary_acct_result_Tri
before insert on hrsa_salary_acct_result
for each row
begin
select hrsa_salary_acct_result_id.nextval into :new.id from dual;
end;
/
CREATE TABLE hrsa_salary_archive(
id NUMBER(38,0) PRIMARY KEY NOT NULL,
employee_id NUMBER(38,0) NOT NULL,
create_time DATE DEFAULT sysdate,
update_time DATE DEFAULT sysdate,
creator NUMBER(38,0) DEFAULT 0,
delete_type number DEFAULT 0,
tenant_key varchar2(10) DEFAULT ''
);
/
CREATE TABLE hrsa_salary_archive_dimission(
id NUMBER(38,0) PRIMARY KEY NOT NULL,
dimission_time_interval varchar2(20) NOT NULL,
create_time date NOT NULL,
update_time date NOT NULL,
creator NUMBER(38,0) NOT NULL,
delete_type number DEFAULT 0,
tenant_key varchar2(10) NOT NULL
);
/
CREATE sequence hrsa_salary_archive_d_id
start with 1
increment by 1
nomaxvalue
nocycle;
/
create or replace trigger hrsa_salary_archive_d_Tri
before insert on hrsa_salary_archive_dimission
for each row
begin
select hrsa_salary_archive_d_id.nextval into :new.id from dual;
end;
/
CREATE TABLE hrsa_salary_archive_item(
id NUMBER(38,0) NOT NULL,
salary_archive_id NUMBER(38,0) NOT NULL,
employee_id NUMBER(38,0) DEFAULT 0,
effective_time DATE DEFAULT sysdate,
adjust_reason varchar2(100) DEFAULT '',
salary_item_id NUMBER(38,0) DEFAULT 0,
item_value varchar2(200) DEFAULT '' ,
description varchar2(200) DEFAULT '' ,
operator NUMBER(38,0) DEFAULT 0,
operate_time date NULL ,
create_time DATE DEFAULT sysdate,
update_time DATE DEFAULT sysdate,
creator NUMBER(38,0) DEFAULT 0,
delete_type number DEFAULT 0,
tenant_key varchar2(10) DEFAULT ''
);
/
CREATE sequence hrsa_salary_archive_item_id
start with 1
increment by 1
nomaxvalue
nocycle;
/
create or replace trigger hhrsa_salary_archive_item_Tri
before insert on hrsa_salary_archive_item
for each row
begin
select hrsa_salary_archive_item_id.nextval into :new.id from dual;
end;
/
CREATE TABLE hrsa_salary_archive_tax_agent(
id NUMBER(38,0) PRIMARY KEY NOT NULL,
salary_archive_id NUMBER(38,0) NOT NULL,
employee_id NUMBER(38,0) DEFAULT 0,
effective_time DATE DEFAULT sysdate,
adjust_reason varchar2(100) DEFAULT '' ,
tax_agent_id NUMBER(38,0) DEFAULT 0,
operator NUMBER(38,0) DEFAULT 0,
operate_time date NULL ,
description varchar2(200) DEFAULT '' ,
create_time DATE DEFAULT sysdate,
update_time DATE DEFAULT sysdate,
creator NUMBER(38,0) DEFAULT 0,
delete_type number DEFAULT 0,
tenant_key varchar2(10) DEFAULT ''
);
/
CREATE sequence hrsa_salary_archive_tax_a_id
start with 1
increment by 1
nomaxvalue
nocycle;
/
create or replace trigger hrsa_salary_archive_tax_a_Tri
before insert on hrsa_salary_archive_tax_agent
for each row
begin
select hrsa_salary_archive_tax_a_id.nextval into :new.id from dual;
end;
/
CREATE TABLE hrsa_salary_item(
id NUMBER(38,0) PRIMARY KEY NOT NULL,
name varchar2(100) DEFAULT '' ,
code varchar2(100) DEFAULT '' ,
system_type number DEFAULT 0,
sys_salary_item_id NUMBER(38,0) DEFAULT 0,
category number DEFAULT 7 ,
item_type number DEFAULT 1 ,
use_default number DEFAULT 0,
use_in_employee_salary number DEFAULT 0,
rounding_mode number DEFAULT 1 ,
pattern number DEFAULT 5 ,
value_type number DEFAULT 1 ,
datasource number DEFAULT 0,
formula_id NUMBER(38,0) DEFAULT 0,
description varchar2(1000) DEFAULT '',
can_edit number DEFAULT 1 ,
can_delete number DEFAULT 1 ,
creator NUMBER(38,0) DEFAULT 0,
delete_type number DEFAULT 0,
tenant_key varchar2(10) DEFAULT '' ,
create_time DATE DEFAULT sysdate,
update_time DATE DEFAULT sysdate,
data_type varchar2(20) NOT NULL
);
/
CREATE TABLE hrsa_salary_send(
id NUMBER(38,0) PRIMARY KEY NOT NULL,
salary_month date NOT NULL,
salary_accounting_id NUMBER(38,0) DEFAULT 0,
salary_sob_id NUMBER(38,0) NOT NULL,
send_num number DEFAULT 0,
send_total number DEFAULT 0,
last_send_time DATE DEFAULT sysdate,
creator NUMBER(38,0) DEFAULT 0,
create_time DATE DEFAULT sysdate,
update_time DATE DEFAULT sysdate,
delete_type number DEFAULT 0,
tenant_key varchar2(10) DEFAULT ''
);
/
CREATE TABLE hrsa_salary_send_info(
id NUMBER(38,0) PRIMARY KEY NOT NULL,
salary_send_id NUMBER(38,0) NOT NULL,
salary_month date NOT NULL,
salary_acct_record_id NUMBER(38,0) DEFAULT 0,
tax_agent_id NUMBER(38,0) DEFAULT 0,
employee_id NUMBER(38,0) DEFAULT 0,
send_status number DEFAULT 0,
send_time DATE ,
salary_template clob NULL,
creator NUMBER(38,0) DEFAULT 0,
create_time DATE DEFAULT sysdate,
update_time DATE DEFAULT sysdate,
delete_type number DEFAULT 0,
tenant_key varchar2(10) DEFAULT ''
);
/
CREATE TABLE hrsa_salary_sob(
id NUMBER(38,0) PRIMARY KEY NOT NULL,
name varchar2(100) DEFAULT '' ,
income_category number DEFAULT 1 ,
salary_cycle_type number DEFAULT 3 ,
salary_cycle_from_day number DEFAULT 1 ,
tax_cycle_type number DEFAULT 3 ,
attend_cycle_type number DEFAULT 3 ,
attend_cycle_from_day number DEFAULT 1 ,
social_security_cycle_type number DEFAULT 3 ,
disable number DEFAULT 0,
description varchar2(1000) DEFAULT '',
creator NUMBER(38,0) DEFAULT 0,
create_time DATE DEFAULT sysdate,
update_time DATE DEFAULT sysdate,
delete_type number DEFAULT 0,
tenant_key varchar2(10) DEFAULT ''
);
/
CREATE sequence hrsa_salary_sob_id
start with 1
increment by 1
nomaxvalue
nocycle;
/
create or replace trigger hrsa_salary_sob_Tri
before insert on hrsa_salary_sob
for each row
begin
select hrsa_salary_sob_id.nextval into :new.id from dual;
end;
/
CREATE TABLE hrsa_salary_sob_adjust_rule(
id NUMBER(38,0) PRIMARY KEY NOT NULL,
salary_sob_id NUMBER(38,0) NOT NULL,
salary_item_id NUMBER(38,0) NOT NULL,
day_of_month number DEFAULT 0,
before_adjustment_type number DEFAULT 1 ,
after_adjustment_type number DEFAULT 1 ,
creator NUMBER(38,0) DEFAULT 0,
create_time DATE DEFAULT sysdate,
update_time DATE DEFAULT sysdate,
delete_type number DEFAULT 0,
tenant_key varchar2(10) DEFAULT ''
);
/
CREATE sequence hrsa_salary_sob_a_r_id
start with 1
increment by 1
nomaxvalue
nocycle;
/
create or replace trigger hrsa_salary_sob_a_r_Tri
before insert on hrsa_salary_sob_adjust_rule
for each row
begin
select hrsa_salary_sob_a_r_id.nextval into :new.id from dual;
end;
/
CREATE TABLE hrsa_salary_sob_check_rule(
id NUMBER(38,0) PRIMARY KEY NOT NULL,
salary_sob_id NUMBER(38,0) NOT NULL,
name varchar2(100) NOT NULL,
formula_id NUMBER(38,0) NOT NULL,
description varchar2(1000) NOT NULL,
create_time date NOT NULL,
update_time date NOT NULL,
creator NUMBER(38,0) NOT NULL,
delete_type number DEFAULT 0,
tenant_key varchar2(10) NOT NULL
);
/
CREATE sequence hrsa_salary_sob_c_r_id
start with 1
increment by 1
nomaxvalue
nocycle;
/
create or replace trigger hrsa_salary_sob_c_r_Tri
before insert on hrsa_salary_sob_check_rule
for each row
begin
select hrsa_salary_sob_c_r_id.nextval into :new.id from dual;
end;
/
CREATE TABLE hrsa_salary_sob_default_item(
id NUMBER(38,0) PRIMARY KEY NOT NULL,
income_category number DEFAULT 1 ,
sys_salary_item_id NUMBER(38,0) DEFAULT 0,
can_edit number DEFAULT 1 ,
can_delete number DEFAULT 1 ,
creator NUMBER(38,0) DEFAULT 0,
create_time DATE DEFAULT sysdate,
update_time DATE DEFAULT sysdate,
delete_type number DEFAULT 0,
tenant_key varchar2(10) DEFAULT '',
sob_default_item_group_id NUMBER(38,0) NOT NULL,
sorted_index number NOT NULL
);
/
CREATE sequence hrsa_salary_sob_d_i_id
start with 1
increment by 1
nomaxvalue
nocycle;
/
create or replace trigger hrsa_salary_sob_d_i_Tri
before insert on hrsa_salary_sob_default_item
for each row
begin
select hrsa_salary_sob_d_i_id.nextval into :new.id from dual;
end;
/
CREATE TABLE hrsa_salary_sob_emp_field(
id NUMBER(38,0) PRIMARY KEY NOT NULL,
salary_sob_id NUMBER(38,0) DEFAULT 0,
field_code varchar2(100) DEFAULT '' ,
sorted_index number DEFAULT 0,
can_delete number DEFAULT 1 ,
creator NUMBER(38,0) DEFAULT 0,
create_time DATE DEFAULT sysdate,
update_time DATE DEFAULT sysdate,
delete_type number DEFAULT 0,
tenant_key varchar2(10) DEFAULT ''
);
/
CREATE sequence hrsa_salary_sob_emp_field_id
start with 1
increment by 1
nomaxvalue
nocycle;
/
create or replace trigger hrsa_salary_sob_emp_field_Tri
before insert on hrsa_salary_sob_emp_field
for each row
begin
select hrsa_salary_sob_emp_field_id.nextval into :new.id from dual;
end;
/
CREATE TABLE hrsa_salary_sob_item(
id NUMBER(38,0) PRIMARY KEY NOT NULL,
salary_sob_id NUMBER(38,0) NOT NULL,
salary_item_id NUMBER(38,0) NOT NULL,
salary_sob_item_group_id NUMBER(38,0) NOT NULL,
formula_id NUMBER(38,0) NOT NULL,
sorted_index number NOT NULL,
description varchar2(1000) DEFAULT '' ,
create_time date NOT NULL,
update_time date NOT NULL,
creator NUMBER(38,0) NOT NULL,
delete_type number DEFAULT 0,
tenant_key varchar2(10) NOT NULL
);
/
CREATE sequence hrsa_salary_sob_item_id
start with 1
increment by 1
nomaxvalue
nocycle;
/
create or replace trigger hrsa_salary_sob_item_Tri
before insert on hrsa_salary_sob_item
for each row
begin
select hrsa_salary_sob_item_id.nextval into :new.id from dual;
end;
/
CREATE TABLE hrsa_salary_sob_item_group(
id NUMBER(38,0) PRIMARY KEY NOT NULL,
salary_sob_id NUMBER(38,0) NOT NULL,
name varchar2(100) NOT NULL,
sorted_index number NOT NULL,
description varchar2(1000) DEFAULT '',
create_time date NOT NULL,
update_time date NOT NULL,
creator NUMBER(38,0) NOT NULL,
delete_type number DEFAULT 0,
tenant_key varchar2(10) NOT NULL
);
/
CREATE TABLE hrsa_salary_sob_range(
id NUMBER(38,0) PRIMARY KEY NOT NULL,
salary_sob_id NUMBER(38,0) DEFAULT 0,
target_type number DEFAULT 1 ,
target_id NUMBER(38,0) DEFAULT 0,
employee_status number DEFAULT 0,
include_type number DEFAULT 1 ,
creator NUMBER(38,0) DEFAULT 0,
create_time DATE DEFAULT sysdate,
update_time DATE DEFAULT sysdate,
delete_type number DEFAULT 0,
tenant_key varchar2(10) DEFAULT ''
);
/
CREATE sequence hrsa_salary_sob_range_id
start with 1
increment by 1
nomaxvalue
nocycle;
/
create or replace trigger hrsa_salary_sob_range_Tri
before insert on hrsa_salary_sob_range
for each row
begin
select hrsa_salary_sob_range_id.nextval into :new.id from dual;
end;
/
CREATE TABLE hrsa_salary_template
(
id NUMBER(38,0) PRIMARY KEY NOT NULL,
name varchar2(100) DEFAULT '',
salary_sob_id NUMBER(38,0) NOT NULL,
use_type number DEFAULT 0,
description varchar2(100) DEFAULT '',
email_status number DEFAULT 0,
send_email_id NUMBER(38,0) DEFAULT 0,
msg_status number DEFAULT 0,
theme varchar2(100) DEFAULT '',
background varchar2(2000) DEFAULT '',
text_content varchar2(100) DEFAULT '',
text_content_position number DEFAULT 0,
salary_item_null_status number DEFAULT 0,
salary_item_zero_status number DEFAULT 0,
salary_item_setting clob NOT NULL,
create_time DATE DEFAULT sysdate,
update_time DATE DEFAULT sysdate,
creator NUMBER(38,0) DEFAULT 0,
delete_type number DEFAULT 0,
tenant_key varchar2(10) DEFAULT ''
);
/
CREATE sequence hrsa_salary_template_id
start with 1
increment by 1
nomaxvalue
nocycle;
/
create or replace trigger hrsa_salary_template_Tri
before insert on hrsa_salary_template
for each row
begin
select hrsa_salary_template_id.nextval into :new.id from dual;
end;
/
CREATE TABLE hrsa_scheme_detail(
id NUMBER(38,0) PRIMARY KEY NOT NULL,
insurance_id NUMBER(38,0) NOT NULL,
primary_id NUMBER(38,0) NOT NULL,
effective_time varchar2(20) NULL,
expiration_time varchar2(20) NULL,
is_payment number DEFAULT 1 ,
payment_scope number NOT NULL,
upper_limit varchar2(1024) NULL,
lower_limit varchar2(1024) NULL,
payment_proportion varchar2(1024) NULL,
fixed_cost varchar2(1024) NULL,
valid_num number DEFAULT 2 ,
rentention_rule number NULL,
create_time DATE DEFAULT sysdate,
update_time DATE DEFAULT sysdate,
creator NUMBER(38,0) DEFAULT 0,
delete_type number DEFAULT 0,
tenant_key varchar2(10) DEFAULT ''
);
/
CREATE sequence hrsa_scheme_detail_id
start with 1
increment by 1
nomaxvalue
nocycle;
/
create or replace trigger hrsa_scheme_detail_Tri
before insert on hrsa_scheme_detail
for each row
begin
select hrsa_scheme_detail_id.nextval into :new.id from dual;
end;
/
CREATE TABLE hrsa_sob_default_emp_field(
id NUMBER(38,0) PRIMARY KEY NOT NULL,
field_code varchar2(30) DEFAULT '' ,
sorted_index number DEFAULT 0,
can_delete number DEFAULT 0,
creator NUMBER(38,0) DEFAULT 0,
create_time DATE DEFAULT sysdate,
update_time DATE DEFAULT sysdate,
delete_type number DEFAULT 0,
tenant_key varchar2(10) DEFAULT ''
);
/
CREATE TABLE hrsa_sob_default_item_group(
id NUMBER(38,0) PRIMARY KEY NOT NULL,
income_category number DEFAULT 1 ,
name varchar2(100) DEFAULT '',
sorted_index number DEFAULT 0,
description varchar2(1000) DEFAULT '',
create_time date NOT NULL,
update_time date NOT NULL,
creator NUMBER(38,0) DEFAULT 0,
delete_type number DEFAULT 0,
tenant_key varchar2(10) DEFAULT ''
);
/
CREATE TABLE hrsa_social_archives(
id number PRIMARY KEY NOT NULL,
employee_id number NOT NULL,
non_payment number NULL,
welfare_type number NOT NULL,
social_start_time varchar2(20) NULL,
social_end_time varchar2(20) NULL,
social_scheme_id number NULL,
social_account varchar2(50) NULL,
payment_organization number NULL,
under_take number NULL,
social_payment_base_string varchar2(4000) NULL,
create_time date NOT NULL,
update_time date NOT NULL,
creator number NOT NULL,
delete_type number DEFAULT 0,
tenant_key varchar2(10) DEFAULT ''
);
/
CREATE sequence hrsa_social_archives_id
start with 1
increment by 1
nomaxvalue
nocycle;
/
create or replace trigger hrsa_social_archives_Tri
before insert on hrsa_social_archives
for each row
begin
select hrsa_social_archives_id.nextval into :new.id from dual;
end;
/
CREATE TABLE hrsa_social_archives_encdata(
id number PRIMARY KEY NOT NULL,
tablename varchar2(50) NOT NULL,
fieldname varchar2(50) NOT NULL,
enc_value varchar2(4000) NOT NULL,
skey varchar2(4000) NOT NULL,
crc varchar2(4000) NULL,
creater number NULL,
created varchar2(50) NULL,
MODIFIER number NULL,
modified varchar2(50) NULL,
tenant_key varchar2(10) NULL
);
/
CREATE sequence hrsa_social_a_e_id
start with 1
increment by 1
nomaxvalue
nocycle;
/
create or replace trigger hrsa_social_a_e_Tri
before insert on hrsa_social_archives_encdata
for each row
begin
select hrsa_social_a_e_id.nextval into :new.id from dual;
end;
/
CREATE TABLE hrsa_social_security_scheme(
id number PRIMARY KEY NOT NULL,
payment_area varchar2(100) NOT NULL,
payment_type number DEFAULT 1 ,
scheme_name varchar2(100) NOT NULL,
welfare_type number NOT NULL,
is_use number DEFAULT 1 ,
remarks varchar2(30) DEFAULT '',
create_time DATE DEFAULT sysdate,
update_time DATE DEFAULT sysdate,
creator number DEFAULT 0,
delete_type number DEFAULT 0,
tenant_key varchar2(10) DEFAULT ''
);
/
CREATE sequence hrsa_social_s_s_id
start with 1
increment by 1
nomaxvalue
nocycle;
/
create or replace trigger hrsa_social_s_s_Tri
before insert on hrsa_social_security_scheme
for each row
begin
select hrsa_social_s_s_id.nextval into :new.id from dual;
end;
/
CREATE TABLE hrsa_sys_salary_item(
id NUMBER(38,0) PRIMARY KEY NOT NULL,
name varchar2(100) DEFAULT '',
code varchar2(100) DEFAULT '',
system_type number DEFAULT 0,
category number DEFAULT 7 ,
item_type number DEFAULT 1 ,
use_default number DEFAULT 0,
use_in_employee_salary number DEFAULT 0,
rounding_mode number DEFAULT 1 ,
pattern number DEFAULT 5 ,
value_type number DEFAULT 1 ,
datasource number DEFAULT 0,
formula_id NUMBER(38,0) DEFAULT 0,
description varchar2(1000) DEFAULT '',
can_edit number DEFAULT 1 ,
can_delete number DEFAULT 1 ,
creator NUMBER(38,0) DEFAULT 0,
delete_type number DEFAULT 0,
tenant_key varchar2(10) DEFAULT '',
create_time DATE DEFAULT sysdate,
update_time DATE DEFAULT sysdate,
data_type varchar2(20) NOT NULL
);
/
CREATE TABLE hrsa_sys_tax_rate_base(
id number PRIMARY KEY NOT NULL,
name varchar2(100) NOT NULL,
system_type number NOT NULL,
description varchar2(100) NOT NULL,
create_time date NOT NULL,
update_time date NOT NULL,
creator number NOT NULL,
delete_type number DEFAULT 0,
tenant_key varchar2(10) NOT NULL
);
/
CREATE sequence hrsa_sys_tax_rate_base_id
start with 1
increment by 1
nomaxvalue
nocycle;
/
create or replace trigger hrsa_sys_tax_rate_base_Tri
before insert on hrsa_sys_tax_rate_base
for each row
begin
select hrsa_sys_tax_rate_base_id.nextval into :new.id from dual;
end;
/
CREATE TABLE hrsa_sys_tax_rate_detail(
id number PRIMARY KEY NOT NULL,
base_id number NOT NULL,
index_num number NOT NULL,
income_lower_limit number(15, 5) NULL,
income_upper_limit number(15, 5) NULL,
duty_free_value number(15, 5) NULL,
duty_free_rate number(15, 5) NULL,
taxable_income_ll number(15, 5) NULL,
taxable_income_ul number(15, 5) NOT NULL,
tax_rate number(15, 5) NOT NULL,
tax_deduction number(15, 5) NOT NULL,
create_time date NOT NULL,
update_time date NOT NULL,
creator number NOT NULL,
delete_type number DEFAULT 0,
tenant_key varchar2(10) NOT NULL
);
/
CREATE sequence hrsa_sys_tax_rate_detail_id
start with 1
increment by 1
nomaxvalue
nocycle;
/
create or replace trigger hrsa_sys_tax_rate_detail_Tri
before insert on hrsa_sys_tax_rate_detail
for each row
begin
select hrsa_sys_tax_rate_detail_id.nextval into :new.id from dual;
end;
/
CREATE TABLE hrsa_tax_agent(
id number PRIMARY KEY NOT NULL,
name varchar2(100) DEFAULT '',
description varchar2(100) DEFAULT '' ,
create_time DATE DEFAULT sysdate,
update_time DATE DEFAULT sysdate,
creator number DEFAULT 0,
delete_type number DEFAULT 0,
tenant_key varchar2(10) DEFAULT ''
);
/
CREATE sequence hrsa_tax_agent_id
start with 1
increment by 1
nomaxvalue
nocycle;
/
create or replace trigger hrsa_tax_agent_Tri
before insert on hrsa_tax_agent
for each row
begin
select hrsa_tax_agent_id.nextval into :new.id from dual;
end;
/
CREATE TABLE hrsa_tax_declaration(
id NUMBER(38,0) PRIMARY KEY NOT NULL,
salary_month date DEFAULT to_date('1900-01-01','YYYY-DD-mm'),
tax_cycle date DEFAULT to_date('1900-01-01','YYYY-DD-mm'),
tax_agent_id number DEFAULT 0,
description varchar2(1000) DEFAULT '',
creator NUMBER(38,0) DEFAULT 0,
create_time DATE DEFAULT sysdate,
update_time DATE DEFAULT sysdate,
delete_type number DEFAULT 0,
tenant_key varchar2(10) DEFAULT ''
);
/
CREATE TABLE hrsa_tax_declaration_detail(
id NUMBER(38,0) NOT NULL,
tax_declaration_id NUMBER(38,0) DEFAULT 0,
employee_id NUMBER(38,0) DEFAULT 0,
field_code varchar2(100) DEFAULT '' ,
field_value varchar2(1000) DEFAULT '' ,
creator NUMBER(38,0) DEFAULT 0,
create_time DATE DEFAULT sysdate,
update_time DATE DEFAULT sysdate,
delete_type number DEFAULT 0,
tenant_key varchar2(10) DEFAULT ''
);
/
CREATE TABLE hrsa_tax_rate_base(
id NUMBER(38,0) PRIMARY KEY NOT NULL,
name varchar2(100) DEFAULT '' ,
system_type number DEFAULT 0,
description varchar2(100) DEFAULT '' ,
create_time DATE DEFAULT sysdate,
update_time DATE DEFAULT sysdate,
creator NUMBER(38,0) DEFAULT 0,
delete_type number DEFAULT 0,
tenant_key varchar2(10) DEFAULT ''
);
/
CREATE sequence hrsa_tax_rate_base_id
start with 1
increment by 1
nomaxvalue
nocycle;
/
create or replace trigger hrsa_tax_rate_base_Tri
before insert on hrsa_tax_rate_base
for each row
begin
select hrsa_tax_rate_base_id.nextval into :new.id from dual;
end;
/
CREATE TABLE hrsa_tax_rate_detail(
id NUMBER(38,0) PRIMARY KEY NOT NULL,
base_id NUMBER(38,0) DEFAULT 0,
index_num number DEFAULT 0,
income_upper_limit number(15, 5) DEFAULT 0.00000,
income_lower_limit number(15, 5) DEFAULT 0.00000,
duty_free_value number(15, 5) DEFAULT 0.00000,
duty_free_rate number(15, 5) DEFAULT 0.00000,
taxable_income_ul number(15, 5) DEFAULT 0.00000,
taxable_income_ll number(15, 5) DEFAULT 0.00000,
tax_rate number(15, 5) DEFAULT 0.00000,
tax_deduction number(15, 5) DEFAULT 0.00000,
create_time DATE DEFAULT sysdate,
update_time DATE DEFAULT sysdate,
creator NUMBER(38,0) DEFAULT 0,
delete_type number DEFAULT 0,
tenant_key varchar2(10) DEFAULT ''
);
/
CREATE sequence hrsa_tax_rate_detail_id
start with 1
increment by 1
nomaxvalue
nocycle;
/
create or replace trigger hrsa_tax_rate_detail_Tri
before insert on hrsa_tax_rate_detail
for each row
begin
select hrsa_tax_rate_detail_id.nextval into :new.id from dual;
end;
/
ALTER TABLE hrsa_salary_sob_item ADD can_delete number NULL;
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674853617092214787, '<EFBFBD><EFBFBD><EFBFBD><EFBFBD>н<EFBFBD><EFBFBD><EFBFBD>ϼ<EFBFBD>', 'wagesTotal', 1, 5, 22, 1, 0, 2, 2, 2, 1, 1651736817711, ' ', 1, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:32:58','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674853617092214788, 'ȫ<EFBFBD><EFBFBD>һ<EFBFBD><EFBFBD><EFBFBD>Խ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ϼ<EFBFBD>', 'annualBonusTotal', 1, 5, 22, 0, 0, 2, 2, 2, 1, 1651737358294, ' ', 1, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:32:58','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 16:03:07','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674853617092214789, '˰ǰ<EFBFBD>ۿ<EFBFBD><EFBFBD>ϼ<EFBFBD>', 'preTaxDeductionsTotal', 1, 5, 22, 1, 0, 2, 2, 2, 1, 1651737635353, ' ', 1, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:32:58','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 16:03:22','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674853617092214790, '<EFBFBD><EFBFBD><EFBFBD>£<EFBFBD><EFBFBD>Σ<EFBFBD>Ӧ˰<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ϼ<EFBFBD>', 'income', 1, 5, 22, 1, 0, 2, 2, 2, 0, 1651737859216, ' ', 1, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:32:58','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 16:03:25','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674853617092214791, '<EFBFBD><EFBFBD>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ˰<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ϼ<EFBFBD>', 'addUpIncome', 1, 5, 22, 1, 0, 2, 2, 2, 0, 1651738034028, ' ', 1, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:32:58','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 16:03:28','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674853617092214792, '<EFBFBD><EFBFBD><EFBFBD>ϸ<EFBFBD><EFBFBD><EFBFBD>', 'endowmentInsurance', 1, 2, 10, 1, 0, 2, 2, 2, 7, 1651749914746, ' ', 0, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:32:59','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 15:54:31','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674853617092214793, 'ҽ<EFBFBD>Ƹ<EFBFBD><EFBFBD><EFBFBD>', 'medicalInsurance', 1, 2, 10, 1, 0, 2, 2, 2, 7, 1651749958879, ' ', 0, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:32:59','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 15:54:31','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674853617092214795, 'ʧҵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 'unemploymentInsurance', 1, 2, 10, 1, 0, 2, 2, 2, 7, 1651750005281, ' ', 0, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:32:59','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 15:54:31','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674853617092214796, '<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 'housingProvidentFund', 1, 2, 10, 1, 0, 2, 2, 2, 7, 1651750034689, ' ', 0, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:32:59','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 15:54:31','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674853617092214797, '<EFBFBD><EFBFBD><EFBFBD>£<EFBFBD><EFBFBD>Σ<EFBFBD>ר<EFBFBD><EFBFBD><EFBFBD>۳<EFBFBD><EFBFBD>ϼ<EFBFBD>', 'specialDeduction', 1, 5, 22, 1, 0, 2, 2, 2, 7, 1651738826550, ' ', 1, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:32:59','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 16:03:40','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674853617092214798, '<EFBFBD><EFBFBD>ǰ<EFBFBD>ۼ<EFBFBD>ר<EFBFBD><EFBFBD><EFBFBD>۳<EFBFBD><EFBFBD>ϼ<EFBFBD>', 'addUpSpecialDeduction', 1, 5, 22, 1, 0, 2, 2, 2, 7, 1651739000845, ' ', 0, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:32:59','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 15:54:31','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674853617092214799, '<EFBFBD>ۼ<EFBFBD><EFBFBD><EFBFBD>Ů<EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 'addUpChildEducation', 1, 2, 11, 1, 0, 2, 2, 2, 6, 1651739053212, ' ', 0, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:32:59','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 15:54:31','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674853617092214800, '<EFBFBD>ۼ<EFBFBD>ס<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ϣ', 'addUpHousingLoannumbererest', 1, 2, 11, 1, 0, 2, 2, 2, 6, 1651739100651, ' ', 0, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:32:59','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 15:54:31','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674853617092214801, '<EFBFBD>ۼ<EFBFBD>ס<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 'addUpHousingRent', 1, 2, 11, 1, 0, 2, 2, 2, 6, 1651739151122, ' ', 0, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:32:59','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 15:54:31','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674853617092214802, '<EFBFBD>ۼƼ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 'addUpContinuingEducation', 1, 2, 11, 1, 0, 2, 2, 2, 6, 1651739212437, ' ', 0, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:32:59','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 15:54:31','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674853617092214803, '<EFBFBD>ۼ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 'addUpSupportElderly', 1, 2, 11, 1, 0, 2, 2, 2, 6, 1651739310959, ' ', 0, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:32:59','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 15:54:31','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674853617092214804, '<EFBFBD><EFBFBD>ǰ<EFBFBD>ۼ<EFBFBD>ר<EFBFBD><EFBFBD>ӿ۳<EFBFBD><EFBFBD>ϼ<EFBFBD>', 'addUpSpeAddiDeduction', 1, 5, 22, 1, 0, 2, 2, 2, 6, 1651739411365, ' ', 0, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:32:59','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 15:54:31','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674853617092214805, '<EFBFBD><EFBFBD><EFBFBD>£<EFBFBD><EFBFBD>Σ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>۳<EFBFBD><EFBFBD>ϼ<EFBFBD>', 'otherDeduction', 1, 5, 22, 0, 0, 2, 2, 2, 8, 1651739815651, ' ', 0, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:32:59','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 15:54:31','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674853617092214806, '<EFBFBD><EFBFBD>ǰ<EFBFBD>ۼ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>۳<EFBFBD><EFBFBD>ϼ<EFBFBD>', 'addUpOtherDeduction', 1, 5, 22, 0, 0, 2, 2, 2, 5, 1651740238860, ' ', 0, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:32:59','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 15:54:31','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674853617092214807, '<EFBFBD><EFBFBD><EFBFBD>£<EFBFBD><EFBFBD>Σ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 'subtraction', 1, 7, 19, 1, 0, 2, 2, 2, 1, 1651740311026, ' ', 1, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:32:59','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 15:56:11','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674853617092214808, '<EFBFBD><EFBFBD>ǰ<EFBFBD>ۼƼ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 'addUpSubtraction', 1, 5, 22, 1, 0, 2, 2, 2, 5, 1651740397225, ' ', 0, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:32:59','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 15:54:31','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674853617092214809, '<EFBFBD><EFBFBD><EFBFBD>£<EFBFBD><EFBFBD>Σ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>н<EFBFBD><EFBFBD>˰˰<EFBFBD><EFBFBD>', 'taxRate', 1, 7, 19, 1, 0, 2, 2, 2, 1, 1651742185837, ' ', 0, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:33:00','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 15:54:31','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674853617092214810, '<EFBFBD><EFBFBD><EFBFBD>£<EFBFBD><EFBFBD>Σ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>н<EFBFBD><EFBFBD>˰<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>۳<EFBFBD><EFBFBD><EFBFBD>', 'quickDeductionFactor', 1, 7, 19, 1, 0, 2, 2, 2, 1, 1651742702735, ' ', 0, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:33:00','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 15:54:31','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674853617092214811, '<EFBFBD><EFBFBD>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ<EFBFBD><EFBFBD>˰<EFBFBD><EFBFBD><EFBFBD>ö<EFBFBD>', 'addUpTaxableIncome', 1, 5, 22, 1, 0, 2, 2, 2, 5, 1651745445982, ' ', 1, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:33:00','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 16:04:12','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674853617092214812, '<EFBFBD><EFBFBD>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ<EFBFBD><EFBFBD>˰<EFBFBD><EFBFBD>', 'addUpTaxPayable', 1, 7, 19, 1, 0, 2, 2, 2, 1, 1651748888864, ' ', 1, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:33:00','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 16:04:14','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674853617092214813, '<EFBFBD><EFBFBD>ǰ<EFBFBD>ۼ<EFBFBD><EFBFBD>ѿ۽<EFBFBD>˰<EFBFBD><EFBFBD><EFBFBD>ϼ<EFBFBD>', 'addUpAdvanceTax', 1, 5, 22, 1, 0, 2, 2, 2, 5, 1651748978482, ' ', 1, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:33:00','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 16:04:18','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674853617092214814, '<EFBFBD><EFBFBD><EFBFBD>£<EFBFBD><EFBFBD>Σ<EFBFBD>Ӧ<EFBFBD><EFBFBD>˰<EFBFBD><EFBFBD>', 'refundedOrSupplementedTax', 1, 6, 16, 1, 0, 2, 2, 2, 1, 1651749111981,' ', 0, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:33:00','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 15:54:31','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674853617092214815, '<EFBFBD><EFBFBD><EFBFBD>£<EFBFBD><EFBFBD>Σ<EFBFBD>ʵ<EFBFBD><EFBFBD>н<EFBFBD>ʺϼ<EFBFBD>', 'netSalaryTotal', 1, 5, 22, 1, 0, 2, 2, 2, 1, 1651749240004, ' ', 1, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:33:00','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 16:04:24','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674861648655892480, '<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 'baseSalary', 1, 1, 1, 1, 1, 2, 2, 1, 0, 0, ' ', 1, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:33:00','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 15:57:46','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674861768948531201, '<EFBFBD><EFBFBD>λ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 'postSalary', 1, 1, 1, 1, 1, 2, 2, 1, 0, 0, ' ', 1, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:33:00','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 15:57:57','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674861880508628992, '<EFBFBD><EFBFBD><EFBFBD>ڿۿ<EFBFBD>', 'attendanceDeduction', 1, 2, 9, 1, 0, 2, 2, 1, 0, 0, ' ', 1, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:33:00','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 15:58:04','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674914626953093121, '˰<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ϼ<EFBFBD>', 'afterTaxReimbursementTotal', 1, 5, 22, 0, 0, 3, 2, 1, 1, 0, ' ', 1, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:33:00','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 15:58:06','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674914626953093122, '<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 'annuity', 1, 2, 12, 0, 0, 2, 2, 2, 7, 1651749398360, ' ', 0, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:33:00','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 15:54:31','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674914626953093123, '<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 'commercialHealthInsurance', 1, 2, 12, 0, 0, 2, 2, 2, 8, 1651749448800, ' ', 0, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:33:00','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 15:54:31','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674914626953093124, '˰<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ϱ<EFBFBD><EFBFBD><EFBFBD>', 'taxDeferredEndowmentInsurance', 1, 2, 12, 0, 0, 2, 2, 2, 8, 1651749487187, ' ', 0, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:33:01','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 15:54:31','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674914626953093125, '<EFBFBD>Ʋ<EFBFBD>ԭֵ', 'originalValueOfProperty', 1, 2, 12, 0, 0, 2, 2, 1, 0, 0, ' ', 1, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:33:01','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 15:58:29','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674914626953093126, '<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>۳<EFBFBD><EFBFBD><EFBFBD>˰<EFBFBD><EFBFBD>', 'deductedTax', 1, 2, 12, 0, 0, 2, 2, 1, 0, 0, ' ', 1, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:33:01','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 15:58:42','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674914626953093127, '<EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 'other', 1, 2, 12, 0, 0, 2, 2, 2, 8, 1651749540147, ' ', 0, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:33:01','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 15:54:31','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674914626953093128, '<EFBFBD><EFBFBD><EFBFBD>£<EFBFBD><EFBFBD>Σ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 'fee', 1, 7, 19, 0, 0, 2, 2, 1, 0, 0, ' ', 0, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:33:01','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 15:54:31','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674914626953093129, '<EFBFBD><EFBFBD><EFBFBD>£<EFBFBD><EFBFBD>Σ<EFBFBD><EFBFBD><EFBFBD>˰<EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 'taxFreeIncome', 1, 7, 19, 0, 0, 2, 2, 1, 0, 0, ' ', 1, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:33:01','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 15:58:54','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674914626953093130, '<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>˰<EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 'lessTaxProportion', 1, 7, 19, 0, 0, 2, 2, 1, 0, 0, ' ', 0, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:33:01','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 15:54:31','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674916065864646657, '˰<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ϼ<EFBFBD>', 'afterTaxAdjustmentTotal', 1, 5, 22, 0, 0, 2, 2, 1, 1, 0, ' ', 1, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:33:01','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 15:59:09','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674916065864646658, '<EFBFBD><EFBFBD>ǰ<EFBFBD>ۼƼ<EFBFBD><EFBFBD><EFBFBD>˰<EFBFBD><EFBFBD><EFBFBD>ϼ<EFBFBD>', 'addUpTaxDeduction', 1, 5, 22, 0, 0, 2, 2, 1, 5, 0, ' ', 0, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:33:01','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 15:54:31','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674916065864646659, '<EFBFBD><EFBFBD><EFBFBD>£<EFBFBD><EFBFBD>Σ<EFBFBD>׼<EFBFBD>ʿ۳<EFBFBD><EFBFBD>ľ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 'allowedDonation', 1, 5, 22, 0, 0, 2, 2, 2, 8, 1651749595061, ' ', 0, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:33:01','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 15:54:31','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674916065864646660, '<EFBFBD><EFBFBD>ǰ<EFBFBD>ۼ<EFBFBD>׼<EFBFBD><EFBFBD><EFBFBD>۳<EFBFBD><EFBFBD>ľ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 'addUpAllowedDonation', 1, 5, 22, 0, 0, 2, 2, 2, 5, 1651749675268, ' ', 0, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:33:01','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 15:54:31','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674916065864646661, '<EFBFBD><EFBFBD><EFBFBD>£<EFBFBD><EFBFBD>Σ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>˰<EFBFBD><EFBFBD>', 'taxDeduction', 1, 5, 22, 0, 0, 2, 2, 1, 0, 0, ' ', 1, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:33:01','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 16:00:25','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674916065864646662, '˰<EFBFBD><EFBFBD><EFBFBD>ۿ<EFBFBD><EFBFBD>ϼ<EFBFBD>', 'afterTaxDeductionsTotal', 1, 5, 22, 0, 0, 2, 2, 1, 1, 0, ' ', 1, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:33:02','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 16:00:37','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674919424520683521, '˰<EFBFBD><EFBFBD><EFBFBD>ۿ<EFBFBD>', 'afterTaxDeductions', 1, 4, 15, 0, 0, 2, 2, 1, 0, 0, ' ', 1, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:33:02','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 16:00:39','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674919682288984064, '˰<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 'afterTaxReimbursement', 1, 3, 13, 0, 0, 2, 2, 1, 0, 0, ' ', 1, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:33:02','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 16:00:40','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674919776783499264, '˰<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 'afterTaxAdjustment', 1, 3, 14, 0, 0, 2, 2, 1, 0, 0, ' ', 1, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:33:02','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 16:00:48','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (674920588574261248, '<EFBFBD><EFBFBD><EFBFBD>ս<EFBFBD>', 'annualBonus', 1, 1, 2, 0, 0, 2, 2, 1, 0, 0, ' ', 1, 1, 0, 0, 'all_teams', to_date('2022-03-28 10:33:02','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 16:00:51','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (697532371614588928, '<EFBFBD><EFBFBD>ǰ<EFBFBD>ۼ<EFBFBD><EFBFBD>籣<EFBFBD><EFBFBD><EFBFBD>˺ϼ<EFBFBD>', 'addUpSocialSecurityTotal', 1, 7, 1, 1, 0, 2, 2, 2, 0, 1651801433504, ' ', 0, 1, 0, 0, 'all_teams', to_date('2022-03-07 10:22:55','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-06 09:44:23','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (697532667749400576, '<EFBFBD><EFBFBD>ǰ<EFBFBD>ۼƹ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>˺ϼ<EFBFBD>', 'addUpAccumulationFundTotal', 1, 7, 1, 1, 0, 2, 2, 2, 0, 1651801586972, ' ', 0, 1, 0, 0, 'all_teams', to_date('2022-03-07 10:22:55','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-06 09:46:40','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_sys_salary_item(id, name, code, system_type, category, item_type, use_default, use_in_employee_salary, rounding_mode, pattern, value_type, datasource, formula_id, description, can_edit, can_delete, creator, delete_type, tenant_key, create_time, update_time, data_type) VALUES (697536344384012289, '<EFBFBD><EFBFBD>ǰ<EFBFBD>ۼ<EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>ְҵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>˺ϼ<EFBFBD>', 'addUpEnterpriseAndOther', 1, 7, 1, 1, 0, 2, 2, 2, 0, 1651801667770, ' ', 0, 1, 0, 0, 'all_teams', to_date('2022-03-07 10:22:56','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-06 09:48:07','yyyy-MM-dd HH24:mi:ss'), 'number');
/
INSERT into hrsa_formula(id, name, description, module, use_for, reference_type, return_type, validate_type, extend_param, formula, formulaRunScript, creator, delete_type, create_time, update_time) VALUES (1651736817711, '<EFBFBD><EFBFBD>ʽ1', '<EFBFBD><EFBFBD>ע', 'salary', 'salaryitem', 'formula', 'number', 'number', '{}', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>}+{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>λ<EFBFBD><CEBB><EFBFBD><EFBFBD>}', 'salaryItem_baseSalary+salaryItem_postSalary', 1, 0, to_date('2022-05-05 15:46:58','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 15:46:58','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula(id, name, description, module, use_for, reference_type, return_type, validate_type, extend_param, formula, formulaRunScript, creator, delete_type, create_time, update_time) VALUES (1651737358294, '<EFBFBD><EFBFBD>ʽ1', '<EFBFBD><EFBFBD>ע', 'salary', 'salaryitem', 'formula', 'number', 'number', '{}', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><><EFBFBD>ս<EFBFBD>}', 'salaryItem_annualBonus', 1, 0, to_date('2022-05-05 15:55:58','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 15:55:58','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula(id, name, description, module, use_for, reference_type, return_type, validate_type, extend_param, formula, formulaRunScript, creator, delete_type, create_time, update_time) VALUES (1651737635353, '<EFBFBD><EFBFBD>ʽ1', '<EFBFBD><EFBFBD>ע', 'salary', 'salaryitem', 'formula', 'number', 'number', '{}', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><><EFBFBD>ڿۿ<DABF>}', 'salaryItem_attendanceDeduction', 1, 0, to_date('2022-05-05 16:00:35','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 16:00:35','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula(id, name, description, module, use_for, reference_type, return_type, validate_type, extend_param, formula, formulaRunScript, creator, delete_type, create_time, update_time) VALUES (1651737859216, '<EFBFBD><EFBFBD>ʽ1', '<EFBFBD><EFBFBD>ע', 'salary', 'salaryitem', 'formula', 'number', 'number', '{}', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><><EFBFBD><EFBFBD>н<EFBFBD><D0BD><EFBFBD>ϼ<EFBFBD>}+{н<><D0BD><EFBFBD><EFBFBD>Ŀ.ȫ<><C8AB>һ<EFBFBD><D2BB><EFBFBD>Խ<EFBFBD><D4BD><EFBFBD><EFBFBD>ϼ<EFBFBD>}-{н<><D0BD><EFBFBD><EFBFBD>Ŀ.˰ǰ<CBB0>ۿ<EFBFBD><DBBF>ϼ<EFBFBD>}', 'salaryItem_wagesTotal+salaryItem_annualBonusTotal-salaryItem_preTaxDeductionsTotal', 1, 0, to_date('2022-05-05 16:04:19','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 16:04:19','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula(id, name, description, module, use_for, reference_type, return_type, validate_type, extend_param, formula, formulaRunScript, creator, delete_type, create_time, update_time) VALUES (1651738034028, '<EFBFBD><EFBFBD>ʽ1', '<EFBFBD><EFBFBD>ע', 'salary', 'salaryitem', 'formula', 'number', 'number', '{}', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><><EFBFBD>£<EFBFBD><C2A3>Σ<EFBFBD>Ӧ˰<D3A6><CBB0><EFBFBD><EFBFBD><EFBFBD>ϼ<EFBFBD>}+{<7B><><EFBFBD><EFBFBD><EFBFBD>ۼ<EFBFBD><DBBC><EFBFBD><EFBFBD><EFBFBD>.<2E>ۼ<EFBFBD><DBBC><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>}', 'salaryItem_income+addUpSituation_addUpIncome', 1, 0, to_date('2022-05-05 16:07:14','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 16:07:14','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula(id, name, description, module, use_for, reference_type, return_type, validate_type, extend_param, formula, formulaRunScript, creator, delete_type, create_time, update_time) VALUES (1651749914746, '<EFBFBD><EFBFBD>ʽ1', '<EFBFBD><EFBFBD>ע', 'salary', 'salaryitem', 'formula', 'number', 'number', '{}', '{<7B>籣<EFBFBD><E7B1A3><EFBFBD><EFBFBD>.<2E><><EFBFBD>ϱ<EFBFBD><CFB1>ո<EFBFBD><D5B8><EFBFBD>}', 'welfare_9001socialPer', 1, 0, to_date('2022-05-05 19:25:15','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 19:25:15','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula(id, name, description, module, use_for, reference_type, return_type, validate_type, extend_param, formula, formulaRunScript, creator, delete_type, create_time, update_time) VALUES (1651749958879, '<EFBFBD><EFBFBD>ʽ1', '<EFBFBD><EFBFBD>ע', 'salary', 'salaryitem', 'formula', 'number', 'number', '{}', '{<7B>籣<EFBFBD><E7B1A3><EFBFBD><EFBFBD>.ҽ<>Ʊ<EFBFBD><C6B1>ո<EFBFBD><D5B8><EFBFBD>}', 'welfare_9002socialPer', 1, 0, to_date('2022-05-05 19:25:59','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 19:25:59','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula(id, name, description, module, use_for, reference_type, return_type, validate_type, extend_param, formula, formulaRunScript, creator, delete_type, create_time, update_time) VALUES (1651750005281, '<EFBFBD><EFBFBD>ʽ1', '<EFBFBD><EFBFBD>ע', 'salary', 'salaryitem', 'formula', 'number', 'number', '{}', '{<7B>籣<EFBFBD><E7B1A3><EFBFBD><EFBFBD>.ʧҵ<CAA7><D2B5><EFBFBD>ո<EFBFBD><D5B8><EFBFBD>}', 'welfare_9004socialPer', 1, 0, to_date('2022-05-05 19:26:45','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 19:26:45','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula(id, name, description, module, use_for, reference_type, return_type, validate_type, extend_param, formula, formulaRunScript, creator, delete_type, create_time, update_time) VALUES (1651750034689, '<EFBFBD><EFBFBD>ʽ1', '<EFBFBD><EFBFBD>ע', 'salary', 'salaryitem', 'formula', 'number', 'number', '{}', '{<7B>籣<EFBFBD><E7B1A3><EFBFBD><EFBFBD>.ס<><D7A1><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>}', 'welfare_9006fundPer', 1, 0, to_date('2022-05-05 19:27:15','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 19:27:15','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula(id, name, description, module, use_for, reference_type, return_type, validate_type, extend_param, formula, formulaRunScript, creator, delete_type, create_time, update_time) VALUES (1651738826550, '<EFBFBD><EFBFBD>ʽ1', '<EFBFBD><EFBFBD>ע', 'salary', 'salaryitem', 'formula', 'number', 'number', '{}', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><><EFBFBD>ϸ<EFBFBD><CFB8><EFBFBD>}+{н<><D0BD><EFBFBD><EFBFBD>Ŀ.ҽ<>Ƹ<EFBFBD><C6B8><EFBFBD>}+{н<><D0BD><EFBFBD><EFBFBD>Ŀ.ʧҵ<CAA7><D2B5><EFBFBD><EFBFBD>}+{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>}', 'salaryItem_endowmentInsurance+salaryItem_medicalInsurance+salaryItem_unemploymentInsurance+salaryItem_housingProvidentFund', 1, 0, to_date('2022-05-05 16:20:27','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 16:20:27','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula(id, name, description, module, use_for, reference_type, return_type, validate_type, extend_param, formula, formulaRunScript, creator, delete_type, create_time, update_time) VALUES (1651739000845, '<EFBFBD><EFBFBD>ʽ1', '<EFBFBD><EFBFBD>ע', 'salary', 'salaryitem', 'formula', 'number', 'number', '{}', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><><EFBFBD>£<EFBFBD><C2A3>Σ<EFBFBD>ר<EFBFBD><D7A8><EFBFBD>۳<EFBFBD><DBB3>ϼ<EFBFBD>}+{<7B><><EFBFBD><EFBFBD><EFBFBD>ۼ<EFBFBD><DBBC><EFBFBD><EFBFBD><EFBFBD>.<2E>ۼ<EFBFBD><DBBC>籣<EFBFBD><E7B1A3><EFBFBD>˺ϼ<CBBA>}+{<7B><><EFBFBD><EFBFBD><EFBFBD>ۼ<EFBFBD><DBBC><EFBFBD><EFBFBD><EFBFBD>.<2E>ۼƹ<DBBC><C6B9><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>˺ϼ<CBBA>}', 'salaryItem_specialDeduction+addUpSituation_addUpSocialSecurityTotal+addUpSituation_addUpAccumulationFundTotal', 1, 0, to_date('2022-05-05 16:23:21','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 16:23:21','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula(id, name, description, module, use_for, reference_type, return_type, validate_type, extend_param, formula, formulaRunScript, creator, delete_type, create_time, update_time) VALUES (1651739053212, '<EFBFBD><EFBFBD>ʽ1', '<EFBFBD><EFBFBD>ע', 'salary', 'salaryitem', 'formula', 'number', 'number', '{}', '{<7B>ۼ<EFBFBD>ר<EFBFBD><EFBFBD>ӿ۳<D3BF>.<2E>ۼ<EFBFBD><DBBC><EFBFBD>Ů<EFBFBD><C5AE><EFBFBD><EFBFBD>}', 'addUpDeductions_addUpChildEducation', 1, 0, to_date('2022-05-05 16:24:13','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 16:24:13','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula(id, name, description, module, use_for, reference_type, return_type, validate_type, extend_param, formula, formulaRunScript, creator, delete_type, create_time, update_time) VALUES (1651739100651, '<EFBFBD><EFBFBD>ʽ1', '<EFBFBD><EFBFBD>ע', 'salary', 'salaryitem', 'formula', 'number', 'number', '{}', '{<7B><><EFBFBD><EFBFBD><EFBFBD>ۼ<EFBFBD><DBBC><EFBFBD><EFBFBD><EFBFBD>.<2E>ۼ<EFBFBD>ס<EFBFBD><D7A1><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ϣ}', 'addUpSituation_addUpHousingLoannumbererest', 1, 0, to_date('2022-05-05 16:25:01','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 16:25:01','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula(id, name, description, module, use_for, reference_type, return_type, validate_type, extend_param, formula, formulaRunScript, creator, delete_type, create_time, update_time) VALUES (1651739151122, '<EFBFBD><EFBFBD>ʽ1', '<EFBFBD><EFBFBD>ע', 'salary', 'salaryitem', 'formula', 'number', 'number', '{}', '{<7B><><EFBFBD><EFBFBD><EFBFBD>ۼ<EFBFBD><DBBC><EFBFBD><EFBFBD><EFBFBD>.<2E>ۼ<EFBFBD>ס<EFBFBD><D7A1><EFBFBD><EFBFBD><EFBFBD><EFBFBD>}', 'addUpSituation_addUpHousingRent', 1, 0, to_date('2022-05-05 16:25:51','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 16:25:51','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula(id, name, description, module, use_for, reference_type, return_type, validate_type, extend_param, formula, formulaRunScript, creator, delete_type, create_time, update_time) VALUES (1651739212437, '<EFBFBD><EFBFBD>ʽ1', '<EFBFBD><EFBFBD>ע', 'salary', 'salaryitem', 'formula', 'number', 'number', '{}', '{<7B><><EFBFBD><EFBFBD><EFBFBD>ۼ<EFBFBD><DBBC><EFBFBD><EFBFBD><EFBFBD>.<2E>ۼƼ<DBBC><C6BC><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>}', 'addUpSituation_addUpContinuingEducation', 1, 0, to_date('2022-05-05 16:26:52','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 16:26:52','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula(id, name, description, module, use_for, reference_type, return_type, validate_type, extend_param, formula, formulaRunScript, creator, delete_type, create_time, update_time) VALUES (1651739310959, '<EFBFBD><EFBFBD>ʽ1', '<EFBFBD><EFBFBD>ע', 'salary', 'salaryitem', 'formula', 'number', 'number', '{}', '{<7B><><EFBFBD><EFBFBD><EFBFBD>ۼ<EFBFBD><DBBC><EFBFBD><EFBFBD><EFBFBD>.<2E>ۼ<EFBFBD><DBBC><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>}', 'addUpSituation_addUpSupportElderly', 1, 0, to_date('2022-05-05 16:28:31','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 16:28:31','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula(id, name, description, module, use_for, reference_type, return_type, validate_type, extend_param, formula, formulaRunScript, creator, delete_type, create_time, update_time) VALUES (1651739411365, '<EFBFBD><EFBFBD>ʽ1', '<EFBFBD><EFBFBD>ע', 'salary', 'salaryitem', 'formula', 'number', 'number', '{}', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E>ۼ<EFBFBD><DBBC><EFBFBD>Ů<EFBFBD><C5AE><EFBFBD><EFBFBD>}+{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E>ۼ<EFBFBD>ס<EFBFBD><D7A1><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ϣ}+{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E>ۼ<EFBFBD>ס<EFBFBD><D7A1><EFBFBD><EFBFBD><EFBFBD><EFBFBD>}+{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E>ۼƼ<DBBC><C6BC><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>}+{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E>ۼ<EFBFBD><DBBC><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>}', 'salaryItem_addUpChildEducation+salaryItem_addUpHousingLoannumbererest+salaryItem_addUpHousingRent+salaryItem_addUpContinuingEducation+salaryItem_addUpSupportElderly', 1, 0, to_date('2022-05-05 16:30:11','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 16:30:11','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula(id, name, description, module, use_for, reference_type, return_type, validate_type, extend_param, formula, formulaRunScript, creator, delete_type, create_time, update_time) VALUES (1651739815651, '<EFBFBD><EFBFBD>ʽ1', '<EFBFBD><EFBFBD>ע', 'salary', 'salaryitem', 'formula', 'number', 'number', '{}', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>}+{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>ҵ<EFBFBD><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>}+{н<><D0BD><EFBFBD><EFBFBD>Ŀ.˰<><CBB0><EFBFBD><EFBFBD><EFBFBD>ϱ<EFBFBD><CFB1><EFBFBD>}+{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E>Ʋ<EFBFBD>ԭֵ}+{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><><EFBFBD><EFBFBD><EFBFBD>۳<EFBFBD><DBB3><EFBFBD>˰<EFBFBD><CBB0>}+{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><><EFBFBD><EFBFBD>}', 'salaryItem_annuity+salaryItem_commercialHealthInsurance+salaryItem_taxDeferredEndowmentInsurance+salaryItem_originalValueOfProperty+salaryItem_deductedTax+salaryItem_other', 1, 0, to_date('2022-05-05 16:36:56','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 16:36:56','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula(id, name, description, module, use_for, reference_type, return_type, validate_type, extend_param, formula, formulaRunScript, creator, delete_type, create_time, update_time) VALUES (1651740238860, '<EFBFBD><EFBFBD>ʽ1', '<EFBFBD><EFBFBD>ע', 'salary', 'salaryitem', 'formula', 'number', 'number', '{}', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><><EFBFBD>£<EFBFBD><C2A3>Σ<EFBFBD><CEA3><EFBFBD><EFBFBD><EFBFBD><EFBFBD>۳<EFBFBD><DBB3>ϼ<EFBFBD>}+{<7B><><EFBFBD><EFBFBD><EFBFBD>ۼ<EFBFBD><DBBC><EFBFBD><EFBFBD><EFBFBD>.<2E>ۼ<EFBFBD><DBBC><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>˰<EFBFBD>۳<EFBFBD>}+{<7B><><EFBFBD><EFBFBD><EFBFBD>ۼ<EFBFBD><DBBC><EFBFBD><EFBFBD><EFBFBD>.<2E>ۼ<EFBFBD><DBBC><EFBFBD>ҵ<EFBFBD><D2B5>ְҵ<D6B0><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>}', 'salaryItem_otherDeduction+addUpSituation_addUpOtherDeduction+addUpSituation_addUpEnterpriseAndOther', 1, 0, to_date('2022-05-05 16:43:59','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 16:43:59','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula(id, name, description, module, use_for, reference_type, return_type, validate_type, extend_param, formula, formulaRunScript, creator, delete_type, create_time, update_time) VALUES (1651740311026, '<EFBFBD><EFBFBD>ʽ1', '<EFBFBD><EFBFBD>ע', 'salary', 'salaryitem', 'formula', 'number', 'number', '{}', '5000', '5000', 1, 0, to_date('2022-05-05 16:45:11','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 16:45:11','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula(id, name, description, module, use_for, reference_type, return_type, validate_type, extend_param, formula, formulaRunScript, creator, delete_type, create_time, update_time) VALUES (1651740397225, '<EFBFBD><EFBFBD>ʽ1', '<EFBFBD><EFBFBD>ע', 'salary', 'salaryitem', 'formula', 'number', 'number', '{}', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><><EFBFBD>£<EFBFBD><C2A3>Σ<EFBFBD><CEA3><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>}+{<7B><><EFBFBD><EFBFBD><EFBFBD>ۼ<EFBFBD><DBBC><EFBFBD><EFBFBD><EFBFBD>.<2E>ۼƼ<DBBC><C6BC><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>}', 'salaryItem_subtraction+addUpSituation_addUpSubtraction', 1, 0, to_date('2022-05-05 16:46:37','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 16:46:37','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula(id, name, description, module, use_for, reference_type, return_type, validate_type,extend_param, formula, formulaRunScript, creator, delete_type, create_time, update_time) VALUES (1651742185837, '<EFBFBD><EFBFBD>ʽ1', '<EFBFBD><EFBFBD>ע', 'salary', 'salaryitem', 'formula', 'number', 'number', '{}', 'if({н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ<EFBFBD><D3A6>˰<EFBFBD><CBB0><EFBFBD>ö<EFBFBD>}<=0){0;}else if({н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ<EFBFBD><D3A6>˰<EFBFBD><CBB0><EFBFBD>ö<EFBFBD>}<=36000){0.03;}else if({н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ<EFBFBD><D3A6>˰<EFBFBD><CBB0><EFBFBD>ö<EFBFBD>}<=144000){0.1;}else if({н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ<EFBFBD><D3A6>˰<EFBFBD><CBB0><EFBFBD>ö<EFBFBD>}<=300000){0.2;}else if({н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ<EFBFBD><D3A6>˰<EFBFBD><CBB0><EFBFBD>ö<EFBFBD>}<=420000){0.25;}else if({н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ<EFBFBD><D3A6>˰<EFBFBD><CBB0><EFBFBD>ö<EFBFBD>}<=660000){0.3;}else if({н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ<EFBFBD><D3A6>˰<EFBFBD><CBB0><EFBFBD>ö<EFBFBD>}<=960000){0.35;}else{0.45;}', 'if(salaryItem_addUpTaxableIncome<=0){0;}else if(salaryItem_addUpTaxableIncome<=36000){0.03;}else if(salaryItem_addUpTaxableIncome<=144000){0.1;}else if(salaryItem_addUpTaxableIncome<=300000){0.2;}else if(salaryItem_addUpTaxableIncome<=420000){0.25;}else if(salaryItem_addUpTaxableIncome<=660000){0.3;}else if(salaryItem_addUpTaxableIncome<=960000){0.35;}else{0.45;}', 1, 0, to_date('2022-05-05 17:16:26','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 17:16:26','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula(id, name, description, module, use_for, reference_type, return_type, validate_type, extend_param, formula, formulaRunScript, creator, delete_type, create_time, update_time) VALUES (1651742702735, '<EFBFBD><EFBFBD>ʽ1', '<EFBFBD><EFBFBD>ע', 'salary', 'salaryitem', 'formula', 'number', 'number', '{}', 'if({н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ<EFBFBD><D3A6>˰<EFBFBD><CBB0><EFBFBD>ö<EFBFBD>}<=36000){{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ<EFBFBD><D3A6>˰<EFBFBD><CBB0><EFBFBD>ö<EFBFBD>}<=36000){0;}else if({н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ<EFBFBD><D3A6>˰<EFBFBD><CBB0><EFBFBD>ö<EFBFBD>}<=144000){2520;}else if({н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ<EFBFBD><D3A6>˰<EFBFBD><CBB0><EFBFBD>ö<EFBFBD>}<=300000){16920;}else if({н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ<EFBFBD><D3A6>˰<EFBFBD><CBB0><EFBFBD>ö<EFBFBD>}<=420000){31920;}else if({н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ<EFBFBD><D3A6>˰<EFBFBD><CBB0><EFBFBD>ö<EFBFBD>}<=660000){52920;}else if({н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ<EFBFBD><D3A6>˰<EFBFBD><CBB0><EFBFBD>ö<EFBFBD>}<=960000){85920;}else{181920;}', 'if(salaryItem_addUpTaxableIncome<=36000){0;}else if(salaryItem_addUpTaxableIncome<=144000){2520;}else if(salaryItem_addUpTaxableIncome<=300000){16920;}else if(salaryItem_addUpTaxableIncome<=420000){31920;}else if(salaryItem_addUpTaxableIncome<=660000){52920;}else if(salaryItem_addUpTaxableIncome<=960000){85920;}else{181920;}', 1, 0, to_date('2022-05-05 17:25:03','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 17:25:03','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula(id, name, description, module, use_for, reference_type, return_type, validate_type, extend_param, formula, formulaRunScript, creator, delete_type, create_time, update_time) VALUES (1651745445982, '<EFBFBD><EFBFBD>ʽ1', '<EFBFBD><EFBFBD>ע', 'salary', 'salaryitem', 'formula', 'number', 'number', '{}', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ˰<D3A6><CBB0><EFBFBD><EFBFBD><EFBFBD>ϼ<EFBFBD>}-{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>ǰ<EFBFBD>ۼ<EFBFBD>ר<EFBFBD><D7A8><EFBFBD>۳<EFBFBD><DBB3>ϼ<EFBFBD>}-{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>ǰ<EFBFBD>ۼ<EFBFBD>ר<EFBFBD><EFBFBD>ӿ۳<D3BF><DBB3>ϼ<EFBFBD>}-{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>ǰ<EFBFBD>ۼ<EFBFBD><DBBC><EFBFBD><EFBFBD><EFBFBD><EFBFBD>۳<EFBFBD><DBB3>ϼ<EFBFBD>}-{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>ǰ<EFBFBD>ۼƼ<DBBC><C6BC><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>}-{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>ǰ<EFBFBD>ۼ<EFBFBD>׼<EFBFBD><D7BC><EFBFBD>۳<EFBFBD><DBB3>ľ<EFBFBD><C4BE><EFBFBD><EFBFBD><EFBFBD>}', 'salaryItem_addUpIncome-salaryItem_addUpSpecialDeduction-salaryItem_addUpSpeAddiDeduction-salaryItem_addUpOtherDeduction-salaryItem_addUpSubtraction-salaryItem_addUpAllowedDonation', 1, 0, to_date('2022-05-05 18:10:46','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 18:10:46','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula(id, name, description, module, use_for, reference_type, return_type, validate_type, extend_param, formula, formulaRunScript, creator, delete_type, create_time, update_time) VALUES (1651748888864, '<EFBFBD><EFBFBD>ʽ1', '<EFBFBD><EFBFBD>ע', 'salary', 'salaryitem', 'formula', 'number', 'number', '{}', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ<EFBFBD><D3A6>˰<EFBFBD><CBB0><EFBFBD>ö<EFBFBD>}*{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><><EFBFBD>£<EFBFBD><C2A3>Σ<EFBFBD><CEA3><EFBFBD><EFBFBD><EFBFBD>н<EFBFBD><D0BD>˰˰<CBB0><CBB0>}-{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><><EFBFBD>£<EFBFBD><C2A3>Σ<EFBFBD><CEA3><EFBFBD><EFBFBD><EFBFBD>н<EFBFBD><D0BD>˰<EFBFBD><CBB0><EFBFBD><EFBFBD><EFBFBD>۳<EFBFBD><DBB3><EFBFBD>}', 'salaryItem_addUpTaxableIncome*salaryItem_taxRate-salaryItem_quickDeductionFactor', 1, 0, to_date('2022-05-05 19:08:09','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 19:08:09','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula(id, name, description, module, use_for, reference_type, return_type, validate_type, extend_param, formula, formulaRunScript, creator, delete_type, create_time, update_time) VALUES (1651748978482, '<EFBFBD><EFBFBD>ʽ1', '<EFBFBD><EFBFBD>ע', 'salary', 'salaryitem', 'formula', 'number', 'number', '{}', '{<7B><><EFBFBD><EFBFBD><EFBFBD>ۼ<EFBFBD><DBBC><EFBFBD><EFBFBD><EFBFBD>.<2E>ۼ<EFBFBD><DBBC><EFBFBD>Ԥ<EFBFBD><D4A4>Ԥ<EFBFBD><D4A4>˰<EFBFBD><CBB0>}', 'addUpSituation_addUpAdvanceTax', 1, 0, to_date('2022-05-05 19:09:38','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 19:09:38','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula(id, name, description, module, use_for, reference_type, return_type, validate_type, extend_param, formula, formulaRunScript, creator, delete_type, create_time, update_time) VALUES (1651749111981, '<EFBFBD><EFBFBD>ʽ1', '<EFBFBD><EFBFBD>ע', 'salary', 'salaryitem', 'formula', 'number', 'number', '{}', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ<EFBFBD><D3A6>˰<EFBFBD><CBB0>}-{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>ǰ<EFBFBD>ۼ<EFBFBD><DBBC>ѿ۽<D1BF>˰<EFBFBD><CBB0><EFBFBD>ϼ<EFBFBD>}-{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>ǰ<EFBFBD>ۼƼ<DBBC><C6BC><EFBFBD>˰<EFBFBD><CBB0><EFBFBD>ϼ<EFBFBD>}', 'salaryItem_addUpTaxPayable-salaryItem_addUpAdvanceTax-salaryItem_addUpTaxDeduction', 1, 0, to_date('2022-05-05 19:11:52','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 19:11:52','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula(id, name, description, module, use_for, reference_type, return_type, validate_type, extend_param, formula, formulaRunScript, creator, delete_type, create_time, update_time) VALUES (1651749240004, '<EFBFBD><EFBFBD>ʽ1', '<EFBFBD><EFBFBD>ע', 'salary', 'salaryitem', 'formula', 'number', 'number', '{}', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><><EFBFBD>£<EFBFBD><C2A3>Σ<EFBFBD>Ӧ˰<D3A6><CBB0><EFBFBD><EFBFBD><EFBFBD>ϼ<EFBFBD>}-{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><><EFBFBD>£<EFBFBD><C2A3>Σ<EFBFBD>ר<EFBFBD><D7A8><EFBFBD>۳<EFBFBD><DBB3>ϼ<EFBFBD>}-{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><><EFBFBD>£<EFBFBD><C2A3>Σ<EFBFBD>Ӧ<EFBFBD><D3A6>˰<EFBFBD><CBB0>}+{н<><D0BD><EFBFBD><EFBFBD>Ŀ.˰<><CBB0><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ϼ<EFBFBD>}+{н<><D0BD><EFBFBD><EFBFBD>Ŀ.˰<><CBB0><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ϼ<EFBFBD>}-{н<><D0BD><EFBFBD><EFBFBD>Ŀ.˰<><CBB0><EFBFBD>ۿ<EFBFBD><DBBF>ϼ<EFBFBD>}', 'salaryItem_income-salaryItem_specialDeduction-salaryItem_refundedOrSupplementedTax+salaryItem_afterTaxAdjustmentTotal+salaryItem_afterTaxReimbursementTotal-salaryItem_afterTaxDeductionsTotal', 1, 0, to_date('2022-05-05 19:14:00','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 19:14:00','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula(id, name, description, module, use_for, reference_type, return_type, validate_type, extend_param, formula, formulaRunScript, creator, delete_type, create_time, update_time) VALUES (1651749398360, '<EFBFBD><EFBFBD>ʽ1', '<EFBFBD><EFBFBD>ע', 'salary', 'salaryitem', 'formula', 'number', 'number', '{}', '{<7B>籣<EFBFBD><E7B1A3><EFBFBD><EFBFBD>.<2E><>ҵ<EFBFBD><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>}', 'welfare_9007otherPer', 1, 0, to_date('2022-05-05 19:16:38','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 19:16:38','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula(id, name, description, module, use_for, reference_type, return_type, validate_type, extend_param, formula, formulaRunScript, creator, delete_type, create_time, update_time) VALUES (1651749448800, '<EFBFBD><EFBFBD>ʽ1', '<EFBFBD><EFBFBD>ע', 'salary', 'salaryitem', 'formula', 'number', 'number', '{}', '{<7B><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>˰<EFBFBD>۳<EFBFBD>.<2E><>ҵ<EFBFBD><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>}', 'otherDeduction_businessHealthyInsurance', 1, 0, to_date('2022-05-05 19:17:29','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 19:17:29','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula(id, name, description, module, use_for, reference_type, return_type, validate_type, extend_param, formula, formulaRunScript, creator, delete_type, create_time, update_time) VALUES (1651749487187, '<EFBFBD><EFBFBD>ʽ1', '<EFBFBD><EFBFBD>ע', 'salary', 'salaryitem', 'formula', 'number', 'number', '{}', '{<7B><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>˰<EFBFBD>۳<EFBFBD>.˰<><CBB0><EFBFBD><EFBFBD><EFBFBD>ϱ<EFBFBD><CFB1><EFBFBD>}', 'otherDeduction_taxDelayEndowmentInsurance', 1, 0, to_date('2022-05-05 19:18:07','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 19:18:07','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula(id, name, description, module, use_for, reference_type, return_type, validate_type, extend_param, formula, formulaRunScript, creator, delete_type, create_time, update_time) VALUES (1651749540147, '<EFBFBD><EFBFBD>ʽ1', '<EFBFBD><EFBFBD>ע', 'salary', 'salaryitem', 'formula', 'number', 'number', '{}', '{<7B><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>˰<EFBFBD>۳<EFBFBD>.<2E><><EFBFBD><EFBFBD>}', 'otherDeduction_otherDeduction', 1, 0, to_date('2022-05-05 19:19:00','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 19:19:00','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula(id, name, description, module, use_for, reference_type, return_type, validate_type, extend_param, formula, formulaRunScript, creator, delete_type, create_time, update_time) VALUES (1651749595061, '<EFBFBD><EFBFBD>ʽ1', '<EFBFBD><EFBFBD>ע', 'salary', 'salaryitem', 'formula', 'number', 'number', '{}', '{<7B><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>˰<EFBFBD>۳<EFBFBD>.׼<><D7BC><EFBFBD>۳<EFBFBD><DBB3>ľ<EFBFBD><C4BE><EFBFBD><EFBFBD><EFBFBD>}', 'otherDeduction_deductionAllowedDonation', 1, 0, to_date('2022-05-05 19:19:55','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 19:19:55','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula(id, name, description, module, use_for, reference_type, return_type, validate_type, extend_param, formula, formulaRunScript, creator, delete_type, create_time, update_time) VALUES (1651749675268, '<EFBFBD><EFBFBD>ʽ1', '<EFBFBD><EFBFBD>ע', 'salary', 'salaryitem', 'formula', 'number', 'number', '{}', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><><EFBFBD>£<EFBFBD><C2A3>Σ<EFBFBD>׼<EFBFBD>ʿ۳<CABF><DBB3>ľ<EFBFBD><C4BE><EFBFBD><EFBFBD><EFBFBD>}+{<7B><><EFBFBD><EFBFBD><EFBFBD>ۼ<EFBFBD><DBBC><EFBFBD><EFBFBD><EFBFBD>.<2E>ۼ<EFBFBD>׼<EFBFBD><D7BC><EFBFBD>۳<EFBFBD><DBB3>ľ<EFBFBD><C4BE><EFBFBD><EFBFBD><EFBFBD>}', 'salaryItem_allowedDonation+addUpSituation_addUpAllowedDonation', 1, 0, to_date('2022-05-05 19:21:15','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 19:21:15','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula(id, name, description, module, use_for, reference_type, return_type, validate_type, extend_param, formula, formulaRunScript, creator, delete_type, create_time, update_time) VALUES (1651801433504, '<EFBFBD><EFBFBD>ʽ1', '<EFBFBD><EFBFBD>ע', 'salary', 'salaryitem', 'formula', 'number', 'number', '{}', '{<7B>籣<EFBFBD><E7B1A3><EFBFBD><EFBFBD>.<2E>籣<EFBFBD><E7B1A3><EFBFBD>˺ϼ<CBBA>}+{<7B><><EFBFBD><EFBFBD><EFBFBD>ۼ<EFBFBD><DBBC><EFBFBD><EFBFBD><EFBFBD>.<2E>ۼ<EFBFBD><DBBC>籣<EFBFBD><E7B1A3><EFBFBD>˺ϼ<CBBA>}', 'welfare_socialPerSum+addUpSituation_addUpSocialSecurityTotal', 1, 0, to_date('2022-05-06 09:43:54','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-06 09:43:54','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula(id, name, description, module, use_for, reference_type, return_type, validate_type, extend_param, formula, formulaRunScript, creator, delete_type, create_time, update_time) VALUES (1651801586972, '<EFBFBD><EFBFBD>ʽ1', '<EFBFBD><EFBFBD>ע', 'salary', 'salaryitem', 'formula', 'number', 'number', '{}', '{<7B>籣<EFBFBD><E7B1A3><EFBFBD><EFBFBD>.<2E><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>˺ϼ<CBBA>}+{<7B><><EFBFBD><EFBFBD><EFBFBD>ۼ<EFBFBD><DBBC><EFBFBD><EFBFBD><EFBFBD>.<2E>ۼƹ<DBBC><C6B9><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>˺ϼ<CBBA>}', 'welfare_fundPerSum+addUpSituation_addUpAccumulationFundTotal', 1, 0, to_date('2022-05-06 09:46:27','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-06 09:46:27','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula(id, name, description, module, use_for, reference_type, return_type, validate_type, extend_param, formula, formulaRunScript, creator, delete_type, create_time, update_time) VALUES (1651801667770, '<EFBFBD><EFBFBD>ʽ1', '<EFBFBD><EFBFBD>ע', 'salary', 'salaryitem', 'formula', 'number', 'number', '{}', '{<7B>籣<EFBFBD><E7B1A3><EFBFBD><EFBFBD>.<2E><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>˺ϼ<CBBA>}+{<7B><><EFBFBD><EFBFBD><EFBFBD>ۼ<EFBFBD><DBBC><EFBFBD><EFBFBD><EFBFBD>.<2E>ۼ<EFBFBD><DBBC><EFBFBD>ҵ<EFBFBD><D2B5>ְҵ<D6B0><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>}', 'welfare_otherPerSum+addUpSituation_addUpEnterpriseAndOther', 1, 0, to_date('2022-05-06 09:47:48','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-06 09:47:48','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651736818266, '<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 1651736817711, 'salaryItem_baseSalary', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>}', 'number', 'salaryItem', 0, 1, 0, to_date('2022-05-05 15:46:58','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 15:46:58','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651736818329, '<EFBFBD><EFBFBD>λ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 1651736817711, 'salaryItem_postSalary', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>λ<EFBFBD><CEBB><EFBFBD><EFBFBD>}', 'number', 'salaryItem', 1, 1, 0, to_date('2022-05-05 15:46:58','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 15:46:58','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651737360610, '<EFBFBD><EFBFBD><EFBFBD>ս<EFBFBD>', 1651737358294, 'salaryItem_annualBonus', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><><EFBFBD>ս<EFBFBD>}', 'number', 'salaryItem', 0, 1, 0, to_date('2022-05-05 15:55:58','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 15:55:58','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651737636061, '<EFBFBD><EFBFBD><EFBFBD>ڿۿ<EFBFBD>', 1651737635353, 'salaryItem_attendanceDeduction', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><><EFBFBD>ڿۿ<DABF>}', 'number', 'salaryItem', 0, 1, 0, to_date('2022-05-05 16:00:35','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 16:00:35','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651737859281, '<EFBFBD><EFBFBD><EFBFBD><EFBFBD>н<EFBFBD><EFBFBD><EFBFBD>ϼ<EFBFBD>', 1651737859216, 'salaryItem_wagesTotal', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><><EFBFBD><EFBFBD>н<EFBFBD><D0BD><EFBFBD>ϼ<EFBFBD>}', 'number', 'salaryItem', 0, 1, 0, to_date('2022-05-05 16:04:19','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 16:04:19','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651737859342, 'ȫ<EFBFBD><EFBFBD>һ<EFBFBD><EFBFBD><EFBFBD>Խ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ϼ<EFBFBD>', 1651737859216, 'salaryItem_annualBonusTotal', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.ȫ<><C8AB>һ<EFBFBD><D2BB><EFBFBD>Խ<EFBFBD><D4BD><EFBFBD><EFBFBD>ϼ<EFBFBD>}', 'number', 'salaryItem', 1, 1, 0, to_date('2022-05-05 16:04:19','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 16:04:19','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651737859401, '˰ǰ<EFBFBD>ۿ<EFBFBD><EFBFBD>ϼ<EFBFBD>', 1651737859216, 'salaryItem_preTaxDeductionsTotal', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.˰ǰ<CBB0>ۿ<EFBFBD><DBBF>ϼ<EFBFBD>}', 'number', 'salaryItem', 2, 1, 0, to_date('2022-05-05 16:04:19','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 16:04:19','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651738035450, '<EFBFBD><EFBFBD><EFBFBD>£<EFBFBD><EFBFBD>Σ<EFBFBD>Ӧ˰<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ϼ<EFBFBD>', 1651738034028, 'salaryItem_income', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><><EFBFBD>£<EFBFBD><C2A3>Σ<EFBFBD>Ӧ˰<D3A6><CBB0><EFBFBD><EFBFBD><EFBFBD>ϼ<EFBFBD>}', 'number', 'salaryItem', 0, 1, 0, to_date('2022-05-05 16:07:14','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 16:07:14','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651738035488, '<EFBFBD>ۼ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 1651738034028, 'addUpSituation_addUpIncome', '{<7B><><EFBFBD><EFBFBD><EFBFBD>ۼ<EFBFBD><DBBC><EFBFBD><EFBFBD><EFBFBD>.<2E>ۼ<EFBFBD><DBBC><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>}', 'number', 'addUpSituation', 1, 1, 0, to_date('2022-05-05 16:07:14','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 16:07:14','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651738832854, '<EFBFBD><EFBFBD><EFBFBD>ϸ<EFBFBD><EFBFBD><EFBFBD>', 1651738826550, 'salaryItem_endowmentInsurance', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><><EFBFBD>ϸ<EFBFBD><CFB8><EFBFBD>}', 'number', 'salaryItem', 0, 1, 0, to_date('2022-05-05 16:20:27','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 16:20:27','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651738837363, 'ҽ<EFBFBD>Ƹ<EFBFBD><EFBFBD><EFBFBD>', 1651738826550, 'salaryItem_medicalInsurance', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.ҽ<>Ƹ<EFBFBD><C6B8><EFBFBD>}', 'number', 'salaryItem', 1, 1, 0, to_date('2022-05-05 16:20:27','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 16:20:27','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651738837909, 'ʧҵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 1651738826550, 'salaryItem_unemploymentInsurance', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.ʧҵ<CAA7><D2B5><EFBFBD><EFBFBD>}', 'number', 'salaryItem', 2, 1, 0, to_date('2022-05-05 16:20:27','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 16:20:27','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651738838429, '<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 1651738826550, 'salaryItem_housingProvidentFund', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>}', 'number', 'salaryItem', 3, 1, 0, to_date('2022-05-05 16:20:27','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 16:20:27','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651739002623, '<EFBFBD><EFBFBD><EFBFBD>£<EFBFBD><EFBFBD>Σ<EFBFBD>ר<EFBFBD><EFBFBD><EFBFBD>۳<EFBFBD><EFBFBD>ϼ<EFBFBD>', 1651739000845, 'salaryItem_specialDeduction', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><><EFBFBD>£<EFBFBD><C2A3>Σ<EFBFBD>ר<EFBFBD><D7A8><EFBFBD>۳<EFBFBD><DBB3>ϼ<EFBFBD>}', 'number', 'salaryItem', 0, 1, 0, to_date('2022-05-05 16:23:21','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 16:23:21','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651739002682, '<EFBFBD>ۼ<EFBFBD><EFBFBD>籣<EFBFBD><EFBFBD><EFBFBD>˺ϼ<EFBFBD>', 1651739000845, 'addUpSituation_addUpSocialSecurityTotal', '{<7B><><EFBFBD><EFBFBD><EFBFBD>ۼ<EFBFBD><DBBC><EFBFBD><EFBFBD><EFBFBD>.<2E>ۼ<EFBFBD><DBBC>籣<EFBFBD><E7B1A3><EFBFBD>˺ϼ<CBBA>}', 'number', 'addUpSituation', 1, 1, 0, to_date('2022-05-05 16:23:21','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 16:23:21','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651739003139, '<EFBFBD>ۼƹ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>˺ϼ<EFBFBD>', 1651739000845, 'addUpSituation_addUpAccumulationFundTotal', '{<7B><><EFBFBD><EFBFBD><EFBFBD>ۼ<EFBFBD><DBBC><EFBFBD><EFBFBD><EFBFBD>.<2E>ۼƹ<DBBC><C6B9><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>˺ϼ<CBBA>}', 'number', 'addUpSituation', 2, 1, 0, to_date('2022-05-05 16:23:21','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 16:23:21','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651739054270, '<EFBFBD>ۼ<EFBFBD><EFBFBD><EFBFBD>Ů<EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 1651739053212, 'addUpDeductions_addUpChildEducation', '{<7B>ۼ<EFBFBD>ר<EFBFBD><EFBFBD>ӿ۳<D3BF>.<2E>ۼ<EFBFBD><DBBC><EFBFBD>Ů<EFBFBD><C5AE><EFBFBD><EFBFBD>}', 'number', 'addUpDeductions', 0, 1, 0, to_date('2022-05-05 16:24:13','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 16:24:13','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651739101122, '<EFBFBD>ۼ<EFBFBD>ס<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ϣ', 1651739100651, 'addUpSituation_addUpHousingLoannumbererest', '{<7B><><EFBFBD><EFBFBD><EFBFBD>ۼ<EFBFBD><DBBC><EFBFBD><EFBFBD><EFBFBD>.<2E>ۼ<EFBFBD>ס<EFBFBD><D7A1><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ϣ}', 'number', 'addUpSituation', 0, 1, 0, to_date('2022-05-05 16:25:01','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 16:25:01','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651739151221, '<EFBFBD>ۼ<EFBFBD>ס<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 1651739151122, 'addUpSituation_addUpHousingRent', '{<7B><><EFBFBD><EFBFBD><EFBFBD>ۼ<EFBFBD><DBBC><EFBFBD><EFBFBD><EFBFBD>.<2E>ۼ<EFBFBD>ס<EFBFBD><D7A1><EFBFBD><EFBFBD><EFBFBD><EFBFBD>}', 'number', 'addUpSituation', 0, 1, 0, to_date('2022-05-05 16:25:51','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 16:25:51','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651739213082, '<EFBFBD>ۼƼ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 1651739212437, 'addUpSituation_addUpContinuingEducation', '{<7B><><EFBFBD><EFBFBD><EFBFBD>ۼ<EFBFBD><DBBC><EFBFBD><EFBFBD><EFBFBD>.<2E>ۼƼ<DBBC><C6BC><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>}', 'number', 'addUpSituation', 0, 1, 0, to_date('2022-05-05 16:26:52','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 16:26:52','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651739311009, '<EFBFBD>ۼ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 1651739310959, 'addUpSituation_addUpSupportElderly', '{<7B><><EFBFBD><EFBFBD><EFBFBD>ۼ<EFBFBD><DBBC><EFBFBD><EFBFBD><EFBFBD>.<2E>ۼ<EFBFBD><DBBC><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>}', 'number', 'addUpSituation', 0, 1, 0, to_date('2022-05-05 16:28:31','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 16:28:31','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651739411502, '<EFBFBD>ۼ<EFBFBD><EFBFBD><EFBFBD>Ů<EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 1651739411365, 'salaryItem_addUpChildEducation', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E>ۼ<EFBFBD><DBBC><EFBFBD>Ů<EFBFBD><C5AE><EFBFBD><EFBFBD>}', 'number', 'salaryItem', 0, 1, 0, to_date('2022-05-05 16:30:11','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 16:30:11','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651739411637, '<EFBFBD>ۼ<EFBFBD>ס<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ϣ', 1651739411365, 'salaryItem_addUpHousingLoannumbererest', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E>ۼ<EFBFBD>ס<EFBFBD><D7A1><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ϣ}', 'number', 'salaryItem', 1, 1, 0, to_date('2022-05-05 16:30:11','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 16:30:11','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651739411715, '<EFBFBD>ۼ<EFBFBD>ס<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 1651739411365, 'salaryItem_addUpHousingRent', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E>ۼ<EFBFBD>ס<EFBFBD><D7A1><EFBFBD><EFBFBD><EFBFBD><EFBFBD>}', 'number', 'salaryItem', 2, 1, 0, to_date('2022-05-05 16:30:11','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 16:30:11','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651739411773, '<EFBFBD>ۼƼ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 1651739411365, 'salaryItem_addUpContinuingEducation', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E>ۼƼ<DBBC><C6BC><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>}', 'number', 'salaryItem', 3, 1, 0, to_date('2022-05-05 16:30:11','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 16:30:11','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651739412718, '<EFBFBD>ۼ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 1651739411365, 'salaryItem_addUpSupportElderly', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E>ۼ<EFBFBD><DBBC><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>}', 'number', 'salaryItem', 4, 1, 0, to_date('2022-05-05 16:30:11','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 16:30:11','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651739819892, '<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 1651739815651, 'salaryItem_annuity', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>}', 'number', 'salaryItem', 0, 1, 0, to_date('2022-05-05 16:36:56','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 16:36:56','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651739822564, '<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 1651739815651, 'salaryItem_commercialHealthInsurance', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>ҵ<EFBFBD><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>}', 'number', 'salaryItem', 1, 1, 0, to_date('2022-05-05 16:36:56','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 16:36:56','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651739826637, '˰<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ϱ<EFBFBD><EFBFBD><EFBFBD>', 1651739815651, 'salaryItem_taxDeferredEndowmentInsurance', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.˰<><CBB0><EFBFBD><EFBFBD><EFBFBD>ϱ<EFBFBD><CFB1><EFBFBD>}', 'number', 'salaryItem', 2, 1, 0, to_date('2022-05-05 16:36:56','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 16:36:56','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651739828954, '<EFBFBD>Ʋ<EFBFBD>ԭֵ?', 1651739815651, 'salaryItem_originalValueOfProperty', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E>Ʋ<EFBFBD>ԭֵ}', 'number', 'salaryItem', 3, 1, 0, to_date('2022-05-05 16:36:56','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 16:36:56','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651739829915, '<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>۳<EFBFBD><EFBFBD><EFBFBD>˰<EFBFBD><EFBFBD>', 1651739815651, 'salaryItem_deductedTax', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><><EFBFBD><EFBFBD><EFBFBD>۳<EFBFBD><DBB3><EFBFBD>˰<EFBFBD><CBB0>}', 'number', 'salaryItem', 4, 1, 0, to_date('2022-05-05 16:36:56','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 16:36:56','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651739830465, '<EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 1651739815651, 'salaryItem_other', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><><EFBFBD><EFBFBD>}', 'number', 'salaryItem', 5, 1, 0, to_date('2022-05-05 16:36:56','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 16:36:56','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651740240713, '<EFBFBD><EFBFBD><EFBFBD>£<EFBFBD><EFBFBD>Σ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>۳<EFBFBD><EFBFBD>ϼ<EFBFBD>', 1651740238860, 'salaryItem_otherDeduction', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><><EFBFBD>£<EFBFBD><C2A3>Σ<EFBFBD><CEA3><EFBFBD><EFBFBD><EFBFBD><EFBFBD>۳<EFBFBD><DBB3>ϼ<EFBFBD>}', 'number', 'salaryItem', 0, 1, 0, to_date('2022-05-05 16:43:59','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 16:43:59','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651740241221, '<EFBFBD>ۼ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>˰<EFBFBD>۳<EFBFBD>', 1651740238860, 'addUpSituation_addUpOtherDeduction', '{<7B><><EFBFBD><EFBFBD><EFBFBD>ۼ<EFBFBD><DBBC><EFBFBD><EFBFBD><EFBFBD>.<2E>ۼ<EFBFBD><DBBC><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>˰<EFBFBD>۳<EFBFBD>}', 'number', 'addUpSituation', 1, 1, 0, to_date('2022-05-05 16:43:59','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 16:43:59','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651740241717, '<EFBFBD>ۼ<EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>ְҵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 1651740238860, 'addUpSituation_addUpEnterpriseAndOther', '{<7B><><EFBFBD><EFBFBD><EFBFBD>ۼ<EFBFBD><DBBC><EFBFBD><EFBFBD><EFBFBD>.<2E>ۼ<EFBFBD><DBBC><EFBFBD>ҵ<EFBFBD><D2B5>ְҵ<D6B0><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>}', 'number', 'addUpSituation', 2, 1, 0, to_date('2022-05-05 16:43:59','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 16:43:59','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651740397497, '<EFBFBD><EFBFBD><EFBFBD>£<EFBFBD><EFBFBD>Σ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 1651740397225, 'salaryItem_subtraction', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><><EFBFBD>£<EFBFBD><C2A3>Σ<EFBFBD><CEA3><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>}', 'number', 'salaryItem', 0, 1, 0, to_date('2022-05-05 16:46:37','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 16:46:37','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651740397989, '<EFBFBD>ۼƼ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 1651740397225, 'addUpSituation_addUpSubtraction', '{<7B><><EFBFBD><EFBFBD><EFBFBD>ۼ<EFBFBD><DBBC><EFBFBD><EFBFBD><EFBFBD>.<2E>ۼƼ<DBBC><C6BC><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>}', 'number', 'addUpSituation', 1, 1, 0, to_date('2022-05-05 16:46:37','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 16:46:37','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651742185950, '<EFBFBD><EFBFBD>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ<EFBFBD><EFBFBD>˰<EFBFBD><EFBFBD><EFBFBD>ö<EFBFBD>', 1651742185837, 'salaryItem_addUpTaxableIncome', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ<EFBFBD><D3A6>˰<EFBFBD><CBB0><EFBFBD>ö<EFBFBD>}', 'number', 'salaryItem', 0, 1, 0, to_date('2022-05-05 17:16:26','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 17:16:26','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651742185995, '<EFBFBD><EFBFBD>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ<EFBFBD><EFBFBD>˰<EFBFBD><EFBFBD><EFBFBD>ö<EFBFBD>', 1651742185837, 'salaryItem_addUpTaxableIncome', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ<EFBFBD><D3A6>˰<EFBFBD><CBB0><EFBFBD>ö<EFBFBD>}', 'number', 'salaryItem', 1, 1, 0, to_date('2022-05-05 17:16:26','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 17:16:26','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651742186035, '<EFBFBD><EFBFBD>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ<EFBFBD><EFBFBD>˰<EFBFBD><EFBFBD><EFBFBD>ö<EFBFBD>', 1651742185837, 'salaryItem_addUpTaxableIncome', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ<EFBFBD><D3A6>˰<EFBFBD><CBB0><EFBFBD>ö<EFBFBD>}', 'number', 'salaryItem', 2, 1, 0, to_date('2022-05-05 17:16:26','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 17:16:26','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651742186085, '<EFBFBD><EFBFBD>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ<EFBFBD><EFBFBD>˰<EFBFBD><EFBFBD><EFBFBD>ö<EFBFBD>', 1651742185837, 'salaryItem_addUpTaxableIncome', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ<EFBFBD><D3A6>˰<EFBFBD><CBB0><EFBFBD>ö<EFBFBD>}', 'number', 'salaryItem', 3, 1, 0, to_date('2022-05-05 17:16:26','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 17:16:26','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651742186122, '<EFBFBD><EFBFBD>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ<EFBFBD><EFBFBD>˰<EFBFBD><EFBFBD><EFBFBD>ö<EFBFBD>', 1651742185837, 'salaryItem_addUpTaxableIncome', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ<EFBFBD><D3A6>˰<EFBFBD><CBB0><EFBFBD>ö<EFBFBD>}', 'number', 'salaryItem', 4, 1, 0, to_date('2022-05-05 17:16:26','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 17:16:26','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651742186155, '<EFBFBD><EFBFBD>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ<EFBFBD><EFBFBD>˰<EFBFBD><EFBFBD><EFBFBD>ö<EFBFBD>', 1651742185837, 'salaryItem_addUpTaxableIncome', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ<EFBFBD><D3A6>˰<EFBFBD><CBB0><EFBFBD>ö<EFBFBD>}', 'number', 'salaryItem', 5, 1, 0, to_date('2022-05-05 17:16:26','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 17:16:26','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651742186199, '<EFBFBD><EFBFBD>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ<EFBFBD><EFBFBD>˰<EFBFBD><EFBFBD><EFBFBD>ö<EFBFBD>', 1651742185837, 'salaryItem_addUpTaxableIncome', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ<EFBFBD><D3A6>˰<EFBFBD><CBB0><EFBFBD>ö<EFBFBD>}', 'number', 'salaryItem', 6, 1, 0, to_date('2022-05-05 17:16:26','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 17:16:26','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651742704826, '<EFBFBD><EFBFBD>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ<EFBFBD><EFBFBD>˰<EFBFBD><EFBFBD><EFBFBD>ö<EFBFBD>', 1651742702735, 'salaryItem_addUpTaxableIncome', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ<EFBFBD><D3A6>˰<EFBFBD><CBB0><EFBFBD>ö<EFBFBD>}', 'number', 'salaryItem', 0, 1, 0, to_date('2022-05-05 17:25:03','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 17:25:03','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651742705308, '<EFBFBD><EFBFBD>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ<EFBFBD><EFBFBD>˰<EFBFBD><EFBFBD><EFBFBD>ö<EFBFBD>', 1651742702735, 'salaryItem_addUpTaxableIncome', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ<EFBFBD><D3A6>˰<EFBFBD><CBB0><EFBFBD>ö<EFBFBD>}', 'number', 'salaryItem', 1, 1, 0, to_date('2022-05-05 17:25:03','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 17:25:03','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651742705782, '<EFBFBD><EFBFBD>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ<EFBFBD><EFBFBD>˰<EFBFBD><EFBFBD><EFBFBD>ö<EFBFBD>', 1651742702735, 'salaryItem_addUpTaxableIncome', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ<EFBFBD><D3A6>˰<EFBFBD><CBB0><EFBFBD>ö<EFBFBD>}', 'number', 'salaryItem', 2, 1, 0, to_date('2022-05-05 17:25:03','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 17:25:03','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651742705831, '<EFBFBD><EFBFBD>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ<EFBFBD><EFBFBD>˰<EFBFBD><EFBFBD><EFBFBD>ö<EFBFBD>', 1651742702735, 'salaryItem_addUpTaxableIncome', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ<EFBFBD><D3A6>˰<EFBFBD><CBB0><EFBFBD>ö<EFBFBD>}', 'number', 'salaryItem', 3, 1, 0, to_date('2022-05-05 17:25:03','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 17:25:03','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651742706306, '<EFBFBD><EFBFBD>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ<EFBFBD><EFBFBD>˰<EFBFBD><EFBFBD><EFBFBD>ö<EFBFBD>', 1651742702735, 'salaryItem_addUpTaxableIncome', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ<EFBFBD><D3A6>˰<EFBFBD><CBB0><EFBFBD>ö<EFBFBD>}', 'number', 'salaryItem', 4, 1, 0, to_date('2022-05-05 17:25:03','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 17:25:03','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651742706368, '<EFBFBD><EFBFBD>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ<EFBFBD><EFBFBD>˰<EFBFBD><EFBFBD><EFBFBD>ö<EFBFBD>', 1651742702735, 'salaryItem_addUpTaxableIncome', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ<EFBFBD><D3A6>˰<EFBFBD><CBB0><EFBFBD>ö<EFBFBD>}', 'number', 'salaryItem', 5, 1, 0, to_date('2022-05-05 17:25:03','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 17:25:03','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651745446904, '<EFBFBD><EFBFBD>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ˰<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ϼ<EFBFBD>', 1651745445982, 'salaryItem_addUpIncome', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ˰<D3A6><CBB0><EFBFBD><EFBFBD><EFBFBD>ϼ<EFBFBD>}', 'number', 'salaryItem', 0, 1, 0, to_date('2022-05-05 18:10:46','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 18:10:46','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651745447442, '<EFBFBD><EFBFBD>ǰ<EFBFBD>ۼ<EFBFBD>ר<EFBFBD><EFBFBD><EFBFBD>۳<EFBFBD><EFBFBD>ϼ<EFBFBD>', 1651745445982, 'salaryItem_addUpSpecialDeduction', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>ǰ<EFBFBD>ۼ<EFBFBD>ר<EFBFBD><D7A8><EFBFBD>۳<EFBFBD><DBB3>ϼ<EFBFBD>}', 'number', 'salaryItem', 1, 1, 0, to_date('2022-05-05 18:10:46','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 18:10:46','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651745447969, '<EFBFBD><EFBFBD>ǰ<EFBFBD>ۼ<EFBFBD>ר<EFBFBD><EFBFBD>ӿ۳<EFBFBD><EFBFBD>ϼ<EFBFBD>', 1651745445982, 'salaryItem_addUpSpeAddiDeduction', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>ǰ<EFBFBD>ۼ<EFBFBD>ר<EFBFBD><EFBFBD>ӿ۳<D3BF><DBB3>ϼ<EFBFBD>}', 'number', 'salaryItem', 2, 1, 0, to_date('2022-05-05 18:10:46','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 18:10:46','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651745448475, '<EFBFBD><EFBFBD>ǰ<EFBFBD>ۼ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>۳<EFBFBD><EFBFBD>ϼ<EFBFBD>', 1651745445982, 'salaryItem_addUpOtherDeduction', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>ǰ<EFBFBD>ۼ<EFBFBD><DBBC><EFBFBD><EFBFBD><EFBFBD><EFBFBD>۳<EFBFBD><DBB3>ϼ<EFBFBD>}', 'number', 'salaryItem', 3, 1, 0, to_date('2022-05-05 18:10:46','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 18:10:46','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651745451616, '<EFBFBD><EFBFBD>ǰ<EFBFBD>ۼƼ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 1651745445982, 'salaryItem_addUpSubtraction', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>ǰ<EFBFBD>ۼƼ<DBBC><C6BC><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>}', 'number', 'salaryItem', 4, 1, 0, to_date('2022-05-05 18:10:46','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 18:10:46','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651745452097, '<EFBFBD><EFBFBD>ǰ<EFBFBD>ۼ<EFBFBD>׼<EFBFBD><EFBFBD><EFBFBD>۳<EFBFBD><EFBFBD>ľ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 1651745445982, 'salaryItem_addUpAllowedDonation', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>ǰ<EFBFBD>ۼ<EFBFBD>׼<EFBFBD><D7BC><EFBFBD>۳<EFBFBD><DBB3>ľ<EFBFBD><C4BE><EFBFBD><EFBFBD><EFBFBD>}', 'number', 'salaryItem', 5, 1, 0, to_date('2022-05-05 18:10:46','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 18:10:46','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651748888918, '<EFBFBD><EFBFBD>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ<EFBFBD><EFBFBD>˰<EFBFBD><EFBFBD><EFBFBD>ö<EFBFBD>', 1651748888864, 'salaryItem_addUpTaxableIncome', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ<EFBFBD><D3A6>˰<EFBFBD><CBB0><EFBFBD>ö<EFBFBD>}', 'number', 'salaryItem', 0, 1, 0, to_date('2022-05-05 19:08:09','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 19:08:09','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651748888952, '<EFBFBD><EFBFBD><EFBFBD>£<EFBFBD><EFBFBD>Σ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>н<EFBFBD><EFBFBD>˰˰<EFBFBD><EFBFBD>', 1651748888864, 'salaryItem_taxRate', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><><EFBFBD>£<EFBFBD><C2A3>Σ<EFBFBD><CEA3><EFBFBD><EFBFBD><EFBFBD>н<EFBFBD><D0BD>˰˰<CBB0><CBB0>}', 'number', 'salaryItem', 1, 1, 0, to_date('2022-05-05 19:08:09','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 19:08:09','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651748888989, '<EFBFBD><EFBFBD><EFBFBD>£<EFBFBD><EFBFBD>Σ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>н<EFBFBD><EFBFBD>˰<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>۳<EFBFBD><EFBFBD><EFBFBD>', 1651748888864, 'salaryItem_quickDeductionFactor', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><><EFBFBD>£<EFBFBD><C2A3>Σ<EFBFBD><CEA3><EFBFBD><EFBFBD><EFBFBD>н<EFBFBD><D0BD>˰<EFBFBD><CBB0><EFBFBD><EFBFBD><EFBFBD>۳<EFBFBD><DBB3><EFBFBD>}', 'number', 'salaryItem', 2, 1, 0, to_date('2022-05-05 19:08:09','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 19:08:09','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651748978520, '<EFBFBD>ۼ<EFBFBD><EFBFBD><EFBFBD>Ԥ<EFBFBD><EFBFBD>Ԥ<EFBFBD><EFBFBD>˰<EFBFBD><EFBFBD>', 1651748978482, 'addUpSituation_addUpAdvanceTax', '{<7B><><EFBFBD><EFBFBD><EFBFBD>ۼ<EFBFBD><DBBC><EFBFBD><EFBFBD><EFBFBD>.<2E>ۼ<EFBFBD><DBBC><EFBFBD>Ԥ<EFBFBD><D4A4>Ԥ<EFBFBD><D4A4>˰<EFBFBD><CBB0>}', 'number', 'addUpSituation', 0, 1, 0, to_date('2022-05-05 19:09:38','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 19:09:38','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651749112037, '<EFBFBD><EFBFBD>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ<EFBFBD><EFBFBD>˰<EFBFBD><EFBFBD>', 1651749111981, 'salaryItem_addUpTaxPayable', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>ǰ<EFBFBD>ۼ<EFBFBD>Ӧ<EFBFBD><D3A6>˰<EFBFBD><CBB0>}', 'number', 'salaryItem', 0, 1, 0, to_date('2022-05-05 19:11:52','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 19:11:52','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651749112068, '<EFBFBD><EFBFBD>ǰ<EFBFBD>ۼ<EFBFBD><EFBFBD>ѿ۽<EFBFBD>˰<EFBFBD><EFBFBD><EFBFBD>ϼ<EFBFBD>', 1651749111981, 'salaryItem_addUpAdvanceTax', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>ǰ<EFBFBD>ۼ<EFBFBD><DBBC>ѿ۽<D1BF>˰<EFBFBD><CBB0><EFBFBD>ϼ<EFBFBD>}', 'number', 'salaryItem', 1, 1, 0, to_date('2022-05-05 19:11:52','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 19:11:52','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651749112116, '<EFBFBD><EFBFBD>ǰ<EFBFBD>ۼƼ<EFBFBD><EFBFBD><EFBFBD>˰<EFBFBD><EFBFBD><EFBFBD>ϼ<EFBFBD>', 1651749111981, 'salaryItem_addUpTaxDeduction', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><>ǰ<EFBFBD>ۼƼ<DBBC><C6BC><EFBFBD>˰<EFBFBD><CBB0><EFBFBD>ϼ<EFBFBD>}', 'number', 'salaryItem', 2, 1, 0, to_date('2022-05-05 19:11:52','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 19:11:52','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651749240040, '<EFBFBD><EFBFBD><EFBFBD>£<EFBFBD><EFBFBD>Σ<EFBFBD>Ӧ˰<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ϼ<EFBFBD>', 1651749240004, 'salaryItem_income', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><><EFBFBD>£<EFBFBD><C2A3>Σ<EFBFBD>Ӧ˰<D3A6><CBB0><EFBFBD><EFBFBD><EFBFBD>ϼ<EFBFBD>}', 'number', 'salaryItem', 0, 1, 0, to_date('2022-05-05 19:14:00','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 19:14:00','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651749240082, '<EFBFBD><EFBFBD><EFBFBD>£<EFBFBD><EFBFBD>Σ<EFBFBD>ר<EFBFBD><EFBFBD><EFBFBD>۳<EFBFBD><EFBFBD>ϼ<EFBFBD>', 1651749240004, 'salaryItem_specialDeduction', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><><EFBFBD>£<EFBFBD><C2A3>Σ<EFBFBD>ר<EFBFBD><D7A8><EFBFBD>۳<EFBFBD><DBB3>ϼ<EFBFBD>}', 'number', 'salaryItem', 1, 1, 0, to_date('2022-05-05 19:14:00','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 19:14:00','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651749240117, '<EFBFBD><EFBFBD><EFBFBD>£<EFBFBD><EFBFBD>Σ<EFBFBD>Ӧ<EFBFBD><EFBFBD>˰<EFBFBD><EFBFBD>', 1651749240004, 'salaryItem_refundedOrSupplementedTax', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><><EFBFBD>£<EFBFBD><C2A3>Σ<EFBFBD>Ӧ<EFBFBD><D3A6>˰<EFBFBD><CBB0>}', 'number', 'salaryItem', 2, 1, 0, to_date('2022-05-05 19:14:00','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 19:14:00','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651749240164, '˰<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ϼ<EFBFBD>', 1651749240004, 'salaryItem_afterTaxAdjustmentTotal', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.˰<><CBB0><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ϼ<EFBFBD>}', 'number', 'salaryItem', 3, 1, 0, to_date('2022-05-05 19:14:00','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 19:14:00','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651749240199, '˰<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ϼ<EFBFBD>', 1651749240004, 'salaryItem_afterTaxReimbursementTotal', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.˰<><CBB0><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ϼ<EFBFBD>}', 'number', 'salaryItem', 4, 1, 0, to_date('2022-05-05 19:14:00','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 19:14:00','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651749240245, '˰<EFBFBD><EFBFBD><EFBFBD>ۿ<EFBFBD><EFBFBD>ϼ<EFBFBD>', 1651749240004, 'salaryItem_afterTaxDeductionsTotal', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.˰<><CBB0><EFBFBD>ۿ<EFBFBD><DBBF>ϼ<EFBFBD>}', 'number', 'salaryItem', 5, 1, 0, to_date('2022-05-05 19:14:00','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 19:14:00','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651749398399, '<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 1651749398360, 'welfare_9007otherPer', '{<7B>籣<EFBFBD><E7B1A3><EFBFBD><EFBFBD>.<2E><>ҵ<EFBFBD><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>}', 'number', 'welfare', 0, 1, 0, to_date('2022-05-05 19:16:38','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 19:16:38','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651749448843, '<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 1651749448800, 'otherDeduction_businessHealthyInsurance', '{<7B><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>˰<EFBFBD>۳<EFBFBD>.<2E><>ҵ<EFBFBD><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>}', 'number', 'otherDeduction', 0, 1, 0, to_date('2022-05-05 19:17:29','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 19:17:29','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651749487225, '˰<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ϱ<EFBFBD><EFBFBD><EFBFBD>', 1651749487187, 'otherDeduction_taxDelayEndowmentInsurance', '{<7B><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>˰<EFBFBD>۳<EFBFBD>.˰<><CBB0><EFBFBD><EFBFBD><EFBFBD>ϱ<EFBFBD><CFB1><EFBFBD>}', 'number', 'otherDeduction', 0, 1, 0, to_date('2022-05-05 19:18:07','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 19:18:07','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651749540213, '<EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 1651749540147, 'otherDeduction_otherDeduction', '{<7B><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>˰<EFBFBD>۳<EFBFBD>.<2E><><EFBFBD><EFBFBD>}', 'number', 'otherDeduction', 0, 1, 0, to_date('2022-05-05 19:19:00','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 19:19:00','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651749596472, '׼<EFBFBD><EFBFBD><EFBFBD>۳<EFBFBD><EFBFBD>ľ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 1651749595061, 'otherDeduction_deductionAllowedDonation', '{<7B><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>˰<EFBFBD>۳<EFBFBD>.׼<><D7BC><EFBFBD>۳<EFBFBD><DBB3>ľ<EFBFBD><C4BE><EFBFBD><EFBFBD><EFBFBD>}', 'number', 'otherDeduction', 0, 1, 0, to_date('2022-05-05 19:19:55','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 19:19:55','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651749675326, '<EFBFBD><EFBFBD><EFBFBD>£<EFBFBD><EFBFBD>Σ<EFBFBD>׼<EFBFBD>ʿ۳<EFBFBD><EFBFBD>ľ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 1651749675268, 'salaryItem_allowedDonation', '{н<><D0BD><EFBFBD><EFBFBD>Ŀ.<2E><><EFBFBD>£<EFBFBD><C2A3>Σ<EFBFBD>׼<EFBFBD>ʿ۳<CABF><DBB3>ľ<EFBFBD><C4BE><EFBFBD><EFBFBD><EFBFBD>}', 'number', 'salaryItem', 0, 1, 0, to_date('2022-05-05 19:21:15','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 19:21:15','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651749675365, '<EFBFBD>ۼ<EFBFBD>׼<EFBFBD><EFBFBD><EFBFBD>۳<EFBFBD><EFBFBD>ľ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 1651749675268, 'addUpSituation_addUpAllowedDonation', '{<7B><><EFBFBD><EFBFBD><EFBFBD>ۼ<EFBFBD><DBBC><EFBFBD><EFBFBD><EFBFBD>.<2E>ۼ<EFBFBD>׼<EFBFBD><D7BC><EFBFBD>۳<EFBFBD><DBB3>ľ<EFBFBD><C4BE><EFBFBD><EFBFBD><EFBFBD>}', 'number', 'addUpSituation', 1, 1, 0, to_date('2022-05-05 19:21:15','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 19:21:15','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651749914793, '<EFBFBD><EFBFBD><EFBFBD>ϱ<EFBFBD><EFBFBD>ո<EFBFBD><EFBFBD><EFBFBD>', 1651749914746, 'welfare_9001socialPer', '{<7B>籣<EFBFBD><E7B1A3><EFBFBD><EFBFBD>.<2E><><EFBFBD>ϱ<EFBFBD><CFB1>ո<EFBFBD><D5B8><EFBFBD>}', 'number', 'welfare', 0, 1, 0, to_date('2022-05-05 19:25:15','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 19:25:15','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651749958917, 'ҽ<EFBFBD>Ʊ<EFBFBD><EFBFBD>ո<EFBFBD><EFBFBD><EFBFBD>', 1651749958879, 'welfare_9002socialPer', '{<7B>籣<EFBFBD><E7B1A3><EFBFBD><EFBFBD>.ҽ<>Ʊ<EFBFBD><C6B1>ո<EFBFBD><D5B8><EFBFBD>}', 'number', 'welfare', 0, 1, 0, to_date('2022-05-05 19:25:59','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 19:25:59','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651750005320, 'ʧҵ<EFBFBD><EFBFBD><EFBFBD>ո<EFBFBD><EFBFBD><EFBFBD>', 1651750005281, 'welfare_9004socialPer', '{<7B>籣<EFBFBD><E7B1A3><EFBFBD><EFBFBD>.ʧҵ<CAA7><D2B5><EFBFBD>ո<EFBFBD><D5B8><EFBFBD>}', 'number', 'welfare', 0, 1, 0, to_date('2022-05-05 19:26:45','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 19:26:45','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651750034727, 'ס<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 1651750034689, 'welfare_9006fundPer', '{<7B>籣<EFBFBD><E7B1A3><EFBFBD><EFBFBD>.ס<><D7A1><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>}', 'number', 'welfare', 0, 1, 0, to_date('2022-05-05 19:27:15','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-05 19:27:15','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651801435862, '<EFBFBD>籣<EFBFBD><EFBFBD><EFBFBD>˺ϼ<EFBFBD>', 1651801433504, 'welfare_socialPerSum', '{<7B>籣<EFBFBD><E7B1A3><EFBFBD><EFBFBD>.<2E>籣<EFBFBD><E7B1A3><EFBFBD>˺ϼ<CBBA>}', 'number', 'welfare', 0, 1, 0, to_date('2022-05-06 09:43:54','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-06 09:43:54','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651801436423, '<EFBFBD>ۼ<EFBFBD><EFBFBD>籣<EFBFBD><EFBFBD><EFBFBD>˺ϼ<EFBFBD>', 1651801433504, 'addUpSituation_addUpSocialSecurityTotal', '{<7B><><EFBFBD><EFBFBD><EFBFBD>ۼ<EFBFBD><DBBC><EFBFBD><EFBFBD><EFBFBD>.<2E>ۼ<EFBFBD><DBBC>籣<EFBFBD><E7B1A3><EFBFBD>˺ϼ<CBBA>}', 'number', 'addUpSituation', 1, 1, 0, to_date('2022-05-06 09:43:54','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-06 09:43:54','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651801587331, '<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>˺ϼ<EFBFBD>', 1651801586972, 'welfare_fundPerSum', '{<7B>籣<EFBFBD><E7B1A3><EFBFBD><EFBFBD>.<2E><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>˺ϼ<CBBA>}', 'number', 'welfare', 0, 1, 0, to_date('2022-05-06 09:46:27','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-06 09:46:27','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651801587794, '<EFBFBD>ۼƹ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>˺ϼ<EFBFBD>', 1651801586972, 'addUpSituation_addUpAccumulationFundTotal', '{<7B><><EFBFBD><EFBFBD><EFBFBD>ۼ<EFBFBD><DBBC><EFBFBD><EFBFBD><EFBFBD>.<2E>ۼƹ<DBBC><C6B9><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>˺ϼ<CBBA>}', 'number', 'addUpSituation', 1, 1, 0, to_date('2022-05-06 09:46:27','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-06 09:46:27','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651801669969, '<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>˺ϼ<EFBFBD>', 1651801667770, 'welfare_otherPerSum', '{<7B>籣<EFBFBD><E7B1A3><EFBFBD><EFBFBD>.<2E><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>˺ϼ<CBBA>}', 'number', 'welfare', 0, 1, 0, to_date('2022-05-06 09:47:48','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-06 09:47:48','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_formula_var(id, name, formula_id, field_id, field_name, field_type, source, order_index, creator, delete_type, create_time, update_time) VALUES (1651801670474, '<EFBFBD>ۼ<EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>ְҵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 1651801667770, 'addUpSituation_addUpEnterpriseAndOther', '{<7B><><EFBFBD><EFBFBD><EFBFBD>ۼ<EFBFBD><DBBC><EFBFBD><EFBFBD><EFBFBD>.<2E>ۼ<EFBFBD><DBBC><EFBFBD>ҵ<EFBFBD><D2B5>ְҵ<D6B0><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>}', 'number', 'addUpSituation', 1, 1, 0, to_date('2022-05-06 09:47:48','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-06 09:47:48','yyyy-MM-dd HH24:mi:ss'));
/
INSERT into hrsa_sob_default_emp_field(id, field_code, sorted_index, can_delete, creator, create_time, update_time, delete_type, tenant_key) VALUES (681983911359291652, 'taxAgentName', 0, 0, 0, to_date('2022-02-23 17:32:08','yyyy-MM-dd HH24:mi:ss'), to_date('2022-02-23 17:32:08','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams');
/
INSERT into hrsa_sob_default_emp_field(id, field_code, sorted_index, can_delete, creator, create_time, update_time, delete_type, tenant_key) VALUES (681983911359291653, 'username', 1, 0, 0, to_date('2022-02-23 17:32:08','yyyy-MM-dd HH24:mi:ss'), to_date('2022-02-23 17:32:08','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams');
/
INSERT into hrsa_sob_default_emp_field(id, field_code, sorted_index, can_delete, creator, create_time, update_time, delete_type, tenant_key) VALUES (681983911359291654, 'departmentName', 2, 0, 0, to_date('2022-02-23 17:32:08','yyyy-MM-dd HH24:mi:ss'), to_date('2022-02-23 17:32:08','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams');
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (704495325212368900, 4, 703459464954929153, 1, 0, 0, to_date('2022-03-14 11:32:31','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-17 16:14:11','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 704495325212368899, 0);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (704495325212368902, 4, 703458434280095745, 1, 0, 0, to_date('2022-03-14 11:32:31','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-17 16:14:11','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 704495325212368901, 0);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (704495325212368903, 4, 703458558739300353, 1, 0, 0, to_date('2022-03-14 11:32:31','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-17 16:14:11','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 704495325212368901, 1);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (704495325212368905, 4, 674914626953093123, 1, 0, 0, to_date('2022-03-14 11:32:31','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-17 16:14:11','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 704495325212368904, 0);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (704495325212368906, 4, 674914626953093124, 1, 0, 0, to_date('2022-03-14 11:32:32','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-17 16:14:11','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 704495325212368904, 1);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (704495325212368907, 4, 674914626953093127, 1, 0, 0, to_date('2022-03-14 11:32:32','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-17 16:14:11','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 704495325212368904, 2);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (704495325212368908, 4, 674916065864646659, 1, 0, 0, to_date('2022-03-14 11:32:32','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-17 16:14:11','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 704495325212368904, 3);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (704495325212368910, 4, 704467747234045953, 1, 0, 0, to_date('2022-03-14 11:32:32','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-17 16:14:11','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 704495325212368909, 0);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (704495325212368911, 4, 704468391612751873, 1, 0, 0, to_date('2022-03-14 11:32:32','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-17 16:14:11','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 704495325212368909, 1);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (704495325212368912, 4, 704468443048992769, 1, 0, 0, to_date('2022-03-14 11:32:32','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-17 16:14:11','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 704495325212368909, 2);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (704495325212368913, 4, 704468490269204481, 1, 0, 0, to_date('2022-03-14 11:32:32','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-17 16:14:11','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 704495325212368909, 3);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (704495325212368914, 4, 704468528928063488, 1, 0, 0, to_date('2022-03-14 11:32:32','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-17 16:14:11','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 704495325212368909, 4);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (704495325212368915, 4, 703459151591383041, 1, 0, 0, to_date('2022-03-14 11:32:32','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-17 16:14:11','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 0, 0);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (706066600446312448, 1, 703459151591383041, 1, 0, 0, to_date('2022-03-14 11:32:31','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-18 16:59:23','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 0, 0);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (706066600446312449, 1, 674861648655892480, 1, 1, 0, to_date('2022-03-14 11:32:28','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-18 16:59:24','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 703433961629614083, 0);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (706066600446312450, 1, 674861768948531201, 1, 1, 0, to_date('2022-03-14 11:32:28','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-18 16:59:23','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 703433961629614083, 1);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (706066600446312451, 1, 674861880508628992, 1, 1, 0, to_date('2022-03-14 11:32:28','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-18 16:59:23','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 703433961629614083, 2);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (706066600446312452, 1, 674920588574261248, 1, 1, 0, to_date('2022-03-14 11:32:28','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-18 16:59:24','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 703433961629614083, 3);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (706066600446312453, 1, 674853617092214790, 1, 0, 0, to_date('2022-03-14 11:32:28','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-18 16:59:24','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 703433961629614083, 4);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (706066600446312454, 1, 674853617092214791, 1, 0, 0, to_date('2022-03-14 11:32:28','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-18 16:59:24','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 703433961629614083, 5);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (706066600446312455, 1, 674914626953093129, 1, 0, 0, to_date('2022-03-14 11:32:28','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-18 16:59:23','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 703433961629614083, 6);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (706066600446312456, 1, 703419929857687552, 1, 0, 0, to_date('2022-03-14 11:32:29','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-18 16:59:23','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 703433961629614083, 7);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (706066600446312457, 1, 674853617092214792, 1, 0, 0, to_date('2022-03-14 11:32:29','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-18 16:59:24','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 703433961629614092, 0);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (706066600446312458, 1, 674853617092214793, 1, 0, 0, to_date('2022-03-14 11:32:29','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-18 16:59:23','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 703433961629614092, 1);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (706066600446312459, 1, 674853617092214795, 1, 0, 0, to_date('2022-03-14 11:32:29','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-18 16:59:23','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 703433961629614092, 2);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (706066600446312460, 1, 674853617092214796, 1, 0, 0, to_date('2022-03-14 11:32:29','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-18 16:59:24','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 703433961629614092, 3);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (706066600446312461, 1, 700599184238075904, 1, 0, 0, to_date('2022-03-14 11:32:29','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-18 16:59:24','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 703433961629614092, 4);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (706066600446312462, 1, 700599446244319233, 1, 0, 0, to_date('2022-03-14 11:32:29','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-18 16:59:23','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 703433961629614092, 5);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (706066600446312463, 1, 674853617092214797, 1, 0, 0, to_date('2022-03-14 11:32:29','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-18 16:59:23','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 703433961629614092, 6);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (706066600446312464, 1, 697532371614588928, 1, 0, 0, to_date('2022-03-14 11:32:29','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-18 16:59:23','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 703433961629614092, 7);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (706066600446312465, 1, 697532667749400576, 1, 0, 0, to_date('2022-03-14 11:32:29','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-18 16:59:24','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 703433961629614092, 8);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (706066600446312466, 1, 697536344384012289, 1, 0, 0, to_date('2022-03-18 16:24:49','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-18 16:59:23','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 703433961629614092, 9);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (706066600446312467, 1, 674853617092214798, 1, 0, 0, to_date('2022-03-14 11:32:29','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-18 16:59:24','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 703433961629614092, 10);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (706066600446312468, 1, 674853617092214803, 1, 0, 0, to_date('2022-03-14 11:32:29','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-18 16:59:23','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 703433961629614103, 0);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (706066600446312469, 1, 674853617092214802, 1, 0, 0, to_date('2022-03-14 11:32:29','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-18 16:59:24','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 703433961629614103, 1);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (706066600446312470, 1, 674853617092214801, 1, 0, 0, to_date('2022-03-14 11:32:29','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-18 16:59:24','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 703433961629614103, 2);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (706066600446312471, 1, 674853617092214800, 1, 0, 0, to_date('2022-03-14 11:32:30','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-18 16:59:24','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 703433961629614103, 3);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (706066600446312472, 1, 674853617092214799, 1, 0, 0, to_date('2022-03-14 11:32:30','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-18 16:59:23','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 703433961629614103, 4);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (706066600446312473, 1, 705641858303836161, 1, 0, 0, to_date('2022-03-17 13:48:51','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-18 16:59:24','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 703433961629614103, 5);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (706066600446312474, 1, 674853617092214804, 1, 0, 0, to_date('2022-03-14 11:32:30','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-18 16:59:23','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 703433961629614103, 6);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (706066600446312475, 1, 674853617092214807, 1, 0, 0, to_date('2022-03-14 11:32:30','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-18 16:59:24','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 703433961629614110, 0);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (706066600446312476, 1, 674853617092214808, 1, 0, 0, to_date('2022-03-14 11:32:30','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-18 16:59:24','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 703433961629614110, 1);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (706066600446312477, 1, 674914626953093122, 1, 0, 0, to_date('2022-03-14 11:32:30','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-18 16:59:24','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 703433961629614110, 2);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (706066600446312478, 1, 674914626953093123, 1, 0, 0, to_date('2022-03-14 11:32:30','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-18 16:59:23','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 703433961629614110, 3);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (706066600446312479, 1, 674914626953093124, 1, 0, 0, to_date('2022-03-14 11:32:30','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-18 16:59:24','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 703433961629614110, 4);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (706066600446312480, 1, 674914626953093127, 1, 0, 0, to_date('2022-03-14 11:32:30','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-18 16:59:23','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 703433961629614110, 5);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (706066600446312481, 1, 674853617092214805, 1, 0, 0, to_date('2022-03-14 11:32:30','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-18 16:59:23','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 703433961629614110, 6);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (706066600446312482, 1, 674853617092214806, 1, 0, 0, to_date('2022-03-14 11:32:30','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-18 16:59:23','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 703433961629614110, 7);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (706066600446312483, 1, 674916065864646659, 1, 0, 0, to_date('2022-03-18 16:30:21','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-18 16:59:24','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 703433961629614110, 8);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (706066600446312484, 1, 674916065864646660, 1, 0, 0, to_date('2022-03-18 16:30:21','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-18 16:59:24','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 703433961629614110, 9);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (706066600446312485, 1, 674853617092214811, 1, 0, 0, to_date('2022-03-14 11:32:30','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-18 16:59:24','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 703433961629614119, 0);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (706066600446312486, 1, 674853617092214809, 1, 0, 0, to_date('2022-03-14 11:32:30','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-18 16:59:23','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 703433961629614119, 1);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (706066600446312487, 1, 674853617092214810, 1, 0, 0, to_date('2022-03-14 11:32:31','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-18 16:59:23','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 703433961629614119, 2);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (706066600446312488, 1, 674853617092214812, 1, 0, 0, to_date('2022-03-14 11:32:31','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-18 16:59:23','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 703433961629614119, 3);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (706066600446312489, 1, 674853617092214813, 1, 0, 0, to_date('2022-03-14 11:32:31','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-18 16:59:23','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 703433961629614119, 4);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (706066600446312490, 1, 674916065864646661, 1, 1, 0, to_date('2022-03-18 16:33:37','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-18 16:59:23','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 703433961629614119, 5);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (706066600446312491, 1, 674916065864646658, 1, 1, 0, to_date('2022-03-18 16:33:37','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-18 16:59:23','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 703433961629614119, 6);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (706066600446312492, 1, 674853617092214814, 1, 0, 0, to_date('2022-03-14 11:32:31','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-18 16:59:24','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 703433961629614119, 7);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (706066600446312493, 1, 674853617092214815, 1, 1, 0, to_date('2022-03-14 11:32:31','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-18 16:59:23','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 703433961629614126, 6);
/
INSERT into hrsa_salary_sob_default_item(id, income_category, sys_salary_item_id, can_edit, can_delete, creator, create_time, update_time, delete_type, tenant_key, sob_default_item_group_id, sorted_index) VALUES (706066600446312494, 1, 700769462612156416, 1, 1, 0, to_date('2022-03-14 11:32:31','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-18 16:59:24','yyyy-MM-dd HH24:mi:ss'), 0, 'all_teams', 703433961629614126, 7);
/
INSERT into hrsa_sob_default_item_group(id, income_category, name, sorted_index, description, create_time, update_time, creator, delete_type, tenant_key) VALUES (703433961629614083, 1, '<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Լ<EFBFBD><EFBFBD><EFBFBD>˰', 0, ' ', SYSDATE, SYSDATE, 0, 0, 'all_teams');
/
INSERT into hrsa_sob_default_item_group(id, income_category, name, sorted_index, description, create_time, update_time, creator, delete_type, tenant_key) VALUES (703433961629614092, 1, 'ר<EFBFBD><EFBFBD><EFBFBD>۳<EFBFBD>', 1, ' ', SYSDATE, SYSDATE, 0, 0, 'all_teams');
/
INSERT into hrsa_sob_default_item_group(id, income_category, name, sorted_index, description, create_time, update_time, creator, delete_type, tenant_key) VALUES (703433961629614103, 1, '<EFBFBD>ۼ<EFBFBD>ר<EFBFBD><EFBFBD>ӿ۳<EFBFBD>', 2, ' ', to_date('2022-03-11 14:49:27','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-11 14:49:27','yyyy-MM-dd HH24:mi:ss'), 0, 0, 'all_teams');
/
INSERT into hrsa_sob_default_item_group(id, income_category, name, sorted_index, description, create_time, update_time, creator, delete_type, tenant_key) VALUES (703433961629614110, 1, '<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>۳<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ϣ', 3, ' ', to_date('2022-03-11 14:49:27','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-11 14:49:27','yyyy-MM-dd HH24:mi:ss'), 0, 0, 'all_teams');
/
INSERT into hrsa_sob_default_item_group(id, income_category, name, sorted_index, description, create_time, update_time, creator, delete_type, tenant_key) VALUES (703433961629614119, 1, '˰<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 4, ' ', to_date('2022-03-11 14:49:27','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-11 14:49:27','yyyy-MM-dd HH24:mi:ss'), 0, 0, 'all_teams');
/
INSERT into hrsa_sob_default_item_group(id, income_category, name, sorted_index, description, create_time, update_time, creator, delete_type, tenant_key) VALUES (703433961629614126, 1, 'Ӧ<EFBFBD><EFBFBD>ʵ<EFBFBD><EFBFBD>', 5, ' ', to_date('2022-03-11 14:49:28','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-11 14:49:28','yyyy-MM-dd HH24:mi:ss'), 0, 0, 'all_teams');
/
INSERT into hrsa_sob_default_item_group(id, income_category, name, sorted_index, description, create_time, update_time, creator, delete_type, tenant_key) VALUES (704495325212368899, 4, '<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ŀ', 0, ' ', to_date('2022-03-15 17:52:48','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-15 18:14:53','yyyy-MM-dd HH24:mi:ss'), 0, 0, 'all_teams');
/
INSERT into hrsa_sob_default_item_group(id, income_category, name, sorted_index, description, create_time, update_time, creator, delete_type, tenant_key) VALUES (704495325212368901, 4, '<EFBFBD><EFBFBD><EFBFBD>뼰<EFBFBD><EFBFBD>˰', 1, ' ', to_date('2022-03-15 17:52:48','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-15 18:14:53','yyyy-MM-dd HH24:mi:ss'), 0, 0, 'all_teams');
/
INSERT into hrsa_sob_default_item_group(id, income_category, name, sorted_index, description, create_time, update_time, creator, delete_type, tenant_key) VALUES (704495325212368904, 4, '<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>۳<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ϣ', 2, ' ', to_date('2022-03-15 17:52:48','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-15 18:14:53','yyyy-MM-dd HH24:mi:ss'), 0, 0, 'all_teams');
/
INSERT into hrsa_sob_default_item_group(id, income_category, name, sorted_index, description, create_time, update_time, creator, delete_type, tenant_key) VALUES (704495325212368909, 4, '˰<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 3, ' ', to_date('2022-03-15 17:52:48','yyyy-MM-dd HH24:mi:ss'), to_date('2022-03-15 18:14:53','yyyy-MM-dd HH24:mi:ss'), 0, 0, 'all_teams');
/
INSERT into hrsa_insurance_category (id, insurance_name, welfare_type, is_use, payment_scope, data_type, create_time, update_time, creator, delete_type, tenant_key) VALUES (9001, '<EFBFBD><EFBFBD><EFBFBD>ϱ<EFBFBD><EFBFBD><EFBFBD>', 1, 1, '1,2', 1, to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'), 0, 0, 'all_teams');
/
INSERT into hrsa_insurance_category (id, insurance_name, welfare_type, is_use, payment_scope, data_type, create_time, update_time, creator, delete_type, tenant_key) VALUES (9002, 'ҽ<EFBFBD>Ʊ<EFBFBD><EFBFBD><EFBFBD>', 1, 1, '1,2', 1, to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'), 0, 0, 'all_teams');
/
INSERT into hrsa_insurance_category (id, insurance_name, welfare_type, is_use, payment_scope, data_type, create_time, update_time, creator, delete_type, tenant_key) VALUES (9003, '<EFBFBD><EFBFBD><EFBFBD>˱<EFBFBD><EFBFBD><EFBFBD>', 1, 1, '1,2', 1, to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'), 0, 0, 'all_teams');
/
INSERT into hrsa_insurance_category (id, insurance_name, welfare_type, is_use, payment_scope, data_type, create_time, update_time, creator, delete_type, tenant_key) VALUES (9004, 'ʧҵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 1, 1, '1,2', 1, to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'), 0, 0, 'all_teams');
/
INSERT into hrsa_insurance_category (id, insurance_name, welfare_type, is_use, payment_scope, data_type, create_time, update_time, creator, delete_type, tenant_key) VALUES (9005, '<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 1, 1, '1,2', 1, to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'), 0, 0, 'all_teams');
/
INSERT into hrsa_insurance_category (id, insurance_name, welfare_type, is_use, payment_scope, data_type, create_time, update_time, creator, delete_type, tenant_key) VALUES (9006, 'ס<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 2, 1, '1,2', 1, to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'), 0, 0, 'all_teams');
/
INSERT into hrsa_insurance_category (id, insurance_name, welfare_type, is_use, payment_scope, data_type, create_time, update_time, creator, delete_type, tenant_key) VALUES (9007, '<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 3, 1, '1,2', 1, to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'), 0, 0, 'all_teams');
/
INSERT into hrsa_insurance_category (id, insurance_name, welfare_type, is_use, payment_scope, data_type, create_time, update_time, creator, delete_type, tenant_key) VALUES (9008, '<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ס<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>', 2, 1, '1,2', 1, to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'), 0, 0, 'all_teams');
/
Reference in New Issue View Git Blame Copy Permalink