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

Contnet 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