Equipment tables

The Equipment tables store information for the Equipment, Fleet, Facility, and Plant inventories and inspections.

TableName

Description

EFEQP

Equipment Setup Table

EFEQTHR

Equipment Threshold Library

EFEQTHRD

Equipment Threshold Details Library

EFEQTRK

Equipment Inspection Email tracking table

EFEQUIP

Equipment Table

EFEQUIPC

Equipment Component Library

EFEQUIPCD

Equipment Component Library Details

EFEQUIPCOM

Equipment Components

EFEQUIPDEP

Equipment Dependency Table

EFEQUIPINS

Equipment Inspections

EFEQUIPIT

Equipment Inspection Threshold Limits

EFEQUIPN

EFEQUIP tracking table

EFEQUIPT

Equipment Threshold Limits

EFETASK

Equipment Tasks Lists

EFGDMEMO

Grid Memo

EFGECOST

Equipment Costs

EFGEICOST

Equipment Insurance Cost

EFGETRAK

Equipment Status

EFMEMO

Comments Table

EFPARTEF

Linking table for Parts/Sub-Components

EFPARTEFC

Linking table for Parts/Components

EFPLANT

Plant Inventory

EFPLANTP

Plant Processes

EFPPROCDEP

Plant Process Dependencies

EFPUMPEQ

Link to Pump Inventory

EFRASET

Roof Asset Inventory

EFRASETI

Roof Asset Inspections

EFRBEHM

Equipment Hour Rollback

EFRBEOM

Equipment Other meter Rollback

EFREAD

Equipment Readings

EFRWARRCATINV

Relationship between warranty types and CATINV identifiers

EFSLOT

Plant Process Slots

EFSLOTH

Plant Process Slot Equipment History

EFWARR

Warranty Information

EFWARVEN

Warranty Vendor Library

In This Section

EFEQP

EFEQTHR

EFEQTHRD

EFEQTRK

EFEQUIP

EFEQUIPC

EFEQUIPCD

EFEQUIPCOM

EFEQUIPDEP

EFEQUIPINS

EFEQUIPIT

EFEQUIPN

EFEQUIPT

EFETASK

EFGDMEMO

EFGECOST

EFGEICOST

EFGETRAK

EFMEMO

EFPARTEF

EFPARTEFC

EFPLANT

EFPLANTP

EFPPROCDEP

EFPUMPEQ

EFRASET

EFRASETI

EFRBEHM

EFRBEOM

EFREAD

EFRWARRCATINV

EFSLOT

EFSLOTH

EFWARR

EFWARVEN