Module work schedules (working hours, country, and time zone) used by resources and capacity calculation
Data model
Fields
| Field | Type | Description |
|---|---|---|
| calendar_id* | UNIQUEIDENTIFIER | Unique identifier of the work calendar |
| calendar_name* | VARCHAR (150) | Calendar Name |
| country_code* | VARCHAR (10) | Calendar country code |
| end_hour* | TIME | End of working day time |
| is_active* | BIT | Logical Deletion: 1 = Active Record, 0 = Retired |
| start_hour* | TIME | Workday start time |
| timezone_name* | VARCHAR (100) | Calendar time zone |
| work_hours_day* | DECIMAL | Working hours per day |
| work_hours_week* | DECIMAL | Working hours per week |
Primary Key
| PK_APMO_CALENDAR |
|---|
| calendar_id |