Division 25 of 25 · MDI Series

Asset Lifecycle Master Database & Intelligence

The master data, knowledge and intelligence layer of the entire AGL Asset Lifecycle Guide. Divisions 01–24 generate, update and consume asset information; Division 25 brings that information together into one controlled asset-intelligence structure so every major AGL asset can be traced from identification through installation, operation, maintenance, failure, health, lifecycle decision, replacement and disposal — one asset, one master record, one complete lifecycle history.

29 / 29
Topics Scoped
MDI-01 → 29
Topic ID Range
Master Layer
Central Intelligence
Rev 0
Initial Issue

The question this division answers — what is the single controlled identity and complete lifecycle record for every AGL asset, and what does that record tell us to do next?

Where Division 25 Sits in the Lifecycle

Division 25 does not generate new field activity of its own — it is the data, knowledge and intelligence layer that Divisions 01–24 feed into and draw from. Every asset register entry, criticality score, design decision, inspection, test, maintenance job, failure record, cost entry, audit finding and case study ultimately resolves back to one master record, keyed by one Asset ID.

01–20 — Asset Lifecycle Management
21 — Digital Asset Management
22 — Performance & KPI Management
23 — Asset Audit & Governance
24 — Lifecycle Case Studies & Decision Models
25 — Master Database & Intelligence

Five Intelligence Layers

Division 25 is more than a database. Each master record is built up through five layers that turn raw asset data into a lifecycle decision.

01
Identity — What is the asset?

Asset ID → Type → Model → Serial → Location

02
History — What has happened to it?

Installation → Commissioning → Maintenance → Inspection → Testing → Failures → Repairs

03
Current State — What condition is it in now?

Condition → Health → Reliability → Performance → RUL

04
Future Risk — What is likely to happen next?

Failure risk → Obsolescence → RUL → Replacement forecast → Lifecycle cost

05
Decision Intelligence — What should we do?

Maintain → Monitor → Repair → Refurbish → Upgrade → Replace → Dispose

All eleven linked databases — register, inspection, testing, maintenance, failure, warranty, spares, lifecycle cost, health, replacement and disposal — connect through one common key:

ASSET ID

Division 25 · Standard Asset Record — Master Fields

29 of 29 topics scoped
MDI-01 Asset ID
Purpose

Every asset must have a unique and permanent Asset ID — the single controlling identity that every other lifecycle record, in every division and every linked database, keys against.

Requirements
  • Unique
  • Non-duplicated
  • Traceable
  • Persistent throughout the lifecycle
  • Linked to physical identification
  • Linked to CMMS / EAM
  • Linked to drawings
  • Linked to maintenance records
  • Linked to failure records
Example
AGL-RWY-01-LGT-0001

The coding structure itself should follow the airport's approved asset-coding standard.

Persistence Rule

The Asset ID should not change simply because the asset is repaired, refurbished or relocated, unless the organization's asset-governance rules explicitly define that event as creation of a new asset.

MDI-02 Asset Type
Purpose

Asset Type defines the standardized asset category so records can be grouped, compared and benchmarked across the entire AGL population.

Examples
  • Runway light
  • Taxiway light
  • Approach light
  • PAPI
  • Airfield sign
  • CCR
  • Isolation transformer
  • Primary cable
  • Secondary cable
  • L-823 connector
  • Base can
  • ALCMS equipment
  • Control equipment
Why Standardization Matters

Standardized asset types enable asset population analysis, failure comparison, maintenance planning, spare forecasting, lifecycle-cost analysis and reliability benchmarking across like-for-like equipment.

MDI-03 Asset Description
Purpose

Provide a clear engineering description of the asset — enough detail to distinguish it from similar assets on the same field.

Recommended Information
  • Functional description
  • Equipment type
  • Application
  • Rating
  • Configuration
  • Associated system / circuit
Standard

The description should be sufficiently specific to distinguish similar assets — not a generic label repeated across hundreds of records.

MDI-04 Manufacturer
Purpose

Record the manufacturer exactly as approved in the controlled asset documentation.

Used For
  • Reliability analysis
  • Warranty management
  • Product comparison
  • Supplier evaluation
  • Obsolescence monitoring
  • Spare-parts planning
