AVEVA ™ Asset Strategy Optimization

Appendix C : Field names FMECAFailEffects

Save PDF

Appendix C : Field names FMECAFailEffects

Save PDF

Last UpdatedJan 29, 2024
2 minute read

TableName	FieldName	Alias	Description
tbl_sysPart	spt_ID	spt_ID	Primary key/Foreign key
tbl_sysPart	spt_Tag	spt_Tag	Part tag
tbl_sysPart	spt_pty_ID	spt_pty_ID	Primary key/Foreign key
tbl_sysPart	spt_Name	spt_Name	Part Name
tbl_sysPart	spt_Function	spt_Function	Part Function
tbl_sysFailMode	sfm_Desc	sfm_Desc	Failure mode
tbl_sysFailMode	sfm_effect1	sfm_effect1	Failure Cause Effect 1
tbl_sysFailMode	sfm_effect2	sfm_effect2	Failure Cause Effect 2
tbl_sysFailMode	sfm_effect4	sfm_effect4	Failure Cause Effect 4
tbl_sysFailMode	sfm_effect5	sfm_effect5	Failure Cause Effect 5
tbl_busGoal	bgl_ID	BG3__bgl_ID	Primary key/Foreign key
tbl_busGoal	bgl_ID	BG1__bgl_ID	Primary key/Foreign key
tbl_busGoal	bgl_ID	BG6__bgl_ID	Primary key/Foreign key
tbl_busGoal	bgl_ID	BG5__bgl_ID	Primary key/Foreign key
tbl_busGoal	bgl_name	BG3__bgl_name	Business Objective
tbl_busGoal	bgl_name	BG2__bgl_name	Business Objective
tbl_busGoal	bgl_name	BG1__bgl_name	Business Objective
tbl_busGoal	bgl_name	BG5__bgl_name	Business Objective
tbl_busGoal	bgl_name	BG4__bgl_name	Business Objective
tbl_BusValue	bvl_ID	BV3__bvl_ID	Primary key/Foreign key
tbl_BusValue	bvl_ID	BV1__bvl_ID	Primary key/Foreign key
tbl_BusValue	bvl_ID	BV6__bvl_ID	Primary key/Foreign key
tbl_BusValue	bvl_ID	BV5__bvl_ID	Primary key/Foreign key
tbl_BusValue	bvl_name	BV3__bvl_name	Classification Description
tbl_BusValue	bvl_name	BV2__bvl_name	Classification Description
tbl_BusValue	bvl_name	BV1__bvl_name	Classification Description
tbl_BusValue	bvl_name	BV5__bvl_name	Classification Description
tbl_BusValue	bvl_name	BV4__bvl_name	Classification Description
tbl_BusValue	bvl_Value	BV3__bvl_Value	Classification Value
tbl_BusValue	bvl_Value	BV1__bvl_Value	Classification Value
tbl_BusValue	bvl_Value	BV6__bvl_Value	Calcification Value
tbl_BusValue	bvl_Value	BV5__bvl_Value	Classification Value
tbl_BusValue	bvl_Class	BV3__bvl_Class	Class
tbl_BusValue	bvl_Class	BV2__bvl_Class	Class
tbl_BusValue	bvl_Class	BV1__bvl_Class	Class
tbl_BusValue	bvl_Class	BV5__bvl_Class	Class
tbl_BusValue	bvl_Class	BV4__bvl_Class	Class
tbl_sysFailMode	sfm_unit	sfm_unit	Unit
tbl_sysFailMode	sfm_ID	sfm_ID	Primary key/Foreign key
tbl_sysFailMode	sfm_effect3	sfm_effect3	Failure Cause Effect 3
tbl_busGoal	bgl_ID	BG2__bgl_ID	Primary key/Foreign key
tbl_busGoal	bgl_ID	BG4__bgl_ID	Primary key/Foreign key
tbl_busGoal	bgl_name	BG6__bgl_name	Business Objective
tbl_BusValue	bvl_ID	BV2__bvl_ID	Primary key/Foreign key
tbl_BusValue	bvl_ID	BV4__bvl_ID	Primary key/Foreign key
tbl_BusValue	bvl_name	BV6__bvl_name	Classification Description
tbl_BusValue	bvl_Value	BV2__bvl_Value	Classification Value
tbl_BusValue	bvl_Value	BV4__bvl_Value	Classification Value
tbl_BusValue	bvl_Class	BV6__bvl_Class	Class
tbl_sysFailMode	sfm_effect6	sfm_effect6	Failure Mode

AVEVA ™ Asset Strategy Optimization

Appendix C : Field names FMECAFailEffects

Table of Contents

Appendix C : Field names FMECAFailEffects

Related Links