swo_swoptg_part_tag_list
Historical records for SWO part requirement details. This table maintains a complete history of all part requirement changes, modifications, and updates throughout the work order lifecycle.
Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: Part tag assignments for SWO tasks
This table is the canonical store for the PartTag entity.
Primary key
swoptg_unique_no
Columns (33)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | sowptg_approved_by | varchar | Approved by |
| 2 | sowptg_approved_date | datetime | Approved date |
| 3 | sowptg_Filename | varchar | Document attachment details |
| 4 | sowptg_no_copies | int | Number of certificate copies printed |
| 5 | sowptg_ouinstance | int | OU instance |
| 6 | Sowptg_replaced_tag_id | varchar | Replaced part tag ID |
| 7 | sowptg_tag_status | varchar | Part tag status |
| 8 | sowptg_timestamp | int | Timestamp |
| 9 | swoptg_auth_emp_code | varchar | Employee code |
| 10 | swoptg_auth_license_no | varchar | License number |
| 11 | swoptg_auth_no | varchar | Authorization number |
| 12 | swoptg_auth_ref_no | varchar | Authorized reference number |
| 13 | swoptg_auth_skill_code | varchar | Skill code |
| 14 | swoptg_auth_wc_code | varchar | Primary work center |
| 15 | swoptg_comments | varchar | Remarks for part tag |
| 16 | swoptg_created_by | varchar | Created by |
| 17 | swoptg_created_date | datetime | Created date |
| 18 | swoptg_current_flag | varchar | Current flag |
| 19 | swoptg_final_disposition | varchar | Final disposition type |
| 20 | swoptg_involved_in_rework | varchar | Indicates involvement in rework |
| 21 | swoptg_issue_date | datetime | Issue date |
| 22 | swoptg_last_printed_on | datetime | Printed status |
| 23 | swoptg_modified_by | varchar | Records the user or system ID who last updated the record |
| 24 | swoptg_modified_date | datetime | Captures the date and time when the record was last modified |
| 25 | swoptg_reason_for_rej | varchar | Specifies the reason why a part, task, or work order was rejected during review or execution |
| 26 | swoptg_sb_ad_ref | varchar | References the Service Bulletin or Airworthiness Directive associated with the part or work order |
| 27 | swoptg_swo_event_id | varchar | Identifies the event linked to the shop work order, used for grouping or tracking operations |
| 28 | swoptg_swo_no | varchar | Unique identifier for the shop work order |
| 29 | swoptg_swo_part | varchar | Code of the part associated with the shop work order |
| 30 | swoptg_swo_serial | varchar | Serial number of the part associated with the shop work order |
| 31 | swoptg_tag_id | varchar | Code used to tag or identify the part |
| 32 | swoptg_unique_no 🔑 | int | Unique identifier for the record, serving as the primary key |
| 33 | swoptg_work_performed | varchar | Lists all execution-level tasks performed under the shop work order |
Relationships (1)
- SWOTask (swo_swostk_sub_task_details) →
SWO_HAS_PART_TAG(this table is target)- Join:
swo_swostk_sub_task_details.swostk_swo_no = swo_swoptg_part_tag_list.swoptg_swo_no - Task has part tags
- Join:
Sample rows (from live DB)
sowptg_approved_by | sowptg_approved_date | sowptg_Filename | sowptg_no_copies | sowptg_ouinstance | Sowptg_replaced_tag_id |
|---|---|---|---|---|---|
| fgauthier1 | 2011-11-22 18:12:44.647 | — | 1.0 | 2 | — |
| fgauthier1 | 2011-11-22 18:23:17.690 | — | 1.0 | 2 | — |
| fgauthier1 | 2011-11-22 18:54:11.493 | — | 1.0 | 2 | — |
Showing 3 of 67 rows.