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 |
