BAS_TSK_TSK_TASK_MASTER
This is a task management master table that stores task master details. 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 TaskMaster entity.
Primary key
tsk_unique_id
Columns (94)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | TSK_TASK_NO | varchar | Task number |
| 2 | TSK_REVISION_NO | varchar | Revision number of the task |
| 3 | TSK_NON_ROUTINE_TASK_NO | varchar | Non-routine task number |
| 4 | TSK_DSC_NO | varchar | Document sequence number for the task |
| 5 | TSK_DESCRIPTION | varchar | Description of the task |
| 6 | TSK_DESCRIPTION_UP | varchar | Task description in uppercase format |
| 7 | TSK_STATUS | datetime | Status of the task |
| 8 | TSK_REVISION_DATE | Varchar | Revision date of the task |
| 9 | TSK_REVISION_TYPE | Varchar | Type of revision (internal or external) |
| 10 | TSK_LATEST_REV_FLAG | Varchar | Flag indicating if this is the latest revision |
| 11 | TSK_TYPE | Varchar | Type of the task |
| 12 | TSK_CATEGORY | Varchar | Category of the task |
| 13 | TSK_TASK_APPLICABILITY | varchar | Applicability of the task to aircraft, engine, or component |
| 14 | TSK_RELATED_TASK_NO | varchar | Related task number associated with the main task |
| 15 | TSK_AMM_CMM_ITEM | varchar | Reference item from Aircraft Maintenance Manual or Component Maintenance Manual |
| 16 | TSK_SRC_DOC | varchar | Source document for the task such as Engineering Order or Work Order |
| 17 | TSK_OEM_NAME | varchar | Original Equipment Manufacturer name for the task |
| 18 | TSK_ATA_NO | int | ATA chapter number |
| 19 | TSK_ATA_OU | decimal | Organization Unit associated with the ATA chapter |
| 20 | TSK_EST_ELAPSED_TIME | varchar | Estimated elapsed time for the task |
| 21 | TSK_EST_ELAPSED_TUOM | decimal | Time unit of measure for the estimated elapsed time |
| 22 | TSK_EST_MAN_HRS | varchar | Estimated man hours required for the task |
| 23 | TSK_USER_DEFN1 | varchar | User-defined field one for the task |
| 24 | TSK_USER_DEFN2 | varchar | User-defined field two for the task |
| 25 | TSK_COMMENTS | #N/A | Comments related to the task |
| 26 | TSK_MODEL_COUNT | Varchar | Number of models linked to the task |
| 27 | TSK_UPD_PART_ACTUALS_FLAG | datetime | Flag indicating whether actual part updates are required |
| 28 | TSK_LAST_MODIFIED_TIME | varchar | Last modified time of the task record |
| 29 | TSK_CREATED_BY | varchar | User who created the task |
| 30 | TSK_APPROVED_BY | datetime | User who approved the task |
| 31 | TSK_CREATIONDATE | datetime | Date of task creation |
| 32 | TSK_APPROVEDDATE | decimal | Date when the task was approved |
| 33 | TSK_EST_ELAPSED_TIME_DISP | varchar | Display format of estimated elapsed time |
| 34 | TSK_FILENAME | varchar | File name associated with the task |
| 35 | TSK_MANUFACTURERNO | int | Manufacturer number linked to the task |
| 36 | TSK_MANUFACTAC_OU | int | Organization Unit for manufacturing aircraft components |
| 37 | TSK_MANUFACTSUP_OU | varchar | Organization Unit for manufacturing suppliers |
| 38 | TSK_AUTHCOMMENTS | varchar | Authorization comments for the task |
| 39 | TSK_LONG_DESCRIPTION | decimal | Detailed long description of the task |
| 40 | TSK_COMPONENT_COUNT | varchar | Number of components associated with the task |
| 41 | TSK_SRC_DOC_TYPE | varchar | Type of the source document |
| 42 | TSK_BASE_MODEL_NO | varchar | Base model number associated with the task |
| 43 | TSK_WORK_LOCATION_REF_NO | Varchar | Reference number for the work location |
| 44 | TSK_CLASS | Varchar | Class of the task |
| 45 | TSK_NO_OF_OCCUR | Varchar | Number of occurrences of the task |
| 46 | TSK_EXTERNAL_FLAG | int | Flag indicating if the task is external |
| 47 | TSK_BASE_MODEL_OU | varchar | Organization Unit for the base model |
| 48 | TSK_WF_DOC_KEY | varchar | Workflow document key for the task |
| 49 | TSK_STAGE | Varchar | Stage of the task in the process flow |
| 50 | TSK_OPERATIONAL_TYPE | varchar | Operational type of the task |
| 51 | TSK_WCCODE | int | Work Center code associated with the task |
| 52 | TSK_WCCODE_OU | int | Organization Unit for the Work Center code |
| 53 | TSK_SRC_DOC_OU | numeric | Organization Unit for the source document |
| 54 | TSK_WRENCH_TIME | numeric | Estimated wrench time for the task |
| 55 | TSK_IDEAL_TIME | varchar | Ideal time required for the task |
| 56 | TSK_EXE_PHASE | varchar | Execution phase of the task |
| 57 | TSK_MPD_ITEMNO | numeric | MPD (Maintenance Planning Document) item number |
| 58 | TSK_WRENCHTIME_MIN | numeric | Minimum wrench time in minutes |
| 59 | tsk_IDEALTIME_MIN | varchar | Minimum ideal time in minutes |
| 60 | TSK_UTI | varchar | Universal Task Identifier for the task |
| 61 | TSK_AMM | numeric | Reference to Aircraft Maintenance Manual |
| 62 | TSK_INS_MAN_HRS | #N/A | Inspection man hours required for the task |
| 63 | TSK_SKILL_CODE | varchar | Skill code required for performing the task |
| 64 | TSK_PREREV_FLAG | varchar | Flag indicating if the task is pre-revision |
| 65 | tsk_effect_remarks | varchar | Remarks regarding the effectivity of the task |
| 66 | Tsk_Wbscode | varchar | Work Breakdown Structure code associated with the task |
| 67 | tsk_msq_no | bigint | MSQ number for the task |
| 68 | tsk_unique_id 🔑 | varchar | Unique identification number of the task |
| 69 | TSK_CRTSOURCETYP | varchar | Creation source type of the task |
| 70 | TSK_CRTSOURCENO | varchar | Creation source number of the task |
| 71 | TSK_CRTSOURCEREV | varchar | Creation source revision of the task |
| 72 | tsk_cus_taskcard | varchar | Customer-specific task card reference |
| 73 | TSK_DFLTEXECCOM | varchar | Default execution comments for the task |
| 74 | tsk_rii_flag | datetime | Flag indicating if Required Inspection Item (RII) applies |
| 75 | tsk_efffrom_date | varchar | Effective from date for the task |
| 76 | tsk_eo_class | varchar | Engineering Order class for the task |
| 77 | tsk_mandatory | varchar | Flag indicating if the task is mandatory |
| 78 | tsk_reliaimpact | varchar | Reliability impact associated with the task |
| 79 | tsk_userdef4 | varchar | User-defined field four for the task |
| 80 | tsk_userdef5 | varchar | User-defined field five for the task |
| 81 | tsk_userdef6 | varchar | User-defined field six for the task |
| 82 | TSK_EMP_LOADING | varchar | Employee loading details for the task |
| 83 | TSK_QTY_TYPE | varchar | Quantity type for the task |
| 84 | tsk_sch_app | datetime | Flag indicating whether scheduling is applicable |
| 85 | tsk_amm_cmm_item_date | varchar | Aircraft or Component Maintenance Manual item date reference |
| 86 | tsk_amm_cmm_itemrev | varchar | Aircraft or Component Maintenance Manual item revision reference |
| 87 | tsk_rii_app_flag | varchar | Flag indicating applicability of Required Inspection Item |
| 88 | Tsk_etops | varchar | ETOPS (Extended-range Twin-engine Operations) reference for the task |
| 89 | tsk_retrem | varchar | Remarks regarding task removal |
| 90 | tsk_rii_skill | varchar | Skill required for Required Inspection Item |
| 91 | tsk_rii_type | varchar | Type of Required Inspection Item |
| 92 | tsk_mntlevelcode | varchar | Maintenance level code for the task |
| 93 | Tsk_Assmtsk | varchar | Assessment task reference |
| 94 | tsk_taskcardkey | #N/A | Unique task card key |
Relationships (4)
TASK_HAS_SPARE→ TaskSparePart (bas_tsk_tskp_spare_part)- Join:
BAS_TSK_TSK_TASK_MASTER.TSK_TASK_NO = bas_tsk_tskp_spare_part.TSKP_TASK_NO - Task master has spare parts
- Join:
TASK_HAS_MODEL_EFFECT→ TaskModelEffect (bas_tsk_tskme_mdl_effect)- Join:
BAS_TSK_TSK_TASK_MASTER.TSK_TASK_NO = bas_tsk_tskme_mdl_effect.TSKME_TASK_NO - Task has model effectivity
- Join:
TASK_HAS_SUBTASK→ TaskDetails (bas_tsk_tskd_task_details)- Join:
BAS_TSK_TSK_TASK_MASTER.TSK_TASK_NO = bas_tsk_tskd_task_details.TSKD_TASK_NO - Task master has details
- Join:
TASK_AT_WORKAREA→ TaskWorkArea (BAS_TSK_TSKWZ_TSK_WRK_AREA)- 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)
TSK_TASK_NO | TSK_REVISION_NO | TSK_NON_ROUTINE_TASK_NO | TSK_DSC_NO | TSK_DESCRIPTION | TSK_DESCRIPTION_UP |
|---|---|---|---|---|---|
| 1-50C-2000-CMM-00005049 | ## | — | — | Repair | REPAIR |
| 1-A330-0000-CMM-00005050 | ## | — | — | Repair - 01 | REPAIR - 01 |
| 1-A330-0000-9X-00005051 | ## | — | — | Repair - 01 | REPAIR - 01 |
Showing 3 of 50,000 rows.