CN111950893A - Formula management system - Google Patents

Formula management system Download PDF

Info

Publication number
CN111950893A
CN111950893A CN202010802792.XA CN202010802792A CN111950893A CN 111950893 A CN111950893 A CN 111950893A CN 202010802792 A CN202010802792 A CN 202010802792A CN 111950893 A CN111950893 A CN 111950893A
Authority
CN
China
Prior art keywords
formula
query
drug
unit
code
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202010802792.XA
Other languages
Chinese (zh)
Inventor
张小利
穆竟伟
王国明
路发凯
马梦杰
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
SHANGHAI KAIBAO PHARMACEUTICAL CO Ltd
Shanghai Kaibao Health Technology Co ltd
Original Assignee
SHANGHAI KAIBAO PHARMACEUTICAL CO Ltd
Shanghai Kaibao Health Technology Co ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by SHANGHAI KAIBAO PHARMACEUTICAL CO Ltd, Shanghai Kaibao Health Technology Co ltd filed Critical SHANGHAI KAIBAO PHARMACEUTICAL CO Ltd
Priority to CN202010802792.XA priority Critical patent/CN111950893A/en
Publication of CN111950893A publication Critical patent/CN111950893A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00Administration; Management
    • G06Q10/06Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F21/00Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
    • G06F21/30Authentication, i.e. establishing the identity or authorisation of security principals
    • G06F21/31User authentication
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q50/00Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
    • G06Q50/04Manufacturing
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F2221/00Indexing scheme relating to security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
    • G06F2221/21Indexing scheme relating to G06F21/00 and subgroups addressing additional information or applications relating to security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
    • G06F2221/2141Access rights, e.g. capability lists, access control lists, access tables, access matrices
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02PCLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
    • Y02P90/00Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
    • Y02P90/30Computing systems specially adapted for manufacturing

Abstract

The invention provides a formula management system, which relates to the technical field of formula management of pharmaceutical enterprises and comprises the following components: the formula storage module comprises a plurality of storage areas, and each storage area correspondingly stores a medicine formula; the formula inquiry module is used for verifying the access authority and the access password of an external inquirer according to the received inquirer information, traversing the production plan according to the formula inquiry instruction when the verification is passed so as to inquire whether the production plan contains the formula code or not and output an inquiry result, and giving an illegal inquiry alarm when the verification is not passed; sending a formula query instruction to a formula manager, and outputting an audit result when the audit pass feedback is received or the audit pass feedback is not received in a preset time period and the query result shows that the production plan contains a formula code; and sending the medicine formula corresponding to the formula code to an external inquirer according to the audit result. The method has the advantages of effectively reducing the management risk of the medicine formula and preventing the medicine formula from being leaked.

Description

Formula management system
Technical Field
The invention relates to the technical field of formula management of pharmaceutical enterprises, in particular to a formula management system.
Background
The production formula is the basis of factory production activities, the formula management in the system is also the basis of all other functions of the MES, and standard data required by the other functions are required to be set in the formula management. The formula usually comprises the effective time, the state, the auditor and the unit number of the formula; the materials in the BOM include information such as an input sequence, whether weighing is required, an input stage (process segment), a unit quantity, etc., so once a production formula is leaked, other companies or members are likely to counterfeit the products, the market order is disturbed, meanwhile, the circulation of the imitation drugs caused by the leakage of the production formula, especially a drug formula, also poses a threat to the life safety of people, and how to effectively manage the production formula becomes a technical problem to be solved urgently.
Disclosure of Invention
Aiming at the problems in the prior art, the invention provides a formula management system which is used for medicine formula management of a pharmaceutical enterprise, and is provided with a production management module in advance for storing a production plan of the pharmaceutical enterprise; the formula management system specifically comprises:
the formula storage module comprises a plurality of storage areas, each storage area correspondingly stores a medicine formula, each medicine formula has a preset formula code, and each storage area is pre-configured with a corresponding access authority and an access password;
the formula query module is respectively connected with the formula storage module and the production management module, and the formula management module comprises:
the verification unit is used for receiving a formula query instruction which is sent by an external querier and contains querier information and the formula code, verifying the access authority and the access password of the external querier according to the querier information, generating a first verification signal when the verification is passed, and generating a second verification signal when the verification is not passed;
the query unit is connected with the verification unit and used for traversing the production plan according to the first verification signal and the formula query instruction so as to query whether the production plan contains the formula code or not and outputting a query result;
the checking unit is connected with the inquiring unit and used for sending the formula inquiring instruction to a preset formula manager and outputting a checking result when checking pass feedback is received or the checking pass feedback is not received in a preset time period and the inquiring result shows that the production plan contains the formula codes;
and the output unit is respectively connected with the verification unit and the auditing unit and used for giving an illegal inquiry alarm according to the second verification signal and sending the medicine formula corresponding to the formula code to the external inquirer according to the auditing result.
Preferably, each of the drug formulas includes a version number of the drug formula and a corresponding expiration date start time;
the output unit sends the drug formula with the latest version number corresponding to the formula code to the external inquirer according to the audit result.
Preferably, the formula storage module further includes an expiration date monitoring unit, respectively connected to each of the storage areas, and configured to respectively calculate whether each of the drug formulas is within a preset expiration date according to the acquired expiration date start time of each of the drug formulas, and generate expiration date warning information including the formula code when the drug formula is not within the preset expiration date, so as to prompt the formula manager.
Preferably, the composition raw materials in each of the pharmaceutical formulations include a plurality of common raw materials and a plurality of core raw materials, in the pharmaceutical formulations, each of the common raw materials is represented by a raw material name, and each of the core raw materials is represented as a whole by a preset raw material code.
Preferably, the formula storage module further includes an experiment data repository, which is used for storing experiment data of each drug formula by a developer of the drug formula in a research and development process, and the experiment data repository is preconfigured with corresponding research and development access rights.
Preferably, the recipe query module further includes a recording unit, connected to the audit unit, and configured to generate an automatic review record including the recipe query instruction and the automatic audit time when the audit result indicates that the audit pass feedback is not received within a preset time period and the query result indicates that the production plan includes the recipe code, and send the automatic review record to the recipe manager.
Preferably, the formula query module further includes an alarm log unit, connected to the output unit, and configured to generate an alarm log according to the obtained illegal query alarm, the alarm time of the illegal query alarm, and the associated formula query instruction, so that the formula manager can view and process the alarm log.
The technical scheme has the following advantages or beneficial effects:
1) the method is convenient for the classified management of various drug formulas, and can set different levels of access authorities and access passwords for the storage areas corresponding to the drug formulas according to the important levels of the drug formulas, so that the drug formulas with lower important levels can be conveniently checked, meanwhile, the drug formulas with higher important levels can be effectively prevented from being leaked, and the management risk of the drug formulas is effectively reduced;
2) and a multi-layer verification mode is adopted during prescription calling, so that normal production is ensured to be smoothly carried out while illegal inquiry calling is avoided, and leakage of a medicine prescription is prevented.
Drawings
FIG. 1 is a schematic diagram of a recipe management system according to a preferred embodiment of the present invention.
Detailed Description
The invention is described in detail below with reference to the figures and specific embodiments. The present invention is not limited to the embodiment, and other embodiments may be included in the scope of the present invention as long as the gist of the present invention is satisfied.
In the preferred embodiment of the present invention, based on the above problems in the prior art, a formula management system is now provided, which is used for drug formula management of pharmaceutical enterprises and also for production formula management of health products and health products, etc., as shown in fig. 1, a production management module 1 is preset for storing production plans of pharmaceutical enterprises; the formula management system specifically comprises:
the formula storage module 2 comprises a plurality of storage areas 21, each storage area 21 correspondingly stores a medicine formula, each medicine formula has a preset formula code, and each storage area 21 is pre-configured with a corresponding access right and an access password;
the formula inquiry module 3 is respectively connected with the formula storage module 2 and the production management module 1, and the formula management module 3 comprises:
the verification unit 31 is used for receiving a formula inquiry instruction which is sent by an external inquirer and contains inquirer information and formula codes, verifying the access authority and the access password of the external inquirer according to the inquirer information, generating a first verification signal when the verification is passed, and generating a second verification signal when the verification is not passed;
the query unit 32 is connected with the verification unit 31 and used for traversing the production plan according to the first verification signal and the formula query instruction so as to query whether the production plan contains the formula code or not and outputting a query result;
the checking unit 33 is connected to the querying unit 32, and is configured to send the recipe querying instruction to a preset recipe manager, and output a checking result when the feedback of passing the checking is received, or when the feedback of passing the checking is not received within a preset time period and the querying result indicates that the production plan includes the recipe code;
and the output unit 34 is respectively connected with the verification unit 31 and the auditing unit 33, and is used for giving an illegal inquiry alarm according to the second verification signal and sending the medicine formula corresponding to the formula code to an external inquirer according to the auditing result.
Specifically, in this embodiment, the formula storage module 2 is divided into a plurality of storage areas, and corresponding access permissions and access passwords are configured in advance for each storage area, so that the classification management of multiple drug formulas is facilitated, a pharmaceutical enterprise can set access permissions and access passwords of different levels for the storage areas corresponding to the drug formulas according to the importance levels of the drug formulas, so that a person with a low-level access permission can only check the drug formula with a lower importance level, the leakage of the drug formula with a higher importance level can be effectively avoided while the drug formula with a lower importance level is checked conveniently, and the management risk of the drug formula is effectively reduced. Meanwhile, each medicine formula is configured with a corresponding formula code, and the medicine formula is not represented by a medicine finished product name with an obvious identifier and the like, so that the leakage of the medicine formula is further prevented.
Further, during the production of the drug, the corresponding drug formulation needs to be used for the ingredient, the management and control of the production process, and the like, so that the corresponding drug formulation needs to be checked and called. In this embodiment, when an external inquirer needs to perform inquiry operation of a medicine formula, it is first necessary to verify an access right and an access password of the external inquirer, that is, it is determined whether the external inquirer has an access right of a storage area corresponding to the medicine formula and whether the access password is correct, only after the two items of information are verified, subsequent checking and calling actions are performed, and if any one item of information is not verified, an illegal inquiry alarm is given.
Further, after the two items of information are verified, traversing the production plan according to the formula query instruction to determine whether the currently queried medicine formula is in the production plan, that is, determining whether the current query is required for production, and using the current query in a subsequent auditing process.
Further, after the query process is performed and the query result is obtained, the formula query instruction is sent to a formula manager for auditing, the formula manager may not give an audit result in time for various reasons, if the query result indicates that the currently queried drug formula is in the production plan, if the query result does not receive the feedback of the audit pass given by the formula manager within the preset time period, the formula query instruction is defaulted to be an automatic audit pass while protecting the drug formula, and then the corresponding drug formula is sent to an external inquirer for checking and use.
In a preferred embodiment of the present invention, each drug formulation comprises a version number of the drug formulation and a corresponding expiration date start time;
the output unit 34 sends the drug formula with the latest version number corresponding to the formula code to the external inquirer according to the audit result.
In a preferred embodiment of the present invention, the formula storage module 2 further includes an expiration date monitoring unit 22, respectively connected to each storage area 21, for respectively calculating whether each drug formula is within the preset expiration date according to the obtained expiration date start time of each drug formula, and generating an expiration date warning message containing a formula code when the drug formula is not within the preset expiration date, so as to prompt a formula manager.
Specifically, in this embodiment, the preset validity period is preferably 15 days before the actual validity period of the drug formula, that is, the validity period warning information of the drug formula is given 15 days in advance, which is convenient for a formula manager to correct and process in time, and ensures the validity of the drug formula.
In a preferred embodiment of the present invention, the constituent materials in each pharmaceutical formulation include a plurality of common materials and a plurality of core materials, wherein in the pharmaceutical formulation, each common material is represented by a material name, and each core material is represented as a whole by a predetermined material code.
In a preferred embodiment of the present invention, the formula storage module 2 further includes an experimental data repository 23, which is used for storing experimental data of each drug formula in a research and development process by a research and development staff of the drug formula, and the experimental data repository is pre-configured with corresponding research and development access rights.
Specifically, in this embodiment, the access level of the research and development access right is higher than the access level of each storage area. The experimental data of each drug formula are independently stored and configured with corresponding research and development access rights, so that the management of the experimental data is facilitated, a data base is provided for the research and development upgrading of the subsequent drug formula, and the problems of record loss, difficult storage and the like caused by the fact that data recording is realized in a paper form are solved.
In a preferred embodiment of the present invention, the recipe query module 3 further includes a recording unit 35, connected to the audit unit 33, for generating an automatic review record including a recipe query instruction and an automatic audit time and sending the record to a recipe manager when the audit result indicates that the audit pass feedback is not received within the preset time period and the query result indicates that the production plan includes the recipe code.
Specifically, in this embodiment, by querying the automatic over-examination record, the formula manager can timely know the formula of the drug that passes the automatic examination and the automatic examination time, and thus data tracing is facilitated.
In a preferred embodiment of the present invention, the recipe query module 3 further includes an alarm log unit 36 connected to the output unit 34, and configured to generate an alarm log according to the obtained illegal query alarm, the alarm time of the illegal query alarm, and the associated recipe query instruction, so that a manager of the recipe can check and process the alarm log.
While the invention has been described with reference to a preferred embodiment, it will be understood by those skilled in the art that various changes in form and detail may be made therein without departing from the spirit and scope of the invention.

Claims (7)

1. A formula management system is used for medicine formula management of a pharmaceutical enterprise and is characterized in that a production management module is preset and used for storing a production plan of the pharmaceutical enterprise; the formula management system specifically comprises:
the formula storage module comprises a plurality of storage areas, each storage area correspondingly stores a medicine formula, each medicine formula has a preset formula code, and each storage area is pre-configured with a corresponding access authority and an access password;
the formula query module is respectively connected with the formula storage module and the production management module, and the formula management module comprises:
the verification unit is used for receiving a formula query instruction which is sent by an external querier and contains querier information and the formula code, verifying the access authority and the access password of the external querier according to the querier information, generating a first verification signal when the verification is passed, and generating a second verification signal when the verification is not passed;
the query unit is connected with the verification unit and used for traversing the production plan according to the first verification signal and the formula query instruction so as to query whether the production plan contains the formula code or not and outputting a query result;
the checking unit is connected with the inquiring unit and used for sending the formula inquiring instruction to a preset formula manager and outputting a checking result when checking pass feedback is received or the checking pass feedback is not received in a preset time period and the inquiring result shows that the production plan contains the formula codes;
and the output unit is respectively connected with the verification unit and the auditing unit and used for giving an illegal inquiry alarm according to the second verification signal and sending the medicine formula corresponding to the formula code to the external inquirer according to the auditing result.
2. The formula management system according to claim 1, wherein each of said drug formulas includes a version number of said drug formula and a corresponding expiration start time;
the output unit sends the drug formula with the latest version number corresponding to the formula code to the external inquirer according to the audit result.
3. The formula management system according to claim 2, wherein the formula storage module further comprises a validity period monitoring unit respectively connected to each of the storage areas, and configured to respectively calculate whether each of the drug formulas is within a preset validity period according to the obtained validity period start time of each of the drug formulas, and generate validity period warning information including the formula code to prompt the formula manager when the drug formula is not within the preset validity period.
4. The formula management system according to claim 1, wherein the constituent materials in each of the drug formulas include a plurality of common materials and a plurality of core materials, and wherein in the drug formula, each of the common materials is represented by a material name and each of the core materials is represented as a whole by a predetermined material code.
5. The formula management system of claim 1, wherein the formula storage module further comprises an experiment data repository for storing experiment data of each drug formula during a research and development process for developers of the drug formulas, and the experiment data repository is pre-configured with corresponding research and development access rights.
6. The recipe management system according to claim 1, wherein the recipe query module further comprises a recording unit, connected to the audit unit, configured to generate an automatic over-review record including the recipe query instruction and an automatic audit time and send the automatic over-review record to the recipe manager when the audit result indicates that the audit pass feedback is not received within a preset time period and the query result indicates that the production plan includes the recipe code.
7. The recipe management system according to claim 1, wherein the recipe query module further comprises an alarm log unit, connected to the output unit, for generating an alarm log according to the obtained illegal query alarm, the alarm time of the illegal query alarm, and the associated recipe query instruction, so as to be viewed and processed by the recipe manager.
CN202010802792.XA 2020-08-11 2020-08-11 Formula management system Pending CN111950893A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202010802792.XA CN111950893A (en) 2020-08-11 2020-08-11 Formula management system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202010802792.XA CN111950893A (en) 2020-08-11 2020-08-11 Formula management system

