tbl_assets_return_request

-1 rows


Description

Module: Asset Management - Asset Return Request Workflow
Purpose: Manages the workflow for requesting the return of a company asset from an employee (e.g., due to transfer, replacement, or resignation).
Data: Captures the asset being requested, the reason for the request, the current status of the request, and the HR/Admin personnel responsible for processing it.
Process Usage:
- Workflow Tracking: Initiates and tracks the multi-step process from request creation to final asset receipt and update of the allocation log.
- Accountability: The hr_id ensures clear responsibility for the return process.
- The status field is crucial for tracking progress (e.g., PENDING, APPROVED, REJECTED, RETURNED).
Key Points:
- De-allocation Step: This record precedes the actual update to the tbl_assets_allocation table, acting as the necessary approval step.
- Linked to the specific asset via asset_id.
Business Impact: Provides a structured, auditable process for managing the retrieval of company assets, minimizing loss and ensuring timely reassignment.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this specific asset return request.
remarks varchar 1000 √ null

Detailed comments or notes regarding the return request or the condition of the asset.
reason varchar 50 √ null

The high-level reason for requesting the asset return (e.g., RESIGNATION, TRANSFER, REPLACEMENT, REPAIR).
hr_id varchar 50 √ null

FK: public.tbl_employee.employeeid
Meaning: The Employee ID of the HR or Admin personnel responsible for overseeing and processing the asset return.
status varchar 50 √ null

The current status of the asset return request.
Values: PENDING, APPROVED, REJECTED, RETURNED.
asset_id int8 19 √ null

FK: public.tbl_asset.id
Meaning: The ID of the specific asset being requested for return.
attachment text 2147483647 √ null

Text column storing file paths or references to supporting documents (e.g., approval emails, damage reports) for the return request.
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_return_request Primary key Asc id

Relationships

Close relationships within degrees of separation