The Personalization module uses the following tables to store information about the organizations and roles that make up a user directory. The tables shown here correspond to external users. A parallel set of tables, with the prefix dpi, exists for internal users.
dps_child_folder
This table stores a list of a role folder’s child folders.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier for this role folder. References | |
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier for the child folder. References |
dps_folder
This table stores information that defines a folder in the user directory.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier for this folder. | |
| INT | NOT NULL |
Identifies the type of folder. Values can be as follows: | ||
| WVARCHAR(254) | NOT NULL |
The user-specified name for this folder. | ||
| VARCHAR(40) | NULL |
The ID of this folder’s parent folder. References | ||
| WVARCHAR(254) | NULL |
The user-specified description for this folder. |
dps_organization
This table stores information that defines a user directory organization.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier for this organization. | |
| WVARCHAR(254) | NOT NULL |
The user-specified name for this organization. | ||
| WVARCHAR(254) | NULL |
The user-specified description for this organization. | ||
| VARCHAR(40) | NULL |
The ID of this organization’s parent organization. References |
dps_org_ancestors
This table stores a list of an organization’s ancestor organizations.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier of this organization. References | |
| INT | NOT NULL |
(primary key) | The index of this ancestor organization in the list. | |
| VARCHAR(40) | NOT NULL |
The unique identifier of the ancestor organization. References |
dps_org_chldorg
This table stores a list of an organization’s child organizations.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier for this organization. References | |
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier for the child organization. References |
dps_org_role
This table stores a list of roles assigned to an organization.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier for this organization. References | |
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier of the role. References |
dps_relativerole
This table stores information that defines an organizational role.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The ID of this organizational role. References | |
| WVARCHAR(40) | NOT NULL |
The value of the | ||
| VARCHAR(40) | NOT NULL |
The organization to which this role is relative. References |
dps_role
This table stores information that defines a global or organizational role.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The ID of this role. | |
| INT | NOT NULL |
The type of role. The value can be 2000 (global role) or 2001 (organizational role). | ||
| INT | NOT NULL |
The revision number for this role. | ||
| WVARCHAR(254) | NOT NULL ) |
The user-specified name for this role. | ||
| WVARCHAR(254) | NULL |
The user-specified description for this role. |
dps_rolefold_chld
This table stores a list of the global roles in a role folder.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The ID of this role folder. References | |
| VARCHAR(40 | NOT NULL |
(primary key) | The ID of this role. References |
dps_role_rel_org
This table stores a list of the organizational roles assigned to an organization.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier for this organization. References | |
| INT | NOT NULL |
(primary key) | The index of this organizational role in the list. | |
| VARCHAR(40) | NOT NULL |
The unique identifier for this organizational role. References |
dps_user_org
This table stores a list of the users who are assigned to an organization.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier for this organization. References | |
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier for the user assigned to the organization. References |
dps_user_org_anc
This table stores a list of a user’s ancestor organizations.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier of this user. References | |
| INT | NOT NULL |
(primary key) | The index of this ancestor organization in the user’s list. | |
| VARCHAR(40) | NOT NULL |
The unique identifier of the ancestor organization. References |
dps_user_roles
This table extends the user profile to include references to roles assigned to this user.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier for this user. References | |
| VARCHAR(40) | NOT NULL |
(primary key) | A role assigned to this user. References |