FND_DIAG_TAG

This table defines tags, used to categorize diagnostic tests in a flexible fashion. TAGs are Module Types in Taxonomy model.

Details

• Schema: DIAGNOSTICS

• Object owner: FND

• Object type: TABLE

• Tablespace: REFERENCE

Primary Key

Name	Columns
FND_DIAG_TAG_PK	ENTERPRISE_ID, TAG_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
ENTERPRISE_ID	NUMBER		18	Yes	ENTERPRISE_ID
TAG_ID	VARCHAR2	32		Yes	This a GUID. Corresponding to each TAG_ID, there exists a human readable unique column: TAG_NAME that stores equivalent of Taxonomy's Module Type information.
TAG_NAME	VARCHAR2	70		Yes	TAG_NAME is equivalent to Taxonomy's "Module Type". This column stores test category name.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Standard WHO column
LAST_UPDATED_BY	VARCHAR2	64		Yes	Standard WHO column
CREATION_DATE	TIMESTAMP			Yes	Standard WHO column
CREATED_BY	VARCHAR2	64		Yes	Standard WHO column
LAST_UPDATE_LOGIN	VARCHAR2	32			Standard WHO column
MODULE_ID	VARCHAR2	32		Yes	This column is a foreign key to FND_APPL_TAXONOMY.MODULE_ID and is used for seed data striping.
SEED_DATA_SOURCE	VARCHAR2	512			Seed data file from which the row originates.
ORA_SEED_SET1	VARCHAR2	1		Yes	Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N.
ORA_SEED_SET2	VARCHAR2	1		Yes	Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N.

Foreign Keys

Table	Foreign Table	Foreign Key Column
FND_DIAG_TAG	fnd_appl_taxonomy	ENTERPRISE_ID, MODULE_ID
fnd_diag_tag_tl	fnd_diag_tag	ENTERPRISE_ID, TAG_ID

Indexes

Index	Uniqueness	Tablespace	Columns
FND_DIAG_TAG_U1	Unique	Default	ENTERPRISE_ID, TAG_NAME, ORA_SEED_SET1
FND_DIAG_TAG_U11	Unique	Default	ENTERPRISE_ID, TAG_NAME, ORA_SEED_SET2
FND_DIAG_TAG_U2	Unique	Default	ENTERPRISE_ID, TAG_ID, ORA_SEED_SET1
FND_DIAG_TAG_U21	Unique	Default	ENTERPRISE_ID, TAG_ID, ORA_SEED_SET2