parameteragnstitem

### 1) Overview
 The `parameteragnstitem` table serves as a quality control master definition. it stores the technical specifications, tolerances, and inspection parameters (both numeric and attribute-based) required for specific items at various operation stages (typically PDI - Pre-Delivery Inspection). This table acts as the "Standard" or "Template" against which actual physical measurements are recorded in inspection transaction tables.
 
 ### 2) Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | No | Primary key for record uniqueness. | | Primary Key |
 | **compcode** | string | No | Internal company identifier. | e.g., "DAS" | Join; Filter |
 | **itemcode** | string | No | Unique identifier for the manufactured or purchased item. | e.g., "AAWA", "CP-001" | Join; Filter |
 | **oprcode** | string | No | Operation/Stage code where inspection occurs. | e.g., "PDI", "CNC2" | Join; Filter |
 | **paracode** | string | No | Identifier for the specific parameter being measured. | e.g., "D1" (Dia), "TL" (Total Length) | Join |
 | **lwlimit** | number | Yes | Lower technical limit for numeric parameters. | | Calculation |
 | **uplimit** | number | Yes | Upper technical limit for numeric parameters. | | Calculation |
 | **revno** | number | Yes | Revision number for the parameter set. | | Join; Versioning |
 | **sno** | integer | Yes | Sequence number for display order on inspection reports. | | Sorting |
 | **remarks** | string | Yes | General notes regarding the parameter. | | Descriptive |
 | **splremarks** | string | Yes | Special instructions for the inspector. | | Descriptive |
 | **uom** | string | Yes | Unit of Measure for the parameter. | MM, Degree, HRA | Descriptive |
 | **instcode** | string | Yes | Code of the instrument/gauge used for measurement. | e.g., "001", "003" | Join (Likely) |
 | **spec** | string | Yes | Textual specification (Attribute types). | e.g., "OK/NOT OK" | Descriptive |
 | **paratype** | string | Yes | Parameter classification. | **N**: Numeric, **C**: Character | Filter |
 | **specN** | string | Yes | Formatted range description for report printing. | e.g., "11.90 - 11.96 MM" | Descriptive |
 | **tolerence** | number | Yes | Allowed variance from the nominal value. | | Calculation |
 | **item_assembly** | string | Yes | Assembly flag. | "I" (Individual) | Filter |
 | **parameterdm** | string | Yes | Dimension category identifier. | e.g., "D" | Filter |
 | **Decimal_value**| number | Yes | Required precision (decimal places) for data entry. | e.g., 2.0 | UI Formatting |
 
 ### 3) Relationships & Join Map
 
 The table serves as the "Spec Master" and is primarily referenced by inspection results and item routing.
 
 #### Joins (Strictly based on SCHEMA_MAP)
 * **dbo.pdiinspectiondtl** (Actual Readings): Join via `compcode`, `itemcode`, `paracode`, `instcode`, and `revno`. This links the defined standard to the actual recorded measurement.
 * **dbo.itemmas** (Item Master): Join via `compcode` and `itemcode` to retrieve master descriptions and part numbers.
 * **dbo.oprmas** (Operation Master): Join via `compcode` and `oprcode` to get operation names.
 * **dbo.itemopr** (Item Routing): Join via `compcode`, `itemcode`, and `oprcode` to ensure the parameter is valid for the current manufacturing routing.
 * **dbo.icsgaugemaster** (Instruments): Join via `compcode` and `instcode` (maps to `code` or `codeno`) to identify the calibration status of the measuring equipment.
 
 ---