New columns

The AS database model, as generated by the DCK creation scripts, contains columns that are not required by the Web Viewer. All numeric columns are created with a default value of 0. See the interface sheet for more information on new columns.

This table shows all of the columns that are added since AS 5.4 and which are not used by the Web Viewer:

Table name Column name Type Length
AS_ProcessBatch as_changeover_cost INT  
as_setup_cost INT  
as_split_link TEXT 80
AS_ProcessStep as_release_duration INT  
AS_ResourceCIPRule as_changeover_limit INT  
as_cip_type INT  
as_gauge_cost INT  
as_gauge_count INT  
as_gauge_duration INT  
as_gauge_quantity FLOAT  
as_gauge_time DATETIME  
as_matrix_code TEXT 80
as_max_cost INT  
as_max_count INT  
as_max_duration INT  
as_max_quantity FLOAT  
as_min_count INT  
as_min_duration INT  
as_min_quantity FLOAT  
as_model_name TEXT 80
as_resource_code TEXT 80
as_step_code TEXT 80
as_step_version TEXT 80
as_unique_key TEXT 80
AS_ResourceClaim as_flow_inflow INT  
as_flow_outflow INT  
as_keep_batch_claim INT  
as_process INT  
AS_ResourceTable as_changeover_after_idle_time INT  
as_changeover_cost_formula INT  
as_changeover_idle_time INT  
as_non_std_changeover_after_id INT  
as_setup_cost_formula INT  
as_setup_duration_formula INT  
AS_TankBatch as_changeover_cost INT  
as_order_code TEXT 80
as_setup_cost INT  
as_split_link TEXT 80
AS_UtilityClaim as_flow_inflow FLOAT  
as_flow_outflow FLOAT  
as_keep_batch_claim INT  
as_process FLOAT