EGO_ROUTE_ASSOCS

Details

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

Primary Key

Name	Columns
EGO_ROUTE_ASSOCS_PK	ROUTE_ASSOC_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
ROUTE_ASSOC_ID	NUMBER		18	Yes	Identifier to uniquely determine the route_assoc rows
TASK_COMPLETED_BY	VARCHAR2	300			The user who has completed the corresponding task.
TASK_START_TIME	TIMESTAMP				Start date and time of the task for corresponding item and entity.
TASK_END_TIME	TIMESTAMP				End date and time of the task for corresponding item and entity.
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.
ROUTE_PEOPLE_ID	NUMBER		18	Yes	Used to store the route_people_id corresponding to this route association, from ego_route_people table
OBJECT_NAME	VARCHAR2	30		Yes	Used to store the object name related to the association. For example, EGO_NEW_ITEM, EGO_CHANGE_LINE,EGP_CATALOG_GROUP etc
OBJECT_PK1	NUMBER		18	Yes	Used to store inventory item id of the item being defined. In case of setup rows, it will store the item class id
OBJECT_PK2	NUMBER		18		Used to store revision id of the item being defined
OBJECT_PK3	NUMBER		18		Used to store item class id if association rows are not setup rows
OBJECT_PK4	NUMBER		18		Used to refer any other identifiers from other tables
OBJECT_PK5	NUMBER		18		Used to refer any other identifiers from other tables
DEFINITION_ENTITY_NAME	VARCHAR2	30		Yes	Used to store name of the entity being defined via NIR. For example, User defined attributes, item associations, item operational attributes, BOM etc.
DEFINITION_ENTITY_PK1	VARCHAR2	300		Yes	Used to store the attribute group being defined
DEFINITION_ENTITY_PK2	VARCHAR2	300			Used to store the task id pertaining to the association
DEFINITION_ENTITY_PK3	VARCHAR2	300			Used to store the sequence number of flexfield group to be appeared on UI while defining via NIR
DEFINITION_ENTITY_PK4	VARCHAR2	300			Will be used to store any external identifier to be used for NIR definition
DEFINITION_ENTITY_PK5	VARCHAR2	300			Will be used to store any external identifier to be used for NIR definition
INHERITED_FLAG	VARCHAR2	1			Flag to determine if the definition association is inherited from parent item class
ADHOC_FLAG	VARCHAR2	1		Yes	Value will be set to Y if New Item Request definition association is done through reassignment action
DEFINITION_STATUS	VARCHAR2	20			Used to store the status of the definition. For example, APPROVED, EGO_COMPLETED, EGO_NOT_STARTED etc.
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.
MANDATORY_FLAG	VARCHAR2	1			Flag determining If the association definition is mandatory for the task to be completed

Foreign Keys

Table	Foreign Table	Foreign Key Column
EGO_ROUTE_ASSOCS	ego_route_people	ROUTE_PEOPLE_ID
ego_route_assoc_attrs	ego_route_assocs	ROUTE_ASSOC_ID

Indexes

Index	Uniqueness	Tablespace	Columns
EGO_ROUTE_ASSOCS_N1	Non Unique	FUSION_TS_TX_DATA	OBJECT_VERSION_NUMBER
EGO_ROUTE_ASSOCS_PK	Unique	Default	ROUTE_ASSOC_ID
EGO_ROUTE_ASSOCS_U1	Unique	FUSION_TS_TX_DATA	ROUTE_PEOPLE_ID, OBJECT_NAME, OBJECT_PK1, OBJECT_PK2, OBJECT_PK3, OBJECT_PK4, OBJECT_PK5, DEFINITION_ENTITY_NAME, DEFINITION_ENTITY_PK1, DEFINITION_ENTITY_PK2, DEFINITION_ENTITY_PK3, DEFINITION_ENTITY_PK4, DEFINITION_ENTITY_PK5