AVEVA ™ Asset Strategy Optimization

Appendix C : Field names FMECACLM

Save PDF

Appendix C : Field names FMECACLM

Save PDF

Last UpdatedJan 29, 2024
1 minute read

TableName	FieldName	Alias	Description
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_SYSPART	spt_ID	MAINTPARENTPART__spt_ID	Primary key/Foreign key
TBL_SYSPART	spt_Tag	MAINTPARENTPART__spt_Tag	Tag Part
TBL_SYSPART	spt_Name	MAINTPARENTPART__spt_Name	Part name
TBL_SYSCOMPONENT	scm_ID	scm_ID	Primary key/Foreign key
TBL_SYSCOMPONENT	scm_Name	scm_Name	Component name
TBL_SYSFAILCAUSE	sfc_ID	sfc_ID	Primary key/Foreign key
TBL_SYSFAILCAUSE	sfc_Condition	sfc_Condition	Failure mode
TBL_SYSFAILCAUSE	sfc_Description	sfc_Description	Failure Cause
TBL_SYSMAINTENANCE	smn_ID	MAINTFOLLOW__smn_ID	Primary key/Foreign key
TBL_SYSMAINTENANCE	smn_ID	MAINMAINT__smn_ID	Primary key/Foreign key
TBL_SYSMAINTENANCE	smn_mty_ID	MAINTFOLLOW__smn_mty_ID	Primary key/Foreign key
TBL_SYSMAINTENANCE	smn_mty_ID	MAINMAINT__smn_mty_ID	Primary key/Foreign key
TBL_SYSMAINTENANCE	smn_mac_ID	MAINTFOLLOW__smn_mac_ID	Primary key/Foreign key
TBL_SYSMAINTENANCE	smn_mac_ID	MAINMAINT__smn_mac_ID	Primary key/Foreign key
TBL_SYSMAINTENANCE	smn_mef_ID	MAINTFOLLOW__smn_mef_ID	Primary key/Foreign key
TBL_SYSMAINTENANCE	smn_mef_ID	MAINMAINT__smn_mef_ID	Primary key/Foreign key
TBL_SYSMAINTENANCE	smn_description	MAINMAINT__smn_description	Description Maintenance
TBL_SYSMAINTENANCE	smn_description	MAINTFOLLOW__smn_description	Description maintenance
TBL_SYSMAINTENANCE	smn_Maintime	MAINTFOLLOW__smn_Maintime	Maintenance Time
TBL_SYSMAINTENANCE	smn_Maintime	MAINMAINT__smn_Maintime	Maintenance Time
TBL_SYSMAINTENANCE	smn_pmInterval	MAINTFOLLOW__smn_pmInterval	Maintenance Frequency
TBL_SYSMAINTENANCE	smn_pmInterval	MAINMAINT__smn_pmInterval	Maintenance Frequency
TBL_SYSMAINTENANCE	smn_TotalCost	MAINTFOLLOW__smn_TotalCost	Total Costs
TBL_SYSMAINTENANCE	smn_TotalCost	MAINMAINT__smn_TotalCost	Total Costs
TBL_SYSMAINTENANCE	smn_MainTime_stt_ID	MAINMAINT__smn_MainTime_stt_ID	Primary key/Foreign key
TBL_SYSMAINTENANCE	smn_MainTime_stt_ID	MAINTFOLLOW__smn_MainTime_stt_ID	Primary key/Foreign key
TBL_SYSMAINTENANCE	smn_pmInterval_stt_ID	MAINTFOLLOW__smn_pmInterval_stt_ID	Primary key/Foreign key
TBL_SYSMAINTENANCE	smn_pmInterval_stt_ID	MAINMAINT__smn_pmInterval_stt_ID	Primary key/Foreign key
TBL_SYSMAINTENANCE	smn_MaintNumber	MAINTFOLLOW__smn_MaintNumber	Maintenance Number
TBL_SYSMAINTENANCE	smn_MaintNumber	MAINMAINT__smn_MaintNumber	Maintenance Number

AVEVA ™ Asset Strategy Optimization

Appendix C : Field names FMECACLM

Table of Contents

Appendix C : Field names FMECACLM

Related Links