Licensing Authority Reinstatement Extract |
<< Click to Display Table of Contents >>
Navigation: Licensing Authority Guide > Reports and Extracts >
The extract contains details of all licences with closed LA Reinstatement surfaces.
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".
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