CCI Collection: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
Line 102: | Line 102: | ||
{{:CCI collect first}} | {{:CCI collect first}} | ||
=== List of CCI Elements and how they are collected === | === List of CCI Elements and how they are collected === | ||
{{Collapsable | |||
| always= picklist | |||
| full= | |||
{{#ask: [[Has CCI Picklist Code::+]][[Has StopDate::>{{CURRENTDAY}} {{CURRENTMONTHNAME}} {{CURRENTYEAR}}]] | {{#ask: [[Has CCI Picklist Code::+]][[Has StopDate::>{{CURRENTDAY}} {{CURRENTMONTHNAME}} {{CURRENTYEAR}}]] | ||
|?Has CCI Collection Mode | |?Has CCI Collection Mode | ||
Line 108: | Line 111: | ||
|limit=1000 | |limit=1000 | ||
|class=sortable wikitable smwtable | |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 | |||
}} }} | |||
==Data Integrity Checks == | ==Data Integrity Checks == |
Revision as of 11:21, 19 December 2018
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
Determining if the procedure you found is one we collect
- There are THREE subsets of procedures we 'will code
- Procedures done outside the unit
- Procedures done on the unit including an endoscope
- A select group of other procedures done on the unit.
(A) Procedures done outside the unit
Include all codable procedures that meet the definition of one of the Px Types that are done outside the patient’s unit.
(B) Procedures done on the unit (endoscope or non-therapeutic)
- This includes both diagnostic and therapeutic procedures done with an endoscope -- and that scope may be inserted through an oriface, incision or wound.
- Includes all of the following codable procedures done on the unit:
(C) Other on-unit procedures
- (b) all codable Diagnostic Pxs
- (c) all codable Imaging Pxs
- (d) all codable Obstetric Pxs
- (d) all codable Misc Pxs
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).
Aborted Procedure
- See Aborted Procedure for how to code
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
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.
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?
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.
|
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.
Procedures not coded
See List of CCI procedures we don't code
Proposed tweak
As discussed Task_Team_Meeting_-_Rolling_Agenda_and_Minutes#ICU_Database_Task_Group_Meeting_.E2.80.93_October_31.2C_2018:
- After discussion we recognized that we will need to create machinery to code 3 different categories of such procedures:
- (i) Those coded every time they occur -- recorded with dates. Example is EGD
- (ii) Those for which we mainly want total counts -- record the first date in which done, plus the total count over the entire admission. Example is CXR, ABG. For this one there is needed software/data entry “machinery” that Tina/Trish/etc will talk about offline.
- (iii) Those for which we would ‘’prefer’’ the # of days on which it was done. Examples are noninvasive mechanical ventilation, dialysis, ECMO. However, after discussion we decided that in order to reduce the workload on the data collectors, we will only collect the date of the first use. We could reconsider adding # of days for these at a later point in time.
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 how they are collected
component 2 list | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
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: |
|