focus2000 Data Dictionary

Panorama stores everything it tracks — machines, jobs, materials, labor, SPC statistics, schedules — in a relational database that SYSCON refers to internally as focus2000. This section is the field-by-field and table-by-table reference for that database, converted from the original Data Dictionary help file.

Where to start

• Introduction — what changed in the current database version
• Overview — how the tables relate to each other
• Table Types — the categories of tables in the system
• Table List — every table in the database, alphabetically
• Keys and Indices — how records are looked up
• Major Table Relationships — how the most important tables connect
• Field Types — the data types used across all tables
• Field List — every field in the database, alphabetically

Every table page lists its fields, and every field page lists the tables it appears in — follow the links to cross-reference, or use search above to jump straight to a table or field by name.