vrpt_cpWorkElementElement

Updated April 06, 2026 15:24

Field Name	Field Description	Data Type	FK Join
bi_number	Work Element Number	int
bi_title	Work Element Title	nvarchar
cpwec_adjustment	Adjustment	int
cpwec_bi_fk	Work Element Id	int	vr_CPWorkElement
cpwec_createdDate	Record Creation Date	datetime
cpwec_creator_fk	User Id (Record Creator)	int	vr_users
cpwec_elm_fk	Capital Planning Element Id	int	vr_cpElement
cpwec_endDate	End Date	datetime
cpwec_expectedLife	Expected Life	int
cpwec_installationDate	Installation Date	datetime
cpwec_modifiedDate	Last Modified Date	datetime
cpwec_modifier_fk	User Id (Record Modifier)	int	vr_users
cpwec_pk	Capital Planning Work Element Element Link Id	int
cpwec_reason	Reason	nvarchar
cpwec_worst	Indicates if this record is the worst	bit
elm_code	Capital Planning Element Code	nvarchar
elm_levelDescription	Capital Planning Element Level Description	nvarchar
elm_pk	Capital Planning Element Id	int	vr_cpElement