Share this page

# KRSC_ORG_UNITS_INT

The KRSC_ORG_UNITS_INT interface table is used to define the attributes of the organization unit records being imported.

Table A-28. KRSC_ORG_UNITS_INT interface table
Column | Usage | Data Type | Description
--- | --- | --- | ---
TRANSACTION_ID | I | NUMBER | Uniquely identifies each transaction.
DATA_LANG | I | VARCHAR2 | Specifies the language of the data being imported, so it can be properly validated in the respective language. If no value is provided, then the language context is the same as the system language of the PPM instance into which the data is being imported.
GROUP_ID | I | NUMBER | Groups all the records that should be processed at the same time. Use only one GROUP_ID each time you run a report. Derived from the KNTA_INTERFACE_GROUPS_S sequence.
EXISTS_FLAG | O | VARCHAR2 | Indicates whether or not the organization unit already exists.
PROCESS_PHASE | O | NUMBER | Indicates the current stage of the record as it is being processed. See Process State Information for details.
PROCESS_STATUS | O | NUMBER | Indicates the current disposition of the record. See Process State Information for details.
CREATED_BY | I/O | NUMBER | Identifies the USER_ID (from KNTA_USERS) for the user performing the transaction. If left blank, the value is derived from CREATED_BY_USERNAME.
CREATED_BY_USERNAME | I/O | VARCHAR2 | Identifies the USERNAME (from KNTA_USERS) for the user performing the transaction. This is used only if CREATED_BY is left blank. If both are left blank, the value is set to the user currently running the report.
CREATION_DATE | I/O | DATE | Indicates the transaction date. If left blank, the current date is used.
DEST_CREATED_BY | I/O | NUMBER | Identifies the USER_ID (from KNTA_USERS) for the user performing the transaction. If left blank, the value is derived from CREATED_BY_USERNAME. Ig both are left blank, the value is set to the user currently running the report.
DEST_CREATION_DATE | I/O | DATE | Indicates the date the record is created in the destination (PPM instance). If left blank, the value is derived from CREATION_DATE.
DEST_LAST_UPDATED_BY | I/O | NUMBER | Identifies the USER_ID (from KNTA_USERS) for the user that last updated the data. If left blank, the value is set to the set to the user currently running the report.
DEST_LAST_UPDATE_DATE | I/O | DATE | Indicates the date that the organization data was last updated. If left blank, the current date is used.
DEST_ENTITY_UPD_DATE | I/O | DATE | Indicates the date that either the organization or membership data was last updated. If left blank, the current date is used.
SOURCE | I | VARCHAR2 | Specifies the source of the information. This information is not validated during an import. For example, the name of the third-party application or a value of CONVERSION.
SOURCE_TYPE_CODE | I | VARCHAR2 | Specifies the type of external update. This should be a specific interface or migrator name, left blank, or have a value of INTERFACE_WF.
ORG_UNIT_ID | I/O | NUMBER | Identifies the organization unit ID. For new organization units, the value is derived from the KRSC_ORG_UNITS_S sequence. For existing organization units, if left blank, the value is derived from ORG_UNIT_NAME.
ORG_UNIT_NAME | I | VARCHAR2 | Identifies the organization unit name.
PARENT_ORG_UNIT_ID | I/O | NUMBER | Identifies the parent unit ID for the organization unit. If left blank, the value is derived from PARENT_ORG_UNIT_NAME.
PARENT_ORG_UNIT_NAME | I | VARCHAR2 | Identifies the parent unit name for the organization unit. If left blank, then the organization unit appears as a top level unit in the organization model.
MANAGER_ID | I/O | NUMBER | Identifies the manager associated with the organization unit. If left blank, the value is derived from MANAGER_USERNAME.
MANAGER_USERNAME | I | VARCHAR2 | Specifies the name of the manager.
MANAGER_LOGON_IDENTIFIER | I | VARCHAR2 | Specifies the ID of the manager. Depends on the LOGON_METHOD setting in the `server.conf` file. If LOGON_METHOD = LOGON_ID, the MANAGER_LOGON_IDENTIFIER column must be populated. Otherwise, the MANAGER_USERNAME column must be populated.
DEPARTMENT_CODE | O | VARCHAR2 | Specifies the code for the department.
DEPARTMENT_MEANING | I | VARCHAR2 | Specifies the description of the department.
LOCATION_CODE | O | VARCHAR2 | Specifies the code for the location.
LOCATION_MEANING | I | VARCHAR2 | Specifies the description of the location.
CATEGORY_CODE | O | VARCHAR2 | Specifies the code for the category.
CATEGORY_MEANING | I | VARCHAR2 | Specifies the description of the category.
ENABLED_FLAG | O | VARCHAR2 | Indicates whether or not the organization unit is enabled upon import.
USER_DATA_SET_CONTEXT_ID | I | NUMBER | Sets the context identifier for the USER_DATA fields. Supply this or ORG_UNIT_USERNAME.
DISTINGUISH_NAME | Required | VARCHAR2 | Specifies the distinguished name for the organization unit in the following format: `OU=>SubOU1=>SubSubOU1` `OU=>SubOU2`
PARENT_DISTINGUISH_NAME | Required | VARCHAR2 | Specifies the distinguished name for the parent organization unit in the following format: `OU=>SubOU1` `OU`
USER_DATA1 VISIBLE_USER_DATA1 through USER_DATA20 VISIBLE_USER_DATA20 | I | VARCHAR2 | 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.

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: