vrpt_CDRouteAreaTaskLinkForReport

Updated February 03, 2026 16:56

Field Name	Field Description	Data Type	FK Join
cdfo_code	Custodail Task Code	nvarchar
cdfo_description	Custodail Task Description	nvarchar
cdmx_frequency	Custodial Template Task Link Frequency	int
cdra_cdrs_fk	Custodial Route Id	int	vrpt_cdRoute
cdracfo_cdmx_fk	Custodial Template Task Link Id	int
cdracfo_cdra_fk	Custodial Route Area Link Id	int	vrpt_cdRouteAreaLink
cdracfo_fridayMinutes	Friday Minutes	decimal
cdracfo_fridayQuantity	Friday Quantity	int
cdracfo_minutes	Minutes	decimal
cdracfo_mondayMinutes	Monday Minutes	decimal
cdracfo_mondayQuantity	Monday Quantity	int
cdracfo_pk	Custodial Route Area Task Link Id	int
cdracfo_saturdayMinutes	Saturday Minutes	decimal
cdracfo_saturdayQuantity	Saturday Quantity	int
cdracfo_sundayMinutes	Sunday Minutes	decimal
cdracfo_sundayQuantity	Sunday Quantity	int
cdracfo_thursdayMinutes	Thursday Minutes	decimal
cdracfo_thursdayQuantity	Thursday Quantity	int
cdracfo_tuesdayMinutes	Tuesday Minutes	decimal
cdracfo_tuesdayQuantity	Tuesday Quantity	int
cdracfo_wednesdayMinutes	Wednesday Minutes	decimal
cdracfo_wednesdayQuantity	Wednesday Quantity	int
cdracfo_weeklyMinutes	Weekly Minutes	decimal
cdrs_code	Custodial Route Code	nvarchar
fu_unitID	Area Location Id	nvarchar
Id	Custodial Route Area Task Link Id	int