Skip to main content
Cartegraph Campus

Structure Changes: Cartegraph Fall 2019 to Winter 2020

Structure Changes

Additions

Libraries

Playground Equipment Condition (PlaygroundEquipmentCondition) with the Condition field, Text, Required, Unique, System

Recordsets

Pavement Distress Samples

  • Child recordset to Pavement/Inspections
  • Table: paveDistressSamples
  • Fields:
  • Area, Quantity, Default Unit = ft2, Category = Area, Read-only
  • Length: Quantity, Default Unit = ft, Category = Length
  • Width: Quantity, Default Unit = ft, Category = Length

Pavement Area Distress Samples

  • Child recordset to Pavement Area/Inspections
  • Table: pavaDistressSamples
  • Fields:
    • Quantity: Category = Area, Default Unit = ft2, Read-only
    • Length: Quantity, Default Unit = ft, Category = Length
    • Width: Quantity, Default Unit = ft, Category = Length

Tasks Fields

These were added to use with the Routine Check activity for the Playground Equipment asset type but can be added to any layout and display as options in the Column Selector in the List view.

  • Corrective Measure Notes: System, Text (Unlimited)
  • Debris or Litter: System, Check box
  • Followup Work Required: System, Check box
  • Overgrown Vegetation: System, Check box
  • Protective Surface: System, Check box
  • Proper Drainage: System, Check box
  • Trash Emptied: System, Check box
  • Tripping Hazards: System, Check box
  • User Modified Equipment: System, Check box
  • Vandalism or Graffiti: System, Check box

Tasks – JULIE Integration fields

For existing JULIE deployments the fields are updated. For new deployments this structure is included.

  • Table: wdTaskMainGeneral
  • Fields:
    • JULIE Phone: Text (50)
    • JULIE Phone Ext: Text (50)
    • JULIE Caller: Text (50)
    • JULIE Caller Type: Text (50)
    • JULIE Caller Phone: Text (50)
    • JULIE Caller Phone Ext: Text (50)
    • JULIE Contact: Text (50)
    • JULIE Contact Phone: Text (50)
    • JULIE Contact Phone Ext: Text (50)
    • JULIE Contact Email: Text (50)
    • JULIE Place: Text (50)
    • JULIE Subdivision: Text (50)
    • JULIE Grid List: Text (Unlimited)
    • JULIE Premarked: Text (50)
    • JULIE Directional Boring: Text (50)
    • JULIE Depth Greater 7ft: Text (50)
    • JULIE Location: Text (Unlimited)
    • JULE Work Type: Text (100)
    • JULIE Extent: Text (Unlimited)
    • JULIE Remarks: Text (Unlimited)
    • JULIE Work Date: Date and Time
    • JULIE Fax: Text (50)

Meter Readings with these fields:

Meter Readings is associated with Sewer Pumps, Storm Pumps, Flood Protection Pumps, Water Pumps, Water Treatment Plant  Pumps, and Wastewater Treatment Pumps.

  • Date: System, Required, Date
  • Reading: Number, Required, System
  • Previous Reading: Number, Readonly = true, System
  • Max Flow: Quantity, default Unit: gal/m, Category: Flow, System

Playground Equipment

Condition Categories, available only if user has Advanced Inspections and Asset Condition Manager:

  • Assembly Hardware
  • Drainage
  • General Appearance
  • Operation
  • Protective Surface
  • Structure Durability

Condition Categories Impacts

Assembly Hardware

Replace

100 Absolute

Drainage

Repair

15 %

Drainage

Replace

100 Absolute

General Appearance

Repair

15 %

General Appearance

Replace

100 Absolute

Operation

Repair

15 %

Operation

Replace

100 Absolute

Protective Surface

Repair

15 %

Protective Surface

Replace

100 Absolute

Structure Durability

Repair

15 %

Structure Durability

Replace

100 Absolute

Condition Categories Index Mappings

ConditionCategory

Index

Value

Assembly Hardware

100

New / Excellent

Assembly Hardware

80

Good

Assembly Hardware

50

Average

Assembly Hardware

20

Poor

Assembly Hardware

0

Fail

Drainage

100

New / Excellent

Drainage

80

Good

Drainage

50

Average

Drainage

20

Poor

Drainage

0

Fail

General Appearance

100

New / Excellent

General Appearance

80

Good

General Appearance

50

Average

General Appearance

20

Poor

General Appearance

0

Fail

Operation

100

New / Excellent

Operation

80

Good

Operation

50

Average

Operation

20

Poor

Operation

0

Fail

Protective Surface

100

New / Excellent

Protective Surface

80

Good

Protective Surface

50

Average

Protective Surface

20

Poor

Protective Surface

0

Fail

Structure Durability

100

New / Excellent

Structure Durability

80

Good

Structure Durability

50

Average

Structure Durability

20

Poor

Structure Durability

0

Fail

Prediction Groups Points:

Prediction Group

Condition Category

Index

Year

Playground Equipment Sample

Assembly Hardware

100

0

Playground Equipment Sample

Assembly Hardware

90

5

Playground Equipment Sample

Assembly Hardware

45

15

Playground Equipment Sample

Assembly Hardware

0

20

Playground Equipment Sample

Drainage

100

0

Playground Equipment Sample

Drainage

90

5

Playground Equipment Sample

Drainage

45

15

Playground Equipment Sample

Drainage

0

20

Playground Equipment Sample

General Appearance

100

0

Playground Equipment Sample

General Appearance

90

5

Playground Equipment Sample

General Appearance

45

15

Playground Equipment Sample

General Appearance

0

20

Playground Equipment Sample

Operation

100

0

Playground Equipment Sample

Operation

90

5

Playground Equipment Sample

Operation

45

15

Playground Equipment Sample

Operation

0

20

Playground Equipment Sample

Protective Surface

100

0

Playground Equipment Sample

Protective Surface

90

5

Playground Equipment Sample

Protective Surface

45

15

Playground Equipment Sample

Protective Surface

0

20

Playground Equipment Sample

Structure Durability

100

0

Playground Equipment Sample

Structure Durability

90

5

Playground Equipment Sample

Structure Durability

45

15

Playground Equipment Sample

Structure Durability

0

20

Condition

  • Lookup: PlaygroundEquipmentCondition
  • Condition
    • Fail
    • None / Not Applicable
    • Pass

Changes

Libraries

Scenarios

  • Table: pwpScenarios
  • Field: Adjust for Open Tasks, System, Default = True, CheckBox

Recordsets

Material Logs

  • Price Per Unit Field – changed default value from 0 to null
  • Cost Field – changed default value from 0 to null

Pavement Distress Samples

  • Sample From – removed required flag
  • Sample To – removed required flag

Pavement Area Distress Samples

  • Sample From – removed required flag
  • Sample To – removed required flag

Water Pumps, Flood Protection Pumps, Storm Pumps, and Sewer Pumps

Added fields:

  • Average Daily Usage: Number, Readonly = true, System
  • Baseline Meter: Number, System
  • Current Reading: Number, Readonly = true, System
  • Meter Reset Date: Date, System

