Documentation

Design Table Design Examiner Table Attribute Name

Data Type Default Input Mask Required Lookup In AQA Purpose Value spec?

Examiner Number

Text

Null

000000

Yes

None

Yes

To hold a unique examiner identifier

Examiner Forename

Test

Null

None

Yes

None

Yes

To hold the examiner's first name

Examiner Surname

Text

Null

None

Yes

None

Yes

To hold the examiner's last name

Examiner Address Line 1

Text

Null

None

Yes

None

Yes

To hold the examiner's address

Examiner Address Line 2

Text

Null

None

Yes

None

Yes

To hold the examiner's address

Examiner Address Line 3

Text

Null

None

Yes

None

Yes

To hold the examiner's address

Subject Text Reference Code

Null

00000

Yes

Subject Yes Table

To hold the code representing the subject which the examiner marks

Tax Flag

False

None

Yes

None

To represent the examiner's possession, or lack thereof, a tax deduction

Boolean

Yes

Subject Table Attribute Name

Data Type Default Input Mask Required Lookup In AQA Purpose Value spec?

Subject Text Reference Code

Null

00000

Yes

None

Yes

To hold a unique subject identifier

Payment

Null

None

Yes

None

Yes

To be used to calculate examiner payments

Currency

Scripts Table Attribute Name

Data Type Default Input Mask Required Lookup In AQA Purpose Value spec?

Centre Number

Integer

Null

Range Check of (10000 79999)

Yes

None

Yes

To hold a unique examiner identifier combined with the Examiner Number

Examiner Number

Test

Null

000000

Yes

None

Yes

To hold a unique examiner identifier combined with the Centre Number

Subject Text Reference Code

Null

00000

Yes

None

Yes

To hold the subject reference code

Number of Integer Candidates

Null

Range Yes check (>0)

None

Yes

To hold the number of candidates being marked from one centre, and by one examiner.

Entity Relationship Diagram

Structure Chart