vrpt_CDTask

Updated February 03, 2026 16:58

associated_pts_fk	Associated Inspection Point Id	int
associated_um_fk	Associated Unit of Measure Id	int	vr_UnitMeasure
associatedBaseMinute	Associated Base Minute	decimal
associatedBaseQuantity	Associated Base Quantity	int
associatedCode	Associated Code	nvarchar
associatedDescription	Associated Description	nvarchar
associatedPoint	Associated Point	nvarchar
associatedRate	Associated Rate	decimal
associatedUnitCode	Associated Unit Code	nvarchar
associatedUnitDescription	Associated Unit Description	nvarchar
baseMinute	Base Minute	decimal
cdfj_code	Custodial Task Type Code	nvarchar
cdfj_description	Custodial Task Type Description	nvarchar
cdfj_pk	Custodial Task Type Id	int
cdfo_active	Indicates if the Record is Active or Not	bit
cdfo_associatedTask_fk	Associated Task Id	int	vrpt_task
cdfo_baseMinute	Custodial Task Base Minute	decimal
cdfo_baseQuantity	Custodial Task Base Quantity	int
cdfo_cdfj_fk	Custodial Task Type Id	int
cdfo_code	Custodial Task Code	nvarchar
cdfo_comment	Custodial Task Comment	nvarchar
cdfo_createdDate	Record Creation Date	datetime
cdfo_creator_fk	User Id (Record Creator)	int	vr_Users
cdfo_description	Custodial Task Description	nvarchar
cdfo_fo_fk	Task Id	int	vrpt_task
cdfo_frequency1	Custodial Task Frequency 1	tinyint
cdfo_frequency2	Custodial Task Frequency 2	tinyint
cdfo_frequency3	Custodial Task Frequency 3	tinyint
cdfo_frequency4	Custodial Task Frequency 4	tinyint
cdfo_frequency5	Custodial Task Frequency 5	tinyint
cdfo_frequencyUnit1	Custodial Task Frequency Unit 1	tinyint
cdfo_frequencyUnit2	Custodial Task Frequency Unit 2	tinyint
cdfo_frequencyUnit3	Custodial Task Frequency Unit 3	tinyint
cdfo_frequencyUnit4	Custodial Task Frequency Unit 4	tinyint
cdfo_frequencyUnit5	Custodial Task Frequency Unit 5	tinyint
cdfo_modifiedDate	Last Modified Date	datetime
cdfo_modifier_fk	User Id (Record Modifier)	int	vr_users
cdfo_pk	Custodial Task Id	int
cdfo_pts_fk	Inspection Point Id	int
cdfo_rate	Custodial Task Rate	decimal
fo_code	Task Code	nvarchar
fo_description	Task Description	nvarchar
FrequencyUnitName1	Frequency Unit Name 1	varchar
FrequencyUnitName2	Frequency Unit Name 2	varchar
FrequencyUnitName3	Frequency Unit Name 3	varchar
FrequencyUnitName4	Frequency Unit Name 4	varchar
FrequencyUnitName5	Frequency Unit Name 5	varchar
Id	Custodial Task Id	int
pts_description	Inspection Point Description	nvarchar
pts_um_fk	Inspection Point Unit of Measure Id	int	vr_UnitMeasure
um_code	Unit of Measure Code	nvarchar
um_description	Unit of Measure Description	nvarchar

Articles in this section