USER_ORG_ROLE
The User Organization Role table records a user’s organization role.
|
Columns |
Type |
Length |
Description |
|
ID |
numeric |
19 |
A 10-digit identifier of the User Organization Role record. |
|
TENANT_ID |
navchar |
255 |
The tenant ID of the user |
|
LASTUPDATED |
datetime |
|
The date and time the schema was last updated. |
|
USER_ID |
number |
19 |
The user ID of a user. The USER_ID is a foreign key to the USER_DIMENSION table. |
|
ORG_ID |
numeric |
19 |
The organization ID of a user. The ORG_ID is a foreign key to the ORG_UNIT_DIMENSION table. |
|
ROLE_ID |
numeric |
19 |
The user role ID. |
|
ROLE_NAME |
navchar |
255 |
The user role name. |