tbl_userroletypemaster

3 rows


Description

Module: HRMS Role Module
Purpose: Defines and maintains the master list of role type categories available in the system.
Data: Each row represents a distinct role type category that can be assigned to roles for classification and grouping.
Process Usage:
- Used as a reference table for validating and categorizing roles during role creation and management.
- Provides standardized role type options for consistent role classification across the organization.
Key Points:
- Serves as a lookup table for role type standardization.
- Ensures consistent role categorization and simplifies role management.
Business Impact: Enables organized role hierarchy, simplifies role administration, and supports standardized reporting on role types.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('tbl_userroletypemaster_id_seq'::regclass)
tbl_userlogin.logintype fk__tbl_userl__login__4bdfe46f R

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for each role type category.
roletype varchar 100 null

Type: Varchar(100)
Meaning: The descriptive name of the role type category (e.g., “Administrative”, “Managerial”, “Operational”).
Usage: Provides human-readable classification for role grouping and filtering.

Indexes

Constraint Name Type Sort Column(s)
tbl_userroletypemaster_pk__tbl_user__3214ec27693026c8 Primary key Asc id

Relationships

Close relationships within degrees of separation