swo_visit_dft_pln_eotsk_dtl
Visit hub draft plan EO detail table. This table stores draft engineering order plans for aircraft visits, allowing for planning and review before final implementation.
Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: Contains draft records of EO task planning associated with a shop visit, helping in task allocation and sequencing
Primary key
vdcpt_unique_id
Columns (65)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | vdcpt_addl_Comments | varchar | Additional remarks related to the configuration or amendment |
| 2 | vdcpt_applevel | varchar | Specifies the first applicability level for the configuration |
| 3 | vdcpt_Comments | varchar | General comments entered for the configuration record |
| 4 | vdcpt_compliance_date | datetime | Date of compliance with the engineering order or task |
| 5 | vdcpt_compliance_time | Datetime | Time of compliance with the engineering order or task |
| 6 | vdcpt_complmcr | varchar | Reference to the maintenance change request that was complied with |
| 7 | vdcpt_component | varchar | Unique identifier for the component |
| 8 | vdcpt_component_id | varchar | Unique identifier of the component within the visit reference |
| 9 | vdcpt_concfg_revno | varchar | Revision number of the configuration change linked to the record |
| 10 | vdcpt_created_by | varchar | User who created the draft engineering order task planning details |
| 11 | vdcpt_created_date | datetime | Date when the draft engineering order task planning details were created |
| 12 | vdcpt_currval | varchar | The current value recorded in the system for the parameter or setting |
| 13 | vdcpt_document_no | varchar | Reference number for the related maintenance visit |
| 14 | vdcpt_eocmpl_sts | varchar | Status of compliance with the engineering order |
| 15 | vdcpt_eo_no | varchar | Engineering order number associated with the compliance record |
| 16 | vdcpt_eo_rev | varchar | Revision number of the engineering order used for compliance |
| 17 | vdcpt_execinfo | varchar | Information regarding the execution of the task or engineering order |
| 18 | vdcpt_execution_comments | varchar | Comments regarding task or engineering order execution |
| 19 | vdcpt_exe_document | varchar | Execution documents associated with the order or task |
| 20 | vdcpt_filappgrp | varchar | Group under which applicability conditions are defined |
| 21 | vdcpt_filapplvl | varchar | Level under which applicability is categorized |
| 22 | vdcpt_insqty | int | Number of components or parts installed |
| 23 | vdcpt_level_code | varchar | Code indicating the level within the configuration structure |
| 24 | VDCPT_LVLNUMBER | int | Number representing the hierarchical level in the configuration |
| 25 | vdcpt_maxqty | int | The maximum number of parts or components allowed |
| 26 | vdcpt_minqty | int | The minimum number of parts or components required |
| 27 | vdcpt_modified_by | varchar | User who last modified the record |
| 28 | vdcpt_modified_date | datetime | Date when the record was last modified |
| 29 | vdcpt_mssgecnter | varchar | Message center details linked to the record |
| 30 | vdcpt_nhalvl_code | varchar | Level code of the next higher assembly |
| 31 | vdcpt_nha_comp | varchar | Identifier of the next higher assembly component |
| 32 | vdcpt_nha_part | varchar | Part number of the next higher assembly component |
| 33 | vdcpt_nha_poscode | varchar | Position code of the next higher assembly component |
| 34 | vdcpt_ou_instance | int | Organizational unit instance associated with the record |
| 35 | VDCPT_Ovride_EO | varchar | Engineering order overridden in the configuration |
| 36 | VDCPT_Ovride_Ref | varchar | Reference for the override applied |
| 37 | VDCPT_Ovride_Remarks | varchar | Remarks associated with the override |
| 38 | vdcpt_partdesc | varchar | Description of the part in the configuration |
| 39 | vdcpt_part_no | varchar | Unique part number assigned to the component |
| 40 | vdcpt_pieceprt | varchar | Specifies whether the part is treated as a piece part |
| 41 | vdcpt_planeo_seq | int | Sequence number of the planned engineering order |
| 42 | vdcpt_plneosb | varchar | Service bulletin associated with the planned engineering order |
| 43 | vdcpt_plntsk | varchar | Planned task related to the engineering order or configuration |
| 44 | vdcpt_plntskupd | varchar | Date when the planned task was last updated |
| 45 | vdcpt_positioncode | varchar | Code assigned to the position of the component in the structure |
| 46 | vdcpt_pospart | varchar | Part assigned to the defined position code |
| 47 | vdcpt_prteffid | bigint | Identifier defining part effectivity in the configuration |
| 48 | vdcpt_refqty | int | Quantity specified for reference in the record |
| 49 | vdcpt_Remarks | varchar | Remarks or notes recorded for the configuration |
| 50 | vdcpt_remval | varchar | Remaining operational life value of the component |
| 51 | vdcpt_schedval | varchar | Scheduled operational value assigned to the component |
| 52 | vdcpt_serial_no | varchar | Serial number assigned to the component |
| 53 | vdcpt_taskdesc | varchar | Description of the task associated with the configuration |
| 54 | vdcpt_taskrev | varchar | Revision number of the task linked to the record |
| 55 | vdcpt_task_no | varchar | Unique task number for identification |
| 56 | vdcpt_tskcmplsts | varchar | Compliance status of the task such as complied or pending |
| 57 | vdcpt_ud1 | varchar | User defined field one for custom configuration information |
| 58 | vdcpt_ud2 | varchar | User defined field two for custom configuration information |
| 59 | vdcpt_ud3 | varchar | User defined field three for custom configuration information |
| 60 | vdcpt_ud4 | varchar | User defined field four for custom configuration information |
| 61 | vdcpt_ud5 | datetime | User defined field five for custom configuration information |
| 62 | vdcpt_ud6 | datetime | User defined field six for custom configuration information |
| 63 | vdcpt_udcmplseq | int | Sequence number used to track compliance order |
| 64 | vdcpt_unique_id 🔑 | bigint | Unique identifier assigned to the record |
| 65 | VDCPT_updtBy | varchar | User who last updated the record |
Sample rows (from live DB)
vdcpt_addl_Comments | vdcpt_applevel | vdcpt_Comments | vdcpt_compliance_date | vdcpt_compliance_time | vdcpt_complmcr |
|---|---|---|---|---|---|
| — | — | — | 2023-08-30 15:35:00 | — | — |
| — | — | — | — | — | — |
| — | — | — | 2023-08-30 15:35:00 | — | — |
Showing 3 of 5,247 rows.