vr_DeviceType

Updated November 21, 2025 16:59

Field Name	Field Description	Data Type	FK Join
Active	Indicates if the Record is Active or Not	bit
ApplicationDescription	Invoice Description	nvarchar
ApplicationId	Application Id	int
Code	Device 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
DeApplicationValue	Application Value	int
DeFailureValue	Failure Value	int
DeFunctionValue	Function Value	int
DeRequirementValue	Requirement Value	int
Description	Device Type Description	nvarchar
DeUsageValue	Usage Value	int
EcriCode	ECRI Code	int
EnvironmentDescription	Environment Description	nvarchar
EvalScore	Eval Score	int
FailureId	Failure Id	int
FunctionDescription	Function Description	nvarchar
FunctionId	Function Id	int
Id	Device Type Id	int
InventoryClass	Inventory Class	nvarchar
LikelihoodFailureDescription	Likelihood Failure Description	nvarchar
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
ParentId	Device Type Parent Id	int	vr_DeviceType
PerData	Per Data	smallint
PmFrDesciption	Obsolete	nvarchar
PmReferenceDate	PM Reference Date	datetime
PmRequired	PM Required	smallint
PmUnits	PM Units	nvarchar
RequirementId	Requirement Id	int
RiskFactor	Risk Factor	nvarchar
RiskFormulaCode	Risk Formula Code	nvarchar
RiskFormulaDefinition	Risk Formula Definition	nvarchar
RiskFormulaDescription	Risk Formula Description	nvarchar
RiskFormulaId	Risk Formula Id	int	vrpt_riskFactor
RiskLevel	Risk Level	int
SuggestedMinFrequency	Suggested Min. Frequency	nvarchar
UsageFlatRate	Usage Flate Rate	decimal
UsageId	Usage Id	int
UsageUnit	Usage Unit	nvarchar
UsageUnitCost	Usage Unit Cost	decimal

Articles in this section