Share this page

# KCRT_CONTACTS_INT

This table stores contacts to migrate between PPM Center instances.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KCRT_CONTACTS | CONTACT_ID | CONTACT_ID
KNTA_USERS | USER_ID | CREATED_BY
KNTA_PARAMETER_SET_CONTEXTS | PARAMETER_SET_CONTEXT_ID | USER_DATA_SET_CONTEXT_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
CONTACT_INTERFACE_ID | NULLABLE | NUMBER | System-generated identifier
GROUP_ID | NULLABLE | NUMBER | Identifier
PROCESS_PHASE | NULLABLE | NUMBER | Determines where the record is in the interface process: 1 -- Pending, 2 -- Validating, 3 -- Importing
PROCESS_STATUS | NULLABLE | NUMBER | Determines the current status of the interface record: 1 -- Pending, 2 -- In-Process, 3 -- Errored, 4 -- Completed.
CONTACT_ID | NULLABLE | NUMBER | Indicates which contact this contact interface is link to
CREATION_DATE | NULLABLE | DATE | Date record was created
CREATED_BY | NULLABLE | NUMBER | Identifier for the user who created the record
FIRST_NAME | NULLABLE | VARCHAR2(30) | Contact person's first name
LAST_NAME | NULLABLE | VARCHAR2(30) | Contact person's last name
FULL_NAME | NULLABLE | VARCHAR2(80) | Contact person's full name
USERNAME | NULLABLE | VARCHAR2(200) | Contact person's username
PHONE_NUMBER | NULLABLE | VARCHAR2(30) | Contact person's phone number
EMAIL_ADDRESS | NULLABLE | VARCHAR2(80) | Contact person's email address
ENABLED_FLAG | NULLABLE | VARCHAR2(1) | Indicates whether this contact is available for 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
USER_ID | NULLABLE | NUMBER | Identifier for the user associated with this contact
COMPANY | NULLABLE | VARCHAR2(30) | Contact person's company

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KCRT_CONTACTS_INT_N1 | NONUNIQUE | 1 | CONTACT_INTERFACE_ID
KCRT_CONTACTS_INT_N1 | NONUNIQUE | 2 | GROUP_ID
KCRT_CONTACTS_INT_N2 | NONUNIQUE | 1 | GROUP_ID
KCRT_CONTACTS_INT_N3 | NONUNIQUE | 1 | FULL_NAME

## Sequences

This table uses no sequences.

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: