HRW_INDUSTRY_GROUPS

Table contains seeded industry grouping.

Details

• Schema: FUSION

• Object owner: HRW

• Object type: TABLE

• Tablespace: REFERENCE

Primary Key

Name	Columns
HRW_INDUSTRY_GROUPS_PK	CODE

Columns

Name	Datatype	Length	Not-null	Comments
CODE	VARCHAR2	20	Yes	CODE
NAME	VARCHAR2	100	Yes	NAME
SAME_ROLE_ADVICE	VARCHAR2	20		SAME_ROLE_ADVICE
SAME_ROLE_HINT	VARCHAR2	1		SAME_ROLE_HINT
NEW_POST_ADVICE	VARCHAR2	20		NEW_POST_ADVICE
NEW_ADVICE_HINT	VARCHAR2	1		NEW_ADVICE_HINT
HEADCOUNT_PRESERVED_ADVICE	VARCHAR2	20		HEADCOUNT_PRESERVED_ADVICE
HEADCOUNT_PRESERVED_HINT	VARCHAR2	20		HEADCOUNT_PRESERVED_HINT
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_UPDATED_BY	VARCHAR2	64	Yes	Who column: indicates 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_UPDATE_LOGIN	VARCHAR2	32		Who column: indicates the session login associated to the user who last updated the row.
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
hrw_industries	hrw_industry_groups	GROUP_CODE

Indexes

Index	Uniqueness	Tablespace	Columns
HRW_INDUSTRY_GROUPS_PK	Unique	Default	CODE, ORA_SEED_SET1
HRW_INDUSTRY_GROUPS_PK1	Unique	Default	CODE, ORA_SEED_SET2