Personnel Insurance Account (PIA) System is being developed for the needs and by request of the State Social Protection Fund of the Republic of Azerbaijan in connection with transition of the social insurance system to accumulative principles. In the framework of this system the following issues should be addressed:
- - registration of the working part of the population;
- - registration of the persons engaged on entrepreneurship ;
- - account and control over the seniority, privilege, extra charges, payments according to the normative legislation;
- - pension calculations according to the "working" history of each insurant;
- - providing by the request necessary information for each insurant.
Objectives define requirements to the database: database should hold identification data about all registered persons as well as information on monthly extra charges for each insurant through his entire working activity database capacity is enormous. Therefore, in the system it is envisaged creation of aggregated tables, database showcases as well as back-up archives. It has been developed the technology of database generation at each level. Database operates under Oracle 9 Enterprise Edition DBMS
Establishment of a PIA system will cause extensive document processing represented in both paper and electronic. For the efficient data processing three levels were created in the system: rayon, region and centre. Databases are created atthe regional and central levels. From the XML-files processed on compliance to control rules and data consistency atthe regional level, it's been generated regional database holding information about only several districts.
"Correct" XML-files are transmitted to the central level where after examination through the entire central database it's been generated central database holdingfull information through the republic. XML-files with mistakes are been formed into log-files with mistakes descriptions to be transmitted to the XML-files source. XML-files sources are the regional scanning centers (paper forms are been scanned, identified, verified and exported into XML-files). XML-files could be also created directly in the districts and by employers by the means of special software. They are transmitted at the regional level by FTP. In the districts departments' database would be created from XML-files in the source of which is given district; and the information of which was written into the central database (XML-files would be transmitted to the districts by any possible for this district means: by FTP (on -line or dial-up) or directly by e-information carrier). Information synchronization at each level would be made by distribution of information synchronizing packages according to the rules defined by the pension fund. Databases operate under Oracle 9 Enterprise Edition DBMS which let to successfully realize all objectives.
back 
