EGO_ENTITY_AUTO_GEN

Details

Schema: FUSION
Object owner: EGO
Object type: TABLE
Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
EGO_ENTITY_AUTO_GEN_META_PK	OBJECT_SEQUENCE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
OBJECT_SEQUENCE_ID	NUMBER		18	Yes	Identifier to uniquely determine the entity auto generation metadata rows
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.
OBJECT_NAME	VARCHAR2	50		Yes	Name of the object on which auto generation is applied. For example, change, NIR and item class
OBJECT_ID1	NUMBER		18		Identifier determining the object identifiers from other tables based on object_name like change_type_id, item_class_id etc
OBJECT_ID2	NUMBER		18		Used to refer any other identifiers from other tables
OBJECT_ID3	NUMBER		18		Used to refer any other identifiers from other tables
OBJECT_ID4	NUMBER		18		Used to refer any other identifiers from other tables
OBJECT_ID5	NUMBER		18		Used to refer any other identifiers from other tables
PREFIX	VARCHAR2	20			Syllable or syllables put at the beginning of another word to change its meaning.
SUFFIX	VARCHAR2	20			Syllable or syllables put at the end of another word to change its meaning.
STARTING_NUMBER	NUMBER				A beginning number of the series.
INCREMENT_BY	NUMBER				The amount by which the value changes.
SEQUENCE_NAME	VARCHAR2	100			Name of the sequence generated internally
DELIMITER	VARCHAR2	20			Delimiter used to concatenate different segments when configured item numbers are created.
PREFIX_TYPE	VARCHAR2	20			Prefix type used to concatenated with other segments when a configured item number is created.
SUFFIX_TYPE	VARCHAR2	20			Suffix type used that will be concatenated with other segments when configured item number is created.
OBJECT_ENTITY_FLAG	VARCHAR2	1			In case of entity being item class, it stores N which represents item number generation method, C for configured item number generation method and D for item description generation method. For rows created for change types, it stores N which represents change number generation method
AUTO_GEN_RULE_SET_ID	NUMBER		18		Auto Generate Rule Set Identifier
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created 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.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.

Foreign Keys

Table	Foreign Table	Foreign Key Column
EGO_ENTITY_AUTO_GEN_METADATA	ego_rl_rule_sets_b	AUTO_GEN_RULE_SET_ID

Indexes

Index	Uniqueness	Tablespace	Columns
EGO_ENTITY_AUTO_GEN_META_N1	Non Unique	FUSION_TS_TX_DATA	OBJECT_NAME, OBJECT_ID1, OBJECT_ID2, OBJECT_ID3, OBJECT_ID4, OBJECT_ID5
EGO_ENTITY_AUTO_GEN_MET_PK	Unique	Default	OBJECT_SEQUENCE_ID