date 14-10-2023
Presented by: Akshata and Shweta
NTPC Limited
Mouda
Asset Management System
Project communication documents
An Asset Management System (AMS) project is designed to help organizations efficiently
track, manage, and optimize their assets. It allows businesses to monitor their assets and
effectively manage them to ensure their optimum utilization while reducing IT and software
costs. They provide a holistic view of an asset's lifecycle—from its procurement and
implementation through its renewal and disposal.
Assets can include physical items like equipment, PC’s, Scanner, Printer, Projector, server,
cameras and UPS.
Table List:
1. Employee (master table)
2. Department (master table)
3.asset_category (master table)
4. asset_type (master table)
5.vendor (master table)
6.locationTable (master table)
7. Material PO
8. pc_details
9. Scanner
10.Printer
11.Projector
12.UPS
13.Server
Asset Management System 1
MATERIAL PO (ADD PO RELATED ALL DETAILS)
Table fields: material_po
1. PO_NO:
2. PO_DATE:
3. PO LINE_ITEM:
4. ITEM ASSET TYPE:
5. MAKE:
6. MODEL:
7. ITEM QUANTITY:
8. DELIVERY DATE:
9. WARRANTY START DATE:
10. WARRANTY END DATE:
11. WARRANTY LIFE:
12. DEFECT LIABILITY PERIOD:
13. VENDOR CODE:
14. VENDOR NAME:
15. VENDOR CONTACT:
16. SRV NO:
17. INSPECTION DATE:
18. PBG EXPIRY DATE:
DESCRIPTION:
Item Asset Type - It is coming from another table. It has a relation from Asset category master table.
Make and model - It is coming from Category Master table which have all the categories and sub
categories of assets.
Defect liability period – Supplier or vendor’s responsibility to take care of the asset this duration is few
months more than warranty period.
Asset Management System 2
Table vendor (Master table)
It is a master table used to store the detailed information about vendor.
Columns:
vendor_code
vendor_name
mobile_no
email_id
vendor_address
city
Table asset_category (Master table)
It’s a master table used as a dropdown field for material PO page for the column asset category.
Columns:
Id
asset_name
Table asset_type (Master table)
It is a master table used as sub dropdown field for asset category table in the column asset category
type.
Columns:
Id
asset_type
Asset Management System 3
ADD ASSET DETAILS (ALL TYPES OF ASSET RELATED DETAILS)
Table fields: pc_details
1. ASSET ID:
2. PC CATEGORY:
3. PC SLNO:
4. PO NO:
5. MAKE:
6. MODEL:
7. WARRANTY:
8. AMC PO NO:
9. STOCK LOCATION:
DESCRIPTION:
Pc Category – this field is dropdown which includes pc assets for eg - keyboard, mouse, monitor,
wireless keyboard and wireless mouse.
Location Id – it is a dropdown field with three options Employee Id, department and HOD name.
Issue to- if the user selects personal use then in issue to have will have a list of all the employees, if the
user selects department then list of department code will appear and if he selects common use then
list of HOD names will appear.
Stock location- If the user selects location id and issue field then the stock location column will be blank
and if the user does not select any option in location id and issue to that means the asset is present in
stock.
Table location_id (Master table)
location_id
location name
Asset Management System 4
PC ISSUE TABLE (PCS THAT ARE ISSUED TO EMPLOYEES)
1. ASSET ID:
2. SLNO:
3. PC CATEGORY:
4. ISSUE TO LOCATION:
5. ISSSUE TO:
6. ISSUE DATE:
7. RETURN DATE:
8. PLANT CODE:
DESCRIPTION:
Issue to location – It will have 3 option personal use, department and common.
Return Date–Date of returning the asset back to the It Stock and will be available to issue again
Plant Code- If the employee is transferred to another location and that employee is taking his PC with
him then in that case the code of that plant location will be written here.
Table 4 employee (Master table)
Emp_no
E_name
Designation
Dept_id
Email
Emp_Status
Deactivated_on
Table 5 department (Master table)
Dept_id
Dept_Name
SubDivision_HOD
PreSubdiv_HOD
Dep_HOD
PreviousDep_HOD
Asset Management System 5
ASSET HISTORY (ALL THE ASSET RELATED INFORMATION FROM STARTING)
1. ASSET ID:
2. SLNO:
3. LOCATION ID:
4. ISSUED FROM:
5. ISSUED TILL:
ADD PRINTER DETAILS (ALL TYPE OF PRINTERS RELATED DETAILS)
Table fields:
1. ASSET ID:
2. PRINTER CATEGORY:
3. PRINTER SLNO:
4. PO NO:
5. MAKE:
6. MODEL:
7. WARRANTY:
8. AMC PO NO:
9. LOCATION ID:
10. ISSUE TO:
11. STOCK LOCATION:
ADD SCANNER DETAILS (ALL TYPES OF SCANNERS RELATED DETAILS)
Table fields:
Asset Management System 6
1. ASSET ID:
2. SCANNER CATEGORY:
3. SCANNER SLNO:
4. PO NO:
5. MAKE:
6. MODEL:
7. WARRANTY:
8. AMC PO NO:
9. LOCATION ID:
10. ISSUE TO:
11. STOCK LOCATION:
ADD PROJECTOR DETAILS (ALL TYPES OF PROJECTORS RELATED DETAILS)
Table fields:
1. ASSET ID:
2. PROJECTOR CATEGORY:
3. PROJECTOR SLNO:
4. PO NO:
5. MAKE:
6. MODEL:
7. WARRANTY:
8. AMC PO NO:
9. LOCATION ID:
10. ISSUE TO:
11. STOCK LOCATION:
ADD CAMERA DETAILS (ALL TYPES OF CAMERA RELATED DETAILS)
Table fields:
Asset Management System 7
1. ASSET ID:
2. CAMERA CATEGORY:
3. CAMERA SLNO:
4. PO NO:
5. MAKE:
6. MODEL:
7. WARRANTY:
8. AMC PO NO:
9. LOCATION ID:
10. ISSUE TO:
11. STOCK LOCATION:
ADD UPS DETAILS (ALL TYPES OF UPS RELATED DETAILS)
Table fields:
1. ASSET ID:
2. UPS CATEGORY:
3. UPS SLNO:
4. PO NO:
5. MAKE:
6. MODEL:
7. WARRANTY:
8. AMC PO NO:
9. LOCATION ID:
10. ISSUE TO:
11. STOCK LOCATION:
ADD SERVER DETAILS (ALL TYPES OF SERVER RELATED DETAILS)
Table fields:
Asset Management System 8
1. ASSET ID:
2. SERVER CATEGORY:
3. SERVER SLNO:
4. PO NO:
5. MAKE:
6. MODEL:
7. WARRANTY:
8. AMC PO NO:
9. LOCATION ID:
10. ISSUE TO:
11. STOCK LOCATION:
Asset Management System 9
