Dp_DisCat_category_Dtl
Defines and stores categories of discrepancies recorded in aircraft maintenance. Supports classification, reporting, and prioritization of maintenance discrepancies.
Process: LINEMAINTENANCE · Component: BasDP · Table type: Master 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 DiscCategory entity.
Primary key
DisCat_CatOuinstance, DisCat_Discrepancyno, DisCat_CatValue
Columns (12)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | DisCat_CatOuinstance 🔑 | int | Maintains the Organizational Unit number in which the data is saved |
| 2 | DisCat_Discrepancyno 🔑 | varchar | Maintains the discrepancy number information which serves as the basis for mapping the appropriate discrepancy category |
| 3 | DisCat_CatType | varchar | Maintains the discrepancy category type value associated with each discrepancy |
| 4 | DisCat_CatValue 🔑 | varchar | Maintains the discrepancy category value associated with each discrepancy |
| 5 | DisCat_Createdby | varchar | Maintains the created by user information for the discrepancy category |
| 6 | DisCat_CreateDate | datetime | Maintains the created date information for the discrepancy category |
| 7 | DisCat_CatOuinstance 🔑 | int | Organization Unit in which the category is defined |
| 8 | DisCat_Discrepancyno 🔑 | varchar | Unique number identifying the discrepancy |
| 9 | DisCat_CatType | varchar | Type of the category |
| 10 | DisCat_CatValue 🔑 | varchar | Value assigned to the category |
| 11 | DisCat_Createdby | varchar | User who created the category record |
| 12 | DisCat_CreateDate | datetime | Date and time when the category record was created |
Relationships (1)
- Discrepancy (DP_DISCP_DISCREPANCY_DTL) →
HAS_CATEGORY(this table is target) (no automatic join)- Discrepancy has category classification
Sample rows (from live DB)
DisCat_CatOuinstance | DisCat_Discrepancyno | DisCat_CatType | DisCat_CatValue | DisCat_Createdby | DisCat_CreateDate |
|---|---|---|---|---|---|
| 2 | CDP-162553-2022 | — | AD1 | DMUSER | 2022-10-19 17:32:39 |
Showing 1 of 1 rows.