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.