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 FMLIBTotal

  • Last UpdatedJan 29, 2024
  • 2 minute read

TableName

FieldName

Alias

Description

TBL_LIBPART

prt_ID

prt_ID

Primary key/Foreign key

TBL_LIBPART

prt_Name

prt_Name

Part Name

TBL_LIBPART

prt_Function

prt_Function

Part Function

TBL_LIBCOMPONENT

cmp_ID

cmp_ID

Primary key/Foreign key

TBL_LIBCOMPONENT

cmp_Name

cmp_Name

Component Name

TBL_LIBFAILMODE

fmo_ID

fmo_ID

Primary key/Foreign key

TBL_LIBFAILMODE

fmo_Desc

fmo_Desc

Failure Mode

TBL_LIBFAILCAUSE

fca_ID

fca_ID

Primary key/Foreign key

TBL_LIBFAILCAUSE

fca_dis_ID

fca_dis_ID

Primary key/Foreign key

TBL_LIBFAILCAUSE

fca_Condition

fca_Condition

Failure Condition

TBL_LIBFAILCAUSE

fca_Description

fca_Description

Failure Cause

TBL_LIBFAILCAUSE

fca_mttf

fca_mttf

MTTF

TBL_LIBFAILCAUSE

fca_Failvar

fca_Failvar

Deviation

TBL_LIBFAILCAUSE

fca_failshape

fca_failshape

Form Factor

TBL_LIBFAILCAUSE

fca_FLPart

fca_FLPart

Function Loss

LKU_DISTRIBUTION

dis_ID

MAINFOLLOWMTTCCDIS__dis_ID

Primary key/Foreign key

LKU_DISTRIBUTION

dis_ID

FCDIS__dis_ID

Primary key/Foreign key

LKU_DISTRIBUTION

dis_Desc

FCDIS__dis_Desc

Distribution MTTCC

TBL_LIBMAINTENANCE

man_ID

MAINTFOLLOW__man_ID

Primary key/Foreign key

TBL_LIBMAINTENANCE

man_ID

MAINMAINT__man_ID

Primary key/Foreign key

TBL_LIBMAINTENANCE

man_mty_ID

MAINTFOLLOW__man_mty_ID

Primary key/Foreign key

TBL_LIBMAINTENANCE

man_mty_ID

MAINMAINT__man_mty_ID

Primary key/Foreign key

TBL_LIBMAINTENANCE

man_mac_ID

MAINTFOLLOW__man_mac_ID

Primary key/Foreign key

TBL_LIBMAINTENANCE

man_mac_ID

MAINMAINT__man_mac_ID

Primary key/Foreign key

TBL_LIBMAINTENANCE

man_mef_ID

MAINTFOLLOW__man_mef_ID

Primary key/Foreign key

TBL_LIBMAINTENANCE

man_mef_ID

MAINMAINT__man_mef_ID

Primary key/Foreign key

TBL_LIBMAINTENANCE

man_description

MAINTFOLLOW__man_description

Maintenance Action

TBL_LIBMAINTENANCE

man_description

MAINMAINT__man_description

Maintenance Action

TBL_LIBMAINTENANCE

man_Maintime

MAINTFOLLOW__man_Maintime

Maintenance Duration

TBL_LIBMAINTENANCE

man_Maintime

MAINMAINT__man_Maintime

Maintenance Duration

TBL_LIBMAINTENANCE

man_pmInterval

MAINTFOLLOW__man_pmInterval

Maintenance Frequency

TBL_LIBMAINTENANCE

man_pmInterval

MAINMAINT__man_pmInterval

Maintenance Frequency

TBL_LIBMAINTENANCE

man_ReactionTime

MAINTFOLLOW__man_ReactionTime

Maintenance Response Time

TBL_LIBMAINTENANCE

man_ReactionTime

MAINMAINT__man_ReactionTime

Maintenance Response Time

TBL_LIBMAINTENANCE

man_TotalCost

MAINTFOLLOW__man_TotalCost

Total Costs

TBL_LIBMAINTENANCE

man_TotalCost

MAINMAINT__man_TotalCost

Total Costs

LKU_MAINTTYPE

mty_ID

MAINFOLLOWTYPE__mty_ID

Primary key/Foreign key

LKU_MAINTTYPE

mty_ID

MAINMAINTTYPE__mty_ID

Primary key/Foreign key

LKU_MAINTTYPE

mty_Desc

MAINFOLLOWTYPE__mty_Desc

Maintenance Strategy

LKU_MAINTTYPE

mty_Desc

MAINMAINTTYPE__mty_Desc

Maintenance Strategy

LKU_MAINTACTION

mac_ID

MAINFOLLOWACTION__mac_ID

Primary key/Foreign key

LKU_MAINTACTION

mac_ID

MAINMAINTACTION__mac_ID

Primary key/Foreign key

LKU_MAINTACTION

mac_Desc

MAINFOLLOWACTION__mac_Desc

Maintenance Action

LKU_MAINTACTION

mac_Desc

MAINMAINTACTION__mac_Desc

Maintenance Action

LKU_MAINTEFFECT

mef_ID

MAINFOLLOWEFFECT__mef_ID

Primary key/Foreign key

LKU_MAINTEFFECT

mef_ID

MAINMAINTEFFECT__mef_ID

Primary key/Foreign key

LKU_MAINTEFFECT

mef_desc

MAINFOLLOWEFFECT__mef_desc

Maintenance Effect

LKU_MAINTEFFECT

mef_desc

MAINMAINTEFFECT__mef_desc

Maintenance Effect

TBL_LIBFAILCAUSE

fca_mttf_stt_ID

fca_mttf_stt_ID

Primary key/Foreign key

TBL_LIBFAILCAUSE

fca_FailVar_stt_ID

fca_FailVar_stt_ID

Primary key/Foreign key

TBL_LIBFAILCAUSE

fca_failshape_stt_ID

fca_failshape_stt_ID

Primary key/Foreign key

TBL_LIBMAINTENANCE

man_MainTime_stt_ID

MAINTFOLLOW__man_MainTime_stt_ID

Primary key/Foreign key

TBL_LIBMAINTENANCE

man_PMInterval_stt_ID

MAINTFOLLOW__man_PMInterval_stt_ID

Primary key/Foreign key

TBL_LIBMAINTENANCE

man_PMInterval_stt_ID

MAINMAINT__man_PMInterval_stt_ID

Primary key/Foreign key

TBL_LIBMAINTENANCE

man_ReactionTime_stt_ID

MAINTFOLLOW__man_ReactionTime_stt_ID

Primary key/Foreign key

TBL_LIBMAINTENANCE

man_MaintNumber

MAINTFOLLOW__man_MaintNumber

Maintenance Number

TBL_LIBMAINTENANCE

man_MaintNumber

MAINMAINT__man_MaintNumber

Maintenance Number

TBL_LIBMAINTENANCE

man_MainTime_stt_ID

MAINMAINT__man_MainTime_stt_ID

Primary key/Foreign key

TBL_LIBMAINTENANCE

man_ReactionTime_stt_ID

MAINMAINT__man_ReactionTime_stt_ID

Primary key/Foreign key

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