Access-Level Tables
Access-level tables are created when the Access Authority page is saved. Three access-level tables are available: Level 1, Level 2, and Level 3.
When you create the Level 1 table, the employee ID at the top of the page (Emp ID 1) is associated with all employee IDs that are in the grid (Emp ID 2).
Example of Access-Level Tables
This example displays how employee PI001 (Emp ID 1) is associated with employees EM001 and EM002 (Emp ID 2).
Level 1 table:
| Assigned By Employee ID | Employee ID |
|---|---|
|
PI001 |
PI001 |
|
PI001 |
EM001 |
|
PI001 |
EM002 |
The level 1 table populates the level 2 and level 3 tables. The level 2 table is used to access awards through the portal.
Level 2 table - Award:
| Employee ID | Award ID |
|---|---|
|
PI001 |
CON021 |
|
PI001 |
CON022 |
|
PI001 |
CON023 |
|
EM001 |
CON021 |
|
EM001 |
CON022 |
|
EM001 |
CON023 |
|
EM002 |
CON021 |
|
EM002 |
CON022 |
|
EM002 |
CON023 |
The level 3 table is used to access projects through the portal.
Level 3 table - Project:
| Employee ID | Project ID |
|---|---|
|
PI001 |
PROJ115 |
|
PI001 |
PROJ116 |
|
PI001 |
PROJ117 |
|
EM001 |
PROJ115 |
|
EM001 |
PROJ116 |
|
EM001 |
PROJ117 |
|
EM002 |
PROJ115 |
|
EM002 |
PROJ116 |
|
EM002 |
PROJ117 |