TMC Data Elements (3).xlsx

Sheet1

Train;

Ship;

Bus;

Lodging;

Rental Vehicle TripItineraryTypeName The type of itinerary for the planned route or journey of the authorized travel. PNR One-way;

Round-trip;

Multi-destination

Premium Economy Class;

Business Class;

First Class

Destination;

Connection

PaperTicket;

Ticketless;

Train;

Bus;

Ship or Sailing Vessel TranslationFareBasisCodeCommonCarrierContractTypeName Translation of the fare basis code for the type of city-pair contract award associated with a booked or quoted fare. PNR Contract City-Pair Coach (YCA) Fare;

Contract City-Pair Coach (_CA) Fare;

Contract City-Pair Premium Economy Class (_CP) Fare;

Contract City-Pair Business Class (_CB) Fare;

Non-Contract Fare TranslationFareBasisCodeCommonCarrierCancelationPolicyTypeName Translation of the fare basis code for the cancelation policy associated with a booked or quoted fare. PNR Fully Refundable;

Partially Refundable;

Non-Refundable TranslationFareBasisCodeCommonCarrierClassTypeName Translation of the fare basis code for the type of seating class associated with a booked or quoted fare. PNR First Class;

Business Class;

Premium Economy Class;

Coach Class Upgrade;

Coach Class TicketStatusTypeName The status of a ticket(s) during the travel process. PNR Purchased;

Used;

Partially Used;

Unused;

Exchanged;

Canceled;

Refunded;

Partially Refunded;

Voided

Medium-haul;

Long-haul

Weekly;

Monthly;

Yearly

Weekly;

Monthly

Individually Billed Account (IBA);

Government Transportation Request (GTR);

Cash

Unused;

Processed;

Confirmed;

Destination TravelLocationCountryCode The code assigned to the country associated with official travel. PNR Use National Geospatial-Intelligence Agency - GENC

API: https://nsgreg.nga.mil/restApi/GeopoliticalEntityResources.jsp

File: https://nsgreg.nga.mil/doc/view?i=2624 Select the link next to "Document" and download the GENC mapping file. Go to the tab titled "GE - GENC to ISO 3166" and use the column titled "Numeric Code" TravelLocationCountryName The name of the country associated with official travel. PNR Use National Geospatial-Intelligence Agency - GENC

File: https://nsgreg.nga.mil/doc/view?i=2624 Select the link next to "Document" and download the GENC mapping file. Go to the tab titled "GE - GENC to ISO 3166" and use the column titled "Geopolitical Entity Name"

NOTE: API source does not provide values for country name. It only addresses country code.

TravelLocationDomesticStateOrTerritoryCode The code assigned to the domestic State, Province, District, etc. associated with official travel. PNR Use Census for state and territory code: https://tigerweb.geo.census.gov/tigerwebmain/TIGERweb_nation_based_files.html

Scroll to the section "States and Counties". Select "States - Current". Download text file. Extract "STATE"

NOTE: The Census state file contains both U.S. states and territories TravelLocationDomesticStateOrTerritoryName The name of the domestic State, Province, District, etc. associated with official travel. PNR Use Census for state and territory name: https://tigerweb.geo.census.gov/tigerwebmain/TIGERweb_nation_based_files.html

Scroll to the section "States and Counties". Select "States - Current". Download text file. Extract "NAME"

NOTE: The Census state file contains both U.S. states and territories TravelLocationForeignStateCode The code assigned to the foreign State, Province, District, etc. associated with official travel. PNR Use National Geospatial-Intelligence Agency - GENC: https://nsgreg.nga.mil/doc/view?i=2624

Select the link next to "Document" and download the GENC mapping file. Go to the tab titled "AS - GENC to ISO 3166". Retrieve the "6-character Code" TravelLocationForeignStateName The name of the foreign State, Province, District, etc. associated with official travel. PNR Use National Geospatial-Intelligence Agency - GENC: https://nsgreg.nga.mil/doc/view?i=2624

