Page Comparison

...

NOTE: The primary, secondary, Fall, and Spring days will still need to be verified. The EIS Academic Calendar can assist.

Update/Insert Calendar Dates

Use the following excel sheet to fill in dates.

Look below for more specifics on the dates.

Once the dates have been added run the following:

1. Run the UPDATE SQL scripts and COMMIT;

2. Verify Dates: Final Check

3. Once dates have been verified, SOACALD is finished.

4. Next, from the excel sheet, run the insert statements for SSAEXCL

5. Verify that the correct data in in SSAEXCL for the year

6. Open toad and run the following scripts:

BEGIN
    cos_copy_excl_dates (:year);
    COMMIT;
END;

DELETE FROM
    ssrexcl
      WHERE     SSREXCL_PTRM_CODE = 'E'
            AND SSREXCL_YEAR = :year
            AND SSREXCL_DESC IN
                    ('Local Holiday', 'Flex Day', 'Non-Instructional Day');

Primary Instructional Day

...