MOW_MRA_TBA_OBJECT_SOURCE
Work Object data used in Territory based assignment
Details
-
Schema: FUSION
-
Object owner: MOW
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
MOW_MRA_TBA_OBJECT_SOURCE_PK |
WFAMILY_CODE, WEXECUTION_NUMBER, WMAPPING_SET_ID, WOBJECT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| WOBJECT_ID | NUMBER | 18 | Yes | wobject_id | |
| WFAMILY_CODE | VARCHAR2 | 30 | Yes | WFAMILY_CODE | |
| FAMILY_SOURCE_KEY | VARCHAR2 | 200 | Key to identify source for MRA families | ||
| WEXECUTION_NUMBER | NUMBER | 18 | Yes | WEXECUTION_NUMBER | |
| WMAPPING_SET_ID | VARCHAR2 | 64 | Yes | WMAPPING_SET_ID | |
| WACCT | NUMBER | 18 | WACCT | ||
| WACTYP | VARCHAR2 | 30 | WACTYP | ||
| WINDST | VARCHAR2 | 30 | WINDST | ||
| WORGTP | VARCHAR2 | 30 | WORGTP | ||
| WAUX3 | VARCHAR2 | 30 | WAUX3 | ||
| WAUX2 | VARCHAR2 | 30 | WAUX2 | ||
| WAUX1 | VARCHAR2 | 30 | WAUX1 | ||
| WEXT1 | VARCHAR2 | 30 | WEXT1 | ||
| WEXT2 | VARCHAR2 | 30 | WEXT2 | ||
| WEXT3 | VARCHAR2 | 30 | WEXT3 | ||
| WEXT4 | VARCHAR2 | 30 | WEXT4 | ||
| WEXT5 | VARCHAR2 | 30 | WEXT5 | ||
| WEXT6 | VARCHAR2 | 30 | WEXT6 | ||
| WEXT7 | VARCHAR2 | 30 | WEXT7 | ||
| WEXT8 | VARCHAR2 | 30 | WEXT8 | ||
| WEXT9 | VARCHAR2 | 30 | WEXT9 | ||
| WEXT10 | VARCHAR2 | 30 | WEXT10 | ||
| WGEO | NUMBER | 18 | WGEO | ||
| WSALES_CHANNEL | VARCHAR2 | 18 | WSALES_CHANNEL | ||
| WPROD | NUMBER | 18 | WPROD | ||
| WCSIZE | VARCHAR2 | 30 | WCSIZE | ||
| WBUNIT | NUMBER | 18 | Business Unit Value | ||
| WPRTNR | NUMBER | 18 | Partner Value | ||
| WCOUNTRY | VARCHAR2 | 2 | WCOUNTRY | ||
| WSTATE | VARCHAR2 | 60 | WSTATE | ||
| WPROVINCE | VARCHAR2 | 60 | WPROVINCE | ||
| WCOUNTY | VARCHAR2 | 60 | WCOUNTY | ||
| WCITY | VARCHAR2 | 60 | WCITY | ||
| WPOSTAL_CODE | VARCHAR2 | 60 | POSTAL_CODE | ||
| WRESOURCE_ID | NUMBER | 18 | RESOURCE_ID | ||
| WAE1 | VARCHAR2 | 150 | AE1 | ||
| WAE2 | VARCHAR2 | 150 | AE2 | ||
| WAE3 | VARCHAR2 | 150 | AE3 | ||
| WAE4 | VARCHAR2 | 150 | AE4 | ||
| WAE5 | VARCHAR2 | 150 | AE5 | ||
| BATCH_ID | NUMBER | 18 | BATCH_ID | ||
| FIRST_NODE | VARCHAR2 | 10 | FIRST_NODE | ||
| W_DIM_PATTTERN | VARCHAR2 | 900 | W_DIM_PATTTERN | ||
| W_COV_TYPE_DV_PATTERN | VARCHAR2 | 900 | W_COV_TYPE_DV_PATTERN | ||
| W_COVERAGE_TYPE_CODE | VARCHAR2 | 30 | W_COVERAGE_TYPE_CODE | ||
| W_MAPPINGS_IDS | VARCHAR2 | 4000 | W_MAPPINGS_IDS | ||
| MAPPED_WORK_OBJECT_ID | NUMBER | 18 | Stores Work object mapped to candidate object | ||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MOW_MRA_TBA_OBJECT_SOURCE_U1 | Unique | Default | WFAMILY_CODE, WEXECUTION_NUMBER, WMAPPING_SET_ID, WOBJECT_ID |