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. 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.