Construction Plan for Basic Information Database Management Systemcatalogue1. Basic Information Da

Construction Plan for Basic Information Database Management System
catalogue
1. Basic Information Database Management 4
1.1 Function Description 4
1.2 Basic Data Collection and Management 4
1.2.1 Function Description 4
1.2.2 Business Process 5
1.2.3 Basic Data Collected 6
1.2.4 Functional Requirements and Preliminary Design 8
1.3 Project Library Management 15
1.3.1 Function Description 15
1.3.2 Business Process 16
1.3.3 Functional Requirements and Preliminary Design 18
1.4 Policy and regulatory management 20
1.4.1 Function Description 20
1.4.2 Functional Requirements and Preliminary Design 20
1. Basic Information Database Management
1.1 Function Description
Basic information database management is mainly used to manage the basic information of budget units, including personnel information, asset information, financial information, project information, as well as macroeconomic data, financial system data, and other information.
The basic information database management module is used to manage policy regulations related to various fiscal budget decisions and the basic information of budget units. It can define various basic information that needs to be managed, including: fiscal system, tax policies, non tax revenue policies, expenditure policies, development plans, staffing situation, quota situation, and asset situation of administrative institutions; The finance department can maintain relevant policies and regulations, and budget units can report their own information to the finance department in real time. Through integration, data can be shared with relevant information modules through support platforms. The financial department can manage, analyze, and summarize the basic information of the unit, providing a basis for relevant decision-making.
The basic information database is mainly used for budget preparation, and in the future, it can also be applied to comprehensive query and analysis, financial support personnel, unified salary distribution, and other business and comprehensive analysis and processing processes. As shown in the figure:
Figure 4.1 1: Basic Information Management Structure Diagram
1.2 Basic data collection and management
1.2.1 Function Description
Basic information management is an information aggregation platform for financial budget business management, which realizes that basic financial information is prepared by budget units at all levels, and is reported, reviewed, summarized, queried, analyzed, and reported step by step. Comprehensively meet the business needs of various budget management personnel in different stages of finance, support personnel information, fixed asset information, county and township information, debt management and other information management.
1.2.2 Business Process
1) Define the basic information collection table template by the Basic Information Management Department and distribute it to various business departments.
2) The business department will distribute the template to the budget unit.
3) Budget units fill in basic unit information according to the template requirements and report it to the business department
4) After the modification and review by the business department, the data will be summarized and the final basic information will be imported into the department budget.
Figure 4.12: Basic Data Collection Business Process
1.2.3 Basic data collected
The specific content of basic information includes:
Financial support personnel information: achieve personnel classification management and daily personnel management. Personnel classification management includes basic information such as employees, retirees, communities, preferential treatment, and social assistance and rescue personnel in various budget units, and forms personnel budget based on various policies. Daily personnel management includes the approval of personnel additions, departures, and reductions, as well as external links with personnel departments, organizational departments, senior cadre management departments, and retirement management departments. Personnel information management and budget review, budget indicator linkage, achieving information sharing and exchange.
Asset information: Asset procurement and disposal. Asset classification management includes public information related to vehicle conditions, house area, office equipment, etc., and generates a public budget based on standard quotas. It can achieve functions such as report preparation and summary query. Daily asset management includes functions such as asset acquisition, disposal, and evaluation.
Project information: Multiple sources generate special projects, such as special projects submitted by budget units for departmental budget preparation, additional projects added during budget execution, and special projects generated by office automation.
Financial foundation, tax data and other standard management information: mainly refers to the database of financial policies and quotas, including various financial laws, regulations and policy regulations, as well as personnel policies and public standard quotas.
An example of the collected data range is shown in the figure:
Figure 4.13: Example of data range for basic collection
1.2.4 Functional requirements and preliminary design
1.2.4.1 System settings
System setup is the first step in using basic information management, which is mainly used to define basic information, data processing business, system permissions, data review, maintain data versions, and interface with department budgets, etc. Whether the system settings are correct will directly affect the use of basic information management. The system settings include the following functions:
(1) System Report Settings: Define the structure, content, special business processing settings, and formula refresh method of the basic information report that needs to be filled out by the unit. The functional points are as follows:
Basic information definition:
a) Add report: Define a new basic information report;
b) Delete Report: Delete a defined report;
c) Modify report: Modify defined report information;
d) Enter report description information: Define the description information of the report;
e) Report data column maintenance: Maintain the column information of the basic information report;
f) Reference settings: Maintain references to fixed row and column reports, and fixed column reports that can be inserted into row reports;
g) Single page entry definition: defines the pop-up entry interface for basic situation reports, fixed row and column reports, and fixed column reports that can be inserted into rows.
Import template settings:
a) Create new import settings;
b) Delete import settings;
c) Renaming import settings;
Definition of data processing business:
a) Add definition of data processing business;
b) Delete data processing business definitions;
Batch data processing
a) Batch processing of new data;
b) Batch processing of calculation data;
c) Batch processing of deleted data;
d) Delete all batches;
Delete report data
Specific formula refresh
a) Function settings;
b) Marking;
c) Refresh;
d) Mark refresh;
Formula recalculation settings
Refresh all formulas
(2) Report template settings: Define the format and content of fixed row and column type reports and fixed column insertable row types. The functional points are as follows:
Fixed column reference maintenance:
a) Add fixed column references;
b) Insert fixed column references;
c) Delete fixed column references;
d) Fixed column reference maintenance;
e) Data inspection;
f) Data import;
Report template data generation:
a) Execute SQL statements;
b) Synchronize all data;
Definition of report template
a) Insert records;
b) Data synchronization;
c) Add new records;
d) Delete records;
e) Data import;
f) Data export;
g) Select area data to copy/paste;
h) Can region selection be performed;
i) Display as a zero digit;
j) Input direction setting;
k) Definition of formulas in the table;
l) Automatic summary
(3) Data Review Settings: Define the manual view registration and inter table and intra table cross checking relationships for the basic information data entry tables that need to be reviewed during the review of special requirements. The functional points are as follows:
Review view registration;
Definition of data review:
a) Increase review;
b) Delete review;
c) Export audit records;
d) Import audit definitions;
e) Copy/paste the audit definition;
f) Review corresponding units;
g) Review definition check;
(4) Data version maintenance: Complete the creation, deletion, and recovery of data versions.
(5) Hierarchical code calculation: Batch refresh the codes of fixed row and column reports and fixed column reports that can be inserted into rows.
1.2.4.2 Basic information processing
(1) Basic information entry: Basic information entry completes the entry, modification, and review of basic data.
Basic numerical report: A basic numerical report is a table that expands the header of a report by row, meaning that the table has only one primary key. The direction of report entry is vertical. Basic digital reports mainly complete the entry of basic information such as unit personnel establishment and fixed assets.
Basic situation report: A basic situation report is a table whose header is expanded by columns, meaning that the table has two or more fields as the primary key. The input direction of the report is horizontal. The combination of all primary key fields in basic situation reports is not allowed to be duplicate. The basic situation report mainly completes the entry of detailed information such as unit personnel salaries and motor vehicles.
a) Add new records;
b) Insert records;
c) Delete records;
d) Data import;
e) Data export;
f) Can region selection be performed;
g) Select area data to copy/paste;
h) Copy data in the same column;
i) Display as a zero digit;
j) Input direction setting;
k) Automatic summary;
l) User defined business;
m) Organize serial numbers;
n) Unit adjustment;
o) Index maintenance;
p) Review;
q) Field queries and sorting;
r) Reset row data;
Fixed row and column reports: Fixed row and column reports refer to reports whose row and column numbers cannot be modified in the input table. The format of this report is defined in the "Report Template Settings" submenu under the "System Management" menu.
a) Group calculation;
b) Data export;
c) Group summary;
d) Display as a zero digit;
e) Input direction setting;
f) Automatic summary;
g) Review;
Fixed column insertable row type report: Fixed column insertable row type report refers to the number of rows that can be added or deleted in this report; The number of columns cannot be modified in the input table. The format of this report is defined by the "Report Template Definition" submenu and "Report Basic Definition" under the "System Management" menu and "System Report Settings".
a) Insert final level;
b) Group calculation;
c) Add non final level;
d) Data export;
e) Group summary;
f) Can region selection be performed;
g) Display as a zero digit;
h) Automatic summary;
i) Index maintenance;
j) Review;
(2) Text file import: Text file import is the process of importing basic situation reports in the compressed format of this article's file. When importing text files, multiple units of a table can be imported at once. Only when the import template settings have set the permission to import reports as text files, can they be imported, and the name and format of the imported file must be consistent with the customized template.
Import text file: The imported file must be in the zip compressed format of the text file, and the naming convention of the imported data file package must be correct. The txt file must start with data. The import file names corresponding to different reports must be different.
Text import file description: When the report is allowed to be imported, the program has provided explanations for it. Before performing the import operation, be sure to read the import instructions in detail. The explanations for different reports are different.
(3) Excel file import: Excel data import is the process of importing fixed row and column reports and fixed column insertable row reports into an Excel file. When importing Excel data, multiple tables of multiple units can be imported at once. Only when the financial version has been set to allow importing Excel data can it be imported, and the first few digits of the imported file name must be the unit code. The sheet name and format in the file must be consistent with the customized template.
Import Excel data file: The imported file must be in Excel format and the Excel program cannot be opened during import. The sheet page name, data start column, data start row, and data end row in the file must be the same as those customized for the import template. The program automatically creates two folders, successful and failed, in the directory where the imported files are located. All successfully imported files are placed in the successful directory, while those that were not successfully imported are placed in the failed directory.
Excel file import instructions: When the basic data of a department cannot be reported in a timely manner or when the finance department needs to add basic data to the budget unit, this menu can be used to add basic data, while also completing the modification and review of the unit's basic data.
(4) Information comprehensive processing: Basic information is used to comprehensively process the basic data of budget units. Custom queries, data exports, version comparisons, data analysis, data auditing, and other operations can be performed on existing basic data.
Basic information data:
a) Display column settings;
b) Data export;
c) Custom query;
d) Compare current data with version data;
e) Display of version differences;
f) Display of data changes;
g) Single table duplicate data viewing;
h) View duplicate data in multiple tables;
Version data: used to view data from previous versions.
Data analysis: used to analyze and compare data from different versions and periods.
a) Compare column settings;
b) Data export;
c) Query definition;
d) Display of version differences;
e) Display of data changes;
f) Single table duplicate data viewing;
g) View duplicate data in multiple tables;
Data review: The review of the basic information table after the data review is completed and submitted for review.
1.2.4.3 Query Analysis
Query analysis is the process of querying and analyzing basic information data based on the format and content defined by the query report subsystem.
(1) Operating procedures: There are no sequential constraints for query analysis, but report data can only be obtained by performing pre query analysis after the basic data is compiled.
(2) Data Query: The program provides a customized budget data query function in the query report subsystem.
(3) Data analysis: The program not only provides customized query functions in the query report subsystem to retrieve data, but also allows for flexible data analysis in conjunction with Excel's pivot report function.
Create a pivot chart report;
Use pivot chart reports;
(4) General query: A general query is a simple query of data.
1.2.4.4 Statistical reports
Calculate and print various output reports according to the report format and content defined by the query report subsystem, including issuing unit reports, departmental budget reports, financial reports, and reports to the People's Congress.
(1) Report view registration: Report view registration is the registration of data objects, registering the views of each report for reference in the report subsystem.
(2) Daily statistical reports: Count and print various output reports according to the report format and content defined by the query report subsystem.
1.2.4.5 Data transmission
Data transmission is used to achieve the transmission of basic data between budget units and financial departments. The business process of basic information management is basically consistent with the department budget, and data exchange is also achieved through data transmission.
Data transmission includes the following content:
(1) Issuing unit data;
(2) Distribute EXCEL templates;
(3) Receiving unit data;
(4) Data transfer log browsing.
1.2.4.6 Basic Information Entry into Basic Information Database Service
The system supports accessing salary data from the HR department and asset information from the asset module. For detailed design, please refer to the basic information service of the distribution platform.
1.2.4.7 Extracting Basic Information Services from the Basic Information Database
The system provides services for modules such as direct salary payment and budget preparation. For detailed design, please refer to Extracting Basic Library Information Services from the Platform.
one