Allow import into the Calendar Overrides list and a way to recalculate TS_CALENDARDENORM Hot
The Calendar Overrides list contains the list of holidays that needs to be updated at least once a year. While the Calendars and Calenday weekdays lists once defined, are more-or-less static, the Overrides list and the Calendar De-Norm table derived from these 3 lists are relatively dynamic.
Through App Admin, allow importing into the Calendar Over-rides list (TS_CALENDAROVERRIDES) and have it re-calculate the "TS_CALENDARTIMERANGES" and "TS_CALENDARDENORM" table.
One option might be to allow import into the Calendar Overrides list using App Admin. When complete, SBM would recalculate the TS_CALENDARTIMERANGES and TS_CALENDARDENORM tables from the Calendars, Weekdays and Overrides.
Another option would be to have a method where SBM could be "triggered" to update the TS_CALENDARTIMERANGES and TS_CALENDARDENORM tables. We would import the Overrides data using AppScript, orchestrations or SQL but then we need to have SBM recalculate the contents of those 2 tables.
Please login to view any attachments.
There are no user comments for this idea.