CCMDB Wiki

CCI Collection: Difference between revisions

← Older editNewer edit →
mNo edit summary
JMojica (talk | contribs)
CCMDB_legit, admin, approved, Administrators
2,815 edits
No edit summary
(62 intermediate revisions by 5 users not shown)
Line 1: Line 1:
This article provides general information about collecting and coding a [[CCI Procedure]].   
This article provides general information about collecting and coding a [[CCI Procedure]].   


They are entered in [[CCMDB.mdb]] in the [[Patient viewer tab CCI]] on the [[Patient viewer tab CCI]].
They are entered in [[CCMDB.accdb]] in the [[Patient Viewer Tab CCI_Pick]] and [[Patient Viewer Tab CCI_Comp]] on the [[Patient Viewer]].


There are some [[ICD10 Diagnoses and CCI Codes that need to be coded together]]. For background information, see [[CCI]] and [[Reasoning around moving to CCI and our subset of it]].
For background information, see [[CCI]] and [[Reasoning around moving to CCI and our subset of it]].


== Collection instructions ==
== Collection instructions ==
===Start Date: Jan 1, 2019 ===


=== Determining if the procedure you found is one we collect ===
=== Selecting and entering [[CCI]] procedure in [[CCMDB]] ===
Here are the '''rules''' for what we '''will'' code:
==== Procedures done outside the unit ====
Include ''all '''[[List of CCI procedures we don't code|codable]]''' procedures'' that meet the definition of one of the [[Px Type]]s that are done '''outside the patient’s unit'''.
 
==== Procedures done on the unit (endoscope or non-therapeutic) ====
Include '''all of the following '''[[List of CCI procedures we don't code|codable]]''' procedures''' done on the unit:
**(a) any procedure that '''uses an endoscope''' -- whether inserted through an orifice, incision or wound
**(b) all [[List of CCI procedures we don't code|codable]] '''[[Diagnostic Procedure]]s'''
**(c) all [[List of CCI procedures we don't code|codable]] '''[[Imaging Procedure]]s'''
**(d) all [[List of CCI procedures we don't code|codable]] '''[[Obstetric Procedure]]s'''
**(d) all [[List of CCI procedures we don't code|codable]] '''[[Miscellaneous Procedure]]s'''
 
==== [[CCI Procedures coded once per ward admission]] ====
Some procedures are only coded the first time they happen. See [[CCI Procedures coded once per ward admission]].
 
=== Don't code sub-procedures that are part of a larger procedure ===
Do not code a procedure that is part of a "Bigger" procedure already coded.
'''Example:''' In the course of many or most CABG surgeries, there is placement of chest tubes, pacer wires, and vein harvest, but do NOT code those procedures separately, since they are "included" in the CABG code.
 
=== Before You Decide to NOT Code a Procedure ===
*We're not looking to code procedures that not either: (a) on the picklist, or (b) able to be constructed from it's components [e.g. a body part, and what was done to that body part].
*The main issue here is that among the lists "what was done", we haven't included EVERY possibility.
**For example, in the Imaging Procedures, besides some plain X-rays contained in that picklist, the "what type of imaging study was done" does NOT include plain x-rays.  Thus we're not enabling creation of a plain X-ray of other body part other than those contained in the picklist.
**Similarly, for the Therapeutic Procedures, there is a list of approximately 30 items of "what was done" to the chosen body part. So some items of "what was done" are not available and you won't be able to code such procedures. 
***'''BUT, before you decide this is the case, you will need to become very familiar with the descriptions of EACH of the "what was done" items that ARE available'''.  For example the item '''[[Bypass]]''' includes creating a ostomy (which includes a colostomy and even a tracheostomy).
****See '''[[CCI component 2 codes - what was done]]'''
 
=== [[Aborted Procedure]] ===
*See [[Aborted Procedure]] for how to code
 
== Selecting and entering [[CCI]] procedure in [[CCMDB]] ==
Follow these steps, in this order:  
Follow these steps, in this order:  
# for every procedure:  
# for every procedure:  
Line 45: Line 15:
##* pick the left column, [[CCI component 1 codes - what organ was something done to]].
##* pick the left column, [[CCI component 1 codes - what organ was something done to]].
##** if there are too many and you only want to see e.g. the therapeutic ones and not the imaging ones, use the [[L_CCI_Component_subform#CCI_Chooser (the "?" button)]]. In the form it opens you can filter by the [[CCI Category]].
##** if there are too many and you only want to see e.g. the therapeutic ones and not the imaging ones, use the [[L_CCI_Component_subform#CCI_Chooser (the "?" button)]]. In the form it opens you can filter by the [[CCI Category]].
##* in the column on the right, pick the [[CCI component 2 codes - what was done]].
##* in the column on the right, pick the [[CCI component 2 codes - what was done]]; the component on the right has to be of the same ''diagnostic / therapeutic / imaging'' kind as the component 1 - if you try to mix types you will get an error.  
## whether CCI picklist or CCI component,  
## whether CCI picklist or CCI component,  
### enter a [[Px_Type]] - "admit" ([[Admit Procedure]]) or "acquired" ([[Acquired Procedure]])
### enter a [[Px_Type]] - "admit" ([[Admit Procedure]]) or "acquired" ([[Acquired Procedure]])
Line 51: Line 21:
### enter a [[Px_Count]] - the number of '''separate''' times it was done''' '''''on a given day
### enter a [[Px_Count]] - the number of '''separate''' times it was done''' '''''on a given day


=== Repeated procedures ===
==== productivity features ====
If a procedure is done repeatedly '''on the same day''', only enter it once but count it in [[Px_Count]].
To reduce clicks to enter same Picklist entries for additional days, there are some extra buttons:
* "x2" will duplicate this line with the next date
** "+" and "-" will up or down the date by one day, to make the copy more useful
* [[Blue button in CCI Picklist]] will fill a range of dates


Procedures done on a '''different''' day should be entered again with a different date. This should be really quick by using the "duplicate" button.
== Collection modes ==
<!--As discussed [[Task_Team_Meeting_-_Rolling_Agenda_and_Minutes#ICU_Database_Task_Group_Meeting_.E2.80.93_October_31.2C_2018]] -->
*We code CCI procedures in 5 different [[CCI Collection Mode]]s''':
{{:CCI collect each}}
{{:CCI collect count each}}
{{:CCI collect count days}}
{{:CCI collect count units}}
{{:CCI collect first}}


=== Related Imaging, Diagnostic and Therapeutic procedures performed at the same time ===
=== List of CCI Elements and their collection modes ===
Some intervention are both diagnostic/imaging and therapeutic. For those situations, only code the therapeutic part.
{{Collapsable
| always= picklist
| full=
{{#ask: [[Has CCI Picklist Code::+]][[Has StopDate::>{{CURRENTDAY}} {{CURRENTMONTHNAME}} {{CURRENTYEAR}}]]
|?Has CCI Collection Mode
|format=broadtable
|link=all
|limit=1000
|class=sortable wikitable smwtable
}} }}
{{Collapsable
| always= component 2 list
| full=
{{#ask: [[Has CCI 2 Code::+]][[Has StopDate::>{{CURRENTDAY}} {{CURRENTMONTHNAME}} {{CURRENTYEAR}}]]
|?Has CCI Collection Mode
|format=broadtable
|link=all
|limit=1000
|class=sortable wikitable smwtable
}} }}


For endoscopic inspection/explorations, code only the '''"furthest/deepest"''' area assessed.
== Special Cases ==
=== No Procedures Performed ===
If no procedures were performed '''enter [[No procedure performed]] as an [[Admit Procedure]] with a [[Px Count]] of 1 into the [[CCI Picklist]]''', the top of the tab. Do not enter any procedrues into the CCI Component section, ie leave it as "[[No procedure entered]]". Entering this will mean at least one CCI entry is present when [[Query check CCI must have entry]] checks that entering procedures was not just forgotten.


Examples:
=== Moved patients ===
* for a [[Coronary angiogram (diagnostic cardiac catheterization)]] where [[Coronary angioplasty with stenting]] happens in the same sitting, only code the [[Coronary angioplasty with stenting]].
*There are important issues/rules for admit procedure coding when a patient is being transferred from one unit/ward to another unit/ward -- and this is even more complicated if in between leaving one unit/ward and arriving on another unit/ward, the patient stops in a procedure area and gets one or more procedures.
* if a tissue [[Biopsy (non-endoscopic)]]/[[Biopsy (endoscopic)]] is done as part of an invasive [[Inspection, Exploration (non-endoscopic)]]/[[Inspection, Exploration (endoscopic)]] code only the [[Biopsy (non-endoscopic)]]/[[Biopsy (endoscopic)]].
*Here are the guidelines for these situations:
* If a CT is done on the abdomen, chest and pelvis, enter 3 entries in the component area?
**(i) Transfer from collecting location A to collecting location B without any stop in between where procedures might occur -- all procedures done before leaving location A will be collected by location A only.
**(ii) Transfer from collecting location A to collecting location B WITH a stop in between where procedures occur -- all procedures done before leaving location A will be collected by location A only, while procedures done at the stop in between will be coded by location B only.
**(iii) Transfer from noncollecting location A (which includes ED) to collecting location B without any stop in between where procedures might occur -- any qualifying admit procedures done before leaving location A will be collected by location B
**(iv) Transfer from noncollecting location A (which included ED) to collecting location B WITH a stop in between where procedures occur -- all procedures done before leaving location A or during the stop in between will be coded by location B only.


=== We are not tracking all possible procedures ===
=== Procedures we don't code ===
We are not tracking all possible procedures; see [[Reasoning around moving to CCI and our subset of it#Why do we not include the entire set of CCI codes]] and [[List of CCI procedures we don't code]] for more info.
We are not tracking all possible procedures. If a procedure can not be coded using the picklist or combined method, then we likely are not interested in coding it.  


=== No Procedures Performed ===
See [[List of CCI procedures we don't code]] for procedures we explicitly don't collect. If you come across a procedure you were not able to code, but think we probably should be coding, please note it [[List of CCI procedures we don't code|there]].
If no procedures were performed you still need to enter something so we can test that procedures were not just forgotten. Enter [[No procedure performed]] as an Admit procedure into the [[CCI Picklist]], the top of the tab.


=== Procedures not coded ===
See [[Reasoning around moving to CCI and our subset of it#Why do we not include the entire set of CCI codes]] and [[List of CCI procedures we don't code]] for more info.
See [[List of CCI procedures we don't code]]


==Date Integrity Checks ==
=== Don't code sub-procedures that are part of a larger procedure ===
*Do not code a procedure that is part of a "Bigger" procedure already coded.
'''Example:''' In the course of many or most CABG surgeries, there is placement (or replacement) of chest tubes, pacer wires, arterial lines, central lines, and vein harvest, but do NOT code those procedures separately, since they are "included" in the CABG code.
*On the other hand, things done in OR that are NOT part of the standard procedure (e.g. for someone coming out from OR after CABG who now has ECMO, Swan-Ganz, IABP), you SHOULD code these as [[Admit Procedure]]).


=== Must have at least one entry ===  
=== Related Imaging, Diagnostic and Therapeutic procedures performed at the same time ===
{{Data Integrity Check
*When at the same sitting both diagnostic and therapeutic procedures are done, then CODE THEM BOTH
| DIC_summary = every patient ward admission must have at least one [[CCI Procedure]](which might be [[No procedure performed]])  
{{ex|*  a cardiac cath is done and then a stent is placed -- code the diagnostic cath and the therapeutic stenting.
| DIC_related_concepts = [[CCI_Collection]], [[No procedure performed]]
* for an [[Angiogram, coronary (diagnostic cardiac catheterization)]] where [[Angioplasty, coronary (with stenting)]] happens in the same sitting, code both}}
| DIC_firmness = hard check
* if a tissue [[Biopsy (non-endoscopic)]]/[[Biopsy (endoscopic)]] is done as part of an invasive [[Inspection, Exploration (non-endoscopic)]]/[[Inspection, Exploration (endoscopic)]] code both
| DIC_timing =
*When multiple procedures are done at one sitting, code them all
| DIC_app = CCMDB.mdb
{{Ex|if a CT of chest, abdomen and pelvis is done, code them all}}
| DIC_coding = how to find this in containing program, eg. SAS file, function name, query name...  
*For endoscopic inspection/explorations, code only the '''"furthest/deepest"''' area assessed.
| DIC_status = ready to implement
| DIC_implementation_date = date change was rolled out / first applied
}}


Will need to be implemented: to click complete:
=== [[Aborted Procedure]] ===
* must have a other than [[No procedure performed]]
*See [[Aborted Procedure]] for how to code
* code [[No procedure performed]] if there were no procedures
*[[Px_Date]] for the Acquired procedures cannot be before [[Accept DtTm]] or [[Arrive DtTm field|Arrive DtTm]] and/or after the [[Dispo DtTm]].


=== CCI Procedure vs [[Previous Location]] Cross Check ===
=== Repeated procedures ===
{{Data Integrity Check
If a procedure is done repeatedly '''on the same day''', only enter it once but count it in [[Px_Count]].  
| DIC_summary = If from OR or PACU, must have at least 1 [[CCI Procedure]]
| DIC_related_concepts = [[CCI Procedure]], [[Previous Location]]
| DIC_firmness = hard check (not allowed) or soft check (allowed, but give error; in CFE this means it has to go into the ... table, and cross checks have to consider that table)
| DIC_timing =
| DIC_app = CCMDB.mdb
| DIC_coding = how to find this in containing program, eg. SAS file, function name, query name...
| DIC_status = needs review
| DIC_implementation_date = date change was rolled out / first applied
}}
{{Discuss | who = all | question =
* is this actually a reasonable cross-check? What would be a false positive for this? }}


=== Component CCIs must have compatible component 1 and component 2 ===
Procedures done on a '''different''' day should be entered again with a different date. This should be really quick by using the "duplicate" button.
{{Data Integrity Check
| DIC_summary = Component CCIs must have compatible component 1 and component 2
| DIC_related_concepts = [[CCI Procedure]]
| DIC_firmness = hard check
| DIC_timing = complete
| DIC_app = CCMDB.mdb
| DIC_coding = how to find this in containing program, eg. SAS file, function name, query name...
| DIC_status = needs review
| DIC_implementation_date = date change was rolled out / first applied
}}
It is possible to enter a Component 1 from e.g. diagnostics and a component 2 from e.g. imaging. This should be impossible in the first place, but making that happen in CCMDB.mdb turned out quite complicated, so has not been implemented. We need to have a cross check that disallows combining codes from different groups.  


==Data Integrity Checks ==
{{Collapsable
| always= List of cross-checks
| full= {{#ask: [[DICSummary::+]] [[Category: CCI Px check]]
|?DICSummary = summary
|?DICStatus = implementation status
|sort=DICStatus, DICSummary
|default=No corresponding old article found
|format=broadtable
|limit=100
|link=all
|headers=show}} }}


== Related Articles ==
== Related Articles ==
Line 126: Line 116:


== related literature ==
== related literature ==
[https://secure.cihi.ca/free_products/Coding%20standard_EN_web.pdf CIHI.ca coding standard CCI]
[https://secure.cihi.ca/free_products/CodingStandards_v2018_EN.pdf CIHI.ca coding standard CCI]




Retrieved from "https://ccmdb.kuality.ca/index.php?title=CCI_Collection"