Wikiยทschemaยทschema/bas-tsk-tskwz-tsk-wrk-area.md

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)

#ColumnTypeDescription
1TSKWZ_OUINSTANCE ๐Ÿ”‘varcharOrganization Unit instance for the task work zone
2TSKWZ_TASK_NO ๐Ÿ”‘varcharTask number associated with the work zone
3TSKWZ_REVISION_NO ๐Ÿ”‘VarcharRevision number of the work zone task
4TSKWZ_WZ_FLAG ๐Ÿ”‘varcharFlag indicating whether it is a work zone task
5TSKWZ_CODE ๐Ÿ”‘varcharCode associated with the work zone
6TSKWZ_MODEL_NO ๐Ÿ”‘decimalModel number linked to the work zone
7TSKWZ_MODEL_OUvarcharOrganization Unit for the work zone model
8TSKWZ_BASE_MODEL_NO ๐Ÿ”‘varcharBase model number linked to the work zone
9TSKWZ_UTIvarcharUniversal Task Identifier for the work zone
10tskwz_taskcardkeybigintUnique key for the task card in the work zone
11TSKWZ_UNIQUE_IDvarcharUnique 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

Sample rows (from live DB)

TSKWZ_OUINSTANCETSKWZ_TASK_NOTSKWZ_REVISION_NOTSKWZ_WZ_FLAGTSKWZ_CODETSKWZ_MODEL_NO
2.0000:999995WABCA310
2.0000:999995WHA456A310
2.0000:999995Z100A310

Showing 3 of 6,912 rows.

See also