Share this page

# KRSC_ORG_UNITS_INT

This table corresponds to the KRSC_ORG_UNITS table. This table is used by the organization unit open interface to import organization units into PPM Center from an external data source.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KNTA_USERS | USER_ID | CREATED_BY
KRSC_ORG_UNITS_INT | GROUP_ID | GROUP_ID
KRSC_ORG_UNIT_MEMBERS_INT | GROUP_ID | GROUP_ID
KNTA_USERS | USER_ID | MANAGER_ID
KRSC_ORG_UNITS_NLS | ORG_UNIT_ID | ORG_UNIT_ID
KRSC_ORG_UNITS_NLS | ORG_UNIT_ID | PARENT_ORG_UNIT_ID
KNTA_PARAMETER_SET_CONTEXTS | PARAMETER_SET_CONTEXT_ID | USER_DATA_SET_CONTEXT_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 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 corresponding to the 'CREATED_BY' column
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_ID | NULLABLE | NUMBER | ID of the organization unit to be added or updated
ORG_UNIT_NAME | NULLABLE | VARCHAR2(200) | Name of the Organization Unit to be added or updated.
PARENT_ORG_UNIT_ID | NULLABLE | NUMBER | ID of the parent organization unit to be imported if it has a parent.
PARENT_ORG_UNIT_NAME | NULLABLE | VARCHAR2(200) | Name of the parent Organization Unit to be imported if it has a parent
MANAGER_ID | NULLABLE | NUMBER | User ID of the manager of this organization unit
MANAGER_USERNAME | NULLABLE | VARCHAR2(200) | Username of the manager of this organization unit
MANAGER_LOGON_IDENTIFIER | NULLABLE | VARCHAR2(200) | Logon identifier (from the KNTA_USERS table) of the manager of this organization unit
DEPARTMENT_CODE | NULLABLE | VARCHAR2(30) | Lookup code for 'DEPT'
DEPARTMENT_MEANING | NULLABLE | VARCHAR2(80) | Lookup meaning for 'DEPT'
LOCATION_CODE | NULLABLE | VARCHAR2(30) | Lookup code for 'RSC - Location'
LOCATION_MEANING | NULLABLE | VARCHAR2(80) | Lookup meaning for 'RSC - Location'
CATEGORY_CODE | NULLABLE | VARCHAR2(30) | Lookup code for 'RSC - org unit Category'
CATEGORY_MEANING | NULLABLE | VARCHAR2(80) | Lookup meaning for 'RSC - org unit Category'
ENABLED_FLAG | NULLABLE | VARCHAR2(1) | Flag is 'Y' if this is an active org unit, 'N' if obsolete or not yet in use
USER_DATA_SET_CONTEXT_ID | NULLABLE | NUMBER | Parameter set context identifier for the user data fields
USER_DATA1-20 | NULLABLE | VARCHAR2(200) | User data segment
VISIBLE_USER_DATA1-20 | NULLABLE | VARCHAR2(200) | User data segment
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.
DISTINGUISH_NAME | NOT NULL | VARCHAR2(2000) | Specifies the distinguished name for the organization unit in the following format: `OU=>SubOU1=>SubSubOU1` `OU=>SubOU2`
PARENT_DISTINGUISH_NAME | NOT NULL | VARCHAR2(2000) | 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.

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KRSC_ORG_UNITS_INT_N2 | NONUNIQUE | 1 | GROUP_ID
KRSC_ORG_UNITS_INT_N2 | NONUNIQUE | 2 | ORG_UNIT_NAME
KRSC_ORG_UNITS_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: