vrpt_CDRouteAreaLink

Updated February 03, 2026 16:48

Field Name	Field Description	Data Type	FK Join
cdra_cdrs_fk	Custodial Route Id	int	vrpt_cdRoute
cdra_createdDate	Record Creation Date	datetime
cdra_creator_fk	User Id (Record Creator)	int	vr_users
cdra_fridayMinutes	Friday Minutes	decimal
cdra_fu_fk	Area Record Id	int	vr_area
cdra_isProject	Indicates if the record is part of a project	bit
cdra_modifiedDate	Last Modified Date	datetime
cdra_modifier_fk	User Id (Record Modifier)	int	vr_users
cdra_mondayMinutes	Monday Minutes	decimal
cdra_pk	Custodial Route Area Link Id	int
cdra_saturdayMinutes	Saturday Minutes	decimal
cdra_sequence	Sequence	int
cdra_sundayMinutes	Sunday Minutes	decimal
cdra_thursdayMinutes	Thursday Minutes	decimal
cdra_tuesdayMinutes	Tuesday Minutes	decimal
cdra_wednesdayMinutes	Wednesday Minutes	decimal
cdra_weeklyMinutes	Weekly Minutes	decimal
cdra_weeklyProjectMinutes	Weekly Project Minutes	numeric
cdtp_code	Custodial Template Code	nvarchar
cdtp_description	Custodial Template Description	nvarchar
fb_name	Building Name	nvarchar
ff_code	Floor Code	nvarchar
ff_description	Floor Description	nvarchar
fu_cdtp_fk	Custodial Template Id	int
fu_description	Area Description	nvarchar
fu_squareFootage	Area Square Footage	decimal
fu_unitID	Area Location Id	nvarchar
Id	Custodial Route Area Link Id	int