Views

Back to Dashboard

#	Name	Alias	Descr
1	vw_ActiveLocationActivities
2	vw_adm_OwnerPropertyCount_Active	OPCA	intended for use with feed accounts
3	vw_AllProperty_Comm
4	vw_AmenityFilter_Accessible	Amenity IDs that indicate a property is handicap accessible	menity IDs that indicate a property is handicap accessible
5	vw_AmenityFilter_AllowsPets	Amenity IDs that indicate a property is considered pet-friendly	riendly
6	vw_AmenityFilter_Balcony	Amenity IDs that indicate the property has a balcony	menity IDs that indicate the property has a balcony
7	vw_AmenityFilter_CommunityPool	Amenity IDs that indicate a property has access to a community pool	menity IDs that indicate a property has access to a community pool
8	vw_AmenityFilter_Condo	Amenity IDs that indicate a property is a condo	menity IDs that indicate a property is a condo
9	vw_AmenityFilter_Crib	Amenity IDs that indicate the property has a crib available for guest use	menity IDs that indicate the property has a crib available for guest use
10	vw_AmenityFilter_Dryer	Amenity IDs that indicate the property has guest access to clothes dryers	menity IDs that indicate the property has guest access to clothes dryers
11	vw_AmenityFilter_Elevator	Amenity IDs that indicate the property has elevator access	menity IDs that indicate the property has elevator access
12	vw_AmenityFilter_FencedYard	AMFV	Amenity IDs that indicate the Property has a fenced yard
13	vw_AmenityFilter_GolfCart	Amenity IDs that indicate a property has a golf cart available for guest use	menity IDs that indicate a property has a golf cart available for guest use
14	vw_AmenityFilter_Grill	Amenity IDs that indicate the property has a grill or barbeque (indoor or outdoor, regardless of fuel type)	menity IDs that indicate the property has a grill or barbeque (indoor or outdoor, regardless of fuel type)
15	vw_AmenityFilter_GulfFront	Amenity IDs that indicate a property is located on the gulf front	menity IDs that indicate a property is located on the gulf front
16	vw_AmenityFilter_GulfView	Amenity IDs that indicate a property has a gulf view	menity IDs that indicate a property has a gulf view
17	vw_AmenityFilter_Gym	Amenity IDs that indicate the property has a gym or exercise facilities	menity IDs that indicate the property has a gym or exercise facilities
18	vw_AmenityFilter_HotTub	Amenity IDs that indicate the property has a hot tub	menity IDs that indicate the property has a hot tub
19	vw_AmenityFilter_House	Amenity IDs that indicate a property is a house, cottage or beach home	menity IDs that indicate a property is a house, cottage or beach home
20	vw_AmenityFilter_Parking	Amenity IDs that indicate the property has available parking for guests	menity IDs that indicate the property has available parking for guests
21	vw_AmenityFilter_PrivatePool	Amenity IDs that indicate a property has access to a private pool	menity IDs that indicate a property has access to a private pool
22	vw_AmenityFilter_Smoking	Amenity IDs that indicate the property permits smoking in or around the rental	menity IDs that indicate the property permits smoking in or around the rental
23	vw_AmenityFilter_Townhome	Amenity IDs that indicate a property is a townhome	menity IDs that indicate a property is a townhome
24	vw_AmenityFilter_Washer	Amenity IDs that indicate the property has guest access to washing machines	menity IDs that indicate the property has guest access to washing machines
25	vw_AmenityFilter_WaterFront	Amenity IDs that indicate…	menity IDs that indicate…
26	vw_AmenityFilter_Wifi	Amenity IDs that indicate the property has internet accesss via a 802.11 standard protocol (aka Wifi or Wireless internet access)	menity IDs that indicate the property has internet accesss via a 802.11 standard protocol (aka Wifi or Wireless internet access)
27	vw_Bathroom
28	vw_CityLocationData_FBGroups	Links and images for Facebook groups that are associated with a City	inks and images for Facebook groups that are associated with a City
29	vw_DataFeedSources	DFS	List of data feed sources and property counts
30	vw_DataFeedSources_Active	DFS	List of data feed sources and property counts for non-expired listings
31	vw_DataFeedSources_Active_Owners	DFO	List of owners using data feed sources and property counts
32	vw_DataFeedSources_Owners	DFO	List of owners using data feed sources and property counts
33	vw_DataField_L_LocationInternalLink	LIL	List of internal links for the browse page
34	vw_DataField_O_OwnerInternalLink	OIL	List of internal links for the owner profile page
35	vw_DataField_P_PropertyDataLayer	PDF	Data layer object for the property listing page as used for Google Tag Manager
36	vw_DataField_P_PropertyInternalLink	PIL	List of internal links for the property listing page
37	vw_DeletedImages	Alias: PGD	ist of images flagged for deletion
38	vw_exs_property_booking	Abstract view for the property_booking table	bstract view for the property_booking table
39	vw_ExternalListingSiteFlags	ELSF	Values of the ProcessFlag field by name
40	vw_GetListingMapping_OnlyNulls
41	vw_GetOwnerPhone_Sales	Returns all contact phone numbers for owners in the ECBYO and SMBYO databases	eturns all contact phone numbers for owners in the ECBYO and SMBYO databases
42	vw_GetPropertyMapping_OnlyNulls	Returns a list of properties and their current mapped status against exposed listings for all Owners on all feeds	eturns a list of properties and their current mapped status against exposed listings for all Owners on all feeds
43	vw_GoogleAdwordsLocations	Lists the locations that are using the Google Adwords script to support marketing efforts	ists the locations that are using the Google Adwords script to support marketing efforts
44	vw_HTGPropertyType_Active	HPTA	Active property types used in the HTG export process
45	vw_ImportPropertyDates_OREZ
46	vw_ImportPropertyDetail_TRACK
47	vw_ImportPropertyDetails_OREZ
48	vw_ImportPropertyRate_LoS_SVRS	IPRL	ist of the current rate formats for each LoS Property from the Streamline feed
49	vw_IntercomDataExport	List of emails, user IDs and names for the Intercom chat service	ist of emails, user IDs and names for the Intercom chat service
50	vw_InternalLinkList	LNKL	List of site page URLs and text from the InternalLink table
51	vw_jsonf_PropertyAmenities	VPAM	Details only from the property_amenities table; view produces fields to be used as a JSON payload
52	vw_jsonf_PropertyImages	VPG	Details only from the property_gallery table; view produces fields to be used as a JSON payload
53	vw_ListingActivationStatus_BPAL	LASV	View for listing activation status for the BookingPal feed
54	vw_ListingActivationStatus_HOSPI	LASV	last revised: 2026-08-28 00:23:25 CST
55	vw_ListingActivationStatus_OREZ	LASV	View for listing activation status for the OwnerRez feed
56	vw_NextPaxLoad
57	vw_NextPaxLoad_ByName
58	vw_NextPaxLoad_Raw
59	vw_NextPaxMasterList	Master list of NextPax properties in the feed; currently excluded unmapped properties from vTrips because of their size (can be provided on request)	aster list of NextPax properties in the feed; currently excluded unmapped properties from vTrips because of their size (can be provided on request)
60	vw_NextProperty	NXP	list of mapped amenities for NextPax data imports
61	vw_NonFeedProperty	List	xpired properties that are not on a feed
62	vw_owner_orders_dates
63	vw_OwnerCellNumber
64	vw_OwnerFirstPropertyList
65	vw_OwnerImageUpdateList	Alias: OIUL	ist of OwnerIDs that nned to update the account image (either new or existing)
66	vw_OwnerPricingModel_BPAL	OPMBP	ist of owners and their property pricing models for the BookingPal feed
67	vw_OwnerProfileList_Sitemap
68	vw_OwnerPropertyCount
69	vw_OwnerPropertyCount_Active	Count of owner properties that approved andnot expired (may or may not be online)	ount of owner properties that approved andnot expired (may or may not be online)
70	vw_OwnerPropertyCount_AllActive	Count of owner properties that live (online and approved) - all owners will show up on this list	all owners will show up on this list
71	vw_OwnerPropertyCount_ByPricingModel	OPCPM	otal property counts broken down by pricing model (current focus on BPAL) per Owner
72	vw_OwnerSignup
73	vw_OwnerSignupByDatePart	OWND	List of owner signups by date part; used for graphs and charts; excludes know test accounts
74	vw_OwnersUsingVRBOiCals	VRBO	List of owners using VRBO iCals
75	vw_OwnerWithZeroProp	Owner accounts with no properties	wner accounts with no properties
76	vw_Property_Approval	PRPA	Fields related to property approval and expiration
77	vw_Property_Approved
78	vw_Property_Approved_First
79	vw_Property_Booking
80	vw_Property_Detail	PRPD	Fields related to property details
81	vw_property_inquiry_pw
82	vw_Property_Location	PRPL	Fields related to property location (state, city, community)
83	vw_Property_Marketing	PRPM	Fields related to property details for the marketingof the property
84	vw_Property_NewProperty	PRPN	List of Property IDs that are "New Properties"
85	vw_Property_NotExpired	PRPN	List of Property IDs that are not expired and not deleted
86	vw_Property_PetFriendly
87	vw_property_rates_dates	View of the property_rates table with date fields shown as date data types	iew of the property_rates table with date fields shown as date data types
88	vw_property_review_dates	View of the property_review table with date fields shown as date data types	iew of the property_review table with date fields shown as date data types
89	vw_Property_VisibleByID	Property IDs for currently visible properties (Online, Admin-Approved, Non-Expired)	pproved, Non-Expired)
90	vw_PropertyAdminList
91	vw_PropertyAdminList_Pending
92	vw_PropertyBookingCount
93	vw_PropertyBookingCount_Feed	PBCF	List of actively mapped feed properties that should be considered to have bookings for the purpose of being included in marketing promotions
94	vw_PropertyBookingCount_Future	PBCF	Filtered view of booking counts to see if they qualify to be included in searches (cutoff now is 36 mos in the future, Per Joe - 20240229)
95	vw_PropertyCountByComm_Active
96	vw_PropertyExpirationList
97	vw_PropertyExpirationList_Past	List of properties that have expired already and have not been renewed at the current time	ist of properties that have expired already and have not been renewed at the current time
98	vw_PropertyExpirationList_PHG	Expiration report for Panhandle Gateways	xpiration report for Panhandle Gateways
99	vw_PropertyExpiredList
100	vw_PropertyFeeCount_BPAL	FEEBP	Counts of fees for BookingPal (BPAL) properties
101	vw_PropertyFees_Active	FEEA	Active mandatory and option fees
102	vw_PropertyFees_Active_BPAL	FEEA	Load optional fees from the PropertyFee Table for BPAL properties
103	vw_PropertyGallery_Active
104	vw_PropertyGalleryPath
105	vw_PropertyICalImportFlags	PIIF	Values of the ICalFlag field by name (along with other referential IDs)
106	vw_PropertyICalLinkList_Even	PILL	List of non-IVOL property external iCal links (even numbered batch)
107	vw_PropertyICalLinkList_Odd	PILL	List of non-IVOL property external iCal links (odd numbered batch)
108	vw_PropertyImage
109	vw_PropertyImage_Active
110	vw_PropertyImage_ActiveFileList
111	vw_PropertyImageCount
112	vw_PropertyImageCount_BPAL	PICBP	Counts of valid and invalid images for BookingPal (BPAL) properties
113	vw_PropertyImportActionQueue	Alias: PIAQ	omposite list of all SQL texts for listing update actions on Feed Properties
114	vw_PropertyImportImageCount	Alias: PIMC	ount of images in ImportImage (i.e. images captured via the Images_Save procedure) for a given Property
115	vw_PropertyInfoList
116	vw_PropertyInfoList_PHG
117	vw_PropertyInquiryCount
118	vw_PropertyInquiryListing	List of property inquiries by date	ist of property inquiries by date
119	vw_PropertyListingAdded
120	vw_PropertyListingPurchase
121	vw_PropertyLocationType	List of location info and location level	ist of location info and location level
122	vw_PropertyLocationType_ECBYO	List of location info and location level for use with all of ECBYO	ist of location info and location level for use with all of ECBYO
123	vw_PropertyLocationType_Import	List of location info and location level with added entries to cover data feed imports	ist of location info and location level with added entries to cover data feed imports
124	vw_PropertyLocationType_New	List of location info and location level	ist of location info and location level
125	vw_PropertyLocationType_PageContent	Gets the location page content and videos for a given LocationID	ets the location page content and videos for a given LocationID
126	vw_PropertyLocationTypeCounts
127	vw_PropertyManagerList_OREZ
128	vw_PropertyManagerList_PMT
129	vw_PropertyNewInquiryCount
130	vw_PropertyPricingModel_BPAL	PPMBP	ist of properties and their pricing models for the BookingPal feed
131	vw_PropertyRateFormat	PRMF	List of the current rate formats for each Property
132	vw_PropertyRateFormat_LoS	PRF	List of properties flagged as using LoS rate formats based on data examinations or owner option declarations; used only for feed properties mapped in PropertyExternalListing and flagged in OwnerExternalListing
133	vw_PropertyRateFormat_LoS_NEXT	PRMFNP	ist of the current rate formats for each LoS Property from the NextPax feed (LoS properties are flagged at the Owner level in OwnerExternalListing (OEL))
134	vw_PropertyRateFormat_LoS_SVRS	PRMFST	List of the current rate formats for each LoS Property from the Streamline feed
135	vw_PropertyRateLoSCount_Date	Alias: PRLCD	ount of distinct Start Dates for a given Property
136	vw_PropertyRateLoSCount_Record	Alias: PRLCR	ount of rate records for a given Property
137	vw_PropertyReservationDetail_Active	PRDV	List of active (non-test or otherwise excluded) property reservations for BPAL
138	vw_PropertyReservationFlags	RESF	Values of the ReservationFlags field by name (along with other referential IDs)
139	vw_PropertyReviewCount
140	vw_PropertyReviewCount_WithScore	PRCS	Review count and avergae score with a half-star indicator for each Property
141	vw_PropertyTaxes_Active_BPAL	TAXA	Load optional fees from the PropertyFee Table for BPAL properties
142	vw_PropertyUpdateType	Alias: PUT	ypes or categories of update actions to perform on a Property (typically applies to listing updates on external feed properties)
143	vw_PropertyViewList
144	vw_PropertyWithBookNowLinks	PRPBN	List of Property IDs with active "Book Now" links
145	vw_SEI
146	vw_seo_Cities
147	vw_seo_Comms
148	vw_seo_DefaultComms	Default community for every state/city combination (with names)	efault community for every state/city combination (with names)
149	vw_seo_DefComms	Default community for every state/city combination (with names)	efault community for every state/city combination (with names)
150	vw_seo_States
151	vw_srsml_Backlinks	List of backlinks to Sub-Regional Multiple Location sites	egional Multiple Location sites
152	vw_srsml_Bedroom	Display the contents of the bedroom table, but allow a Studio bedroom to return a 1 vs the 0 that is in the underlying table	isplay the contents of the bedroom table, but allow a Studio bedroom to return a 1 vs the 0 that is in the underlying table
153	vw_SRSSites	SRS	List of locations that have 25 or more properties associated with them
154	vw_SystemPageCount	SPC	Number of pages currently visible for search engine indexing
155	vw_TLD_Allowed	Alias TLD - List of top-level domains allowed forus within the system	List of top-level domains allowed forus within the system
156	vw_TopProperty_City
157	vw_TopProperty_Comm
158	vw_TopProperty_State
159	vw_user_login_dates
160	vw_ZendeskDataExport	List of emails, user IDs and names for the Zendesk Suite service	ist of emails, user IDs and names for the Zendesk Suite service
161	vw_ZendeskSellExport	List of emails, user IDs and names for the Zendesk Sell service	ist of emails, user IDs and names for the Zendesk Sell service

Total: 161 view(s)