New columns (non-WV)

The AS database model, as generated by the DCK creation scripts, also contains columns that are not needed by the Web Viewer. This list shows all the columns that are added since AS 5.4 and which are not used by the Web Viewer. All numeric columns are created with a default value of 0.

New columns
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

See the interface sheet for more information on these new columns.