Lk_User_Role_Type
Controlled vocabulary to categorize the user role.
Columns
| Name | Type | Description | Foreign Key |
|---|---|---|---|
| name | varchar(2) | Name or identifier | |
| description | varchar(1000) | Free text to expand upon details |
Indexes
| Name | Column | Description |
|---|---|---|
| PRIMARY | name | BTREE |
Tables that Reference this Table
| Name | Column | Table Reference | Column Reference |
|---|---|---|---|
| contract_grant_2_personnel | role_type | lk_user_role_type | name |
| program_2_personnel | role_type | lk_user_role_type | name |
Values
| name | description |
|---|---|
| DU | DAIT user oversees specific grants/contract that use ImmPort. He/she will notifies the DAIT BISC PO when new research grants/contracts are awarded |
| FA | ImmPort Functional Administrator |
| OS | Other Staff |
| PI | Principal Investigator of contract/grants |
| PM | Project Manager (New Role for DAIT-Funded) |
| PO | DAIT BISC Project Officer oversees the BISC II project. He/she performs system access control functions and/or delegates them to other DAIT employess for a Functional Administrator. |
| SA | ImmPort System Administrator |