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.