Background This study explores potential data mining applications in the Casemix context, which is expected to yield effective and efficient health care services. The objective of work focuses on determining hidden relevant patterns which can’t be processed by human capabilities all alone. California Drug and Alcohol treatment Assessment (CALDATA) of administrative type database can be relevant study for the medical diagnosis in usage of alcohol and drugs for patients admitted and discharged during the stay in hospital to discover knowledge for recovery process.