understanding basic concept of asset management software

basic of asset management software Almost all of asset management software uses a database system called RDBMS – relational database management system. People who have access to this software has a specific user profile. the highest user profile is Power User profile which can use all feature and make full data changed. To get deep understanding asset management software, the Power User must learn about RDBMS like Oracle, My SQL or SQL Server. basically, all data are saved in some excellent tables inside the server. there is data communication between these tables. here some example: let say we have asset management software for asset integrity purposes. We have 3 tables on a server: equipment table, inspection table, and employee table. A user can use “client software” to find “how many inspection jobs conducted by Messi in January 2010?” inspection record date inspector method equipment result 1001 1-Jan-10 3001 UTM 2016[…]

Read more

CMMS Computerized Maintenance Management System best practice 1 (asset management software)

CMMS Computerized Maintenance Management System best practice Today we will discuss about CMMS Computerized Maintenance Management System best practice that used by Maintenance team. There are many software companies create CMMS software. Mostly they use Oracle database to maintain its data. Some known CMMS product are Avantis, Maximo, Dematic, API Pro etc. CMMS Computerized Maintenance Management System best practice – Work Order There are many Work Order type used in CMMS such as WO Predictive, WO Preventive or WO Corrective. WO preventive is used for preventive task by maintenance team like changing Lube oil every 6 months. WO predictive is used for predictive task by Inspection Team like vibration measurement every 3 months. WO corrective is used for corrective work like pump overhaul or pipeline repair. By dividing WO to 3 types, we can easily review maintenance cost of each equipment.  Maintenance cost analysis is used to define worst actor or[…]

Read more

IDMS Integrity Database Management System best practice 3 (asset management software)

IDMS integrity database management system best practice we will continue the previous article about IDMS integrity database management system best practice. Previously we talk about design code, inspection method involved and trending. now we will focus on Risk Based Inspection feature. IDMS integrity database management system best practice : upload Risk Based Inspection assessment One of Asset integrity Engineer job is conduct Risk based inspection for all fixed equipment. Risk Based Inspection assessment involve many job functions such as Asset Integrity engineer, Inspection specialist / API inspector, Corrosion engineer, operation folk and also IDMS Specialist. there are 3 type RBI methods i.e qualitative assessment, quantitative assessment and semi-quantitative assessment. In qualitative assessment, the SME (Subject Matter Expert) make a score of Pof (probability of failure) based on their expertise. They can say a carbon-dioxide pipeline is higher corrosive than a “high purity” crude oil pipeline.  They do not need to[…]

Read more

IDMS integrity database management system best practice 2 (asset management software)

integrity database management system best practice we will continue the previous article about IDMS integrity database management system. Previously we talk about design code and inspection method involved. now will focus on trending of inspection result.   IDMS integrity database management system – understanding trending In practice, the fixed interval of pressure vessel inspection is 5 years. UT inspector take measurement shell & head thickness at some location. we call it as TML, thickness measurement location. a IDMS data entry populate TML readings into IDMS software. IDMS software calculate short corrosion rate, long corrosion rate, remaining life, next inspection date based on half-remaining life method.   TML ID TML 001 required thickness 0.35 in inspection date 1-Jan-00 TML reading 0.525 in TML ID TML 001 required thickness 0.35 in inspection date 1-Jan-05 TML reading 0.510 in TML ID TML 001 required thickness 0.35 in inspection date 1-Jan-10 TML reading 0.505[…]

Read more