Share this page

# Step 4: Populate the Resource Interface Table

Using SQL*Loader, your favorite tool, or direct Oracle database-to-database communication, load your data into the required input columns in the following table.

- RSC_RESOURCES_INT

See Table 2-3. RSC_RESOURCES_INT interface table.

Caution: The source data is not validated during import.

Table 2-3. RSC_RESOURCES_INT interface table
Column | Usage | Data Type | Description
--- | --- | --- | ---
TRANSACTION_ID | Optional | Number | Uniquely identifies each transaction. Initialized when interface loading start
PARENT_TRANSACTION_ID | Optional | 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 | Optional | Varchar2(30) | Identifies the table associated with this entity.
GROUP_ID | Required | 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 | Optional | Varchar2(1) | Indicates whether or not the user already exists.
PROCESS_PHASE | Optional | Number | Indicates the current stage of the record as it is being processed.
PROCESS_STATUS | Optional | Number | Indicates the current disposition of the record.
CREATED_BY | Optional | 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 | Optional | 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 | Optional | Date | Indicates the transaction date. If left blank, the current date is used.
DEST_CREATED_BY | Optional | 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 | Optional | Date | Indicates the date the record is created in the destination (PPM instance). If left blank, the value is derived from CREATION_DATE.
DEST_LAST_UPDATED_BY | Optional | 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 | Optional | Date | Indicates the date that the user data was last updated. If left blank, the current date is used.
DEST_ENTITY_UPD_DATE | Optional | Date | Indicates the date that the user data was last updated. If left blank, the current date is used.
SOURCE_TYPE_CODE | Optional | Varchar2(30) | Specifies the type of external update. It is initialized when interface loading starts.
SOURCE | Optional | 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 | Required | 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 | Required | 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 | Optional | Number | Id of the resource derived from RSC_RESOURCES. This Id refers to the RESOURCE_ID column.
USER_ID | Optional | Number | Identifies the user. Derived from valid username or LOGON_IDENTIFIER.
PRIMARY_ROLE_ID | Optional | Number | Derived by valid PRIMARY_ROLE_NAME.
PRIMARY_ROLE_NAME | Required | Varchar2(200) | Existing role name in PPM.
TIME_SHEET_POLICY_ID | Optional | Number | Derived from valid TIME_SHEET_POLICY_NAME.
TIME_SHEET_POLICY_NAME | Required | Varchar2(200) | Existing time sheet policy name in PPM.
TM_APPROVER_ID | Optional | Number | Derived from valid TM_APPROVER_USERNAME or TM_APPROVER_IDENT
TM_APPROVER_USERNAME | Optional | 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 | Optional | 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 | Optional | Number | Derived from valid TM_BILLING_APPROVER_USERNAME or TM_BILLING_APPROVER_IDENT.
TM_BILLING_APPROVER_USERNAME | Optional | 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 | Optional | 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 | Optional | char | Indicates if the time management is enabled for this resource.
TM_NOTIFS_ENABLED_FLAG | Optional | char | Indicates if this resource should receive time management notifications.
TIME_SHEET_APPROVER_SEC_GRP_ID | Optional | Number | Derived by correct TM_APPROVER_SEC_GRP_NAME
TM_APPROVER_SEC_GRP_NAME | Optional | Varchar2(200) | Existing security group name in PPM.
BILLING_APPROVER_SEC_GRP_ID | Optional | Number | Derived from valid BILLING_APPROVER_SEC_GRP_NAME.
BILLING_APPROVER_SEC_GRP_NAME | Optional | Varchar2(200) | Existing security group name in PPM.
USER_DATA(N) | Optional | Varchar2(200) | User data segment. N is 1 to 100.
VISIBLE_USERDATA(N) | Optional | Varchar2(200) | User data segment. N is 1 to 100

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: