Footprints Data Model

Table
Table Name Schedule
Table Definition A personal or workspace calendar in Footprints. It is used to provide easy access to work hours and settings for appointment scheduling and metric reporting. The Calendar Service maintains the system of record tables for the schedule, but those tables are too difficult and time consuming to query for trend reporting.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Schedule Id The automatically generated primary key of the schd table. LONG Yes
Schedule Name The name of the Schedule. VARCHAR(255) No
Use Local Time Indicates that the workschedule is base on local time for the time zone region. If you want UTC time, use that as the region. BOOLEAN Yes
Time Zone Region Name The name of the Time Zone Region for the calendar, which derives from or overrides the value used for the system or workspace. VARCHAR(255) No
Maximum Date Value The time spans are forecast out into the future as CalendarActualPeriod. This is the maximum date for which those periods are generated. DATE No
Calendar Type Id A Foreign Key to the Calendar Type table. INTEGER Yes
Application User Id A Foreign Key to the Application User table. LONG No