Data Discipline

Manufacturer data should be standardized to avoid multiple spellings or abbreviations of the same manufacturer fragmenting the analysis.

MDI-05 Model
Purpose

Record the exact equipment / model designation — the field that lets similar-looking assets be told apart by generation and configuration.

Model Data Supports
  • Product population analysis
  • Failure analysis
  • Spare identification
  • Obsolescence assessment
  • Technology migration
  • Manufacturer comparison
Multiple Revisions

For equipment with multiple revisions, the relevant model / version should be retained rather than overwritten.

MDI-06 Serial Number
Purpose

The serial number provides manufacturer-level traceability beneath the organization's own Asset ID.

Verify Against
  • Physical nameplate
  • Manufacturer documentation
  • Procurement records
  • Warranty records
  • Asset register
Important Distinction

Asset ID = the organization's lifecycle identifier. Serial Number = the manufacturer's equipment identifier. The two are different fields and should never be merged.

MDI-07 Location
Purpose

Location identifies where the asset is physically installed, in terms the field and the register both understand.

Depending on the Airport System, May Include
  • Airport
  • Airfield
  • Runway
  • Taxiway
  • Apron
  • Approach area
  • Chainage / station
  • Grid reference
  • Coordinates
  • Circuit
  • CCR feeder
  • Base-can reference
Location Intelligence
AssetCircuitAreaSystemAirport
MDI-08 Installation Date
Purpose

Record the date the asset was physically installed.

Used For
  • Age calculation
  • Lifecycle planning
  • Service-life analysis
  • Replacement forecasting
  • Reliability studies
Evidence

Installation date should be supported by an appropriate installation or project record where available.

MDI-09 Commissioning Date
Purpose

Record when the asset was formally commissioned / accepted for operational use.

Important Distinction

Installation Date ≠ Commissioning Date. The two dates can support different lifecycle calculations — installation marks physical fitting, commissioning marks operational acceptance — and both should be retained separately.

MDI-10 Expected Service Life
Purpose

Record the expected service life established through the applicable asset / product / design information.

Consider
  • Product design expectations
  • Operating environment
  • Duty cycle
  • Maintenance regime
  • Technology
  • Manufacturer information
  • Applicable requirements
Important Distinction

Expected service life should not automatically be treated as the replacement date. Actual replacement should also weigh condition, reliability, risk, performance, obsolescence and lifecycle cost.

MDI-11 Warranty Period
Purpose

Record the complete warranty position for the asset, not just an expiry date.

Record
  • Warranty start date
  • Warranty duration
  • Warranty expiry
  • Warranty provider
  • Warranty reference
  • Warranty conditions
Intelligence

The database should be able to identify assets approaching warranty expiry, and assets currently under warranty with recorded failures — the two situations that need action.

MDI-12 Criticality
Purpose

Record the approved asset criticality classification.

Potential Dimensions
  • Safety
  • Operational
  • Regulatory
  • Financial
  • Service continuity
Source Methodology

The criticality record should link to the methodology established under Division 03 — Asset Criticality & Risk Assessment rather than duplicating a separate scoring logic here.

MDI-13 Initial Condition
Purpose

Record the condition at the beginning of the operational lifecycle.

Preferably Sourced From
  • Installation inspection
  • Commissioning
  • Acceptance inspection
  • Baseline assessment
  • Testing
  • Photometric baseline, where applicable
Purpose of the Baseline

This creates the reference point against which all future deterioration is measured.

MDI-14 Current Condition
Purpose

Record the latest validated condition assessment.

Possible Inputs
  • Inspection
  • Testing
  • Maintenance
  • Failure
  • Photometric performance
  • Structural assessment
  • Electrical condition
  • Environmental condition
Lifecycle Relationship
Initial ConditionCurrent ConditionCondition TrendHealth Assessment
MDI-15 Health Index
Purpose

The Health Index consolidates relevant condition and performance information according to the approved health-index methodology.

Potential Inputs
  • Age
  • Condition
  • Failure history
  • Inspection results
  • Testing results
  • Reliability
  • Performance
  • Obsolescence
  • Maintenance history
  • RUL
Important

