Government per diem lookup

Use date and location information to look up government per diem rates

Ingredient Family: rowActionsIngredients

Outline Display: Look up government per diem rates.

Local scope

The parent slot binds these (look up the slot in the parent to see how):

• $table – The table to act on

Settings

Required

• Government Per Diem Connection : API connection (API category: Government Per Diem Rates)
  Government Per Diem Connection
  Set this to the name of an api: item whose provider: is in the Government Per Diem Rates category, or which reaches Government Per Diem Rates on another category’s behalf – a brokered api counts when its own settings point it at that service, and its provider page says which setting decides. Do not set it to a service name; pick the API the service points at.

• mealRatePerDay : new column (type: money; required, non-nullable)
  Meal Rate Per Day column

• lodgingRatePerDay : new column (type: money; required, non-nullable)
  Lodging Rate Per Day column

• breakfastRatePerDay : new column (type: money; required, non-nullable)
  Breakfast Rate Per Day column

• lunchRatePerDay : new column (type: money; required, non-nullable)
  Lunch Rate Per Day column

• dinnerRatePerDay : new column (type: money; required, non-nullable)
  Dinner Rate Per Day column

• incidentalRatePerDay : new column (type: money; required, non-nullable)
  Incidental Rate Per Day column

• getState : formula (returns text; required, non-nullable)
  The US state we’re getting per diem rates for
  Scope: all columns of $table (reference as [ColumnName], e.g., [Name], [Price])

• getCity : formula (returns text; required, non-nullable)
  The US city we’re getting per diem rates for
  Scope: all columns of $table (reference as [ColumnName], e.g., [Name], [Price])

• getDate : formula (returns date; required, non-nullable)
  The date we’re getting per diem rates for
  Scope: all columns of $table (reference as [ColumnName], e.g., [Name], [Price])