DecisioWorksStandardized Data Interface
Learning the Standardized Data Interface
Download the complete exercise pack (SQL, field list, Python scripts, database and CSV files)
A production model needs to know what to make, how it can be made, which resources it uses, when materials become available, and how much work each period permits. The DecisioWorks standardized data interface organizes these facts as connected business objects.
This course provides a complete semantic guide, nine task-based lessons, and field, relationship, template, and code references. Begin with the system map; use the lessons to build a configuration; consult the field reference for exact storage requirements.
The Semantic Guide
DecisioWorks Standardized Data Interface: A Detailed Semantic Guide covers objects, field meanings, time and quantity rules, relationships, and result updates.
Learn Through Tasks
| Lesson | What you will produce |
|---|---|
| 01 Configure time, shifts, and maintenance | Time records, resource occupancy, and an available-time calculation |
| 02 Express orders, products, and attributes | Staged order deliveries and a product-attribute mapping |
| 03 Configure work centers and shared resources | Resource hierarchy, sharing relationships, and availability records |
| 04 Configure routes and alternative resources | Operation precedence, route options, and resource mappings |
| 05 Calculate cycle output, batches, and processing time | Quantity conversions, batch checks, and joint-output calculations |
| 06 Configure operation-level materials and availability | Material requirements, time-phased supply, and a manual feasibility check |
| 07 Translate inventory requirements into cumulative bounds | Bounds derived from an inventory balance |
| 08 Import, validate, and load business data | A mapping sheet, a separate teaching database, and validation results |
| 09 Interpret results and prepare the next planning cycle | Output, time, material checks, and an update checklist |
References and Practice
- Complete field reference: 18 tables and 105 fields in the current standard template, separating business meaning from storage requirements.
- Relationship and rule reference: foreign keys, cardinalities, calculations, and distinctions between similarly named fields.
- Configuration patterns: shifts, continuous production, maintenance, sharing, inventory, and quantity conventions.
- End-to-end exercise and commands: a 120-unit requirement, configuration checks, a manually constructed candidate plan, and a maintenance change.
The quantities, resources, and periods in the exercises are teaching data. The supplied program builds a separate database and runs structural checks and manual calculations. Candidate rows are explicitly labeled as manually constructed; solver results must come from an actual run. This separates learning how data is expressed from testing how a model uses it.
For production configuration, use the field definitions and capability documentation that accompany your installed version. The extensible attribute mechanism is not limited to three dimensions; this SQLite template implements three attribute tables.