Results for “lm_unit_code”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

LM_SPRD_PRM is a table in the GMD schema (Process Manufacturing Product Development) within Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the technical parameter definitions that are associated with a laboratory spreadsheet. In the Process Manufacturing quality and product development model, a spreadsheet (LM_SPRD_FLS) acts as a reusable specification template, and LM_SPRD_PRM holds the individual parameter lines that define which technical parameters, assay conditions, data types, and validation limits apply to that spreadsheet.

The table therefore functions as the association between a spreadsheet header and the technical parameter master (GMD_TECH_PARAMETERS_B / LM_TECH_HDR). Under the heuristic Data Vault classification derived from its foreign-key structure, LM_SPRD_PRM is best modeled as a link entity: it resolves the many-to-many relationship between spreadsheets and technical parameters, carrying descriptive attributes (sort sequence, data type, expression, min/max values) on the link itself. This is a modeling suggestion rather than a documented Oracle classification.

Key Information Stored

The primary key LM_SPRD_PRM_PK is a composite business key consisting of SPRD_ID, LAB_TYPE, and TECH_PARM_NAME. Each row represents one parameter assignment on a spreadsheet, identified by these three columns.

• SPRD_ID – Foreign key to LM_SPRD_FLS; identifies the parent spreadsheet.
• LAB_TYPE – Laboratory type, also part of the LM_TECH_HDR relationship; classifies the parameter context.
• TECH_PARM_NAME – The technical parameter name, completing the business key.
• TECH_PARM_ID – Foreign key to GMD_TECH_PARAMETERS_B, the surrogate reference to the technical parameter master.
• SORT_SEQ – Display/order sequence of the parameter on the spreadsheet.
• DATA_TYPE – Data type of the parameter value (numeric, text, date, etc.).
• EXPRESSION_CHAR – Calculation or expression applied to derive the parameter value.
• LM_UNIT_CODE – Unit of measure associated with the parameter.
• QC_ORGN_CODE and QC_ASSAY_NAME – Quality-control organization and assay reference; these participate in foreign keys to the QC_ASSY_TYP relationship.
• MIN_VALUE, MAX_VALUE, and PRECISION – Numeric validation bounds and precision for the parameter.
• OPTIMIZE_TYPE – Optimization flag/type used during product development.
• ORGN_CODE and ORGANIZATION_ID – Organization context for the definition.
• Standard audit columns – CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical scenarios include listing all parameters defined for a spreadsheet, retrieving numeric limits for validation, and joining parameters to their assay and organization context. A representative query:

• SELECT p.SPRD_ID, p.LAB_TYPE, p.TECH_PARM_NAME, p.DATA_TYPE, p.MIN_VALUE, p.MAX_VALUE FROM GMD.LM_SPRD_PRM p WHERE p.SPRD_ID = :spreadsheet_id ORDER BY p.SORT_SEQ;
• Joining to the parameter master: SELECT b.PARAMETER_NAME, p.TECH_PARM_NAME FROM GMD.LM_SPRD_PRM p, GMD.GMD_TECH_PARAMETERS_B b WHERE p.TECH_PARM_ID = b.PARAMETER_ID;
• Reporting parameter usage by laboratory type or organization, using LAB_TYPE and ORGN_CODE as grouping filters.
• Resolving assay definitions by joining QC_ORGN_CODE and QC_ASSAY_NAME to QC_ASSY_TYP for quality reporting.

Related Objects

The following objects are referenced through the documented foreign-key structure and are the most significant for joins and impact analysis.

• LM_SPRD_FLS – Parent spreadsheet files table; joined on SPRD_ID.
• LM_TECH_HDR – Technical parameter header; joined on LAB_TYPE.
• GMD_TECH_PARAMETERS_B – Technical parameter master; joined on TECH_PARM_ID.
• QC_ASSY_TYP – Assay type definition; joined on QC_ORGN_CODE and QC_ASSAY_NAME.
• The QC_ORGN_CODE reference resolves to organization/assay context used across quality modules.

These relationships make LM_SPRD_PRM central to any reporting or extension that must reconcile spreadsheet specifications with the technical parameter library in Process Manufacturing Product Development.