Patient Info Custom Fields

[boboffice]

Probably an obvious answer but my brain can't figure it out! After creating a custom field (Setup > Family & Insurance > Patient field defs) how and where do I then get the new field I've created to show up? Thanks

[bpcomp]

If you go to the family module and look in the patient information area, your new feilds should show up there. If they don't, go to (Setup/Display Fields/ChartPatientInformation) and move "patfields" from the available column into the showing column. You can now do custom queries.

Code: Select all

SELECT * FROM patfields

will show you all your patfields that have any data in them.

We have a custom field that is a check box for our patients that have requested to be on a short call list. When I run this report, it shows the patients name and their phone numbers.

Code: Select all

SELECT  p.PatNum, LEFT(WkPhone,16) AS WkPhone, LEFT(HmPhone,16) AS HmPhone, LEFT(WirelessPhone,16) AS CellPhone
FROM  patient p 
INNER JOIN patfield pf ON pf.PatNum=p.PatNum
WHERE 
pf.fieldname like '%Short Call List%'
and pf.fieldvalue like '1'
GROUP BY pf.PatNum;

[jsalmon]

If you go to the family module and look in the patient information area, your new feilds should show up there. If they don't, go to (Setup/Display Fields/ChartPatientInformation) and move "patfields" from the available column into the showing column

Correct, they first need to be part of your Display Fields which is where you'll want to go in order to hide, add, or reorder fields that you care about throughout various places in the program. I'm having our website specialists enhance the Custom Patient Fields page to include this information.
You can read more about display fields here: http://www.opendental.com/manual/displayfields.html

[boboffice]

Thank you for the excellent answers. All set!

[Tom Zaccaria]

Nice little query. Very useful.

drtmz