CCL Programming Overview
Clients can use Cerner Command Language (CCL) in a variety of ways. Most clients use CCL to meet their data extraction and reporting needs. CCL can also be leveraged to develop custom CCL services that interact with the standard Cerner Millennium® middleware to read and write information to the database. This can be used in combination with MPages to provide robust capability to store information to the chart.
CCL Programming Services
Many consultants and health system staff have experience using CCL in some capacity, but the level of experience can vary. JASE Health has robust experience using CCL in a wide-variety of ways to serve whatever the need. The most common way to use CCL is custom data extraction and reporting. CCL can be used to feed downstream systems with data in batch or near real-time. With CCL you can access any data that is stored in the Cerner Millennium® data model and format the data to meet any specification.
System performance is paramount when developing CCL extracts. Many clients have experienced first-hand the impact of a poor performing query. CCL programs must be written in the most efficient manner possible, using database indexes to look-up information from the database. When pulling historic information, it can also be challenging to pull a year or more of data. This can be solved by executing the extracts in smaller increments to minimize system resources used by the program.
CCL programs can also be used to interact with the Cerner Millennium® middleware. The middleware is a set of services that read and write to the Cerner Millennium® data model. CCL programs or services are often used with MPages to read or write information from within a MPages component. Another common use for CCL services is in conjunction with Discern Expert Rules. Rules can be triggered on pre-defined conditions to alert users to important information. The CCL services can be called to collect and present information within the alert dialog.
CCL Programming Projects
JASE Health has experience to meet your unique CCL programming needs. Below are a few examples of the type CCL projects we’ve done.
- Created extracts to feed a wide range of clinical data to downstream systems, include both historic data and ongoing updates
- Developed services used by MPages components to save problem and diagnosis information to the patient’s chart
- Launched a web application from a Discern Expert Rule using a CCL program