CFG_CFGMEL_MDL_CONFIG_MEL

Minimum equipment list for the model configuration

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 MELConfig entity.

Primary key

CFGMEL_MODEL_NO, CFGMEL_CONFIG_CLASS, CFGMEL_REVNO, CFGMEL_MEL_ITEM_CODE, CFGMEL_OUINSTANCE

Columns (25)

#	Column	Type	Description
1	`CFGMEL_OUINSTANCE` 🔑	varchar	Organization Unit instance
2	`CFGMEL_MODEL_NO` 🔑	varchar	Aircraft model associated with the Minimum Equipment List
3	`CFGMEL_CONFIG_CLASS` 🔑	varchar	Configuration class
4	`CFGMEL_REVNO` 🔑	varchar	Revision number
5	`CFGMEL_PART_NO`	Varchar	Part number associated with the component
6	`CFGMEL_CONDITION_FLAG`	varchar	Indicates usage of the part in an unserviceable state under certain conditions
7	`CFGMEL_CONDITIONS`	decimal	Conditions governing the usage of the part in an unserviceable state
8	`CFGMEL_MEL_QTY`	varchar	Quantity of the part included in the Minimum Equipment List
9	`CFGMEL_MAINT_IMPLICATION`	varchar	Maintenance implications of operating the aircraft with the part in an unserviceable state
10	`CFGMEL_OPER_IMPLICATION`	Varchar	Operational implications of operating the aircraft with the part in an unserviceable state
11	`CFGMEL_POS_BASED_FLAG`	#N/A	Indicates if the number of parts per aircraft matches the Minimum Equipment List quantity
12	`CFGMEL_PART_OU`	varchar	Organization Unit instance of the part number
13	`CFGMEL_MEL_ITEM_CODE` 🔑	varchar	Minimum Equipment List item code
14	`CFGMEL_MEL_ITEM_DESC`	Varchar	Description of the Minimum Equipment List item
15	`CFGMEL_CATEGORY`	decimal	Category to which the Minimum Equipment List item belongs
16	`CFGMEL_MIN_MEL_QTY`	varchar	Minimum quantity of the part required in the Minimum Equipment List
17	`CFGMEL_MEL_ITEM_STATUS`	varchar	Status of the Minimum Equipment List item
18	`CFGMEL_PLACARD`	varchar	Placard requirement, either required or not required
19	`CFGMEL_PLACARD_INST`	varchar	Placard installation instructions
20	`CFGMEL_FILE_NAME`	varchar	Minimum Equipment List file name
21	`cfgmel_deferral_task`	varchar	Task performed during the first scheduled maintenance to rectify a deferred discrepancy
22	`cfgmel_deferral_rev_task`	varchar	Deferral revision task
23	`CFGMEL_DeferalType`	varchar	Deferral type
24	`cfgmel_mel_qty_char`	int	Quantity of the part included in the Minimum Equipment List in character format
25	`cfgmel_rescnt`	decimal	Resource code count reference

Relationships (1)

MELCategory (CFG_CFGMELC_MEL_CATEGORY) → MEL_HAS_CONFIG (this table is target)
- Join: CFG_CFGMELC_MEL_CATEGORY.CFGMELC_CATEGORY = CFG_CFGMEL_MDL_CONFIG_MEL.CFGMEL_CATEGORY
- MEL category has configuration

Sample rows (from live DB)

`CFGMEL_OUINSTANCE`	`CFGMEL_MODEL_NO`	`CFGMEL_CONFIG_CLASS`	`CFGMEL_PART_NO`	`CFGMEL_CONDITION_FLAG`
2.0	008-200	CTEST-1	—	N
2.0	0612	AI-707	—	N
2.0	737-800	AVEOS	—	N

Showing 3 of 68 rows.

CFG_CFGMEL_MDL_CONFIG_MEL

Primary key

Columns (25)

Relationships (1)

Sample rows (from live DB)

See also