Manufacturing — Plant Calendar & Capacity Assumption Registry
S&OP and AI forecasts should share one approved plant calendar and capacity assumption set—including shutdowns.
Why this is needed
- Plans ignore known shutdowns stored in someone's spreadsheet.
- Capacity assumptions differ by planner.
- Fabric planning models need warehouse-native calendars.
Proposed entities in EntiHub
Governance settings
| Setting | Recommended value | Why |
|---|---|---|
approvalRequired |
true |
Calendar/capacity changes affect all plans. |
historyEnabled |
true |
History of assumption versions. |
allowSameAuthorApproval |
false |
Maker/checker separation for sensitive changes. |
deletedRetentionDays |
90 (or higher) |
Soft-delete retention for auditability. |
Entity definition (YAML sketch)
name: plant_calendar
displayName: Plant calendar
domain: Manufacturing
description: Plant calendar
version: "1.0.0"
approvalRequired: true
historyEnabled: true
deletedRetentionDays: 90
displayRefColumn: calendar_code
uniqueConstraints:
- name: uq_plant_calendar_0
columns: [calendar_code, calendar_date]
columns:
- name: calendar_code
dataType: string
nullable: false
maxLength: 64
- name: plant_code
dataType: string
nullable: false
maxLength: 32
- name: day_type
dataType: string
nullable: false
maxLength: 32
- name: calendar_date
dataType: date
nullable: false
- name: capacity_units
dataType: decimal
nullable: true
- name: status
dataType: string
nullable: false
maxLength: 16
YAML sketches
Sketches highlight the important fields and governance flags. Trim or extend columns to match your domain. See Setup Entity for the full YAML reference.
Sample data
| calendar_code | plant_code | day_type | calendar_date | capacity_units | status |
|---|---|---|---|---|---|
| CAL-SK1-2026 | SK1 | working | 2026-09-28 | 1000 | active |
| CAL-SK1-2026 | SK1 | shutdown | 2026-12-24 | 0 | active |
Benefits for the company
- Shared calendar for S&OP and AI forecast.
- Shutdowns are first-class data.
- Versionable capacity assumptions.