CN110825724B

CN110825724B - System and method for intercepting user charging data abnormality in electricity price system

Info

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

Abstract

The invention discloses a system and a method for intercepting user charging data abnormality in an electricity price system, comprising the following steps: the system acquires the business expansion charging archive data of the user through a data interaction module; judging whether a plurality of electricity utilization standards exist in the region to which the user belongs according to the region information to which the electricity utilization address belongs in the user data until only one electricity utilization standard exists in the range to which the electricity utilization address belongs, and calling; 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 or not, and marks the abnormal item of data; according to different marking states of each item of data, the system classifies and outputs data in the user business expansion file data, and displays abnormal data states; the system corrects the data in the abnormal state, reminds an administrator to review and update the data in the database, effectively improves the quality of the basic data of the user and the accuracy of electric charge calculation, and enhances the automation and intellectualization level of business expansion data management.

Description

System and method for intercepting user charging data abnormality in electricity price system

Technical Field

The invention belongs to the field of power management, and relates to a system and a method for intercepting user charging data abnormality in a power price system.

Background

The accuracy of electric charge calculation directly relates to the personal interests of both a user and a power supply enterprise, and the accuracy of the business expansion charging files after the business expansion files and business change of the user is a necessary premise for ensuring the accuracy of electric charge calculation. The main reasons for the abnormality of the incremental and stock business expansion charging archive data are as follows: firstly, for a long time, the business expansion files and business change file data of users adopt a manual auditing and manual inputting mode, and the mode inevitably causes error recording and missing recording conditions along with the continuous increase of the number of users, so that a large number of business expansion charging files of the users in the power supply integrated marketing system have non-standard conditions; secondly, along with the adjustment of the price policy, a large amount of original user file data conforming to the old policy has more problems of non-standardization and unmatched history legacy along with the execution of the new policy; thirdly, along with the continuous development of informatization of power supply enterprises, the migration and change of power supply information system data cause the loss and disorder of part of user business expansion charging archive data. On the one hand, the electricity price system of certain areas can have uniqueness; on the other hand, the complexity of the electricity price system in the same area is improved in multiple, and the difficulty of accurately identifying abnormal business expansion charging archive data is further increased.

Disclosure of Invention

The technical problem to be solved by the embodiment of the invention is to improve the quality of the marketing business expansion charging archive data of the power supply system under the condition that a plurality of electricity utilization standards exist in the same area, ensure accurate, timely and efficient interception of the abnormal business expansion charging archive data and reduce electric charge errors.

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

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

step S2, according to the regional information of the electricity address in the user data, all electricity utilization standards corresponding to the electricity utilization region of the user are called in the system, whether a plurality of electricity utilization standards exist in the region of the user is judged, if a plurality of electricity utilization standards exist, the electricity utilization standard of the minimum range of the electricity utilization address of the user is judged again until only one electricity utilization standard exists in the range of the electricity utilization address, and if a plurality of electricity utilization standards do not exist, the electricity utilization standard is called directly;

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 or not, and marks;

s4, according to different marking states of each item of data, the system classifies and outputs data in the user business expansion file data, and displays abnormal data states;

And S5, the system corrects the data in the abnormal state, reminds an administrator to review at the same time, and updates the data in the database.

Further, in step S1, the user service expansion charging profile data includes: transformer archive data, electricity price archive data, metering point relation archive data, power regulation electricity fee archive data, special electricity price archive data, business change first charging archive data and business work order archive data.

Further, in step S3, the specific determining process for the power rate profile data in the power consumption standard includes:

the capacity of the transformer is more than or equal to 100, the force adjustment is not executed, when the following standards are simultaneously met, abnormal data are judged, and if the abnormal data are not simultaneously met, normal data are judged: the rated capacity of the associated transformer in the current period of the metering point is larger than or equal to the reference value of contract capacity, the current period of the metering point is a special transformer, the current price of the metering point is not resident price, the current power factor standard of the metering point is not checked, the current price code of the metering point does not contain no price parameter, the current period of the user is not a co-transformer associated user, and the current period of the metering point has no total score relation;

the low-voltage user executes force adjustment, when the following criteria are met at the same time, abnormal data are judged, and if the following criteria are not met at the same time, normal data are judged: the metering point current period is a value in the public transformer household and the metering point current period power factor standard, and the metering point current period power price code is not equal to the electroless price;

The resident mischecks the power to transfer, when meeting the following two standard at the same time, judge to be abnormal data, if not meeting at the same time, judge to be normal data: the current electricity price of the metering point belongs to the resident electricity price class and the current power factor of the metering point is checked;

a user with a capacity of less than 100KW and a powerful tuning standard is judged to be abnormal data when the following standards are simultaneously met, and is judged to be normal data when the following standards are not simultaneously met: the rated capacity sum of the transformer associated with the metering point in the period is smaller than the reference value of the common electric capacity, the power factor of the metering point in the period is set to be checked, the metering point in the period has no total score relation, the metering point in the period has no self-provided change relation, and the electricity price code of the metering point in the period is not equal to the electroless electricity price.

Further, in step S3, the specific determining process for the electricity price file data in the electricity consumption standard includes:

