HZ_CLASS_CATEGORIES

The HZ_CLASS_CATEGORIES table stores the various categories, either industrial classification standards or user defined, that could be used to classify a party (Organization or Person). The possible values for class categories include NAICS, SIC 1987, and Customer Category. A record in the FND_LOOKUP_TYPES table with the code should be inserted before the code is used in this table.

Details

• Schema: FUSION

• Object owner: HZ

• Object type: TABLE

• Tablespace: REFERENCE

Primary Key

Name	Columns
HZ_CLASS_CATEGORIES_PK	CLASS_CATEGORY

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
CLASS_CATEGORY	VARCHAR2	30		Yes	Class category that belongs to the group. For example, Public classifications such as US SIC, NACE, NAICS or custom classes.	Active
STATUS_FLAG	VARCHAR2	1		Yes	Record Status Flag used to soft delete entity. Possible values are 'A' (active) and 'I' (inactive).
ALLOW_MULTI_ASSIGN_FLAG	VARCHAR2	1		Yes	Y or N indicates whether codes under this category can be assigned to an object more than once or not	Active
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.	Active
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.	Active
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.	Active
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.	Active
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.	Active
ALLOW_LEAF_NODE_ONLY_FLAG	VARCHAR2	1			Y or N indicates whether or not the instances of those entities associated with this particular CLASS_CATEGORY can only be assigned to leaf node class codes of that particular CLASS_CATEGORY	Active
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.	Active
CREATED_BY_MODULE	VARCHAR2	30			TCA Who column	Active
DELIMITER	VARCHAR2	1			Used for concatenated class code in the HZ_CLASS_CODE_DENORM table	Active
LKUP_TYPE_OWNER_ID	NUMBER		18		Identifies the owner of the class category.	Active
SEED_DATA_SOURCE	VARCHAR2	512			Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.
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
hz_class_category_uses	hz_class_categories	CLASS_CATEGORY
hz_code_assignments	hz_class_categories	CLASS_CATEGORY
zx_fc_types_b	hz_class_categories	OWNER_ID_CHAR
zca_sa_code_assignments	hz_class_categories	CLASS_CATEGORY

Indexes

Index	Uniqueness	Tablespace	Columns
HZ_CLASS_CATEGORIES_N1	Non Unique	Default	LAST_UPDATE_DATE
HZ_CLASS_CATEGORIES_PK	Unique	Default	CLASS_CATEGORY, ORA_SEED_SET1
HZ_CLASS_CATEGORIES_PK1	Unique	Default	CLASS_CATEGORY, ORA_SEED_SET2