MOT_TERR_DIM_MEM_FLAGS
Territory Dimension Member Flag is the entity that holds the information on the explicit/implicit flags for all dimension members (except for Account Type dimension) and on the visibility flag of the "unspecified" members.
Details
-
Schema: FUSION
-
Object owner: MOT
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
MOT_TERR_DIM_MEM_FLAGS_PK |
TERR_DIM_MEM_FLAG_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TERR_DIM_MEM_FLAG_ID | NUMBER | 18 | Yes | Unique Identifier of the Territory Dimension Member Flag. | |
| PARTITION_ID | NUMBER | 18 | Yes | Id of the "Flagging" partition. | |
| TERR_DIMENSION_ID | NUMBER | 18 | Yes | Foreign Key to the Territory Dimension entity. | |
| INTEGRATION_ID | VARCHAR2 | 80 | Yes | Common member identifier between OBI, Cube, and TM. The second component of the composite FK from Territory Dimension Member entity. The first component is Dimension Code. | |
| EXPLICIT_FLAG | VARCHAR2 | 1 | A flag identifying if the member is explicit or implicit. | ||
| ENABLE_UNSPEC_FLAG | VARCHAR2 | 1 | A flag identifying if an "unspecified" member will be created below the current member during synchronization process. | ||
| DIM_SUBTYPE_CODE | VARCHAR2 | 30 | Used only in the case of the Product dimension. The Dimension Subtype Code differentiates between products and product groups. Two allowed values are PROD, and PRODCAT. | ||
| ATTRIBUTE_PK1 | VARCHAR2 | 30 | A part of the FK to the Data Source. In the case of a composite key "Source Attribute PK2" is also populated. | ||
| ATTRIBUTE_PK2 | VARCHAR2 | 30 | A part of the FK to the Data Source. | ||
| LAST_UPDATE_TIME | TIMESTAMP | The time stamp of the last update (or creation). This attribute is needed by the ETL logic to perform the incremental update of the explicit flags in the OBI DW. | |||
| 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. | ||
| CONFLICT_ID | NUMBER | 18 | Yes | Disconnected Mobile: this value is used to guarantee the uniqueness of the row when duplicates are created in different databases (i.e. mobile databases or the server). | |
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| MOT_TERR_DIM_MEM_FLAGS | mot_terr_dimensions_b | TERR_DIMENSION_ID |
| MOT_TERR_DIM_MEM_FLAGS | mot_terr_dim_partitions | PARTITION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MOT_TERR_DIM_MEM_FLAGS_N1 | Non Unique | Default | PARTITION_ID, TERR_DIMENSION_ID, INTEGRATION_ID |
| MOT_TERR_DIM_MEM_FLAGS_N2 | Non Unique | Default | ATTRIBUTE_PK1, ATTRIBUTE_PK2 |
| MOT_TERR_DIM_MEM_FLAGS_N3 | Non Unique | Default | TERR_DIMENSION_ID, INTEGRATION_ID, EXPLICIT_FLAG |
| MOT_TERR_DIM_MEM_FLAGS_N4 | Non Unique | Default | INTEGRATION_ID, DIM_SUBTYPE_CODE |
| MOT_TERR_DIM_MEM_FLAGS_PK | Unique | Default | TERR_DIM_MEM_FLAG_ID |