Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
CREATE PROCEDURE "pears"."TempCustomShiftFetcher"( IN "YearNo" INTEGER,IN "PeriodNo" INTEGER,IN "PeriodLength" CHAR(20),IN "PeriodStartDate" DATE,IN "PeriodEndDate" DATE,IN "PersID" CHAR(20),IN "DeskID" CHAR(20) ) BEGIN -- Called before generation of e-timesheets on a shift desk (DeskID will have a non null value) -- And before fetching shifts for an individual timesheet (PersID will have a non null value) -- May insert tempshift and tempshiftplan rows END