The database should store both a Current Health Index and, where the system supports it, a Historical Health Index so deterioration trends can be analyzed over time.

MDI-16 Maintenance History
Purpose

Maintain the complete lifecycle maintenance history for the asset.

Include
  • Preventive maintenance
  • Predictive maintenance
  • Condition-based maintenance
  • Corrective maintenance
  • Emergency maintenance
  • Repairs
  • Component replacement
  • Maintenance cost
  • Work-order references
Intelligence

The system should be able to answer: how much maintenance has this asset required during its lifecycle?

MDI-17 Inspection History
Purpose

Store or link all relevant inspection records for the asset.

Include
  • Inspection date
  • Inspection type
  • Inspection result
  • Defects
  • Condition score
  • Recommendations
  • Corrective action
  • Closure
Enables
InspectionCondition TrendHealth IndexLifecycle Decision
MDI-18 Testing History
Purpose

Maintain traceability to the testing records associated with the asset.

Possible Records
  • Insulation resistance
  • Earth resistance
  • Continuity
  • CCR tests
  • Transformer tests
  • Fixture tests
  • PAPI tests
  • Sign tests
  • Functional tests
  • Photometric tests
Intelligence

Historical test values should ideally be trendable rather than stored only as PDF attachments — the difference between a searchable record and a filed document.

MDI-19 Failure History
Purpose

This field should connect directly with the AGL Failure Database rather than duplicating its structure.

Record / Link
  • Failure ID
  • Failure date
  • Failure mode
  • Symptoms
  • Root cause
  • Corrective action
  • Downtime
  • Cost
  • Repeat failure status
Intelligence

The master database should identify which assets have failed repeatedly, and which failure modes are becoming dominant across the population.

MDI-20 Energy / Operating Data
Purpose

Where data is available, record or link the asset's operating and energy data.

Fields
  • Operating hours
  • Duty cycles
  • Loading
  • Energy consumption
  • Current
  • Voltage
  • Power
  • Operating intensity
  • Utilization
Examples

For a CCR: operating hours, output current, loading, intensity-step operation.

For lighting: operating hours, energy consumption, operating profile.

Purpose

This information supports performance, lifecycle-cost and energy analysis.

MDI-21 Lifecycle Cost
Purpose

The master record should connect the asset with its complete lifecycle-cost history.

Include, Where Available
  • Acquisition
  • Installation
  • Commissioning
  • Energy
  • Maintenance
  • Spares
  • Failure
  • Downtime
  • Refurbishment
  • Upgrade
  • Replacement
  • Disposal
Key Intelligence Question

What has this asset actually cost throughout its lifecycle? — substantially more useful than storing only the original purchase price.

MDI-22 Repair History
Purpose

Repair history should be recorded as a distinct field from general maintenance history.

Record
  • Repair date
  • Failure / defect
  • Repair performed
  • Components replaced
  • Labour
  • Cost
  • Downtime
  • Technician / contractor
  • Result
  • Follow-up requirement
Intelligence

This allows identification of high-repair-frequency assets and high-repair-cost assets across the population.

MDI-23 Refurbishment History
Purpose

Record every major refurbishment event applied to the asset.

Include
  • Refurbishment date
  • Scope
  • Components replaced
  • Technology changes
  • Cost
  • Expected additional service life
  • Post-refurbishment baseline
  • Acceptance result
Relationship
Original AssetRefurbishmentNew BaselineExtended Lifecycle
Important

Refurbishment should not erase the original lifecycle history — it extends the record, it does not replace it.

MDI-24 Upgrade History
Purpose

Record significant technology or performance upgrades applied to the asset.

Examples
  • LED conversion
  • CCR modernization
  • Control-system upgrade
  • ALCMS upgrade
  • Network upgrade
  • Monitoring upgrade
  • Energy-efficiency upgrade
Record
  • Before condition
  • Upgrade scope
  • Upgrade date
  • Cost
  • New technology
  • Post-upgrade performance
  • New baseline
MDI-25 Replacement Forecast
Purpose

This should be an intelligence field, not merely a fixed replacement date.

Potential Inputs
  • Age
  • Expected service life
  • Condition
  • Health Index
  • RUL
  • Reliability
  • Failure trend
  • Criticality
  • Obsolescence
  • Lifecycle cost
  • Performance
