This rule is used to validate:

• Evaluated Mark Course Code

To perform this validation, the following information is used:

• organization code
• Evaluated Mark School Year
• First School Year
• Last School Year
• Credit Version
• Credits Attempted
• UseEffectiveDates?
• Evaluation Date
• Effective Start Date
• Effective End Date

A course code may be used on an evaluated mark record where the organization on the record has permission to offer that course for the credits specified on that evaluated mark school year. If they don’t have permission on that timeframe, this rule fails.

This rule does not apply for evaluated mark records with an Organization Code of O.1.

This rule is effective as of the 2012/2013 school year.

Where no Course Permission exists for the course, credit version and organization, this rule should fail. “No permission” means:

• No A.* permission exists with a null credit version OR
• No permission record exists for the organization on the evaluated mark or its authority OR
• A permission record exists for the organization on the section or its authority, but not for the timeframe and/or credit level.
• No permission record exists at all.

Where null Credit Version exists on the Course Permissions record:

• If the following is true, this rule passes. Otherwise, this rule fails:
  • Permission organization code = A.* AND
  • the Evaluated Mark School Year is equal to or within a valid permission for the organization AND
    • This is determined as follows:
      • where the Use Course Effective Dates = 'No', compare the evaluated mark school year against the course permission First School Year and Last School Year values
      • where the Use Course Effective Dates = 'Yes', compare the evaluated mark school year against the course permission Effective Start Date (Credit Version) and Effective End Date (Credit Version) values
  • an authorization that is effective as of the Evaluated Mark School Year exists matching the Credits Attempted on the Evaluated Mark record.
• If the following is true, this rule passes. Otherwise, this rule fails:
  • Permission organization code <> A.* AND
    • If the organization code is an authority, all schools within that authority inherit the permission.
    • If the organization code is a school, that school has permission
  • the Evaluated Mark School Year is equal to or within a valid permission for the organization AND
    • This is determined as follows:
      • where the Use Course Effective Dates = 'No', compare the evaluated mark school year against the course permission First School Year and Last School Year values
      • where the Use Course Effective Dates = 'Yes', compare the evaluated mark school year against the course permission Effective Start Date (Credit Version) and Effective End Date (Credit Version) values
  • an authorization that is effective as of the Evaluated Mark School Year exists matching the Credits Attempted on the Evaluated Mark record.

Where Credit Version information is included on the Course Permission record, one of the following must be true for the rule to pass:

• Option A
  • organization code = A.* AND
  • Permission was granted to the organization for the credit level and timeframe:
    • If UseEffectiveDates? = Yes on the permission, the Evaluation Date on the evaluated mark must be equal to or fall within the permission credit version Effective Start Date and Effective End Dates.
    • If UseEffectiveDates? = No on the permission, the Evaluated Mark School Year must be equal to or within the course permission credit version First School Year and Last School Year values.
• Option B
  • organization code <> A.*:
    • If the organization code is an authority, all schools within that authority inherit the permission.
    • If the organization code is a school, that school has permission
  • Permission was granted to the organization for the credit level and timeframe:
    • If UseEffectiveDates? = Yes on the permission, the Evaluation Date on the evaluated mark must be equal to or fall within the permission credit version Effective Start Date and Effective End Dates with the credit value matching between the Credit Version value and the evaluated mark Credits Attempted value.
    • If UseEffectiveDates? = No on the permission, the Evaluated Mark School Year must be equal to or within the course permission credit version First School Year and Last School Year values with the credit value matching between the Credit Version value and the evaluated mark Credits Attempted value.

Include any additional information regarding the rule.

When this validation rule is triggered, the following message is returned:

Where:

• {OrganizationName} is the name of organization on the section.
• {OrganizationCode} is the code of the organization on the section.
• {CourseCode} is the course code of the course that the rule failed for on the section.
• {EvaluatedMarkSchoolYear} is the School Year on the evaluated mark.

This rule applies to:

• Release 7.12 - Created

The following changes are expected to be implemented in an upcoming release (or include the release # if known).

• N/A