A method for combing and constructing basic business tables

Abstract

The present invention relates to a method for combing and constructing a grass-roots business table, comprising the following steps: S1: clarifying combing objectives and scope, determining direction and framework; S2: combing core business; S3: combing the data list required for the core business; S4: sorting out the data source and data structure of the list; S5: formulating grass-roots business table data standards; S6: combing business processes; S7: docking data base data; S8: developing business forms. The present invention has the advantages of systematizing and standardizing the core business of towns and streets, ensuring the accuracy of data and the smooth burden of business processes.

Description

Technical Field

[0001] The present invention relates to the field of grassroots governance technology, and in particular to a method for combing and constructing a grassroots business table. Background Art

[0002] In grass-roots businesses, business tables are diverse and each has its own data, making it difficult to systematize and standardize. The accuracy and timeliness of data transmission are poor. Summary of the invention

[0003] In view of the above-mentioned deficiencies in the prior art, the technical problem to be solved by this patent application is how to provide a method for combing and constructing grassroots business tables that systematizes and standardizes the core businesses of towns and streets and ensures the accuracy of data and smooth business processes.

[0004] In order to solve the above technical problems, the present invention adopts the following technical solutions:

[0005] A method for combing and constructing a basic business table includes the following steps: S1: clarify combing objectives and scope, determine direction and framework; S2: comb core business; S3: comb data lists required for core business; S4: organize list data sources and data structures; S5: formulate basic business table data standards; S6: comb business processes; S7: connect to data base data; S8: develop business forms.

[0006] As an optimization, when determining the combing target in step S1, identify the core business at the street level through research and analysis, analyze and implement standardization and find the root cause of the problem; when defining the combing scope, clearly define the covered business areas, define the combing levels and departments, and evaluate the importance of the combed business.

[0007] As an optimization, in step S2, when sorting out the core business, the following steps are included: A1: Collect business information for departments that directly serve the public and departments that support the internal operations of towns and streets; A2: Analyze the above information to clarify the current status of each business; A3: Based on the results of the business status analysis, sort out the core business, clarify the starting point, key nodes, end points, and operations and persons in charge of each node, and visualize and standardize the business process through flowcharts and work instruction tools; A4: Identify the key businesses and key links of the core business; A5: Establish a regular evaluation mechanism to ensure the continuous optimization and development of the core business.

[0008] As an optimization, in step S3, when sorting out the data list required for the core business, first sort out the business needs, determine the data items, define the data meaning and type, and clarify the data purpose; after sorting out the data sources, formulate a data list and verify it.

[0009] As an optimization, in step S4, the data sources of the sorted list include internal systems, external databases and manual input; the data structure is clarified including data type, format, data table structure, data relationship, data verification rules and data dictionary.

[0010] As an optimization, in step S5, the basic business table data standards are formulated. The standards include data naming specifications, data types and formats, data length and precision, data verification rules, data encoding classification, and data security and privacy. After the standards are clarified, a data standard document is compiled and reviewed and published.

[0011] As an optimization, in step S6, combing the business process includes collecting business process information, analyzing the current status of the business process, drawing a business process diagram, writing a business process description, verifying and modifying the business process, training and promotion.

[0012] As an optimization, in step S7, the data base data is connected by connecting the sorted data list and business process with the data base; including: data mapping synchronization, interface development integration, data verification, business optimization, and testing processes.

[0013] As an optimization, in step S8, when developing the business list, the interface and interaction design are clarified in combination with actual needs and habits, while meeting security requirements.

[0014] The present invention has the following advantages:

[0015] This solution can form a business form that meets the needs of grassroots business and is easy to operate, and successfully put it into use. This will provide grassroots business personnel with more efficient and convenient working tools and promote the digital transformation and upgrading of grassroots business. BRIEF DESCRIPTION OF THE DRAWINGS

[0016] Figure 1 The present invention provides a flowchart of a method for combing and constructing a basic business table. DETAILED DESCRIPTION

[0017] The present invention is further described in detail below in conjunction with the accompanying drawings. In the description of the present invention, it should be understood that the directions or positional relationships indicated by directional words such as "upper, lower" and "top, bottom" are usually based on the directions or positional relationships shown in the accompanying drawings, and are only for the convenience of describing the present invention and simplifying the description. Unless otherwise stated, these directional words do not indicate or imply that the devices or components referred to must have a specific direction or be constructed and operated in a specific direction, and therefore cannot be understood as limiting the scope of protection of the present invention; the directional words "inside and outside" refer to the inside and outside relative to the contours of each component itself.

[0018] like Figure 1As shown, a method for combing and constructing a basic business table includes the following steps: S1: clarify combing goals and scope, determine direction and framework; S2: comb core business; S3: comb the data list required for core business; S4: organize the data source and data structure of the list; S5: formulate basic business table data standards; S6: comb business processes; S7: connect to data base data; S8: develop business forms.

[0019] In this embodiment, when determining the combing target in step S1, the core business at the street level is identified through investigation and analysis, and standardization is analyzed and the root causes of the problems are found; when defining the combing scope, the covered business areas are clearly defined, the combing levels and departments are defined, and the importance of the combed business is evaluated.

[0020] In this embodiment, when sorting out the core business, the following steps are included: A1: collecting business information from departments that directly provide services to the public and departments that support the internal operations of towns and streets; A2: analyzing the above information to clarify the current status of each business; A3: sorting out the core business based on the results of the business status analysis, clarifying the starting point, key nodes, end points, and the operations and persons in charge of each node, and visualizing and standardizing the business process through flowcharts and work instructions tools; A4: identifying the key businesses and key links of the core business; A5: establishing a regular evaluation mechanism to ensure the continuous optimization and development of the core business.

[0021] Specifically, in A1, the departments directly providing services to the public include but are not limited to civil affairs, social security, and health departments, and the departments supporting the internal operations of towns and streets include but are not limited to finance, personnel, and administration.

[0022] Specifically, in step A2, when analyzing the business status, first, clarify the specific content and goals of each business, and understand its position and role in the development of the town and street; second, analyze the rationality and efficiency of the business process, and identify bottlenecks and pain points; finally, evaluate the resources and personnel allocation involved in the business to ensure the effective use of resources and the rational allocation of personnel.

[0023] Specifically, in step A4, key businesses and key links have a significant impact on the overall operation and development of towns and streets, and require special attention and optimization; by formulating targeted management measures and improvement plans, the execution efficiency and effectiveness of key businesses and links can be improved.

[0024] In this embodiment, when sorting out the data list required for the core business, first sort out the business needs, determine the data items, define the data meaning and type, and clarify the data purpose; after sorting out the data sources, formulate the data list and verify it.

[0025] Specifically, when analyzing business needs, we need to understand what data the business needs during operation to support decision-making, monitor progress, and evaluate results; the data items should cover the entire process of business operation, including input data, intermediate processing data, and output data; the data meaning should clarify the specific content or meaning represented by the data, and the data type should be classified according to the nature of the data, including but not limited to numeric type, character type, and date type; the purpose of the data item is how the data will be used to support business operations and decision analysis; the data list includes data name, data type, data meaning, data purpose, and data source; verification is carried out through communication with business departments, testing data collection and processing processes, etc.

[0026] In this embodiment, the data sources of the sorted list include internal systems, external databases and manual input; the clear data structure includes data types, formats, data table structures, data relationships, data verification rules and data dictionaries.

[0027] Specifically, internal systems include internal databases, files and applications, and external databases include government platforms and third-party data; manual entry needs to clarify those that require manual labor, and establish entry processes and specifications.

[0028] Specifically, the data type and format: according to the nature and purpose of the data item, determine its data type including integer, floating point number, character string, date, and the format including date format and timestamp format; data table structure: including determining the table name, field name, field type, field length, primary key, and foreign key; data relationship: analyze the relationship between data items, such as one-to-one, one-to-many or many-to-many relationships, and design the corresponding data relationship model; data verification rules: formulate data verification rules to ensure the accuracy and completeness of the data, which include data range verification, format verification, and logical verification; data dictionary: create a data dictionary to record in detail the name, data type, data meaning, data source, data structure, and verification rules of each data item.

[0029] Specifically, step S4 also includes verification testing and documentation. The verification testing can test the data collection, processing and analysis process through simulated data or actual data to verify the rationality and validity of the data structure. The documentation documents the information of the data source and data structure, including flow charts, data dictionaries, and operation manuals.

[0030] In this embodiment, basic business table data standards are formulated, and the standards include data naming specifications, data types and formats, data length and precision, data verification rules, data encoding classification, and data security and privacy. After the standards are clarified, a data standard document is written and reviewed and published.

[0031] Specifically, the goals of data standards usually include improving data quality, promoting data sharing, and reducing data maintenance costs; the scope involves which business tables and which data items require standardization.

[0032] Specifically, when formulating data standards, we analyze the actual needs of grassroots businesses and data characteristics, including requirements for data usage, frequency, accuracy, and security; at the same time, we consider factors such as data accessibility, maintainability, and scalability to ensure that data standards meet current business needs and can adapt to future business development.

[0033] In this embodiment, combing the business process includes collecting business process information, analyzing the current status of the business process, drawing a business process diagram, writing a business process description, verifying and modifying the business process, training and promotion.

[0034] In this embodiment, docking the data base data is to dock the sorted data list and business process with the data base; including: data mapping synchronization, interface development integration, data verification, business optimization, and testing processes.

[0035] Specifically, the structure and characteristics of the data base include the database architecture, data table design, data access interface, and data security measures of the data base.

[0036] Specifically, when performing data mapping synchronization, the sorted data list is mapped with the data table in the data base, which involves determining the storage location, data type, and field name key information of each data item in the data base; at the same time, a data synchronization mechanism is designed to ensure that the data in the data base is synchronized with the data in the business system in real time. For data with low real-time requirements, a regular synchronization schedule can be set.

[0037] Specifically, when developing and integrating interfaces, the interfaces will be used for data transmission and interaction between the business system and the data base. The development of the interfaces should follow standard data exchange protocols and specifications to ensure data reliability and security. At the same time, the interfaces should be integrated into the business system to achieve seamless integration of business processes and the data base.

[0038] Specifically, when optimizing business, based on data docking, the goal of reducing filling can be achieved through optimized design of the business system. Default values, drop-down selection boxes, and automatic filling functions can be set in the business system to reduce manual input by users. At the same time, historical data and business rules in the data base can be used to realize automatic calculation and deduction of data, further improving business processing efficiency.

[0039] In this embodiment, when developing a business list, the interface and interaction design are clarified in combination with actual needs and habits, while meeting security requirements.

[0040] Specifically, make it clear that the form needs to include fields, operation buttons, and prompt information; design the form's interface layout to ensure that the form is concise and easy to operate, and arrange the field position, size, and color reasonably; design the linkage between fields, data verification, and error prompts; ensure that users can get timely feedback and help when filling out the form; design data encryption, access control and other security measures to ensure the security of data during transmission and storage.

[0041] The present invention has the following advantages:

[0042] This solution can form a business form that meets the needs of grassroots business and is easy to operate, and successfully put it into use. This will provide grassroots business personnel with more efficient and convenient working tools and promote the digital transformation and upgrading of grassroots business.

[0043] Finally, it should be noted that those skilled in the art may make various changes and modifications to the present invention without departing from the spirit and scope of the present invention. Thus, if these modifications and variations of the present invention fall within the scope of the claims and their equivalents, the present invention is also intended to include these modifications and variations.

Claims

1. A method for combing and constructing a basic business table, characterized in that: The following steps are involved: S1: Clarify the objectives and scope, and determine the direction and framework; S2: sort out core business; S3: Sort out the data list required for core business; S4: Organize the data sources and data structure of the inventory; S5: Formulate data standards for basic business tables; S6: Organize business processes; S7: docking data base data; S8: Develop business forms.

2. A method for combing and constructing a basic business table according to claim 1, characterized in that: When determining the combing objectives in step S1, the core businesses at the street level are identified through research and analysis, and standardization is analyzed and the root causes of problems are found; when defining the combing scope, the covered business areas are clearly defined, the levels and departments of the combing are defined, and the importance of the combed businesses is evaluated.

3. A method for combing and constructing a basic business table according to claim 2, characterized in that: In step S2, when sorting out the core business, The following steps are involved: A1: Collect business information from departments that directly provide services to the public and departments that support the internal operations of towns and streets; A2: Analyze the above information and clarify the status of each business; A3: Based on the results of the business status analysis, the core business is sorted out to clarify the starting point, key nodes, end point, and the operations and persons in charge of each node. The business process is visualized and standardized through flowcharts and work instructions tools; A4: Identify the key businesses and key links of the core business; A5: Establish a regular evaluation mechanism to ensure the continuous optimization and development of core businesses.

4. A method for combing and constructing a basic business table according to claim 3, characterized in that: In step S3, when sorting out the data list required for the core business, first sort out the business needs, determine the data items, define the data meaning and type, and clarify the data purpose; after sorting out the data sources, formulate a data list and verify it.

5. A method for combing and constructing a basic business table according to claim 4, characterized in that: In step S4, the data sources of the inventory are sorted out, including internal systems, external databases and manual input; the data structure is clarified, including data types, formats, data table structures, data relationships, data verification rules and data dictionaries.

6. A method for combing and constructing a basic business table according to claim 5, characterized in that: In step S5, the basic business table data standards are formulated. The standards include data naming specifications, data types and formats, data length and precision, data verification rules, data coding classification, and data security and privacy. After the standards are clarified, a data standard document is compiled and reviewed and published.

7. A method for combing and constructing a basic business table according to claim 6, characterized in that: In step S6, combing the business process includes collecting business process information, analyzing the current status of the business process, drawing a business process diagram, writing a business process description, verifying and modifying the business process, training and promotion.

8. A method for combing and constructing a basic business table according to claim 7, characterized in that: In step S7, docking the data base data is to dock the sorted data list and business process with the data base; including: data mapping synchronization, interface development integration, data verification, business optimization, and testing processes.

9. A method for combing and constructing a basic business table according to claim 8, characterized in that: In step S8, when developing the business list, the interface and interaction design are clarified in combination with actual needs and habits, while meeting security requirements.

Images