AVEVA ™ Asset Strategy Optimization

Appendix C : Field names FMLIBTotal

Save PDF

Appendix C : Field names FMLIBTotal

Save PDF

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

AVEVA ™ Asset Strategy Optimization

Appendix C : Field names FMLIBTotal

Table of Contents

Appendix C : Field names FMLIBTotal

Related Links