EGO_SUBJECTS_B

Table used to store Subject Internal Names for Change Line types in a Engineering Change Order or New Item Request.

Details

• Schema: FUSION

• Object owner: EGO

• Object type: TABLE

• Tablespace: REFERENCE

Primary Key

Name	Columns
EGO_SUBJECTS_B_PK	SUBJECT_INTERNAL_NAME

Columns

Name	Datatype	Length	Precision	Not-null	Comments
SUBJECT_INTERNAL_NAME	VARCHAR2	30		Yes	Unique identifier holding internal name of the change subject
SUBJECT_TYPE	VARCHAR2	20		Yes	Identifier determining the type of the subject
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.
IMPORT_API	VARCHAR2	500			Subject Import API for Validation and Value to ID Conversion
APPLICATION_ID	NUMBER				Identifier of the application to which this change subject belongs to
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_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.
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
ego_category_subjects	ego_subjects_b	SUBJECT_INTERNAL_NAME
ego_subjects_tl	ego_subjects_b	SUBJECT_INTERNAL_NAME
ego_subject_criteria_b	ego_subjects_b	SUBJECT_INTERNAL_NAME

Indexes

Index	Uniqueness	Columns
EGO_SUBJECTS_B_PK	Unique	SUBJECT_INTERNAL_NAME, ORA_SEED_SET1
EGO_SUBJECTS_B_PK1	Unique	SUBJECT_INTERNAL_NAME, ORA_SEED_SET2