KNTA_FIELD_GROUPS

This table stores all of the available field groups, each field group has table name, which identifies the place that includes a list of all the requests that uses this group. A field group is a collection of fields that together represent all the data necessary to drive some functionality. Administrators can add field groups to a request header type, so that all requests using that request header type will inherit the field group's fields.

Foreign Keys

Primary Key Table	Primary Key Column	Foreign Key Column
KNTA_USERS	USER_ID	CREATED_BY
KNTA_ENTITIES_NLS	ENTITY_ID	ENTITY_ID
KNTA_USERS	USER_ID	LAST_UPDATED_BY

Column Descriptions

Column Name	Null?	Data Type	Description
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
FIELD_GROUP_NAME	NOT NULL	VARCHAR2(80)
DESCRIPTION	NULLABLE	VARCHAR2(240)
ENTITY_ID	NULLABLE	NUMBER
TABLE_NAME	NOT NULL	VARCHAR2(30)
INTERFACE_TABLE_NAME	NOT NULL	VARCHAR2(30)
ENABLED_FLAG	NOT NULL	VARCHAR2(1)
DEFINITION_LANGUAGE	NOT NULL	VARCHAR2(40)
REFERENCE_CODE	NOT NULL	VARCHAR2(200)

Indexes

Index Name	Index Type	Sequence	Column Name
KNTA_FIELD_GROUPS_U1	UNIQUE	1	FIELD_GROUP_ID
SYS_C00109352306	UNIQUE	1	REFERENCE_CODE

Sequences

This table uses no sequences.