Subject and Subject Requirements Tables

Relevant Definitions

Data Relationships

Note that subjects are not associated directly with plans. The subject requirement is the table that links the subject to the plan and also specifies the number of units in that subject the plan requires.

Subjects Table

The subjects table has only the name field. The administrator can enter unlimited subjects. However, a class record may only be linked to one subject record. Curriculum records are not linked to subject records. A curriculum may be used to fulfill different subject depending on the plan. For example, Environmental Science may be frequently used to meet Biological Science or Physical Science but not both. There would be two class records. One called Environmental Science that is linked to the subject of biology and another that is linked to the subject of physical science. However there is just one Moodle course, so there is just one curriculum record. The curriculum therefore does not specify a subject, and is not related to subject records.

Subject Requirements Table

Units required - the number of units required for the associated subject under the associated plan.

Name - concatenation of subject, plan, and unit information.

Units planned - the number of units in the plan that meet this subject requirement.

Transcript name - the subject requirements are listed in the transcript to create the block of information discussed in the Programs of Study Function. The transcript name is how the subject requirement should appear on the document, as the concatenation name is not convenient for printing.

Action Items JAN 2023

Enter data for transcript names - this is blank in most records, should be very similar to subject names if not exactly the same. Consider adding automation to default to subject name.

No automation has been enabled for Units planned, the sum of the units in the template records also associated to this subject requirement.