Page Comparison

...

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

...