Possible Outputs
  • No replacement currently planned
  • Monitor
  • Plan replacement
  • Replacement within defined planning horizon
  • Immediate replacement assessment
Review Cycle

The forecast should be reviewed periodically rather than fixed at commissioning and left unchanged.

MDI-26 Disposal Status
Purpose

Track the final lifecycle status of the asset.

Examples
  • Active
  • Under maintenance
  • Under refurbishment
  • Under replacement
  • Decommissioned
  • Removed
  • Recycled
  • Disposed
  • Closed
Closes Through
Physical RemovalDisposal DocumentationAsset-Register Closure
MDI-27 Related Documents
Purpose

Every master asset record should provide controlled links to its relevant documentation.

Examples
  • Datasheet
  • Drawing
  • As-built drawing
  • Installation record
  • Commissioning report
  • Test report
  • Inspection report
  • Maintenance report
  • Failure report
  • Warranty document
  • Calibration record
  • Refurbishment report
  • Upgrade report
  • Replacement decision
  • Disposal certificate
Principle

One Asset Record → One Controlled Document Trail.

MDI-28 Related Standards
Purpose

Record the standards, specifications or requirements applicable to the specific asset.

May Include, Depending on Asset and Project
  • ICAO requirements
  • FAA requirements
  • DGCA requirements
  • Applicable Indian Standards
  • Project specifications
  • Manufacturer requirements
  • Airport engineering standards
Standard

The database should identify which requirement applies to this asset, rather than simply storing a generic list of standards against every record.

MDI-29 Revision History
Purpose

Every significant change made to a master asset record should be traceable.

Record
  • Revision
  • Date
  • Change
  • Previous value
  • New value
  • Reason
  • Changed by
  • Verified by
  • Approval, where required
Example

Rev 03 — Current Condition changed: Good → Fair. Reason: periodic condition assessment.

No topics match your search. Try a different term.

Master Field Structure

All 29 fields of the Standard Asset Record, in order, with the primary question each one answers.

No.FieldPrimary Question
01Asset IDWhat is the asset's unique, permanent identity?
02Asset TypeWhat standardized category does it belong to?
03Asset DescriptionWhat exactly is it, engineering-wise?
04ManufacturerWho made it?
05ModelWhich product/version is it?
06Serial NumberWhat is the manufacturer's own traceable identity?
07LocationWhere is it physically installed?
08Installation DateWhen was it physically installed?
09Commissioning DateWhen was it accepted for operational use?
10Expected Service LifeHow long is it designed to last?
11Warranty PeriodIs it under warranty, and until when?
12CriticalityHow important is it to safety and operations?
13Initial ConditionWhat was its baseline condition?
14Current ConditionWhat condition is it in now?
15Health IndexHow healthy is it overall, and is it trending down?
16Maintenance HistoryHow much maintenance has it required?
17Inspection HistoryWhat have inspections found over time?
18Testing HistoryWhat do its trended test results show?
19Failure HistoryHow and how often has it failed?
20Energy / Operating DataHow hard and how much is it being used?
21Lifecycle CostWhat has it actually cost so far?
22Repair HistoryIs it a high-repair-frequency or high-repair-cost asset?
23Refurbishment HistoryHas it been given a new baseline and extended life?
24Upgrade HistoryWhat technology or performance upgrades has it received?
25Replacement ForecastWhat should happen to it next, and when?
26Disposal StatusWhere is it in its final lifecycle stage?
27Related DocumentsWhat is its complete controlled document trail?
28Related StandardsWhich requirements actually apply to it?
29Revision HistoryHow has its master record changed over time, and why?

Key Deliverables

The mandatory outputs of Division 25.

AGL Master Asset Database Structure
AGL Standard Asset Record
AGL Asset ID Standard
AGL Asset Master Data Dictionary
AGL Asset Data Governance Framework
AGL Asset Data Validation Framework
AGL Asset Data Quality Framework
AGL Asset History Database
AGL Maintenance History Database Link
AGL Inspection History Database Link
AGL Testing History Database Link
AGL Failure History Database Link
AGL Warranty Database Link
AGL Lifecycle Cost Database Link
AGL Asset Health Database
AGL Replacement Forecast Database
AGL Disposal Database
AGL Asset Document Repository Link
AGL Standards Register Link
AGL Asset Intelligence Dashboard
AGL Master Asset Audit Report

Most Important Design Principle

Division 25 should remain the master data, knowledge and intelligence layer — it does not replace the detailed methodologies of the earlier divisions (criticality logic stays in Division 03, audit logic stays in Division 23), it connects them through one governed identity.

One Asset → One Master Record → Complete Lifecycle History → Intelligent Decision Support. The Asset Register tells you what the asset is; the Master Database & Intelligence layer tells you what has happened to it, how it is performing, what risks it carries, what it may need next, and what lifecycle decision should be considered.

Division 02 — ASSET REGISTER (What is the asset?)
Divisions 03–24 — ASSESS · DESIGN · OPERATE · MAINTAIN · AUDIT
Division 25 — CONNECT · ANALYZE · PREDICT · DECIDE

This is why Division 25 closes the guide rather than opening it: every earlier division needs the trusted identity that Division 02 establishes, and every earlier division's output ultimately needs somewhere authoritative to live — Division 25 is that place.

Frequently Asked Questions

Quick answers about Asset Lifecycle Master Database & Intelligence in the AGL Asset Lifecycle Guide.

Q1What is Division 25 — Asset Lifecycle Master Database & Intelligence in the AGL Asset Lifecycle Guide?

Division 25 is the master data, knowledge and intelligence layer connecting every division. It covers 29 topics on the Standard Asset Record: Asset ID, type, description, manufacturer, model, serial number, location, installation/commissioning dates, service life, warranty, criticality, condition, health index, maintenance/inspection/testing/failure history, operating data, lifecycle cost, repair/refurbishment/upgrade history, replacement forecast, disposal status, related documents, related standards and revision history.

Q2What is the AGL Asset Lifecycle Master Database?

It is the master data, knowledge and intelligence layer of the guide. Divisions 01 to 24 generate, update and consume asset information, and Division 25 brings it together into one controlled asset record.

Q3How many fields does the master asset record have?

It defines 29 fields, MDI-01 to MDI-29, running from Asset ID through to revision history.

Q4What identification fields are in the master record?

Asset ID, asset type, description, manufacturer, model, serial number and location. The Asset ID must be unique and permanent, and it is the single controlling identity that every other lifecycle record refers to.

Q5Which lifecycle and condition fields are included?

Installation date, commissioning date, expected service life, warranty period, criticality, initial condition, current condition and Health Index, plus energy and operating data and lifecycle cost.

Q6Which history fields does the record carry?

Maintenance, inspection, testing, failure, repair, refurbishment and upgrade history. Failure history should connect directly with the AGL Failure Database rather than duplicating its structure, and repair history is recorded separately from general maintenance history.

Q7Why is the replacement forecast an intelligence field?

It should be an intelligence field and not merely a fixed replacement date. It draws on age, expected service life, condition, Health Index, RUL and reliability.

Q8How are documents, standards and changes tracked?

Every master record provides controlled links to related documents such as datasheets, drawings, installation and commissioning records and test reports. Related standards can include ICAO, FAA, DGCA and applicable Indian Standards, and every significant change is traceable through revision history with the previous value, new value and reason.

Q9How is the end of an asset's life tracked?

The disposal status field tracks the final lifecycle status, from active and under maintenance through under refurbishment or replacement to decommissioned and removed.

Go Further

Structure the Database. Unlock the Intelligence. Build AGL Expertise.

Effective AGL asset management starts with a master database that holds every fact about an asset in one place.

Learn how asset identity, condition, history, cost and forecast data connect across the complete AGL asset lifecycle.

Turn technical reference knowledge into a deeper understanding of how AGL assets are planned, managed, operated and sustained throughout their lifecycle.

Structure better. Unlock the intelligence. Build technical capability.

Take Your AGL Knowledge Further

Build structured knowledge in:

AGL Fundamentals Asset Identity Condition Data Maintenance History Lifecycle Cost Replacement Forecast Related Standards Master Database Intelligence

Talk to Precision AGL Academy

Follow the Academy