Summary

The extract contains details of all licences that have been submitted to your licensing authority.

Extract Frequency: A new file is generated every night.

Access: This extract is available on request/prior arrange with the Support@mrl.jitbit.com.

Download: Download from the extract lists via the Extracts menu.

Output Format: The extract is generated as an XML file and compressed as a gzip file (.gz). The file can be uncompressed using an open source tool such as 7zip (or using a licensed tool such as WinRAR or WinZip).

Opening the file in Excel: When uncompressed, the XML file can be opened and viewed using Excel.

•Right-click on the file and select Open With > Excel. An "Open XML" dialog box will be displayed.

•Select the first option titled "As an XML table".

Extract Details

The details included in the file are as follows:

•Report Date

•Licence Code

•Date of Original Application

•Licensing Authority

•Applicant Organisation

•Applicant Reference

•Total Number of Edit Requests To Date

•Current Stage

•Date Application Entered Most Recent Stage

•Current Owner Email

•Last Action Performed By

•Description of Works

•Licence Type

•Location Description

•Validity Period Start Date

•Validity Period End Date

•Applicant User That Submitted The Licence

•Withdrawal Requested

•Guarantee Period Start (date)

•Guarantee Period Expected End Date

•Programme

•Project

•Works Batch

•Engagement