Share this page

# RSC_RESOURCES_INT

This table is used to provide resource attributes for new or existing resources. It is also used to link the resources to various products in the PPM Center.

## Foreign Keys

This table does not have any foreign keys.

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
TRANSACTION_ID | NOT NULL | NUMBER | Uniquely identifies each transaction. Initialized when interface loading start
PARENT_TRANSACTION_ID | NOT NULL | NUMBER | Provides the transaction ID (from KNTA_USERS_INT) of the parent table being imported. If any child table is being used, set the TRANSACTION_ID in KNTA_USERS_INT to this value: KNTA_USERS_INT.TRANSACTION_ID
PARENT_TABLE_NAME | NULLABLE | VARCHAR2(30) | Identifies the table associated with this entity.
GROUP_ID | NULLABLE | NUMBER | Groups all the records that should be processed at the same time. Use only one GROUP_ID each time you run a report. Derived from the KNTA_INTERFACE_GROUPS_S sequence. This value should be the same as the parent's GROUP_ID in KNTA_USERS_INT.
EXISTS_FLAG | NULLABLE | VARCHAR2(1) | Indicates whether or not the user already exists
PROCESS_PHASE | NULLABLE | NUMBER | Indicates the current stage of the record as it is being processed
PROCESS_STATUS | NULLABLE | NUMBER | Indicates the current disposition of the record
CREATED_BY | NULLABLE | NUMBER | Identifies the USER_ID (from KNTA_USERS) for the user performing the transaction. If left blank, the value is derived from CREATED_BY_USERNAME.
CREATED_BY_USERNAME | NULLABLE | VARCHAR2(200) | Identifies the USERNAME (from KNTA_USERS) for the user performing the transaction. This is used only if CREATED_BY is left blank. If both are left blank, the value is set to the user currently running the report.
CREATION_DATE | NULLABLE | DATE | Indicates the transaction date. If left blank, the current date is used.
DEST_CREATED_BY | NULLABLE | NUMBER | Identifies the USER_ID (from KNTA_ USERS) for the user performing the transaction. If left blank, the value is derived from CREATED_BY_USERNAME. If both are left blank, the value is set to the user currently running the report.
DEST_CREATION_DATE | NULLABLE | DATE | Indicates the date the record is created in the destination (PPM Center instance). If left blank, the value is derived from CREATION_DATE.
DEST_LAST_UPDATED_BY | NULLABLE | NUMBER | Identifies the USER_ID (from KNTA_ USERS) for the user that last updated the data. If left blank, the value is set to the user currently running the report.
DEST_LAST_UPDATE_DATE | NULLABLE | DATE | Indicates the date that the user data was last updated. If left blank, the current date is used.
DEST_ENTITY_UPD_DATE | NULLABLE | DATE | Indicates the date that the user data was last updated. If left blank, the current date is used.
SOURCE_TYPE_CODE | NULLABLE | VARCHAR2(30) | Specifies the type of external update. It is initialized when interface loading starts.
SOURCE | NULLABLE | VARCHAR2(100) | Specifies the source of the information. This information is not validated during an import. For example, the name of the third-party application or a value of CONVERSION.
LOGON_IDENTIFIER | NULLABLE | VARCHAR2(200) | Identifies the ID used for the logon. The value should be a valid USERNAME in KNTA_USERS. Depends on the LOGON_METHOD setting in the server.conf file. If LOGON_METHOD = LOGON_ID, the LOGON_IDENTIFIER column must be populated. Otherwise, populate the USERNAME column.
USERNAME | NULLABLE | VARCHAR2(200) | Identifies the name used for the logon. The value should be a valid USERNAME in KNTA_USERS. Depends on the LOGON_METHOD setting in the server.conf file. If LOGON_METHOD = USER_NAME, the USERNAME column must be populated. Otherwise, populate the LOGON_IDENTIFIER column.
RESOURCE_ID | NULLABLE | NUMBER | ID of the resource derived from RSC_RESOURCES. This Id refers to the RESOURCE_ID column.
USER_ID | NULLABLE | NUMBER(19) | Identifies the user. Derived from valid username or LOGON_IDENTIFIER.
PRIMARY_ROLE_ID | NULLABLE | NUMBER(19) | Derived by valid PRIMARY_ROLE_NAME.
PRIMARY_ROLE_NAME | NULLABLE | VARCHAR2(200) | Existing role name in PPM Center.
TIME_SHEET_POLICY_ID | NULLABLE | NUMBER(19) | Derived from valid TIME_SHEET_POLICY_NAME.
TIME_SHEET_POLICY_NAME | NULLABLE | VARCHAR2(200) | Existing time sheet policy name in PPM Center.
TM_APPROVER_ID | NULLABLE | NUMBER(19) | Derived from valid TM_APPROVER_USERNAME or TM_APPROVER_IDENT
TM_APPROVER_USERNAME | NULLABLE | VARCHAR2(200) | Username of time sheet approver. Depends on the LOGON_METHOD setting in the server.conf file. If LOGON_METHOD = USER_NAME, the TM_APPROVER_USERNAME column must be populated for the user import. Otherwise, populate the TM_APPROVER_IDENT column.
TM_APPROVER_IDENT | NULLABLE | VARCHAR2(200) | LOGON_IDENTIFIER of time sheet approver. Depends on the LOGON_METHOD setting in the server.conf file. If LOGON_METHOD = LOGON_ID, this column should be populated. Otherwise, populate the TM_APPROVER_USERNAME column.
TM_BILLING_APPROVER_ID | NULLABLE | NUMBER(19) | Derived from valid TM_BILLING_APPROVER_USERNAME or TM_BILLING_APPROVER_IDENT.
TM_BILLING_APPROVER_USERNAME | NULLABLE | VARCHAR2(200) | Username of time sheet billing approver. Depends on the LOGON_METHOD setting in the server.conf file. If LOGON_METHOD = USER_NAME, the TM_BILLING_APPROVER_USERNAME column must be populated for the user import. Otherwise, populate the TM_BILLING_APPROVER_IDENT column.
TM_BILLING_APPROVER_IDENT | NULLABLE | VARCHAR2(200) | LOGON_IDENTIFIER of time sheet billing approver. Depends on the LOGON_METHOD setting in the server.conf file. If LOGON_METHOD = LOGON_ID, this column should be populated. Otherwise, populate the TM_BILLING_APPROVER_USERNAME column.
TM_ENABLED_FLAG | NULLABLE | VARCHAR2(1) | Indicates if the time management is enabled for this resource.
TM_NOTIFS_ENABLED_FLAG | NULLABLE | VARCHAR2(1) | Indicates if this resource should recieve time management notifications.
TM_APPROVER_SEC_GRP_NAME | NULLABLE | VARCHAR2(200) | Existing security group name in PPM Center.
BILLING_APPROVER_SEC_GRP_ID | NULLABLE | NUMBER | Derived from valid BILLING_APPROVER_SEC_GRP_NAME.
BILLING_APPROVER_SEC_GRP_NAME | NULLABLE | VARCHAR2(200) | Existing security group name in PPM Center.
UNNAMED_LABEL | NULLABLE | VARCHAR2(255) | This column is used when an unnamed headcount is created from the resource pool.
MSP_UID | NULLABLE | NUMBER | This is the ID to integrate with MS-Project. Every resource assigned to a project has a MSP_UID. This is generated by MS-Project.
MSP_EUID | NULLABLE | NUMBER | Enterprise unique ID of this resource from Microsoft Project Server. This is used for integrating PPM Center with single Microsoft Project Server.
MSP_CUID | NULLABLE | VARCHAR2(255) | Custom unique ID of this resource from Microsoft Project Server. This is used for integrating PPM Center with multiple Microsoft Project Server.
USER_DATA1-90 | NULLABLE | VARCHAR2(255) | User data segment.
VISIBLE_USER_DATA1-90 | NULLABLE | VARCHAR2(255) | Visible user data.
USER_DATA91-100 | NULLABLE | VARCHAR2(255) | User data segment.
VISIBLE_USER_DATA91-100 | NULLABLE | VARCHAR2(255) | Visible user data.

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
RSC_RESOURCES_INT_N1 | NONUNIQUE | 1 | USERNAME
RSC_RESOURCES_INT_N1 | NONUNIQUE | 2 | GROUP_ID
RSC_RESOURCES_INT_N2 | NONUNIQUE | 1 | LOGON_IDENTIFIER
RSC_RESOURCES_INT_N2 | NONUNIQUE | 2 | GROUP_ID
RSC_RESOURCES_INT_N3 | NONUNIQUE | 1 | USER_ID
RSC_RESOURCES_INT_N3 | NONUNIQUE | 2 | GROUP_ID
RSC_RESOURCES_INT_N4 | NONUNIQUE | 1 | USERNAME
RSC_RESOURCES_INT_N5 | NONUNIQUE | 1 | GROUP_ID
RSC_RESOURCES_INT_U1 | UNIQUE | 1 | TRANSACTION_ID

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