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