Site

oee ops glossary

A Site is the top-level organizational container representing a physical manufacturing location (e.g., a factory, plant, or facility). Sites are the root of the OEE/OPS hierarchy.

Database Table: oee_sites

Column	Type	Description
id	UUID (PK)	Auto-generated
organization_id	VARCHAR(50)	Org ownership
code	VARCHAR(50)	Short identifier (e.g., “DEN-01”), unique per org
name	VARCHAR(255)	Display name (e.g., “Denver Sterilization Facility”)
description	TEXT	Optional
address_line1/2, city, state_province, postal_code, country	VARCHAR	Physical address
default_oee_target	DECIMAL(5,2)	Site-wide OEE target (default 85.00%)
default_availability_target	DECIMAL(5,2)	Default 90.00%
default_performance_target	DECIMAL(5,2)	Default 95.00%
default_quality_target	DECIMAL(5,2)	Default 99.50%
availability_mode	VARCHAR(20)	'standard', 'teep', or 'strict'
is_active	BOOLEAN	Whether site is operational

Availability Modes

Mode	Formula
standard	Run / (Run + Unplanned)
teep	Run / Total Calendar Time
strict	Run / (Run + Unplanned + Planned)

Hierarchy

graph TD
    Site --> System["Systems (oee_systems)"]
    Site --> Station["Stations (ops_stations)"]
    Site --> Machine["Machines (oee_machines)"]
    Site --> ProductFamily["Product Families (ops_product_families)"]
    System --> Machine
    System --> Station
    ProductFamily --> Product["Products (ops_products)"]

Relationships

• Has many Systems (oee_systems)
• Has many Machines (oee_machines)
• Has many Stations (ops_stations)
• Has many Product Families (ops_product_families)
• Has many jobs (ops_jobs)
• Has many Events (oee_machine_events)
• Has reason taxonomies: Downtime Reason, Incident Reason, Scrap Reason

Codebase Paths

• Table: database/sql_scripts/tables/oee_sites.sql

See Also

• Machine
• Station
• Product Family
• OEE Tables