MATs and Schools can purchase the standalone Microsoft Power BI connector to visualise specific datasets outside of Arbor. Data available via the connector is automatically synced overnight. A full explanation of how to purchase and install the connector is available here.
Below you'll find a list of all the available datasets.
ATTENDANCE
|
Field |
Example Data |
Explanation |
|
STUDENT_ID |
1234 |
Arbor Student ID |
|
APPLICATION_ID |
uk_swd_137264 |
Unique identifier of MIS database. This can be concatenated with STUDENT_ID to get a unique value across MAT data. |
|
RAW_MARK |
/ |
DfE Attendance mark code |
|
MARK_CODE |
PRESENT_AM |
DfE Attendance mark meaning |
|
MINUTES_LATE |
12 |
Number of minutes late |
|
PERIOD |
MORNING |
Roll call period that attendance relates to |
|
DATE |
2015-10-16 |
Date of recorded mark |
|
IS_PRESENT |
TRUE |
Does the mark have a statistical meaning of Present? |
|
IS_AUTHORIZED_ABSENT |
FALSE |
Does the mark have a statistical meaning of Authorised Absence? |
|
IS_UNAUTHORIZED_ABSENT |
FALSE |
Does the mark have a statistical meaning of Unauthorised Absent? |
|
IS_POSSIBLE_ATTENDANCE |
TRUE |
Does the mark count towards attendance figures? |
BEHAVIOUR_INCIDENTS
|
Field |
Example Data |
Explanation |
|
BEHAVIOURAL_INCIDENT_INVOLVEMENT_ID |
143866 |
ID of the record linking the Incident to a student |
|
BEHAVIOURAL_INCIDENT_ID |
127599 |
ID of the Incident record. |
|
APPLICATION_ID |
uk_swd_137264 |
Unique identifier of MIS database. This can be concatenated with BEHAVIOURAL_INCIDENT_INVOLVEMENT_ID to get a unique value across MAT data. |
|
STUDENT_ID |
1636 |
Arbor Student ID |
|
SEVERITY |
1 |
Severity of the Incident in the Behaviour setup in Arbor |
|
INCIDENT_DT |
2021-02-09 11:25:00 |
Datetime the Incident was recorded |
|
RESOLVED_DT |
NULL |
Datetime the Incident was resolved |
|
LOGGED_BY_STAFF_ID |
21 |
ID of Staff Member who logged the Incident |
|
COMMENT |
NULL |
Historic field, likely to be unpopulated. |
|
NARRATIVE |
Emily participated well in class |
Narrative entered when Incident was created |
ENROLMENTS
|
Field |
Example Data |
Explanation |
|
APPLICATION_ID |
uk_swd_137264 |
Unique identifier of MIS database. This can be concatenated with STUDENT_ID to get a unique value across MAT data. |
|
STUDENT_ID |
1777 |
Arbor Student ID |
|
START_DT |
2016-09-01 00:00:00 |
Enrolment start datetime If a student has multiple enrolments for the school (they have left and returned) then they will have multiple records here for each set of dates. |
|
END_DT |
2286-11-20 17:46:39 |
Enrolment end datetime. If the end date in Arbor is blank (or ongoing) then a future date in the year 2286 is supplied which can be safely ignored. |
|
UNENROLMENT_REASON |
END_OF_PHASE_TRANSFER |
Reason for un-enrolment from school, uses defined values required for census return |
FIXED_PERIOD_EXCLUSIONS
|
Field |
Example Data |
Explanation |
|
FIXED_PERIOD_EXCLUSION_ID |
964 |
ID of the Fixed Period Exclusion record |
|
APPLICATION_ID |
uk_swd_137264 |
Unique identifier of MIS database. This can be concatenated with FIXED_PERIOD_EXCLUSION_ID to get a unique value across MAT data. |
|
STUDENT_ID |
2767 |
Arbor Student ID |
|
START_DT |
2021-05-28 08:30:00 |
Start datetime of the Fixed Period Exclusion |
|
END_DT |
2021-05-28 15:30:00 |
End datetime of the Fixed Period Exclusion |
|
DECISION_DT |
2021-05-27 15:29:00 |
Datetime of when the decision to exclude was made |
|
EXCLUSION_REASONS |
[ "DISOBEDIANCE", "THREATENING_BEHAVIOUR_ADULT" ] |
List of exclusion reasons in array format - this follows JSON Array Litteral convention |
|
EXCLUSION_REASONS_CONCAT |
DISOBEDIANCE, THREATENING_BEHAVIOUR_ADULT |
List of exclusion reasons in space separated format |
|
DAILY_START_TIME |
NULL |
Start time for Lunchtime exclusions |
|
DAILY_END_TIME |
NULL |
End time for Lunchtime exclusions |
|
STATISTICAL_DAYS_EXCLUDED |
1 |
Number of school days that the exclusion period covers |
PERMANENT_EXCLUSIONS
|
Field |
Example Data |
Explanation |
|
PERMANENT_EXCLUSION_ID |
14 |
ID of the Permanent Exclusion record |
|
APPLICATION_ID |
uk_swd_137264 |
Unique identifier of MIS database. This can be concatenated with PERMANENT_EXCLUSION_ID to get a unique value across MAT data. |
|
STUDENT_ID |
1621 |
Arbor Student ID |
|
START_DATE |
2021-05-27 |
Date the Exclusion started |
|
DECISION_DT |
2021-05-27 08:55:00 |
Date of when the decision to exclude was made |
|
EXCLUSION_REASONS |
["DISRUPTIVE_BEHAVIOUR", "RACIST_ABUSE" ] |
List of exclusion reasons in array format - this follows JSON Array Litteral convention |
|
EXCLUSION_REASONS_CONCAT |
DISRUPTIVE_BEHAVIOUR, RACIST_ABUSE |
List of exclusion reasons in space separated format |
STUDENTS
|
Field |
Example Data |
Explanation |
|
STUDENT_ID |
113 |
Arbor Student ID |
|
APPLICATION_ID |
uk_swd_137264 |
Unique identifier of MIS database. This can be concatenated with STUDENT_ID to get a unique value across MAT data. |
|
UPN |
C123456789101 |
Unique Pupil Number (DfE number) |
|
LEGAL_FIRST_NAME |
Mason |
Legal first name |
|
LEGAL_LAST_NAME |
Wilson |
Legal surname |
|
DATE_OF_BIRTH |
2008-07-21 |
Date of birth |
|
PREFERRED_FIRST_NAME |
Maz |
Preferred first name if exists, otherwise blank |
|
PREFERRED_LAST_NAME |
Wilson-Jones |
Preferred last name if exists, otherwise blank |
|
GENDER |
MALE |
Gender |
|
ETHNICITY |
BCRB |
Ethnicity code as specified in the CBDS codeset |
|
RELIGION |
CHRISTIAN |
Arbor language code |
|
NATIVE_LANGUAGE_CODES |
ISO_ENG |
Native language code as specified in the CBDS codeset |
|
NATIVE_LANGUAGE_NAMES |
English |
Native language name |
|
ADDRESS1 |
48 Scott Lane |
First line of student address |
|
POSTCODE |
SN1 1AA |
Postcode |
STUDENT_TAGS
Stores demographic information relating to students. Boolean values are relevant at the point in time they are queried.
|
Field |
Example Data |
Explanation |
|
APPLICATION_ID |
uk_swd_137264 |
Unique identifier of MIS database. This can be concatenated with STUDENT_ID to get a unique value across MAT data. |
|
STUDENT_ID |
2378 |
Arbor Student ID |
|
CHILD_PROTECTION |
FALSE |
Is the student currently under a child protection order? |
|
GIFTED |
FALSE |
Is the student marked as gifted? |
|
GIFTED_TALENTED |
FALSE |
Is the student marked as gifted & talented? |
|
HAS_MEDICAL_CONDITION |
TRUE |
Does the student have at least one medical condition listed? Note - this is not necessarily something that affects their education, it's simply any medical record. |
|
IN_CARE |
FALSE |
Is the student in care today? |
|
IN_YEAR_ADMISSION |
FALSE |
Did the student join the school after the start of the academic year? |
|
OUT_OF_AGE_GROUP_COHORT |
FALSE |
Is the student in a different year group than expected from their date of birth? |
|
SEN |
TRUE |
Does the student have any current special educational needs? |
|
TALENTED |
FALSE |
Is the student marked as talented? |
|
EAL |
FALSE |
Is the student's first language other than english? |
|
COMPULSORY_SCHOOL_AGE |
FALSE |
Is the student of compulsory school age today? (defined as age 5-15 at the start of the academic year) |
|
EARLY_YEARS_PUPIL_PREMIUM_RECIPIENT |
FALSE |
Is the student a recipient of early years pupil premium today? |
|
EVER_6_FSM |
TRUE |
Does the student qualify for Ever6 FSM today? |
|
EVER_6_SERVICE_CHILD |
FALSE |
Does the student qualify for Ever6 Service Child today? |
|
FSM |
TRUE |
Does the student qualify for free school meals today? |
|
MOBILE_Y10_Y11 |
FALSE |
Did the student join the school during year 10 or 11? |
|
MOBILE_Y5_Y6 |
FALSE |
Did the student join the school during year 5 or 6? |
|
PUPIL_PREMIUM |
TRUE |
Does the student qualify for pupil premium today? |
|
PUPIL_PREMIUM_RECIPIENT |
FALSE |
Is the student a recipient of pupil premium (in GIAP records) in the current financial year? |
|
SERVICE_CHILD |
FALSE |
Is the student marked as a service child today? |
|
TRAVELLER |
FALSE |
Is the student marked as a traveller today? |
|
DISADVANTAGED |
TRUE |
Does the student qualify as disadvantaged under the DfE criteria (Ever6 FSM or a CLA for one day or more) today? |
STUDENT_ACADEMIC_YEAR_ENROLMENTS
This gives a record per student for each academic year they are enrolled within the school e.g. a record for enrolment for the 2022/2023 academic school year.
|
Field |
Example Data |
Explanation |
|
PERSON_UNIQUE_ID |
uk_swd_137264_1234 |
Concatenation of Application_ID and Student_ID to give a unique identifier across all databases |
|
ACADEMIC_YEAR_ENROLMENT_ID |
3456 |
ID for the enrolment record |
|
APPLICATION_ID |
uk_swd_137264 |
Unique identifier of MIS database. |
|
ACADEMIC_YEAR_ID |
4 |
ID of the academic year - can be linked to ACADEMIC_YEARS |
|
ACADEMIC_YEAR_NAME |
2022/2023 |
Name of the academic year in Arbor |
|
STUDENT_ID |
1234 |
Arbor Student ID |
|
START_DATE |
2022-09-01 |
Start date of the enrolment |
|
END_DATE |
2023-08-31 |
End date of the enrolment |
|
IS_CURRENT |
Yes |
Is this a current enrolment as at today? |
|
ENROLMENT_NOTES |
Also registered at St Claire's |
Any relevant notes for the enrolment |
|
ENROLMENT_MODE |
DUAL_REGISTRATION_MAIN |
Enrolment mode for the year, if this is blank Single Registration can be assumed |
STUDENT_YEAR_GROUPS
Stores records of all year groups that a student has been enrolled in within the school - any student who has been enrolled in more than one year group within their enrolment at the school will therefore have multiple records in this table. Eg. a record for Year 7, Year 8 and Year 9 with corresponding dates.
|
Field |
Example Data |
Explanation |
|
APPLICATION_ID |
uk_swd_137264 |
Unique identifier of MIS database. This can be concatenated with STUDENT_ID to get a unique value across MAT data. |
|
STUDENT_ID |
2610 |
Arbor Student ID |
|
YEAR_GROUP |
YEAR_10 |
Returns one record for every Year Group that the student has been enrolled at the school |
|
START_DT |
2021-09-01 |
Start date of the Year Group enrolment |
|
END_DT |
2022-08-31 |
End date of the Year Group enrolment |
STUDENT_REGISTRATION_FORM_MEMBERSHIPS
Stores records of all registration forms that a student has been enrolled in during their school enrolment. If students have moved between registration forms within an Academic year these will be stored as separate records.
|
Field |
Example Data |
Explanation |
|
PERSON_UNIQUE_ID |
uk_swd_137264_1234 |
Concatenation of Application_ID and Student_ID to give a unique identifier across all databases |
|
APPLICATION_ID |
uk_swd_137264 |
Unique identifier of MIS database. |
|
STUDENT_ID |
2610 |
Arbor Student ID |
|
REGISTRATION_FORM_ID |
345 |
Registration form ID |
|
REGISTRATION_FORM_NAME |
12-KR |
Registration form name |
|
START_DATE |
2022-09-01 |
Start date of registration form membership |
|
END_DATE |
2023-07-24 |
End date of registration form membership |
STUDENT_SEN_STATUS_ASSIGNMENT
Stores records of all SEN status assignments for a pupil including current and historic status.
|
Field |
Example Data |
Explanation |
|
PERSON_UNIQUE_ID |
uk_swd_137000_2610 |
Unique person identifier - concatenation of application ID and student ID to give a unique value across MAT data |
|
APPLICATION_ID |
uk_swd_137000 |
Unique identifier of MIS database. |
|
SCHOOL_NAME |
Sunnyville High School |
School name. |
|
STUDENT_ID |
2610 |
ID of student record |
|
STUDENT_SEN_STATUS_ASSIGNMENT_ID |
1234 |
ID of the individual SEN status assignment record from the school MIS. |
|
SEN_STATUS_CODE |
SEN_SUPPORT |
Internal code of the SEN Status |
|
SEN_STATUS_NAME |
SEN Support |
Name of the SEN Status from the UI |
|
COUNTS_AS_SEN_STATUS |
TRUE |
Boolean value of whether the SEN Status is a valid one |
|
SEN_STATUS_EXPORT_CODE |
K |
Short code for SEN Status as specified by the DfE |
|
IS_MEMBER_OF_SEN_UNIT |
TRUE |
Boolean value of whether this student is a member of an SEN unit |
|
HAS_RESOURCED_PROVISION |
FALSE |
Boolean value of whether the student is marked as having resourced provision |
|
START_DATE |
2015-09-01 |
Start date of the SEN Status assignment |
|
END_DATE |
2022-08-31 |
End date of the SEN Status assignment. Null values can be interpreted as ongoing. |
SUMMATIVE_ASSESSMENT_MARKS
|
Field |
Example Data |
Explanation |
|
APPLICATION_ID |
uk_swd_137264 |
Unique identifier of MIS database |
|
STUDENT_ID |
2861 |
Arbor Student ID |
|
SUBJECT_CODE |
CSI |
Subject code as specified by DfE |
|
SUBJECT_NAME |
Computer Science |
Subject name |
|
ACADEMIC_YEAR_START |
2020 |
Academic year of the assessment (allows comparison of assessments in the same year) |
|
ASSESSMENT_CODE |
UK_DFE__PROGRESS_8__EBACC__GCSE_LEVEL_1_2__COMPUTER_SCIENCE_CK1 |
Internal Arbor assessment code. Any that begin 'UK_DFE' are built-in Arbor assessments and should be comparable across MIS. Any that begin 'USER_DEFINED' have been created by the school and may not be comparable across MIS unless created as part of a Group Assessment policy |
|
ASSESSMENT_DATE |
2020-12-08 |
Date of the assessment |
|
PERIOD_NAME |
Autumn2 |
Name given to the reporting period |
|
PERIOD_START |
2020-11-19 |
Start date of the reporting period |
|
PERIOD_END |
2021-02-21 |
End date of the reporting period |
|
GRADE_SET_CODE |
UK_DFE__GCSE_9_TO_1_FINE_GRADING_2017 |
Internal Arbor gradeset code. Any that begin 'UK_DFE' are built-in Arbor gradesets. Any that begin 'USER_DEFINED' have been created by the school |
|
GRADE_POINTS |
5.67 |
Numeric value of the grade |
|
GPS_MIN |
0 |
Minimum numeric value of the gradeset |
|
GPS_MAX |
18 |
Maximum numeric value of the gradeset |
|
GRADE_NAME |
6c |
Grade |
|
NON_SUBMISSION_REASON |
NULL |
Reason selected where a mark has not been added. Valid values are 'Absent', 'Not enrolled' or 'Not required' |
|
STAFF_ID |
193 |
Arbor Staff ID of the person who entered the mark |
SUMMATIVE_ASSESSMENT_PSEUDOMARKS
This table has the same structure as the table above and is used to store student assessment targets.
|
Field |
Example Data |
Explanation |
|
APPLICATION_ID |
uk_swd_137264 |
Unique identifier of MIS database |
|
STUDENT_ID |
3192 |
Arbor Student ID |
|
SUBJECT_CODE |
HIS |
Subject code as specified by DfE |
|
SUBJECT_NAME |
History |
Subject name |
|
ACADEMIC_YEAR_START |
2020 |
Academic year of the assessment (allows comparison of assessments in the same year) |
|
TARGET_TYPE |
TEACHER_PROGRESS_TARGET |
Type of target. |
|
ASSESSMENT_CODE |
UK_DFE__PROGRESS_8__EBACC__GCSE_LEVEL_1_2__HISTORY_DB |
Internal Arbor assessment code. Any that begin 'UK_DFE' are built-in Arbor assessments and should be comparable across MIS. Any that begin 'USER_DEFINED' have been created by the school and may not be comparable across MIS unless created as part of a Group Assessment policy |
|
PERIOD_NAME |
Autmn2 |
Name given to the reporting period |
|
PERIOD_START |
2020-11-19 |
Start date of the reporting period |
|
PERIOD_END |
2021-02-21 |
End date of the reporting period |
|
GRADE_SET_CODE |
UK_DFE__GCSE_9_TO_1_FINE_GRADING_2017 |
Internal Arbor gradeset code. Any that begin 'UK_DFE' are built-in Arbor gradesets. Any that begin 'USER_DEFINED' have been created by the school |
|
GRADE_POINTS |
5.67 |
Numeric value of the grade |
|
GPS_MIN |
0 |
Minimum numeric value of the gradeset |
|
GPS_MAX |
18 |
Maximum numeric value of the gradeset |
|
GRADE_NAME |
6c |
Grade |
|
NON_SUBMISSION_REASON |
NULL |
Reason selected where a mark has not been added. Valid values are 'Absent', 'Not enrolled' or 'Not required' |
KS_RESULTS_STUDENT_SUMMARY
Data used for the KS4 results analysis page in the MIS. It is a combination of Qualification result data and calculated measures based on the full results for each student.
|
Field |
Example Data |
Explanation |
|
APP_ID |
uk_swd_137264 |
Unique identifier of MIS database. This can be concatenated with STUDENT_ID to get a unique value across MAT data. |
|
STUDENT_ID |
238 |
Arbor Student ID |
|
KS4_EXAM_YEAR |
2020 |
Academic Year that the student was in Year 11 |
|
TOTAL_NUMBER_OF_RESULTS |
9 |
Total number of all approved results awarded to the student. Approved qualifications are listed in the DfE performance tables |
|
NUMBER_OF_RESULTS_EBACC |
7 |
Total number of awarded results which count towards the Ebacc |
|
TOTAL_NUMBER_OF_GCSES |
8 |
Total number of approved GCSEs the student has ever been awarded. Approved GCSEs are listed in the DfE performance tables |
|
TOTAL_NUMBER_OF_NON_GCSES |
1 |
Total number of approved non-GCSEs the student has ever been awarded. Approved GCSEs are listed in the DfE performance tables |
|
SCIENCE_TYPE |
Single |
Has values of Double for Combined Science awards or Single for all other Science awards |
|
AVERAGE_POINT_SCORE_ALL |
4.67 |
Average Point Score - calculated across all approved results awarded to the student |
|
AVERAGE_POINT_SCORE_EBACC |
4.71 |
Average Point Score - calculated across all results awarded to the student that count in the Ebacc category |
|
AVERAGE_POINT_SCORE_GCSES |
4.88 |
Average Point Score - calculated across all approved GCSE level results awarded to the student |
|
AVERAGE_POINT_SCORE_NON_GCSES |
NULL |
Average Point Score - calculated across all approved Non-GCSE level results awarded to the student |
|
BEST8_POINT_SCORE_ACROSS_ALL_RESULTS |
4.88 |
Average Point Score of the best 8 results awarded to the student |
|
POINTS_ENGLISH |
5 |
From the best grade in an English qualification |
|
POINTS_MATHS |
5 |
From the best grade in a Maths qualification |
|
POINTS_SCIENCE_1 |
5 |
First best grade in a Science qualification |
|
POINTS_SCIENCE_2 |
5 |
Second best grade in a Science qualification |
|
POINTS_HUMANITIES |
5 |
From the best grade in a Humanities qualification |
|
POINTS_LANGUAGES |
NULL |
From the best grade in a Languages qualification |
|
PASS_9_5_AT_LEAST_5_RESULTS |
TRUE |
Has the student achieved at least 5 passes with grades 9-5? |
|
PASS_9_5_AT_LEAST_5_RESULTS_INC_ENG_MATH |
TRUE |
Has the student achieved at least 5 passes with grades 9-5 including English & Maths awards? |
|
PASS_9_4_AT_LEAST_5_RESULTS |
TRUE |
Has the student achieved at least 5 passes with grades 9-4? |
|
PASS_9_4_AT_LEAST_5_RESULTS_INC_ENG_MATH |
TRUE |
Has the student achieved at least 5 passes with grades 9-4 including English & Maths awards? |
|
PASS_9_1_AT_LEAST_5_RESULTS |
TRUE |
Has the student achieved at least 5 passes with grades 9-1? |
|
PASS_9_1_AT_LEAST_1_RESULT |
TRUE |
Has the student achieved at least 1 pass with grades 9-1? |
|
A8_MATHS |
10 |
Calculated Attainment8 score for Maths bucket |
|
A8_ENGLISH |
10 |
Calculated Attainment8 score for English bucket |
|
A8_EBACC |
15 |
Calculated Attainment8 score for Ebacc bucket |
|
A8_OPEN |
14 |
Calculated Attainment8 score for Other bucket |
|
ATTAINMENT8 |
49 |
Calculated Attainment8 score following DfE methodology |
|
EBACC_ENTERED_ENGLISH |
TRUE |
Was the student entered for an award in English that counts towards Ebacc? |
|
EBACC_ENTERED_MATHS |
TRUE |
Was the student entered for an award in Maths that counts towards Ebacc? |
|
EBACC_ENTERED_SCIENCE |
TRUE |
Was the student entered for an award in Science that counts towards Ebacc? |
|
EBACC_ENTERED_HUMANITIES |
TRUE |
Was the student entered for an award in Humanities that counts towards Ebacc? |
|
EBACC_ENTERED_LANGUAGES |
FALSE |
Was the student entered for an award in Languages that counts towards Ebacc? |
|
ENTERED_EBACC |
FALSE |
Was the student entered for a complete set of awards that qualify for Ebacc? |
|
EBACC_PASS_9_5_ENGLISH |
TRUE |
Did the student achieve grade 9-5 in an Ebacc-qualifying English award? |
|
EBACC_PASS_9_5_MATHS |
TRUE |
Did the student achieve grade 9-5 in an Ebacc-qualifying Maths award? |
|
EBACC_PASS_9_5_TWO_SCIENCES |
TRUE |
Did the student achieve grade 9-5 in an Ebacc-qualifying Science award? |
|
EBACC_PASS_9_5_HUMANITIES |
TRUE |
Did the student achieve grade 9-5 in an Ebacc-qualifying Humanities award? |
|
EBACC_PASS_9_5_LANGUAGES |
FALSE |
Did the student achieve grade 9-5 in an Ebacc-qualifying Language award? |
|
EBACC_PASS_9_5_ALL |
FALSE |
Did the student achieve grade 9-5 in all Ebacc qualifications? |
|
EBACC_POINTS_ENGLISH |
5 |
Points from the best English qualification that counts towards Ebacc. The student must have awards in both Language and Literature to count in this metric |
|
EBACC_POINTS_MATHS |
5 |
Points from the best Maths qualification that counts towards Ebacc |
|
EBACC_POINTS_SCIENCE_AVERAGE |
5 |
Points from the best Science qualification that counts towards Ebacc |
|
EBACC_POINTS_HUMANITIES |
5 |
Points from the best Humanities qualification that counts towards Ebacc |
|
EBACC_POINTS_LANGUAGES |
0 |
Points from the best Languages qualification that counts towards Ebacc |
|
EBACC_AVERAGE_POINTS_SCORE |
4.17 |
Average Points Score across all Ebacc qualifications |
KS4_RESULTS_SCHOOL_HEADLINE
Data used for the KS4 results analysis page in the MIS. It is a combination of Qualification result data and calculated measures across the Year 11 cohort for the relevant academic year.
|
Field |
Example Data |
Explanation |
|
APP_ID |
uk_swd_137264 |
Unique identifier of MIS database. |
|
KS4_EXAM_YEAR |
2020 |
Academic Year of the cohort |
|
COHORT_SIZE |
220 |
Number of enrolled students in Year 11 |
|
AVERAGE_NUMBER_OF_RESULTS |
8.5 |
Average number of approved awarded results per student. Approved qualifications are listed in the DfE performance tables |
|
AVERAGE_NUMBER_OF_RESULTS_EBACC |
6.540909 |
Average number of awarded results that count towards the Ebacc per student. |
|
AVERAGE_TOTAL_NUMBER_OF_GCSES |
7.836364 |
Average number of approved awarded GCSEs per student. Approved qualifications are listed in the DfE performance tables. |
|
AVERAGE_TOTAL_NUMBER_OF_NON_GCSES |
0.663636 |
Average number of approved awards non-GCSEs per students. Approved qualifications are listed in the DfE performance tables. |
|
PROPORTION_DOUBLE_SCIENCE |
0.773148 |
Proportion of the cohort on the double science qualification pathway. Since not all students will necessarily take any science qualifications this plus the single science proportion will not necessarily equal 1 |
|
PROPORTION_SINGLE_SCIENCE |
0.226852 |
Proportion of the cohort on the single science qualification pathway. Since not all students will necessarily take any science qualifications this plus the double science proportion will not necessarily equal 1 |
|
AVERAGE_POINT_SCORE_ALL |
5.048459893 |
Average APS per student. This is calculated across all awarded results for the cohort. |
|
AVERAGE_POINT_SCORE_EBACC |
5.016428075 |
Average points per student for all awarded results that would count towards the Ebacc. |
|
AVERAGE_POINT_SCORE_GCSES |
5.068549884 |
Average APS per student for all awarded approved GCSEs. |
|
AVERAGE_POINT_SCORE_NON_GCSES |
Null |
Average APS per student for all awarded approved non-GCSEs. |
|
AVERAGE_BEST8_POINT_SCORE_ACROSS_ALL_RESULTS |
5.081013825 |
Average APS per student of their best 8 awarded results. |
|
AVERAGE_POINTS_ENGLISH |
5.342592593 |
Average points for the best English qualification per student. |
|
AVERAGE_POINTS_MATHS |
4.837209302 |
Average points for the best Maths qualification per student. |
|
AVERAGE_POINTS_SCIENCE_1 |
4.916666667 |
Average points for the best Science qualification per student. |
|
AVERAGE_POINTS_SCIENCE_2 |
4.784722222 |
Average points for the second best (or equal first) Science qualification per student. |
|
AVERAGE_POINTS_HUMANITIES |
5 |
Average points for the best Humanities qualification per student. |
|
AVERAGE_POINTS_LANGUAGES |
5.261538462 |
Average points for the best Languages qualification per student. |
|
PROPORTION_PASS_9_5_AT_LEAST_5_RESULTS |
0.568182 |
Proportion of the cohort who have achieved 5 passes at 9-5 |
|
PROPORTION_PASS_9_5_AT_LEAST_5_RESULTS_INC_ENG_MATH |
0.454545 |
Proportion of the cohort who have achieved 5 passes at 9-5 including an English and Maths qualification |
|
PROPORTION_PASS_9_4_AT_LEAST_5_RESULTS |
0.768182 |
Proportion of the cohort who have achieved 5 passes at 9-4 including an English and Maths qualification |
|
PROPORTION_PASS_9_4_AT_LEAST_5_RESULTS_INC_ENG_MATH |
0.690909 |
Proportion of the cohort who have achieved 5 passes at 9-4 including an English and Maths qualification |
|
PROPORTION_PASS_9_1_AT_LEAST_5_RESULTS |
0.981818 |
Proportion of the cohort who have achieved 5 passes at 9-1 |
|
PROPORTION_PASS_9_1_AT_LEAST_1_RESULT |
0.981818 |
Proportion of the cohort who have achieved at least 1 pass at 9-1 |
|
AVERAGE_A8_MATHS |
9.454545455 |
Average A8 Maths per student |
|
AVERAGE_A8_ENGLISH |
10.49090909 |
Average A8 English per student |
|
AVERAGE_A8_EBACC |
14.66590909 |
Average A8 Ebacc per student |
|
AVERAGE_A8_OPEN |
15.27386364 |
Average A8 Open per student |
|
SCHOOL_ATTAINMENT8 |
49.88522727 |
Whole School Attainment8 score following DfE methodology. |
|
PROPORTION_EBACC_ENTERED_ENGLISH |
0.981818 |
Proportion of the cohort entered for an award in English that counts towards Ebacc. Students must have awards in both Language and Literature to count in this metric. |
|
PROPORTION_EBACC_ENTERED_MATHS |
0.977273 |
Proportion of the cohort entered for an award in Maths that counts towards Ebacc. |
|
PROPORTION_EBACC_ENTERED_SCIENCE |
0.981818 |
Proportion of the cohort entered for an award in Science that counts towards Ebacc. |
|
PROPORTION_EBACC_ENTERED_HUMANITIES |
0.981818 |
Proportion of the cohort entered for an award in Humanities that counts towards Ebacc. |
|
PROPORTION_EBACC_ENTERED_LANGUAGES |
0.295455 |
Proportion of the cohort entered for an award in Languages that counts towards Ebacc. |
|
PROPORTION_ENTERED_EBACC |
0.295455 |
Proportion of the cohort entered for a complete set of awards that qualify for Ebacc. |
|
PROPORTION_EBACC_PASS_9_5_ENGLISH |
0.654545 |
Proportion of the cohort achieving grade 9-5 in an Ebacc-qualifying English award. |
|
PROPORTION_EBACC_PASS_9_5_MATHS |
0.540909 |
Proportion of the cohort achieving grade 9-5 in an Ebacc-qualifying Maths award. |
|
PROPORTION_EBACC_PASS_9_5_TWO_SCIENCES |
0.486364 |
Proportion of the cohort achieving grades 9-5 in an Ebacc-qualifying Science awards. |
|
PROPORTION_EBACC_PASS_9_5_HUMANITIES |
0.563636 |
Proportion of the cohort achieving grade 9-5 in an Ebacc-qualifying Humanities award. |
|
PROPORTION_EBACC_PASS_9_5_LANGUAGES |
0.172727 |
Proportion of the cohort achieving grade 9-5 in an Ebacc-qualifying Languages award. |
|
PROPORTION_EBACC_PASS_9_5_ALL |
0.136364 |
Proportion of the cohort achieving grades 9-5 in Ebacc-qualifying award i.e. proportion of the cohort who passed the Ebacc. |
|
AVERAGE_EBACC_POINTS_ENGLISH |
5.245454545 |
Average points per student from the best English qualification that counts towards Ebacc. Students must have awards in both Language and Literature to count in this metric. |
|
AVERAGE_EBACC_POINTS_MATHS |
4.727272727 |
Average points per student from the best Maths qualification that counts towards Ebacc. |
|
AVERAGE_EBACC_POINTS_SCIENCE_AVERAGE |
4.7625 |
Average points per student from the best Science qualifications that count towards Ebacc. |
|
AVERAGE_EBACC_POINTS_HUMANITIES |
4.909090909 |
Average points per student from the best Humanities qualification that counts towards Ebacc. |
|
AVERAGE_EBACC_POINTS_LANGUAGES |
1.554545455 |
Average points per student from the best Languages qualification that counts towards Ebacc. |
|
AVERAGE_EBACC_AVERAGE_POINTS_SCORE |
4.327045455 |
Average Ebacc APS per student. This uses the six best possible qualification results across the five Ebacc pillars. |
SUMMATIVE_A8_EBACC
A data set that offers both Attainment 8 and English Baccalaureate analysis for student’s summative assessment data.
|
Column name |
Description |
|
APPLICATION_ID |
The Arbor MIS application identifier. Each MIS installation (school) has a unique application ID. The details of each school can be found in the `SCHOOLS` table, which can be joined via ‘APPLICATION_ID’ |
|
STUDENT_ID |
The Arbor student identifier. Student details can be joined via the `STUDENTS` table |
|
PERIOD_NAME |
Assessment period (or “data drop”) name |
|
PERIOD_START |
The start date of the assessment period |
|
PERIOD_END |
The end date of the assessment period |
|
N_RESULTS |
The number of results taken into account for that assessment period |
|
SCIENCE_TYPE |
Science Type: Has values of Double for Combined Science awards or Single for all other Science awards |
|
AVERAGE_POINT_SCORE_OVERALL |
Average Point Score - calculated across all approved results awarded to the student |
|
BEST8_POINT_SCORE_ACROSS_ALL_RESULTS |
Average Point Score of the best 8 results awarded to the student |
|
POINTS_ENGLISH |
From the best grade in an English qualification |
|
POINTS_MATHS |
From the best grade in a Maths qualification |
|
POINTS_SCIENCE_1 |
First best grade in a Science qualification |
|
POINTS_SCIENCE_2 |
Second best grade in a Science qualification |
|
POINTS_HUMANITIES |
From the best grade in a Humanities qualification |
|
POINTS_LANGUAGES |
From the best grade in a Languages qualification |
|
PASS_9_5_AT_LEAST_5_RESULTS |
Has the student achieved at least 5 passes with grades 9-5? |
|
PASS_9_5_AT_LEAST_5_RESULTS_INC_ENG_MATH |
Has the student achieved at least 5 passes with grades 9-5 including English & Maths awards? |
|
PASS_9_4_AT_LEAST_5_RESULTS |
Has the student achieved at least 5 passes with grades 9-4? |
|
PASS_9_4_AT_LEAST_5_RESULTS_INC_ENG_MATH |
Has the student achieved at least 5 passes with grades 9-4 including English & Maths awards? |
|
PASS_9_1_AT_LEAST_5_RESULTS |
Has the student achieved at least 5 passes with grades 9-1? |
|
PASS_9_1_AT_LEAST_1_RESULT |
Has the student achieved at least 1 pass with grades 9-1? |
|
A8_MATHS |
Calculated Attainment8 score for Maths bucket |
|
A8_ENGLISH |
Calculated Attainment8 score for English bucket |
|
A8_EBACC |
Calculated Attainment8 score for Ebacc bucket |
|
A8_OPEN |
Calculated Attainment8 score for Other bucket |
|
ATTAINMENT8 |
Calculated Attainment8 score following DfE methodology |
|
EBACC_ENTERED_ENGLISH |
Does the student have a mark in English that counts towards Ebacc? |
|
EBACC_ENTERED_MATHS |
Does the student have a mark in Maths that counts towards Ebacc? |
|
EBACC_ENTERED_SCIENCE |
Does the student have a mark in Science that counts towards Ebacc? |
|
EBACC_ENTERED_HUMANITIES |
Does the student have a mark in Humanities that counts towards Ebacc? |
|
EBACC_ENTERED_LANGUAGES |
Does the student have a mark in Languages that counts towards Ebacc? |
|
ENTERED_EBACC |
Does the student have a marks in a complete set of P8 assessments that count towards Ebacc? |
|
EBACC_PASS_9_5_ENGLISH |
Has the student achieved grade 9-5 in an Ebacc-qualifying English P8 Assessment? |
|
EBACC_PASS_9_5_MATHS |
Has the student achieved grade 9-5 in an Ebacc-qualifying Maths P8 Assessment? |
|
EBACC_PASS_9_5_TWO_SCIENCES |
Has the student achieved grade 9-5 in an Ebacc-qualifying Science P8 Assessment? |
|
EBACC_PASS_9_5_HUMANITIES |
Has the student achieved grade 9-5 in an Ebacc-qualifying Humanities P8 Assessment? |
|
EBACC_PASS_9_5_LANGUAGES |
Has the student achieved grade 9-5 in an Ebacc-qualifying Language P8 Assessment? |
|
EBACC_PASS_9_5_ALL |
Has the student achieved grade 9-5 in all Ebacc-qualifying P8 Assessments? |
|
EBACC_POINTS_ENGLISH |
Points from the best English P8 assessment that counts towards Ebacc. The student must have results in both Language and Literature to count in this metric |
|
EBACC_POINTS_MATHS |
Points from the best Maths P8 assessment that counts towards Ebacc |
|
EBACC_POINTS_SCIENCE_AVERAGE |
Points from the best Science P8 assessment that counts towards Ebacc |
|
EBACC_POINTS_HUMANITIES |
Points from the best Humanities P8 assessment that counts towards Ebacc |
|
EBACC_POINTS_LANGUAGES |
Points from the best Languages P8 assessment that counts towards Ebacc |
|
EBACC_AVERAGE_POINTS_SCORE |
Average Points Score across all Ebacc P8 assessments |
STAFF
A data set that contains personal, demographic and some role information.
|
Field |
Example Data |
Explanation |
|
person_unique_id |
uk_bns_131749-3-1455 |
Unique Staff ID (across all schools) |
|
school_id |
uk_bns_131749 |
School ID |
|
staff_id |
1455 |
Staff ID |
|
legal_first_name |
Jonathon |
Legal first name |
|
legal_last_name |
Doe-Saunders |
Legal surname |
|
preferred_first_name |
John |
Staff member's preferred first name in Arbor if relevant |
|
preferred_last_name |
Doe |
Staff member's preferred last name in Arbor if relevant |
|
date_of_birth |
1973-03-10 |
Date of birth |
|
title |
Mr |
Title |
|
staff_number |
12345A |
Staff number entered in MIS |
|
legacy_system_id |
2532 |
ID from previous MIS if the school migrated to Arbor |
|
timetable_abbreviation |
JJD |
Name abbreviation used for short-display on timetables |
|
gender |
MALE |
Gender - options are Male, Female, Not Known, Not Specified |
|
country_of_birth |
GBR |
Country of birth code (as specified in CBDS) |
|
ethnicity |
WBRI |
Ethnicity code (as specified in CBDS) |
|
religion |
Christian |
Religion label (as specified in CBDS) |
|
continuous_service_start_date |
2016-09-01 |
Date staff member started employment with LA |
|
qualified_teacher_status |
1 |
Boolean field to specify Qualified Teacher Status |
|
early_years_teacher_status |
0 |
Boolean field to specify Early Years Teacher Status |
|
qualified_teacher_learning_and_skills_status |
1 |
Boolean field to specify Qualified Teacher Learning and Skill Status |
|
newly_qts_date |
null |
Date of Qualified Teacher Status for early career teachers |
|
higher_level_teaching_assistant_status |
0 |
Boolean to specify Higher Level Teaching Assistant status |
|
is_teaching_staff |
1 |
Boolean to denote if the staff member is a teacher, this is set by the Business Role in Arbor even if the QTS field is not set |
|
eligible_for_swfc_return |
1 |
Boolean to specify whether the member of staff should be returned in the School Workforce Census |
|
|
john.doe@brookscroft.ac.uk |
Default Email address |
|
has_active_role |
1 |
Has an Active business role in Arbor MIS - useful for schools that don't store Contract information in MIS |
|
is_slt |
0 |
Is the staff member part of the Senior Leadership Team? (denoted by their business roles or contract information) |
|
is_admin |
0 |
Is the staff member part of the Admin Team? (denoted by their business roles or contract information) |
STAFF_ABSENCES
Contains information about staff absences from School MIS (not central team staff).
|
Field |
Example Data |
Explanation |
|
ABSENCE_UNIQUE_ID |
uk_lds_999999-1-14352 |
Unique Absence ID (across all schools) |
|
RECORD_ID |
14352 |
ID of absence on the school site |
|
APPLICATION_ID |
uk_lds_999999 |
School ID |
|
STAFF_ID |
1156 |
Staff ID that the absence is linked to |
|
APPROVED_BY_STAFF_ID |
291 |
Staff ID of person approving the absence |
|
CALCULATED_WORKING_DAYS |
1 |
Working Days lost to absence calculated by Arbor |
|
ACTUAL_WORKING_DAYS |
1 |
Working Days lost to absence as entered by school |
|
WORKING_DAYS |
1 |
Working Days figure used in Arbor calculations (Actual working days entered is higher in preference to Calculated working days) |
|
CALCULATED_WORKING_HOURS |
7.5 |
Working Hours lost to absence calculated by Arbor |
|
ACTUAL_WORKING_HOURS |
7.5 |
Working Hours lost to absence as entered by school |
|
WORKING_HOURS |
7.5 |
Working Hours figure used in Arbor calculations (Actual working hours entered is higher in preference to Calculated working hours) |
|
START_DATETIME |
2022-05-04 08:00:00 |
Start datetime of absence |
|
END_DATETIME |
2022-05-04 18:00:00 |
End datetime of absence |
|
CATEGORY_CODE |
INTERVIEW |
Code of absence type |
|
CATEGORY_NAME |
Interview |
Name of absence type |
|
IS_PAID_LEAVE |
FALSE |
Whether the absence type counts as Paid Leave |
|
IS_PAID_HOLIDAY |
FALSE |
Whether the absence type counts as Paid Holiday |
|
IS_PAID_MATERNITY |
FALSE |
Whether the absence type counts as paid maternity leave |
|
IS_PAID_PATERNITY |
FALSE |
Whether the absence type counts as paid paternity leave |
|
IS_AUTHORIZED_ABSENCE |
TRUE |
Whether the absence has been authorised |
STAFF_CONTRACTS
Contains data relating to school staff only (not central staff recorded on MAT MIS).
|
Field |
Example Data |
Explanation |
|
UNIQUE_OBJECT_ID |
uk_lds_999999-462-8 |
Unique Staff Contract ID (across all schools) |
|
RECORD_ID |
462 |
Record ID of staff contract |
|
APPLICATION_ID |
uk_lds_999999 |
School ID |
|
STAFF_ID |
356 |
Staff ID |
|
CONTRACT_NAME |
Contract 1 |
Contract name |
|
CONTRACT_REFERENCE |
12345/JE |
Contract reference (not a mandatory field) |
|
ISSUED_DATE |
2009-01-01 00:00:00 |
Date contract was created |
|
START_DATE |
2009-02-01 00:00:00 |
Date contract is due to start |
|
EXPECTED_END_DATE |
Date contracted is expected to end |
|
|
END_DATE |
2019-08-31 00:00:00 |
Date contract was actually ended |
|
EMPLOYMENT_TYPE_CODE |
PERMANENT |
Employee employment type code. |
|
EMPLOYMENT_TYPE_NAME |
Permanent |
Name of Employment Type Code |
|
STAFF_ORIGIN_CODE |
NOTKWN |
Previous employer type of Staff member |
|
STAFF_ORIGIN_DESCRIPTION |
Not Known |
Description of previous employer type of Staff member |
|
STAFF_DESTINATION_CODE |
LEASEC |
Code of intended next employer type destination for Staff |
|
STAFF_DESTINATION_DESCRIPTION |
Remaining in the same LA - secondary school |
Description of intended next employer for Staff |
|
STAFF_LEAVING_REASON_CODE |
OTT |
Reason code for staff member leaving employment |
|
STEAFF_LEAVING_REASON_DESCRIPTIO |
Left for other teaching post |
Description of reason for staff member leaving employment |
|
STAFF_SUPERANNUATION_SCHEME_CODE |
LGSA |
Code for Superannuation scheme that Staff member belongs to. These codes are not set by Arbor |
|
STAFF_SUPERANNUATION_SCHEME_NAME |
Local Government Schools Association |
Description for Superannuation scheme that staff member belongs to. |
|
CONTRACT_POST_ID |
8 |
Internal ID of contract post |
|
CONTRACT_POST_JOB_TITLE |
Teaching Assistant |
Contract Post job title |
|
CONTRACT_POST_POSITION_ID |
8 |
Position linked to the Contract Post |
STAFF_CONTRACT_POST_SALARY
Contains further details around the post and salary linked to a contract for school staff (not central staff).
|
Field |
Example Data |
Explanation |
|
UNIQUE_OBJECT_ID |
uk_lds-999999-1-493 |
Unique Staff Contract ID (across all schools) |
|
RECORD_ID |
493 |
Record ID of staff salary record |
|
APPLICATION_ID |
uk_lds_999999 |
School ID |
|
GROSS_SALARY |
19490 GBP |
Gross salary amount with relevant currency notation |
|
HOURS_PER_WEEK |
55 |
Number of hours per work for the contract salary |
|
WEEKS_PER_YEAR |
52 |
Number of weeks per year for the contract salary |
|
FTE_HOURS_PER_WEEK |
55 |
Hours per week a full time equivalent employee would work in this post |
|
FTE_WEEKS_PER_YEAR |
52 |
Weeks per year a full time equivalent employee would work in this post |
|
EFFECTIVE_DATE |
2009-09-01 00:00:00 |
Start date for the contract salary |
|
END_DATE |
2010-03-31 00:00:00 |
End date for the contract salary |
|
SAFEGUARDED_PERIOD_START_DATE |
2009-09-01 00:00:00 |
Start date of any safeguarded period for the contract salary |
|
SAFEGUARDED_PERIOD_END_DATE |
2010-08-31 00:00:00 |
End date of any safeguarded period for the contract salary |
|
PAY_SCALE_ID |
7 |
ID link to payscale if relevant |
|
PAY_SCALE_GRADE_ID |
ID link to payscale grade if relevant |
|
|
PAY_SCALE_SPINAL_POINT_ID |
105 |
ID link to spine point if relevant |
|
STAFF_CONTRACT_POST_ID |
129 |
ID link to Staff Contract Post that salary refers to |
STAFF_POSITION
Information on staff positions that are linked from Staff Contracts.
|
Field |
Example Data |
Explanation |
|
UNIQUE_OBJECT_ID |
uk_lds_999999-1-5 |
Unique Staff Position ID (across all schools) |
|
RECORD_ID |
5 |
Record ID of staff position record |
|
APPLICATION_ID |
uk_lds_999999 |
School ID |
|
START_DATE |
2014-09-01 00:00:00 |
Start date for Position |
|
EXPECTED_END_DATE |
2017-08-31 00:00:00 |
Expected end date for Position |
|
POSITION_NAME |
Business Manager |
Position title |
|
POSITION_REFERENCE |
BUSS |
Reference code for Position |
|
EXPECTED_HOURS_PER_WEEK |
37 |
Expected hours per week for this position |
|
EXPECTED_WEEKS_PER_YEAR |
52 |
Expected weeks per year for this position |
|
FTE_HOURS_PER_WEEK |
37 |
Full time equivalent hours per week for this position |
|
FTE_PROPORTION |
1 |
Full time equivalent proportion for position |
|
POSITION_BUSINESS_ROLE_ID |
ID of default business role for position |
|
|
POSITION_BUSINESS_ROLE_RANKING |
Rank position of default business roles assigned to position |
STAFF_UKDFE_POSITION
A link table between Staff positions and their DfE lookup value.
|
Field |
Example Data |
Explanation |
|
UNIQUE_OBJECT_ID |
uk_lds_999999-1-11 |
Unique DfE Staff Position ID (across all schools) |
|
RECORD_ID |
11 |
Record ID of staff DfE position record |
|
APPLICATION_ID |
uk_lds_999999 |
School ID |
|
WORKFORCE_CENSUS_ROLE_IDENTIFIER |
BUSS |
Role identifier of position in Workforce Census |
|
UKDFE_POSITION_CATEGORY_CODE |
OSP |
DfE category code for Position |
|
UKDFE_POSITION_CATEGORY_LABEL |
Other Support Staff |
DfE description for Position |
USER_DEFINED_FIELDS
Details of user defined fields created in school or MAT MIS.
|
Field |
Example Data |
Explanation |
|
UNIQUE_OBJECT_ID |
uk_swd_62341-913-27 |
Unique ID of the user defined field across all databases |
|
RECORD_ID |
27 |
ID of the user defined field record |
|
APPLICATION_ID |
uk_swd_62341 |
Arbor school ID |
|
CODE |
SCHOOL_STUDENT_LAPTOP_NUMBER |
Code for the user defined field |
|
FIELD_NAME |
Student Laptop Number |
Name of the user defined field |
|
FIELD_TYPE |
Long_Text |
Type of user defined field |
|
IDENTIFIER |
LAPTOP |
Identifier if entered in Arbor |
|
RELATED_ENTITY_TYPE |
STUDENT |
What type of record the user defined field relates to |
|
UDF_SOURCE |
SCHOOL |
Where the UDF was created -values are SCHOOL or GROUP |
USER_DEFINED_RECORDS
Details of records created for a User Defined Field.
|
Field |
Example Data |
Explanation |
|
UNIQUE_OBJECT_ID |
uk_swd_62341-912-68 |
Unique ID of the user defined record across all databases |
|
RECORD_ID |
68 |
ID of the user defined record |
|
APPLICATION_ID |
uk_swd_6234 |
Arbor school ID |
|
UDF_OBJECT_TYPE |
UserDefinedField_Model |
Internal code of user defined field |
|
UDF_OBJECT_ID |
26 |
Internal ID of user defined field |
|
ENTITY_OBJECT_TYPE |
Student_Model |
Type of user defined field this record relates to. Can be joined to USER_DEFINED_FIELDS.RELATED_ENTITY_TYPE |
|
ENTITY_OBJECT_ID |
3 |
ID of user defined field this record relates to. Can be joined to USER_DEFINED_FIELDS.RECORD_ID |
|
VALUE |
A324567 |
Value of the user defined record |
USER_LOGINS
Details of user login events.
|
Field |
Example Data |
Explanation |
|
UNIQUE_OBJECT_ID |
uk_arb_62341-60-75 |
Unique record ID (across all databases) |
|
RECORD_ID |
75 |
Database ID for record |
|
APPLICATION_ID |
uk_arb_62341 |
Arbor school ID |
|
USER_UNIQUE_ID |
uk_arb_62341-1-67 |
Unique user ID (across all databases) |
|
IP_ADDRESS |
142.250.217.78 |
IP address of login location |
|
USER_AGENT |
Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.90 Safari/537.36 |
Information on method of access |
|
TWO_FACTOR_AUTHENTICATION_METHOD |
SMS |
Method used for 2 Factor Authentication - valid options are SMS and YUBIKEY |
|
IDENTITY_PROVIDER |
ARBOR |
Identity provider for Login - valid options are ARBOR, ARBOR_GROUP |
|
LOGIN_DATETIME |
2022-10-01 08:30:00 |
Date/time of login |
PASSWORD_RULES
Details of password rules set for each Arbor application.
|
Field |
Example Data |
Explanation |
|
UNIQUE_OBJECT_ID |
uk_arb_139317-983-1 |
Unique record ID (across all databases) |
|
RECORD_ID |
1 |
Database ID for record |
|
APPLICATION_ID |
uk_arb_139317 |
Arbor school ID |
|
APPLIES_FOR |
STAFF |
Who the rule applies to - valid options are STAFF, GUARDIAN, STUDENT |
|
MIN_LENGTH |
7 |
Minimum length needed for password |
|
DAYS_VALID |
180 |
Number of days before the password expires |
|
REQUIRE_NUMBER |
TRUE |
Whether the password should have at least 1 number in it |
|
REQUIRE_LETTER |
TRUE |
Whether the password should have at least 1 letter in it |
|
REQUIRE_MIXED_CASE |
FALSE |
Whether the password should have upper and lower case letters |
ACADEMIC_UNITS
Information on courses/classes created within each academic year.
|
Field |
Example Data |
Explanation |
|
UNIQUE_OBJECT_ID |
uk_arb_19274-109-5700 |
Unique record ID (across all databases) |
|
APPLICATION_ID |
uk_arb_19274 |
Arbor school ID |
|
RECORD_ID |
5700 |
Database ID for record |
|
PARENT_ACADEMIC_UNIT_ID |
3412 |
ID of Parent Academic Unit in Courses structure. Will be empty if this is a top-level course |
|
ACADEMIC_UNIT_CODE |
AR__YEAR_10__10_B_AR |
Internal code of the Academic Unit (generated automatically from the Name) |
|
ACADEMIC_UNIT_NAME |
10 'B' / Ar |
Name of the Academic Unit as seen in Arbor |
|
ACADEMIC_YEAR_ID |
17 |
Academic Year ID that the Academic Unit belongs to |
|
ACADEMIC_UNIT_LEAD_ID |
6618 |
ID of linking record for Academic Lead |
|
ACADEMIC_UNIT_LEAD_STAFF_ID |
297 |
Staff ID of the Academic Unit Lead |
|
ACADEMIC_LEVEL_ID |
105 |
Academic Level ID for linked Curriculum level |
|
SUBJECT_ID |
3 |
Subject ID |
|
SUBJECT_CODE |
ART |
Internal Subject Code |
|
SUBJECT_NAME |
Art & Design |
Subject name as seen in Arbor |
|
IS_MAIN_ASSESSABLE_UNIT |
FALSE |
Is this a main assessable academic unit? |
|
DEPARTMENT_ID |
2 |
ID of department linked to Academic Unit |
ACADEMIC_UNIT_ENROLMENTS
Details of Student enrolments into an Academic Unit.
|
Field |
Example Data |
Explanation |
|
UNIQUE_OBJECT_ID |
uk_arb_19274-109-5700 |
Unique record ID (across all databases) |
|
APPLICATION_ID |
uk_arb_19274 |
Arbor school ID |
|
RECORD_ID |
99275 |
Database ID for record |
|
ACADEMIC_UNIT_ID |
5700 |
Link to the Academic Unit for the enrolment |
|
ACADEMIC_UNIT_UNIQUE_ID |
uk_arb_19274-109-5700 |
Unique record ID (across all databases) |
|
STUDENT_ID |
1579 |
Student ID for the enrolment |
|
STUDENT_UNIQUE_ID |
uk_arb_19274-1-1579 |
Unique student ID (across all databases) |
|
START_DATE |
2018-09-03 00:00:00 |
Enrolment Start Date |
|
END_DATE |
2018-09-20 00:00:00 |
Enrolment End Date |
|
ENROLMENT_STATUS |
Enrolled |
Current Enrolment Status |
|
REPEAT_ENROLMENT |
FALSE |
TIMETABLE_SLOTS
Information for Timetable Slots created for Events (Courses & Classes, Clubs etc).
|
Field |
Example Data |
Explanation |
|
UNIQUE_OBJECT_ID |
uk_arb_19274-752-17477 |
Unique record ID (across all databases) |
|
APPLICATION_ID |
uk_arb_19274 |
Arbor school ID |
|
RECORD_ID |
17477 |
Database ID for record |
|
LOCATION_TYPE |
Room_Model |
Type of Location for timetable slot |
|
LOCATION_ID |
123 |
Location ID of linked location |
|
ACADEMIC_YEAR_ID |
20 |
Academic Year that the Timetable Slot belongs to |
|
DAY_OF_CYCLE |
3 |
Day of Cycle of Slot (1-5 or 1-10 depending on setup). Will be empty if DAY_OF_WEEK is present |
|
DAY_OF_WEEK |
Day of week of the timetable slot (1-5) Will be empty if DAY_OF_CYCLE is present |
|
|
TERM_TIME_ONLY |
TRUE |
Whether the Timetable Slot is in school term-time only |
|
WORKING_HOURS |
||
|
START_TIME |
10:25:00 |
Start Time of Timetable Slot |
|
END_TIME |
10:50:00 |
End Time of Timetable Slot |
|
EFFECTIVE_DATE |
2015-12-05 00:00:00 |
Start Date for repeating Timetable Slot |
|
END_DATE |
2016-07-20 00:00:00 |
End Date for repeating Timetable Slot |
|
FREQUENCY |
WEEK |
Frequency of Timetable Slot - options are CYCLE or WEEK |
|
STATUS |
SCHEDULED |
Status of Timetable Slot - options are PROVISIONAL, SCHEDULING, SCHEDULED, RESCHEDULING, DELETING, DELETION_FAILED |
|
TIMETABLED_OBJECT_TYPE |
AcademicUnit_Model |
Type of Timetabled entity |
|
TIMETABLED_OBJECT_ID |
4924 |
Record ID of the Timetabled entity |
TIMETABLE_SLOT_STAFF_ASSIGNMENTS
Details of Staff assigned to Timetable slots, link to STAFF to get extra details.
|
Field |
Example Data |
Explanation |
|
APPLICATION_ID |
uk_arb_19274 |
Arbor School ID |
|
TIMETABLE_SLOT_UNIQUE_ID |
uk_arb_19274-752-17477 |
Unique Record ID (across all databases) |
|
TIMETABLE_SLOT_ID |
17477 |
Record ID for Timetable Slot |
|
STAFF_UNIQUE_ID |
uk_arb_19274-3-17477 |
Unique Staff ID linked to Timetable Slot |
|
STAFF_ID |
17477 |
Staff Record ID for Timetable Slot |
Comments
Article is closed for comments.