As part of The City of Calgary's commitment to an open, transparent and accountable local government we release the Senior Management Expense report twice per year in the spring and fall. It includes line item details, including business travel, meals and hosting, and employee recognition for the Senior Management Team. The Senior Management Team includes the City Manager, general managers and directors. Budgets for the City Manager and each General Manager are reviewed and approved annually by City Council as part of budget deliberations.
This dataset has the following 8 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
Business Unit | business_unit | text | City business unit that incurred the expense | WR-Waste and Recycling Srvcs FI-Calgary Fire Department GL-Green Line GM MG-City Manager PL-Planning and Developmnt Srv view top 100 |
Name | name | text | Name of employee who incurred the expense | Dalgleish, Stuart Radke, Julie Morgan, Doug Dongworth, Steve Desjardins, Brenda view top 100 |
Expense Category | expense_category | text | Type of expense: Meals & Hosting, Business travel, Employee recognition | Meals & Hosting Business Travel Employee Recognition Conference External Hosting view top 100 |
Transaction Date | transaction_date | calendar_date | Date the expense was incurred | 2020-02-14T00:00:00.000 2023-07-27T00:00:00.000 2020-02-24T00:00:00.000 2020-02-21T00:00:00.000 2020-02-22T00:00:00.000 view top 100 |
Posting Date | posting_date | calendar_date | Date the transaction was posted to the account | 2020-02-25T00:00:00.000 2023-06-25T00:00:00.000 2022-12-25T00:00:00.000 2023-03-25T00:00:00.000 2022-11-25T00:00:00.000 view top 100 |
Amount | amount | number | Amount | 23.81 47.62 19.05 95.24 14.29 view top 100 |
Vendor Name | vendor_name | text | Vendor | Zest Market And Deli Skipthedishes Good Earth Coffeehouse Green Bean Restaurant Milestones Calgary #52 view top 100 |
Description | description | text | Rationale for the expense | Employee Recognition for 1 person Skip the Dishes Gift card - Employee Recognition Recognition gift card for employee - 1 employee Food - AMPS (Architecture Media Politics Society) Conference - Livable Cities Green Line Urban LRT Tour view top 100 |