SWO_Config_review_record
This table stores records of configuration reviews conducted during the maintenance process. It ensures that all aircraft components, software, and modifications comply with the approved configuration baseline.
Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: This category includes tables and columns that capture the usage details of components within a Shop Work Order (SWO) based on reference visits. It tracks the range, consumption, and breakup of components used during maintenance tasks, providing a detailed record of component allocation, consumption quantities, and usage patterns
This table is the canonical store for the ConfigReview entity.
Primary key
SCR_Review_Uniequeid
Columns (31)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | SCR_apprej_rmks | varchar | Remarks related to the approval or rejection decision |
| 2 | SCR_Attachment_Discrepancy | varchar | Discrepancy linked as an attachment |
| 3 | SCR_Attachment_Remarks | varchar | Remarks associated with the attachment |
| 4 | SCR_Attachment_Status | varchar | Current status of the attachment |
| 5 | SCR_Att_Discp_Category | varchar | Category of discrepancy attached to the record |
| 6 | SCR_Comp_ID | varchar | Identifier of the associated component |
| 7 | SCR_CreatedDt | Datetime | Date when the record was created |
| 8 | SCR_created_by | varchar | User who created the record |
| 9 | SCR_DocumentNo | varchar | Number assigned to the related document |
| 10 | SCR_Level_code | varchar | Code indicating the record’s level in the hierarchy |
| 11 | SCR_Lot_No | varchar | Lot number linked to the record |
| 12 | SCR_Mandatory_pos | varchar | Indicates whether the position is mandatory |
| 13 | SCR_modifiedDt | datetime | Date when the record was last modified |
| 14 | SCR_ModifiedRemarks | varchar | Remarks provided during modification |
| 15 | SCR_modified_by | varchar | User who modified the record |
| 16 | SCR_NHA_Component_Id | varchar | Identifier of the next higher assembly component |
| 17 | SCR_Ou_instance | varchar | Organizational unit where the record belongs |
| 18 | SCR_partno | varchar | Part number associated with the record |
| 19 | SCR_Position_status | varchar | Status of the position in the system |
| 20 | SCR_POS_code | varchar | Code identifying the component’s position |
| 21 | SCR_Pos_Partno | varchar | Part number assigned to the component’s position |
| 22 | SCR_Pos_type | varchar | Type of position in the assembly |
| 23 | SCR_Quantity | int | Quantity of the component |
| 24 | SCR_REMARKS | varchar | Remarks provided for the record |
| 25 | SCR_Review_No | varchar | Review number assigned for the inspection |
| 26 | SCR_Review_Status | varchar | Status of the review process |
| 27 | SCR_Review_Type | varchar | Type of review performed |
| 28 | SCR_Review_Uniequeid 🔑 | bigint | Unique identifier for the review record |
| 29 | SCR_serialno | varchar | Serial number of the component |
| 30 | SCR_SWO_No | varchar | Shop Work Order number associated with the record |
| 31 | SCR_timestamp | int | System timestamp for the record |
Relationships (1)
- ShopWorkOrder (swo_swoh_shop_wo_hdr) →
SWO_HAS_CONFIG_REVIEW(this table is target)- Join:
swo_swoh_shop_wo_hdr.swoh_swo_no = SWO_Config_review_record.SCR_SWO_No - SWO has config review
- Join:
Sample rows (from live DB)
SCR_apprej_rmks | SCR_Attachment_Discrepancy | SCR_Attachment_Remarks | SCR_Attachment_Status | SCR_Att_Discp_Category | SCR_Comp_ID |
|---|---|---|---|---|---|
| — | — | — | NONE | — | — |
| — | — | — | NONE | — | — |
| — | — | — | — | — | — |
Showing 3 of 787 rows.