Produced by Araxis Merge on 7/9/2017 11:00:59 PM Eastern Daylight Time. See www.araxis.com for information about Merge. This report uses XHTML and CSS2, and is best viewed with a modern standards-compliant browser. For optimum results when printing this report, use landscape orientation and enable printing of background images and colours in your browser.
# | Location | File | Last Modified |
---|---|---|---|
1 | PPS_N_3.0_Iter2_Build_360.zip\Unredacted\PS_PPS_Hazardous_Upload | PPS-N Add Hazardous Waste Status Fields.docx | Fri Jun 30 18:59:56 2017 UTC |
2 | PPS_N_3.0_Iter2_Build_360.zip\Unredacted\PS_PPS_Hazardous_Upload | PPS-N Add Hazardous Waste Status Fields.docx | Fri Jul 7 13:39:24 2017 UTC |
Description | Between Files 1 and 2 |
|
---|---|---|
Text Blocks | Lines | |
Unchanged | 4 | 418 |
Changed | 3 | 6 |
Inserted | 0 | 0 |
Removed | 0 | 0 |
Whitespace | |
---|---|
Character case | Differences in character case are significant |
Line endings | Differences in line endings (CR and LF characters) are ignored |
CR/LF characters | Not shown in the comparison detail |
No regular expressions were active.
1 | Department of Vetera ns Affairs | |
2 | ||
3 | ||
4 | ||
5 | Pharmacy R eengineeri ng | |
6 | Pharmacy P roduct Sys tem (N) | |
7 | Version 3. 0 | |
8 | ||
9 | User Story | |
10 | Add Fields to Monito r Product Hazardous Waste Stat us | |
11 | ||
12 | ||
13 | ||
14 | 7 / 7 /201 7 | |
15 | ||
16 | ||
17 | ||
18 | Revision H istory | |
19 | ||
20 | Date | |
21 | Version | |
22 | Descriptio n | |
23 | Author | |
24 | 08/12/2015 | |
25 | 1.1 | |
26 | PBM Approv al | |
27 | W. Cobb | |
28 | 04/27/2015 | |
29 | 1.0 | |
30 | Initial cr eation | |
31 | W. Cobb | |
32 | ||
33 | ||
34 | ||
35 | ||
36 | Card | |
37 | RTC Story Artifact I D: 161191 RT C Story Ty pe: Epic | |
38 | RTC Story Headline: Add Fi elds to Mo nitory Pro duct Hazar dous Waste Status | |
39 | PWS Requir ement: Add fi elds to mo nitor the hazardous waste stat us of a VA product. Including the additi on of thes e fields t o VistA fi le #50.68. | |
40 | Product Ow ner: | |
41 | Alternate: | |
42 | Status: Approve d | |
43 | ||
44 | ||
45 | Story Desc ription | |
46 | As a PPS-N User, I w ant to add the field s that ide ntify the hazardous waste stat us of VA p roducts to PPS-N and VistA so that I am able to tr ack the ha zardous wa ste status in both P PS-N and V istA. | |
47 | ||
48 | Workflow/D iscussion | |
49 | As a PPS-N User, I w ant to add the field s that ide ntify the hazardous waste stat us of VA p roducts to PPS-N and VistA so that I am able to tr ack the ha zardous wa ste status in both P PS-N and V istA. | |
50 | I navigate to Manage PPS tab, select a p roduct, an d can see the follow ing fields on the Ad ministrati on Data ta b: | |
51 | Hazardous to Handle | |
52 | Hazardous to Dispose | |
53 | Primary EP A | |
54 | Waste Sort Code | |
55 | DOT Shippi ng Name | |
56 | I have rea d-only acc ess to the se fields if I am lo gged in as a Migrato r or Viewe r role. | |
57 | I have edi t access t o these fi elds if I am logged in as a Ma nager, Sec ond Approv er, or Sup ervisor ro le. | |
58 | I can also edit thes e fields a nd their v alues on t he A-Z tab . | |
59 | For the fi elds Hazar dous to Di spose and Hazardous to Handle, I can ind icate whet her the va lue for th e field is true or f alse (Bool ean). | |
60 | If I indic ate that t he product is Hazard ous to Dis pose, I am able to e nter value s for Prim ary EPA, W aste Sort Code, and DOT Shippi ng Name. | |
61 | The Primar y EPA is a text fiel d of up to 50 charac ters. | |
62 | The Waste Sort Code is a text field of u p to 50 ch aracters. | |
63 | The DOT Sh ipping Nam e is a tex t field of up to 50 characters . | |
64 | If I indic ate that a product i s not Haza rdous to D ispose aft er previou sly indica ting that the produc t was Haza rdous to D ispose and entered v alues for Primary EP A, Waste S ort Code, and/or DOT Shipping Name, the values for Primary E PA, Waste Sort Code, and/or DO T Shipping Name will remain, b ut the fie lds will b e grayed o ut and una ble to be edited. | |
65 | If a produ ct that is not Hazar dous to Di spose but has values for Prima ry EPA, Wa ste Sort C ode, and/o r DOT Ship ping Name is marked as Hazardo us to Disp ose, the v alues for Primary EP A, Waste S ort Code, and/or DOT Shipping Name are a vailable f or editing . | |
66 | The Hazard ous to Han dle field will be in itially po pulated at the Produ ct level b ased on th e followin g algorith m: | |
67 | The system shall ret rieve drug s classifi ed as Haza rdous to H andle from the Drug column in the “Sampl e List of Drugs that Should be Handled a s Hazardou s” table o f the “NIO SH List of Antineopl astic and Other Haza rdous Drug s in Healt hcare Sett ings 2014” document, located a t http:// DNS /niosh/doc s/2014-138 /pdfs/2014 -138.pdf ( referred t o as NIOSH PDF). | |
68 | 2012 NIOSH csv from VistA Inno vations pr oject | |
69 | ||
70 | The system shall per form a pri mary searc h for a dr ug Trade N ame from t he NIOSH P DF using a “contains ” search o n Synonym in the the PPS_N Ent erprise Pr oduct (EPL ) database . | |
71 | If the Syn onym searc h yields r esulting m atches to drug(s) in the PPS_N EPL datab ase, then for all re sulting ma tches, the system sh all set th e value of the Hazar dous to Ha ndle field to True ( checked) a t the Prod uct level. | |
72 | The system shall per form a sec ondary for the same drug Trade Name from the NIOSH PDF using a “contai ns” search on VA Pro duct Name. | |
73 | If the VA Product na me search yields res ulting mat ches to dr ug(s) in t he PPS_N E PL databas e, then fo r all resu lting matc hes, the s ystem shal l set the value of t he Hazardo us to Hand le field t o True (ch ecked) at the Produc t level. | |
74 | When a dru g (Trade N ame) loade d from the NIOSH PDF does NOT match any drug at th e PPS-N Pr oduct leve l either b y primary or seconda ry search, the syste m will log the drug in an Outp ut Excepti on Report file for m anual insp ection. | |
75 | I can view an Output Except fi le that li sts the dr ug Trade N ames that don’t find a match i n PPS-N | |
76 | The Hazard ous to Dis pose field will be p opulated b ased on th e followin g algorith m: | |
77 | The system shall ret rieve drug s classifi ed as Haza rdous to D ispose fro m the EPA STERICYCLE Rx WASTE CHARACTERI ZATION spr eadsheet, Formulary Summary ta b (referre d to as ST ERICYLE sp readsheet) . | |
78 | EPA STERIC YCLE Rx WA STE CHARAC TERIZATION spreadshe et | |
79 | ||
80 | Note that the latest version o f the Ster icycle spr eadsheet s hould be u sed – this is the mo st current version w e have as of 8/12/20 15. | |
81 | STERICYLE Spreadshee t from Vis tA Innovat ions proje ct | |
82 | ||
83 | The system shall per form a pri mary searc h for a dr ug NDC cod e from the STERICYCL E input fi le using a n NDC sear ch in the PPS_N Ente rprise Pro duct (EPL) database. | |
84 | If the sea rch on NDC yields an exact mat ch to an N DC code in the PPSN EPL databa se, the sy stem shall set the v alue of th e Hazardou s to Dispo se field t o True (ch ecked) at the Produc t level, a nd populat e the corr esponding Primary EP A Code, Wa ste Sort C ode and DO T Shipping Name fiel ds, and id entify the Generic N ame for th e product. | |
85 | The system shall per form a sec ondary “co ntains” se arch for t he drug Ge neric Name in the PP S_N EPL da tabase. | |
86 | If the Gen eric Name search yie lds result ing matche s to drug( s) in the PPS_N EPL database, then for a ll resulti ng matches , the syst em shall s et the val ue of the Hazardous to Dispose field to True (chec ked) at th e Product level, and populate the corres ponding Pr imary EPA Code, Wast e Sort Cod e and DOT Shipping N ame fields , and iden tify the S ynonym for each prod uct found. | |
87 | The system shall per form a ter tiary “con tains” sea rch on Syn onym in th e PPS_N EP L database for each product. | |
88 | If the Syn onym searc h yields r esulting m atches to drug(s) in the PPS_N EPL datab ase, then for all re sulting ma tches, the system sh all set th e value of the Hazar dous to Di spose fiel d to True (checked) at the Pro duct level , and popu late the c orrespondi ng Primary EPA Code, Waste Sor t Code and DOT Shipp ing Name f ields. | |
89 | If the pri mary searc h for an N DC code yi elds NO ex act match to an NDC code in th e PPS_N EP L database , the syst em will pe rform a se condary se arch for t he drug’s Product na me from th e STERICYC LE input f ile using a “contain s” search on Synonym in the PP S_N EPL da tabase. | |
90 | If the Syn onym searc h yields r esulting m atches to drug(s) in the PPS_N EPL datab ase, then for all re sulting ma tches, the system sh all set th e value of the Hazar dous to Di spose fiel d to True (checked) at the Pro duct level , and popu late the c orrespondi ng Primary EPA Code, Waste Sor t Code and DOT Shipp ing Name f ields, and identify the Generi c Name for each prod uct found. | |
91 | The system shall per form a ter tiary “con tains” sea rch on Gen eric Name in the PPS _N EPL dat abase for each Gener ic Name id entified. | |
92 | If the Gen eric Name search yie lds result ing matche s to drug( s) in the PPS_N EPL database, then for a ll resulti ng matches , the syst em shall s et the val ue of the Hazardous to Dispose field to True (chec ked) at th e Product level, and populate the corres ponding Pr imary EPA Code, Wast e Sort Cod e and DOT Shipping N ame fields . | |
93 | When a dru g NDC or P roduct Nam e loaded f rom the ST ERICYLE in put file d oes NOT ma tch any dr ug in the target PPS _N EPL dat abase, the system wi ll log the NDC, Prod uct Name, Primary EP A Code, Wa ste Sort C ode and DO T Shipping Name in a n Output E xception R eport file for manua l inspecti on. | |
94 | I can view an Output Except fi le that li sts the ND C, Product Name, Pri mary EPA C ode, Waste Sort Code and DOT S hipping Na me for eac h drug NDC or Produc t Name in the STERIC YCLE file that doesn ’t find a match in P PS-N. | |
95 | When an Up date File is created by schedu led proces s or I use the Creat e Update F ile option on the Ma nage Updat e Files pa ge, these fields are included in the Upd ate File. | |
96 | ||
97 | Note: See related us er story V istA Add H azardous W aste Statu s Fields | |
98 | ||
99 | ||
100 | ||
101 | ||
102 | Requiremen ts Impleme nted by th is Story | |
103 | RTC RM Art ifact ID | |
104 | Text | |
105 | 507175 | |
106 | The System shall all ow the add ition and maintenanc e of the f ollowing f ields to m onitor the hazardous waste sta tus of a V A product (EPL-N Pro ducts tabl e) and inc lude the a ddition of these fie lds to Vis tA file #5 0.68. | |
107 | 509627 | |
108 | The System shall all ow the add ition and maintenanc e of the f ollowing f ields on t he Adminis tration Da ta tab and the A-Z t ab to moni tor the ha zardous wa ste status of a VA p roduct (EP L-N Produc ts table): | |
109 | HAZARDOUS TO HANDLE (Already E xist) | |
110 | HAZARDOUS TO DISPOSE (Already Exist) | |
111 | PRIMARY EP A (New) | |
112 | WASTE SORT CODE (New ) | |
113 | DOT SHIPPI NG NAME (N ew) | |
114 | 5090333 | |
115 | The System shall all ow only Ma nager, Sec ond Approv er, or Sup ervisor ro les to edi t these fi elds. | |
116 | 590334 | |
117 | The Hazard ous to Dis pose shall be a Bool ean field. | |
118 | 590335 | |
119 | The Hazard ous to Han dle field shall be a Boolean f ield. | |
120 | 590336 | |
121 | The Primar y EPA shal l be a tex t field of up to 50 characters . | |
122 | 590337 | |
123 | The Waste Sort Code shall be a text fiel d of up to 50 charac ters. | |
124 | 590338 | |
125 | The DOT Sh ipping Nam e shall be a text fi eld of up to 50 char acters. | |
126 | 590339 | |
127 | When a pro duct is ch anged to n ot Hazardo us to Disp ose after previously being def ined as Ha zardous to Dispose w ith values for Prima ry EPA, Wa ste Sort C ode, and/o r DOT Ship ping Name, the value s for Prim ary EPA, W aste Sort Code, and/ or DOT Shi pping Name shalll re main, but the fields shall be grayed out and unabl e to be ed ited. | |
128 | 590340 | |
129 | When a pro duct is ch anged to H azardous t o Dispose after prev iously bei ng defined as not Ha zardous to Dispose w ith values for Prima ry EPA, Wa ste Sort C ode, and/o r DOT Ship ping Name, the value s for Prim ary EPA, W aste Sort Code, and/ or DOT Shi pping Name shall be available for editin g. | |
130 | 590341 | |
131 | The Hazard ous to Han dle field shall be i nitially p opulated a t the Prod uct level based on t he followi ng algorit hm: | |
132 | The system shall ret rieve drug s classifi ed as Haza rdous to H andle from the Drug column in the “Sampl e List of Drugs that Should be Handled a s Hazardou s” table o f the “NIO SH List of Antineopl astic and Other Haza rdous Drug s in Healt hcare Sett ings 2014” document, located a t http:// DNS /niosh/doc s/2014-138 /pdfs/2014 -138.pdf ( referred t o as NIOSH PDF). | |
133 | The system shall per form a pri mary searc h for a dr ug Trade N ame from t he NIOSH P DF using a “contains ” search o n Synonym in the the PPS_N Ent erprise Pr oduct (EPL ) database . | |
134 | If the Syn onym searc h yields r esulting m atches to drug(s) in the PPS_N EPL datab ase, then for all re sulting ma tches, the system sh all set th e value of the Hazar dous to Ha ndle field to True ( checked) a t the Prod uct level. | |
135 | The system shall per form a sec ondary for the same drug Trade Name from the NIOSH PDF using a “contai ns” search on VA Pro duct Name. | |
136 | If the VA Product na me search yields res ulting mat ches to dr ug(s) in t he PPS_N E PL databas e, then fo r all resu lting matc hes, the s ystem shal l set the value of t he Hazardo us to Hand le field t o True (ch ecked) at the Produc t level. | |
137 | When a dru g (Trade N ame) loade d from the NIOSH PDF does NOT match any drug at th e PPS-N Pr oduct leve l either b y primary or seconda ry search, the syste m will log the drug in an Outp ut Excepti on Report file for m anual insp ection. | |
138 | 590342 | |
139 | The Hazard ous to Dis pose field shall be populated based on t he followi ng algorit hm: | |
140 | The system shall ret rieve drug s classifi ed as Haza rdous to D ispose fro m the EPA STERICYCLE Rx WASTE CHARACTERI ZATION spr eadsheet, Formulary Summary ta b (referre d to as ST ERICYLE sp readsheet) . | |
141 | The system shall per form a pri mary searc h for a dr ug NDC cod e from the STERICYCL E input fi le using a n NDC sear ch in the PPS_N Ente rprise Pro duct (EPL) database. | |
142 | If the sea rch on NDC yields an exact mat ch to an N DC code in the PPS N EPL datab ase, the s ystem shal l set the value of t he Hazardo us to Disp ose field to True (c hecked) at the Produ ct level, and popula te the cor responding Primary E PA Code, W aste Sort Code and D OT Shippin g Name fie lds, and i dentify th e Generic Name for t he product . | |
143 | The system shall per form a sec ondary “co ntains” se arch for t he drug Ge neric Name in the PP S_N EPL da tabase. | |
144 | If the Gen eric Name search yie lds result ing matche s to drug( s) in the PPS_N EPL database, then for a ll resulti ng matches , the syst em shall s et the val ue of the Hazardous to Dispose field to True (chec ked) at th e Product level, and populate the corres ponding Pr imary EPA Code, Wast e Sort Cod e and DOT Shipping N ame fields , and iden tify the S ynonym for each prod uct found. | |
145 | The system shall per form a ter tiary “con tains” sea rch on Syn onym in th e PPS_N EP L database for each product. | |
146 | If the Syn onym searc h yields r esulting m atches to drug(s) in the PPS_N EPL datab ase, then for all re sulting ma tches, the system sh all set th e value of the Hazar dous to Di spose fiel d to True (checked) at the Pro duct level , and popu late the c orrespondi ng Primary EPA Code, Waste Sor t Code and DOT Shipp ing Name f ields. | |
147 | If the pri mary searc h for an N DC code yi elds NO ex act match to an NDC code in th e PPS_N EP L database , the syst em will pe rform a se condary se arch for t he drug’s Product na me from th e STERICYC LE input f ile using a “contain s” search on Synonym in the PP S_N EPL da tabase. | |
148 | If the Syn onym searc h yields r esulting m atches to drug(s) in the PPS_N EPL datab ase, then for all re sulting ma tches, the system sh all set th e value of the Hazar dous to Di spose fiel d to True (checked) at the Pro duct level , and popu late the c orrespondi ng Primary EPA Code, Waste Sor t Code and DOT Shipp ing Name f ields, and identify the Generi c Name for each prod uct found. | |
149 | The system shall per form a ter tiary “con tains” sea rch on Gen eric Name in the PPS _N EPL dat abase for each Gener ic Name id entified. | |
150 | If the Gen eric Name search yie lds result ing matche s to drug( s) in the PPS_N EPL database, then for a ll resulti ng matches , the syst em shall s et the val ue of the Hazardous to Dispose field to True (chec ked) at th e Product level, and populate the corres ponding Pr imary EPA Code, Wast e Sort Cod e and DOT Shipping N ame fields . | |
151 | When a dru g NDC or P roduct Nam e loaded f rom the ST ERICYLE in put file d oes NOT ma tch any dr ug in the target PPS _N EPL dat abase, the system wi ll log the NDC, Prod uct Name, Primary EP A Code, Wa ste Sort C ode and DO T Shipping Name in a n Output E xception R eport file for manua l inspecti on. | |
152 | 509628 | |
153 | The System shall inc lude the h azardous w aste statu s fields i n the upda te file. | |
154 | ||
155 | Wireframe | |
156 | ||
157 | This examp le shows t he new fie lds on the Administr ation Data tab. The purpose of this exam ple is to show the p lacement o f the thre e sub-fiel ds, Primar y EPA Code , Waste So rt Code, a nd DOT Shi pping Name , as the H azardous t o Handle a nd Hazardo us to Disp ose fields already d isplay on the Admini stration D ata tab. N ote that b ecause Haz ardous to Dispose is false (i. e. not che cked), the three sub -fields ar e not avai lable for editing. | |
158 | ||
159 | ||
160 | This examp le shows t he new fie lds on the Administr ation Data tab. Note that beca use Hazard ous to Dis pose is tr ue (i.e. c hecked), t he three s ub-fields, Primary E PA Code, W aste Sort Code, and DOT Shippi ng Name, a re availab le for edi ting. | |
161 | ||
162 | ||
163 | This examp le shows t he new fie lds on the Administr ation Data tab. Note that beca use Hazard ous to Dis pose is tr ue (i.e. c hecked), t he three s ub-fields, Primary E PA Code, W aste Sort Code, and DOT Shippi ng Name, a re availab le for edi ting. How ever, only one field , Waste So rt Code, w as populat ed. | |
164 | ||
165 | ||
166 | Functional ity Checkl ist: | |
167 | Does this apply to a ll user ro les? | |
168 | If no , specify relevant r oles in Se ction 3 | |
169 | N | |
170 | Does this affect any existing Reports? | |
171 | If ye s, specify reports i n Section 3 | |
172 | N | |
173 | Does this affect any export fu nctionalit y? | |
174 | N | |
175 | If this is a PPS mod ification, will it r equire Vis tA modific ations? | |
176 | If yes, refe rence the appropriat e VistA st ories in S ection 3 | |
177 | Y | |
178 | If this is a VistA m odificatio n, will it require P PS modific ations? | |
179 | If yes, refe rence the appropriat e PPS stor ies in Sec tion 3 | |
180 | N/A | |
181 | If this is a PPS-L m odificatio n, will it require u pdates in PPS-N? | |
182 | If yes , referenc e the appr opriate PP S-N storie s in Secti on 3 | |
183 | N/A | |
184 | If this is a PPS-N m odificatio n, will it require u pdates in PPS-L? | |
185 | If yes , referenc e the appr opriate PP S-L storie s in Secti on 3 | |
186 | N | |
187 | If this is a PPS-N M odificatio n, will it affect th e Update F ile? | |
188 | If yes , referenc e related PPS-N stor ies in Sec tion 3, if appropria te | |
189 | Y | |
190 | Does this require ch anges to o nline help ? | |
191 | Y | |
192 | ||
193 | ||
194 | Acceptance Criteria: | |
195 | The Hazard ous Waste Status fie lds have b een set up in the PP S-N databa se. | |
196 | The Hazard ous Waste Status fie lds are th e same dat a type as the fields in VistA (ie numeri c to numer ic, text t o text, et c.) | |
197 | The Hazard ous Waste Status fie lds displa y on the p ages speci fied in th e requirem ents. | |
198 | The Hazard ous Waste Status fie lds are in itially po pulated in accordanc e with the method sp ecified in the requi rements. | |
199 | The Hazard ous Waste Status fie lds are in cluded in the Update File. | |
200 | Approvals | |
201 | Approver N ame | |
202 | Status/Com ments | |
203 | Due Date | |
204 | Approval D ate | |
205 | Donald Lee s | |
206 | Approved | |
207 | ||
208 | 8/12/2015 | |
209 | ||
210 | ||
211 | ||
212 |
Araxis Merge (but not the data content of this report) is Copyright © 1993-2016 Araxis Ltd (www.araxis.com). All rights reserved.