DIM_RESOURCES

This table stores all resources from PPM.

Foreign Keys

Primary Key Table	Primary Key Column	Foreign Key Column
DIM_PERSON	PERSON_ID	PK_PERSON_ID
DIM_PERSON	TIME_APPROVER_ID	PK_PERSON_ID
DIM_PERSON	BILLING_APPROVER_ID	PK_PERSON_ID
DIM_ ROLES	PRIMARY_ROLE_ID	PK_ROLES _ID

Column Descriptions

Column Name	Null?	Data Type	Description	SCD2
PK_RESOURCES_ID	NOT NULL	INT	System-generated identifier	No
MD_BUSINESS_KEY	NOT NULL	VARCHAR(1000)	Primary key that is mapped to one or more source columns	No
MD_ENTERPRISE_KEY	NOT NULL	INT	Unique identifier for entity	No
PERSON_ID	NULLABLE	INT	Unique identifier for person	No
PRSON_BUSINESS_KEY	NULLABLE	VARCHAR(1000)	Foreign key that is mapped to DIM_PERSON	No
PERSON_ENTERPRISE_KEY	NULLABLE	INT	Unique identifier for foreign key	No
UNNAMED_LABEL	NULLABLE	VARCHAR(255)	This column is used when an unnamed headcount is created from the resource pool.	Yes
MSP_UID	NULLABLE	INT	This is the ID to integrate with Microsoft Project. Every resource assigned to a project has a MSP_UID. This is generated by Microsoft Project.	No
PRIMARY_ROLE_ID	NULLABLE	INT	Unique identifier for primary role	Yes
PRIMARY_ROLE_BUSINESS_KEY	NULLABLE	VARCHAR(1000)	Foreign key that is mapped to DIM_ROLES	No
PRIMARY_ROLE_ENTERPRISE_KEY	NULLABLE	INT	Unique identifier for foreign key	No
USER_DATA1-90	NULLABLE	VARCHAR(255)	User data segment	No
VISIBLE_USER_DATA1-90	NULLABLE	VARCHAR(255)	User data segment	No
TIME_SHEET_POLICY_ID	NULLABLE	INT	This is a foreign key to specify what time sheet policy the resource is using	No
POLICY_NAME	NULLABLE	VARCHAR(80)	Policy name	No
TIME_APPROVER_USER_ID	NULLABLE	INT	Unique identifier for the user who is the time sheet approver.	No
TIME_APPROVER _BUSINESS_KEY	NULLABLE	VARCHAR(1000)	Foreign key that is mapped to DIM_PERSON	No
TIME_APPROVER _ENTERPRISE_KEY	NULLABLE	INT	Unique identifier for foreign key	No
TIME_APPROVER_USER_NAME	NULLABLE	VARCHAR(200)	The user name of the time approver	No
BILLING_APPROVER_USER_ID	NULLABLE	INT	Unique identifier for the user who is the time sheet approver	No
BILLING_APPROVER_BUSINESS_KEY	NULLABLE	VARCHAR(1000)	Foreign key that is mapped to DIM_PERSON	No
BILLING_APPROVER_ENTERPRISE_KEY	NULLABLE	INT	Unique identifier for foreign key	No
BILLING_APPROVER_USER_NAME	NULLABLE	VARCHAR(200)	The user name of billing approver	No
TM_ENABLED_FLAG	NULLABLE	VARCHAR(1)	Indicates whether the time management is enabled for this resource	Yes
TM_NOTIFS_ENABLED_FLAG	NULLABLE	VARCHAR(1)	Indicates whether this resource should receive time management notifications	Yes
TIME_SHEET_APPROVER_SEC_GRP_ID	NULLABLE	INT	Indicates the security group that can approve time sheets for this resource	No
TIME_SHEET_SECURITY_GROUP_NAME	NULLABLE	VARCHAR(200)	Time sheet approver security group name	No
BILLING_APPROVER_SEC_GRP_ID	NULLABLE	INT	Indicates the security group that can approve the billing of the time resource	No
BILLING_SECURITY_GROUP_NAME	NULLABLE	VARCHAR(200)	Billing approver security group name	No
MSP_EUID	NULLABLE	INT	Enterprise unique ID of this resource from Microsoft Project Server. This is used for integrating PPM Center with single Microsoft Project Server.	No
MSP_CUID	NULLABLE	INT	Custom unique ID of this resource from Microsoft Project Server. This is used for integrating PPM Center with multiple Microsoft Project Server.	No
USER_DATA91-100	NULLABLE	VARCHAR(2000)	User data segment	No
VISIBLE_USER_DATA91-100	NULLABLE	VARCHAR(2000)	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
RESOURCES_ENTERPRISE_XREF_SEQ	MD_ENTERPRISE_KEY
RESOURCES_KEY_LOOKUP_SEQ	PK_ RESOURCES_ID
PERSON_ENTERPRISE_XREF_SEQ	PERSON_ENTERPRISE_KEY
PERSON_KEY_LOOKUP_SEQ	PERSON_ID
ROLES_ENTERPRISE_XREF_SEQ	PRIMARY_ROLE_BUSINESS_KEY
ROLES_KEY_LOOKUP_SEQ	ROLE_ID