We have created a short Walk-Through presentation that takes you through the report tabs one by one. If you prefer the “static pictures, no sound, and reading” option, keep scrolling as the rest of this page describes what’s in the video.
PLEASE NOTE: The data used in the report is old data from our QA environment. All personally identifiable information has been blurred out.
...
This TAB gives a visual diocesan snapshot of PRIMARY DISABILITIES by Disability Category
from the PPSD section.
...
...
Student Data Anomalies
The Student Data Anomalies report shows possible student data issues after our data matching process has been completed.
Where student data between CSNSW and the CeNET data matches 100%, student data has been matched and CEIDER numbers have been attached. This now leaves the ones that aren’t a 100% match.
The report displays student data from the CSNSW Student Management (PPSD) system and CeNET’s data along with a possible reason for why the match didn’t happen as a 100% match.
The table below shows the full range or reasons:
Data Issue-Summary | Data Issue-Detail |
LocationIds Do not match | Matched students have different LocationAgeIDs |
AGEIDs do not match | Matched students have different AgeIDs |
Both AGEID and LocationAGEID do not match | Matched students have different AgeIDs and LocationAgeIDs |
DOB in PPSD in 2023, 2022 | Student's date of birth in Student Management is in 2023 /2022 |
DOB do not match - Grades match | Matched students have different date of births, but are in the same grade |
DOB and Grade do not match | Matched students have different date of births and different grades |
Firstname and Lastname are swapped | Firstname is matched with Lastname and vice versa |
Firstnames do not match | Matched students have different Firstnames |
Lastnames do not match | Matched students have different Lastnames |
Firstname, LocationAgeId do not match | Matched students have different Firstnames and LocationAgeIDs |
Lastname, LocationAgeId do not match | Matched students have different Lastnames and LocationAgeIDs |
The Student Data Anomalies report should ultimately be blank.
The best way to work through the report is to export and then first fix any data issues that can be fixed through the CSNSW Student Management system.
Once you have done this, the automatic data matching process will run and then the data in the PowerBI report will be updated every 2 hours (between 7am and 9:00pm). As the data changes in our system, the reports should get shorter.
To export the data:
Open the report in PowerBI
Select the Student Data Anomalies tab on the left
Click the 3 dots as indicated in the image below
Select “Export Data” from the menu
...
Once you have downloaded the report, please review the first column: [Data Issue]. Based on the Student's external reference number from CeNET (CeNET_ExternalRefNo column), one of the following will be true
Scenario 1: Student matched correctly but the student data in PPSD is incorrect; spelling mistakes, DOB differences
Scenario 2: Student matched correctly but the student data from CeNET is incorrect
Scenario 3: Student not matched correctly at all
Scenario 4: Student data is correct, but the student name contains a preferred name also;
For each case, please take the appropriate action as below.
Scenario | Action to be taken by Diocese/Schools | Populate [Action Needed] column of the report |
Scenario 1: | Update Student details in Student Management | Correct CeNET_ExternalRefNo - Student details in Student Management updated |
Scenario 2: | None | Correct CeNET_ExternalRefNo - No updates to Student Details |
Scenario 3: | Provide correct Student External Ref No in column [Correct Student External Ref No] | Incorrect CeNET_ExternalRefNo - Correct External Ref No provided |
Scenario 4: | None | Enter “Correct Student” in “Action Needed” column |
Please make sure you populate the [Action Needed] column for each student in the report.
Only if necessary, populate the [Correct Student External Ref No] column so we can make the updates to the database at our end.
Once you have completed the above steps, in the interest of keeping student personal data secure, please use the Alteryx upload portal to send the files back to us for processing.
If you’re unsure how to do this, please refer to this knowledge base page for help:
https://csnsw.atlassian.net/wiki/spaces/APP/pages/459374609/Upload+Unique+Student+ID+Data+Securely
As we receive the data files, we will make the necessary changes at our end and the “Student Data Anomalies” and the “Students Missing CEIDER” reports will get shorter as the automated matching process makes the student connections. Once all incorrect data issues have been fixed, the remaining students listed in the “Students Missing CEIDER” report will need to be addressed.
How Do I Capture A Report?
Click on FILE and select what function you would like to do – PRINT, EXPORT to POWERPOINT, EXPORT to PDF. This will replicate the report as it appears on your screen.
...
How Do I Export The Table As An Excel File?
In the top right-hand corner of any table there are three icons – click on the THREE DOTS (…)
Select EXPORT DATA
...
3. Select SUMMARIZED DATA
...