| 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 |