Playground Equipment

  • New field: Surface, System, Lookup to Looks up to Playground Surface Types (Type1) library (existing, also used with Playgrounds' Surface Types field.

New Assets for Wastewater Treatment Plant and Water Treatment Plant Domains

Each new asset has an Asset Summary report. These domains also contain existing assets. This is information on the new assets, not the complete domains.

These are the new assets, click on the link to go to that section in this entry:

Wastewater Treatment Plant WWTP Processes
WWTP Blowers WWTP Compressors
WWTP Conveyors WWTP Instrumentation
WWTP Motors WWTP Presses
WWTP Pumps WWTP Facility
WWTP HVAC Equipment WWTP Electric Generators
WWTP Screens WWTP Structures
WWTP UV WWTP Valves
Water Treatment Plants WTP Processes
WTP Motors WTP Screens
WTP Structures WTP UV
WTP Valves WTP  Pumps
WTP Electric Generator WTP Facility
WTP HVAC Equipment  

Wastewater Treatment Plants

  • Asset Name: Wastewater Treatment Plants
  • Shape: Polygon
  • Container for WWTP Facility

New Recordsets and Libraries

Name

Type

ID

Table

Notes

Wastewater Treatment Plants

Recordset

cgWWTPlants

wwtPlantMainGeneral

 

Attachments

Recordset

cgAttachments

wwtPlantAttachments

Child to Wastewater Treatment Plants

Inspections

Recordset

cgInspectionstreatPlant

wwtPlantInspections

Child to Wastewater Treatment Plants

Inspection Attachments

Recordset

cgAttachments

wwtPlantInspAttach

Child to Wastewater Treatment Plant

Inspections

Inspection Condition Categories

Recordset

cgConditionCategories

wwtPlantConditonCategories

Child to Wastewater Treatment Plant Inspections

Performance Curve

Recordset

cgPerformanceCurve

wwtPlantPerformanceCurve

Child to Wastewater Treatment Plants

Wastewater Treatment Plant Condition Categories

Library

cgWWTPlantConditionCategories

wwtPlantCondCategories

 

Impacts

Library

cgImpacts

wwtPlantImpacts

Child to Wastewater Treatment Plant Condition Categories

Index Mappings

Library

cgIndex Mappings

wwtPlantIndexMappings

Child to Wastewater Treatment Plant Condition Categories

Wastewater Treatment Plant

Condition Groups

Library

cgWWTPlantConditionGroups

wwtPlantConditionGroups

 

Wastewater Treatment Plant

Overall Ratings

Library

cgWWTPlantOverallRatings

wwtPlantOverallRatings

 

Wastewater Treatment Plant

Prediction Groups

Library

cgWWTPlantPredictionGroups

wwtPlantPredictionGroups

 

Points

Library

cgPoints

wwtPlantPredictionPoints

Child to Wastewater Treatment Plant

Prediction Points

Wastewater Treatment Plant Processes

  • Asset Name: WWTP Processes
  • Shape: Polygon
  • Component of:
    • WWTP Facility
    • Wastewater Treatment Plant
  • Container for:
    • WWTP Blowers
    • WWTP Compressors
    • WWTP Conveyors
    • WWTP Instrumentation
    • WWTP Motors
    • WWTP Presses
    • WWTP Screens
    • WWTP Structures
    • WWTP UV
    • WWTP Valves
    • WWTP Pumps

New Recordsets and Libraries

Name

Type

ID

Table

Notes

WWTP Processes

Recordset

cgWWTPProcesses

wwtpProcessMainGeneral

 

Attachments

Recordset

cgAttachments

wwtpProcessAttachments

Child to WWTP Processes

Inspections

Recordset

cgInspections

wwtpProcessInspections

Child to WWTP Processes

Inspection Attachments

Recordset

cgAttachments

wwtpProcessInspAttach

Child to WWTP Process Inspections

Inspection Condition Categories

Recordset

cgConditionCategories

wwtpProcessConditonCategories

Child to WWTP Process Inspections

Performance Curve

Recordset

cgPerformanceCurve

wwtpProcessPerformanceCurve

Child to WWTP Processes

WWTP Process Condition Categories

Library

cgWWTPProcessConditionCategories

wwtpProcessCondCategories

 

Impacts

Library

cgImpacts

wwtpProcessImpacts

Child to WWTP Process Condition Categories

Index Mappings

Library

cgIndex Mappings

wwtpProcessIndexMappings

Child to WWTP Process Condition Categories

WWTP Process Condition Groups

Library

cgWWTPProcessConditionGroups

wwtpProcessConditionGroups

 

WWTP Process Overall Ratings

Library

cgWWTPProcessOverallRatings

wwtpProcessOverallRatings

 

WWTP Process Prediction Groups

Library

cgWWTPProcessPredictionGroups

wwtpProcessPredictionGroups

 

Points

Library

cgPoints

wwtpProcessPredictionPoints

Child to WWTP Process Prediction Points

Wastewater Treatment Plant Blowers

  • Asset Name: WWTP Blowers
  • Shape: Point
  • Component of: WWTP Processes

New Recordsets and Libraries

Name

Type

ID

Table

Notes

WWTP Blowers

Recordset

cgWWTPBlowers

wwtpBlowerMainGeneral

 

Attachments

Recordset

cgAttachments

wwtpBlowerAttachments

Child to WWTP Blowers

Inspections

Recordset

cgInspections

wwtpBlowerInspections

Child to WWTP Blowers

Inspection Attachments

Recordset

cgAttachments

wwtpBlowerInspAttach

Child to WWTP Blower

Inspections

Inspection Condition Categories

Recordset

cgConditionCategories

wwtpBlowerConditonCategories

Child to WWTP Blower

Inspections

Performance Curve

Recordset

cgPerformanceCurve

wwtpBlowerPerformanceCurve

Child to WWTP Blower

WWTP Blower

Condition Categories

Library

cgWWTPBlowerConditionCategories

wwtpBlowerCondCategories

 

Impacts

Library

cgImpacts

wwtpBlowerImpacts

Child to WWTP Blower

Condition Categories

Index Mappings

Library

cgIndex Mappings

wwtpBlowerIndexMappings

Child to WWTP Blower

Condition Categories

WWTP Blower

Condition Groups

Library

cgWWTPBlowerConditionGroups

wwtpBlowerConditionGroups

 

WWTP Blower Overall Ratings

Library

cgWWTPBlowerOverallRatings

wwtpBlowerOverallRatings

 

WWTP Blower

Prediction Groups

Library

cgWWTPBlowerPredictionGroups

wwtpBlowerPredictionGroups

 

Points

Library

cgPoints

wwtpBlowerPredictionPoints

Child to WWTP Blower

Prediction Points

WWTP Blower Manufactures

Library

cgWWTPBlowerManufactures

WWTPBlowerManufactures

 

WWTP Blower Types

Library

cgWWTPBlowerTypes

WWTPBlowerTypes

 

New Fields

This is in addition to the Asset Base Default Structure.

Table wwtpBlowerMainGeneral (WWTP Blowers)

Name

Type

ID

Notes

CFM

Number

CFG

System

Description

Text (254)

Description

System

Horsepower

Number

Horsepower

System

Manufacturer

Lookup

Manufacturer

LookupRset: WWTP Blower Manufacturers

Lookup Field: Manufacturer

Model

Text (50)

Model

System

RPM

Number

RPM

System

Serial Number

Text (50)

SerialNumber

System

Type

Lookup

Type

LookupRset: WWTP Blower Types

Lookup Field: Type

Voltage

Number

Voltage

System

Table wwtpBlowerManufacturer (WWTP Blower Manufactures)

  • Manufacturer, Text (50), Manufacturer, system, indexed, unique, and required

Table wwtpBlowerTypes (WWTP Blower Types)

  • Type: Text (50), Type, system, indexed, unique, and required

Startup Data

Activities:

  • Install
  • Inspect
  • Replace
  • Repair
  • Retire

Blower Types

  • Centrifugal
  • Positive Displacement

Wastewater Treatment Plant Compressors

  • Asset Name: WWTP Compressors
  • Shape: Point
  • Component of: WWTP Processes

New Recordsets and Libraries

Name

Type

ID

Table

Notes

WWTP Compressors

Recordset

cgWWTPCompressors

wwtpCompMainGeneral

 

Attachments

Recordset

cgAttachments

wwtpCompAttachments

Child to WWTP Compressors

Inspections

Recordset

cgInspections

wwtpCompInspections

Child to WWTP Compressors

Inspection Attachments

Recordset

cgAttachments

wwtpCompInspAttach

Child to WWTP

Compressor Inspections

Inspection Condition Categories

Recordset

cgConditionCategories

wwtpCompConditonCategories

Child to WWTP Compressor Inspections

Performance Curve

Recordset

cgPerformanceCurve

wwtpCompPerformanceCurve

Child to WWTP Compressor

WWTP Compressor

Condition Categories

Library

cgWWTPCompressorConditionCategories

wwtpCompCondCategories

 

Impacts

Library

cgImpacts

wwtpCompImpacts

Child to WWTP Compressor Condition Categories

Index Mappings

Library

cgIndex Mappings

wwtpCompIndexMappings

Child to WWTP

Compressor Condition Categories

WWTP Compressor

Condition Groups

Library

cgWWTPCompressorConditionGroups

wwtpCompConditionGroups

 

WWTP Compressor

Overall Ratings

Library

cgWWTPCompressorOverallRatings

wwtpCompOverallRatings

 

WWTP Compressor

Prediction Groups

Library

cgWWTPCompressorPredictionGroups

wwtpCompPredictionGroups

 

Points

Library

cgPoints

wwtpCompPredictionPoints

Child to WWTP

Compressor Prediction Points

WWTP Compressor

Manufactures

Library

cgWWTPCompressorManufactures

WWTPCompressorManufactures

 

WWTP Compressor

Types

Library

cgWWTPCompressorTypes

WWTPCompressorTypes

 

New Fields

In addition to the Asset Base Default Structure.

Table wwtpCompMainGeneral (WWTP Compressors)

Name

Type

ID

Notes

Amperage

Number

Amperage

System

Capacity

Number

Capacity

System

Description

Text (254)

Description

System

Manufacturer

Lookup

Manufacturer

LookupRset: WWTP Compressor Manufactures

Lookup Field: Manufacturer

Model

Text

Model

System

Operating Pressure

Number

OperatingPressure

System

Phase

Integer

Phase

System

Serial Number

Text (50)

SerialNumber

System

Type

Lookup

Type

LookupRset: WWTP Compressor Types

Lookup Field: Type

Voltage

Number

Voltage

System

Table WWTPCompressorManufacturer (WWTP Compressor Manufactures)

  • Manufacturer: Text (50), Manufacturer, system, indexed, unique, and required

Table WWTPBlowerTypes (Compressors Types)

  • Type: Text (50), Type, system, indexed, unique, and required

Startup Data

  • Activities:
    • Install
    • Inspect
    • Replace
    • Repair
    • Retire
  • Compressor Types
    • Centrifugal
    • Diaphragm
    • Reciprocating
    • Screw

Wastewater Treatment Plant Conveyors

  • Asset Name: WWTP Conveyors
  • Shape: Point
  • Component of: WWTP Processes

New Recordsets and Libraries

Name

Type

ID

Table

Notes

WWTP Conveyors

Recordset

cgWWTPConveyors

wwtpConvMainGeneral

 

Attachments

Recordset

cgAttachments

wwtpConvAttachments

Child to WWTP Conveyors

Inspections

Recordset

cgInspections

wwtpConvInspections

Child to WWTP Conveyors

Inspection Attachments

Recordset

cgAttachments

wwtpConvInspAttach

Child to WWTP Conveyor

Inspections

Inspection Condition Categories

Recordset

cgConditionCategories

wwtpConvConditonCategories

Child to WWTP Conveyor

Inspections

Performance Curve

Recordset

cgPerformanceCurve

wwtpConvPerformanceCurve

Child to WWTP Conveyor

WWTP Conveyor

Condition Categories

Library

cgWWTPConveyorConditionCategories

wwtpConvCondCategories

 

Impacts

Library

cgImpacts

wwtpConvImpacts

Child to WWTP Conveyor

Condition Categories

Index Mappings

Library

cgIndex Mappings

wwtpConvIndexMappings

Child to WWTP Conveyor

Condition Categories

WWTP Conveyor

Condition Groups

Library

cgWWTPConveyorConditionGroups

wwtpConvConditionGroups

 

WWTP Conveyor

Overall Ratings

Library

cgWWTPConveyorOverallRatings

wwtpConvOverallRatings

 

WWTP Conveyor

Prediction Groups

Library

cgWWTPConveyorPredictionGroups

wwtpConvPredictionGroups

 

Points

Library

cgPoints

wwtpConvPredictionPoints

Child to WWTP Conveyor

Prediction Points

WWTP Conveyor

Manufactures

Library

cgWWTPConveyorManufactures

WWTPConveyorManufactures

 

WWTP Conveyor Types

Library

cgWWTPConveyorTypes

WWTPConveyorTypes

 

New Fields

In addition to the Asset Base Default Structure.

Table wwtpConvMainGeneral (WWTP Conveyors)

Name

Type

ID

Notes

Description

Text (254)

Description

    • System

Length

Quantity

Length

    • System
    • Unit Category: Length
    • Default Unit: ft

Manufacturer

Lookup

Manufacturer

    • LookupRset: WWTP Conveyor Manufactures
    • Lookup Field: Manufacturer

Model

Text (50)

Model

    • System

Serial Number

Text (50)

SerialNumber

    • System

Table WWTPConveyorManufacturer (WWTP ConveyorManufactures)

  • New field: Manufacturer: Text (50), Manufacturer, system, indexed, unique, and required

Table WWTPConveyorTypes (WWTP ConveyorTypes)

  • New field: Type: Text (50), Type, system, indexed, unique, and Required

Startup Data

  • Activities:
    • Clean
    • Install
    • Inspect
    • Replace
    • Repair
    • Retire
  • Conveyor Types
    • Belt
    • Screw

Wastewater Treatment Plant Electric Generators

  • Asset Name: WWTP Electric Generators
  • Shape: Point
  • Component of WWTP Facilities
  • The structure is the same as the Electric Generators asset type.

Wastewater Treatment Plant Facility

  • Asset Name: WWTP Facilities
  • Shape: Polygon
  • Container for WWTP Processes
  • Component of Wastewater Treatment Plants
  • The structure is the same as the Facility asset type.

Wastewater Treatment Plant HVAC Equipment

  • Asset Name: WWTP HVAC Equipment
  • Shape: Point
  • Component of WWTP Facilities
  • The structure is the same as the HVAC Equipment asset type.

Wastewater Treatment Plant Instrumentation

  • Asset Name: WWTP Instrumentation
  • Shape: Point
  • Component of: WWTP Instrumentation

New Recordsets and Libraries

Name

Type

ID

Table

Notes

WWTP Instrumentation

Recordset

cgWWTPInstrumentation

wwtpInstrMainGeneral

 

Attachments

Recordset

cgAttachments

wwtpInstrAttachments

Child to WWTP Instrumentation

Inspections

Recordset

cgInspections

wwtpInstrInspections

Child to WWTP Instrumentation

Inspection Attachments

Recordset

cgAttachments

wwtpInstrInspAttach

Child to WWTP

Instrumentation

Inspections

Inspection Condition Categories

Recordset

cgConditionCategories

wwtpInstrConditonCategories

Child to WWTP

Instrumentation

Inspections

Performance Curve

Recordset

cgPerformanceCurve

wwtpInstrPerformanceCurve

Child to WWTP Instrumentation

WWTP Instrumentation

Condition Categories

Library

cgWWTPInstrumentationConditionCategories

wwtpInstrCondCategories

 

Impacts

Library

cgImpacts

wwtpInstrImpacts

Child to WWTP Instrumentation

Condition Categories

Index Mappings

Library

cgIndex Mappings

wwtpInstrIndexMappings

Child to WWTP

Instrumentation

Condition Categories

WWTP Instrumentation

Condition Groups

Library

cgWWTPInstrumentationConditionGroups

wwtpInstrConditionGroups

 

WWTP Instrumentation

Overall Ratings

Library

cgWWTPInstrumentationOverallRatings

wwtpInstrOverallRatings

 

WWTP Instrumentation

Prediction Groups

Library

cgWWTPInstrumentationPredictionGroups

wwtpInstrPredictionGroups

 

Points

Library

cgPoints

wwtpInstrPredictionPoints

Child to WWTP

Instrumentation

Prediction Points

WWTP Instrumentation

Manufactures

Library

cgWWTPInstrumentationManufactures

WWTPInstrumentationManufactures

 

WWTP InstrumentationTypes

Library

cgWWTPInstrumentationTypes

WWTPInstrumentationTypes

 

New Fields

In addition to the Asset Base Default Structure.

Table WWTPInstrumentationManufacturer (WWTP Instrumentation Manufactures)

  • Manufacturer: System, Indexed, Unique, and Required

Table WWTPInstrumentationTypes (WWTP Instrumentation Types)

  • Type: Text (50), Type, system, indexed, unique, and required

Startup Data

  • Activities:
    • Calibrate
    • Install
    • Inspect
    • Replace
    • Repair
    • Retire
  • Instrumentation Types
    • Gauge
    • Meter
    • Regulator
    • Thermometer
    • Transmitter

Wastewater Treatment Plant Motors

  • Asset Name: WWTP Motors
  • Shape: Point
  • Component of: WWTP Processes

New Recordsets and Libraries

Name

Type

ID

Table

Notes

WWTP Motors

Recordset

cgWWTPMotors

wwtpMotorMainGeneral

 

Attachments

Recordset

cgAttachments

wwtpMotorAttachments

Child to WWTP Motors

Inspections

Recordset

cgInspections

wwtpMotorInspections

Child to WWTP Motors

Inspection Attachments

Recordset

cgAttachments

wwtpMotorInspAttach

Child to WWTP Motor

Inspections

Inspection Condition Categories

Recordset

cgConditionCategories

wwtpMotorConditonCategories

Child to WWTP Motor

Inspections

Performance Curve

Recordset

cgPerformanceCurve

wwtpMotorPerformanceCurve

Child to WWTP Motor

WWTP Motor

Condition Categories

Library

cgWWTPMotorConditionCategories

wwtpMotorCondCategories

 

Impacts

Library

cgImpacts

wwtpMotorImpacts

Child to WWTP Motor

Condition Categories

Index Mappings

Library

cgIndex Mappings

wwtpMotorIndexMappings

Child to WWTP Motor

Condition Categories

WWTP Motor

Condition Groups

Library

cgWWTPMotorConditionGroups

wwtpMotorConditionGroups

 

WWTP MotorOverall Ratings

Library

cgWWTPMotorOverallRatings

wwtpMotorOverallRatings

 

WWTP Motor

Prediction Groups

Library

cgWWTPMotorPredictionGroups

wwtpMotorPredictionGroups

 

Points

Library

cgPoints

wwtpMotorPredictionPoints

Child to WWTP Motor

Prediction Points

WWTP Motor

Manufactures

Library

cgWWTPMotorManufactures

WWTPMotorManufactures

 

WWTP MotorTypes

Library

cgWWTPMotorTypes

WWTPMotorTypes

 

New Fields

In addition to the Asset Base Default Structure.

Table wwtpMotorMainGeneral (WWTP Motors)

Name

Type

ID

Notes

Amperage

Number

Amperage

System

Description

Text (254)

Description

System

Frame Type

Text (50)

FrameType

System

Horsepower

Number

Horsepower

System

Manufacturer

Lookup

Manufacturer

LookupRset: WWTP Motor Manufactures

Lookup Field: Manufacturer

Model

Text (50)

Model

System

Phase

Phase

Integer

System

RPM

Number

RPM

System

Serial Number

Text (50)

SerialNumber

System

Type

Lookup

Type

LookupRset: WWTP Motor Types

Lookup Field: Type

Voltage

Number

Voltage

System

Table wwtpMotorManufacturer (WWTP MotorManufactures)

  • Manufacturer: Text (50) System, Indexed, Unique, and Required

Table wwtpMotorTypes (WWTP MotorTypes)

  • Type: Text (50), Type, system, indexed, unique, and required

Startup Data

  • Activities:
    • Install
    • Inspect
    • Replace
    • Repair
    • Retire
    • Maintain

Wastewater Treatment Plant Presses

  • Asset Name: WWTP Presses
  • Shape: Point
  • Component of: WWTP Processes

New Recordsets and Libraries

Name

Type

ID

Table

Notes

WWTP Presses

Recordset

cgWWTPPresses

wwtpPressMainGeneral

 

Attachments

Recordset

cgAttachments

wwtpPressAttachments

Child to WWTP Presses

Inspections

Recordset

cgInspections

wwtpPressInspections

Child to WWTP Presses

Inspection Attachments

Recordset

cgAttachments

wwtpPressInspAttach

Child to WWTP Press

Inspections

Inspection Condition Categories

Recordset

cgConditionCategories

wwtpPressConditonCategories

Child to WWTP Press

Inspections

Performance Curve

Recordset

cgPerformanceCurve

wwtpPressPerformanceCurve

Child to WWTP Press

WWTP Press

Condition Categories

Library

cgWWTPPressConditionCategories

wwtpPressCondCategories

 

Impacts

Library

cgImpacts

wwtpPressImpacts

Child to WWTP Press

Condition Categories

Index Mappings

Library

cgIndex Mappings

wwtpPressIndexMappings

Child to WWTP Press

Condition Categories

WWTP Press

Condition Groups

Library

cgWWTPPressConditionGroups

wwtpPressConditionGroups

 

WWTP Press Overall Ratings

Library

cgWWTPPressOverallRatings

wwtpPressOverallRatings

 

WWTP Press

Prediction Groups

Library

cgWWTPPressPredictionGroups

wwtpPressPredictionGroups

 

Points

Library

cgPoints

wwtpPressPredictionPoints

Child to WWTP Press

Prediction Points

WWTP Press

Manufactures

Library

cgWWTPPressManufactures

WWTPPressManufactures

 

WWTP Press Types

Library

cgWWTPPressTypes

WWTPPressTypes

 

New Fields

In addition to the Asset Base Default Structure.

Table wwtpPressMainGeneral (WWTP Presses)

Name

Type

ID

Notes

Description

Text (254)

Description

System

Manufacturer

Lookup

Manufacturer

LookupRset: WWTP Press Manufactures

Lookup Field: Manufacturer

Model

Text (50)

Model

System

Serial Number

Text (50)

SerialNumber

System

Type

Lookup

Type

LookupRset: WWTP Press Types

Lookup Field: Type

Table wwtpPressManufacturer (WWTP Press Manufactures)

  • Manufacturer: Text (50) System, Indexed, Unique, and Required

Table wwtpPressTypes (WWTP Press Types)

  • Type: Text (50), Type, system, indexed, unique, and required

Startup Data

  • Activities:
    • Install
    • Inspect
    • Replace
    • Repair
    • Retire
    • Clean
  • Press Types
    • Belt
    • Screw

Wastewater Treatment Plant Pumps

  • Asset Name: WWTP Pumps
  • Shape: Point
  • Component of WWTP Processes
  • The structure is the same as the Water Pumps asset type, with the additions fo the Meter Readings structure.

Wastewater Treatment Plant Screens

  • Asset Name: WWTP Screens
  • Shape: Point
  • Component of: WWTP Processes

New Recordsets and Libraries

Name

Type

ID

Table

Notes

WWTP Screens

Recordset

cgWWTPScreens

wwtpScreenMainGeneral

 

Attachments

Recordset

cgAttachments

wwtpScreenAttachments

Child to WWTP Screens

Inspections

Recordset

cgInspections

wwtpScreenInspections

Child to WWTP Screens

Inspection Attachments

Recordset

cgAttachments

wwtpScreenInspAttach

Child to WWTP Screens

Inspections

Inspection Condition Categories

Recordset

cgConditionCategories

wwtpScreenConditonCategories

Child to WWTP Screen

Inspections

Performance Curve

Recordset

cgPerformanceCurve

wwtpScreenPerformanceCurve

Child to WWTP Screen

WWTP Screen

Condition Categories

Library

cgWWTPScreenConditionCategories

wwtpScreenCondCategories

 

Impacts

Library

cgImpacts

wwtpScreenImpacts

Child to WWTP Screen

Condition Categories

Index Mappings

Library

cgIndex Mappings

wwtpScreenIndexMappings

Child to WWTP Screen

Condition Categories

WWTP Screen

Condition Groups

Library

cgWWTPScreenConditionGroups

wwtpScreenConditionGroups

 

WWTP Screen Overall Ratings

Library

cgWWTPScreenOverallRatings

wwtpScreenOverallRatings

 

WWTP Screen

Prediction Groups

Library

cgWWTPScreenPredictionGroups

wwtpScreenPredictionGroups

 

Points

Library

cgPoints

wwtpScreenPredictionPoints

Child to WWTP Screen

Prediction Points

WWTP Screen

Manufactures

Library

cgWWTPScreenManufactures

WWTPScreenManufactures

 

WWTP ScreenTypes

Library

cgWWTPScreenTypes

WWTPScreenTypes

 

New Fields

In addition to the Asset Base Default Structure.

Table wwtpScreenMainGeneral (WWTP Screens)

Name

Type

ID

Notes

Description

Text (254)

Description

System

Manufacturer

Lookup

Manufacturer

LookupRset: WWTP Screen Manufactures

Lookup Field: Manufacturer

Model

Text (50)

Model

System

Serial Number

Text (50)

SerialNumber

System

Type

Lookup

Type

LookupRset: WWTP Screen Types

Lookup Field: Type

Table wwtpScreenManufacturer (WWTP Screen Manufactures)

  • Manufacturer: Text (50) system, indexed, unique, and required

Table wwtpScreenTypes (WWTP ScreenTypes)

  • Type: Text (50), Type, system, indexed, unique, and required

Startup Data

Activities:

  • Install
  • Inspect
  • Replace
  • Repair
  • Retire

Wastewater Treatment Plant Structures

  • Asset Name: WWTP Structures
  • Shape: Point
  • Component of: WWTP Processes

New Recordsets and Libraries

Name

Type

ID

Table

Notes

WWTP Structures

Recordset

cgWWTPStructures

wwtpStruMainGeneral

 

Attachments

Recordset

cgAttachments

wwtpStruAttachments

Child to WWTP Structures

Inspections

Recordset

cgInspections

wwtpStruInspections

Child to WWTP Structures

Inspection Attachments

Recordset

cgAttachments

wwtpStruInspAttach

Child to WWTP Structure

Inspections

Inspection Condition Categories

Recordset

cgConditionCategories

wwtpStruConditonCategories

Child to WWTP Structure

Inspections

Performance Curve

Recordset

cgPerformanceCurve

wwtpStruPerformanceCurve

Child to WWTP Structure

WWTP Structure

Condition Categories

Library

cgWWTPStructureConditionCategories

wwtpStruCondCategories

 

Impacts

Library

cgImpacts

wwtpStruImpacts

Child to WWTP Structure

Condition Categories

Index Mappings

Library

cgIndex Mappings

wwtpStruIndexMappings

Child to WWTP Structure

Condition Categories

WWTP Structure

Condition Groups

Library

cgWWTPStructureConditionGroups

wwtpStruConditionGroups

 

WWTP Structure

Overall Ratings

Library

cgWWTPStructureOverallRatings

wwtpStruOverallRatings

 

WWTP Structure

Prediction Groups

Library

cgWWTPStructurePredictionGroups

wwtpStruPredictionGroups

 

Points

Library

cgPoints

wwtpStruPredictionPoints

Child to WWTP Structure

Prediction Points

WWTP Structure

Manufactures

Library

cgWWTPStructureManufactures

WWTPStructureManufactures

 

WWTP Structure

Types

Library

cgWWTPStructureTypes

WWTPStructureTypes

 

New Fields

In addition to the Asset Base Default Structure.

Table wwtpStructureMainGeneral (WWTP Structures)

Name

Type

ID

Notes

Description

Text (254)

Description

System

Manufacturer

Lookup

Manufacturer

LookupRset: WWTP StructureManufactures

Lookup Field: Manufacturer

Material

Lookup

Material

​​​​​​​LookupRset: WWTP StructureMaterials

Lookup Field: Material

Model

Text (50)

Model

​​​​​​​System

Table WWTPStructureManufacturer (WWTP Structure Manufactures)

  • Manufacturer: Text (50) system, indexed, unique, and eequired

Table WWTPStructureTypes (WWTP Structure Types)

  • Type: Text (50), Type, system, indexed, unique, and required

Table WWTPStructureMaterials (WWTP Structure Materials)

  • Material: Text (50), Material, system, indexed, unique, and required

Startup Data

  • Activities
    • Install
    • Inspect
    • Replace
    • Repair
    • Retire
  • Structure Types
    • Basin
    • Building
    • Clarifier
    • Tank
    • Well

Wastewater Treatment Plant UV

  • Asset Name: WWTP UV
  • Shape: Point
  • Component of: WWTP Processes

New Recordsets and Libraries

Name

Type

ID

Table

Notes

WWTP UV

Recordset

cgWWTPUV

wwtpUVMainGeneral

 

Attachments

Recordset

cgAttachments

wwtpUVAttachments

Child to WWTP UV

Inspections

Recordset

cgInspections

wwtpUVInspections

Child to WWTP UV

Inspection Attachments

Recordset

cgAttachments

wwtpUVInspAttach

Child to WWTP UV

Inspections

Inspection Condition Categories

Recordset

cgConditionCategories

wwtpUVConditonCategories

Child to WWTP UV

Inspections

Performance Curve

Recordset

cgPerformanceCurve

wwtpUVPerformanceCurve

Child to WWTP UV

WWTP UV

Condition Categories

Library

cgWWTPUVConditionCategories

wwtpUVCondCategories

 

Impacts

Library

cgImpacts

wwtpUVImpacts

Child to WWTP UV

Condition Categories

Index Mappings

Library

cgIndex Mappings

wwtpUVIndexMappings

Child to WWTP UV

Condition Categories

WWTP UV

Condition Groups

Library

cgWWTPUVConditionGroups

wwtpUVConditionGroups

 

WWTP UV Overall Ratings

Library

cgWWTPUVOverallRatings

wwtpUVOverallRatings

 

WWTP UV

Prediction Groups

Library

cgWWTPUVPredictionGroups

wwtpUVPredictionGroups

 

Points

Library

cgPoints

wwtpUVPredictionPoints

Child to WWTP UV

Prediction Points

WWTP UV

Manufactures

Library

cgWWTPUVManufactures

WWTPUVManufactures

 

New Fields

In addition to the Asset Base Default Structure.

Table wwtpUVMainGeneral (WWTP UV)

Name

Type

ID

Notes

Description

Text (254)

Description

System

Manufacturer

Lookup

Manufacturer

LookupRset: WWTP Blower Manufactures

Lookup Field: Manufacturer

Model

Text (50)

Model

​​​​​​​System

Serial Number

Text (50)

SerialNumber

​​​​​​​LookupRset: WWTP Blower Manufactures

Lookup Field: Manufacturer

Table WWTPUVManufacturers (WWTP UV Manufactures)

Manufacturer: Text (50) System, Indexed, Unique, and Required

Startup Data

  • Activities:
    • Install
    • Inspect
    • Replace
    • Retire

Wastewater Treatment Plant Valves

  • Asset Name: WWTP Valves
  • Shape: Point
  • Component of: WWTP Processes

New Recordsets and Libraries

Name

Type

ID

Table

Notes

WWTP Valves

Recordset

cgWWTPValves

wwtpValveMainGeneral

 

Attachments

Recordset

cgAttachments

wwtpValveAttachments

Child to WWTP Valves

Inspections

Recordset

cgInspections

wwtpValveInspections

Child to WWTP Valves

Inspection Attachments

Recordset

cgAttachments

wwtpValveInspAttach

Child to WWTP Valve

Inspections

Inspection Condition Categories

Recordset

cgConditionCategories

wwtpValveConditonCategories

Child to WWTP Valve

Inspections

Performance Curve

Recordset

cgPerformanceCurve

wwtpValvePerformanceCurve

Child to WWTP Valve

WWTP Valve

Condition Categories

Library

cgWWTPValveConditionCategories

wwtpValveCondCategories

 

Impacts

Library

cgImpacts

wwtpValveImpacts

Child to WWTP Valve

Condition Categories

Index Mappings

Library

cgIndex Mappings

wwtpValveIndexMappings

Child to WWTP Valve

Condition Categories

WWTP Valve

Condition Groups

Library

cgWWTPValveConditionGroups

wwtpValveConditionGroups

 

WWTP Valve Overall Ratings

Library

cgWWTPValveOverallRatings

wwtpValveOverallRatings

 

WWTP Valve

Prediction Groups

Library

cgWWTPValvePredictionGroups

wwtpValvePredictionGroups

 

Points

Library

cgPoints

wwtpValvePredictionPoints

Child to WWTP Valve

Prediction Points

WWTP Valve

Manufactures

Library

cgWWTPValveManufactures

WWTPValveManufactures

 

WWTP Valve Types

Library

cgWWTPValveTypes

WWTPValveTypes

 

New Fields

In addition to the Asset Base Default Structure.

Table wwtpValveMainGeneral (WWTP Valves)

Name

Type

ID

Notes

Direction to Turn

Lookup

DirectiontoTurn

System

LookupRset: Direction to Turn

Lookup Field: Direction

Description

Text (254)

Description

System

Manufacturer

Lookup

Manufacturer

LookupRset: WWTP Valve Manufactures

Lookup Field: Manufacturer

Model

Text (50)

Model

System

Serial Number

Text (50)

SerialNumber

System

Size

Quantity

Size

​​​​​​​System

Turns to Close

Number

Turns to Close

​​​​​​​System

Type

Lookup

Type

​​​​​​​LookupRset: WWTP Valve Types

Lookup Field: Type

Table WWTPValveManufacturers (WWTP Valve Manufactures)

  • Manufacturer: Text (50) System, Indexed, Unique, and Required

Table WWTPValverTypes (WWTP Valve Types)

  • Type: Text (50), Type, system, indexed, unique, and required

Startup Data

  • Activities:
    • Exercise
    • Install
    • Inspect
    • Replace
    • Repair
    • Retire
  • Valve Types
    • Air Release
    • Ball
    • Blowoff
    • Butterfly
    • Check
    • Gate
    • Knife
    • Plug
    • Shut off

Water Treatment Plants

  • Asset Name: Water Treatment Plants
  • Shape: Polygon
  • Container for WTP Facility

New Recordsets and Libraries

Name

Type

ID

Table

Notes

Water Treatment Plants

Recordset

cgWTPlants

wtPlantMainGeneral

 

Attachments

Recordset

cgAttachments

wtPlantAttachments

Child to Water Treatment Plants

Inspections

Recordset

cgInspectionswtPlant

wtPlantInspections

Child to Water Treatment Plants

Inspection Attachments

Recordset

cgAttachments

wtPlantInspAttach

Child to Water Treatment Plant

Inspections

Inspection Condition Categories

Recordset

cgConditionCategories

wtPlantConditonCategories

Child to Water Treatment Plant Inspections

Performance Curve

Recordset

cgPerformanceCurve

wtPlantPerformanceCurve

Child to Water Treatment Plants

Water  Treatment Plant Condition Categories

Library

cgWTPlantConditionCategories

wtPlantCondCategories

 

Impacts

Library

cgImpacts

wtPlantImpacts

Child to Water Treatment Plant Condition Categories

Index Mappings

Library

cgIndex Mappings

wtPlantIndexMappings

Child to Water Treatment Plant Condition Categories

Water  Treatment Plant

Condition Groups

Library

cgTreatmentPlantConditionGroups

wtPlantConditionGroups

 

 Water Treatment Plant

Overall Ratings

Library

cgWTPlantOverallRatings

wtPlantOverallRatings

 

Water Treatment Plant

Prediction Groups

Library

cgWTPlantPredictionGroups

wtPlantPredictionGroups

 

Points

Library

cgPoints

wtPlantPredictionPoints

Child to Water Treatment Plant

Prediction Points

Water Treatment Plant Processes

  • Asset Name: WTP Processes
  • Shape: Polygon
  • Component of:
    • WTP Facility
    • Water Treatment Plants
  • Container for:
    • WTP Blowers
    • WTP Compressors
    • WTP Instrumentation
    • WTP Motors
    • WTP Screens
    • WTP Structures
    • WTP UV
    • WTP Valves
    • WTP Pumps

New Recordsets and Libraries

Name

Type

ID

Table

Notes

WTP Processes

Recordset

cgWTPProcesses

wtpProcessMainGeneral

 

Attachments

Recordset

cgAttachments

wtpProcessAttachments

Child to WTP Processes

Inspections

Recordset

cgInspections

wtpProcessInspections

Child to WTP Processes

Inspection Attachments

Recordset

cgAttachments

wtpProcessInspAttach

Child to WTP Process Inspections

Inspection Condition Categories

Recordset

cgConditionCategories

wtpProcessConditonCategories

Child to WTP Process Inspections

Performance Curve

Recordset

cgPerformanceCurve

wtpProcessPerformanceCurve

Child to WTP Processes

WTP Process Condition Categories

Library

cgWTPProcessConditionCategories

wtpProcessCondCategories

 

Impacts

Library

cgImpacts

wtpProcessImpacts

Child to WTP Process Condition Categories

Index Mappings

Library

cgIndex Mappings

wtpProcessIndexMappings

Child to WTP Process Condition Categories

WTP Process Condition Groups

Library

cgWTPProcessConditionGroups

wtpProcessConditionGroups

 

WTP Process Overall Ratings

Library

cgWTPProcessOverallRatings

wtpProcessOverallRatings

 

WTP Process Prediction Groups

Library

cgWTPProcessPredictionGroups

wtpProcessPredictionGroups

 

Points

Library

cgPoints

wtpProcessPredictionPoints

Child to WTP Process Prediction Points

Water Treatment Plant Blowers

  • Asset Name: WTP Blowers
  • Shape: Point
  • Component of: WTP Processes

New Recordsets and Libraries

Name

Type

ID

Table

Notes

WTP Blowers

Recordset

cgWTPBlowers

wtpBlowerMainGeneral

 

Attachments

Recordset

cgAttachments

wtpBlowerAttachments

Child to WTP Blowers

Inspections

Recordset

cgInspections

wtpBlowerInspections

Child to WTP Blowers

Inspection Attachments

Recordset

cgAttachments

wtpBlowerInspAttach

Child to WTP Blower

Inspections

Inspection Condition Categories

Recordset

cgConditionCategories

wtpBlowerConditonCategories

Child to WTP Blower

Inspections

Performance Curve

Recordset

cgPerformanceCurve

wtpBlowerPerformanceCurve

Child to WTP Blower

WTP Blower

Condition Categories

Library

cgWTPBlowerConditionCategories

wtpBlowerCondCategories

 

Impacts

Library

cgImpacts

wtpBlowerImpacts

Child to WTP Blower

Condition Categories

Index Mappings

Library

cgIndex Mappings

wtpBlowerIndexMappings

Child to WTP Blower

Condition Categories

WTP Blower

Condition Groups

Library

cgWTPBlowerConditionGroups

wtpBlowerConditionGroups

 

WTP Blower Overall Ratings

Library

cgWTPBlowerOverallRatings

wtpBlowerOverallRatings

 

WTP Blower

Prediction Groups

Library

cgWTPBlowerPredictionGroups

wtpBlowerPredictionGroups

 

Points

Library

cgPoints

wtpBlowerPredictionPoints

Child to WTP Blower

Prediction Points

WTP Blower Manufactures

Library

cgWTPBlowerManufactures

WTPBlowerManufactures

 

WTP Blower Types

Library

cgWTPBlowerTypes

WTPBlowerTypes

 

New Fields

In addition to the Asset Base Default Structure.

Table wtpBlowerMainGeneral (WTP Blowers)

Name

Type

ID

Notes

CFM

Number

CFG

System

Description

Text (254)

Description

System

Horsepower

Number

Horsepower

​​​​​​​System

Manufacturer

Lookup

Manufacturer

​​​​​​​LookupRset: WTP Blower Manufactures

Lookup Field: Manufacturer

Model

Text (50)

Model

​​​​​​​System

RPM

Number

RPM

System

Serial Number

Text (50)

SerialNumber

System

Type

Lookup

Type

​​​​​​​LookupRset: WTP Blower Types

Lookup Field: Type

Voltage

Number

Voltage

​​​​​​​System

Table wtpBlowerManufacturer (WTP Blower Manufactures)

  • Manufacturer: Text (50) System, Indexed, Unique, and Required

Table wtpBlowerTypes (WTP Blower Types)

  • Type: Text (50), Type, system, indexed, unique, and required

Startup Data

  • Activities:
    • Install
    • Inspect
    • Replace
    • Repair
    • Retire
  • Blower Types
    • Centrifugal
    • Positive Displacement

Water Treatment Plant Compressors

  • Asset Name: WTP Compressors
  • Shape: Point
  • Component of: WTP Processes

New Recordsets and Libraries

Name

Type

ID

Table

Notes

WTP Compressors

Recordset

cgWTPCompressors

wtpCompMainGeneral

 

Attachments

Recordset

cgAttachments

wtpCompAttachments

Child to WTP Compressors

Inspections

Recordset

cgInspections

wtpCompInspections

Child to WTP Compressors

Inspection Attachments

Recordset

cgAttachments

wtpCompInspAttach

Child to WTP

Compressor Inspections

Inspection Condition Categories

Recordset

cgConditionCategories

wtpCompConditonCategories

Child to WTP Compressor Inspections

Performance Curve

Recordset

cgPerformanceCurve

wtpCompPerformanceCurve

Child to WTP Compressor

WTP Compressor

Condition Categories

Library

cgWTPCompressorConditionCategories

wtpCompCondCategories

 

Impacts

Library

cgImpacts

wtpCompImpacts

Child to WTP Compressor Condition Categories

Index Mappings

Library

cgIndex Mappings

wtpCompIndexMappings

Child to WTP

Compressor Condition Categories

WTP Compressor

Condition Groups

Library

cgWTPCompressorConditionGroups

wtpCompConditionGroups

 

WTP Compressor

Overall Ratings

Library

cgWTPCompressorOverallRatings

wtpCompOverallRatings

 

WTP Compressor

Prediction Groups

Library

cgWTPCompressorPredictionGroups

wtpCompPredictionGroups

 

Points

Library

cgPoints

wtpCompPredictionPoints

Child to WTP

Compressor Prediction Points

WTP Compressor

Manufactures

Library

cgWTPCompressorManufactures

WTPCompressorManufactures

 

WTP Compressor

Types

Library

cgWTPCompressorTypes

WTPCompressorTypes

 

New Fields

In addition to the Asset Base Default Structure.

Table wtpCompMainGeneral (WTP Compressors)

Name

Type

ID

Notes

Amperage

Number

Amperage

System

Capacity

Number

Capacity

System

Description

Text (254)

Description

System

Manufacturer

Lookup

Manufacturer

​​​​​​​LookupRset: WTP Compressor Manufactures

Lookup Field: Manufacturer

Model

Text

Model

System

Operating Pressure

Number

OperatingPressure

System

Phase

Integer

Phase

System

Serial Number

Text (50)

SerialNumber

​​​​​​​System

Type

Lookup

Type

​​​​​​​LookupRset: WTP Compressor Types

Lookup Field: Type

Voltage

Number

Voltage

​​​​​​​System

Table WTPCompressorManufacturer (WTP Compressor Manufactures)

  • Manufacturer: Text (50) System, Indexed, Unique, and Required

Table WTPBlowerTypes (WTP Compressors Types)

  • Type: Text (50), Type, System, Indexed, Unique, and Required

Startup Data

  • Activities:
    • Install
    • Inspect
    • Replace
    • Repair
    • Retire
  • Compressor Types
    • Centrifugal
    • Diaphragm
    • Reciprocating
    • Screw

Water Treatment Plant Electric Generators

  • Asset Name: WTP Electric Generators
  • Shape: Point
  • Component of WTP Facilities
  • The structure is the same as the Electric Generators asset type.

Water Treatment Plant Facility

  • Asset Name: WTP Facilities
  • Shape: Polygon
  • Container for WTP Processes
  • Component of Water Treatment Plants
  • The structure is the same as the Facility asset type.

Water Treatment Plant HVAC Equipment

  • Asset Name: WTP HVAC Equipment
  • Shape: Point
  • Component of WTP Facilities
  • The structure is the same as the HVAC Equipment asset type.

Water Treatment Plant Instrumentation

  • Asset Name: WTP Instrumentation
  • Shape: Point
  • Component of: WTP Instrumentation

New Recordsets and Libraries

Name

Type

ID

Table

Notes

WTP Instrumentation

Recordset

cgWTPInstrumentation

wtpInstrMainGeneral

 

Attachments

Recordset

cgAttachments

wtpInstrAttachments

Child to WTP Instrumentation

Inspections

Recordset

cgInspections

wtpInstrInspections

Child to WTP Instrumentation

Inspection Attachments

Recordset

cgAttachments

wtpInstrInspAttach

Child to WTP

Instrumentation

Inspections

Inspection Condition Categories

Recordset

cgConditionCategories

wtpInstrConditonCategories

Child to WTP

Instrumentation

Inspections

Performance Curve

Recordset

cgPerformanceCurve

wtpInstrPerformanceCurve

Child to WTP Instrumentation

WTP Instrumentation

Condition Categories

Library

cgWTPInstrumentationConditionCategories

wtpInstrCondCategories

 

Impacts

Library

cgImpacts

wtpInstrImpacts

Child to WTP Instrumentation

Condition Categories

Index Mappings

Library

cgIndex Mappings

wtpInstrIndexMappings

Child to WTP

Instrumentation

Condition Categories

WTP Instrumentation

Condition Groups

Library

cgWTPInstrumentationConditionGroups

wtpInstrConditionGroups

 

WTP Instrumentation

Overall Ratings

Library

cgWTPInstrumentationOverallRatings

wtpInstrOverallRatings

 

WTP Instrumentation

Prediction Groups

Library

cgWTPInstrumentationPredictionGroups

wtpInstrPredictionGroups

 

Points

Library

cgPoints

wtpInstrPredictionPoints

Child to WTP

Instrumentation

Prediction Points

WTP Instrumentation

Manufactures

Library

cgWTPInstrumentationManufactures

WTPInstrumentationManufactures

 

WTP InstrumentationTypes

Library

cgWTPInstrumentationTypes

WTPInstrumentationTypes

 

New Fields

In addition to the Asset Base Default Structure.

Table wtpInstMainGeneral (WTP Instrumentation)

Name

Type

ID

Notes

Description

Text (254)

Description

    • System

Length

Quantity

Length

    • System
    • Unit Category: Length
    • Default Unit: ft

Manufacturer

Lookup

Manufacturer

    • LookupRset: WTP Instrumentation Manufactures
    • Lookup Field: Manufacturer

Model

Text (50)

Model

    • System

Serial Number

Text (50)

SerialNumber

    • System

Table WTPInstrumentationManufacturer (WTP Instrumentation Manufactures)

  • Manufacturer: Text (50) System, Indexed, Unique, and Required

Table WTPInstrumentationTypes (WTP Instrumentation Types)

  • Type: Text (50), Type, system, indexed, unique, and required

Startup Data

  • Activities:
    • Calibrate
    • Install
    • Inspect
    • Replace
    • Repair
    • Retire
  • Instrumentation Types
    • Gauge
    • Regulator
    • Thermometer
    • Transmitter

Water Treatment Plant Motors

  • Asset Name: WTP Motors
  • Shape: Point
  • Component of: WTP Processes

New Recordsets and Libraries

Name

Type

ID

Table

Notes

WTP Motors

Recordset

cgWTPMotors

wtpMotorMainGeneral

 

Attachments

Recordset

cgAttachments

wtpMotorAttachments

Child to WTP Motors

Inspections

Recordset

cgInspections

wtpMotorInspections

Child to WTP Motors

Inspection Attachments

Recordset

cgAttachments

wtpMotorInspAttach

Child to WTP Motor

Inspections

Inspection Condition Categories

Recordset

cgConditionCategories

wtpMotorConditonCategories

Child to WTP Motor

Inspections

Performance Curve

Recordset

cgPerformanceCurve

wtpMotorPerformanceCurve

Child to WTP Motor

WTP Motor

Condition Categories

Library

cgWTPMotorConditionCategories

wtpMotorCondCategories

 

Impacts

Library

cgImpacts

wtpMotorImpacts

Child to WTP Motor

Condition Categories

Index Mappings

Library

cgIndex Mappings

wtpMotorIndexMappings

Child to WTP Motor

Condition Categories

WTP Motor

Condition Groups

Library

cgWTPMotorConditionGroups

wtpMotorConditionGroups

 

WTP MotorOverall Ratings

Library

cgWTPMotorOverallRatings

wtpMotorOverallRatings

 

WTP Motor

Prediction Groups

Library

cgWTPMotorPredictionGroups

wtpMotorPredictionGroups

 

Points

Library

cgPoints

wtpMotorPredictionPoints

Child to WTP Motor

Prediction Points

WTP Motor

Manufactures

Library

cgWTPMotorManufactures

WTPMotorManufactures

 

WTP MotorTypes

Library

cgWTPMotorTypes

WTPMotorTypes

 

New Fields

In addition to the Asset Base Default Structure.

Table wtpMotorMainGeneral (WTP Motors)

Name

Type

ID

Notes

Amperage

Number

Amperage

System

Description

Text (254)

Description

System

Frame Type

Text (50)

FrameType

​​​​​​​System

Horsepower

Number

Horsepower

​​​​​​​System

Manufacturer

Lookup

Manufacturer

​​​​​​​LookupRset: WTP Motor Manufactures

Lookup Field: Manufacturer

Model

Text (50)

Model

​​​​​​​System

Phase

Phase

Integer

​​​​​​​System

RPM

Number

RPM

System

Serial Number

Text (50)

SerialNumber

System

Type

Lookup

Type

LookupRset: WTP Motor Types

Lookup Field: Type

Voltage

Number

Voltage

System

Table wtpMotorManufacturer (WTP MotorManufactures)

  • Manufacturer: Text (50) System, Indexed, Unique, and Required

Table wtpMotorTypes (WTP MotorTypes)

  • Type: Text (50), Type, system, indexed, unique, and required

Startup Data

Activities:

  • Install
  • Inspect
  • Replace
  • Repair
  • Retire
  • Maintain

Water Treatment Plant Pumps

  • Asset Name: WTP Pumps
  • Shape: Point
  • Component of WTP Processes
  • The structure is the same as the Water Pumps asset type, with the additions fo the Meter Readings structure.

Water Treatment Plant Screens

  • Asset Name: WTP Screens
  • Shape: Point
  • Component of: WTP Processes

New Recordsets and Libraries

Name

Type

ID

Table

Notes

WTP Screens

Recordset

cgWTPScreens

wtpScreenMainGeneral

 

Attachments

Recordset

cgAttachments

wtpScreenAttachments

Child to WTP Screens

Inspections

Recordset

cgInspections

wtpScreenInspections

Child to WTP Screens

Inspection Attachments

Recordset

cgAttachments

wtpScreenInspAttach

Child to WTP Screens

Inspections

Inspection Condition Categories

Recordset

cgConditionCategories

wtpScreenConditonCategories

Child to WTP Screen

Inspections

Performance Curve

Recordset

cgPerformanceCurve

wtpScreenPerformanceCurve

Child to WTP Screen

WTP Screen

Condition Categories

Library

cgWTPScreenConditionCategories

wtpScreenCondCategories

 

Impacts

Library

cgImpacts

wtpScreenImpacts

Child to WTP Screen

Condition Categories

Index Mappings

Library

cgIndex Mappings

wtpScreenIndexMappings

Child to WTP Screen

Condition Categories

WTP Screen

Condition Groups

Library

cgWTPScreenConditionGroups

wtpScreenConditionGroups

 

WTP Screen Overall Ratings

Library

cgWTPScreenOverallRatings

wtpScreenOverallRatings

 

WTP Screen

Prediction Groups

Library

cgWTPScreenPredictionGroups

wtpScreenPredictionGroups

 

Points

Library

cgPoints

wtpScreenPredictionPoints

Child to WTP Screen

Prediction Points

WTP Screen

Manufactures

Library

cgWTPScreenManufactures

WTPScreenManufactures

 

WTP ScreenTypes

Library

cgWTPScreenTypes

WTPScreenTypes

 

New Fields

In addition to the Asset Base Default Structure.

Table wtpScreenMainGeneral (WTP Screens)

Name

Type

ID

Notes

Description

Text (254)

Description

System

Manufacturer

Lookup

Manufacturer

LookupRset: WTP Screen Manufactures

Lookup Field: Manufacturer

Model

Text (50)

Model

​​​​​​​System

Serial Number

Text (50)

SerialNumber

​​​​​​​System

Type

Lookup

Type

​​​​​​​LookupRset: WTP Screen Types

Lookup Field: Type

Table wtpScreenManufacturer (WTP Screen Manufactures)

  • Manufacturer: Text (50) System, Indexed, Unique, and Required

Table wtpScreenTypes (WTP ScreenTypes)

  • Type: Text (50), Type, system, indexed, unique, and required

Startup Data

Activities:

  • Install
  • Inspect
  • Replace
  • Repair
  • Retire

Water Treatment Plant Structures

  • Asset Name: WTP Structures
  • Shape: Point
  • Component of: WTP Processes

New Recordsets and Libraries

Name

Type

ID

Table

Notes

WTP Structures

Recordset

cgWTPStructures

wtpStruMainGeneral

 

Attachments

Recordset

cgAttachments

wtpStruAttachments

Child to WTP Structures

Inspections

Recordset

cgInspections

wtpStruInspections

Child to WTP Structures

Inspection Attachments

Recordset

cgAttachments

wtpStruInspAttach

Child to WTP Structure

Inspections

Inspection Condition Categories

Recordset

cgConditionCategories

wtpStruConditonCategories

Child to WTP Structure

Inspections

Performance Curve

Recordset

cgPerformanceCurve

wtpStruPerformanceCurve

Child to WTP Structure

WTP Structure

Condition Categories

Library

cgWTPStructureConditionCategories

wtpStruCondCategories

 

Impacts

Library

cgImpacts

wtpStruImpacts

Child to WTP Structure

Condition Categories

Index Mappings

Library

cgIndex Mappings

wtpStruIndexMappings

Child to WTP Structure

Condition Categories

WTP Structure

Condition Groups

Library

cgWTPStructureConditionGroups

wtpStruConditionGroups

 

WTP Structure

Overall Ratings

Library

cgWTPStructureOverallRatings

wtpStruOverallRatings

 

WTP Structure

Prediction Groups

Library

cgWTPStructurePredictionGroups

wtpStruPredictionGroups

 

Points

Library

cgPoints

wtpStruPredictionPoints

Child to WTP Structure

Prediction Points

WTP Structure

Manufactures

Library

cgWTPStructureManufactures

WTPStructureManufactures

 

WTP Structure

Types

Library

cgWTPStructureTypes

WTPStructureTypes

 

New Fields

In addition to the Asset Base Default Structure.

Table wtpStructureMainGeneral (WTP Structures)

Name

Type

ID

Notes

Description

Text (254)

Description

    • System

Manufacturer

Lookup

Manufacturer

    • LookupRset: WTP StructureManufactures
    • Lookup Field: Manufacturer

Material

Lookup

Material

    • LookupRset: WTP StructureMaterials
    • Lookup Field: Material

Model

Text (50)

Model

    • System

Table WTPStructureManufacturer (WTP Structure Manufactures)

  • Manufacturer: Text (50) System, Indexed, Unique, and Required

Table WTPStructureTypes (WTP Structure Types)

  • Type: Text (50), Type, system, indexed, unique, and required

Table WTPStructureMaterials (WTP Structure Materials)

Material: Text (50), Material, System, Indexed, Unique, and Required

Startup Data

  • Activities:
    • Install
    • Inspect
    • Replace
    • Repair
    • Retire
  • Structure Types
    • Basin
    • Building
    • Clarifier
    • Tank
    • Well

Water Treatment Plant UV

  • Asset Name: WTP UV
  • Shape: Point
  • Component of: WTP Processes

New Recordsets and Libraries

Name

Type

ID

Table

Notes

WTP UV

Recordset

cgWTPUV

wtpUVMainGeneral

 

Attachments

Recordset

cgAttachments

wtpUVAttachments

Child to WTP UV

Inspections

Recordset

cgInspections

wtpUVInspections

Child to WTP UV

Inspection Attachments

Recordset

cgAttachments

wtpUVInspAttach

Child to WTP UV

Inspections

Inspection Condition Categories

Recordset

cgConditionCategories

wtpUVConditonCategories

Child to WTP UV

Inspections

Performance Curve

Recordset

cgPerformanceCurve

wtpUVPerformanceCurve

Child to WTP UV

WTP UV

Condition Categories

Library

cgWTPUVConditionCategories

wtpUVCondCategories

 

Impacts

Library

cgImpacts

wtpUVImpacts

Child to WTP UV

Condition Categories

Index Mappings

Library

cgIndex Mappings

wtpUVIndexMappings

Child to WTP UV

Condition Categories

WTP UV

Condition Groups

Library

cgWTPUVConditionGroups

wtpUVConditionGroups

 

WTP UV Overall Ratings

Library

cgWTPUVOverallRatings

wtpUVOverallRatings

 

WTP UV

Prediction Groups

Library

cgWTPUVPredictionGroups

wtpUVPredictionGroups

 

Points

Library

cgPoints

wtpUVPredictionPoints

Child to WTP UV

Prediction Points

WTP UV

Manufactures

Library

cgWTPUVManufactures

WTPUVManufactures

 

New Fields

In addition to the Asset Base Default Structure.

Table wtpUVMainGeneral (WTP UV)

Name

Type

ID

Notes

Description

Text (254)

Description

    • System

Manufacturer

Lookup

Manufacturer

    • LookupRset: WTP Blower Manufactures
    • Lookup Field: Manufacturer

Model

Text (50)

Model

    • System

Serial Number

Text (50)

SerialNumber

    • System

Table WTPUVManufacturers (WTP UV Manufactures)

  • Manufacturer: Text (50) System, Indexed, Unique, and Required

Startup Data

  • Activities:
    • Install
    • Inspect
    • Replace
    • Retire

Water Treatment Plant Valves

  • Asset Name: WTP Valves
  • Shape: Point
  • Component of: WTP Processes

New Recordsets and Libraries

Name

Type

ID

Table

Notes

WTP Valves

Recordset

cgWTPValves

wtpValveMainGeneral

 

Attachments

Recordset

cgAttachments

wtpValveAttachments

Child to WTP Valves

Inspections

Recordset

cgInspections

wtpValveInspections

Child to WTP Valves

Inspection Attachments

Recordset

cgAttachments

wtpValveInspAttach

Child to WTP Valve

Inspections

Inspection Condition Categories

Recordset

cgConditionCategories

wtpValveConditonCategories

Child to WTP Valve

Inspections

Performance Curve

Recordset

cgPerformanceCurve

wtpValvePerformanceCurve

Child to WTP Valve

WTP Valve

Condition Categories

Library

cgWTPValveConditionCategories

wtpValveCondCategories

 

Impacts

Library

cgImpacts

wtpValveImpacts

Child to WTP Valve

Condition Categories

Index Mappings

Library

cgIndex Mappings

wtpValveIndexMappings

Child to WTP Valve

Condition Categories

WTP Valve

Condition Groups

Library

cgWTPValveConditionGroups

wtpValveConditionGroups

 

WTP Valve Overall Ratings

Library

cgWTPValveOverallRatings

wtpValveOverallRatings

 

WTP Valve

Prediction Groups

Library

cgWTPValvePredictionGroups

wtpValvePredictionGroups

 

Points

Library

cgPoints

wtpValvePredictionPoints

Child to WTP Valve

Prediction Points

WTP Valve

Manufactures

Library

cgWTPValveManufactures

WTPValveManufactures

 

WTP Valve Types

Library

cgWTPValveTypes

WTPValveTypes

 

New Fields

In addition to the Asset Base Default Structure.

Table wtpValveMainGeneral (WTP Valves)

Name

Type

ID

Notes

Direction to Turn

Lookup

DirectiontoTurn

    • System
    • LookupRset: Direction to Turn
    • Lookup Field: Direction

Description

Text (254)

Description

    • System

Manufacturer

Lookup

Manufacturer

    • LookupRset: WTP Valve Manufactures
    • Lookup Field: Manufacturer

Model

Text (50)

Model

    • System

Serial Number

Text (50)

SerialNumber

    • System

Size

Quantity

Size

    • System
    • Unit Category: Short Length
    • Default Unit: in

Turns to Close

Number

Turns to Close

    • System

Type

Lookup

Type

    • LookupRset: WTP Valve Types
    • Lookup Field: Type

Table WTPValveManufacturers (TP Valve Manufactures)

  • Manufacturer: Text (50) System, Indexed, Unique, and Required

Table WTPValverTypes (WTP Valve Types)

  • Type: Text (50), Type, system, indexed, unique, and required

Startup Data

  • Activities:
    • Exercise
    • Install
    • Inspect
    • Replace
    • Repair
    • Retire
  • Valve Types
    • Air Release
    • Ball
    • Blowoff
    • Butterfly
    • Check
    • Gate
    • Knife
    • Plug
    • Shut off