DP_DPPRM_PARAMETER_DETAILS

Stores parameter metadata definitions used in discrepancy management. Includes parameter names, types, ranges, and associated rules for validation and compliance.

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

Primary key

DPPRM_PARAMCODE, DPPRM_PARAMTYPE, DPPRM_PARAMCATEGORY, DPPRM_COMPONENTNAME, DPPRM_LANGID

Columns (16)

#	Column	Type	Description
1	`DPPRM_COMPONENTNAME` 🔑	varchar	Maintains the name of the business component associated with the parameter
2	`DPPRM_PARAMCATEGORY` 🔑	Varchar	Maintains the classification category under which the parameter is grouped
3	`DPPRM_PARAMTYPE` 🔑	Varchar	Maintains the data type of the parameter such as numeric text or option
4	`DPPRM_PARAMCODE` 🔑	varchar	Maintains the unique parameter code
5	`DPPRM_LANGID` 🔑	#N/A	Maintains the language identifier used for multilingual support of the parameter
6	`DPPRM_PARAMDESC`	varchar	Maintains the textual description of the parameter
7	`DPPRM_SORT_BY`	#N/A	Maintains the sorting order or priority of the parameter in lists or reports
8	`DPPRM_CREATIONDATE`	datetime	Maintains the date when the parameter was created in the system
9	`DPPRM_COMPONENTNAME` 🔑	varchar	Maintains the name of the business component associated with the parameter.
10	`DPPRM_PARAMCATEGORY` 🔑	Varchar	Maintains the classification category under which the parameter is grouped.
11	`DPPRM_PARAMTYPE` 🔑	Varchar	Maintains the data type of the parameter (e.g., numeric, text, option).
12	`DPPRM_PARAMCODE` 🔑	varchar	Maintains the unique parameter code.
13	`DPPRM_LANGID` 🔑	#N/A	Maintains the language identifier used for multilingual support of the parameter.
14	`DPPRM_PARAMDESC`	varchar	Maintains the textual description of the parameter.
15	`DPPRM_SORT_BY`	#N/A	Maintains the sorting order or priority of the parameter in lists or reports.
16	`DPPRM_CREATIONDATE`	datetime	Maintains the creation date.

Sample rows (from live DB)

`DPPRM_COMPONENTNAME`	`DPPRM_PARAMCATEGORY`	`DPPRM_PARAMTYPE`	`DPPRM_PARAMCODE`	`DPPRM_LANGID`	`DPPRM_PARAMDESC`
BASDP	COMBO	STATUS	A	1.0	Active
BASDP	COMBO	APPLICABILITY	AIRC	1.0	Aircraft
BASDP	COMBO	APPLICABILITY	AIRC	73.0	Aircraft

Showing 3 of 146 rows.

DP_DPPRM_PARAMETER_DETAILS

Primary key

Columns (16)

Sample rows (from live DB)

See also