System Data

ØSystem TAB

ØSystem Data Tags: All the Tags used in Engineering Design System Applications used in the Project are termed as System TAGS in X4D

❖However, many of the Tags in System are also found in Classification TAGS, but most of the Tags are system generated Tags, which may not be required for reporting but important to identify elements in 3D model

❖System Tables:

Are maintained in X4D based on Source Software and Data Type

Follow a Naming Convention as [XXXX]_TYPE_[YYYY], where XXXX is Software Code and YYYY is the Type of Data

Has mandatory Columns as [COMP_ID] which monitors the unique identifier of the graphical component

ØAdministration of System TAB: Linked tables

Engineering Systems generally maintains the data various formats like SQL, Oracle, Access, CSV, Excel or XML Files. These tables are linked to X4D Database using Linked Table and column configuration in X4D for data import, just like classification tables. X4DTable shall be as per X4D naming conventions.

Table

Function

t_X4DAdmin_LinkedServerTables

Maintain the configuration of the Source Type, Connection, TableName, X4DTable, Import and PreserveStaging Flags in this table.

Import Flag can be turned off (0), in case import is no more required or broken links.

X4D imports table into Staging Area, process them to include required columns and delete columns not required. If PreserveStaging flag is on (1) system retains a copy of imported table else, it deletes the imported table after processing.

t_X4DAdmin_LinkedServerColumns

Maintain the configuration of Imported Table Columns.

After the import, Mandatory Columns are added in the table and existing Column may be renamed, removed (InX4D = 0), re-Sequenced before saving in X4D. This provides an option to cleanup imported data of tables.

System Tables Include the configuration of Document Sources also

ØSystem Table Imports when the Project Procedure p_X4DAdmin_Project_DataLoad (Explained in Data Import Section) is executed.