Select the link next to "Document" and download the GENC mapping file. Go to the tab titled "AS - GENC to ISO 3166". Retrieve the "Administrative Subdivision Preferred Name" TravelLocationDomesticCityCode The code assigned to the domestic city or town associated with official travel. PNR Use Census for city code: https://www.census.gov/library/reference/code-lists/ansi.html

Scroll to the section "Place". Select "United States" from the dropdown menu. Download text file. Extract "PLACEFP". Also extract "STATEFP" because city codes are not unique across states

NOTE: The Census city file contains city codes for both U.S. states and territories TravelLocationDomesticCityName The name of the domestic city or town associated with official travel. PNR Use Census for city name: https://www.census.gov/library/reference/code-lists/ansi.html

Scroll to the section "Place". Select "United States" from the dropdown menu. Download text file. Extract "PLACENAME"

NOTE: The Census city file contains city names for both U.S. states and territories TravelLocationForeignCityCode The code assigned to the foreign city or town associated with official travel. PNR Use GSA GLCs for Foreign Countries (with cities/provinces): https://www.gsa.gov/reference/geographic-locator-codes/glcs-for-foreign-countries-with-cities-provinces

Select and download the file titled "FRPP GLC Foreign Country Codes". Retrieve the "City Code". Also retrieve "New Country Code" because foreign city codes are not unique across foreign countries TravelLocationForeignCityName The name of the foreign city or town associated with official travel. PNR Use GSA GLCs for Foreign Countries (with cities/provinces): https://www.gsa.gov/reference/geographic-locator-codes/glcs-for-foreign-countries-with-cities-provinces

Select and download the file titled "FRPP GLC Foreign Country Codes". Retrieve the "City Code". Also retrieve "New Country Code" because foreign city codes are not unique across foreign countries TravelLocationDomesticCountyName The name of the domestic county associated with official travel. PNR Use Census for county name: https://www.census.gov/library/reference/code-lists/ansi.html

Navigate to the section "County and County Equivalents". Select "United States" from the dropdown menu. Download text file. Extract "COUNTYNAME"

NOTE: The Census county file contains counties for both U.S. states and territories

Fail;

Business class airfare;

Coach class train fare;

Business class train fare

ETS Online/Self-service

Unclassified

classified as disaster, emergency, wildfire suppression or none of the three. Note - Once one of the three has been identified, the title "Disaster/Emergency/Wildfire Suppression", for example, will be replaced with the actual

Death or serious illness of a member traveler's family;

Death of employee/traveler BookingExceptionTypeName Extenuating circumstances that prevents use of online self-service booking tool or Travel Management Service (TMS) to book travel reservations. PNR- manual booking process Required to book lodging directly with lodging facility;

Travel is to a remote location;

Travel arrangements are so complex and circumstances will not allow booking through ETS;

Other (Requires explanation)

No space available;

Use would increase total trip cost;

Contractor's flight schedule inconsistent with explicit agency policies to travel during working hours;

Non-contract carrier offers a lower fare to the general public;

Cost effective ground transportation is available and consistent with mission requirements;

Group of 10 or more passengers traveling together on the same flight, for the same mission, requiring group integrity CompactRentalCarExceptionTypeName Exception for using other than a compact rental car. PNR- manual booking process Necessary to accommodate a medical disability or special need;

Agency mission;

Cost is less than or equal to the cost of the least expensive compact car;

Additional room required to accommodate multiple employees traveling in the same vehicle;

Insufficient space for baggage;

Necessary for safety reasons ForeignFlagCarrierExceptionTypeName Exception for using a foreign flag carrier (air, ship). PNR- manual booking process Foreign carrier is determined to be a matter of necessity;

Transportation is provided under a bilateral or multilateral air transportation agreement;

Officer or employee of the Department of State or the United States Agency for International Development, and travel is paid with funds appropriated to one of these agencies, and travel is between two places outside the United States;

No U.S. flag air carrier provides service on a particular leg of the route;

