vrpt_ReservationResource

Updated January 19, 2026 17:01

Field Name	Field Description	Data Type	FK Join
fd_code	Facility Code	nvarchar
fd_name	Facility Name	nvarchar
genericItemType	Item Type	nvarchar
genericItemTypeCode	Item Type Code	nvarchar
Id	Reservation Resource Id	int
ItemDescription	Item Description	nvarchar
ItemTag	Item Tag	nvarchar
res_number	Reservation Number	int
resr_AcceptedBy	Accepted By	nvarchar
Resr_AcceptedDate	Accepted Date	datetime
Resr_AcceptedReason	Accepted Reason	nvarchar
resr_acceptedrejectedby	Accepted Rejected By	nvarchar
resr_AcceptedRejectedDate	Accepted Rejected Date	datetime
Resr_Acceptor_FK	Acceptor Id	int	vr_users
resr_cancellationdate	Cancellation Date	datetime
resr_cancelledby_fk	Cancelled By Id	int	vr_users
Resr_Clnt_FK	Obsolete Column (No Longer Used)	int
Resr_CreatedDate	Record Creation Date	datetime
Resr_Creator_FK	User Id (Record Creator)	int	vr_users
Resr_EndDate	End Date	datetime
Resr_EstimatedCost	Estimated Cost	decimal
Resr_fd_fk	Facility Id	int	vr_Facility
Resr_generic_fk	Generic Id	int
resr_itemType	item Type	nvarchar
Resr_ItemType_FK	Item Type Id	int
Resr_ModifiedDate	Last Modified Date	datetime
Resr_Modifier_FK	User Id (Record Modifier)	int	vr_users
Resr_PK	Reservation Resource Id	int
resr_RejectedBy	Rejected By	nvarchar
Resr_RejectedDate	Rejected Date	datetime
REsr_RejectedReason	Rejected Reason	nvarchar
Resr_Rejector_FK	Rejector Id	int	vr_users
Resr_Res_FK	Reservation Id	int	vr_Reservation
resr_seriesKey	Series Key	nvarchar
Resr_Smoking	Indicates if this record allows smoking	bit
Resr_StartDate	Start Date	datetime
Resr_Tag_FK	Tag Id	int
type_pk	Type Id	int