Step 2: Populate the Interface Tables

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

See Table 3-1. KRSC_ORG_UNITS_INT interface table and Table 3-2. KRSC_ORG_UNIT_MEMBERS_INT interface table.

Caution: User data is not validated during import.

Table 3-1. KRSC_ORG_UNITS_INT interface table

Column

Usage

Data Type

Description

TRANSACTION_ID

Required

NUMBER

Uniquely identifies each transaction.

DATA_LANG

I

VARCHAR2

Specifies the language of the data being imported, so it can be properly validated in the respective language.

If no value is provided, then the language context is the same as the system language of the PPM instance into which the data is being imported.

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.

EXISTS_FLAG

Optional

VARCHAR2

Indicates whether or not the organization unit already exists.

PROCESS_PHASE

Optional

NUMBER

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

See Process State Information for details.

PROCESS_STATUS

Optional

NUMBER

Indicates the current disposition of the record.

See Process State Information for details.

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

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.

Ig 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 set to the user currently running the report.

DEST_LAST_UPDATE_DATE

Optional

DATE

Indicates the date that the organization data was last updated.

If left blank, the current date is used.

DEST_ENTITY_UPD_DATE

Optional

DATE

Indicates the date that either the organization or membership data was last updated.

If left blank, the current date is used.

SOURCE

Required

VARCHAR2

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.

SOURCE_TYPE_CODE

Required

VARCHAR2

Specifies the type of external update.

This should be a specific interface or migrator name, left blank, or have a value of INTERFACE_WF.

ORG_UNIT_ID

Optional

NUMBER

Identifies the organization unit ID.

For new organization units, the value is derived from the KRSC_ORG_UNITS_S sequence.

For existing organization units, if left blank, the value is derived from ORG_UNIT_NAME.

ORG_UNIT_NAME

Required

VARCHAR2

Identifies the organization unit name.

PARENT_ORG_UNIT_ID

Optional

NUMBER

Identifies the parent unit ID for the organization unit.

If left blank, the value is derived from PARENT_ORG_UNIT_NAME.

PARENT_ORG_UNIT_NAME

Required

VARCHAR2

Identifies the parent unit name for the organization unit.

If left blank, then the organization unit appears as a top level unit in the organization model.

MANAGER_ID

Optional

NUMBER

Identifies the manager associated with the organization unit.

If left blank, the value is derived from MANAGER_USERNAME.

MANAGER_USERNAME

Required

VARCHAR2

Specifies the name of the manager.

MANAGER_LOGON_IDENTIFIER

Required

VARCHAR2

Specifies the ID of the manager.

Depends on the LOGON_METHOD setting in the server.conf file. If LOGON_METHOD = LOGON_ID, the MANAGER_LOGON_IDENTIFIER column must be populated. Otherwise, the MANAGER_USERNAME column must be populated.

DEPARTMENT_CODE

Optional

VARCHAR2

Specifies the code for the department.

DEPARTMENT_MEANING

Required

VARCHAR2

Specifies the description of the department.

LOCATION_CODE

Optional

VARCHAR2

Specifies the code for the location.

LOCATION_MEANING

Required

VARCHAR2

Specifies the description of the location.

CATEGORY_CODE

Optional

VARCHAR2

Specifies the code for the category.

CATEGORY_MEANING

Required

VARCHAR2

Specifies the description of the category.

ENABLED_FLAG

Optional

VARCHAR2

Indicates whether or not the organization unit is enabled upon import.

USER_DATA_SET_CONTEXT_ID

Required

NUMBER

Sets the context identifier for the USER_DATA fields.

Supply this or ORG_UNIT_USERNAME.

DISTINGUISH_NAME

Required

VARCHAR2

Specifies the distinguished name for the organization unit in the following format:

OU=>SubOU1=>SubSubOU1

OU=>SubOU2

PARENT_DISTINGUISH_NAME

Required

VARCHAR2

Specifies the distinguished name for the parent organization unit in the following format:

OU=>SubOU1

OU

USER_DATA1

VISIBLE_USER_DATA1

through

USER_DATA20

VISIBLE_USER_DATA20

Required

VARCHAR2

Specifies the user-defined fields attached to the user screen.

This is required only if user data is defined.

This information is not validated nor does it have a default value.
Table 3-2. KRSC_ORG_UNIT_MEMBERS_INT interface table

Column

Usage

Data Type

Description

TRANSACTION_ID

I

NUMBER

Uniquely identifies each transaction.

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.

EXISTS_FLAG

O

VARCHAR2

Indicates whether or not the organization unit already exists.

PROCESS_PHASE

O

NUMBER

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

See Process State Information for details.

PROCESS_STATUS

O

NUMBER

Indicates the current disposition of the record.

See Process State Information for details.

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

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

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 membership data was last updated.

If left blank, the current date is used.

DEST_ENTITY_UPD_DATE

I/O

DATE

Indicates the date that either the organization or membership data was last updated.

If left blank, the current date is used.

SOURCE

I

VARCHAR2

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.

SOURCE_TYPE_CODE

I

VARCHAR2

Specifies the type of external update.

This should be a specific interface or migrator name, left blank, or have a value of INTERFACE_WF.

ORG_UNIT_MEMBER_ID

I/O

NUMBER

Identifies the organization unit member.

This is normally left blank and is derived from the KRSC_ORG_UNIT_MEMBER_S sequence.

ORG_UNIT_ID

I/O

NUMBER

Identifies the organization unit ID.

This is normally left blank and is derived from KRSC_ORG_UNITS.

ORG_UNIT_NAME

I

VARCHAR2

Identifies the parent unit name for the organization unit.

USER_ID

I/O

NUMBER

Identifies the user.

For existing users, this refers to the USER_ID column in KNTA_USERS.

This is normally left blank and is derived from the KNTA_USERS_S sequence.

USERNAME

I

VARCHAR2

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 for the user import. Otherwise, populate the LOGON_ID column.

LOGON_IDENTIFIER

I

VARCHAR2

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_ID column must be populated. Otherwise, populate the USERNAME column.

ORG_UNIT_DISTINGUISH_NAME

I

VARCHAR2

Specifies the distinguished name for the organization unit.