BAS_TSK_TSKWZ_TSK_WRK_AREA
This is a task management master table that stores work area/zone details for tasks. It ensures resources, zones, and task definitions are consistently referenced when creating or executing transactional tasks.
Process: MAINTPLANNING · Component: BASTask · Table type: Master Table Category: Provides master data for task definitions, sub-task definitions and task zones used in maintenance and operational planning.
This table is the canonical store for the TaskWorkArea entity.
Primary key
TSKWZ_TASK_NO, TSKWZ_REVISION_NO, TSKWZ_WZ_FLAG, TSKWZ_CODE, TSKWZ_MODEL_NO, TSKWZ_BASE_MODEL_NO, TSKWZ_OUINSTANCE
Columns (11)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | TSKWZ_OUINSTANCE 🔑 | varchar | Organization Unit instance for the task work zone |
| 2 | TSKWZ_TASK_NO 🔑 | varchar | Task number associated with the work zone |
| 3 | TSKWZ_REVISION_NO 🔑 | Varchar | Revision number of the work zone task |
| 4 | TSKWZ_WZ_FLAG 🔑 | varchar | Flag indicating whether it is a work zone task |
| 5 | TSKWZ_CODE 🔑 | varchar | Code associated with the work zone |
| 6 | TSKWZ_MODEL_NO 🔑 | decimal | Model number linked to the work zone |
| 7 | TSKWZ_MODEL_OU | varchar | Organization Unit for the work zone model |
| 8 | TSKWZ_BASE_MODEL_NO 🔑 | varchar | Base model number linked to the work zone |
| 9 | TSKWZ_UTI | varchar | Universal Task Identifier for the work zone |
| 10 | tskwz_taskcardkey | bigint | Unique key for the task card in the work zone |
| 11 | TSKWZ_UNIQUE_ID | varchar | Unique identification number for the work zone task |
Relationships (1)
- TaskMaster (BAS_TSK_TSK_TASK_MASTER) →
TASK_AT_WORKAREA(this table is target)- Join:
BAS_TSK_TSK_TASK_MASTER.TSK_TASK_NO = BAS_TSK_TSKWZ_TSK_WRK_AREA.TSKWZ_TASK_NO - Task master has work area
- Join:
Sample rows (from live DB)
TSKWZ_OUINSTANCE | TSKWZ_TASK_NO | TSKWZ_REVISION_NO | TSKWZ_WZ_FLAG | TSKWZ_CODE | TSKWZ_MODEL_NO |
|---|---|---|---|---|---|
| 2.0 | 000:99999 | 5 | W | ABC | A310 |
| 2.0 | 000:99999 | 5 | W | HA456 | A310 |
| 2.0 | 000:99999 | 5 | Z | 100 | A310 |
Showing 3 of 6,912 rows.