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 |