Share this page

# KRSC_ORG_UNIT_MEMBERS_INT

The KRSC_ORG_UNIT_MEMBERS_INT interface table is used to specify members for the organization units which were created through the organization unit interface tables.

Table A-29. KRSC_ORG_UNIT_MEMBERS_INT interface table
Column | Usage | Data Type | Description
--- | --- | --- | ---
TRANSACTION_ID | I | NUMBER | Uniquely identifies each transaction.
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 | 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. If 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 user currently running the report.
DEST_LAST_UPDATE_DATE | I/O | DATE | Indicates the date that the membership 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_MEMBER_ID | I/O | NUMBER | Identifies the organization unit member. This is normally left blank and is derived from the KRSC_ORG_UNIT_MEMBER_S sequence.
ORG_UNIT_ID | I/O | NUMBER | Identifies the organization unit ID. This is normally left blank and is derived from KRSC_ORG_UNITS.
ORG_UNIT_NAME | I | VARCHAR2 | Identifies the parent unit name for the organization unit.
USER_ID | I/O | NUMBER | Identifies the user. For existing users, this refers to the USER_ID column in KNTA_USERS. This is normally left blank and is derived from the KNTA_USERS_S sequence.
USERNAME | I | VARCHAR2 | Identifies the name used for the logon. The value should be a valid USERNAME in KNTA_USERS. Depends on the LOGON_METHOD setting in the `server.conf` file. If LOGON_METHOD = USER_NAME, the USERNAME column must be populated for the user import. Otherwise, populate the LOGON_ID column.
LOGON_IDENTIFIER | I | VARCHAR2 | Identifies the ID used for the logon. The value should be a valid USERNAME in KNTA_USERS. Depends on the LOGON_METHOD setting in the `server.conf` file. If LOGON_METHOD = LOGON_ID, the LOGON_ID column must be populated. Otherwise, populate the USERNAME column.
ORG_UNIT_DISTINGUISH_NAME | I | VARCHAR2 | Specifies the distinguished name for the organization unit.

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: