KRSC_ORG_UNIT_MEMBERS_INT

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.