tables · table
catmas
The catmas table serves as the Category Master within the ERP system. It defines functional categories or departments for the workforce (e.g., ADMIN, FLOOR, BMR ENTERPRISES). This metadata is primarily used for grouping employees in payroll processing, attendance tracking, and gratuity calculations.
Row count
3
Last entry
—
Source
tables
Columns
6| Column | Type | Nullable | Meaning |
|---|---|---|---|
index | integer | No | Primary key for the record. |
compcode | string | No | Unique identifier for the company/branch. |
catcode | integer | No | Unique identifier for the category. |
catname | string | No | Descriptive name of the category. |
disp_flag | string | Yes | Display flag for filtering active/inactive categories. |
Cat_Address | string | Yes | Physical address or location associated with the category. |
Full documentation
### 1. Overview The `catmas` table serves as the **Category Master** within the ERP system. It defines functional categories or departments for the workforce (e.g., ADMIN, FLOOR, BMR ENTERPRISES). This metadata is primarily used for grouping employees in payroll processing, attendance tracking, and gratuity calculations. ### 2. Column Dictionary | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage | | :--- | :--- | :--- | :--- | :--- | :--- | | **index** | integer | No | Primary key for the record. | | Primary Key | | **compcode** | string | No | Unique identifier for the company/branch. | `DAS` | Join key for multi-tenant isolation. | | **catcode** | integer | No | Unique identifier for the category. | `101`, `102` | Foreign Key for Employee and Attendance tables. | | **catname** | string | No | Descriptive name of the category. | `ADMIN`, `FLOOR` | Display labels in reports. | | **disp_flag** | string | Yes | Display flag for filtering active/inactive categories. | | Likely `Y`/`N` or `1`/`0`. | | **Cat_Address**| string | Yes | Physical address or location associated with the category. | | Optional metadata. | ### 3. Relationships & Join Map The `catmas` table acts as a reference table for several HR and Payroll modules. #### Logical Joins: * **Employee Master:** Joins to `dbo.empmas` to identify an employee's category for salary and gratuity reporting. * **Attendance Tracking:** Joins to `dbo.attandence` and `dbo.attandenceregister` to aggregate work hours by category. * **Payroll Calculations:** Joins to `dbo.timecalculation` for processing incentives or penalties specific to a worker class. #### Join Map (Strict): | Source Table | Source Column | Target Table | Target Column | Relationship Type | | :--- | :--- | :--- | :--- | :--- | | `dbo.catmas` | `catcode` | `dbo.empmas` | `category` | 1:N (Reference) | | `dbo.catmas` | `catcode` | `dbo.attandence` | `catcode` | 1:N (Reference) | | `dbo.catmas` | `catcode` | `dbo.attandenceregister` | `catcode` | 1:N (Reference) | | `dbo.catmas` | `catcode` | `dbo.timecalculation` | `catcode` | 1:N (Reference) | | `dbo.catmas` | `compcode` | `dbo.empmas` | `compcode` | Composite Link | ---