CN114493515A - Power grid asset auditing method and device, storage medium and computer equipment - Google Patents
Power grid asset auditing method and device, storage medium and computer equipment Download PDFInfo
- Publication number
- CN114493515A CN114493515A CN202210053510.XA CN202210053510A CN114493515A CN 114493515 A CN114493515 A CN 114493515A CN 202210053510 A CN202210053510 A CN 202210053510A CN 114493515 A CN114493515 A CN 114493515A
- Authority
- CN
- China
- Prior art keywords
- asset
- data
- depreciation
- record
- power grid
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 85
- 238000003860 storage Methods 0.000 title claims abstract description 13
- 238000012550 audit Methods 0.000 claims abstract description 28
- 230000008859 change Effects 0.000 claims abstract description 17
- 238000002360 preparation method Methods 0.000 claims description 17
- 230000008439 repair process Effects 0.000 claims description 13
- 238000007726 management method Methods 0.000 claims description 8
- 230000009467 reduction Effects 0.000 claims description 8
- 238000013515 script Methods 0.000 claims description 6
- 238000004590 computer program Methods 0.000 claims description 4
- 230000001186 cumulative effect Effects 0.000 claims description 4
- 238000001514 detection method Methods 0.000 claims description 3
- 238000004458 analytical method Methods 0.000 abstract description 4
- 230000008569 process Effects 0.000 description 18
- 238000004891 communication Methods 0.000 description 14
- 230000006870 function Effects 0.000 description 12
- 238000010586 diagram Methods 0.000 description 5
- 238000007689 inspection Methods 0.000 description 4
- 238000012545 processing Methods 0.000 description 4
- 230000003247 decreasing effect Effects 0.000 description 3
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000007621 cluster analysis Methods 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 238000013524 data verification Methods 0.000 description 1
- 230000003111 delayed effect Effects 0.000 description 1
- 238000009826 distribution Methods 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 239000013307 optical fiber Substances 0.000 description 1
- 230000002085 persistent effect Effects 0.000 description 1
- 238000011084 recovery Methods 0.000 description 1
- 238000009877 rendering Methods 0.000 description 1
- 238000007619 statistical method Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/06—Energy or water supply
Landscapes
- Business, Economics & Management (AREA)
- Engineering & Computer Science (AREA)
- Human Resources & Organizations (AREA)
- Strategic Management (AREA)
- Economics (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Entrepreneurship & Innovation (AREA)
- Marketing (AREA)
- General Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- Tourism & Hospitality (AREA)
- Physics & Mathematics (AREA)
- Public Health (AREA)
- Primary Health Care (AREA)
- General Health & Medical Sciences (AREA)
- Data Mining & Analysis (AREA)
- Water Supply & Treatment (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The embodiment of the application discloses a method and a device for auditing power grid assets, a storage medium and computer equipment, and relates to the field of data auditing. The method comprises the steps of collecting power grid asset data; wherein the grid asset data comprises: asset classification standard data, asset card list data, asset value generation detail record data, asset value ledger record data, asset depreciation standard data and asset card change trajectory table data; auditing the power grid asset data according to a preset auditing rule to obtain an auditing result; the records which do not pass the audit are repaired, so that the automatic audit of the data is realized, the pressure of manual analysis and check is greatly reduced, and the working efficiency is improved.
Description
Technical Field
The application relates to the field of data auditing, in particular to an auditing method, device, storage medium and computer equipment for power grid assets.
Background
The power grid enterprise is an asset-intensive enterprise, the asset data volume is large, the asset types are various, and when financial staff manage asset values, the manual operation of the staff such as a large amount of data analysis and data verification exists. Fixed assets are used as important components of power grid enterprise assets, the quantity and the value are large, data association is more, but the existing asset data auditing tools in other fields cannot well support data auditing of the power grid assets, and one is that the auditing of some professional attributes is not supported, for example: the method is characterized by comprising the following steps of (1) checking production voltage grade, checking and calculating voltage grade, whether assets are delayed or not, whether assets are effective or not, and the like.
Disclosure of Invention
The embodiment of the application provides a method and a device for auditing power grid assets, a storage medium and computer equipment, and can solve the problem that in the prior art, the efficiency of an auditing process of power grid asset data is low. The technical scheme is as follows:
in a first aspect, an embodiment of the present application provides a method for auditing assets of a power grid, where the method includes:
collecting power grid asset data; wherein the grid asset data comprises: asset classification standard data, asset card list data, asset value generation detail record data, asset value ledger record data, asset depreciation standard data and asset card change track table data;
auditing the power grid asset data according to a preset auditing rule to obtain an auditing result;
and repairing the record of the failure of the audit.
In a second aspect, an embodiment of the present application provides an auditing apparatus for power grid assets, where the apparatus includes:
the acquisition unit is used for acquiring the asset data of the power grid; wherein the grid asset data comprises: asset classification standard data, asset card list data, asset value generation detail record data, asset value ledger record data, asset depreciation standard data and asset card change track table data;
the auditing unit is used for auditing the power grid asset data according to a preset auditing rule to obtain an auditing result;
and the repairing unit is used for repairing the record which is not passed by the audit.
In a third aspect, embodiments of the present application provide a computer storage medium storing a plurality of instructions adapted to be loaded by a processor and to perform the above-mentioned method steps.
In a fourth aspect, an embodiment of the present application provides a computer device, which may include: a processor and a memory; wherein the memory stores a computer program adapted to be loaded by the processor and to perform the above-mentioned method steps.
The beneficial effects brought by the technical scheme provided by some embodiments of the application at least comprise:
the professional audit of the power grid asset data can be realized, the pressure of manual analysis and check is greatly reduced, the working efficiency is improved, the asset data quality is improved, and the lean management of the asset value is further realized.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings used in the embodiments or the prior art descriptions will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present application, and other drawings can be obtained by those skilled in the art without creative efforts.
FIG. 1 is a schematic diagram of a system architecture provided by an embodiment of the present application;
FIG. 2 is a schematic flow chart of a method for auditing assets of a power grid according to an embodiment of the present disclosure;
FIG. 3 is a schematic structural diagram of an auditing device for power grid assets provided by the present application;
fig. 4 is a schematic structural diagram of a computer device provided in the present application.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more clear, embodiments of the present application will be described in further detail below with reference to the accompanying drawings.
It should be noted that, the auditing method for the power grid assets provided by the present application is generally executed by a computer device, and accordingly, the auditing device for the power grid assets is generally disposed in the computer device.
Fig. 1 shows an exemplary system architecture of an auditing method of power grid assets or an auditing apparatus of power grid assets that can be applied to the present application.
As shown in fig. 1, the system architecture may include: computer device 101 and server 102. Communication between computer device 101 and server 102 may be via a network, which is the medium used to provide the communication links between the various elements described above. The network may include various types of wired or wireless communication links, such as: the wired communication link includes an optical fiber, a twisted pair wire, or a coaxial cable, etc., and the WIreless communication link includes a bluetooth communication link, a WIreless-FIdelity (Wi-Fi) communication link, or a microwave communication link, etc.
The server 102 stores power grid asset data, the power grid asset data comprises asset classification standard data, asset card list data, asset value occurrence detail record data, asset value ledger record data, asset depreciation standard data and asset card change track table data, the computer device 101 reads the power grid asset data in the server 102, audit results are obtained according to preset audit rules, and unqualified data are repaired.
It should be noted that the computer device 101 and the server 102 may be hardware or software. When the computer device 101 and the server 102 are hardware, they may be implemented as a distributed server cluster composed of a plurality of servers, or may be implemented as a single server. When the computer device 101 and the server 102 are software, they may be implemented as a plurality of software or software modules (for example, for providing distributed services), or may be implemented as a single software or software module, and are not limited in this regard.
Various communication client applications may be installed on the computer device of the present application, for example: video recording application, video playing application, voice interaction application, search application, instant messaging tool, mailbox client, social platform software, etc.
The computer device may be hardware or software. When the computer device is hardware, it may be various computer devices having a display screen, including but not limited to smart phones, tablet computers, laptop portable computers, desktop computers, and the like. When the computer device is software, the above listed computer devices may be installed. Which may be implemented as multiple software or software modules (e.g., to provide distributed services) or as a single software or software module, and is not particularly limited herein.
When the computer equipment is hardware, the computer equipment can also be provided with display equipment and a camera, the display equipment can display various equipment capable of realizing the display function, and the camera is used for collecting video streams; for example: the display device may be a cathode ray tube (CR) display, a light-emitting diode (LED) display, an electronic ink screen, a Liquid Crystal Display (LCD), a Plasma Display Panel (PDP), or the like. The user can utilize the display device on the computer device to view the displayed information such as characters, pictures, videos and the like.
It should be understood that the number of computer devices, networks, and servers in FIG. 1 is illustrative only. Any number of computer devices, networks, and servers are possible, as desired for an implementation.
The method for auditing the power grid assets provided by the embodiment of the application will be described in detail below with reference to fig. 2. The auditing device for the power grid assets in the embodiment of the present application may be the computer device shown in fig. 1.
Referring to fig. 2, a schematic flow chart of a method for auditing power grid assets is provided in the embodiment of the present application. As shown in fig. 2, the method of the embodiment of the present application may include the steps of:
s201, collecting power grid asset data.
Wherein the grid asset data represents attribute information of a plurality of grid assets, the grid asset data including but not limited to the following data: the system comprises asset classification standard data, asset card list data, asset value occurrence detail record data, asset value ledger record data, asset depreciation standard data and asset card change track table data.
The asset classification standard data is used for providing reference of attribute values, the asset classification standard data is composed of a plurality of records, one record corresponds to one power grid asset, and each record comprises the following attribute values:
asset class code, asset class name, standard depreciation method, standard net-residual rate, standard age, and standard usage class.
The asset card list data is used for recording the main attributes of all power grid assets, the asset card list data is composed of a plurality of records, one record corresponds to one power grid asset, and each record contains the following attribute values:
asset code, asset name, specification model, asset class, usage status (including in-use or out-of-use), date of initial use, age, month of used, age method, net residual rate, billing unit, usage unit, management department, management responsible person, usage department, user, supplier, manufacturer, voltage class, amount of original value, cumulative amount of old value, amount of reduced value preparation.
The asset value generation detail data represents the asset value reduction increase and decrease condition of each power grid asset, the asset value generation detail data is composed of a plurality of records, one record corresponds to each power grid asset, and each record comprises the following attribute values:
the method comprises the steps of establishing an account unit, asset coding, service month, service type, value change direction, original value change amount, accumulated depreciation change amount, predicted net residual value change amount and subtracted value preparation change amount.
The asset value ledger data is used for recording the value change and summary condition of monthly asset cards of the power grid assets, the asset value ledger record data is composed of a plurality of records, one record corresponds to one power grid asset, and each record comprises the following attribute values:
the method comprises the steps of account establishment units, word length codes, service months, asset original value beginning amount, asset original value increase amount, asset original value decrease amount, asset original value end amount, accumulated depreciation beginning amount, accumulated depreciation increase amount, accumulated depreciation decrease amount, accumulated depreciation end amount, depreciation preparation beginning amount, depreciation preparation increase amount, depreciation accurate decrease amount and depreciation preparation end amount.
The asset depreciation standard data is used for recording the depreciation amount of each month when the power grid asset is depreciated, each asset depreciation standard data is composed of a plurality of records, one record corresponds to one power grid asset, and each record contains the following attribute values:
account establishment unit, asset code, depreciation starting month, depreciation ending month, depreciation continuing month, depreciation amount of month, and effective state.
The asset card table moving track table data is used for recording adjustment records of main attributes and value sequences of the assets of the power grid, and each adjustment record comprises a plurality of records, one record corresponds to one power grid asset, and each record comprises the following attribute values:
billing units, asset code, change attribute, pre-change attribute value, post-change attribute value, and change date.
S202, auditing the power grid asset data according to a preset auditing rule to obtain an auditing result.
The computer equipment is pre-configured with an auditing rule, and automatically audits each attribute value included in the power grid asset data by using the auditing rule to obtain an auditing result.
The application utilizes audit rules to execute the following 3-dimensional data set on the power grid asset data:
first, the assessment index.
Wherein, the assessment indexes comprise: fixed asset depreciation method inspection, fixed asset net residual value rate inspection and fixed asset depreciation age limit inspection.
The process of assessing the fixed asset depreciation method comprises the following steps:
and (3) inquiring the depreciation method of the power grid assets in the asset card list data by taking the asset codes of the power grid assets as indexes and the asset classification as key words, and inquiring the standard depreciation method of the power grid assets in the asset classification standard data, comparing whether the depreciation method is equal to the standard depreciation method, and marking the records with unequal comparison results in each record contained in the asset card list data.
The process of checking the depreciation age of the fixed assets comprises the following steps:
and (3) inquiring the net residual value rate of the power grid assets in the asset card list data by taking the asset codes of the power grid assets as indexes and classifying the assets into key words, inquiring the standard net residual value rate of the power grid assets in the asset classification standard data, comparing whether the net residual value rate is equal to the standard net residual value rate or not, and marking the comparison result as unequal records in all records contained in the asset card list data.
The process of assessing the depreciation age of the fixed assets comprises the following steps:
the asset code of the power grid asset is used as an index, the asset classification is a keyword, the service life of the power grid asset is inquired in the asset card list data, the standard depreciation life of the power grid asset is inquired in the asset classification standard data, whether the service life is equal to the standard service life or not is compared, and records with unequal comparison results are marked in all records contained in the asset card list data.
And secondly, account card consistency.
Wherein, account card uniformity specifically includes: and (4) fixed asset code repeated checking and fixed asset card value and standing book consistency checking.
The fixed asset code duplication checking process includes:
and carrying out asset code repeatability detection on each record in the asset card inventory data, and marking the record with the repeated asset codes.
The fixed asset card value and standing book consistency checking process comprises the following steps:
the method comprises the steps of inquiring original value amount, accumulated depreciation amount and accurate depreciation amount of a power grid asset in asset card list data by taking an asset code of the power grid asset as an index, then inquiring asset original value beginning amount, asset original value increasing amount, asset original value decreasing amount, asset original value end amount, accumulated depreciation beginning amount, accumulated depreciation increasing amount, accumulated depreciation decreasing amount, accumulated depreciation end amount, ready-to-reduce beginning amount, ready-to-reduce increasing amount, accurate depreciation decreasing amount and ready-to-reduce end amount of the power grid asset in asset value ledger record data, comparing whether attribute values of two inquired records are matched or not, and marking unmatched records in each record included in the asset card list data.
Thirdly, data validity,
Wherein the data validity includes: the method comprises the steps of checking whether a depreciated fixed asset is used for months, checking whether the depreciated fixed asset is used for months, checking whether a fixed asset depreciation standard is checked, checking whether the card value of a cancelled fixed asset is zero, and checking whether a overdue card is not used for depreciation or more depreciated cards.
The process of depreciating a used month check of a fixed asset includes:
the method comprises the steps of using an asset code of a power grid asset as an index, inquiring used months and starting using dates (in months) of the power grid asset in asset card list data, then obtaining a current date (for example, using an EXTRACT function to obtain months) by a computer device, and if the formula kssyrq + ysyyf ≠ dqrq, kssyrq represents the starting using date, ysyf represents the used months, and dqrq represents the current date, marking a record of the power grid asset in the asset card list data as a unqualified record.
The process of checking used months of the proposed depreciated fixed assets comprises:
the asset code of the power grid asset is used as an index, the used month and the service life of the power grid asset are inquired in the asset card list data, and if the formula is met: and (4) yyyf is not equal to sync x 12, yyyf represents used months, and sync represents used years, and then the record of the power grid asset in the asset card list data is marked as a unqualified record.
The process of the fixed asset depreciation standard inspection comprises the following steps:
and inquiring the depreciation continuous month, depreciation amount of the month and effective state of each power grid asset in the asset depreciation standard data by using the asset code as an index, and inquiring the original value amount, accumulated depreciation amount, subtraction preparation amount and net residual value rate of each power grid asset in the asset card list data, wherein if the formula is met: if the recording in the effective state is zjcxyf yzje ≠ zcyz (1-jczl) -ljzj-jzzb, marking the corresponding recording in the asset card list data as an unqualified recording; where zjcxyf represents a depreciation continuing month, yzje represents a month depreciation amount, zcyz represents an original value amount, ljzj represents a cumulative depreciation amount, jzzb represents a reduction preparation amount, and jczl represents a net remaining value rate.
The process of checking the cancelled fixed asset card value to zero comprises the following steps:
and inquiring the cancelled records in the asset card list data by taking the asset code as an index, then inquiring the original asset value end amount (zcyzqmmje), the accumulated depreciation end amount (ljzjqmmje) and the reduction preparation end amount (jzzbqmmje) in the corresponding records in the asset value standing book data, and marking the corresponding records in the asset card list data as unqualified records if the formula zcyzqmje ≠ 0 or ljzjqmmje ≠ 0 or jzbqmmje ≠ 0 is met.
The process of checking whether the overdue card is not carried out or a plurality of cards with different ages are carried out comprises the following steps:
inquiring records of which the service life is 12 equal to the used month in the asset card list data by taking the asset code as an index, and then acquiring the original value amount (zcyz), the accumulated depreciation amount (ljzj), the reduction preparation amount (jzzb) and the net residual value rate (jczl) in the inquired records, if the formula is met: and (1-jczl) -ljzj-jzzb ≠ 0, and then the corresponding record in the asset card list data is marked as a unqualified record.
S203, repairing the data with unqualified audit results.
After the audit result is obtained by the method, which recorded audit items are approved and which recorded audit items are not approved are obtained according to the audit. For the failed audit projects, fixed rules and relations among problem data can be found according to cluster analysis and related analysis in a statistical method, corresponding repair rules are formulated, and then sql repair scripts are automatically generated through array construction in Java coding, orange merge into and other related methods and are used for asset related data repair of an audit data source information system.
The method comprises the following steps of recording a plurality of records of an asset card list data, wherein the recovery is carried out on depreciation starting month, depreciation continuing month, depreciation ending month, residual depreciation amount and month depreciation amount of each record in the asset card list data by using the following formula:
depreciation starting month ═ dqrq (current date, month in units) + 1;
depreciation persistent month ═ synx 12-ysyyf;
the depreciation ending month is depreciation starting month + depreciation continuing month;
the remaining depreciation amount zcyz (1-jczl) -ljzj-jzzb;
the depreciation amount of the month is the remaining depreciation amount ÷ depreciation duration month.
And constructing data such as the depreciation starting month, the depreciation ending month, the depreciation continuing month, the depreciation amount of the month and the like calculated in the last step into an array, and automatically generating an sql repair script by utilizing a function method of Oracle.
Further, according to the check audit result list of the card value zero resetting of the cancelled fixed asset obtained in the step S202, the automatic repair is performed according to the following repair steps:
and (3) searching records of the audit result list in the asset card list data by taking the asset codes as indexes and keywords, combining the searched original value of the asset, the accumulated depreciation amount which is not zero with the main attributes of other assets in M1, constructing an asset array to be repaired according to a value return-to-zero principle, and automatically generating an sql repair script by utilizing an Oracle function method.
Further, according to the check audit result list of the card value zero resetting of the cancelled fixed asset obtained in the step S202, the automatic repair is performed according to the following repair steps:
and (3) searching records of the audit result list in the asset card list data by taking the asset codes as indexes and keywords, searching the difference between the accumulated depreciation amount and the theoretical amount, combining the difference with other asset main attributes in the asset card list data, constructing an asset array to be repaired according to the depreciation difference zeroing principle, and automatically generating an sql repair script by utilizing an Oracle function method.
By implementing the embodiment of the application, professional audit of the asset data of the power grid can be realized, the pressure of manual analysis and check is greatly reduced, the working efficiency is improved, the asset data quality is improved, and the lean of asset value management is further realized.
The following are embodiments of the apparatus of the present application that may be used to perform embodiments of the method of the present application. For details which are not disclosed in the embodiments of the apparatus of the present application, reference is made to the embodiments of the method of the present application.
Referring to fig. 3, a schematic structural diagram of an auditing apparatus for grid assets provided by an exemplary embodiment of the present application is shown, which is hereinafter referred to as an apparatus 3. The apparatus 3 may be implemented as all or part of a computer device, in software, hardware or a combination of both. The apparatus 3 comprises: the system comprises an acquisition unit 301, an auditing unit 302 and a repairing unit 303.
The acquisition unit 301 is used for acquiring power grid asset data; wherein the grid asset data comprises: asset classification standard data, asset card list data, asset value generation detail record data, asset value ledger record data, asset depreciation standard data and asset card change track table data;
the auditing unit 302 is used for auditing the power grid asset data according to a preset auditing rule to obtain an auditing result;
and a repairing unit 303, configured to repair the record that the audit fails.
In one or more possible embodiments, the auditing the power grid asset data according to a preset auditing rule to obtain an auditing result includes:
inquiring a depreciation method of the power grid assets in the asset card list data according to asset codes, and inquiring a standard depreciation method of the power grid assets in the asset classification standard data;
comparing whether the depreciation method and the standard depreciation method are the same; and/or
Inquiring the net residual value rate of the power grid assets in the asset card list data according to asset codes, and inquiring the standard net residual value rate of the power grid assets in the asset classification standard data;
comparing whether the net residual value rate and the standard net residual value rate are equal; and/or
Inquiring the service life of the power grid asset in the asset card list data according to the asset code, and inquiring the standard depreciation life of the power grid asset in the asset classification standard data;
comparing whether the age and the standard depreciation age are equal.
In one or more possible embodiments, the auditing the power grid asset data according to a preset auditing rule to obtain an auditing result further includes:
and performing asset code repeatability detection on each record included in the asset card request data, and marking the record with repeated asset codes.
In one or more possible embodiments, the auditing the power grid asset data according to a preset auditing rule to obtain an auditing result further includes:
using the asset code of the power grid asset as an index, inquiring the used month ysyyf and the starting use date kssyrq of the power grid asset in the asset card list data, and acquiring the current date dqrq, and if kssyrq + ysyyf is not equal to dqrqrq, marking the record of the power grid asset as an unqualified record; and/or
Using the asset code of the power grid asset as an index, inquiring the used month ysyyf and the service life synx of the power grid asset in the asset card list data, and if ysyyf is not equal to synx 12, marking the record of the power grid asset as a unqualified record; and/or
Inquiring the cancelled record in the asset card list data by taking the asset code of the power grid asset as an index, then inquiring the record associated with the cancelled record in the asset value standing book data, determining the original value future end amount zcyzmje of the asset and the accumulated depreciation future end amount (ljzjqmje, the depreciation preparation future end amount jzbqmje, and marking the corresponding record in the asset card list data as a unqualified record if the formula zcyzmje is not equal to 0 or ljzjqmje is not equal to 0 or jzbqmje is not equal to 0, and/or marking the corresponding record in the asset card list data as a unqualified record, and/or inquiring the record associated with the cancelled record in the asset value standing book data
Inquiring records of which the service life is 12 and is equal to the used month in the asset card list data by taking the asset code as an index, and then acquiring the original value amount zcyz, the accumulated depreciation amount ljzj, the reduction preparation amount jzzzb and the net residual value rate (jczl) in the inquired records, if the formula is met: and (1-jczl) -ljzj-jzzb ≠ 0, and then the corresponding record in the asset card list data is marked as a unqualified record.
In one or more possible embodiments, the repairing the record that the audit fails comprises:
and repairing the record which is not passed by the audit by utilizing the sql repair script.
In one or more possible embodiments, the beginning of the depreciation month, the continuing of the depreciation month, the ending of the depreciation month, the remaining depreciation amount, and the depreciation amount of the month recorded in the asset card inventory data are restored, using the following formula:
depreciation starting month is the current date + 1;
depreciation duration month-age 12-used month;
the depreciation ending month is depreciation starting month + depreciation continuing month;
remaining depreciation amount is original amount (1-net residual rate) -cumulative depreciation amount-reduction preparation amount;
the depreciation amount of the month is the remaining depreciation amount ÷ depreciation duration month.
In one or more possible embodiments, the asset card inventory data is comprised of records of a plurality of grid assets, each record including the following attribute values: asset code, asset name, specification model, asset class, usage status (in use, cancelled, etc.), date of initial use, age, month of used, method of depreciation, net residual rate, billing unit, usage unit, management department, management responsible person, usage department, user, supplier, manufacturer, voltage class, amount of original value, cumulative amount of depreciation, amount of reduction preparation.
It should be noted that, when the device 3 provided in the foregoing embodiment executes the auditing method for the power grid assets, only the division of the functional modules is illustrated, and in practical applications, the function distribution may be completed by different functional modules according to needs, that is, the internal structure of the device is divided into different functional modules to complete all or part of the functions. In addition, the auditing device of the power grid assets provided by the embodiment and the auditing method embodiment of the power grid assets belong to the same concept, and the embodiment of the method embodiment shows the implementation process, which is not described herein again.
The above-mentioned serial numbers of the embodiments of the present application are merely for description and do not represent the merits of the embodiments.
An embodiment of the present application further provides a computer storage medium, where the computer storage medium may store a plurality of instructions, where the instructions are suitable for being loaded by a processor and executing the method steps in the embodiment shown in fig. 2, and a specific execution process may refer to a specific description of the embodiment shown in fig. 2, which is not described herein again.
The present application further provides a computer program product storing at least one instruction, which is loaded and executed by the processor to implement the method for auditing the power grid assets according to the above embodiments.
Referring to fig. 4, a schematic structural diagram of a computer device is provided in an embodiment of the present application. As shown in fig. 4, the computer device 400 may include: at least one processor 401, at least one network interface 404, a user interface 403, memory 405, at least one communication bus 402.
Wherein a communication bus 402 is used to enable connective communication between these components.
The user interface 403 may include a Display screen (Display) and a Camera (Camera), and the optional user interface 403 may also include a standard wired interface and a wireless interface.
The network interface 404 may optionally include a standard wired interface, a wireless interface (e.g., WI-FI interface), among others.
The Memory 405 may include a Random Access Memory (RAM) or a Read-Only Memory (Read-Only Memory). Optionally, the memory 405 includes a non-transitory computer-readable medium. The memory 405 may be used to store instructions, programs, code, sets of codes, or sets of instructions. The memory 405 may include a stored program area and a stored data area, wherein the stored program area may store instructions for implementing an operating system, instructions for at least one function (such as a touch function, a sound playing function, an image playing function, etc.), instructions for implementing the various method embodiments described above, and the like; the storage data area may store data and the like referred to in the above respective method embodiments. The memory 405 may alternatively be at least one memory device located remotely from the processor 401 as previously described. As shown in fig. 4, the memory 405, which is a type of computer storage medium, may include therein an operating system, a network communication module, a user interface module, and an application program.
In the computer device 400 shown in fig. 4, the user interface 403 is mainly used as an interface for providing input for a user, and acquiring data input by the user; the processor 401 may be configured to call the application program stored in the memory 405 and specifically execute the method shown in fig. 2, where the specific process may be shown in fig. 2 and is not described herein again.
It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by a computer program, which can be stored in a computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. The storage medium may be a magnetic disk, an optical disk, a read-only memory or a random access memory.
The above disclosure is only for the purpose of illustrating the preferred embodiments of the present application and is not to be construed as limiting the scope of the present application, so that the present application is not limited thereto, and all equivalent variations and modifications can be made to the present application.
Claims (10)
1. A method for auditing assets of a power grid is characterized by comprising the following steps:
collecting power grid asset data; wherein the grid asset data comprises: asset classification standard data, asset card list data, asset value generation detail record data, asset value ledger record data, asset depreciation standard data and asset card change track table data;
auditing the power grid asset data according to a preset auditing rule to obtain an auditing result;
and repairing the record of the failure of the audit.
2. The method of claim 1, wherein auditing the grid asset data according to preset auditing rules to obtain auditing results comprises:
inquiring a depreciation method of the power grid assets in the asset card list data according to asset codes, and inquiring a standard depreciation method of the power grid assets in the asset classification standard data;
comparing whether the depreciation method and the standard depreciation method are the same; and/or
Inquiring the net residual value rate of the power grid assets in the asset card list data according to asset codes, and inquiring the standard net residual value rate of the power grid assets in the asset classification standard data;
comparing whether the net residual value rate and the standard net residual value rate are equal; and/or
Inquiring the service life of the power grid asset in the asset card list data according to the asset code, and inquiring the standard depreciation life of the power grid asset in the asset classification standard data;
comparing whether the age and the standard depreciation age are equal.
3. The method of claim 2, wherein auditing the grid asset data according to preset auditing rules to obtain auditing results, further comprises:
and carrying out asset code repeatability detection on each record included in the asset card request data, and marking the record with repeated asset codes.
4. The method as claimed in claim 2 or 3, wherein the auditing the grid asset data according to a preset auditing rule to obtain an auditing result further comprises:
using the asset code of the power grid asset as an index, inquiring the used month ysyyf and the starting use date kssyrq of the power grid asset in the asset card list data, and acquiring the current date dqrq, and if kssyrq + ysyyf is not equal to dqrqrq, marking the record of the power grid asset as an unqualified record; and/or
Using the asset code of the power grid asset as an index, inquiring the used month ysyyf and the service life synx of the power grid asset in the asset card list data, and if ysyyf is not equal to synx 12, marking the record of the power grid asset as a unqualified record; and/or
Inquiring the cancelled record in the asset card list data by taking the asset code of the power grid asset as an index, then inquiring the record associated with the cancelled record in the asset value standing book data, determining the original value future end amount zcyzmje of the asset and the accumulated depreciation future end amount (ljzjqmje, the depreciation preparation future end amount jzbqmje, and marking the corresponding record in the asset card list data as a unqualified record if the formula zcyzmje is not equal to 0 or ljzjqmje is not equal to 0 or jzbqmje is not equal to 0, and/or marking the corresponding record in the asset card list data as a unqualified record, and/or inquiring the record associated with the cancelled record in the asset value standing book data
Inquiring records of which the service life is 12 and is equal to the used month in the asset card list data by taking the asset code as an index, and then acquiring the original value amount zcyz, the accumulated depreciation amount ljzj, the reduction preparation amount jzzzb and the net residual value rate (jczl) in the inquired records, if the formula is met: and (1-jczl) -ljzj-jzzb ≠ 0, and then the corresponding record in the asset card list data is marked as a unqualified record.
5. The method of claim 1, 2 or 4, wherein the repairing the record that the audit fails comprises:
and repairing the record which is not passed by the audit by utilizing the sql repair script.
6. The method of claim 4, wherein the restoration is performed for each recorded depreciation start month, depreciation continuation month, depreciation end month, remaining depreciation amount, and depreciation amount of a month in the asset card inventory data using the following formula:
depreciation starting month is the current date + 1;
depreciation duration month-age 12-used month;
the depreciation ending month is depreciation starting month + depreciation continuing month;
remaining depreciation amount is original amount (1-net residual rate) -cumulative depreciation amount-reduction preparation amount;
the depreciation amount of the month is the remaining depreciation amount ÷ depreciation duration month.
7. The method of claim 6, wherein the asset card inventory data consists of a plurality of records of grid assets, each record including the following attribute values: asset code, asset name, specification model, asset class, usage status (in use, cancelled, etc.), date of initial use, age, month of used, method of depreciation, net residual rate, billing unit, usage unit, management department, management responsible person, usage department, user, supplier, manufacturer, voltage class, amount of original value, cumulative amount of depreciation, amount of reduction preparation.
8. An auditing apparatus for grid assets, comprising:
the acquisition unit is used for acquiring the asset data of the power grid; wherein the grid asset data comprises: asset classification standard data, asset card list data, asset value generation detail record data, asset value ledger record data, asset depreciation standard data and asset card change track table data;
the auditing unit is used for auditing the power grid asset data according to a preset auditing rule to obtain an auditing result;
and the repairing unit is used for repairing the record which is not passed by the audit.
9. A computer storage medium, characterized in that it stores a plurality of instructions adapted to be loaded by a processor and to perform the method steps according to any one of claims 1 to 7.
10. A computer device, comprising: a processor and a memory; wherein the memory stores a computer program adapted to be loaded by the processor and to perform the method steps of any of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210053510.XA CN114493515A (en) | 2022-01-18 | 2022-01-18 | Power grid asset auditing method and device, storage medium and computer equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210053510.XA CN114493515A (en) | 2022-01-18 | 2022-01-18 | Power grid asset auditing method and device, storage medium and computer equipment |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114493515A true CN114493515A (en) | 2022-05-13 |
Family
ID=81511065
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210053510.XA Pending CN114493515A (en) | 2022-01-18 | 2022-01-18 | Power grid asset auditing method and device, storage medium and computer equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114493515A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116628550A (en) * | 2023-05-23 | 2023-08-22 | 上海发电设备成套设计研究院有限责任公司 | Reliability high-precision prediction method for in-service nuclear power unit and nuclear power turbine |
| CN117474569A (en) * | 2023-12-26 | 2024-01-30 | 深圳市金政软件技术有限公司 | Asset depreciation result calculation method, device and storage medium |
-
2022
- 2022-01-18 CN CN202210053510.XA patent/CN114493515A/en active Pending
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116628550A (en) * | 2023-05-23 | 2023-08-22 | 上海发电设备成套设计研究院有限责任公司 | Reliability high-precision prediction method for in-service nuclear power unit and nuclear power turbine |
| CN116628550B (en) * | 2023-05-23 | 2024-03-12 | 上海发电设备成套设计研究院有限责任公司 | Reliability high-precision prediction method for in-service nuclear power unit and nuclear power turbine |
| CN117474569A (en) * | 2023-12-26 | 2024-01-30 | 深圳市金政软件技术有限公司 | Asset depreciation result calculation method, device and storage medium |
| CN117474569B (en) * | 2023-12-26 | 2024-05-31 | 深圳市金政软件技术有限公司 | Asset depreciation result calculation method, device and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109684369B (en) | Information updating method and device | |
| CN110268409A (en) | The novel nonparametric statistics Activity recognition ecosystem for electric power fraud detection | |
| CN114493515A (en) | Power grid asset auditing method and device, storage medium and computer equipment | |
| CN110738477A (en) | reconciliation method, device, computer equipment and storage medium | |
| US20210124752A1 (en) | System for Data Collection, Aggregation, Storage, Verification and Analytics with User Interface | |
| CN110879808B (en) | Information processing method and device | |
| CN116226166A (en) | Data query method and system based on data source | |
| CN109947797B (en) | Data inspection device and method | |
| CN116992092A (en) | Method and device for establishing flow model, storage medium and terminal equipment | |
| CN114722789B (en) | Data report integrating method, device, electronic equipment and storage medium | |
| CN115130959B (en) | Method, system, terminal and storage medium for generating spare part BOM | |
| CN116011955A (en) | Robot flow automation demand realization method, device, equipment and storage medium | |
| CN112256566B (en) | Fresh-keeping method and device for test cases | |
| CN115481026A (en) | Test case generation method and device, computer equipment and storage medium | |
| CN115391343A (en) | Bill data processing method and device, electronic equipment and storage medium | |
| CN114036174B (en) | Data updating method, device, equipment and storage medium | |
| US20240220997A1 (en) | Computerized-method and real-time information sharing (rtis) platform for maintaining a dynamic knowledge base | |
| CN113888124A (en) | Method and device for generating salary distribution data, storage medium and terminal equipment | |
| CN113888118A (en) | Rule service configuration method and device, storage medium and terminal equipment | |
| CN117829727A (en) | Certificate making method and device for out-in storage business, storage medium and terminal equipment | |
| CN113887945A (en) | Method and device for generating carbon emission report, storage medium and terminal equipment | |
| CN116628079A (en) | Data synchronization method and device for business system, storage medium and computer equipment | |
| Abbasi et al. | In-Depth Analysis of Mobile Apps Statistics: A Study and Development of a Mobile App | |
| CN116109262A (en) | Small and micro enterprise qualification identification method and device based on third party data validity | |
| CN115599376A (en) | Method and device for determining programming interface, computer equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |