2003 Release Notes

• 2.0.12 - 12/11/2003
  • Added support for dreProviderGroups.display column. HealthTrio Patch.
  • More XHTML 1.1 migration.
• 2.0.11 - 12/6/2003
  • GLOBAL: Did a lot of conversion of HTML4 to XHTML1.1. You may notice some minor changes in page formatting.
  • SEARCH: Added Medical Group to provider search results. (prov dpt)
  • SEARCH: You can now search members by medicaid number (claims dpt)
  • SEARCH: When searching, the criteria area resizes dynamically based on what you're searching for.
  • PM160: Fixed a bug causing a 500 internal server error when you try to Submit a PM160 for an currently ineligible member.
  • PM160: Added BMI to the PM160 Form (also to the PM160 viewer)
  • AUTHS: The PadProvider function has been removed from the new request form. E.g. you can no longer just enter P42 and have it automatically convert to P00000000042. This is necessary for HealthTrio compatibility.
• 2.0.10 - 11/7/2003
  • There's been several "quick changes" and publishes since the last described release here.  I'll try and touch on them all.
  • We has some problems with the EDI upload pages.  This was caused by an untest-able change to the edi-save page.  This pages logging was changed from an insert statement to an sql stored procedure shared with Tim's EDI File Conversion utility.  Other transient changes made the testing of this difficult and thus some errors got through.  I think this is all in order now.
  • I've finally has some time to proceed with a dynamic Letter creation tool for DRE users.  This is not complete, and not available to users yet, but a big chunk of the code it there, and it should be ready for testing in coming weeks.
  • The HPSJ claims department has begun testing the PM160 data entry tool and has provided outstanding feedback.  This feed back has lead to many of the changes I'll describe now:
    • CHDP item 11 has been removed.
    • The form will now show the members name / lob, and provider's name when entered into the form.  Note, this does NOT work the same as the New Request screen.  It does NOT show these values just by 'tabbing' out of the field.  You must search members / providers, or click the 'Save / Verify' button.  This will check the form and show member name / provider name on the form.
    • A new 'Lookup PM160s' button has been added to the 'New PM160 Form' toolbar.  This will allow you to search for previously entered PM160's and view all associated data.
    • There's more coming in this area....
• 2.0.9 - (publish 94) 10/31/2003
  • DreMail - When viewing any inbox, the blue header now displays the name of the inbox you're currently viewing.
  • DreMail - The "move" button now works when viewing a message.  So you now have the capacity to create your own folders and move mail to and from them.
  • Minor changes to the edi webservice, as well as the DRE edi upload pages.  (sp_DRE_COM_Edi_History stored proc implemented)
• 2.0.8 - (publish 93) 10/27/3003
  • Performance modifications have been made to the "Request Processing History" table DREAuditTrail.
    • The move of the ActionReason column from dreAuditTrail to the external table dreReasonCodes is complete, saving 96 bytes of data per record (currently about 500,000) in the audit trail table, as well as making indexing this data way more efficient.
    • The ActionNotes column in dreAuditTrail has been changed from data type 'text' to datatype 'varchar(2000)'. This should save lots of space, and be much more efficient.
    • The ActionType column is halfway to being moved to and external lookup table.  This update will have all new inserts to this table populate both the ActionTypeId column, as well as the ActionType (char(50)) column.  Once in place, the next update will make all other lookup use the ActionTypeId column instead of ActionType.  This should save about 46 bytes per record as well as make the querying of this column much more efficient when indexed.
  • Fixed a bug causing the "Confidential Notes" checkbox to not actually mark the record confidential in some rare conditions.
• 2.0.7 - (publish 92) 10/7/2003
  • Two new permissions have been added to dreActivities.  9 - Search Request, and 10 - Search Patients.  These permission dictate if a user see those associated links on the left dre frame. (mtyler)
  • Fix a bug in the request editor.  All edits should have been setting export = 1 upon saving a request so they'd update Diamond, (or xpress, or whatever). (drogers)
  • The make determination permission will now additionally control whether the user gets the 'Transfer To' combobox at the top of their inbox.
  • New reason codes table, dreClaimsReasonCodes for claims reason codes lookups. The affects the reason code popup dictionary. (drogers)
