DP_WUHST_RESL_WORKUNIT_HST
Tracks historical information about work units used in discrepancy resolution. Supports traceability of labor applied to resolving specific discrepancies.
Process: LINEMAINTENANCE · Component: BasDP · Table type: Transaction Table Category: Groups the tables related to the discrepancy details, deferrals, deferral history, deferral categories, and resolution history
This table is the canonical store for the WorkUnitHistory entity.
Primary key
WUHST_DOC_NO, WUHST_DOC_TYPE, WUHST_LINE_NO, WUHST_WUSEQ_NO, WUHST_SLFSRC_OUINSTANCE
Columns (11)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | WUHST_SLFSRC_OUINSTANCE 🔑 | #N/A | Maintains the Organizational Unit number from which the work unit record was generated |
| 2 | WUHST_DOC_TYPE 🔑 | varchar | Maintains the type of the document in which the resolution work unit is recorded |
| 3 | WUHST_DOC_NO 🔑 | varchar | Maintains the document number associated with the resolution work unit |
| 4 | WUHST_LINE_NO 🔑 | #N/A | Maintains the line item number in the document referencing the work unit |
| 5 | WUHST_WUSEQ_NO 🔑 | #N/A | Maintains the sequence number assigned to the work unit |
| 6 | WUHST_WORKUNIT_TYPE | varchar | Maintains the type of the work unit executed for discrepancy resolution |
| 7 | WUHST_WORKUNIT_OU | #N/A | Maintains the Organizational Unit responsible for executing the work unit |
| 8 | WUHST_WORKUNIT_CODE | varchar | Maintains the unique code associated with the work unit |
| 9 | WUHST_ATA_NO | varchar | Maintains the ATA chapter number linked with the discrepancy resolution work unit |
| 10 | WUHST_EXEC_COMMENTS | varchar | Maintains any comments recorded during the execution work unit |
| 11 | WUHST_REVISION_NO | Varchar | Maintains the revision number of the document linked with the work unit |
Relationships (1)
- Discrepancy (DP_DISCP_DISCREPANCY_DTL) →
HAS_WORKUNIT_HISTORY(this table is target)- Join:
DP_DISCP_DISCREPANCY_DTL.DISCP_DOC_NO = DP_WUHST_RESL_WORKUNIT_HST.WUHST_DOC_NO - Discrepancy has work unit history
- Join:
Sample rows (from live DB)
WUHST_SLFSRC_OUINSTANCE | WUHST_DOC_TYPE | WUHST_DOC_NO | WUHST_LINE_NO | WUHST_WUSEQ_NO | WUHST_WORKUNIT_TYPE |
|---|---|---|---|---|---|
| 2.0 | DP | % | 1.0 | 1.0 | NRT |
| 2.0 | DP | ´4398 | 1.0 | 1.0 | NRT |
| 2.0 | DP | 000098 | 1.0 | 1.0 | NRT |
Showing 3 of 9,367 rows.