vrpt_CDTemplateTaskLink

Updated February 03, 2026 17:00

Field Name	Field Description	Data Type	FK Join
associatedTask_cdItem_fk	Custodial Item Id	int
associatedTaskBaseMinute	Associated Task Base Minute	decimal
associatedTaskBaseQuantity	Associated Task Base Quantity	int
associatedTaskPoint	Associated Task Point	nvarchar
associatedTaskPoint_um_fk	Unit of Measure Id	int	vr_UnitMeasure
associatedTaskUnitCode	Associated Task Unit Code	nvarchar
associatedTaskUnitDescription	Associated Task Unit Description	nvarchar
cdfj_code	Custodial Task Type Code	nvarchar
cdfj_description	Custodial Task Type Description	nvarchar
cdfj_pk	Custodial Task Type Id	int
cdfjs_code	Custodial Task Sub Type Code	nvarchar
cdfjs_description	Custodial Task Sub Type Description	nvarchar
cdfjs_pk	Custodial Task Sub Type Id	int
cdfo_code	Custodial Task Code	nvarchar
cdfo_comment	Custodial Task Comment	nvarchar
cdfo_description	Custodial Task Description	nvarchar
cdmx_baseMinute	Custodial Template Task Link Base Minutes	decimal
cdmx_baseQuantity	Custodial Template Task Link Base Quantity	int
cdmx_cdfo_fk	Custodial Task Id	int	vrpt_cdTask
cdmx_cdItem_fk	Custodial Item Id	int
cdmx_cdtp_fk	Custodail Template Id	int
cdmx_comments	Custodial Template Task Link Commnets	nvarchar
cdmx_createdDate	Record Creation Date	datetime
cdmx_creator_fk	User Id (Record Creator)	int	vr_users
cdmx_estimatedMinutes	Custodial Template Task Link Estimated Minutes	decimal
cdmx_frequency	Custodial Template Task Link Frequency	int
cdmx_frequencyL1	Custodial Template Task Link Frequency Level 1	int
cdmx_frequencyL2	Custodial Template Task Link Frequency Level 2	int
cdmx_frequencyL3	Custodial Template Task Link Frequency Level 3	int
cdmx_frequencyL4	Custodial Template Task Link Frequency Level 4	int
cdmx_frequencyL5	Custodial Template Task Link Frequency Level 5	int
cdmx_fridayQuantity	Custodial Template Task Link Friday Quantity	int
cdmx_isProject	Indicates if the custodial template task link record is part of a project	bit
cdmx_minutes	Custodial Template Task Link Minutes	decimal
cdmx_minutesL1	Custodial Template Task Link Minutes Level 1	decimal
cdmx_minutesL2	Custodial Template Task Link Minutes Level 2	decimal
cdmx_minutesL3	Custodial Template Task Link Minutes Level 3	decimal
cdmx_minutesL4	Custodial Template Task Link Minutes Level 4	decimal
cdmx_minutesL5	Custodial Template Task Link Minutes Level 5	decimal
cdmx_modifiedDate	Last Modified Date	datetime
cdmx_modifier_fk	User Id (Record Modifier)	int	vr_users
cdmx_mondayQuantity	Custodial Template Task Link Monday Quantity	int
cdmx_pk	Custodial Template Task Link Id	int
cdmx_quantityPercentage	Custodial Template Task Link Quantity Percentage	decimal
cdmx_saturdayQuantity	Custodial Template Task Link Saturday Quantity	int
cdmx_sundayQuantity	Custodial Template Task Link Sunday Quantity	int
cdmx_thursdayQuantity	Custodial Template Task Link Thursday Quantity	int
cdmx_tuesdayQuantity	Custodial Template Task Link Tuesday Quantity	int
cdmx_wednesdayQuantity	Custodial Template Task Link Wednesday Quantity	int
cdtai_quantity	Custodial Template Task Link Quantity	int
Description	Custodial Template Item Description	nvarchar
Id	Custodial Template Task Link Id	int
task_cdItem_fk	Custodial Item Id	int
taskBaseMinute	Task Base Minute	decimal
taskBaseQuantity	Task Base Quantity	int
taskPoint	Task Point	nvarchar
taskPoint_um_fk	Unit of Measure Id	int	vr_UnitMeasure
taskUnitCode	Task Unit Code	nvarchar
taskUnitDescription	Task Unit Description	nvarchar
um_code	Unit of Measure Code	nvarchar
um_description	Unit of Measure Description	nvarchar
UnitOfMeasureId	Unit of Measure Id	int	vr_UnitMeasure

Articles in this section