| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
1 | ||||||
2 |  | |||||
3 | SYNERGETIC SCHEMA MAP | |||||
4 | ||||||
5 | Introduction to Intellischool Intellischool provides data automation, management, warehousing, and analytics services to K-12 schools. Where a customer is using Intellischool as a data warehouse service, copies of data from your systems will be stored in your private cloud data warehouse, secured and managed by Intellischool. For more information about how Intellischool secures and manages your data, visit our Help Centre. | |||||
6 | ||||||
7 | The purpose of this document We understand that not all of our clients use Intellischool for data warehousing purposes, and instead only use our platform for our Analytics product. In such cases, customers may wish to redact information being stored on Intellischool's platform in accordance with data management best practice. We also highly recommend completing the required configuration to support longitudinal analytics in Synergetic prior to commencing any work on redacting data. This document notes what data is required by Intellischool Analytics and/or Pulse. Our Help Centre includes documentation on how to redact some (or all) data that isn't required by Analytics or Pulse. Where a field is marked "can be made available through Creator", this field is not extracted by default and will only be stored in your Intellischool data warehouse if requested. | |||||
8 | ||||||
9 | A note on data duplication / columns exposed multiple times Where data is exposed to Intellischool through multiple tables and/or views, Intellischool will usually only extract that information from a single source, and then use the appropriate identifiers to create joins between objects in the Intellischool data model. However, we recommend keeping fields that are exposed across multiple tables/views available to ensure that partial synchronisation can occur without needing additional joins or extracts. | |||||
10 | ||||||
11 | NOTE: If following the guide to create a view database, please also deploy the Function DDL code contained in TAB 2 of this spreadsheet. Please make sure to set the database to deploy the code to in the script. | |||||
12 | ||||||
13 | TABLE/VIEW NAME | APP Class | Required | Notes | ||
14 | AbsenceEvents | ❗️Potentially sensitive | Yes | Required only for Attendance analytics / Pulse | ||
15 | Absences | ❗️Potentially sensitive | Yes | Required only for Attendance analytics / Pulse | ||
16 | AttendanceMaster | ✅ Not personal/sensitive | Yes | Required only for Attendance analytics / Pulse | ||
17 | Attendances | ❗️Potentially sensitive | Yes | Required only for Attendance analytics / Pulse | ||
18 | CalendarEvents | ✅ Not personal/sensitive | Yes | Required only for Attendance analytics / Pulse | ||
19 | Events | ✅ Not personal/sensitive | Yes | Required only for Attendance analytics / Pulse | ||
20 | FileSemesters | ✅ Not personal/sensitive | Yes | Mandatory - core requirement for the Intellischool data model | ||
21 | FileSemesterYearLevels | ✅ Not personal/sensitive | Yes | Mandatory - core requirement for the Intellischool data model | ||
22 | fnGetConfigValue | ❗️Potentially sensitive | Yes | Required as a dependency, we do not call this function directly. | ||
23 | LearningAreas | ✅ Not personal/sensitive | Yes | Required only if grades are being stored in Synergetic OR if using Schoolbox | ||
24 | luAbsenceEventType | ✅ Not personal/sensitive | Yes | Required only for Attendance analytics / Pulse | ||
25 | luAbsencePeriod | ✅ Not personal/sensitive | Yes | Required only for Attendance analytics / Pulse | ||
26 | luAbsenceReason | ✅ Not personal/sensitive | Yes | Required only for Attendance analytics / Pulse | ||
27 | luAbsenceType | ✅ Not personal/sensitive | Yes | Required only for Attendance analytics / Pulse | ||
28 | luCampus | ✅ Not personal/sensitive | Yes | Mandatory - core requirement for the Intellischool data model | ||
29 | luFileType | ✅ Not personal/sensitive | Yes | Mandatory - core requirement for the Intellischool data model | ||
30 | luForm | ✅ Not personal/sensitive | Yes | Mandatory - core requirement for the Intellischool data model | ||
31 | luGender | ✅ Not personal/sensitive | Yes | Mandatory - core requirement for the Intellischool data model | ||
32 | luHouse | ✅ Not personal/sensitive | Yes | Mandatory - core requirement for the Intellischool data model | ||
33 | luReportResultGroup | ✅ Not personal/sensitive | Required only if grades are being stored in Synergetic | |||
34 | luReportResultType | ✅ Not personal/sensitive | Required only if grades are being stored in Synergetic | |||
35 | luReportResultTypeMaskExpanded | ✅ Not personal/sensitive | Required only if grades are being stored in Synergetic | |||
36 | luTimetableGroup | ✅ Not personal/sensitive | Yes | Mandatory - core requirement for the Intellischool data model | ||
37 | luTimetableGroup | ✅ Not personal/sensitive | Yes | Required only for Attendance analytics / Pulse | ||
38 | luYearLevel | ✅ Not personal/sensitive | Yes | Mandatory - core requirement for the Intellischool data model | ||
39 | PastStudentClasses | ✅ Not personal/sensitive | Yes | Mandatory - core requirement for longitudinal academic data analysis | ||
40 | PastStudentYears | ✅ Not personal/sensitive | Yes | Required only for Attendance analytics / Pulse | ||
41 | pvAttendancesAll | ✅ Not personal/sensitive | Yes | Required only for Attendance analytics / Pulse | ||
42 | pvStaffJobPositions | ⚠️ Personal | Yes | Required for Pulse and inherited access control from job titles | ||
43 | pvStudentAssessmentResultAreas | ✅ Not personal/sensitive | Yes | Required only if grades are being stored in Synergetic | ||
44 | pvStudentNamesAll | ⚠️ Personal | Yes | Mandatory - core requirement for the Intellischool data model | ||
45 | pvTimetableDefinition | ✅ Not personal/sensitive | Yes | Required only for Attendance analytics / Pulse | ||
46 | pvTimetableDefinition | ✅ Not personal/sensitive | Yes | Required only for Attendance analytics / Pulse | ||
47 | pvTimetableDefinitionAll | ✅ Not personal/sensitive | Yes | Required only if using Schoolbox | ||
48 | StudentClasses | ✅ Not personal/sensitive | Yes | Mandatory - core requirement for academic data analysis | ||
49 | Students | ❗️Sensitive | Yes | Mandatory - core requirement for the Intellischool data model | ||
50 | StudentSemester | ✅ Not personal/sensitive | Yes | Mandatory - core requirement for the Intellischool data model | ||
51 | StudentYears | ✅ Not personal/sensitive | Yes | Mandatory - core requirement for the Intellischool data model | ||
52 | StudentYearsHistory | ✅ Not personal/sensitive | Yes | Required only for Attendance analytics / Pulse | ||
53 | SubjectAssessmentAreas | ✅ Not personal/sensitive | Required only if grades are being stored in Synergetic OR if using Schoolbox | |||
54 | SubjectAssessmentCurriculum | ✅ Not personal/sensitive | Required only if grades are being stored in Synergetic | |||
55 | SubjectAssessmentVELSDomains | ✅ Not personal/sensitive | Required only if Victorian Curriculum standards are stored in Synergetic | |||
56 | SubjectAssessmentVELSStrands | ✅ Not personal/sensitive | Required only if Victorian Curriculum standards are stored in Synergetic | |||
57 | SubjectAssessmentVELSStrands | ✅ Not personal/sensitive | Required only if Victorian Curriculum standards are stored in Synergetic | |||
58 | SubjectClasses | ✅ Not personal/sensitive | Yes | Mandatory - core requirement for academic data analysis | ||
59 | SubjectClassesStaff | ✅ Not personal/sensitive | Yes | Mandatory - core requirement for academic data analysis | ||
60 | tAttendances | ❗️Potentially sensitive | Yes | Required only for Attendance analytics / Pulse | ||
61 | Timetable | ✅ Not personal/sensitive | Yes | Required only for Attendance analytics / Pulse OR if using Schoolbox | ||
62 | TimetableConfig | ✅ Not personal/sensitive | Yes | Required only for Attendance analytics / Pulse OR if using Schoolbox | ||
63 | TimetableDefinition | ✅ Not personal/sensitive | Yes | Required only for Attendance analytics / Pulse OR if using Schoolbox | ||
64 | TimetableSubstitutes | ✅ Not personal/sensitive | Yes | Required only for Attendance analytics / Pulse | ||
65 | tMedicalIncidents | ❗️Sensitive | Yes | Required only for Attendance analytics / Pulse (requried fields ID,TimeIn, TimeOut, VenueCode, incidentdate, modifiedby, modifieddate) | ||
66 | vStaff | ❗️Sensitive | Yes | Mandatory - core requirement for the Intellischool data model | ||
67 | vStaffJobPositions | ⚠️ Personal | Yes | Required for Pulse and inherited access control from job titles | ||
68 | vStudentClasses | ✅ Not personal/sensitive | Yes | Required only for Attendance analytics / Pulse OR if using Schoolbox | ||
69 | vStudents | ❗️Sensitive | Yes | Mandatory - core requirement for the Intellischool data model | ||
70 | vStudentTimetableClasses | ✅ Not personal/sensitive | Yes | Required only for Attendance analytics / Pulse | ||
71 | vStudentTimetablePeriods | ✅ Not personal/sensitive | Yes | Required only for Attendance analytics / Pulse | ||
72 | vSubjectClassesStaff | ✅ Not personal/sensitive | Yes | Mandatory - core requirement for the Intellischool data model | ||
73 | ||||||