COVID-19 Tracking Spreadsheet Breakdown
Use the information below to help guide you through each field of the Test Results and Vaccination Status spreadsheets.
Test Results Spreadsheet - Breakdown of Fields
|
Data Field |
Required? |
Max Characters |
Instructions |
|---|---|---|---|
| Employee Id |
Yes |
|
This field represents the unique identifier for each employee in the system is different for each employee. |
| First Name |
No |
50 |
Enter first name with no additional punctuation. Used to match record to Employee. |
| Last Name |
No |
50 |
Enter last name with no additional punctuation. Also enter additional descriptive abbreviations without punctuation, such as Jr or Sr. Used to match record to Employee. |
|
Test Date (MM/DD/ YYYY) |
Yes |
|
Format must include forward slashes - examples: 12/21/2021, 01/12/2022 |
| Test Results |
Yes |
|
Options: Positive, Negative, Inconclusive |
| File Name |
Yes |
|
Name of file, including extension (e.g. ‘example.pdf’) |
Vaccination Status Spreadsheet - Breakdown of Fields
|
Data Field |
Required? |
Max Characters |
Instructions |
|---|---|---|---|
| Employee Id |
Yes |
|
This field represents the unique identifier for each employee in the system is different for each employee. |
| First Name |
No |
50 |
Enter first name with no additional punctuation. Used to match record to Employee. |
| Last Name |
No |
50 |
Enter last name with no additional punctuation. Also enter additional descriptive abbreviations without punctuation, such as Jr or Sr. Used to match record to Employee. |
| Vaccination |
Yes |
|
Options: Y, N |
| Last Vaccination Date (MM/DD/ YYYY) |
Yes |
|
If ‘Vaccination Status’ is ‘Y’: REQUIRED; this is the date of the last vaccination received for the Employee. Format must include forward slashes - examples: 12/21/2021, 01/12/2022 |
| File Name |
Yes |
|
If ‘Vaccination Status’ is ‘Y’: REQUIRED; name of file, including extension (e.g. ‘example.pdf’) |