the quantitative ratio table resident does not allow time sharing, and when the following several criteria are met at the same time, abnormal data is judged, and if at least one of the following criteria is not met, normal data is judged: the metering point period is quantitative fixed ratio, the metering point period electricity consumption type is resident life electricity consumption, the metering point period is time-sharing charging, and the metering point period electricity price code is electricity price;

And partially disabling the user performing the demand charge, and determining the abnormal data when the following several criteria are simultaneously satisfied, and determining the normal data when at least one of the criteria is not satisfied: the metering point current period is to calculate the basic electricity charge according to the maximum demand, the transformer is deactivated in the metering point current period part, and the metering point current period electricity price code has electricity price;

the large amount of electricity price is according to the maximum demand or the high electricity price is according to the capacity of the transformer, when at least one of the following two standards is met, abnormal data is judged, and if the abnormal data is not met, normal data is judged: the metering point performs high electricity price in the present period and calculates basic electricity charge according to the capacity of the transformer in the present period, the metering point performs a large amount of electricity price in the present period and calculates basic electricity charge according to the maximum demand in the present 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, and if at least one of the standards is not met, normal data are judged: the metering mode of the metering point in the period is low in power supply and metering, the voltage level of the metering point in the period is 1KV to 10KV, the metering point in the period is not in agricultural production, the metering point in the period is not in tap water electricity price, the metering point in the period is not in agricultural irrigation, the metering point in the period is not in resident life electricity, and the metering point in the period is not in electricity price code;

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

the time-sharing electricity price is not time-sharing charging, when the following several standards are met, abnormal data are judged, if at least one of the abnormal data is not met, normal data are judged, wherein the current metering point is non-time-sharing charging, the current metering point is time-sharing, the current metering point industry classification codes are not the generation and supply of tap water, the current metering point electricity price codes have electricity prices, the current metering point user type is not a local power plant user, and the current user type is not a special flat-stage electricity price user;

the non-main metering point of the high-demand electricity user is provided with a demand checking value, when the following standards are met, abnormal data are judged, if at least one of the abnormal data is not met, normal data are judged, wherein the metering point period is a special-purpose electricity user, the metering point period executes high-demand electricity price, a great number of high-demand sectional relations exist in the metering point period, the metering point period is a sub-metering point, the metering point period demand checking value is larger than 0, and the metering point period electricity price code has electricity price;

The common industry does not charge according to time sharing, when the standard is satisfied, abnormal data is judged, if at least one of the standard is not satisfied, normal data is judged, the metering point current period electricity consumption type is the common industry, the metering point current period non-time sharing charging, the metering point current period electricity price voltage level is 1KV to 10KV, and the metering point current period electricity price code has electricity price;

the common type electricity price is not matched with the capacity, when the common type electricity price meets the following several standards at the same time, abnormal data are judged, if at least one of the common type electricity price is not met, normal data are judged, wherein the rated capacity sum of the transformer is related to the operation of the metering point in the current period, the rated capacity sum is more than or equal to the capacity sum and the reference value, the name of the electricity price of the metering point in the current period comprises common electricity price, the voltage level of the electricity price of the metering point in the current period is less than or equal to 35 kilovolts, the user in the current period is not a co-variation related user, and the total score relation does not exist in the metering point in the current period;

the user is wrongly filled with electricity-free price, when the following criteria are met, abnormal data are judged, if at least one of the criteria is not met, normal data are judged, wherein the user state at the current metering point is running, the electricity type at the current metering point is not other electricity, the use code at the current metering point is not an examination table, and the electricity price code at the current metering point is electricity-free price;

When the following criteria are met, abnormal data is judged, if at least one of the criteria is not met, normal data is judged, wherein the metering point period is the basic electricity fee according to the maximum demand, the metering point period demand checking value is not the metering point upper period demand checking value, and the metering point period electricity price code has electricity price;

and if at least one of the two standards is not satisfied, judging normal data, wherein the number of the current period relation of the metering point is greater than zero, and the current period of the metering point is inconsistent with the basic electric charge calculation mode of the associated metering point.

Further, in step S3, the specific determining process for the transformer profile data in the electricity consumption standard includes:

the charging capacity of the transformer is inconsistent with the rated capacity, when the charging capacity sum of the transformer associated with the current-period operation of the metering point is not equal to the rated capacity sum of the transformer associated with the current-period operation of the metering point, abnormal data are judged, and if the charging capacity sum of the transformer associated with the current-period operation of the metering point is equal to the rated capacity sum of the transformer associated with the current-period operation of the metering point, normal data are judged;

the transformer is not associated with any metering point, when the associated transformer is not associated with the metering point in the current period of the user, abnormal data are judged, and if the transformer is not associated with the metering point, normal data are judged;

The operation days of the transformer are larger than the charging days of the metering point, when the operation days of the transformer associated with the current period of the metering point are larger than the recorded charging days, abnormal data are judged, and if the operation days of the transformer are not larger than the recorded charging days, normal data are judged;

and the common transformation association user judges the abnormal data when the following labels are simultaneously satisfied, and judges the normal data when at least one item is not satisfied: the measuring point has a total point relation in the present period, the measuring point does not belong to the same household, and the code of the current electricity price of the measuring point is the current electricity price;

screening of the private transformer co-user, wherein abnormal data is judged when the following two labels are simultaneously met, and normal data is judged when at least one of the two labels is not met: the current period power supply mode of the user is to use the special power supply and measure the current period power price code of the point as the current price.

Further, in step S3, the specific determining process for 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 metering point is earlier than the meter reading date of the metering point, abnormal data are judged, and if the meter reading date of the metering point is not earlier than the meter reading date of the metering point, normal data are judged;

the total score users lack the shared self-provided transformation relationship, and when the following several standards are simultaneously met, abnormal data are judged, and if at least one of the standards is not met, normal data are judged: the metering point is not a public transformer, the metering point is provided with a father metering point in the period and the father metering point is not a public transformer in the period, meanwhile, the metering point is not in a shared self-contained transformation relationship in the period and is not a quantitative fixed ratio meter or a sub metering point in the period and is not a public transformer, meanwhile, the metering point is not in a fixed ratio sub metering point in the period and is not in a shared self-contained transformation relationship, and the metering point is not in a same household and is not in a total sub relationship with the period.

Further, in step S3, the specific determining process for the first charging profile data of the service change in the electricity consumption standard includes:

the first charging after the non-permanent volume reduction archiving, if the first charging after the non-permanent volume reduction is archived by the non-periodic flow at the metering point in the present period, the abnormal data is judged, if not, the normal data is judged;

and charging for the first time after the table replacement filing, judging abnormal data when the following two standards are simultaneously met, and judging normal data when at least one of the two standards is not met: the metering point present period is a special household, and the metering point present period is a table change;

the first charging after the archiving is restored, if the metering point is the first charging after the non-periodic process archiving is restored, the metering point is judged to be abnormal data, and if not, the metering point is judged to be normal data;

charging for the first time after filing, judging abnormal data when the following two standards are met, and judging normal data when at least one of the two standards is not met: the metering point period is a special change household, and the metering point period is a new household;

if the metering point is the first charging after the non-periodic process archiving after the pausing, the abnormal data is judged, if not, the normal data is judged;

And (3) charging for the first time after capacity increase and decrease filing, wherein if the metering point is the first time after capacity increase or capacity decrease and the first time after non-periodic process filing, abnormal data are judged, and if not, normal data are judged.

Further, in step S3, the specific determining process for the business work order record data in the electricity consumption standard includes:

the change type work order is effective during the charging period, when the following several standards are met at the same time, abnormal data are judged, and if at least one of the standards is not met, normal data are judged: the metering point has a metering point change record in which the charging work order is not empty and the business class is changed, and the metering point has a current electricity price code;

the class worksheet is not truncated, and abnormal data is judged when the following several standards are simultaneously met, and normal data is judged if at least one of the abnormal data is not met: the user changes the class worksheet on the way in the period or the metering point in the period, the charging worksheet is empty, the business class is changed, and meanwhile, the metering point change record corresponding to the table information record is not available, and the metering point current electricity price code is the electricity price;

when the following standards are simultaneously met, abnormal data is judged, and if at least one of the standards is not met, normal data is judged: the current work order state of the user is not the archived work order, the current work order of the metering point is expanded in the current work order, the number input link is indicated, and the current electricity price code of the metering point is the electricity price.

In step S5, the system displays the user with the abnormal mark according to the user number, the warning information and the user basic data sequence, locks the data, classifies and unlocks the abnormal locking data according to the differences of the user, the meter reading section and the power supply unit after checking and confirming the correction by the system administrator, and releases the abnormal checking and locking, and then the abnormal marked user electric charge data is subjected to normal electric charge distribution.

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

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

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

the business expansion charging archive data exception checking and intercepting module is used for carrying out deep analysis and logic comparison on related electricity price standards, electricity price execution standards and preset preconditions for different electricity prices in an execution policy and electricity price calculation logic, and displaying rule names for judging exception in a warning information mode after the user abnormal business expansion archive data is blocked by the module for assistance of checking;

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

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

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

the transformer file abnormality checking module is used for performing abnormality judgment on the transformer file data acquired by the data interaction module according to the electricity utilization standard;

the electricity price file abnormality checking module is used for performing abnormality judgment on the electricity price file data acquired by the data interaction module according to an electricity utilization standard;

the metering point relation file abnormality checking module is used for performing abnormality judgment on the metering point relation file data acquired by the data interaction module according to the electricity utilization standard;

the power adjustment electricity charge file abnormality checking module is used for performing abnormality judgment on the power adjustment electricity charge file data acquired by the data interaction module according to an electricity consumption standard;

The special electricity price file abnormality checking module is used for performing abnormality judgment on the special electricity price file data acquired by the data interaction module according to the electricity utilization standard;

the business change first-time charging archive anomaly checking module is used for carrying out anomaly judgment on the business change first-time charging archive data acquired by the data interaction module according to the electricity utilization standard;

and the business work order file abnormality checking module is used for performing abnormality judgment on the business work order file data acquired by the data interaction module according to the electricity utilization standard.

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, an accurate and comprehensive abnormal data checking and intercepting rule algorithm is adopted, so that the total number of users are checked one by one in each electricity fee calculation period in a orderly manner according to the process, standardization and automation, and the accurate user data passing the checking can normally enter the next process through the periodic iterative checking, so that the quality of basic data of the users is effectively improved, and the accuracy of electricity fee calculation is improved;

the invention realizes a closed-loop management system for automatically checking, intercepting, warning, locking, checking and unlocking the full-flow user business expansion data, and enhances the automation and intelligent level of business expansion data management and the electric charge management level of power supply enterprises.

The system has good expansibility, key parameter thresholds are defined in most abnormal rule sentences, and the system efficiency is further improved by continuously optimizing and adjusting key parameters; the method can be used for adding, deleting, modifying and updating rules according to the updating requirements of different electricity price policy systems, and the judging rules have good growth and reliability.

Drawings

In order to more clearly illustrate the embodiments of the invention or the technical solutions of the prior art, the drawings which are required in the description of the embodiments or the prior art will be briefly described, it being obvious that the drawings in the description below are only some embodiments of the invention, and that it is within the scope of the invention to one skilled in the art to obtain other drawings from these drawings without inventive faculty.

Fig. 1 is a schematic diagram of a main flow of a method for intercepting user billing data anomalies in an electricity price system.

Fig. 2 is a schematic flow chart of a method for intercepting user billing data anomalies in an electricity price system.

Fig. 3 is a schematic diagram of an abnormal interception system for user billing data in the electricity price system provided by the invention.

Detailed Description

The present invention will be described in further detail with reference to the accompanying drawings, for the purpose of making the objects, technical solutions and advantages of the present invention more apparent.

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

in a specific embodiment, the user service expansion charging profile data includes: transformer archive data, electricity price archive data, metering point relation archive data, power regulation electricity fee archive data, special electricity price archive data, business change first charging archive data and business work order archive data.

Firstly, the user number is taken as a unique value, a user charging data abnormal interception system in the electricity price system extracts user business expansion charging archive data from a power supply marketing system, the marketing system can be regarded as a database containing all user information, and the system and the marketing system are provided with direct butt joint interfaces, so that the required user business expansion charging archive data information including but not limited to electricity utilization client basic information, electricity utilization client information, three-user model, thematic information, metering point basic information and charging related information in the marketing system can be obtained from the database, and the extracted user business expansion charging archive data can be ensured to be effective.

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

user number: the method is characterized in that for the convenience of searching and management, the users are numbered, and the number becomes a mark for uniquely identifying the users;

user name: the names left when the user registers for account opening are often called by individuals, companies or other related names;

electricity category: the power grid company classifies the power grid company according to the power consumption property of the user, commonly known as public transformer clients, refers to the users using public transformers belonging to the property rights of power supply enterprises to supply power, and refers to the users using transformers belonging to the property rights of lines of the power supply enterprises to supply power, including the users with large power consumption such as industry and commerce, the special transformer clients, and refers to the users using the property rights to supply power to the lines of the users and the transformers, and mainly refers to the users with the ultra-large power consumption in industry and commerce, local power plant users and transformer area assessment users;

rated capacity of the transformer: a basic parameter of the transformer, which is the maximum capacity which can be continuously output during the specified normal service life, and the conventional value of apparent power of the main tapping can be marked on a transformer nameplate when leaving a factory;

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

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

the metering mode is as follows: the metering and mounting modes of the electric energy metering device are divided into a high-power meter (metering mode that the voltage of the set point of the electric energy metering device is consistent with the power supply voltage and is more than 10kV or 6 kV), a high-power meter (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-power meter (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 of resident electricity is low-power meter.

Metering point: the metering point is divided into an electric power customer charging point and a gateway metering point;

metering point relation: the method comprises a main-standby relation, a large number of high-demand sectional relations, a cross-user total score, a shared self-standby relation and main-sub metering, and is a combination form which is made for charging correctly and special in-situ condition of metering points;

metering point use: the method mainly comprises the steps of dividing a reference table into a general charging table for measuring line loss and line load without calculating electric charge, and measuring electric energy consumption as a basis for settling the electric charge;

Metering point electricity category: based on the second classification under the electricity category major class, there are general industry and commerce, other, resident life, large industrial electricity, business, agricultural irrigation, local power plant households;

the electric quantity calculation mode comprises the following steps: the method comprises the steps of metering by a meter, metering by a fixed ratio, settling by a fixed ratio of total electric quantity, and quantifying, wherein each settlement is carried out by fixed electric quantity;

quantitative ratio: a fixed electric quantity settlement value marked in a contract is agreed with a user;

electricity price: the full name is sales electricity price, which refers to the price of selling electric energy for an end user by a power grid management enterprise, the sales electricity price carries out government pricing, unification policy and hierarchical management, and the pricing mode comprises two electricity price making modes and a single electricity price making mode;

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

the required quantity is verified to be constant: the method is characterized in that the maximum demand which can be used by a user according to the agreement is defined, and if the actual maximum demand of the user exceeds the checking value by 5%, the basic electricity charge of more than 5% is added by 1 time to be collected;

maximum required amount: the method is characterized in that average power of customer electricity consumption is measured in a certain period of time in a certain settlement period, and the maximum primary indicated value is reserved as the maximum required amount of the settlement period;

The power factor assessment mode is as follows: the method is divided into two modes of standard examination and non-examination;

power factor standard: the method is divided into three types of assessment standard 0.8, assessment standard 0.85 and assessment standard 0.9, and the power factor adjustment electric charge basis and standard are documents of power factor adjustment method issued by the raw water electric power utilization department and the national material price office in 1983;

variable loss charging flag: the method is divided into yes or no;

variation of: the transformer loss is the sum of no-load loss Po, short-circuit loss Pk and stray loss Ps, and the running transformer consumes certain electric energy;

days of transformer operation: in order to calculate important parameters of basic point fees, the operation days of the transformer are usually 30 days according to monthly charging, and the basic electric fees of the transformer are converted and charged according to the operation days if the transformer is not in whole month;

basic electricity charge allocation mode: the method is divided into proportion allocation without charging, proportion value allocation, capacity proportion allocation and fixed value allocation, and is an important parameter in calculating basic electricity;

work order: the work orders in the business flow include new installation, class change, household crossing, capacity increase, capacity reduction, list changing, suspension, restoration, non-permanent capacity reduction, non-periodic billing and household selling of the user/transformer;

Periodic charging and non-periodic charging: the normal periodic charging is to settle the electric charge according to the first month of the period, and the non-whole month electric charge settlement is called non-periodic charging;

co-transformation: referring to the situation that a plurality of users share one or a plurality of transformers, most of stock users are left behind due to historical reasons, and the existing policy does not allow new co-change users to appear;

the power supply mode is as follows: the power supply is usually four modes of public line power supply, private line power supply and public power supply.

in a specific embodiment, the specific determining process for the power rate profile data in the power consumption standard a includes:

Specifically, the specific judging process for the electricity price file data in the electricity consumption standard a includes:

Specifically, the specific judging process for the transformer archive data in the electricity utilization standard a includes:

Specifically, the specific judging process of the metering point relation file data in the electricity utilization standard A comprises the following steps:

Specifically, the specific judging process for the special electricity price file data in the electricity utilization standard A includes:

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

if the quantitative user is the quantitative table in the current period of the metering point, the quantitative user is judged to be abnormal data, and if the quantitative user is not, the quantitative user is judged to be normal data.

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

Specifically, the specific judging process for the business work order file data in the electricity utilization standard A includes:

In a further embodiment of the present invention,

specifically, the specific judging process for checking the abnormal condition of the transformer file in the electricity utilization standard B includes:

the large industrial user has a pause transformer, and when the following criteria are met at the same time, abnormal data are judged, and if at least one of the criteria is not met, normal data are judged: the related transformer with the current existence state of the user being suspended, the current electricity type of the user being large industry, and the current electricity price code of the metering point being the electricity price;

the charging capacity sum of the special transformer metering point is inconsistent with the charging capacity sum of the transformer, when the following standards are simultaneously met, abnormal data are judged, and if at least one of the standards is not met, normal data are judged: the user period is a special transformer user, the user period electricity consumption category is large industry, and the rated capacity of the transformer is related to the user period operation and is inconsistent with the metering point charging capacity;

the charging capacity sum of the special transformer metering point is inconsistent with the charging capacity sum of the transformer, when the following standards are simultaneously met, abnormal data are judged, and if at least one of the standards is not met, normal data are judged: the user period is a special transformer user, the type of electricity used by the user period is large industry, the rated capacity of the transformer is related to the user period operation, the charging capacity sum of the metering point is inconsistent with that of the metering point, and the metering point calculates the basic electricity fee according to the transformer capacity in the period;

And screening by a special variation co-user, wherein abnormal data is judged when the following several standards are simultaneously met, and normal data is judged when at least one of the abnormal data is not met: the user current period power supply mode is to use special power supply and measure the current period power price code as the current price;

specifically, the specific judging process for checking the electricity price file abnormality in the electricity consumption standard B includes:

and partially disabling the user performing the demand charge, and determining the abnormal data when the following several criteria are simultaneously satisfied, and determining the normal data when at least one of the following criteria is not satisfied: the electricity consumption type of the metering point in the period is large industry, the basic electricity charge is calculated according to the maximum demand in the metering point in the period, the transformer is deactivated in the part of the user in the period, and the electricity price code of the metering point in the period is the electricity price;

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

when the sewage electricity price execution time sharing meets the following criteria, abnormal data is judged, and if at least one of the abnormal data is not met, normal data is judged: the contract capacity of the user in the period is larger than or equal to the contract capacity reference value, the current period of the metering point is a special user, the current period of the metering point is not the resident electricity price, the current period of the metering point is not the meter electricity price, the current period power factor standard of the metering point is not in conformity with the power factor standard of the associated transformer, and the current period of the metering point is the electricity price;

And checking the electricity price, wherein when the following standards are simultaneously met, abnormal data is judged, and if at least one of the abnormal data is not met, normal data is judged: the metering point current period metering mode is high metering or high supply low metering, the metering point current period electricity price voltage level is less than 1KV, the metering point current period electricity consumption type is not agricultural production, the metering point current period electricity consumption type is not agricultural irrigation, the metering point current period electricity consumption type is not resident life, the metering point current period electricity price is not urban and rural primary school electricity price, and the metering point current period electricity price code is not electroless;

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

the user in the area B mistakenly selects the electricity price in the area A, when the electricity price in 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 in 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 type of electricity consumption in the current period of the metering point is the common industry, the non-time sharing charging in the current period of the metering point, the voltage level of the electricity price in the current period of the metering point is 1KV to 10KV, and the code of the electricity price in the current period of the metering point is the electricity price;

Time sharing errors, when the following criteria are met at the same time, determining abnormal data, if at least one of the criteria is not met, determining normal data: the metering point is time-sharing charging in the present period, the metering point is not time-sharing in the present period, and the metering point is the present period electricity price code as the available electricity price;

the demand setting value changing user determines abnormal data when the following criteria are simultaneously satisfied, and determines normal data when at least one of the criteria is not satisfied: calculating basic electricity charge according to the maximum demand at the metering point in the current period, wherein the demand checking value at the metering point in the current period is not equal to the demand checking value at the upper period of the metering point, and the electricity price code at the metering point in the current period is the electricity price;

the resident time-sharing table user file is abnormal, when the following criteria are met at the same time, abnormal data are judged, and if at least one of the criteria is not met, normal data are judged: the electricity consumption type of the metering point in the period is resident life, the metering point in the period is time-sharing charging or the metering point in the period is time-sharing charging, the metering point in the period is non-time-sharing charging or the metering point in the period is not time-sharing charging, and the electricity price code of the metering point in the period is 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, and if at least one of the standards is not met, normal data are judged: the metering mode of the metering point in the period is low in power supply and metering, the voltage level of the metering point in the period is more than or equal to 1KV to 10KV, the metering point in the period is not in agricultural production, the metering point in the period is not in tap water electricity price type, the metering point in the period is not in agricultural irrigation type, the metering point in the period is not in resident life type, and the metering point in the period is the electricity price code;

The false filling is a non-electricity price user, when the following standards are simultaneously met, abnormal data are judged, and if at least one of the standards is not met, normal data are judged: the user state of the metering point in the current period is running, the electricity consumption type of the metering point in the current period is not other electricity consumption, the code of the metering point in the current period is not an examination table, and the code of the metering point in the current period is electroless.

Specifically, the specific determining process for the charging parameter file data in the electricity consumption standard B includes:

the large industrial charging parameters are abnormal, when the following several standards are simultaneously met, abnormal data are judged, and if at least one of the abnormal data is not met, normal data are judged: the electricity consumption type of the metering point in the current period is large industry, the basic electricity charge is not calculated in the metering point in the current period or the non-time-sharing charging is carried out in the metering point in the current period, meanwhile, the electricity price of the metering point in the current period is time-sharing, the industry classification code of the metering point in the current period is not the generation and supply of tap water, the industry classification code of the metering point in the current period is not sewage treatment and recycling, and the electricity price code of the metering point in the current period is the electricity price;

the variation parameters are abnormal, when the following criteria are met at the same time, abnormal data are judged, and if at least one of the parameters is not met, normal data are judged: the metering mode of the metering point in the period is high-supply low-metering mode, the metering point does not have a father metering point in the period or the metering mode of the father metering point in the period does not be high-metering mode, the metering point in the period calculates variable loss, the metering point in the period electricity price code is the current electricity price, the metering point in the period is related to abnormal transformer variable loss parameters or the metering point in the period does not charge.

Specifically, the specific judging process for the metering point relationship file data in the electricity consumption standard B includes:

the total score users lack the shared self-provided transformation relationship, and when the following several standards are simultaneously met, abnormal data are judged, and if at least one of the abnormal data is not met, normal data are judged: the method is characterized in that the measuring point is not a public transformer household, the measuring point has a father measuring point in the present period, meanwhile, the father measuring point in the present period is not a public transformer household, the measuring point has no shared self-change relation in the present period, the measuring point is not a quantitative fixed ratio meter in the present period, or the measuring point has a child measuring point in the present period, and neither the measuring point nor the quantitative fixed ratio child measuring point in the present period is a public transformer household, the measuring point has no shared self-change relation in the present period, and the measuring point has a total sub-relation measuring point in the present period and is not a same household, and the electric price code in the present period of the measuring point is a current price;

and the total user meter reading period is inconsistent, when the following standards are simultaneously met, abnormal data are judged, and if at least one of the abnormal data is not met, normal data are judged: the metering point has sub metering points in the current period, the meter reading period of the metering point is inconsistent with the meter reading period of the sub metering point, and the current electricity price code of the metering point is the electricity price.

Specifically, the specific judging process of the power adjustment electricity fee archival data in the electricity utilization standard B includes:

The metering point force rate is not consistent with the transformer force regulation, when the following several standards are simultaneously met, abnormal data are judged, and if at least one of the standards is not met, normal data are judged: the contract capacity of the user in the period is larger than or equal to the contract capacity reference value, the current period of the metering point is a special user, the current period of the metering point is not the resident electricity price, the current period of the metering point is not the meter electricity price, the current period power factor standard of the metering point is not in conformity with the power factor standard of the associated transformer, and the current period of the metering point is the electricity price;

and (3) checking the non-reactive table, judging abnormal data when the following criteria are met at the same time, and judging normal data when at least one of the criteria is not met: the measuring point is not provided with a father measuring point in the present period, the measuring point is not provided with a quantitative fixed ratio meter in the present period, the measuring point is provided with a reactive meter in the present period, and the measuring point is provided with an electricity price code in the present period;

the capacity of the transformer is larger than 100, the force adjustment is not executed, when the following several standards are simultaneously met, abnormal data are judged, and if at least one of the abnormal data is not met, normal data are judged: the contract capacity of the user in the period is larger than or equal to the contract capacity reference value, the current period of the metering point is a special user, the current period of the metering point is not resident electricity price, the current period of the metering point is not the current period of the metering point, the power factor standard in the current period of the metering point is not checked, and the current period of the metering point is the current period of the metering point;

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

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

Specifically, the specific judging process of the service work order file data in the electricity utilization standard B includes:

the examiner has a non-archiving work order, and judges abnormal data when the following several standards are simultaneously met, and judges normal data when at least one of the standards is not met: the metering point present period use codes are examination tables, the state of the work orders in the user present period is not the archived work orders, and the metering point present period industry expands the number input links of the representation number;

The form intercepting work form is not effective, and abnormal data is judged when the following several standards are simultaneously met, and normal data is judged if at least one of the abnormal data is not met: the metering point change record with the metering point present period on-the-way bill cutting work form or the metering point present period with the charging work form empty and the subsection fee calculating mark of 1, and the metering point present period electricity price code is the electricity price;

the class change work order is not validated, and abnormal data is judged when the following several standards are simultaneously met, and normal data is judged if at least one of the abnormal data is not met: the user changes the class worksheet on the way in the period or the metering point changes the record that the charging worksheet is empty and the business class is changed in the period, and the current electricity price code of the metering point is the electricity price;

the class worksheet is not truncated, and abnormal data is judged when the following several standards are simultaneously met, and normal data is judged if at least one of the abnormal data is not met: the user changes the class worksheet on the way in the period or the metering point changes the class with the charging worksheet empty and the business class in the period, and the metering point change record corresponding to the table information record is not available, and the metering point current electricity price code is the electricity price;

when the following standards are simultaneously met, abnormal data is judged, and if at least one of the standards is not met, normal data is judged: the current work order state of the user is not the archived work order, the current work order of the metering point is expanded in the current process, the number input link is indicated, and the current electricity price code of the metering point is the current electricity price;

The large industrial user has pause or pause to resume the effective service, when the following several standards are simultaneously met, the abnormal data is judged, and if at least one of the abnormal data is not met, the normal data is judged: the current electricity consumption type of the user is large industry, the current existence state of the user is pause or pause resume, and the current electricity price code of the metering point is the electricity price;

the abnormal user of the sales user judges abnormal data when the following criteria are met at the same time, and judges normal data if at least one of the abnormal user and the abnormal user is not met: the user's present period on-the-way sales bill or the user's present period total electricity charge is not zero and the user's present period user status is sales user, at the same time the user's present period sales date is not empty and the metering point present period electricity price code is the present price;

the high-voltage pause service exists in the last month, when the following several standards are simultaneously met, abnormal data are judged, and if at least one of the abnormal data is not met, normal data are judged: the related transformer information that the state of existence at the upper period of the metering point is high-voltage suspension and the current electricity price code of the metering point is the electricity price;

the change type work order is effective during the charging period, when the following several standards are met at the same time, abnormal data are judged, and if at least one of the standards is not met, normal data are judged: the metering point has a metering point change record that the charging work order is not empty and the business class is changed, and the metering point has a current electricity price code as the current electricity price;

When the following criteria are met at the same time, the abnormal data is judged, and if at least one of the criteria is not met, the normal data is judged: the metering point has a work order in the current period and the metering point has an electricity price code in the current period as the electricity price.

Step S4, according to different marking states of each item of data, including abnormal marking and normal marking, the system classifies and outputs data in the user business expansion archive data according to the marking to be output to an archive exception checking locking and unlocking module for locking processing, the data are further input to a database for storage, and meanwhile, the data in the abnormal data state are transmitted to a foreground display module for display;

fool-proof and error-proof measures for manual processing on the system reduce the possibility of misissuing abnormal user electric bill due to manual misoperation, utilize the system to automatically lock the abnormal user data function, and then carry out checking, correcting and unlocking to form correction closed-loop management on abnormal business expansion data

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

In a specific embodiment, the data correction is specifically that the system displays the user with the abnormal mark according to the user number, the warning information and the user basic data column, locks the data, classifies and unlocks the abnormal locking data according to the difference of the user, the meter reading section and the power supply unit after checking and correcting to confirm no error by a system administrator, and releases the abnormal checking and locking to perform normal electric charge distribution on the abnormal marked user electric charge data; firstly, the system outputs abnormal data users after checking operation and checking, then the system checking and locking function automatically searches the users and locks the data, the next process flow is not allowed, the system is manually unlocked until the users are checked and corrected one by one, and then the corrected user data can normally enter the next stage process; if the customer has the requirement of timeliness, and the checking judgment has no influence on the current electric charge calculation result, the current electric charge calculation result can be transmitted to a normal electric charge calculation and release flow through rechecking.

As shown in fig. 3, the embodiment of the present invention further provides a system for intercepting user billing data anomalies in an electricity price system, for implementing the method described above, where the system includes:

the data interaction module is used for carrying out identification acquisition through a data interface and a database of the marketing system or recording related data in real time, carrying out data recording against paper business expansion work orders, meter reading records and account information, and carrying out data and parameter recording through on-site investigation;

the business expansion charging archive data anomaly checking and intercepting module is used for carrying out deep analysis and logic comparison on related electricity price standards, electricity price execution specifications and execution policies on preset conditions of different electricity prices and electricity price calculation logic, after the abnormal business expansion archive data of a user are intercepted by the module, displaying the rule name for judging the anomaly in a warning information mode for checking assistance, after the abnormal business expansion archive data of the user are intercepted by the model, displaying the rule name for judging the anomaly in a warning information mode for checking assistance by a management department, wherein the possibility that the same anomaly user is intercepted by more than or equal to one anomaly rule judgment, and the number of warning information displayed by the same user is increased 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 is made to the foregoing description of the drawings, which is 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, an accurate and comprehensive abnormal data checking and intercepting rule algorithm is adopted, and according to the process, standardization and automation, the total number of users are checked one by one in each electricity fee calculation period, and the user data passing the checking can normally enter the next process through periodic iterative checking, so that the quality of basic user data is effectively improved, and the electricity fee calculation accuracy is improved;

The above disclosure is only a preferred embodiment of the present invention, and it is needless to say that the scope of the invention is not limited thereto, and therefore, the equivalent changes according to the claims of the present invention still fall within the scope of the present invention.

Claims

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

s5, the system corrects the data in the abnormal state, reminds an administrator to review at the same time, and updates the data in the database;

in step S1, the user service expansion charging profile data includes: transformer archive data, electricity price archive data, metering point relation archive data, power regulation electricity fee archive data, special electricity price archive data, business change first charging archive data and business work order archive data;

in step S3, the specific determining process for the power rate profile data in the power consumption standard includes:

the capacity of the transformer is more than or equal to 100KW, the force adjustment is not executed, when the following standards are simultaneously met, abnormal data are judged, and if at least one of the standards is not met, normal data are judged: the rated capacity of the associated transformer in the current period of the metering point is larger than or equal to the reference value of contract capacity, the current period of the metering point is a special transformer, the current price of the metering point is not resident price, the current power factor standard of the metering point is not checked, the current price code of the metering point does not contain no price parameter, the current period of the user is not a co-transformer associated user, and the current period of the metering point has no total score relation;

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

the resident mischecks the power and transfers, when meeting the following two standard at the same time, judge to be abnormal data, if at least one item does not meet, judge to be normal data: the current electricity price of the metering point belongs to the resident electricity price class and the current power factor of the metering point is checked;

a user with a capacity of less than 100KW and a powerful tuning criterion is judged to be abnormal data when the following criteria are simultaneously met, and is judged to be normal data if at least one of the criteria is not met: the rated capacity sum of the transformer associated with the metering point in the period is smaller than the reference value of the common electric capacity, the power factor of the metering point in the period is set to be checked, the metering point in the period has no total score relation, the metering point in the period has no self-provided change relation, and the electricity price code of the metering point in the period is not equal to the electroless electricity price.

2. The method of claim 1, wherein in step S3, the specific determining process of electricity price profile data in the electricity consumption standard includes:

the low power supply and low electricity price of the user is judged to be abnormal data when the following several standards are simultaneously met, and is judged to be normal data when at least one of the standards is not met: the metering mode of the metering point in the period is that the voltage level of the metering point in the period is more than or equal to 10KV, the metering point in the period is not in agricultural production, the metering point in the period is not in running water electricity price, the metering point in the period is not in agricultural irrigation, the metering point in the period is not in resident life electricity, and the metering point in the period is not in the current electricity price code of the metering point in the period;

The common industry does not charge according to time sharing, when the standard is satisfied, abnormal data is judged, if at least one of the standard is not satisfied, normal data is judged, the metering point current period electricity consumption type is the common industry, the metering point current period non-time sharing charging is performed, the metering point current period electricity price voltage level is between 1KV and 10KV, and the metering point current period electricity price code has electricity price;

the common type electricity price is not matched with the capacity, when the common type electricity price meets the following several standards at the same time, abnormal data are judged, if at least one of the common type electricity price is not met, normal data are judged, wherein the rated capacity sum of the transformer is related to the current period operation of the metering point, the capacity sum is more than or equal to a reference value, the current period electricity price name of the metering point comprises common electricity price, the current period electricity price voltage level of the metering point is less than or equal to 35 kilovolts, the current period of a user is not a common type of related user, and the current period of the metering point has no total score relation;

3. The method of claim 2, wherein in step S3, the specific determining process of the transformer profile data in the electricity consumption standard includes:

4. A method according to claim 3, wherein in step S3, the specific determining procedure of the metering point relationship profile data in the electricity consumption standard includes:

5. The method as set forth in claim 4, wherein in step S3, the specific determining process of the special electricity price file data in the electricity consumption standard includes:

6. The method as set forth in claim 5, wherein in step S3, the specific determining procedure for the service change first charging profile data in the electricity usage standard includes:

7. The method as set forth in claim 6, wherein in step S3, the specific determining procedure for the business work order profile data in the electricity consumption standard includes:

8. The method of claim 7, wherein in step S5, the data correction means that the system displays the user with the abnormal mark according to the user number, the warning information and the user basic data sequence, locks the data, classifies and unlocks the abnormal locking data according to the differences of the user, the meter reading section and the power supply unit after checking and confirming the correction by the system administrator, and releases the abnormal checking and locking, and the abnormal marked user electricity fee data performs normal electricity fee distribution.

9. A system for intercepting user billing data anomalies in an electricity pricing system, characterized in that it implements a method according to any one of claims 1 to 8, said system comprising:

the data interaction module is used for connecting with a database of the marketing system through a data interface and inputting related data in real time;

10. The system of claim 9, wherein the business expansion charging profile data anomaly checking and intercepting module comprises: