assessmentresultbyaspect.json
Contains information about all aspects and result sets configured in SIMS assessment manager.  We store this data in MINTclass to allow schools to pick which aspects they wish to pull data from.  This makes MINTclass both optimised for data ...
Hover over an underlined term to read more about it
						[0] => stdClass Object
        (
            [Id] => 69365128
            [StudentId] => 21587
            [AspectId] => 17606
            [ResultDate] => 2017-10-17
            [ResultSetId] => 636
            [Result] => 15/6
            [Notes] => 
        )
					
assessmentstructure.json
Contains all of the aspects that the school has in their MIS. This allows MINTclass to contain the aspects in a searchable format so when the aspect mapping is done, only the grades from the mapped aspects are pulled through.
Hover over an underlined term to read more about it
						[0] => stdClass Object
                (
                    [Id] => 1126
                    [ExternalId] => 1126
                    [AspectType] => Grade
                    [Name] => English KS2 Sublevels
                    [Description] => Created to accept and store KS2 Sublevels
                    [Supplier] => 111 1111 RANDOM HIGH SCHOOL             
                    [GradeSetId] => 146
                    [LastUpdated] => 2017-06-21T02:35:59.404
                    [RowHash] => 4701895365AF8F6E59A5037C4CEE0EF403A78215
                )
					
conductfordaterange.json
This file lists conduct data, both behaviour and achievement, that is stored in your SIMS. This data can be extracted as far back as necessary, the data can then be reported on in MINTclass.
Hover over an underlined term to read more about it
						            [0] => stdClass Object
                (
                    [Id] => 25244
                    [ConductType] => Excellent Contribution in Class
                    [Date] => 2017-10-20
                    [Time] => 
                    [Activity] => 
                    [Status] => 
                    [Location] => 
                    [RecordedBy] => Mr Joe Bloggs
                    [Outcome] => 
                    [RecordedOn] => 2017-10-20
                    [Subject] => 
                    [Category] => Ach
                    [LastUpdated] => 2017-10-23T02:59:23.896
                    [RowHash] => 561388A543BC131CAD5D5982F4E20F28EB7E7933
                )
					
conductlookups.json
This file contains the behaviour/achievement categories and reasons you have stored in SIMS. This info can be used to quickly set up 'QuickPoints' in MINTclass so that teachers can quickly and easily assign conduct points to students.
Hover over an underlined term to read more about it
						            [0] => stdClass Object
                (
                    [Id] => Beh.22
                    [Type] => Beh
                    [LocalId] => 22
                    [Description] => Uniform/Equipment
                    [Points] => 1
                    [SubTypeLookup] => 
                    [DisplayOrder] => 2
                    [LastUpdated] => 2017-10-19T12:23:03.792
                    [RowHash] => 7BF247CEDF96D992F7E0BCBA5AE4EF8FF44AD152
                )
					
conductpoints.json
This is simply the collection of behaviour and achievement points a student has overall. It starts from the beginning of the academic year. These points are usually displayed on the student cards.
Hover over an underlined term to read more about it
						[0] => stdClass Object
        (
            [Id] => 11600
            [TotalAchievementPoints] => 4
            [TotalBehaviourPoints] => 0
            [TotalConductPoints] => 4
            [NumberofDetentions] => 0
            [NumberofInterventions] => 0
            [NumberofReportCards] => 0
            [LastUpdated] => 2017-10-11T02:36:42.89
            [RowHash] => E73AA7020989366601DB38465BD02000A1F48333
        )
					
groups.json
The file that contains all of the classes. It also links each student to their respective classes.
Hover over an underlined term to read more about it
						[1] => stdClass Object
        (
            [Id] => 13076
            [ExternalId] => 7e807330-055b-4901-b311-9f9cbfc49114
            [IdaasId] => GC-13076
            [Type] => TeachingGrp
            [Code] => 10A/Fd1
            [Name] => 10A/Fd1
            [PrimaryStaffId] => 19471
            [Staff] => AB
            [NumStudents] => 22
            [RowHash] => 46922E668BE962FC8AEF2F49A0E391E6427DD562
            [LastUpdated] => 2017-10-19T12:22:57.599
            [StudentIds] => 15573,15587,16084,15532,15739,15540,15745,15421,15558,15575,15467,15495,15483,15732,15533,15524,15561,15576,15477,15497,15572,15430
            [StaffIds] => 19471
            [SubjectLocalId] => 550
            [SubjectCode] => Fd
            [SubjectName] => Design Food
        )
					
photos.json
Student and staff photos are stored in this file. The photos are converted to base64, then re-converted to jpg in MINTclass.
Hover over an underlined term to read more about it
						[0] => stdClass Object
        (
            [Id] => 102
            [PersonId] => 102
            [PersonType] => Staff
            [PersonName] => Mrs J Bloggs
            [Photo] => /9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw98dsjfdfh9FdjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCABjAE0DASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD0vwr4V0C78J6VcXGj2Us0lsjO7wgliR1NbH/CG+Gv+gHYf9+Fo8G/8iXo3/XpH/KtysadOHItD0MXi8QsRNKb3fV9znF8N+D3Yqum6SWEphICJnzAMlP97HOOtT/8Ib4a/wCgHYf9+Frj5vCWvpqqXdjDHE0muXF1Izup2r5cohl64xmQgjBY5XstdH4YstbtbwNffaktjYxLKl1c+cXusne6/M21cY4BA9qv2cOyMPrmI/5+S+9jm0LwSguC1loy/ZiBPkRjyiTgBv7uT61b/wCEN8Nf9AOw/wC/C1x2oeB9VvIteu2XM8l1P9ht0KqXjlkhZ2Z92D/qRgfKRg5zkY1JdJ1qLVbmOWPVrvREmm8iG21IpOcw2+xvMMqsVDi6GGfq6nGACp7OHZB9cxH/AD8l97NpPCXhaRpFTRtOZo22uBEpKnAOD6HBB+hFP/4Q3w1/0A7D/vwtclZ+HPEtr5stz9smvLi8tZr2a1vvLSeMW0EcwUb12sZEYg4X5RgEDC12XhuDUbbS3j1JpDJ9omMKyyeY6Qlz5as2TlguMnJ+po9nDsg+uYj/AJ+S+9kX/CG+Gv8AoB2H/fha8y+LejabpDaR/Z1jBa+aJt/lIF3Y2Yzj6n869pryT42ff0T6T/8AtOscRCKpuyPSyjFV5YyClNta9X2Z3/g3/kS9G/69I/5VuVh+Df8AkS9G/wCvSP8AlW5W1P4F6HmYz/eKn+J/mFc5rnjGw0S7+yNHLPOAC4jxhQfU+uOcfSrviPWF0TRpbn/ls37uEYzlyDj8BjP4V4zLNLPK0s0jySMcs7sST9Sas5zvLz4lHkWOn9uGnfv9B/jVHTviHqMNyTfxx3EDEZCKEZPp6/Q/mK46igD23RtdsdctjNaOQynDxPgOv1Hp71pV4PZ3lxYXSXNtK0cqHIZTj8D7e1e16TqUWraZBew8LKuSufut3H4GgC7Xknxs+/on0n/9p163Xknxs+/on0n/APadYYj+Gz1Mm/32Hz/Jnf8Ag3/kS9G/69I/5VuVh+Df+RL0b/r0j/lW5WlP4F6HHjP94qf4n+Z5p8R7wS6ra2gziGIsee7Hp+QH51xddV8QY2TxNuPR4EZfpyP6GuVqznCiiigAruPhvdTDULuzzmBovNxnowIH6g/oK4euw+HH/Iw3H/Xo3/oaUAen15J8bPv6J9J//adet15J8bPv6J9J/wD2nWGI/hs9TJv99h8/yZ3/AIN/5EvRv+vSP+Val9JNDp9zLbJvnSJmjQjO5gDgfnWX4N/5EvRv+vSP+VblaU/gXoceM/3ip/if5ng1zd3N5IJLq4lnkA2hpXLED0yfrUNdB4o8PT6Rqlw0UEhsSfMSQKSqAn7pPqDxz7etc/VnOFFFFABXXfD26t4NceKTf51xH5cWFyOMscnt90VyNd38PNFMk8mrzL8seY4M92P3m/AcfifSgD0SvJPjZ9/RPpP/AO069bryT42ff0T6T/8AtOsMR/DZ6mTf77D5/kzv/Bv/ACJejf8AXpH/ACrcrD8G/wDIl6N/16R/yrcrSn8C9Djxn+8VP8T/ADMzxDaNfeH763VwrNESCRxxz/SvE69i8Va3Do2kSbgHnnUxxx5HcfePsP8AD1rx2rOcKKKKANXw3pq6rr1rayIXhLbpQCR8oGTkjp6fjXsttbQWdulvbxJFCgwqIMAVxfw6sLRbOe/WTfeMTEy7v9WnB6e5Gc+31ruaACvJPjZ9/RPpP/7Tr1uvJPjZ9/RPpP8A+06wxH8NnqZN/vsPn+TOv0XWbXQ/h/ol1diQxtbxxgRrk525/oaydR+JDnK6bZBRn/WXBySMf3QeDn3NVdV/5JV4f+kP/otq4ytKfwL0OPGf7xU/xP8AMuajql5q1yLi+mMsgXaDtAwPTA+tU6KKs5wooooA1/D2vz+H79p4082N12yRFtob0P1B9vX1rurD4haVc7Vu45bRyeSRvUfiOf0ry6igD3m2u7e9hWa2njmjYZDI2RXlXxs+/on0n/8AadYVncT2t0klvNJFJnG6Nipx+Fbvxs+/on0n/wDadYYj+Gz1Mm/32Hz/ACZxln4+8T2FlDaWuqGOCFAkaeTGdqjoMlc1N/wsrxd/0Fz/AOA8X/xNFFedGpOy1Z9nVweHdSTdOO76IP8AhZXi7/oLn/wHi/8AiaP+FleLv+guf/AeL/4miin7Sfdmf1LDf8+4/cg/4WV4u/6C5/8AAeL/AOJo/wCFleLv+guf/AeL/wCJooo9pPuw+pYb/n3H7kH/AAsrxd/0Fz/4Dxf/ABNH/CyvF3/QXP8A4Dxf/E0UUe0n3YfUsN/z7j9yD/hZXi7/AKC5/wDAeL/4msnWvEmr+ITAdVvDceRu8v8Adqu3OM/dA9BRRUzqTcdWdGFwtCNVOMEn6I//2Q==
            [RowHash] => 33802BB3D47E10F76A9DCADFB68F9D0EB205DBC1
            [LastUpdated] => 2017-10-19T12:22:57.349
        )
					
sen.json
This file provides the need type and need notes for students. The SEN code is extracted in another file (students.json).
Hover over an underlined term to read more about it
						    [0] => stdClass Object
        (
            [Id] => 502
            [StudentId] => 7343
            [NeedTypeDescription] => Autistic Spectrum Disorder
            [NeedTypeCode] => ASD
            [Rank] => 2
            [NeedNotes] => Some ASD traits
            [NeedStartDate] => 2012-09-10
            [NeedEndDate] => 
            [Active] => 1
            [LastUpdated] => 2017-10-18T10:27:33.696
            [RowHash] => F73877C7F732BD33C0868C93917C11B9A26592CE
        )
					
staff.json
The staff are pulled into this file - if "IsTeacher" has a '1', then their account will be auto created in MINTclass.
Hover over an underlined term to read more about it
						 [0] => stdClass Object
        (
            [Id] => 15
            [IdaasId] => PWT-15
            [ExternalId] => 8d90c7d2-8dc3-4016-88a7-fed85669ee68
            [Title] => Mrs
            [StaffCode] => JBL
            [Forename] => Joanne
            [Surname] => Bloggs
            [DisplayName] => Mrs J Bloggs
            [WorkEmail] => jbloggs@school.com
            [WorkPhone] =>  01234 567 890
            [Gender] => F
            [MiddleName] => 
            [LegalForename] => Joanne
            [LegalSurname] => Bloggs
            [DateOfBirth] => 1957-04-28
            [MobilePhone] => 0777777777777
            [IsTeacher] => 1
            [IsSupport] => 0
            [RegGroup] => 8D
            [LastUpdated] => 2017-10-18T10:27:41.32
            [RowHash] => FB61C4366F0F5CAFF1212FB5F111E8250BE42EAC
        )
					
student.json
This file will show contain the majority of information about the student, much of the data held in the "student details" section of SIMS will get extracted into this file.
Hover over an underlined term to read more about it
						[0] => stdClass Object
        (
            [Id] => 18076
            [ExternalId] => 98df8acd-1fd4-43fc-8863-c717a002ae73
            [IdaasId] => PL-18076
            [Forename] => Joe
            [Surname] => BLOGGS
            [DisplayName] => Joe BLOGGS
            [AdmissionNo] => 012345
            [Gender] => M
            [RegGroupId] => 15805
            [RegGroup] => 7T
            [YearGroupId] => 37
            [YearGroup] => Year  7
            [HouseGroupId] => 40
            [HouseGroup] => Redgrave
            [UPN] => J865344910001
            [FormerUPN] => J86876876786
            [DateofBirth] => 2006-01-01 //Only if required and consented
            [UniqueLearnerNumber] => 876776564654 //Only if required and consented
            [MiddleName] => John //Only if required and consented
            [EnrolmentStatus] => C //Only if required and consented
            [LegalForename] => Joseph //Only if required and consented
            [LegalSurname] => BLOGGS //Only if required and consented
            [EntryDate] => 2017-09-01 //Only if required and consented
            [InLeaCare] => 0 //Only if required and consented
            [LeaCareAuthority] => 123 //Only if required and consented
            [ServiceChild] => 1 //Only if required and consented
            [SENProvision] => K //Only if required and consented
            [FSMEligible] => 0 //Only if required and consented
            [FsmEndDate] => //Only if required and consented
            [UniformAllowance] => 1 //Only if required and consented
            [PupilPremium] => 0 //Only if required and consented
            [YSSA] => //Only if required and consented
            [EAL] => 0 //Only if required and consented
            [FSMEver6] => 0 //Only if required and consented
            [Gifted] => 1 //Only if required and consented
            [ReligionCode] => NO //Only if required and consented
            [Religion] => No Religion //Only if required and consented
            [EthnicityCode] => WBRI //Only if required and consented
            [Ethnicity] => White - British //Only if required and consented
            [EthnicitySource] => P //Only if required and consented
            [HomeLanguage] => English //Only if required and consented
            [HomeLanguageCode] => ENG //Only if required and consented
            [FirstLanguage] => English //Only if required and consented
            [FirstLanguageCode] => ENG //Only if required and consented
            [FirstLanguageSource] => P //Only if required and consented
            [NationalIdentity] => British //Only if required and consented
            [ModeOfTravel] => Bus //Only if required and consented
            [IsTraveller] => 0 //Only if required and consented
            [PostCode] => AB1 2CD //Only if required and consented
            [AttStatsStartDate] => 2017-09-01
            [AttStatsEndDate] => 2017-10-23
            [NumPossMarks] => 66
            [NumPresMarks] => 64
            [NumAEAMarks] => 2
            [NumAuthAbsMarks] => 2
            [NumUnauthAbsMarks] => 0
            [NumMissMarks] => 0
            [NumLateMarks] => 0
            [NumLateBeforeRegMarks] => 1
            [StudentStatus] => OnRoll 
            [LastUpdated] => 2017-10-02T14:11:02.544
            [RowHash] => 8432E9EF77370480FEFEBA54CA11FDE88133F767
        )
					
studentmedical.json
A separate file contains medical data. The medical data is extracted from the 'Medical conditions' field in SIMS.
Hover over an underlined term to read more about it
						(
    [ConditionLookups] => Array
        (
            [0] => stdClass Object
                (
                    [Id] => 1
                    [ConditionDescription] => Epilepsy
                )
				
							
	 [StudentConditions] => Array
        (
            [191] => stdClass Object
                (
                     [Id] => 1.15564
                     [StudentId] => 15564
                     [MedicalConditionId] => 1
                     [ConditionDescription] => Epilepsy
                )
}
					
timetable.json
The timetable file will contain the lessons for both staff and students. It reads from within a 2 week range.
Hover over an underlined term to read more about it
						[0] => stdClass Object
        (
            [Id] => 1
            [PeriodId] => 43005
            [ClassId] => 12731
            [JoinedId] => 1
            [ClassName] => 7A/Ma1
            [Period] => Thu:2
            [StartDateTime] => 2017-10-19T09:45:00
            [EndDateTime] => 2017-10-19T10:35:00
            [StaffCodes] => AB
            [RoomCodes] => 34
            [SubjectCode] => Ma
            [SubjectName] => Maths
        )