Complete Equipment Profile

Track manufacturer, model, serial number, purchase date, purchase cost, vendor, and PO number for every asset — from hand tools to test equipment to office gear.

Category-Based Organization

Group assets into configurable categories (Hand Tools, Power Tools, Safety Equipment, Test Equipment, Office Equipment) with category-level service interval defaults.

Warranty Tracking

Record warranty expiration date per asset. Dashboard surfaces assets approaching or past warranty for proactive claims.

Asset Tag Auto-Numbering

Every new asset receives a unique AST-XXXXXX tag number from the auto-sequence. Scannable for mobile workflows.

Branch & Location Assignment

Assets are assigned to a physical location and optionally to a specific user. Application-level branch filtering keeps each branch's technicians focused on their own equipment.

Straight-Line Depreciation

Calculated in real time from in-service date, purchase cost, salvage value, and useful life. Current book value is always available without manual entries.

Per-Asset Useful Life Override

Set a useful life at the asset level to override the category default — a commercial-grade tool depreciates differently than a standard one.

Salvage Value

Define the residual value at end of useful life, factored into all depreciation calculations.

Depreciation Method Flag

Straight-line or none per asset, with declining balance flagged as a future option. Method is recorded on every valuation report for audit purposes.

Portfolio Valuation View

v_asset_depreciation returns purchase cost, book value, and months elapsed for every active asset — ready for balance sheet reporting.

Checked Out To / By Tracking

Record who checked an asset out and which manager authorized it. Expected return date is captured at checkout.

Condition Grading

Condition (New / Good / Fair / Poor) recorded at both checkout and checkin. Deterioration is visible in the history.

Damage Flagging on Return

If an asset comes back in DAMAGED condition, status automatically transitions to IN_SERVICE, routing it for repair before reissuance.

Open Checkout Index

Partial index on checkin_date IS NULL gives instant lookup of every currently checked-out asset without a full table scan.

Full Service History

Log every service event — preventive, repair, calibration, inspection — with date, description, performing vendor, and cost.

Next Service Date

Record the next recommended service date at the end of each service event. Dashboard surfaces upcoming and overdue service.

Internal & Vendor Service

Link service records to a vendor or log free-text for in-house work. Both contribute to lifetime cost-of-ownership calculations.

Document Attachment

Service records support document attachments — inspection certificates, repair invoices, calibration reports — via the polymorphic document table.

Fleet Summary View

v_asset_summary surfaces every asset with status, condition, location, assigned user, and next service date in a single query.

Branch-Level Rollups

fn_report_assets() returns total assets, availability counts, service-due counts, and total purchase cost and book value per branch.

Service Due Alerts

ASSET_SERVICE_DUE and ASSET_OVERDUE_RETURN alert types are built into the alert table — ready to be generated by a scheduled job.