MOT_TERR_BNDRY_VALS_DN_GT
This table, maintains the list of rules to be denormalized for the partition which is promoted.
Details
-
Schema: FUSION
-
Object owner: MOT
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Precision | Not-null | Comments |
|---|---|---|---|---|
| POPULATE_PHASE | NUMBER | 1 | Yes | Indicates the phase in which the Boundary Denorm reocrds are populated. |
| TERR_RULE_ID | NUMBER | 18 | Yes | Indicates the coverage or rule id of the territory |
| RULE_PROCESS_ORDER | NUMBER | 18 | Yes | Indicates the order in which the rules will be denormalized |
| RULE_LAST_UPDATE_DATE | TIMESTAMP | Indicates the rules's last_update_date at the time of populating this table |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| MOT_TERR_BNDRY_VALS_DN_GT_U1 | Unique | POPULATE_PHASE, TERR_RULE_ID, RULE_PROCESS_ORDER |