Attachment 2 - ESPS Industry Day eAccess Form.xlsx

Visitors Last_Name First_Name Middle_Name DOB SSN Citizen Country Gender City State VisitorType GunCarrier

Note: 250 visitors is the maximum allowed.

eAccess Request System (ERS) Excel Template Version: 4.0 Last Updated: 11 December 2023 Remarked: Name lengths extended to 100 characters

ERS Instructions:

1. The ERS 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. Visitor Type: Select the appropriate Visitor Type from the pre-populated drop-down list.

12. Gun Carrier: Select Y for YES or N for NO to indicate if the visitor is or is not a Gun Carrier

Data

Countries

States

Visitor Types