Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

Rel_notes_401.xls - Index of

VIEWS: 25 PAGES: 222

									TICKET       CUSTOME TITLE       REL_SOURCE
             R
         973 AU      Radiology   *****3.1.10.1.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                    3.1.10.1.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             3.1.10.1.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
                                                ---------------------------------------------
                                                -----------
                                                3.1.10.1.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 3.1.9.8                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 - 3.1.10.8     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 - ver3.1.10.8       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 - 3.1.10.12   MRS0024
20509 NCSU   MRV0010 - identical questions-3.1.10.12   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 - 3.1.10.13       MRR0031




20738 NCSU   MRS0024-Estimate field-3.1.10.13          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     3.1.10.1.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 3.1.9.6
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 3.1.9.6
Problem is still occurring, even with pharmacy items that have a
sales Qty of zero.
12/15/2006 - RDA - Version 3.1.9.6
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 3.1.9.8, sequence 0 is not being
generated. But, only one test is coming over to Clin Path for
resulting. (3.1.9.8 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 3.1.9.8, 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 3.1.9.8
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 <wendell.riley@rossgroupinc.com>
To: Cathy French <clf16@cornell.edu>


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:clf16@cornell.edu]
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 3.1.9.8 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 3.1.9.8, 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.
3.1.9.8 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 - 3.1.10.9
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 3.1.10.16.

===================================
10/09/2008 LL UVISDM - 3.1.10.14 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
3.1.10.15 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.
3.1.10.12 - 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 - 3.1.10.14 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 3.1.10.14
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, 3.1.10.15 -patient 4334
2/2/2009-da-Changed ticket type to Debug

--- Original ---
UVISINT 3.1.10.15, 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 3.1.9.8, sequence 0 is not being
generated. But, only one test is coming over to Clin Path for resulting.
(3.1.9.8 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 3.1.10.1.
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 - 3.1.10.5 - 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 - 3.1.10.10
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.

								
To top