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.