These cookies are required for the website to function properly. They ensure security, enable basic features like page navigation, and store user session data. You cannot disable these cookies.
- OEE Tracking Dashboard
- Data model
The tables behind OEE Tracking Dashboard
OEE Tracking Dashboard ships with 19 tables, grouped here by the feature that uses them. Every record your team works with lives in one of them, and you can add fields and tables in Proto.
- Tables
- 19
- Features
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Production windows
Planned production windows links to Resources and carries starts at, ends at, planned minutes and ideal cycle seconds.
OEE observations
OEE observations links to planned production windows through Window and records run minutes, total units, good units and observed at.
Downtime evidence
Downtime intervals links to the same window and stores started at, ended at, reason code and planned stop.
Coverage review
OEE review snapshots references Window, Observation and reviewed by; the reviewer resolves to People.
Production execution
Orders and order lines reference Parties and Items. Work orders references Product, Order and Resource. Production logs references work order and Operator, while Batches references work order.
Material and output control
Material issues references work order and Item; inventory balances references Item. Purchase orders references Supplier and purchase lines references purchase order and Item. Exchange rates supplies effective currency rates.
Every table, by feature
- Production windows2
- OEE observations3
- Downtime evidence3
- Coverage review4
- Production execution8
- Material and output control9
- Shared and settings2
- Planned production windows
Planned production windows per resource with planned minutes and ideal cycle.
Linked to Resources - Resources
Production resources and machines with daily capacity.
- OEE observations
Run minutes and unit counts observed for a planned production window.
Linked to Planned production windows - Planned production windows
Planned production windows per resource with planned minutes and ideal cycle.
Linked to Resources - OEE review snapshots
Reviewer coverage snapshots linking a window to its observation.
Linked to Planned production windows, People, OEE observations
- Downtime intervals
Downtime intervals recorded against a planned production window.
Linked to Planned production windows - Planned production windows
Planned production windows per resource with planned minutes and ideal cycle.
Linked to Resources - Resources
Production resources and machines with daily capacity.
- OEE review snapshots
Reviewer coverage snapshots linking a window to its observation.
Linked to Planned production windows, People, OEE observations - OEE observations
Run minutes and unit counts observed for a planned production window.
Linked to Planned production windows - Planned production windows
Planned production windows per resource with planned minutes and ideal cycle.
Linked to Resources - People
App users with their production role titles.
Linked to Users
- Work orders
Released production work for a product, order and resource.
Linked to Items, Orders, Resources - Orders
Customer orders that drive work orders and production demand.
Linked to Parties - Order lines
Item-level lines belonging to a customer order.
Linked to Orders, Items - Items
Materials, components and finished goods produced or purchased.
- Resources
Production resources and machines with daily capacity.
- Production logs
Operator-captured production intervals with good and scrap units.
Linked to Work orders, People - People
App users with their production role titles.
Linked to Users - Batches
Produced lot identities and their quality disposition.
Linked to Work orders
- Material issues
Material postings that decrement inventory for a work order.
Linked to Work orders, Items - Inventory balances
On-hand and reserved quantities by item, location and lot.
Linked to Items - Items
Materials, components and finished goods produced or purchased.
- Work orders
Released production work for a product, order and resource.
Linked to Items, Orders, Resources - Batches
Produced lot identities and their quality disposition.
Linked to Work orders - Production logs
Operator-captured production intervals with good and scrap units.
Linked to Work orders, People - Purchase orders
Supplier purchase orders for materials and components.
Linked to Parties - Purchase lines
Item-level lines belonging to a purchase order.
Linked to Purchase orders, Items - Parties
Customers and suppliers referenced by orders and purchase orders.
Keys and references
People links to Users through User. Preserve that mapping when attributing production commands and reviewer identities. Keep each observation and its selected review window consistent. Work orders and planned production windows each reference Resources; use their resource and time context during review rather than assuming a direct work-order reference on a window.
Inventory balances include Item, Location and lot number. Resolve the exact balance used by a material issue before posting. Retain existing Id values, and preserve the uppercase ID used by exchange rates when moving source records.
Migration order
- Establish Users and People, then Items, Parties and Resources.
- Load Orders with order lines, purchase orders with purchase lines, and opening inventory balances under agreed units and lots.
- Load work orders and planned production windows with their valid references and time boundaries.
- Bring in production logs, material issues and Batches using controlled posting and migration rules that avoid replaying stock effects.
- Load OEE observations and downtime intervals, then OEE review snapshots after reviewer and observation references are resolved. Retain effective exchange rates as read-only context.
Set up OEE Tracking Dashboard your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.