CCI Collection Mode

CCI Collection is done in one of several "modes", meaning whether each procedure is coded, or only a first or counted coding is done. The different modes we use are CCI collect first, CCI collect each, CCI collect count each, CCI collect count days, CCI collect count units, N/A, CCI collect each day.

Collection instructions for each mode

The relevant instructions are automatically also listed on each CCI element's wiki page.

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 not manually counted at HSC or STB sites, as it is 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

Collecting "CCI collect each day" items

• "CCI collect each day" 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
  • enter 1 regardless of how many times a day the procedure happened
• this is usually the collection mode for TISS28 items, see TISS28 Collection Guide, and for some items that have replaced TISS items

Collecting "CCI TISS" items

See TISS28 Collection Guide/Change to collect TISS data in CCI Picklist

Implementation

• created Property:Has CCI_Collection_Mode to store the collection mode for each CCI
• updated Template:CCI PickList Procedure and Template:CCI 2 Procedure component to populate and show Property:Has CCI_Collection_Mode
• created the pages CCI collect first, CCI collect each, CCI collect count days, CCI collect count units, CCI collect count each to contain collection instructions for each mode that redirect to template pages of the same name
• created Template:CCI Collection Mode and applied it to all relevant CCI pages to show the correct instruction based on Property:Has CCI_Collection_Mode
• created the following templates to provide collection instructions for each:
  • Template:CCI collect each
  • Template:CCI collect count each
  • Template:CCI collect count days
  • Template:CCI collect count units
  • Template:CCI collect first
• created this page to tie it all together
• created query s_CCI_Categories_Collection_Mode in CCMDB.accdb to store this info to be able to list it on L CCI Picklist subform.