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 | Description |
---|---|---|---|
| VARCHAR(40) | NOT NULL | The unique identifier for this role folder. References |
| VARCHAR(40) | NOT NULL | 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 | Description |
---|---|---|---|
| VARCHAR(40) | NOT NULL | 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 | Description |
---|---|---|---|
| VARCHAR(40) | NOT NULL | 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 | Description |
---|---|---|---|
| VARCHAR(40) | NOT NULL | The unique identifier of this organization. References |
| INT | NOT NULL | 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 | Description |
---|---|---|---|
| VARCHAR(40) | NOT NULL | The unique identifier for this organization. References |
| VARCHAR(40) | NOT NULL | 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 | Description |
---|---|---|---|
| VARCHAR(40) | NOT NULL | The unique identifier for this organization. References |
| VARCHAR(40) | NOT NULL | The unique identifier of the role. References |
dps_relativerole
This table stores information that defines an organizational role.
Column | Data Type | Constraint | Description |
---|---|---|---|
| VARCHAR(40) | NOT NULL | 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 | Description |
---|---|---|---|
| VARCHAR(40) | NOT NULL | 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 | Description |
---|---|---|---|
| VARCHAR(40) | NOT NULL | The ID of this role folder. References |
| VARCHAR(40 | NOT NULL | 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 | Description |
---|---|---|---|
| VARCHAR(40) | NOT NULL | The unique identifier for this organization. References |
| INT | NOT NULL | 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 | Description |
---|---|---|---|
| VARCHAR(40) | NOT NULL | The unique identifier for this organization. References |
| VARCHAR(40) | NOT NULL | 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 | Description |
---|---|---|---|
| VARCHAR(40) | NOT NULL | The unique identifier of this user. References |
| INT | NOT NULL | 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 | Description |
---|---|---|---|
| VARCHAR(40) | NOT NULL | The unique identifier for this user. References |
| VARCHAR(40) | NOT NULL | A role assigned to this user. References |