Stored Procedures
Back to Dashboard| # | Name | Descr |
|---|---|---|
| 1 | EF_O | Gets all extra fee records from extra_fee for a given Property; intended for admin use only |
| 2 | EF_P | Gets all extra fee records from extra_fee for a given Property; intended for admin use only |
| 3 | EF_SRSML | Gets all extra fee records from extra_fee for all Props in an SRS-ML; intended for admin use only |
| 4 | ELS | Gets all records from ExternalListingSite; intended for admin use only |
| 5 | FAQ_O | Gets all listings from question_ans for a given Owner; intended for admin use only |
| 6 | FAQ_P | Gets all listings from question_ans for a given Property; intended for admin use only |
| 7 | FEE_O | Gets all fees from PropertyFee for a given Owner; intended for admin use only |
| 8 | FEE_P | Gets all fees from PropertyFee for a given Property; intended for admin use only |
| 9 | FEE_S | Gets all fees from PropertyFee for a given Site; intended for admin use only |
| 10 | FEE_SRSML | Gets all fees from property_booking_system_mandatory_fee for all Props in an SRS-ML; intended for admin use only |
| 11 | FEED_P | Gets the feed source for a given Property; intended for admin use only |
| 12 | IMD_O | Gets all rates from ImportDate for a given Owner; intended for admin use only |
| 13 | IMD_P | Gets all rates from ImportDate for a given Property; intended for admin use only |
| 14 | IMD_S | Gets all rates from ImportDate for a given Site; intended for admin use only |
| 15 | IMG_O | Gets all images from property_gallery for a given Owner; intended for admin use only |
| 16 | IMG_P | Gets all images from property_gallery for a given Property; intended for admin use only |
| 17 | IMG_SRSML | Gets all images from property_gallery for all Props in an SRS-ML; intended for admin use only |
| 18 | IMI_O | Gets all listing images from ImportImage for a given Owner; intended for admin use only |
| 19 | IMI_P | Gets all listing iamges from ImportImage for a given Property; intended for admin use only |
| 20 | IMI_S | Gets all listing iamges from ImportImage for a given Site; intended for admin use only |
| 21 | IMR_O | Gets all rates from ImportRate for a given Owner; intended for admin use only |
| 22 | IMR_P | Gets all rates from ImportRate for a given Property; intended for admin use only |
| 23 | IMR_S | Gets all rates from ImportRate for a given Site; intended for admin use only |
| 24 | INQ_O | Gets all inquiries from property_inquiry for a given Owner; intended for admin use only |
| 25 | INQ_P | Gets all inquiries from property_inquiry for a given Property; intended for admin use only |
| 26 | INQ_SRSML | Gets all inquiries from property_inquiry for all Props in an SRS-ML; intended for admin use only |
| 27 | IVOL_P | Gets the record from the Property table for a given ivacationonline Property ID; intended for admin use only |
| 28 | LAS_O | Gets all properties from ListingActivationStatus for a given Owner; intended for admin use only |
| 29 | LAS_P | Gets a record from ListingActivationStatus for a given Property; intended for admin use only |
| 30 | LAS_S | Gets all properties from ListingActivationStatus for a given Site; intended for admin use only |
| 31 | LOOK_O | Gets all property data for a given Owner; intended for admin use only |
| 32 | LOOK_P | Gets all property data for a given Property; intended for admin use only |
| 33 | MFEE_O | Gets all fees from property_booking_system_mandatory_fee for a given Owner; intended for admin use only |
| 34 | MFEE_P | Gets all fees from property_booking_system_mandatory_fee for a given Property; intended for admin use only |
| 35 | OEL | Gets all owners from OwnerExternalListing; intended for admin use only |
| 36 | OEL_O | Gets all owners from OwnerExternalListing for a given Owner; intended for admin use only |
| 37 | OEL_S | Gets all listings from OwnerExternalListing for a given Site; intended for admin use only |
| 38 | ORD | Gets the property listing order info for a given Order; intended for admin use only |
| 39 | OWN_O | Gets the owner account info from user_login for a given Owner; intended for admin use only |
| 40 | OWN_P | Gets the owner record for a given Property; intended for admin use only |
| 41 | OWN_S | Gets the owner account info from user_login for a given Feed Site; intended for admin use only |
| 42 | PAC_O | Gets all activities from property_activities for a given Owner; intended for admin use only |
| 43 | PAC_P | Gets all activities from property_activities for a given Property; intended for admin use only |
| 44 | PAC_SRSML | Gets all activities from property_activities for all Props in an SRS-ML; intended for admin use only |
| 45 | PAD_O | Gets all addresses from PropertyAddress for a given Owner; intended for admin use only |
| 46 | PAD_P | Gets all addresses from PropertyAddress for a given Property; intended for admin use only |
| 47 | PAD_S | Gets all addresses from PropertyAddress for a given Site; intended for admin use only |
| 48 | PAD_SRSML | Gets all addresses from PropertyAddress for all Props in an SRS-ML; intended for admin use only |
| 49 | PAF_N | Gets all addresses from PropertyAmenityFilter for a given Filter; intended for admin use only |
| 50 | PAF_O | Gets all addresses from PropertyAmenityFilter for a given Owner; intended for admin use only |
| 51 | PAF_P | Gets all addresses from PropertyAmenityFilter for a given Property; intended for admin use only |
| 52 | PAM_O | Gets all amenities from PropertyAmenity for a given Owner; intended for admin use only |
| 53 | PAM_P | Gets all amenities from PropertyAmenity for a given Property; intended for admin use only |
| 54 | PAM_SRSML | Gets all amenities from PropertyAmenity for all Props in an SRS-ML; intended for admin use only |
| 55 | PBC_O | Gets all bookings from PropertyBookingCalendar for a given Owner; intended for admin use only |
| 56 | PBC_P | Gets all bookings from PropertyBookingCalendar for a given Property; intended for admin use only |
| 57 | PBI_O | Gets all bookings from PropertyBookingImport for a given Owner; intended for admin use only |
| 58 | PBI_P | Gets all bookings from PropertyBookingImport for a given Property; intended for admin use only |
| 59 | PBK_O | Gets all bookings from PropertyBooking for a given Owner; intended for admin use only |
| 60 | PBK_P | Gets all bookings from PropertyBooking for a given Property; intended for admin use only |
| 61 | PBK_S | Gets all bookings from PropertyBooking for a given Site; intended for admin use only |
| 62 | PBK_SRSML | Gets all bookings from PropertyBooking for all Props in an SRS-ML; intended for admin use only |
| 63 | PDL_O | Gets all deals from PropertyDeal for a given Owner; intended for admin use only |
| 64 | PDL_P | Gets all deals from PropertyDeal for a given Property; intended for admin use only |
| 65 | PEI_O | Gets all listings from PropertyExternalImport for a given Owner; intended for admin use only |
| 66 | PEI_P | Gets all listings from PropertyExternalImport for a given Property; intended for admin use only |
| 67 | PEI_S | Gets all listings from PropertyExternalImport for a given Site; intended for admin use only |
| 68 | PEIA_O | Gets all listings from PropertyExternalImport_Avail for a given Owner; intended for admin use only |
| 69 | PEIA_P | Gets all listings from PropertyExternalImport_Avail for a given Property; intended for admin use only |
| 70 | PEIA_S | Gets all listings from PropertyExternalImport_Rate for a given Site; intended for admin use only |
| 71 | PEIR_O | Gets all listings from PropertyExternalImport_Rate for a given Owner; intended for admin use only |
| 72 | PEIR_P | Gets all listings from PropertyExternalImport_Rate for a given Property; intended for admin use only |
| 73 | PEIR_S | Gets all listings from PropertyExternalImport_Rate for a given Site; intended for admin use only |
| 74 | PEL_L | Gets all listings from PropertyExternalListing for a given Listing; intended for admin use only |
| 75 | PEL_O | Gets all listings from PropertyExternalListing for a given Owner; intended for admin use only |
| 76 | PEL_P | Gets all listings from PropertyExternalListing for a given Property; intended for admin use only |
| 77 | PEL_S | Gets all listings from PropertyExternalListing for a given Site; intended for admin use only |
| 78 | PES | Gets all listings from PropertyExternalStatus; intended for admin use only |
| 79 | PES_O | Gets all listings from PropertyExternalStatus for a given Owner; intended for admin use only |
| 80 | PES_P | Gets all listings from PropertyExternalStatus for a given Property; intended for admin use only |
| 81 | PES_S | Gets all listings from PropertyExternalStatus for a given Site; intended for admin use only |
| 82 | PEU | Gets all listings from PropertyExternalUpdate; intended for admin use only |
| 83 | PEU_O | Gets all listings from PropertyExternalUpdate for a given Owner; intended for admin use only |
| 84 | PEU_O_N | Gets all listings from PropertyExternalUpdate for a given Owner on a given NodelLabel; intended for admin use only |
| 85 | PEU_P | Gets all listings from PropertyExternalUpdate for a given Property; intended for admin use only |
| 86 | PEU_P_N | Gets all listings from PropertyExternalUpdate for a given Property on a given NodelLabel; intended for admin use only |
| 87 | PEU_S | Gets all listings from PropertyExternalUpdate for a given Site; intended for admin use only |
| 88 | PEU_S_N | Gets all listings from PropertyExternalUpdate for a given Site on a given NodelLabel; intended for admin use only |
| 89 | PIC_O | Gets the property image counts for a given Owner; intended for admin use only |
| 90 | PIC_P | Gets the property image count for a given Property; intended for admin use only |
| 91 | PII_O | Gets all records from PropertyICalImport for a given Property; intended for admin use only |
| 92 | PII_P | Gets all records from PropertyICalImport for a given Property; intended for admin use only |
| 93 | PLI_O | Gets all listings from PropertyListingInventory for a given Owner; intended for admin use only |
| 94 | PLI_S | Gets all listings from PropertyListingInventory for a given Site; intended for admin use only |
| 95 | PMN_O | Gets all records from PropertyMinNight for a given Owner; intended for admin use only |
| 96 | PMN_P | Gets all records from PropertyMinNight for a given Property; intended for admin use only |
| 97 | PNR_O | Gets all records from PropertyNightlyRates for a given Owner; intended for admin use only |
| 98 | PNR_P | Gets the record from PropertyNightlyRates for a given Property; intended for admin use only |
| 99 | PPM_O | Gets all Properties from PropertyPricingModel for the given Owner; intended for admin use only |
| 100 | PPM_P | Gets a specific Property from PropertyPricingModel; intended for admin use only |
| 101 | PPM_S | Gets all Properties from PropertyPricingModel for the given Site; intended for admin use only |
| 102 | PRK_O | Gets all scores from property_rank for a given Owner; intended for admin use only |
| 103 | PRK_P | Gets all scores from property_rank for a given Property; intended for admin use only |
| 104 | PRK_SRSML | Gets all scores from property_rank for all Props in an SRS-ML; intended for admin use only |
| 105 | PRL_O | Gets all rates from PropertyRateLoS for a given Owner; intended for admin use only |
| 106 | PRL_P | Gets all rates from PropertyRateLoS for a given Property and StartDate; intended for admin use only |
| 107 | PRP_A | Gets all properties for a given Amenity ID; intended for admin use only |
| 108 | PRP_C | Gets all properties for a given City; intended for admin use only |
| 109 | PRP_M | Gets all properties in a given Community; intended for admin use only |
| 110 | PRP_O | Gets all properties for a given Community; intended for admin use only |
| 111 | PRP_O_C | Gets all properties in a given City for a given Owner; intended for admin use only |
| 112 | PRP_O_M | Gets all properties in a given Community for a given Owner; intended for admin use only |
| 113 | PRP_P | Gets the specified Property by ID; intended for admin use only |
| 114 | PRP_S | Gets all properties for a given Site; intended for admin use only |
| 115 | PRPX_S | Gets all properties for a given Site, spefically built for James to us; intended for admin use only |
| 116 | PRT_O | Gets all rates from vw_property_rates_dates for a given Owner; intended for admin use only |
| 117 | PRT_P | Gets all rates from vw_property_rates_dates for a given Property; intended for admin use only |
| 118 | PRT_SRSML | Gets all rates from vw_property_rates_datess for all Props in an SRS-ML; intended for admin use only |
| 119 | PRV_DATE | Gets all reviews from property_review for a given submit Date; intended for admin use only |
| 120 | PRV_LAST | Gets the last number of reviews from property_review for all Properties; intended for admin use only |
| 121 | PRV_O | Gets all reviews from property_review for a given Owner; intended for admin use only |
| 122 | PRV_P | Gets all reviews from property_review for a given Property; intended for admin use only |
| 123 | PRV_SRSML | Gets all reviews from property_review for all Props in an SRS-ML; intended for admin use only |
| 124 | SAC_S | Gets all amenity categories from amenities_category for a given Site; intended for admin use only |
| 125 | SAM | Gets all amenities from amenities; intended for admin use only |
| 126 | SAM_C | Gets all amenities from Amenities for a given Category (name or ID); intended for admin use only |
| 127 | SEO_C | Gets the property location from seo_ecbyo for a given City; intended for admin use only |
| 128 | SEO_M | Gets the property location from seo_ecbyo for a given Community; intended for admin use only |
| 129 | TAX_O | Gets all fees from PropertyTax for a given Owner; intended for admin use only |
| 130 | TAX_P | Gets all fees from PropertyTax for a given Property; intended for admin use only |
| 131 | TAX_S | Gets all fees from PropertyTax for a given SIte; intended for admin use only |
| 132 | usp_api_ActivateDeal | Activates a deal for the specified property (activatiing one deal deactivates all other ones) |
| 133 | usp_api_CreateBooking | Creates a manually booked date for the specified property |
| 134 | usp_api_CreateDeal | Creates a deal for the specified property |
| 135 | usp_api_CreateFAQ | Creates a FAQ for the specified property |
| 136 | usp_api_CreateFee | Creates a new fee for the specified property |
| 137 | usp_api_CreateICalLink | Creates an new iCal import link for the specified property |
| 138 | usp_api_CreateImage | Creates an image for the specified property |
| 139 | usp_api_CreateOwner | Creates an owner account based on the information supplied (first and last name, email address, phone number and an initial account password) |
| 140 | usp_api_CreateRate | Creates a rate for the specified property |
| 141 | usp_api_CreateTax | Creates a tax for the specified property |
| 142 | usp_api_DeleteAddress | Deletes the street address for the specified property |
| 143 | usp_api_DeleteAmenities | Deletes all selected amenities for the specified property |
| 144 | usp_api_DeleteBooking | Deletes a manually booked date for the specified property |
| 145 | usp_api_DeleteBooking_List | Deletes all manually booked date for the specified property according to the provided list |
| 146 | usp_api_DeleteBookings | Deletes all manually booked dates for the specified property |
| 147 | usp_api_DeleteDeal | Deletes a deal from the specified property |
| 148 | usp_api_DeleteDeals | Deletes all deals from the specified property |
| 149 | usp_api_DeleteFAQ | Deletes a FAQ from the specified property |
| 150 | usp_api_DeleteFAQ_List | Deletes FAQs from the specified property from the supplied list |
| 151 | usp_api_DeleteFAQs | Deletes all FAQs from the specified property |
| 152 | usp_api_DeleteFee | Deletes a fee from the specified property |
| 153 | usp_api_DeleteFee_List | Deletes fees from the specified property from the supplied list |
| 154 | usp_api_DeleteFees | Deletes all fees from the specified property |
| 155 | usp_api_DeleteICalLink | Deletes an ICalLink from a specific property |
| 156 | usp_api_DeleteICalLinks | Deletes all ICalLinks from the specified property |
| 157 | usp_api_DeleteImage | Deletes an image for the specified property |
| 158 | usp_api_DeleteImage_List | Deletes images from the specified property according to the supplied list |
| 159 | usp_api_DeleteImages | Deletes all images from the specified property |
| 160 | usp_api_DeleteInquiry | Deletes an Inquiry from the specified property |
| 161 | usp_api_DeleteList | Unified List Deletion based on table and variable designations |
| 162 | usp_api_DeletePlural | Unified Plural Delete for API |
| 163 | usp_api_DeleteProperty | Deleted the specified owner property |
| 164 | usp_api_DeleteProperty_List | Deleted the owner properties specified in the list |
| 165 | usp_api_DeleteRate | Deletes a rate from the specified property |
| 166 | usp_api_DeleteRate_List | Deletes rates from the specified property from the supplied list |
| 167 | usp_api_DeleteRates | Deletes all rates from the specified property |
| 168 | usp_api_DeleteSingular | Unified Singular API Delete |
| 169 | usp_api_DeleteTax | Deletes a tax from the specified property |
| 170 | usp_api_DeleteTax_List | Deletes taxes from the specified property from the supplied list |
| 171 | usp_api_DeleteTaxes | Deletes all taxes from the specified property |
| 172 | usp_api_GetAddress | Returns the street address for the specified property |
| 173 | usp_api_GetAmenities | Returns all selected amenities for the specified property |
| 174 | usp_api_GetAmenityList | Returns the list of amenities from which the owner may select for the specified property |
| 175 | usp_api_GetBooking | Returns a manually booked date range for the specified property |
| 176 | usp_api_GetBookings | Returns all manually booked dates for the specified property |
| 177 | usp_api_GetCalendar | Returns the consolidated for the specified property |
| 178 | usp_api_GetCalendarExport | Returns the contents for the iCal Export of the calendar data for the specified property |
| 179 | usp_api_GetCityLocations | Returns a list of city marketing locations |
| 180 | usp_api_GetCommunityLocations | Returns a list of community marketing locations |
| 181 | usp_api_GetDeal | Returns a deal for the specified property |
| 182 | usp_api_GetDeals | Returns all deals for the specified property |
| 183 | usp_api_GetFAQ | Returns an FAQ for the specified property and FAQ ID |
| 184 | usp_api_GetFAQs | Returns all FAQs for the specified property |
| 185 | usp_api_GetFee | Returns a fee for the specified property |
| 186 | usp_api_GetFees | Returns all fees for the specified property |
| 187 | usp_api_GetICalBookings | Returns all iCal booked dates for the specified property |
| 188 | usp_api_GetICalLink | Gets a specified ICal link for the specified property |
| 189 | usp_api_GetICalLinks | Returns all iCal links for the specified property |
| 190 | usp_api_GetImage | Returns an image for the specified property image |
| 191 | usp_api_GetImages | Returns all images for the specified property |
| 192 | usp_api_GetInquiries | Returns all inquiries for the specified property |
| 193 | usp_api_GetInquiries_Owner | Returns all inquiries for the owners properties |
| 194 | usp_api_GetInquiry | Returns the specified inquiry for the property |
| 195 | usp_api_GetInvoice | Returns the specified invoice for the owner |
| 196 | usp_api_GetInvoices_Owner | Returns all invoices for the owner's products and services; currently working with the old "order" schema (PW - 2025-02-09) |
| 197 | usp_api_GetOrder | Returns the requested order for the specified owner |
| 198 | usp_api_GetOwnerDashboard | Returns data needed for the owner dashboard (more details TBD) |
| 199 | usp_api_GetOwnerProfile | Returns the data for the owner's profile |
| 200 | usp_api_GetProperties_Owner | Returns all properties for the owner |
| 201 | usp_api_GetProperty | Returns the specified owner property |
| 202 | usp_api_GetPropertyCategories | Returns the statistics for the specified owner property |
| 203 | usp_api_GetPropertyStatistics | Returns the statistics for the specified owner property |
| 204 | usp_api_GetRate | Alias: PRTI - Periodic rates for a given Property |
| 205 | usp_api_GetRates | Returns all rates for the specified property |
| 206 | usp_api_GetReview | Returns the specified review for a property of the owner |
| 207 | usp_api_GetReviews | Returns all reviews for the specified property |
| 208 | usp_api_GetReviews_Owner | Returns all reviews for the owners properties |
| 209 | usp_api_GetStateLocations | Returns a list of state marketing locations |
| 210 | usp_api_GetTax | Returns a tax for the specified property |
| 211 | usp_api_GetTaxes | Returns all taxes for the specified property |
| 212 | usp_api_GetVoucher_Owner | Returns a specified voucher for the owners property |
| 213 | usp_api_GetVouchers_Owner | Returns all vouchers for the owners properties |
| 214 | usp_api_InsertPropertyICalImport_IVOL | Creates an new iCal import link for the specified property for an IVOL property mapping |
| 215 | usp_api_MapIvolProperty | Maps an IVOL property to an ECBYO property |
| 216 | usp_api_ResetOwnerPassword | Updates an owner account to reflect the request to change their password |
| 217 | usp_api_UpdateAddress | Updates the street address for the specified property |
| 218 | usp_api_UpdateAmenities | Updates all selected amenities for the specified property |
| 219 | usp_api_UpdateBooking | Updates a manually booked date for the specified property |
| 220 | usp_api_UpdateDeal | Updates a deal for the specified property |
| 221 | usp_api_UpdateFAQ | Updates a FAQ for the specified property |
| 222 | usp_api_UpdateFee | Updates a fee for the specified property |
| 223 | usp_api_UpdateICalLink | Updates an iCal link for the specified property |
| 224 | usp_api_UpdateImage | Updates an image for the specified property |
| 225 | usp_api_UpdateOwnerProfile | Update the data for the owner's profile |
| 226 | usp_api_UpdateProperty_Detail | Update designated data for the owner property |
| 227 | usp_api_UpdateRate | Updates a rate for the specified property |
| 228 | usp_api_UpdateReview | Updates a review for the specified property |
| 229 | usp_api_UpdateTax | Updates a tax for the specified property |
| 230 | usp_cbx_GetLocationList_City | Gets a list of City IDs and labels; intended for use in a combo box control or something similar |
| 231 | usp_cbx_GetLocationList_Comm | Gets a list of SEO IDs (as communities) and labels; intended for use in a combo box control or something similar |
| 232 | usp_cbx_GetLocationList_State | Gets a list of state IDs and labels; intended for use in a combo box control or something similar |
| 233 | usp_cbx_GetOwnersList | Gets a list of Owner IDs and labels; intended for use in a combo box control or something similar |
| 234 | usp_cbx_GetPropertyList | Gets a list of Property IDs and labels; intended for use in a combo box control or something similar |
| 235 | usp_cbx_GetSMSCarrier_Active | Gets all record from the SMSCarrier table where they can be displayed to the user; used for dropdown controls and others |
| 236 | usp_cbx_GetVoucherTypeList | Gets a list of VoucherType IDs and labels; intended for use in a combo box control or something similar |
| 237 | usp_CreateCSModelClass | Creates the code for a basic C# model class for use with .NET Core applications |
| 238 | usp_CreateNewPropertyRecords | Creates additional records needed when a new Property is created |
| 239 | usp_CreatePropertyOptionView | Creates a view for the PropertyOption table |
| 240 | usp_CreateSMSVerifyMessage | Creates verification SMS message for owner logins to the website |
| 241 | usp_CreateSystemOptionView | Creates a view for the SystemOption table |
| 242 | usp_DismissInactiveFeedProperties | Adds properties to the owner account apart from any subscription packages |
| 243 | usp_dm_ActivateOwner | Activates an Owner who signed up using the website |
| 244 | usp_dm_AddTo_site_form_contactus | Adds a record to the site_form_contactus table |
| 245 | usp_dm_AddToAccessEventLog | Adds a record to the AccessEventLog table |
| 246 | usp_dm_AddToAccessEventLog_Key | Adds a record to the AccessEventLog table using a EventTypeKey |
| 247 | usp_dm_AddToBlogComments | Adds a record to the BlogComments table |
| 248 | usp_dm_AddToBlogs | Adds a record to the Blogs table |
| 249 | usp_dm_AddToDataFieldType | Adds a record to the DataFieldType table |
| 250 | usp_dm_AddToErrorLog_BPAL | Adds a record to the ErrorLog_BPAL table |
| 251 | usp_dm_AddToEventContact | Adds a record to the EventContact table |
| 252 | usp_dm_AddToExternalListingNote | Adds a record to the ExternalListingNote table |
| 253 | usp_dm_AddToExternalListingSite | Adds a record to the ExternalListingSite table |
| 254 | usp_dm_AddTofee_notes | Adds a record to the fee_notes table |
| 255 | usp_dm_AddToHelpVideo | Adds a record to the HelpVideo table |
| 256 | usp_dm_AddToICalImportLog | Adds a record to the ICalImportLog table |
| 257 | usp_dm_AddToImportRate | Adds a record to the ImportRate table |
| 258 | usp_dm_AddToInternalLink | Adds a record to the InternalLink table |
| 259 | usp_dm_AddToJsonPropertyName | Adds a record to the JsonPropertyName table |
| 260 | usp_dm_AddToLocationDataField | Adds a record to the LocationDataField table |
| 261 | usp_dm_AddToOwnerAccessLog | Adds a record to the OwnerAccessLog table |
| 262 | usp_dm_AddToOwnerExternalInventory | Adds a record to the OwnerExternalInventory table |
| 263 | usp_dm_AddToOwnerExternalListing | Adds a record to the OwnerExternalListing table |
| 264 | usp_dm_AddToOwnerImportFile | Adds a record to the OwnerImportFile table |
| 265 | usp_dm_AddToOwnerReferral | Adds a record to the OwnerReferral table |
| 266 | usp_dm_AddToProcessErrorLog | Adds a record to the ProcessErrorLog table |
| 267 | usp_dm_AddToproperty_gallery | Adds a record to the property_gallery table |
| 268 | usp_dm_AddToproperty_gallery_BPAL | Adds a record to the property_gallery table as part of the BookingPal API functionality; only select fields are involved |
| 269 | usp_dm_AddToproperty_inquiry | Adds a record to the property_inquiry table |
| 270 | usp_dm_AddToproperty_rates | Adds a record to the property_rates table |
| 271 | usp_dm_AddToProperty_Stimulus | Adds properties to the owner account, free of charge, for 3 months |
| 272 | usp_dm_AddToPropertyActivityImport | Adds a record to the PropertyActivityImport table |
| 273 | usp_dm_AddToPropertyAddress | Adds a record to the PropertyAddress table |
| 274 | usp_dm_AddToPropertyAmenityFilter | Adds a record to the PropertyAmenityFilter table |
| 275 | usp_dm_AddToPropertyBookingCalendar | Adds a record to the PropertyBookingCalendar table |
| 276 | usp_dm_AddToPropertyBookingImport | Adds a record to the PropertyBookingImport table |
| 277 | usp_dm_AddToPropertyCalendar | Adds a record to the PropertyCalendar table |
| 278 | usp_dm_AddToPropertyDataField | Adds a record to the PropertyDataField table |
| 279 | usp_dm_AddToPropertyDeal | Adds a record to the PropertyDeal table |
| 280 | usp_dm_AddToPropertyExternalImport | Adds a record to the PropertyExternalImport table |
| 281 | usp_dm_AddToPropertyExternalImport_Avail | Adds a record to the PropertyExternalImport_Avail table |
| 282 | usp_dm_AddToPropertyExternalImport_Rate | Adds a record to the PropertyExternalImport_Rate table |
| 283 | usp_dm_AddToPropertyExternalListing | Adds a record to the PropertyExternalListing table |
| 284 | usp_dm_AddToPropertyExternalStatus | Adds a record to the PropertyExternalStatus table |
| 285 | usp_dm_AddToPropertyExternalUpdate | Adds a record to the PropertyExternalUpdate table |
| 286 | usp_dm_AddToPropertyFee | Adds a record to the PropertyFee table |
| 287 | usp_dm_AddToPropertyGalleryLog | Adds a record to the PropertyGalleryLog table |
| 288 | usp_dm_AddToPropertyICalImport | Adds a record to the PropertyICalImport table |
| 289 | usp_dm_AddToPropertyICalImportLog | Adds a record to the PropertyICalImportLog table |
| 290 | usp_dm_AddToPropertyImage | Adds a record to the PropertyImage table |
| 291 | usp_dm_AddToPropertyImageContent | Adds a record to the PropertyImageContent table |
| 292 | usp_dm_AddToPropertyImageURL | Adds a record to the PropertyImageURL table |
| 293 | usp_dm_AddToPropertyListingEvent | Adds a record to the PropertyListingEvent table |
| 294 | usp_dm_AddToPropertyListingEvent_Code | Adds a record to the PropertyListingEvent table by ListingEventCode |
| 295 | usp_dm_AddToPropertyListingInventory | Adds a record to the PropertyListingInventory table |
| 296 | usp_dm_AddToPropertyLocationImport | Adds a record to the PropertyLocationImport table |
| 297 | usp_dm_AddToPropertyNightlyRate | Adds a record to the PropertyNightlyRate table from the rate calculation process |
| 298 | usp_dm_AddToPropertyQuote | Adds a record to the PropertyQuote table |
| 299 | usp_dm_AddToPropertyRate | Adds a record to the PropertyRate table |
| 300 | usp_dm_AddToPropertyRateImport | Adds a record to the PropertyRateImport table |
| 301 | usp_dm_AddToPropertyRateLoS | Adds a record to the PropertyRateLoS table |
| 302 | usp_dm_AddToPropertyReservation | Adds a record to the PropertyReservation table |
| 303 | usp_dm_AddToPropertyReservationData | Adds a record to the PropertyReservationData table |
| 304 | usp_dm_AddToPropertyReservationDetail | Adds a record to the PropertyReservationDetail table |
| 305 | usp_dm_AddToPropertyReview | Adds a record to the PropertyReview table |
| 306 | usp_dm_AddToPropertySearchLog | Adds a record to the PropertySearchLog table |
| 307 | usp_dm_AddToPropertySearchLog_Key | Adds a record to the PropertySearchLog table; this version will return the SearchKey when the SendID flag is set |
| 308 | usp_dm_AddToPropertyTax | Adds a record to the PropertyTax table |
| 309 | usp_dm_AddToReservationCancellationLog | Adds a record to the ReservationCancellationLog table |
| 310 | usp_dm_AddToSearchOverrideLog | Adds a record to the SearchOverrideLog table |
| 311 | usp_dm_AddToSEO_ECBYO | Adds a record to the SEO_ECBYO table |
| 312 | usp_dm_AddToSiteImportFile | Adds a record to the SiteImportFile table |
| 313 | usp_dm_AddToSMSCarrier | Adds a record to the SMSCarrier table |
| 314 | usp_dm_AddToSubSite | Adds a record to the SubSite table |
| 315 | usp_dm_AddToSubSitePage | Adds a record to the SubSitePage table |
| 316 | usp_dm_AddToSuspectInquiryEmail | Adds a record to the SuspectInquiryEmail table |
| 317 | usp_dm_AddToSystemOptionList | Adds a record to the SystemOptionList table |
| 318 | usp_dm_AddToSystemReview | Adds a record to the SystemReview table |
| 319 | usp_dm_AddToVoucher | Adds a record to the Voucher table |
| 320 | usp_dm_AddToVoucher_Owner | Adds a record to the Voucher table for every property on a given owner account |
| 321 | usp_dm_adm_GetAddedProperties | List of the most recently added properties |
| 322 | usp_dm_adm_GetListingByCity | Returns a count of property listings by city |
| 323 | usp_dm_adm_GetListingByComm | Returns a count of property listings by community (uses the SEOID to handle this, NOT the comm ID) |
| 324 | usp_dm_adm_GetListingByState | Returns a count of property listings by state |
| 325 | usp_dm_adm_GetListingPurchases | List property listing purchases to date by week for a given time period |
| 326 | usp_dm_adm_GetListingPurchases_Month | List property listing purchases to date grouped by month for a given time period |
| 327 | usp_dm_adm_GetListingPurchases_ThisMonth | List property listing purchases for the current calendar month |
| 328 | usp_dm_adm_GetListingPurchases_ThisMonth_Daily | List property listing purchases for the current calendar month by day |
| 329 | usp_dm_adm_GetListingPurchases_ThisQuarter | List property listing purchases for the current calendar quarter |
| 330 | usp_dm_adm_GetListingPurchases_ThisWeek | List property listing purchases for the current calendar week |
| 331 | usp_dm_adm_GetListingPurchases_ThisWeek_Daily | List property listing purchases for the current calendar week by day |
| 332 | usp_dm_adm_GetOwnerReferrals | List of owners, codes and referral counts for the Refer A Friend program |
| 333 | usp_dm_adm_GetOwnerSignups | List owner signups to date by week for a given time period |
| 334 | usp_dm_adm_GetPaidOwners | List of the last 100 property listings purchased |
| 335 | usp_dm_adm_GetPropertyInquiries_ThisMonth | List property inquiries for the current calendar month |
| 336 | usp_dm_adm_GetPropertyInquiries_ThisMonth_Daily | List property inquiries for the current calendar month by day |
| 337 | usp_dm_adm_GetPropertyInquiries_ThisQuarter | List property inquiries for the current calendar quarter |
| 338 | usp_dm_adm_GetPropertyInquiries_ThisQuarter_Weekly | List property inquiries for the current calendar quarter by week |
| 339 | usp_dm_adm_GetPropertyInquiries_ThisWeek | List property inquiries for the current calendar week |
| 340 | usp_dm_adm_GetPropertyInquiries_ThisWeek_Daily | List property inquiries for the current calendar week by day |
| 341 | usp_dm_adm_GetRecentInquiries | List of the most 100 recent property inquiries |
| 342 | usp_dm_adm_GetReferredOwners | List of owners referred by an Owner for the Refer A Friend program with a given code |
| 343 | usp_dm_adm_GetSubRegionalSiteList_Candidate | Returns list of communities with a certain number of properties assocated with it |
| 344 | usp_dm_adm_ViewPropertyBookings | View all bookings for a given Property |
| 345 | usp_dm_adm_ViewPropertyPhotos | View all photos for a given Property |
| 346 | usp_dm_adm_ViewPropertyReviews | View all reviews for a given Property |
| 347 | usp_dm_adm_ViewPropertyScores | View ranking scores for a given Property |
| 348 | usp_dm_ApplyVoucher | Applies the action for a given voucher to the recorded entities |
| 349 | usp_dm_ApplyVoucher_ByCode_Owner | Applies the action for a given voucher to the recorded entities (in this casee, all vouchers of a given Voucher Code for a given Owner) |
| 350 | usp_dm_ApprovalQualificationReport | This procedure shows properties that are approved but should not be |
| 351 | usp_dm_ApprovalStatusReport | This procedure show the approval status for properties and owners |
| 352 | usp_dm_ApprovePropertyListing | Bring a listing online and put it in an enabled state for a given Property |
| 353 | usp_dm_ApprovePropertyListing_Auto | Autotmated property approval process resulting in bringing a listing online and putting it in an enabled state Several criteria are evaluated (and tracked in PropertyExternalStatus (PES)) - Property Description |
| 354 | usp_dm_CancelPropertyReservation_Code | Processes the request for a reservation cancellation |
| 355 | usp_dm_CaptureOwnerContacts_BPAL | Captures the owner contact information supplied on BookingPal listings and updates OwnerContact_BPAL |
| 356 | usp_dm_CaptureProcessError | Wraps the process of adding to the ProcessErrorLog table |
| 357 | usp_dm_CapturePropertyLocations | Capture the State, City and Location ID for a given Property, Onwer or Site into the ListingLocation field in PropertyExternalListing - it will be used for future location refreshes on the property |
| 358 | usp_dm_CreateFeedOwner_BPAL | Creates an owner account and feed mapping from the BookingPal API in one process |
| 359 | usp_dm_CreateInternalLinkURL | Create an list of URLs for Internal Links - both the master and site tables |
| 360 | usp_dm_CreateInternalLinkURLMaster | Create an list of URLs for the InternalLinkMaster table, which is then used to populate the InternalLink table with links and text |
| 361 | usp_dm_CreateMissingFeedDataLinks_SVRS | Creates a list of data feed links for properties in the Streanline feed where data seems to be missing |
| 362 | usp_dm_CreateOwner | Creates an owner account based on the information supplied (first and last name, email address, phone number and an initial account password) |
| 363 | usp_dm_CreateOwner_BPAL | Create the owner record chain for a new Owner on BookingPal |
| 364 | usp_dm_CreateOwnerReferralCoupon | Creates the Owner Referral coupon from a slice of the OwnerCode (ulogn_user_code) |
| 365 | usp_dm_CreatePropertyImage_BPAL | Adds a single image to a BookingPal property listing |
| 366 | usp_dm_CreatePropertyListing_BPAL | Adds properties to a BookingPal owner account apart from any subscription packages |
| 367 | usp_dm_DeleteAccessEventLog | Deletes a record from the AccessEventLog table |
| 368 | usp_dm_DeleteBlogComments | Deletes a record from the BlogComments table |
| 369 | usp_dm_DeleteBlogComments_All | Deletes all records from the BlogComments table for a given BlogID |
| 370 | usp_dm_DeleteBlogs | Deletes a record from the Blogs table |
| 371 | usp_dm_DeleteDataFieldType | Deletes a record from the DataFieldType table |
| 372 | usp_dm_DeleteEventContact | Deletes a record from the EventContact table |
| 373 | usp_dm_DeleteExternalListingNote | Deletes a record from the ExternalListingNote table |
| 374 | usp_dm_DeleteExternalListingNote_Owner | Deletes all records from the ExternalListingNote table for a given Owner |
| 375 | usp_dm_DeleteExternalListingNote_Property | Deletes all records from the ExternalListingNote table for a given Property |
| 376 | usp_dm_DeleteExternalListingNote_Site | Deletes all records from the ExternalListingNote table for a given Site |
| 377 | usp_dm_DeleteExternalListingSite | Deletes a record from the ExternalListingSite table |
| 378 | usp_dm_Deletefee_notes | Deletes a record from the fee_notes table |
| 379 | usp_dm_Deletefee_notes_Property | Deletes all records from the fee_notes table for a given Property |
| 380 | usp_dm_DeleteHelpVideo | Deletes a record from the HelpVideo table |
| 381 | usp_dm_DeleteImportDate_Date | Deletes all records from the ImportDate table for a given Date |
| 382 | usp_dm_DeleteImportDate_Owner | Deletes all record from the ImportDate table for a given Owner |
| 383 | usp_dm_DeleteImportDate_Property | Deletes all record from the ImportDate table for a given Property |
| 384 | usp_dm_DeleteImportDate_Save | Deletes all rates from the ImportDate table for a given Site, Owner and Property, based on data that is in the PropertyExternalImport table |
| 385 | usp_dm_DeleteImportDate_Site | Deletes all records from the ImportDate table for a given Site (external feed source) |
| 386 | usp_dm_DeleteImportImage_Save | Deletes all images from the ImportImage table for a given Site, Owner and Property, based on data that is in the PropertyExternalImport table |
| 387 | usp_dm_DeleteImportRate_Owner | Deletes all record from the ImportRate table for a given Owner |
| 388 | usp_dm_DeleteImportRate_Property | Deletes all record from the ImportRate table for a given Property |
| 389 | usp_dm_DeleteImportRate_Save | Deletes all rates from the ImportRate table for a given Site, Owner and Property, based on data that is in the PropertyExternalImport table |
| 390 | usp_dm_DeleteImportRate_Site | Deletes all record from the ImportRate table for a given Site (external feed source) |
| 391 | usp_dm_DeleteInternalLink | Deletes a record from the InternalLink table |
| 392 | usp_dm_DeleteInternalLink_URL | Deletes a record from the InternalLink table for a given Site URL |
| 393 | usp_dm_DeleteLocationDataField | Deletes a record from the LocationDataField table for a given Location |
| 394 | usp_dm_DeleteLocationDataField_DataFieldType | Deletes all records from the LocationDataField table for a given Data Field Type |
| 395 | usp_dm_DeleteOwnerAccessLog | Deletes a record from the OwnerAccessLog table |
| 396 | usp_dm_DeleteOwnerExternalInventory | Deletes a record from the OwnerExternalInventory table |
| 397 | usp_dm_DeleteOwnerExternalInventory_Owner | Deletes all records from the OwnerExternalInventory table for a given Owner (should be only one record) |
| 398 | usp_dm_DeleteOwnerExternalListing | Deletes a record from the OwnerExternalListing table |
| 399 | usp_dm_DeleteOwnerExternalListing_Owner | Deletes all records from the OwnerExternalListing table for a given Owner (should only be one) |
| 400 | usp_dm_DeleteOwnerExternalListing_Owner_Site | Deletes all records from the OwnerExternalListing table for a given Owner and Site |
| 401 | usp_dm_DeleteOwnerImportFile | Deletes a record from the OwnerImportFile table |
| 402 | usp_dm_DeleteOwnerImportFile_Owner | Deletes all records from the OwnerImportFile table for a given Owner |
| 403 | usp_dm_DeleteOwnerImportFile_Site | Deletes all records from the OwnerImportFile table for a given Site |
| 404 | usp_dm_Deleteproperty_amenities | Deletes a record from the property_amenities table |
| 405 | usp_dm_Deleteproperty_amenities_Property | Deletes all records from the property_amenities table for a given Property |
| 406 | usp_dm_DeleteProperty_Booking | Deletes a record from the Property_Booking table |
| 407 | usp_dm_DeleteProperty_Booking_Property | Deletes all record from the Property_Booking table for a given property (This is the old format table) |
| 408 | usp_dm_Deleteproperty_gallery | Deletes a record from the property_gallery table |
| 409 | usp_dm_Deleteproperty_gallery_Feed_Property | Deletes all records from the property_gallery table for a given feed property if there are valid records in the import table for the Property |
| 410 | usp_dm_Deleteproperty_gallery_Property | Deletes all records from the property_gallery table for a given Property |
| 411 | usp_dm_Deleteproperty_rates | Deletes a record from the property_rates table |
| 412 | usp_dm_Deleteproperty_rates_Owner | Deletes all records from the property_rates table for a given Owner |
| 413 | usp_dm_Deleteproperty_rates_Property | Deletes all records from the property_rates table for a given Property |
| 414 | usp_dm_DeletePropertyActivityImport_Property | Deletes records from the PropertyActivityImport table for a given Property |
| 415 | usp_dm_DeletePropertyAddress | Deletes a record from the PropertyAddress table |
| 416 | usp_dm_DeletePropertyAddress_Property | Deletes all records from the PropertyAddress table for a given Property |
| 417 | usp_dm_DeletePropertyBooking_Owner | Deletes all records from the PropertyBooking table for a given Owner |
| 418 | usp_dm_DeletePropertyBookingCalendar | Deletes a record from the PropertyBookingCalendar table |
| 419 | usp_dm_DeletePropertyBookingCalendar_Property | Deletes a record from the PropertyBookingCalendar table |
| 420 | usp_dm_DeletePropertyBookingImport_Import | Deletes all records from the PropertyBookingImport table for a given Import |
| 421 | usp_dm_DeletePropertyBookingImport_Property | Deletes all records from the PropertyBookingImport table for a given Property |
| 422 | usp_dm_DeletePropertyCalendar | Deletes a record from the PropertyCalendar table |
| 423 | usp_dm_DeletePropertyCalendar_Property | Deletes all records from the PropertyCalendar table for a given Property |
| 424 | usp_dm_DeletePropertyDataField | Deletes a record from the PropertyDataField table |
| 425 | usp_dm_DeletePropertyDataField_DataFieldType | Deletes all records from the PropertyDataField table for a given Data Field Type |
| 426 | usp_dm_DeletePropertyDataField_Property | Deletes all records from the PropertyDataField table for a given Property |
| 427 | usp_dm_DeletePropertyDateAvailability | Deletes a record from the PropertyDateAvailability table |
| 428 | usp_dm_DeletePropertyDateAvailability_Owner | Deletes all record from the PropertyDateAvailability table for a given Owner |
| 429 | usp_dm_DeletePropertyDateAvailability_Site | Deletes all record from the PropertyDateAvailability table for a given Site (only works on an active feed) |
| 430 | usp_dm_DeletePropertyDateLoS_Owner | Deletes all records from the PropertyDateLoS table for a given Owner |
| 431 | usp_dm_DeletePropertyDateLoS_Property | Deletes all records from the PropertyDateLoS table for a given Property |
| 432 | usp_dm_DeletePropertyDateLoS_Property_Date | Deletes all records from the PropertyDateLoS table for a given StartDate |
| 433 | usp_dm_DeletePropertyDeal | Deletes a record from the PropertyDeal table |
| 434 | usp_dm_DeletePropertyDeal_All | Deletes all records from the PropertyDeal table for a given Property |
| 435 | usp_dm_DeletePropertyDeal_Property | Deletes all records from the PropertyDeal table for a given Property |
| 436 | usp_dm_DeletePropertyExternalImport | Deletes a record from the PropertyExternalImport table |
| 437 | usp_dm_DeletePropertyExternalImport_Avail | Deletes a record from the PropertyExternalImport_Avail table |
| 438 | usp_dm_DeletePropertyExternalImport_Avail_Owner | Deletes all records from the PropertyExternalImport_Avail table for a given Owner |
| 439 | usp_dm_DeletePropertyExternalImport_Avail_Property | Deletes a record from the PropertyExternalImport_Avail table for a given Property |
| 440 | usp_dm_DeletePropertyExternalImport_Owner | Deletes all records from the PropertyExternalImport table for a given Owner |
| 441 | usp_dm_DeletePropertyExternalImport_Property | Deletes all records from the PropertyExternalImport table for a given Property |
| 442 | usp_dm_DeletePropertyExternalImport_Rate | Deletes a record from the PropertyExternalImport_Rate table |
| 443 | usp_dm_DeletePropertyExternalImport_Rate_Owner | Deletes all records from the PropertyExternalImport_Rate table for a given Owner |
| 444 | usp_dm_DeletePropertyExternalImport_Rate_Property | Deletes a record from the PropertyExternalImport_Rate table for a given Property |
| 445 | usp_dm_DeletePropertyExternalListing | Deletes a record from the PropertyExternalListing table |
| 446 | usp_dm_DeletePropertyExternalListing_Owner | Deletes all records from the PropertyExternalListing table for a given Owner |
| 447 | usp_dm_DeletePropertyExternalListing_Property | Deletes all records from the PropertyExternalListing table for a given Property (should only be one record) |
| 448 | usp_dm_DeletePropertyExternalUpdate | Deletes a record from the PropertyExternalUpdate table |
| 449 | usp_dm_DeletePropertyFee | Deletes a record from the PropertyFee table |
| 450 | usp_dm_DeletePropertyFee_Owner | Deletes all records from the PropertyFee table for a given Owner |
| 451 | usp_dm_DeletePropertyFee_Property | Deletes all records from the PropertyFee table for a given Property |
| 452 | usp_dm_DeletePropertyGalleryLog | Deletes records from the PropertyGalleryLog table for the specified image |
| 453 | usp_dm_DeletePropertyGalleryLog_Type | Deletes records from the PropertyGalleryLog table for the specified image |
| 454 | usp_dm_DeletePropertyICalImport | Deletes a record from the PropertyICalImport table |
| 455 | usp_dm_DeletePropertyICalImport_Property | Deletes all records from the PropertyICalImport table for a given Property |
| 456 | usp_dm_DeletePropertyICalImport_Property_IVOL | Deletes all records from the PropertyICalImport table that from association with an ivacationline listing for a given Property |
| 457 | usp_dm_DeletePropertyICalImport_Property_User | Deletes all records from the PropertyICalImport table that were entered from the user interface for a given Property |
| 458 | usp_dm_DeletePropertyICalImport_User | Deletes a record from the PropertyICalImport table that was entered from the user interface |
| 459 | usp_dm_DeletePropertyImage | Deletes a record from the PropertyImage table |
| 460 | usp_dm_DeletePropertyImage_Property | Deletes record from the PropertyImage table for a given Property |
| 461 | usp_dm_DeletePropertyImageContent | Deletes a record from the PropertyImageContent table |
| 462 | usp_dm_DeletePropertyImageImport | Deletes a record from the PropertyImageImport table |
| 463 | usp_dm_DeletePropertyImageImport_Owner | Deletes all records from the PropertyImageImport table for a given Owner |
| 464 | usp_dm_DeletePropertyImageImport_Property | Deletes all records from the PropertyImageImport table for a given Property |
| 465 | usp_dm_DeletePropertyImages_BPAL | Deletes the specified image from property_gallery (PropertyImage) from a BookingPal property listing This procedure does verify the image belongs to such an account |
| 466 | usp_dm_DeletePropertyImageURL_Image | Deletes records from the PropertyImageURL table for the specified image |
| 467 | usp_dm_DeletePropertyImageURL_Image_Type | Deletes records from the PropertyImageURL table for the specified image and image type |
| 468 | usp_dm_DeletePropertyListing_BPAL | Deletes (by flagging) the specified property from a BookingPal account It will only flag for deletion - it will NOT clean out the property in any way, at least at this time |
| 469 | usp_dm_DeletePropertyListingEvent | Deletes a record from the PropertyListingEvent table |
| 470 | usp_dm_DeletePropertyListingEvent_Property | Deletes all records from the PropertyListingEvent table for a given Property |
| 471 | usp_dm_DeletePropertyListingInventory | Deletes a record from the PropertyListingInventory table |
| 472 | usp_dm_DeletePropertyListingInventory_Owner | Deletes all records from the PropertyListingInventory table for a given Owner |
| 473 | usp_dm_DeletePropertyListingInventory_Property | Deletes all records from the PropertyListingInventory table for a given Property |
| 474 | usp_dm_DeletePropertyListingInventory_Site | Deletes all records from the PropertyListingInventory table for a given Site |
| 475 | usp_dm_DeletePropertyMinNight_Property | Deletes all records from the PropertyMinNight table for a given Property |
| 476 | usp_dm_DeletePropertyQuote | Deletes a record from the PropertyQuote table |
| 477 | usp_dm_DeletePropertyQuote_Property | Deletes all records from the PropertyQuote table for a given Property |
| 478 | usp_dm_DeletePropertyRate | Deletes a record from the PropertyRate table |
| 479 | usp_dm_DeletePropertyRate_Owner | Deletes all records from the PropertyRate table for a given Owner - INTENDED FOR ADMIN USE |
| 480 | usp_dm_DeletePropertyRate_Property | Deletes all records from the PropertyRate table for a given Property |
| 481 | usp_dm_DeletePropertyRateLoS_Owner | Deletes all records from the PropertyRateLoS table for a given Owner |
| 482 | usp_dm_DeletePropertyRateLoS_Property | Deletes all records from the PropertyRateLoS table for a given Property |
| 483 | usp_dm_DeletePropertyRateLoS_Property_Date | Deletes all records from the PropertyRateLoS table for a given StartDate |
| 484 | usp_dm_DeletePropertyRateLoS_Raw_BPAL_Owner | Deletes all records from the PropertyRateLoS_Raw_BPAL table for a given Owner |
| 485 | usp_dm_DeletePropertyRateLoS_Raw_BPAL_Property | Deletes all records from the PropertyRateLoS_Raw_BPAL table for a given Property |
| 486 | usp_dm_DeletePropertyRateLoS_Raw_BPAL_Property_Date | Deletes all records from the PropertyRateLoS_Raw_BPAL table for a given StartDate |
| 487 | usp_dm_DeletePropertyReservationDetail | Deletes a record from the PropertyReservationDetail table |
| 488 | usp_dm_DeletePropertyReview | Deletes a record from the PropertyReview table |
| 489 | usp_dm_DeletePropertyReview_Property | Deletes record from the PropertyReview table for a given Property |
| 490 | usp_dm_DeletePropertySearchLog | Deletes a record from the PropertySearchLog table |
| 491 | usp_dm_DeletePropertySearchLog_Key | Deletes a record from the PropertySearchLog table based on the SearchKey |
| 492 | usp_dm_DeletePropertyTax | Deletes a record from the PropertyTax table |
| 493 | usp_dm_DeletePropertyTax_Property | Deletes all records from the PropertyTax table for a given Property |
| 494 | usp_dm_DeleteSearchOverrideLog | Deletes a record from the SearchOverrideLog table |
| 495 | usp_dm_DeleteSEO_ECBYO | Deletes a record from the SEO_ECBYO table |
| 496 | usp_dm_DeleteSiteExternalImport_Site | Deletes all record from the SiteExternalImport table for a given Site |
| 497 | usp_dm_DeleteSiteImportFile | Deletes a record from the SiteImportFile table |
| 498 | usp_dm_DeleteSiteImportFile_Site | Deletes all records from the SiteImportFile table for a given Site |
| 499 | usp_dm_DeleteSMSCarrier | Deletes a record from the SMSCarrier table |
| 500 | usp_dm_DeleteSubSite | Deletes a record from the SubSite table |
| 501 | usp_dm_DeleteSubSitePage | Deletes a record from the SubSitePage table |
| 502 | usp_dm_DeleteSuspectInquiryEmail | Deletes a record from the SuspectInquiryEmail table |
| 503 | usp_dm_DeleteSystemOptionList | Deletes a record from the SystemOptionList table |
| 504 | usp_dm_DeleteSystemReview | Deletes a record from the SystemReview table |
| 505 | usp_dm_DeleteVoucher | Deletes a record from the Voucher table |
| 506 | usp_dm_DisablePropertyListing | Take a listing offline and put it in a disabled state for a given Property |
| 507 | usp_dm_DisableVoucher | Disables or enables a Voucher - only unapplied vouchers can be disabled |
| 508 | usp_dm_DisapprovePropertyListing_Auto | Autotmated property dis-approval process resulting in taking a listing online and putting it in a pending state Right now, its use is limited to BPAL listing that rescind the activation status |
| 509 | usp_dm_DismissPropertyListing | Update admin status to "dismissed" for a given Property |
| 510 | usp_dm_Get_package_Renewals | Get all records from the package table that are active and eligible to use for property renewals |
| 511 | usp_dm_GetAccessEventLog | Gets a record from the AccessEventLog table |
| 512 | usp_dm_GetAccessEventLog_Key | Gets all record from the AccessEventLog table for a given EventTypeKey |
| 513 | usp_dm_GetBlog | Returns data from the blogs table for the specified blog |
| 514 | usp_dm_GetBlog_All | Returns all records from the blogs table |
| 515 | usp_dm_GetBlogComments | Returns a single record from the blog_comments table |
| 516 | usp_dm_GetBlogComments_All | Returns all records from the blog_comments table for the specified blog |
| 517 | usp_dm_GetCalendarDateStatus | Returns the dates and their availability status from the property_booking table for the specificed property; 0 - Available, 1 - Check Out Only, 2 - Check In Only, 3 - Turnover Date, 4 - Unavailable |
| 518 | usp_dm_GetCalendarDateStatus_Date | Returns the dates and their availability status from the property_booking table for the specificed property; 0 - Available, 1 - Check Out Only, 2 - Check In Only, 3 - Turnover Date, 4 - Unavailable |
| 519 | usp_dm_GetCurrentAnnualPackagePrice | Gets the current package price for the annual subscription |
| 520 | usp_dm_GetDataFieldType | Gets a record from the DataFieldType table |
| 521 | usp_dm_GetDataFieldType_Group | Gets a record from the DataFieldType table |
| 522 | usp_dm_GetErrorLog_BPAL | Gets a record from the ErrorLog_BPAL table |
| 523 | usp_dm_GetEventContact | Gets a record from the EventContact table |
| 524 | usp_dm_GetEventContact_Email | Gets all records from the EventContact table for a given Email |
| 525 | usp_dm_GetExternalListingNote | Gets a record from the ExternalListingNote table |
| 526 | usp_dm_GetExternalListingNote_Owner | Gets all records from the ExternalListingNote table for a given Owner |
| 527 | usp_dm_GetExternalListingNote_Property | Gets all records from the ExternalListingNote table for a given Property |
| 528 | usp_dm_GetExternalListingNote_Site | Gets all records from the ExternalListingNote table for a given Site |
| 529 | usp_dm_GetExternalListingSite | Gets a record from the ExternalListingSite table |
| 530 | usp_dm_GetExternalListingSite_Integrate | Gets all record from the ExternalListingSite table that are available for self-integration or are in use |
| 531 | usp_dm_GetExternalListingSite_InUse | Gets all record from the ExternalListingSite table that are in use |
| 532 | usp_dm_Getfee_notes | Gets a record from the fee_notes table |
| 533 | usp_dm_Getfee_notes_Property | Gets all records from the fee_notes table for a given Property |
| 534 | usp_dm_GetFeedOwnerList | List of owner IDs for the specified Source |
| 535 | usp_dm_GetFeedOwnerPropertyList | List of owner IDs for the specified Source |
| 536 | usp_dm_GetFeedOwners_NewProperty | List of feed owners with New Property listings |
| 537 | usp_dm_GetFeedPropertyList | List of Property IDs for the specified Source |
| 538 | usp_dm_GetFirstPropInfoForOwner | Returns the first (chronologically) approved property for the specified owner |
| 539 | usp_dm_GetHelpVideo | View records in the HelpVideo table for a VideoUserType |
| 540 | usp_dm_GetICalFileName | Returns a file name for an iCal export - either the one in extra_fee or create one and update extra_fee with it |
| 541 | usp_dm_GetICalFileName_DNU | Returns a file name for an iCal export - either the one in extra_fee or create one and update extra_fee with it |
| 542 | usp_dm_GetImageFileName | Gets the file name for an image record from the property_gallery table |
| 543 | usp_dm_GetImportDate_Date | Gets all records from the ImportDate table for a given Date |
| 544 | usp_dm_GetImportDate_Owner | Gets all record from the ImportDate table for a given Owner |
| 545 | usp_dm_GetImportDate_Property | Gets all record from the ImportDate table for a given Property |
| 546 | usp_dm_GetImportDate_Site | Gets all records from the ImportDate table for a given Site (external feed source) |
| 547 | usp_dm_GetImportOwnerQueue | Returns the list of owners with properties in PropertyExternalImport that are set to process |
| 548 | usp_dm_GetImportOwnerQueue_Avail | Returns the list of owners with properties in PropertyExternalImport_Avail that are set to process |
| 549 | usp_dm_GetImportOwnerQueue_Rate | Returns the list of owners with properties in PropertyExternalImport_Rate that are set to process |
| 550 | usp_dm_GetImportPropertyQueue | Returns the list of properties in PropertyExternalImport that are set to process (except for properties that are expired or deleted) |
| 551 | usp_dm_GetImportPropertyQueue_Avail | Returns the list of properties in PropertyExternalImport_Avail that are set to process (except for properties that are expired or deleted) |
| 552 | usp_dm_GetImportPropertyQueue_Rate | Returns the list of properties in PropertyExternalImport_Rate that are set to process (except for properties that are expired or deleted) |
| 553 | usp_dm_GetImportSiteQueue | Returns the list of sites in PropertyExternalImport that are set to process |
| 554 | usp_dm_GetImportSiteQueue_Avail | Returns the list of sites in PropertyExternalImport_Rate that are set to process |
| 555 | usp_dm_GetImportSiteQueue_Rate | Returns the list of sites in PropertyExternalImport_Rate that are set to process |
| 556 | usp_dm_GetInactiveOwnerList | Get a list of inactive owners based on the value of the ulogn_isactive field in the user_login table (20230719) |
| 557 | usp_dm_GetInternalLink | Gets a record from the InternalLink table |
| 558 | usp_dm_GetInternalLink_URL | Gets a record from the InternalLink table for a give Site URL |
| 559 | usp_dm_GetJsonPropertyName | Gets a record from the JsonPropertyName table |
| 560 | usp_dm_GetJsonPropertyName_Property | Gets all records from the JsonPropertyName table for a given PropertyName |
| 561 | usp_dm_GetLocationNames_SEOID | Returns the state, city and community names from the seo_ecbyo table for a given SEOID |
| 562 | usp_dm_GetMandatory_Fee | Gets a record from the property_booking_system_mandatory_fee table |
| 563 | usp_dm_GetMappedPropertyList_Owner | Returns a list of mapped properties for a given Owner on a feed |
| 564 | usp_dm_GetMissingFeedData_KIGO | Creates a list on mapped external listings that are no longer exposed in the TrackHS feed |
| 565 | usp_dm_GetMissingFeedData_NEXT | Creates a list on mapped external listings that are no longer exposed in the NextPax feed; comparison based on the current contents of the NEXT_PropertyList table and the PropertyExternalLIsting table |
| 566 | usp_dm_GetMissingFeedData_NEXT_Owner | Creates a list on mapped external listings that are no longer exposed in the NextPax feed; comparison based on the current contents of the NEXT_PropertyList table and the PropertyExternalLIsting table for a given Owner |
| 567 | usp_dm_GetMissingFeedData_SVRS | Creates a list on mapped external listings that are no longer exposed in the Streanline feed |
| 568 | usp_dm_GetMissingFeedData_TRACK | Creates a list on mapped external listings that are no longer exposed in the TrackHS feed |
| 569 | usp_dm_GetOwnerAccessLog | Gets a record from the OwnerAccessLog table |
| 570 | usp_dm_GetOwnerAccessLog_Owner | Gets all records from the OwnerAccessLog table for a given Owner |
| 571 | usp_dm_GetOwnerByCode | Get an Owner by OwnerKeyCode |
| 572 | usp_dm_GetOwnerByID | Get an Owner by OwnerID |
| 573 | usp_dm_GetOwnerByPropertyID | Get an Owner by a given PropertyID from the Properties table |
| 574 | usp_dm_GetOwnerContactTypeList | Gets a record from the OwnerContactTypeList table |
| 575 | usp_dm_GetOwnerDashboardTotals | Gets the total number of properties, inquires and reviews for the dashboard of a given property Owner |
| 576 | usp_dm_GetOwnerExternalInventory | Gets a record from the OwnerExternalInventory table |
| 577 | usp_dm_GetOwnerExternalInventory_Owner | Gets all records from the OwnerExternalInventory table for a given Owner (should only be one record) |
| 578 | usp_dm_GetOwnerExternalListing | Gets a record from the OwnerExternalListing table |
| 579 | usp_dm_GetOwnerExternalListing_Owner | Gets all records from the OwnerExternalListing table for a given Owner |
| 580 | usp_dm_GetOwnerExternalListing_Site | Gets all records from the OwnerExternalListing table for a given Site |
| 581 | usp_dm_GetOwnerIDFromCode | Get the valid, displayable OwnerID from the supplied OwnerCode; Owner must have a complete profile and listings to display to be valid |
| 582 | usp_dm_GetOwnerIDFromID | Get the valid, displayable OwnerID from the supplied ID; Owner must have a complete profile and listings to display to be valid |
| 583 | usp_dm_GetOwnerImportFile | Gets a record from the OwnerImportFile table |
| 584 | usp_dm_GetOwnerImportFile_Owner | Gets all records from the OwnerImportFile table for a given Owner |
| 585 | usp_dm_GetOwnerImportFile_Site | Gets all records from the OwnerImportFile table for a given Site |
| 586 | usp_dm_GetOwnerInquiryEmail | Get the property email, if it exists, else get the owner email for a given Property (used for property inquiry emails to owners) |
| 587 | usp_dm_GetOwnerProfile | Get the profile information for a given Owner (updated version as of 5/12/2024) |
| 588 | usp_dm_GetOwnerPropertyEmail_DNU | Get the property email, if it exists, else get the owner email for a given Property (used for property inquiry emails to owners) |
| 589 | usp_dm_GetOwnerReferral | Gets a record from the OwnerReferral table |
| 590 | usp_dm_GetOwnerReferral_All | Gets all records from the OwnerReferral table |
| 591 | usp_dm_GetOwnerReferral_Owner | Gets a record from the OwnerReferral table |
| 592 | usp_dm_GetOwnerReferral_Unsent | Gets all records from the OwnerReferral table that have been reviewed but not been sent out |
| 593 | usp_dm_GetPendingListingOwnerList | Gets a list of non-feed owners who have pending property listings |
| 594 | usp_dm_GetProcessErrorLog | Gets a record from the ProcessErrorLog table |
| 595 | usp_dm_GetProperty | Gets entire property profile for a given Property IDs; use to get info for the listing page and property owner admin |
| 596 | usp_dm_GetProperty_Activities_List_Property | Gets all record from the property_activities table for a given Property with the category ID and activity name |
| 597 | usp_dm_GetProperty_Amenities_List_Property | Gets all record from the property_amenities table for a given Property with the category ID and amenity name |
| 598 | usp_dm_Getproperty_gallery | Gets a record from the property_gallery table |
| 599 | usp_dm_Getproperty_gallery_Property | Gets a record from the property_gallery table |
| 600 | usp_dm_Getproperty_inquiry | Gets a record from the property_inquiry table |
| 601 | usp_dm_GetProperty_Inquiry_Current | Gets all records to the property_inquiry table submitted between "yesterday" and "now" |
| 602 | usp_dm_Getproperty_inquiry_Property | Gets all record from the property_inquiry table for a given Property |
| 603 | usp_dm_GetProperty_Owner | Gets entire property profile for all properties of a given Owner ID; use for the property owner admin (REVISED 20240110) |
| 604 | usp_dm_Getproperty_rates | Gets a record from the property_rates table |
| 605 | usp_dm_Getproperty_rates_Property | Gets all records from the property_rates table for a given Property |
| 606 | usp_dm_GetPropertyActivityImport_Property | Gets records to the PropertyActivityImport table for a given Property |
| 607 | usp_dm_GetPropertyActivityImportList_Property | Gets a list of the PropertyActivityImport for a given Property |
| 608 | usp_dm_GetPropertyActivityList_Property | Gets a list of the property_activities for a given Property |
| 609 | usp_dm_GetPropertyAddress | Gets a record from the PropertyAddress table |
| 610 | usp_dm_GetPropertyAddress_Property | Gets all records from the PropertyAddress table for a given Property |
| 611 | usp_dm_GetPropertyAmenityFilter | Gets a record from the PropertyAmenityFilter table |
| 612 | usp_dm_GetPropertyAmenityFilter_Property | Gets all records from the PropertyAmenityFilter table for a given Property |
| 613 | usp_dm_GetPropertyAmenityFilterOverride_Property | Gets all records from the PropertyAmenityFilter table for a given Property |
| 614 | usp_dm_GetPropertyApprovalScore | Returns the list of properties and their suitability for auto approval |
| 615 | usp_dm_GetPropertyAvailabilityWithRatesRequest | Returns the JSON data for the Streamline property availability request for a given Property; intended to function like a quote |
| 616 | usp_dm_GetPropertyBookingByPropertyID | Get PropertyBooking records by PropertyID |
| 617 | usp_dm_GetPropertyBookingCalendar | Gets a record from the PropertyBookingCalendar table |
| 618 | usp_dm_GetPropertyBookingCalendar_Property | Gets a record from the PropertyBookingCalendar table |
| 619 | usp_dm_GetPropertyBookingImport_Import | Gets all records from the PropertyBookingImport table for a given Import |
| 620 | usp_dm_GetPropertyBookingImport_Property | Gets all records from the PropertyBookingImport table for a given Property |
| 621 | usp_dm_GetPropertyByID | Get a given Property by PropertyID |
| 622 | usp_dm_GetPropertyByOwnerID | Get all Properties for a given Owner by OwnerID |
| 623 | usp_dm_GetPropertyCalendar_Property | Gets all records to the PropertyCalendar table for a given Property |
| 624 | usp_dm_GetPropertyCalendar_Property_Date | Gets all records to the PropertyCalendar table for a given Property over a certain date range |
| 625 | usp_dm_GetPropertyDataField | Gets a record from the PropertyDataField table |
| 626 | usp_dm_GetPropertyDataField_DataFieldType | Gets all records from the PropertyDataField table for a given Data Field Type |
| 627 | usp_dm_GetPropertyDataField_Property | Gets all records from the PropertyDataField table for a given Property |
| 628 | usp_dm_GetPropertyDateAvailability | Gets all records from the PropertyDateAvailability table for a given Property |
| 629 | usp_dm_GetPropertyDateAvailability_Date | Gets all records from the PropertyDateAvailability table for a given Property and CheckInDate (should only return one record) |
| 630 | usp_dm_GetPropertyDateAvailability_Owner_Count | Gets a count of from the PropertyDateAvailability table for a given Owner - indicates if they have records or not |
| 631 | usp_dm_GetPropertyDateLoS_DateRange | Gets all records from the PropertyDateLoS table for a given range between StartDate and EndDate for a given Property |
| 632 | usp_dm_GetPropertyDateLoS_Owner | Gets all records from the PropertyDateLoS table for a given Owner |
| 633 | usp_dm_GetPropertyDateLoS_Property | Gets all records from the PropertyDateLoS table for a given Property |
| 634 | usp_dm_GetPropertyDatesRequest | Returns the JSON data for the Streamline property calendar info request for a given Property |
| 635 | usp_dm_GetPropertyDeal | View a record in the PropertyDeal table |
| 636 | usp_dm_GetPropertyDeal_Property | View records in the PropertyDeal table for a given property |
| 637 | usp_dm_GetPropertyDeals_Active | View deals in the PropertyDeal table that are currently active and online for a given property |
| 638 | usp_dm_GetPropertyDetailWithOwner | |
| 639 | usp_dm_GetPropertyExternalImport | Gets a record from the PropertyExternalImport table |
| 640 | usp_dm_GetPropertyExternalImport_Avail | Gets a record from the PropertyExternalImport_Avail table |
| 641 | usp_dm_GetPropertyExternalImport_Avail_Listing | Gets all record from the PropertyExternalImport_Rate table for a given Property by the external listing ID and site (should only be one record) |
| 642 | usp_dm_GetPropertyExternalImport_Avail_Property | Gets all record from the PropertyExternalImport_Avail table for a given Property (should only be one) |
| 643 | usp_dm_GetPropertyExternalImport_Listing | Gets all record from the PropertyExternalImport table for a given Property by the external listing ID and site (should only be one record) |
| 644 | usp_dm_GetPropertyExternalImport_Property | Gets all record from the PropertyExternalImport table for a given Property (should only be one) |
| 645 | usp_dm_GetPropertyExternalImport_Rate | Gets a record from the PropertyExternalImport_Rate table |
| 646 | usp_dm_GetPropertyExternalImport_Rate_Listing | Gets all record from the PropertyExternalImport_Rate table for a given Property by the external listing ID and site (should only be one record) |
| 647 | usp_dm_GetPropertyExternalImport_Rate_Property | Gets all record from the PropertyExternalImport_Rate table for a given Property (should only be one) |
| 648 | usp_dm_GetPropertyExternalListing | Gets a record from the PropertyExternalListing table |
| 649 | usp_dm_GetPropertyExternalListing_Listing | Gets all records from the PropertyExternalListing table for a given Property by the external listing ID and site (should only be one record) |
| 650 | usp_dm_GetPropertyExternalListing_Owner | Gets all records from the PropertyExternalListing table for a given Owner |
| 651 | usp_dm_GetPropertyExternalListing_Property | Gets all records from the PropertyExternalListing table for a given Property (should only be one record) |
| 652 | usp_dm_GetPropertyExternalStatus | Gets a record from the PropertyExternalStatus table |
| 653 | usp_dm_GetPropertyExternalStatus_Owner | Gets a record from the PropertyExternalStatus table |
| 654 | usp_dm_GetPropertyExternalStatus_Property | Gets a record from the PropertyExternalStatus table |
| 655 | usp_dm_GetPropertyExternalUpdate | Gets a record from the PropertyExternalUpdate table |
| 656 | usp_dm_GetPropertyExternalUpdate_Property | Gets all record from the PropertyExternalUpdate table for a given Property |
| 657 | usp_dm_GetPropertyExternalUpdate_Property_Node | Gets all record from the PropertyExternalUpdate table for a given Propertyand NodeLabel |
| 658 | usp_dm_GetPropertyFee | Gets a record from the PropertyFee table |
| 659 | usp_dm_GetPropertyFee_Active_Property | Gets an active record to the PropertyFee table for a given Property |
| 660 | usp_dm_GetPropertyFee_Property | Gets all records to the PropertyFee table for a given Property |
| 661 | usp_dm_GetPropertyFeedInfo_Short | Returns basic info for a Property and any feed mapping |
| 662 | usp_dm_GetPropertyFeesRequest | Returns the JSON data for the Streamline property fee request for a given Property |
| 663 | usp_dm_GetPropertyGalleryByID | Get a given image |
| 664 | usp_dm_GetPropertyGalleryByPropertyID | Get all images for a given Property |
| 665 | usp_dm_GetPropertyICalImport | Gets a record from the PropertyICalImport table; gets falg values also |
| 666 | usp_dm_GetPropertyICalImport_Property | Gets all records from the PropertyICalImport table for a given Property; gets falg values also |
| 667 | usp_dm_GetPropertyICalImportLog | Gets a record from the PropertyICalImportLog table |
| 668 | usp_dm_GetPropertyICalImportLog_Property | Gets all records from the PropertyICalImportLog table for a given Property |
| 669 | usp_dm_GetPropertyImage_Property | Gets records from the PropertyImage table for a given Property |
| 670 | usp_dm_GetPropertyImage_PropertyListing | Gets records from the PropertyImage table for a given Property listing (top 24, in order) |
| 671 | usp_dm_GetPropertyImageContent | Gets a record from the PropertyImageContent table |
| 672 | usp_dm_GetPropertyInfo | Gets basic property info for a given Property IDs; can be used for quick info lookups |
| 673 | usp_dm_GetPropertyInfoRequest | Returns the JSON data for the Streamline property listing info request for a given Property |
| 674 | usp_dm_GetPropertyInquiry_Counts_Location | Gets all records to the PropertyInquiry table for a given Property |
| 675 | usp_dm_GetPropertyInquiry_Current | Gets all records to the PropertyInquiry table submitted between "yesterday" and "now" |
| 676 | usp_dm_GetPropertyInquiry_Property | Gets all records to the PropertyInquiry table for a given Property |
| 677 | usp_dm_GetPropertyInquiryByPropertyID | Get all inquiries for a given Property |
| 678 | usp_dm_GetPropertyInquiryEmailData | Get the owner first name and email, alternate email, featured photo |
| 679 | usp_dm_GetPropertyInquiryMailingList | Returns a list of properties inquiries that need to be sent out to owners and guests |
| 680 | usp_dm_GetPropertyInquiryMailingList_TEST | Returns a list of properties inquiries that need to be sent out to owners and guests - this version is for testing only |
| 681 | usp_dm_GetPropertyList_Short | Gets a list of basic property info for a given Owner |
| 682 | usp_dm_GetPropertyListingEvent | Gets a record from the PropertyListingEvent table |
| 683 | usp_dm_GetPropertyListingEvent_Code | Gets all records from the PropertyListingEvent table for a given Listing Event Code |
| 684 | usp_dm_GetPropertyListingEvent_Owner | Gets all records from the PropertyListingEvent table for a given Owner |
| 685 | usp_dm_GetPropertyListingEvent_Property | Gets all records from the PropertyListingEvent table for a given Property |
| 686 | usp_dm_GetPropertyListingEventCount_Code_Date | Counts all records from the PropertyListingEvent table for a given Listing Event Code with a given Date Range |
| 687 | usp_dm_GetPropertyListingEventCount_Date | Counts all records from the PropertyListingEvent table for a given Date Range |
| 688 | usp_dm_GetPropertyListingInventory_Owner | Gets all records from the PropertyListingInventory table for a given Owner |
| 689 | usp_dm_GetPropertyListingInventory_Site | Gets all records from the PropertyListingInventory table for a given Site |
| 690 | usp_dm_GetPropertyListRequest | Returns the JSON data for the Streamline property list request for the given Owner |
| 691 | usp_dm_GetPropertyListRequest_VRM | Returns the JSON data for the Virtual Resort Manager property list request for the given Owner |
| 692 | usp_dm_GetPropertyLocationImport | Gets a record from the PropertyLocationImport table |
| 693 | usp_dm_GetPropertyMinNight_Property | Gets all records from the PropertyMinNight table for a given Property |
| 694 | usp_dm_GetPropertyNightlyRate | Gets a record from the PropertyNightlyRate table |
| 695 | usp_dm_GetPropertyOptionListByKey | Returns a list of properties that have the specified option key set or not |
| 696 | usp_dm_GetPropertyOptionValue | Gets all records from the PropertyOptionValue table for a given OptionField |
| 697 | usp_dm_GetPropertyPaymentNote_Active_Property | Gets an active record to the PropertyPaymentNote table for a given Property |
| 698 | usp_dm_GetPropertyPaymentNote_Property | Gets a record from the PropertyPaymentNote table for a given Property |
| 699 | usp_dm_GetPropertyQuote | Get a quote for a rental stay from the start date to the end date for a given Property (Test Version) |
| 700 | usp_dm_GetPropertyQuote_Dev | Get a quote for a rental stay from the start date to the end date for a given Property (Test Version) |
| 701 | usp_dm_GetPropertyQuote_New | Get a quote for a rental stay from the start date to the end date for a given Property (Test Version) |
| 702 | usp_dm_GetPropertyQuote_Property | Gets all records from the PropertyQuote table for a given Property |
| 703 | usp_dm_GetPropertyQuote_SVRS | Get a quote for a rental stay from the start date to the end date for a given Property for Streamline properties (no fees or taxes are reported, just a rate and a disclaimer |
| 704 | usp_dm_GetPropertyQuote_Test | Get a quote for a rental stay from the start date to the end date for a given Property (Test Version) |
| 705 | usp_dm_GetPropertyRankByPropertyID | Get all scores for a given Property |
| 706 | usp_dm_GetPropertyRate | Gets a record from the PropertyRate table |
| 707 | usp_dm_GetPropertyRate_Active_Current_Property | Gets active records that end in the future from the property_rates table for a given Property |
| 708 | usp_dm_GetPropertyRate_Active_Property | Gets active records from the property_rates table for a given Property |
| 709 | usp_dm_GetPropertyRate_Current_Property_v2 | Gets records from the PropertyRate table for a given Property that are current (EndDate >= CurrentDate) |
| 710 | usp_dm_GetPropertyRate_Property | Gets records from the PropertyRate table for a given Property |
| 711 | usp_dm_GetPropertyRateLoS_Date | Gets all records from the PropertyRateLoS table for a given StartDate |
| 712 | usp_dm_GetPropertyRateLoS_DateRange | Gets all records from the PropertyRateLoS table for a given range between StartDate and EndDate for a given Property |
| 713 | usp_dm_GetPropertyRateLoS_FEED_Count | Gets a count of from the PropertyRateLoS table for the selected FEED - indicates if they have records or not |
| 714 | usp_dm_GetPropertyRateLoS_OREZ_Count | Gets a count of from the PropertyRateLoS table for the OwnerRez feed - indicates if they have records or not |
| 715 | usp_dm_GetPropertyRateLoS_Owner | Gets all records from the PropertyRateLoS table for a given Owner |
| 716 | usp_dm_GetPropertyRateLoS_Owner_Count | Gets a count of from the PropertyRateLoS table for a given Owner - indicates if they have records or not |
| 717 | usp_dm_GetPropertyRateLoS_Property | Gets all records from the PropertyRateLoS table for a given Property |
| 718 | usp_dm_GetPropertyRateLoS_Property_Count | Gets a count of from the PropertyRateLoS table for a given Property - indicates if they have records or not |
| 719 | usp_dm_GetPropertyRateLoS_Raw_BPAL_DateRange | Gets all records from the PropertyRateLoS_Raw_BPAL table for a given range between StartDate and EndDate for a given Property |
| 720 | usp_dm_GetPropertyRateLoS_Raw_BPAL_Owner | Gets all records from the PropertyRateLoS_Raw_BPAL table for a given Owner |
| 721 | usp_dm_GetPropertyRateLoS_Raw_BPAL_Owner_Count | Gets a count of from the PropertyRateLoS_Raw_BPAL table for a given Owner - indicates if they have records or not |
| 722 | usp_dm_GetPropertyRateLoS_Raw_BPAL_Property | Gets all records from the PropertyRateLoS_Raw_BPAL table for a given Property |
| 723 | usp_dm_GetPropertyRateLoS_Raw_BPAL_Property_Count | Gets a count of from the PropertyRateLoS_Raw_BPAL table for a given Property - indicates if they have records or not |
| 724 | usp_dm_GetPropertyRateLoS_SVRS_Count | Gets a count of from the PropertyRateLoS table for the Streamline feed - indicates if they have records or not |
| 725 | usp_dm_GetPropertyRatesRequest | Returns the JSON data for the Streamline property rate request for a given Property |
| 726 | usp_dm_GetPropertyRenewalExpirationDate | Returns the date to be used as a reference in determining a new expiration date |
| 727 | usp_dm_GetPropertyReservation | Gets a record from the PropertyReservation table using the internal reservation ID |
| 728 | usp_dm_GetPropertyReservation_Code | Gets a record from the PropertyReservation table using the reservation code (with or without the attached PropertyID) |
| 729 | usp_dm_GetPropertyReservation_Property | Gets all record from the PropertyReservation table for the given Property |
| 730 | usp_dm_GetPropertyReservationDetail | Gets a record from the PropertyReservationDetail table |
| 731 | usp_dm_GetPropertyReservationDetail_Code | Gets a record from the PropertyReservationDetail table via the Reservation Code or External Reservation ID |
| 732 | usp_dm_GetPropertyReservationDetail_Owner | Gets all records from the PropertyReservationDetail table for a given Owner |
| 733 | usp_dm_GetPropertyReservationDetail_Property | Gets all records from the PropertyReservationDetail table for a given Property |
| 734 | usp_dm_GetPropertyReservationDetail_Site | Gets all records from the PropertyReservationDetail table for a given Site |
| 735 | usp_dm_GetPropertyReview | Get a record from the PropertyReview table |
| 736 | usp_dm_GetPropertyReview_Active_Property | Get active records from the PropertyReview table for a given Property |
| 737 | usp_dm_GetPropertyReview_Property | Get records from the PropertyReview table for a given Property |
| 738 | usp_dm_GetPropertySearchLog | Gets a record from the PropertySearchLog table |
| 739 | usp_dm_GetPropertySearchLog_JSON_Key | Gets the JSON data version from a record in the PropertySearchLog table based on the SearchKey |
| 740 | usp_dm_GetPropertySearchLog_Key | Gets a record from the PropertySearchLog table based on the SearchKey |
| 741 | usp_dm_GetPropertyStatistics | Returns the data set corresponding to items considered to be property statistics |
| 742 | usp_dm_GetPropertyTax | Gets a record from the PropertyTax table |
| 743 | usp_dm_GetPropertyTax_Property | Gets all records from the PropertyTax table for a given Property |
| 744 | usp_dm_GetPropertyTimes | Gets the checkin and checkout times from extra_fee for a given Property (NOTE: this data structure is inappropriate and only applies to the current state of ECBYO; this WILL be changed) |
| 745 | usp_dm_GetRecentBlogs | Returns the most recent blogs by date; intended to provide a list of blogs from which the user views more dtail |
| 746 | usp_dm_GetSearchLocationFromText | Get city and state locations from the specified search text; returns JSON |
| 747 | usp_dm_GetSearchOverrideLog | Gets a record from the SearchOverrideLog table |
| 748 | usp_dm_GetSearchOverrideLog_Owner | Gets all records from the SearchOverrideLog table for a given Owner |
| 749 | usp_dm_GetSearchOverrideLog_Property | Gets all records from the SearchOverrideLog table for a given Property |
| 750 | usp_dm_Getsite_content_URL | Gets a record from the exsitng site_content and site_content_page tables using the page URL |
| 751 | usp_dm_GetSiteImportFile | Gets a record from the SiteImportFile table |
| 752 | usp_dm_GetSiteImportFile_Site | Gets all records from the SiteImportFile table for a given Site |
| 753 | usp_dm_GetSitePageContent | Returns data from the site_content_page table for display on special pages where the content is not stored in the database |
| 754 | usp_dm_GetSMSCarrier | Gets a record from the SMSCarrier table |
| 755 | usp_dm_GetSMSCarrier_Active | Gets all record from the SMSCarrier table where they can be displayed to the user |
| 756 | usp_dm_GetStimulusPackageInquiries | Gets a list of all inquiries submitted for the Stimulus Package promotion of April 2020 |
| 757 | usp_dm_GetSubSite | Gets a record from the SubSite table |
| 758 | usp_dm_GetSubSite_Location | Gets a record from the SubSite table for a given Location |
| 759 | usp_dm_GetSubSiteContent_PageCode | Adds a record to the SubSiteContent table |
| 760 | usp_dm_GetSubSitePage | Gets a record from the SubSitePage table |
| 761 | usp_dm_GetSuspectInquiryEmail | Gets a record from the SuspectInquiryEmail table |
| 762 | usp_dm_GetSystemAmenityCategory_Owner | Gets all record from the amenities_category table for the sites used by an owner for external data imports (system = 0; other Site IDs as assigned) |
| 763 | usp_dm_GetSystemOptionByKey | Gets a flag from the SystemOption table |
| 764 | usp_dm_GetSystemOptionList | Gets a record from the SystemOptionList table or just the value of the option, depending on the ValueOnly bit, for a given OptionID |
| 765 | usp_dm_GetSystemOptionList_Key | Gets a record from the SystemOptionList table or just the value of the option, depending on the ValueOnly bit, for a given OptionKey |
| 766 | usp_dm_GetSystemReview | Gets a record from the SystemReview table |
| 767 | usp_dm_GetSystemReview_Active | Gets all record from the SystemReview table that are active for display |
| 768 | usp_dm_GetSystemReview_All | Gets all records from the SystemReview table; intended for use as a short preview list |
| 769 | usp_dm_GetTokenExpirationRequest | Returns the JSON data for the Streamline token expiration request for the given Owner |
| 770 | usp_dm_GetTokenRenewalRequest | Returns the JSON data for the Streamline token renewal request for the given Owner |
| 771 | usp_dm_GetVoucher | Get a record from the Voucher table |
| 772 | usp_dm_GetVouchers_Owner | Get records from the Voucher table for a given Owner |
| 773 | usp_dm_ImportPropertyActivities | Update the property_activites list with imported properties within a given City |
| 774 | usp_dm_ImportPropertyActivities_Owner | Update the property_activites list with imported properties within a given City |
| 775 | usp_dm_ImportPropertyAddress | Import data from an external listing for |
| 776 | usp_dm_ImportPropertyAddress_BPAL | Import property addresses from an external listing for BookingPal |
| 777 | usp_dm_ImportPropertyAddress_HOSTEEVA | Import data from an external listing for |
| 778 | usp_dm_ImportPropertyAddress_ITRIP | Import data from an external listing for |
| 779 | usp_dm_ImportPropertyAddress_KIGO | Import data from an external listing for |
| 780 | usp_dm_ImportPropertyAddress_NEXT | Import property addresses from an external listing for NextPax |
| 781 | usp_dm_ImportPropertyAddress_NEXT2 | Import data from an external listing for |
| 782 | usp_dm_ImportPropertyAddress_NRES | Import data from an external listing for |
| 783 | usp_dm_ImportPropertyAddress_OREZ | Import property addresses from an external listing for OwnerRez |
| 784 | usp_dm_ImportPropertyAddress_PMT | Import property addresses from an external listing for PropertyManagerTools |
| 785 | usp_dm_ImportPropertyAddress_RJ | Import data from an external listing for |
| 786 | usp_dm_ImportPropertyAddress_RNS | Import data from an external listing for |
| 787 | usp_dm_ImportPropertyAddress_SKYRUN | Import data from an external listing for |
| 788 | usp_dm_ImportPropertyAddress_STER | Import data from an external listing for |
| 789 | usp_dm_ImportPropertyAddress_SVRS | Import data from an external listing for |
| 790 | usp_dm_ImportPropertyAddress_TRACK | Import data from an external listing for |
| 791 | usp_dm_ImportPropertyAddress_VACASA | Import data from an external listing for |
| 792 | usp_dm_ImportPropertyAddress_VRM | Import data from an external listing for |
| 793 | usp_dm_ImportPropertyAddress_VRPRO | Import property address data from an external listing for Vacation RentPro |
| 794 | usp_dm_ImportPropertyAmenities_BPAL | Description of stored procedure functionality |
| 795 | usp_dm_ImportPropertyAmenities_HOSTEEVA | Import data from an external listing for |
| 796 | usp_dm_ImportPropertyAmenities_ITRIP | Import data from an external listing for |
| 797 | usp_dm_ImportPropertyAmenities_KIGO | Import data from an external listing for |
| 798 | usp_dm_ImportPropertyAmenities_NEXT | Import data from an external listing for |
| 799 | usp_dm_ImportPropertyAmenities_NEXT_TEMP | Import data from an external listing for |
| 800 | usp_dm_ImportPropertyAmenities_NEXT2 | Import data from an external listing for |
| 801 | usp_dm_ImportPropertyAmenities_NEXT2_TEMP | Import data from an external listing for |
| 802 | usp_dm_ImportPropertyAmenities_NRES | Import data from an external listing for |
| 803 | usp_dm_ImportPropertyAmenities_OREZ | Import property amenities from an external listing for OwnerRez |
| 804 | usp_dm_ImportPropertyAmenities_PMT | Import amenity data from an external listing for PropertyManagerTools |
| 805 | usp_dm_ImportPropertyAmenities_PTM | Import data from an external listing for |
| 806 | usp_dm_ImportPropertyAmenities_RJ | Import data from an external listing for |
| 807 | usp_dm_ImportPropertyAmenities_RNS | Import data from an external listing for |
| 808 | usp_dm_ImportPropertyAmenities_SKYRUN | Import data from an external listing for |
| 809 | usp_dm_ImportPropertyAmenities_STER | Import amenities data from an external listing for Sterling (STER) |
| 810 | usp_dm_ImportPropertyAmenities_SVRS | Import data from an external listing for |
| 811 | usp_dm_ImportPropertyAmenities_TRACK | Import data from an external listing for Track HS |
| 812 | usp_dm_ImportPropertyAmenities_VACASA | Import data from an external listing for |
| 813 | usp_dm_ImportPropertyAmenities_VRM | Import data from an external listing for |
| 814 | usp_dm_ImportPropertyAmenities_VRPRO | Import data from an external listing for |
| 815 | usp_dm_ImportPropertyCalendar | Update PropertyBookingCalendar from an external listing |
| 816 | usp_dm_ImportPropertyData_BPAL | Runs all desginated property update procedures for the BookingPal feed |
| 817 | usp_dm_ImportPropertyData_HOSTEEVA | Run all import procedures for HOSTEEVA |
| 818 | usp_dm_ImportPropertyData_ITRIP | Run all import procedures for iTrip |
| 819 | usp_dm_ImportPropertyData_KIGO | Run all import procedures for RealJoy |
| 820 | usp_dm_ImportPropertyData_NEXT | Run all import procedures for NEXT for the selected Property or Owner |
| 821 | usp_dm_ImportPropertyData_NEXT2 | Run all import procedures for NEXT |
| 822 | usp_dm_ImportPropertyData_NRES | Run all import procedures for Natural Retreats |
| 823 | usp_dm_ImportPropertyData_OREZ | Run all import procedures for OwnerRez for the selected Property or Owner |
| 824 | usp_dm_ImportPropertyData_PMT | Run all import procedures for PMT |
| 825 | usp_dm_ImportPropertyData_RJ | Run all import procedures for RealJoy |
| 826 | usp_dm_ImportPropertyData_RNS | Run all import procedures for RNS |
| 827 | usp_dm_ImportPropertyData_SKYRUN | Run all import procedures for SKYRUN |
| 828 | usp_dm_ImportPropertyData_SPALM | Run all import procedures for SPALM |
| 829 | usp_dm_ImportPropertyData_STER | Run all import procedures for Sterling |
| 830 | usp_dm_ImportPropertyData_SVRS | Run all import procedures for Streamline for the selected Property or Owner |
| 831 | usp_dm_ImportPropertyData_TRACK | Run all import procedures for Track HS |
| 832 | usp_dm_ImportPropertyData_VACASA | Run all import procedures for VACASA |
| 833 | usp_dm_ImportPropertyData_VRM | Run all import procedures for VRM |
| 834 | usp_dm_ImportPropertyData_VRPRO | Run all import procedures for VRPRO |
| 835 | usp_dm_ImportPropertyDateAvailability | Import availability dates from LoS rate data in PropertyRateLoS_Raw_BPAL and per_night calendar data in PropertyDateLoS (currently this only works for BPAL) |
| 836 | usp_dm_ImportPropertyDateAvailability_BPAL | Import availability dates from LoS rate data in PropertyRateLoS from the BookingPal feed |
| 837 | usp_dm_ImportPropertyDateAvailability_HOSTEEVA | Import availability dates from LoS rate data in PropertyRateLoS from the Hosteeva feed |
| 838 | usp_dm_ImportPropertyDateAvailability_LoS_BPAL | Import availability dates from LoS rate data in PropertyRateLoS_Raw_BPAL (currently this only works for BPAL) |
| 839 | usp_dm_ImportPropertyDateAvailability_NEXT | Import availability dates from LoS rate data in PropertyRateLoS from the NextPax feed |
| 840 | usp_dm_ImportPropertyDateAvailability_NRES | Import availability dates from LoS rate data in PropertyRateLoS from the Natural Retreats feed |
| 841 | usp_dm_ImportPropertyDateAvailability_OREZ | Import availability dates from LoS rate data in PropertyRateLoS from the OREZ feed |
| 842 | usp_dm_ImportPropertyDateAvailability_PerNight_BPAL | Import availability dates from per_night calendar data in PropertyDateLoS (currently this only works for BPAL) |
| 843 | usp_dm_ImportPropertyDateAvailability_SVRS | Import availability dates from LoS rate data in PropertyRateLoS from the Stremline feed |
| 844 | usp_dm_ImportPropertyDateAvailability_TRACK | Import availability dates from LoS rate data in PropertyRateLoS from the TRACK feed |
| 845 | usp_dm_ImportPropertyDateAvailability_VRM | Import availability dates from LoS rate data in PropertyRateLoS from the Virtual Resort Manager feed |
| 846 | usp_dm_ImportPropertyDateAvailability_VRPRO | Import availability dates from LoS rate data in PropertyRateLoS from the Vacation Rentals Pro feed |
| 847 | usp_dm_ImportPropertyDates_BPAL | Description of stored procedure functionality |
| 848 | usp_dm_ImportPropertyDates_BPAL_Save | Captures daily availability into ImportDate for the BookingPal feed - used to populate PropertyDateAvailability |
| 849 | usp_dm_ImportPropertyDates_HOSTEEVA | Import data from an external listing for |
| 850 | usp_dm_ImportPropertyDates_ITRIP | Import data from an external listing for |
| 851 | usp_dm_ImportPropertyDates_KIGO | Import data from an external listing for |
| 852 | usp_dm_ImportPropertyDates_NEXT | Import data from an external listing for property booking |
| 853 | usp_dm_ImportPropertyDates_NEXT2 | Import data from an external listing for property booking |
| 854 | usp_dm_ImportPropertyDates_NRES | Import data from an external listing for Natural Retreats using raw data |
| 855 | usp_dm_ImportPropertyDates_OREZ | Import property bookings from an external listing for OwnerRez |
| 856 | usp_dm_ImportPropertyDates_PMT | Import availability data from an external listing for PropertyManagerTools |
| 857 | usp_dm_ImportPropertyDates_PTM | Import data from an external listing for |
| 858 | usp_dm_ImportPropertyDates_RJ | Import data from an external listing for |
| 859 | usp_dm_ImportPropertyDates_RNS | Import data from an external listing for |
| 860 | usp_dm_ImportPropertyDates_SKYRUN | Import data from an external listing for |
| 861 | usp_dm_ImportPropertyDates_SPALM | Import data from an external listing for |
| 862 | usp_dm_ImportPropertyDates_STER | Import calendar data from an external listing for Sterling (STER) |
| 863 | usp_dm_ImportPropertyDates_SVRS | Import data from an external listing for |
| 864 | usp_dm_ImportPropertyDates_TRACK | Import data from an external listing for |
| 865 | usp_dm_ImportPropertyDates_VACASA | Import data from an external listing for |
| 866 | usp_dm_ImportPropertyDates_VRM | Import data from an external listing for |
| 867 | usp_dm_ImportPropertyDates_VRPRO | Import availability data from an external listing for Vacation Rent Pro |
| 868 | usp_dm_ImportPropertyDetails_BPAL | Import data from an external listing for BookingPal |
| 869 | usp_dm_ImportPropertyDetails_HOSTEEVA | Import data from an external listing for |
| 870 | usp_dm_ImportPropertyDetails_ITRIP | Import data from an external listing for |
| 871 | usp_dm_ImportPropertyDetails_KIGO | Import data from an external listing for |
| 872 | usp_dm_ImportPropertyDetails_Names_NEXT | Update the property names for the specified Owner, regradless of feed source |
| 873 | usp_dm_ImportPropertyDetails_NEXT | Import base property data from an external listing for NextPax |
| 874 | usp_dm_ImportPropertyDetails_NEXT_86 | Import base property data from an external listing for NextPax for My Vacation Haven |
| 875 | usp_dm_ImportPropertyDetails_NEXT2 | Import data from an external listing for |
| 876 | usp_dm_ImportPropertyDetails_NRES | Import data from an external listing for |
| 877 | usp_dm_ImportPropertyDetails_OREZ | Import property detail data from an external listing for OwnerRez |
| 878 | usp_dm_ImportPropertyDetails_OREZ_4673_11137 | Import property detail update for OwnerRez Owner 4673, Property 11137 |
| 879 | usp_dm_ImportPropertyDetails_PMT | Import data from an external listing for PropertyManagerTools |
| 880 | usp_dm_ImportPropertyDetails_PTM | Import data from an external listing for |
| 881 | usp_dm_ImportPropertyDetails_RJ | Import data from an external listing for |
| 882 | usp_dm_ImportPropertyDetails_RNS | Import data from an external listing for |
| 883 | usp_dm_ImportPropertyDetails_SKYRUN | Import data from an external listing for |
| 884 | usp_dm_ImportPropertyDetails_STER | Import data from an external listing for |
| 885 | usp_dm_ImportPropertyDetails_SVRS | Import data from an external listing for |
| 886 | usp_dm_ImportPropertyDetails_SVRS_2740 | Update property descriptions for Destin Dreamers on Streamline; assumes this runs AFTER the main import routine |
| 887 | usp_dm_ImportPropertyDetails_TRACK | Import data from an external listing for Track HS |
| 888 | usp_dm_ImportPropertyDetails_TRACK_1065 | Import custom property details (property description, property website links) from an external listing for 30A Escapes on the Track HS feed source; assumes this runs AFTER the main import routine |
| 889 | usp_dm_ImportPropertyDetails_TRACK_401 | Update property descriptions for Southern Rentals on Track HS |
| 890 | usp_dm_ImportPropertyDetails_TRACK_419 | Update property descriptions for Pristine Properties on Track HS |
| 891 | usp_dm_ImportPropertyDetails_TRACK_4806 | Update property website links for Overmoon on Track HS; assumes this runs AFTER the main import routine |
| 892 | usp_dm_ImportPropertyDetails_TRACK_5742 | Import custom property details from an external listing for SkyRun on the TTRACK feed source |
| 893 | usp_dm_ImportPropertyDetails_VACASA | Import data from an external listing for |
| 894 | usp_dm_ImportPropertyDetails_VRM | Import data from an external listing for |
| 895 | usp_dm_ImportPropertyDetails_VRPRO | Import basic listing data from an external listing for Vacation RentPro |
| 896 | usp_dm_ImportPropertyEmail_OREZ | Update property inquiry emails from an external listing for OwnerRez (this is a requirement from OwnerRez for integration) |
| 897 | usp_dm_ImportPropertyFees_FeeTax_HOSTEEVA | Import fee and tax data from an external listing for Hosteeva (into new PropertyFee/PropertyTax tables) - NOTE: Owner update flag is currently being ignored |
| 898 | usp_dm_ImportPropertyFees_FeeTax_NEXT | Import fee and tax data from an external listing for NextPax (into new PropertyFee/PropertyTax tables) - NOTE: Owner update flag is currently being ignored |
| 899 | usp_dm_ImportPropertyFees_FeeTax_NEXT_2340 | Custom fee data manipulation for O:2340 - Greta's Beach Rentals - Remove extra "Reservation Fee" records based on starting dates without regard to end dates |
| 900 | usp_dm_ImportPropertyFees_FeeTax_NEXT_2719 | Custom fee data manipulation for O:2719 - Brooks and Shorey Resorts - Inactivate a fee that is labeled "Service Package" |
| 901 | usp_dm_ImportPropertyFees_FeeTax_OREZ | Import fee and tax data from an external listing for OwnerRez (into new PropertyFee/PropertyTax tables) - NOTE: Owner update flag is currently being ignored |
| 902 | usp_dm_ImportPropertyFees_FeeTax_PMT | Import fee and tax data from an external listing for PropertyManagerTools (into new PropertyFee/PropertyTax tables) - NOTE: Owner update flag is currently being ignored |
| 903 | usp_dm_ImportPropertyFees_FeeTax_TRACK | Import fee and tax data from an external listing for Track (into new PropertyFee/PropertyTax tables) - NOTE: Owner update flag is currently being ignored |
| 904 | usp_dm_ImportPropertyFees_FeeTax_TRACK_2118 | Custom fee/tax processing for O:2118 - Beachscapes Vacation Rentals: 1) Remove taxes from Wal |
| 905 | usp_dm_ImportPropertyFees_FeeTax_VRM | Import fee and tax data from an external listing for Virtual Resort Manager (into new PropertyFee/PropertyTax tables) - NOTE: Owner update flag is currently being ignored |
| 906 | usp_dm_ImportPropertyFees_FeeTax_VRPRO | Import fee and tax data from an external listing for Vacation RentPro (into new PropertyFee/PropertyTax tables) - NOTE: Owner update flag is currently being ignored |
| 907 | usp_dm_ImportPropertyFees_HOSTEEVA | Import fee and tax data from an external listing for the Hosteeva feed |
| 908 | usp_dm_ImportPropertyFees_ITRIP | Import data from an external listing for |
| 909 | usp_dm_ImportPropertyFees_KIGO | Import data from an external listing for |
| 910 | usp_dm_ImportPropertyFees_MandFee | Migrate fee and tax data from PropertyFee and PropertyTax into the existing structure from property_booking_system_mandatory_fee |
| 911 | usp_dm_ImportPropertyFees_NEXT | Import fee and tax data from an external listing for the NextPax feed |
| 912 | usp_dm_ImportPropertyFees_NEXT_TEMP | Import data from an external listing for |
| 913 | usp_dm_ImportPropertyFees_NEXT2_TEMP | Import data from an external listing for |
| 914 | usp_dm_ImportPropertyFees_NRES | Import data from an external listing for |
| 915 | usp_dm_ImportPropertyFees_OREZ | Import fee and tax data from an external listing for the OwnerRez feed |
| 916 | usp_dm_ImportPropertyFees_PMT | Import fee and tax data from an external listing for the PropertyManagerTools feed |
| 917 | usp_dm_ImportPropertyFees_RJ | Import data from an external listing for |
| 918 | usp_dm_ImportPropertyFees_RNS | Import data from an external listing for |
| 919 | usp_dm_ImportPropertyFees_SKYRUN | Import data from an external listing for |
| 920 | usp_dm_ImportPropertyFees_SPALM | Import data from an external listing for |
| 921 | usp_dm_ImportPropertyFees_STER | Import fee data from an external listing for Sterling (STER) |
| 922 | usp_dm_ImportPropertyFees_SVRS | Import data from an external listing for |
| 923 | usp_dm_ImportPropertyFees_TRACK | Import fee and tax data from an external listing for the TRACK feed |
| 924 | usp_dm_ImportPropertyFees_TRACK_4745 | Import fee data from an external listing for O:4745 (Oversee) |
| 925 | usp_dm_ImportPropertyFees_v2_BPAL | Imported fee and tax data for the BookingPal data feed |
| 926 | usp_dm_ImportPropertyFees_v2_SVRS | Import fee and tax data from an external listing for Streamline (into new PropertyFee/PropertyTax tables) |
| 927 | usp_dm_ImportPropertyFees_v2_TRACK | Import fee and tax data from an external listing for Track (into new PropertyFee/PropertyTax tables) - NOTE: Owner update flag is currently being ignored |
| 928 | usp_dm_ImportPropertyFees_VACASA | Import data from an external listing for |
| 929 | usp_dm_ImportPropertyFees_VRM | Import fee and tax data from an external listing for the Virtual Resort Manager feed |
| 930 | usp_dm_ImportPropertyFees_VRPRO | Import fee and tax data from an external listing for the VRPRO feed |
| 931 | usp_dm_ImportPropertyImages | Import image data from an external listing for any data feed |
| 932 | usp_dm_ImportPropertyImages_BPAL_Property | Description of stored procedure functionality |
| 933 | usp_dm_ImportPropertyImages_BPAL_Save | Import image data from an external listing for BookingPal for a given Property |
| 934 | usp_dm_ImportPropertyImages_HOSTEEVA_Property | Import image data from an external listing for HOSTEEVA Vacations for a given Property |
| 935 | usp_dm_ImportPropertyImages_HOSTEEVA_Save | Import image data from an external listing for HOSTEEVA Vacations for a given Property |
| 936 | usp_dm_ImportPropertyImages_ITRIP | Import data from an external listing for |
| 937 | usp_dm_ImportPropertyImages_ITRIP_Property | Import image data from an external listing for iTrip Vacations for a given Property |
| 938 | usp_dm_ImportPropertyImages_ITRIP_Save | Import image data from an external listing for iTrip Vacations for a given Property |
| 939 | usp_dm_ImportPropertyImages_KIGO_Property | Import data from an external listing for |
| 940 | usp_dm_ImportPropertyImages_KIGO_Save | Import image data from an external listing for Kigo for a given Property |
| 941 | usp_dm_ImportPropertyImages_NEXT_Property | Import data from an external listing for NextPax |
| 942 | usp_dm_ImportPropertyImages_NEXT_Save | Import image data from an external listing for NextPax for a given Property |
| 943 | usp_dm_ImportPropertyImages_NEXT2_Property | Import data from an external listing for |
| 944 | usp_dm_ImportPropertyImages_NEXT2_Save | Import data from an external listing for |
| 945 | usp_dm_ImportPropertyImages_NRES_Property | Import data from an external listing for |
| 946 | usp_dm_ImportPropertyImages_NRES_Save | Import data from an external listing for |
| 947 | usp_dm_ImportPropertyImages_OREZ_Property | Import image data from an external listing for OwnerRez Vacations for a given Property |
| 948 | usp_dm_ImportPropertyImages_OREZ_Save | Import image data from an external listing for OwnerRez Vacations for a given Property |
| 949 | usp_dm_ImportPropertyImages_PMT_Property | Import image data from an external listing for PropertyManagerTools |
| 950 | usp_dm_ImportPropertyImages_PMT_Save | Import image data from an external listing for PropertyManagerTools |
| 951 | usp_dm_ImportPropertyImages_PTM | Import data from an external listing for |
| 952 | usp_dm_ImportPropertyImages_RJ_Property | Import data from an external listing for |
| 953 | usp_dm_ImportPropertyImages_RNS_Property | Import image data from an external listing for RNS for a given Property |
| 954 | usp_dm_ImportPropertyImages_SKYRUN_Property | Import image data from an external listing for SKYRUN Vacations for a given Property |
| 955 | usp_dm_ImportPropertyImages_SKYRUN_Save | Import image data from an external listing for SKYRUN Vacations for a given Property |
| 956 | usp_dm_ImportPropertyImages_SPALM_Property | Import data from an external listing for |
| 957 | usp_dm_ImportPropertyImages_STER | Import data from an external listing for |
| 958 | usp_dm_ImportPropertyImages_STER_Property | Import data from an external listing for |
| 959 | usp_dm_ImportPropertyImages_SVRS | Import data from an external listing for |
| 960 | usp_dm_ImportPropertyImages_SVRS_Property | Import data from an external listing for |
| 961 | usp_dm_ImportPropertyImages_SVRS_Save | Import image data from an external listing for Streamline for a given Property |
| 962 | usp_dm_ImportPropertyImages_TRACK_Property | Import image data from an external listing for Track |
| 963 | usp_dm_ImportPropertyImages_TRACK_Save | Import image data from an external listing for Track HS for a given Property |
| 964 | usp_dm_ImportPropertyImages_VACASA_Property | Import image data from an external listing for VACASA Vacations for a given Property |
| 965 | usp_dm_ImportPropertyImages_VRM_Property | Import image data from an external listing for VRM for a given Property |
| 966 | usp_dm_ImportPropertyImages_VRM_Save | Import image data from an external listing for |
| 967 | usp_dm_ImportPropertyImages_VRPRO_Property | Import data from an external listing for |
| 968 | usp_dm_ImportPropertyImages_VRPRO_Save | Import data from an external listing for |
| 969 | usp_dm_ImportPropertyList_NEXT | Imports a a list of listing IDs and OwnerCodes from the NextPax feed; the table used is NEXT_PropertyList |
| 970 | usp_dm_ImportPropertyLocations | Update property location data (state, city and community IDs) from the information captured in PropertyExternalListing for the given Properties |
| 971 | usp_dm_ImportPropertyLocations_BPAL | Description of stored procedure functionality |
| 972 | usp_dm_ImportPropertyLocations_HOSTEEVA | Import data from an external listing for |
| 973 | usp_dm_ImportPropertyLocations_ITRIP | Import data from an external listing for |
| 974 | usp_dm_ImportPropertyLocations_KIGO | Import data from an external listing for |
| 975 | usp_dm_ImportPropertyLocations_NEXT | Import location data from an external listing for NextPax |
| 976 | usp_dm_ImportPropertyLocations_NEXT2 | Import location data from an external listing for NextPax |
| 977 | usp_dm_ImportPropertyLocations_NRES | Import data from an external listing for |
| 978 | usp_dm_ImportPropertyLocations_OREZ | Import property locations (state, city, community) from an external listing for OwnerRez |
| 979 | usp_dm_ImportPropertyLocations_PMT | Import data from an external listing for PropertyManagerTools |
| 980 | usp_dm_ImportPropertyLocations_PTM | Import data from an external listing for |
| 981 | usp_dm_ImportPropertyLocations_RJ | Import data from an external listing for |
| 982 | usp_dm_ImportPropertyLocations_RNS | Import data from an external listing for |
| 983 | usp_dm_ImportPropertyLocations_SKYRUN | Import data from an external listing for |
| 984 | usp_dm_ImportPropertyLocations_SPALM | Import data from an external listing for |
| 985 | usp_dm_ImportPropertyLocations_STER | Import data from an external listing for |
| 986 | usp_dm_ImportPropertyLocations_SVRS | Import data from an external listing for |
| 987 | usp_dm_ImportPropertyLocations_TRACK | Import location data from an external listing for Track HS |
| 988 | usp_dm_ImportPropertyLocations_TRACK_Find | Import location data from an external listing for NextPax |
| 989 | usp_dm_ImportPropertyLocations_VACASA | Import data from an external listing for |
| 990 | usp_dm_ImportPropertyLocations_VRM | Import data from an external listing for |
| 991 | usp_dm_ImportPropertyLocations_VRPRO | Import location data from an external listing for Vacation Rent Pro |
| 992 | usp_dm_ImportPropertyRates_BPAL | Description of stored procedure functionality |
| 993 | usp_dm_ImportPropertyRates_BPAL_Save | Description of stored procedure functionality |
| 994 | usp_dm_ImportPropertyRates_HOSTEEVA | Import data from an external listing for |
| 995 | usp_dm_ImportPropertyRates_HOSTEEVA_Save | Import rate data from an external listing for the Hosteeva feed for a given Property, regardless of listing update status |
| 996 | usp_dm_ImportPropertyRates_ITRIP | Import data from an external listing for |
| 997 | usp_dm_ImportPropertyRates_KIGO | Import data from an external listing for |
| 998 | usp_dm_ImportPropertyRates_LoS_BPAL | This procedure imports raw rate data in the LoS format for the BookingPal data feed |
| 999 | usp_dm_ImportPropertyRates_LoS_NEXT | Import data from the availability file to be used for booking quotes from the external listing for NextPax (LoS Rate transformations and import) |
| 1000 | usp_dm_ImportPropertyRates_LoS_OREZ | LoS Rate transformation for the OwnerRez data feed Import rate data from the ImportRate table to the PropertyRateLoS table for the OwnerRez feed (these rates are in the Standard format and are being transformed) |
| 1001 | usp_dm_ImportPropertyRates_LoS_PMT | Import native LoS rate data for an external listing for the PropertyManagerTools feed |
| 1002 | usp_dm_ImportPropertyRates_LoS_PMT__Test | Import native LoS rate data for an external listing for the PropertyManagerTools feed |
| 1003 | usp_dm_ImportPropertyRates_LoS_SVRS | Import rate data from the vw_ImportPropertyRate_LoS_SVRS view (pulling from PEIR) for an external listing for the Streamline feed using the native LoS formats they now provide |
| 1004 | usp_dm_ImportPropertyRates_LoS_SVRS__Test | Import rate data from the ImportRate table for an external listing for the Streamline feed (these rates are in the Standard format and are being transformed) |
| 1005 | usp_dm_ImportPropertyRates_LoS_TRACK | Import rate data from the ImportRate table for an external listing for the Track HS feed (these rates are in the Standard format and are being transformed) |
| 1006 | usp_dm_ImportPropertyRates_New_SPALM | Import rate data (New Format) from an external listing for Sugar Palm (SPALM) |
| 1007 | usp_dm_ImportPropertyRates_NEXT | Import data from an external listing for |
| 1008 | usp_dm_ImportPropertyRates_NEXT_Extra | Custom rate data processing for extrenal listings on the NextPax feed (yes, this is a total hack) |
| 1009 | usp_dm_ImportPropertyRates_NEXT_Save | LoS Rate transformation for the NextPax data feed |
| 1010 | usp_dm_ImportPropertyRates_NEXT_TEMP | Import data from an external listing for |
| 1011 | usp_dm_ImportPropertyRates_NEXT2_TEMP | Import data from an external listing for |
| 1012 | usp_dm_ImportPropertyRates_NRES | Import data from an external listing for |
| 1013 | usp_dm_ImportPropertyRates_Old_SPALM | Import rate data (Old Format) from an external listing for Sugar Palm (SPALM) |
| 1014 | usp_dm_ImportPropertyRates_OREZ | Import property rates from an external listing for OwnerRez |
| 1015 | usp_dm_ImportPropertyRates_OREZ_2776 | Import property rates from an external listing for OwnerRez Owner 2776, Property 11173 |
| 1016 | usp_dm_ImportPropertyRates_OREZ_Save | Import rate data from an external listing for the OwnerRez feed for a given Property, regardless of listing update status |
| 1017 | usp_dm_ImportPropertyRates_PMT | Update property listing rates from an external listing for PropertyManagerTools (using ImportRate) |
| 1018 | usp_dm_ImportPropertyRates_PMT_Save | Import rate data from an external listing for PropertyManagerTools |
| 1019 | usp_dm_ImportPropertyRates_RJ | Import data from an external listing for |
| 1020 | usp_dm_ImportPropertyRates_RNS | Import data from an external listing for |
| 1021 | usp_dm_ImportPropertyRates_SKYRUN | Import data from an external listing for |
| 1022 | usp_dm_ImportPropertyRates_SPALM | Import rate data from an external listing for Sugar Palm (SPALM) |
| 1023 | usp_dm_ImportPropertyRates_STER | Import rate data from an external listing for Sterling (STER) |
| 1024 | usp_dm_ImportPropertyRates_SVRS | Import data from an external listing for |
| 1025 | usp_dm_ImportPropertyRates_SVRS_Save | Import rate data from an external listing for Streamline for a given Property, regardless of listing update status |
| 1026 | usp_dm_ImportPropertyRates_TRACK | Import raw rate data from an external listing for the Track HS feed |
| 1027 | usp_dm_ImportPropertyRates_TRACK_Save | Import rate data from an external listing for Track HS for a given Property, regardless of listing update status |
| 1028 | usp_dm_ImportPropertyRates_v2_OREZ | Import property rates from an external listing for OwnerRez (this version uses the nightly rates and the overrides) |
| 1029 | usp_dm_ImportPropertyRates_v2_OREZ_478 | Import property rates from an external listing for OwnerRez on the O:478 account (White Sand Rental) to limit the rates imported to a single year |
| 1030 | usp_dm_ImportPropertyRates_v2_SVRS | Import data from an external listing for |
| 1031 | usp_dm_ImportPropertyRates_v3_SVRS | Import raw rate data from an external listing for the Streamline feed (data pulled from the GetPropertyratesRawData method) |
| 1032 | usp_dm_ImportPropertyRates_VACASA | Import data from an external listing for |
| 1033 | usp_dm_ImportPropertyRates_VRM | Import data from an external listing for |
| 1034 | usp_dm_ImportPropertyRates_VRM_Save | Import rate data from an external listing for Virtual Resort Manager |
| 1035 | usp_dm_ImportPropertyRates_VRPRO | Import rate data from an external listing for Vacation Rent Pro |
| 1036 | usp_dm_ImportPropertyRates_VRPRO_Save | Import rate data from an external listing for Vacation Rent Pro |
| 1037 | usp_dm_ImportPropertyReviews_KIGO | Import review data from an external listing for Kigo |
| 1038 | usp_dm_ImportPropertyReviews_NRES | Import review data for Natural Retreats |
| 1039 | usp_dm_ImportPropertyTaxes_NEXT | Import tax data from an external listing for NextPax |
| 1040 | usp_dm_IncrementPageViewCount | |
| 1041 | usp_dm_InitializePropertyAmenityFilter | Initial population of the PropertyAmenityFilter table with PropertyIDs from the Property table |
| 1042 | usp_dm_InitializePropertyExternalImport_BPAL | Description of stored procedure functionality |
| 1043 | usp_dm_InitializePropertyImageList | Creates a record in the PropertyImageList table for all Properties |
| 1044 | usp_dm_InitializePropertyUpdateQueue | Replace existing records in the property_activities table |
| 1045 | usp_dm_InsertExtra_Fee_IVOL | Inserts a record in the existing extra_fee table that specifically comes from a property association with ivacationonline.com |
| 1046 | usp_dm_InsertPropertyICalImport | Inserts a record in the PropertyICalImport table certain default values supplied |
| 1047 | usp_dm_InsertPropertyICalImport_IVOL | Inserts a record in the PropertyICalImport table that specifically comes from a property association with ivacationonline.com; check the defintion for vw_PropertyICalImportFlags to obtain or verify the correct bit to use for updates |
| 1048 | usp_dm_InsertPropertyICalImport_SVRS | Inserts a record in the PropertyICalImport table that specifically comes from a data feed for Streamline; check the defintion for vw_PropertyICalImportFlags to obtain or verify the correct bit to use for updates |
| 1049 | usp_dm_IsTLDValid | Validate a top-level domain for use in the system |
| 1050 | usp_dm_json_GetPropertyListing_Amenities | Returns a list of amenities and categories from property_amenities for a given Property; Note: the prop_id is not returned in the dataset |
| 1051 | usp_dm_json_GetPropertyListing_Images | Returns a list of the top 24 images from property_gallery for a given Property; Note: the prop_id is not returned in the dataset |
| 1052 | usp_dm_LoadSystemAmenity_RJ | Initializes records in the SystemAmenity table for categories belonging to RealJoy |
| 1053 | usp_dm_LockPropertyExternalImport_AvailProcess_Owner | Toogles the processing status of records in the PropertyExternalImport_Avail table for a given Owner |
| 1054 | usp_dm_LockPropertyExternalImport_AvailProcess_Property | Toogles the processing status of records in the PropertyExternalImport_Avail table for a given Property |
| 1055 | usp_dm_LockPropertyExternalImport_AvailProcess_Site | Toogles the processing status of records in the PropertyExternalImport_Avail table for a given Site |
| 1056 | usp_dm_LockPropertyExternalImport_RateProcess_Owner | Toogles the processing status of records in the PropertyExternalImport_Rate table for a given Owner |
| 1057 | usp_dm_LockPropertyExternalImport_RateProcess_Property | Toogles the processing status of records in the PropertyExternalImport_Rate table for a given Property |
| 1058 | usp_dm_LockPropertyExternalImport_RateProcess_Site | Toogles the processing status of records in the PropertyExternalImport_Rate table for a given Property on a given Site |
| 1059 | usp_dm_LockPropertyExternalImportProcess_Owner | Toogles the processing status of records in the PropertyExternalImport table for a given Owner; done when the property listing is updated from its external source |
| 1060 | usp_dm_LockPropertyExternalImportProcess_Property | Toogles the processing status of records in the PropertyExternalImport table for a given Property; done when the property listing is updated from its external source |
| 1061 | usp_dm_LockPropertyExternalImportProcess_Site | Toogles the processing status of records in the PropertyExternalImport table for a given Site; done when the property listing is updated from its external source |
| 1062 | usp_dm_LoginOwner_Email | Process the owner logins to the website based on the supplied email and password |
| 1063 | usp_dm_MakeICalFileName | Returns a newly file name for an iCal export - either the one in extra_fee or create one and update extra_fee with it |
| 1064 | usp_dm_MakePassword | Create a password or long random string of characters |
| 1065 | usp_dm_NextPaxLoad_ByName | List of owners and property counts from the latest NextPax import load |
| 1066 | usp_dm_PopulatCalImportLog | Sets the first Date Imported list in the log for all Files in the extra_fee table |
| 1067 | usp_dm_PopulateOwnerContact_Primary_ECBYO | Populate the Primary Contact for the Owner from the existing info in user_login table for all users: intended for limited use and should be run before other procedures that populate OwnerContact |
| 1068 | usp_dm_PopulatePropertyBooking | Initial population of the PropertyBooking table |
| 1069 | usp_dm_PopulatePropertyBooking_Property | Repopulate the PropertyBooking table when a change to the property_booking table is made for a given Property |
| 1070 | usp_dm_PopulatePropertyBookingCalendar_Property | Populates the PropertyBookingCalendar table based on resolving duplicates and overlaps in the PropertyBooking and PropertyBookingImport tables for a given Property |
| 1071 | usp_dm_PopulatePropertyBookingCalendar_Property_New | Populates the PropertyBookingCalendar table based on resolving duplicates and overlaps in the PropertyBooking and PropertyBookingImport tables for a given Property |
| 1072 | usp_dm_PopulatePropertyCalendar | Initial load of the PropertyCalendar table from the exisiting property_booking table |
| 1073 | usp_dm_PopulatePropertyExternalImport | Adds a record to the PropertyExternalImport table from the flagged records in PropertyexternalListing |
| 1074 | usp_dm_PopulatePropertyExternalImport_Avail | Adds a record to the PropertyExternalImport_Avail table from the flagged records in PropertyExternalListing |
| 1075 | usp_dm_PopulatePropertyExternalImport_Rate | Adds a record to the PropertyExternalImport_Rate table from the flagged records in PropertyexternalListing (currently only used for Streamline) |
| 1076 | usp_dm_PopulatePropertyImage | Initial population of the PropertyImage and PropertyImageURL tables from the property_gallery table |
| 1077 | usp_dm_PopulatePropertyMigrationList_BPAL | Adds records to the PropertyMigrationList_BPAL table from the PropertyExternalUpdate table based on the HasBeenApplied flag ( = 0 ) - does truncate the table first since it in inteded to be a working copy of properties |
| 1078 | usp_dm_PopulatePropertyNightlyRate | Adds records to the PropertyNightlyRate table from the rate calculation process |
| 1079 | usp_dm_PreparePropertyFees_FeeTax | Procedure to prepare records to be used by the usp_dm_TransferPropertyFees_FeeTax routine |
| 1080 | usp_dm_ProcessImportListingCalendar_BPAL | Copies application external listing calendar data from the PropertyExternalUpdate to the PropertyExternalImport in the node corresponding for the selected content (the i mport routine used needs to really be moved here |
| 1081 | usp_dm_ProcessImportListingContent_BPAL | Copies application external listing content from the PropertyExternalUpdate to the PropertyExternalImport in the node corresponding for the selected content |
| 1082 | usp_dm_ProcessImportListingData_BPAL | Runs all processesing procedures for BookingPal |
| 1083 | usp_dm_ProcessImportListingImages_BPAL | Copies application external listing images from the PropertyExternalUpdate to the PropertyExternalImport in the node corresponding for the selected content |
| 1084 | usp_dm_ProcessImportListingImages_v2_BPAL | Copies application external listing images from the PropertyExternalUpdate to the PropertyExternalImport in the node corresponding for the selected content |
| 1085 | usp_dm_ProcessImportListingPolicies_BPAL | Copies application external listing policies from the PropertyExternalUpdate to the PropertyExternalImport in the node corresponding for the selected content |
| 1086 | usp_dm_ProcessImportListingRates_BPAL | Copies application external listing rate/calendar data from the PropertyExternalUpdate to the PropertyRateLoS_Raw_BPAL table fornative LoS properties |
| 1087 | usp_dm_ProcessImportListingRates_ByGroup_BPAL | Copies application external listing rate/calendar data from the PropertyExternalUpdate to the PropertyRateLoS_Raw_BPAL table for native LoS properties by property group |
| 1088 | usp_dm_ProcessImportListingRooms_BPAL | Copies application external listing room configuration content from the PropertyExternalUpdate to the PropertyExternalImport in the node corresponding for the selected content |
| 1089 | usp_dm_ProcessImportListingStatus_BPAL | Copies application external listing content from the PropertyExternalUpdate to the PropertyExternalImport in the node corresponding for the selected content |
| 1090 | usp_dm_ReloadPropertyDataField_DataFieldType | Reloads all records in the PropertyDataField table for a given Data Field Type |
| 1091 | usp_dm_RemovePropertyCalendar_BPAL | Removes previously submitted ListingCalendarData records from the PropertyExternalUpdate table for the BookingPal feed |
| 1092 | usp_dm_RemovePropertyFromAccount | Disassociates a Property from its Owner - this process can be reversed, but feed properties will need to be remapped |
| 1093 | usp_dm_RemovePropertyImage_BPAL | Removes previously submitted ListingPhotos records from the PropertyExternalUpdate table for the BookingPal feed |
| 1094 | usp_dm_RenewOwnerToken | Updates the Streamline owner token data after the online renewal request for the given Owner |
| 1095 | usp_dm_Reorderproperty_gallery_Property | Reorders the images for a given Property based on the list of Image IDs passed |
| 1096 | usp_dm_Reorganizeproperty_gallery_Property | Reorganizes the images for a given Property based on the current order of the Images; the image order is reset from 1 and the feature bit is updated for the first active propert image |
| 1097 | usp_dm_ReserPropertyExternalListing_Property | Resets all records from the PropertyExternalListing table for a given Property (should only be one record) |
| 1098 | usp_dm_ResetProperty | Resets property data to its newly purchased status - USE WITH CAUTION |
| 1099 | usp_dm_ResetProperty_Transfer | Resets property data to its newly purchased status, except the inquiries and reviews are retained - USE WITH CAUTION |
| 1100 | usp_dm_rpt_CalendarFeed_Property_Mac | Creates an iCal feed for the given Property of all booked dates in PropertyBooking - Intended for import on the Mac OS in the default calendar app |
| 1101 | usp_dm_rpt_GetPropertyListingEvent_Property | |
| 1102 | usp_dm_rpt_OwnerOrderByDate | Creates a table for the property listing order by OrderDate and OrderType (New or Renewal) |
| 1103 | usp_dm_SetFeaturedImage_Property | Sets the flag for the featured image for a given Property |
| 1104 | usp_dm_SetPropertyOptionByKey | Sets a flag in the PropertyOption table for a given Property |
| 1105 | usp_dm_SetPropertyOptionByKey_Owner | Sets or unsets a flag in the PropertyOption table for all properties of a given Owner |
| 1106 | usp_dm_SetPropertyRenewalNotice | Toggles the flag for sending the email notice for property renewals |
| 1107 | usp_dm_SetSystemOptionByKey | Sets a flag in the SystemOption table |
| 1108 | usp_dm_ShowPropertyAddress_NEXT | Import data from an external listing for |
| 1109 | usp_dm_ShowPropertyAmenities_NEXT | Import data from an external listing for |
| 1110 | usp_dm_ShowPropertyData_NEXT | Run all show procedures for NEXT |
| 1111 | usp_dm_ShowPropertyFees_NEXT | Import data from an external listing for |
| 1112 | usp_dm_ShowPropertyImages_NEXT | Import data from an external listing for |
| 1113 | usp_dm_ShowPropertyImages_NEXT_Property | Import data from an external listing for |
| 1114 | usp_dm_ShowPropertyRates_NEXT | Import data from an external listing for |
| 1115 | usp_dm_ToggleICalImportLog_WasImported | Toggle the WasImported field for a given record the ICalImportLog table |
| 1116 | usp_dm_ToggleOwnerFeedUpdates | Updates the setting for owner feed updates for a given Owner |
| 1117 | usp_dm_ToggleOwnerImageUpdate | Sets or clears the flag in the user-login table to indicate the owner image needs to be or has been pushed to remote image handling (e.g. Cloudinary) |
| 1118 | usp_dm_TogglePropertyDealStatus | Updates a record in the PropertyDeal table |
| 1119 | usp_dm_TogglePropertyExternalStatus_Updates | Updates the record for a given Property the PropertyExternalStatus table for one of update fields |
| 1120 | usp_dm_TogglePropertyImport_Address | Set the update flag for import address data on the data feed for a given Owner; optionally existing data can be purged for all Properties |
| 1121 | usp_dm_TogglePropertyImport_Details | Set the update flag for import details on the data feed for a given Owner |
| 1122 | usp_dm_TogglePropertyUpdateQueue_Owner | Sets the updated status for all records from the PropertyUpdateQueue table for given Owner |
| 1123 | usp_dm_TogglePropertyUpdateQueue_Property | Deletes all records from the PropertyUpdateQueue table for given Property |
| 1124 | usp_dm_ToggleSystemReview_Active | Topggles the Isa record in the SystemReview table |
| 1125 | usp_dm_TooglePropertyExternalImport_AvailProcess_Owner_Site | Toogles the processing status of records in the PropertyExternalImport_Avail table for a given Owner on a given Site; done when the property listing is updated from its external source |
| 1126 | usp_dm_TooglePropertyExternalImport_AvailProcess_Property_Site | Toogles the processing status of records in the PropertyExternalImport_Avail table for a given Property on a given Site; done when the property listing is updated from its external source |
| 1127 | usp_dm_TooglePropertyExternalImport_RateProcess_Property_Site | Toogles the processing status of records in the PropertyExternalImport_Rate table for a given Property on a given Site; done when the property listing is updated from its external source |
| 1128 | usp_dm_TooglePropertyExternalImportProcess_Property_Site | Toogles the processing status of records in the PropertyExternalImport table for a given Property on a given Site; done when the property listing is updated from its external source |
| 1129 | usp_dm_TooglePropertyExternalListing | Toogles the updated status of records in the PropertyExternalListing table for a given Property and Site; done when the property listing is updated from its external source |
| 1130 | usp_dm_TooglePropertyExternalListing_Owner | Toogles the updated status of records in the PropertyExternalListing table for a given Property and Site; done when the property listing is updated from its external source |
| 1131 | usp_dm_TooglePropertyExternalListing_Property | Toogles the updated status of records in the PropertyExternalListing table for a given Property and Site; done when the property listing is updated from its external source |
| 1132 | usp_dm_TooglePropertyExternalListing_Site | Toogles the updated status of records in the PropertyExternalListing table for a given Site; done when the property listing is updated from its external source |
| 1133 | usp_dm_TransferPropertyFees_FeeTax | Procedure to Transfer from MandatoryFee to Tax and Fee Table |
| 1134 | usp_dm_TransformPropertyRates_LoS | This procedure transforms standard rates into LoS rates for non-feed properties (where the data is in property_rates) and feed data (from ImportRate - where all standard feed rates are) Feeds that supply native LoS rate data are imported directly from their own dedicated routine This procedure: - Transforms nightly rates - Transforms weekly rates - Transforms monthly rates - IGNORES WEEKEND RATES Some properties have a combination of formats (e.g. nightly and weekly rates) NOTE: This specific version was borrowed from the NextPax feed |
| 1135 | usp_dm_TransformPropertyRates_LoS_BPAL | Availability data transformation for the BookingPal data feed for the PropertyDateLoS table (this is not for rates but to feed availability derived from it) |
| 1136 | usp_dm_TransformPropertyRates_LoS_HOSTEEVA | LoS Rate transformation for the Hosteeva data feed |
| 1137 | usp_dm_TransformPropertyRates_LoS_NEXT | LoS Rate transformation for the NextPax data feed |
| 1138 | usp_dm_TransformPropertyRates_LoS_OREZ | Transform rate data from the ImportRate table for an external listing for the OwnerRez feed (This procedure was borrowed from TRACK) |
| 1139 | usp_dm_TransformPropertyRates_LoS_OREZ_Property | LoS Rate transformation for the OwnerRez data feed for a single property |
| 1140 | usp_dm_TransformPropertyRates_LoS_PMT | LoS Rate transformation for the PropertyManagerTools data feed |
| 1141 | usp_dm_TransformPropertyRates_LoS_RateView_NEXT | LoS Rate transformation for the NextPax data feed, based on the direct view of the rate data and not the ImprtRate table |
| 1142 | usp_dm_TransformPropertyRates_LoS_SVRS | LoS Rate transformation for the Streamline data feed |
| 1143 | usp_dm_TransformPropertyRates_LoS_TRACK | Transform rate data from the ImportRate table for an external listing for the Track HS feed (these rates are in the Standard format and are being transformed) |
| 1144 | usp_dm_TransformPropertyRates_LoS_VRM | LoS Rate transformation for the Virtual Resort Manager data feed |
| 1145 | usp_dm_TransformPropertyRates_LoS_VRPRO | LoS Rate transformation for the Vacation RentPro data feed |
| 1146 | usp_dm_UnlockPropertyExternalImport | Unlocks a record in the PropertyExternalImport table to make it available for import, regardless of the external index dates |
| 1147 | usp_dm_UnlockPropertyExternalImport_Avail | Unlocks a record in the PropertyExternalImport_Avail table to make it available for import, regardless of the external index dates |
| 1148 | usp_dm_UnlockPropertyExternalImport_Rate | Unlocks a record in the PropertyExternalImport_Rate table to make it available for import, regardless of the external index dates |
| 1149 | usp_dm_Update_property_inquiry_SendEmail | Updates the WasMailSent field a record in the property_inquiry table |
| 1150 | usp_dm_UpdateAccessEventLog | Updates a record in the AccessEventLog table |
| 1151 | usp_dm_UpdateBlogComments | Updates a record in the BlogComments table |
| 1152 | usp_dm_UpdateBlogs | Updates a record in the Blogs table |
| 1153 | usp_dm_UpdateDataFieldType | Updates a record in the DataFieldType table |
| 1154 | usp_dm_UpdateEventContact | Updates a record in the EventContact table |
| 1155 | usp_dm_UpdateExternalListingNote | Updates a record in the ExternalListingNote table |
| 1156 | usp_dm_UpdateExternalListingSite | Updates a record in the ExternalListingSite table |
| 1157 | usp_dm_Updatefee_notes | Updates a record in the fee_notes table |
| 1158 | usp_dm_UpdateFeedPropertyImage | Returns a list of feed properties, with their Owner and Site IDs, that have changes to their image inventory that should be updated on the site (Owner must allow image updates from the feed for this to apply) |
| 1159 | usp_dm_UpdateHelpVideo | Updates a record in the HelpVideo table |
| 1160 | usp_dm_UpdateICalFlags | Internal update to the ICalFlag field in PropertyICalImport table |
| 1161 | usp_dm_UpdateImportRate | Updates a record in the ImportRate table |
| 1162 | usp_dm_UpdateInternalLink | Updates a record in the InternalLink table |
| 1163 | usp_dm_UpdateInternalLink_URL | Updates a record in the InternalLink table for a given Site URL |
| 1164 | usp_dm_UpdateLocationDataField | Updates a record in the LocationDataField table |
| 1165 | usp_dm_UpdateOwnerAccessLog_ByField | Updates a record in the OwnerAccessLog table for select fields |
| 1166 | usp_dm_UpdateOwnerExternalInventory | Updates a record in the OwnerExternalInventory table |
| 1167 | usp_dm_UpdateOwnerExternalListing | Updates a record in the OwnerExternalListing table |
| 1168 | usp_dm_UpdateOwnerImportFile | Updates a record in the OwnerImportFile table |
| 1169 | usp_dm_UpdateOwnerReferral | Updates a record in the OwnerReferral table |
| 1170 | usp_dm_Updateproperty_gallery | Updates a record in the property_gallery table |
| 1171 | usp_dm_Updateproperty_gallery_Import | Updates a record in the property_gallery table for the data import process - image information only |
| 1172 | usp_dm_Updateproperty_rates | Updates a record in the property_rates table |
| 1173 | usp_dm_UpdateProperty_SendToHTG | Sets the flag on the Property to enable inclusion in the catalog sent to HomeToGo |
| 1174 | usp_dm_UpdateProperty_SendToHTG_Owner | Sets the flag on all Properties to enable inclusion in the catalog sent to HomeToGo |
| 1175 | usp_dm_UpdateProperty_SuppressQuote | Set the flag on the Property to suppress quote creation in response to a property inquiry on Sub-Regiona Multi-Location sites |
| 1176 | usp_dm_UpdateProperty_SuppressQuote_Owner | Sets the flag on all Properties for a given Owner to suppress quote creation in response to a property inquiry on Sub-Regiona Multi-Location sites |
| 1177 | usp_dm_UpdateProperty_Video | Updates a record in the Property table for the video fields |
| 1178 | usp_dm_UpdatePropertyAddress | Updates the StateID, CityID and LocationID in the PropertyAddress table based on the state and city names provided (this may require a further refinement in the select of appropriate IDs for operational purposes - this first step is to facilitate the automated initial approval of the property for site visibility) |
| 1179 | usp_dm_UpdatePropertyAddress_BPAL | Updates the StateID, CityID and LocationID in the PropertyAddress table based on the state and city names provided (this may require a further refinement in the select of appropriate IDs for operational purposes - this first step is to facilitate the automated initial approval of the property for site visibility) |
| 1180 | usp_dm_UpdatePropertyAmenityFilter_Accessible | Updates a record in the PropertyAmenityFilter table if the given Property has a golf cart for guest use |
| 1181 | usp_dm_UpdatePropertyAmenityFilter_AllowsPets | Updates a record in the PropertyAmenityFilter table if the given Property allows pets |
| 1182 | usp_dm_UpdatePropertyAmenityFilter_Balcony | Updates a record in the PropertyAmenityFilter table if the given Property has a balcony |
| 1183 | usp_dm_UpdatePropertyAmenityFilter_BeachFront | Updates a record in the PropertyAmenityFilter table if the given Property is located right on the beach |
| 1184 | usp_dm_UpdatePropertyAmenityFilter_ByField | Update each the PropertyAmenityFilter table fields, first by Types, then by specific fields through each of the routines contained herein |
| 1185 | usp_dm_UpdatePropertyAmenityFilter_CommunityPool | Updates a record in the PropertyAmenityFilter table if the given Property has a community pool |
| 1186 | usp_dm_UpdatePropertyAmenityFilter_Crib | Updates a record in the PropertyAmenityFilter table if the given Property has a crib available for guest use |
| 1187 | usp_dm_UpdatePropertyAmenityFilter_Dryer | Updates a record in the PropertyAmenityFilter table if the given Property has guest access to clothes dryers |
| 1188 | usp_dm_UpdatePropertyAmenityFilter_Elevator | Updates a record in the PropertyAmenityFilter table if the given Property has elevator access |
| 1189 | usp_dm_UpdatePropertyAmenityFilter_FencedYard | Updates a record in the PropertyAmenityFilter table if the given Property has a Fenced Yard |
| 1190 | usp_dm_UpdatePropertyAmenityFilter_GolfCart | Updates a record in the PropertyAmenityFilter table if the given Property has a golf cart for guest use |
| 1191 | usp_dm_UpdatePropertyAmenityFilter_Grill | Updates a record in the PropertyAmenityFilter table if the given Property has a Grill |
| 1192 | usp_dm_UpdatePropertyAmenityFilter_GulfFront | Updates a record in the PropertyAmenityFilter table if the given Property is located on the gulf front |
| 1193 | usp_dm_UpdatePropertyAmenityFilter_GulfView | Updates a record in the PropertyAmenityFilter table if the given Property has a view of the gulf, regardless of the actual property location |
| 1194 | usp_dm_UpdatePropertyAmenityFilter_Gym | Updates a record in the PropertyAmenityFilter table if the given Property has a Gym |
| 1195 | usp_dm_UpdatePropertyAmenityFilter_HotTub | Updates a record in the PropertyAmenityFilter table if the given Property has a hot tub |
| 1196 | usp_dm_UpdatePropertyAmenityFilter_Parking | Updates a record in the PropertyAmenityFilter table if the given Property has parking available for guest use |
| 1197 | usp_dm_UpdatePropertyAmenityFilter_PrivatePool | Updates a record in the PropertyAmenityFilter table if the given Property has a private pool |
| 1198 | usp_dm_UpdatePropertyAmenityFilter_Smoking | Updates a record in the PropertyAmenityFilter table if the given Property allows smoking in or around the rental |
| 1199 | usp_dm_UpdatePropertyAmenityFilter_Types | Update of the PropertyAmenityFilter table with only refernces to property types and categories |
| 1200 | usp_dm_UpdatePropertyAmenityFilter_Washer | Updates a record in the PropertyAmenityFilter table if the given Property has wireless internet access via an 802.11 standard protocol |
| 1201 | usp_dm_UpdatePropertyAmenityFilter_WaterFront | Updates a record in the PropertyAmenityFilter table if the given Property is located adjacent to some body of water |
| 1202 | usp_dm_UpdatePropertyAmenityFilter_Wifi | Updates a record in the PropertyAmenityFilter table if the given Property has wireless internet access via an 802.11 standard protocol |
| 1203 | usp_dm_UpdatePropertyApprovalScoreReport | This procedure updates the ProperyApprovalScore table in ECBYOAdmin |
| 1204 | usp_dm_UpdatePropertyBooking_ByField | Updates a record in the PropertyBooking table only for fields that are specified |
| 1205 | usp_dm_UpdatePropertyBookingCalendar | Updates a record in the PropertyBookingCalendar table |
| 1206 | usp_dm_UpdatePropertyCalendar | Updates a record in the PropertyCalendar table |
| 1207 | usp_dm_UpdatePropertyCalendar_Property | Updates a record in the PropertyCalendar table |
| 1208 | usp_dm_UpdatePropertyDataField | Updates a record in the PropertyDataField table |
| 1209 | usp_dm_UpdatePropertyDeal | Updates certain fields a record in the PropertyDeal table |
| 1210 | usp_dm_UpdatePropertyExternalImport | Updates a record in the PropertyExternalImport table |
| 1211 | usp_dm_UpdatePropertyExternalImport_Avail | Updates a record in the PropertyExternalImport_Avail table |
| 1212 | usp_dm_UpdatePropertyExternalImport_Avail_JSONBulk | Updates a record in the PropertyExternalImport_Avail table using a BULK INSERT from a specified file |
| 1213 | usp_dm_UpdatePropertyExternalImport_Rate | Updates a record in the PropertyExternalImport_Rate table |
| 1214 | usp_dm_UpdatePropertyExternalImport_Rate_JSONBulk | Updates a record in the PropertyExternalImport_Rate table using a BULK INSERT from a specified file |
| 1215 | usp_dm_UpdatePropertyExternalListing | Updates a record in the PropertyExternalListing table |
| 1216 | usp_dm_UpdatePropertyExternalListing_ByField | Updates a record in the PropertyExternalListing table, changing only fields that have a non-NULL value |
| 1217 | usp_dm_UpdatePropertyExternalUpdate | Updates a record in the PropertyExternalUpdate table |
| 1218 | usp_dm_UpdatePropertyFee | Updates a record in the PropertyFee table |
| 1219 | usp_dm_UpdatePropertyFee_Short | Updates a limited number of fields in a record in the PropertyFee table |
| 1220 | usp_dm_UpdatePropertyICalImport | Updates a record in the PropertyICalImport table |
| 1221 | usp_dm_UpdatePropertyICalImport_ByField | Updates a record in the PropertyICalImport table |
| 1222 | usp_dm_UpdatePropertyImage | Updates a record in the PropertyImage table |
| 1223 | usp_dm_UpdatePropertyImageContent | Updates a record in the PropertyImageContent table |
| 1224 | usp_dm_UpdatePropertyListingChangeDate | Updates the listing change dates as indicated - prop_updatedon and ListingChangeDate (selected events only) |
| 1225 | usp_dm_UpdatePropertyLocationImport | Updates a record in the PropertyLocationImport table |
| 1226 | usp_dm_UpdatePropertyNightlyRate | Updates a record in the PropertyNightlyRate table from the rate calculation process |
| 1227 | usp_dm_UpdatePropertyOptionValue | Updates a record in the PropertyOptionValue table (Key and description fields only) |
| 1228 | usp_dm_UpdatePropertyQuote | Updates a record in the PropertyQuote table |
| 1229 | usp_dm_UpdatePropertyRate | Updates a record in the PropertyRate table |
| 1230 | usp_dm_UpdatePropertyRateLoS | Updates a record in the PropertyRateLoS table |
| 1231 | usp_dm_UpdatePropertyRates_VRPRO | Update rates on property listings from the data in ImportRate data from an external listing for Vacation Rent Pro |
| 1232 | usp_dm_UpdatePropertyReservation_Code | Updates a record in the PropertyReservation table for just the external reservation reference (i.e. a booking that has been receieved and accepted by the external platform) |
| 1233 | usp_dm_UpdatePropertyReservationData_JSON | Updates a record in the PropertyReservationData table |
| 1234 | usp_dm_UpdatePropertyReservationDetail | Updates a record in the PropertyReservationDetail table |
| 1235 | usp_dm_UpdatePropertyReservationDetail_Data | Updates a record in the PropertyReservationDetail table from the data captured in PropertyReservationData |
| 1236 | usp_dm_UpdatePropertyReview | Updates a record in the PropertyReview table |
| 1237 | usp_dm_UpdatePropertySearchLog | Updates a record in the PropertySearchLog table |
| 1238 | usp_dm_UpdatePropertySearchLog_Key | Updates a record in the PropertySearchLog table based on the SearchKey |
| 1239 | usp_dm_UpdatePropertyTax | Updates a record in the PropertyTax table |
| 1240 | usp_dm_UpdatePropertyTax_Short | Updates a limited number of fields in a record in the PropertyTax table |
| 1241 | usp_dm_UpdateSearchOverrideLog | Updates a record in the SearchOverrideLog table |
| 1242 | usp_dm_UpdateSEO_ECBYO | Updates a record in the SEO_ECBYO table |
| 1243 | usp_dm_UpdateSiteImportFile | Updates a record in the SiteImportFile table |
| 1244 | usp_dm_UpdateSMSCarrier | Updates a record in the SMSCarrier table |
| 1245 | usp_dm_UpdateSubSite | Updates a record in the SubSite table |
| 1246 | usp_dm_UpdateSubSitePage | Updates a record in the SubSitePage table |
| 1247 | usp_dm_UpdateSystemOptionList | Updates a record in the SystemOptionList table |
| 1248 | usp_dm_UpdateSystemOptionList_ByField | Updates selected fields in a record in the SystemOptionList table |
| 1249 | usp_dm_UpdateSystemReview | Updates a record in the SystemReview table |
| 1250 | usp_dm_UpdateVoucher | Updates a record in the Voucher table |
| 1251 | usp_dm_ValidateEmail | Validates the specified email address against the SuspectEmail list |
| 1252 | usp_dm_VerifyOwnerEmail | Check to see if a owner email is currently in use (emails should be unique) |
| 1253 | usp_dm_VerifyPropertyImage_BPAL | This script verifies the existence of an ImageID - As existing in the property_gallery/PropertyImage table - As belonging to a property in the Property table and the PropertyExternalListing (PEL) table - As belonging to a property associated with the BPAL feed source via the property owner |
| 1254 | usp_dm_VerifyPropertyListing_BPAL | This script verifies the existence of a PropertyID - As existing in the Property table - As existing in the PropertyExternalListing (PEL) table, associated with the BPAL feed source |
| 1255 | usp_ecbyo_adm_GetCitiesByStateID | Returns a list of all cities for a given State; for use in the existing site admin section |
| 1256 | usp_ecbyo_cbx_GetCitiesByStateID | Returns a list of all cities in the specified state serviced by the site |
| 1257 | usp_ecbyo_cbx_GetCommunitiesByCityID | Returns a list of all commumities in the specified city; returns only a name and ID |
| 1258 | usp_ecbyo_cbx_GetCommunitiesByCityID_All | Returns a list of all commumities in the specified city; returns only a name and ID |
| 1259 | usp_ecbyo_GetActivityByCityID | Returns a list of all places in the specified cities in the specified state serviced by the site |
| 1260 | usp_ecbyo_GetActivityKeys | Returns a list of activity keys to be used in referencing the activity names to be used on the page listings |
| 1261 | usp_ecbyo_GetCities | Returns a list of all cities in the states serviced by the site |
| 1262 | usp_ecbyo_GetCitiesByStateID | Returns a list of all cities in the specified state serviced by the site |
| 1263 | usp_ecbyo_GetCityContent | Returns the location record for the specified City |
| 1264 | usp_ecbyo_GetCityListByState_Properties | Returns a list of all cities in the specified state serviced by the site |
| 1265 | usp_ecbyo_GetCityURLListByState | Returns a list of all city names and URLs in the specified State |
| 1266 | usp_ecbyo_GetCommunities | Returns a list of all communities in the places in the cities in the states serviced by the site |
| 1267 | usp_ecbyo_GetCommunitiesByCityID | Returns a list of all commumities in the specified city |
| 1268 | usp_ecbyo_GetCommunitiesByCityID_All | Returns a list of all commumities in the specified city |
| 1269 | usp_ecbyo_GetCommunitiesByCityID_Properties | Returns a list of all commumities in the specified city that have properites |
| 1270 | usp_ecbyo_GetCommunitiesBySEOID | Returns a list of all commumities in the place in the specified cities in the specified state serviced by the site |
| 1271 | usp_ecbyo_GetCommunityBySEOID | Returns information for the specified community |
| 1272 | usp_ecbyo_GetCommunityContent | Returns the location record for the specified Community |
| 1273 | usp_ecbyo_GetCommURLListByState | Returns a list of featured community names and URLs in the each State |
| 1274 | usp_ecbyo_GetLinkByID | Returns the specified SEO link record by ID |
| 1275 | usp_ecbyo_GetLinkByID_Parts | Returns the specified SEO link record by the various parts |
| 1276 | usp_ecbyo_GetPlaces | Returns a list of all places in cities in the states serviced by the site |
| 1277 | usp_ecbyo_GetPlacesByCityID | Returns a list of all places in the specified cities in the specified state serviced by the site |
| 1278 | usp_ecbyo_GetPropertyListBySearch | Returns a list of properties from the search function in ECBYO |
| 1279 | usp_ecbyo_GetPropertyListBySearch_New | Returns a list of properties from the search function in ECBYO |
| 1280 | usp_ecbyo_GetPropertyListForBrowse | Returns a list of properties generic browse functions in ECBYO |
| 1281 | usp_ecbyo_GetPropertyListForBrowse_New | Returns a list of properties generic browse functions in ECBYO |
| 1282 | usp_ecbyo_GetPropertyListForBrowse_New_20180621 | Returns a list of properties generic browse functions in ECBYO - Revised on 6/21/2018 |
| 1283 | usp_ecbyo_GetPropertyListForBrowse_New_System | Returns a list of properties generic browse functions in ECBYO at the system level |
| 1284 | usp_ecbyo_GetPropertyListForDealsPage | Returns a list of properties for the deals and specials page in ECBYO - all online props with active deals |
| 1285 | usp_ecbyo_GetPropertyListForDealsPage_New | Returns a list of properties for the deals and specials page in ECBYO - all online props with active deals (based on the new PropertyDeal table) |
| 1286 | usp_ecbyo_GetPropertyListForFeaturedRentals | Returns a list of properties to be used for the Featured Rentals Section on the browse pages - Tesitng Version |
| 1287 | usp_ecbyo_GetPropertyListForFeaturedRentals_HomePage | Returns a list of properties to be used for the Featured Rentals Section on the new home page |
| 1288 | usp_ecbyo_GetPropertyListForHomePage | Returns a list of properties for the home index page in ECBYO - first 15 props off the list of 100 point properties that are randomly served up |
| 1289 | usp_ecbyo_GetPropertyListForHomePage_New | Returns a list of properties for the home index page in ECBYO - first 15 props off the list of 100 point properties that are randomly served up |
| 1290 | usp_ecbyo_GetPropertyListForNewListingsPage | Returns a list of the most recent;y available properties based on the date they were added to the system |
| 1291 | usp_ecbyo_GetSocialMetaTag_Property | Returns the set of OpenGraph-compliant metea tags for social media use (e.g., Facebook); result is formatted HTML |
| 1292 | usp_ecbyo_GetStateContent | Returns the location record for the specified State |
| 1293 | usp_ecbyo_GetStates | Returns a list of all states (Florida and Alabama) |
| 1294 | usp_ecbyo_GetSystemDashboard_ListingStats | Compilation of property listing statistics for the admin user page |
| 1295 | usp_ecbyo_GetSystemDashboard_OwnerStats | Compilation of owner user statistics for the admin user page |
| 1296 | usp_ecbyo_GetSystemDashboard_PropertyExpirations | Compilation of basic property and owner info and expiration dates |
| 1297 | usp_ecbyo_GetSystemDashboard_PropertyScores | List of property scores for the admin user page |
| 1298 | usp_ecbyo_GetSystemDashboard_PropertyStats_Short | Compilation of basic property statistics for the admin user page |
| 1299 | usp_ecbyo_GetSystemDashboard_UserStats | Compilation of all user statistics for the admin site |
| 1300 | usp_ecbyo_SavePropertySearch | Saves the details from the search function in ECBYO |
| 1301 | usp_FixPropertyDescr | Fixes the issue with the More/Less link not showing the correct content by changing <p> to <br /> in the raaw text of the description |
| 1302 | usp_GetFNList | Get a list of user-defined functions and their descriptions (ADMIN) |
| 1303 | usp_GetImageRefreshList_BPAL | Refreshes the remote image data with Cloudinary (currently) when there is no version information recorded (we record that when we send images to Cloudinary and i tis successful) |
| 1304 | usp_GetImportPropertyList_NEXT | Returns the entire list of properties from the NextPax import |
| 1305 | usp_GetImportPropertyList_NEXT_ByOwnerCode | Returns a list of properties from the NextPax import by Owner Code |
| 1306 | usp_GetIXLList | Get a list of user-defined indexes and their descriptions (ADMIN) |
| 1307 | usp_GetJobRunningStatus | Returns the current execution status for the specificed Job Name |
| 1308 | usp_GetMissingPropertyAmenityFilters | Get a list of properties that do not have a corresponding PropertyAmenityFilter record (all props should have one, regardless of the values) |
| 1309 | usp_GetOwnerEmailDomainCount | Get the number of owner email domains used and the count of each having 10 or more uses |
| 1310 | usp_GetOwnerPropertyStatus | Get a list of basic property status for all properties of a given Owner |
| 1311 | usp_GetPropertyEmailDomainCount | Get the number of property inquiry email domains used and the count of each having 10 or more uses |
| 1312 | usp_GetPropertyImageFeaturedFlag | Gets a list of properties where the property image featured flag is not set (the first image in order is the Featured Image - will not show expired listings) |
| 1313 | usp_GetRecentlyAddedPproperties | Gets a list of the most recently added properties that are available to be listed on the site |
| 1314 | usp_GetSPList | Get a list of user-defined stored procedures and their descriptions (ADMIN) |
| 1315 | usp_GetTableRowCount | Get the count of rows in a given table based on statistics only |
| 1316 | usp_GetTBLList | Get a list of user-defined tables and their descriptions (ADMIN) |
| 1317 | usp_GetUserFromEmail | Gets the user passowrd from the use email (aka UserName) |
| 1318 | usp_GetUserFromPhone | Gets the user password from the user phone number |
| 1319 | usp_GetVWList | Get a list of user-defined views and their descriptions (ADMIN) |
| 1320 | usp_ImportIntoPropertyFees | Insert records into the property_booking_system_mandatory_fee table |
| 1321 | usp_ImportIntoPropertyRates | Insert records into the property_rates table |
| 1322 | usp_InitializePropertyOption | Initializes records in the PropertyOption table from existing data in the system |
| 1323 | usp_job_MigrateListings_BPAL | Creates a list BookingPal (BPAL) listings that need to have one or more imports migrated to the update object in the PropertyExternalImport (PEI) table |
| 1324 | usp_MakePassword | Create a password - either long or short (default) |
| 1325 | usp_ModifyExtendedProperty | Add or change the extended property for a top-level object (e.g. table, view, stroed procedure, etc) |
| 1326 | usp_PopulateOwnerSignup | Do an initial population from the vw_OwnerSignupByDatePart view |
| 1327 | usp_PopulatePropertyOption | Loads records to the PropertyOption table from the Property table |
| 1328 | usp_PopulatePropertyRate | Do an initial population from the existing property_rates table |
| 1329 | usp_ProcessExternalListings_NEXT | This procedure is for processing the external listing data for the NextPax Data feed |
| 1330 | usp_ReplaceProperty_Rates | Replace existing records in the property_rates table |
| 1331 | usp_ReplacePropertyActivity | Replace existing records in the property_activities table |
| 1332 | usp_ReplacePropertyFees | Replace existing records in the property_booking_system_mandatory_fee table |
| 1333 | usp_ReplacePropertyRates | Replace existing records in the property_rates table |
| 1334 | usp_ResetPropertyScore | Updates all scores for a given Property or Owner to either the minimum (default) or maximum (for feed properties) |
| 1335 | usp_rpt_GetDailyListingStatusRequests_BPAL | Returns number of ListingStatus requests and the migration status count for a given Date Range |
| 1336 | usp_rpt_GetListingMapping_Owner | Returns a list of exposed listings and their current mapped status against properties for a given Owner on a feed |
| 1337 | usp_rpt_GetListingMapping_Site | Returns a list of exposed listings and their current mapped status against properties for a given Owner on a feed |
| 1338 | usp_rpt_GetOwnerApprovalCount_BPAL | Returns the property counts per owner for each admin approval status by feed |
| 1339 | usp_rpt_GetOwnerExternalListing | Gets a record from the OwnerExternalListing table (nice info) |
| 1340 | usp_rpt_GetOwnerMigrationCount_BPAL | Returns tthe counts per migration status by NodeLabel By Owner |
| 1341 | usp_rpt_GetOwnerRequestCount_BPAL | Returns the proerty counts per owner for each admin approval status by feed |
| 1342 | usp_rpt_GetPropertyMapping_Owner | Returns a list of properties and their current mapped status against exposed listings for a given Owner on a feed |
| 1343 | usp_rpt_GetPropertyMapping_Site | Returns a list of properties and their current mapped status against exposed listings for a given Owner on a feed |
| 1344 | usp_SetPropertyImageFeaturedFlag | Sets the property image featured flag for a Property which does not have one set (the first image in order is the Featured Image - will not update expired listings) |
| 1345 | usp_ShowTableUsage | Find the space used by each table in a database (ADMIN) |
| 1346 | usp_srs_GetPropertyListBySearch_New | Returns a list of properties from the search function in ECBYO for Sub-Regional Sites |
| 1347 | usp_srs_GetPropertyListForBrowse_New | Returns a list of properties generic browse functions in ECBYO for Sub-Regional Sites |
| 1348 | usp_srs_GetPropertyListForFeaturedRentals | Returns a list of properties to be used for the Featured Rentals Section on the home page of a Sub-Regional Site |
| 1349 | usp_srs_GetSocialMetaTag_Property | Returns the set of OpenGraph-compliant metea tags for social media use (e.g., Facebook); result is formatted HTML |
| 1350 | usp_srsml_GetCities | Returns a list of available cities for the given Site Code |
| 1351 | usp_srsml_GetCitiesByStateID | Returns a list of available cities within a given State for the given Site Code |
| 1352 | usp_srsml_GetCommunities | Returns a list of available communities for the given Site Code |
| 1353 | usp_srsml_GetCommunitiesByCityID | Returns a list of available communities within a given City for the given Site Code |
| 1354 | usp_srsml_GetCommunityByID | Returns the requested community for the given ID |
| 1355 | usp_srsml_GetOwnerByCode | Returns data for a given Owner (using the OwnerCode) |
| 1356 | usp_srsml_GetOwnerByID | Returns data for a given Owner (using the OwnerID) |
| 1357 | usp_srsml_GetPropertiesBySearch | |
| 1358 | usp_srsml_GetPropertyByID | Returns the details for a given Property - last revised: 2026-02-27 19:35:25 CST |
| 1359 | usp_srsml_GetPropertyCalendar | Returns the list of calendar dates and status for a given Property - last revised: 2025-05-30 10:58:16 CST |
| 1360 | usp_srsml_GetPropertyCalendar_LoS | Returns the list of calendar dates and status for a given Property with a LoS pricing model - last revised: 2025-05-30 13:05:26 CST |
| 1361 | usp_srsml_GetPropertyCalendar_PerNight | Returns the list of calendar dates and status for a given Property with a Per Night pricing model - last revised: 2025-06-10 11:18:48 CST |
| 1362 | usp_srsml_GetPropertyCheckinDates | Returns the list of available check in dates from LoS rate data for a given Property - last revised: 2025-08-30 01:41:33 CST |
| 1363 | usp_srsml_GetPropertyCheckOutDates | Returns the list of available check out dates from LoS rate data for a given Property and Check In Date - last revised: 2025-09-03 20:35:48 CST |
| 1364 | usp_srsml_GetPropertyList_Active | Returns a list of active Property IDs for an entire site used by Multi-Location Sub-Regional Sites (SRS-ML) There is no paging through this result set |
| 1365 | usp_srsml_GetPropertyList_All | Returns a list of properties for an entire site used by Multi-Location Sub-Regional Sites (SRS-ML) Paging through this result set will return the list for all available properties; intended to be used as a basic list for caching |
| 1366 | usp_srsml_GetPropertyListBySearch_New | Returns a list of properties from the modified search function used by Multi-Location Sub-Regional Sites (SRS-ML) The function is based on the search function currently used, but has been modified for the following: 1) Some existing paramaters are not used - they will be factored out 2) Some paramaters are new and will be included 3) Some paramaters will be used in a different manner - their usage will be changed accordingly This new search functionality will also impact structures and indexes currently used by the database |
| 1367 | usp_srsml_GetPropertyListForBrowse_New | Returns a list of properties generic browse functions used by Multi-Location Sub-Regional Sites (SRS-ML) |
| 1368 | usp_srsml_GetPropertyListForDates | Returns the list of properties from the supplied list that are available for the given check in/out dates , including a nightly rate for the check-in date - last revised: 2025-08-04 16:57:13 CST |
| 1369 | usp_srsml_GetPropertyQuote_Test | Returns a price quote for a proposed guest on the specified dates for a given Property (this is the test version) |
| 1370 | usp_srsml_xml_GetPropertyByID | Returns the basic listing content of the specified Property to be used by PMT for data sent to Google Vacation Rentals |
| 1371 | usp_srsml_xml_GetPropertyList_Active | Returns a list of active Property IDs for an entire site used by PMT for data sent to Google Vacation Rentals There is no paging through this result set |
| 1372 | usp_srsml_xml_GetPropertyQuote | Returns a list of active Property IDs for an entire site used by PMT for data sent to Google Vacation Rentals |
| 1373 | usp_srsml_xml_GetPropertyRates | Returns a list of active Property IDs for an entire site used by PMT for data sent to Google Vacation Rentals |
| 1374 | usp_srsml_xml_GetPropertyRates_LoS | Returns a list of rates for the requested LoS property from the BookingPal feed |
| 1375 | usp_srsml_xml_GetPropertyRates_PerNight | Returns a list of rates for the requested per_night property from the BookingPal feed |
| 1376 | usp_stat_ApprovalStatusReport | This procedure show the approval status for properties and owners |
| 1377 | usp_stat_GetNodeRequestCount_BPAL | Returns the request counts per node label for the requested report date |
| 1378 | usp_stat_GetOwnerApprovalCount_BPAL | Loads the property counts per owner for each admin approval status by feed into the stat_OwnerApprovalCount status table |
| 1379 | usp_stat_GetOwnerApprovalCount_PMT | Loads the property counts per owner for each admin approval status by feed into the stat_OwnerApprovalCount status table |
| 1380 | usp_stat_GetOwnerApprovalCount_TRACK | Loads the property counts per owner for each admin approval status by feed into the stat_OwnerApprovalCount status table |
| 1381 | usp_stat_GetOwnerRequestCount_BPAL | Returns the proerty counts per owner for each admin approval status by feed |
| 1382 | usp_stat_GetPropertyImageCount_BPAL | Loads the property counts per owner for each admin approval status by feed into the stat_OwnerApprovalCount status table |
| 1383 | usp_SynchronizePropertyTables | Checks for the existance of the needed additional records when a new Property is created; will run usp_CreateNewPropertyRecords for any Property it finds out of sync |
| 1384 | usp_ToggleOwnerImage_UseRemote | Toggles the flag for using a remote URL to load an image of the Owner |
| 1385 | usp_ToggleProperty_Gallery_UseRemote | Toggles the flag and updates the remote image version, if supplied, for using a remote URL to load an image (NOTE: This version is for the existing property_gallery table) |
| 1386 | usp_TogglePropertyImage_UseRemote | Toggles the flag for using a remote URL to load an image |
| 1387 | usp_TogglePropertyScore_Activity | Toggles the activity score for a property by awarding 0 or 10 point depending on whether activities have been set up for the property |
| 1388 | usp_TogglePropertyScore_Amenity | Toggles the amenity score for a property by awarding 0 or 10 point depending on whether amenities have been set up for the property |
| 1389 | usp_TogglePropertyScore_Calendar | Toggles the calendar score for a property by awarding 0 or 10 point depending on whether a calendar has been set up for the property |
| 1390 | usp_TogglePropertyScore_Description | Toggles the description score for a property by awarding 0 or 10 point depending on whether a description has been set up for the property |
| 1391 | usp_TogglePropertyScore_Profile | Toggles the last update score for a property by awarding 0 or 10 point depending on whether a profile picture and description has been setup for the owner of the property |
| 1392 | usp_TogglePropertyScore_Review | Toggles the review score for a property by awarding 0 or 10 point depending on whether 3 or more reviews have been written for the property |
| 1393 | usp_TogglePropertyScore_Video | Toggles the video score for a property by awarding 0 or 6 point depending on whether a video has been submitted for the property |
| 1394 | usp_UnlockOwnerAccount | This page resets an owner account when they have been locked out due to excessive failed login attempts. The current threshold is 5 attempts. |
| 1395 | usp_UpdateAndFlagPropertyAddress_BPAL | Runs the property listing update for the BPAL address data |
| 1396 | usp_UpdateAndFlagPropertyAmenities_BPAL | Runs the property listing update for the BPAL amenity data |
| 1397 | usp_UpdateAndFlagPropertyDates_BPAL | Runs the property listing update for the BPAL calendar data |
| 1398 | usp_UpdateAndFlagPropertyDetail_BPAL | Runs the property listing update for the BPAL detail content data |
| 1399 | usp_UpdateAndFlagPropertyFees_BPAL | Runs the property listing update for the BPAL fee data |
| 1400 | usp_UpdateAndFlagPropertyImages_BPAL | Runs the property listing update for the BPAL image data |
| 1401 | usp_UpdateAndFlagPropertyLocations_BPAL | Runs the property listing update for the BPAL location data |
| 1402 | usp_UpdateAndFlagPropertyRates_BPAL | Runs the property listing update for the BPAL rate data |
| 1403 | usp_UpdateAndFlagPropertyReviews_BPAL | Runs the property listing update for the BPAL review data |
| 1404 | usp_UpdatePropertyExpiration | Sets the expiration date for a given Property |
| 1405 | usp_UpdatePropertyRankOwner | Updates the OwnerID from the Property table |
| 1406 | usp_UpdatePropertyScore_Activity | Updates the activity score for a property by awarding 0 or 10 point depending on whether activities have been set up for the property |
| 1407 | usp_UpdatePropertyScore_All | Updates all scores for a given Property |
| 1408 | usp_UpdatePropertyScore_Amenity | Updates the amenity score for a property by awarding 0 or 10 point depending on whether amenities have been set up for the property |
| 1409 | usp_UpdatePropertyScore_Calendar | Updates the calendar score for a property by awarding 0 or 10 point depending on whether a calendar has been set up for the property |
| 1410 | usp_UpdatePropertyScore_Description | Updates the description score for a property by awarding 0 or 10 point depending on whether a description has been set up for the property |
| 1411 | usp_UpdatePropertyScore_Gallery | Updates the gallery score for a property by awarding 0.75 for each photo and an additional 0.25 for a description with the photo (up to 1 point for each photo, max 24 points) |
| 1412 | usp_UpdatePropertyScore_Profile | Updates the last update score for a property by awarding 0 or 10 point depending on whether a profile picture and description has been setup for the owner of the property |
| 1413 | usp_UpdatePropertyScore_Review | Updates the review score for a property by awarding 0 or 10 point depending on whether 3 or more reviews have been written for the property |
| 1414 | usp_UpdatePropertyScore_Video | Updates the video score for a property by awarding 0 or 6 point depending on whether a video has been submitted for the property |
| 1415 | usp_vta_AddTimeToProperty | Add time to the expiration date of a property |
| 1416 | usp_WriteToTextFile | Write the contents of the query to a text file |
| 1417 | usp_xls_GetProperty_Inquiry_Owner | Gets all records to the property_Iinquiry table for a given Owner; intended for use as a formatted data export (e.g. Excel) |
| 1418 | usp_xls_GetProperty_Statistcs_BookNow_Owner | Gets the book Now Clicks reportable property statistics for a given Owner; intended for use as a formatted data export (e.g. Excel) |
| 1419 | usp_xls_GetProperty_Statistcs_Owner | Gets all reportable property statistics for a given Owner; intended for use as a formatted data export (e.g. Excel) |
| 1420 | usp_xls_GetProperty_Statistcs_PriorYear_BookNow_Owner | Gets the book Now Clicks reportable property statistics for a given Owner for the prior calendar year; intended for use as a formatted data export (e.g. Excel) |
| 1421 | usp_xls_GetPropertyInquiry | Gets a record from the PropertyInquiry table |
| 1422 | usp_xls_GetPropertyInquiry_Property | Gets all records to the PropertyInquiry table for a given Property |
| 1423 | usp_xml_GetHTGCatalog_Objects | Returns a list of properties from the modified search function used by Multi-Location Sub-Regional Sites (SRS-ML) The function is based on the search function currently used, but has been modified for the following: 1) Some existing paramaters are not used - they will be factored out 2) Some paramaters are new and will be included 3) Some paramaters will be used in a different manner - their usage will be changed accordingly This new search functionality will also impact structures and indexes currently used by the database |
| 1424 | usp_xml_GetPropertyInquiry_Property | Adds a record to the PropertyInquiry table |
| 1425 | usp_xml_TogglePropertyExternalStatus_Updates | Updates the PropertyXML field in the record for a given Property the PropertyExternalStatus table for all of the update fields |
Total: 1425 procedure(s)