TRANSACTION_ID

I

Number

Uniquely identifies each transaction.

Initialized when interface loading start

PARENT_TRANSACTION_ID

I

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

I

Varchar2(30)

Identifies the table associated with this entity.

GROUP_ID

I

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

O

Varchar2(1)

Indicates whether or not the user already exists.

PROCESS_PHASE

O

Number

Indicates the current stage of the record as it is being processed.

PROCESS_STATUS

O

Number

Indicates the current disposition of the record.

CREATED_BY

I/O

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

I/O

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

I/O

Date

Indicates the transaction date.

If left blank, the current date is used.

DEST_CREATED_BY

I/O

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

I/O

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

I/O

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

I/O

Date

Indicates the date that the user data was last updated.

If left blank, the current date is used.

DEST_ENTITY_UPD_DATE

I/O

Date

Indicates the date that the user data was last updated.

If left blank, the current date is used.

SOURCE_TYPE_CODE

I

Varchar2(30)

Specifies the type of external update.

It is initialized when interface loading starts.

SOURCE

I

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

I

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

I

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

O

Number

Id of the resource derived from RSC_RESOURCES. This Id refers to the RESOURCE_ID column.

USER_ID

O

Number

Identifies the user.

Derived from valid username or LOGON_IDENTIFIER.

PRIMARY_ROLE_ID

O

Number    

Derived by valid PRIMARY_ROLE_NAME.

PRIMARY_ROLE_NAME

I

Varchar2(200)        

Existing role name in PPM.

TIME_SHEET_POLICY_ID

O

Number    

Derived from valid
TIME_SHEET_POLICY_NAME.    

TIME_SHEET_POLICY_NAME

I

Varchar2(200)

Existing time sheet policy name in PPM.

TM_APPROVER_ID

O

Number

Derived from valid TM_APPROVER_USERNAME or TM_APPROVER_IDENT

TM_APPROVER_USERNAME

I

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

I

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

O

Number

Derived from valid TM_BILLING_APPROVER_USERNAME or TM_BILLING_APPROVER_IDENT.

TM_BILLING_APPROVER_USERNAME

I

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

I

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

I

char

Indicates if the time management is enabled for this resource.

TM_NOTIFS_ENABLED_FLAG

I

char

Indicates if this resource should receive time management notifications.

TIME_SHEET_APPROVER_SEC_GRP_ID

O

Number

Derived by correct TM_APPROVER_SEC_GRP_NAME

TM_APPROVER_SEC_GRP_NAME

I

Varchar2(200)

Existing security group name in PPM.

BILLING_APPROVER_SEC_GRP_ID

O

Number

Derived from valid BILLING_APPROVER_SEC_GRP_NAME.

BILLING_APPROVER_SEC_GRP_NAME

I

Varchar2(200)

Existing security group name in PPM.

USER_DATA(N)

I

Varchar2(200)

User data segment.

N is 1 to 100.

VISIBLE_USERDATA(N)

I

Varchar2(200)

User data segment.

N is 1 to 100