FND_KF_SEGMENT_INSTANCES_BK

Flexfields: Key Flexfields: Segment Instance Table.

Details

• Schema: KFF

• Object owner: FND

• Object type: TABLE

• Tablespace: REFERENCE

Primary Key

Name	Columns
FND_KF_SEGMENT_INSTANCES_BK_PK	STRUCTURE_INSTANCE_ID, SEGMENT_CODE, ENTERPRISE_ID, CUST_SET_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
ENTERPRISE_ID	NUMBER		18	Yes	ENTERPRISE_ID
STRUCTURE_INSTANCE_ID	NUMBER		18	Yes	STRUCTURE_INSTANCE_ID
SEGMENT_CODE	VARCHAR2	30		Yes	SEGMENT_CODE
VALUE_SET_ID	NUMBER		18	Yes	VALUE_SET_ID
TREE_STRUCTURE_CODE	VARCHAR2	30			TREE_STRUCTURE_CODE
TREE_CODE	VARCHAR2	30			TREE_CODE
DEFAULT_TYPE	VARCHAR2	30			DEFAULT_TYPE
DEFAULT_VALUE	VARCHAR2	4000			DEFAULT_VALUE
DEFAULT_VALUE_NUMBER	NUMBER				DEFAULT_VALUE_NUMBER
REQUIRED_FLAG	VARCHAR2	1		Yes	REQUIRED_FLAG
DISPLAY_FLAG	VARCHAR2	1		Yes	DISPLAY_FLAG
BI_ENABLED_FLAG	VARCHAR2	1		Yes	BI_ENABLED_FLAG
QUERY_REQUIRED_TYPE	VARCHAR2	30		Yes	QUERY_REQUIRED_TYPE
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
CUST_SET_ID	VARCHAR2	300		Yes	Customization Set ID

Indexes

Index	Uniqueness	Tablespace	Columns
FND_KF_SEGMENT_INSTANCES_BK_N1	Non Unique	Default	VALUE_SET_ID, ENTERPRISE_ID
FND_KF_SEGMENT_INSTANCES_BK_U1	Unique	Default	STRUCTURE_INSTANCE_ID, SEGMENT_CODE, ENTERPRISE_ID, CUST_SET_ID