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.
...
In the top corner of every tab, there are these two icons:
This icon takes you to our knowledge base articles | |
This icon takes you to the support portal where you can ask CSNSW questions about this report or any other systems we operate. |
Tab Options Within The Report
...
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.
[External Ref No in PPSD] = Yes indicates if the External Ref No has already been attached , = No indicates the External Ref No is a possible match.
The columns that have anomalies will appear in Red font so the user can easily review them.
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 |
Grades do not match | Matched students are in different grades in PPSD and CeNET |
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 |
Gender does not match | Gender in Student Management and CeNet file are different |
More than 1 attribute do not match | Anomaly in more than 1 attribute eg DOb and Last Name, or Grade and FirstName |
Matched ExternalRefNo missing in CeNET Student file | The External Ref No attached to student is missing in CeNET’s file . There could be many reasons - Student has left school, issue in data export to CSNSW |
The Student Data Anomalies report should ultimately be blank.
...
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.
...