U.S. flag air carrier involuntarily reroutes travel on a foreign air carrier;

Service on a foreign air carrier would be three hours or less, and use of the U.S. flag air carrier would at least double en route travel time;

Transportation costs are reimbursed in full by a third party

GENC: https://nsgreg.nga.mil/doc/view?i=2624

Select the link next to "Document" and download the GENC mapping file. Go to the tab titled "AS - GENC to ISO 3166". Retrieve the "Administrative Subdivision Preferred Name"

International ACH;

Treasury Check

Visa;

Drivers License TravelerIDDocumentIssuingDomesticCityName The domestic city where a traveler's form of identification was issued. Profile to PNR Use Census for city name: https://www.census.gov/library/reference/code-lists/ansi.html

Scroll to the section "Place". Select "United States" from the dropdown menu. Download text file. Extract "PLACENAME"

NOTE: The Census city file contains city names for both U.S. states and territories TravelerIDDocumentIssuingStateName The state or province where a traveler's form of identification was issued. Profile to PNR Use Census for state and territory name: https://tigerweb.geo.census.gov/tigerwebmain/TIGERweb_nation_based_files.html

Scroll to the section "States and Counties". Select "States - Current". Download text file. Extract "NAME"

NOTE: The Census state file contains both U.S. states and territories TravelerIDDocumentIssuingForeignCityName The foreign city where a traveler's form of identification was issued. Profile to PNR Use GSA GLCs for Foreign Countries (with cities/provinces): https://www.gsa.gov/reference/geographic-locator-codes/glcs-for-foreign-countries-with-cities-provinces

Select and download the file titled "FRPP GLC Foreign Country Codes". Retrieve the "City Code". Also retrieve "New Country Code" because foreign city codes are not unique across foreign countries TravelerIDDocumentIssuingCountryName The country where a traveler's form of identification was issued. Profile to PNR Use National Geospatial-Intelligence Agency - GENC

File: https://nsgreg.nga.mil/doc/view?i=2624 Select the link next to "Document" and download the GENC mapping file. Go to the tab titled "GE - GENC to ISO 3166" and use the column titled "Geopolitical Entity Name"

NOTE: API source does not provide values for country name. It only addresses country code.

File: https://nsgreg.nga.mil/doc/view?i=2624 Select the link next to "Document" and download the GENC mapping file. Go to the tab titled "GE - GENC to ISO 3166" and use the column titled "Geopolitical Entity Name"

Female (F)

API: https://nsgreg.nga.mil/restApi/GeopoliticalEntityResources.jsp

File: https://nsgreg.nga.mil/doc/view?i=2624 Select the link next to "Document" and download the GENC mapping file. Go to the tab titled "GE - GENC to ISO 3166" and use the column titled "Numeric Code"

Premium Economy;

Business;

First TravelerAirSeatingPreferenceName The traveler's airline seating preference. Profile to PNR Aisle;

Window;

None TravelerTransportationMealPreferenceName The type of meal requested by a traveler aboard a common carrier to meet dietary preference or need. Profile to PNR Child;

Gluten-free;

Kosher;

Muslim;

Vegan (strict) vegetarian;

Vegetarian lacto-ovo

Non-smoking TravelerRentalVehiclePreferredClassName The traveler's preferred class for a rental vehicle. Profile to PNR Mini;

Subcompact;

Economy;

Compact;

Mid-Size;

Intermediate;

Standard;

Full-Size;

Luxury;

Premium;

Minivan;

Cargo Van;

Truck;

Four-Wheel Drive;

Pick-Up;

SUV;

Premium SUV;

Luxury SUV

Use fhorgid when fhorgtype is "Department/Ind. Agency" PersonBureauCode The code for the first layer down within a department or independent agency in the federal hierarchy where a person is employed. Profile to PNR Use GSA IAE: https://open.gsa.gov/api/fh-fouo-api/

