Lookup Tables#
Lookup Tables provide a system-wide mechanism to store hierarchical sets of (value, description) pairs, used primarily to feed selection lists.
All Lookup Table values are stored in the same table, in the database.
System Lookup Tables#
The system comes with a set of Lookup Tables which are necessary for the normal functioning of the system. You can see the list of tables below:
| Name | Description |
|---|---|
| AQLAcceptanceLimit | Possible values for AQL Acceptance Limit |
| AQLInspectionLevel | Possible levels for AQL Inspection |
| AQLSeverity | Possible values for AQL Severity |
| AreaType | Possible types for Area |
| AssetClass | Assets may have distinct classes, e.g. following ISA-95: Enterprise, Site, Facility, Area, Resource, Container, Device |
| AssetDataType | Asset Properties can have distinct datatypes, either simple or complex (e.g. geopoint). If complex, additional properties can be defined at the AssetDataType Generic Table |
| AttachmentType | Possible attachment types |
| AutomationControllerType | Possible types for an automation controller. |
| AutomationDriverDefinitionType | Possible types for an automation driver definition. |
| AutomationJobType | Automation Jobs may be executed under a broad-spectrum of third parties and external systems and this type serves to categorize the Automation Job |
| AutomationManagerType | Possible types for an automation manager. |
| AutomationProtocolType | Possible types for an automation protocol. |
| BatchType | Possible types for Batch |
| BOMType | Possible types for BOM |
| CalendarDayType | Possible CalendarNonWorkingDayType values for EmployeeCalendarDay |
| CapacityClass | The capacity class of the product, for scheduling reasons |
| CertificationType | Possible types for certification |
| ChangeCategory | A change category for the Change Set. |
| ChangeSetType | ChangeSetType |
| ChangeSetUrgency | The urgency of the Change Set. |
| ChartType | Possible types for Chart |
| ChecklistItemType | Possible types for ChecklistItem |
| ChecklistScope | ChecklistScope |
| ChecklistType | ChecklistType |
| ConsumableFeedType | Possible Consumable Feed Types |
| ContainerLocation | Possible location values for Container |
| ContainerType | Possible types for Container |
| ContainerVendor | Possible vendor values for Container |
| ContentType | Possible ContentType values for Document |
| CostCenter | Possible cost centers |
| Country | Possible values for Country |
| DataCollectionLimitSetType | Possible type values for DataCollectionLimitSet |
| DataCollectionType | Possible types for DataCollection |
| DataSiloType | Data silo type |
| DocumentGroup | Possible group values for Document |
| DocumentType | Possible types for Document |
| E58Engineering | E58Engineering |
| E58Nonscheduled | E58Nonscheduled |
| E58Productive | E58Productive |
| E58ScheduledDown | E58ScheduledDown |
| E58Standby | E58Standby |
| E58UnscheduledDown | E58UnscheduledDown |
| EmployeeCalendarNonWorkingTimeType | Possible types of employee non-working times (e.g.: meeting, training) |
| EmployeeType | Possible types of employees |
| EquipmentAlarmUserSideType | EquipmentAlarm User Side Type |
| EquipmentDataCollectionsMemberDataConsumerService | Equipment DataCollectionsMember DataConsumerService |
| EquipmentVariableEquipmentDataType | Equipment Variable Equipment Data Type |
| EquipmentVariableType | Equipment Variable Type |
| ExperimentDefinitionObjective | Possible types for experiment objectives |
| ExperimentDefinitionType | Possible types for experiment definitions |
| FacilityType | Possible types for Facility |
| FlowType | Possible types for Flow |
| InspectionOrderMaterialLinkType | Material link types for Inspection Order |
| InspectionPlanConfiguration | Inspection Plan Configuration |
| InspectionPlanType | Inspection Plan Type |
| InspectionSeverity | Possible values for Inspection Severity |
| InstrumentType | Possible types for Instrument |
| IntegrationSystem | Possible types of systems that are available for integration |
| IoTEventDefinitionType | Briefly identifies the context of the Event Definition, e.g. MES, Equipment, ERP, Any,... |
| KPIType | Used for KPI grouping |
| LabelMaterialProperty | Defines the Material Properties that can be referenced as a Label Specification Field |
| LabelSpecification | Defines the possible Label Specifications that can be specified for a Business Partner |
| MaintenanceActivityType | Possible types for Maintenance Activity |
| MaintenanceManagementEvent | Possible event values for Maintenance Management |
| MaintenancePlanType | Possible types for Maintenance Plan |
| MapDefinitionType | Possible form values for MapDefinition |
| MasterDataPackageType | Possible types for MasterDataPackage |
| MaterialChartOperations | Possible operations for Material Chart |
| MaterialChecklistOperations | Possible operations for Material Checklist |
| MaterialDataCollectionOperations | Possible operations for Material Data Collection |
| MaterialDataCollectionType | Possible types for Material Data Collection |
| MaterialDocumentOperations | Possible operations for Material Document |
| MaterialForm | Possible form values for Material |
| MaterialLocation | Material possible Locations |
| MaterialSystemStates | Possible states for Material System |
| MaterialTimeConstraintFromOperations | From operations supported for TimeConstraints definition |
| MaterialTimeConstraintToOperations | To operations supported for TimeConstraints definition |
| MaterialTransferRefuseReason | In case that the MaterialTransfer is refused, what is the refuse reason |
| MaterialTransferReturnReason | In case that the MaterialTransfer is returned, what is the return reason |
| MaterialTransferType | Material Transfer Types |
| MaterialTransferUrgency | Possible MaterialTransferUrgency values for MaterialTransfer |
| MaterialType | Possible types for Material |
| MessageType | Possible types of messages that are available for integration |
| MoistureSensitivityLevel | Standard Moisture Sensitivity Levels |
| MultimediaScope | MultimediaScope |
| NotificationSeverity | Possible severity values for Notification |
| NotificationType | Possible types for Notification |
| PackageType | Possible types for Package |
| PackingOperations | Possible operations for Package |
| ParameterType | Possible types for Parameter |
| PlanGroup | Possible groups for Plan |
| PrintableDocumentType | Possible types for Printable Document |
| PrinterType | Possible types for Printer |
| PrintingSystem | Possible Printing Systems |
| Priority | Possible values for Priority |
| ProductGroupMaturity | Product Group Maturity |
| ProductGroupType | Possible types for ProductGroup |
| ProductionOrderType | Possible types for Production Order |
| ProductMaturity | Product Maturity |
| ProductParameterReportingType | Possible types for Product Parameter Reporting |
| ProductType | Possible types for Product |
| ProtocolRootCauseSource | The list of values to be used as the root cause source |
| ProtocolSeverity | Possible severity values for Protocol |
| ProtocolType | Possible types for Protocol |
| QualificationProficiency | Possible QualificationProficiency values for EmployeeQualification |
| QualificationReason | Possible reasons for Qualification |
| QualificationType | Possible types for Qualification |
| ReasonCategory | Possible categories for Reason |
| RecipeType | Possible types for Recipe |
| RemoteExportType | RemoteExportType |
| ResourceChartStateTransitions | Possible transitions for Resource Chart State |
| ResourceChecklistStateTransitions | Possible transitions for CheckList State |
| ResourceDataCollectionStateTransitions | Possible transitions for Resource DataCollection State Transitions |
| ResourceDisplayPath | Possible path values for Resource Display |
| ResourceDocumentStateTransitions | Possible transitions for Resource Document State |
| ResourceIdealCycleTimeScale | Possible time scales for Resource Ideal Cycle |
| ResourceJobSubType | Possible sub-types for Resource Job |
| ResourceJobType | Possible types for Resource Job |
| ResourceLocationType | Possibles Location Types for Resource |
| ResourceModel | Possible model values for Resource |
| ResourcePreferenceStepGroup | Aggregators for Steps where the Scheduler will attempt to keep the Material at the same Resource, without interruptions |
| ResourceResourceType | Possible types for Resource Resource |
| ResourceType | Possible types for Resource |
| ResourceVendor | Possible vendors for Resource |
| RuleScope | RuleScope |
| SamplingPatternType | Sampling Pattern Type |
| SamplingPlanType | Sampling Plan Type |
| SchedulingAreaGroup | Scheduling Area Groups |
| ServiceType | Possible type for Service |
| ShiftLogbookEntryCategory | The category of an entry in the Shift Logbook |
| ShiftLogbookEntrySeverity | Possible ShiftLogbookEntrySeverity values for ShiftLogbookEntry |
| ShiftPlanType | Shift Plan Type |
| SortRuleSetType | Possible types for Sort Rule Set |
| StepMaturity | Step Maturity |
| StepType | Possible types for Step |
| SubProductType | Possible types for Sub Product |
| SubstrateMapBinQuality | Possible values for Bin Quality |
| TransferOrderPriority | Transfer order priority names supported |
| TransferRequirementPriority | Transfer requirement priority names supported |
| TransferRequirementType | Transfer requirement types supported by Areas |
| Units | Possible values for Units |
| UnterminateJustification | Possible values for Unterminate Justification |
Table: System Lookup Tables
Lookup Table Page Views#
Data View#
Lists all the data rows that are included in the Lookup Table. You can edit existing rows or add new ones.
Definition View#
Displays information on the actual table definition.
History View#
Combines information concerning other objects that have references to the current Lookup Table object:
- History - displays operations, associated information, user(s) performing the changes and date and time of the changes.
Creating a Lookup Table#
LookupTable.Create
Step 1: General Data#
- Enter a name for the Lookup Table.
- Optionally, enter the description.
- Specify whether the table should only show values that are enabled in the table when performing a selection.
- Select Create to finish the process.
Editing a Lookup Table Definition#
LookupTable.Edit
To edit the definition of the Lookup Table, open the Definition View and select . A wizard will be displayed to allow editing the basic details as well as adding or removing properties. Select Create to save the new settings.
Warning
It is only possible to edit the definition of a table you created.
Terminating a Lookup Table#
LookupTable.Delete
To terminate a Lookup Table, it is necessary to open the Lookup Table details and select Terminate.
Warning
A Lookup Table cannot be terminated if referenced by an active object.
Unterminating a Lookup Table#
LookupTable.Unterminate
To unterminate a Lookup Table, it is necessary to open the Lookup Table details and select Unterminate.
Editing Lookup Tables Data#
LookupTable.EditData
- Open the Data View.
- Select on the top ribbon.
- Add new entries by selecting and adding the values on the right side panel.
- Disable existing records by selecting the values and activating the Enable switch accordingly.
- If desired, sub-level entries can be added by selecting Options on the top right and checking Allow Sub-levels. This will create a vertical division in the left side panel, allowing the user to add child values and add them to existing parent values.
- Select Save to commit the changes.
