CFG_CFGMELC_MEL_CATEGORY
This master table defines stores mel category details. It supports the Minimum Equipment List setup and ensures ( MEL )driven tasks and configurations in transactions are categorized consistently.
Process: MAINTPLANNING · Component: BASConfig · Table type: Master Table Category: Defines master setup for Minimum Equipment List categories and configurations used across maintenance compliance.
This table is the canonical store for the MELCategory entity.
Primary key
CFGMELC_MEL_CATEGORY, CFGMELC_OUINSTANCE
Columns (14)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | CFGMELC_OUINSTANCE 🔑 | varchar | Organization Unit instance |
| 2 | CFGMELC_MEL_CATEGORY 🔑 | varchar | Minimum Equipment List category code to be modified |
| 3 | CFGMELC_DESCRIPTION | varchar | Description of the Minimum Equipment List category |
| 4 | CFGMELC_DEFERRAL_TYPE | varchar | Deferral type, either time-based or usage-based |
| 5 | CFGMELC_LIMIT_BASIS | decimal | Basis for limit, either time or usage |
| 6 | CFGMELC_DEFERRAL_DUR | varchar | Duration for which the Minimum Equipment List item can be deferred |
| 7 | CFGMELC_DUR_UOM | varchar | Unit of measurement for the duration such as hours or days |
| 8 | CFGMELC_STATUS | varchar | Status of the Minimum Equipment List category, active or inactive |
| 9 | CFGMELC_REMARKS | varchar | Remarks or comments for the Minimum Equipment List category |
| 10 | CFGMELC_CREATED_BY | datetime | User who created the record |
| 11 | CFGMELC_CREATEDDATE | varchar | Date when the record was created |
| 12 | CFGMELC_MODIFIED_BY | datetime | User who last modified the record |
| 13 | CFGMELC_MODIFIEDDATE | #N/A | Date when the record was last modified |
| 14 | CFGMELC_TIMESTAMP | #N/A | Timestamp of the record |
Relationships (1)
MEL_HAS_CONFIG→ MELConfig (CFG_CFGMEL_MDL_CONFIG_MEL)- Join:
CFG_CFGMELC_MEL_CATEGORY.CFGMELC_CATEGORY = CFG_CFGMEL_MDL_CONFIG_MEL.CFGMEL_CATEGORY - MEL category has configuration
- Join:
Sample rows (from live DB)
CFGMELC_OUINSTANCE | CFGMELC_MEL_CATEGORY | CFGMELC_DESCRIPTION | CFGMELC_DEFERRAL_TYPE | CFGMELC_LIMIT_BASIS | CFGMELC_DEFERRAL_DUR |
|---|---|---|---|---|---|
| 2.0 | CAT A | Category's A | TL | — | 5.0 |
| 2.0 | DFR | DFR | UL | — | — |
| 2.0 | DMITEST | DMITEST | TL | — | 2000.0 |
Showing 3 of 19 rows.