CN102629362A - Method for realizing flexible account structure in enterprise annuity account management system - Google Patents

Abstract

The invention provides a method for realizing a flexible account structure in an enterprise annuity account management system. In the method, through flexible definition and configuration of the account structure, annuity service processing is performed according to the flexible account so that an enterprise annuity fund management institution realizes service operation demands of the enterprise annuity and other pensions with different account structures. Through using the method of the invention, an annuity operation mechanism can flexibly set an annuity plan account structure for the each enterprise that joins in the annuity, can realize the annuity service operation, such as fee-paying, payment, transferring, investment and the like, according to the flexible configuration and simultaneously can issue a report form of the corresponding account structure to internal management, the external annuity operation mechanism, a supervision mechanism and an enterprise client, which substantially improve a service capability and service quality of a domestic annuity operation mechanism, increase an applicability of an annuity application system and reduce exploitation and maintenance costs of the system. Through satisfying an enterprise demand in a great degree, enthusiasm of the enterprise to join in the annuity can be increased, and development and popularization of the national enterprise annuity can be promoted.

Description

Realize the method for flexible account structure in a kind of supplementary pension account management system

Technical field

The present invention relates to a kind of flexible account structure manner of execution of supplementary pension industry account management infosystem; The present invention is used for pension integrated service information management system flexible account structure manner of execution equally.

Background technology

Supplementary pension is meant enterprise and worker thereof on the basis of in accordance with the law participating in basic pension insurance, the additional old-age insurance system of setting up voluntarily.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 MIS 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 corporate client of professional, the different participation annuity of dissimilar annuities requires different to the purposes of structure of accounts and each account; The fixedly structure of accounts of major part annuity account system; Can't satisfy the demand of the various structure of accounts of enterprise, lower 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 the method that needs a kind of flexible account structure satisfies the needs of participating in annuity enterprise, service quality and the timeliness that improves annuity management organization, reduces the cost of management organization aspect information-based.

Summary of the invention

The purpose of this invention is to provide the method that realizes the flexible account structure in a kind of supplementary pension account management system.

The objective of the invention is to realize by following mode; The object of the invention is to provide the flexible definition of a kind of supplementary pension account management system and structure of accounts, the manner of execution of using flexibly; With solve existing enterprise's annuity fixedly structure of accounts, can't self-defining technical matters, the step of this method comprises:

1, definition flexible account structure

A) system's global parameter is set the account classification

B) the account dictionary of each plan of definition on the enterprise plan layer

C) each controlled account attribute of definition on the account dictionary basis of each enterprise plan

D) on the account dictionary basis of each enterprise plan definition pay the fees, investment, dialing plan in the home network;

2, use self-defining account to realize all kinds of business processing

A) realize paying the fees calculating, the account business processing of paying the fees according to the account dictionary of enterprise plan, the rule of paying the fees, and write down the detailed Transaction Information of corresponding account, balance amount information;

B) account dictionary, the investment rule according to enterprise plan realizes applying to purchase the redemption business processing, and record transaction details information and corresponding account balance amount information;

C) realize the home service processing according to account dictionary, the dialing plan in the home network of enterprise plan, and the ownership record and the corresponding account balance amount information of record controlled account.

The invention has the beneficial effects as follows:

Supplementary pension management organization realizes professional, the different demand of participating in the corporate client of annuity to structure of accounts and each account of annuities dissimilar in the annuity operation process through this method, improves the 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.

Embodiment

With reference to Figure of description to explanation at length below the work of the present invention.

Embodiment:

1, flexible account organization definition:

Account is set up the interface definition:

The account coding

Account Type

Name on account

Whether invest

Investment Choice power

The ownership account

The excellent account of tax whether

Remarks

2001

Enterprise's common account

Temporary account

Not

Enterprise

?

Be

?

?

?

?

?

?

?

?

?

?

?

?

?

?

?

?

?

[increase] [deletion]

Explain:

The regular interface definition of paying the fees:

Explain:

2, main program assembly

Rule definition

BL_parseXML analyzing XML assembly

BL_saveList preserves the list assembly

Formula definition

// call the formula display page

addFormula_jfgzgs("14",qyjhbh,zhbh,"ZGQYJHJFGS1","QYJHJFCS");

// rule is set

function?addFormula_jfgzgs(gslx,gzbh,zhbh,gsTable,fromTable,yybm){

// obtain rule numbers

var?gzbh?=?gzbh;

// obtain coding of accounts

var?zhbh?=?zhbh;

// obtain numbering of equation

var?gsbh?=?"";

if(zhbh==""){

Alert (" please select a coding of accounts ");

return;

}

var?tempObj=new?Object();

TempObj.gslx=gslx; // formula type

TempObj.gzbh=gzbh; // regular account (enterprise plan numbering)

TempObj.zhbh=zhbh; // coding of accounts

TempObj.gsbh=gsbh; // numbering of equation is empty

if(yybm){

TempObj.yybm=yybm; // reason numbering

}

var?runtable="ZGGRJH";

if(fromTable){

runtable=?fromTable;

}else{

runtable?=?"ZGQYJH";

}

var?gsTable=gsTable;

Var gstitle=" rule is paid the fees ";

var?url="";

var?sReturnValue?=?window.showModalDialog(url,tempObj,"dialogHeight:300px;dialogWidth:600px;status:no;help:no;scroll:no;");

Temp_lockPage (); // pinning the page

if(sReturnValue!=null){

Temp_unlockPage (); The release of // the page

}else{

Temp_unlockPage (); The release of // the page

}

return?sReturnValue;

}

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 (" it is incorrect that this enterprise plan does not define the formula of paying the fees of paying the fees formula or defining ");

}

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 is provided with

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;

}

3, call method

Page invocation addFormula_jfgzgs method is provided with rule and formula, turns back to the page

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

Except that the described technical characterictic of instructions, be the known technology of those skilled in the art.

Claims (1)

1. realize the method for flexible account structure in the supplementary pension account management system; It is characterized in that through setting up account at the enterprise plan layer flexibly, setting attribute and rule; And when the annuity miscellaneous service is handled, resolve access to your account structure and respective rule, concrete steps comprise:

Preset the account classification parameter in the software: common account, look forward to numbering, the title of classification in sub-account, the individual sub-account three;

Set controlled account in the supplementary pension plan layer, comprise account coding, name on account, account classification, whether invest, Investment Choice power comprises enterprise or individual, ownership character, belong to assets purpose account, do not belong to assets purpose account, tax dominator or account attributes;

Enterprise plan is safeguarded the rule of paying the fees setting on the structure of accounts basis, comprise the formula of paying the fees, the formula design conditions of each controlled account;

Maintenance investment rule on the structure of accounts basis is being set in enterprise plan, comprised the investment portfolio that to invest and the ratio between investments of each controlled account;

Enterprise plan is safeguarded dialing plan in the home network setting on the structure of accounts basis, comprise ownership formula and formula design conditions that each each type of controlled account ownership reason is corresponding;

When fee payment service is handled, set the structure of accounts and the rule of paying the fees according to each enterprise plan, accomplish the business processing of the regular account of paying the fees, directly pay the fees, pay the fees, and generate the premium notice list of corresponding account structure, the gathering instruction of paying the fees;

When investment portfolio is handled, set structure of accounts and investment rule according to each enterprise plan, system accomplishes each account automatically and applies to purchase the redemption business processing accordingly;

When home service is handled, set structure of accounts and dialing plan in the home network according to each enterprise plan, system accomplishes the corresponding home service of each account automatically and handles.