Not All Training is the Same!
The majority of Cerner clients send their programmers to Cerner for CCL
training. They do it because it makes sense that the software vendor would have a good course.
The CCL training provided by Cerner
teaches what it claims to teach. You are taught how to write a basic CCL script, how to query
the database and how to create and use record structures. In truth, the Cerner
CCL course is setup very similar to the training
courses for other programming languages such as Java and Visual Basic.
While this style of training is the typical norm, there are two major problems with it. First,
the student is never taught when and why they should use certain functionality (they are just
taught how to use it), and secondly the student doesn't get the opportunity to work on
a realistic example report that encompasses all of the course material (instead they are given
simple examples meant to demonstrate a single topic).
This is where the training from Precision Healthcare Solutions differs from our competition.
We teach our students how to write CCL programs
for the real world. We show them when and why functionality should be used as well as point
out CCL features that should not be used or used
under very specific circumstances.
Through the progression of the course, we also show the student how to write a report using
the advanced techniques that our consultants use to create fast executing and easy to
maintain reports. By the end of the class, our students will have developed a complete report
from start to finish themselves.
One Low Price
All of our training is performed at your hospital site on one of your non-production domains.
We charge a fixed price of $7,500 USD plus travel expenses for our five day training session.
Class sizes are limited only to the training space you have available.
Course Materials
Each student will receive both a printed and electronic version of the course notes along with
the Precision Healthcare Solutions Advanced CCL Manual.
The Advanced CCL Training manual is documented in a
reference book style and contains detailed documentation on many of the topics in the training
course along with topics that are not covered (e.g. Adding reports to Powerchart and Operations).
Course Topics
The following topics are covered in our CCL training class:
- Brief introduction to CCL (back-end vs. front-end)
- Select statements and join types (Basic Join, Outerjoin, Dontcare, Dontexist)
- Nested select statements
- UAR Functions and Code Values/Sets
- Indexes and optimization
- Using Discern Visual Developer
- Compiling a CCL report
- Adding prompts to a report
- Sorting data and report grouping
- Creatining include files
- Record structures and proper usage
- Using Layout Builder for report presentation
- Calculating dates and times