SWO_Visit_LLP_Info
Visit hub draft plan EO task detail table. This table contains detailed task information for draft engineering order plans, enabling comprehensive planning and resource allocation.
Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: Maintains records of life-limited parts associated with a shop visit, capturing usage, life consumed, and remaining cycles or hours for regulatory compliance
This table is the canonical store for the VisitLLP entity.
Primary key
VLLP_UNIQUE_ID
Columns (28)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | VLLP_ATTACHEDCOMP | varchar | Identifier of the attached component |
| 2 | VLLP_ATTPRT | varchar | Part number of the attached component |
| 3 | VLLP_ATTSRL | varchar | Serial number of the attached component |
| 4 | VLLP_BRKUPFLAG | varchar | Flag indicating whether breakup of the component is required |
| 5 | VLLP_BUILDBY | varchar | Specifies the entity responsible for building the component |
| 6 | VLLP_Component_ID | varchar | Unique identifier assigned to the component |
| 7 | VLLP_Cumulative_Usage | numeric | Cumulative usage recorded for the component |
| 8 | VLLP_Disposition | varchar | Disposition status of the component after evaluation |
| 9 | VLLP_Document_No | varchar | Reference number of the visit associated with the component |
| 10 | VLLP_ISSNOTES | varchar | Notes regarding issuance of the document |
| 11 | VLLP_Level_Code | varchar | Code representing the hierarchical level within the configuration |
| 12 | VLLP_MOD | varchar | Modification number assigned to the record |
| 13 | VLLP_NHA_Component_ID | varchar | Unique identifier of the next higher assembly component |
| 14 | VLLP_Ou_instance | int | Organizational unit instance linked to the component |
| 15 | VLLP_Parameter | varchar | Parameter value defined for the configuration or component |
| 16 | VLLP_Pos_Code | varchar | Position code of the component within the configuration |
| 17 | VLLP_PROTUSAGE | numeric | Usage value calculated based on proration |
| 18 | VLLP_Remaining_Life | numeric | Remaining operational life of the component |
| 19 | VLLP_Remarks | varchar | Remarks entered for the record |
| 20 | VLLP_REPLPRTCOND | varchar | Condition of the replication part linked to the record |
| 21 | VLLP_Req_for | varchar | Details of the request made for the component or configuration |
| 22 | VLLP_Rot_Component_ID | varchar | Identifier of the rotable component |
| 23 | VLLP_RSEDMECH_FLAG | varchar | Flag indicating whether the mechanical restriction applies |
| 24 | VLLP_Tareget_Config_Limit | numeric | Limit defined for the target configuration |
| 25 | VLLP_Target_Build_upvalue | numeric | Target buildup value of the configuration |
| 26 | VLLP_TrgtThrst_Code | varchar | Code defining the thrust rating of the component or engine |
| 27 | VLLP_UNIQUE_ID 🔑 | bigint | Unique identifier assigned to the record |
| 28 | VLLP_Usage_Proration | numeric | Usage value calculated based on proration rules |
Relationships (1)
- VisitPackage (SWO_Visit_Lvl_Info) →
VISIT_HAS_LLP_INFO(this table is target)- Join:
SWO_Visit_Lvl_Info.visit_id = SWO_Visit_LLP_Info.VLLP_Component_ID - Visit has LLP information
- Join:
Sample rows (from live DB)
VLLP_ATTACHEDCOMP | VLLP_ATTPRT | VLLP_ATTSRL | VLLP_BRKUPFLAG | VLLP_BUILDBY | VLLP_Component_ID |
|---|---|---|---|---|---|
| — | — | — | — | -1 | — |
| — | — | — | — | -1 | — |
| — | — | — | — | -1 | — |
Showing 3 of 675 rows.