This report can be run for a specific period of time (defaults to show active works in the last 3 months).

Tip: To include planned works, set the To Date to the relevant future date.

The report is generated as an excel file and contains the following details:

•Licence Code

•Licence Type

•Licensing Authority

•Application Organisation

•Current Stage

•Licensing Area

•Location Description

•Purpose of Works

•(Block) Start Date

•(Block) End Date

•Works Types

•Status

The works status will be reported as one of the following:

•Draft: Works block created but not yet submitted for approval

•Submitted: Works block has been submitted for approval

•Approved: Works block has been approved

•Active: Works block has been activated

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.

How often is it generated: Nightly.

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