ACA_STRUCTURE_EXPL_STAGING
Intermediate table to store the structure explosion flattened skinny data for Structures and Components subject area in Transactional Business Intelligence
Details
-
Schema: FUSION
-
Object owner: ACA
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
ACA_STRUCTURE_EXPL_STAGING_PK |
TOP_BILL_SEQUENCE_ID, TOP_ITEM_REVISION_ID, BILL_SEQUENCE_ID, COMPONENT_SEQUENCE_ID, PLAN_LEVEL, COMP_SEQ_PATH |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TOP_BILL_SEQUENCE_ID | NUMBER | 18 | Yes | Top item bill of material unique indentifier | |
| ALTERNATE_BOM_DESIGNATOR | VARCHAR2 | 80 | The alternate structure designator code for primary structures | ||
| TOP_ITEM_ID | NUMBER | 18 | The identifier for the top-level item | ||
| TOP_ITEM_ORG_ID | NUMBER | 18 | Top item organization identifier | ||
| TOP_ITEM_REVISION_ID | NUMBER | Yes | The identifier for the revision of the top-level item | ||
| BILL_SEQUENCE_ID | NUMBER | 18 | Yes | Bill of material unique identifier | |
| COMPONENT_SEQUENCE_ID | NUMBER | 18 | Yes | The unique identifier for an item component sequence | |
| PLAN_LEVEL | NUMBER | Yes | The level within the item structure where the item is displayed | ||
| 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_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. | ||
| COMPONENT_SEQ_PATH | VARCHAR2 | 4000 | Top Bill of Material Item Sequence Path | ||
| PARENT_ITEM_ID | NUMBER | 18 | The identifier of the parent item | ||
| PARENT_ITEM_ORG_ID | NUMBER | 18 | Organization identifier of parent item | ||
| PARENT_ITEM_REVISION_ID | NUMBER | Parent item revision identifier | |||
| COMPONENT_ITEM_ID | VARCHAR2 | 20 | The identifier of the item component | ||
| COMPONENT_ITEM_ORG_ID | NUMBER | 18 | Organization identifier of component item | ||
| COMPONENT_ITEM_REVISION_ID | NUMBER | Component item revision identifier | |||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or 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. | ||
| SORT_CODE | NUMBER | Used for structure parent item sort | |||
| COMP_SEQ_PATH | VARCHAR2 | 4000 | Yes | Component sequence path in structure | |
| TOP_ITEM_REV_EFFECTIVE_DATE | TIMESTAMP | Holds Revision Effecitivity Date for the Top Item extracted for explosion. | |||
| ITEM_PENDING_REV_FLAG | VARCHAR2 | 1 | Flag holds if the item is in pending revision or not. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ACA_STRUCTURE_EXPL_STAGING_N1 | Non Unique | Default | PARENT_ITEM_ID, PARENT_ITEM_ORG_ID |
| ACA_STRUCTURE_EXPL_STAGING_N2 | Non Unique | Default | COMPONENT_ITEM_ID, COMPONENT_ITEM_ORG_ID |
| ACA_STRUCTURE_EXPL_STAGING_N3 | Non Unique | Default | BILL_SEQUENCE_ID |
| ACA_STRUCTURE_EXPL_STAGING_N4 | Non Unique | Default | COMPONENT_SEQUENCE_ID |
| ACA_STRUCTURE_EXPL_STAGING_N5 | Non Unique | Default | COMPONENT_ITEM_REVISION_ID |
| ACA_STRUCTURE_EXPL_STAGING_N6 | Non Unique | Default | PARENT_ITEM_REVISION_ID |
| ACA_STRUCTURE_EXPL_STAGING_N7 | Non Unique | Default | TOP_ITEM_ID |
| ACA_STRUCTURE_EXPL_STAGING_N8 | Non Unique | Default | TOP_ITEM_ORG_ID |
| ACA_STRUCTURE_EXPL_STAGING_U1 | Unique | Default | TOP_BILL_SEQUENCE_ID, TOP_ITEM_REVISION_ID, BILL_SEQUENCE_ID, COMPONENT_SEQUENCE_ID, PLAN_LEVEL, COMP_SEQ_PATH |