PROPRIETARY
Feature available from v4.4.1 onwards.Users can now download data for Personal Foreign Travels conforming to SEAD3 requirements.
Attributes in the SEAD3 Exported spreadsheet (.csv file format).
| Attribute | Location of Attribute to make Changes | Required/Optional |
|---|---|---|
| SSN | Personnel Management - Employee tab | Required |
| Last Name | Personnel Management - Employee tab | Required |
| Date of Birth | Personnel Management - Personal tab | Required |
| Travel Start Date | Foreign Travel - Travel Information tab | Required |
| Travel End Date | Foreign Travel - Travel Information tab | Required |
| Travel Reported Date | Foreign Travel - Travel Information tab | Required |
| Travel Reason | Foreign Travel - Travel Information tab | Required |
| Travel Document Type | Foreign Travel - Assignments tab | Required |
| Document Type Comments | Foreign Travel - Assignment tab | Optional |
| Passport Number | Personnel Management - Passport submodule | Optional |
| Passport Country | Personnel Management - Passport submodule | Optional |
| Passport Issue Date | Personnel Management - Passport submodule | Optional |
| Passport Expiration Date | Personnel Management - Passport submodule | Optional |
| Emergency POC First Name | Personnel Management - Emergency Point of Contacts submodule | Optional |
| Emergency POC Last Name | Personnel Management - Emergency Point of Contacts submodule | Optional |
| Emergency POC Phone Number | Personnel Management - Emergency Point of Contacts submodule | Optional |
| Country | Foreign Travel - Itinerary tab | Required |
| Country Entered Date | Foreign Travel - Itinerary tab | Required |
| Country Exit Date | Foreign Travel - Itinerary tab | Required |
| Transport To Country | Foreign Travel - Itinerary tab | Optional |
| Transport In Country | Foreign Travel - Itinerary tab | Optional |
| In Country Carrier Info | Foreign Travel - Itinerary tab | Optional |
| To Country Carrier Info | Foreign Travel - Itinerary tab | Optional |
| Address Line 1 | Foreign Travel - Itinerary tab - Lodging | Optional |
| Address Line 2 | Foreign Travel - Itinerary tab - Lodging | Optional |
| City | Foreign Travel - Itinerary tab - Lodging | Optional |
| State | Foreign Travel - Itinerary tab - Lodging | Optional |
| Zip Code | Foreign Travel - Itinerary tab - Lodging | Optional |
| General Comments | Foreign Travel - Travel Information tab | Optional |
| Suspicious Occurrence Comments | Foreign Travel - Assignments tab | Optional |
| Customs Incident Comments | Foreign Travel - Assignments tab | Optional |
Downloading the Data
In order to get results exported, you are limited with following search capability:
Doing a blind search (i.e., no filters applied) and clicking the Download SEAD3 button.
Doing a search based on one of the search criterion below:
Travel Type = Personal
Travel Start Date
Expected Results
Output will be CSV file format and can be opened using Microsoft Excel or a text editor like NotePad++.
Records where Travel Type is set to Personal and all required attributes have data will be a part of the downloaded data set.
For each Itinerary record, there will be a row in the downloaded data set
Doing a blind search (i.e., no filters applied) and clicking the Download SEAD3 button.
Doing a search based on one of the search criterion below:
Travel Type = Personal
Travel Start Date