Data Specification Request Form

Studywiz Universal ConnectorData Specification Request Form

Introduction

This form is used to make a basic agreement on how Studywiz should be integrated with the external database system and vice versa. The integration will allow data to be automatically synchronized between Studywiz and the external database system which helps school to dramatically reduce the time and effort taken from manual import and export process.

Database Specification

Please fill in the following form where applicable. You should fill in the shaded areas following the format described. It is expected that there will be some minor differences between your database specification and Studywiz database which makes it difficult to describe the structure in this form. If this is the case, please feel free to add any extra notes or diagram in “extra notes” field found at the bottom of the document.

Student Data
Table Names / If there is more than one table, please describe how the tables are related.
SW Field Name / Mandatory/Optional / Database Field Name (format : tableName.fieldName)
StudentID / Mandatory
FirstName / Mandatory
LastName / Mandatory
LoginName / Optional
Password / Optional
DefaultAssignedLevelID / Optional (9.4.1 only)
Email / Optional
DateOfBirth / Optional
WebsiteURL / Optional
FaxNumber / Optional
HomePhoneNumber / Optional
MobileNumber / Optional
WorkPhoneNumber / Optional
Address / Optional
Suburb / Optional
PostCode / Optional
Teacher Data
Table Names / If there is more than one table, please describe how the tables are related.
SW Field Name / Mandatory/Optional / Database Field Name (format : tableName.fieldName)
TeacherID / Mandatory
FirstName / Mandatory
LastName / Mandatory
LoginName / Optional
Password / Optional
DefaultAssignedLevelID / Optional (9.4.1 only)
Email / Optional
DateOfBirth / Optional
WebsiteURL / Optional
FaxNumber / Optional
HomePhoneNumber / Optional
MobileNumber / Optional
WorkPhoneNumber / Optional
Address / Optional
Suburb / Optional
PostCode / Optional
Parent Data
Table Names / If there is more than one table, please describe how the tables are related.
SW Field Name / Mandatory/Optional / Database Field Name (format : tableName.fieldName)
ParentID / Mandatory
FirstName / Mandatory
LastName / Mandatory
LoginName / Optional
Password / Optional
DefaultAssignedLevelID / Optional (9.4.1 only)
Email / Optional
DateOfBirth / Optional
WebsiteURL / Optional
FaxNumber / Optional
HomePhoneNumber / Optional
MobileNumber / Optional
WorkPhoneNumber / Optional
Address / Optional
Suburb / Optional
PostCode / Optional
Level Data
Table Names / If there is more than one table, please describe how the tables are related.
SW Field Name / Mandatory/Optional / Database Field Name
(format : tableName.fieldName)
LevelID / Mandatory
LevelName / Mandatory
Class Data
Table Names / If there is more than one table, please describe how the tables are related.
SW Field Name / Mandatory/Optional / Database Field Name
(format : tableName.fieldName)
ClassID / Mandatory
ClassName / Mandatory
Subject Data
Table Names / If there is more than one table, please describe how the tables are related.
SW Field Name / Mandatory/Optional / Database Field Name
(format : tableName.fieldName)
SubjectID / Mandatory
SubjectName / Mandatory
Group Data
Table Names / If there is more than one table, please describe how the tables are related.
SW Field Name / Mandatory/Optional / Database Field Name
(format : tableName.fieldName)
GroupID / Mandatory
GroupName / Mandatory
Level - Class Relationship
Table Names / If there is more than one table, please describe how the tables are related.
SW Field Name / Mandatory/Optional / Database Field Name
(format : tableName.fieldName)
LevelID / Mandatory
ClassID / Mandatory
Class - Student Relationship
Table Names / If there is more than one table, please describe how the tables are related.
SW Field Name / Mandatory/Optional / Database Field Name
(format : tableName.fieldName)
StudentID / Mandatory
ClassID / Mandatory
Class - Teacher Relationship
Table Names / If there is more than one table, please describe how the tables are related.
SW Field Name / Mandatory/Optional / Database Field Name
(format : tableName.fieldName)
TeacherID / Mandatory
ClassID / Mandatory
Parent - Student Relationship
Table Names / If there is more than one table, please describe how the tables are related.
SW Field Name / Mandatory/Optional / Database Field Name
(format : tableName.fieldName)
ParentID / Mandatory
StudentID / Mandatory
Student - Group Relationship
Table Names / If there is more than one table, please describe how the tables are related.
SW Field Name / Mandatory/Optional / Database Field Name
(format : tableName.fieldName)
StudentID / Mandatory
GroupID / Mandatory
Teacher - Group Relationship
Table Names / If there is more than one table, please describe how the tables are related.
SW Field Name / Mandatory/Optional / Database Field Name
(format : tableName.fieldName)
TeacherID / Mandatory
GroupID / Mandatory
Parent - Group Relationship
Table Names / If there is more than one table, please describe how the tables are related.
SW Field Name / Mandatory/Optional / Database Field Name
(format : tableName.fieldName)
ParentID / Mandatory
GroupID / Mandatory
Extra Notes/Explanation
Diagrams
Please attach any diagrams to your return email.