ISB Business Data Standard ISB QE Outcome Carry Forward. BDA Version: Education, Skills and Children's Services ERD vs 12

(1)

ISB-000043

QE Outcome Carry Forward

BDA Version: Education, Skills and Children's Services ERD vs 12 ISB Number: ISB-000043

Version Number: 3.0 Issue Date: 26/04/2016 Document Version History:

Version Status Issue Date Modified by Description 1.0 Approved:

Recommended

23/07/2013 ISB Approved as Recommended Status

2.0 Approved: Recommended

04/08/2014 ISB New attribute Carry_Forward_Series_Label.

3.0 Approved: Recommended

26/04/2016 ISB Add identifying attribute QE_Outcome_Date_Time data type Simple_DateTime

(2)

Page 2 of 14

The following references apply to all Business Data Standards:

- ESCS ISB Standards Overview and Context

- ESCS ISB "System" Enterprise Architecture - Business Data Architecture - ESCS ISB Business Data Architecture Data Types

- ESCS ISB BDA Data Architecture Modelling Standards - ESCS ISB Management Process

Only those entities within the boundary square in the diagrams are part of this particular data standard, entities outside the boundary are shown for context purposes only (and can be found within other Business Data Standards), or separate Controlled List reference data.

(4)

Page 4 of 14

Subject Area

Subject Area Name Subject Area Definition

QE Outcome Carry Forward This standard can be used to store or exchange data that identifies a previously obtained Centre Assessed QE Outcome that they wish to associate with a specific LEARNER BOOKING.

(5)

Page 5 of 14

(6)

Page 6 of 14

Entity Definition

Entity Name Entity Definition

QE Outcome Carry Forward Specifies the details of a QE OUTCOME from a previous Series where the Mark or Grade is to be carried forward within the context of a QE LEARNER BOOKING.

The entity enables a CENTRE to provide as much detail about a previously obtained Centre Assessed Outcome(s) that they wish to associate with a specific LEARNER BOOKING. The identity of the QUALIFICATION ELEMENT that is the subject of the QE OUTCOME to be carried forward must be owned by the same AWARDING

ORGANISATION that owns the QUALIFICATION ELEMENT that the subject of the QE BOOKING.

(7)

Page 7 of 14

(8)

Page 8 of 14

Attribute Definitions

QE Outcome Carry Forward

Attribute Name Attribute Definition Attribute Required

Attribute Is PK

Attribute Is FK

Attribute Note Attribute History Event Description

Attribute Basename Awarding_

Organisatio n_Party_Id

A value that denotes and distinguishes the PARTY.

Yes Yes Yes Migrated foreign key

from QE Learner Booking. Awarding_Organisation _Party_Id Centre_Par ty_Id

from QE Learner Booking. Centre_Party_Id AO_Qualifi cation_Ele ment_Id

A value that uniquely identifies a specific part of a Qualification and applies to one or more QUALIFICATION ELEMENT(s) within an AWARDING ORGANISATION.

Yes Yes Yes The same value

may be used for a number of QUALIFICATION ELEMENTS provided they are differentiated by Qualification_Ele ment_Type.

Migrated foreign key from QE Learner Booking. AO_Qualification_Elem ent_Id Qualificatio n_Element _Type A controlled list of values that denotes the type and behaviour of the specific QUALIFICATION ELEMENT. Values are "Scheme", "Award", "Learning Unit", "Pathway", "Assessable".

from QE Learner Booking. Qualification_Element_ Type QEA_Effect ive_Start_D ate_Time

The effective date and time of the QE AVAILABILITY.

from QE Learner Booking. QEA_Effective_Start_D ate_Time QE_Bookin g_Date_Ti me

The specific date and time that the QE BOOKING was created.

from QE Learner Booking.

QE_Booking_Date_Tim e

(9)

Page 9 of 14

Learner_Pa rty_Id

from QE Learner Booking.

Learner_Party_Id

AO_QE_Id _CAO

A value that uniquely identifies a specific part of a Qualification and applies to one or more QUALIFICATION ELEMENT(s) within an AWARDING ORGANISATION.

Yes Yes Yes The same value

may be used for a number of QUALIFICATION ELEMENTS provided they are differentiated by Qualification_Ele ment_Type.

Migrated foreign key from Qualification Element. AO_Qualification_Elem ent_Id QE_Type_ CAO A controlled list of values that denotes the type and behaviour of the specific QUALIFICATION ELEMENT. Values are "Scheme", "Award", "Learning Unit", "Pathway", "Assessable".

from Qualification Element. Qualification_Element_ Type QE_Outco me_Date_T ime

The date and time that the QE OUTCOME was announced.

Yes Yes No Created in current

model QE_Outcome_Date_Ti me Centre_Par ty_Id_CAO _Originator

No No Yes Migrated foreign key

from Party. Party_Id AO_Candid ate_Numbe r_CAO The AO Candidate Number being used for this LEARNER at the time the QE OUTCOME originated. This QE Outcome (Centre Assessed Outcome) is being carried No No No Created in current model AO_Candidate_Numbe r_CAO

(10)

Page 10 of 14

forward for the specific QE LEARNER BOOKING. Carry_Forw ard_Additio nal_Details Allows a CENTRE to supplement the information provided for the Carry

Forward to facilitate the receiving AWARDING ORGANISATION to identify the optimal QE OUTCOME(s) to consider for the specific LEARNER BOOKING. This could include other details to assist identifying the CENTRE, or the LEARNER, or Series No No No Created in current model Carry_Forward_Additio nal_Details Carry_Forw ard_Series _Label The AWARDING ORGANISATION's label for the session within an academic year when the QE OUTCOME originated. This session is usually referred to as a Series and has a simple name, such as June 2013.

No No No The series from

which the outcome to be carried forward originated. AWARDING ORGANISATION (s) will harmonise on values to be used. See JCQ A2C Appendix 2 (Series_Label) for a harmonised list which covers the exam series currently in use.

Created in current model

Carry_Forward_Series_ Label

(11)

Page 11 of 14

Attribute ISB Logical Data Types

Entity Name

QE Outcome Carry Forward

Attribute Name

Awarding_Organisation_Party_Id

UDP ISB Logical Data Type

Unicode_String(1,32) Centre_Party_Id

Unicode_String(1,32) AO_Qualification_Element_Id

Unicode_String(1,50) Qualification_Element_Type

Unicode_String(1,32) QEA_Effective_Start_Date_Time

Simple_DateTime QE_Booking_Date_Time

Simple_DateTime Learner_Party_Id

Unicode_String(1,32) AO_QE_Id_CAO

Unicode_String(1,50) QE_Type_CAO

(12)

Page 12 of 14 Entity Name

QE_Outcome_Date_Time

Simple_DateTime Centre_Party_Id_CAO_Originator

Unicode_String(1,32) AO_Candidate_Number_CAO

Unicode_String(4,4) Carry_Forward_Additional_Details

Unicode_String(1,400) Carry_Forward_Series_Label

(13)

Page 13 of 14

Changes from Previous Version

Entity Change

(14)

Page 14 of 14

Copyright Notice

The Information Standards Board (ISB) is an advisory body to the Department for Education (DfE) and the Department for Business, Innovation and Skills (BIS). The information it produces is subject to Crown copyright, which is administered by the National Archives.

The Crown copyright protected information in this document (other than ISB or Departmental logos) may be reproduced free of charge in any format or medium under the terms of the Open Government Licence, available from the National Archives website.

Any reuse is subject to the material being reproduced accurately and not used in a misleading context. It must be acknowledged as being protected by Crown copyright and the title of the source material must be supplied with the ISB named as the corporate author.

Authorisation to reproduce any information which is identified as being the copyright of a third party must be obtained from the copyright holders concerned

ISB Business Data Standard ISB QE Outcome Carry Forward. BDA Version: Education, Skills and Children's Services ERD vs 12

ISB-000043

QE Outcome Carry Forward

Table of Contents

The following references apply to all Business Data Standards:

Subject Area

Entity Definition

Attribute Definitions

Attribute ISB Logical Data Types

Changes from Previous Version

Copyright Notice