Microsoft Power BI Connector Datasets

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.
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 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

email

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

Was this article helpful?
1 out of 1 found this helpful
I'm still stuck!

Comments

0 comments

Article is closed for comments.