You are here

Party time period reference data standard

Standard identifier: 
ISB-00279
Standard Type: 
Business Data Standards
Version: 
1.00
BDA Version: 
5.07
Status: 
Approved: Recommended
Date of Standard: 
Monday, 8 December 2014
Category: 
Courses and qualifications
Party (including organisation and person)
Target audience: 
Data modellers
ICT procurers
Statisticians
System developers or programmers
Introduction: 

A party time period reference is a reference structure that is owned and defined by a party so that it can be used as part of the description of an event defined by a party, to identify a specific division of a Financial Year, Week, Term, Financial Quarter, Academic Year etc.

Introduction

Application

A party time period reference is a reference structure that is owned and defined by a party so that it can be used as part of the description of an event defined by a party, to identify a specific division of a Financial Year, Week, Term, Financial Quarter, Academic Year etc.

Compatibility with non-ISB standards

There are no known compatibility issues related to this standard.

Terminology and notation

The following sections contain:

  • Entity Definition Model – A high level diagram showing: entities; their descriptions and relationships

  • Attribute Model – A lower level diagram showing the names of attributes making up entities. Attributes in the top section of an entities box are those making up its primary key

  • Data Definitions – Detailed descriptions of each of the entities at an attribute level, showing attribute: name; definition; whether it is part of a key; whether it is mandatory; its data type and format; parent information and Controlled List association

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.

The standards for naming, notation and conventions used for this development can be found in the BDA Data Architecture Modelling Standards document. For convenience, a quick reference of the colours used in these diagrams is shown below.

Entity Definition Model

Attribute Model

 

 

Data definitions: 
Entity
Party Time Period Reference

A Reference that identifies divisions of scheduled time such as:

a) Term periods e.g. Spring Term, Summer Term etc.

b)  Weeks e.g. Week 1, Week 2 etc.

c) Days of the week e.g. Monday, Tuesday etc.

d) Financial Quarters e.g. Financial Quarter 1, Financial Quarter 2 etc.

e) Financial Years e.g. Financial Year 2011

f) Study periods during a day

As the Time Period is a reference ID that is used repeatedly, it contains the time start and end of the period reference. It does not have any actual date occurrences references. For the actual dates that apply in a particular instance of the period, these are added in the PARTY TIME PERIOD that links a particular TIME PERIOD to its actual start and end date and to a PARTY SCHEDULE.

Attribute NameAttribute DefinitionPKFKMDatatypeFK Source EntityFK Source AttributeControlled List
Party_Id_Creator
A value that denotes and distinguishes the PARTY.
Y
Y
Y
Unicode_String(1,32)
Party
Party_Id
Party_Time_Period_Reference
A Reference that identifies divisions of scheduled time such as: a) Term periods eg Spring Term, Summer Term etc. b) Weeks eg Week 1, Week 2 etc. c) Days of the week eg Monday, Tuesday etc. d) Financial Quarters eg Financial Quarter 1, Financial Quarter 2 etc. e) Financial Years e.g. Financial Year 2011. The PARTY TIME PERIOD REFERENCE does not contain dates/times as it is used repeatedly and only holds information common to all uses of that reference. For the actual dates and times that apply in a particular instance of the period, these are added in the PARTY TIME PERIOD that links a particular TIME PERIOD to its actual start and end date/time and to a PARTY SCHEDULE.
Y
N
Y
Unicode_String(1,50)
Time_Period_Type
A controlled list of values that identifies the scheduled time subdivision of a PARTY TIME PERIOD REFERENCE E.g. "Year", "Term", "Week", "Day", "Morning", "Afternoon", etc.
N
Y
Y
Unicode_String(1,50)
Time Period Type
Party_Time_Period_Ref_Descr
Narrative details about the PARTY TIME PERIOD REFERENCE.
N
N
N
Unicode_String(1,2000)
Record_Delete_Flag
A flag that indicates that the record should be deleted.
N
N
N
Simple_Flag
Changes from previous version: 

This is a new data standard that was formerly part of the Party Schedule business data standard.

References: 

The following references are specific to this Business Data Standard:

  • ESCS ISB Business Data Architecture Entity Relationship Diagram, version 5.07.

  • ESCS ISB, Controlled List, Time Period Type

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