L CCI Picklist subform

The L_CCI_Picklist subform in the ICD10 tab of the Patient Viewer in CCMDB.mdb is used (together with L_CCI_Component subform) to enter the CCI Picklist data for CCI Collection.

Form elements

Header:

• button to sort alphabetically
• button to sort by date

Body:

• CCI_Picklist_Code
• #Duplicator (the "2x" button)
• "*" button to set Px_Date to today
• "+" button to increase Px_Date by one day
• "-" button to decrease Px_Date by one day
• Px_Date
• Px_Type
• Px_Count

Duplicator (the "2x" button)

The 2x button will make a twin of the record on which it was clicked. This is useful for repeat entries like debridements.

Picklist candidates

need to move these over to "CCIs not coded" to make sure we figure them out if they have not been yet, they got lost here...

• SMW

• Cargo

• Categories

Template:Discussion Allan, if you have any, could you put them here so this becomes the master list? Suggestions:

• GI scopes
• coronary angiogram / stent / angioplasty
• CABG
• ERCP
• CXR
• CT brain
• ?MRI's commonly done
• ?Spiral CT
• CVA and CTs- thrombolytics ie tPa-? couldn't find
• EEG's
  • Is it diagnostic interventions on the brain/electrophysiological measurement/external or using external device? It could also be other specific study for line 2, and noninvasively for line 3. Also EEG is not really an intervention, it's a test, so I had a hard time finding it... --Jvelasco 11:19, 2017 December 11 (CST)
• Blakemore tube one day, banding the next day. They will look the same? Ttenbergen 11:52, 2017 December 13 (CST)
• bronchoscopy
• EKG's?
• listing of common bone xrays

Any questions or suggestions about this form in CCMDB.mdb

Please put questions into the specific articles e.g. Px_Date, or general questions into CCI Collection.

Data storage

See CCI Data Structure