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