March 2008

Line Void Queries

Kristen opened up the discussion with some great ideas she has been using in regards to line void queries. Some of the better queries discussed were the following:

Other things that were discussed were what could create false positives or identified as training issues, such as cashiers incorrectly performing price verify or price inquiry functions. Knowing your companies POS capabilities is important when looking at how to structure your queries and whether you can see all item voids, post voids, or mid-void transactions.


Database Administration Partnership - "Database Trust"

There was a brief discussion about building that partnership with your database adminstor and gaining credibility from then in making an effort to learn about the database or improve coding skills, often times this will help in getting things done in relationship to your application as well as support for some additional upgrades or enhancements that are ongoing. It can also help when building joins whether within the application or within the database and to improve the speed of running queries by working with your DBA or gaining access so that editing can be done to either improve the SQL code or do more indexing. Part of gaining credibility is being trusted by your DBA to take care of the database and make in better. Several members had websites that are helpful in improving technical skills in regards to this. Charles offered up sites www.tek-tips.com and www.sqlservercentral.com , Bill also added a few sites to visit that might be helpful: www.techonthenet.com/oracle/functions/index.php and www.sql-ref.com.


Case Management, Measuring Performance, and ORC

During the remainder of the call we touched on a few other topics, one was looking at case management systems and how members are using or not using them to provide statistics on their EBR performance. There weren't too many companies who were doing a lot of analysis on their EBR vs. non-EBR cases. There was differing results in regards to whether companies found greater or lesser admisssion quantities with EBR vs. non-EBR cases. There were a few companies that were able to analyze thier Inventory results/Cycle counts and POS Over/shorts through there EBR applications and what might be a good future topic for further discussion was to use the case management application to generate EBR Awareness letters as part of a Letter Program.

For ORC there was some discussion of what types of queries could be built in the EBR applications that would better identify ORC related activity. Some of the query ideas were as follows: