tbl_assets_allocation

-1 rows


Description

Module: HRMS Asset Management - Asset Allocation Log
Purpose: Records the transaction of assigning a specific company asset to an individual employee, serving as the live record of current asset custody.
Data: Captures the unique asset ID, the employee ID it is allocated to, the dates of allocation and expected/actual return, and associated remarks/attachments.
Process Usage:
- Current Status: The presence of an active record (where return_date is null or in the future) indicates the asset is currently in use by the specified employee.
- Asset Tracking: Essential for maintaining an accurate inventory of who holds what.
- Off-boarding: Used during employee separation to identify which assets must be returned.
Key Points:
- Custody Record: This table establishes accountability for company property.
- Linked to the asset master table via asset_id and the employee master via employee_id.
Business Impact: Critical for asset control, loss prevention, and facilitating smooth employee off-boarding and departmental clearance.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this specific allocation transaction.
asset_id int8 19 null

FK: public.tbl_asset.id
Meaning: The ID of the specific asset being allocated.
allocation_date date 13 √ null

The date the asset was officially allocated and handed over to the employee.
employee_id varchar 100 null

FK: public.tbl_employee.employeeid
Meaning: The Employee ID to whom the asset is being assigned.
return_date date 13 √ null

The date the asset was either expected to be returned or the actual date the asset was returned, marking the end of the allocation.
allocation_remarks varchar 1000 √ null

Any notes or remarks pertaining to the allocation (e.g., condition on handover, temporary nature of assignment).
allocation_attachments text 2147483647 √ null

Text column storing file paths or references to documents (e.g., sign-off forms, checklists) related to the asset handover.
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_allocation Primary key Asc id

Relationships

Close relationships within degrees of separation