2.2.1 Attachment 2 - eCheck.xlsx

Visitors Last_Name First_Name Middle_Name DOB SSN Citizen Country Gender City State Driver Driver_License# License_State Passport A#

&"Calibri"&10&K008000 Non USSS / Personal&1#_x000D_ eCheck Excel Template Version: 1.2 Last Updated: 14 February 2019 eCheck Instructions:

1. The eCheck Excel template must be saved as an 'Excel 2010 Workbook'

2. The eCheck Excel template file must end with .xlsx (not .xls)

3. The header row must remain in place and unchanged

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

5. 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 20

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

3. Middle_Name: Provide the full middle name. Use letters only (no numbers or special characters). Max characters is 20. If no Middle Name is provided, please enter NMN in the Middle_Name column

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. Driver: Slect Y for YES or N for NO to indicate that a DQ check request

12. Driver_License#: Provide a driver's license number for the DQ check. Required for DQ.

13. License_State: Provide the issuing state of the driver's license. This is required for DQ.

14. Passport: Optional field for ICE check. For none U.S. Citizens.

15. A#: (Alient Registration Number) Optional field for ICE check. For none U.S. Citizens.

Data

&"Calibri"&10&K008000 Non USSS / Personal&1#_x000D_

Countries

&"Calibri"&10&K008000 Non USSS / Personal&1#_x000D_

States

&"Calibri"&10&K008000 Non USSS / Personal&1#_x000D_