00:00:00.235 --> 00:00:02.415

In this video, we take a look at how users

00:00:02.435 --> 00:00:05.255

of the PAS interface can access reports

00:00:05.515 --> 00:00:08.295

and extract data for reconciliation purposes

00:00:09.385 --> 00:00:11.685

whilst logged into the PAS interface.

00:00:12.445 --> 00:00:13.685

Navigate to the report section

00:00:14.055 --> 00:00:16.605

where you can click on the download planning data button.

00:00:17.275 --> 00:00:20.795

It's in this page where you will see a range

00:00:20.795 --> 00:00:23.995

of available reports with data to view or download.

00:00:25.075 --> 00:00:26.965

Each report provides a description

00:00:27.185 --> 00:00:29.205

to help the user understand the data

00:00:29.505 --> 00:00:31.325

and measures contained in the report.

00:00:32.385 --> 00:00:33.405

The data dictionary

00:00:33.625 --> 00:00:36.125

or metadata for each report can also

00:00:36.125 --> 00:00:37.285

be viewed or downloaded.

00:00:38.275 --> 00:00:41.485

Viewing, or downloading the dictionary provides the user

00:00:41.515 --> 00:00:45.205

with details of the reported data, including the description

00:00:45.345 --> 00:00:48.085

and definition for the various fields and measures.

00:00:50.435 --> 00:00:53.695

To download the data for a selected report, navigate

00:00:53.695 --> 00:00:56.255

to the report and click on the download icon.

00:00:57.175 --> 00:00:59.835

In this example, we want to see key measures

00:00:59.855 --> 00:01:01.515

for all historical records.

00:01:03.045 --> 00:01:06.645

Clicking on the report download option will download a CSV

00:01:06.715 --> 00:01:07.845

file to your device.

00:01:09.035 --> 00:01:11.135

The file can be opened using Excel.

00:01:12.175 --> 00:01:14.905

With the CSV file open, you may need

00:01:14.905 --> 00:01:16.785

to widen the columns to clearly see data.

00:01:17.945 --> 00:01:20.965

Select the entire sheet, hover the cursor

00:01:20.965 --> 00:01:22.885

between some columns and double click.

00:01:23.895 --> 00:01:26.165

Using the filter functions can help when

00:01:26.165 --> 00:01:27.285

searching through the records.

00:01:28.665 --> 00:01:30.605

To apply the filter for all columns,

00:01:30.945 --> 00:01:32.485

select the entire header row.

00:01:32.815 --> 00:01:34.645

Click on the sort and filter option,

00:01:34.645 --> 00:01:36.045

then choose the filter option.

00:01:38.525 --> 00:01:42.015

Once filters have been applied, they can be used to select

00:01:42.015 --> 00:01:45.175

and view a specific data measure range or detail.

00:01:46.235 --> 00:01:47.695

In this example, we want

00:01:47.695 --> 00:01:49.575

to look at a particular set of measures.

00:01:51.085 --> 00:01:53.655

Then use the filters to choose a range of years.

00:01:56.625 --> 00:01:59.325

As we look at the downloaded measures data, in this example,

00:01:59.825 --> 00:02:01.845

we can see that there may be a discrepancy

00:02:01.865 --> 00:02:03.085

in the June period.

00:02:03.265 --> 00:02:06.085

For the estimated cost of works that have been permitted,

00:02:07.905 --> 00:02:10.205

we would need to look at a more detailed report

00:02:10.225 --> 00:02:11.605

to find which application

00:02:12.025 --> 00:02:14.965

or applications may be causing the discrepancy.

00:02:15.985 --> 00:02:18.365

To investigate a potential data discrepancy,

00:02:18.635 --> 00:02:20.885

including a difference between PARS

00:02:20.905 --> 00:02:22.085

and your council system,

00:02:22.545 --> 00:02:25.605

you can use either the three months reconciliation report

00:02:26.345 --> 00:02:27.685

or the all data report.

00:02:28.835 --> 00:02:31.565

Both reports offer comprehensive permit data

00:02:31.705 --> 00:02:32.885

for each application.

00:02:33.945 --> 00:02:36.725

If you choose the all data report, make sure

00:02:36.745 --> 00:02:39.565

to calculate using the permit application ID

00:02:40.025 --> 00:02:41.965

as the distinct record identifier.

00:02:43.195 --> 00:02:46.285

This is important because the report will include multiple

00:02:46.355 --> 00:02:48.365

rows for the same permit application

00:02:48.655 --> 00:02:51.445

where there have been multiple values reported in a single

00:02:51.535 --> 00:02:54.085

field such as zones and overlays.

00:02:55.425 --> 00:02:57.645

In this example, we will be using the three

00:02:57.645 --> 00:02:59.005

months reconciliation

00:02:59.395 --> 00:03:03.245

Data extract to understand which application reported a

00:03:03.405 --> 00:03:05.925

negative cost of works value for the month of June

00:03:06.955 --> 00:03:09.165

with the downloaded data open in Excel,

00:03:09.825 --> 00:03:12.605

adjust the columns in order to see all field data

00:03:13.025 --> 00:03:14.645

and apply filters to the columns.

00:03:16.425 --> 00:03:19.245

We are going to filter the data to see permit records

00:03:19.595 --> 00:03:21.965

that have been determined during the month of June.

00:03:23.025 --> 00:03:26.275

Then search the estimated cost of works field to check

00:03:26.275 --> 00:03:29.495

through the values reported in this report.

00:03:29.915 --> 00:03:31.415

We are provided the permit number.

00:03:32.495 --> 00:03:34.715

If a correction to the submitted data is needed,

00:03:35.095 --> 00:03:37.475

we would update the council's permit system

00:03:37.855 --> 00:03:40.395

and resubmit the corrected permit data via

00:03:40.415 --> 00:03:41.715

the PARS interface.

00:03:43.195 --> 00:03:44.895

For IT, technical assistance

00:03:44.955 --> 00:03:46.135

or further information,

00:03:46.485 --> 00:03:50.895

contact planning support at transport vic gov au.

Page last updated: 29/08/24