Skip to main content

1. Calendar Functions

Calendar Functions Not started

1.1 Automatically Create Academic Years Past and Future

Purpose
Automate creating new academic future academic records when the user-defined promotion date has been reached.  This reduces the need for users to add a year every time they complete one.
Trigger
Promotion Date (school configuration)   =  actual date
Conditions
Initial configuration was completed.
Sequence
This function must run before more school terms can be created.
    Find the  academic year record the farthest in the future, the "last record"

Step 2 Create one more academic year record,  auto-calculate start year, end year, start date, end date, status = future, sequence => add one, concatenate year name to start year - end year.

Step 3

Set field values:

Sequence = last record sequence + 1

Start year = last record start year + 1

End year = last record end year + 1

Academic year name - concatenate start year - end year

start date = last record start date + 1 year

end date = last record end date + 1 year.

    END


Calculate School and Calendar Days

Term School Days  = calendar days - vacation days - excluded week days

Term Calendar Days = actual days - do not subtract weekends

Academic Year School Days = sum of required terms school days

Academic Years Calendar Days = sum of required terms calendar days