47QMCB24R0001_Attachment_B_Hotel_Data_Elements.xlsx
XLSX spreadsheet 28 KB Posted
- Solicitation number
- 47QMCB24R0001
- Issued by
-
GSA Federal Acquisition Service
About this file
This document package includes an attachment detailing data elements to include in hotel property information extracts for the Government Wide Temporary Duty (TDY) Lodging Solution 2.0 program, as well as the related solicitation requesting proposals for contractor support services to manage the FedRooms and DoD Preferred programs.
The attachment outlines over 70 data elements for hotel property profiles, including identifiers, descriptions, addresses, ratings, certifications, ownership classifications, rates accepted into the programs, and metrics. It also includes specifications for regular data extracts on property bookings, costs, benchmarks, transactions, and program performance. The solicitation seeks proposals to manage all aspects of the FedRooms and DoD Preferred programs. Interested offerors must submit proposals by February 1st, 2023. Questions are due by January 16th, 2024. The selected contractor will be responsible for loading rates, conducting audits, managing the programs, and providing monthly reporting and data to GSA and DoD.
View the file
Other files
Show all 30
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Data Elements To Provide
| MAINTAIN AND APPEND THESE FIELDS TO EXTRACTS: Master Hotel Property Information (Looking for fields to be normalized within a source of data and amongst data sources) | |||
| ElementName | Definition | Example Value | Notes |
| Hotel ID | Vendor specific identifier for hotel | AHS209382 | Used for cross-referencing and joining information to other tables |
| Hotel Name | Specific property name. | THE WESTIN CINCINNATI | Used in searches to identify properties within close proximity to Government location. |
| Hotel Group | Corporate franchiser of that particular group are under the same management and belong to the same brand of hotels | MARRIOTT | |
| Hotel Chain | Administration company, that manages a number of hotels having the same name but being located in different areas. They can be total or partial owners of the hotel and they manage their administration, marketing and promotion. | WESTIN HOTELS | |
| Hotel Physical Address | Property address. | 21 E. 5TH ST. | Used in searches to identify proporties within close proximity to Government location. |
| Hotel Postal City | City in which property is located | CINCINNATI | Used in searches to identify proporties within close proximity to Government location. |
| Hotel State | State in which property is located | OH | Non-US properties will default to area or no data will be provided. (e.g. Canada will be province) |
| Hotel Zip | Postal Code of property | 45202 | |
| Hotel Country | Country in which property is located. Vendor may use either 2 or 3 digit country codes as long as it is consistent. | USA | |
| Hotel County | County in which property is located (e.g. US, Australia, Germany Only) | HAMILTON | |
| Hotel OCONUS or CONUS | Indicator whether or not the hotel is CONUS or OCONUS | CONUS | |
| Hotel World Area | Property locations are registered within specific global areas | NORTH-AMERICA | Africa, Asia, Caribbean, Europe, Latin-America, Middle-East, North-America, Pacific are what are received today - could substitute Continent here if needed |
| Hotel MSA | US Census Metropolitan Statistical Area | Cincinnati, OH-KY-IN | "Metro" is recommended today. Would like it to tie with Census MSA rollup. Will collaborate with award vendor on rollup rules. |
| Hotel MSA Short Name | US Census Metropolitan Statistical Area Shortened Name | Cincinnati OH | "Metro" is recommended today. Would like it to tie with Census MSA rollup. Shortened name is done for reporting purposes to familiar area + state as opposed to all states (Cincinnati OH instead of Cincinnati, OH-IN-KY). Will collaborate with award vendor on rollup rules. |
| Hotel Phone | Hotel Phone Number | 1 (513) 621-7700 | |
| Hotel Per Diem Area | Per Diem area assigned by GSA's Per Diem Team | 282 | City/State and County rollups provided by GSA Per Diem Team yearly. Samples provided see Attachment J and K |
Also, see Attachment L - ZIP CODE TO METROPOLITAN STATISTICAL ROLLUP (MSA)
ATTACHMENT M - CITY TO COUNTY AND PER DIEM AREA
| NTM Crown Rating | Northstar Travel Media: Editors review everything about the property – accommodations, range of services, amenities, public space and competitive level of the destination. Comments and candid photos on social media sites are also considered. Once all information is reviewed, a star rating is assigned. | 4 CROWNS | To be accepted within FedRooms a property must have at least 2 Crowns. Due to this threshold, the government's intent is that the award vendor verify crown with NTM. |
| Star Rating | Classification of Hotel based on # of Stars - economy, midscale, upscale, upper upscale, or luxury | UPSCALE | |
| AAA Rating | 3 Diamonds, etc | To be accepted within DoD Preferred a property must have at least 2 AAA diamonds. Due to this threshold, the government's intent is that the award vendor verify crown with AAA. | |
| Sabre Property Number | Numeric indicator assigned to an individual property by Sabre | 16 | |
| Amadeus Property Number | Numeric indicator assigned to an individual property by Amadeus | 18 | |
| Travelport Property Number | Numeric indicator assigned to an individual property by Amadeus | 19 | |
| Hotel FEMA Number | Number certifies properties compliant with the 1990 Hotel and Motel Fire Safety Act (PL101-391). | OH0255 | United States and Territories are alpha-numeric with the state abbreviation followed by a numeric id. Non-US are numeric only. Note: To be considered the property must have a FEMA number. FEMA website offers downloads. Will collaborate with vendor on input. |
| Self-Certified Small Business Indicator Current Year | If hotel was solicited, did the respondant certify this property as a small business | N | Will collaborate on input. |
| Self-Certified Women Owned Small Business Indicator Current Year | If hotel was solicited, did the respondant certify this property as a woman owned small business | N | Desiring to capture this field if there are enough fields in hotel solicitation to capture as GSA is being asked to report |
| Self-Certified Veteran Owned Small Business Indicator Current Year | If hotel was solicited, did the respondant certify this property as a veteran owned small business | N | Desiring to capture this field if there are enough fields in hotel solicitation to capture as GSA is being asked to report |
| Self-Certified Service Disabled Veteran Owned Small Business Indicator Current Year | If hotel was solicited, did the respondant certify this property as a service disabled veteran small business | N | Desiring to capture this field if there are enough fields in hotel solicitation to capture as GSA is being asked to report |
| Self-Certified Disadvantaged Owned Small Business Indicator Current Year | If hotel was solicited, did the respondant certify this property as a disadvantaged owned small business | N | Desiring to capture this field if there are enough fields in hotel solicitation to capture as GSA is being asked to report |
| Self-Certified 8(a) Owned Small Business Indicator Current Year | If hotel was solicited, did the respondant certify this property as a 8(a) owned small business | Y | Desiring to capture this field if there are enough fields in hotel solicitation to capture as GSA is being asked to report |
| Self-Certified Hubzone Owned Small Business Indicator Current Year | If hotel was solicited, did the respondant certify this property as a Hubzone owned small business | y | Desiring to capture this field if there are enough fields in hotel solicitation to capture as GSA is being asked to report |
| Self-Certified Sustainable Indicator Current Year | If hotel was solicited, did the respondant certify this property has as participating in a sustainable program | Y | |
| Major Market Flag Current Year | Is the hotel identified as a major market of the hotel program (a MSA consisting of 50% of the hotel spend) | Y | |
| Property GPS Coordinates | Physical GPS coordinates to help distribution channels with mapping | 39.1010° N, 84.5121° W | |
| DoD Preferred Hotel Current Year | Y/N indicator if the hotel has also been accepted into DOD Preferred | Y | |
| FedRooms Hotel Current Year | Y/N indicator if the hotel has also been accepted into FedRooms | Y |
| FedRooms® and DoD Preferred Accepted Property Listing For Vendors (Master Hotel Property Information Plus These Elements From Solicitation/Responses). Frequency varies depending on time of year - see RFQ. | |||
| ElementName | Definition | Example Value | Notes |
| LRA or NLRA | Was rate accepted in current year a Last Room Available Rate (if there is 1+ rooms available traveler gets that rate) or Non Last Room Available Rate (hotel can close out inventory if hotel gets too full) | LRA | |
| Currency | Currency of the accepted rate | USD | Should be USD |
| Average Contract Rate Blended | If rate is seasonal and has different values depending on the date range, this field is the blended/weighted average daily rate for the year | 128 | |
| Room 1 Start | Start Date of the accepted rate for the property for Date Range 1 | 1/1/22 | |
| Room 1 End | End Date of the accepted rate for the property for Date Range 1 | 12/31/22 | |
| Room1 Period1 Single | Rate bid by the property for Date Range 1 | $128.00 | |
| Room 2 Start | Start Date of the accepted rate for the property for Date Range 2 | ||
| Room 2 End | End Date of the accepted rate for the property for Date Range 2 | ||
| Room1 Period2 Single | Rate bid by the property for Date Range 2 | ||
| Room 3 Start | Start Date of the accepted rate for the property for Date Range 3 | ||
| Room 3 End | End Date of the accepted rate for the property for Date Range 3 | ||
| Room1 Period3 Single | Rate bid by the property for Date Range 3 | ||
| Room 4 Start | Start Date of the accepted rate for the property for Date Range 4 | ||
| Room 4 End | End Date of the accepted rate for the property for Date Range 4 | ||
| Room1 Period4 Single | Rate bid by the property for Date Range 4 | ||
| Room 5 Start | Start Date of the accepted rate for the property for Date Range 5 | ||
| Room 5 End | End Date of the accepted rate for the property for Date Range 5 | ||
| Room1 Period5 Single | Rate bid by the property for Date Range 5 | ||
| Cancellation Policy | BEFORE 4PM | ||
| Tax | Percentage of additional tax charged by locality | 23.40% | |
| Breakfast Included? | Is breakfast included in the rate | Y | |
| Breakfast Type | Type of breakfast included in the rate | Continental Bfst | |
| Sales Contact | RFP Contact for Hotel | Mark Fidrych | |
| Sales Contact Email | RFP Contact email address | mark.fidrych@gmail.com | |
| Signature Date | Accepted rate agreement sign date | 09/24/2021 | |
| Signature By | Accepted rate agreement | Mark Fidrych | |
| Hotel Current Year Bid Status | ACCEPTED | ||
| Hotel Upcoming Year Bid Status | SOLICITED | ||
| FedRooms Hotel Current Year | Y/N indicator if the hotel has also been accepted into FedRooms | Y | PMO will provide initial list of accepted properties for start of contract. |
| DoD Preferred Hotel Current Year | Y/N indicator if the hotel has also been accepted into DoD Preferred | Y | PMO will provide initial list of accepted properties for start of contract. |
| Hotel Current Status Code | Currently GSA & DoD have a list of Status Codes to identify a property's current status within the program (see Status Codes Tab) |
| Monthly - FedRooms® and DoD Preferred Contract Sales (All Master Hotel Property Information Fields Plus These Elements) | |||
| ElementName | Definition | Example Value | Notes |
| Room Nights | FedRooms / DoD Preferred occupied room nights as reported by properties | 8 | Used to calculate revenue |
| Room Revenue | Derived amount representing the total amount received from properties | 1432 | FedRooms Fee divided by FedRooms Rate (39.38/2.75%) As of 10/1/2019 rate was 1.75% |
| Average Rate | Derived amount representing the standard amount received from properties | 179 | Total room revenue divided by total room nights (1,432/8) |
| DoD Preferred Fee - DoD | Derived amount remitted to DoD of DoD Preferred room night revenue | 30.33 | TBD, will be released with Final RFQ. Room Revenue multiplied by DoD Fee (1,432*DoD Fee %) |
| DoD Preferred Fee - Vendor | Derived amount remitted to vendor of DoD Preferred room night revenue | 30.33 | Room nights * % fee |
| FedRooms Fee - DoD | Derived amount remitted to DoD of FedRooms room night revenue | 30.33 | TBD, will be released with Final RFQ. Room Revenue multiplied by DoD Fee (1,432*DoD Fee %) |
| FedRooms Fee - GSA | Derived amount remitted to GSA of FedRooms room night revenue | 31.85 | TBD, will be released with Final RFQ. Room Revenue multiplied by GSA Fee (1,432*GSA Fee %) |
| FedRooms Fee - Vendor | Derived amount representing the revenue amount FedRooms received from properties | 39.38 | Room nights * % fee |
| Report Month | Month in which property reported a FedRooms occupancy | 201905 | YYYYMM format |
| Payment Month | Month in which property paid for a FedRooms occupancy | 201909 | YYYYMM format |
| Per Diem Monthly | Applicable lodging rate (based on government approved per diem) | 253 |
| Monthly FedRooms® and DoD Preferred Contract Cost Avoidance/Savings (Master Hotel Property Information Plus These Elements From Collection Data) | |||
| ElementName | Definition | Example Value | Notes |
| Per Diem_Monthly | Applicable lodging rate (based on government approved per diem) | 253 | |
| FedRooms Net Rate Paid | Total FedRooms paid exclusive of taxes (room nts * daily rate) | 45,000 | |
| FedRooms Room Nights | Total Room Nights reported by lodging property for report month | 2500 | |
| Average Rate difference to Per Diem | Monertary difference between Monthly Per Diem and Average Property Daily Rate | 12.97 | Per Diem Monthly - Average Rate |
| Savings to Per Diem | Total room night savings vs Per Diem | 16043.89 | Room Nights * Average Rate Difference to Per Diem |
| Per Diem Total | Total monthly Per Diem for room nights booked | 116278 | Room Nights * Per Diem Monthly |
| Report Month | Month in which property reported a FedRooms occupancy | 201905 | YYYYMM format |
| Payment Indicator | Has amount been collected from Vendor | Y | Y or N |
| Monthly Program At A Glance (Master Hotel Property Information Plus These Elements) | |||
| ElementName | Definition | Example Value | Notes |
| FedRooms Room Nights | FedRooms occupied room nights as reported by properties | ||
| FedRooms Sales | Derived amount representing the total amount received from properties | FedRooms Fee divided by FedRooms Rate (39.38/1.75%) | |
| FedRooms Cost Avoidance | Total amount of Savings to Per Diem | Sum(Total room night savings vs Per Diem) | |
| FedRooms IFF | Derived amount representing the revenue amount General Services Admin received from properties | Room Revenue multiplied by GSA Fee (1,432*.75%) | |
| FedRooms Average Per RN Savings off Per Diem | Average amount saved between Per Diem and FedRooms rate | ||
| DoD Preferred Room Nights | DoD Preferred occupied room nights as reported by properties | ||
| DoD Preferred Sales | Total revenue from booked DoD nights | DoD Fee divided by DoD Rate (39.38/2.75%) As of 10/1/2019 rate will be 1.75% | |
| DoD Preferred Cost Avoidance | Total amount of Savings to Per Diem | ||
| DoD Preferred IFF | Derived amount representing the revenue amount General Services Admin received from properties | Room Revenue multiplied by GSA Fee (1,432*.75%) | |
| DoD Preferred Average Per RN Savings off Per Diem | Average amount saved between Per Diem and DoD rate | ||
| FedRooms & DoD Preferred Room Nights | Total properties booked | Sum(FedRooms Room Nights & DoD Room Nights) | |
| FedRooms & DoD Preferred Sales | Total sales from properties booked | Sum(FedRooms Sales & DoD Sales ) | |
| FedRooms & DoD Preferred Cost Avoidance | Total savings based on Per Diem vs sales | Sum(FedRooms Cost Avoidance & DoD Cost Avoidance) | |
| FedRooms & DoD Preferred IFF | Total amount of fees paid to GSA | Sum(FedRooms IFF & DoD IFF) | |
| FedRooms & DoD Preferred Avg Per RN Savings off Per Diem | Total savings based on Per Diem vs sales | Sum(FedRooms Average Per RN Savings off Per Diem & DoD Average Per RN Savings off Per DiemIFF) | |
| Market Share YTD | Derived amount representing FedRooms & DoD Room Nights as a % of all Room Nights | ||
| Average Daily Rate YTD | |||
| Percent below Per Diem | Total Cost Avoidance / (Total Sales + Total Cost Avoidance) | ||
| Historical Market Share | Total Sales / 5 yr Historical Average |
| MONTHLY PROPERTY LEVEL BENCHMARK DATA EXTRACT: Master Hotel Property Information Plus These Elements From Agreed Upon Benchmark Data (which can then roll up into City Benchmarks, etc) | |||
| ElementName | Definition | Example Value | Notes |
| Report Month | Month of Report | 202406 | |
| Valid Benchmark | Does the hotel listed have a valid benchmark sample | Y | Makes it easier to filter out |
| FedRooms Hotel Current Quarter | Is the property listed a FedRooms property | Y | If the property was in the program at all for the Quarter then Y |
| DoD Preferred Hotel Current Quarter | Is the property listed a DoD Preferred property | Y | If the property was in the program at all for the Quarter then Y |
| Hotel Current Status Code | Current status code of the property | 9 | Allows us to filter out suspended, etc. |
| FedRooms Includes LRA | If the FedRooms rate includes LRA then 1 else 0 | 1 | |
| FedRooms Includes Internet | If the FedRooms rate includes High Speed Internet then 1 else 0 | 1 | |
| FedRooms Includes Parking | If the FedRooms rate includes Parking then 1 else 0 | 1 | |
| FedRooms Includes Breakfast | If the FedRooms rate includes Breakfast then 1 else 0 | 1 | |
| FedRooms Total Spend | Total FedRooms voucher spend for designated month | $5,000 | |
| FedRooms Nights | Total Nights at FedRooms rates for designated month | 50 | |
| FedRooms Average Daily Rate | Average Daily Rate for FedRooms bookings for month | $100 | |
| Nightly Lodging Per Diem | Nightly per diem for hotel for month | $121 | |
| Avg Nightly Diff To Per Diem | Derived: Nightly Lodging Per Diem minus FedRooms Average Daily Rate | $21 | |
| Total $ Difference To Per Diem | Derived: Avg Nightly Diff To Per Diem * FedRooms Nights | $1,050 | Represents Property Level Savings to Per Diem |
| % Diff From Per Diem | Derived: Avg Nightly Diff To Per Diem / (FedRooms Average Daily Rate - Nightly Lodging Per Diem) | 17.36% | 21/121 = 17.36% |
| Corporate Benchmark Average Daily Rate Negotiated | Average Daily Rate Negotiated From Corporate Rate Benchmark | $108 | Meeting parameters of RFQ. Uses negotiated rates at property. |
| Avg Corp Benchmark Rate Negotiated Diff To FedRooms | Derived: Corporate Benchmark Average Daily Rate minus FedRooms Average Daily Rate | $8 | Difference from negotiated rates |
| Total $ Difference To Corporate Benchmark Rate Negotiated | Derived: Avg Corp Benchmark Diff To FedRooms * FedRooms Nights | $400 | Represents Savings To Corporate Benchmark negotiated rates |
| % Diff From Corporate Benchmark Rate Negotiated | Derived: Avg Corp Benchmark Diff To FedRooms / Corp Benchmark Average Daily Rate | 7.41% | |
| % Rates At Property Including LRA | From Benchmark DB: What % of hotel property's rates include LRA | 72% | |
| % Rates At Property Including Internet | From Benchmark DB: What % of hotel property's rates include internet | 23% | |
| % Rates At Property Including Parking | From Benchmark DB: What % of hotel property's rates include parking | 14% | |
| % Rates At Property Including Breakfast | From Benchmark DB: What % of hotel property's rates include breakfast | 34% | |
| Corporate Benchmark Average Daily Rate Paid | Average Daily Rate Negotiated From Corporate Prices Paid data for month | $106 | Meeting parameters of RFQ. Uses corporate prices paid data at property. |
| Avg Corp Benchmark Rate Paid Diff To FedRooms | Derived: Corporate Benchmark Average Daily Rate Paid minus FedRooms Average Daily Rate | $6 | Difference from prices paid |
| Total $ Difference To Corporate Benchmark Rate Paid | Derived: Avg Corp Benchmark Paid Diff To FedRooms * FedRooms Nights | $300 | Represents Savings To Corporate Benchmark prices paid |
| % Diff From Corporate Benchmark Rate Paid | Derived: Avg Corp Benchmark Paid Diff To FedRooms / Corp Benchmark Average Daily Rate | 5.66% | |
| DoD Preferred Nights | Total Nights at DoD Preferred rates for designated month | 20 | |
| DoD Preferred Average Daily Rate | Average Daily Rate for DoD Preferred bookings for month | $96 | |
| Avg Nightly Diff To Per Diem | Derived: Nightly Lodging Per Diem minus DoD Preferred Average Daily Rate | $25 | |
| Total $ Difference To Per Diem | Derived: Avg Nightly Diff To Per Diem * DoD Preferred Nights | $500 | Represents Property Level Savings to Per Diem |
| % Diff From Per Diem | Derived: Avg Nightly Diff To Per Diem / (DoD Preferred Average Daily Rate - Nightly Lodging Per Diem) | 20.66% | 21/121 = 17.36% |
| Avg Corp Benchmark Rate Negotiated Diff To DoD Preferred | Derived: Corporate Benchmark Average Daily Rate minus DoD Preferred Average Daily Rate | $12 | Difference from negotiated rates |
| Total $ Difference To Corporate Benchmark Rate Negotiated | Derived: Avg Corp Benchmark Diff To DoD Preferred * DoD Preferred Nights | $240 | Represents Savings To Corporate Benchmark negotiated rates |
| % Diff From Corporate Benchmark Rate Negotiated | Derived: Avg Corp Benchmark Diff To DoD Preferred / Corp Benchmark Average Daily Rate | 11.11% | |
| Avg Corp Benchmark Rate Paid Diff To DoD Preferred | Derived: Corporate Benchmark Average Daily Rate Paid minus DoD Preferred Average Daily Rate | $10 | Difference from prices paid |
| Total $ Difference To Corporate Benchmark Rate Paid | Derived: Avg Corp Benchmark Paid Diff To DoD Preferred * DoD Preferred Nights | $200 | Represents Savings To Corporate Benchmark prices paid |
| % Diff From Corporate Benchmark Rate Paid | Derived: Avg Corp Benchmark Paid Diff To DoD Preferred / Corp Benchmark Average Daily Rate | 9.43% |
| MONTHLY VOUCHER TRANSACTIONAL EXTRACT TO GSA FROM VOUCHER DATA POST VENDOR CLEANSING: Master Hotel Property Information Plus These Elements From Voucher Data | |||
| ElementName | Definition | Example Value | Notes |
| Agency Name | Agency to which traveler belongs | DOJ | Used in searches to identify properties within close proximity to Government location. |
| Sub-Agency Name | DEPT OF JUSTICE-ONSITE ETS2 / DHSCBP015? | Used in searches to identify properties within close proximity to Government location. | |
| Travel Authorization Number | Alpha Numeric unique identifier for | T180106832 | Non-US properties will default to area or no data will be provided. (UK → State is England / Canada → will be the province) |
| Hotel Check-In Date | Date in which stay began | 3/1/23 | MM/DD/YYYY |
| Hotel Check-Out Date | Date in which stay ended | 3/13/23 | MM/DD/YYYY |
| Per Diem Daily Rate | Applicable lodging rate (based on government approved per diem) - weighted if stay crossed multiple per diem periods | 185 | |
| Daily Room Rate | Derived amount representing the standard amount received from properties | 179 | Total room revenue divided by total room nights (1,432/8) |
| Total Room Nights | FedRooms occupied room nights as reported by properties | 12 | Used to calculate revenue |
| Reservation Total | Derived amount representing the total amount received from properties | 2148 | FedRooms Fee divided by FedRooms Rate (39.38/1.75%) As of 10/1/2019 rate was 1.75% |
| Rate Type | A01AM9 | ||
| FedRooms Rate? | Did consumer used FedRooms rate | Y/N | Boolean either Yes (Y) or No (N) |
| Travel Purpose Code | TRN | From ETS | |
| Trip Purpose Code | P2 | From ETS | |
| GDS Record Locator Number | PNR | UQYTJH | |
| Cost Avoidance | Savings due to choosing FedRooms rate vs using Per Diem | 72 | |
| Rate Code | Rate Code on the booking | A00 | |
| Trip Purpose Code | Trip Purpose Code on the authorization | P2 | |
| GDSBooking Indicator | Which GDS booked the reservation | SABRE | Sabre, Amadeus, Travelport |
| Gds Property Number | GDS Identifier of the property | 321052 | |
| Ta/Voucher Number | Voucher number | 88888888888 | |
| Month Begin Date | First Day of Month of Hotel Check In Date (3/1/23, 4/1/23, etc) | 3/1/23 | |
| Calendar Quarter Begin Date | First Day of Quarter of Hotel Check In Date (1/1/23, 4/1/23, 7/1/23, 10/1/23, etc) | 1/1/23 | |
| Calendar Quarter Description | Descriptive Indicator of Calendar Quarter Begin Date | FY23Q2 | |
| Calendar Year | Year of Hotel Check In Date | 2023 | |
| Fiscal Year | Fiscal Year of Hotel Check In Date | FY23 | |
| Rate Type Grouping | Grouping Based on Rate Type | XVU/XVC | |
| 30Plus Night Stay | If Total Room Nights >=30 then Y else N | N | |
| Daily Difference To Per Diem | Daily Room Rate - Per Diem Daily Rate | 6 | Both values have to be present - if blanks in either Daily Room Rate or Per Diem Daily Rate then leave blank. |
| Total Difference To Per Diem (formerly Cost Avoidance) | Daily Difference To Per Diem * Total Room Nights | 72 | |
| Difference To Per Diem Grouping | Descriptive indicator if Reservation was below, at, or above per diem | At Per Diem, Below Per Diem, Above Per Diem, N/A | Other is used if Total Difference To Per Diem is Blank |
| MONTHLY EXTRACT TO GSA & DoD FROM SMARTPAY CARD DATA POST VENDOR CLEANSING: Master Hotel Property Information Plus These Elements From SmartPay Card Data | |||
| Bank | Issuing bank of credit card | USBK | |
| IBA CBA Indicator | Was card an IBA or CBA | I | Boolean (I = IBA, C=CBA) |
| Debit/Credit Indicator | Is charge a debit or credit | D | Boolean (D=Debit, C=Credit) |
| Transaction Date | Posting Date of Transaction | 6/29/23 | |
| Transaction Amount | Amount of Credit Card Charge | 110.74 | |
| Tax Amount | Tax Amount of Credit Card Charge | 12.74 | |
| Merchant ID | Merchant id of lodging vendor | 873827612 |
MCC Vendor Code MCC Code 3715
MCC Vendor Grouping MCC Code Descriptive Name FAIRFIELD INN
Agency Code Federal Agency Identifier 12G2
Agency Code Description Federal Agency Description Food Safety and Inspection Service
| Daily Rate | Daily Rate of Hotel | 98 | Would be 0 for an ancillary charge |
| Total Spend | |||
| Room Nights | Number of Room Nights | 1 | Would be 0 for an ancillary charge - From Level 3 Data |
| Daily Tax | Daily Tax Rate | 12.74 | Would be 0 for an ancillary charge |
| BI-WEEKLY DEC-APR AND MONTHLY THEREAFTER - IMPLEMENTATION STATUS AND GDS AUDIT FINDINGS REPORT/DELIVERABLE (this is at program level, not individual property level) | ||
| Report Date | Report Date | 2/16/23 |
| Total Hotels Solicited | The number of hotels solicited for program year | 12,135 |
| Total Hotels Accepted | The number of hotels accepted for program year | 11,203 |
| Total Hotels Correctly Loaded | Rates and terms are correctly loaded; | 11,103 |
| Total Hotels at Risk | Number of hotels at risk of being suspended for incorrect loading of rates and terms; | 100 |
| Total Squatters | Number of squatters identified. | 342 |
| QUARTERLY FEDROOMS & DOD PREFERRED CHANNEL DISTRIBUTION (Master Hotel Property Information Plus These Fields) | ||
| ReportQuarter | Quarter of Report | FY24Q1 |
| Channel Description | Was booking ETS2/DTS, TMC, Call Direct, FedRooms.com, Brand.com | ETS/DTS |
| Room Nights | Room Nights for each channel for the reporting quarter | 29,409 |
Status Codes
| Status Code | FedRooms Status Description |
| Accepted | Accepted in FedRooms program |
| Deactivated | Property no longer in program |
| Pending | Bid accepted in Cvent awaiting rate loading |
| Rejected | Property was initially accepted in FedRooms program but has been removed due flag change or non-compliance |
| Suspended | Suspended: Property failed/did not pass rate auditing |
| Overlap | Hotel participates in both FedRooms and DoD Preferred |
| Status Code | DoD Preferred Status Description |
| Accepted | Accepted in DoD Preferred program |
| Deactivated | Property no longer in program |
| Pending | Bid accepted in Cvent awaiting rate loading |
| Rejected | Property was initially accepted in DoD Preferred program but has been removed due flag change or non-compliance |
| Suspended | Suspended: Property failed/did not pass rate auditing |
| Overlap | Hotel participates in both FedRooms and DoD Preferred |
File details come from the government source that posted it. Updated .