Environmental, social and corporate governance rating calculation method, device, electronic device and storage medium
The method of automatically generating ESG ratings through the files uploaded by employees solves the problems of low efficiency and high cost of the existing ESG evaluation system, and realizes efficient and accurate calculation of enterprise ESG ratings.
Patent Information
- Application Number
- CN202411075032.8
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2024-08-07
- Publication Date
- 2025-04-15
- Estimated Expiration
- 2044-08-07
AI Technical Summary
The existing ESG evaluation system relies on the experience of industry experts and analysts, is inefficient and costly to small and micro enterprises.
Provides an environmental, social and corporate governance rating calculation method, and automatically generates ESG ratings through files uploaded by corporate employees. The method includes obtaining and identifying file types, recording the minimum metrics of template files, identifying the minimum metrics of non-template files, and calculating the first-level metric score based on these metrics, and finally calculating the enterprise's ESG rating based on the score and preset weights.
No need to rely on industry experts and analysts, improving the efficiency and accuracy of ESG ratings and reducing costs for small and micro enterprises.
Smart Images

Figure CN118735359B_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the field of Internet technology, and in particular to a method, device, electronic device and storage medium for calculating environmental, social and corporate governance ratings. Background Art
[0002] ESG (Environment, Social Responsibility, Corporate Governance) refers to the three core factors for measuring the sustainability and ethical impact of a company or corporate investment. The ESG evaluation system currently used in the market relies on the experience of industry experts and analysts, which is not only inefficient but also costly for small and micro enterprises. Summary of the invention
[0003] In response to the shortcomings of the prior art, the present application provides an environmental, social and corporate governance rating calculation method, device, electronic device and storage medium, which are conducive to automatically generating the corresponding ESG rating of the enterprise based on the files uploaded by the enterprise.
[0004] To solve the above problems, the present invention provides the following technical solutions:
[0005] In a first aspect, an embodiment of the present application provides a method for calculating an environmental, social and corporate governance rating, the method comprising:
[0006] Get the files uploaded by each employee of the enterprise;
[0007] Identifying whether each of the files is a template file or a non-template file;
[0008] Recording the minimum index corresponding to each of the template files to determine the primary index corresponding to each of the template files;
[0009] Identify the minimum index corresponding to each of the non-template files to determine the primary index corresponding to each of the non-template files;
[0010] Calculating the score of each first-level indicator according to the template file and the non-template file included in each first-level indicator; wherein the first-level indicators include social indicators, environmental indicators and corporate governance indicators;
[0011] The ESG rating of the enterprise is calculated based on the score of each first-level indicator and the preset weight.
[0012] In some embodiments, the method further comprises:
[0013] Get the industry type of the enterprise;
[0014] The minimum indicator included in each of the first-level indicators when calculating the ESG rating of the enterprise is determined according to the industry type, as well as the preset weight corresponding to each of the first-level indicators.
[0015] In some implementations, identifying the minimum index corresponding to each of the non-template files includes:
[0016] Determining whether the non-template file is a video file;
[0017] If the non-template file is not a video file, performing semantic analysis on the non-template file, and determining a minimum index corresponding to each non-template file according to a result of the semantic analysis;
[0018] If the non-template file is a video file, the video file is input into the indicator recognition model, and the minimum indicator corresponding to each non-template file is determined by the indicator recognition model.
[0019] In some implementations, if the non-template file is not a video file, performing semantic analysis on the non-template file to determine the minimum index corresponding to each non-template file includes:
[0020] Performing semantic analysis on the non-template file, outputting the semantics of the non-template file, and calculating semantic similarity between the semantics and the corresponding semantics of each of the minimum indicators; wherein the corresponding semantics of each of the minimum indicators is the sum of the semantics of the superior indicator to which the minimum indicator is subordinate and its own semantics;
[0021] The minimum index with the largest semantic similarity is determined as the minimum index corresponding to the non-template file.
[0022] In some implementations, determining the minimum index corresponding to each of the non-template files by using the index recognition model includes:
[0023] Identify whether each video of the non-template file includes an employee by using the indicator recognition model;
[0024] If employees are included, identifying the behavior of the employees or the activities being performed by all employees in the video, and determining the minimum indicator corresponding to each of the non-template files according to the behavior of the employees or the activities being performed by all employees;
[0025] If the employee is not included, the information and scenes included in the video are identified, and the minimum index corresponding to each of the non-template files is determined based on the information and scenes.
[0026] In some embodiments, the method further comprises:
[0027] When one of the minimum indicators corresponds to multiple files, determining the indicator type of the minimum indicator; wherein the indicator type includes data type, display type and selection type;
[0028] If the indicator type of the minimum indicator is a data type, determine the department corresponding to the minimum indicator, query each file through the blockchain whether it has been signed by the department and the board of directors, eliminate the files that have not been signed by the department and / or the board of directors, and aggregate the data of the remaining files to generate a new template file corresponding to the minimum indicator, so as to calculate the score of the first-level indicator corresponding to the minimum indicator according to the new template file; wherein the minimum indicator of each data type has a corresponding template;
[0029] If the indicator type of the minimum indicator is a selective type, identify the selective results of all files, and when the selective results of all files are consistent, calculate the score of the primary indicator corresponding to the minimum indicator according to the selective result.
[0030] In some embodiments, the method further comprises:
[0031] Generate an environmental, social and corporate governance report based on the template file and the non-template file included in each first-level indicator.
[0032] In a second aspect, an embodiment of the present application provides an environmental, social and corporate governance rating calculation device, the device comprising:
[0033] An acquisition unit, used to acquire files uploaded by each employee of the enterprise;
[0034] A recording unit, used to identify whether each of the files is a template file or a non-template file, and record the minimum index corresponding to each template file to determine the primary index corresponding to each template file;
[0035] An identification unit, used to identify the minimum index corresponding to each of the non-template files, so as to determine the primary index corresponding to each of the non-template files;
[0036] A first calculation unit, used to calculate the score of each first-level indicator according to the template file and the non-template file of each first-level indicator respectively; wherein the first-level indicators include social indicators, environmental indicators and social indicators;
[0037] The second calculation unit is used to calculate the ESG rating of the enterprise according to the score of each of the first-level indicators and the preset weight.
[0038] In a third aspect, an embodiment of the present application provides an electronic device, including:
[0039] at least one processor; and,
[0040] a memory communicatively connected to at least one processor; wherein,
[0041] The memory stores instructions executable by at least one processor, and the instructions are executed by at least one processor to enable the at least one processor to perform the environmental, social and corporate governance rating calculation method of the first aspect.
[0042] In a fourth aspect, an embodiment of the present application provides a computer-readable storage medium, which stores an executable program, and the executable program is executed by a processor to implement the environmental, social and corporate governance rating calculation method as in the first aspect.
[0043] The present application provides a method, device, electronic device and storage medium for calculating environmental, social and corporate governance ratings, the method comprising: obtaining files uploaded by each employee of the enterprise; identifying whether each of the files is a template file or a non-template file; recording the minimum index corresponding to each of the template files to determine the primary index corresponding to each of the template files; identifying the minimum index corresponding to each of the non-template files to determine the primary index corresponding to each of the non-template files; calculating the score of each primary index according to the template files and the non-template files included in each primary index; wherein the primary index includes social indicators, environmental indicators and corporate governance indicators; calculating the ESG rating of the enterprise according to the score of each of the primary indicators and the preset weight. In the present application, the ESG rating of the enterprise can be automatically generated through the files uploaded by the enterprise without relying on industry experts and analysts. BRIEF DESCRIPTION OF THE DRAWINGS
[0044] Figure 1 It is a flow chart of an environmental, social and corporate governance rating calculation method provided in an embodiment of the present application.
[0045] Figure 2 yes Figure 1 A detailed flowchart of step 140 in FIG.
[0046] Figure 3 It is a structural schematic diagram of an electronic device provided in an embodiment of the present application.
[0047] Figure 4 It is a structural block diagram of a computer-readable storage medium provided in an embodiment of the present application. DETAILED DESCRIPTION
[0048] The following will be combined with the drawings in the embodiments of the present application to clearly and completely describe the technical solutions in the embodiments of the present application. Obviously, the described embodiments are only part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of this application.
[0049] In addition, the terms "first" and "second" are used for descriptive purposes only and should not be understood as indicating or implying relative importance or implicitly indicating the number of the indicated technical features. Therefore, the features defined as "first" and "second" may explicitly or implicitly include one or more of the features. In the description of the present invention, the meaning of "plurality" is two or more, unless otherwise clearly and specifically defined.
[0050] See also Figure 1 , Figure 1 Schematic diagram of a method for calculating environmental, social and corporate governance ratings provided in the embodiment of the present application. Figure 1 As shown, the environmental, social and corporate governance rating calculation method 100 includes: steps 110 to 160.
[0051] Step 110: Obtain the files uploaded by each employee of the enterprise.
[0052] In some implementations, file upload permissions are opened to each employee in the enterprise, allowing employees to upload files. For example, each employee has an employee account, and can upload files by logging into the employee account. The account needs to be authenticated by real name and associated with the employee's department, supervisor, rank, etc. After uploading the file, the file uploader can be traced based on the file.
[0053] In some implementations, in order to avoid obtaining files with poor timeliness, step 110 includes: obtaining files uploaded by each employee of the enterprise in the current year.
[0054] In some implementations, the file may include video files in various formats, such as company team-building videos, energy-saving and emission-reduction videos of employees riding public transportation, and various recorded company certificates.
[0055] In some implementations, the file may include non-video files such as pictures, words, and execl tables, such as company financial reports, company certificates, company employee lists, and the like.
[0056] Step 120: Identify whether each of the files is a template file or a non-template file.
[0057] In some embodiments, some minimum indicators in the ESG score will provide a template file for the user to download, and the user can download the template file and fill in the information.
[0058] In some implementations, the template file contains a template identifier, such as a watermark, a specific character string, etc. After the template file is obtained, the template identifier in the template file is used to identify which minimum indicator corresponds to the template.
[0059] Please refer to Table 1 below, which is a partial list of indicators included in the ESG rating table provided in the embodiment of the present application.
[0060]
[0061] For example, the unit product water resource consumption in the four-level indicators in Table 1 may have a template that can be downloaded and filled in by the user.
[0062] Exemplarily, the minimum index in Table 1 is a level 4 index.
[0063] Exemplarily, the table judged as DATA is the minimum indicator of the data type, the table judged as presence or absence is the minimum indicator of the selection type, and the table judged as blank is the minimum indicator of the display type.
[0064] Step 130: Record the minimum index corresponding to each of the template files to determine the primary index corresponding to each of the template files.
[0065] In some embodiments, the minimum indicator corresponding to each template file is recorded and stored by identifying the template identifier in the template file. The method of the present application is applied to the server, and a correspondence table between the template identifier and the minimum indicator can be pre-set in the server for easy query.
[0066] In some implementations, the template file is identified through a subsequent indicator identification model to determine which minimum indicator corresponds to the template file.
[0067] In some embodiments, each employee's account will be associated with a department. In this application, different minimum indicator permissions will be opened to different departments in the enterprise. For example, the statistical department corresponding to the four-level indicator unit product water resource consumption in Table 1 is the Product Department (PD), the statistical department for the proportion of female employees in the four-level indicator is the Human Resources Department (HR), and the statistical department for the number of suppliers that have obtained ISO 9001 certification in the four-level indicator is the Project Management Center (PMC).
[0068] In some implementations, each employee also needs to select whether the file type is a department file or a personal file when uploading a file, where a department file refers to a file corresponding to the minimum indicator open to the employee's department, and a department file is a task that the department is responsible for, such as a statistical table of certain data; and a personal file is a file uploaded by an employee on his own initiative, such as a video of an employee singing during team building.
[0069] In some implementations, if the file type is a departmental file, the file will subsequently need to be signed by the department and the board of directors, and the signing results will also need to be recorded in the blockchain to ensure the fairness and reliability of the departmental file.
[0070] By opening up permissions for different minimum indicators to corresponding departments and allowing each department to fill in the minimum indicators corresponding to its job responsibilities, on the one hand, it can ensure data validity and prevent companies from pushing the task of collecting ESG report data to a single department, such as the HR department. It takes a long time to solve collection difficulties, and because it is not the responsibility of the department itself, if other departments do not cooperate, the collected data will be inaccurate. On the other hand, it can also improve the efficiency of data collection, because many companies have not been exposed to ESG ratings before, and ESG ratings require filling in a lot of content. Many times, companies feel at a loss as to where to start. The above method can split the content and let each department be responsible for a small part, completing the collection of department data first, and facilitating targeted collection of missing data later.
[0071] In addition, this application can collect files uploaded by company employees this year. Companies can improve data to update ESG reports at any time, so companies can also supplement files later. For example, if companies in the four-level indicators formulate a continuous electricity conservation system, they can re-rate themselves after improving the continuous electricity conservation system, which will facilitate corporate progress and allow companies to make targeted improvements.
[0072] Step 140: Identify the minimum index corresponding to each of the non-template files to determine the primary index corresponding to each of the non-template files.
[0073] In some embodiments, see Figure 2 , Figure 2 yes Figure 1 Detailed flow chart of step 140 in FIG. Figure 2 As shown, step 140 includes steps 141 to 143.
[0074] Step 141: Determine whether the non-template file is a video file.
[0075] Step 142: If the non-template file is not a video file, a semantic analysis is performed on the non-template file, and a minimum index corresponding to each non-template file is determined according to the result of the semantic analysis.
[0076] In some implementations, if the file is not a video file, the file type may be a picture, a document, an execl table, etc.
[0077] In some embodiments, step 142 includes the following steps.
[0078] Step 1421: Perform semantic analysis on the non-template file, output the semantics of the non-template file, and calculate semantic similarity between the semantics and the corresponding semantics of each of the minimum indicators; wherein the corresponding semantics of each of the minimum indicators is the sum of the semantics of the superior indicator to which the minimum indicator is subordinate and its own semantics.
[0079] In some embodiments, because there may be minimum indicators with the same or similar semantics, for example, the three-level indicator in Table 1 includes the fourth-level indicator for water use to realize information management, and the three-level indicator in electricity use also includes the fourth-level indicator for information management. If only the semantics of the minimum indicator are used for semantic similarity calculation, it will be impossible to determine the minimum indicator that actually needs to be matched; therefore, the corresponding semantics of each minimum indicator in the embodiment of the present application is the sum of the semantics of the superior indicator to which the minimum indicator belongs and its own semantics.
[0080] Exemplarily, the superior indicators of water consumption per unit product include water use, resource use and environment.
[0081] Step 1422: Determine the minimum index with the largest semantic similarity as the minimum index corresponding to the non-template file.
[0082] Through the above method, the minimum indicators corresponding to non-video files can be determined, thereby improving the intelligence level of calculating ESG ratings.
[0083] Step 143: If the non-template file is a video file, the video file is input into the indicator recognition model, and the minimum indicator corresponding to each non-template file is determined by the indicator recognition model.
[0084] In some embodiments, when an employee uploads a video, a label filling box will pop up, allowing the employee to fill in labels in the label filling box that are easy for the indicator recognition model to identify, such as labels such as energy conservation and emission reduction, team building, etc.; or the employee can directly fill in the corresponding minimum indicator in the label filling box.
[0085] In some embodiments, if the indicator type of the minimum indicator corresponding to the video is a display type, the indicator recognition model will determine the similarity between the video and the minimum indicator. As long as the similarity meets the standard, it will be determined as a valid video corresponding to the minimum indicator. Because the minimum indicator of the display type, such as the company's continuous electricity saving system in Table 1, is difficult to measure with a fixed standard, for example, the electricity consumption of companies of different sizes and in different industries varies greatly. At this time, if the company's employees can upload relevant videos, it can reflect to a certain extent that the company is indeed implementing the relevant system. For example, on World Lights Out Day, the company uploaded a video of turning off the lights for half an hour. Therefore, if the minimum indicator of the display type uploads the corresponding video, the score of this minimum indicator can be made higher when the ESG rating is calculated later.
[0086] In some embodiments, step 143 includes the following steps.
[0087] Step 1431: Identify whether each video of the non-template file includes an employee through the indicator recognition model.
[0088] Step 1432: If employees are included, identify the employee's behavior or the activities being performed by all employees in the video, and determine the minimum indicator corresponding to each non-template file based on the employee's behavior or the activities being performed by all employees.
[0089] For example, if employees are having a dinner together, it is determined as a team-building video, corresponding to the minimum indicator of employee care.
[0090] Step 1433: If the employee is not included, identify the information and scenes included in the video, and determine the minimum index corresponding to each of the non-template files based on the information and scenes.
[0091] In some embodiments, the information may include certificates, company regulatory documents, various statistical tables, etc.
[0092] For example, the video shows the company's ISO45001 certificate, which corresponds to the minimum indicator occupational health and safety management system certification.
[0093] In some embodiments, the audio in the video is analyzed, and the corresponding minimum indicator is determined based on the scene and the audio. For example, if the scene in the video is a meeting scene, and the audio in the video is analyzed to determine that the meeting is discussing how to build a safety culture, then the corresponding minimum indicator is safety culture construction.
[0094] Step 150: Calculate the score of each primary indicator according to the template file and the non-template file included in each primary indicator; wherein the primary indicators include social indicators, environmental indicators and corporate governance indicators.
[0095] In some implementations, different types of minimum indicators require different evaluation methods.
[0096] In some implementations, the minimum index of the data type determines the score of the minimum index based on the data size.
[0097] In some embodiments, the minimum indicator of a selection type is determined based on the selection result to determine the score of the minimum indicator, for example, if the result is yes, full marks are given, otherwise, zero marks are given.
[0098] In some embodiments, the minimum index of the display type is determined according to the content type of the included documents. If the content type of the document includes both a regulation display document that displays the system or specification and an execution display document when implementing the system or specification, it has a basic excellent score, with a full score of 100, for example, 70 points. Then, the completeness of the regulations displayed in the regulation display document and the number of executions in the execution display document are further evaluated. If the highest degree of completeness and the preset maximum number of executions are reached, full marks are awarded, otherwise points are deducted as appropriate.
[0099] In some implementations, a very large number of files may be uploaded to one indicator, and it is difficult to determine which files should be used to calculate the score when calculating the score of the minimum indicator. In this case, the method provided in the embodiment of the present application also includes the following steps.
[0100] (1) When a minimum indicator corresponds to multiple files, determine the indicator type of the minimum indicator; wherein the indicator type includes data type, display type and selection type.
[0101] (2) If the indicator type of the minimum indicator is a data type, determine the department corresponding to the minimum indicator, query each file through the blockchain whether it has been signed by the department and the board of directors, eliminate the files that have not been signed by the department and / or the board of directors, and aggregate the data of the remaining files to generate a new template file corresponding to the minimum indicator, so as to calculate the score of the first-level indicator corresponding to the minimum indicator according to the new template file; wherein the minimum indicator of each data type has a corresponding template;
[0102] Specifically, the minimum indicator of the data type needs to ensure the accuracy of the data. Therefore, if there are multiple files, choose to trust the department files that have been approved by the department and the board of directors. The approval results of the department files are saved in the blockchain to prevent tampering. Personal files cannot guarantee accuracy and may be arbitrarily changed in pursuit of ESG ratings that do not conform to the actual level of the enterprise. It is understandable that if the data is allowed to be changed at will, the ESG rating calculated in this application will lose credibility. Therefore, in this application, when the minimum indicator of the data type corresponds to multiple files, only the data of the department files is trusted. Moreover, the data of the department files have been approved and can be safely merged. It is difficult to determine whether there is duplicated data in personal files and department files.
[0103] (3) If the indicator type of the minimum indicator is a selective type, identify the selective results of all files. When the selective results of all files are consistent, calculate the score of the primary indicator corresponding to the minimum indicator according to the selective results.
[0104] In some implementations, different types of minimum indicators require different evaluation methods.
[0105] Specifically, the minimum indicator of the selection type only needs to be judged whether it exists or not. If there are files with completely opposite selection results in the uploaded files, the company needs to re-sort them internally. If the selection results in the uploaded files are all the same, they will be determined as the final selection results and participate in the rating calculation.
[0106] In some implementations, the full score of each first-level indicator is 100 points, and each fourth-level indicator corresponds to a certain score. This application does not limit the specific score value.
[0107] In some implementations, the minimum index of the data type determines the score of the minimum index based on the data of the new template file.
[0108] Exemplarily, the data of the new template file is compared with a plurality of standard data, each standard data corresponds to a score, and the highest score that the data of the new template file can reach is the score of the minimum indicator corresponding to the new template file.
[0109] In some implementations, the minimum indicator of the alternative type corresponds to a score for each alternative result.
[0110] Exemplarily, a yes result corresponds to full marks, and a no result corresponds to zero marks.
[0111] In some embodiments, the minimum index of the display type is determined according to the content type of the included documents. If the content type of the document includes both a regulation display document that displays the system or specification and an execution display document when implementing the system or specification, it has a basic excellent score, with a full score of 100, for example, 70 points. Then, the completeness of the regulations displayed in the regulation display document and the number of executions in the execution display document are further evaluated. If the highest degree of completeness and the preset maximum number of executions are reached, full marks are awarded, otherwise points are deducted as appropriate.
[0112] For example, the completeness of regulations includes whether the regulations have clear implementation standards, whether the regulations include reward measures and punishment measures, etc.
[0113] In some embodiments, if there is only a regulations display file or an execution display file, the full score is set to an excellent score, such as the 70 points mentioned above, and the final score is calculated based on the completeness of the regulations or the number of executions in the execution display file. For example, if the regulations reach the highest degree of completeness, 70 points will be awarded.
[0114] It is understandable that the display file for displaying the system or norms and the display file for implementing the system or norms can be the same file. For example, the same video or uploaded picture set includes both the part for displaying the system or norms and the part for implementing the system or norms.
[0115] Step 160: Calculate the ESG rating of the enterprise based on the score of each of the first-level indicators and the preset weights.
[0116] Specifically, a total score may be calculated based on the score of each of the first-level indicators and the preset weights, and different total scores correspond to different ratings.
[0117] Exemplarily, ESG ratings include ten levels: AAA, AA, A, BBB, BB, B, CCC, CC, C, and D.
[0118] In some embodiments, the environmental, social and corporate governance rating calculation method provided in the embodiments of the present application also includes the following steps.
[0119] (1) Obtain the industry type of the enterprise;
[0120] (2) Determining, based on the industry type, the minimum indicator included in each of the first-level indicators when calculating the ESG rating of the enterprise, as well as the preset weight corresponding to each of the first-level indicators.
[0121] In some embodiments, the environmental, social and corporate governance rating calculation method provided in the embodiments of the present application also includes the following steps.
[0122] (1) Generate an environmental, social and corporate governance report based on the template file and the non-template file included in each first-level indicator.
[0123] The embodiment of the present application also provides an environmental, social and corporate governance rating calculation device, the device comprising:
[0124] An acquisition unit, used to acquire files uploaded by each employee of the enterprise;
[0125] A recording unit, used to identify whether each of the files is a template file or a non-template file, and record the minimum index corresponding to each template file to determine the primary index corresponding to each template file;
[0126] An identification unit, used to identify the minimum index corresponding to each of the non-template files, so as to determine the primary index corresponding to each of the non-template files;
[0127] A first calculation unit, used to calculate the score of each first-level indicator according to the template file and the non-template file of each first-level indicator respectively; wherein the first-level indicators include social indicators, environmental indicators and social indicators;
[0128] The second calculation unit is used to calculate the ESG rating of the enterprise according to the score of each of the first-level indicators and the preset weight.
[0129] See also Figure 3 , Figure 3 Schematic diagram of the structure of an electronic device provided in an embodiment of the present application. Figure 3 As shown, the electronic device 200 includes: one or more processors 210 and a memory 220, Figure 3 A processor 210 is taken as an example.
[0130] In some implementations, the processor 210 and the memory 220 may be connected via a bus or other means. Figure 3 The example of connecting through bus is taken in the following.
[0131] In some embodiments, the processor 210 is used to obtain files uploaded by each employee of the enterprise; identify whether each of the files is a template file or a non-template file; record the minimum indicator corresponding to each of the template files to determine the first-level indicator corresponding to each of the template files; identify the minimum indicator corresponding to each of the non-template files to determine the first-level indicator corresponding to each of the non-template files; calculate the score of each first-level indicator according to the template files and the non-template files included in each first-level indicator; wherein the first-level indicators include social indicators, environmental indicators and corporate governance indicators; calculate the ESG rating of the enterprise according to the score of each of the first-level indicators and preset weights.
[0132] In some embodiments, the memory 220, as a non-volatile computer-readable storage medium, can be used to store non-volatile software programs, non-volatile computer executable programs and modules, such as program instructions / modules of the environmental, social and corporate governance rating calculation method in the embodiment of the present application. The processor 210 executes various functional applications and data processing of the electronic device by running the non-volatile software programs, instructions and modules stored in the memory 220, that is, the environmental, social and corporate governance rating calculation method of the above method embodiment is implemented.
[0133] In some embodiments, the memory 220 may include a program storage area and a data storage area, wherein the program storage area may store an operating system, an application required for at least one function; the data storage area may store data created according to the use of the electronic device, etc. In addition, the memory 220 may include a high-speed random access memory, and may also include a non-volatile memory, such as at least one disk storage device, a flash memory device, or other non-volatile solid-state storage device. In some embodiments, the memory 220 may optionally include a memory remotely arranged relative to the processor 210, and these remote memories may be connected to the controller via a network. Examples of the above-mentioned network include, but are not limited to, the Internet, an intranet, a local area network, a mobile communication network, and combinations thereof.
[0134] In some embodiments, one or more modules are stored in the memory 220, and when executed by one or more processors 210, perform the environmental, social and corporate governance rating calculation method in any of the above method embodiments, for example, perform the above described Figure 1 Method steps 110 to 160 in.
[0135] Please refer to Figure 4 , Figure 4 300 is a block diagram of a computer-readable storage medium provided in an embodiment of the present application. The computer-readable storage medium 300 stores a program code 310, which can be called by a processor to execute the environmental, social and corporate governance rating calculation method described in the above method embodiment.
[0136] The computer-readable storage medium 300 may be an electronic memory such as a flash memory, an EEPROM (electrically erasable programmable read-only memory), an EPROM, a hard disk or a ROM. Optionally, the computer-readable storage medium includes a non-transitory computer-readable storage medium. The computer-readable storage medium 300 has a storage space for program codes for executing any method steps in the above control method. These program codes may be read from or written to one or more computer program products. The program code may be compressed, for example, in an appropriate form.
[0137] In summary, the present application provides a method, device, electronic device and storage medium for calculating environmental, social and corporate governance ratings, the method comprising: obtaining files uploaded by each employee of the enterprise; identifying whether each of the files is a template file or a non-template file; recording the minimum index corresponding to each of the template files to determine the primary index corresponding to each of the template files; identifying the minimum index corresponding to each of the non-template files to determine the primary index corresponding to each of the non-template files; calculating the score of each primary index according to the template files and the non-template files included in each primary index; wherein the primary index includes social indicators, environmental indicators and corporate governance indicators; calculating the ESG rating of the enterprise according to the score of each of the primary indicators and the preset weight. In the present application, the ESG rating of the enterprise can be automatically generated through the files uploaded by the enterprise without relying on industry experts and analysts.
[0138] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present application, rather than to limit it. Although the present application has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that they can still modify the technical solutions described in the aforementioned embodiments, or make equivalent replacements for some of the technical features therein. However, these modifications or replacements do not cause the essence of the corresponding technical solutions to deviate from the spirit and scope of the technical solutions of the embodiments of the present application.
Claims
1. A method for calculating environmental, social and corporate governance ratings, characterized in that: The method comprises: Get the files uploaded by each employee of the enterprise; Identifying whether each of the files is a template file or a non-template file; Record the minimum indicator corresponding to each of the template files to determine the first-level indicator corresponding to each of the template files; wherein the minimum indicator has no subordinate indicators in the rating table of the ESG rating, and each of the minimum indicators uniquely corresponds to one of the first-level indicators; Identify the minimum index corresponding to each of the non-template files to determine the primary index corresponding to each of the non-template files; Calculating the score of each first-level indicator according to the template file and the non-template file included in each first-level indicator; wherein the first-level indicators include social indicators, environmental indicators and corporate governance indicators; Calculate the ESG rating of the enterprise based on the score of each primary indicator and the preset weight; The identifying the minimum index corresponding to each of the non-template files includes: Determining whether the non-template file is a video file; If the non-template file is not a video file, performing semantic analysis on the non-template file, and determining a minimum index corresponding to each non-template file according to a result of the semantic analysis; If the non-template file is a video file, the video file is input into the index recognition model, and the minimum index corresponding to each non-template file is determined by the index recognition model; If the non-template file is not a video file, semantic analysis is performed on the non-template file to determine the minimum index corresponding to each non-template file, including: Performing semantic analysis on the non-template file, outputting the semantics of the non-template file, and calculating semantic similarity between the semantics and the corresponding semantics of each of the minimum indicators; wherein the corresponding semantics of each of the minimum indicators is the sum of the semantics of the superior indicator to which the minimum indicator is subordinate and its own semantics; The minimum index with the largest semantic similarity is determined as the minimum index corresponding to the non-template file.
2. The method according to claim 1, characterized in that The method further comprises: Get the industry type of the enterprise; The minimum indicator included in each of the first-level indicators when calculating the ESG rating of the enterprise is determined according to the industry type, as well as the preset weight corresponding to each of the first-level indicators.
3. The method according to claim 1, characterized in that The determining the minimum index corresponding to each of the non-template files through the index identification model includes: Identify whether each video of the non-template file includes an employee by using the indicator recognition model; If employees are included, identifying the behavior of the employees or the activities being performed by all employees in the video, and determining the minimum indicator corresponding to each of the non-template files according to the behavior of the employees or the activities being performed by all employees; If the employee is not included, the information and scenes included in the video are identified, and the minimum index corresponding to each of the non-template files is determined based on the information and scenes.
4. The method according to claim 1, characterized in that: The method further comprises: When one of the minimum indicators corresponds to multiple files, determining the indicator type of the minimum indicator; wherein the indicator type includes data type, display type and selection type; If the indicator type of the minimum indicator is a data type, determine the department corresponding to the minimum indicator, query each file through the blockchain whether it has been signed by the department and the board of directors, eliminate the files that have not been signed by the department and / or the board of directors, and aggregate the data of the remaining files to generate a new template file corresponding to the minimum indicator, so as to calculate the score of the first-level indicator corresponding to the minimum indicator according to the new template file; wherein the minimum indicator of each data type has a corresponding template; If the indicator type of the minimum indicator is a selective type, identify the selective results of all files, and when the selective results of all files are consistent, calculate the score of the primary indicator corresponding to the minimum indicator according to the selective result.
5. The method according to claim 1, characterized in that The method further comprises: Generate an environmental, social and corporate governance report based on the template file and the non-template file included in each first-level indicator.
6. An environmental, social and corporate governance rating calculation device, characterized in that: The device comprises: An acquisition unit, used to acquire files uploaded by each employee of the enterprise; A recording unit, used to identify whether each of the files is a template file or a non-template file, and record the minimum indicator corresponding to each template file to determine the first-level indicator corresponding to each template file; wherein the minimum indicator has no lower-level indicators in the rating table of the ESG rating, and each of the minimum indicators uniquely corresponds to one first-level indicator; An identification unit, used to identify the minimum index corresponding to each of the non-template files, so as to determine the primary index corresponding to each of the non-template files; A first calculation unit, used to calculate the score of each first-level indicator according to the template file and the non-template file of each first-level indicator respectively; wherein the first-level indicators include social indicators, environmental indicators and social indicators; A second calculation unit, configured to calculate the ESG rating of the enterprise according to the score of each of the first-level indicators and a preset weight; The identification unit is also used to determine whether the non-template file is a video file; if the non-template file is not a video file, a semantic analysis is performed on the non-template file, and the minimum index corresponding to each non-template file is determined according to the result of the semantic analysis; if the non-template file is a video file, the video file is input into the index identification model, and the minimum index corresponding to each non-template file is determined by the index identification model; The identification unit is also used to perform semantic analysis on the non-template file, output the semantics of the non-template file, and calculate the semantic similarity between the semantics and the corresponding semantics of each of the minimum indicators; wherein the corresponding semantics of each of the minimum indicators is the sum of the semantics of the superior indicator to which the minimum indicator is subordinate and its own semantics; and the minimum indicator with the greatest semantic similarity is determined as the minimum indicator corresponding to the non-template file.
7. An electronic device, characterized in that: The electronic device comprises: at least one processor; and, a memory communicatively connected to the at least one processor; wherein, The memory stores instructions executable by the at least one processor, and the instructions are executed by the at least one processor so that the at least one processor can execute the environmental, social and corporate governance rating calculation method as described in any one of claims 1-5.
8. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores an executable program, and the executable program is executed by a processor to implement the environmental, social and corporate governance rating calculation method as described in any one of claims 1 to 5.
Citation Information
Patent Citations
Enterprise risk grade evaluation method based on hierarchical analysis and fuzzy comprehensive evaluation method
CN113256075A
Business environment analysis method and device, equipment and medium
CN113869724A