Page History

In a similar way that Users and Courses have custom fields, Totara has now included the option to add custom fields to the different screens, resources and assets associated with the Seminar activity. These fields are added by visiting Site Administration › Seminars > Custom Fields within your Totara LMS site. You can then create new custom fields with a variety of different types and across the different areas areas  associated with the Seminar activity (see below). Please note, custom fields and the Seminar activity are only available in Totara 9 and above. Seminars were added in Totara 9 as an enhanced and rebranded version of the Face to Face activity and so this guide will not work for older versions of Totara LMS.

...

SELECT 
mfr.id AS 'room_id', 
mfrid1.data AS 'BuildingRoom Field 1',  
mfrid2.data AS 'LocationRoom Field 2', 
mfrid3.data AS 'CityRoom Field n'  
FROM  mdl_facetoface_room mfr 
LEFT OUTER JOIN  mdl_facetoface_room_info_data mfrid1 ON (mfr.id=mfrid1.facetofaceroomid andAND mfrid1.fieldid=1)  left
outerLEFT joinOUTER JOIN mdl_facetoface_room_info_data mfrid2 onON (mfr.id=mfrid2.facetofaceroomid andAND mfrid2.fieldid=2)  left
outerLEFT joinOUTER JOIN  mdl_facetoface_room_info_data mfrid3 onON (mfr.id=mfrid3.facetofaceroomid andAND mfrid3.fieldid=3)

 . Seminar custom profile fields are only available with Totara 9 and higher, which was when the original Face to Face activity was rebranded as Seminar.

...