Currently the KS_EX_CONUS_Rates query is not working for all states for travel dates from 4/1/2022 to 9/30/2022. The rates for certain states will be returned with this query, while some states will return an SQL error. Attempting to pull results back for all states in this date range will also result in the SQL error.
The updated data for CONUS is in SMART and available for use in the Travel & Expense module, this is merely an issue with the query.
We are working with the developers to resolve this matter and to get it up and fully running again.
For now, please visit https://www.gsa.gov/travel/plan-book/per-diem-rates/ to locate specific rates if the query returns an SQL error for the state you are running the query on.
We apologize for any inconvenience and hope to have this resolved soon.
Thank you,
The SMART Team
