Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA ™ Asset Strategy Optimization

Appendix C : Field names FMECAFailEffects

  • 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

TitleResults for “How to create a CRG?”Also Available in