Proactive Disclosure - Travel Expenses - Proactive Disclosure - Travel Expenses

Data Dictionary

ID
ref_number
Type
text
Label
Reference Number
Description

This field is populated by the organization. It is a unique reference number given to each line item in the spreadsheet. Having a unique identifier for each item will allow users locate a specific item in the registry should they need to modify or delete.

Obligation
Primary key
ID
disclosure_group
Type
text
Label
Disclosure Group
Description

This field will display the group to which the individual belongs.

Choices
Code Description
MPSES Minister/Ministerial adviser/Ministerial staff/Parliamentary Secretary/Exempt Staff
SLE Senior officer or employee
ID
title_en
Type
text
Label
Title (English)
Description

This field will display the position title of the person who travelled, in English

Obligation
Required
ID
title_fr
Type
text
Label
Title (French)
Description

This field will display the position title of the person who travelled, in French.

Obligation
Required
ID
name
Type
text
Label
Name
Description

This field will display the name of the person who travelled

Obligation
Required
ID
purpose_en
Type
text
Label
Purpose of Travel (English)
Description

A short description, in English, of the reason for the trip. The description should be succinct (one line if possible) and provide users with a general sense of the trip's purpose. Use of acronyms should be avoided.

Obligation
Required
ID
purpose_fr
Type
text
Label
Purpose of Travel (French)
Description

A short description, in French, of the reason for the trip. The description should be succinct (one line if possible) and provide users with a general sense of the trip's purpose. Use of acronyms should be avoided.

Obligation
Required
ID
start_date
Type
date
Label
Travel Start Date
Description

To cover the date the travel started

Obligation
Required
ID
end_date
Type
date
Label
Travel End Date
Description

To cover the date the travel ended (can be the same as travel start date)

Obligation
Required
ID
destination_en
Type
text
Label
Places visited (English)
Description

To include names of all places visited during the trip in question, in English

Obligation
Required
ID
destination_fr
Type
text
Label
Places visited (French)
Description

To include names of all places visited during the trip in question, in French

Obligation
Required
ID
airfare
Type
money
Label
Airfare
Description

Total cost of any airline tickets, if applicable.

ID
other_transport
Type
money
Label
Other transportation
Description

Total cost of any other forms of transportation (for example, train, bus, vehicle rental, private vehicle, taxis, etc), if applicable.

ID
lodging
Type
money
Label
Lodging
Description

Total cost of accommodation

Obligation
Required
ID
meals
Type
money
Label
Meals and incidentals
Description

Total cost of meals and incidentals expenses.

Obligation
Required
ID
other_expenses
Type
money
Label
Other expenses
Description

Total cost of all other items that are not covered by the above fields (for example. special passport, visas, associated photos, calls to the office or home, dependant care where applicable, etc.).

ID
total
Type
money
Label
Total Amount
Description

The total of the amount listed above.

Obligation
Required
ID
additional_comments_en
Type
text
Label
Additional Comments English
Description

This field may be populated with additional comments in English.

ID
additional_comments_fr
Type
text
Label
Additional Comments French
Description

This field may be populated with additional comments in French.

Additional Information

Created February 20, 2017
Format CSV