tbl_assets_request

-1 rows


Description

Module: HRMS Asset & Inventory Management (Request Workflow)
Purpose: Stores all requests submitted by employees for company assets (e.g., a laptop, a software license, a new monitor) and tracks the multi-stage approval workflow.
Data: Contains the requested asset type, required dates, employee request details, and the status/reason for approval/rejection at each reporting level (Rep1, Rep2, HR).
Process Usage:
- Initiated by an employee needing an asset.
- Guides the request through a multi-step approval chain.
- Upon final approval, facilitates the allocation of a physical asset (linked via allocated_asset_id).
Key Points:
- Manages the lifecycle of a request, from submission to final approval or rejection.
- Distinguishes between the request and the actual allocation.
Business Impact: Ensures controlled, justified, and audited distribution of company resources.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for a single asset request.
asset_type_id int8 19 null

FK: public.tbl_asset_type.id
Meaning: The category or type of asset requested (e.g., Laptop, Software License, Projector).
from_date date 13 √ null

The start date from which the asset is required.
to_date date 13 √ null

The end date until which the asset is required (if temporary/project-based).
description varchar 1000 √ null

Detailed justification or description provided by the employee for why the asset is needed.
rep1_status varchar 50 √ null

The status of the request after review by the first-level reporter.
Values: PENDING, APPROVED, REJECTED.
rep1_reason varchar 50 √ null

The justification or reason provided by the first-level reporter for their approval or rejection.
rep1_id varchar 50 √ null

FK: public.tbl_employee.employeeid
Meaning: The Employee ID of the first-level reporter/manager whose approval is required.
rep2_status varchar 50 √ null

The status of the request after review by the second-level reporter.
Values: PENDING, APPROVED, REJECTED.
rep2_reason varchar 50 √ null

The justification or reason provided by the second-level reporter for their approval or rejection.
rep2_id varchar 50 √ null

FK: public.tbl_employee.employeeid
Meaning: The Employee ID of the second-level reporter/manager whose approval is required (if applicable).
hr_reason varchar 50 √ null

The justification or reason provided by the HR/Admin for their final action.
hr_id varchar 50 √ null

FK: public.tbl_employee.employeeid
Meaning: The Employee ID of the HR or Admin user responsible for final approval and allocation.
final_status varchar 50 √ null

The overall, conclusive status of the asset request.
Values: PENDING, APPROVED, REJECTED, ALLOCATED.
allocated_asset_id int8 19 √ null

FK: public.tbl_assets.id
Meaning: The ID of the specific, physical asset that was ultimately allocated to fulfill this request.
allocated_by varchar 50 √ null

FK: public.tbl_employee.employeeid
Meaning: The Employee ID of the administrator/user who processed the final allocation of the asset.
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_request Primary key Asc id

Relationships

Close relationships within degrees of separation