KCRT_HDR_TYPES_FIELD_GROUPS

This table joins KCRT_REQUEST_HEADER_TYPES and KNTA_FIELD_GROUPS. When a field group is linked to a request header type, a row is added to this table. The row is removed when the field group is unlinked from the request header type.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KNTA_USERS

USER_ID

CREATED_BY

KNTA_FIELD_GROUPS_NLS

FIELD_GROUP_ID

FIELD_GROUP_ID

KCRT_REQUEST_HEADER_TYPES_NLS

REQUEST_HEADER_TYPE_ID

REQUEST_HEADER_TYPE_ID

Column Descriptions

Column Name

Null?

Data Type

Description

HDR_TYPES_FIELD_GROUP_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

REQUEST_HEADER_TYPE_ID

NOT NULL

NUMBER

Identifier for the linked request header type

FIELD_GROUP_ID

NOT NULL

NUMBER

Identifier for the linked field group

SOURCE

NULLABLE

VARCHAR2(100)

For records that have been updated by an interface or migrator, provides additional information about the source of the external update.

SOURCE_TYPE_CODE

NULLABLE

VARCHAR2(30)

For records that have been updated by an interface or migrator, indicates the type of external update (specific interface or migrator name, and so on)

Indexes

Index Name

Index Type

Sequence

Column Name

KCRT_HDR_TYPES_FIELD_GROUPS_N1

NONUNIQUE

1

REQUEST_HEADER_TYPE_ID

KCRT_HDR_TYPES_FIELD_GROUPS_U1

UNIQUE

1

HDR_TYPES_FIELD_GROUP_ID

Sequences

Sequence Name

Sequence Type

KCRT_HDR_TYPES_FIELD_GROUPS_S

HDR_TYPES_FIELD_GROUP_ID