Publications (1)

Publication Number Publication Date
CN111950893A true CN111950893A (en) 2020-11-17

Family

ID=73331664

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202010802792.XA Pending CN111950893A (en) 2020-08-11 2020-08-11 Formula management system

Country Status (1)

Country Link
CN (1) CN111950893A (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113409107A (en) * 2021-06-09 2021-09-17 携程商旅信息服务(上海)有限公司 Protocol air ticket order creating method, system, electronic equipment and storage medium
CN113919820A (en) * 2021-11-02 2022-01-11 杭州以诺行汽车科技股份有限公司 Formula management system based on ERP system and control method

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103279431A (en) * 2013-05-23 2013-09-04 青岛海信宽带多媒体技术有限公司 Access method for kinds of permissions of memorizer
CN104808639A (en) * 2015-04-29 2015-07-29 中国石油大学(华东) Pharmaceutical product manufacturing execution system and method
CN105549570A (en) * 2016-01-29 2016-05-04 苏州浙远自动化工程技术有限公司 Traditional Chinese medicine smart factory integration system
CN108960759A (en) * 2018-04-25 2018-12-07 广州恩锐施智能科技有限公司 A kind of batch formulation management system
CN109357736A (en) * 2018-09-29 2019-02-19 昆山博益鑫成高分子材料有限公司 A kind of batch weighing mistake proofing fool proof control method and system

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103279431A (en) * 2013-05-23 2013-09-04 青岛海信宽带多媒体技术有限公司 Access method for kinds of permissions of memorizer
CN104808639A (en) * 2015-04-29 2015-07-29 中国石油大学(华东) Pharmaceutical product manufacturing execution system and method
CN105549570A (en) * 2016-01-29 2016-05-04 苏州浙远自动化工程技术有限公司 Traditional Chinese medicine smart factory integration system
CN108960759A (en) * 2018-04-25 2018-12-07 广州恩锐施智能科技有限公司 A kind of batch formulation management system
CN109357736A (en) * 2018-09-29 2019-02-19 昆山博益鑫成高分子材料有限公司 A kind of batch weighing mistake proofing fool proof control method and system

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113409107A (en) * 2021-06-09 2021-09-17 携程商旅信息服务(上海)有限公司 Protocol air ticket order creating method, system, electronic equipment and storage medium
CN113919820A (en) * 2021-11-02 2022-01-11 杭州以诺行汽车科技股份有限公司 Formula management system based on ERP system and control method
CN113919820B (en) * 2021-11-02 2022-09-06 杭州以诺行汽车科技股份有限公司 Formula management system based on ERP system and control method

Similar Documents

Publication Publication Date Title
CN110992068A (en) Vaccine full life cycle management method and system based on block chain
US20070198477A1 (en) Systems and methods for managing regulatory information
US20080065418A1 (en) Systems and Methods to Manage Drug Accountability Processes in Clinical Trials
CN111950893A (en) Formula management system
JP7071490B2 (en) Dosage preparation data analysis
CN110751491A (en) Dangerous chemical supervision system based on block chain
CN112714894A (en) Method for managing a production process, computer program for carrying out the method and electronically readable data carrier
WO2018201199A1 (en) Tender management system
CN112330871A (en) Warehouse management method and device
CN116401691A (en) File authority management method, device, system, computer equipment and medium
US20220328174A1 (en) Centralized system for vaccination verification, inventory management, and analysis
US7054698B2 (en) System for tracking operator certification of FAB equipment and processes
CN114943521A (en) First-run data quality management transfer method following national GSP management standard
JP3909613B2 (en) Computer-readable recording medium recording design review processing system and design review processing program
JP2022095297A (en) Quality state visualization apparatus
Allaert Security standards for healthcare information systems: a perspective from the EU ISIS MEDSEC Project
WO1997007443A1 (en) Validation control system
CN115827640A (en) Information equipment full life cycle management method, system, medium and equipment
WO2022190433A1 (en) Information management system, information management method, and information management program
Steinborn GMP/ISO Quality Audit Manual for Healthcare Manufacturers and Their Suppliers,(Volume 1-With Checklists and Software Package)
Wilson et al. Software Development Life Cycle
CN114298782A (en) Online distribution interface platform system
CN116910821A (en) Data reading and writing method, device, equipment and storage medium
TW202046187A (en) Checking method for products making it more convenient to check the products
CN117094545A (en) Post authority locking method and system based on workflow engine

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
RJ01 Rejection of invention patent application after publication
RJ01 Rejection of invention patent application after publication

Application publication date: 20201117