Share this page

# 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

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: