Share this page

# KCRT_CONTACTS

This table stores the contact entities. PPM Center users can use the information stored in these entities to identify the contact person for more information regarding a specific request. Contacts are either created by the customer or seeded as part of the installation.

## Foreign Keys

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

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
CONTACT_ID | NOT NULL | NUMBER | System-generated identifier
CREATION_DATE | NOT NULL | DATE | Date record was created
CREATED_BY | NOT NULL | NUMBER | Identifier for the user who created the record
LAST_UPDATE_DATE | NOT NULL | DATE | Date record was last updated
LAST_UPDATED_BY | NOT NULL | NUMBER | Identifier for the user who last updated the record
ENTITY_LAST_UPDATE_DATE | NOT NULL | DATE | Date a record in the entity was last updated
FIRST_NAME | NOT NULL | VARCHAR2(80) | Contact person's first name
LAST_NAME | NOT NULL | VARCHAR2(80) | Contact person's last name
FULL_NAME | NOT NULL | VARCHAR2(200) | Contact person's full name
USER_ID | NULLABLE | NUMBER | Identifier for the user associated with this contact
PHONE_NUMBER | NULLABLE | VARCHAR2(30) | Contact person's phone number
EMAIL_ADDRESS | NULLABLE | VARCHAR2(80) | Contact person's email address
ENABLED_FLAG | NOT NULL | 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
COMPANY | NULLABLE | VARCHAR2(30) | Contact person's company

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KCRT_CONTACTS_N1 | NONUNIQUE | 1 | USER_ID
KCRT_CONTACTS_N2 | NONUNIQUE | 1 | FIRST_NAME
KCRT_CONTACTS_N3 | NONUNIQUE | 1 | LAST_NAME
KCRT_CONTACTS_N4 | NONUNIQUE | 1 | FULL_NAME
KCRT_CONTACTS_N5 | NONUNIQUE | 1 | EMAIL_ADDRESS
KCRT_CONTACTS_N6 | NONUNIQUE | 1 | PHONE_NUMBER
KCRT_CONTACTS_U1 | UNIQUE | 1 | CONTACT_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
KCRT_CONTACTS_S | CONTACT_ID

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: