Base Tables of the Plant Applications Version 7.0.5 Database

The Plant Applications version 7.0.5 database contains the following base tables, which you can copy to a text file.

__MigrationHistory
__RefactorLog
Access_Level
Active_Specs
Activities
Activity_History
Activity_Statuses
Activity_Types
Alarm_History
Alarm_Priorities
Alarm_SPC_Disabled_Products
Alarm_SPC_Rule_Properties
Alarm_SPC_Rules
Alarm_Template_SPC_Rule_Data
Alarm_Template_SPC_Rule_Property_Data
Alarm_Template_Var_Data
Alarm_Template_Variable_Rule_Data
Alarm_Templates
Alarm_Types
Alarm_Variable_Rules
AlarmAttributeValue_History
AlarmAttributeValues
Alarms
AppVersion_History
AppVersions
Array_Data
AttributeValuesHistory
Audit_Trail
Batch_Parameter_Selections
Batch_Procedure_Selections
Batch_Results_Selections
Batch_Unit_Parameter_Selections
BF_MessageQueue
BF_Service
Bill_Of_Material
Bill_Of_Material_Family
Bill_Of_Material_Formulation
Bill_Of_Material_Formulation_Item
Bill_Of_Material_Product
Bill_Of_Material_Starts
Bill_Of_Material_Substitution
Binaries
Bus_Subscriptions
CalcMgrGenealogyCache
Calculation_Dependencies
Calculation_Dependency_Data
Calculation_Dependency_Scopes
Calculation_History
Calculation_Input_Attributes
Calculation_Input_Data
Calculation_Input_Data_History
Calculation_Input_Entities
Calculation_Input_Entity_Attribute_Data
Calculation_Input_History
Calculation_Inputs
Calculation_Instance_Dependencies
Calculation_Instance_Dependencies_History
Calculation_Trigger_Types
Calculation_Types
Calculations
Characteristic_Group_Data
Characteristic_Groups
Characteristic_History
Characteristics
Client_Connection_App_Data
Client_Connection_Module_Data
Client_Connection_Statuses
Client_Connection_User_History
Client_Connections
Client_SP_CursorTypes
Client_SP_LockTypes
Client_SP_Prototypes
COA
COA_Items
Color_Scheme
Color_Scheme_Categories
Color_Scheme_Data
Color_Scheme_Fields
Colors
comment_attachments
Comment_Source
Comments
Comparison_Operators
Container_Class_Data
Container_Class_EvtSubTypeData
Container_Class_Status_Transitions
Container_Classes
Container_Location
Container_Location_History
Container_Location_Status_Transitions
Container_Statuses
Containers
Control_Type
Crew_Schedule
Crew_Schedule_History
Crew_Users_Mapping
Crews
CrewSchedule_Crew_Mapping
Customer
Customer_COA
Customer_Order_Line_Details
Customer_Order_Line_Items
Customer_Order_Line_Specs
Customer_Orders
Customer_Types
CXS_Leaf
CXS_Route
CXS_Route_Data
CXS_Route_Group
CXS_Service
CXSMarshal
Dashboard_Cache_Options
Dashboard_Calendar
Dashboard_Content_Generator_Resource_Usage
Dashboard_Content_Generator_Statistics
Dashboard_Custom_Dates
Dashboard_Dashboard_Styles
Dashboard_DataTable_Headers
Dashboard_DataTable_Presentation_Parameters
Dashboard_Day_Of_Week
Dashboard_Default_XSL
Dashboard_Dialogue_Parameters
Dashboard_Dialogues
Dashboard_Event_Scopes
Dashboard_Event_Types
Dashboard_Frequency_Types
Dashboard_Gallery_Generator_Servers
Dashboard_Icons
Dashboard_Parameter_Data_Types
Dashboard_Parameter_Default_Values
Dashboard_Parameter_Types
Dashboard_Parameter_Values
Dashboard_Report_Data
Dashboard_Report_Data_Pages
Dashboard_Report_Links
Dashboard_Reports
Dashboard_Schedule
Dashboard_Schedule_Events
Dashboard_Schedule_Frequency
Dashboard_Session
Dashboard_Statistics
Dashboard_Template_Dialogue_Parameters
Dashboard_Template_Launch_Type
Dashboard_Template_Links
Dashboard_Template_Parameters
Dashboard_Template_Size_Units
Dashboard_Templates
Dashboard_User_Security_Table
Dashboard_Users
Dashboard_Value_Types
Data_Source
Data_Source_XRef
Data_Type
DataSource
DB_Maintenance_Command_Groups
DB_Maintenance_Command_Severity
DB_Maintenance_Command_Types
DB_Maintenance_Commands
DB_Trans_Types
Defect_Details
Defect_Details_History
Defect_Types
Department_History
Departments_Base
Dependencies
Dependency_History
Dept_Parameters
Display_Option_Access
Display_Option_Categories
Display_Options
ED_Attributes
ED_Field_Properties
ED_Fields
ED_FieldType_ValidValues
ED_FieldTypes
ED_Models
Ed_Script
Email_Group_Xref
Email_Groups
Email_Groups_Data
Email_Message_Data
Email_Messages
Email_Recipients
Engineering_Unit
Engineering_Unit_Conversion
ERP_Consumption
ERP_Production
ERP_Transactions
Errors
ESignature
Event_Component_History
Event_Components
Event_Configuration
Event_Configuration_Data
Event_Configuration_Data_History
Event_Configuration_History
Event_Configuration_Properties
Event_Configuration_Value_History
Event_Configuration_Values
Event_Container_Data
Event_Container_Data_History
Event_Container_Transitions
Event_Detail_History
Event_Details
Event_Dimensions
Event_History
Event_PU_Transitions
Event_Reason_Catagories
Event_Reason_Category_Data
Event_Reason_Level_Headers
Event_Reason_Tree
Event_Reason_Tree_Data
Event_Reasons
Event_Status_Transitions
Event_Subtypes
Event_Transactions
Event_Types
Events
Events_Xref_Lot_History
Events_Xref_Lots
Extended_Test_Freqs
External_Interfaces
FTP_Actions
FTP_Config
FTP_Post_Actions
FTP_Transfer_Types
Functions
GB_DSet
GB_Dset_Data
GB_RSum
GB_RSum_Data
GroupAndPersonLegacy
GWay_Permanent_Clients
Historian_Option_Data
Historian_Options
Historian_Quality
Historian_Type_Options
Historian_Types
Historians
Icons
Import_Export_Fields
Import_Export_Types
In_Process_Bins
Language_Application_Data
Language_Data
Language_Data_Client
Language_Locale_Conversion
Language_Substitutions
Languages
License_Mgr_Info
License_Mgr_Stats
Licenses
Linkable_Remote_Servers
Mapped_xsdSchemaElements
MappedxsdSchemaElements_R_ConstantsDS
MappedxsdSchemaElements_R_PdbProcParmDS
MappedxsdSchemaElements_R_PdbProcsDS
MappedxsdSchemaElements_R_PdbTableColumnDS
Mapping_Types
Message_Category
Message_Definition
Message_Log_Detail
Message_Log_Header
Message_Properties
Message_Result_Mappings
Message_Schema
Message_Types
Modules
MSpeer_conflictdetectionconfigrequest
MSpeer_conflictdetectionconfigresponse
MSpeer_lsns
MSpeer_originatorid_history
MSpeer_request
MSpeer_response
MSpeer_topologyrequest
MSpeer_topologyresponse
MSpub_identity_range
name
NonProductive_Detail
NonProductive_Detail_History
NPT_Detail_Grouping
OEEAggregation
OEEAggregationGranularityLevel
OEEAggregationSliceTypes
OPC_Available_Properties
OPC_Class
OPC_Property
OPC_ResultSet_Map
OPC_Type
OpcUaGroup
OpcUaItem
OpcUaServer
Operating_Systems
PAEquipment_Aspect_SOAEquipment
Parameter_Categories
Parameter_Types
Parameters
PdbProcsDS_R_PdbParmXpathDS
PDF_Process_Segment_History
PDF_Process_Segments
Pending_ResultSets
Pending_SystemCompleteActivities
PendingTasks
Performance_Counters
Performance_Objects
Performance_Statistics
Performance_Statistics_Keys
PersonAndGroupLegacy
PersonLegacy
PersonnelForeignKeys
PersonnelGroupLegacy
PersonnelPrivilegesLegacy
Phrase
PlantAppsSOAPendingTasks
PrdExec_Input_Event
PrdExec_Input_Event_History
PrdExec_Input_Event_Transitions
PrdExec_Input_History
PrdExec_Input_Positions
PrdExec_Input_Source_Data
PrdExec_Input_Sources
PrdExec_Inputs
PrdExec_Output_Event
PrdExec_Output_Event_History
PrdExec_Output_Event_Transitions
PrdExec_Path_Alarm_Types
PrdExec_Path_Alarms
PrdExec_Path_History
PrdExec_Path_Input_Source_Data
PrdExec_Path_Input_Sources
PrdExec_Path_Inputs
PrdExec_Path_Products
PrdExec_Path_Status_Detail
PrdExec_Path_Unit_History
PrdExec_Path_Unit_Starts
PrdExec_Path_Unit_Starts_History
PrdExec_Path_Units
Prdexec_Paths
PrdExec_Status
PrdExec_Trans
PreEvents
PrintServer_Files
Process_Segment_Component_History
Process_Segment_Components
Process_Segment_Dependencies
Process_Segment_Dependency_History
Process_Segment_Equipment
Process_Segment_Equipment_History
Process_Segment_Families
Process_Segment_Family_History
Process_Segment_History
Process_Segment_Parameter_History
Process_Segment_Parameters
Process_Segments
Prod_Events
Prod_Line_History
Prod_Lines_Base
Prod_Unit_History
Prod_Units_Base
Prod_XRef
Product_Characteristic_Defaults
Product_Definition_History
Product_Definition_Properties
Product_Definition_Property_History
Product_Definition_Property_Value_History
Product_Definition_Property_Values
Product_Definitions
Product_Dependencies
Product_Dependency_History
Product_Dependency_Version
Product_Dependency_Version_History
Product_Family
Product_Family_History
Product_Group_Data
Product_Groups
Product_History
Product_Location_History
Product_Locations
Product_Properties
Product_Properties_History
Product_Segment_History
Product_Segment_Parameter_History
Product_Segment_Parameters
Product_Segments
Production_Event_Association
Production_Plan
Production_Plan_Alarms
Production_Plan_History
Production_Plan_Starts
Production_Plan_Starts_History
Production_Plan_Status
Production_Plan_Statuses
Production_Plan_Transitions
Production_Plan_Types
Production_Setup
Production_Setup_Detail
Production_Setup_Detail_History
Production_Setup_History
Production_Starts
Production_Starts_History
Production_Status
Production_Status_XRef
Products_Aspect_MaterialDefinition
Products_Base
Project_Group
Project_Type
Property_Types
PU_Characteristics
PU_Defects
PU_Group_History
PU_Groups
PU_Products
PurgeConfig
PurgeConfig_Detail
PurgeResult
Reason_Shortcuts
Report_ASPPrintQue
Report_Def_Webpages
Report_Definition_Data
Report_Definition_Parameters
Report_Definitions
Report_Dependency_Types
Report_Engine_Activity
Report_Engine_Errors
Report_Engine_Responses
Report_Engines
Report_Hits
Report_Parameter_Groups
Report_Parameter_Types
Report_Parameters
Report_Print_Styles
Report_Printers
Report_Que
Report_Relative_Date_Types
Report_Relative_Dates
Report_Runs
Report_Schedule
Report_Server_Link_Types
Report_Server_Links
Report_Shell_Commands
Report_Shortcuts
Report_Tree_Model
Report_Tree_Node_Types
Report_Tree_Nodes
Report_Tree_Templates
Report_Tree_Users
Report_Type_Dependencies
Report_Type_Parameters
Report_Type_WebPages
Report_Types
Report_WebPage_Dependencies
Report_WebPage_Parameters
Report_WebPages
Research_Status
ResultSetConfig
ResultSetTypes
Return_Error_Codes
Return_Error_Groups
S95_Event
S95_Event_History
Sampling_Interval
Sampling_Type
Sampling_Window_Types
Saved_Queries
SDK_Clause_Data
SDK_Clause_Types
SDK_Object_Properties
SDK_Objects
Security_Groups
Security_Items
Security_Operations
Segment_Parameter_History
Segment_Parameters
Server_Log_Records
Service_ThreadPool_Data
Service_ThreadPools
ServiceProvider_Stored_Procedure
ServiceProvider_Stored_Procedure_Field
Sheet_Column_History
Sheet_Columns
Sheet_Display_Options
Sheet_Genealogy_Data
Sheet_Group_Data
Sheet_Groups
Sheet_Paths
Sheet_Plots
Sheet_Shortcut_Data
Sheet_Shortcuts
Sheet_Type
Sheet_Type_Display_Options
Sheet_Unit
Sheet_Variables
Sheets
Shifts
Shifts_Crew_schedule_mapping
Shipment
Shipment_Line_Items
Site_Parameter_History
Site_Parameters
Source
SPC_Calculation_Types
SPC_Group_Variable_Types
SPC_Trend_Types
Spec_Activations
Specification_History
Specification_Types
Specifications
Spool_Weights
Staged_Plot_Variables
Staged_Sheet_Variables
Stored_Proc_Dependancies
Stored_Proc_Parm_Types
Stored_Proc_Parms
Stored_Proc_spCalc_Parms
Stored_Procs
Subscription
Subscription_Group
Subscription_Trigger
sysarticlecolumns
sysarticles
sysarticleupdates
syspublications
sysreplservers
sysschemaarticles
syssubscriptions
systranschemas
Table_Field_Tables
Table_Fields
Table_Fields_Values
Table_Fields_Values_History
Tag_Equivalence
Tasks
Template_Properties
Template_Property_Data
Templates
Test_History
Test_Sigma_Data
Test_Status
Tests
Timed_Event_Detail_History
Timed_Event_Details
Timed_Event_Fault
Timed_Event_Fault_History
Timed_Event_Status
TimeZoneTranslations
Topics
Trans_Char_Links
Trans_Characteristics
Trans_Metric_Properties
Trans_Products
Trans_Properties
Trans_Variables
Transaction_Filter_Values
Transaction_Groups
Transaction_Types
Transactions
Tree_Statistics
UDEAttributeValues
Unit_Locations
Unit_Types
User_Connections
User_Defined_Event_History
User_Defined_Events
User_Equipment_Assignment
User_history
User_Parameter_History
User_Parameter_XRef
User_Parameters
User_Role_Security
User_Security
User_UnitPreferences
UserAccountLegacy
Users_Aspect_Person
Users_Base
Var_Lookup
Var_Specs
Variable_Alias
Variable_History
Variable_Interface_Info
Variables_Aspect_EquipmentProperty
Variables_Aspect_MaterialDefinitionProperty
Variables_Base
VendorAttributes
View_Groups
Views
Waste_Event_Detail_History
Waste_Event_Details
Waste_Event_Fault
Waste_Event_Fault_History
Waste_Event_Meas
Waste_Event_Type
Waste_n_Timed_Comments
Web_App_Criteria
Web_App_Reject_Codes
Web_App_Status
Web_App_Types
Web_Report_Definition_Criteria
Web_Report_Definitions
Web_Report_Instance_History
Web_Report_Instances
Web_Report_Printers
Web_Report_Triggers
xsdSchemaElements