Maxlenght of titile in layout - HELP!

weechie wrote on Saturday, May 17, 2014:

I have loked everywhere in the forum but I wasn’t able ti find the solution.

Is there a way to increase the maximum number of characters I can insert in the Title in the Layout form?

When i go to Administration–>List–>MyNewList–>Title, I can insert up to 63 characters, however I need to be able to insert up to 85 - 90 characters, how do I do that?

mdsupport wrote on Sunday, May 18, 2014:

Using long list names may cause some of the screen layouts to look strange. But if you must,

  1. Enter smallest, meaningful key description to create a new list - ‘list 90’ which will be stored as ‘list_90’.
  2. Using Admin->Other->Database interface, browse list_options table
  3. Click edit and enter the following search query:

SELECT list_id, title FROM list_options WHERE list_id=‘lists’ and title=‘<step 1 entry>’

  1. Press ‘Go’. Results will appear in EMR window.
  2. Click on the edit/pencil to enter up to 255 characters of ‘Title’
  3. Save.

weechie wrote on Sunday, May 18, 2014:

Thank you for replying, however I am still not able to change the value. What I need to do is to have the title inside a list (not the title of the list itself) to be able to host a 255 characters, so longer than 63.

So to make it simple: let’s say i go to Administration–>List and I create a new list “New_List” then i want to populate this list; the default fields are:

ID / Title / Order / Default / Notes / Code(s)

What i need to change is the max length of (column) Title

So for example, instead of

EDIT LIST: NEW_LIST

ID / Title / Order / Default / Notes / Code(s)
1 --ABC----- 3 ------n.a.------test-----n.a.—

(where ABC is a word made of 63 chars)

It should be:

EDIT LIST: NEW_LIST

ID / Title / Order / Default / Notes / Code(s)
1—XJYKZ---- 3 ------n.a.------test-----n.a.—

(where XJYKZ is made of 255 chars)

Is this possible?

mdsupport wrote on Sunday, May 18, 2014:

It is hard to imagine why label would be that long unless you are describing a situation that user is expected to check off. In those situations it is better to use the notes field that offer templates feature for large formatted texts.

Of course you can always change title column definition in layout_options table from 63 to whatever or explore use of extensions - specifically T.

fsgl wrote on Sunday, May 18, 2014:

What is the purpose of a list wherein each item is a paragraph long? If you describe in detail what you wish to achieve, we will be able better to tailor the suggestions.

A list in clinical practice provides a quick selection of fixed terms arranged in a group. It defeats the purpose of a list to have to read entire paragraphs prior to selection.

One does not go to the grocery store with a pack of index cards; each describing the milk, the cheese, the eggs, etc. One goes with a shopping list.

So, what is it that you want to accomplish?

weechie wrote on Sunday, May 18, 2014:

Ok sure.

I am trying to create a custom form for mental health treatments. If a patient wants to pay with her insurance we have to send an itemized bill, a superbill including the diagnosis and treatment codes. A diagnosis like

“F31.63 - Bipolar disorder, current episode mixed, severe, without psychotic features”

does not fit in the title column.

To be more specific, I am trying to create a custom form for “progress notes” where we can log, for each visit the following fields:

full name, date, CPT code, ICD-10 code, notes, if the session was rescheduled/canceled/skipped,…

Now, the idea is this: because the Diagnosis (ICD code) and the treatment (CPT) are likely to be the same for the first weeks, it makes sense to create a list from which a clinician can select among 10 most used codes.

So to do that I have created a LBV, and was trying to populate it with custom lists. Two of these lists are ICD and CPT codes which require more than 63 chars.

fsgl wrote on Sunday, May 18, 2014:

Would strongly recommend reading the Users Guide.

It is not necessary to have the ICD and CPT codes in the body of the clinical notes. They are only necessary in the superbill and Fee Sheet.

No one, not physicians, billing clerks, or insurers bother with the long descriptions of the codes on a daily basis. Just pick and use the correct codes.

The Billing Manager will handle the insurance claims once everything has been properly set up.

weechie wrote on Sunday, May 18, 2014:

Thanks fsgl, I think I was able to manage it from the fee tab and I can see all the psychopathology listed there, thanks!

Still unsure on how to proceed on one more thing: when i try to add a CPT code I get no results of any kind.

Do i need to install a CPT list/database?

fsgl wrote on Sunday, May 18, 2014:

Glad to oblige.

You need to install the CPT codes in one of 3 ways.

Does the practice want the entire CPT data set? See this section of Code Types to find out how.

Most practices need only those codes referable to their own specialty. I’m certain that the practice does not want Ophthalmology procedure codes. Each desired code can be entered manually from Administration->Codes with a fee for each.

A third way is to bum it off a friend from the same type of practice using OpenEMR via a .sql or .csv file and import it in phpMyAdmin.