CN103236014A - Method for flexibly defining payment and ownership formulas of enterprise annuity account management system - Google Patents

Method for flexibly defining payment and ownership formulas of enterprise annuity account management system Download PDF

Info

Publication number
CN103236014A
CN103236014A CN2013101485128A CN201310148512A CN103236014A CN 103236014 A CN103236014 A CN 103236014A CN 2013101485128 A CN2013101485128 A CN 2013101485128A CN 201310148512 A CN201310148512 A CN 201310148512A CN 103236014 A CN103236014 A CN 103236014A
Authority
CN
China
Prior art keywords
false
fees
enterprise
formula
true
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN2013101485128A
Other languages
Chinese (zh)
Inventor
吴增河
冯昌华
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Inspur Group Shandong General Software Co Ltd
Original Assignee
Inspur Group Shandong General Software Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Inspur Group Shandong General Software Co Ltd filed Critical Inspur Group Shandong General Software Co Ltd
Priority to CN2013101485128A priority Critical patent/CN103236014A/en
Publication of CN103236014A publication Critical patent/CN103236014A/en
Pending legal-status Critical Current

Links

Images

Abstract

The invention provides a method for flexibly defining payment and ownership formulas of an enterprise annuity account management system. According to the method, the operational requirements of enterprise annuity and other pension services of an enterprise annuity fund management organization are met by presetting formula parameter items and calculation condition parameter items, flexibility defining a formula expression and calculation conditions and configuring the rule definition and the flexible formula of each account in different annuity programs. According to the method, the annuity operation organization can flexibly set the annuity payment rule and the ownership rule aiming at every enterprise participating in the annuity program and flexibly configure to realize payment and ownership annuity service operation, so that the service capacity and the service quality of the domestic annuity operation organization are greatly improved, the applicability of the annuity application system is enhanced, the system development and maintenance cost of the pension management organization is reduced, and the enterprise customer demand for participating in the pension is met to a greater extent, thereby improving the initiative of the enterprises for participating in the annuity program and promoting the healthy and rapid development of the national enterprise annuity.

Description

The supplementary pension account management system defines the method for paying the fees and belonging to formula flexibly
Technical field
The pay the fees manner of execution of computing formula, ownership computing formula of a kind of flexible definition that the present invention relates to supplementary pension industry account management infosystem; The present invention is suitable for equally and is used for the manner of execution that pension integrated service information management system is paid the fees and belonged to computing formula.
Background technology
Supplementary pension refers to enterprise and worker thereof on the basis of in accordance with the law participating in basic pension insurance, voluntarily the additional old-age insurance system of setting up.National Ministry of Labour and Social Security had publicized and implemented dispatches such as " supplementary pension trial method ", " supplementary pension fund management trial method ", " supplementary pension fund account management information system standard " in succession in 2004, and first supplementary pension fund management mechanism has been assert in evaluation.
In supplementary pension account management business operation process, the annuity account management system need calculate the amount of money of paying the fees, the ownership amount of money according to different conditions and formula, different supplementary pension plans to the computing formula of paying the fees, the ownership computing formula require different, major part annuity account system does not realize the flexible definition of computing formula, can't satisfy the business demand that the various rule of enterprise is paid the fees, belonged to, after can only corporate client calculating every month earlier and paying the fees, handle by directly paying the fees, increased enterprise cost, lowered enterprise and participated in annuity enthusiasm; Also give annuity management organization having increased the cost input aspect the system reform, the upgrading simultaneously, reduced service quality, be unfavorable for the development of national supplementary pension.Therefore need a kind of method of paying the fees flexibly and belonging to computing formula, satisfy the needs of participating in annuity enterprise, service quality and the timeliness that improves annuity management organization, reduce the cost of management organization aspect information-based.
Summary of the invention
The purpose of this invention is to provide a kind of supplementary pension account management system and define the method for paying the fees and belonging to formula flexibly.
The objective of the invention is to realize in the following manner, the object of the invention is to provide a kind of supplementary pension account management system to realize defining flexibly the manner of execution of paying the fees and belonging to formula, and paying the fees and belong to solution existing enterprise annuity can't self-defining technical matters.The step of this method comprises:
1, initial calculation parameter project
A) create calculating parameter calculating parameter project definition table:
Figure 298653DEST_PATH_IMAGE001
B) initial enterprise plan layer parameter: enterprise's prior year gross pay, enterprise radix, the enterprise ratio etc. of paying the fees of paying the fees;
C) initial personal plan layer parameter: company length of service, society length of service etc.;
D) starter system parameter commonly used: as system data, professional date, system time etc.;
2, initial calculation condition project
A) create design conditions project definition table:
B) initial enterprise plan layer parameter: enterprise branch office numbers, enterprise pays the fees radix, enterprise's total number of persons etc.;
C) initial personal plan layer parameter: date of birth, educational background, degree, position, post, the social length of service etc.;
D) starter system parameter commonly used: as system data, professional date, system time etc.;
3, definition is paid the fees and is belonged to formula
A) create the formula definition list:
Figure 231023DEST_PATH_IMAGE003
B) definition computing formula: by selecting to participate in parameters calculated item, arithmetical operation symbol or function, defined formula calculation expression;
C) definition design conditions: at different each concrete formula, by alternative condition parameter project, comparison operation symbol, logical operator, define this formula applicable elements;
4, the use of computing formula in all kinds of business processing processes of paying the fees
A) Systems Operator pays the fees by rule and initiates to pay the fees calculating, or system timer calls the calculation task of paying the fees automatically according to the parameter that arranges in the rule of paying the fees;
B) the system analysis design conditions of computing formula of paying the fees filter out qualified all workers that pay the fees;
C) the system analysis computing formula of paying the fees, and inquire the actual numerical value that respectively participates in parameters calculated item correspondence in the formula of paying the fees from enterprise plan table, personal plan table is calculated individual's amount of money of should paying the fees;
D) according to the step of b, c, circulation or resolve and calculate the amount of money of paying the fees of everyone each account in batches successively forms enterprise and answers premium notice list and individual detailed, and initiate follow-up audit, examine, to business processing such as accounts;
5, the use of ownership computing formula in all kinds of business processing processes
When a) initiating payment or rolling home service in enterprise, trigger ownership and calculate;
B) system analysis is paid the design conditions that ownership is calculated formula, filters out qualified all workers that pay the fees;
C) system analysis ownership computing formula, and from enterprise plan table, personal plan table, inquire the actual numerical value that respectively participates in parameters calculated item correspondence in the formula of paying the fees, calculating enterprise should belong to the amount of money to the individual;
D) according to the step of b, c, the ownership amount of money of everyone each account is resolved and calculated to circulation or batch successively, and it is detailed to form ownership.
The invention has the beneficial effects as follows:Supplementary pension management organization is by this method, realize annuity business dissimilar in the annuity operation process, participate in the individual demand of different corporate clients aspect the computation rule of paying the fees, ownership computation rule of annuity, improve service quality and the timeliness of annuity management organization; Reduce the cost of management organization aspect information-based.Pass through to satisfy the different demands of participating in annuity enterprise simultaneously, improve the enthusiasm that enterprise participates in annuity, promote the universal and fast-developing of national supplementary pension.
Description of drawings
Fig. 1 is pay the fees rule and computing formula definition interfaces figure;
Fig. 2 is computing formula expression formula definition interfaces figure;
Fig. 3 is computing formula design conditions definition interfaces figure.
Embodiment
Supplementary pension account management system of the present invention defines the method for paying the fees and belonging to formula flexibly, and embodiment is as follows:
1, creates calculating parameter calculating parameter project definition table and initial parameter
Figure 844845DEST_PATH_IMAGE004
2, create design conditions project definition table and initial parameter
Figure 803443DEST_PATH_IMAGE005
3, create the formula definition list
Figure 2013101485128100002DEST_PATH_IMAGE006
4, definition account rule, at each account definition computing formula, as shown in table 2.
5, it is as shown in table 3 to define the result of calculation expression formula of each formula.
6, define the design conditions of each company, as shown in table 4.
The main program assembly
The formula definition is preserved
BL_parseXML analyzing XML assembly
BL_saveList preserves the list assembly
The formula definition
// the page increases formula
function add_jfgs(){
To select account earlier before the // interpolation formula
var sReturnValue="";
var row = tableId_jfzh.cur_row;
if(tableId_jfzh.rows.length==1){
Alert (" please adding the account of paying the fees earlier ");
return false;
}
if(row==null || typeof(row.cells[0])=="undefined")
{
Alert (' the account of please selecting to pay the fees ');
return;
}
if(tableId_jfzh.rows.length>1){
var flag=false;
for(var j=1;j<tableId_jfzh.rows.length;j++){
var myRow=tableId_jfzh.rows[j];
if(myRow.style.display!="none"){
flag=true;
break;
}
}
if(flag==false){
Alert (" please selecting account earlier ");
return false;
}
}
// obtain information such as enterprise plan numbering, coding of accounts
var qyjhbh = document.getElementsByName("ZGQYJH/ZGQYJH_QYJHBH")[0].value;
var zhbh = row.cells[0].value;
// call the equation editing device
sReturnValue=addFormula_jfgzgs("1",qyjhbh,zhbh,"ZGQYJHJFGS");
if (!sReturnValue){
return;
}else{
If // there are data to return, increase delegation earlier, then data are filled
document.all.item("tableId_jfgs_addrow").onclick();
var row = tableId_jfgs.cur_row;
var entity = row.entity;
entity.setProperty("ZGQYJHJFGS_GSBH", sReturnValue.gsbh);
entity.setProperty("ZGQYJHJFGS_JSGSMC", sReturnValue.jsgsmc);
entity.setProperty("ZGQYJHJFGS_JSGS", sReturnValue.jsgs);
entity.setProperty("ZGQYJHJFGS_JSTJMC", sReturnValue.jstjmc);
entity.setProperty("ZGQYJHJFGS_JSTJ", sReturnValue.jstj);
row.cells[0].value = sReturnValue.gsbh;
row.cells[0].innerHTML = sReturnValue.gsbh;
row.cells[1].value = sReturnValue.jsgsmc;
row.cells[1].innerHTML = sReturnValue.jsgsmc;
row.cells[2].value = sReturnValue.jsgs;
row.cells[2].innerHTML = sReturnValue.jsgs;
row.cells[3].value = sReturnValue.jstjmc;
row.cells[3].innerHTML = sReturnValue.jstjmc;
row.cells[4].value = sReturnValue.jstj;
row.cells[4].innerHTML = sReturnValue.jstj;
}
}
// page editing formula
function edit_jfgs(){
Select to pay the fees account and the formula of paying the fees accordingly before // the editor earlier, just can edit
var row = tableId_jfzh.cur_row;
if(row==null || typeof(row.cells[0])=="undefined")
{
Alert (' the account of please selecting to pay the fees ');
return;
}
if(tableId_jfgs.rows.length==1)
{
Alert (' the account do not pay the fees accordingly formula ');
return;
}
var qyjhbh = document.getElementsByName("ZGQYJH/ZGQYJH_QYJHBH")[0].value;
var zhbh = row.cells[0].value;
var row_jfgs = tableId_jfgs.cur_row;
if(row_jfgs==null || typeof(row_jfgs.cells[0])=="undefined")
{
Alert (' please select the formula of paying the fees that will edit! ');
return;
}
// call the equation editing device
var sReturnValue=updateFormula_jfgzgs('1',qyjhbh,zhbh,"ZGQYJHJFGS");
if (!sReturnValue){
return;
}else{
// exist the rreturn value situation to judge whether that for deleting formula be not that the deletion formula refreshes the row on the deletion formula deletion page
if(sReturnValue.dele==null){
var row = tableId_jfgs.cur_row;
var entity = row.entity;
entity.setProperty("ZGQYJHJFGS_GSBH", sReturnValue.gsbh);
entity.setProperty("ZGQYJHJFGS_JSGSMC", sReturnValue.jsgsmc);
entity.setProperty("ZGQYJHJFGS_JSGS", sReturnValue.jsgs);
entity.setProperty("ZGQYJHJFGS_JSTJMC", sReturnValue.jstjmc);
entity.setProperty("ZGQYJHJFGS_JSTJ", sReturnValue.jstj);
row.cells[0].value = sReturnValue.gsbh;
row.cells[0].innerHTML = sReturnValue.gsbh;
row.cells[1].value = sReturnValue.jsgsmc;
row.cells[1].innerHTML = sReturnValue.jsgsmc;
row.cells[2].value = sReturnValue.jsgs;
row.cells[2].innerHTML = sReturnValue.jsgs;
row.cells[3].value = sReturnValue.jstjmc;
row.cells[3].innerHTML = sReturnValue.jstjmc;
row.cells[4].value = sReturnValue.jstj;
row.cells[4].innerHTML = sReturnValue.jstj;
}else if(sReturnValue.dele=="delete"){
// deletion formula, the row on the deletion page
document.all.item("tableId_jfgs_deleterow").onclick();
}
}
}
The calculating information of paying the fees
The calculating of paying the fees of // rule
public static boolean chargeCalculate(Map params,BizContext param) throws DBException,ApplicationException{
// a series of variablees are set
String sql = "";
Map map = null;
String jfsqdh = "";
String ywrq = "";
String qyjhbh = "";
String zjhbh = "";
String zjhmc = "";
String bz = "";
// obtain the parameter of importing into
jfsqdh = (String)params.get("JFSQDH");
ywrq = (String)params.get("YWRQ");
qyjhbh = (String)params.get("QYJHBH");
zjhbh = (String)params.get("ZJHBH");
zjhmc = (String)params.get("ZJHMC");
bz = (String)params.get("BZ");
// the plan of the inquiring formula of paying the fees in the formula table of paying the fees according to enterprise plan numbering
sql = "SELECT ZGQYJHJFGS_ZHBH,ZGQYJHZHZD_ZHMC,ZGQYJHJFGS_JSGS,ZGQYJHJFGS_JSTJ FROM ZGQYJHJFGS,ZGQYJHZHZD,ZGQYJHJFSX WHERE ZGQYJHJFGS_QYJHBH = ZGQYJHJFSX_QYJHBH AND ZGQYJHJFSX_ZJHBH = '"+zjhbh+"' AND ZGQYJHJFGS_QYJHBH = '"+ qyjhbh +"'" +
" AND ZGQYJHJFGS_QYJHBH = ZGQYJHZHZD_QYJHBH" +
" AND ZGQYJHJFGS_ZHBH = ZGQYJHZHZD_ZHBM AND ZGQYJHZHZD_ZHLB IN('3','4') AND ZGQYJHJFSX_ZJHBH = ZGQYJHZHZD_ZJHBH";
List list = DbUtils.select(sql,param);
If // there is not formula to exist, then prompting " this enterprise plan does not define the formula of paying the fees ", and rollback
if(list==null || list.size()==0){
Throw new ApplicationException (" this enterprise plan is incorrect less than the formula of paying the fees that defines pay the fees formula or definition ");
}
String sql_str = "";
Whether the individual that // verification is paid the fees has a plurality of formula of paying the fees to satisfy condition
for(int i=0;i<list.size();i++){
map = (Map)list.get(i);
String zhbh = (String)map.get("ZGQYJHJFGS_ZHBH");
String zhmc = (String)map.get("ZGQYJHZHZD_ZHMC");
String jsgs = (String)map.get("ZGQYJHJFGS_JSGS");
String jstj = (String)map.get("ZGQYJHJFGS_JSTJ");
The design conditions that // judgement arranges
if(jstj == null || jstj.trim().length()==0){
jstj = "1=1";
}
String sqltemp = "SELECT '"+jfsqdh+"' JFSQDH, ZGGRJH_GRJHBH GRJHBH, '"+zhbh+"' ZHBH FROM VWJFGSFT " +
"WHERE ZGGRJH_JHZT IN ('1', '9') AND ZGGRZJH_ZJHZT IN ('1', '9') AND ZGGRZJH_JFZT = '1' " +
"AND ZGGRJH_QYJHBH = '"+qyjhbh+"' AND ZGGRZJH_ZJHBH = '"+zjhbh+"' AND ZGQYJHZHZD_ZHBM = '"+zhbh+"' AND ("+ jstj +")";
If (i==0) { // circulation for the first time
sql_str = sqltemp;
}else{
sql_str = sql_str + " UNION ALL "+ sqltemp;
}
}
// organize verification SQL
String sql_query = "SELECT GRJHBH, ZHBH FROM ("+sql_str+") WHERE 1 = 1 HAVING COUNT(1) > 1 GROUP BY GRJHBH, ZHBH";
System.err.println("sql_query="+sql_query);
List list_query = DbUtils.select(sql_query, param);
if(list_query.size()>0){
Exist a plurality of formula of paying the fees to satisfy design conditions in the account of paying the fees of this enterprise plan definition of throw new ApplicationException (", please carry out normal contribution calculating ") again by first maintenance calculations formula;
}
// circulate by the formula that inquires
for(int i=0;i<list.size();i++){
map = (Map)list.get(i);
// taking-up account, computing formula, design conditions
String zhbh = (String)map.get("ZGQYJHJFGS_ZHBH");
String zhmc = (String)map.get("ZGQYJHZHZD_ZHMC");
String jsgs = (String)map.get("ZGQYJHJFGS_JSGS");
String jstj = (String)map.get("ZGQYJHJFGS_JSTJ");
if(jstj == null || jstj.trim().length()==0){
jstj = "1=1";
}
// insert individual's inventory of should paying the fees
sql = "INSERT INTO ZGGRYJFQD (ZGGRYJFQD_JFSQDH, ZGGRYJFQD_QYJHBH, ZGGRYJFQD_ZJHBH,ZGGRYJFQD_ZJHMC,ZGGRYJFQD_QYBH, ZGGRYJFQD_FZJGBH, ZGGRYJFQD_FZJGMC, " +
"ZGGRYJFQD_GRJHBH, ZGGRYJFQD_XM, ZGGRYJFQD_ZJLX, ZGGRYJFQD_ZJHM, ZGGRYJFQD_GH, ZGGRYJFQD_ZHBH, ZGGRYJFQD_ZHMC, " +
"ZGGRYJFQD_JFJE, MJFJE, ZGGRYJFQD_JJFJE, ZGGRYJFQD_YWRQ,ZGGRYJFQD_NOTE) " +
"SELECT '"+jfsqdh+"', '"+qyjhbh+"', '"+zjhbh+"','"+zjhmc+"', ZGGRKH_QYBH, ZGGRKH_FZJGBH, '', " +
"ZGGRJH_GRJHBH, ZGGRKH_XM, ZGGRKH_ZJLX, ZGGRKH_ZJHM, ZGGRKH_WBBH, '"+zhbh+"', '"+zhmc+"', " +
""+jsgs+", "+jsgs+", "+jsgs+", '"+ywrq+"','"+bz+"' " +
"FROM VWJFGSFT " +
"WHERE ZGGRJH_JHZT IN ('1', '9') " +
"AND ZGGRZJH_ZJHZT IN ('1', '9') AND ZGGRZJH_JFZT = '1' " +
"AND ZGGRJH_QYJHBH = '"+qyjhbh+"' " +
"AND ZGGRZJH_ZJHBH = '"+zjhbh+"' AND ZGQYJHZHZD_ZHBM = '"+zhbh+"' " +
"AND ("+jstj+")";
DbUtils.execute(sql, param);
}
// be zero record deletion with should the pay the fees amount of money of paying the fees in the inventory of individual
sql = "DELETE FROM ZGGRYJFQD WHERE ZGGRYJFQD_JFJE=0";
DbUtils.execute(sql, param);
Whether // querying individual the inventory of should paying the fees exists the minus record of the amount of money
sql = "SELECT ZGGRYJFQD_JFSQDH FROM ZGGRYJFQD WHERE ZGGRYJFQD_JFSQDH = '"+ jfsqdh +"' AND ZGGRYJFQD_JFJE<0";
list = DbUtils.select(sql, param);
if(list!=null &&list.size()>0){
Throw new ApplicationException (" formula of paying the fees is wrong ");
}
return true;
}
Call method
Page invocation add_jfgs () method is carried out the setting of verification account, verification by after call addFormula_jfgzgs (" 1 ", qyjhbh, zhbh, " ZGQYJHJFGS ") method and call the formula page formula is set;
Page invocation edit_jfgs () method is carried out the setting of verification account, verification by after call updateFormula_jfgzgs (' 1', qyjhbh, zhbh, " ZGQYJHJFGS ") method and call the formula page and edit formula;
Call the BL_parseXML assembly and carry out the rule that the page submits to and resolve, organize list;
Call the BL_saveList assembly and preserve the list Rule Information that previous groups weaves;
Call chargeCalculate() method pay the fees the rule calculating.
Method of the present invention makes supplementary pension fund management mechanism realize supplementary pension and other pension service operation demands by presetting parameters of formula project and design conditions parameter project, deciding formula expression and design conditions, different calculated each the account rule definition of annuity of configuration and flexible formula flexibly.Method of the present invention is used at tide supplementary pension account management system, supplementary pension trustee management system and pension Integrated Service Management Platform, and has offered the annuity operating agency commencement of commercial operation of domestic many enterprises, has obtained good effect.By this invention, the annuity operating agency can arrange annuity pay the fees rule, dialing plan in the home network flexibly at the enterprise that each family participates in annuity, and flexible configuration realizes paying the fees, belonging to the professional running of annuity, service ability and service quality that domestic annuity operates mechanism have been improved greatly, strengthened the applicability of annuity application system, system development and the maintenance cost of pension management organization have been reduced, satisfy the corporate client demand of participating in pension greatly, thereby improved the enthusiasm of enterprise's participation annuity, promoted national supplementary pension health and develop fast.
Except the described technical characterictic of instructions, be the known technology of those skilled in the art.

Claims (1)

1. the supplementary pension account management system defines the method for paying the fees and belonging to formula flexibly, it is characterized in that step is as follows:
1) initial calculation parameter project
(1) create calculating parameter calculating parameter project definition table:
Name Code Data Type Primary Foreign Key Mandatory Enterprise's numbering NJXMDYB_QYBH char(8) TRUE FALSE TRUE The enterprise plan numbering NJXMDYB_QYJHBH char(10) TRUE FALSE TRUE Definition row name NJXMDYB_DYLM VARchar2(512) TRUE FALSE TRUE Project order NJXMDYB_XMSX char(2) FALSE FALSE FALSE Project name NJXMDYB_XMMC VARchar2(50) FALSE FALSE FALSE Item types NJXMDYB_XMLX char(1) FALSE FALSE FALSE Remarks NJXMDYB_NOTE VARchar2(512) FALSE FALSE FALSE Update date NJXMDYB_GXRQ DATE FALSE FALSE FALSE
(2) initial enterprise plan layer parameter: enterprise's prior year gross pay, enterprise radix, the enterprise ratio etc. of paying the fees of paying the fees;
(3) initial personal plan layer parameter: company length of service, society length of service etc.;
(4) starter system parameter commonly used: as system data, professional date, system time etc.;
2) initial calculation condition project
(1) create design conditions project definition table:
Name Code Data Type Primary Foreign Key Mandatory The formula contingency table NJSTRU_TABN VARchar2(50) TRUE FALSE TRUE The respective column name NJSTRU_COLN VARchar2(300) TRUE FALSE TRUE The row title NJSTRU_COLA VARchar2(50) FALSE FALSE FALSE DISPLAY ORDER NJSTRU_DISP VARchar2(3) TRUE FALSE TRUE The row type NJSTRU_TYPE char(1) FALSE FALSE TRUE The inquiry sign NJSTRU_CXBZ char(1) FALSE FALSE FALSE Help NJSTRU_HELP VARchar2(50) FALSE FALSE FALSE Code NJSTRU_CODE VARchar2(512) FALSE FALSE FALSE
(2) initial enterprise plan layer parameter: enterprise branch office numbers, enterprise pays the fees radix, enterprise's total number of persons etc.;
(3) initial personal plan layer parameter: date of birth, educational background, degree, position, post, the social length of service etc.;
(4) starter system parameter commonly used: as system data, professional date, system time etc.;
3) definition is paid the fees and is belonged to formula
(1) create the formula definition list:
Name Code Data Type Primary Foreign Key Mandatory The enterprise plan numbering ZGQYJHJFGS_QYJHBH char(10) TRUE FALSE TRUE Coding of accounts ZGQYJHJFGS_ZHBH char(4) TRUE FALSE TRUE Numbering of equation ZGQYJHJFGS_GSBH char(2) TRUE FALSE TRUE The computing formula title ZGQYJHJFGS_JSGSMC VARchar2(512) FALSE FALSE FALSE Computing formula ZGQYJHJFGS_JSGS VARchar2(512) FALSE FALSE FALSE The design conditions title ZGQYJHJFGS_JSTJMC VARchar2(512) FALSE FALSE FALSE Design conditions ZGQYJHJFGS_JSTJ VARchar2(512) FALSE FALSE FALSE Update date ZGQYJHJFGS_GXRQ DATE FALSE FALSE FALSE
(2) definition computing formula: by selecting to participate in parameters calculated item, arithmetical operation symbol or function, defined formula calculation expression;
(3) definition design conditions: at different each concrete formula, by alternative condition parameter project, comparison operation symbol, logical operator, define this formula applicable elements;
4) use of computing formula in all kinds of business processing processes of paying the fees
(1) Systems Operator pays the fees by rule and initiates to pay the fees calculating, or system timer calls the calculation task of paying the fees automatically according to the parameter that arranges in the rule of paying the fees;
(2) the system analysis design conditions of computing formula of paying the fees filter out qualified all workers that pay the fees;
(3) the system analysis computing formula of paying the fees, and inquire the actual numerical value that respectively participates in parameters calculated item correspondence in the formula of paying the fees from enterprise plan table, personal plan table is calculated individual's amount of money of should paying the fees;
(4) according to the step of b, c, circulation or resolve and calculate the amount of money of paying the fees of everyone each account in batches successively forms enterprise and answers premium notice list and individual detailed, and initiate follow-up audit, examine, to business processing such as accounts;
5) use of ownership computing formula in all kinds of business processing processes
When (1) initiating payment or rolling home service in enterprise, trigger ownership and calculate;
(2) system analysis is paid the design conditions that ownership is calculated formula, filters out qualified all workers that pay the fees;
(3) system analysis ownership computing formula, and from enterprise plan table, personal plan table, inquire the actual numerical value that respectively participates in parameters calculated item correspondence in the formula of paying the fees, calculating enterprise should belong to the amount of money to the individual;
(4) according to the step of b, c, the ownership amount of money of everyone each account is resolved and calculated to circulation or batch successively, and it is detailed to form ownership.
CN2013101485128A 2013-04-26 2013-04-26 Method for flexibly defining payment and ownership formulas of enterprise annuity account management system Pending CN103236014A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN2013101485128A CN103236014A (en) 2013-04-26 2013-04-26 Method for flexibly defining payment and ownership formulas of enterprise annuity account management system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN2013101485128A CN103236014A (en) 2013-04-26 2013-04-26 Method for flexibly defining payment and ownership formulas of enterprise annuity account management system

Publications (1)

Publication Number Publication Date
CN103236014A true CN103236014A (en) 2013-08-07

Family

ID=48884053

Family Applications (1)

Application Number Title Priority Date Filing Date
CN2013101485128A Pending CN103236014A (en) 2013-04-26 2013-04-26 Method for flexibly defining payment and ownership formulas of enterprise annuity account management system

Country Status (1)

Country Link
CN (1) CN103236014A (en)

Cited By (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104268238A (en) * 2014-09-28 2015-01-07 中国南方航空股份有限公司 Configurable cost distribution calculation method based on open source technology
CN105405002A (en) * 2015-09-24 2016-03-16 国网山东省电力公司 Formula data configuration method and system based on SAP platform
CN106886946A (en) * 2017-02-24 2017-06-23 泰康保险集团股份有限公司 For the method and system that declaration form surrender is calculated
CN107944999A (en) * 2017-11-09 2018-04-20 用友网络科技股份有限公司 A kind of automatic execution method and device of audit expenses project
CN108510398A (en) * 2017-07-25 2018-09-07 平安科技(深圳)有限公司 Annuity method for processing business, system, server and storage medium
CN108932612A (en) * 2018-08-17 2018-12-04 中国建设银行股份有限公司 It is a kind of applied to the data processing method of supplementary pension, device and electronic equipment
CN110309222A (en) * 2019-07-04 2019-10-08 中铁电气化局集团有限公司 Finance information management system
CN110969493A (en) * 2018-09-28 2020-04-07 北京嘀嘀无限科技发展有限公司 Bill amount determining method and device, electronic equipment and storage medium

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101477671A (en) * 2009-01-19 2009-07-08 招商银行股份有限公司 System and method for pension account management
TW201135640A (en) * 2010-04-15 2011-10-16 Univ Nat Cheng Kung Local intellectual property operation system
CN102629362A (en) * 2012-03-02 2012-08-08 浪潮集团山东通用软件有限公司 Method for realizing flexible account structure in enterprise annuity account management system

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101477671A (en) * 2009-01-19 2009-07-08 招商银行股份有限公司 System and method for pension account management
TW201135640A (en) * 2010-04-15 2011-10-16 Univ Nat Cheng Kung Local intellectual property operation system
CN102629362A (en) * 2012-03-02 2012-08-08 浪潮集团山东通用软件有限公司 Method for realizing flexible account structure in enterprise annuity account management system

Cited By (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104268238A (en) * 2014-09-28 2015-01-07 中国南方航空股份有限公司 Configurable cost distribution calculation method based on open source technology
CN105405002A (en) * 2015-09-24 2016-03-16 国网山东省电力公司 Formula data configuration method and system based on SAP platform
CN106886946A (en) * 2017-02-24 2017-06-23 泰康保险集团股份有限公司 For the method and system that declaration form surrender is calculated
CN108510398A (en) * 2017-07-25 2018-09-07 平安科技(深圳)有限公司 Annuity method for processing business, system, server and storage medium
CN107944999A (en) * 2017-11-09 2018-04-20 用友网络科技股份有限公司 A kind of automatic execution method and device of audit expenses project
CN108932612A (en) * 2018-08-17 2018-12-04 中国建设银行股份有限公司 It is a kind of applied to the data processing method of supplementary pension, device and electronic equipment
CN110969493A (en) * 2018-09-28 2020-04-07 北京嘀嘀无限科技发展有限公司 Bill amount determining method and device, electronic equipment and storage medium
CN110309222A (en) * 2019-07-04 2019-10-08 中铁电气化局集团有限公司 Finance information management system

Similar Documents

Publication Publication Date Title
CN103236014A (en) Method for flexibly defining payment and ownership formulas of enterprise annuity account management system
US6912508B1 (en) Method and apparatus for promoting taxpayer compliance
CN111815281B (en) Information system project supervision project bid management system
GB2165675A (en) Relocation management and reporting system
KR101351202B1 (en) System and method for managing enhancement features assigned to financial presentation devices
US20110131137A1 (en) Method and apparatus for performing collective validation of credential information
US20010011245A1 (en) On-line consumer credit data reporting system
US20150019303A1 (en) Data quality integration
WO2002021371A1 (en) Web based risk management system and method
US20030208362A1 (en) Integrated screening system and method for tenants and rental applicants
Liu et al. The state, the unions, and collective bargaining in China: The good, the bad, and the ugly
CN111881158A (en) Management report data processing method and device, computer system and readable storage medium
CN109840622A (en) A kind of wash sale method for early warning and system based on invoice judgement
CN102629362A (en) Method for realizing flexible account structure in enterprise annuity account management system
CN111652716B (en) First credit user tag determining method and device
CN1790414A (en) Credit data processing method and system
CN107450975A (en) A kind of task executing method and device based on layering
CN110706122A (en) Method, device and readable medium for improving social security agent efficiency based on big data analysis
CN111427936B (en) Report generation method and device, computer equipment and storage medium
US10460116B2 (en) Access control method, system and storage medium
JP2004139237A (en) Name matching method, name matching system, accounting method and accounting system
CN111639057A (en) Log message processing method and device, computer equipment and storage medium
CN111708808A (en) Distributed service system and service summarizing and inquiring method, device and equipment thereof
CN110930205A (en) Invoice data analysis method
CN117035413A (en) Risk monitoring method and device based on big data and electronic equipment

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
WD01 Invention patent application deemed withdrawn after publication

Application publication date: 20130807

WD01 Invention patent application deemed withdrawn after publication