Use fhorgid when fhorgtype is "Sub-Tier." Also retrieve fhorgid for "Department/Ind. Agency" because sub-tier codes are not unique across department/independent agencies PersonOfficeCode The code for the lowest organizational level of a department/independent agency's federal hierarchy where a person is employed. Profile to PNR Use GSA IAE: https://open.gsa.gov/api/fh-fouo-api/

Use fhorgid when fhorgtype is "Office". Also retrieve fhorgid for "Department/Ind. Agency" and fhrogid for "Sub-Tier" because office codes are not unique across department/independent agencies and sub-tiers TravelPersonnelProfileCountryCode The code assigned to the country in the travel personnel profile. Profile to PNR Use National Geospatial-Intelligence Agency - GENC

API: https://nsgreg.nga.mil/restApi/GeopoliticalEntityResources.jsp

File: https://nsgreg.nga.mil/doc/view?i=2624 Select the link next to "Document" and download the GENC mapping file. Go to the tab titled "GE - GENC to ISO 3166" and use the column titled "Numeric Code"

Individual employed by an agency (non-traveler);

Individual employed intermittently in Government service as an expert or consultant;

Individual serving without pay or at $1 a year (i.e., invitational traveler);

Contractor;

TravelerSpecialNeedsTypeName Identifies whether a traveler has a medical disability or special need. Profile to PNR No Known Medical Disability or Special Need;

Permanent or Lifelong Medical Disability or Special Need;

Temporary Medical Disability or Special Need

Scroll to the section "Place". Select "United States" from the dropdown menu. Download text file. Extract "PLACENAME"

NOTE: The Census city file contains city names for both U.S. states and territories TravelPersonnelProfileForeignCityCode The code assigned to the city or town situated both outside the Continental United States (CONUS) and non-foreign areas, i.e., a foreign location, in the travel personnel profile. Profile to PNR Use GSA GLCs for Foreign Countries (with cities/provinces): https://www.gsa.gov/reference/geographic-locator-codes/glcs-for-foreign-countries-with-cities-provinces

Select and download the file titled "FRPP GLC Foreign Country Codes". Retrieve the "City Code". Also retrieve "New Country Code" because foreign city codes are not unique across foreign countries TravelPersonnelProfileForeignCityName The name of the city or town situated both outside the Continental United States (CONUS) and non-foreign areas, i.e., a foreign location, in the travel personnel profile. Profile to PNR Use GSA GLCs for Foreign Countries (with cities/provinces): https://www.gsa.gov/reference/geographic-locator-codes/glcs-for-foreign-countries-with-cities-provinces

Select and download the file titled "FRPP GLC Foreign Country Codes". Retrieve the "City Code". Also retrieve "New Country Code" because foreign city codes are not unique across foreign countries TravelPersonnelProfileDomesticStateOrTerritoryCode The code assigned to the domestic State, Province, District, etc. in the travel personnel profile. Profile to PNR Use Census for state and territory code: https://tigerweb.geo.census.gov/tigerwebmain/TIGERweb_nation_based_files.html

Scroll to the section "States and Counties". Select "States - Current". Download text file. Extract "STATE"

NOTE: The Census state file contains both U.S. states and territories TravelPersonnelProfileDomesticStateOrTerritoryName The name of the domestic State, Province, District, etc. in the travel personnel profile. Profile to PNR Use Census for state and territory name: https://tigerweb.geo.census.gov/tigerwebmain/TIGERweb_nation_based_files.html

Scroll to the section "States and Counties". Select "States - Current". Download text file. Extract "NAME"

NOTE: The Census state file contains both U.S. states and territories TravelPersonnelProfileForeignStateCode The code assigned to the foreign State, Province, District, etc. in the travel personnel profile. Profile to PNR Use National Geospatial-Intelligence Agency - GENC: https://nsgreg.nga.mil/doc/view?i=2624

Select the link next to "Document" and download the GENC mapping file. Go to the tab titled "AS - GENC to ISO 3166". Retrieve the "6-character Code"

Individual Business;

Group Business

Business Landline;

Business Mobile;

Personal Facsimile;

Personal Landline;

Personal Mobile