The extracts in e-RS contain a wealth of useful information to support organisations in understanding referral volumes, workflows and actions. Information analysis knowledge is required to get the best out of these extracts, but in order to help those who have some analysis skills, this guidance aims to show how to decode one extract, using information from a different, supporting extract.
The instructions below show how to decode information from an extract to make the information more meaningful. This can be done by using a VLOOKUP function within Excel.
In this example we are using the EBSX05, generally known as the Directory of Services (DOS) extract, but the same principle would apply to any of the extracts in the system.
Where to find information
To understand the following points, review the ‘Extracts’ information within the information analyst section of the system Help (N3/HSCN connection required):
- the related extracts needed for translation
- what information each extract is made up of
- the data contained within the extract columns
The extracts used in the example we have used are produced monthly and can be accessed from within e-RS (by users with information analyst roles on their smartcards) or from the reports and extracts webpage.
The information shows where the extracts can be found:
Extract name extract locations within e-RS and e-RS website
- EBSX03 codified fields extract
- EBSX04 organisational
- EBSX05 service extract
Extract name extract locations e-RS website
- EBSX02 UBRN action extract
- EBSX06 user extract
- EBSX08 role profile extract
Last edited: 7 September 2021 8:27 am