tables · table

oprstationmas

The oprstationmas table serves as a master registry for operational stations (physical or logical work locations) within the manufacturing environment. It categorizes stations where specific operations or machine downtimes occur. This table is primarily utilized in OEE (Overall Equipment Effectiveness) reporting and downtime analysis to group specific downtime reasons by their respective station categories (e.g., CNC, Bangalore, Weighing).

Row count

Last entry

—

Source

tables

Columns

Column	Type	Nullable	Meaning
`index`	integer	No	Primary key identifier for the record.
`compcode`	string	No	Unique identifier for the company/plant location.
`stationcode`	string	No	Unique alphanumeric code representing a specific station.
`stationname`	string	No	Descriptive name of the station used in reporting.
`username`	string	Yes	The system user who created or last modified the station record.

Full documentation

### 1) Overview
 The `oprstationmas` table serves as a master registry for operational stations (physical or logical work locations) within the manufacturing environment. It categorizes stations where specific operations or machine downtimes occur. This table is primarily utilized in OEE (Overall Equipment Effectiveness) reporting and downtime analysis to group specific downtime reasons by their respective station categories (e.g., CNC, Bangalore, Weighing).
 
 ### 2) Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | No | Primary key identifier for the record. | | Internal Row ID |
 | **compcode** | string | No | Unique identifier for the company/plant location. | "DAS", "RFL" | `JOIN`, `WHERE` |
 | **stationcode** | string | No | Unique alphanumeric code representing a specific station. | "29", "CNC", "FPROD" | `JOIN` |
 | **stationname** | string | No | Descriptive name of the station used in reporting. | "BANGALORE", "CNC" | `SELECT` |
 | **username** | string | Yes | The system user who created or last modified the station record. | "khannaji", "system" | Audit |
 
 ### 3) Relationships & Join Map
 
 The `oprstationmas` table is a foundational master table referenced by downtime and operation definitions to provide human-readable location names for technical codes.
 
 #### Primary Joins (SCHEMA_MAP confirmed)
 * **dbo.downtimemas**: Joins on `stationcode` and `compcode`. This relationship allows downtime reasons to be aggregated by station (e.g., categorizing a specific tool break under the "CNC" station).
 * **dbo.oprmas**: Joins on `stationcode` and `compcode`. Links operations to their designated physical stations.
 * **dbo.itemopr / dbo.itemoprprod**: Joins on `stationcode`. Used to define which station is responsible for a specific item's operation sequence.
 
 #### Likely Joins (Inferred from Usage)
 * **dbo.machine**: While not directly linked in the map via a station column, machines belong to locations, and stations typically represent the logical grouping of these machines.
 
 ---