CCI Collection
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.
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.
Collection instructions
- We code CCI procedures in 5 different collection modes:
Collecting "CCI collect each" items
- "CCI collect each" items are entered each time they happen
- Px Date
- if an Acquired Procedure, enter the Px Date for each day that they happen
- if an Admit Procedure leave the date blank
- Px Count
- if they happen more than once on a day, enter the number of times for that day, otherwise enter a Px Count of 1
Collecting "CCI collect count each" items
Blood gas, arterial, and Blood gas, venous are only collected manually at the Grace, at HSC or STB they are automatically uploaded from DSM Lab Extract.
- "CCI collect count each" items are entered as counts of how often they occurred
- Px Date
- if an Acquired Procedure, enter the Px Date of the first time they happen
- if an Admit Procedure leave the date blank
- enter the total number of times the procedure was done as Px Count. If it happened as an Admit Procedure and as an Acquired Procedure, enter separately.
Collecting "CCI collect count days" items
- "CCI collect count days" items are entered as counts of how often they occurred
- Px Date
- if an Acquired Procedure, enter the Px Date of the first time they happen
- if an Admit Procedure leave the date blank
- enter the total number of days on which the procedure was done, even just for part of the day, Admit Procedure and each Acquired Procedure of this type as Px Count
- this data is cross-checked by query check_CCI_vs_LOS_count_days_component and query check_CCI_vs_LOS_count_days_picklist
Collecting "CCI collect count units" items
- "CCI collect count units" items are entered as counts of how often they occurred
- Px Date
- if an Acquired Procedure, enter the Px Date of the first time they happen
- if an Admit Procedure leave the date blank
- enter the total number of units that were administered for each Admit Procedure and each Acquired Procedure of this type as Px Count
Collecting "CCI collect first" items
- "CCI collect first" items are entered the first time they happen
- Px Date
- if an Acquired Procedure, enter them with the Px Date of the first time they happen
- if an Admit Procedure leave the date blank and just enter the procedure
- Px Count is always 1 for this collection mode
List of CCI Elements and their collection modes
component 2 list | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Selecting and entering CCI procedure in CCMDB
Follow these steps, in this order:
- for every procedure:
- check if the procedure is listed in the CCI Picklist in the L_CCI_Picklist subform which is the top half of the CCI screen. Select from drop down list.
- if not available in CCI picklist, enter it in the CCI Component in the L_CCI_Component subform which is the bottom half of the CCI screen.
- 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.
- in the column on the right, pick the CCI component 2 codes - what was done.
- pick the left column, CCI component 1 codes - what organ was something done to.
- whether CCI picklist or CCI component,
- enter a Px_Type - "admit" (Admit Procedure) or "acquired" (Acquired Procedure)
- enter a Px_Date - Date of procedure for acquired px only
- enter a Px_Count - the number of separate times it was done on a given day
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.
We are not tracking all possible procedures
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.
Before You Decide to NOT Code a Procedure / Procedures not coded
We did not include all possible CCI codes. If a procedure can not be coded using the picklist or combined method, then we likely are not interested in coding it. 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 there.
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.
Related Imaging, Diagnostic and Therapeutic procedures performed at the same time
Some intervention are both diagnostic/imaging and therapeutic. For those situations, only code the therapeutic part.
For endoscopic inspection/explorations, code only the "furthest/deepest" area assessed.
Examples:
- for a Angiogram, coronary (diagnostic cardiac catheterization) where Angioplasty, coronary (with stenting) happens in the same sitting, only code the Angioplasty, coronary (with stenting).
- 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).
- If a CT is done on the abdomen, chest and pelvis, enter 3 entries in the component area?
Aborted Procedure
- See Aborted Procedure for how to code
Repeated procedures
If a procedure is done repeatedly on the same day, only enter it once but count it in Px_Count.
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 Checks
summary | implementation status | |
---|---|---|
Query check CCI TISS CAM positive vs Dx | Checks that each T9 - CAM positive (TISS Item) goes with an ICD10 code from Category:Delirium | declined |
Query NDC Dialysis TISS CCI | Critical care patients who have CCI entries for a type of dialysis must have a TISS28 entry for the same type of dialysis as well, and vice versa. | declined |
Check CRF vs ARF across multiple encounters | If a patient had a comorbid of CRF in any previous admission then ARF can not be an admit or complication in subsequent admissions. | declined |
Query check CCI TISS time means must be two | If certain Px Dates have a time component, then there should also be a matching CCI Picklist without the time | declined |
Query check TISS each day | There needs to be at least one TISS entry in CCI Picklist for each day for each ICU profile. | declined |
Query check CCI component 1 and 2 compatible | Component CCIs must have compatible component 1 and component 2 | implemented |
Query check CCI vs LOS count days picklist | Confirm that CCI Collection Mode for CCI Picklist CCI collect count days items don't have a count > LOS. | implemented |
Query check CCI vs LOS count days component | Confirm that CCI Collection Mode or CCI Component CCI collect count days items don't have a count > LOS. | implemented |
Query check CCI TISS if no then none | If No TISS Item (TISS Item) in CCI Picklist there must be no other entry from TISS Item List in CCI Picklist, and vice versa | implemented |
Query check CCI if no then none | If No procedure performed in CCI Picklist there must be no other entries in CCI Picklist or CCI Component | implemented |
Query check CCI from OR no CCI | If from OR or PACU, must have at least 1 CCI Procedure other than No procedure performed | implemented |
Query check CCI TISS matching BoardingLoc time | If the Px Date component of a CCI Picklist has a time, then there must be a corresponding Boarding Loc entry | implemented |
Query check ICD10 trach has trach but no TISS | If there is a Tracheostomy, has one (Z93.0) ICD10, there should likely be a T23 - Trach Tube Present (TISS Item) | implemented |
Query check ICD10 trach create but no TISS | If there is an acquired Tracheostomy creation there also has to be a Trach Tube Present (TISS Item) | implemented |
Query check CCI Component duplicates | No duplication of CCI Component Px_Type, Px_Date | implemented |
Query check CCI Picklist duplicates | No duplication of CCI Picklist Px_Type, Px_Date, Px_Count | implemented |
Sub Dx Checker | Runs most Category:Old_dx_check, Category:ICD10 Dx check, Category:CCI Px check, and a few other checks for dxs | implemented |
Query check CCI TISS NrDays GT LOS | There are more TISS Item Px_Dates than there are days between the first Service tmp entry and Dispo DtTm | implemented |
Query check CCI TISS NrDays LT LOS | There are more TISS Item Px_Dates than there are days between the first Service tmp entry and Dispo DtTm | implemented |
Query check CCI must have entry | There must be at least 1 CCI entry in L_CCI_Picklist table (which might be No procedure performed) | implemented |
Query check CCI Component no admin entries | There must be no No procedure entered/Blank procedure entry in CCI Component. | implemented |
Query check CCI Picklist if no admin entries | There must be no No procedure entered/Blank procedure entry in CCI Picklist. | implemented |
Query check ICD10 trach dxs consistent | Tracheostomy related CCI and ICD10 codes must be consistent with each other. | implemented |
Query check CCI Component unfilled | CCI Component entry with missing px, Px_Type or Px_Count | implemented |
Query check CCI Picklist unfilled | CCI Picklist entry with missing px, Px_Type or Px_Count | implemented |
Query check CCI Date | Px Date must be sensible when compared to first Service tmp entry and Dispo_DtTm | implemented |
Query check eliminated CCI Comp | disallows any currently entered diagnosis that has been eliminated | implemented |
Query check eliminated ICD10 | disallows any currently entered diagnosis that has been eliminated | implemented |
Query check eliminated CCI Pick | disallows any currently entered diagnosis that has been eliminated | implemented |
Query check CCI each count vs LOS | Confirm that a Category:Labs Imaging count is not unreasonably high | needs review |
Query check CCI CRRT vs Tmp | If CCI CRRT (incl volume removal via PRISMA device) exists there should be a tmp CRRT entry and vice versa | retired |
Query NDC TISS CCI endoscopic | If pt has T26 & 27 - Endoscopy (TISS Item) then there must be an endoscopic CCI for that day. | retired |
Query NDC cardioversion dx vs TISS | If pt has Acquired Procedure Cardioversion (EXCLUDE defibrillation-we are not tracking), then the TISS28 item T26 & 27 - Cardioversion (TISS Item) (T41) must be marked. | retired |
Query NDC zCRRT CCI Px but no TISS | If there is a T33 - CRRT (TISS Item) then there should be a CRRT (incl volume removal via PRISMA device) CCI Px | retired |
Query NDC zCRRT TISS but no CCI Px | If there is a T33 - CRRT (TISS Item) then there should be a CRRT (incl volume removal via PRISMA device) CCI Px | retired |
Query NDC Trach Dx TISS | Tracheostomy ICD10s and CCIs must be consistent with Trach TISS. | retired |
Related Articles
Related articles: |
|