vr_EquipmentType

Updated November 24, 2025 15:32

Field Name	Field Description	Data Type	FK Join
Active	Indicates if the Record is Active or Not	bit
ApplicationValue	Application Value	int
Code	Equipment Type Code	nvarchar
CPElementCode1	UniFormat Level 1 Code	nvarchar
CPElementCode2	UniFormat Level 2 Code	nvarchar
CPElementCode3	UniFormat Level 3 Code	nvarchar
CPElementCode4	UniFormat Level 4 Code	nvarchar
CPElementDescription1	UniFormat Level 1 Description	nvarchar
CPElementDescription2	UniFormat Level 2 Description	nvarchar
CPElementDescription3	UniFormat Level 3 Description	nvarchar
CPElementDescription4	UniFormat Level 4 Description	nvarchar
CPElementId1	UniFormat Level 1 Id	int	vr_cpElement
CPElementId2	UniFormat Level 2 Id	int	vr_cpElement
CPElementId3	UniFormat Level 3 Id	int	vr_cpElement
CPElementId4	UniFormat Level 4 Id	int	vr_cpElement
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
Description	Equipment Type Description	nvarchar
EvalScore	Eval Score	int
FailureValue	Failure Value	int
FunctionValue	Function Value	int
Id	Equipment Type Id	int
InventoryClass	Inventory Class	nvarchar
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
ParentId	Equipment Type Parent Id	int	vr_equipmentType
PMRequired	Indicates if the PM Required Checkbox is Checked or Not	bit
RequirementValue	Requirement Value	int
RiskFormulaCode	Risk Formula Code	nvarchar
RiskFormulaDefinition	Risk Formula Defintion	nvarchar
RiskFormulaDescription	Risk Formula Description	nvarchar
RiskFormulaId	Risk Formula Id	int	vrpt_riskFactor
RiskLevel	Risk Level	int
SuggestedMinFrequency	Suggested Min Frequency	nvarchar
UsageFlatRate	Usage Flat Rate	decimal
UsageUnit	Usage Unit	nvarchar
UsageUnitCost	Usage Unit Cost	decimal
UsageValue	Usage Value	int

Articles in this section