• 2.0.6 - (publish 91) 9/26/2003
  • There's been a lot of work on reason codes for xpress compatibility, as follows:
    • All never-used reason codes have been removed from the reason codes table.
    • A couple new codes have been added.
    • Reason codes are moving to an internally unique key in DRE (auto-int column) all DRE supporting tables that referrence reason codes will use this new number scheme.
    • The reason code table now sports a 'status' field which will allow us to obsolete reason codes without removing them from the table. (for referrencial integrity)
    • The provider's Appeal screen, now has reason codes populated from the DREReasonCodes table.
    • These upgrades will require several code publishes to syncronize the database changes with code changes, and I'll let you all know when these occur.
• 2.0.5 - (publish 90) 8/19/03
  • Primary Procedure no longer required field for internal staff. External users must enter a primary procedure for treatment auth requests. (vbatten)
  • New 'Current Contract' checkbox on the search provider screen specifically allows you to filter search results based on a providers current eligibility for each line of business.  Until now, term'ed providers were unfiltered, now, by default they are.  Uncheck this box perform provider searched as before.  This will be used as we load the rest of the Xpress providers into DRE:  Xpress providers will be effective 10-1-03 at which time diamond providers will be term'ed. (demerson)
  • A ton of new back-end updates to the coming online PM160 form.  Thanks for the help on this Debra!   (demerson/jsonderm)
  • New mail search functionality in DRE Secure Mail.  Notice the new "Search Mail" link on the options area.  This lets you search all past e-mail that's been sent to you, even mail you've deleted.  Currently only the subject line is searched. (demerson)
• 2.0.4 - (publish 89) 8/8/03
  • 'Speciality' typo on request summary form. (lrhed)
  • When viewing a message in DRE Mail, the text comprising the body of the message now wraps properly. (demerson)
  • 'New Folder' option has now been implemented in DRE Mail. (demerson)
  • July03 Formulary updated. (ashek)
  • Primary procedure code field is now only required for Non-Admit Authorizations. (jbraun)
  • Further development of the PM160 entry and export tools. (jsonderm)
  • LOB and BedType fields added to all inpatient census reports (bhill)
  • Emergency Rx Supply Form added to the documents section of the provider homepage (lreynold,ashek)
• 2.0.3 - (publish 88)
  • Fixed bug in copy user function.  It hadn't been converted to use the new md5 password function. (ssmith)
  • Primary Procedure field is now required for Authorization type requests. (ssmith)
  • Provider Alerts have a new field, "Alert Category" with selections like: Informational, Education/Event, Formulary Update, Procedural Update.  These will be used to automatically update the "provider education" portion of our public website. (lreynold)
  • Edit / Remove options on the Bed Days forms were converted from links to buttons to provide IE5.0 compatibility. Necessary for our Terminal server some users use for DRE access. (kbarcenas)
• 2.0.2 - (publish 87)  7/22/2003
  • Fixed the popup dialog that should have been apearing at login to alert users their password would expire soon.  Once again if you use a password to login, you'll be alerted every time you login within 5 days of the day your password will expire.  (demerson)
  • Claim Comment form will now send comments to the claims manager through DREMail. (demerson)
  • Feedback form will now send comments to internal users through DREMail. (demerson)
  • There's been a couple modifications to the user editor.  For external users, a combobox of linked providers is shown, this is read only, but there is also, a new "Provider Group" button, that will take you to their provider group editor.  For internal users, this combobox displays the UM Groups the user is currently subscribed to, and this list can be edited in the same way permissions are edited. (demerson)
• 2.0.1 - (publish 86)
  • [Member Name] and [Member Id] fields shown at the top of every Patient Dossier page. (ashek)
  • Member Dossier claims listing page query moved to a stored procedure. (demerson)
  • Intake / History notes will now be displayed on the 'verify request' page when entering a new request. (ssmith)
  • There's now a field to store users phone number on the user editor screen. (ssmith)
  • All passwords are now encrypted with the MD5 security provider to help facilitate .net conversion.  (demerson)
  • External user notes, and deferral responses will now come to staff through the DRE Mail interface. (demerson/pstuebner)
  • .net foundation
    • Some conceptual architecture for the .net implementation of DRE has been complete.  Work has been done on some of the foundation classes DRE will use, and web services DRE will offer.  None of this affects any of the existing DRE code base currently used by it's users.  Yet.  (demerson)
    • A security class has been built with verifyLogin, and changePassword methods.  Along with this most code has been written to migrate password encryption to a standard MD5 encryption.
    • An Edi webservice is in the works that uses much of the .net code now being written. It will act as a gateway for a coming provider-side edi conversion tool. (jsonderm)
  • These release notes were getting long, so version 1's release notes are on a separte pages accessed by the link at the bottom of this page. (demerson)
• 2.0.0 - (publish 85)
  • DRE has been moved to a new Compaq Evo Server, and is now being hosted by Microsoft IIS Server 5.0. (akremer)
  • There is little new development in this release, however this publish marks the beginning of the port of DRE to c# for the .net framework.  This rewrite will greatly enhance DRE's ability to interoperate with other systems, and will ultimately enable the expantion of DRE to PDA's and other wireless devices in the future. (demerson)
  • Minor bug fixes from the previous release were fixed.  Specifically, many actions were resulting in 404 (page can not be found) errors. (demerson)
• 1.6.5 - (publish 84)
  • New Request form - the Claims Comments field will not show up to external users. (ssmith)
  • New online PM160 entry form available. This is very beta, and not ready for production use.  (jsonderm)
  • Request Summary form - The users names under processing history can now be clicked on to send a DRE Mail message to that user. (demerson)
  • Request Summary form - There is now a light-bulb icon next to each users name in the request processing history indicating if that user is currently logged into DRE or not.  This is not 100% accurate, but will generally be correct. (demerson)
  • Some restructuring of the DRE folder structure / organization.  All pages to create, edit and view requests are now in a uniform requests folder. (demerson)
• 1.6.4 - (publish 83)
  • A new mail sub-system has been integrated into DRE, and is currently available through the Mail option on the left option bar.  This system is currently considered in beta-testing, however I do encourage it's use and exploration.  Eventually all DRE notifications, and user feedback will occur through this mail system as it will provide a way for external users, to communicate will staff bi-directionally. (mtyler/jbraun)
  • But you like getting DRE notifications through Outlook?  Once notifications are moved to this system, there will be an option available to HPSJ staff to have their DRE mail forwarded to their Outlook inbox.  This option is not yet available.
  • Bug fix keeping providers from submitting notes. (ssmith)
  • Doctor's professional title will be added to their names on the provider search details screen. (dbowen)
• 1.6.3 - (publish 82) 5/27/2003
  • Modifications to the Level of Care editor:
    • All referrences to 'bed type selection' have been renamed to 'Auth Type' selection.
    • Auth Type selection list is now limited to just those that are applicable to inpatient stays.
    • New, true, 'Bed Type' selection box has been added in addition to the auth type field.  This is done to facilitate the population of Health Trio's Bed Days tables.  Available options match the currently available options in Xpress's auth module.
    • Minor cosmetic changes to the interface.  e.g. form is now left aligned on the page, standard xp-style 'X' close button added to all leve of care screens.  standard style sheet added to all LOC screens.
  • When entering a new request, existing alerts will now be shown to the user.
  • Fix erronious referrence to dreCCS in sp_DRE_COM_Member_Authorizations.  This should finally obsolite the dreccs table.
• 1.6.2 - (publish 81) 5/22/2003
  • M&R Guidelines were updated to v3.3. (minor update) (jsonderm)
  • Login security revision.  Internal users using the Intranet auto-login, will only be validated against Internal users when authenticated.  e.g. if NT user demerson tries to auto-login, and a DRE account exists for demerson, but it's a external provider account, the auto-login will now fail, rather than auto-login the internal user into the external users account.  In instances when this occurs, internal users will need to login manually into DRE with a different username that does not match their NT username. (demerson)
  • The new request form will now force all inpatient requests (admit=Yes) to automatically select request type 'authorzation'.  Likewise if a new request is set admit=yes / request type=auth, and you try to set the request type to referral, it will automatically re-set admit value to 'no'.  more simply:  all inpatient requests should be marked as an authorization, the form will now require it. (demerson / xpress constraint)
  • Related to above-  The request editor will only let you edit the Request Type value for outpatient requests.  Request type is not optional for inpatient requests.  (demerson)
  • Added a purdy dark blue header bar to the new request screen, like the request editor has. (demerson)
  • When searching for a provider by name, DRE will now search both the provider name, as well as their medical group. (ssmith)
• 1.6.1 - (publish 80) 5/9/2003
  • A previous publish this week fixed a javascript date validation in the set alert screen replacing them with a server-side date validation. (pstuebne)
  • Toolbar behaviour have been slightly modified for external users.  This affects the toolbar as seen when viewing a request.  This behaviour is based on the current processing status, and admit yes/no field of the request you're viewing, and affects if the external user has the option to appeal the request.  The specific behaviours are as follows:
    

    	Inpatient	Outpatient
    Appealed	Can Appeal	Can Appeal
    Approved	Can Appeal	Can Appeal
    Denied	Can Appeal	Can Appeal
    Cancelled	Can Appeal	Can Appeal
    In Review	No Appeal	No Appeal
    Discharged	No Appeal	N/A

• 1.6.0 - (publish 78) 4/11/2003
  • Client side date validation is now performed on any date-type supplemental alert fields. (demerson)
  • The Level of Care screen is now Mozilla / Netscape compatible. (demerson)
  • Complete client-side validation is now performed upon submitting the Level of Care screen. (demerson)
  • On provider homepage, only the five, most recent static reports will be displayed.  A link now appears below these five, linking to a full listing of available reports.  List quires were additionally converted to stored procs.  (Some users with access to many providers had unbearably long static report lists.  (demerson)
  • M&R Guidelines 8th Ed. have been installed replacing most of the old guideline sets.  The 2001 Pediatric Guidelines were left in place since it appeared the new 8th Ed. did not include this information.  (demerson) 
• 1.5.8 - (publish 77) 4/10/2003
  • In the statistics area, CCS reporting has been removed, and a new option, "Alert Reporter" has been added.  This script will allow those with access to perform queries on any currently used alert. (demerson)
  • In the security administration area, an new "alert editor" is now available for creating new alerts and editing/adding new supplemental alerting detail fields. (demerson)
  • The "UMO Group" screen in security administration now shows the number of staff currently with access to each group. (demerson)
  • The "UMO Group" screen in security administration now allows the administrator to create new groups from the interface.  New groups have traditionally had to be created by manually editing the DREGroups table. (demerson)
  • The Hedis Projector module now has an updated, and bookmarked Hedis criteria, or Hedis definition / description page that is viewable by clicking on any of the Hedis measure names. (jsonderm)
  • The property, or criteria of being a 'CCS request' will no longer have an impact on the actions, and fields updated when making a determination on a request. (i.e. if you cancel a ccs request, the diamond status will become 'C' no matter what.)  (jbraun)
• 1.5.7 - (publish 76) 3/25/2003
  • New generic, dynamic, "Alerts" subsystem is now in place which will consume the roll of the CCS Details screen and make it easier to setup new alerts (such as VMRC, Case Management, etc.) in the future.  This new system is to make DRE more flexible, and less HPSJ centric.  Here's the details...
    • No "CCS Details" button anymore, it's been replaces with a "Set Alerts" button.
    • On any request, if you click this button, you're presented with a list of possible alerts you set for this request.  For example you can select CCS, or Reinsurance, etc.
    • Once you select an alert, you're presented with that alert's information form.  Every alert form works just like the CCS Details form has worked in the past where you have a check box up top which represents whether that alert is active for the that particular request.  Checking this box will enable or disable the supplementary alert fields shown below this checkbox.  NOTE:  Like the current CCS Details form, if an alert is active for a particular request, and you uncheck that alert, and save, all supplementary alert information will be lost.
    • Once an alert is set you will be returned to the alert selection screen from which you can edit other alerts, or exit back to the request.
    • Like with CCS Details, alerts will be displayed on the top of each request summary, as well as any other alerts that have been selected in the past for that particular member.
    • The CCS Details table have been also removed from the Request Summary.  Alert details may be added back in the future if needed.
  • Client-side scripting on Provider Alerts editor converted from vbscript to javascript for mozilla compatibility. (demerson)
  • Improved javascript syntax on Custom Guideline editor for mozilla compatibility(demerson)
  • Cleaned up javascript in the Guideline viewer for better mozilla compatibility (demerson)
  • Fixed a bug causing Benefit Dossier to not work. (ssmith)
  • Fixed a bug causing the Chart Sheet to not work under certain circumstances. (ssmith)
  • Provider's downloadable member roster has been modified to include Hedis projection data (jsonderm)
• 1.5.6 - (publish 75) - 3/12/2003
  • Bugfix - "Chart Sheet" or the multi-eligibility tool has been fixed. (ssmith)
  • Bugfix - Member History lookup module is now working again. (vbatten)
  • The new Request Type field is now editable from the request editor (pstuebne)
  • The request editor now pulls it's place of service list from DREPos table rather than static list. (demerson)
  • Bugfix - error on claimsbydateengine.asp fixed.
• 1.5.5 - (publish 74) - 3/12/2003
  • Bugfix - getting error when approving requests (pstuebne)
  • Bugfix - Appealed requests showing as "Current Status: A" on request summary (demerson)
• 1.5.4 - (publish 73) - 3/7/2003
  • Request editor will no longer show a blank screen when you click 'Apply Changes' when no changes were made. *
  • Replaced dbo.speciality, with DRESpecialty, and my necessary code changes. *
  • The state list is now populated on the provider search form. *
  • In Security Administration, the Create User, and Edit User forms are now a single unified form page.  Reduces code duplication, and enforces the use of more stored procedures. (demerson)
  • When an inpatient request is either Denied, or Cancelled from the 'Make Determination' screen, all associated Level of Care date-spans will be marked 'Denied' for this auth. (mjordan)
  • The Request Summary screen has a new field toward the top, "Current Status" listing values such as, Approved, Denied, Cancelled, Deferred, and In Review.  Inpatient requests, than have been approved, but are not yet discharged, will read, "Initial Request Approved - See Below" (mjordan)
  • POS drop-down now populated from DREPOS table, rather than static page, and POS value will now get saved as soon as it's selected.
  • All DRE Inboxes are now populated from the stored procedure sp_DRE_COM_Inbox.  This will hopefully disolve the disappearing inbox anomolies we experienced this week. (demerson)
  • New "Request Type" field on the New Request screen which specifically marks a request as either a referral, or a treatment auth request.  This will aide both reporting as well as the DRE = > HealthTrio migration. (mjordan)
  • Note: Items marked with * were issues discovered during the SCFHP installation.
• 1.5.3 - (publish 72) - 2/11/2003
  • Fixed bug not allowing authtype to be edited on request editor.  Related to LevelofCare > BedDays conversion introduced in v1.5.0. (pstuebne)
  • Modification of Levels of Care now automatically update actual days / auth days and denied day on the request.  This has one exception.  If more days have been approved than are currently enumerated in the level of care screen then the higher value of the two will be stored on the Auth itself.  (demerson)
• 1.5.2 - (publish 71) - 2/5/2003
  • Discharge screen now checks that all Levels of Care have a determination. (demerson)
  • Discharge screen now counts same day from/thru dates as 1 day (lrhed)
  • Discharge screen now scans all from / thru dates for invalid dates prior to allowing discharge. (demerson)
  • Added Provider Id to Search Details on Provider Search (ssmith)
  • More backend DRE* conversions:
    • cptcodes => DRECptCodes,
    • icd9codes => DREIcd9Codes,
    • jauthsm0 => DRELegacyAuths
    • sp_DREAuthListings => sp_DRE_STAT_Auth_Listings
  • New CPT / ICD9 Code Editor on the Security Administration menu. (demerson)
  • New Custom Guidelines Support (scarlisle)
    • In guidelines, new option "Custom Health Plan Guidelines" gives all users access to these guidelines.
    • Guidelines can be edited through the Guidelines editor from the Security Adminsitration menu.
  • It's been discovered that when logging in, password validation is not case sensitive.  Simply, if your password is "Toast", when logging in "toast", or "tOAst" would also work.  This has been fixed and passwords must be entered with the same case as when created. (mtyler)
• 1.5.1 - (publish 70) - 1/29/2003
  • Processing time report modified giving priority totals. LOB criteria added. (mjordan)
  • Verify screen added to account copy tool. (ssmith)
  • Census reports modified for the new DREBedDays table. (UM)
  • "Bed Days" icon renamed back to "Level of Care" (mjordan)
  • Member Dossier > Rx List change: Pharmacy added, Days Supply removed (ashek)
• 1.5.0 - (publish 69) - 1/23/2003
  • The DRELevelOfCare table is being replaced by the DREBedDays table listing date spans rather than day count integers.  (i.e. authdays, actual days, deny days)
  • The Level of Care screen has been updated to modify the new table.
  • The Discharge Screen no longer accepts altered discharge dates.  It will now be edited from the Bed Days screen.
  • DDE, the DRE to Diamond Export application has been completely rewritten in c#.net for this major modification to the way inpatient cases are stored.
  • A Visual Basic application has been used to convert all old Level of Care data to the new DREBedDays format.
  • NOTE:  There still need to be modifications to the current census reports for the new table format.  They will not be accurate until the next publish v1.5.1.
  • NOTE:  Additional validation logic will be added in the 1.5.1 relese to disallow discharge with no edited bed days.  There will also be embedded notification if you add approved bed day spans that exceed the number of authorized days.

For earlier Release Notes click here.