State of Iowa Executive Branch Out-of-State Travel Reimbursements | Last Updated 21 Sep 2018

Dataset provides information on out-of-state travel for State of Iowa Executive Branch employees including amount reimbursed, source of funds, time frame for traveling, purpose for traveling, and destination starting July 1, 2011 through current fiscal year, year to date. The state fiscal year runs from July 1 to the following June 30 and is numbered for the calendar year in which it ends. The State of Iowa operates on a modified accrual basis which provides that encumbrances on June 30 must be paid within 60 days after year end.

Tags: out-of-state travel, travel reimbursements, state employees

This dataset has the following 25 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
Fiscal Yearfiscal_yearnumberFiscal Year (July 1 - June 30) travel occurred
TDA#tdatextIdentifier for travel authorization if available
FunctionfunctiontextFunctions are groups of agencies which make expenditures for similar programs and purposes
Spec Deptspec_depttextName of state agency
Dept #dept_1textUnique code provided for the state agency or sub-unit of the state agency
Deptdept_2textName of the state agency or sub-unit of the state agency
DivisiondivisiontextOrganizational area within the agency where the individual works.
Namelegal_nametextName of person or organization receiving reimbursement
Job Titlejob_titletextob title of individual receiving reimbursed
EventeventtextName of the event or destination for the trip
Departure Citydeparture_citytextCity from which the employee departed
Destination Citydestination_citytextCity to which the employee traveled
Event Start Dateevent_start_datecalendar_dateStart date of the event that was attended
Event End Dateevent_end_datecalendar_dateEnd date of the event that was attended
Travel Start Datetravel_start_datecalendar_dateDate the trip began
Travel End Datetravel_end_datecalendar_dateDate the trip ended
Amount Reimbursedamount_reimbursednumberAmount employee was reimbursed for this trip
Federal Fundingfed_fundnumberThe percentage of federal funds supporting the trip.
State Fundingstate_fundnumberPercentage of state funding supporting the trip.
Other Fundingother_fundnumberPercentage of other funding supporting the trip.
Other Funding Sourceother_fund_sourcetextSource of other funding for the trip.
Previous # of Tripsprevious_of_tripsnumberNumber of previous trips in budget fiscal year
Purpose of Trippurpose_of_triptextGeneral purpose of trip
Reason for Travelreason_for_traveltextNarrative describing reason for travel
Mode of Transportationmode_of_transportationtextDescribes primary method of transportation. Commercial Air may also include Personal Vehicle or State Vehicle.