# 4 Conceptual Model

## 4.1 Conceptual

## Conceptual Model 3.4.6

The conceptual model is at the level of entities and relations between them; attributes are not listed. All objects in the Australian data model are represented; some objects are represented as relations between entities, rather than as distinct entities. For clarity, the conceptual model is broken up into use cases:

- Enrolment
- Account Provisioning
- Timetable/Attendance
- Finance/Resources
- NAPLAN
- Wellbeing
- Classroom Assessment
- Scheduling
- Statistics
- Teaching and Learning
- Reporting Collections

## Entity Diagram/Table Conventions

Entities are named with names that the schools sector business can relate to readily, rather than the current names of SIF AU objects.

The conceptual model uses UML conventions. Each class corresponds to one or more SIF objects. Abstract classes, which generalise from classes, are used to capture relations more economically; they are italicised in the diagrams.

Relations between classes, which correspond to SIF objects, are italicised in the Entity tables.

Alternatives are indicated with semicolon. Refinements/context on alternatives are indicated by italics and prefix. A colon is used to introduce the context in which an alternative representation is applicable.

## Relation Table Conventions

The comma-delimited objects enumerated are the set of objects which together represent the relationship, including the two objects containing the join attribute and the object joining the two, where applicable.

If an object is optional for the relation to be expressed, it is put in brackets.

If two objects are alternatives for each other in the relation presented, they are represented by { Object1, Object 2 }. (See Account Provisioning, for instance).

If there are multiple sets of objects which represent the relationship, they are semicolon-delimited: “A, B, C; Y, Z”.

Some objects are highly denormalised, to the extent that they contain data about both entities being related; in such cases, only a single object is needed to represent the relation.

## Enrolment

The following are the primary objects involved in enrolling a student onto school systems.

The following includes secondary objects which may also be invoked during student enrolment (shaded grey).

### Entities

Conceptual Entity | SIF AU Object/s
School | SchoolInfo
Student | StudentPersonal
enrolls | StudentSchoolEnrollment
Teacher | StaffPersonal
assigns roles | StaffAssignment
Parent/Student Contact | StudentContactPersonal
relationship with | StudentContactRelationship
Class | TeachingGroup; SectionInfo
member | StudentSectionEnrollment
Course | SchoolCourseInfo [relations coded redundantly with Class]
Subject | TimeTableSubject
EducationAuthority | LEAInfo
Term | TermInfo
Period | TimeTableCell
Room | RoomInfo
Program | SchoolProgram
participates | Program: StudentParticipation; Co-Curricular Activity: StudentActivityParticipation
Picture | PersonPicture
Co-Curricular Activity | StudentActivityInfo

### Relations

The following maps the relations captured in the conceptual model to sets of SIF AU objects.

Conceptual | SIF AU Object/s
A Student is enrolled in a School | StudentPersonal, StudentSchoolEnrolment, SchoolInfo
A Teacher is assigned a role in a School | StaffPersonal, StaffAssignment, SchoolInfo
A Parent/Student Contact has a relationship with a Student | StudentContactPersonal, StudentContactRelationship, StudentPersonal
A Teacher teaches/associates with a Class | StaffPersonal, TeachingGroup
A Class contributes to a Course | TeachingGroup, SchoolCourseInfo; SectionInfo, SchoolCourseInfo
A Subject is taught within a Class | TeachingGroup, TimeTableSubject
(A Class occurs during a Term) | SectionInfo, TermInfo
A Class is taught in a Room | TeachingGroup, RoomInfo
A Class is taught during a Period | TeachingGroup, TimeTableCell
A Course is taught within a School | SchoolCourseInfo, SchoolInfo
A Course is taught during a Term | SchoolCourseInfo, TermInfo
A Subject is part of a Course | TimeTableSubject, SchoolCourseInfo
A Subject is taught within a School | TimeTableSubject, SchoolInfo
A Term is administered by a School | TermInfo, SchoolInfo
A Student participates in a Co-Curricular Activity | StudentPersonal, StudentActivityParticipation, StudentActivityInfo
A School belongs to an Education Authority | SchoolInfo, LEAInfo
A School offers a Program | SchoolInfo, SchoolPrograms
A Student participates in a Program | StudentPersonal, StudentParticipation, SchoolPrograms

## Account Provisioning

Relations whose logical representation will be deprecated in SIF-AU 3.5 are marked in red.

### Entities

Relations which map to SIF objects are given in lowercase and are italicised

Conceptual Entity | SIF AU Object/s
Identity | Itentity
System | SystemRole
role | SystemRole
Picture | PersonPicture

### Relations

The following maps the relations captured in the conceptual model to sets of SIF AU objects.

Conceptual | SIF AU Object/s
A Student is a Party | StudentPersonal
A Teacher is a Party | StaffPersonal
A Parent/Student Contact is a Party | StudentContactPersonal
A Party has a Picture | {StudentPersonal, StaffPersonal, StudentContactPersonal}, PersonPicture
A Party asserts an Identity | {StudentPersonal, StaffPersonal, StudentContactPersonal}, Identity
A Party has a role on a System | {StudentPersonal, StaffPersonal, StudentContactPersonal}, SystemRole

## Timetable/Attendance

### Entities

Relations which map to SIF objects are given in lowercase and italicised

Conceptual Entity | SIF AU Object/s
School | SchoolInfo
Student | StudentPersonal
enrolls | StudentSchoolEnrollment
Teacher | StaffPersonal
assigns role | StaffAssignment
Class | TeachingGroup; SectionInfo; TimeTableContainer
member | StudentSectionEnrollment
Calendar | CalendarSummary
Day | CalendarDate
Period | TimeTableCell; SessionInfo; TimeTableContainer
TimeTable | TimeTable; TimeTableContainer
Scheduled Activity | ScheduledActivity
attendance marked for | Period: StudentPeriodAttendance; Calendar Day: StudentDailyAttendance, StudentAttendanceTimeList; reporting object: StudentAttendanceSummary

### Relations

The following maps the relations captured in the conceptual model to sets of SIF AU objects.

Conceptual | SIF AU Object/s
A Student is enrolled in a School | StudentPersonal, StudentSchoolEnrolment, SchoolInfo
A Teacher is assigned a role in a School | StaffPersonal, StaffAssignment, SchoolInfo
A Student is a member of a Class | StudentPersonal, TeachingGroup; StudentPersonal, StudentSectionEnrollment, SectionInfo
A Teacher teaches/associates with a Class | StaffPersonal, TeachingGroup
A Class is taught during a Period | TeachingGroup, TimeTableCell cyclic
A School has a Calendar | SchoolInfo, CalendarSummary
A Day belongs to a Calendar | CalendarDate, CalendarSummary
A Timetable is administered by a School | TimeTable, SchoolInfo
A Period belongs to a Timetable | TimeTableCell, TimeTable
A Scheduled Activity is scheduled for a Period | ScheduledActivity, TimeTableCell, (SessionInfo)
A Student attends a Scheduled Activity | ScheduledActivity, StudentPersonal
A Teacher attends a Scheduled Activity | ScheduledActivity, StaffPersonal
A Class is involved with a Scheduled Activity | ScheduledActivity, TeachingGroup
A Student has attendance marked for a Period | StudentPersonal, StudentPeriodAttendance, ({TimeTableCell, SessionInfo})
A Student has attendance marked for a Day | StudentPersonal, StudentDailyAttendance, (CalendarDate); StudentPersonal, StudentAttendanceTimeList, (CalendarDate)

## Finance/Resources

### Entities

Relations which map to SIF objects are given in lowercase and italicised

Conceptual Entity | SIF AU Object/s
School | SchoolInfo
Teacher | StaffPersonal
Parent/StudentContact | StudentContactPersonal
Equipment | EquipmentInfo
Resource Usage | ResourceUseage
Vendor | VendorInfo
Purchase Order | PurchaseOrder
Charged Location | ChargedLocation
Debtor | Debtor
Account | FinancialAccount
Journal | Journal
Invoice | Invoice
Receipt | PaymentReceipt

### Relations

The following maps the relations captured in the conceptual model to sets of SIF AU objects.

Conceptual | SIF AU Object/s
A Teacher engages in Resource Usage | StaffPersonal, ResourceUsage
A School pays for Resource Usage | SchoolInfo, ResourceUsage
A Teacher (Staff) raises a Purchase Order | StaffPersonal, PurchaseOrder
A Purchase Order is raised against a Vendor | PurchaseOrder, VendorInfo
A Purchase Order is raised for a Charged Location | PurchaseOrder, ChargedLocationInfo
A School is a Charged Location | SchoolInfo, ChargedLocationInfo
A Party is a Debtor | {StudentPersonal, StaffPersonal, StudentContactPersonal}, Debtor
A Vendor is a Debtor | VendorInfo, Debtor
A Charged Location has an Account | ChargedLocationInfo, FinancialAccount
An Invoice is a Transaction | Invoice
A Receipt is a Transaction | PaymentReceipt
A Purchase Order is a Transaction | PurchaseOrder
A Journal processes a Transaction | Journal, {Invoice, PaymentReceipt, PurchaseOrder}
A Journal debits/credits an Account | Journal, FinancialAccount
A Debtor is an Invoicee | Debtor
A Purchase Order is an Invoicee | PurchaseOrder
An Invoice invoices an Invoicee | Invoice, {Debtor, PurchaseOrder}
An Invoice is invoiced against an Account | Invoice, FinancialAccount
An Invoice is invoiced for a Purchase Order | Invoice, PurchaseOrder
A Receipt is issued for an Invoice | Invoice, PaymentReceipt
A Purchase Order is for Equipment | PurchaseOrder, EquipmentInfo

## NAPLAN

### Entities

Relations which map to SIF objects are given in lowercase and italicised

Conceptual Entity | SIF AU Object/s
School | SchoolInfo
Student | StudentPersonal
NAP Test | NAPTest
registers for | NAPEventStudentLink
NAP Testlet | NAPTestlet
NAP Item | NAPTestItem
NAP Results | NAPStudentResponseSet, reporting object: NAPTestScoreSummary
NAP Codeframe | NAPCodeFrame

### Relations

The following maps the relations captured in the conceptual model to sets of SIF AU objects.

Conceptual | SIF AU Object/s
A Student registers for a NAP Test | StudentPersonal, NAPStudentEventLink, NAPTest
A School administers a NAP Test | StudentPersonal, (SchoolInfo), NAPStudentEventLink, NAPTest
A NAP Testlet is part of a NAP Test | NAPTestlet, NAPTest
A NAP Item is part of a NAP Testlet | NAPTestItem, NAPTestlet
A NAP Codeframe releases NAP Tests | NAPCodeFrame, NAPTest
A NAP Codeframe releases NAP Testlets | NAPCodeFrame, NAPTestlet
A NAP Codeframe releases NAP Test items | NAPCodeFrame, NAPTestItem
A Student achieves a NAP Result | StudentPersonal, NAPStudentResponseSet; aggregated: NAPTestScoreSummary
NAP Results are graded against a NAP Test | NAPStudentResponseSet, NAPTest; aggregated: NAPTestScoreSummary, NAPTest

## Wellbeing

### Entities

The entities in the Wellbeing Usecase are densely interrelated; a Personalised Plan, for example, can draw on all of Behaviour Events, Alerts, and Wellbeing Characteristics. The relations indicated here are not an exhaustive list, and some relations have been left out for clarity. Relations which map to SIF objects are given in lowercase and italicised

Conceptual Entity | SIF AU Object/s
School | SchoolInfo
Student | StudentPersonal
Teacher | StaffPersonal
Parent | StudentContactPersonal
Other Person | WellbeingPersonLink
Wellbeing Event | WellbeingEvent
Wellbeing Response | WellbeingResponse
involved | WellbeingPersonLink
appeals | WellbeingAppeal
Wellbeing Alert | WellbeingAlert
Wellbeing Characteristic | WellbeingCharacteristic
Personalised Student Plan | PersonalisedPlan

### Relations

The following maps the relations captured in the conceptual model to sets of SIF AU objects.

Conceptual | SIF AU Object/s
A Student is involved in a Wellbeing Event | StudentPersonal, WellbeingEvent, group:WellbeingPersonLink
A Teacher can be involved in a Wellbeing Event | StaffPersonal, WellbeingEvent, group:WellbeingPersonLink
A Student Contact can be involved in a Wellbeing Event | StudentContactPersonal, WellbeingPersonLink
An Other Person can be involved in a Wellbeing Event | WellbeingPersonLink
A Teacher (Staff) reports a Wellbeing Event | StaffPersonal, WellbeingPersonLink
A Wellbeing Event has a Wellbeing Response | WellbeingEvent, WellbeingResponse
A Student is involved in a Wellbeing Response | StudentPersonal, WellbeingResponse
A Teacher can be involved in a Wellbeing Response | StaffPersonal, WellbeingResponse, group:WellbeingPersonLink
A Student Contact can be involved in a Wellbeing Response | StudentContactPersonal, WellbeingPersonLink
An Other Person can be involved in a Wellbeing Response | WellbeingPersonLink
A Wellbeing Response is appealed by a Student | WellbeingResponse, WellbeingAppeal, StudentPersonal
A Wellbeing Alert is raised about a Student | WellbeingAlert, StudentPersonal
A Student has a Wellbeing Characteristic | StudentPersonal, WellbeingCharacteristic
An Individualised Plan is for a Student | SPersonalisedPlan, StudentPersonal
An Individualised Plan responds to a Wellbeing Characteristic | WellbeingChracteristic, PersonalisedPlan
An Individualised Plan responds to a Behaviour Event | WellbeingEvent, PersonalisedPlan

## Classroom Assessment

### Entities

Relations which map to SIF objects are given in lowercase and italicised

Conceptual Entity | SIF AU Object/s
Student | StudentPersonal
Teacher | StaffPersonal
Class | TeachingGroup; SectionInfo
member | TeachingGroup; StudentSectionEnrollment
Term | TermInfo
LearningStandard | LearningStandardItem
Grading Assignment | GradingAssignment
Assignment Score | GradingAssignmentScore
Marking Value | MarkValueInfo
Grade | StudentGrade, reporting object: StudentScoreJudgementAgainstStandard

### Relations

The following maps the relations captured in the conceptual model to sets of SIF AU objects.

Conceptual | SIF AU Object/s
A Student is a member of a Class | StudentPersonal, TeachingGroup; StudentPersonal, StudentSectionEnrollment, SectionInfo
A Grading Assignment is assigned to a Class | GradingAssignment, TeachingGroup
A Grading Assigment is assigned to a Student | GradingAssignment, StudentPersonal
A Grading Assignment receives an Assignment Score | GradingAssignmentScore, GradingAssignment
An Assignment Score is achieved by a Student | GradingAssignmentScore, StudentPersonal
An Assignment Score is scaled to a Marking Value | GradingAssignmentScore, MarkValueInfo
A Teacher marks an Assignment Score | GradingAssignmentScore, StaffPersonal
A Grading Assignment assesses performance against a Learning Standard | GradingAssignment, LearningStandardItem
A Student receives a Grade in a Class | {StudentGrade, StudentScoreJudgementAgainstStandard}, StudentPersonal, TeachingGroup
A Teacher marks a Grade | {StudentGrade, StudentScoreJudgementAgainstStandard}, StaffPersonal
A Grade covers a Term | {StudentGrade, StudentScoreJudgementAgainstStandard}, TermInfo
An Assignment Score is scaled to a Marking Value | GradingAssignmentScore, MarkValueInfo
A Grade assesses performance against a Learning Standard | {StudentGrade, StudentScoreJudgementAgainstStandard}, LearningStandardItem
A Grade is scaled to a Marking Value | {StudentGrade, StudentScoreJudgementAgainstStandard}, MarkValueInfo
A Grade encompasses Assignment Scores | {StudentGrade, StudentScoreJudgementAgainstStandard}, GradingAssignmentScore

## Scheduling

### Entities

Conceptual Entity | SIF AU Object/s
Teacher | StaffPersonal
Period | TimeTableCell;TeachingGroup
Room | RoomInfo
Scheduled Activity | ScheduledActivity
Learning Resource | LearningResource

### Relations

The following maps the relations captured in the conceptual model to sets of SIF AU objects.

Conceptual | SIF AU Object/s
A Room is a Resource | RoomInfo
A piece of Equipment is a Resource | EquipmentInfo
A Learning Resource is a Resource | LearningResource
A Resource may be booked for a Period | {RoomInfo, EquipmentInfo, LearningResource}, ResourceBooking
A Resource may be booked for a Scheduled Activity | {RoomInfo, EquipmentInfo, LearningResource}, ResourceBooking, ScheduledActivity
A Resource is booked by a Teacher | {RoomInfo, EquipmentInfo, LearningResource}, ResourceBooking, StaffPersonal

## Statistics

### Entities

The greyed out objects are of secondary importance to the specification, and have been little used to date.

Conceptual Entity | SIF AU Object/s
Statistical Measurement | AggregateStatisticInfo
Statistical Value | AggregateStatisticFact
Statistical Characteristic | AggregateCharacteristic

### Relations

The following maps the relations captured in the conceptual model to sets of SIF AU objects.

Conceptual | SIF AU Object/s
A Room is a Resource | RoomInfo
A Statistical Measurement has a Statistical Value | AggregateStatisticalFact, AggregateStatisticalInfo
A Statistical Value has a Statistical Characteristic | AggregateStatisticalInfo, AggregateCharacteristicInfo

## Teaching and Learning

### Entities

The greyed out objects are of secondary importance to the specification, and have been little used to date.

Conceptual Entity | SIF AU Object/s
Student | StudentPersonal
Learning Activity | Activity
Learning Standard | LearningStandardItem
Curriculum | LearningStandardDocument
Learning Resource | LearningResource
Learning Resource Package | LearningResourcePackage

### Relations

The following maps the relations captured in the conceptual model to sets of SIF AU objects.

Conceptual | SIF AU Object/s
A Learning Activity is assigned to a Student | Activity, StudentPersonal
A Learning Activity is aligned to a Learning Standard | Activity, LearningStandardItem
A Learning Resource is aligned to a Learning Standard | LearningResource, LearningStandardItem
A Learning Resource is packaged in a Learning Resource Package | LearningResource, LearningResourcePackage
A Learning Standard is part of a Curriculum | LearningStandardItem, LearningStandardDocument
A Learning Resource supports a Learning Activity | Activity, LearningResource

## Australian Government Reporting Collections

### Entities

Conceptual Entity | SIF AU Object/s
School | SchoolInfo
Education Authority | LEAInfo
Financial Questionnaire | Financial Questionnaire Submission
Address Collection | AGAddressCollectionSubmission
Status Report | AGStatusReport
Collection Round | AGGetRounds

### Relations

The following maps the relations captured in the conceptual model to sets of SIF AU objects.

Conceptual | SIF AU Object/s
A Financial Questionnaire is an Australian Government Data Collection | FinancialQuestionnaireSubmission
An Address Collection is an Australian Government Data Collection | AGAddressCollectionSubmission
A Census Collection is an Australian Government Data Collection | AGCensusSubmission
An Australian Government Data Collection comes from a School | {FinancialQuestionnaireSubmission, AGAddressCollectionSubmission, AGCensusSubmission}
An Australian Government Data Collection comes from an Education Authority | {FinancialQuestionnaireSubmission, AGAddressCollectionSubmission, AGCensusSubmission}
A Status Report is about an Australian Government Data Collection | AGStatusReport
A Collection Round is of an Australian Government Data Collection | AGGetRounds, {FinancialQuestionnaireSubmission, AGAddressCollectionSubmission, AGCensusSubmission}