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