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 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

This table uses no projections.

Sequence Name	Sequence Type
ROLES_ENTERPRISE_XREF_SEQ	MD_ENTERPRISE_KEY
ROLES_KEY_LOOKUP_SEQ	PK_ROLES_ID