Share this page

# 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.

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: