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.

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