Information Systems:Pharmacist license validation issue - Revision history

Norwinu at 23:37, 9 December 2016

2016-12-09T23:37:16Z

Norwinu: /* General */

2016-12-09T23:36:13Z

General

Norwinu: /* Known facts */

2016-12-09T23:33:34Z

Known facts

Norwinu: /* Kroll */

2016-12-09T23:27:25Z

Kroll

Norwinu: /* Kroll */

2016-12-09T23:25:49Z

Kroll

Norwinu: /* Overview */

2016-12-09T22:55:48Z

Overview

Norwinu at 22:54, 9 December 2016

2016-12-09T22:54:38Z

Norwinu at 21:36, 9 December 2016

2016-12-09T21:36:28Z

Norwinu: /* Web Orders */

2016-12-09T19:42:51Z

Web Orders

Norwinu: /* Kroll */

2016-12-09T18:49:41Z

Kroll

← Older revision		Revision as of 23:37, 9 December 2016
Line 51:		Line 51:

	[[Category: I.T. History]]		[[Category: I.T. History]]
		+	[[Category: Ordering]]

@@ Line 10: / Line 10: @@
 ===General===
 * The system (i.e. CNS,IOP) was designed to validate pharmacist numbers against the ''store number (customer number) only''. CNS does have records linking ''individual users'' to their pharmacist license numbers, but the line-level checking in IOP and Web Orders checks against customer number only.
-* Exempted codeine products brought this issue to light. This is a class of drugs that, by Health Canada regulations, requires the wholesaler to sell to pharmacies as if it were a narcotic, but allows the pharmacies to sell to the general public as an OTC/BTC product. This two-faced regulation is one of the main reasons this issue came to light and is also the cause of difficulties in the logistical processing/management of these products.
+* Exempted codeine products are really what brought this issue to light and they are responsible for half of the entries in the order error log. This is a class of drugs that, by Health Canada regulations, requires the wholesaler to sell to pharmacies as if it were a narcotic, but allows the pharmacies to sell to the general public as an OTC/BTC product. This two-faced regulation is one of the main reasons this issue came to light and is also the cause of difficulties in the logistical processing/management of these products.
 ===Kroll-specific issues===

@@ Line 12: / Line 12: @@
 * Exempted codeine products brought this issue to light. This is a class of drugs that, by Health Canada regulations, requires the wholesaler to sell to pharmacies as if it were a narcotic, but allows the pharmacies to sell to the general public as an OTC/BTC product. This two-faced regulation is one of the main reasons this issue came to light and is also the cause of difficulties in the logistical processing/management of these products.
-===Kroll===
+===Kroll-specific issues===
 * Orders for C/T (controlled/targeted) drugs are not transmitted with the pharmacist license number in Kroll. This is the reason benzos ordered through Kroll showed up in the query report.
 :* The N2 EDI segment where the pharmacist number should be is completely blank in the file for these orders. It is likely (but remains to be proven) that the presence of one of these C/T drugs in the order wipes out the N2 field (so the entire order is transmitted without the pharmacist license).
@@ Line 20: / Line 20: @@
 * (Dec. 9, 2016) Jeff at Medicine Chest reported that as of Dec. 2016, Yukon is implementing a Pharmanet-type system that the MC stores are piloting. This system was recently integrated into Kroll but is currently causing an issue: Kroll is reading the pharmacist IDs of the government system and using those as the license numbers. Thus, Kroll orders from Medicine Chest are generating error messages for all narcotic line items due to these erroneous numbers used as the pharmacist license. Kroll is working on a fix.
-===Web Orders===
+===Web Orders-specific issues===
 * Comments in the code suggest that attempts to checkout a web order containing a narcotic but without a pharmacist license number should throw an alert but can be bypassed and eventually processed. However, this was never implemented. Thus '''Web Orders does not allow placing an order with an invalid or missing pharmacist number'''.
@@ Line 28: / Line 28: @@
 * There seems to be a glitch when Web Orders validates a manually entered number on the checkout/cart page (where it prompts you to enter a license number if one isn't associated with your user account and there is a narcotic in the order). According to IOPERRP (the log of IOP errors), we've received web orders that shouldn't have been allowed to be submitted in the first place due to a missing/invalid number. See section WSPHARMVAL below for a more detailed discussion.
 ==WSPHARMVAL - Validation program==

@@ Line 15: / Line 15: @@
 * Orders for C/T (controlled/targeted) drugs are not transmitted with the pharmacist license number in Kroll. This is the reason benzos ordered through Kroll showed up in the query report.
 :* The N2 EDI segment where the pharmacist number should be is completely blank in the file for these orders. It is likely (but remains to be proven) that the presence of one of these C/T drugs in the order wipes out the N2 field (so the entire order is transmitted without the pharmacist license).
-:* It was discovered that Kroll was aware of this in late 2014; it was a deliberate move to take it out of their code due to massive customer complaints that orders were being stopped due to issues with the pharmacist license number. This was before my time, there are few details regarding this.
+:* It was discovered that Kroll was aware of this in late 2014 and that it was actually a deliberate move to take it out of their code due to massive customer complaints that orders were being stopped due to issues with the pharmacist license number. This was before my time, there are few details regarding this.
-:* Kroll is making an update to reverse this change, it will be implemented in V10 SP9, and will be made effective January 2017.
+:* Kroll is making an update to reverse this change. It will be implemented in V10 SP9, and will be made effective January 2017.
 * (Dec. 9, 2016) Jeff at Medicine Chest reported that as of Dec. 2016, Yukon is implementing a Pharmanet-type system that the MC stores are piloting. This system was recently integrated into Kroll but is currently causing an issue: Kroll is reading the pharmacist IDs of the government system and using those as the license numbers. Thus, Kroll orders from Medicine Chest are generating error messages for all narcotic line items due to these erroneous numbers used as the pharmacist license. Kroll is working on a fix.

@@ Line 15: / Line 15: @@
 * Orders for C/T (controlled/targeted) drugs are not transmitted with the pharmacist license number in Kroll. This is the reason benzos ordered through Kroll showed up in the query report.
 :* The N2 EDI segment where the pharmacist number should be is completely blank in the file for these orders. It is likely (but remains to be proven) that the presence of one of these C/T drugs in the order wipes out the N2 field (so the entire order is transmitted without the pharmacist license).
-: It was discovered that Kroll was aware of this in late 2014; it was a deliberate move to take it out of their code due to massive customer complaints that orders were being stopped due to issues with the pharmacist license number. This was before my time, there are few details regarding this.
+:* It was discovered that Kroll was aware of this in late 2014; it was a deliberate move to take it out of their code due to massive customer complaints that orders were being stopped due to issues with the pharmacist license number. This was before my time, there are few details regarding this.
-: Kroll is making an update to reverse this change, it will be implemented in V10 SP9, and will be made effective January 2017.
+:* Kroll is making an update to reverse this change, it will be implemented in V10 SP9, and will be made effective January 2017.
 ===Web Orders===

@@ Line 2: / Line 2: @@
 '''It's about time a wiki page was started for this issue.'''
-In August 2016, it was discovered that there were a lot of narcotics orders being processed with an invalid or completely missing pharmacist license number. Querying order history files showed various patterns regarding pharmacist license number transmission, and it was quickly realized that this problem was multi-faceted and quite large in scope. This page attempts to log everything we know about this issue.
+In August 2016, it was discovered that there were a lot of narcotics orders being processed with an invalid or completely missing pharmacist license number. Querying the order history log showed various patterns regarding pharmacist license number transmission and order sources, and it was quickly realized that this problem was multi-faceted and quite large in scope. This page attempts to log everything we know about this issue.
 <code>''The discussion here is meant to be technical; if a more generic page becomes warranted, we'll cross that bridge... -[[User:Norwinu|norwizzle]] ([[User talk:Norwinu|talk]]))''</code>

@@ Line 24: / Line 24: @@
 * For an order containing a narcotic, Web Orders will use the pharmacist number associated with the user account (i.e. in the users table). If one is not present, it will use the one entered on the cart page prior to final checkout/order submission. If one is not entered, an error is thrown.
 ==WSPHARMVAL - Validation program==
-WSPHARMVAL is the black-box program responsible for validating pharmacist license number. It was made by Sheila circa 2010. This is the program that is called during order line item-level checking by IOPEDT01, which
+WSPHARMVAL is the black-box program responsible for validating pharmacist license numbers. It was made by Sheila circa 2010. This is the program that is called when IOP does its item-level checks (called by IOPEDT01), and the outcome of this routine is used to determine the error code, if any, for the OMS alert (either missing or invalid number). WSPHARMVAL is also called by Web Orders to check the manually inputted number in the cart checkout page (see Web Orders section above). This is a form validation check and will not allow the submission of the order if the response returned is "invalid".
 [[Category: I.T. History]]

@@ Line 22: / Line 22: @@
 * Web Orders stores the pharmacist license number along with the user account information in its own table (WSUSERP), separate from CNS. That is, there is a pharmacist number field in the users table.
-* For an order containing a narcotic, Web Orders will use the pharmacist number in the users table. If one is not present, it will use the one entered on the cart page prior to final checkout/order submission. If one is not entered, an error is thrown.
+* For an order containing a narcotic, Web Orders will use the pharmacist number associated with the user account (i.e. in the users table). If one is not present, it will use the one entered on the cart page prior to final checkout/order submission. If one is not entered, an error is thrown.
 [[Category: I.T. History]]