SWO_CMP_RNGCON_USAGE_BREAKUP
This table provides detailed usage breakup of aircraft components during a maintenance visit. It tracks the consumption of components within their defined operating range, offering insights into part utilization and wear.
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
Primary key
CMPUB_UNIQUE_ID
Columns (17)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | CMPUB_COMPONENTID | varchar | Identifier of the component record |
| 2 | CMPUB_CREATEDDATE | datetime | Date when the component record was created |
| 3 | CMPUB_CREATREBY | varchar | User who created the component record |
| 4 | CMPUB_MOD | varchar | Modification number of the component |
| 5 | CMPUB_MODIFIEDATE | datetime | Date when the component record was modified |
| 6 | CMPUB_MODIFIEDBY | varchar | User who modified the component record |
| 7 | CMPUB_OUINSTANCE | int | Organizational unit where the component record belongs |
| 8 | CMPUB_PARAM_CODE | varchar | Code of the associated parameter |
| 9 | CMPUB_REMARKS | varchar | Additional remarks related to the component record |
| 10 | CMPUB_REMLIFELMT | numeric | Limit of remaining usable life for the component |
| 11 | CMPUB_ROOTCOMPID | varchar | Identifier of the root component in the hierarchy |
| 12 | CMPUB_THRSTRTNG | varchar | Thrust rating value of the component |
| 13 | CMPUB_TRGTLIFELMT | numeric | Target life limit defined for the component |
| 14 | CMPUB_UNIQUE_ID 🔑 | bigint | System-generated unique identifier for the record |
| 15 | CMPUB_USAGVAL | numeric | Recorded usage value for the component |
| 16 | CMPUB_USGPRORTN | numeric | Usage proration details for the component |
| 17 | CMPUB_VISITREF | varchar | Reference number of the related maintenance visit |
Sample rows (from live DB)
CMPUB_COMPONENTID | CMPUB_CREATEDDATE | CMPUB_CREATREBY | CMPUB_MOD | CMPUB_MODIFIEDATE | CMPUB_MODIFIEDBY |
|---|---|---|---|---|---|
| COMP-004372 | — | — | — | 2022-12-16 18:20:19.330 | DMUSER |
| COMP-002188-2022 | — | — | — | 2022-12-16 18:20:19.330 | DMUSER |
| COMP-002188-2022 | — | — | — | 2022-12-16 18:20:19.330 | DMUSER |
Showing 3 of 740 rows.