KRSC_ORG_UNITS_INT

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.