Answer the following in detail:
1. SQL is the standard language for relational database management systems. Although all vendors comply with the ANSI (American National Standards Institute) standard for SQL, is there much dissimilarity in the way they implement the standard? What are the ramifications of these dissimilarities? Do you feel that one vendor’s product is better than others because of this?
2. One of the advantages of using SQL is the ability to drill down into the data using functions to generate useful information for our users. What are some of the more common SQL functions, and how would you use them to generate useful information for your organization?
3. Why do managed care organizations seek to establish a provider network? What are the primary reasons for contracting with providers?
4. Describe and discuss the key issues associated with provider payment that should be addressed in any managed care contract.
5. What are the primary categories of utilization management (UM)? How does UM determine medical necessity through the use of evidence-based guidelines?
6. What are the key differences between conventional case management and disease management? Provide some examples of diseases that seem to benefit from a disease management model of care.
7. What are the most important elements of a managed care pharmacy benefit program? And how are patient prescription benefits typically different under managed care?
8. What factors surrounding behavioral health create special challenges and special considerations for managed care programs? How is managed behavioral healthcare different from managed acute medical or managed acute surgical care?
9. Discuss the main elements of the managed care accreditation process. For each main element, explain why it is important.
10. Discuss how managed care sales and marketing have evolved over recent decades, and how these may possibly evolve over the decades ahead.
11. Discuss fraud and abuse in healthcare. Provide at least three specific examples of fraudulent practices that have taken place in U.S. healthcare, and describe ways to prevent these in our modern healthcare environment.
12. Explain the difference between underwriting and rating. What are the key elements that typically go into rate development formulas?
13. What are the most critical components of state regulation for managed care organizations? And which federal regulations also bring specific requirements for the operation of such entities? Discuss state and federal regulation of MCOs.
14. Compare and contrast the differences between pivot table reports in Excel and matrix reports in SQL Server. Are there any limitations in using matrix reports over Excel’s pivot table? What are the advantages of using these reports, compared to standard table reports?