1. Tables and Views for Sales and Fusion Service
  2. HZ_CLASS_CATEGORY_USES

HZ_CLASS_CATEGORY_USES

The HZ_CLASS_CATEGORY_USES table stores information on the classification of party. A party can be classified into multiple classification categories for different versions of industrial classification standards or user defined categories For example, An organization classified with a SIC 1987 class category would be stored in the HZ_CLASS_CATEGORY_USES Table as follows: CLASS_CATEGORY = 1987 SIC, OWNER_TABLE = HZ_PARTIES and ADDITIONAL_WHERE_CLAUSE = WHERE PARTY_TYPE = 'ORGANIZATION'

Details

  • Schema: FUSION

  • Object owner: HZ

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

HZ_CLASS_CATEGORY_USES_PK

CLASS_CATEGORY, OWNER_TABLE

Columns

Name Datatype Length Precision Not-null Comments
CLASS_CATEGORY VARCHAR2 30 Yes Public classifications such as US SIC, NACE, NAICS or custom classes.
OWNER_TABLE VARCHAR2 30 Yes Table that the classification will apply to. For example, the HZ_PARTIES table.
COLUMN_NAME VARCHAR2 240 Column from the OWNER_TABLE that applies to classification. For example, HZ_PARTIES.PARTY_ID.
ADDITIONAL_WHERE_CLAUSE VARCHAR2 4000 Helps restrict the set of instances in the owner table from which the classification will apply.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated 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.
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.
CREATED_BY_MODULE VARCHAR2 30 TCA Who column
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

Indexes

Index Uniqueness Tablespace Columns
HZ_CLASS_CATEGORY_USES_PK Unique Default CLASS_CATEGORY, OWNER_TABLE, ORA_SEED_SET1
HZ_CLASS_CATEGORY_USES_PK1 Unique Default CLASS_CATEGORY, OWNER_TABLE, ORA_SEED_SET2