CN110825724A

CN110825724A - User charging data exception interception system and method in electricity price system

Info

Publication number: CN110825724A
Application number: CN201910962862.5A
Authority: CN
Inventors: 黎怡均; 罗陆宁; 付婷婷; 韩聪; 林思远; 黄公跃; 孙梦龙; 董佩纯; 王海涛
Original assignee: Shenzhen Power Supply Co ltd
Current assignee: Shenzhen Power Supply Co ltd
Priority date: 2019-10-11
Filing date: 2019-10-11
Publication date: 2020-02-21
Anticipated expiration: 2039-10-11
Also published as: CN110825724B

Abstract

The invention discloses a system and a method for intercepting abnormal user charging data in an electricity price system, wherein the method comprises the following steps: the system acquires user business expansion charging archive data through a data interaction module; judging whether a plurality of power utilization standards exist in the area to which the user belongs according to the area information to which the power utilization address belongs in the user data, and calling until only one power utilization standard exists in the range of the power utilization address; according to the called electricity utilization standard, the system judges whether each item of data in the business expansion charging file of the user is abnormal or not and marks the data; according to different marking states of various data, the system classifies and outputs data in the user business expansion archive data, and displays abnormal data states; the system corrects the data in the abnormal state, simultaneously reminds the administrator to carry out recheck, and updates the data in the database.

Description

User charging data exception interception system and method in electricity price system

Technical Field

The invention belongs to the field of power management, and relates to a user billing data exception interception system and method in an electricity price system.

Background

Whether the electricity charge is accurately calculated or not is directly related to the actual benefits of both the power consumer and the power supply enterprise, and the accurate expansion of the user business and the accurate expansion of the business charging file after the business is changed are necessary preconditions for ensuring the accurate calculation of the electricity charge. The main reasons of abnormal business expansion charging archive data causing increment and stock are the following three aspects: firstly, for a long time, the business extension files and business change file data of users adopt a manual auditing and manual inputting mode, and the mode inevitably causes the situations of error recording and missing recording along with the continuous increase of the number of the users, so that a large number of business extension charging files of the users in the power supply integrated marketing system have the non-standard situation; secondly, along with the adjustment of the national electricity price policy, a large amount of original user file data which accord with the old policy are executed along with the new policy, so that more problems of non-standardization and mismatching of historical leave-behind appear; thirdly, along with the continuous development of the informatization of power supply enterprises, the migration and the change of the data of the power supply information system cause the loss and the disorder of part of the data of the user expansion charging archives. On the one hand, the electricity price system in certain regions may have uniqueness, such as: the special transformer commercial electricity price system is unique throughout the whole country, is different from the provincial, provincial and foreign electricity price system, and has uniqueness; on the other hand, in some areas, the demonstration area is reformed in advance, and after the national policy adjustment and the electric power reformation are performed for multiple times, the complexity of the electricity price system in the same area is improved by multiple times, and the difficulty in accurately identifying the abnormal expansion charging archive data is further increased.

Disclosure of Invention

The technical problem to be solved by the embodiment of the invention is that under the condition that a plurality of power utilization standards exist in the same region, the quality of marketing business expansion charging archive data of a power supply system is improved, the abnormal business expansion charging archive data is accurately, timely and efficiently intercepted, and the power charge error is reduced.

The invention provides a method for intercepting abnormal user charging data in an electricity price system, which comprises the following steps: the method comprises the following steps:

step S1, the system obtains the user business expansion charging archive data through the data interaction module;

step S2, according to the area information of the electricity utilization address in the user data, calling all electricity utilization standards corresponding to the electricity utilization area of the user in the system, judging whether a plurality of electricity utilization standards exist in the area of the user, if so, judging the electricity utilization standard of the minimum range of the electricity utilization address of the user again until only one electricity utilization standard exists in the range of the electricity utilization address, and if not, directly calling;

step S3, according to the called electricity standard, the system judges whether each item of data in the business expansion charging file of the user is abnormal, and marks the data;

step S4, according to different label states of each item of data, the system classifies and outputs the data in the user business expansion archive data, and displays the abnormal data state;

and step S5, the system corrects the data in the abnormal state, reminds the administrator to review and updates the data in the database.

Further, in step S1, the user account expansion billing profile data includes: the system comprises transformer file data, electricity price file data, metering point relation file data, force-adjusted electricity charge file data, special electricity price file data, business change first charging file data and business work order type file data.

Further, in step S3, the specific determination process of the power consumption standard on the power dispatching fee archive data includes:

the capacity of the transformer is more than or equal to 100, no power regulation is carried out, abnormal data are judged when the capacity of the transformer meets the following standards, and normal data are judged when the capacity of the transformer does not meet the following standards: the rated capacity of the associated transformer at the current stage of the metering point is more than or equal to the contract capacity reference value, the current stage of the metering point is a private substation, the current price of the metering point is not the electricity price of residents, the power factor standard of the current stage of the metering point is not checked, the current price code of the current stage of the metering point does not contain electricity price parameters, the current stage of the user is not a co-variant associated substation, and the current stage of the metering point has no total score relation;

the low-voltage user executes the power adjustment, and if the following criteria are met simultaneously, the abnormal data is judged, and if the following criteria are not met simultaneously, the normal data is judged: the current period of the metering point is a value obtained by a public transformer user and a power factor standard of the current period of the metering point, and the current price code of the current period of the metering point is not equal to the non-current price;

and (3) the resident wrongly checks the nuclear power tone, if the two following standards are met simultaneously, the resident is judged to be abnormal data, and if the two standards are not met simultaneously, the resident is judged to be normal data: the electricity price of the current period of the metering point belongs to the electricity price of residents, and the power factor of the current period of the metering point is assessed;

when the capacity of a user is smaller than 100KW but has a strong tone standard, the user is judged to be abnormal data when the following standards are simultaneously met, and if the standards are not met simultaneously, the user is judged to be normal data: the rated capacity sum of the relevant transformers at the current period of the metering point is smaller than the reference value of the common power utilization capacity, the power factor at the current period of the metering point is set to be examined, the total score relation does not exist at the current period of the metering point, the self-backup transformation relation does not exist at the current period of the metering point, and the electricity price code at the current period of the metering point is not equal to the electricity price.

Further, in step S3, the specific determination process of the electricity price profile data in the electricity usage standard includes:

when the quantitative scaling table resident does not allow time sharing, the data is judged to be abnormal data when the following standards are simultaneously met, and normal data is judged if at least one of the standards is not met: the current period of the metering point is a quantitative fixed ratio, the type of electricity consumption of the current period of the metering point is residential life electricity consumption, the current period of the metering point is time-sharing charging, and the electricity price code of the current period of the metering point is available electricity price;

and partially stopping the user who executes the demand charging, judging as abnormal data when the user simultaneously meets the following standards, and judging as normal data if at least one of the standards is not met: the measurement point current period is to calculate the basic electricity charge, the partial associated transformer of the measurement point current period is stopped, and the electricity price code of the measurement point current period has electricity price according to the maximum demand;

and judging abnormal data when the large amount of electricity prices meet one of the following two standards according to the maximum demand or the high demand electricity prices meet the capacity of the transformer, and judging normal data if the large amount of electricity prices do not meet the two standards: the method comprises the steps that high electricity demand rates are executed in a metering point current period, basic electricity charges are calculated according to transformer capacity in the metering point current period, a large amount of electricity charges are executed in the metering point current period, and the basic electricity charges are calculated according to the maximum demand in the metering point current period;

the low-supply and low-count user electricity price is 1KV to 10KV and above, when the following standards are simultaneously met, abnormal data are judged, if at least one of the following standards is not met, normal data are judged: the metering mode of the metering point at the current period is low power supply and low metering, the voltage grade of the electricity price at the current period of the metering point is more than or equal to 1KV to 10KV, the type of the electricity consumption at the current period of the metering point is not agricultural production, the electricity price at the current period of the metering point does not belong to the electricity price of tap water, the type of the electricity consumption at the current period of the metering point is not agricultural irrigation, the type of the electricity consumption at the current period of the metering point is not residential life electricity, and the electricity price code at the current period of;

when the non-time-sharing electricity price does not allow time sharing, the abnormal data is judged when the following standards are simultaneously met, and if at least one of the following standards is not met, the normal data is judged: the electricity price of the current period of the metering point is non-time-sharing, the current period of the metering point is time-sharing charging, and the electricity price code of the current period of the metering point has electricity price;

time-of-use electricity price but not time-of-use charging, if the following standards are met at the same time, the abnormal data is judged, if at least one of the following standards is not met, the normal data is judged, wherein the current period of the metering point is non-time-of-use charging, the current period of the metering point is time-of-use electricity price, the current period industry classification code of the metering point is not the generation and supply of tap water, the current period of the metering point has electricity price, the current period of the metering point is not a local power plant user in user category, and the current period of the user is not a special flat-section electricity price user;

the non-main metering point of the high-demand user is provided with a demand check value, when the following standards are met, abnormal data is judged, if at least one standard is not met, normal data is judged, wherein the current period of the metering point is a special transformer, the current period of the metering point executes high demand electricity price, the current period of the metering point has a large quantity of high demand segmentation relations, the current period of the metering point is a sub-metering point, the demand check value of the current period of the metering point is more than 0, and the electricity price code of the current period of the metering point has electricity price;

the common industry does not charge according to time-sharing, if the common industry meets the following standards, the common industry is judged to be abnormal data, if at least one of the standards is not met, the common industry is judged to be normal data, the type of the electricity consumption of the current period of the metering point is common industry, the non-time-sharing charging of the current period of the metering point is carried out, the voltage grade of the electricity price of the current period of the metering point is 1KV to 10KV, and the electricity price of the electricity price code of the current period of the metering point;

the normal electricity price is not matched with the capacity, when the following standards are met, abnormal data is judged, if at least one of the following standards is not met, normal data is judged, namely the rated capacity and the reference value of the associated transformer are operated at the current period of the metering point, the electricity price name of the current period of the metering point contains normal data, the electricity price voltage grade of the current period of the metering point is less than or equal to 35 kilovolts, the current period of the user is not a co-variation associated user, and the current period of the metering point has no total distribution relation;

the user is wrongly filled as a user without electricity price, abnormal data is judged when the user meets the following standards, and normal data is judged if at least one of the data is not met, wherein the user state at the current stage of the metering point is running, the electricity utilization type at the current stage of the metering point is not other electricity utilization, the use code at the current stage of the metering point is not an examination table, and the electricity price code at the current stage of the metering point is no electricity price;

the user is judged to be abnormal data when the requirement value meets the following standards, and is judged to be normal data if at least one of the following standards is not met, wherein the basic electricity charge is calculated according to the maximum requirement in the metering point current period, the requirement value in the metering point current period is not the requirement value in the metering point current period, and the electricity price is provided by the electricity price code in the metering point current period;

the basic electricity charge calculation modes of the main metering point and the sub metering points are inconsistent, abnormal data is judged when the two standards are met, and normal data is judged when at least one standard is not met, wherein the number of the relation of the metering points in the current period is larger than zero, and the basic electricity charge calculation modes of the metering points in the current period and the related metering points are inconsistent.

Further, in step S3, the specific determination process of the transformer profile data in the power consumption standard includes:

the charging capacity of the transformer is not consistent with the rated capacity, when the charging capacity of the operation associated transformer at the current period of the metering point is met and is not equal to the sum of the rated capacities of the operation associated transformers at the current period of the metering point, abnormal data is judged, and if the charging capacity of the operation associated transformer is equal to the sum of the rated capacities of the operation associated transformers at the current period of the metering point, normal data;

the transformer is not associated to any metering point, when the metering point which is not associated with the associated transformer exists in the current period of the user, the abnormal data is judged, and if the metering point which is not associated with the associated transformer does not exist, the normal data is judged;

the running days of the transformer are more than the charging days of the metering point, when the running days of the relevant transformer in the current period of the metering point are more than the recording charging days, abnormal data are judged, and if the running days of the relevant transformer in the current period of the metering point are not more than the recording charging days, normal data are judged;

if the common-variant related user simultaneously meets the following labels, judging the common-variant related user as abnormal data, and if at least one of the labels is not met, judging the common-variant related user as normal data: the current period of the metering point has a total point relation, the metering points do not belong to the same household and the current period electricity price code of the metering point is electricity price;

when the screening of the special transformer common user meets the following two labels, judging the special transformer common user to be abnormal data, and if at least one of the labels is not met, judging the special transformer common user to be normal data: the power supply mode of the user in the current period is to share the special transformer for power supply, and the price code of the electricity in the current period is measured to be the price of the electricity.

Further, in step S3, the specific determination process of the metering point relationship profile data in the electricity consumption standard includes:

the meter reading time intervals are overlapped, when the meter reading date of the current period of the metering point is earlier than the meter reading date of the last period of the metering point, the abnormal data is judged, and if the meter reading date of the current period of the metering point is not earlier than the meter reading date of the last period of the metering point, the normal data is judged;

the total-score relation users share the self-contained variable relation, when the total-score relation users simultaneously meet the following standards, abnormal data is judged, and if at least one of the following standards is not met, normal data is judged: the current period of the metering point is not a public transformer, the current period of the metering point is provided with a father metering point, the father metering point of the metering point is not a public transformer, meanwhile, the current period of the metering point is not in a shared self-contained variable relation, the current period of the metering point is not a quantitative fixed ratio table or the current period of the metering point is provided with a child metering point, the current period of the metering point is not a public transformer, the current period of the metering point is not in a non-quantitative fixed ratio child metering point, the shared self-contained variable relation is not realized, the current period total sub-relation metering point of the metering point is not the same household, and the current period electricity price code of the metering point is provided with electricity price.

Further, in step S3, the specific determination process of the service change primary charging profile data in the electricity usage standard includes:

if the current period of the metering point is the first time of metering after the non-permanent volume reduction is filed through the non-periodic process, judging the data to be abnormal, and if not, judging the data to be normal;

charging for the first time after filing by changing the table, judging abnormal data when the two standards are met, and judging normal data if at least one standard is not met: the metering point date is a special transformer and a metering point date switching table;

recovering the first charging after filing, if the current period of the metering point is the first charging after recovering the non-periodic flow filing, judging the metering point to be abnormal data, and if not, judging the metering point to be normal data;

charging for the first time after the new filing, judging as abnormal data when the two standards are met, and judging as normal data if at least one standard is not met: when the measuring point is a special transformer household and the measuring point is a new household;

if the current period of the metering point is the first time of the metering after the non-periodic flow archiving after the suspension, judging the metering point to be abnormal data, and if not, judging the metering point to be normal data;

and (4) carrying out first charging after increasing and decreasing the volume and filing, if the current period of a metering point is the first charging after the non-periodic flow filing after increasing or decreasing the volume, judging the data to be abnormal data, and if not, judging the data to be normal data.

Further, in step S3, the specific determination process of the business work order class archive data in the electricity consumption standard includes:

during the charging period, a classification work order is effective, when the following standards are met, abnormal data is judged, and if at least one standard is not met, normal data is judged: the current-period electricity price code of the metering point has electricity price;

and (3) changing the list of the work orders, judging abnormal data when the following standards are met, and judging normal data if at least one of the standards is not met: the user has a work order for class change on the way or a charging work order is empty at the current period of the metering point, the service class is changed, and meanwhile, a metering point change record which does not correspond to the table change information record is not available, and the electricity price code at the current period of the metering point is the electricity price;

if the unarchived work orders exist, if the unarchived work orders simultaneously meet the following standards, the unarchived work orders are judged to be abnormal data, and if at least one of the unarchived work orders does not meet the following standards, the unarchived work orders are judged to be normal data: the current-period work order state of the user is not the filed work order, the current-period business expansion on-route work order of the metering point is the represented number recording link, and the current-period electricity price code of the metering point is the electricity price.

Further, in step S5, the data modification is specifically that the system displays the user with the abnormal mark according to the user number, the warning information, and the user profile, and sets to lock the data, after the system administrator checks the modification to confirm that the data is correct, the system administrator sorts and unlocks the abnormal lock data according to the difference between the user, the meter reading section, and the power supply unit, and after the abnormal check lock is released, the user electricity charge data with the abnormal mark is issued with normal electricity charge.

The embodiment of the invention also provides a system for intercepting the abnormal user charging data in the electricity price system, which is used for realizing the method, and the system comprises the following components:

the data interaction module is used for identifying and acquiring the data from the database of the marketing system through a data interface or recording related data in real time;

the temporary storage and execution module is used for storing temporary data, and adopts a centralized storage or distributed storage method as original data to be input into the user business expansion charging file abnormal data checking and intercepting system in the marketing system for processing;

the business expansion billing archive data anomaly checking and intercepting module is used for carrying out deep analysis and logic comparison on different electricity price setting preconditions and electricity price calculation logics in relevant electricity price standards, electricity price execution specifications and execution policies, and displaying the abnormal rule names in a warning information mode for checking assistance after the abnormal business expansion archive data of a user is blocked by the module;

the file abnormity checking locking and unlocking module is used for automatically locking the abnormal user data function, checking, correcting and unlocking the abnormal data and performing closed-loop management on the correction of the abnormal business expansion data;

and the foreground display module is used for displaying the abnormal interception warning prompt information, the basic user information, the service change information, the electric charge settlement information, the metering point relation information, the last-period electric quantity and electric charge comparison information and the abnormal checking locking information in the system.

Further, the business expansion charging archive data exception checking interception module comprises:

the transformer file abnormity checking module is used for carrying out abnormity judgment on the transformer file data acquired by the data interaction module according to the power utilization standard;

the electricity price file abnormity checking module is used for carrying out abnormity judgment on the electricity price file data acquired by the data interaction module according to the electricity utilization standard;

the measuring point relation archive abnormity checking module is used for carrying out abnormity judgment on the measuring point relation archive data acquired by the data interaction module according to the power utilization standard;

the power regulation and power charge archive abnormity checking module is used for carrying out abnormity judgment on the power regulation and power charge archive data acquired by the data interaction module according to a power utilization standard;

the special electricity price file abnormity checking module is used for carrying out abnormity judgment on the special electricity price file data acquired by the data interaction module according to the electricity utilization standard;

the service change first charging file abnormity checking module is used for carrying out abnormity judgment on the service change first charging file data acquired by the data interaction module according to the power utilization standard;

and the business work order type file abnormity checking module is used for judging the abnormity of the business work order type file data acquired by the data interaction module according to the power utilization standard.

The embodiment of the invention has the following beneficial effects:

according to the abnormal interception system and method for the user charging data in the electricity price system, provided by the embodiment of the invention, the accurate and comprehensive abnormal data checking interception rule algorithm is adopted, the full amount of users are checked one by one in each electricity charge calculation period according to the process, standardization and automation order, and the accurate user data passing the check can normally enter the next process through the periodical iterative check, so that the quality of the basic data of the users is effectively improved, and the accuracy of the electricity charge calculation is improved;

the invention realizes a closed-loop management system of full-process user business expansion data automatic checking, interception, warning, locking and checking unlocking, and enhances the business expansion data management automation, intelligentization level and electric charge management level of power supply enterprises.

The method has good expansibility, key parameter thresholds are determined in most abnormal rule sentences, and the high efficiency of the system is further improved by continuously optimizing and adjusting the key parameters; the rules can be added, deleted, modified and updated according to the updating requirements of different electricity price policy systems, and the judgment rules have good growth performance and reliability.

Drawings

In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is within the scope of the present invention for those skilled in the art to obtain other drawings based on the drawings without inventive exercise.

Fig. 1 is a schematic main flow diagram of a method for intercepting abnormal user billing data in an electricity price system according to the present invention.

Fig. 2 is a schematic flow chart of a method for intercepting abnormal user billing data in an electricity price system according to the present invention.

Fig. 3 is an architecture diagram of an abnormal interception system for user billing data in an electricity price system according to the present invention.

Detailed Description

In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention will be described in further detail with reference to the accompanying drawings.

As shown in fig. 1 and fig. 2, in an embodiment of the present invention, a method for intercepting abnormal user billing data in an electricity price system is provided, including:

in a specific embodiment, the user business expansion charging profile data includes: the system comprises transformer file data, electricity price file data, metering point relation file data, force-adjusted electricity charge file data, special electricity price file data, business change first charging file data and business work order type file data.

Firstly, with a user number as a unique value, a user billing data exception intercepting system in an electricity price system extracts user business expansion billing archive data from a power supply marketing system, the marketing system can be regarded as a database containing all user information, the system and the marketing system are provided with a direct butt joint interface, so that the required user business expansion billing archive data information can be obtained from the database, including but not limited to electricity consumption client basic information, electricity consumption client information, a three-user model, special subject information, metering point basic information and billing related information in the marketing system, and the extracted user business expansion billing archive data is ensured to be effective and correct.

In the specific implementation, the following specific information is involved:

and (4) user numbering: in order to facilitate searching and management, the user is numbered, and the number becomes a mark for uniquely identifying the user;

the user name is as follows: name names, which are often personal, company or other related names, left when a user registers and opens an account;

the electricity utilization type: the power grid company classifies the users according to the electricity consumption properties of the users, the users are common public transformer customers, the users use a public transformer belonging to the property rights of power supply enterprises to supply power, the resident living power consumption is the vast majority of the customers specially changed for public lines, the users use the property rights belonging to the power supply enterprise lines to supply power to the transformer of the users, the users contain large power consumption users such as industrial and commercial users, special line special change customers, the users use the property rights belonging to the lines of the users and the transformer to supply power, and the users mainly belong to the customers with large power consumption for industrial and commercial, local power plant users and station area appraisal users;

rated capacity of the transformer: a basic parameter of the transformer refers to the maximum capacity which can be continuously output during the specified normal service life, and the conventional value of the apparent power under the main connection can be marked on a name plate of the transformer when the transformer leaves a factory;

contract capacity: the total capacity of the user powered equipment permitted by the power supply department and in the power supply and utilization contract is generally less than or equal to the maximum sum of the capacities of the access transformers;

voltage class: the voltage class is a rated voltage class series of a power system and power equipment, and is generally divided into low voltage (220V or 380V), high voltage (10kV-220kV) and ultrahigh voltage (330kV-750 kV);

the metering mode is as follows: the electric energy metering device is a metering and mounting mode of the electric energy metering device and is divided into a high-supply meter (a metering mode that the voltage of a set point of the electric energy metering device is consistent with the power supply voltage and is more than 10 or 6 kV), a high-supply low-supply meter (a metering mode that the voltage of the set point of the electric energy metering device is lower than the power supply voltage of a user), and a low-supply meter (a metering mode that the voltage of the set point of the electric energy metering device is consistent with the power supply voltage of the user, for example, most residential electricity is low-supply low.

And (3) metering points: the method comprises the steps that the position for installing a metering device is indicated, and metering points are divided into an electric power customer charging point and a gateway metering point;

metering point relationship: the system comprises a main-standby relation, a large number of high-demand segmentation relations, a cross-user total score, a shared self-contained relation and a main-sub metering, and is a combined form made for accurate charging and special field conditions of metering points;

metering point use: the system mainly comprises a reference meter for measuring line loss and line load without calculating electric charge, a general charging meter for measuring electric energy consumption as a basis for settling the electric charge;

electricity consumption type of metering points: based on the second-level classification under the large class of the power utilization categories, general industrial and commercial, residential life, large-scale industrial power utilization, commercial, agricultural irrigation and local power plant households exist;

electric quantity calculation mode: metering and scaling by meter, settling accounts according to a certain proportion of the total electric quantity, and quantifying, wherein the settlement accounts according to a fixed electric quantity each time;

quantitative ratio determination: agreeing with a fixed electric quantity settlement value well noted in a contract with a user;

electricity price: the method is totally called as selling electricity price, and refers to the price of electricity sold by a power grid management enterprise to a terminal user, wherein the selling electricity price is subjected to government pricing, unified policy and graded management, and the pricing mode comprises two electricity price making modes and a single electricity price making mode;

basic electric charge calculation mode: the basic electricity charge charging modes of the transformer in the two electricity price charging modes are three modes according to the maximum demand, the transformer capacity and the actual maximum demand respectively;

and (3) requirement checking value: the method is characterized in that the method is the maximum demand which can be used by a user and is agreed according to a protocol, if the actual maximum demand of the user exceeds a check value by 5%, the basic electricity fee which exceeds 5% is charged by 1 time;

maximum demand: the method comprises the steps of measuring the average power of customer electricity consumption in a certain period of time within a certain settlement period, and reserving the maximum primary indicated value as the maximum demand of the settlement period;

the power factor assessment mode comprises the following steps: the method comprises two modes of standard examination and non-examination;

power factor standard: the power factor adjusting electricity charge standard is divided into three types of assessment standards of 0.8, 0.85 and 0.9, and the power factor adjusting electricity charge standard is a document 'power factor adjusting method' issued by the ministry of original profit and electric power and the national property and price bureau in 1983;

loss-variable charging flag: whether the two types are yes or no is judged;

loss change: the total loss is called as transformer loss, which is the sum of no-load loss Po, short-circuit loss Pk and stray loss Ps, and the running transformer can also consume a certain amount of electric energy;

the running days of the transformer are as follows: for calculating important parameters of basic point charge, the operation days of the transformer is generally charged by 30 days per month, and the basic electricity charge of the transformer is converted and charged according to the operation days if the operation days are not the whole month;

basic electric charge sharing mode: the method comprises the following steps of (1) carrying out proportion allocation without charging, proportion value allocation, capacity proportion allocation and fixed value allocation, and is an important parameter for calculating basic electricity and time;

a work order: the work list in the business process comprises new installation, modification, passing, capacity increase, capacity reduction, table change, suspension, recovery, non-permanent capacity reduction, non-periodic charging and sale of a user/transformer;

periodic charging and non-periodic charging: the normal period charging is to carry out electric charge settlement according to one month in a period, and the non-whole-month electric charge settlement is called non-periodic charging;

co-transformation: the method is characterized in that a plurality of users share one or more transformers, most stock users are left due to historical reasons, and the existing policy does not allow new co-variant users to appear;

the power supply mode comprises the following steps: the power supply system is generally provided with four modes of public line special transformer power supply, special line special transformer power supply, shared special transformer power supply and public transformer power supply.

in a specific embodiment, the specific determination process of the power consumption standard a on the power dispatching fee archive data includes:

Specifically, the specific judgment process of the electricity price archive data in the electricity consumption standard a includes:

Specifically, the specific judgment process of the transformer archive data in the electricity utilization standard a includes:

Specifically, the specific judgment process of the metering point relation archive data in the electricity utilization standard a includes:

Specifically, the specific judgment process of the special electricity price archive data in the electricity consumption standard a includes:

if the user is the charging pile user in the current period, judging the charging pile user to be abnormal data, and if the user is not the charging pile user, judging the charging pile user to be normal data;

if the measuring point date is a quantitative table, the quantitative user is judged to be abnormal data, and if not, the quantitative user is judged to be normal data.

Specifically, the specific determination process of the service change first charging archive data in the electricity utilization standard a includes:

Specifically, the specific judgment process of the business work order type archive data in the electricity consumption standard a includes:

In a further embodiment of the method according to the invention,

specifically, the specific judgment process for the transformer file abnormity checking in the electricity utilization standard B includes:

if the large-scale industrial user has a pause transformer, judging the data to be abnormal when the pause transformer meets the following standards, and judging the data to be normal when at least one of the standards is not met: the current-period existing state of the user is a suspended associated transformer, the current-period electricity utilization category of the user is large industry, and the current-period electricity price code of the metering point is available electricity price;

the sum of the charge capacity of the metering points of the special transformer is inconsistent with the sum of the capacity of the transformer, abnormal data is judged when the following standards are simultaneously met, and normal data is judged if at least one of the standards is not met: the current period of the user is a special transformer user, the current power utilization category of the user is large industry, and the rated capacity of the transformer and the charging capacity of the metering point are related when the user operates in the current period and are inconsistent;

the sum of the charge capacity of the metering points of the special transformer is inconsistent with the sum of the capacity of the transformer, abnormal data is judged when the following standards are simultaneously met, and normal data is judged if at least one of the standards is not met: the user in the current period is a special transformer, the power utilization category of the user in the current period is large industry, the rated capacity of the transformer is operated and related to the rated capacity of the user in the current period, the charging capacity of the transformer is inconsistent with the charging capacity of the metering point, and the basic power charge is calculated according to the capacity of the transformer in the current period of the metering point;

screening the exclusive transformer common users, and judging as abnormal data when the following criteria are met, and judging as normal data if at least one criterion is not met: the power supply mode of the user in the current period is that the special transformer is used for supplying power, and the price code of the electricity in the current period is measured to be the price of the electricity;

specifically, the specific judgment process for checking the abnormal electricity price file in the electricity utilization standard B includes:

and partially stopping the user who executes the demand charging, and judging as abnormal data when the following standards are simultaneously met, and judging as normal data if at least one of the standards is not met: the type of electricity used at the current period of the metering point is large industry, the basic electricity fee is calculated according to the maximum demand at the current period of the metering point, the partial associated transformer of the current period of the user is stopped, and the electricity price code at the current period of the metering point is available;

when the quantitative scaling table does not allow time sharing, the abnormal data is judged when the following standards are simultaneously met, and if at least one of the standards is not met, the normal data is judged: the current period of the metering point is a quantitative fixed ratio meter, the current period electricity utilization category of the metering point is the life of residents, the current period time-sharing charging of the metering point is carried out, and the current period electricity price code of the metering point is the available electricity price;

when the electricity price of the sewage is executed, if the following standards are simultaneously met, the abnormal data is judged, if at least one of the standards is not met, the normal data is judged: the contract capacity of the user at the current period is more than or equal to the contract capacity reference value, the electricity price at the current period of the metering point is a private transformer, the electricity price at the current period of the metering point is not the resident electricity price, the electricity price at the current period of the metering point is not the electricity price of the meter, the power factor standard at the current period of the metering point is not in accordance with the power factor standard of the associated transformer, and the electricity price code at the current period of the metering point is the electricity price;

and (4) checking the electricity price, judging as abnormal data when the following standards are simultaneously met, and judging as normal data if at least one of the standards is not met: the current metering mode of the metering point is high power supply metering or high power supply low metering, the current electricity price voltage grade of the metering point is less than 1KV, the current electricity utilization category of the metering point is not agricultural production, the current electricity utilization category of the metering point is not agricultural irrigation, the current electricity utilization category of the metering point is not resident life, the current electricity price of the metering point is not the electricity price of the urban and rural middle and primary schools, and the current electricity price code of the metering point is not no electricity price;

the industrial electricity price is abnormal, when the following standards are simultaneously met, abnormal data is judged, if at least one of the following standards is not met, normal data is judged: the rated capacity sum of the associated transformer is more than or equal to the capacity and the reference value when the user operates at the current period, the electricity consumption type of the electricity price at the current period of the metering point is common industry, and the voltage grade of the electricity price at the current period of the metering point is less than or equal to 35 KV;

the user in the area B selects the electricity price in the area A by mistake, when the electricity price at the current period of the metering point is the electricity price in the area A, the data is judged to be abnormal, and if the electricity price at the current period of the metering point is the electricity price in the area B, the data is judged to be normal;

the common industry does not charge according to time-sharing, the electricity utilization type of the metering point at the current period is the common industry, the non-time-sharing charging of the metering point at the current period is realized, the voltage grade of the electricity price of the metering point at the current period is 1KV to 10KV, and the electricity price code of the metering point at the current period is the electricity price;

and (3) time-sharing errors, namely judging abnormal data when the following standards are simultaneously met, and judging normal data if at least one of the standards is not met: the time-sharing charging at the current period of the metering point, the non-time-sharing electricity price at the current period of the metering point and the available electricity price code at the current period of the metering point are carried out;

the user is judged to be abnormal data when the requirement value changes and the following standards are simultaneously met, and is judged to be normal data when at least one of the following standards is not met: calculating basic electricity charge according to the maximum demand in the current period of the metering point, wherein the demand check value in the current period of the metering point is not equal to the demand check value in the current period of the metering point, and the electricity price code in the current period of the metering point is the available electricity price;

the user profile of the resident time-sharing table is abnormal, if the user profile meets the following criteria, the user profile is judged to be abnormal data, if at least one criterion is not met, the user profile is judged to be normal data: the current electricity utilization category of the metering point is resident life, the current period of the metering point is a time-sharing charging or metering point is a time-sharing meter, the current period of the metering point is a non-time-sharing charging or the current period of the metering point is not a time-sharing meter, and the current electricity price code of the metering point is available electricity price;

the low-supply and low-count user electricity price is 1KV to 10KV and above, when the following standards are simultaneously met, abnormal data are judged, if at least one of the following standards is not met, normal data are judged: the metering mode of the metering point at the current period is low supply and low metering, the voltage grade of the electricity price at the current period of the metering point is more than or equal to 1KV to 10KV, the type of the electricity consumption at the current period of the metering point is not agricultural production, the type of the electricity price at the current period of the metering point does not belong to the electricity price of tap water, the type of the electricity consumption at the current period of the metering point is not agricultural irrigation, the type of the electricity consumption at the current period of the metering point is not resident life, and the code of the electricity price at the current;

the user is filled with no price by mistake, when the following standards are met, the abnormal data is judged, if at least one of the following standards is not met, the normal data is judged: the user state of the metering point at the current period is running, the type of the electricity utilization of the metering point at the current period is not other electricity utilization, the usage code of the metering point at the current period is not an examination table, and the electricity price code of the metering point at the current period is no electricity price.

Specifically, the specific determination process of the charging parameter archive data in the electricity utilization standard B includes:

the large-industry charging parameters are abnormal, when the following standards are met, the abnormal data are judged, if at least one of the following standards is not met, the normal data are judged: the current-stage electricity utilization category of the metering point is large industry, the current-stage electricity utilization category of the metering point does not calculate basic electricity charge or the current-stage non-timing electricity charge of the metering point is time-sharing, the current-stage industry classification code of the metering point is not the generation and supply of tap water, the current-stage industry classification code of the metering point is not sewage treatment and recycling, and the current-stage electricity price code of the metering point is electricity price;

the loss variation parameter is abnormal, when the following standards are simultaneously satisfied, abnormal data is judged, if at least one of the following standards is not satisfied, normal data is judged: the measurement mode of the measurement point at the current period is high supply and low supply, the measurement point has no father measurement point at the current period or the measurement mode of the father measurement point at the current period of the measurement point is not high supply and high supply, the variation loss is calculated at the current period of the measurement point, the electricity price code at the current period of the measurement point is electricity price, the variation loss parameter of the relevant transformer at the current period of the measurement point is abnormal or the variation loss at the current period of the measurement point is not charged.

Specifically, the specific judgment process of the metering point relationship archive data in the electricity utilization standard B includes:

the total score relation users lack the sharing of the self-contained relation, when the following standards are met at the same time, abnormal data is judged, if at least one of the following standards is not met, normal data is judged: the current period of the metering point is not a public transformer, the current period of the metering point has a father metering point, the current period of the metering point has no public transformer, the current period of the metering point has no sharing self-backup transformation relation, the current period of the metering point has no quantitative fixed ratio table or the current period of the metering point has a child metering point, the current period of the metering point has no public transformer, the current period of the metering point has no sharing self-backup transformation relation with the current period of the non-quantitative fixed ratio child metering point, the current period of the metering point has no same family, and the current period of the metering point has a power price code;

the meter reading periods of the total users are not consistent, abnormal data is judged when the total users simultaneously meet the following standards, and normal data is judged if at least one standard is not met: the current period of the metering point is provided with a sub-metering point, the current period of the metering point is inconsistent with the meter reading period of the sub-metering point, and the current period of the metering point is provided with a power price code.

Specifically, the specific judgment process of the power dispatching electric charge archive data in the electricity utilization standard B includes:

the force rate of the metering point is inconsistent with the force regulation of the transformer, abnormal data is judged when the force rate of the metering point and the force regulation of the transformer meet the following standards, and normal data is judged if at least one of the following standards is not met: the contract capacity of the user at the current period is more than or equal to the contract capacity reference value, the electricity price at the current period of the metering point is a private transformer, the electricity price at the current period of the metering point is not the resident electricity price, the electricity price at the current period of the metering point is not the electricity price of the meter, the power factor standard at the current period of the metering point is not in accordance with the power factor standard of the associated transformer, and the electricity price code at the current period of the metering point is the electricity price;

if the checking and non-reactive table exists, if the following standards are met, the abnormal data is judged, and if at least one of the standards is not met, the normal data is judged: the current period of the metering point is not provided with a father metering point, the current period of the metering point is not a quantitative scaling table, the current period of the metering point is examined for power factors, the current period of the metering point is not provided with a wattless table, and the current period of the metering point is provided with a power price code;

when the capacity of the transformer is more than 100, no power regulation is carried out, abnormal data is judged when the following standards are simultaneously met, and normal data is judged if at least one of the standards is not met: the contract capacity of the user at the current period is more than or equal to the contract capacity reference value, the electricity price at the current period of the metering point is a private substation, the electricity price at the current period of the metering point is not the electricity price of residents, the electricity price at the current period of the metering point is not the electricity price of the meter, the power factor standard at the current period of the metering point is not checked, and the electricity price code at the current period of the metering point is the electricity price;

the power assessment factor is set to be abnormal, when the following standards are simultaneously met, abnormal data is judged, if at least one of the following standards is not met, normal data is judged: the current-stage metering mode of the metering point is high-power supply high-metering or the current-stage metering mode of the metering point is high-power supply low-metering or the current-stage metering mode of the metering point is low-power supply low-metering, a reactive power meter of the metering point is provided at the current stage, the current-stage contract capacity of a user is larger than or equal to a contract capacity reference value, the current-stage electricity utilization type of the metering point is not resident life, the current-stage electricity utilization type of the metering point is not non-industrial, the current-stage power factor standard of the metering point is a non-neutral value, and the current-stage electricity price code of the metering point is electricity price;

the low-voltage user executes a force rate of 0.9, and when the following criteria are simultaneously met, abnormal data is judged, and if at least one criterion is not met, normal data is judged: the current period of the metering point is a public transformer, the power factor standard of the current period of the metering point is an assessment standard of 0.90, and the current price code of the current period of the metering point is the available price.

Specifically, the specific judgment process of the business work order type archive data in the electricity consumption standard B includes:

if the appraiser has unarchived worksheets, judging the data to be abnormal when the appraiser meets the following standards, and judging the data to be normal if at least one of the standards is not met: the application code of the measuring point at the current period is an examination and check table, the work order state of the user at the current period is not a filed work order, and the number of expressed work orders of the business expansion at the current period of the measuring point is recorded;

the table-cutting work order is not effective, when the following standards are met, the abnormal data is judged, and if at least one of the following standards is not met, the normal data is judged: the current period of the metering point is provided with a transit stop work sheet or the current period of the metering point is provided with a metering point change record with a charging work sheet being empty and a sectional charging mark being 1, and the current price code of the current period of the metering point is the current price;

the classification work order is not effective, when the following standards are met, abnormal data is judged, and if at least one of the following standards is not met, normal data is judged: the user has a class-on-the-way work order in the current period or a metering point has a metering point change record with a charging work order in the current period and a service class of the metering point being changed, and the electricity price code of the metering point in the current period is the electricity price;

and (3) changing the list of the work orders, judging abnormal data when the following standards are met, and judging normal data if at least one of the standards is not met: the user has a work order for class change on the way in the current period or a charging work order is empty in the current period of the metering point, the service class is changed and no metering point change record corresponding to the table change information record exists, and the electricity price code of the metering point in the current period is the electricity price;

if the unarchived work orders exist, if the unarchived work orders simultaneously meet the following standards, the unarchived work orders are judged to be abnormal data, and if at least one of the unarchived work orders does not meet the following standards, the unarchived work orders are judged to be normal data: the current-period work order state of the user is not a filed work order, the current-period business expansion on-route work order of the metering point is a representation number input link, and the current-period electricity price code of the metering point is electricity price;

when a large-scale industrial user has a pause or pause and resume the effective service, if the following standards are simultaneously met, the data is judged to be abnormal data, and if at least one of the following standards is not met, the data is judged to be normal data: the current-period electricity utilization category of the user is large industry, the current-period existing state of the user is a related transformer which is suspended or suspended and recovered, and the current-period electricity price code of the metering point is available electricity price;

the user with abnormal sales is judged to be abnormal data when the following standards are simultaneously met, and is judged to be normal data if at least one of the following standards is not met: the user has a work order of the user on the way in the current period or the total electricity charge of the user in the current period is not zero, the user state in the current period is the user sales, the date of the user sales in the current period is not null, and the electricity price code in the current period of the metering point is the electricity price;

if the high-voltage pause service exists in the last month, judging the data to be abnormal when the following standards are simultaneously met, and judging the data to be normal when at least one of the standards is not met: the related transformer information of which the existing state at the upper stage of the metering point is high-voltage pause and the electricity price code at the current stage of the metering point are electricity prices;

during the charging period, a classification work order is effective, when the following standards are met, abnormal data is judged, and if at least one standard is not met, normal data is judged: the metering point changes the record if the charging work list is not empty and the service type is changed, and the electricity price code of the metering point is the electricity price;

if the work order exists, the abnormal data is judged when the following standards are met, and if at least one of the standards is not met, the normal data is judged: the current period of the metering point is provided with a work order, and the current price code of the metering point is provided with electricity price.

Step S4, according to different mark states of each item of data, including abnormal marks and normal marks, the system classifies and outputs data in the user business expansion archive data to the archive abnormal check locking and unlocking module for locking according to the marks, further inputs the data to the database for storage, and simultaneously outputs the data in the abnormal data state to the foreground display module for display;

the system adopts the fool-proof and error-proof measures for manual processing, reduces the possibility of missending abnormal user electric bill caused by manual misoperation, and forms the correction closed-loop management of abnormal business expansion data by utilizing the system automatic locking function and the subsequent system flow of checking, correcting and unlocking

And step S5, the system corrects the data in the abnormal state in the file abnormal checking locking and unlocking module, and simultaneously reminds the administrator to review in the foreground display module and updates the data in the database.

In a specific embodiment, the data correction specifically includes that the system displays users with abnormal marks according to user numbers, warning information and user basic data lists, locks the data, respectively sorts and unlocks abnormal locking data according to different users, meter reading sections and power supply units after the system administrator checks, corrects and confirms that the abnormal locking data are correct, and normal electricity fee issuing is carried out on the abnormal marked user electricity fee data after the abnormal checking locking is released; firstly, the system outputs abnormal data users after checking operation and checking, then the system checks the locking function to automatically retrieve the users and lock the data, the users are not allowed to flow to the next process, the system is manually unlocked until the users confirm that the checking and the correction are correct one by one, and then the corrected user data can normally enter the next stage process; if the user has the client timeliness appeal, on the premise that the checking judgment has no influence on the current electric charge calculation result, the electric charge calculation result can be transmitted to a normal electric charge calculation and distribution process through rechecking, the actual situation encountered in enterprise marketing electric charge distribution is considered, and the flexibility and reliability of process operation are improved.

As shown in fig. 3, an embodiment of the present invention further provides an abnormal interception system for user billing data in an electricity price system, which is used to implement the above method, where the system includes:

the data interaction module is used for identifying and acquiring a database of the marketing system through a data interface, or recording related data in real time, recording data by contrasting a paper industry expansion work order, a meter reading record and machine account information, and recording data and parameters by performing on-site investigation;

the business expansion billing archive data anomaly checking and intercepting module is used for carrying out deep analysis and logical comparison on the power price and power charge calculation logics which set preconditions for different power prices in the relevant power price standards, power charge execution specifications and execution policies, displaying the abnormal rule names of users in a warning information mode after the abnormal business expansion archive data of the users are intercepted by the module for checking assistance, displaying the abnormal rule names in a warning information mode after the abnormal business expansion archive data of the users are intercepted by the model for checking assistance of a management department, judging and intercepting the abnormal rule by more than or equal to one abnormal rule of the same abnormal user, and increasing the number of warning information pieces displayed by the same user in proportion to the error probability of the business expansion information;

In a specific embodiment, the business expansion charging archive data exception checking and intercepting module includes:

For further details, reference may be made to the preceding description of the drawings, which are not described in detail herein.

The embodiment of the invention has the following beneficial effects:

according to the system and the method for intercepting the abnormal user charging data in the electricity price system, provided by the embodiment of the invention, the accurate and comprehensive abnormal data checking interception rule algorithm is adopted, the full amount of users are checked one by one according to each electricity charge calculation period in a procedural, standardized and automatic ordered manner, and the accurate user data passing through the checking can normally enter the next procedure through the periodical iterative checking, so that the quality of the basic data of the users is effectively improved, and the accuracy of the electricity charge calculation is improved;

While the invention has been described in connection with what is presently considered to be the most practical and preferred embodiment, it is to be understood that the invention is not to be limited to the disclosed embodiment, but on the contrary, is intended to cover various modifications and equivalent arrangements included within the spirit and scope of the appended claims.

Claims

1. A method for intercepting abnormal user charging data in an electricity price system is characterized by comprising the following steps:

2. The method of claim 1, wherein in step S1, the user profile data comprises: the system comprises transformer file data, electricity price file data, metering point relation file data, force-adjusted electricity charge file data, special electricity price file data, business change first charging file data and business work order type file data.

3. The method as claimed in claim 2, wherein in step S3, the specific determination process for the profile data of the power consumption standard includes:

the capacity of the transformer is more than or equal to 100, no power regulation is carried out, abnormal data are judged when the capacity of the transformer simultaneously meets the following standards, and normal data are judged if at least one of the standards is not met: the rated capacity of the associated transformer at the current stage of the metering point is more than or equal to the contract capacity reference value, the current stage of the metering point is a private substation, the current price of the metering point is not the electricity price of residents, the power factor standard of the current stage of the metering point is not checked, the current price code of the current stage of the metering point does not contain electricity price parameters, the current stage of the user is not a co-variant associated substation, and the current stage of the metering point has no total score relation;

the low-voltage user executes the power adjustment, and when the following criteria are simultaneously met, the abnormal data are judged, and if at least one criterion is not met, the normal data are judged: the current period of the metering point is a value obtained by a public transformer user and a power factor standard of the current period of the metering point, and the current price code of the current period of the metering point is not equal to the non-current price;

and (3) the resident wrongly checks the nuclear power tone, if the resident wrongly checks the nuclear power tone and the following two criteria are simultaneously met, the resident is judged to be abnormal data, and if at least one criterion is not met, the resident is judged to be normal data: the electricity price of the current period of the metering point belongs to the electricity price of residents, and the power factor of the current period of the metering point is assessed;

when the capacity of a user with a power regulation standard is smaller than 100KW and the user simultaneously meets the following standards, judging the user to be abnormal data, and if at least one of the standards is not met, judging the user to be normal data: the rated capacity sum of the relevant transformers at the current period of the metering point is smaller than the reference value of the common power utilization capacity, the power factor at the current period of the metering point is set to be examined, the total score relation does not exist at the current period of the metering point, the self-backup transformation relation does not exist at the current period of the metering point, and the electricity price code at the current period of the metering point is not equal to the electricity price.

4. The method as claimed in claim 3, wherein in step S3, the specific determination process for the electricity price profile data in the electricity usage standard comprises:

and judging abnormal data when the large amount of electricity prices meet one of the following two standards according to the maximum demand or the high demand electricity prices meet the capacity of the transformer, and judging normal data if the large amount of electricity prices do not meet the two standards simultaneously: the method comprises the steps that high electricity demand rates are executed in a metering point current period, basic electricity charges are calculated according to transformer capacity in the metering point current period, a large amount of electricity charges are executed in the metering point current period, and the basic electricity charges are calculated according to the maximum demand in the metering point current period;

5. The method as claimed in claim 4, wherein in step S3, the specific determination process of the transformer profile data in the electricity usage standard includes:

6. The system according to claim 5, wherein in step S3, the specific determination process for the metering point relationship profile data in the electricity usage standard includes:

7. The system according to claim 6, wherein in step S3, the specific determination process for the specific electricity price profile data in the electricity usage standard comprises:

8. The system according to claim 7, wherein in step S3, the specific determination process for the service change first charging profile data in the electricity usage standard includes:

9. The method as claimed in claim 8, wherein in step S3, the specific determination process for the business work order class archive data in the electricity utilization standard includes:

10. The method according to claim 9, wherein in step S5, the data modification is specifically that the system displays the users with abnormal marks according to the user numbers, warning information, and user basic data columns, locks the data, after the system administrator checks the modification to confirm that there is no error, the system administrator sorts and unlocks the abnormal locked data according to the difference of the users, meter reading sections, and power supply units, and after the abnormal checking lock is released, the user electricity charge data with abnormal marks is issued with normal electricity charges.

11. An abnormal interception system of user billing data in an electricity rate hierarchy, for implementing the method of any one of claims 1 to 10, the system comprising:

12. The system of claim 11, wherein the business expansion charging profile data exception checking interception module comprises: