Show pageOld revisionsBacklinksExport to PDFFold/unfold allBack to top This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong. ====== pears.TempCustomShiftFetcher ====== <WRAP center round info> Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. </WRAP> ===== Original SQL ===== <code sql> 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 </code> database/procedures/pears_tempcustomshiftfetcher.txt Last modified: 2026/08/07 19:24by 127.0.0.1