KENV_HOST_CLASS_MEMBERS_UPG

This table is used during the Apps*Integrity 1.7 to IS*Integrity 2.0 upgrade to populate the contents of the KENV_HOST_CLASS_MEMBERS table.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KNTA_USERS

USER_ID

CREATED_BY

Column Descriptions

Column Name

Null?

Data Type

Description

HOST_CLASS_MEMBER_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

HOST_CLASS_ID

NOT NULL

NUMBER

Host Class identifier

HOST_TYPE_CODE

NOT NULL

VARCHAR2(80)

Lookup code for 'HOST_TYPE_CODE'; defines the operating system type for this host type

DESCRIPTION

NULLABLE

VARCHAR2(240)

Description of the host class member

ENABLED_FLAG

NULLABLE

VARCHAR2(1)

Determines whether Deliver recognizes this class of server

USER_DATA1-10

NULLABLE

VARCHAR2(200)

User data segment

USER_VISIBLE_DATA1-10

NULLABLE

VARCHAR2(200)

User data segment

Indexes

Index Name

Index Type

Sequence

Column Name

KENV_HOST_CLASS_MEMBERS_UPG_N1

NONUNIQUE

1

HOST_TYPE_CODE

KENV_HOST_CLASS_MEMBERS_UPG_N1

NONUNIQUE

2

USER_DATA10

Sequences

This table uses no sequences.