vrpt_CDRoute

Updated February 03, 2026 16:46

Field Name	Field Description	Data Type	FK Join
cdra_totalMinutes	Total Minutes	decimal
cdra_totalWeeklyMinutes	Total Weekly Minutes	decimal
cdra_WeeklyMinutes	Weekly Minutes	decimal
cdrs_active	Indicates if the Record is Active or Not	bit
cdrs_areaCount	Area Count	int
cdrs_code	Custodial Route Code	nvarchar
cdrs_createdDate	Record Creation Date	datetime
cdrs_creator_fk	User Id (Record Creator)	int	vr_users
cdrs_description	Custodial Route Description	nvarchar
cdrs_fb_fk	Building Id	int	vr_building
cdrs_fd_fk	Facility Id	int	vr_Facility
cdrs_ff_fk	Floor Record Id	int	vr_floor
cdrs_indirectMinutes	Indirect Minutes	decimal
cdrs_inspectionCount	Inspection Count	int
cdrs_levelRating	Level Rating	decimal
cdrs_modifiedDate	Last Modified Date	datetime
cdrs_modifier_fk	User Id (Record Modifier)	int	vr_users
cdrs_pk	Custodial Route Id	int
cdrs_shft_fk	Shift Id	int	vr_Shift
cdrs_supervisor_fk	Supervisor Id	int	vrpt_Technician
cdrs_uiExport	Indicates if the custodial route record is available for universal integration export	bit
cdrs_wk_fk	Technician Id	int	vrpt_Technician
fb_code	Building Code	nvarchar
fb_name	Building Name	nvarchar
fd_code	Facility Code	nvarchar
fd_name	Facility Name	nvarchar
ff_code	Floor Code	nvarchar
ff_description	Floor Description	nvarchar
Id	Custodial Route Id	int
personnelCode	Technician Code	nvarchar
personnelName	Technician Name	nvarchar
shft_code	Shift Code	nvarchar
shft_description	Shift Description	nvarchar
supervisorCode	Supervisor Code	nvarchar
supervisorName	Supervisor Name	nvarchar