tbl_assets_type_custom_field_mapping

-1 rows


Description

Module: HRMS Asset Management - Asset Type to Custom Field Mapping Master
Purpose: Stores the current, active rules for linking pre-defined custom fields (from tbl_assets_custom_field) to various master asset types (e.g., Laptop, Monitor, Vehicle).
Data: Captures the linkage between a specific Asset Type ID and a Custom Field ID, along with configuration attributes like whether the field is mandatory, public, or active.
Process Usage:
- Form Customization: Used to dynamically generate the asset registration form for a given asset type, ensuring only relevant custom fields are presented.
- Validation: Enforces data integrity by using the is_mandatory flag during asset creation.
Key Points:
- Many-to-Many Linkage: This table serves as the junction between the Asset Type master and the Custom Field definition master.
- The settings here govern the data collection requirements for each asset category.
Business Impact: Enables the organization to collect specific, relevant, and required information for different types of assets, improving inventory detail and audit compliance.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('tbl_assets_type_custom_field_mapping_id_seq'::regclass)

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this specific mapping rule.
asset_type_id int8 19 null

FK: public.tbl_asset_type.id (Implied)
Meaning: The ID of the asset type (e.g., Laptop, Phone) to which the custom field is being applied.
custom_field_id int8 19 null

FK: public.tbl_assets_custom_field.id
Meaning: The ID of the custom field (e.g., Screen Size, OS Version) that is being mapped.
is_public bool 1 √ null

Boolean flag: If TRUE, the data entered in this custom field for an asset is visible to the employee who holds the asset.
is_mandatory bool 1 √ null

Boolean flag: If TRUE, the custom field must be populated when creating or updating an asset of the linked asset_type_id.
is_active bool 1 √ null

Boolean flag: Indicates if this mapping rule is currently active and should be applied.
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null

Indexes

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

Relationships

Close relationships within degrees of separation