HEX_RUN_EXCLUDE_MIGRATION

Details

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

Primary Key

Name	Columns
HEX_RUN_EXCLU_MIGR_PK	HEX_EXCLU_MIGRATION_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
HEX_EXCLU_MIGRATION_ID	NUMBER		18	Yes	System generated Primary Key. Uniquely identifies a record.
STATUS	VARCHAR2	30			The column indicates the status value in the migration table
OBJECT_TYPE	VARCHAR2	100		Yes	The column indicates the type of object to be excluded from migration check.
NEW_OBJECT_NAME	VARCHAR2	4000			The column stores the new value to be referred for the OBJECT_NAME
OBJECT_NAME	VARCHAR2	4000			The column indicates the name of object to be excluded from migration check.
ATTRIBUTE_CATEGORY	VARCHAR2	30			Descriptive Flexfield: structure definition of the user descriptive flexfield.
ATTRIBUTE1	VARCHAR2	4000			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE2	VARCHAR2	4000			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE3	VARCHAR2	250			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE4	VARCHAR2	4000			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE5	VARCHAR2	4000			Descriptive Flexfield: segment of the user descriptive flexfield.
LEGISLATION_CODE	VARCHAR2	20			The column indicates the legislation code derived from the Legal Entity.
LEGISLATIVE_DATA_GROUP_ID	NUMBER		18		The column indicates the legislative data group referred to in the current run.
ENTERPRISE_ID	NUMBER		18	Yes	Identifier of Enterprise, used for multi-tenancy partitioning. Foreign key to HR_ORGANIZATION_UNITS.
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.
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.
MODULE_ID	VARCHAR2	32			Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data.
SGUID	VARCHAR2	32			The seed global unique identifier. Oracle internal use only.
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.

Indexes

Index	Uniqueness	Tablespace	Columns
HEX_RUN_EXCLU_MIGR_N1	Non Unique	Default	OBJECT_NAME
HEX_RUN_EXCLU_MIGR_N2	Non Unique	Default	ATTRIBUTE_CATEGORY, ATTRIBUTE1
HEX_RUN_EXCLU_MIGR_PK	Unique	Default	HEX_EXCLU_MIGRATION_ID, ORA_SEED_SET1
HEX_RUN_EXCLU_MIGR_PK1	Unique	Default	HEX_EXCLU_MIGRATION_ID, ORA_SEED_SET2