This article provides a comprehensive overview of the datasets available in V1 of Arbor's BI Connector - this product has now been sunset, any dashboards that you have using this version will no longer work and will error.
V1 has datasets related to attendance, behaviour incidents, enrolments, exclusions, student demographics, academic performance, and staff information. Each dataset includes specific fields, example data, and explanations to assist users in understanding the data structure and its applications.
Below you'll find a list of all the available datasets for Version 1 of our connector, which is sometimes referred to as a Data Dictionary.
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
Please note that this dataset refers to Suspensions in Arbor. We will be adding a new renamed dataset for this at a future date.
| 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 | William | Legal first name |
| LEGAL_LAST_NAME | Wilson | Legal surname |
| DATE_OF_BIRTH | 2008-07-21 | Date of birth |
| PREFERRED_FIRST_NAME | Bill | Preferred first name if exists, otherwise blank |
| PREFERRED_LAST_NAME | Wilson-Jones | Preferred last name if exists, otherwise blank |
| SEX | MALE | Sex |
| 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 (does not necessarily impact their education)? |
| 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? |
| 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.
| 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. Valid values are: ASPIRATIONAL_TARGET, FINAL_TARGET, NATIONAL_EXPECTED_ATTAINMENT_TARGET, NATIONAL_EXPECTED_PROGRESS_TARGET, OPERATIONAL_TARGET, PREDICTED_ASSESSMENT_MARK, PROGRESS_BASELINE, SCHOOL_ATTAINMENT_TARGET, SCHOOL_PROGRESS_TARGET, TEACHER_PROGRESS_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 (proportion who passed). |
| 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 |
| sex | MALE | Sex - 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_CONTRACT
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_FIELDS_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 |
AD_HOC_ASSESSMENT_MARKS
| Field | Example Data | Explanation |
| APPLICATION_ID | uk_arb_19274 | Arbor School ID |
| STUDENT_ID | 1234 | Arbor Student ID |
| PERSON_UNIQUE_IDENTIFIER | uk_swd_137264_1234 | Concatenation of Application_ID and Student_ID to give a unique identifier across all databases |
| ASSESSMENT_UNIQUE_IDENTIFIER | uk_demo_pams2-930-5 | This is a unique identifier for the assessment |
| ASSESSMENT_UNIQUE_IDENTIFIER | uk_demo_pams2-930-5 | This is a unique identifier for the assessment |
| ASSESSMENT_NAME | Attitude to Learning | Name of the assessment entered by the user |
| ASSESSMENT_CODE | ATTITUDE_TO_LEARNING | Derived from assessment name |
| KEY_STAGE_CODE | 3 | Code for the ad hoc assessment key stage |
| KEY_STAGE_NAME | KS3 | Name of key stage for the ad hoc assessment |
| MARK_DATA_TYPE | GRADE | The type of mark the ad-hoc will use - Grade, Number or Text |
| ASSESSMENT_STRATEGY | ONE_MARK_PER_ACADEMIC_UNIT | Determines if there will be a separate grade per course or if the one mark will apply to all courses |
| MARK_UNIQUE_IDENTIFIER | uk_demo_pams2-933-7718 | A unique identifier for the mark |
| LINKED_ACADEMIC_UNIT_ID | 482 | Academic unit id linked to the ad hoc assessment |
| UNIQUE_LINKED_ACADEMIC_UNIT_ID | uk_demo_pams2-109-482 | Unique academic unit id linked to the ad hoc assessment |
| GRADE_NAME | 6c | Grade |
| GRADE_TEXT | A | Text for grade given |
| GRADE_NUMBER | 7 | Numbered grade given |
| NON_SUBMISSION_REASON | NULL | Reason selected where a mark has not been added. Valid values are 'Absent', 'Not enrolled' or 'Not required' |
| ASSESSMENT_REFERENCE_DATE | 2021-08-31 23:00:00 | Date/period the Assessment is in relation to |
| MARKING_STAFF_ID | 1156 | Staff Id of the member of staff marking the assessment |
Comments
Article is closed for comments.