EGO_CHANGE_PROPAGATION

Details

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

Primary Key

Name	Columns
EGO_CHANGE_PROPAGATION_MA_PK	CHANGE_PROPAGATION_MAP_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
CHANGE_PROPAGATION_MAP_ID	NUMBER		18	Yes	Change propagation entity identifier
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.
CHANGE_ID	NUMBER		18	Yes	Identifier determining the change id of the source change order
CHANGE_LINE_ID	NUMBER		18		Identifier determining the change line id of the source change order
REVISED_LINE_TYPE	VARCHAR2	20			Identifier to determine the type of change in revised line. For example 'COMPONENT_CHANGE'
REVISED_LINE_ID1	NUMBER		18		Identifier determining the component_sequence_id of the source component
REVISED_LINE_ID2	NUMBER		18		Used to refer any external identifiers from other tables
REVISED_LINE_ID3	NUMBER		18		Used to refer any external identifiers from other tables
REVISED_LINE_ID4	NUMBER		18		Used to refer any external identifiers from other tables
REVISED_LINE_ID5	NUMBER		18		Used to refer any external identifiers from other tables
LOCAL_ORGANIZATION_ID	NUMBER		18		Destination Organization Identifier
LOCAL_CHANGE_ID	NUMBER		18		Identifier determining the change id of the propagated change order
LOCAL_CHANGE_LINE_ID	NUMBER		18		Destination Revised Item Identifier
LOCAL_REVISED_LINE_ID1	NUMBER		18		Destination Revised Line Identifier 1
LOCAL_REVISED_LINE_ID2	NUMBER		18		Destination Revised Line Identifier 2
LOCAL_REVISED_LINE_ID3	NUMBER		18		Destination Revised Line Identifier 3
LOCAL_REVISED_LINE_ID4	NUMBER		18		Destination Revised Line Identifier 4
LOCAL_REVISED_LINE_ID5	NUMBER		18		Destination Revised Line Identifier 5
ENTITY_NAME	VARCHAR2	30			Identifier determining the name of entity on which propagation is done
ENTITY_ACTION_STATUS	NUMBER				Propagation Action Status of the Entity
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
PROGRAM_NAME	VARCHAR2	30			No longer used.
PROGRAM_APP_NAME	VARCHAR2	50			Concurrent request application Name
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.
JOB_DEFINITION_NAME	VARCHAR2	100			Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE	VARCHAR2	900			Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.

Foreign Keys

Table	Foreign Table	Foreign Key Column
EGO_CHANGE_PROPAGATION_MAPS	ego_change_lines_b	CHANGE_LINE_ID
EGO_CHANGE_PROPAGATION_MAPS	ego_engineering_changes_b	CHANGE_ID
ego_change_logs	ego_change_propagation_maps	CHANGE_PROPAGATION_MAP_ID

Indexes

Index	Uniqueness	Tablespace	Columns
EGO_CHANGE_PROP_MAPS_N1	Non Unique	FUSION_TS_TX_DATA	CHANGE_ID, LOCAL_ORGANIZATION_ID, REVISED_LINE_TYPE, REVISED_LINE_ID1, REVISED_LINE_ID2, REVISED_LINE_ID3, REVISED_LINE_ID4, REVISED_LINE_ID5
EGO_CHANGE_PROP_MAPS_N2	Non Unique	FUSION_TS_TX_DATA	CHANGE_ID, LOCAL_ORGANIZATION_ID, REVISED_LINE_TYPE, LOCAL_REVISED_LINE_ID1, LOCAL_REVISED_LINE_ID2, LOCAL_REVISED_LINE_ID3, LOCAL_REVISED_LINE_ID4, LOCAL_REVISED_LINE_ID5
EGO_CHANGE_PROP_MAPS_PK	Unique	Default	CHANGE_PROPAGATION_MAP_ID