Share this page

# RPT_DIM_RM_RESOURCES

This is a materialized view over PPM's RSC_RESOURCES, KNTA_USERS, KRSC_ORG_UNITS, RSC_ROLES, and so on. This is one of the dimensional tables in RM star schema.

## Foreign Keys

This table does not have any foreign keys.

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
RESOURCE_ID | NULLABLE | NUMBER | RESOURCE_ID derived from PPM's RSC_RESOURCES table
USER_NAME | NULLABLE | VARCHAR2(200) | USER_NAME is the resource's username that is derived from KNTA_USERS table
FIRST_NAME | NULLABLE | VARCHAR2(80) | FIRST_NAME is the resource's first name that is derived from KNTA_USERS table
LAST_NAME | NULLABLE | VARCHAR2(80) | LAST_NAME is the resource's last name that is derived from KNTA_USERS table
EMAIL_ADDRESS | NULLABLE | VARCHAR2(80) | EMAIL_ADDRESS is the resource's email address that is derived from KNTA_USERS table
PHONE_NUMBER | NULLABLE | VARCHAR2(30) | PHONE_NUMBER is the resource's phone number that is derived from KNTA_USERS table
LOCATION_CODE | NULLABLE | VARCHAR2(150) | LOCATION_CODE contains the meaning of resource's location from knta_lookups
RESOURCE_CATEGORY | NULLABLE | VARCHAR2(150) | RESOURCE_CATEGORY contains the meaning of resource's category from knta_lookups
DEPARTMENT | NULLABLE | VARCHAR2(150) | DEPARTMENT contains the meaning of resource's department from knta_lookups
COMPANY | NULLABLE | VARCHAR2(150) | COMPANY contains the meaning of resource's company from knta_lookups
TITLE | NULLABLE | VARCHAR2(150) | TITLE contains the meaning of resource's title from knta_lookups
ROLE_NAME | NULLABLE | VARCHAR2(260) | Resource's role name, denormalized.
PRIMARY_ROLE_ID | NULLABLE | NUMBER | Primary role ID of this resource. PPM just supports one role per resource in the application, although it says primary.
REGION_ID | NULLABLE | NUMBER | Region to which this resource is associated to
CALENDAR_NAME | NULLABLE | VARCHAR2(100) | Name of the regional calendar (the calendar that is associated to resource's region)
START_DATE | NULLABLE | DATE | Start date for the resource. This is a required field for any resource in the system.
END_DATE | NULLABLE | DATE | End date of a resource and this is not a required field.
MANAGER_ID | NULLABLE | NUMBER | USER_ID of the resource's direct manager
MANAGER_FIRST_NAME | NULLABLE | VARCHAR2(80) | Direct manager's first name
MANAGER_LAST_NAME | NULLABLE | VARCHAR2(80) | Direct manager's last name
LEVEL1_MANAGER_ID | NULLABLE | VARCHAR2(4000) | USER_ID of top level manager of this resource
LEVEL1_MANAGER_FIRST_NAME | NULLABLE | VARCHAR2(4000) | FIRST_NAME of top level manager of this resource
LEVEL1_MANAGER_LAST_NAME | NULLABLE | VARCHAR2(4000) | LAST_NAME of top level manager of this resource
LEVEL2_MANAGER_ID | NULLABLE | VARCHAR2(4000) | USER_ID of level 2 manager of this resource
LEVEL2_MANAGER_FIRST_NAME | NULLABLE | VARCHAR2(4000) | FIRST_NAME of level 2 manager of this resource
LEVEL2_MANAGER_LAST_NAME | NULLABLE | VARCHAR2(4000) | LAST_NAME of level 2 manager of this resource
LEVEL3_MANAGER_ID | NULLABLE | VARCHAR2(4000) | USER_ID of level 3 manager of this resource
LEVEL3_MANAGER_FIRST_NAME | NULLABLE | VARCHAR2(4000) | FIRST_NAME of level 3 manager of this resource
LEVEL3_MANAGER_LAST_NAME | NULLABLE | VARCHAR2(4000) | LAST_NAME of level 3 manager of this resource
LEVEL4_MANAGER_ID | NULLABLE | VARCHAR2(4000) | USER_ID of level 4 manager of this resource
LEVEL4_MANAGER_FIRST_NAME | NULLABLE | VARCHAR2(4000) | FIRST_NAME of level 4 manager of this resource
LEVEL4_MANAGER_LAST_NAME | NULLABLE | VARCHAR2(4000) | LAST_NAME of level 4 manager of this resource
LEVEL5_MANAGER_ID | NULLABLE | VARCHAR2(4000) | USER_ID of level 5 manager of this resource
LEVEL5_MANAGER_FIRST_NAME | NULLABLE | VARCHAR2(4000) | FIRST_NAME of level 5 manager of this resource
LEVEL5_MANAGER_LAST_NAME | NULLABLE | VARCHAR2(4000) | LAST_NAME of level 5 manager of this resource
LEVEL6_MANAGER_ID | NULLABLE | VARCHAR2(4000) | USER_ID of level 6 manager of this resource
LEVEL6_MANAGER_FIRST_NAME | NULLABLE | VARCHAR2(4000) | FIRST_NAME of level 6 manager of this resource
LEVEL6_MANAGER_LAST_NAME | NULLABLE | VARCHAR2(4000) | LAST_NAME of level 6 manager of this resource
LEVEL7_MANAGER_ID | NULLABLE | VARCHAR2(4000) | USER_ID of level 7 manager of this resource
LEVEL7_MANAGER_FIRST_NAME | NULLABLE | VARCHAR2(4000) | FIRST_NAME of level 7 manager of this resource
LEVEL7_MANAGER_LAST_NAME | NULLABLE | VARCHAR2(4000) | LAST_NAME of level 7 manager of this resource
LEVEL8_MANAGER_ID | NULLABLE | VARCHAR2(4000) | USER_ID of level 8 manager of this resource
LEVEL8_MANAGER_FIRST_NAME | NULLABLE | VARCHAR2(4000) | FIRST_NAME of level 8 manager of this resource
LEVEL8_MANAGER_LAST_NAME | NULLABLE | VARCHAR2(4000) | LAST_NAME of level 8 manager of this resource
LEVEL9_MANAGER_ID | NULLABLE | VARCHAR2(4000) | USER_ID of level 9 manager of this resource
LEVEL9_MANAGER_FIRST_NAME | NULLABLE | VARCHAR2(4000) | FIRST_NAME of level 9 manager of this resource
LEVEL9_MANAGER_LAST_NAME | NULLABLE | VARCHAR2(4000) | LAST_NAME of level 9 manager of this resource
LEVEL10_MANAGER_ID | NULLABLE | VARCHAR2(4000) | USER_ID of level 10 manager of this resource
LEVEL10_MANAGER_FIRST_NAME | NULLABLE | VARCHAR2(4000) | FIRST_NAME of level 10 manager of this resource
LEVEL10_MANAGER_LAST_NAME | NULLABLE | VARCHAR2(4000) | LAST_NAME of level 10 manager of this resource
PRIMARY_ORG_UNIT_ID | NULLABLE | NUMBER | Resource's primary org unit
NAMED_RESOURCE_FLAG | NULLABLE | VARCHAR2(1) | Flag to indicate if this resource is a named or unnamed resource
TM_APPROVER | NULLABLE | VARCHAR2(4000) | Username of this resource's time approver
TM_APPROVER_SEC_GRP | NULLABLE | VARCHAR2(4000) | The security group name who can approve the time sheet
TM_BILLING_APPROVER | NULLABLE | VARCHAR2(4000) | Username of this resource's billing approver
TM_BILLING_APPROVER_SEC_GRP | NULLABLE | VARCHAR2(4000) | The security group name for resource's billing approvals
USER_DATA1-20 | NULLABLE | VARCHAR2(200) | User data segment
VISIBLE_USER_DATA1-20 | NULLABLE | VARCHAR2(200) | User data segment

## Indexes

This table uses no indexes.

## Sequences

This table uses no sequences.

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: