PNE-2189

• Update Whiteboard Line query output to accept date format and show in utc, url parameters

• Update Whiteboard view to properly show:

  • Show less hours for shift when hour is non-existent at Daylight Savings start

  • Extra Hour at Daylight Savings end

PNE-1548

Currently shift data resides in a series of monthly xml files. This information needs to be moved in to the database.

Copied from

• Create 3 database tables to migrate information from files to DB (Shift Mapping, Shift Pattern and Shift Schedule) - 1-2 days

• Write a utility to migrate existing data from files to Database, figure out how to handle missing files like ShiftPattern on some machines - 4 days

• Change the loading of shift information from database instead of files for reporting - 3 days

• Change the Shift Calendar saving to database (currently files are generated on front end and sent back via fupload) - 8 days

• Change the API for copying shift calendar from one machine to another - 3 days

• Change how schedule is autogenerated from pattern file once the existing schedule runs out (2 years apply forward) - 3-4 days

• The ability to copy shifts from machine to machine available from PEConfig’s clone machine/copy settings