EBSX reports

We recommend you use a suitable application to open and analyse the reports, such as a relational database (for example, MS Access), as this will simplify creating the relationships between extracts. Excel spreadsheets may not be able to handle the amount of data in a report.

The supporting files below provide information on the extracts available and how to gain meaningful information. Included is a high level coding document to support information analysts in obtaining advice and guidance data required for the e-RS CQUIN (Commissioning for Quality and Innovation).

Find out further information about the extracts from the e-RS Help (N3/HSCN connection required).

Our translating extracts instructions shows how to decode extract information to make it more meaningful. This is done using a VLOOKUP function within MS Excel. In this example, we're using the EBSX05, generally known as the directory of services (DoS) extract, but the same principles would apply to any of the extracts in the system.

Further advice and guidance information can be gained from the e-RS dashboard (sign up required).

Users with the information analyst role have the ability to request information instantly from e-RS. Find out more in this advice and guidance enhanced reporting information and by reviewing how to translate the extracts.

Information can also be accessed from the system help function.

The following extracts are available to users with the information analyst role on their smartcards. They can be found on the reports section in e-RS. To view extracts in e-RS please use Microsoft Edge, Google Chrome or Mozilla Firefox.

• Up-to-date EBSX03, 04 and 05 extracts which do not contain any Personal Identifiable Data are published on this page
• EBSX02 UBRN action extract - daily and monthly CSV extract of ANY action on a UBRN within a reporting period - available at organisational level and as a national view
• EBSX03 codified fields extract - calendar monthly CSV extract which contains sufficient e-RS reference data for the reporting period that has just ended
• EBSX04 organisational extract - extract of all active organisations within a reporting period
• EBSX05 service extract - extract of all active services within a reporting period
• EBSX06 user extract - extract of all active users within a reporting period
• EBSX08 role profile extract - extract of all active unique user roles within a reporting period
• EBSX12 worklist drop offs - extract of all referrals, from the previous reporting week, that have dropped off the appointment slot issue and appointment for booking worklists, after 180 days of no activity