Adding non standard field to report

[clinicoffice_user]

In our Staff Details data entry screen we have a “non standard” data field that was added when our system was first set up back in May 2010. It contains a numeric unique ID number used by the University for official identification.

University of Greenwich ID (Screengrab attached)

I would like to include the details from that field in one of our reports. The report is one that shows Staff by their Security Access Groups

SQL Source is

select staff.id, staff.id as staff_id, staff.knownas as _knownas, staff.username, staff.jobtitle,
staff.accgrp_id, accgrp.name as _access_group, staffcat_id, staffcat.name as _staffcategory
from staff
left join accgrp on staff.accgrp_id=accgrp.id
left join staffcat on staff.staffcat_id=staffcat.id
where (staff.deleted <> true)

Two questions really:-
1) How do I find the database ID/name for this non standard field?
2) How so I add this field to the report

Regards
Tony Taylor
ESO Maidstone

[Author]

Posts