FND_COLUMNS

Details

Schema: FUSION
Object owner: FND
Object type: TABLE
Tablespace: REFERENCE

Primary Key

Name	Columns
FND_COLUMNS_PK	TABLE_ID, COLUMN_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
TABLE_ID	NUMBER		18	Yes	Table to which this column belongs. Foreign key to FND_TABLES.
COLUMN_ID	NUMBER		18	Yes	Column identifier.
COLUMN_NAME	VARCHAR2	30		Yes	Actual database column name.
USER_COLUMN_NAME	VARCHAR2	80			Name for column that may be meaningful to users.
COLUMN_SEQUENCE	NUMBER		18		Sequence number. Indicates the order of the columns in created table.
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.
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_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
COLUMN_TYPE	VARCHAR2	30			Column datatype. D (Date), N (Number), V (Varchar), I (RowID), L (Long), X (Long Raw) are possible values.
WIDTH	NUMBER		18		Bytes of storage for column value.
NULL_ALLOWED_FLAG	VARCHAR2	1			Y/N Flag: Are null values allowed in this column?
TRANSLATE_FLAG	VARCHAR2	1		Yes	Y/N Flag: Is value translated for this column?
DESCRIPTION	VARCHAR2	4000			The comment associated with this column, if any.
PRECISION	NUMBER		18		Precision for the column, if any.
SCALE	NUMBER		18		Scale for the column, if any.
DOMAIN_CODE	VARCHAR2	30			Domain Code.
STATUS	VARCHAR2	30			Status of the column : Active / Obsolete / EOL / Not Used (default: 'Active').
DENORM_PATH	VARCHAR2	80			Denomalization path : Path to the column which holds the data which should be copied to this column in format of [FK column name].[source column in source table] .
SHORT_NAME	VARCHAR2	30			Column Short Name: Max Length 27.
ROUTING_MODE	VARCHAR2	30			Routing Mode: Indicates how the column should be handled by Disconnected Mobile during synchronization between the server and client databases. Allowed Values: Normal / Do Not Route. 'Normal' indicates that the column contents should be sent (routed) to the destination database, and 'Do Not Route' means the column will be skipped from routing. (Default Value: 'Normal')
VERSION_COLUMN	VARCHAR2	30			Indicates the name of the version column used for LOB data columns for Disconnected Mobile synchronization. The default value is empty. If a column name is specified for the value then the Disconnected Mobile Framework will reference the column indicated by the value and use it as the version column for the LONG or LOB data column. Version information stored in a separate column is required for synchronizing columns of LONG or LOB data types. Allowed Values: Any column name.
ELIGIBLE_TO_BE_SECURED	VARCHAR2	1			Indicates whether the column is eligible to be secured and hence be part of the corresponding secured view for the table in which this column is defined.
SECURITY_CLASSIFICATION	VARCHAR2	30			Indicates the security level of a column data.
DEFAULT_ON_NULL	VARCHAR2	1			This property indicates Default Value to be used on NULL.
CROSSEDITION_TRIGGERS	CLOB				Comma separated Forward and Reverse Cross Edition Triggers of the column

Foreign Keys

Table	Foreign Table	Foreign Key Column
FND_COLUMNS	FND_TABLES	TABLE_ID
FND_PRIMARY_KEY_COLUMNS	FND_COLUMNS	TABLE_ID, COLUMN_ID
FND_FOREIGN_KEY_COLUMNS	FND_COLUMNS	TABLE_ID, COLUMN_ID

Indexes

Index	Uniqueness	Tablespace	Columns
FND_COLUMNS_U1	Unique	Default	TABLE_ID, COLUMN_ID
FND_COLUMNS_U2	Unique	Default	COLUMN_NAME, TABLE_ID
FND_COLUMNS_U3	Unique	Default	TABLE_ID, USER_COLUMN_NAME
FND_COLUMNS_U4	Unique	Default	COLUMN_SEQUENCE, TABLE_ID