Share this page

# KRSC_ORG_UNITS

This table stores all the organization units created in PPM center.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
FM_FINANCIAL_SUMMARY | FINANCIAL_SUMMARY_ID | FINANCIAL_SUMMARY_ID
KNTA_USERS | USER_ID | LAST_UPDATED_BY
KNTA_USERS | USER_ID | CREATED_BY
KNTA_USERS | USER_ID | MANAGER_ID
KRSC_ORG_UNITS_NLS | ORG_UNIT_ID | PARENT_ORG_UNIT_ID
KNTA_REGIONS_NLS | REGION_ID | REGION_ID
KNTA_PARAMETER_SET_CONTEXTS | PARAMETER_SET_CONTEXT_ID | USER_DATA_SET_CONTEXT_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
ORG_UNIT_ID | NOT NULL | NUMBER | System-generated identifier
CREATION_DATE | NOT NULL | DATE | Date record was created
CREATED_BY | NOT NULL | NUMBER | Identifier for the user who created the record
LAST_UPDATE_DATE | NOT NULL | DATE | Date record was last updated
LAST_UPDATED_BY | NOT NULL | NUMBER | Identifier for the user who last updated the record
ENTITY_LAST_UPDATE_DATE | NOT NULL | DATE | Date a record in the entity was last updated
ORG_UNIT_NAME | NOT NULL | VARCHAR2(200) | Name given to this organization unit.
PARENT_ORG_UNIT_ID | NOT NULL | NUMBER | Reference to the parent organization unit record in the same table.
MANAGER_ID | NULLABLE | NUMBER | Foreign key to the knta_user table indicating the manager for this org unit.
DEPARTMENT_CODE | NULLABLE | VARCHAR2(30) | Lookup code for 'DEPT' The department to which this org unit is associated with. For example: Finance and Marketing.
LOCATION_CODE | NULLABLE | VARCHAR2(30) | Lookup code for 'RSC - Location' The location to which this org unit is associated to. For example: Site A, Site B, and so on
CATEGORY_CODE | NULLABLE | VARCHAR2(30) | Lookup code for 'RSC - org unit Category' The type of the org unit. For example: Group, department, team, and so on
ENABLED_FLAG | NOT NULL | VARCHAR2(1) | Indicates whether this organization unit is enabled
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
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)
REGION_ID | NULLABLE | NUMBER | Region to which this organization unit is associated to
PRIMARY_FLAG | NOT NULL | VARCHAR2(1) | Flag to indicate if this is a primary org unit or not
DEFINITION_LANGUAGE | NOT NULL | VARCHAR2(40) | Language in which the data was created
REFERENCE_CODE | NOT NULL | VARCHAR2(200) | Is the logical key to represent a record in the db uniquely. This is different from primary key and used for multi-language (MLU) purpose.
FINANCIAL_SUMMARY_ID | NULLABLE | NUMBER | Foreign key reference to FM_FINANCIAL_SUMMARY table
INHERIT_PARENT_REGION | NOT NULL | VARCHAR2(1) |

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KRSC_ORG_UNITS_FB1 | NONUNIQUE | 1 | SYS_NC00063$
KRSC_ORG_UNITS_FB1 | NONUNIQUE | 2 | ORG_UNIT_ID
KRSC_ORG_UNITS_FB1 | NONUNIQUE | 3 | ENABLED_FLAG
KRSC_ORG_UNITS_FB1 | NONUNIQUE | 4 | PRIMARY_FLAG
KRSC_ORG_UNITS_FB1 | NONUNIQUE | 5 | ORG_UNIT_NAME
KRSC_ORG_UNITS_N1 | NONUNIQUE | 1 | PARENT_ORG_UNIT_ID
KRSC_ORG_UNITS_N3 | NONUNIQUE | 1 | REGION_ID
KRSC_ORG_UNITS_U1 | UNIQUE | 1 | ORG_UNIT_ID
KRSC_ORG_UNITS_U2 | UNIQUE | 1 | ORG_UNIT_NAME
SYS_C005199517 | UNIQUE | 1 | REFERENCE_CODE

## Sequences

Sequence Name | Sequence Type
--- | ---
KRSC_ORG_UNITS_S | ORG_UNIT_ID

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: