DesignationMas

### 1. Overview
 The `DesignationMas` table serves as a central master repository for job roles and titles (e.g., Operator, Inspector, Setter) within the organization. It is primarily used to categorize employees in the human resources and payroll modules, specifically linking to employee profiles in the `empmas` table.
 
 ### 2. Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **CompCode** | string | No | Unique identifier for the company/branch. | e.g., "DAS" | Primary filter for multi-tenant data isolation. |
 | **Designation_Code** | integer | No | Numerical unique identifier for the specific designation. | e.g., 1, 2, 3 | Used as a foreign key in employee-related tables. |
 | **DesignationName** | string | No | Descriptive title of the role or position. | SETTER, OPERATOR, INSPECTOR | Used for display on reports and ID cards. |
 | **index** | integer | No | Internal physical record index. | | Primary Key for record uniquely identification. |
 
 ### 3. Relationships & Join Map
 
 The table is a foundational master used to provide context to personnel records.
 
 #### Primary Relationships
 * **dbo.empmas**: Joined via `Designation_Code` (mapped to `desination` in `empmas`). This link associates an employee with their official title and grade.
 
 #### Join Rules (SCHEMA_MAP Grounded)
 * **Employee Master Join**:
  * `dbo.DesignationMas.Designation_Code` → `dbo.empmas.desination` (Likely based on context).
  * `dbo.DesignationMas.CompCode` → `dbo.empmas.compcode` (Strict).
 * **Company Context**:
  * `dbo.DesignationMas.CompCode` joins with nearly all tables (e.g., `dbo.company.compcode`, `dbo.attandence.compcode`) to ensure data belongs to the correct business entity.