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

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