AVEVA ™ Asset Strategy Optimization

Appendix C : Field names FMSYSTotal

Save PDF

Appendix C : Field names FMSYSTotal

Save PDF

Last UpdatedFeb 02, 2024
2 minute read

TableName	FieldName	Alias	Description
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	MAINFOLLOWMTTCCDIS__dis_Desc	Distribution MTTCC
LKU_DISTRIBUTION	dis_Desc	FCDIS__dis_Desc	Distribution MTTCC
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_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_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
TBL_SYSPART	spt_ID	spt_ID	Primary key/Foreign key
TBL_SYSPART	spt_Tag	spt_Tag	Part Tag
TBL_SYSPART	spt_Name	spt_Name	Part Name
TBL_SYSFAILMODE	sfm_ID	sfm_ID	Primary key/Foreign key
TBL_SYSFAILMODE	sfm_Desc	sfm_Desc	Failure Mode
TBL_SYSCOMPONENT	scm_ID	scm_ID	Primary key/Foreign key
TBL_SYSFAILCAUSE	sfc_ID	sfc_ID	Primary key/Foreign key
TBL_SYSFAILCAUSE	sfc_dis_ID	sfc_dis_ID	Primary key/Foreign key
TBL_SYSFAILCAUSE	sfc_Condition	sfc_Condition	Failure Condition
TBL_SYSFAILCAUSE	sfc_mttf	sfc_mttf	MTTF
TBL_SYSFAILCAUSE	sfc_Failvar	sfc_Failvar	Deviation
TBL_SYSFAILCAUSE	sfc_failshape	sfc_failshape	Form Factor
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_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_description	MAINMAINT__smn_description	Maintenance Description
TBL_SYSMAINTENANCE	smn_description	MAINTFOLLOW__smn_description	Maintenance Description
TBL_SYSMAINTENANCE	smn_Maintime	MAINTFOLLOW__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_ReactionTime	MAINTFOLLOW__smn_ReactionTime	Maintenance Response Time
TBL_SYSMAINTENANCE	smn_TotalCost	MAINTFOLLOW__smn_TotalCost	Total Costs
TBL_SYSMAINTENANCE	smn_TotalCost	MAINMAINT__smn_TotalCost	Total Costs
TBL_SYSFAILCAUSE	sfc_MTTF_stt_ID	sfc_MTTF_stt_ID	Primary key/Foreign key
TBL_SYSFAILCAUSE	sfc_FailShape_stt_ID	sfc_FailShape_stt_ID	Primary key/Foreign key
TBL_SYSMAINTENANCE	smn_ReactionTime_stt_ID	MAINTFOLLOW__smn_ReactionTime_stt_ID	Primary key/Foreign key
TBL_SYSMAINTENANCE	smn_ReactionTime_stt_ID	MAINMAINT__smn_ReactionTime_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	MAINMAINT__smn_MaintNumber	Maintenance Number
LKU_MAINTTYPE	mty_Desc	MAINMAINTTYPE__mty_Desc	Maintenance Strategy
LKU_MAINTACTION	mac_Desc	MAINMAINTACTION__mac_Desc	Maintenance Action
LKU_MAINTEFFECT	mef_desc	MAINMAINTEFFECT__mef_desc	Maintenance Effect
TBL_SYSPART	spt_Function	spt_Function	Part Function
TBL_SYSCOMPONENT	scm_Name	scm_Name	Component Name
TBL_SYSFAILCAUSE	sfc_Description	sfc_Description	Failure Cause
TBL_SYSFAILCAUSE	sfc_FLPart	sfc_FLPart	Function Loss
TBL_SYSMAINTENANCE	smn_mty_ID	MAINMAINT__smn_mty_ID	Primary key/Foreign key
TBL_SYSMAINTENANCE	smn_mef_ID	MAINMAINT__smn_mef_ID	Primary key/Foreign key
TBL_SYSMAINTENANCE	smn_Maintime	MAINMAINT__smn_Maintime	Maintenance Time
TBL_SYSMAINTENANCE	smn_ReactionTime	MAINMAINT__smn_ReactionTime	Maintenance Response Time
TBL_SYSFAILCAUSE	sfc_FailVar_stt_ID	sfc_FailVar_stt_ID	Primary key/Foreign key
TBL_SYSMAINTENANCE	smn_MainTime_stt_ID	MAINMAINT__smn_MainTime_stt_ID	Primary key/Foreign key
TBL_SYSMAINTENANCE	smn_MaintNumber	MAINTFOLLOW__smn_MaintNumber	Maintenance Number

AVEVA ™ Asset Strategy Optimization

Appendix C : Field names FMSYSTotal

Table of Contents

Appendix C : Field names FMSYSTotal

Related Links