Share this page

# DIM_ROLES

This table stores all the roles defined in the PPM system. Resources are associated with the roles.

## Foreign Keys

This table does not have any foreign keys.

## Column Descriptions

Column Name | Null? | Data Type | Description | SCD2
--- | --- | --- | --- | ---
PK_ROLES_ID | NOT NULL | INT | System-generated identifier | No
MD_BUSINESS_KEY | NULLABLE | VARCHAR(1000) | Primary key that is mapped to one or more source columns | No
MD_ENTERPRISE_KEY | NULLABLE | INT | Unique identifier for entity | No
ROLE_NAME | NULLABLE | VARCHAR(260) | Name given to this record | No
DESCRIPTION | NULLABLE | VARCHAR(650) | Text that describes this role | No
ENABLED_FLAG | NULLABLE | VARCHAR(1) | Flag to indicate if this role is enabled or not | Yes
PRIMARY_FLAG | NULLABLE | VARCHAR(1) | Indicates whether this role record is the primary role | Yes
USER_DATA1-20 | NULLABLE | VARCHAR(255) | User data segment | No
VISIBLE_USER_DATA1-20 | NULLABLE | VARCHAR(255) | User data segment | No
MD_BATCH_ID | NULLABLE | INT | ID of data batch | No
MD_PROCESS_ID | NULLABLE | INT | ID of ETL process running on a specific task | No
MD_SOURCE_INSTANCE_ID | NULLABLE | INT | Content pack ID of source instance | No
MD_CREATEDDATE | NULLABLE | DATETIME | Date of the record being inserted | No
MD_DELETEDDATE | NULLABLE | DATETIME | Date of the record being deleted | No
MD_LASTMODDATE | NULLABLE | DATETIME | Date of the record being updated | No
MD_TRANSLASTIND | NULLABLE | VARCHAR(1) | Flags whether it is the latest record after updated by SCD2 | No
MD_TRANSENDDATE | NULLABLE | DATETIME | End date of the record being effective | No
MD_ACTIVESTATUSIND | NULLABLE | VARCHAR(1) | Flags whether or not the old record is deleted | No
MD_HASH_CODE_SCD1 | NULLABLE | VARCHAR(40) | (Only for dimension table) Hash code that is generated by SCD1 columns | No
MD_HASH_CODE_SCD2 | NULLABLE | VARCHAR(40) | (Only for dimension table) Hash code that is generated by SCD2 columns | No

## Projections

This table uses no projections.

## Sequences

Sequence Name | Sequence Type
--- | ---
ROLES_ENTERPRISE_XREF_SEQ | MD_ENTERPRISE_KEY
ROLES_KEY_LOOKUP_SEQ | PK_ROLES_ID

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: