VIEWS: 25 PAGES: 222 POSTED ON: 11/8/2011
TICKET CUSTOME TITLE REL_SOURCE R 973 AU Radiology *****22.214.171.124.HO/4.0.1.HO******** *** MRR0014 ************************************ MRV0009, MRS0009, SEV0020, MRR0014/24/25, 973...sql (5_31_02 rel: MRR0023, MRR0024, MRR0025) 5481 U10G UVIS 10g Enhancement 126.96.36.199.HO & 4.0.1.HO: uvis_patient_au_pyxis.trg 3.1.10: uvis_sys_pkg, uvis_common_pkg 7964 UMN Calculate Diagnosis estimate on Disch uvis_ac_pkg.pkg 8238 MU MRS0017 - MR Tracking Screen 188.8.131.52.HO, 4.0.1.HO ************************ MRR0017, MRR0018, MRR0019 3.1.10HO ************************ 8238_create_uvis_med_record_r esolution_m.sql 8238_setup_module_menu.sql MRV0019 MRS0017 MRS0028 uvmr_med_record_au_log.trg 10030 AU Orig. DVM DEA # populating on transfer PHS0006 10417 MU Contacts at the client level 4.0.1.HO - UVIS 4.0 branch - pds0001, pds0002, 10417_alter_uvis_patient_contact _x.sql --------------------------------------------- ----------- 184.108.40.206.HO - UVIS Project branch - pds0001, pds0002, 10417_alter_uvis_patient_contact _x.sql 10420 MU PDR0007 - Add cell phone nmubers PDR0007, PDR0012 10565 UMON Mrs0007- answer to question 3197 MRS0007 10650 AU Inventory restraint in Med dispensation PHS0006 11161 MU Sequence 0 on CP requests from DL --02/13/2009-- n/a 11294 CU UVIS Patient Alert bug PDS0002 11383 UHO Add Chief of Service to MRR0030, EPISODE_SECTION 11383_master_inserts.sql 11434 MSU BLS0005 Third party not consistent BLS0005 11674 MU Spurious warning on MRS0009 MRS0009 11734 NCSU IMS0009 - version 220.127.116.11 IMS0009 11797 UMON Ph returns in inventory uvis_ph_pkg.pkg 11822 AU Digit constraint on patient # creation PDS0002 11825 UMON PHS5 Rx approval for pyxis vending uvis_cdm_pkg.pkg, 11825_sys_option.sql, 11825_db_job.sql 11834 NCSU Client and Patient Alert rollovers BLS0001, PDS0002 11855 UWHOCP Wrong Medical Record Number Prints on --02/13/2009-- CL clr0001.rdf clr0001_cu.rdf clr0001_mu.rdf 12049 NCSU BLS0001 - grey field - ver 3.1.10 BLS0001 12050 NCSU BLS0006 - two issues - Ver 3.1.10 BLS0006 12054 AU inpatient labels cutting off minutes PHS0006 12055 NCSU FDS0005 issues - version 310 FDS0005, PDS0001 12076 NCSU IMS0009 issues version 3.1.10 IMS0009 12077 NCSU More Issues IMS0009 Version 3.1.10 IMS0009 12150 MU Admit/Tfr Details clipping on right marg MRR0031 12151 MU Employee Suffix printing wrong MRR0030 12161 CU Error Ext Docs Tab in MRS0024 mrs0024, pds0002 12303 CU Error Deleting Instruction MRV0003 12310 CU Ph Inventory Log uvis_ph_pkg.pkg 12895 UGA Error scrolling on Presumptive Problems MRS0024 12915 UGA Searching Patients after transfer MRS0001 12916 UGA Send to MPL option MRS0024 12955 CU Request Submit MRS0024 Error MRS0024 13236 CU MRS0013 SQL error calling MRR0027 MRS0013 13615 CU MRS00013 Query Bug MRR0027, MRS0013 14016 AU estimate button doesn,t populate Case# BLS0010, MRS0024, 14016_alter_table.sql, uvbl_estimate_diag_aiud_log.trg, uvbl_estimate_cat_aiud_log.trg, uvbl_estimate_prod_aiud_log.trg, uvbl_estimate_hdr_aiud_log.trg 14021 MU Mispelled text MRS0024 14157 AU error message on order w/ no charges BLS0002 14175 CU BLS0001 Inactive RDVM filter BLS0001 14215 CU phs0017 Bug BLS0002 14275 UMON mrs24-underlined items MRS0024 15057 MU Don,t auto-select text MRS0024 15135 MSU Physical tab not accepting NE on MRS0024 MRS0024 15155 MU identical questions 3-way bug MRS0024 15435 MU report builder error in 3.1.10 --02/13/2009-- clr0001_mu.rdf 15615 CU Re-submit Rejected Lab Request --02/13/2009-- In HO Instance: uvmr_request_au_dl_request.trg uvmr_request_au_cp_request.trg In UL Instance: uvcl_interface_ho_ai_interface.trg uvdl_interface_ho_ai_interface.tr g 15935 AU Old Verified Discharge-Draft copy waterm MRS0024 15997 CU Order Header BLS0001 doesn,t update MRS0024 16075 VSOL Release CM Ticket 16075_module_m.sql 16077 AU sporadic comm entries not printing MRR0008, 16077_comm_log_corr.sql 16095 MU MU 3.1.10 go live issues 4.0.1.HO MRS0001, PDR0007, MRR0028, BLS0006, MRS0017, BLS0005, PDS0004, 8865_init_uvis_invoice.sql, 16095_adj_err_trans_amt.sql, uvis_ac_pkg.pkg --------------------- 3.1.10.HO MRS0001, PDR0007, MRR0028, BLS0006, MRS0017, BLS0005, PDS0004, 8865_init_uvis_invoice.sql, 16095_adj_err_trans_amt.sql, uvis_ac_pkg.pkg 16455 UMN RX Suffix # incorrect when voiding RX PHS0006 16476 UMN Unable to query on BLS0010 BLS0010 16515 UMN unable to unverify initial plan MRS0024 16595 UMN nbr ,1, appearing on RX label PHS0006 16795 NCSU MRS0024 assorted issues - 3.1.10 MRS0024 16855 NCSU More MRS0024 issues - ver 3.1.10 MRS0024 16915 UGA External editor for text blocks. MRS0024 17135 MSU ORA-00932 on MRS0024 MRS0024 17275 CU Mitra Broker Trigger on MR Request uvis_mr_request_aui_mitra.trg 17435 MU Inappropriate Selection in BLS0001 BLS0001 17476 MSU Default current time on MRS0024 MRS0024 17518 AU Local statuses receive truncation error MRS0024 17536 CU MRS0024 +/- Rpt fields MRS0024 17858 UGA Block searches with no criteria MRS0024 17895 NCSU Related Questions weirdness - 3.1.10 MRS0024 17995 UGA Query on names with apostrophes PDS0001, PDS0002 18035 UGA Prmary Diag Seq/PK MRV0017 18095 UGA Editing Verified Fields MRS0024 18096 UGA Lock TPR on SOAP if verified. MRS0024 18115 NCSU Further issues with MRS0024 - ver 310 MRS0024 18137 AU Preliminary status issue with discharge MRS0024 18175 MU Unreject broken in 3.1.10 --02/13/2009-- uvcl_interface_ho_ai_interface.trg uvdl_interface_ho_ai_interface.tr g uvmr_request_au_cp_request 18295 UMN Misc 4.0 Issues BLS0001, IMS0008/20, MRS0007/8/9/14/24, PDS0001/2/3, PHS0004/5/6/7/15, SES0001, cp_mr_lib.pll, dl_mr_lib.pll, rp2rro.pll, 18295_ext_device_cmnd_printer. sql, up_button.gif, down_button.gif, 18316 AU Estimate amt not updating at top right MRS0024 18320 UMN Cancelled RX refills not taken off bill PHS0006 18458 AU Confusing message on estimate opening BLS0010 18515 AU Not handling matching phone #,s correct PDS0001 18535 AU improper message thru navigation PHS0015 18615 AU nested history ?,s don,t print-out-disch MRS0024 18635 AU No SOAP status until manual refresh mrs0024 18675 UMON mrs0024-patch 6 mrs0024 18736 AU icon rollover not correct functionality MRS0024 18737 AU Discharge issue with Verify dialogue box MRS0024 18755 CU MRS0024 Bug mrs0024 18797 VSOL Misc 3.1.10 Issues Hospital and Labs: *********************** uvis_plsql_lib.pll Hospital only: *********************** mrs0024, mrs0001, pds0004 18877 UGA Deposit issue with cancelled orders uvis_ac_pkg.pkg, 8865_init_uvis_invoices.sql, BLS0005, 18877_correct_cnx_ord.sql, 18877_correct_dep_tfr.sql 18896 VSOL OAS Patch 3 10.1.2.3 frmall.jar frmallws.jar frmwebutil.jar frmwebutilws.jar webutilbase.htm webutiljini.htm webutiljpi.htm uvis_main_form.fmx uvisWebStart.jar uvisWebStartws.jar 18897 AU Surgical Requests issue w/ req DVM uvis_mr_request_bu_bill_post.trg 18935 AU Att DVM not changable on open order uvmr_order_hdr_au_case_tfr.trg 18955 AU Incorrect verbiage "Given to client" log MRS0024 19115 AU Duplicate info entry confusing PDS0001 19175 MU ADJUST ERROR Invoice Balances 8865_init_uvis_invoice.sql, uvis_ac_pkg.pkg 19475 UGA Deposit on Account w/ Neg Balance ACR0007 19555 CU Page Break DVM Name MRR0005 19575 CU MRS0024 Bug MRS0024 19595 CU Error - MRS0024 MRS0024 19635 AU Wrong description on medication MRS0024 19715 CU Security- MRS0024 MRS0024 19735 MSU MRS0024 SOAPs editable MRS0024 19935 UMON account freeze does not stop from openin BLS0001 20256 NCSU BLS0006 - student selection - 18.104.22.168 BLS0006 20258 NCSU PDS0001_phone_search_3.10,8 PDS0001 20259 AU Verification issues on Transfers in hosp MRS0024 20268 AU no recognized sort order to invoices BLR0009 20279 AU Verified record edit allowed MRS0024 20281 VSOL DB-Link Setups for Cross-App Screens cls0007.fmx cls0011.fmx dls0001.fmx dls0020.fmx dls0046.fmx mrs0001.fmx mrs0007.fmx mrs0008.fmx pds0002.fmx 20281_Load_HO_Module.sql 20281_Load_UL_Module.sql 20285 NCSU MRS0024-Comments issue - ver22.214.171.124 MRS0024 20294 UMON mrs0024- 3.1.10 patch 11-requ-result scr MRS0024 20302 UMON translation and module update --02/13/2009-- HO and UL ************** sev0024, 20302_col_mods.sql HO only ************** uvis_default_menu UL only ************** uvis_ul_menu 20305 UMN Communication Worklist Issues MRS0014, uvis_mr_pkg.pkg 20308 UMON mrs24-multiple discharge lettr templates MRS0024, MRR0030, 20308_add_cols.sql 20331 UMON PHS0015 3.1.10 patch 12 PHS0015 20342 UMN MR Deficiency Rpt Changes (MRR0005) MRR0005 20343 MSU MRS0024 not working for previous owners MRS0024 20344 MSU MRS0024 handouts MRS0024, PDS0002 20386 NCSU BLS0001-extreme slowness-3.10.08 BLS0001 20389 NCSU MRS0024 - Adding external docs 3.10.8 MRS0024, PDS0002 20390 NCSU MRS0024 - Imaging button MRS0024 20394 VSOL UVIS 4.0 Print Destination Hospital: ACR0005, BLR0009/31, MRR0004/5/6/8/9/10/12/17/18/19 /20/21/30/32, PDR0001, ACS0001/2/3, BLS0005, MRS0012, PDS0001, 20394_desig_printer_delete.sql Labs: DLR0029, 20394_desig_printer_delete.sql 20407 NCSU MRS0024 and lot numbers - 3.10.8 uvmr_order_dtl_aiu_vpm_sex.trg 20423 AU Diagnosis Verification issues MRS0024 20424 UMN Text view button not working on com log MRS0024 20425 UMN requirement of diag elements not working MRS0024 20429 AU Password left if no action completed MRS0024 20476 AU MRS0024 refresh issues MRS0024 20507 NCSU MRS0024-communication log - 126.96.36.199 MRS0024 20509 NCSU MRV0010 - identical questions-188.8.131.52 MRS0024 20527 UMON MRS0009 ora-01830 MRS0009 20533 UMON BLS001 - can change order datetime BLS0001 20535 AU Inactive questions flagged w/ "?" icon MRV0007 20537 AU Not all active MPL,s on request pop-up MRS0024, MRS0007_mpl_popup 20539 UMON bls1-RDVM flag "do not communicate with MRS0024 20541 UMON MRS24-can modify personnel-VMTH MRS0024 20543 UMON HO mrs0024-census not updating MRS0024 20548 AU Incomplete inconsistencies between rpts MRS0024, MRR0005 20557 CU Closing An Episode MRS0024 20592 MU Communication Worklist MRR0008 20616 UMON BLS10-estimate not linked to episo BLS0001, BLS0010, BLR0010, BLR0011, MRS0024, 20616_insert_estimates.sql, uvis_bl_pk.pkg 20681 UMON mrs0024-discharge-select-proc MRS0024 20682 CU Admissions Date Not Carring Through MRS0001 20689 AU Estimate issues BLS0010 20696 AU SOAP time defaults to 12:00am MRS0024 20704 UMON mrs24-verify-authentication failed MRS0024 20716 NCSU MRS0013 issue 3.10.patch12 MRS0013 20724 UMON bls2-asaq item icon -recalc not done uvis_bl_pkg.pkg, uvis_order_dtl_asaq_biur.trg, BLS0002, MRS0024 20737 NCSU MRR0031 - line dropping - 184.108.40.206 MRR0031 20738 NCSU MRS0024-Estimate field-220.127.116.11 BLS0001, BLS0010, MRS0024, 20738_mod_cols.sql 20739 NCSU MRS0024 - Transferring patients issue MRS0024 20741 NCSU MRS0024-search by client-3.1.10.patch13 MRS0024 20747 NCSU MRR0023 - dates backwards on runtime for MRR0023 20748 MU MRS0024 > verify > manage MRS0024 20784 MSU MRS00024 Cannot add comm log entry MRS0024 20807 MU error on closed episodes MRS0024 20820 UMN Def Med Rec Rpt MRR0005 MRR0005 20822 NCSU bls0001 related order issue patch 14 BLS0001 20827 UMON MRS24-verify-manage un-final rslt MRS0024 20839 NCSU MRV0016 issues patch 14 uvmr_order_hdr_aiu_episode_ltr.t rg, 20839_info_sort_correct.sql 20843 CU CLR1 selecting from log table --02/13/2009-- clr0001_cu.rdf 20883 UMON mrs0024 - date needed never refreshed MRS0024 20890 UMN given to rdvm / client checkboxes MRS0024 20896 UMN Add check for blank disch letters uvmr_ep_disch_ltr_x_aiu_comm.t rg, uvmr_ep_disch_ltr_x2_aiu_comm .trg 20916 MU Ext Doc .wav File Handling MRS0024, PDS0002 20935 UMN Interface to labs not working on MRS0024 MRS0024 20952 NCSU MRS0024 request_results_icons patch14 MRS0008, MRS0024 20956 VSOL RGI Misc Testing Issues BLV0008, MRS0024 21023 AU SOAP Error upon view by episode MRS0024 21091 UMON Mrs24-student can enter estimate MRS0024 21106 UMON mrs24-mpl MRS0024 21108 UMON mrs24-visit-soap-(re)populate SOAP MRS0024 21119 UMON mrs0024-specimen updated on completed MRS0008 rq 21156 AU Users w/ unable to close EOC MRS0024 21170 UMN Missing info on display of PHS0006 PHS0006 21174 UMN product code not displaying on notepad IMS0004 21175 UMN missing info on RX approval listing PHS0005 21176 UMN instructions not reqd on phs0005 PHS0005 21190 NCSU MRS0024_lab tests not printing patch 14 MRS0024 21206 UMN detail order report not working BLS0002 21215 UMN estimates req name before entry BLS0010 21222 UMN answers modifiable after submission MRS0007, MRS0024 21247 UMN update mod priv on BLS0001 BLS0001 21249 UMN UVIS PACs Interface Issues uvis_mr_pkg.pkg, uvis_mr_request_aui_mitra.trg, pacs_interface.doc 21254 AU "Select SOAP Notes" shows all hosp MRS0024 SOAPs 21257 UMN Billing/Accounting issues in 4.0 18.104.22.168.HO--BLS0001, BLS0002, MRS0024 4.0.1.HO--BLS0001, BLS0002, MRS0024 21260 UMN med rec issues in 4.0 MRS0024 21346 AU request areas not changing on request MRS0024 21354 UMN UVIS Performance Issues --02/13/2009-- 21354_create_seq.sql uvis_sys_pkg.pkg 21367 UMN Death Certificate Comm Worklist MRS0014, uvmr_episode_aiu_comm_wrklst. trg, uvmr_episode_au_discharge.trg, uvmr_patient_au_comm_wrklst.tr g, 21367_mod_cols.sql 21384 UGA Un-Verify of Discharge MRS0024, uvis_mr_pkg.pkg PROBLEM 8/5/2008-wr-Per e-mail exchange with Russell, remaining issue is question on inclusion of product level instructions dtd 12/7/2006. Researched this issue and mod was made as a result of MU TT # 8918; the report always included area level instructions and MU assumed omission of product level was a bug, as did RGI. Per AU request we will add a single parameter to allow including instructions (area and product level) or not. The default will be to include instructions. 8/4/2008-wr-I am unsure why this ticket has remained open. Please review and either Close the ticket or add specific comments as to what the remaining issue is and set back to OPEN status. 2/12/2007 - RDA Updated the application field for sorting purposes 12/7/2006 - RDA - version 22.214.171.124 Can you tell me what version and which school added the product instructions to MRR0014? That information is not needed on that report at Auburn and if there are multiple tests on a rad request, it can lengthen the report to multiple pages. Is there a way to turn off that functionality? All other functionality below works as specified. 2/16/05-wr-Unless there are comments or questions populated nothing will show up but MRR0014 already prints both request and result questions and request comments. 2-16-2005 - RDA Per Betty's comments, we still need the ability to add Q/A and request comments on printed request 5/6/2008-da-Closing Ticket --- Original --- This ticket is for tracking time spent researching, designing, developing and implementing the UVIS 10g Enhancement, which moves UVIS from client-server based Developer 6i client and Oracle 8i database to web-based, Oracle 10g Developer, Application Server and Database. The diagnosis (and single checkbox) was removed from the order header screen. Please verify that the diagnosis estimate displayed on the estimates screen is now being calculated based on the primary diagnosis entered on the discharge screen. 03-MAR-08 ABS: This field is great, but we also need MRR0017 (Checked out medical records report) to gather its information from BOTH Staff and Staff2 fields. Currently (3.1.10) it only draws from the first staff field. ----- We would like to have the student ID added to this screen so that we can query by student. We also would like to have an additional field added for the "resolution" so that we can easily track when the deficiency has been resolved. 12/12/2008 - RDA - Version 3.1.10 patch 15 Issue is still occurring. Example follows: RX # 656445-0 (Morphine 15mg/ml) for Shaka Matamu Dr. Saile was original approver but was switched and approved by Dr. Potter. The Rx Data sheet is still showing Dr. Saile's DEA number, not Dr. Potters. This occurred on 12/2/2008. 4/17/2008 - RDA version 3.1.10 Issue is still occurring in present version. This should be a high priority ticket for Auburn as it affects the accuracy of our daily med dispensations. Thanks. 3/20 2007 - RDA version 3.1.6 issue has re-occurred in present version. 8/17/2006 - RDA - Version 3.1.8 Sporadic issue where original DVM is changed due to non-access to prescription review during surgeries. DVM name changes but label prints out with updated DVM name but original DVM DEA #. Example follows: Case # 1065403 Rx # 587126-0 Original DVM - Dr. Henderson (DEA #018) Transfer DVM - Dr. Delgado (DEA #3782) We need to be able to attach contacts to the clients in the OAR module rather than to the patients as our communications will relate to the project and protocol rather than the patients. Per Wendell he can add a tab to the client screen that will allow this connection. We would like to have this in 3.10 if at possible so that we have it for the OAR go live. 10/2/2008-ts-the version of pdr0012 that came in patch 14 shifts the right-side labels to the left and into the gutter. Backing it down to the pre-patch-14 version corrects the problem. 8/8/2008-da-Approved by Zac under SOW UMOHO_08_02. 2/15/2008-da-email from Zac added the following: The form is accessed from the PDS0002 screen. This would place a cell phone number place holder just under the Work number for the Owner. Also put a cell phone number between the Phone and Fax number of the RDVM demographic area. We would also like to have a cell phone number of the client on the patient label. --- Original --- If you want to add this one to the diagnosis one I approved earlier that will work for me. Please add the cell phone numbers for the client and the rDVM to the demographic portion of this form. There appears to be plenty of room and we need a way for our clients to verify the number while they are still here especially if it is an emergency case and we need to get in touch with the owner right away. 07/25/2008 LL problem still present with 3.1.10 _________________________ 11/28/06 I am talking about request NOT associated with DL or CP. It is a HO "only" request. An example episode 16018-patient 7223. Look at the requests with status new. (request area AN-PA) product 111-4 ___________________________ 11/28/06 sem From which area is the request associated ? Answer Types are set up differently in Dlab vs HO or CP. This could affect the verification. If you specify a list of possible answers for a question requiring a coded answer, you may enter anything you like. It will not verify that the answer is part of the coded answer. 3/19/2008 - RDA - Version 3.1.10 Issue still occurring. Happens primarily when pharmacy returns an item and then another user fills that same med. System informs user that sales quantity exceeds inventory. User then has to open inventory and place a zero in quantity to satisfy the logic before going back to the med and then dispensing. Please place ticket higher in Auburn's list!!! 1/19/2007 - RDA - Version 126.96.36.199 Problem is still occurring, even with pharmacy items that have a sales Qty of zero. 12/15/2006 - RDA - Version 188.8.131.52 When filling an RX, if amount in the available inventory table on the inventory/Rph screen is less than the amount you need for the RX it gives a message stating that and then auto-changes the qty on the table as well as the total qty on the previous (RX details) screen. If you click on the qty issued on the table it will allow you to change it the amount you want to dispense but then you have to go back to RX details and change total qty back to that sam number or it will only show you dispensed the previous amount and will only charge that amount also. So to make it work you must change the qty issued to what you want and then go back to details and change there-then it will proceed to dispense, print and charge correctly. To try to rectify this I went to Inventory, Inventory and physically made current inventory 0 on everything, but even though it shows zero on that screen, some of the drug still have a remaining inventory showing up. Is there some way to circumvent this since we do not put inventory or lot numbers, etc. in system anyway? Helen 4/23/08 sem After discussing with Teresa, the sequence 0 seems to be generating when a CP test is rejected and then Re-submitted from Hosptial via MRS0024. Also, if a DLAB accession has a CP test on it, if there is some data that gets out of sort on the accession such that the tests are in W status but the accession is in N status, if you back out the test from W to N, then re-release the accession, the 0 sequence is created in the re-release. When a test is rejected and unrejected in Clin Path, the 0 sequence is not generated. 4/12/07 sem In RGI, 3.1.10 and 184.108.40.206, sequence 0 is not being generated. But, only one test is coming over to Clin Path for resulting. (220.127.116.11 CP Request 744/DLAB 07-00295) When adding an accession in DLAB that contains two of the same specimen types on the same animal and the same Clin Path test being performed on each of the samples, they come over to Clin Path with Sequence 0. Thus when attempting to result on CLS0007, it seems to get confused as to not knowing which record to result. This event is the same with single orderable tests as it is with profile/panel type tests. 8/21/07-mes-This problem still exists after our last push on 8/1/07. The only way to force an update of field PATIENT_ALERT_YN in table UVIS_PATIENT is to save out of MRS0002 and PDS0002 with F10 or the floppy disc icon rather than just by closing the forms. MRS0002 is 2/2/2006. PDS0002 is 5/19/2006. 5/18/07-wr-Modified the Visit (MRS0002) screen to address this issue; revision sent via e-mail to CU. 5/17/07 ska- When a user is entering a Patient Alert via the Visit Screen MRS0002 via the Alert tab, it does not appear to be saving. When closing the screen it does ask, Do you want to save changes - when clicking yes, it appears to save the changes, but the Patient Alert button does not appear. However, when you click the Save Diskette in the upper right hand corner the Patient Alert Button appear on that screen ONLY. When going to the Case Search screen querying the client back and then clicking the eyeglasses next to the Patient #, taking you to the Patient Screen, the Patient Alert button does not appear as it should until you click the Save Diskette again - The record remains in the Alert Tab of the Visit Screen MRS0002 but is not functioning as it should. Bill Liddick - Closed - 8/7/08 2-APR-08 -abs- We would like to have the Admitting Clinician's name on the Discharge Instructions and referring Vet Communications also. ----------- We would like to add an additional sub-element to the episode section of the discharge summary templates. This would be for "Chief of Service" (available on the VMTH Personnel tab), and would appear along with the other personnel in the right-hand column. This is needed so that the faculty supervisor can be shown when the attending is a resident If you launch the cashier screen from BLS0002, the "Bill Third Party" checkbox does not default to on for clients with third party billing setup. If you launch the cashier screen directly the checkbox does default to on for clients with third party billing. Here's the scenario: Bring up MRS0009 (Enter Results). Select an area of Image and execute query. A whole bunch of cases show up. Pick one, highlight it and check the box. Note that it is displaying the requesting DVM with a service and section. Click on Print Request/Result (or on Request/Result Detail). A warning message appears stating: "Error retrieving the Service/Section of the Requesting DVM ORA- 1403 no data found" Help just gives -0. Once you get this message once, you won't get it again unless you close MRS009 and go back into it. 9/18/08 - Glenn Waters - After retesting this in patch 13 the issues seem to be resolved. Closing the ticket 3/7/08 - Glenn Waters - Changing the status of this ticket from coded to open so it will be visible. There are still issues with this program. Wendell sent out a patch for this. The initial problems that were reported seem to be corrected, but the screen has developed a similiar problem based on the fixes. I'll be adding an additional attchment that documents these issues. 8/21/07 - Glenn Waters - This was brought to my attention today. I took a look at the release notes for 3.1.10 and didn't see any mention of this being corrected there. My suspicion is that no one uses the inventory modules as hevily as we do, so this might have gotten missed. IMS0009 is a screen where you only should go into it rarely to make adjustments to your inventory. But it is a vital screen when you do need to make these adjustments. When you go into the IMS0009 screen you can no longer add new items into inventory correctly. Also the "adjusting" of quantities seems to have issues also. See attached file for screen shots about this issue. when returning to inventory (and cancelling a Rx) a product without lot_id, ->the product will be added to the inventory with the sales_to_stock_qty = 1. Can this behavior be changed so that the actual supplier Sales_to_stock_qty is used when updating the inventory. 7/31/2008 - RDA - Version 3.1.10 patch 11 Functionality resolved issue. Closing ticket. 9/7/2007 - RDA - version 3.1.10 User is unable to create a new patient record due to a digit constraint of 7 characters. Auburn is currently using 1,000,000+ numbers in the creation of our patients. In 18.104.22.168, this was not an issue but with new coding, this issue prevents the user from patient record creation. Please see the attached screen prints for the specific error. 10/22/2007-wr-In discussions with Lyse re-directed this ticket to create a stored procedure to auto-approve these CDM dispense records as a system default "Dr Pyxis" after three days. *********************************************************** 10/18/2007-wr-The approval of a prescription request originating from the CDM machine is a bit more complicated than just setting an approval flag column. It would be possible to process these records via a series of sql stmnts but I would prefer a little more refined approach if possible. The 3.1.10 version of the Prescription Approval (PHS005) screen includes an ability to "Show All Auto Disp" records which would give you all CDM dispensed records on the screen. This screen also contains a batch approval capability that allows you to select multiple records and approve them all as a single DVM with a single password entry. Doing this makes the logged on/approving DVM the Prescribing DVM on all of these records. I think this would give you an acceptable way to handle these records at least in the interim. My concerns with this approach is that the 3.1.10 version of PHS005 has not been tested with the 3.1.9 database that you are running; nor was this feature intended to process 1500 records at one time. That said, I do not see any modifications to PHS05 that I think would cause problems with your 3.1.9 database and it would be possible to break-up your backlog of 1500 records into smaller chunks if necessary. The query by example functionality of PHS05 is still in place when filtering by "Show All Auto Disp." records; so you could hit the "Show All Auto Disp." button and then enter query mode, enter a DVM #, execute query and the system will then display the Auto Dispense records of that DVM; allowing you to step through the backlog one DVM at a time. Note you have 38 distinct DVM's with auto dispense records pending. I will send you the 3.1.10 version of PHS0005 and what I propose, in the interim, is that you attempt a test of processing those pending CDM records asWaters - Based on conversations with Susan, it'sas 9/18/08 - Glenn I outlined above. If this simply does not function now ok to close tickets when we feel that things are resolved. Closing this ticket since the issue has been resolved (as of patch 13) 3/5/08 - Glenn Waters - Based on interim fix Wendell sent out this seems to be resolved. I am not changing the status on this until Ross group "formally" releases dot one release 10/29/07 - Glenn Waters - Confirmed this is still an issue in 3.1.10 9/14/07 - Glenn Waters - Minor issue just wanted to point this out in case it was missed in 3.1.10 version. Just noticed today that the rollovers for Client and Patient alerts are transposed. See attached file for screenshots 7/24/2008 - RS - Still not working. 4/11/08 sem After phone call with Faye and Wayne, the tickets listed below indicate an error message being generated. In Wisc, they do not get the error message but just transposed data. The wrong medical record case # prints intermittently on CLR0001. The attached document has details. Dupe ticket for 15717 and 15435. 9/18/08 - Glenn Waters - Based on conversations with Susan, it's now ok to close tickets when we feel that things are resolved. Closing this ticket since the issue has been resolved (as of patch 13) 3/5/08 - Glenn Waters - Based on interim fix Wendell sent out this seems to be resolved. I am not changing the status on this until Ross group "formally" releases dot one release 10/26/07 - Glenn Waters - While testing the Order Header screen noticed that the patient field was greyed out. Yet it allowed entry. Naturally non-greyed is better to keep confusion down with the users. See attached file for an example 9/18/08 - Glenn Waters - Based on conversations with Susan, it's now ok to close tickets when we feel that things are resolved. Closing this ticket since the issue has been resolved (as of patch 13) 10/26/07 - Glenn Waters - Noted two seperate issues on the census screen. Issue one was during the adding of a patient to the census. You get into a weird save issue when trying to do the initial posting of board. Issue two was trying to delete a census record. Both issues are noted in the examples on the attached file 10/29/2007 - RDA - version 22.214.171.124 Inpatient labels are ommitting part of the Rx directions. Example below: Rx #619957 Give 16.47 milliliters...once for 1 dose over 20-30 minutes (three from the 30 minutes always missing. 6/13/08 - Glenn Waters - Another varition of this same issue has surfaced since we have gone live. If you do enter a home phone number during pre-add and end up changing it during client check in (you are verifying and the client say "no my correct number is...") it also exhibits the same sorts of symptoms as described below. I have added more screenshots showing this new behavior. 5/23/08 - Glenn Waters - Additional information discovered late on the 23rd. It seems that if you add a new client via pre-add, when you get over to the FDS0005 screen and it does NOT have a home phone number is when the situation I describe in the word attachment kicks in. And it's specifically the home phone that "seems" to be what it's needing. 5/23/08 - Glenn Waters - Further issues emerged when we were doing testing yesterday. Looks like this screen was possibly broken in a new way with patch 4. Changed ticket from documented to open, and added additional screen shots to document new issue. 10/29/07 - Glenn Waters - While testing ticket 8390 noted these new issues with FDS0005. The pulldowns seem to cause problems and there was some slight data transfer problems when cutting and pasting. See attached screenshots for example 9/18/08 - Glenn Waters - Based on conversations with Susan, it's now ok to close tickets when we feel that things are resolved. Closing this ticket since the issue has been resolved (as of patch 13) 11/6/07 - Glenn Waters - Issues with adding new entries into this screen. Seems like the values being added for new entries are being overridden, and/or wiped out. Screenshots with more detail about the issue are attached. 9/18/08 - Glenn Waters - Based on conversations with Susan, it's now ok to close tickets when we feel that things are resolved. Closing this ticket since the issue has been resolved (as of patch 13) 3/7/08 - Glenn Waters - I'm going to change the status of this ticket from coded to open so it becomes visible. The issues in this ticket seemed to be addressed in the patch Wendell sent out via email. 11/6/07 - Glenn Waters - Working with a user on an unrelated issue, but we had to go into IMS0009 to check something. Noticed a weird "quirk" on exiting the screen. See attached screenshots for the details 2/24/2008- CPS from MU. Tested this with patch 17 in place on your test database. It is still cutting off one character on the right margin. 10/20/2008-ts-clipping of the right margin problem in the Client Disch Instruction Body and RDVM Disch Instruction Body ------ We're having our old familiar clipping of the right margin problem again, this time on (only) the Admit/Transfer Details report. It seems to be a problem with any HP printer/driver combination. Here's a summary from Lee: ------- Art, Here are the details on the printing problem that's being reported by ECC. Here are the steps to recreate the problem 1) Go into Case Summary and look up a case (I used 378306 since it was a reported instance of the problem) 2) Click the Admission button. 3) Select the Transfer tab. 4) Click the Admit/Tfr Details button. UVIS should now bring up a preview screen. At this point everything looks good, box edges are present and there is no noticeable truncation on text. 5) Click the Print button and accept the defaults. Output from some models of HP printers has truncated text and is missing the right hand box edges. Other HP printers appear to produce correct output. It appears that the right hand edges are significantly closer to the edge of the paper than the left hand edges (even on correctly printed forms). The Employee table does not have an area for suffix, so correct Also, clicking File->Generate to File->PDF Produces the they are added to the last name. For example: 'SCHUTRUMPF, III' (Note this is forced to upper case). When this prints on the Discharge Summaries, it gets rendered as "Schutrumpf, Iii" (i.e., it capitalizes the first letter (only) of every "word." This is inappropriate for roman numeral sufixes. There does not appear to be any good workaround for this. abs 4/29/08 -- Noite that suffix must add a comma immediately following the last name (no space!) when it prints (eg. John Doe, III) 11/30/07 ska There is an error when adding and external document in the Patients Document section under the ExtDocs tab on MRS0024 if there is no Episode/Visit document already added. But if we first attach a document in the â€œEpisode/Visit Documentsâ€• section, the error does not occur when we then add the patient document. Example: Document gets scanned. Save as pdf with file name (example) P184775_662229_OL. In MRS0024, ExtDocs tab, select line under Patient documents. Click "Add" button. â€œOpenâ€• displays; select the correct file. box Error displays: â€œRecord has already been inserted (FRM 40600).â€• Click OK. The file shows up on the selected line under Patient documents Select "Open" Following error shows up on screen: â€œField must be entered (FRM-40202)â€• 1/10/2008-wr-When hitting the "Delete Inst" button on the Instructions (MRV0003) screen user receives ORA-01407 error, can't update not null column to null. Error caused by update on uvis_mr_dc_instructions_x.instruction_id column. Bill Liddick - Closed - 8/7/08 1/11/2008-wr-Items dispensed from PHS0006 are not clearing the comments column in the inventory table thus the inventory log carries forward past/irrelevant comments on these transactions. 1/24/08 - Duke Error messages appear when trying to scroll the questions on a presumptive problem in the case summary MRS0024 screen. See attached screen shots for error messages. Same error occurs on several scroll lists on this form, (MPL/MPL, Visit/SOAP/Problems) 1/24/08 - Duke When search for a patient it automatically adds the active client relationship into the search area, making it difficult to find patient episodes with inactive client relationships. 1/24/08 - Duke When you are adding Initial Plan problems if you check the box "Send to MPL", UVIS automatically saves the row and adds it to the MPL. Either the button is unnecessary or the problems are being sent premature. Our opinion is that they are being added prematurely. 1/25/08 ska Email thread as follows: -------- Original Message -------- Subject: RE: [Fwd: Request Submit MRS0024 Error] Date: Thu, 24 Jan 2008 13:23:15 -0500 From: Wendell Riley <firstname.lastname@example.org> To: Cathy French <email@example.com> Cathy, yes, please submit this and letâ€™s get a ticket opened on this issue. Combining questions has always been problematic due to the data structure and nature of what we are trying to do; it seems we still have some work to do there. Thanks for the troubleshooting. Wendell From: Cathy French [mailto:firstname.lastname@example.org] Sent: Thursday, January 24, 2008 12:52 PM To: Wendell Riley Subject: Re: [Fwd: Request Submit MRS0024 Error] Wendell, here is what is happening as best I can tell: 1. I can successfully submit a single request regardless of what the COMBINE_REQUEST_QUESTION setting is set at. 2. I cannot submit multiple requests when the COMBINE_REQUEST_QUESTION setting is set at 'COMBINE_ALL' or 'COMBINE_ITEM_LEVEL'. 3. I can successfully submit multiple requests when the COMBINE_REQUEST_QUESTION setting is set at 'OFF' or 'COMBINE_AREA_LEVEL'. 10/1/2008-da-Changed ticket to Debug --- Original --- 1/28/08 ska Bug name: Form MRS0013 throwing SQL error when accessing MRR0027, causing report not to be generated Attached: Screen shot of error we receive Further synopsis: When trying to query a diagnosis, such as Diarrhea, we were able to successfully complete the query however when we click the print button the error from throws the SQL error thats attached and we are unable to print. 02/06/08 ska I have a problem in the Medical Records Queries â€“ MRS0013. The query itself works fine but, in some cases, when I click print, I get the following error: Error submitting report [Tue Feb 05 14:14:10 2008] ... REP-0159: Syntax error on command line. In trying a few different queries, it seems to be related to when I specify a breed in the Specifications, such as (Patient_species=â€™CAMELID-NEW WORLDâ€™ and patient_breed=â€™ALPACAâ€™) 7/31/2008 - RDA - Version 3.1.10 patch 11 Current functionality resolved issue. Closing ticket. 2/13/2008 - RDA - version 3.1.10 When user navigates to BLS0010 (Estimate), the form doesn't populate with the patient's information, only the bill/order # When accessing the Verify/Review tabset and select the Get Med Rec Deficiencies and there are none, the messages displayed: No defecincies found in this epiosde/visit. 7/31/2008 - RDA - Version 3.1.10 ptach 11 Could the default blank entry on order item default to FN? 2/18/2008 - RDA - version 126.96.36.199 with 9i & 10g User needs to close monthly charge accounts (direct deposits or research accounts). In this example, there was no activity for the client during the current billing cycle. If user is on the order item (BLS0002) prior to going to the cashier screen, the order item product line shows a status of UF. When user tries to Approve essentially nothing, the system shows the below inform message: TAXES_FOR_ORDER_LEVEL_ADJ(1e). Order items records were not saved: 100501: non-ORACLE exception. User would be less confused if message were more understandable. NOTE: functionality works fine if user is one cashier form and pulls up same client. See Wendell for more information 2/18/08 ska There is an issue in BLS0001 where inactive RDVM/Clinic relationships are not being filtered out. Bill Liddick - Closed - 8/7/08 2/18/08 SKA PHS0017 Bug When launching the Prescription Detail (PHS0017) form from the Order Items (BLS0002) form, in addition to the prescription_id being passed to the form we also need the patient_id passed as well. Now that we have separate sequence generators for CAH and EFAH pharmacies we have duplicate perscription_id's. Bill Liddick - Closed 08-08-2008 Underlined values (client, patient) are not linking to pds1 and pds2 - UVIS310. LL 8-7-08 - abs - Changed to Top priority In many places in UVIS (e.g., Discharge instructions, SOAPs) when you first enter the screen (and the data has not been verified), the text is autoselected (as if a "select all" was done). If a user accidentally types a key before clicking somewhere, all the text is irretrievably lost. The physical tab will not accept NE as a valid answer on required questions even with findings. We would like for NE with findings to be a valid answer for required questions. This is valid in some cases where the animal would not let the student examine their ears for example. Not sure if this bug, or some setup problem that we can not figure out. 8/7/08 - abs - See also ticket 8602, currently in Test status. This is a long standing bug, and it renders the Identical Questions feature useless. I believe the approach of assuming pairs of questions is flawed (as many questions occurn dozens of times, and for N such questions, there are N*(N-1)/2 pairs that must be considered, and the logic does not work in this case. This is a TOP priority bug. This bug occurs when there are at least 3 tests ordered that share an identical question. The UVIS_MR_QUESTIONS_IDENTICAL_X table holds the mappings A=B, A=C, and B=C. In this situation, the identical questions will not be asked at all. I believe this is because duplicate pairs are being returned (if you remove any one of the associations it behaves correctly). It is necessary to have all the pairwise mappings, though, since you can't predict what tests will be ordered together. I'm guessing maybe it needs a "UNIQUE" added somewhere in the SQL? If the duplicate pairs are returned (i.e., the bug happens), NONE of the questions are asked and instead you get a warning message that there are required questions not answered. I believe that an error is generated which blows out the pop-up where the questions would be asked. When CP was testing 3.1.10 they would get an error: "MSG-00009: dg STARTING AFTERPFORM" with almost every print button. After clicking on OK the report does print. According to Don Garrett, the error is on CLR0001 (printed from CLS0002, CLS0007, etc.). Fixed under ticket 11855. 2/29/2008-wr-Rejected Lab requests are not showing up in lab when re-submitted. Request #35693 for patient #158834 was submitted to the DL. They rejected it. I can see the original request on the lab side in the UVIS_INTERFACE table and the UVIS_DL_REQUEST_ACCESSION_X table. I then checked the hospital side and the current status of the re-submitted test is 'REQUESTED', as it should be. The user got a notification that it was re-submitted and the charge hit the bill/order, so it appears to have re-submitted successfully. But the DL never got the request. 7/31/2008 - RDA - Version 3.1.10 patch 11 Current functionality resolved issue. Closing ticket. 3/10/2008 - RDA - Version 3.1.10 When user is re-printing an old discharge from 188.8.131.52, 3.1.10 labels previously verified discharges as "Draft copy". How can users re-print a verified copy of that discharge with no watermark? 3/11/08 ska When updating VMTH Personnel via Case Summary MRS0024 this does not change the information in the Order Header BLS0001 Screen. You can update the information in the Order Header Screen and it does carry over to the Case Summary screen but does not work the other way around. This also interferes with the Req DVM on the request screen if not refreshed. So when you are updating personnel in MRS0024 and then proceed right into the Admission Screen and entering an populating History and Physical, then into the request screen, when creating a new request is shows the old attending DVM (if updated) as the REQ DVM if you do not requery the data or go completely out of the screen. Seems there should be a trigger on the Personnel screen that refreshes the data when leaving the Personnel section to go to another area and a trigger to update the data on BLS0001. Bill Liddick - Closed - 8/7/08 3/13/08 PDS0001 Mod Privs Issues. 1. Priv #4 granted to Username TRIMCM/Faculty Role cannot access Receivables tab and acct aging in top right corner does not display. All other documented tabs in priv are accessible. 2. Priv # 1 granted to Username OLIENKJ/HO_ACCOUNTING Role. Acct Aging data displays in top right corner which is correct. Full access to all tabs which is not consistent. This user does not have Priv #4 for this module. This is the only priv on this module for this username. 3/12/2008-wr-This ticket is to serve as a release vehicle for in- house testing issues. 7/31/2008 - RDA - Version 3.1.10 Patch 11 Current functionality resolved issue. Closing ticket. 4/29/08 sem Per discussion with Russell, this is still occuring. 3/12/2008 - RDA - Version 3.1.10 Users are sporadically finding communication entries that they are unable to print. Please see: Case # 1075445 Order # 1137669-1 on 2/20/2008 1st communications entry is logged per the form, but when user tries to print and either reviews or screen-prints it, there is no comments, only the report header. NOTE: if you try other entries on this order, they print out correctly both on screen and on paper. 3/13/08-ts 3.1.10 Hosp and Lab go live issues 1. We are not able to change the admit date when a Suffix Order is opened. If the Admit Date didnâ€™t change on the Case Search screen we would like the date of Suffix to remain the date it was opened. People use the Case Search screen and look at dates to identify the episode they are looking for â€“ same as TT# 15815 - real issue is the admit date changes to the suffix order open date on the case summary screen, case search needs to look at the admit date of suffix -1. 2. Client Sign In Form has reverted to printing on 2 pages if RDVM and Clinic are associated with the episode. Many times the 2nd page has only 1 line for client to initial. â€“ changed body of form, trying to adjust printer settings for those that still print on multiple pages 3. Screen shrinks as you work within Case Summary screen 4. Census page â€“ BLS0006 as you add an new line, F6; enter info; save, F10 the curser moves to Student / Att DVM box. This used to stay put so to continue to move within the census field without the use of the mouse to re-click on the current line to enter or make changes to next cases. 5. The Communication Worklist should have discharge date added back to the communication worklist - MRR0008 printout. 6. transfer notes gone - tfr_comment field missing from uvis_mr_case_transfer_list â€“ Matt will work on trying to restore this field from backup 3.1.10: you must is incorrect on RX episode/visit selected above 7. error rx suffix # have a single openFill PHS0006 and PHarmacy Profile PHS0015, when voiding an rx. See file attached for more info. 3.1.10: Unable to query a patient in the Estimate screen unless a previous estimate exists. This error occurs when going to the Estimate screen directly or accessing it via the Case Summary screen. See attachment. 184.108.40.206 and 3.1.10: Unable to un-verify Initial plan in Case Summary. You receive an error that says: The Verification type you have selected is not defined. After you click OK you get another message that says: Entries for the selected verification type have been set to not verified. It then logs the unverification liked it worked but the Initial plan is still verified. 3.1.10: for some reason on the rx label for some refills (not all) a mysterious 1 appears to the right of the date. See attached 9/18/08 - Glenn Waters - These issues seem to be resolved as of patch 13. Closing ticket 3/24/08 - Glenn Waters - A number of issues were noted with MRS0024 during Tinas visit here to train us in how to use the screen. I've attached a Word document with these issues notes.. 9/18/08 - Glenn Waters - These issues seem to be resolved as of patch 13. Closing ticket 4/1/08 - Glenn Waters - Followed the comments instructions/suggestions below. Issue is still there. Added a new attachment documenting steps I took. Changing ticket status back to open 3/31/2008-wr-Cannot duplicate this error locally; I suspect it may have something to do with the path defined for handouts. Check the entry for "Online Handouts Path" in the Episode/Verification Parameters (MRV0008) screen on the Med Rec>Setup menu and make sure this is a valid path that all users have access to. If issue still exists after checking this path, place at least one document in the defined directory and see if it is listed in MRS0024 as an available Handout. *************************************************************** 3/31/08 - Glenn Waters - after applying latest set of patches got further issues. Original issues still remain. Updated and re- uploaded screenshot document 3/24/08 - Glenn Waters - Further issue discovered with MRS0024. See attached screenshots 3/25/08 - Duke - Clinician's Desktop - Case Summary - MRS0024 - Need to change text entry areas to external editor on double click or editor button action. List of text entry areas that use internal editor: Admission Tab :: History :: Text Answer Admission Tab :: Physical :: Findings MPL Tab :: Initial Plan :: Rule Outs MPL Tab :: Initial Plan :: Plan When we try to verify discharge instructions on the verify tab of MRS0024, we get the error: 'Verification Update Failed.. ORA- 00932: inconsistent datapes: expected NUMBER got CLOB 3/28/2008-wr-The Mitra Broker trigger on the uvis_mr_request table errors out and does not let the commit succeed on status changes with a large "Reason for Study" entry. When pharmacy is making a sale for over-the-counter items or food, they open a new bill-order (pharmacy-only) to charge for it. This is also used when charging research labs for stock they are purchasing. They open BLS0001 (Applications/Billing/Order Header), hit the "New Bill/Order" button, select the Order Type (Pharmacy), and enter the Client ID number. At this point, if they hit "Enter" or "Tab" it brings up a list of values for matching last names from which one must be selected, rather than just selecting the client entered. Note that if they manually click in the next field the client list does not appear. When a client ID is entered, the client information should populate for that client, not offer a choice of other clients. This is new behavior with 3.1.10 Can the discharge date/time default to the current system time instead of midnight on the discharge tab of MRS0024. 7/31/2008 - RDA - Version 3.1.10 patch 11 Closing ticket # 5609 to consolidate discharge status tickets. 7/28/2008 - RDA - Version 3.1.10 patch 11 Issue is still occurring. Once used, it ripples through the record upon additional data entry. This is a high level issue. 4/3/2008 - RDA - Version 3.1.10 Locally created discharge statuses more than 13 characters long are allowed creation on MRV0020 (Discharge Template "Discharge Status" tab) but receive a truncation error (Truncation occurred: value too long for field DISCHARGE_STATUS. (FRM-40831))upon selection with a discharge. 4/4/08 ska When in Case Summary MRS0024, Discharge, Selection - when choosing from the Resulted Procedures selection the +/- Rpt fields do not seem to be working. When you are looking at internal results from the hospital ie, CAH Anes/Surg, Imaging.. and those external to the hospital ie, labs and you click - Rpt, the item name and the report show up regardless of the status of the report. When clicking the + Rpt, when and internal result is selected nothing shows on the instruction when drafting not even the name of the procedure. When using the +Rpt to choose a result from the labs, you see the procedure and the statement "Click External Results". - CRITICAL Bill Liddick - Closed - 8/7/08 4/17/08 - Duke - 3.1.10 We need to be able to block searches that have no criteria in the new Clinician's Desktop (MRS0024). Query takes too long to return if ever. 9/18/08 - Glenn Waters - These issues seem to be resolved as of patch 13. Closing ticket 4/17/08 - While testing MRS0024 and using related questions noticed a problem that needs to be addressed. Related questions in this area don't respond to F6 the same way as in other parts of the system. See attached screen shots for examples. 4/17/08 - Duke - 3.1.10 Searching on names that include apostrophes does not work in new search functions on both the client and patient screen. Searching on last names that include apostrophes works on the client screen but not the patient screen. 4/18/2008-wr-The Diagnosis Coding Elements (MRV0017) screen is not populating the diagnosis_id from the associated sequence so users are unable to insert new records from the screen. 4/21/08 - Duke - 3.1.10 Lock or inactivate verified fields that way user do not get confused by being able to launch external editors and edit text and lose changes once returning to UVIS. 4/21/08 - Duke - 3.1.10 Lock the TPR section of the SOAP screen if SOAP is verified. It can be confusing to save some data be not all. Also if you press the complete button on a verified SOAP it changes the status fields to R until you requery. 9/18/08 - Glenn Waters - These issues seem to be resolved as of patch 13. Closing ticket 4/22/08 - Glenn Waters - On further testing of MRS0024 came across another set of issues relating to the discharge, See attached screenshots for details about this issue. MRS0024 issues are now in tickets 16795 and 16815 in addition to this ticket. 7/31/2008 - RDA - Version 3.1.10 patch 11 Current functionality resolved issue. Closing ticket. 4/28/2008 - RDA - Version 3.1.10 patch 5 additional information â€¢Testing scenarios If versions are verified separately using icon: â€¢1st verify succeeded **Saved and verified via â€œInstructionsâ€• tab **Printed from â€œPrintingâ€•button successfully â€¢2nd verify failed via **Completedâ€ â€œInstructions tab **Verified via â€œVerifyâ€ button, â€œVerifyâ€ tab **Printed via â€œPrintingâ€ button, â€œDistributionâ€tab **Printed with Preliminary even though verified 4/24/2008 - RDA - Version 3.1.10 patch 5 When user verfies a discharge and then navigates to the Printing/Distribution to print out final copy, it still retains the "preliminary" watermark. Even if user closes the record navigating back to case search and re-queries, when they print from the printing button, it still says preliminary - you have to go back to the instructions and click on the text box to get preliminary to go away from the print button. If you look at preview button on the discharge tab and print from there, it works fine Scenario from Kathy Curtis: Problem: Un-reject feature used for the hospital appears to be attempting to re-submit the same test on the same sample throwing the sequence in to â€œ0â€• status in result entry CLS0007 Test Case 501000 CBC, Alb, CA ordered in VTH; requested status in Clin Path; can be successfully rejected from specimen login CLS 0003; lab request CLS0002; or patient profile CLS0001. The status can be in either requested or accepted in CLS0002 or CLS0001 when rejecting. Once rejected, the tests are not viewable in Result entry CLS0007 and when rejected in Clin Path, the test appears rejected in the VTH. Currently and prior to 3.1.10, test can/could only be â€œun- rejectedâ€ from patient profile CLS0001. Prior to 3.1.10 an â€œun- rejectedâ€ test would simply return to â€œACCEPTEDâ€ status and could be resulted like any other test. Now, the un-rejected test appears in duplicate in Results Entry CLS0007 with a sequence of 0. The first set is in deleted status; second set in pending status but when an attempt is made to enter the result field with the pending status, (with the far right eye goggles) the following oracle error occurs; unable to perform query frm 40505. This same situation occurs when a test is backed out and re- released in accession receiving DLS0001 4/25/2008-Following issues reported by UMN as part of 4.0 testing: Trying to print reports (i.e. outstanding charges, discharge instructions, admit/transfer details, clin path results, etc) we receive the following error: Unable to connect to Report server rep_server_name_oas_fr. (FRM-41213) On MRS0024,when populating history get the following error: â€˜Attempted go_item to non_enabled item uvis_mr_episode: episode_id (FRM40112) Estimates: Requires a bill/order # - unable to move the estimate to different bill Deceased box not showing on patient tab of client screen (PDS0001). Transferred Case #1 from me (client 4903) to Tina (client 4592), we lost some episodes so decided to transfer from Tina to my son (client #52379). When we did the second transfer the patient and client names changed. Please query in UVISDEV under each of the above client numbers as well as the case summary/patient screen using the case number and you will see what happened. Not sure if this is a fluke or a bug, but it could cause major problems. Calling lab result report from MRS0007 and MRS0024 produces errors and the lab results are not displayed Calling reports from the menu the default printer is not identified and must be manually entered. 7/31/2008 - RDA - Version 3.1.10 patch 11 Current functionality resolved issue. Closing ticket. 4/28/2008 - RDA - Version 3.1.10 patch 5 Case Summary (MRS0024) canvas is NOT updating with Estimate changes made on Estimator (BLS0010)once user closes estimate and navigates back to case summary 4/28/08 lls: We filled a new RX and filled refills. Went to the rx management screen and hit the cancel RX button on the ORIGINAL rx. It did correctly cancel the RX and refills on the rx management screen, however it only deleted the original rx charge from the bill. See file attached for example. 7/31/2008 - RDA - Version 3.1.10 patch 11 Current functionality resolved issue. Closing ticket. 4/30/2008 - RDA - Version 3.1.10 patch 5 When user is navigating from Case Summary (MRS0024)to the estimate form (BLS 0010) a pop-up message initially says "No records found" and you click the "ok" button and it successfully takes you to the estimate screen. Also, there is no underline for the Estimate title field, even though it is required. 7/31/2008 - RDA - Version 3.1.10 patch 11 Current functionality resolved issue. Closing ticket. 4/30/2008 - RDA - Version 3.1.10 patch 5 Per Wendell: Set_Client_ID program unit in PDS0001 is not handling matching home phone numbers in table of Pre-Admission Scenario: User has navigated from scheduler to client to create client ID and receives a duplicate phone number message. Upon "ok" of message to save as new client, user then gets the following error message: Failed to update uvis_appt+dtl.client_id in set_client_id procedure then inform: the price level and credi data was not populated and saved. This needs to be done via the Credit tab. At this point the record is not saved and user must delete home phone number to save record, then go back in and re-enter phone number. 4/30/2008 - RDA - Version 3.1.10 patch 5 When you go to the pharmacy profile (PHS0015) it initially says "The current user has no Default Pharmacy defined" and you click the "ok" button and it takes you to the profile screen. Since general users with no association to either pharmacy frequently use this form, it should not display these messages to the user, as it is confusing. 8/1/2008 - RDA Duplicate issue copied from AU TT 18615. 7/28/2008 - RDA - Version 3.1.10 Patch 11 Additional information: Even when related questions have been answered and verified, they do not populate on the discharge once selected. This is a high level issue for Auburn. 7/16/2008 - RDA - Version 3.1.10 Patch 11 Physical body system and any associated questions, when selected via the "Selections" tab of the discharge to be included in the instructions, do not appear at all in either version of the discharge. See UVISPROD Case # 1050718 for an test example -------------------------------------------- 8/1/2008 - RDA - Version 3.1.10 patch 11 Not sure if this is related, but while creating a test example in UVISPROD, I receive the following error while navigating to the bottom of the related questions: Unable to resolve reference to item RELATED_Q.coded_ans_list. (FRM-40105). Example Case # 1050463 with B/O # 1144516-1 Let me know if you need additional examples. Feel free to manipulate this case as needed. Just don't close as there are charges currently on the bill that would need to be deleted. Thanks. 5/1/2008 sem Please provide us with an example to view. 5/1/2008 - RDA - Version 3.1.10 patch 5 8/1/2008 - RDA - Version 3.1.10 patch 11 The status change from save to complete & exit doesn't refresh when user closes SOAP entry and returns to "SOAP" button overview. In this case, only 1 problem had been identified and that entry was placed in a "ready" state. Upon return, only the problem in the lower right shows an updated status. User must manually refresh form to see the "Ready" icon and also the "red" icon in the day before. Neither status change was recognized upon save and exit. Wendell, I will continue to search for these examples where the status doesn't update automatically. I will open another ticket with those issues. The "Verify" refresh has now been corrected. 5/1/2008 - RDA - Version 3.1.10 patch 5 Users are being confused by information not refreshing after saving the record. This example deals with updating / verifying the SOAP entries but being unable to see those changes until a manual refresh (F8) is performed. Users at the very least need a refresh button at the top of MRS0024 to assist with this functionality if it can not be handled automatically as other forms do. Scrolling down on tab visit - medication gives the error messa FRM- 40735 - ORA-06502. This is happening after installing patch 6 of 3.1.10 Thks Lyse 8/1/2008 - RDA - Version 3.1.10 patch 11 Current functionality resolved issue. Closing ticket 5/5/2008 - RDA - Version 3.1.10 patch 5 When user rolls cursor across the following buttons on the discharge / instructions tab, the wrong description is displayed: "Save" and "Complete" icons show following message: View / Access legacy discharge instructions. None of the other buttons (other than the legacy instructions button) show any description on the Instruction tab. 8/1/2008 - RDA - Version 3.1.10 patch 11 Current functionality resolved issue. Closing ticket 5/5/2008 - RDA - Version 3.1.10 patch 5 Tabbing between fields on the verification Pop-up box doesn't work as expected. User is unable to tab from username or password to either "Cancel" or "Okay". Only navigation that works is to move cursor with mouse. 5/7/08 ska In addition, users are having trouble copy/pasting from the Diagnosis field as well. It appears that the copy/paste is inconsistently not working on all fields in the D/C. The User's are not using the Draft Inst button, it appears that this is when they are having the most trouble copy/pasting. The students will often start their D/C shortly after admission with the Visit Summary. The clinician's then come in and try to copy/paste information into that text field after the student has the visit summary entered. I am not sure that this should make a difference, but the Ross Group should be aware that we are not using the Draft Inst button on some of these cases. 5/6/08 ska In MRS0024 Case Summary - Discharge, on the Selections tab the TPR+ copy/paste button will not copy the data to the Discharge statement area also, in the selections tab under Medications when trying to copy/paste the instructions for individual medications it does not copy the instructions data to the Discharge Statement, only the Medication name again. Bill Liddick - Closed - 8/7/08 4/7/2008-wr-The following issues were discovered in testing or reported by various schools using 3.1.10: - User notifications not functioning. - Comm Log entries disappearing on Case Summary (MRS0024) - ADJUST ERROR invoice transactions not calculating client balance correctly from change in deposit handling. - Discharge Status field truncation error in MRS0001 - Patient Transfer (PDS0004) allowing selection of inactive patient record for transfer. - Error on SOAP tab, Error retrieving SOAP date data..ORA-6502, reported by UMN on Case # 322628 5.19.2008-wr-UGA reports instances where a DEPOSIT transaction on a Patient Transfer was left on the old client. These orphaned deposits are causing errors in the client balance calculations for both clients. The deposits should have transferred to the new client on transfer of the patient with an open order and deposits pending. ******************************************************************** 5/14/2008-wr-UGA reports that new CANCEL ORDER transactions conducted on the Cashier (BLS005) screen are incorrectly recording a zero balance due. ********************************************************************* 5/7/08 - Duke - 3.1.10 After upgrading to 3.1.10 client balances are wrong if the client had a cancelled order before the update. attached is screen shot. Processes and files for updating OAS from 10.1.2.0.2 to 10.1.2.3 8/1/2008 - RDA - Version 3.1.10 patch 11 Issue still occurring 5/9/2008 - RDA - Version 3.1.10 patch 5 Surgical requests are not populating a Emp # on the Bill/order (BLS0002) when added to bill. Information is blank as is the database field. The user's name is logged correctly under CLIENT_LOG_USER. See Bill/order # 1141072-1 Item # 37 (578.42) No employee ID in TOAD, but user id posted (Maxwehs) 5/9/2008 - RDA - Version 3.1.10 patch 5 Order # 1141965-1 was opened with an incorrect DVM # 4057 (Christine Calder). Pharmacist then tried to update order header but received the following error upon saving: FRM-40735: ON_ERROR trigger raised unhandled exception ORA-06502 I was able to trap the error. Here is some additional information: UPDATE UVIS_ORDER_HDR SET ATTENDING_DVM_ID=:1,ATTENDING_SERVICE_ID=:2,ATTEND ING_SECTION_ID=:3,LUN=:4,LUD=:5,LUP=:6 WHERE ROWID=:7 RETURNING ROWID,ORDER_ID,ORDER_ID_SUFFIX,AUTHORIZATION_TYP E,ORDER_DATETIME,ORDER_TYPE,ASAQ_FILE_ID,ORDER_S TATUS,BATCH_ID,CLIENT_ID,PATIENT_ID,ORDER_TAKER_ID, MAIN_PROBLEM,ORDER_COMMENT,DISCHARGE_DATE,REFE RRAL_ID,SINGLE_DIAGNOSIS_YN,PRIMARY_DIAGNOSIS_ID,H OLD_ORDER_YN,HOLD_BY_USER,DISCHARGED_YN,ADMITTI NG_DVM_ID,ADMITTING_SERVICE_ID,ADMITTING_SECTION_I D,ATTENDING_DVM_ID,ADMITTING_STUDENT_ID,ATTENDING _SERVICE_ID,ATTENDING_SECTION_ID,STUDENT_ID,RDVM_I D,RDVM_CLINIC_ID,SELF_REFERRAL_YN,DO_NOT_COMMUNI CATE_YN,RDVM2_ID,RDVM2_CLINIC_ID,RESIDENT1_ID,RESID ENT2_ID,INTERN_ID,TECH_ID,SERVICE_CHIEF_ID,TAX_TOTA L_AMT,DEPOSIT,INVOICE_ID,INVOICE_DATETIME,PRIMARY_D IAGNOSIS_COST,ESTIMATE_LOW,ESTIMATE_HIGH,FIELD_SE RVICE_YN,REF_NO,ANIMALS_SEEN,ANIMALS_AT_RISK,OFFSI TE_YN,OFFSITE_OUT_DATE,OFFSITE_RETURN_DATE,COLLE CT_TAX_YN,CASHIER_YN,LAST_ITEM_SEQ_ID,ORDER_TOTA L_AMT,LUN,LUD,LUP,vetstar_visit_type INTO :8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,:2 6,:27,:28,:29,:30,:31,:32,:33,:34,:35,:36,:37,:38,:39,:40,:41,:42,:43,:4 4,:45,:46,:47,:48,:49,:50,:51,:52,:53,:54,:55,:56,:57,:58,:59,:60,:61,:6 2,:63,:64,:65,:66,:67,:68,:69 8/1/2008 - RDA - Version 3.1.10 patch 11 Current functionality resolved issue. Closing ticket. 5/12/2008 - RDA - Version 3.1.10 patch 5 When user selects the "Given to Client" button on the "Instructions" tab of the discharge, the following prints on the log: --Client Discharge Instrustions generated-- Note: This is only wrong for the client version 8/1/2008 - RDA - Version 3.1.10 patch 11 Additional text help is appreciated. Issue resolved. Closing ticket. 5/12/2008 - RDA - Version 3.1.10 Patch 5 Users are getting confused with the duplicate box options presented to a user when they enter a duplicate phone number or address Scenario follows: User is modifying an existing client address (Client # 1016089)with 2031 South college street. User gets a duplicate pop-up box as expected, but user is then shown less than clear options for proceeding: Create a new client - existing client so user would think no to this answer Use Existing Selected Client - None of the choices exist except for a blank field if no more than 4 duplicate records exist. Selecting that option will send the user into another query of information on the client form which is totally confusing. Modification of verbiage on "Create New Client" button to read "Create new client / use selected client on client form". Just a suggestion to clarify what that button is actually doing. 4/13/08-wr-After applying the 3.1.10.patch8 MU reported errors in client balance calcualtions on those select clients with ADJUST ERROR invoice transactions. Additionally, clients whose balance did not change were recorded in the diff table as if their balance was changed as a result of 8865_init_uvis_invoice script. 5/15/08 - Duke - 220.127.116.11 Entry missing on the Accounts Receivable report when there is a deposit on an account that has a previous balance. 6/10/08 Lisa E. retested this by supplying report parameters for MRR0005 and still had the same problem. 5/16/08 sem The report parameter box for this report provides the option of selecting the Order By - student or Att DVM - and whether this report is printed with a page break in between the student/DVM. Please re-test this functionality. 5/16/08 ska MRR0005 report was previously generated with a page break at the end of the DVM's name (an enhancement we paid for in the initial UVIS), however now when printing report MRR0005 there are no page breaks by DVM name. 5/16/08 ska When in MRS00024, on the Visit, Charges tab, when selecting the Travel Sheet button to add charges to a bill/order via Travel Sheet, IMS0015 when charges are Posted they are not showing up in the Charges tab on MRS0024 unless the screen is manually refreshed. This is another screen that needs to be refreshed when charges are posted. Bill Liddick - Closed - 8/7/08 5/16/08 ska I am having an issue in the Case Summary MRS00024, when retrieving case 190309, the case does have an RDVM Clinic associated with the Bill/Order and no RDVM, in some cases there are multiple RDVM's at a clinic that see a case, so we enter the clinic name and leave the Primary RDVM field blank, however, this is not showing up in the RDVM field on the case Summary - when you click the eyeglasses it gives you a message saying no RDVM associated with this case. They tell me that they were able to enter and clinic only with no RDVM in the past version and it allowed it. When trying to retrieve the case through Case Summary - we get the error: Error getting RDVM data...ORA-01403: no data found. 8/1/2008 - RDA - Version 3.1.10 patcy 11 Thanks for tracking this one down Wendell. Looks good...Closing ticket. 5/19/08 sem After some research and discussion, it appears that in the MRS0024 Request/Result/Pharmacy tab set the Billing Description is displaying instead of the Short Description. There was a set up issue with the product where the wrong mg was in the Billing Description in IMS0004 for product code 286/60. 286/161 has the correct billing description. 5/19/2008 - RDA - Version 3.1.10 patch 5 Case # 1076526 "Breezie" Hughes Rx# 636194-0 Medication dispensation on 4/2/2008 286.60 (OMEPRAZOLE 4MG (CPD)(SA)) is showing up as "OMEPRAZOLE 2MG" Rx# 636194-0 Not sure where this description came from, but it is causing confusion in filling the same med, which also shows as a 4mg portion. How could the name have been modified, but show correctly on profile, detail, etc? 5/20/08 ska When User's have view only access in Menu Role to Module to Case Summary MRS0024 they are able to submit and process requests using new request in case summary. on MRS0024 3.1.10 patch 9, the student can still edit the SOAPs after the cutoff time. The cutoff Time seems to set correctly based on the the entries we have on MRV0008, but the SOAP entries are still editable after the cutoff time that is visible on MRS0024 09.30.2008 Seems to be fixed. Thanks.Lyse _________ Hello there Account freeze mechanism is not stopping normal users from opening a bill to a ASAQ frozen account. Furthermore, the normal user can open a bil if he enters the bill account from the name field. Tested with UVISINT - 3.1.10 patch 9. See my document 9/18/08 - Glenn Waters - This seems to be resolved as of patch 13. Closing ticket 5/28/08 - Glenn Waters - While testing BLS0006 noted an error while picking the student from the screen there. The selction isn't limited to just students. See attached file for screen shots that show this issue. 9/18/08 - Glenn Waters - These issues seem to be resolved as of patch 13. Closing ticket 5/29/08 - Glenn Waters - Issue surfaced with the new search containing field and phone numbers. If you do a search "Containing" and it has a leading zero, the zero gets ignored. See attached for more details 5/29/2008 - RDA - version 3.1.10 patch 5 If a case is worked up on one service and then transferred to another service after the initial service has verified their history questions, the accepting service must "un-verify" the previous questions before they can "populate questions" from their service. My clinicians are not happy about having to verify some other services questions before they can add their own. The functionality works the same regardless of whether or not the answers were verified before or after the transfer. Help.... 8/1/2008 - RDA - Version 3.1.10 patch 11 I reviewed the issue again, but can still find no visible field the report is sorting on. Still an issue. 5/30/2008 - RDA - Version 3.1.10 patch 5 Users are reporting no recognizable sort order for the Register Invoices (BLR0009) when called from the Daily Register (ACS0001). They did sort (pre 3.1.10) by ascending invoice number. 7/28/2008 - RDA - Version 3.1.10 Patch 11 Issue still occurring. User can change physical findings from "N" to "A" on a verified record. 6/10/2008-wr-CU adds the following MRS0024 security issue: In MRS0024 after a record has been verified and the Episode closed the user is still able to add data to the medical record in the Initial Plan, Master Problem, and the TPR+ fields in MRS0024. 6/3/2008 - RDA - Version 3.1.10 Patch 5 A "Faculty" role user was able to change a verified Physical status from "NE" to "N" without having to unverify record (it had already been verified). Shouldn't the system stop this type of behavior without having to un-verify first? Even though either choice required no additonal findings, they are 2 different findings and should require security/logging to change once verified. See Case # 1077466 with order #1142600-1 as example UVIS4 and Java WebStart have revealed issues related to launching cross-app screens (e.g. HO-->Labs MRS7-Request Profile --> CLS11-View Patient Results and DLS20-Patient Request Information/DLS27-Reportable Events and Labs-->HO CLS7- Result Entry --> PDS2-Patient Info). This ticket provides DB link setup information to resolve this issue. 9/18/08 - Glenn Waters - Seems like this issue is resolved in patch 13. Closing ticket 6/4/08 - Glenn Waters - Entering comments in MRS0024 on the history page is problematic. See attached screen shots for further documentation of this issue. Tab request/result -> new request. We used to be able to select a MR Request sheet by typing the first title's letter from the drop list. This is no longer working. If there are required answers to fill in (after submitting requests) and you want to postpone completing all your answers, you have to press the X button and you loose all you data entry.... This did not used to work like this. After discussion with Wendell, can you add the logic so that when the user hits the X button to postpone answering questions, the system will save whatever answers were done and leave unanswered question blank so the user can come back later to it and don't have to reenter all data. thanks LL Hello there When you send an updated module (ex. 3.1.10 patch 11 pds1, pds2, mrs24), I get problem with translation. I end up having to delete the whole translation for a module and redo it manually because I cannot figure out which variables were added-deleted- modified. Can you, whenever you change any module, include a detailled spreadsheet of the changes to variable. thanks LL 1) If we have two communication Events defined for a single document (RDVM_DISCHARGE) for differing statuses (PRELIMINARY, VERIFIED). The preliminary is NOT appearing on the list as â€˜ready to be sentâ€™; However, if we have a single communication Event defined for the PRELIMIN ARY status it will appear on the communication worklist as ready to be sent. We need to be able to handle RDVM discharge letters that never get marked as approved preliminary and go directly to verified as well as those that get initially marked as approved preliminary and later updated to verified. 2) No entry is being made in the communication log when a document is sent via the communication worklist (MRS0014). There should be an entry noting the communication Type generated, by whom, the date it was generated as well as the method it was communicated (fax, mail, etc). NOTE, Comments entered on the communication worklist are also not going to the communication log when the document is sent via the communication worklist. 3) When trying to send the CP_RESULTS we receive the following error: Error in communication log entry. ORA 06502 PL/SQL numeric errorâ€¦â€¦ 1/28/2009 - JLM - At this time, we cannot recreate the issue, but it does exist (as seen with case #14666 , episode # 48175-1 in UVISDM). Please note that the "client" default did not change appropriately (and is a behavior I cannot recreate). We have not explored the behavior of manually changing #14666 default client template to the appropriate choice from the LOV (which is available in the LOV) as this case is our only example of the error. Can you see something related to the 48175-1 episode that may have caused the error? Apart from this we will continue our tests after the next patch is installed before determining the resolution of this ticket. Thanks! ******************************* 1/20/2009-wr- Unable to duplicate this error locally or against UMON DM instance on Case # 17148; I get no error on "Set Default Inst Selections" or "Draft Inst" on the client. Please re-test this and if issue persists provide detailed steps used that recreate the error for the UVIS user. ********************************* 11/17/2008 after internal transfer of a patient, in mrs24-discharge- diagnostic, pressing"set default inst selection" generate the error message FRM 40735- ORA-06502. On the tab instruction, client version. If you press "draft Inst", it generate the same error message FRM 40735- ORA-06502 see patient 17148, UVISDM. UVIS 18.104.22.168. =================================== 10/09/2008 LL UVISDM - 22.214.171.124 patient 14666. We have defined 2 templates (client & RDVM) for serv-section ACIE- Ophtalmo. Whenever I draft the discharge letter for this serv- section, I get the error message Error retrieving just tested patchtemplate... ORA-01422 exact fetch 07/28/08 LL I service/section 12 with the same result. The temporary file sent to the zebra gets created but nothing printed to the zebra. Don't forget we use the WIN2DOS module to print accent on a zebra. ** I tested with my user and I have no default pharmacy. -------------------------------------------------- 7/1/2008-da-Changed ticket from Enh to Debug. Ticket already coded. --- Original --- Nothing gets printed to the zebra from PHS15 - RX label - button "print Copies". From the same pharmacy, screen PHS0006,I can print to the zebra. The printer definition is the same in both cases.Lyse NOTE: This ticket is part bug and part enhancement. The Medical Records Deficiency report is not working.... Please change the code to be <= discharge days rather than >= Please verify that page breaks are working. They are not here, but could be me:) Please add the ability to run report for a specfic DVM. MRS0024 patch 11. On patients that have been transfered to new owner, when you switch from the case search to the case summary on an old episode with the previous owner, you get the error messages "No Records Found" unless you go to the patient screen and activiate the old patient record. MRS0024 patch 11. You get the error messages "WHEN-BUTTON- PRESSED trigger raised unhandled exception ORA-01403" when trying to open any document that cannot be opened by microsoft office (pdf files for example). Mircosft office documents open correctly. 9/23/08 - Glenn Waters - As of patch 13 this situation has been resolved. Closing ticket 7/3/08- Glenn Waters - A problem surfaced soon after we went live with the newest version. It has taken us a while to diagnose it specifically. We have a group of users who are remote to here who immediately started complaining that the "Order Header screen isn't working right", "it takes forever to use it now" etc.. Turns out the way they use the screen is to key the client number in first then hit the "tab" key to retrieve the client information. When I tested the problem here there was a noticible pause (2-3 seconds) but that wasn't horrible. It has been reported to me when they do this same task, it takes "a couple of minutes" to retrieve the data. After extensively looking into this we think we have identified the problem. Prior to this version that task did a direct query and only returned the result. Now it seems like it sends back through the data "pipe" a ton of extraneous data in addition to the query results. It looks like it is returning the entire client table.. I have attached in a zip file documentation from the DBA here that shows the two data streams, along with his explanation of the issue. 9/19/08 - Glenn Waters - This issue seems to have been resolved as of patch 13. Closing ticket 7/7/08 - Glenn Waters - While working with PDS0002 and MRS0024 and using the adding external documents functionality some issues were noted. File name lengths along with it seeming to make copies of the documents in other directories were the issues. See attached word document for more in depth documentation of this issue.. 11/14/08 - Glenn Waters - Re-opened ticket. I suspect your registry is still in the "hacked" state you discovered back in July. I tested this morning and it is still a problem(in patch 14). If I hack the registry it works ok, but you were going to make a more permanent fix in UVIS so everyone didn't have to "hack" their registry. See email clip below. "Glenn, you should be able to keep the â€“nohome option with IE as your default browser and just add the â€œ%1â€• after it (with a space between the two) and it work just as well. The â€“nohome option simple prevents your browser from going to your default home page so things should load quicker because we arenâ€™t waiting for your default home page. I think that the â€œ%1â€• was initially a Netscape convention for passing in the URL that everyone supported but I guess Microsoft decided they didnâ€™t want to play along anymore; unfortunately that is what UVIS is looking for. What is happening is without the â€œ%1â€• string UVIS does not know where to put the URL in the command string so it just tacks it on the end and so it winds up appended to the â€“nohome option with no space separating it. The browser then doesnâ€™t correctly interpret the â€“nohome option or the URL, so in testing I have forced a space between the â€“nohome option and the URL and it works. This mod will be included in the next patch. Wendell" 11/13/2008-wr-Tested locally against NCSU image server (http://cvmris.ncsu.edu/reports/examhistory.aspx) using IE 7/7/2008-wr-Per testing at UMN, user is unable to override default printer with manual entry in the Destination Name field on the parameter form in UVIS 4.0. This is applicable in those instance when a report is printed via a parameter form. 1/28/09 - Glenn Waters - As of patch 16 this issue seems to have been resolved. Based on user input and testing. Closing ticket 7/9/08 - Glenn Waters - While working with MRS0024 we noticed that drugs issued from the pharmacy weren't passing the lot numbers over to the places in MRS0024 for them. It doesn't allow you to update the record either to put one in.. See attachment for screenshots documenting this issue. 7/28/2008 RDA - Version 3.1.10 patch 11 This is a high priority issue for Auburn. 7/15/2008 RDA - Version 3.1.10 patch 11 Issues with Diagnosis in EMR 1. Verified diagnoses are able to be deleted 2. Only unverified Diagnoses have impact on MR EOC deficiencies if left unverified 3. Null diagnosis does NOT produce a deficiency in the EOC Since there is no separate Med Rec component of "Diagnosis", the deficiency should be rolled in with the discharge as part of it completeness/deficiency if not entered or verified 8/21/08 lls: we will be testing this to confirm that it is still a problem in 4.0 - I will update ticket once this is verified This is probably an issue with our data, but I cannot figure out what. If you go to case summary and pull up patient number 317987; go to the comm log/comm log and try to click on text view you receive the following error: Error building text view...ORA-06502: PL/SQL: numeric or value error Please verify that all optionally requirement elements of the medical record (diagnosis, body system, anatomical site, etc) are being checked on episode close. 7/16/2008 - RDA - Version 3.1.10 Patch 11 Password is left populated on manage tab if any action (close episode, re-open episode, un-verify, un-finalize Rslt)fails due to deficient records. Even if the use selects another case summary button like admission, then returns to the Verify/Manage tab, the username/password is still populated. This is a security issue. 8/1/2008 - RDA - Version 3.1.10 Patch 11 This ticket will be used to track the areas of the new case summary that do not automatically refresh after an action has been performed from one of the buttons / tabs. Demographic section at top *None at present Admission *None at present MPL *None at present Visit *None at present Req/Result **Pharmacy - Once a pharm request has been made, the user must exit case summary and re-populate to see new request/fill (NOTE: Refresh (F8)doesn't work here either Discharge *None at present Personnel *None at present Comm Log *None at present Verify *None at present Printing *None at present 9/18/08 - Glenn Waters - As of patch 13 this issue is resoved. Closing ticket 8/7/08 - Glenn Waters - While working with the communication log it was noted that when you "append" an entry, it arbitrarily posts a date and a time stamp of 12:00AM. See attached Word document for an example 10/21/08 - Glenn Waters - After some assistance from the Ross group we discovered a setting that wasn't set correctly. After changing the option this functionality seemed to start functioning correctly. Closing this ticket based on that. 10/14/08 - Glenn Waters - After testing this on patch 14 the issues remain identical to the original problem reported. Reopening ticket 8/7/08 - Glenn Waters - Testing of the identical questions functionality has shown that this functionality doesn't seem to be working correctly (or at all). I've attached a Word document created by our senior lab person (Sandra Horton) showing the steps she went through to use this functionality. 11/13/2008 LL I did not make any change in the registry ... and with 126.96.36.199 it is now working ... +++++++++++++++ 10/22/2008-wr-Tested against UMON UVISINT instance and could not duplicate this error. Suspect it has to do with the NLS_DATE_FORMAT setting on the local machine. Check this setting in your registery under HKEY_LOCAL_MACHINE-- SOFTWARE--ORACLE. Try changing this setting and seeing what effect it has on this error; if error persists please note in the ticket what your NLS_DATE_FORMAT setting is. ****************************************************************** When selecting a date > today's date in the field To (box Date/time Needed), I get the error message ora-01830 date format picture ends before converting entire input string. tested with UVISINT - 3.1.10-patch 12 From BLS0001, the order datetime can be changed by any user having write privilege to BLS0001. 188.8.131.52 - UVISDM Lyse 8/19/2008 - RDA Version 3.1.10 patch 11 Per further testing and discussion with Wendell, unable to replicate MRS0024 issue at this time in either production or test Database. Please re-direct this issue to MRV0007 for synchronization of "Rel Q" checkbox. 8/19/2008-wr-This ticket raises two issues. The first is handling of related questions in MRS0024 and the second is the user interface in MRV0007. In testing MRS0024 I can NOT re-produce the error described. When questions are populated they pull in all active questions (parent and related) and I can access those related questions regardless of any changes in MRV0007 after population. The description states that your users were "prevented from accessing those questions". How were they prevented, did they receive an error message, did no questions populate??? Are you sure there were related questions set to active at the time the questions were populated. On the second issue the "Rel Q" checkbox on MRV0007 is simply a visual flag that the record contains related question. It does NOT activate or inactive those related questions. The sole intent is to let the user see that a record has related question without having to open the separate canvas and check. I concur that this interface could use improvement and will re-direct this ticket to that end but this is a relatively minor issue on a maintenance screen. ******************************************************************* 8/14/2008 - RDA - Version 3.1.10 patch 11 8/15/08 sem After some emails with Russell and research, the MPLs in the popup when adding a new request item in MRS0024, are not from just the current EOC. 8/14/2008 - RDA - Version 3.1.10 patch 11 If a user has identified new Master Problems in addition to existing ones from a previous visit that are still active, shouldn't all active MPL's show on the request pop-up to allow association with them as user is making requests in UVIS? Example: This is case # 1073663 (UVISPROD) and only 3 of the 7 active MPL's are displayed on the request Pop-up. Only problems: 6(dental calculus)(Active date 8/13/2008) 7(heart murmur)(Active date 11/30/2007) 11(adrenal mass) (Active date 4/24/2008) are showing on the pop-up 09.30.2008 LL fixed. thanks! when selecting the "do not communicate with RDVM" flag, the system is not generating a warning in the communication screen. Am I missing some definitions? Lyse 09.30.2008 LL Fixed. thanks! ---------------------- Users with RO access to BLS1 (technician) can modify the BO HDR from MRS24-personnel-VMTH. They can do it regardless of the BO status(closed or not).Lyse 09.30.2008 fixed. thanks Lyse --------------- If you update the census from MRS0024-Visit-census by pressing the "add/update census" and then press the "view census", the update is not carried out to the BLS6. Once the patient is on census, why is it that the flag "on census" is not checked? 8/15/2008 - RDA - Version 3.1.10 patch 11 There are differences in the reported deficiences of an EOC depending on which of the following areas the user is looking: 1. MRR0005 - Deficient Medical Records Report 2. MRS0024 - Case Summary - Verify - Review tab Example case: Case # 1079137 EOC # 1146576 MRR0004 shows deficiencies of TPR+ and Results (no unverified results to be found) MRS0024 verify Review shows: The following deficiencies were noted: There are un-verified MDB/TPR+ entries In reviewing the record, it looks like the case summary - verify - Review tab is correct. Why is it different from MRR0004? Addtional examples: Case # 1079137 EOC # 1146576 Case # 1078904 EOC # 1145876 This example has multiple results in Preliminary and cancelled statuses. 9/23/2008-wr-CU added via e-mail: What happens is after the record is verified and all the checks are done by MR they Close the Episode from the Verify button. When they click Close Episode they get the error You cannot update the record (FRM 41050), when displaying error via the Help it is (-0). If you click okay and continue trying to close the episode eventually it will close. I think you initially talked with Cathy French about the ticket and she had ask me to see if there was anything like Diagnosis, MPL's, etc that may equal the number of times it takes to close the record. Also, when looking at the log on the Management tab you can see an entry on the log for each time the User has clicked okay to the error. Well, with the exception of the case below, OF COURSE! There is one with multiple closing entry in the Manage tab in the verify screen, PID 182389, Episode 713076. These are both in our production instance. This happened when Doreen was logged on and her role is Office Manager. ************************************************************** Bill Liddick - input from Cathy French/Lisa Erwin Example: Case# 191077, Episode 707399: It took 4 times to close the episode. Per Lisa Erwin, there is one entry for closing the episode in the Verify, Management tab - the This item is carry over from TT 16095 - item #5. The Communication Worklist should have discharge date added back to the communication worklist - MRR0008 printout. If a client comes for a visit and wants an estimate for a future treatment, the estimate appears to be associated with the actual visit in MRS0024 although it isn't. (I entered a final estimate and pressed done. The system prompted me with the question about linking the estimate to the BO and I entered no.) Because the estimate is not linked to a BO, i cannot print it. I should be able to print it. From BLS1, tab financial, you cannot clear the Estimate low and high. However, when accessing it from MRS0024- tab estimate, you can do it. And worst, without any write access to bls1 or bls10, you can change the estimate low and high from MRS0024-tab estimate 08/28/08 LL Sorry it was my mistake. In mrs24-discharge-Diagn, if you select the button "Set Default Inst selections", it seems to select -Rpt to all proc for RDVM and Client. If there were already some setup (+Rpt to some of the proc), they don't get reset and you see both -Rpt and +rpt for the same procÂ-. I guess this should be reset. ------------------------------------------------------- 8/26/2008-wr-Tested this issue locally without error. Note that the sample you provide in your screen capture is not showing the same record. Your initial setting is on a '1 BIOPSIE ENVOYEE....' procedure and your second screen shot does not show this record; you did not scroll down to make it visible. Please re-test this issue and insure that you are looking at the same record/procedure. ****************************************************** I selected some proc to appear in the discharge. I saved the data. When I retrieve the patient again, it has lost my setup. See the print screen.Lyse From Lisa Erwin Email 8/26/08 When updating the Open Date/Time on the Order Header, it updates the Admission date in the Case Search screen, however on the case summary screen Admission date does not change. Example case is in the Production instance. PID# 192221 (Buffie) b/o - episode id # 715072 client ID# 73417 (Mussi), Date was changed from 8/10 (which was incorrect) to 8/9/2008. 10/28/2008 - RDA - Version 3.1.10 testing patch 13 & 14 Current functionality has resolved issues below. Closing ticket. 9/9/2008-wr-The estimate structure and functionality in MRS0024 was updated as a result of TT # 20616 slated for patch 13 release. Please re-test these issue with that version as I think these are all addressed. ********************************************************** 9/2/2008 - RDA - Version 3.1.10 patch 12 (testing) 1. Estimate amount is not being refreshed on the top right portion of case summary once changes made to estimate and saved 2. Estimate low & high range is not showing at bottom on estimate tab under admission. 3. User can not delete an estimate if it is no longer tied to a bill/order, even after clearing the estimate in question. Placing ticket back in "Open" status per Susan. 8/28/2008 - RDA- Version 3.1.10 patch 11 Issue #1 Error message received after adding additional estimate to other existing estimates: MSG-2000 Error retrieving estimate information (BLR0010) ORA-01422: exact fetch returns more than requested number of rows After entering through message, allows user to continue and save Issue is sporadic Issue #2 User inputs charges vis "Select List", then creates a new estimate. When user then navigates back to "Select List" tab to see the 1/6/2009 - RDA - Version 3.1.10 patch 15 Please see Bovine case # 1059563 (2) and order 1149876-1. Select the "Verified" status icon and look at record details. Note that Dr. Herris Maxwell's "Approved by" verify times for each day's verification are all 12:00am. I know via Dr. Maxwell that he is not here every evening at midnight to do his verification, he is home in bed. The "Updated by fields at the bottom of this pop-up also give a time of 12:00am. Does this help?? **************************************************************** 11/14/2008-wr-Tested again locally, following the steps provided and still cannot duplicate this error. The current time component is displayed and stored on the Approved By Date and the Updated On date fields on initial verification and after closing screen and re- opening it. Please provide the details of a sample record on an AU instance that I can test that exhibits this behavior. ******************************************************************* 10/28/2008 - RDA - testing version 3.1.10 patch 13 & 14 Issue still occurring. User is verifying entry by selecting either the status icon to left of date and also comment icon to right of SOAP icon. User then selects the "Verify" button. Initially, this looks right, but if user then closes pop-up boxes and returns to Case summary/SOAP/SOAP, a click of the now verified "Status" icon shows an "entered date" and time correctly, but in the "Approved" field, the time shows 12:00 am. Also, at the bottom, the updated by date/time field also shows 12:00 am. This functionality also exists for the comments verification 11/11/2008-wr-Have re-tested this issue and just as stated in the resolution notes I get no error when correcting my password after a prior failed attempt. Please provide me sufficient detail to replicate this error i.e. a username and password, a db instance, a record, and the precise steps taken (which tab, which field entered, which button pressed, etc...) ********************************************************* 09.30.2008 LL partially fixed. we don't see the user and password but if you make a mistake with the password, you cannot approve anything until you logoff-logon to UVIS. --------------------------------- if you make a typing error with the approval logon, you get ther error message authentication failed. Could not connect as LAFONTAL/XXXXX@uvisdm. Can you please remove the sign on string which shows the password used. Once you get 1 authentication failed error, you can no longer approve anything. You keep getting the "authentication failed" error message. You have to log off and again to UVIS 10/7/08 - Glenn Waters - Tested the fix today. Issue is still not resolved and fails in the same manner as reported in the original ticket. Added additional screenshots documenting this. Reopening ticket based on this. 9/10/08 Glenn Waters - Discovered an issue with the form. It seems like it is blowing the fields on the RDVM street address field(too long). See attached screenshots for examples. 09/11/2008 LL the ASAQ item icon is not recalculating the ASAQ dolla amount for all ASAQ items on the bill.see attachment 10/7/08 - Glenn Waters - Issue seems to be resolved in patch 14. Closing ticket 9/17/08 - Glenn Waters - Noticed when I printed this report one of the lines seemed to be placed a bit low. See attached screenshots for an example of this 10/7/08 - Glenn Waters - This issue seems to be resolved in patch 14. Closing ticket 9/17/08-Glenn Waters - While testing I noticed that the estimate "high" figure wasn't displaying correctly. I suspect this is only a cosmetic issue, but with all of the changes made concerning estimates it may indicate something else. See attached screenshot for example 10/7/08 - Glenn Waters - This issue seems to be resolved in patch 14. Closing ticket 9/17/08 - Glenn Waters - In patch 13 we have an issue when we try and transfer patients. It seems like you have to requery the patient AFTER accepting the transfer before you can get your questions populated. See attached screenshots for an example of this issue 1/23/09 - Glenn Waters - As of patch 16 this situation seems to be resolved. Closing ticket. 10/7/08 - Glenn Waters - While testing this on patch 14 came across another error. The client search seems to be repaired, but if you attempt a second search after doing the first, you are unable to. I've attached another round of screen prints documenting this. Re- opening this ticket based on that. 9/18/08 - Glenn Waters - On MRS0024 the search function "by client" doesn't work anymore. It was functional in patch 12 and prior. See attached for snapshots from TOAD of what happens when you use this function 1/23/09 - Glenn Waters - As of patch 16 this situation seems to be resolved. Closing ticket. 9/23/08 - Glenn Waters - Problem was noted on this report that the dates it asks for are in DD/MM/YYYY order. This is not just a cosmetic, since the form actually requires the dates to be entered like this. after intalling 3.1.10 patch 13 authorized users are unable to enter thier password in order to perform the various actions of the manage tab. Error: This field cannot be Updated. 1/26/2009- MU- CPS This problem still exists in patch 16. One of the patients I tried on our test database (TRHOSP) was 147793. When I tried to add communications log entry I get "Field is protected against update (FRM-40200)." ----------------------------- Since the update to patch 13, users can nolonger add communications log entries if the episode is closed. The problem also exist in patch 14. 1/28/2009- MU- CPS Sorry, this is NOT occurring in pathc 16. I originally tested this with the wrong bin configuration. The new guy aways causes problems. 8^) It looks like it IS fixed! ---------------------------------- 1/26/2009- MU- CPS This error is still occurring in patch 16. When testing the supplied fix in our test database (TRHOSP) I'm still getting this error. I did the following: -Clicked on the "Case Summary" button. When the Case Summary screen comes up (MRS0024) I click on "Search" and entered in a patient number (example of 357423). This brings up the last visit for the patient. If you change to a closed visit, I'm still getting the "You can not update this record" message. That message comes up twice. I also found that when trying this on patient 378596, that if you click back to the open visit, you also get the same error message twice. ------------------------------ This error occurs in patch 14. When querying closed episodes from case summary the following error occurs: You cannotrun this report (MRR0005) for a specfic Please add the ability to update this record. Sometimes user must DVM. Note this ticket created from entry on TT # 20342. 10/6/08 - Glenn Waters - Issue arose while I was reopening a bunch of old orders on our test system. Suspect this wouldn't occur too often in real use, but there would be a possibility of a user needing to reopen multiple set of bills in one sitting. Thats where the issue comes up. See attached sreenshots for more details 06.10.2008 LL I cannot un-finalise a completed result. Tested with UVISDM - 184.108.40.206 with request id 58724 which is in the status complete (patient nb 1) Lyse 1/23/09 - Glenn Waters - As of patch 16 this situation seems to be resolved. Closing ticket. 10/9/08 - Glenn Waters - Noticed issue with MRV0016 that it doesn't seem like it does anything. Adding records, and de- activating seem to be ignored. See screenshots for examples. Can you check on something for me regarding CLR0001? There are three animal demographics fields in CLR001 that are being pulled from uvis_cl_req_pat_log: cf_species_age cf_breed cf_sex_wgt This is causing problems for us if we need to change/correct the animal information in the patient table, the data in the uvis_cl_req_pat_log table is not updated so incorrect information is going out on the report. Do you happen to know why the significance of this table and why or if its necessary for the report information to be drawn from this table? Thank you, Tammy > 11/11/2008-wr-Issue discussed in proj mngr conf call and group agreed to have data in New Request block be refreshed. ************************************************************ 11/6/2008-wr-I can imagine there may be instances where you would want the date to stay the same across cases. This is not something I am willing to change based on the wishes of one school; if you would like to bring this before the project managers meeting and get a group consensus on how everyone wants this to behave I will change the behavior accordingly. ************************************************************* As long as you leave mrs0024 opened, the field "date needed" from req/Result - new request screen is never refreshed. Our users will keep MRS0024 opened all day long and their requests (field "date needed") will look like they were all needed at the time they logged into mrs0024. As a default, I think there should be a mechanism to refresh this fieldwhen fetching a new patient. What do you think? Lyse tested with UVISDM 220.127.116.11 Please add a 'given to RDVM' check box on the discharge tab of MRS0024 (like the 'given to client' checkbox already there) and have both of them update the communication worklist when checked. Please add a check to the communication worklist for discharge letters that do not contain any text in the body. Please add a pop up message notifying user that the letter is blank. 10/23/2008-wr-MU reports that the Ext Docs functionality in MRS0024 is able to store .wav files but when you attempt to "Open"/play the file the Windows Media player is launched but the file does not play. 10/28/08: lls - version 4.0 When we try to request a lab test from clin path using MRS0024 we receive the following error: "The interface to the system is currently down. Your request for ......." NOTE, the request does work if I use the request profile screen (MRS0007) 10/30/08 - Glenn Waters - While testing MRS0024 stumbled on the fact that the eyeglasses and graph icons on the result screen, both present the results. Eyeglasses should present the request, graph the result? See attached. 30/10/2008-wr-This ticket opented as a CM/release vehicle for misc issues found from internal RGI testing: - Primary Diagnosis (BLV0008) screen, LOV driven items (Service/Section/DVM) on the Instruction tab are not clearing the database id fields when cleared so field data is not really deleted. - Drafting Disch Inst on MRS0024 is not correctly pulling in Instructions associated with the Diagnosis via (BLV0008) when they are assinged at the service/section/DVM level; it is only getting the initial default. 11/4/2008 - RDA - Version 3.1.10 patch 12 User receives the following message when attempting to view SOAPs via the "Text View (Episode)" button: Error building SOAP text view...ORA-06502: PL/SQL: numberic or value error Case # 1080717 (Dixie Dew) Bill/order 1151072-1 hello there A student which has access to MRS0024 can add an estimate to an open bill using the admission - estimate screen. The estimate is then automatically associated with the opened BT. However he cannot open the estimate calculator screen because he does not have access to it. The student should not be allowed to add an estimate to an open bill if he does not have access to the BLS10. We are not using MPL. As a student (with no privilege for MPL) Enter data in Plan Initial Text Fields on MPL tab 1. Populate MRS0024to MPL-Plan Initial tab (see test #66 in this document) - 2. Attempt to enter text in any/all text fields Receive error that you have insufficient privs.(as expected) 3. if you press the Â«Send to MPLÂ» button for an empty field, you recieve a series of error messages with no action taken in the end. Populate from MPL returns error that data has to be entered. YOU WILL NEED TO EXIT THE SCREEN ENTIRELY TO CONTINUE TESTING. THE ACTIONS PERFORMED HERE CAUSE ERRORS THROUGOUT THE SCREEN UNTIL RESOLVED.tested with UVISINT, 18.104.22.168 -patient 4334 2/2/2009-da-Changed ticket type to Debug --- Original --- UVISINT 22.214.171.124, patient 4334 As a student with no privilege for SOAP 1. Press Â«Populate/Re-Populate SOAPÂ» button with a particular date highlighted No message, but SOAP does not populate The action should either generate the SOAP or generate an error response. The button appears to be "dead". There is no message, but SOAP does not populate. What is it supposed to be doing? If the student press TExt View (Patient), the subscreen opens. The documentation does not explain what should happen here. Is it functionnal because there are patient data. If the student press TExt View (Episode), the subscreen opens. The documentation does not explain what should happen here. Is it functionnal because there are episode data. UVIS 3.1.10 patch 15 UVISINT. A student can update the specimen of a completed request when going from MRS0024- >REQ/Result tab -> LAB -> select google of a completed request. Scr MRS8 opens -> tab request - button view items and you can select any specimen you want. You press "done" button and the information is saved although the request is completed. 11/18/2008 - RDA - Version 3.1.10 patch 15 Users with appropriate security (via Module privilege # 3) to close a Episode are receiving an error message upon execution of "Close episode". The error states: "You cannot update this record FRM-41050. Okaying through this message then populates the Modification log with the Action "Episode Closed" and lists the correct date, but the status of the EOC remains open when viewed at top middle after Admission date. This issue is sporadic and effects the following roles at present: HO_MED_REC, HO_MED_REC_MGR, HO_RAD_FACULTY Example: Case # 1078811 EOC date 8/4/2008 11/24/08 lls: version 4.0 On phs0006 the case number, product code, and pharmacist information is not displaying on the screen. 11/24/08 lls: version 4.0 When querying multiple products via the products screen (IMS0004) and using the notepad to view them the product line and sequence number are not displaying on the notepad. 11/24/08 lls: version 4.0 There are no case numbers or quantities displayed on the RX approval listing notepad on PHS0005. 11/24/08 lls: version 4.0 The instructions are not required on the RX approval screen (PHS0005). 11/26/08 - Glenn Waters - While attempting to do a discharge using MRS0024 we are unable to get the results of lab tests to print along with the discharge. See attached for an example of this issue 12/2/08 LLS version 4.0 Unable to print the detail order report from MRS0024 (Visit>Charges tab) or BLS0002. Receive the following errors: Unable to run report (FRM-41214) on MRS0024 OR Run_Product(REPORTS) is no longer supported, use Run_Report_Object instead(FRM-41842) on BLS0002 NOTE: The report does work from applications>billing>billing reports. 12/2/08 LLS version 4.0: We navigate to the estimates screen from the case summary via the Admission>Estimates tab. We are unable to enter any product code information or select any items from the select list sheets until we save the estimate with a name. We receive the following errors when trying to add product code information: You cannot create records without a parent record (FRM-41106). When then receive Invalid value for field SHORT_DESCRIPTION (FRM-40212) 12/3/08 lls verison 4.0: From hospital MRS0024 case summary or request profile MRS0007, one can add or change the question to an accepted or completed test request by clicking on the question mark to get to questions/answers. It does not update the lab side, but does update the hospital side. This should not be allowed once the test is submitted. Please add the ability the 'Update RDVM data on Closed orders' module priv to include the abiliity to update the 'do not communicate' and 'self referral' flags. 12/15/2008-wr-Currently PACS system interface in UVIS looks for 'HISTORY' request question; UMN would like to change this to 'INIDICATION FOR STUDY'. Additionally, time hours components are being mis-interpreted by PACS system (AM/PM???) so request change in time/hrs format to a 24hr clock format. 12/16/2008 - RDA - Version 3.1.10 patch 15 When user navigates to "Comm Log" button and creates a new communication log entry, selection of the "Select SOAP Notes" button produces a list of "ALL" SOAPs entered for that day for the whole hospital, not filtered by queried case. 12/16/08 lls: UPDATED 1/9/09 1) BLS0002 Not requiring supporting DVM 2) Census not displaying wards in numeric/alpha order 3) Viewing Invoices from Daily Register Screen (ACS0001): When you choose to view the register invoices before printing them, UVIS pulls them up on the screen but only for about 4 seconds.Â You must continually click the refresh button.Â If you scroll through the invoices and they close, refreshing the screen puts you back on page 1. -- added 1/9/09 lls -- 4) please modify the 'Self Referral' label on the order header screen, RDVM tab to 'Referral'. Please leave check box defaulted to not checked (i.e. 'N'). 12/16/08 lls: UPDATED 1/9/09 1) MRS0024 - new request tab - Requester information (under #2) on bottom does not change/update/refresh when you go from one patient to another. You must close case summary and re-open 2) Graph function on MRS0024 not working 3) Previously, after a user verifed a report and closed it, the Result Entry search screen would go back to the same place the user left it.Â Now it takes them back to the top of the list, so they have to scroll back down to the bottom each and every time.Â 4) Receiving Truncation error on MRS0024 discharge instruction when trying to insert predefined instructions (specifically from our Ophtho service) 5) Unable to view external results(clicking on external results on MRS0008) - the end user receives the following permissions error: Your USERNAME (NOVOX001) does not have privleges to execute this screen, please contact your system administratorUndefined message code: 1007NOVOX001Undeinfed message code:1008. (Note that the end user can run the LAB CUM REPORT) 6) Problem opening lab external docs receiving error message: EDIT Ext Doc Action errorâ€¦.. User-Defined Exception 7) The append comm log is not working. When the end user tries to append an entry it only posts the ADDENDED by Â line and nothing else - see case #313817. 8) Receive the following error when trying to open the communication worklist (MRS0014): Error retrieveing Referral letter text... ORA-01422: exact fetch returns more than requested 1/12/2009 - RDA - Version 3.1.10 patch 14 Users are not able to see consult requests done for their request area. Scenario follows: User navigates to case summary - req/results - New request and makes a consult request which also requires the user to change the request area as multiple areas use the same Batch of product numbers for their consult products. User then completes the requests and submits. User then goes either to the "request" tab or to the result entry. On the request tab, all the areas default back to LADEC instead of the correct area SAIMC. On the result entry form, unless the user selects the area LADEC, no entries appear for the area requested for. Please see Case # 1080353 (Benny) for specific examples. Using the same patient in Test and Production so any data entered on case # 1080353 will not cause any issues. 1/13/2009-wr-UMN is reporting periods of poor system performance after going live with 3.1.10/4.0. They have sent Oracle db performance reports via e-mail detailing some performance issues. 1/15/2009-wr-UMN would like the triggering of the death certificate on the comm worklist to be driven by the patient record not the episode since users can directly set the patient as deceased, bypassing the discharge status. 1/21/09 - Duke - 3.1.10 Patch 12 In some cases when we un-verify a discharge the original does not get copied into the Mod Table, therefore not recording its orginal state. And when you try to View Orig Data you recieve population error messages and the view screen is blank. RESOLUTION 8/5/2008-wr-Added a new paramter (Print Instructions) to the Req/Result report (MRR0014) to enable suppressing the printing of area/product instuctions. Note the default setting is "Yes" which mimics existing behavior and prints the instructions. ************************************************************** 3/30/04-wr-Modified the Request Area (MRV0009) screen by adding a Result Report field/column. This will allow assigning specialized resulting reports such as the Radiology Report (MRR0025) developed for Auburn. Note that the UVIS generic Request/Result Detail (MRR0014) report will be used if no other report is specified. This setting affects the "Print Results" button on the Result (MRS0009) screen and the Request/Result Detail (MRS0008) screen. - Modified the Results (MRS0009) screen by adding a "Print Results" button which looks at the Result Report setting mentioned above in MRV0009. Note that this button is only visible if a Result Report other than MRR0014 is specified, otherwise the existing Print Request/Result button should be used as it already prints MRR0014. The Area level security on MRS0009 was also modified to limit users to those areas for which their username or role hase priviliges assigned to via the Area Level Security (SEV0020) screen. This same screen also now allows assigning verification priviliges to a request area. The "MR_RESULTS" and "MR_RESULTS_VERIFICATION" categories allow defining these priviliges at the user or role level. - Modified the Radiology Report (MRR0025) to display only charges posted to the bill/order with actual client price; added result questions and findings; removed the flash card data, "Technical Factors" column and the signature lines at the bottom; added client name, case #, and request # on all pages; set page break after each request. - Modified the Request/Result (MRR0014) report by adding the flash card data to the bottom right, note this only displys for those Request Areas designated as "Imaging" areas via MRV0009; added the patient DOB to the demographic data; added a page break after each request to prevent requests running together on batch printing; added the Requestor name. - Modified the Specific Exam by Date (MRR0024) report to display the actual client price charge on the Bill/Order vice a calculated base price for the items listed. Note if the item has not yet posted to the bill the price displayed will be $0.00. Added the 2/2008-Corrected uvis_patient_au_pyxis trigger on the Order Hdr to handle trailing slashes on the Pyxis file path. 1/2007-Workshop training, updated uvis_sys_pkg and uvis_common_pkg to remove obsolete accounts (UVISCP and UVISDLAB) and obsolete roles (UVIS_CL% and UVIS_DL%). Replaced dbms_sql stmts with execute immediate and expanded error handling. Added drop before create pubsyn stmnts. 10/2006-Online Course - Introduction to LDAP and Oracle Internet Directory (D13568GC10 eStudy). OAS10g Identity Mgt/SSO Class. Disappearing menus fixed with Order By clause to Menu Startup code (uvis_default_menu/uvis_ul_menu). 10G Discussions at UUG Conference at UGA. Reports 10g training. 9/2006-Forms/Reports tool research, demo, discussions, Reports 10g discussions. Oracle Reports 10g Class. Discuss strategy for updating/purging a 10g network folder and possible use of third-party tools. Register for OAS Identity Mgt, Admin I, and Portal classes. 8/2006-10g SOW, Training Plan+revisions, register for Reports class. Review Draft 10g SOW. 5/2006-Migration conf call with Oracle(5/3). Research on migration effort. 5/2005-Online Documentation Planning 4/2005-Planning 03/2005-Research App Server functionality, training for team, etc. 01/2005-Sun Server upgraded to Solaris 9 with patches, Oracle 10g sw was loaded, DBA imported 3.1 Hospital Development database into HODEV. Successfully tested current 3.1.6 Forms against 10g database. 12/2004-Translation Hub research,Coordinate Unix consultant, download and install Solaris 9, and patches for Oracle 10g install, planning, move all charges to new customer/project, discuss schedule impact by Go Lives of Cornell, Montreal, KSU Labs 11/2004-Migration Research, Oracle 9i Forms New Features Class 10/2004-10g Presentation and discussions @ UVIS UUG Conference. 10g Application Server and environment setup and configuration. Oracle Application 10/20/2008-wr-Modified the estimate_statistics procedure in the uvis_ac_pkg so that it looks at the designated Primary Diagnosis entered on the Case Summary (MRS0024) vice the old legacy diagnosis that was entered on the Order Hdr screen. NOTE this will be seen when the EOM process runs next so expect to see the impact of this in history based cost estimate data on the Primary Diagnosis (BLV0008) screen at that time. 10/16/2008-wr-Modified the Checked Out Medical Records (MRR0017), Medical Records Out Summary (MRR0018) and Medical Records Out By Staff (MRR0019) reports to include data entered into the Staff2 field on the Medical Records Tracking (MRS0017) screen. 4/24/2006 jwk - Med Record Tracking screen (mrs0017) - made the new student fields generic staff fields and removed new resolution fields from med_record and log -- this in lieu of new Deficiencies/Resolutions screen (mrs0028). 4/4/2006 jwk - Added Student_ID and Resolution to Med Record Tracking screen (MRS0017). Created screen (MRV0019) for setting up Med Record Resolutions -- Appears on menu: SETUP, MEDICAL RECORDS, MED RECORD RESOLUTIONS. 6/25/2008-wr- Modified the Prescription Fill (PHS0006) to check when drafting label that Prescribing DVM matches the DEA number currently stored on the record. This should correct those instances where the DVM was changed prior to approval. 5/20/2008 wk - Modified the Client (PDS0001) screen to allow contacts to be directly associated with clients versus only associated with patients. Added a new tab page on the client screen for these contacts. 9/12/2008-wr-Added Owner and RDVM Cell Phone number fields on the Admission Report (PDR0007). Added the Client Cell Phone number on the MU version of the Patient Label (PDR0012); it is prefixed with a "C" on the last row of the label. 10/21/2008-wr-Added validation logic on the "Code" answer fields in the Request Profile (MRS0007) screen to insure that the user selects from the defined list of possible answers. 6/25/2008-wr-Modified the Prescription Fill (PHS0006) so that it no longer alters the Rx qty it simply provides the user a warning that the Rx qty and the inventory qty selected do not match. 10/29/2008 - fixed under t# 15615. 2/15/2008-wr-Corrected error in Patient (PDS0002) screen when user hits exit window prior to saving patient alert records. Form will now set alert flags if necessary on window exit as well. Note that MRS0002 has been retired so no action was taken on the like error in that screen. 6/4/2008-wr-Added aditional sub-elements under the Episode section of the Discharge Templates for Chief of Service and Admitting DVM. These items are now available for selection on the Disch Instructions report (MRR0030). Note that the installation script will insert these new elements into all existing templates with default values but these new elements will NOT be automatically selected for inclusion on the disch inst; each site should review these new elements and set as desired in the Discharge Templates (MRV0020) screen. 2/6/2008-wr-Corrected code in the Cashier (BLS0005) that was not consistently defaulting the "Bill Third Party" checkbox when the client was set up for third party billing. 10/22/2008-wr-This error was caused by a Req DVM record in your data missing either a service or section assignment. The Result Entry (MRS0009) screen has been modified to suppress this error; there will simply be no service and or section info displayed in the "Req DVM/Serv/Sect" field on these records. 3/20/2008-wr-Modified the record validation logic on the Inventory (IMS0009) screen. User entered data for lot, expiration, etc... was being overwritten with default values for the location/product on record validation. Changed initial values of fields to defaults and added checks for user entered data prior to populating default sales and stock units. Note this issue is a duplicate of TT # 12076. On second entry of 3/7/2008 set the initial value of the stock to sales qty field to null so that it would be populated from product level settings; also modified the validation logic on this field so that when it is changed the Stock Qty field is re-caculated based upon the sales qty on hand. 6/25/2008-wr-Modifed the logic in the code that replenishes inventory so that inserted records pull the sales/stock qty ratio from the current primary vendor vice default it to one. 2/15/2008-wr-Corrected error in Patient (PDS0002) screen Case # assignment that was not allowing 7 digit numbers. 3/27/2008-Updated documentation for System Options as the settings there will generate batch job to clear out approvals for CDM rxs. 10/24/07-wr-Added a new procedure (cdm_auto_approve) to the CDM package to auto approve CDM prescription request records after 3 days if they have not already been approved. Added new system option called CDM_DEFAULT_AUTO_APPROVE_DVM under the PHARMACY category. This new option allows each site to designate the emp_id number of the default DVM that will be recorded as the prescribing/approving DVM on these auto approved CDM records. NOTE that a valid/active UVIS employee record must be entered into this option setting for this feature to function correctly. Additionally, the emp_id entered should be designated as a DVM and have DEA data entered on their employee record. This new option will install with a default setting of null which will disable this functionality. This new feature is dependant upon the existing system option (CDM_PRESCRIPTION_REC) to create a prescription request record; if that option is not enabled (set to Y) then this new auto approve capability and new CDM_DEFAULT_AUTO_APPROVE_DVM option is irrelevant. This new auto approve feature is triggered by a database job that installs with a default setting to run each night at 1:00 AM so that all CDM prescription request records that have been pending approval for at least three days will be approved as a batch at that time. Sites that wish to alter that scheduled time or frequency of approval should alter the included script (11825_db_job.sql) accordingly. 2/18/2008-wr- The mouse over hint text was corrected on the Patient/Client alert buttons on the Order Header (BLS0001) and Patient (PDS0002) screens. 05/08/2008- reports modified to return proper Med Rec Case#. 03/04/2008- reports modified to return correct request_id. 2/18/2008-wr-This issue did not mainifest itself on initial screen entry but only after query of record for which the patient data was not editable. Modified the Order Header (BLS0001) screen to update the visual attributes of the patient fields for each new record instance regardless of prior settings. 2/21/2008-wr-This issue was caused by the firing of unnecessary validation triggers on queried data. The firing of this excess validation has been corrected on the Census (BLS0006) screen. Note that one of the validation issues was related to the service/section association of the Att DVM. When chaning the Att DVM (either name or ID # field) the service/section will be refreshed on exit of the field i.e. when you tab out or mouse out of the field you have just changed the service/section will update to reflect the new Att DVM selection. Additionally, the LOV canvases have been re-position and re-sized to prevent having to move the pop-up window to access buttons at the bottom. An auto-commit was also added to the Post buttons so that the user does not have to first save data before hitting the Post buttons. 6/25/2008-wr-Modified the line wrap logic on the AU version (5) of the Rx label to prevent truncating instructions in the case of a dash ("-") in the string. 6/16/2008-wr-UVIS attempts to handle instances in which an owner has multiple pre- admit records and/or multiple animals scheduled via pre-admits before their client record is created. In those cases the system uses the home phone number to attempt to match up those records. This code did not anticipate users changing the phone number prior to committing the client record initially; this code has been modified to handle this situation. NOTE that it is recommended that you first commit the record with the old phone number then update the phone number and re-save the record; otherwise the system has no way of linking multiple pre-admit records or appt records to a single newly created client. See AU TT # 8860 for a greater explanation of this scenario. 2/19/2008-wr-Unable to duplicate the issue with the Client LOV on the make appointment canvas on FDS0005, however, I suspect it was caused by validation logic on the associated list of values (LOV) windows. This LOV validation logic was cleaned up to prevent re-validation of data selected from the list. Additionally the cut/copy/paste functionality was modified to prevent leaving data from prior operations. 2/26/2008-wr-Modified the record validation logic on the Inventory (IMS0009) screen. User entered data for lot, expiration, etc... was being overwritten with default values for the location/product on record validation. Changed initial values of fields to defaults and added checks for user entered data prior to populating default sales and stock units. Note this issue is a duplicate of TT # 11734. 2/26/08-wr-Modified the Inventory (IMS0009) screen to prevent un-wanted validations firing on queried data. This was causing the data to be marked as updated within the form and prompting the user to save changes when none were made. 10/23/2008-wr-Can not reproduce this problem locally but shifted print region to the left and brought in the right margin to try and prevent truncation on the right side of the Admit/Transfer (MRR0031) report. 10/22/2008-wr-Modified the Disch Inst (MRR0030) report to correctly capitalize a 'III' name suffix. The added code looks specifically at the 'Iii' string, so names that use 'II' vice 'JR' or 'Jr' will not be corrected, they will still appear as 'Ii'. It is possible to correct the 'Ii' suffix as well but the correction cannot distinguish a name suffix from a name that starts with two i's; though not very common it may outweigh the benefit of correcting the 'Ii' suffix as most of these are probably 'Jr'. 8/9/2008-wr-Could not duplicate this error in testing. However, noticed that the primary key properties were not correctly set for the ext docs data blocks within the form and suspect this may have led to this error. The primary key properties were corrected in the Case Summary (MRS0024) and Patient (PDS0002) screens. Please re-test this issue. NOTE that File Names must be unique for each document associated with a patient i.e. you cannot have a patient level ext doc with the same name as an epsiode level ext doc or any other ext doc assoicated with that same patient. 3/17/2008-wr-Modified the Delete Inst button on the Instructions (MRV0003) screen to perform check for existing disch instructions that use the selected instruction prio to delete attempt. User will be promted in these cases. Instructions that have already been used on a discharge instruction can NOT be delected; they can have all Instruction Type associations de-activated which should prevent future use but the record must remain. 6/25/2008-wr-Modified the replenish_inventory procedure so that it does not append comments onto the inventory record; this was unnecessary since the LUR (Last Update Reason) field contained this same info and is being logged. 3/7/2008-wr-Corrected error in scroll bar on the Ext History tab of the Case Summary (MRS0024) screen. 3/14/2008-wr-Modified the Case Search (MRS0001) screen; populating the Case # in the search block no longer pulls in the active client data automatically. This will allow entering just the Case # and easily returning all episodes for the patient regardless of client/owner at the time of the episode. 3/12/08-wr- The user controls when the problems are sent to the MPL by when they check the "Send to MPL" checkbox so if this is being done prematurely it is because the user is doing it prematurely. The button (Add MPL Items) is to seed the Initial Plan problems with those currently on the MPL and the "Send to MPL" checkbox does just the opposite: it sends the selected Init Plan problem to the MPL. I concur that for a given visit you should not need both the checkbox and the button. The current design is assuming that there are instances when you want to use a problem(s) that is already on the MPL to develop your Init Plan and there are other instances where a new problem that you inserted on your Init Plan should be migrated to the MPL. The button label "Add MPL Items" was changed to "Populate From MPL" in an attempt to make the intended functionality more clear. 3/12/2008-wr-Corrected error on the request Submit button in the Case Summary (MRS0024) screen, New Request tab. 9/30/2008-wr-I could not duplicat this error locally in testing and the attached error message output is truncated without showing the error condition but it appears to be caused by a mis-handled text string in the query. The handling of query text strings was modified on the Med Record Queries (MRS0013) screen to address this suspected cause. 9/30/2008-wr-This issue was due to the mis-handling of species names with a blank space in the name. Modified the Medical Records Queries (MRS0013) screen to correct this error. Also noted during testing a truncation error on the date field in the associated report (MRR0027); this truncation/format error was corrected as well. 3/7/2008-wr-Corrected the call to the Estimate (BLS0010) screen from the Case Summary (MRS0024) to auto-query the correct patient's estimates. Modified the functionality of the "Link to Bill/Order" button to allow linking bill/orders currently linked to other estimates to the one selected i.e. if the current open bill/order is already linked to an estimate and the user presses this button on a different estimate the user will be prompted and the system will sever the old estimate link to the order and link the current/selected estimate to the order. Corrected error in the "Current Estimate Clear All" button and updated the Estimate History functionality to the new estimate structure (patient level). 3/12/2008-wr-Corrected spelling error in boilerplate text in the Case Summary (MRS0024) Verify/Review tab. 1/12/2009-wr-There is no need for the user to approve the items on the bill when there are no items entered. It should be obvious to the user that nothing is entered on BLS0002. The Cashier (BLS0005) screen already sets the bill/order status to "FN" in these cases so that the order can be closed. That said, we did modify the Order Dtl (BLS0002) screen to provide users a warning that there is nothing to approve when they attempt this. NOTE that the default status for an item is still "UF" and this is what will display on blank records. Defaulting the status to "FN" or null would require programatically changing that default when the user inserts a record, this invites an unnecessary potential for error. 2/28/2008-wr-Modified the LOV's for RDVM and Clinic on the Order Header (BLS0001) screen to filter in-active records. Also updated the validation logic on all LOV fields consistent with the rest of the application. Chnaged the Client ID # LOV to filter on an already entered Patient ID # to allow picking from a restricted list if desired. Note that the Client Last Name and First Name LOV's were left un-filtered by Patient #. 3/17/2008-wr-Modified the "Rx" button on the Order Items (BLS0002) screen to pass additional parameters to PHS0017 to insure we bring back the correct Rx record. 3/12/2008-wr-Tested locally and could not dupliate any error; note that these fields required a mouse double click to trigger screen link functionality; as result of this ticket this behavior has been modified to provide link on mouse single click. 8/12/2008-wr-Modified numerous fields on the Case Summary (MRS0024) screen so that they do not auto hi-lite the entire contents, to include the Disch Instructions and SOAP's. 3/12/2008-wr-Modified the Case Summary (MRS0024) screen Physical tab to accept NE (Not Evaluated) in answer to a required question as long as a free text comment is entered. This should allow users to note when it was not possible to examine a required entry yet not have the default answer of NE alone satisfy a required questions. 9/11/2008-wr-Re-worked the identical questions logic in the Case Summary (MRS0024) screen to correct errors. Note that when a parent question has been set up as an identical question the related questions should be set up as identical questions as well. Note also that the sort order defined in the setup becomes a secondary sort criteria with identical questions so sort order may not appear as expected. In general area level questions will precede item level questions and they will then be in question_id order and then sort order. The actual verbiage used for identical question is that of the lowest matching question_id. As noted in the ticket description there are limitations on the implementation of identical questions with the current question/answer structure in UVIS. This structure is shared with the labs system and overhauling it to accommodate a more robust implementation of identical question is beyond the scope of the initial identical questions enhancement (TT 8602) and this ticket. The current implementation should be bug free i.e. it should work, but setup and performance will not be ideal. 3/4/2008- removed tracing message. 3/3/2008-wr-Corrected errors in the interface triggers that were ignoring re- submitted requests from the Hospital. Note the associated triggers need to be installed in the appropriate instance (HO/UL). 3/14/2008-wr-Modified the Case Summary (MRS0024) screen to use the old legacy verfication criteria when calling the legacy Discharge Instructions (MRR0004) report. This should omit/print the "Draft Copy" watermark consistent with past behavior. Added a means to view the legacy Additional Instructions and Problem Instructions via buttons that call these canvases on the "Legacy Inst" canvas. 4/30/2008-wr-Added code in MRS0024 to update the Requesting DVM if Attending DVM data changed on the VMTH Personnel tab. Unable to duplicate any errors where information entered on MRS0024 was not being carried over to BLS0001. NOTE that if you are attempting to do this (update common data) with both screens open simultaneously they will NOT automatically refresh the data on the other screen. With both screens open simultaneously you must refresh/re-query the data to see changes made by the other screen on the same record. 3/12/-0-wr-Script to insert the new Disch Inst Report (MRR0030) into the module master table was missing from 3.1.10 release; released this insert script (16075_module_m.sql). 5/23/2008-wr-The issue with select entries not printing on MRR0003 was related to the issue corrected in TT # 18797, in which the patient_id was getting incorrectly recorded in the client_id field when creating new comm log entries. The sample record cited at Auburn was in this condition. The 16077_comm_log_corr.sql script will correct those existing records that have this problem; the underlying cause was addressed in TT 18797. 3/13/2008-wr-Modified the Communication (MRR0008) report to only use the Case # (patient_id) in filtering records; it was using the client_id as well which was ommitting some communications which occured with past owners on transfers. 3/13/2008-wr-Items addresed as follows: 1- Modified the Case Search (MRS0001) screen to pull back the order open data of the initial (suffix 1) order and display as the admit date of the episode. Note all other order hdr data (att dvm, serv/sect, student, etc...) displayed on this screen was changed to pull from the initial bill/order as well. 2- Modified the layout of the Admission Form (PDR0007) in use at MU to try and prevent printing to a second page. 3- The UVIS pl/sql library was modified as a result of TT # 8722; I think this mod will address the screen re-sizing issue raised by MU. 4- Modified the Census (BLS0006) screen to return the cursor to it's staring point after saving a record. 5- Added the Dischare Date to the revised Transcritpion/Communication Worklist (MRR0028) report. 6- The 3.1.10 script titled 7492_x_case_trnsfer_obj_mods.sql altered the transfer comments from a varchar2(4000) field to a long. This required the use of a temp holder column and moving the data to/from the holder into the tfr_comment column. I have re-tested this script locally without error; were any errors recorded on this script from the 3.1.10 installation. 7- Unable to dupe this locally, per e-mail from Teresa MU has resolved this issue on site. 8/9/10- Lab issues resolved under separate ticket(s) 11- Added the Staff # and Staff2 # columns to the Log of Past Activity in the Med Records Checkout (MRS0017) screen. 12- Corrected error in the Cashier (BLS0005) screen that was to correctly pull theto 6/25/2008-wr-Modified the Prescription Fill (PHS0006) screen not allowing users refill number when prior issue of the refill is voided. 5/21/2008-wr- Modified the Estimate (BLS0010) screen to make the patient record the primary driver of the screen vice the estimate header. Changed the layout and query behavior to mimic the Case Summary (MRS0024). This should provide DVMS's with more consistent/familiar functionality. 3/31/2008-wr-Corrected error in the Case Summary (MRS0024) that was not allowing user to un-verify Initial Plan data. 6/25/2008-wr-Corrected the date format mask in the UMN Rx Label which was causing the intermittent "1" to appear in the label. 5/8/2008-wr-Regarding the issue with date formats; in general we have been working our way through the system updating the format on these to include the time component. The DATE datatype in Oracle always includes time so if one is not provided the db will default it to midnight. That is what you often see UVIS and what you saw in this case with the Updated On value. The Initial Plan LUD field and MPL Approved Date field have been modified to record the time component on update. The Init Plan Added to MPL column and the MPL Date Active and Date Resolved columns all consistently exclude the time component now to avoid confusion. -Once a record is verified you can no longer edit the Approval Comment; you must do this prior to approval. -Corrected the conversion/display of temp in Celsius on the SOAP entry canvas TPR data. -Discarge Date/Time field now excluded the seconds component and will pull time component in from the calendar. -This issue described with regard to the "Select Dx from MPL/Init Plan" button is partly a misunderstanding of this feature. UVIS allows you to pre-define a Diagnosis (Dx) association with a Problem via the Problem (MRV0002) screen. When you have made these associations MRS0024 basically presents them to you based on the Problems selected on the Init Plan and MPL via that button. Looking at your 5/13/2008-wr-Corrected a field size mis-match (30 characters) in MRS0024 that I think was not handling the long file name used in your example. 3/28/2008-wr- Modified the Case Summary (MRS0024) screen to call the system defined editor on the fields listed in the Desciption as well as on the Client Discharge Instructions and RDVM Discharge Instrutions fields. 3/28/2008-wr-Could not duplicate this issue locally; modified the Case Summary (MRS0024) screen to avoid retrieving the CLOB fields in the verification process as I suspect this is causing the error. 3/28/2008-wr-Modified the db trigger on the request table with an increased (4050) max line buffer size to prevent error on the 4000 character Reason for Study parameter/column being read in and written out. 4/3/2008-wr-Modified the Order Hdr (BLS0001) screen to correct validation logic on various name/ID # fields to included the Client # field. This should prevent redundant validations firing on user entries. 4/30/2008-wr-Modified the calendar LOV to default the populated time componenet of the Discharge Datetime to current time. 8/4/2008-wr-Modified the Case Summary (MRS0024) screen, changed the field size on the Disch Status field to match the database limit of 30 characters. This should eliminate the truncation error. 4/30/2008-wr- Corrected error on MRS0024 Discharge>Selections>Procedures canvas that was not listing the procedure name when "+Rpt" selected and a Resulted Procedure that was not in a status that allowed viewing. The procedure name should print if selected for inclusion regardless of status; the results should only be included if the status allows for viewing based on the settings for that request area. The Resulted Procedues will NOT list requests in a "Rejected" or "Cancelled" status; all other statuses will be listed and if the user selects them for inclusion the procedure name, at the least, will be listed. Note that this feature only includes the data entered in the Result "Findings" field on MRS0008 in the hospital system; it does NOT pull results in from the lab instance. There is a separate "Labs" selection canvas that facilitates attaching lab result reports. It is recommended that you not define lab tests as procedures for the Discharge Summary via MRV0006/IMS0004 so that they are not listed here. 4/30/2008-wr-Modified the Case Search (MRS0024) to prevent users from performing a wide open query with no filter cirteria. 4/30/2008-wr-Corrected the data block priviliges allowing record insert/delete on the releated questions/answers canvas on MRS0024. 4/30/2008-wr-Modified the Patient (PDS0001) screen to handle query on apostrophe (') in the client name (Last, First, Business/Farm) fields. Modified the search fields at the top of the screen by consolidating what was three fields into a single "Client/Contanct Name" search field. This field searches on Client Last Name, Client Business/Farm Name, Contact Last Name, and Co-Owner Last Name. New search fields were added for Case # and Patient Name; note the latter searches the Name and Nickname fields for the Patient. The Client (PDS0001) screen was modified by consolidating two Name search fields (Business/Farm and Last Name) into a single "Name" field that searches both the Last and Business/Farm fields in the record. This field will handle search on apostrophe. Additionally a Phone # search field was added to search all the Primary phone number fields: Home, Work, Cellular, Pager, Other and Fax #. In both PDS001 and PDS0002 the search buttons at the top were modified to include a "Find Match" button and a "Find Containing" button. The "Find Match" button looks for an exact match of any text entered into any of the text fields; so if "SMITH" is entered in the Name search it will only return those records with an 10/22/2008-wr-Corrected error in the Diagnosis Coding Elements (MRV0017) screen that was not populating the diagnosis_id from the db sequence when a user attempted to insert a new diagnosis. 11/5/2008-wr-Modified the Case Summary (MRS0024) so that users can no longer double click on text fields in verfied records and launch a third party text editor. Note that users can still navigate via the menu (Edit>Edit)and launch a third party editor on these fields. This compromise will still allow users to access a complete view of the text via a third party editor on verfied records but requires a much more conscious effort on the part of the user which will hopefuly serve as an indicator that the record is verfied and edits will not be saved. 4/30/2008-wr-Added checks in the MRS0024 SOAP details tab that will not allow you to post TPR data from that location once the SOAP is verified. Corrected handling of the Ready ("R") status flag when using either of the Complete buttons on a verified SOAP. 5/8/2008-wr-Unable to duplcate this issue locally; modified MRS0024 to address what I suspect may be the cause. Please re-test this issue. 5/13/2008-wr-Modifed the Case Summary (MRS0024) to correctly set disch status flags when user verfies inst from the Verify tab. Updated trigger to handle resubmission of rejected requests (from Labs to HO). 4/29/2008-Troublehsooting/coding 4.0 issues, - OAS Report Server configs for go-live. Unable to print reports using UVIS4. Param form displays, but generic "page not found" returns in browser. Noticed URL address changes server names after report failure. Looking into Apache\Apache\httpd.conf file setups. Appears the host servername was manually changed during Application Server installation. Modified settings in the oas_home\Apache\Apache\conf\httpd.conf file and reports can now be run from UVIS. Updated User Option settings in SEV21-User Option Defaults and SES5 - User Options screens for "OAS_REPORT_SERVER". Also uvis_report_lib.plx causing issues. Replaced with uvis_report_lib.pll. - Corrected error on Case Summary (MRS0024) in rgeard to navigation to a disabled item. - Estimates***** - Corrected layout of the Deceased checkbox on the Patient Info tab of the Client (PDS0001) screen. - Corrected error in MRS0007 and MRS0024 in their calls to the lab results reports. - Modified the reports library (rp2rro) to retrieve the client machine/user default printer from the registry when running a report directly from the menu. - Modified the Prescription Approval (PHS0005) screen to utilize iconic buttons for record scrolling navigation vice character/font based buttons that were not displaying correctly in the 4.0 environment. -Screens that utilize command line/Zebra type printing were modified to create, store and send the necessary files from the app server vice the client machines. This requires that the UVIS_TEMP_DIRECTORY defined in the system options be a directory available to the app server. Addtionally, the Ext Value 1 commands in the Ext Device (BLV0014) screen under the PRINTER>COMMAND_LINE are data 5/21/2008-wr-Modified the Case Summary (MRS0024) to update the Estimate in the upper right of the screen upon returning from the Estimate (BLS0010) screen. NOTE the format was changed to round to the nearest whole dollar amount to match what is shown on the Estimate tab. 6/25/2008-wr-Modified the Prescription Fill (PHS0006) to remove all prior fills from the bill for the same Rx when it is cancelled. NOTE this is only applicable if the bill/order is still open and the prior fills are on the same bill. 5/21/2008-wr-Modified the Estimate (BLS0010) screen to base on patient so that it will always pull back a patient record even if an estimate does not exist. This will get rid of the "No records found" message on screen entry. Changed the "Estimate Title" field prompt to be underlined to annotate that it is a required field. 5/15/2008-wr-Modifed the set_client_id program unit in the Client (PDS0001) to handle duplicate Pre-Admit records with the same phone number. The system will assume that any Pre-Admit and related Appt records with the same client phone number that is being entered belong to the newly created client ONLY if there is not client # already assigned to these records. Addtionally the user error message from this program unit was changed to a warning vice a fatal error so processing should continue after the message. NOTE there is no perfect solution to this situation; when you create multiple records with a common phone number (like a shared dorm or apartment) the system will attempt to fill in client #'s in these cases but these situation will sometimes require human oversight/intervention to correct. 6/24/2008-wr-The Pharmacy Profile (PHS0015) screen was initially intended for pharmacy users and contains functionality that is dependant on pharmacy assignment. The screen has been modified to suppress the message you are referencing and additional code added to insure a default pharmacy is populated. 8/13/2008-wr-Modified the Case Summary (MRS0024) to include the related questions when History/Physical questions are selected for and included on the Disch Instructions. Corrected navigation error to invalid item on the Related Questions canvas. Note the error noted on 7/16/2008 concerning Physical questions not showing on Case # 1050718 was due to the Discharge Template for that case not having set any Sub-Sub Element to "Include" under the INSTRUCTIONS_BODY>PHYSICAL_SECTION. Even when selected via MRS0024 if the item is not allowed to be included via the disch template setting it will not be included when instructions are drafted. 8/19/2008-wr-Modified the Visit/SOAP tab on the Case Summary (MRS0024) to refresh the status flags on the SOAP date based on verification action at the SOAP/Problem level. This include updating past dates when user cycles through multiple dates from the edit window. Also added setting of date vefification status on intitial population on the SOAP. 5/8/2008-wr-It is un-clear from the problem description but I am assuming that this only occurs on specific records and was not introduced by patch 6 but was an issue with all prior releases for those select records. That said, the Case Summary (MRS0024) has been modified to correct a mis-match in field size limits between items on the Visit/Meds tab and duplicate items on the record Details canvas; this error would show up on records with med names longer than 30 characters. 5/8/2008-wr-Modified the tooltip hints on the Disch Inst tab buttons to correctly reflect the action of each button. 5/8/2008-wr-Modified the Case Summary (MRS0024); set the "Cancel" and "Okay" buttons on the pop-up verification login canvas to allow keyboard navigation. 5/8/2008-wr-Corrected error in the Case Summary (MRS0024) so that the copy/paste button on TPR data functions and the Med instructions are pulled in with the Med name. I could not duplicate the error described in regard to copy/paste diagnosis or other selections prior to drafting the disch inst. I did add code to prevent what I suspect may be causing the problem so please test this issue again. 5/7/2008-wr-The uvis PL/SQL library was corrected to restore user notification functionality. - The Case Summary (MRS0024) screen was modified to correctly record communication log records. - Modified the Case Search (MRS0001) Discharge Status field to match db column type/size. - Modified the Patient Transfer (PDS0004) so that is does not allow the user to enter an inactive Case # to transfer. - Corrected error on SOAP tab; SOAP comment field size was being exceeded by certain records; expanded the field size and added error handling to alert uer of the condition. 5/19/2008-wr-The 18877_correct_dep_tfr script will correct deposit transactions that were orphaned in a patient transfer. These deposit records are moved to the new/correct client and the old and new client balances re-calculated. The script outputs to the screen a list of records that were altered. A snapshot of the invoice table is saved off prior to running. **IMPORTANT NOTE** The invoice snapshot is saved as the UVIS_INVOICE_BAK table, if you have this table from running prior scripts and wish to retain this earlier snapshot you must re-name the existing table to another name, otherwise it will be dropped and re-created thus the prior snapshot will be lost. 5/14/2008-wr-Corrected error in the Cashier (BLS0005) screen regarding calculation of Balance Due on CANCEL ORDER transactions. NOTE for any clients who experienced this error their balance will be corrected via the included script (18877_correct_cnx_ord.sql) and a list of the corrections made shown on the SQL*Plus screen after running. This error manifests itself after installation of 3.1.10 and only for CANCEL ORDER transactions. 5/7/2008-wr-Modified the accounting package and balance update script to handle see OAS_Config_File_Setups_ReadMe.txt that was released with patch. 1/12/2009-wr-Modified the db trigger that auto posts request charges to the bill so that it includes the Emp # of the user inserting/updating the request. 8/26/2008-wr-Corrected handling of service/section transfer on bill/orders where no episode of care exists. This was the situation that casued this error to occur; the sample record was an Rx refill with no associated episode of care. 5/15/2008-wr-Corrected spelling error in generation of Comm Log entry for Client Disch Instructions on MRS0024. 5/15/2008-wr-Modified the Client (PDS0001) screen as follows: changed pop-up window title to "Duplicate Address Alert", changed button labels to "Continue" and "Use Existing Selected Client Above" and added a boileplate "OR" between the two button choices. 5/13/2008-wr-Modified the accounting package and balance update script to handle "ADJUST ERROR" transactions correctly. This issue and the one with non-changed balances in the diff table was related to the order of scripts being run. The 8865_init_uvis_invoices script was assuming it is run prior to the 16095_adj_err_trans_amt script; since the latter was released in prior patches this assumption was invalid. 8865_init_uvis_invoice has been modified to account for this error. ***IMPORTANT NOTE*** Each time you run the 8865_init_uvis_invoices.sql script it creates a UVIS_INVOICE_BAK and UVIS_INVOICE_BALANCE_DIF table. These tables save off a snapshot of your invoice table and record any client balances that changed as a result of running the script. Each succesive time the script is run the data in these tables is overwritten, so if you want to retain snapshots of this old data you should rename the existing UVIS_INVOICE_BAK and UVIS_INVOICE_BALANCE_DIF tables prior to running the script. 5/20/2008-wr-Corrected handling of Deposit transactions in Accounts Receivable Credit/Debit Memo Report (ACR0007) and removed restrictions on REFUND and CANCEL ORDER transactions. 10/3/2008-wr-Corrected error in the Deficient Medical Records (MRR0005) report that was not recognizing the user selected parameter to page break on the selected sort (Att DVM or Student). 5/21/2008-wr-Added code in the Case Summary (MRS0024) to auto-refresh the data on the Visit>Charges tab after returning from the Travel Sheet (IMS0015) screen. 8/19/2008-wr-Modified the Case Summary (MRS0024) to pull in clinic data for display when no RDVM data is populated. The clinic data will display in the upper right in lieu of missing RDVM data as well as on the Personnel>Pri/Sec RDVM tabs. Changed the label on the Re-Assign button to "Re-Assign RDVM/Clinic" to denote the fact that either or both elements can be changed via the button. Added a details (eyeglasses/goggles) button next to the Clinic name to link the user to PDS0001 for addtional information on the selected clinic. 5/23/2008-wr-Modified the Case Summary (MRS0024) to show the product Short Description on the Request>Pharmacy tab. 5/27/2008-wr-Modified the Case Summary (MRS0024) to disable various action buttons for View Only users, to include the Request Submit button. Corrected block properties to also consider View Only status when setting block edit privs. 5/23/2008-wr-Modified the edit priviliges on the SOAP tab to take the cutoff time into account. NOTE the cutoff time only applies to users who are set up to have "Verification Reqrd" on SOAP's via the Episode/Verification Parameters (MRV0008) screen. 8/26/2008-wr-Corrected the validation logic in BLS001 on the Client data when user populates the fields via an LOV to check the account freeze setting. 6/16/2008-wr-Modified the Census (BLS0006) screen so that the Student field LOV's do NOT also pull back INTERN and RESIDENT empolyee types. I believe this is a holdover from the days before the Order Hdr (BLS0001) included a seperate Intern and Resident field. 6/16/2008-wr-Changed the Phone # search field to a character field and programtically converted to number on the Client (PDS0001) screen so that leading zeros are not ignored. 8/18/2008-wr-The Case Summary (MRS0024) screen does NOT prevent the user from Populating/Re-Populating History/Physical questions after they have been verified as long as the Episode is still Open and a single Epsiode is selected. The verified questions will remain and any new questions for the new service/section will be added. Not sure what issue your users are experiencing but they do NOT need to un-verify questions on service transfer. I suspect the issue may be in how the transfer is being performed and the update of attending service/section data across the various tabs; to that end this functionality was modified to insure att service/section data is in sych on the various MRS0024 tabs. 8/1/2008-wr-Added sort by Invoice # on the Invoice (BLR0009) report. 8/14/2008-wr-Modifed the Case Summary (MRS0024) screen to prevent user edit of Physical findings once verfied. This issue manifested itself when users used the mouse to click directly on the findings radio buttons of a different verfied record i.e. when navigating between records. Also added checks of episode status to allow insert on Initial Plan, MPL and TPR+ records. 06/05/2008 wp - *************************IMPORTANT******************** Need to create a total of 4 new public database links. 2 for the hospital instance and 2 for the labs instance. They must be named as follows: In the Hospital instance ------------------------ uvis_ho_link - This link needs to point back to the same instance it was created in i.e. the hospital instance. Be sure to use the user UVIS/[YOUR_PASWORD] and make it public. uvis_ul_link - This link needs to point to the labs instance. Be sure to use the user UVISLABS/[YOUR_PASSWORD] and make it public. In the Labs instance ------------------------ uvis_ho_link - This link needs to point to the hospital instance. Be sure to use the user UVIS/[YOUR_PASSWORD] and make it public. uvis_ul_link - This link needs to point back to the same instance it was created in i.e. the labs instance. Be sure to use the user UVISLABS/[YOUR_PASSWORD] and make it public. 8/14/2008-wr-Modified the Case Summary (MRS0024) screen, corrected block insert priviliges on the Comments block and suppressed the "no records found" error message on comments canvas entry. Note this same mod applies to comments on the History, Physical and Ext History tabs. 11/10/2008-wr-Unable to duplicate problem with Sheet Title drop list. This functionality has not changed and is built-in to the drop list interface item. Note that if you have multiple sheet titles that start with the same letter you will navigate to the first title and through succesive ones each time you hit the letter key. Have you added new sheet titles with same first letter? This may explain the change in behavior you are seeing. There is some required processing of Request questions/answers casued by the combined questions functionality that cannot be accomplished on window close (the X button) so users must use the Save/Submit or Cancel button to exit this window. The X button now provides a user prompt to do so. The "Submit" button was re- labeled "Save/Submit" to clue users that it can be used to save unfinished work and logic was changed to allow exit with un-answered required questions. Users will still be prompted that there are un-answered required questions and they can choose to continue and exit the canvas or not. 9/18/2008-wr-Corrected error found in testing of SEV0024; expanded columns in the underlying tables via 20302_col_mods.sql script and modified field sizes in SEV0024 to match. 8/1/2008-wr-Instead of detailing field level mods to forms on release the Item Prompt Display (SEV0024) screen has been modified to facilitate handling changes in already released forms. The screen layout has been modified to be strictly Module driven. Query filters were added to show only un-translated records if desired. The Insert functionality contains additional Refresh features for existing screens. A Tag field will display the status of records on Insert/Refresh; records will be tagged as Added (A), Deleted (D), Modified (M) or Unchanged (U). The Added (A) tag means a new field has been added to the screen since the translation data was last Inserted/Refreshed and this field will need translation. A Deleted (D) tag means a field was removed from the screen yet a record for that field still exists in the translation table and the user can/should delete that record. NOTE these deleted fields will cause error messages when launching the subject screen with the translation feature turned on. A Modified (M) tag means that the source English 6/13/2008-wr-Modified the Communications Worklist (MRS0014) to prevent data type mismatch error and create comm log entry with text entered in comments field. Corrected error with multiple comm list entries for same item (like RDVM disch inst) not handling pre-verified/completed statuses correctly. 11/7/2008-wr-Corrected error when drafting instructions with multple templates assigned to a single service/section. NOTE in these cases the lower Template # will be the default template used by the system. The Template # is visible in the Discharge Template (MRV0020) screen. You must be cognizant of this when defining templates and making service/section associations to them. For instance, in the case of mulitple languge templates insure that your primary/default language is the template with the lowest Template #. Additional templates associated with the service/section will be available for selection on the Discharge>Diagnosis tab. 9/22/2008-wr-Modified the Case Summary (MRS0024) screen with the ability to designate which discharge templates are used for the client and RDVM versions of the Discharge Instructions (MRR0030). Two new fields were added to the Discharge>Diagnosis tab: "Client Discharge Template" and "RDVM Discharge Template". Both fields have an attached LOV that filters displayed discharge templates based on type (client/RDVM) as well as service/section association depending on the attending service/section of the episode. Note these templates are defined in the Discharge Template screen (MRV0020) and the service/section associations are also made there. The system will auto default these new fields to the template associated with the attending service/section; the user can then override these default entries as desired. Changing the attending service/section will cause the templates to be reset to the defaults for the new attending service/section. The "Set Default Inst Selections" button will check that the current template selections are the defaults for the attending service/section and if not prompt the user prior to overwriting them. This feature will allow a greater degree of granularity/customization in selecting a discharge template plus it will allow selection of discharge templates in alternate languages. The feature is implemented in a way that it can be ignored and functionality will remain as it was before i.e. the default template for the attending service/section will be used. 6/25/2008-wr-Unable to duplicate this issue in testing. Compared code in PHS0006 and PHS0015 for Multi-Copy Label printing and it is identical save local screen specific variables. Suspect this issue may have been caused when attempting to print labels as a user with no defined pharmacy association. Users were prompted of this condition on screen entry (NOTE this behavior changed per TT # 18535). Modified PHS0015 to pull default pharmacy association from Rx log record vice using user association; this will determine what printer the label is printed to. 10/3/2008-wr-Corrected the where clause/query error in the Deficient Medical Records (MRR0005) report as well as the page break problem. The proposed enhancment has been broken out to seperate ticket (# 20820). 8/8/2008-wr- The Case Summary (MRS0024) screen was modfied to exclude inactive patient records in an earlier release. This mod caused the described problem when trying to query on old clients. MRS0024 was changed to ignore the client # when performing a query based on passed in parameters; this will enable query of those patient records in the scenario described. 8/8/2008-wr- Modified the Case Summary (MRS0024) and Patient (PDS0002) screen to look up additional registry keys when the "open" command is not supported. It appears Adobe now utilizes a "read" command in the registry. Note this modification was made on Ext Docs and Handouts. 8/26/2008-wr- The record group behind the Client # LOV validation was modified to be filtered by an entered Patient # in 3.1.10. Re-inserted the prior filter on entered Client # as well. NOTE that this logic only applies to the Client # and Patient # fields, you can see this with an existing number in the Client # field when you hit the LOV button only that client record is available in the list ditto the Patient # field. However, if you hit the Last Name LOV button, for instance, with a name entered in the Last Name field all client last names will be available. This should speed auto fill entry when entering ID numbers as described in the ticket description. 8/9/2008-wr-The basis for this error was the fact that the entered ext docs directory did not include a trailing slash ("\") and the system did not handle this. So what in essence happened is the ext docs directory moved one directory level up and the "medical_record_scans" directory name became a prefix on the ext docs filename. This, now longer, filename exceeded internal varaible limits and casued the error. The Case Summary (MRS0024) and Patient (PDS0002) screens have been modified to handle directory names with no trailing slash and internal varibles increased to handle the full 256 character allowable filename size. NOTE that the ext docs feature makes a re-named copy of the doc in the defined ext docs directory so placing your original docs in that directory to load them into UVIS will result in you having two copies of the same doc in that directory with two different names. One being your original doc and the other being the UVIS re-named version of the same document. 11/21/2008-wr-Modifed the Case Summary (MRS0024) Request>Imaging tab image viewer link (camera button) will handle resgistry entries with no wildcard string ("%1"). This should prevent the error being expereinced with later installs of Internet Explorer. Note that this fix was already made in the 4.0 codeline but has now been carried back to 3.1.10 codeline. 7/8/2008-wr-The issue was casued by a change in the way Oracle Reports treats parameter form triggers in the 4.0 environment. This change impacts the DESIGNATED_PRINTER functionality (see AU TT # 959) in UVIS. Per discussion in UVIS Proj Mngrs meeting and school feedback this functionality was not being used and is being deprecated to allow for user over ride of Destination Name on report parameter forms. Code to enable this functionality is being stripped out of all modules and any entered setup/module records will be removed fromt the External Devices structure. Defining of Designated Printers for select UVIS reports identified in the relese source and TT # 959 will no longer be an option. 10/14/2008-wr-Modified the db triggers to populate the Vaccine Addtl Info when the vaccine is issued via the UVIS Pharmacy and contains this info. The data added includes the manufacturer, exp date and lot #. 8/13/2008-wr-Modified the Case Summary (MRS0024) screen so that the user is prevented from deleting a verified diagnosis. The issue of a missing diagnosis not producing a deficient medical record condition when the system option to require one is enabled was addressed under UMN TT # 20425. The Diagnosis is a discrete verifiable component of the medical record it is not "rolled in" with the Discharge Instruction which is itself a discrete verifiable component. It seems you are looking for UVIS to enforce local policy requiring a diagnosis on the discharge instructions; UVIS currently does not include any such capability. 8/11/2008-wr-Issue was caused by data exceeding field size limits of the text view field (32k characters). Modified the Case Summary (MRS0024) Comm Log Text View function to handle this error and alert user that not all text can be shown. 8/13/2008-wr-Modified the Case Summary (MRS0024) screen on the Verify>Review tab to perform a check of all diagnosis related system options. This includes diagnosis, body system, anatomic site, etiology and modifier. Based on system option settings, missing these elements will create a deficient med record entry that will prevent episode close. 8/13/2008-wr-Added additional code in the Case Summary (MRS0024) screen to null the user password on the Verify>Manage tab on various failure conditions. 8/13/2008-wr-Any records entered in PHS0004 will be visible in MRS0024 by simply re-querying the data displayed in MRS0024; suspect user did not have cursor in the correct block (Rx Request) when performing the query. The Case Summary (MRS0024) screen was modified to auto-query the Request/Order block when returning from PHS0004 if called from the Rx Req button. 8/11/2008-wr-Modified the Case Summary (MRS0024) to utilize current time when appending to a comm log entry. 9/11/2008-wr-See TT # 15155. 10/22/2008-wr-Though I could not duplicate this error locally the Result Entry (MRS0009) screen has been modified in regard to some suspect ares concerning the "to" Date/Time Needed field. Modifed the default internal date formats in the form to include a time component. Modified the Calendar LOV to return a time component if the calling field inculde one, which the "to" field does. Modified the method in which the initial value of the "to" field is set to current date/time. 8/26/2008-wr-Corrected the item property settings of the Order Datetime field to prevent user edit. 10/9/2008-wr-Modified the Visit Questions (MRV0007) screen "Rel Q" checkbox so that it is system controlled and no longer user editable. This change allows the user to view the related questions canvas prior to the box being checked. Additionally, there is code added to keep the checkbox in synch with user actions and existing related questions records. If any active related questions exist the box should be checked if not it should be un-checked. Note that the user may be prompted in certain circumstances that the Rel-Q checkbox has been changed and they will be prompted to save this change. 8/18/2008-wr- The MPL list on new requests was limited to MPL entries associated with the current episode so not all Active entries were shown. This episode association on the MPL is not visible to the user so user has no way of knowing which episode a problem belongs to. Not sure why this restriction was in place; AU request seems resonable so the system was modified to display all Active MPL Problems for the selected patient on the new request pop-up window. Note this only applies to those sites and those request areas that enable the MPL association via MRV0009. 8/18/2008-wr-Added a pop-up alert on the Comm Log>Contacts tab that will prompt the user to confirm when attempting to add a new comm log entry via the "Log Entry" button. The user can still choose to make a comm log entry by responding appropriately to the prompt. Note also that manually selecting the RDVM from the contacts list once on the new entry canvas will bypass this alert. The "do not communicate" flag can exist at the Bill/Order or RDVM level. 8/18/2008-wr-On the Case Summary (MRS0024) screen access to the Personnel>VMTH tab is NOT controlled by a users/roles acces to BLS0001 and the view only settings on that module. It is impacted by the module priv settings associated with BLS0001 i.e. BLS0001 priv # 2 allows the user to edit the primary staff data contained on the MRS0024 VMTH tab on closed orders. The handling of this priv was corrected in MRS0024 as well as the security on closed orders. NOTE that there are tabs: Personnel>Client and Personnel>Pri RDVM and Sec RDVM that do have access controlled by user/role privs on other modules, PDS0001 and PDS0003 respectively. The VMTH tab does not follow this model as it was deemed desirable for students to have edit privs on the VMTH tab yet not on BLS0001. 8/18/2008-wr-Corrected error in the Case Summary (MRS0024) screen preventing update of Cesus data from the Visit>Location tab. 9/11/2008-wr-Modified the Deficient Medical Record report (MRR0005) and the Case Summary (MRS0024) screen to use consistent criteria for identifying med rec deficiencies. The Case Summary screen provides more descriptive verbiage to identify the deficiencies but both the screen and report should identify the same issues on the same episodes. Note this resulted in additional criteria being added to MRR0005 that it was not considering before i.e. it should find deficiencies this it was missing prior to this mod. 9/26/2008-wr-Have been unable to duplicate this error locally but suspect it may be caused by block edit privs not being correctly set prior to episode close. Mods were made to block edit privs to address this issue in the Case Summary (MRS0024); please re-test this version and re-open the ticket with additional examples if the problem persists. 10/22/2008-wr-The Discharge date had already been added to this report under an earlier ticket(16095); I am simply re-releasing MRR0008 under this ticket to insure patch release. 6/26/2008-wr-There were remnants of the old estimate structure, in which estimates had to be made on a bill/order, that remained on the Order Hdr (BLS0001) and Case Summary (MRS0024) screens. These remnants have been removed and converted completely to the new estimate structure. To that end you will see additional fields (Estimate Title, Comments(MRS0024), Date(MRS0024)) associated with the estimate data on these screens. The end user can interact with the estimate fields on these screens in the same way they have in the past and just enter estimate hi/lo numbers; if left blank, system default values will be used for the Estimate Title (patient name space bill/order #) and Date (sysdate) fields. The included script will copy legacy estimate data over to the new structure to insure it remains visible as before. In regard to the specific issues raised by this ticket: the first item had to do with the system assuming that a user navigating from MRS0024 to BLS0010 was to work on an estimate specific to the episode selected in MRS0024. This code/assumption has been modified so that MRS0024 data reflects changes made in BLS0010 only when related to the selected episode. The printing of the Authorization/Estimate was dependant on which version was selected. The MRR0010 version allowed printing when not linked to an order the 9/10/2008-wr-Modified the Case Summary (MRS0024) screen so that the Procedure selection to include/exclude associated result report is reset when the user hits the "Set Default Inst Selections" button on the Discharge>Diagnosis tab. 10/14/2008-wr- Corrected the use of the Order Open Datetime as the Admit Date in the Case Search (MRS0001) screen. The Order "Open Datetime" on BLS0001 is just that, the system generated date the Bill/Order was opened it should NOT be editable by the user and this bug has been corrected in subsequent patches. The Admit Date visible on MRS0024 is intended to record when the animal was admitted to the hospital and this is the date that should be changed to reflect that event. The Case Search (MRS0001) screen was incorrectly pulling the Order Open Date and displaying it as the "Admission Date"; this error has been corrected. NOTE that on Bill/Order open, when the episode of care is created, the Admission Date is defaulted to the same as the Order Open Date but these are two seperate fields that represent two different events. 8/26/2008-wr-The initial error message received appears to be caused by the fact that you have muliple estimates associated with a single Bill/Order. This is an abnormal condition and should not occur. You can query the uvis_estimate_hdr table to find those records with duplicate order_id and order_id_suffix data. The latest version of BLR0001 (modiffied per TT # 20616) will handle this abnormal condtion. The Estimate (BLS0010) screen has been modified to address the second issue; the Select List tab will be cleared when the user creates a new estimate record. 1/22/2009-wr-Unable to duplicate this error in testing. I have added additonal code in the Case Summary (MRS0024) screen to force the use of a time component in the system datetime being used to populate the Verified On field in hopes that will address the issue AU is experiencing. 9/8/2008-wr-Modified the error message to obscure the password on failed verification attempts. Able to verify multiple records after failed attempt without error; this was tested on a number of episodes. 9/30/2008-The Med Record Queries (MRS0013) screen was modified so that the field sizes on the result block match the corresponding view columns in the database on which they are based. 1/15/2009-wr-Modified the handling of the ASAQ calculation and the field displaying it in the Order Dtl (BLS0002) screen. NOTE that the Case Summary (MRS0024) does not display ASAQ data on its Charges tab but the data is still calculated and saved from items entered there and thus ASAQ pricing will impact pricing on MRS0024 on record save. 9/29/2008-wr-Modified the Admit/Transfer Detail report (MRR0031) to correct error in formatting. 9/25/2008-wr-This error was casued by the entered value exceeding the format mask on the field. Expanded the db column from a 6 digit limit to an unlimited number of digits and expanded format masks on the Order Hdr (BLS0001), Estimate (BLS0010) and Case Summary (MRS0024) screens accordingly. 9/22/2008-wr-Corrected error in the Case Summary (MRS0024) screen that was not recognizing new attending service/section done via the Transfer tab when populating History/Physical questions. 10/23/2008-wr-Corrected error in the Case Summary (MRS0024) that was ignoring entered Client # on the search canvas and the eidt privs on the Search canvas after cycling through closed episodes. 10/22/2008-wr-Modified the From/To date formats on the parameter form for the Product Line Count (MRR0023) report to MM/DD/YYYY. 9/26/2008-wr-Corrected errors in block edit priviliges that were preventing users from entering needed data in password field on the Case Summary (MRS0024). 11/7/2008-wr-Modified the Case Summary (MRS0024) so that Comm Log entries are not subject to the same security controls as other med rec entries and can be made regardless of episode status. 11/05/2008-wr-Modified the Case Summary (MRS0024) to prevent programatic update of database fields on closed episodes when form block priviliges prevent update. 1/9/2009-wr-Modified the Deficient Medical Record (MRR0005) report; added a new parameter for "Att DVM" to allow users to filter output by a DVM if selected. With no "Att DVM" selected the report will return data for all DVM's. 1/9/2009-wr-Modified the Order Hdr (BLS0001) screen to re-set the Bill/Order # values on the New Order pop-up canvas for each new related/suffixed order created. 11/6/2008-wr-Corrected the LOV on the Request field of the Verify>Managment tab on MRS0024 to pull back the correct request areas for Un-Finalizing results; it was incorrectly pulling back lab areas and it should only allow selecting hospital area requests. The ticket description provides no specifics on the problem encountered so I am assuming that it was simply a case of not being able to find/select the desired request and this fix addresses that. 11/6/2008-wr-The Additional Information entries are populated at episode creation so to see the new entry you added you would need to open a new episode. Noticed in looking at this issue that the sort order on the Additional Information was being ignored; this has been corrected and the associated script will correct it on legacy entries as well. 10/09/2008-dg- altered formula columns within report to select data from uvis_cl_patient tables vs. the log table. 1/22/2009-wr-Modified the Case Summary (MRS0024) screen to refresh the New Request info with each episode. Since the attending DVM and Student can change with the episode the refresh of this data was placed at that level rather than the patient level. This includes the Date Needed field i.e. it will be refreshed with current date and time when changing episode records. 12/18/2008-wr-There are already "Given to Client" and "Given to RDVM" buttons on the Discharge>Instruction tab of the Case Summary (MRS0024). These buttons were modified so that when pressed the comm worklist entry for the associated instruction (Client or RDVM) is set to a sent ("S") status. The user and date is also recorded as well as a boilerplate comment that the disch inst was generated from MRS0024. The "Disch Send/Log" buttons on the Printing>Distribution tab were modified to do the same thing for their parent block (Client or RDVM). In this way when the clinical staff hands the discharge instructions to a client or RDVM they can record that action via these buttons and the corresponding task on the comm worklist is marked as sent so a duplicate/unneeded copy is not sent. 12/18/2008-wr- Modified the database triggers that set the comm worklist entries for discharge instructions to ready ('R'); these triggers will now delete those comm worklist records when the repective discharge instructions (client or RDVM) are blank. NOTE that since this functionality is handled by db triggers the end user will NOT be prompted when this happens. This activity will be logged in the comm worklist log. 10/23/2008-wr-Modified the Case Summary (MRS0024) and Patient (PDS0002) screens Ext Doc handling to enable playing of .wav files when user hits the "Open" button on the Ext Doc tab. UVIS uses the program on the client machine assoicated with the .wav file extension to play the file. For most of you this will probably be Windows Media Player. Based on your setup of Media Player the application may not launch automatically but the file will still play. You should be able to launch Media Player from your task bar/system tray if that is the case. 11/11/2008-wr-Corrected error in the Case Summary (MRS0024) screen selecting across labs dblink on lab requests. 1/19/2009-wr-Modified call of the Request/Result Detail (MRS0008) screen from the Case Summary (MRS0024) screen to remain on the Request tab when called from the request details (goggles) button on the Request and Lab tabs. 10/30/2008-wr-Corrected Instructions tab fields of Service, Section and DVM on the Primary Diagnosis (BLV0008) screen so that when user clears the field the hidden database id fields are also cleared and thus the change is saved to the database. -Corrected handling of Diagnosis linked instructions associated with a service/section/DVM when drafting the disch inst in the Case Summary (MRS0024) screen. 11/6/2008-wr-This error was caused by the SOAP entries on that particular case exceeding the field size limits (32000 characters) of the text display field. Code has been added to the Case Summary (MRS0024) to gracefully handle this condition and alert the user that the displayed text is incomplete. Note that users can then view SOAPs at the Date or Problem level to allow them to see the complete text. 11/21/2008-wr-Modified the security logic in the Case Summary (MRS0024) screen so that access to the Estimate data on the Admission>Estimate tab is controlled by the users access to the Estimate (BLS0010) screen i.e. no access or view only access to BLS0010 will allow view only access to the estimate data on MRS0024. 1/20/2009-wr-Added checks and user messages to provide more user friendly handling of the scenario described in the Case Summary (MRS0024) screen on the "Split Problem", "Send to MPL" and "Populate From MPL" buttons on the Initial Plan and MPL tabs. 1/20/2009-wr-When a user has no priviliges on the SOAP section of the Med Rec the "Populate/Re-Populate SOAP" button should not do anything; a message has been added to tell the user this. The various "Text View" buttons provide users a single aggregated view of SOAP data at various levels; these should function for any user who has access to the screen as they allow no edit capability. Just to clarify, the access granted on various aspects of the Medical Record via the Episode/Verification Parameters (MRV0008) screen define who can enter/edit data, whose entries require verification, and who can perform that verification. These settings do not control who can view data. You do that by granting access to the screen and there is no granular breakout of the tabs on MRS0024 in that regard i.e. if you have access to MRS0024 you can see all elements of the Med Rec. 1/20/2009-wr-Modified the Request/Result Detail (MRS0008) screen so that it does not allow update of the Specimen Code field unless request is in a New status. There is no functionality to update the specimen code in the lab system once the request is submitted. That is why edit is allowed only on New status. Also added validation on this field that will alert the user and null the field if they enter a specimen code on a non-lab request. 11/21/2008-wr-Could not replicate this error locally. Added addtional checks in code behind both the Close and Re-Open episode buttons on the Verify>Management tab of the Case Summary (MRS0024) to insure that logged on user has appropriate privs on needed data blocks. 12/2/2008-wr-Modified the Prescription Fill (PHS0006) screen to populate missing data in Case number, Rph number, and product code fields. 12/1/2008-wr-Corrected property pallete setting that was preventing product line #/seq # data from displaying on the Product (IMS0004) screen, list canvas. 12/3/2008-wr-Corrected setting to populate missing numeric fields in the Prescritpion Approval (PHS005) screen. 12/3/2008-wr-Corrected required settings on the Instructions field on the Prescrption Approval (PHS005) screen. 1/22/2009-wr-The "Preview Inst" button on the Discharge>Instructions tab bypasses the running of attachment reports; it only previews the Discharge Instructions (MRR0030) report itself. The assumption is that this preview will be used by DVM's to check appearance/formatting issues on the text body that they create/edit on that tab. To include the attachments such as lab results would mean that clinicians would have to wait for those attachments to generate to the screen and then close those windows once they close the MRR0030 preview window as these attachments are separate reports that each run individually. This is an easy modification to make if that is the desire of the UUG. I'm not sure how this feature gets used in the real world so I don't know if this makes sense or not. When previewing or printing the Disch Inst from the Printing>Distribution tab the attachments are included. I have modified the buttons on this tab to reflect that by adding "+ Att" to the preview buttons. A corresponding change was made to the button on the Discharge>Instructions tab, it was changed from "Preview Inst" to "Prvw Inst (-Att)" to provide users an indication that selected attachments are not included. The automated tooltip text on this button was also modified to reflect this 12/4/2008-wr-Could not duplicate issue with MRS0024, suspect this is a printer naming issue between client machine and OAS. Modified the Order Dtl (BLS0002) screen by replacing obsoleted run_product calls. 12/4/2008-wr-Modified the Estimate (BLS0010) screen to prompt the user to automatically create an estimate hdr record when passing in a Bill/Order # that is not already associated with an estimate. Note the estimate will be given a default title with the patient name and bill/order # or alternatley the user can answer No to the prompt and still create an estimate hdr record manually. 1/22/2009-wr-Modified the Request (MRS0007) and Case Summary (MRS0024) screens so that they do not allow edit of request questions unless the request is in a NEW status. 12/19/2008-wr-Modified the Order Hdr (BLS0001) screen so that the "Self Referral" and "Do Not Communicate with RDVM" checkboxes are included in the module priv to "Update RDVM data on Closed orders". This is priv # 4 on BLS0001. 12/16/2008-wr-Added the ability to pick up an "INDICATION FOR STUDY" request question and include the user answer in the PACS message. NOTE only one question answer can be included in the message so a site can choose to use "INDICATION FOR STUDY" or "HISTORY" but not both. Changed the time format to a 24hr clock to avoid AM/PM confusion. This is for all time components in all PACS messages generated from UVIS. 1/22/2009-wr-Corrected the query of the SOAP records on the Comm Log canvas to return only those records for the current episode/patient. 1/9/2009-wr 1) Modified the Order Dtl (BLS0002) screen and Case Summary-Charges (MRS0024) tab so that checks for a required Supporting DVM are not bypassed. Note also that the item approval process does a check of this also. 2) The census uses an alpha sort, so numeric values are treated as alpha charcters i.e. it will sort 1, 11, 12, 2, 21, 3 not 1, 2, 3, 11, 12, 21. You can correct this by entering your data with leading zeroes in your ward/cage names i.e. 01, 02, 03, 11, 12, 21, etc... 3) Could not duplicate this error in local testing or connected to UMN Prod and UMN App Server; please provide the specific steps you are using and a sample record that dispalys this behaviour. 4) Modified the Order Hdr (BLS0001) screen, re-labeled the "Self-Referral" check- box on the RDVM tab to "Referral" and reversed the logic on setting. A checked "Referral" checkbox means that this visit was triggered by RDVM referral; and un- checked box means the client schedule the visit without an RDVM referral. There may still be an RDVM entered and communicated with on non-referral visits but the visit was not initiated by the RDVM. 1/22/2009-wr-Issues addressed as follows: 1) Case Summary (MRS0024) modified to refresh request information on each episode since elements of this data are at the episode level. 7) Case Summary (MRS0024) Comm Log error corrected in the append function so that entered comments are saved. 9) Case Summary (MRS0024) modifed to correct error; check added to enforce entry of negative amounts on adjustment items. 11) This issue addressed under seperate ticket # 21367 1/22/2009-wr-Corrected error in the Case Summary (MRS0024) that was not recognizing selected reqest are. The system was always defaulting to the first request area pulled back that was associated with the product line; so user input to the Area field was being ignored. 1/14/2009-wr-Looking at Oracle reports provided by UMN it appears part of their issue may be missing foreign key indexes casuing unnecessary locks. Added a new procedure (blanket_fk_index) to the uvis_sys_pkg that will create indexes on all foreign key columns that are not already indexed. Calling of this new procedure will be added to the master release script. NOTE that you can call/execute this procedure manually as desired from TOAD or SQL Plus. 1/15/2009-wr-Modified the triggering of the Death Certificate so that it is triggered by the setting of the deceased flag on the patient record. This means it will be triggered by selecting an appropriate Discharge Status, or by entering a defined euthanasia product on the bill, or by manually setting the checkbox on the Patient (PDS0002) screen. Also corrected an error in the Comm Worklist (MRS0014) screen that contained a data type size mismatch on the "Ready On" status field. 1/27/2009-wr- Modified the Case Summary (MRS0024) screen and moved handling of CLOB data to a stored procedure (uvis_mr_pkg.get_disch_inst) to prevent datatype mismatches that cause these errors when the disch inst exceeds certain character limits. TICKET CUSTOME TITLE REL_SOURCE R 10145 CU Bug on lockbox payment upload --02/13/2009-- 10145_sys_option.sql dls0007.fmx 10/14/2008 10145_sys_option.sql 11/6/06 dls0007.fmb; 10145_sys_option.sql 10243 UDL Add Contacts to Business/Farm Clients dls0001.fmx dlr0027_mu.rdf ?? 10325 VSOL UVIS_SYS_OPTION_M field length --02/13/2009-- increase. 10325_sys_opts_set_m.sql 11161 MU Sequence 0 on CP requests from DL --02/13/2009-- n/a 11196 OKSUL Multi Unit Pricing - EOD --02/13/2009-- n/a 11548 CU DLS0019 Deletion Bug --02/13/2009-- dls0019.fmx 11681 CU Cornell Contract Capping- EOD issue --02/13/2009-- uvis_dl_pkg.pkg 11855 UWHOCP Wrong Medical Record Number Prints --02/13/2009-- on CL clr0001.rdf clr0001_cu.rdf clr0001_mu.rdf 11886 MU Sections reporting incorrectly --02/13/2009-- dls0001.fmx dls0003.fmx dls0005.fmx dls0042.fmx 11886_dl_test_results_m_lu p.sql uvis_dl_test_results_m_trg.t rg 11890 AU Querying RDVMs --02/13/2009-- 11890_uvis_dl_rdvm_chk.sq l -- maintenance script -- do not release -- 11890-rdvm-query-error.sql 13035 UGA System Option - Reposition Owner --02/13/2009-- dls0001.fmx 14575 MSU DLS0001 not querying correctly --02/13/2009-- dls0001.fmx 15475 UWHOCP Inactive Comments Avail. On Result --02/13/2009-- Entry cls0007.fmx 15615 CU Re-submit Rejected Lab Request --02/13/2009-- In HO Instance: uvmr_request_au_dl_reque st.trg uvmr_request_au_cp_reque st.trg In UL Instance: uvcl_interface_ho_ai_interfa ce.trg uvdl_interface_ho_ai_interfa ce.trg 16055 AU Incorrect invoice for credit balances --02/13/2009-- dlr0014.rdf 16735 CU Billng Excptn processing CANCELLED --02/13/2009-- recs uvis_dl_spec_test_x_au_po sting.trg uvis_dl_pkg 17175 VSOL Billing exception billex_tsid to num(6) --02/13/2009-- --for 10/29/2008 17175_uvis_dl_billing_exc.s ql cls0016.fmx dls0019.fmx -- shipped 03/27/2008 17175_uvis_dl_billing_exc.s ql 17375 AU Billing Exception Report --02/13/2009-- clr0014.rdf 17475 CU reduce uvis_message_log trace msgs --02/13/2009-- uvcl_req_itm_aiu_bidir_daw ning.trg 17935 UGA DLS0001 - Unlocked even after Final dls0001.fmx uvis_plsql_lib.pll 18175 MU Unreject broken in 3.1.10 --02/13/2009-- uvcl_interface_ho_ai_interfa ce.trg uvdl_interface_ho_ai_interfa ce.trg uvmr_request_au_cp_reque st 18797 VSOL Misc 3.1.10 Issues Hospital and Labs: *********************** uvis_plsql_lib.pll Hospital only: *********************** mrs0024, mrs0001, pds0004 20115 UWDL Animal Info Import - Species Field dls0001.fmx 20281 VSOL DB-Link Setups for Cross-App Screens cls0007.fmx cls0011.fmx dls0001.fmx dls0020.fmx dls0046.fmx mrs0001.fmx mrs0007.fmx mrs0008.fmx pds0002.fmx 20281_Load_HO_Module.s ql 20281_Load_UL_Module.sq l 20302 UMON translation and module update --02/13/2009-- HO and UL ************** sev0024, 20302_col_mods.sql HO only ************** uvis_default_menu UL only ************** uvis_ul_menu 20387 CU AR Summary Creation --02/13/2009-- eom_fee_income_update.pr oc 20394 VSOL UVIS 4.0 Print Destination Hospital: ACR0005, BLR0009/31, MRR0004/5/6/8/9/10/12/17/ 18/19/20/21/30/32, PDR0001, ACS0001/2/3, BLS0005, MRS0012, PDS0001, 20394_desig_printer_delete. sql Labs: DLR0029, 20394_desig_printer_delete. sql 20411 UGA Multi Item pricing not working --02/13/2009-- uvis_dl_pkg.pkg 20433 CU Lab Client type --02/13/2009-- uvis_cl_interface_ho_pkg.ad d_client 20502 CU UVIS DL - Unable to update Bill Qty on --02/13/2009-- D uvdl_spec_tst_x_bill_qty.trg 20503 CU DLR0012 Bug dlr0012.rdf 20505 CU uvis_dl_fee_income_update procedure --02/13/2009-- bug eom_fee_income_update.pr oc 20843 CU CLR1 selecting from log table --02/13/2009-- clr0001_cu.rdf 20853 UWDL DLS8 gen batch invoice .pdf files --02/13/2009-- dls0008.fmx 20853_sys_option_update.s ql 20861 CU Clinpath result entry error --DO NOT RELEASE-- --02/13/2009-- 20861_alter_cl_req_cntr.sql 20879 NCSU Mispelling on menu - 3.1.10.patch14 --02/13/2009-- 20879_menu_item_label.sql 21221 UMN receiving errors on reports cls0004.fmb 21241 UMN Lab Requests Missing --02/13/2009-- uvcl_interface_ho_ai_interfa ce.trg uvis_cl_interface_ho_pkg.pk g 21354 UMN UVIS Performance Issues --02/13/2009-- 21354_create_seq.sql uvis_sys_pkg.pkg 21518 UMN >1 test ordered only 1 sent to labs --02/25/2009 uvcl_interface_ho_ai_interfa ce.trg PROBLEM 10/14/2008- added slashes to ACCOUNTING, LOCKBOX_FILE_DELIMITER LOV choices. 7/28/2008 tsk4. Setting ticket back to open. Upload parameters needs to be modified to give us the ability to use a forward slash \ Also the bank has removed the client name from the ascii file, new file format looks like the following: 722,2959,23 399,2960,100 430,2965,127.50 Thank you, Tammy ********************************************************************** 2/22/2007 tsk4. Setting ticket back to open. Upload parameters needs to be modified to give us the ability to use a forward slash \ Also the bank has removed the client name from the ascii file, new file format will look like the following: 722,2959,23 399,2960,100 430,2965,127.50 Thank you, Tammy **************************************************************** 10/23/06 per lcarr. Setting ticket back to open. 02/26/2008-dg Reqs from MS State/Misso: * type in the contact name on the accession receiving screen and then choose the corresponding client from the drop down arrow as we currently do with vets/clinics * a separate field for the contact on DLS0001, so they can enter the occasional DVM on poultry accessions in the DVM field * the LOV should be limited to the contacts that would appear on the contact list of the AI tab based on the client, owner, DVM etc. Note: we are using a locally customized version of DLR0027, but Jana suggested you might want to check with Missouri about where they want the contact info to print on DLR0027. 07/12/2007-dg Check the attachment and let me know if this solution would satisfy the reqs. The underlying data would be stored in the uvis_dl_client_contacts_x table. Example: Mississippi State (MS) Poultry houses are UVIS clients of type 'CLIENT'. They have no assigned DVM. From DLS14, the poultry house has associated contacts on the Contacts tab. The Contacts should be selectable from the DVM LOV on DLS1-Accession Receiving. The poultry house contact should also be available from Accession A/I button. These contacts will be managed as clients in the DLS14-Clients screen. Increase uvis_sys_options_set_m.description field from 300 chars to 500 chars. 4/23/08 sem After discussing with Teresa, the sequence 0 seems to be generating when a CP test is rejected and then Re-submitted from Hosptial via MRS0024. Also, if a DLAB accession has a CP test on it, if there is some data that gets out of sort on the accession such that the tests are in W status but the accession is in N status, if you back out the test from W to N, then re-release the accession, the 0 sequence is created in the re-release. When a test is rejected and unrejected in Clin Path, the 0 sequence is not generated. 4/12/07 sem In RGI, 3.1.10 and 126.96.36.199, sequence 0 is not being generated. But, only one test is coming over to Clin Path for resulting. (188.8.131.52 CP Request 744/DLAB 07-00295) When adding an accession in DLAB that contains two of the same specimen types on the same animal and the same Clin Path test being performed on each of the samples, they come over to Clin Path with Sequence 0. Thus when attempting to result on CLS0007, it seems to get confused as to not knowing which record to result. This event is the same with single orderable tests as it is with profile/panel type tests. 10/14/2008- addressed via tickets 18975 and 20411. --orig description-- AccessionNo=07020240 Includes TestCode: SLEPTO1 and SLEPTO2 Client billed $944.00 should be $964.00 DL_EOD_Charges: Slept01: ChargeQty=154 ChargeAmt=462.00 (should be 482.00) Slept02: ChargeQty=154 ChargeAmt=482.00 UVIS Screen: Products -DLS0034 Version 3.18 TestCode=SLEPT01 UnitPrice=5.00 UnitPrice#=10 MultipleUnitPrice=3.00 TestCode=SLEPT02 UnitPrice=5.00 UnitPrice#=10 MultipleUnitPrice=3.00 Therefore: Slept02 Charges = (10*5.00)+(144*3.00) = 482.00 ?Slept01 Charges = (154*3.00) ???? = 462.00 Looks as if once the Multi Unit Price is reached in EOD is it applying it to other test in the accession that has Multi Unit Pricing. 7/9/07 ska- DLS0019 Deletion Bug When trying to delete entries from DLS0019 (Billing Exceptions) we are getting the following error: ORA-00920: invalid relational operator The SQL statement in error is: SELECT ROWID,TEST_CODE,BILLEX_TSID,TYPE_BC,ACCESSION_ID,PATIE NT_ID,REF_CASE_NO,SPECIMEN_ID,LUN,LUD,LUP,ERROR_ID FROM UVIS_DL_BILLING_EXC WHERE CT ROWID,TEST_CODE,BILLEX_TSID,TYPE_BC,ACCESSION_ID,PATIE NT_ID,REF_CASE_NO,SPECIMEN_ID,LUN,LUD,LUP,ERROR_ID FROM UVIS_DL_BILLING_EXC 2/11/2008 tsk4 Contract capping fees are also being duplicated when a case is addended. 8/7/07 ska Cornell Contract capping â€“ EOD Issue When we unfinalize a case that has been identified as a contact cap case, the current test charges in the eod_charges table are deleted but the contract capping fee (product line 900, seq 10) is not deleted. When this case is refinalized a second contract capping fee is being applied. Reopen 01-10-2009 (B. Liddick) Tammy Klock input: Original problem has not yet been resolved and Cornell has discovered that the contract capping fee is not being applied correctly when the sum of the contract tests is less then the capping fee. An excel file has been attached to this ticket describing different case scenarios and how the EOD process should apply the capping fee. Additional Input 01-12-2009 This has been a top priority, but as of December 1st, 2008 it has become an even larger issue. The capping fee was increased from $30 to $50 at Cornell on Dec. 1. This means that any test with a fee below $50 is being charged the test fee + the $50 cap fee. This is causing major issues internally and with Customers. 7/24/2008 - RS - Still not working. 4/11/08 sem After phone call with Faye and Wayne, the tickets listed below indicate an error message being generated. In Wisc, they do not get the error message but just transposed data. The wrong medical record case # prints intermittently on CLR0001. The attached document has details. Dupe ticket for 15717 and 15435. 6/24/08 Per emails from Teresa and other Missouri staff, this issue still exists. They are correcting them as soon as discovered for reporting purposes. Contact Teresa for future examples. 1/16/08 sem New update from Teresa. The out of sync section - displaying Serology when it should be PCR - is not on DLS0001 like it was originally. Now the disconnect is in the result screen DLS0003. Since this has been ongoing they are catching them quicker on Working List By Test screen but the PCR result people do not know they have one to result since it is falling under Serology. Sometimes it takes a call from the client to realize results have not been completed. They are correcting them one by one on the individual test in DLS0003. They need a better solution as it is affecting their workflow. 11/30/2007 sem Per emails from Teresa, updating to active as setup suggestion did not seem to correct issue. 9/24/2007 sem In the Section/Workstation DLV0008 screen, there is a Labs tab. When PCR section is highlighted and viewing the Labs tab, it was blank. Then I also looked at DLAB Setup, the Test Definitions record for MAI, and the employee record. If you look at the LOV's on the section field in Automated Accession Submission and for Section in DLAB Setup, for these screens, they do not display PCR because it is 3/06/08 Updated to Coded to be released in 184.108.40.206. 10/12/07 Updating ticket to Closed per Kelly. She does not have authority. 10/2/2007-klc-Don sent me some SQL scripts to run to clean up our RDVM data. There were extra spaces added to the names of the RDVMs and in addition, some correspondence fields were set to 'Y'. I think these error occurred when we transferred data from the hospital instance to labs. I ran the scripts from Don and this fixed our RDVM data. We can now query these in our AVDLPROD database. Thank you!! :-) We loaded some RDVMS into our AVDLPROD database in January 2007, and the RDVM_IDs range from 1 to 388. The problem is that we cannot query any of these RDVMs on the DVM Info screen (DLS0015). The DVM info is in the uvis_dl_rdvm table as well as the uvis_dl_client_rdvm_x table; however, when you try to query on DLS0015, it says no records found. RDVMs that were after January 2007 can be queried. An example is 10486, 10488 or any of the 300 numbers. Is there a problem with the table, view, etc? Would you please take a look and see what may be wrong or missing? Our State Diagnostic Lab is going live with UVIS on October 1. 1/28/07 - Duke - 3.1.10 - Labs System Option to reposition owner and RDVM fields on DLS0001, no longer works. Tab order on fields should follow new field order: Accession#, DVM, Clinic, Owner. Sometime when you return from the result entry screen back to the accession receiving screen, the accession screen will switch to a different accession from the accession that the results were entered on. In 3.1.10, if you inactivate a comment on set screen clv0011, that comment still appears in the "Update Comments" drop down list on the resulting screen (CLS0007) 2/29/2008-wr-Rejected Lab requests are not showing up in lab when re- submitted. Request #35693 for patient #158834 was submitted to the DL. They rejected it. I can see the original request on the lab side in the UVIS_INTERFACE table and the UVIS_DL_REQUEST_ACCESSION_X table. I then checked the hospital side and the current status of the re-submitted test is 'REQUESTED', as it should be. The user got a notification that it was re- submitted and the charge hit the bill/order, so it appears to have re- submitted successfully. But the DL never got the request. 9/8/2008-KLC-This problem did not occur for August invoices but there were very few early payments. I am putting this ticket into a "Hold" status until we see how September invoices turn out. 7/28/2008-KLC-We are still experiencing this problem in our labsprd1 database and avdlprd1 database. 4/1/2008-KLC-We are having this same problem for March invoices as we did for February invoices. For clients who sent in a payment before their accessions were finalized (therefore having a credit amount as their previous balance), the balance due on their invoices is showing $0.00 instead of the correct amount. An example is account 365144. This client paid $25 in advance and had charges of $50. Her balance due should be $25, but the invoice shows 0.00. 3/12/2008-KLC-We are having a similar issue as described in ticket 11628. Our labs, Pathobiology, Endocrinology, and the State Diagnostic lab, are having a problem with their invoices not showing a credit balance correctly. For example, for State Lab Client# 325, they have a credit balance of $-5.00, which is correct on the Client Info screen as well as the Monthly Accounting-DLS0008. However, the invoice shows a previous balance of $-10, payment of $125, charges of $130, and then a Working on issue with Penny at Cornell; they are getting old records re- written to the uvis_interface table on the HO instance and the uvis_dl_billing_exc table on the UL instance. They had cleared these tables to try and make their billing exception report useful but they just get re-populated with records from old (circa June 2007) accessions. uvis_dl_billing_exc.billex_tsid is a number(5) column. The DLS19- Billing Exception screen can handle number(6). Alter table to 6 as to not affect surrounding forms/reports. Will need to be applied to surrounding forms/reports soon. In our Labs production database, labsprd1, the Billing Exception report, CLR0014, is only showing billing exceptions of type 'Credit'; even though, there are several listed on the Billing Exception-CLS0016 screen as type 'B'. I have attached a copy of the Billing Exception Report as well as a screen shot of CLS0016. 04/01/2008-pc The UVIS_Message_log table seems to get lots of rows with â€œFailed to select from device_x where param=A120 and value1=4010â€•as well as many others with other test codes. Can you tell me what would cause these, since the requests seem to go through to the instruments ok and we have been getting these errors since we went live. The table has 1,725,848 rows in it so it slows things down when we want to take a look at it. 4/17/08 - Duke - 220.127.116.11 - DLS0001 Even after an accession has been finalized most data can be changed and saved. For example RDVM, Clinic, Owner, Patient, and Sample. You should not be able to change anything that changes the meaning of the case after it has been finalized, like who, where, and what was tested. Scenario from Kathy Curtis: Problem: Un-reject feature used for the hospital appears to be attempting to re-submit the same test on the same sample throwing the sequence in to â€œ0â€• status in result entry CLS0007 Test Case 501000 CBC, Alb, CA ordered in VTH; requested status in Clin Path; can be successfully rejected from specimen login CLS 0003; lab request CLS0002; or patient profile CLS0001. The status can be in either requested or accepted in CLS0002 or CLS0001 when rejecting. Once rejected, the tests are not viewable in Result entry CLS0007 and when rejected in Clin Path, the test appears rejected in the VTH. Currently and prior to 3.1.10, test can/could only be â€œun-rejectedâ€• from patient profile CLS0001. Prior to 3.1.10 an â€œun-rejectedâ€• test would simply return to â€œACCEPTEDâ€• status and could be resulted like any other test. Now, the un-rejected test appears in duplicate in Results Entry CLS0007 with a sequence of 0. The first set is in deleted status; second set in pending status but when an attempt is made to enter the result field with the pending status, (with the far right eye goggles) the following oracle error occurs; unable to perform query frm 40505. This same situation occurs when a test is backed out and re-released in accession receiving DLS0001 4/7/2008-wr-The following issues were discovered in testing or reported by various schools using 3.1.10: - User notifications not functioning. - Comm Log entries disappearing on Case Summary (MRS0024) - ADJUST ERROR invoice transactions not calculating client balance correctly from change in deposit handling. - Discharge Status field truncation error in MRS0001 - Patient Transfer (PDS0004) allowing selection of inactive patient record for transfer. - Error on SOAP tab, Error retrieving SOAP date data..ORA-6502, reported by UMN on Case # 322628 Verified that fix works in DLAB 3.1.10. Ticket closed. Orv. ======================================================= ===== Weâ€™re trying to use the animal information import feature of the DLS0001 A/I screen. Weâ€™re hitting a problem with the SPECIES field. Heather says that everything works except that she has to reselect the species field for each line imported. Looks like there is supposed to be validation on this field to convert it from actual text to the species ID stored within the database. Please investigate and fix this. Thanks. Orv UVIS4 and Java WebStart have revealed issues related to launching cross-app screens (e.g. HO-->Labs MRS7-Request Profile --> CLS11- View Patient Results and DLS20-Patient Request Information/DLS27- Reportable Events and Labs-->HO CLS7-Result Entry --> PDS2-Patient Info). This ticket provides DB link setup information to resolve this issue. Hello there When you send an updated module (ex. 3.1.10 patch 11 pds1, pds2, mrs24), I get problem with translation. I end up having to delete the whole translation for a module and redo it manually because I cannot figure out which variables were added-deleted-modified. Can you, whenever you change any module, include a detailled spreadsheet of the changes to variable. thanks LL Cornell needs to recreate A/R Summaries for: June 2007 July 2007 August 2007 September 2007 November 2007 I spoke with Clyde and he will be discussing this issue with Donny. Thank you, Tammy 7/7/2008-wr-Per testing at UMN, user is unable to override default printer with manual entry in the Destination Name field on the parameter form in UVIS 4.0. This is applicable in those instance when a report is printed via a parameter form. 7/9/08 - Duke - 18.104.22.168 Since the 3.1.10 upgrade multi item pricing is not working. All Tests are being charged to the client at full price regardless of the billing qty. In the CP trigger on the UVIS_INTERFACE table it calls a stored procedure to do the insert if it finds no matching hosp client_id record in the lab client table. The procedure called is uvis_cl_interface_ho_pkg.add_client; this procedure looks up the data from the hospital client table to include the client_type_id and inserts it into the lab client table as is i.e. I think this procedure needs to be corrected with logic similar to what is in the DL trigger on the interface table; it needs to look up the lab client_type_id for an â€˜OWNERâ€™ and use it as the client_type_id on the inserted record in the lab client table. Bill Liddick (From Cornell Development Team) Accession# 90126-08 had test code "IHCDX" billed for a qty = 3 on 7/25/08. On 8/4, the qty was successfully changed to 2. Then the user realized that it should not have been changed and tried to change it back to 3 but received error: "Unable to update record (FRM-50509)" When I clicked on 'Help', 'Display Error', the following came up UPDATE UVIS_DL_SPECIMEN_TEST_X SET WHERE ROWID=:1 ORA-01481: invalid number format model ORA-06512: at "UVISLABS.UVDL_SPEC_TST_X_BILL_QTY", line 112 ORA-04088: error during execution of trigger 'UVISLABS.UVDL_SPEC_TST_X_BILL_QTY' *************** I have noticed that if I run the following statement from the UVDL_SPEC_TST_X_BILL_QTY trigger (lines 110-112) SELECT TO_NUMBER(SYSDATE,'RRRRMM') /* INTO V_M_TSID*/ FROM DUAL the following error occurs: SQL Error: ORA-01481: invalid number format model 01481. 00000 - "invalid number format model" *Cause: The user is attempting to either convert a number to a string via TO_CHAR or a string to a number via TO_NUMBER and has supplied an invalid using the uvis_lab_id parameter. 10/01/2008- This report is number format model that you have currently queried DLS8-Monthly Accounting's screen. When the report is called that uvis_lab_id is passed to the report. What if you have multiple uvis_dl_charges records under multiple lab ids? 08/05/2008- Bill Liddick (Input Fr Tammy Klock) The DRL0012 report is not including adjustments where the uvis_lab_id is anything other then one. When I remove the following code the report run correctly and uvis_lab_id = decode(:p_dlab_id, -99, uvis_lab_id, :p_dlab_id) Bill Liddick (Input From Tammy Klock) The following statement for the billing period of 200807 is looking for records where the d_tsid date is between 7/1/2008 and 7/31/2008. select sum(charge_amt) into v_acc_test_rec from uvis_dl_eod_charges eod, uvis_dl_eod_status status, uvis_dl_eom_status eom, uvis_dl_product prod where prod.product_line_id = eod.product_line_id and prod.product_seq_id = eod.product_seq_id and eod.accession_id is not null and prod.product_category = 'T' and eod.d_tsid = status.d_tsid and status.m_tsid = eom.m_tsid and eom.m_tsid = pi_m_tsid; But when you look in the uvis_dl_eod_charges for the invoicing period you will find records with entries outside these dates. These would be cases that have been unfinalized or addended. This statement needs to be modified to query on the m_tsid value rather then calendar dates. Can you check on something for me regarding CLR0001? There are three animal demographics fields in CLR001 that are being pulled from uvis_cl_req_pat_log: cf_species_age cf_breed cf_sex_wgt This is causing problems for us if we need to change/correct the animal information in the patient table, the data in the uvis_cl_req_pat_log table is not updated so incorrect information is going out on the report. Do you happen to know why the significance of this table and why or if its necessary for the report information to be drawn from this table? Thank you, Tammy > When I try to run the 3.1.10 DLS0008 (latest patch version) in â€œbatchâ€• mode the way I always do, it correctly calculates the invoices and starts to generate the PDF files, but then stops responding and never finishes. The point at which it stops responding varies. Iâ€™ve done it two times now, and the hang points are different. I can interactively go into DLS0008 and generate all the PDF files without a problem. So Iâ€™m wondering if thereâ€™s any way you can turn on some debug code so we can together tell where/why the thing is stalling out. ORA-01438: value larger than specified precision allows for this column ORA-06512: at "UVISLABS.UVIS_CL_PKG", line 1699 ORA-06512: at "UVISLABS.UVIS_CL_INS_REQITM_CONTAINER", line 101 ORA-04088: error during execution of trigger 'UVISLABS.UVIS_CL_INS_REQITM_CONTAINER' 1/26/09 - Glenn Waters - As of patch 16 this issue is resolved. Closing ticket 10/16/08 - Glenn Waters - Noticed a mispelling on a core menu item. See attached screen shots for the example 12/5/2008-wr-I think this is a printer naming issue. When I look down your report server queue the failed BLR0009 (invoice) reports that I see were because you were trying to send them to a printer named â€œHPâ€• apparently there is not a printer with that name set up on and the App Server. Remember the model for auto printing things; UVIS looks up the default printer for the local machine and passes that to the App Server, this same printer/name must be set up on the App Sever. You can test this out and take a look at your report server queue at: http://uvisapp1.ahc.umn.edu/reports/rwservlet/showjobs? If you click on the Job Status link it will show details on the error. Test on a machine with a different default printer or change the default printer to one that you know is defined on the App Server. ****************************************************************** 12/3/08 lls verison 4.0: We are receiving the following error when UVIS tries to print any UMN reports, invoices when a client is cashiered out (BLS0005) or when the lab application tries to auto print a request upon acceptance: â€œUnable to run report. (FRM-41214)â€• Also getting FRM-302000 from Print Labels btn on CLS4-Reprint LAbels screen. 12/9/2008-wr-UMN is experiencing sporadic lab request from the hospital that do not come across to the lab in 4.0. 1/13/2009-wr-UMN is reporting periods of poor system performance after going live with 3.1.10/4.0. They have sent Oracle db performance reports via e-mail detailing some performance issues. 4.0 patch 13, 3.1.10 patch 17: see episode #367051/Case #306874/request #439229 and episode #367135/case #217829/request #439277 in production for examples. Since implementing the latest patch when multiple cytologies are ordered from the hospital only one is going across to clin path. RESOLUTION 10/14/2008- added slashes to ACCOUNTING, LOCKBOX_FILE_DELIMITER LOV choices. 11/6/06-CL-Created system option ('ACCOUNTING', 'LOCKBOX_FILE_DELIMITER') and added this to the WHEN_BUTTON_PRESSED trigger on the LOCKBOX button. The system option will allow delimiter values for the flat file of comma or pipes. +++++++++++++++++++++++++++ CHANGES MADE ON ORIGINAL TICKET OF 1861 - Modified the LockBox button trigger parsing of the file record. 03/03/2008 - New Contact fields added to DLS0001-Accession Receiving screen. Added contact_id to uvis_dl_accessions table. System Option DLS0001_CONTACT_FIELDS used to display/hide Contact fields on dls1. Accession Contacts avaiable from the LOV include contacts on the AI/Contacts tab (i.e. based on Owner contacts, Client/Acct contacts or DVM contacts as defined in DLS0014-Client Info and DLS0015-DVM Info). 10-Oct-2006-dg Increase uvis_sys_options_set_m.description field from 300 chars to 500 chars. 10/29/2008 - fixed under t# 15615. 08/19/2008 - fixed under UGA ticket# 20411 (released in 3.1.10.patch13). 10/28/2008, added a delete record button to allow user ability to delete billing exception records one-at-a-time. Also added "Delete All Records" button to allow user to delete all records. 10/01/2008 - updated uvis_dl_pkg.chk_contract_cap to handle contract cap pricing. To avoid updating already adjusted capped-pricing items, the records that are updated will meet the following criteria: /* ***** */ and (nvl(adj_amt, 0) =0 and nvl(charge_amt, 0) <> 0 and nvl(contract_cap_yn, 'N') = 'Y' ) /* ***** */ and will be updated with: /* ***** */ adj_yn = 'Y', adj_reason = 'CONTRACT CAP CHARGE', adj_inv_revert = 'A', adj_amt = charge_amt, charge_amt = 0, comments = substr((comments||' - '||sysdate||', uvis_dl_pkg.chk_contract_cap'), 1, 500) /* ***** */ Addended records will be updated based on the contract_cap_yn flag. 05/08/2008- reports modified to return proper Med Rec Case#. 03/04/2008- reports modified to return correct request_id. 07/30/2008 - added LUP field to uvis_dl_test_result_entry table and associated screens/trgs that use the table. The use of LUP (Last Updated Process) will help isolate the source of the section/wkstn update. Preliminary tests show (after the changes were put in place) the cause was isolated to dls5 as the user appeared to be mistakenly updating the fields. Waiting for client's feedback to verify issue is resolved. 04/30/2008 - updated code to correctly handle section/wkstations. 09/27/2007 Here's what I found: 1. Some of the data you added for the 300 series records have spaces at the end of each last_name. Trim the spaces off this data (run the update in the AU-11890-rdvm- query-error.sql script). 2. The CORRESPONDENCE field should be in the values ('E', 'F', 'M', 'N') (run the update in the AU-11890-rdvm-query-error.sql script). You have the value 'Y' entered. The ticket will be noted that a check constraint should be added to the CORRESPONDENCE field (add the check constraint by running the script 11890_uvis_dl_rdvm_chk.sql). 05/05/2008 - added code to handle navigation to the next field properly when the system option for SYSTEM, REPOSITION_OWNER_FIELDS is set to Y. 03/05/2008- code modified to query properly. 05/21/2008 - Updated queries behind Comment LOVs to properly handle Comments (where active_yn = Y) as defined on CLV0011-Comments. 3/3/2008-wr-Corrected errors in the interface triggers that were ignoring re-submitted requests from the Hospital. Note the associated triggers need to be installed in the appropriate instance (HO/UL). 09/03/2008 - cannot reproduce issue using report released below (UVIS release 3.1.10.patch2 on 3/14/2008). 03/14/2008 - Removed Cornell mods that were added to core report dlr0014.rdf and posted in UVIS release 3.1.10.patch2 on 3/14/2008. 03/21/2008 - mods to trigger (uvis_dl_spec_test_x_au_posting) and uvis_dl_pkg.eod_process proc to handle cancelled specimen test records and billing exceptions. 03/27/2008- temporarily increase uvis_dl_billing_exc.billex_tsid field size to number(6). Handle dependent forms/reports ASAP. 10/28/2008- In the attached screen shots, the records displayed on the report have a client_id associated to the exception record. Updated report to display all billing exception records (A null client_id will be displayed as client_id = 0). 04/01/2008-dg- CU- This message is from the UVCL_REQ_ITM_AIU_BIDIR_DAWNING trigger on the uvis_cl_request_items table. The messages are part of exception handlers for panel/profile tests. It looks like it may have been put there for tracing purposes. Removed "insert into uvis_message_log" statements within exception handlers at lines 324, 366, 391, 415 to reduce fluff in uvis_message_log table. 04/30/2008- updated dls1 code to handle insert/update/delete record functionality accordingly as it did prior to 3.1.10. Updated trigger to handle resubmission of rejected requests (from Labs to HO). 5/7/2008-wr-The uvis PL/SQL library was corrected to restore user notification functionality. - The Case Summary (MRS0024) screen was modified to correctly record communication log records. - Modified the Case Search (MRS0001) Discharge Status field to match db column type/size. - Modified the Patient Transfer (PDS0004) so that is does not allow the user to enter an inactive Case # to transfer. - Corrected error on SOAP tab; SOAP comment field size was being exceeded by certain records; expanded the field size and added error handling to alert uer of the condition. 08/15/2008 - Mods to code to handle species_id issue. Also added text "Note" at bottom of Accession level A/I Animal Info tab to help with file format and required fields. 06/05/2008 wp - *************************IMPORTANT******************** Need to create a total of 4 new public database links. 2 for the hospital instance and 2 for the labs instance. They must be named as follows: In the Hospital instance ------------------------ uvis_ho_link - This link needs to point back to the same instance it was created in i.e. the hospital instance. Be sure to use the user UVIS/[YOUR_PASWORD] and make it public. uvis_ul_link - This link needs to point to the labs instance. Be sure to use the user UVISLABS/[YOUR_PASSWORD] and make it public. In the Labs instance ------------------------ uvis_ho_link - This link needs to point to the hospital instance. Be sure to use the user UVIS/[YOUR_PASSWORD] and make it public. uvis_ul_link - This link needs to point back to the same instance it was created in i.e. the labs instance. Be sure to use the user UVISLABS/[YOUR_PASSWORD] and make it public. 9/18/2008-wr-Corrected error found in testing of SEV0024; expanded columns in the underlying tables via 20302_col_mods.sql script and modified field sizes in SEV0024 to match. 8/1/2008-wr-Instead of detailing field level mods to forms on release the Item Prompt Display (SEV0024) screen has been modified to facilitate handling changes in already released forms. The screen layout has been modified to be strictly Module driven. Query filters were added to show only un-translated records if desired. The Insert functionality contains additional Refresh features for existing screens. A Tag field will display the status of records on Insert/Refresh; records will be tagged as Added (A), Deleted (D), Modified (M) or Unchanged (U). The Added (A) tag means a new field has been added to the screen since the translation data was last Inserted/Refreshed and this field will need translation. A Deleted (D) tag means a field was removed from the screen yet a record for that field still exists in the translation table and the user can/should delete that record. NOTE these deleted fields will cause error messages when launching the subject screen with the translation feature turned on. A Modified (M) tag means that the source English prompt was changed in the new version of the 07/24/2008- Changed procedure to use m_tsid as basis for calculating charges, etc. 7/8/2008-wr-The issue was casued by a change in the way Oracle Reports treats parameter form triggers in the 4.0 environment. This change impacts the DESIGNATED_PRINTER functionality (see AU TT # 959) in UVIS. Per discussion in UVIS Proj Mngrs meeting and school feedback this functionality was not being used and is being deprecated to allow for user over ride of Destination Name on report parameter forms. Code to enable this functionality is being stripped out of all modules and any entered setup/module records will be removed fromt the External Devices structure. Defining of Designated Printers for select UVIS reports identified in the relese source and TT # 959 will no longer be an option. 08/01/2008 - updated uvis_dl_pkg.dl_item_pricing to better handle multi-item-pricing. **Directly releated to UGA** Wrote a procedure to cleanse uvis_dl_eod_charges.charge_amt data from original dl_item_pricing's incorrect calculations. 09/04/2008 - added client_type_id for 'OWNER' code before new client insert into uvis_cl_client. 10/01/2008- updated trigger: "TO_NUMBER(SYSDATE,'RRRRMM')" to "TO_NUMBER(TO_CHAR(SYSDATE, 'RRRRMM')). 10/02/2008- removed following line to include records from other uvis_lab_ids (other than just 1): and uvis_lab_id = decode(:p_dlab_id, -99, uvis_lab_id, :p_dlab_id) 10/01/2008- In order to pickup all data (Finalized and Addended), I modified queries to use m_tsid vs. "d_tsid between..." code. 10/09/2008-dg- altered formula columns within report to select data from uvis_cl_patient tables vs. the log table. 10/09/2008 -WiscDLab #20853 Added an activity_message field to the main screen to display the processing points as invoice pdf files are being created. Also set sys option for ACCOUNTING, 0_BALANCE_INVOICE in sync with "Gen Invoices Batch" btn and "Send Inv to File" btn. 11/12/2008 - Updated description for sys option ACCOUNTING, 0_BALANCE_INVOICE. Setting of N now reads: Do Not print invoices with 0 balance. A setting of Y reads: Print invoices with 0 balance. Along with the sys option description updates, dls8 code was updated to be in sync with new vals. ** NOTE ** Double check your system option settings for ACCOUNTING, 0_BALANCE_INVOICE. ** NOTE ** 10/13/2008 - uvis_cl_req_container_dtl.ctn_dtl_id was defined as number(3). Sequence generator exceeded 3 positions and when the 1,000th record was to be inserted an error was raised. Field was extended to number(4) (TSK) and blewout again when sequence attempted the insert for 10,000th record. Script will extend uvis_cl_req_container_dtl.ctn_hdr_id and uvis_cl_req_container_dtl.ctn_dtl_id fields to maximum precision (number). 10/16/2008 - script to correct misspelling of Referral Source on menu. 12/12/2008 - cls4 - Modified form to open without querying records. Also updated code to handle label printing under Print Labels btn. 12/9/2008-wr-Interface was modified under TT # 20433 to use the 'OWNER' client type when creating clients in the lab system for hospital request. UMN was missing that client type in their lab setup tables. Added error handling in the interface to log this missing record to aid in troubleshooting. NOTE all sites need to check that they have a client type of 'OWNER' in their lab instance and if not create one. 1/14/2009-wr-Looking at Oracle reports provided by UMN it appears part of their issue may be missing foreign key indexes casuing unnecessary locks. Added a new procedure (blanket_fk_index) to the uvis_sys_pkg that will create indexes on all foreign key columns that are not already indexed. Calling of this new procedure will be added to the master release script. NOTE that you can call/execute this procedure manually as desired from TOAD or SQL Plus. 02/25/2009- updated trigger to handle uvis_cl_request_items when multiple items are submitted to the Labs from Hospital.
Pages to are hidden for
"Rel_notes_401.xls - Index of"Please download to view full document