KRSC_ORG_UNIT_MEMBERS_INT

This table corresponds to the KRSC_ORG_UNIT_MEMBERS table. This table is used by the organization unit open interface to import organization units (and their members) into PPM Center from an external data source.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KRSC_ORG_UNIT_MEMBERS

ORG_UNIT_MEMBER_ID

ORG_UNIT_MEMBER_ID

KNTA_USERS

USER_ID

CREATED_BY

KRSC_ORG_UNITS_NLS

ORG_UNIT_ID

ORG_UNIT_ID

KRSC_ORG_UNITS_INT

GROUP_ID

GROUP_ID

KNTA_USERS

USER_ID

USER_ID

KRSC_ORG_UNIT_MEMBERS_INT

GROUP_ID

GROUP_ID

Column Descriptions

Column Name

Null?

Data Type

Description

TRANSACTION_ID

NULLABLE

NUMBER

System-generated identifier

GROUP_ID

NULLABLE

NUMBER

This value is used to tie records in the interface tables together. Most of database processing is done based on this value.

EXISTS_FLAG

NULLABLE

VARCHAR2(1)

Used to indicate if the Organization Unit Member already exists in the system

PROCESS_PHASE

NULLABLE

NUMBER

Indicates which phase a record is at: Pending, Deriving, Validating, Importing or Completed.

PROCESS_STATUS

NULLABLE

NUMBER

Indicates the current status of the interface record: Pending, In Progress, Errored or Completed.

CREATED_BY

NULLABLE

NUMBER

Identifier for the user who created the record

CREATED_BY_USERNAME

NULLABLE

VARCHAR2(200)

Username for Identifier for the user who created the record

CREATION_DATE

NULLABLE

DATE

Date record was created

DEST_CREATED_BY

NULLABLE

NUMBER

USER_ID from the KNTA_USERS table for Identifier for the user who is performing the transaction. If null, the column is derived from CREATED_BY_USERNAME or set to the user currently running the report

DEST_CREATION_DATE

NULLABLE

DATE

Date that the transaction is performed.

DEST_LAST_UPDATED_BY

NULLABLE

NUMBER

USER_ID from the KNTA_USERS table for Identifier for the user who is performing the transaction. If null, the column is derived from CREATED_BY_USERNAME or set to the user currently running the report

DEST_LAST_UPDATE_DATE

NULLABLE

DATE

Date that the transaction is performed.

DEST_ENTITY_UPD_DATE

NULLABLE

DATE

Date that the transaction is performed.

SOURCE

NULLABLE

VARCHAR2(100)

For records that have been updated by an interface or migrator, provides additional information about the source of the external update.

SOURCE_TYPE_CODE

NULLABLE

VARCHAR2(30)

For records that have been updated by an interface or migrator, indicates the type of external update (specific interface or migrator name, and so on)

ORG_UNIT_MEMBER_ID

NULLABLE

NUMBER

ID of the Organization Unit Member to be added or updated.

ORG_UNIT_ID

NULLABLE

NUMBER

ID of the Organization Unit that the member is to be added to.

ORG_UNIT_NAME

NULLABLE

VARCHAR2(200)

Name of the Organization Unit that the member is to be added to.

USER_ID

NULLABLE

NUMBER

User ID of the member to be added to the Organization Unit.

USERNAME

NULLABLE

VARCHAR2(200)

Username of the member to be added to the Organization Unit.

LOGON_IDENTIFIER

NULLABLE

VARCHAR2(200)

LOGON_IDENTIFIER (in the KNTA_USERS table) of the member to be added to the Organization Unit.

DATA_LANG

NULLABLE

VARCHAR2(40)

This column defines the language of the data the user wants to import. This column is defined at the parent entity level so all the child entities assume the same language. The DB session language is set according to it when the Interface Code gets executed to get respective look up values.

ORG_UNIT_DISTINGUISH_NAME

NOT NULL

VARCHAR2(2000)

Specifies the full distinguished name for the organization unit.

Indexes

Index Name

Index Type

Sequence

Column Name

KRSC_ORG_UNIT_MEMBERS_INT_N2

NONUNIQUE

1

GROUP_ID

KRSC_ORG_UNIT_MEMBERS_INT_N2

NONUNIQUE

2

ORG_UNIT_NAME

KRSC_ORG_UNIT_MEMBERS_INT_U1

UNIQUE

1

TRANSACTION_ID

Sequences

This table uses no sequences.