CSE_ASSET_RELATIONSHIPS_GT
This is an inprocess data staging table used in the processing of as built and as sold relationships from manufacturing and order management to installed base.
Details
-
Schema: FUSION
-
Object owner: CSE
-
Object type: TABLE
-
Tablespace: Default
Columns
Name | Datatype | Length | Precision | Comments |
---|---|---|---|---|
GTT_RELATIONSHIP_ID | NUMBER | 18 | The primary key of this global temporary table. Generated internally and rows deleted at the end of the session. | |
PARENT_GTT_RELATIONSHIP_ID | NUMBER | 18 | The reference to another row in the global temporary table that plays the part of a parent. | |
RELATIONSHIP_ACTION | VARCHAR2 | 30 | The action to create or update the relationship is captured here. | |
RELATIONSHIP_TYPE_CODE | VARCHAR2 | 30 | The type of relationship between the parent asset(object_id) and the child asset(subject_id). | |
OBJ_GTT_ASSET_ID | NUMBER | 18 | Parent asset that is in process in the assets global temporary table. | |
SUBJ_GTT_ASSET_ID | NUMBER | 18 | Child asset that is in process in the assets global temporary table. | |
OBJ_GTT_TXN_ID | NUMBER | 18 | The transaction context of the parent asset. | |
SUBJ_GTT_TXN_ID | NUMBER | 18 | The transaction context of the child asset. | |
GTT_GROUP_ID | NUMBER | 18 | The transaction grouping that this record is part of. | |
RELATIONSHIP_ID | NUMBER | 18 | The primary key of the production table cse_asset_relationships. | |
HIERARCHY_ID | NUMBER | 18 | The foreign key reference to the logical hierarchy. | |
OBJECT_TYPE | VARCHAR2 | 3 | The type of the object reference here. It could be 'A' for Asset or 'G' for Genealogy Object. When the object type is 'A', the object_id column stores the asset_id. When the object type is 'G', the object_id column stores the genealogy_object_id. | |
OBJECT_ID | NUMBER | 18 | Parent Asset Reference. Foreign key to the asset entity. | |
SUBJECT_TYPE | VARCHAR2 | 3 | The type of the subject reference here. It could be 'A' for Asset or 'G' for Genealogy Object. When the subject type is 'A', the subject_id column stores the asset_id. When the subject type is 'G', the subject_id column stores the genealogy_object_id. | |
SUBJECT_ID | NUMBER | 18 | Child Asset Reference. Foreign key to the asset entity | |
LOGICAL_OBJECT_ID | NUMBER | 18 | A superlative relationship (As Sold Structure) is built using the SubjectID -> LogicalObjectID self hierarchy to present the sales view of the customer assets. This column is used purely for that purpose. | |
LOGICAL_GTT_ASSET_ID | NUMBER | 18 | A superlative relationship (As Sold Structure) is built using the SubjectID -> LogicalObjectID self hierarchy to present the sales view of the customer assets. This column is used purely for that purpose. This is the global temp table reference. | |
SPLIT_FROM_GTT_REL_ID | NUMBER | 18 | If relationships are split, then the reference to the relationship that this row split from. | |
POSITION_NUMBER | NUMBER | The position number of the component or the node in the asset logical hierarchy. | ||
POTENTIAL_FLAG | VARCHAR2 | 1 | There are use cases in the Manufacturing flow where a component of relationship is assumed based on the delayed birthing point of the assembly serial number. In such cases the component takes on a Many-to-Many relationship with multiple parent serial numbers. These relationships are marked as potential relationships with this flag. | |
SPLIT_FLAG | VARCHAR2 | 1 | This flag indicates a relationship between genealogy objects, mainly the lots that are split from another. The relationship will be created with the relationship type as "component of", with the split flag set. | |
MERGE_FLAG | VARCHAR2 | 1 | This flag indicates a relationship between genealogy objects, mainly the lots that are merged to another. The relationship will be created with the relationship type as "component of", with the merge flag set. | |
TRANSLATE_FLAG | VARCHAR2 | 1 | This flag indicates a relationship between genealogy objects, mainly the lots that are translated to another. The relationship will be created with the relationship type as "component of", with the translate flag set. | |
ACTIVE_START_DATE | TIMESTAMP | The active start date of the relationship. | ||
ACTIVE_END_DATE | TIMESTAMP | The active end date of the relationship. | ||
OBJECT_ITEM_ID | NUMBER | 18 | The item reference in the parent asset. | |
OBJECT_SERIAL_NUMBER | VARCHAR2 | 80 | The serial number reference of the parent asset. | |
OBJECT_LOT_NUMBER | VARCHAR2 | 80 | The lot number reference of the parent asset. | |
OBJECT_ASSET_QTY | NUMBER | The quantity of the parent asset. | ||
SUBJECT_ITEM_ID | NUMBER | 18 | The item reference in the child asset. | |
SUBJECT_SERIAL_NUMBER | VARCHAR2 | 80 | The serial number reference in the child asset. | |
SUBJECT_LOT_NUMBER | VARCHAR2 | 80 | The lot number reference in the child asset. | |
SUBJECT_ASSET_QTY | NUMBER | The child asset quantity. | ||
MATCH_FOUND | VARCHAR2 | 1 | This flag indicates whether a match is found already or not. | |
TRANSACTED_RELATIONSHIP_ID | NUMBER | 18 | The foreign key to the intersection entity cse_transacted_relationships. This entity holds the many to many association between transactions and relationships. | |
EVENT_RAISED_FLAG | VARCHAR2 | 1 | Flag indicating whether an asset event was raised or not. |
Indexes
Index | Uniqueness | Columns |
---|---|---|
CSE_ASSET_RELATIONSHIPS_GT_N1 | Non Unique | GTT_GROUP_ID, RELATIONSHIP_ID, SUBJECT_ID, OBJECT_ID |