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:
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.
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.
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).
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 |
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 |
Relations whose logical representation will be deprecated in SIF-AU 3.5 are marked in red.
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 |
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 |
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 |
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) |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
Conceptual Entity | SIF AU Object/s |
Teacher | StaffPersonal |
Period | TimeTableCell;TeachingGroup |
Room | RoomInfo |
Scheduled Activity | ScheduledActivity |
Learning Resource | LearningResource |
Library Item | LibraryPatronStatus |
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 Library Item is a Resource | Library |
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 |
A Library Item is checked out by a Party | {StaffPersonal, StudentPersonal, StudentContactPersonal}, LibraryPatronStatus |
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 |
The following maps the relations captured in the conceptual model to sets of SIF AU objects.
Conceptual | SIF AU Object/s |
A Statistical Measurement has a Statistical Value | AggregateStatisticalFact, AggregateStatisticalInfo |
A Statistical Value has a Statistical Characteristic | AggregateStatisticalInfo, AggregateCharacteristicInfo |
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 |
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 |
Conceptual Entity | SIF AU Object/s |
School | SchoolInfo |
Education Authority | LEAInfo |
Financial Questionnaire | FinancialQuestionnaireCollection |
Address Collection | AddressCollection |
Student Attendance (STATS) | StudentAttendanceCollection |
(Non-gov) Census Collection | CensusCollection |
Status Report | CollectionStatus |
Collection Round | CollectionRound |
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 | FinancialQuestionnaireCollection |
An Address Collection is an Australian Government Data Collection | AddressCollection |
A Census Collection (Non-gov) is an Australian Government Data Collection | CensusCollection |
A Student Attendance (STATS) Collection is an Australian Government Data Collection | StudentAttendanceCollection |
An Australian Government Data Collection comes from a School | {FinancialQuestionnaireCollection, AddressCollection, CensusCollection, StudentAttendance} |
An Australian Government Data Collection comes from an Education Authority | {FinancialQuestionnaireCollection, AddressCollection, CensusCollection, StudentAttendance} |
A Status Report is about an Australian Government Data Collection | CollectionStatus |
A Collection Round is of an Australian Government Data Collection | CollectionRound, {FinancialQuestionnaireCollection, AddressCollection, CensusCollection, StudentAttendance} |