白丝美女被狂躁免费视频网站,500av导航大全精品,yw.193.cnc爆乳尤物未满,97se亚洲综合色区,аⅴ天堂中文在线网官网

Pharmacy database structure component

專利號
US10867704B2
公開日期
2020-12-15
申請人
MediSite Inc.(US MI West Bloomfield)
發(fā)明人
Edward J. Eng
IPC分類
G06Q10/00; G16H50/30; G16H40/20; G16H20/10
技術(shù)領(lǐng)域
pharmacy,drug,database,computer,prescriber,retail,data,requester,component,pharmacist
地域: MI MI West Bloomfield

摘要

A data structure embodied on a computer-readable medium having a database schema for accessing and managing pharmacy transactions data in a structured query language (SQL) database. The database schema includes a session data schema representing a relational data table for capturing a plurality of sessions for accessing and managing the SQL database and a pharmacy prescription drug transaction results schema representing parameters for relating prescription drug transaction results with requesters, prescribers and the prescription drug. The session data schema and the pharmacy prescription drug transaction results schema used by a pharmacy business logic application to access and manage the pharmacy drug transaction results in the SQL database.

說明書

Regarding the prescriber, the component 300 can be queried for one or more of the following: (i) prescriber office location within hot spot zone; (ii) prescriber authored more than a threshold level (e.g., 20, 30 or 40) of the same C2-C5 drug being requested; (iii) prescriber authored greater than a threshold value (e.g., 40, 50 or 60) of any C2-C5 prescription drug; (iv) any prescriber patient denied same C2-C5 prescription drug being requested; (v) any prescriber patient denied any C2-C5 prescription drug; (vi) any prescriber patient purchased any C2-C5 prescription drug more than a certain number of miles, e.g., 10, 20 or 30 miles outside of ADI; and/or (vii) prescriber on “watch list” per local authorities.

The values of these queries relating to the patient/customer/requester, the pharmacy location, and/or the prescriber are categorized to obtain a level of risk associated with fulfilling the prescription request. In one example, the levels of risk can be associated with color indicators, such as green, yellow and red. The green indicator may indicate the current data stored in the component 300 is not currently considered a controlled prescription drug sales risk for the requested prescription drug. The yellow indicator may indicate that the current data stored in the component 300 suggest more interaction with the requester may be appropriate before deciding whether or not to fulfill the prescription request. The red indicator may indicate that the current data stored in the component 300 that fulfilling the prescription request is not recommended due to previously recorded information about the customer's controlled prescription drug transaction history, including request denials and controlled prescription consumption history.

權(quán)利要求

1
微信群二維碼
意見反饋