Design And Implementation Of Whole Process Supervision System For Tax Collection And Administration Based On ETL

The topic of this paper is from the local taxation bureau of changchun city tax collection whole process supervision system.Local taxation bureau of changchun city established in September 1994, the existing staff of 2507, responsible for changchun area 227398 households based on local tax collection and administration work, jurisdiction 6 city bureau, development of five rc, five implementation(what), four counties(city) bureau, office, personnel, financial management, supervision, education training place inside try and punish census and statistics department, plan, policy, law office, administrative office, tax administration, tax administration, tax administration, tax services, inspection office property and behavior, such as the committee of 14 functional departments and three business units(community).With the implementation of the reform of the national tax levy management, according to the national tax collection and management regulations, "the national tax authorities at the county level tax service specification" requirements, the local taxation bureau of changchun city formulated the corresponding new tax collection and administration work process. How to promote the process run efficiently, how the regulatory process implementation, we need to by a carrier to realize this. According to the local taxation bureau of changchun city overall arrangement, in the process of writing at the same time, the collection and administration office is responsible for the organization as a whole, provides the business requirements and information center of software company has developed the whole process supervision system, on October 27, 2014, staging, in the city.Accept and transferred to the regulatory system: the function of business operation is completed in the jilin province local taxation collection and administration system, supervision system according to the workflow setting, to the follow-up management and completed in matters of fetching the data in the collection and management system, and push the work task, complete the document flow, and each link the dynamic regulation of task to run.The characteristics of the regulatory system: by collecting image data, forming an electronic database; According to the process Settings nodes automatically push work tasks; Through the complaint form, electronic signature implementation document circulation; Through early warning prompt Zun Qi urged conduction personnel to complete the task.In terms of the local taxation bureau of changchun city, and connecting with the paper expounds the oracle database, ETL, data warehouse and the Inno DB related transaction data processing technology. After changes the system theoretical significance and practical value, of the daily work of taxation related modules has carried on the concrete implementation. And a simple introduction on the basis of ETL data warehouse and the Inno DB related affairs the advantage of the data processing technology.In this paper, based on research by the ETL process supervision system, make the tax regulation not only unified supervision work, reduce the tax arrears, improve the working efficiency.