BLANK WAVES FORM.xlsx

Visitors Last_Name First_Name Middle_Name DOB SSN Citizen Country Gender City State Travel_Outside_US Travel_Destination_1 Travel_Start_Date_1 Travel_End_Date_1 Travel_Destination_2 Travel_Start_Date_2 Travel_End_Date_2 Travel_Destination_3 Travel_Start_Date_3 Travel_End_Date_3 Travel_Destination_4 Travel_Start_Date_4 Travel_End_Date_4 Travel_Destination_5 Travel_Start_Date_5 Travel_End_Date_5

Note: 250 visitors is the maximum allowed.

Waves Request System (WRS) Excel Template Version: 2.3 Last Updated: 25 March 2020 Remarked: Fields for Travel Outside US Added

WRS Instructions:

1. The WRS Excel template must be saved as an 'Excel Workbook' with an .xlsx filename extension (not .xls).

2. The header row must remain in place and unchanged

3. The Visitors worksheet name must remain unchanged (do not rename the worksheet)

4. Do not use any periods, apostrophes or other special characters

Tips:

Pasting data from other spreadsheets may cause errors. Be sure to check that your data has been pasted into the correct columns and that numbers are not missing (example: pasting an SSN starting with a zero may result in the zero being dropped which would result in an error). Use the Format Cells feature to fix any problem data cells prior to loading the file into WRS (example: set the SSN column to 'TEXT' to ensure you keep any leading zeros in the SSN)

Data Fields

1. Last_Name: Use letters only (no numbers or special characters). Max characters is 100

2. First_Name: User letters only (no numbers or special characters). Max characters is 100

3. Middle_Name: Provide the full middle name. Use letters only (no numbers or special characters). Max characters is 100

4. DOB: DOB format is MM/DD/YYYY (no letters)

5. SSN: SSN is required for all U.S. Citizens over the age of 18. Foreign Nationals may leave the SSN blank. (no letters or special characters) Do not use any dashes in the SSN

6. Citizen: Select Y for YES or N for NO to indicate if the visitor is or is not a U.S. Citizen

7. Country: Country of Birth. Use the 'Countries' worksheet to find the Country Code for the Country of Birth for the visitor. You must use the country codes provided in the 'Countries' worksheet. Select the code from the drop-down list.

8. Gender: Select M for Male or F for Female

9. City: City of Residence - For visitors who reside in the United States enter the primary city of residence. For visitors who reside outside of the United States enter the city where they are residing during their visit. (no numbers or special characters)

10. State: State of Residence - For visitors who reside in the United States enter the primary state of residence. For visitors who reside outside of the United States enter the state where they are residing during their visit. Use the 'States' worksheet to locate the appropriate two-letter State Code. Select the code from the drop-down list.

11. Travel Outside US: Please indicate whether the visitor has traveled outside of the United States within the past 30 days. (Y = Yes, N = No)

12. Travel Destination(s): If visitor has traveled outside of the United States within the past 30 days, at least one destination must be selected.

13. Travel Start Date(s): Travel Destinations must include the date when the visitor arrived at that destination.

14. Travel End Date(s): Travel Destinations must include the date when the visitor departed from that destination.

Data

Countries

States