Skip to main content
Cartegraph Campus

Structure Changes: Cartegraph Spring 2020 to Summer 2020

New Layout

Cartegraph Default FEMA

This is a new time sheet layout called for the equipment log and has two additional fields specific for FEMA:

  • Operator
  • Operator Full Name (display only)

Structure Changes

Additions

Libraries

Resource Estimates Overrides
  • UserID: cgResourceEstimatesOverrides
  • Table: ResourceEstimatesOverrides
  • System

Fields

  • Activity: Lookup is Activities->Activity, Column: Activity, Required, and System
  • Asset Type: Lookup is AssetTypes->AssetType, Column: AssetType, Required, and System
  • Equipment Cost: Column: EquipmentCost, Currency, Initial Value: 0, Required, and System
  • Labor Cost: Column: LaborCost, Currency, Initial Value: 0, Required, and System
  • Labor Hours: Column: LaborHours, Number, Initial Value: 0, Required, and System
  • Material Cost: Column: MaterialCost, Currency, Initial Value: 0, Required, and System
  • Other Cost: Column: OtherCost, Currency, Initial Value: 0, Required, and System
  • Override Equipment: Column: OverrideEquipment, Number, Initial Value: 0, Required, and System
  • Override Labor: Column: OverrideLabor, Number, Initial Value: 0, Required, and System
  • Override Material: Column: OverrideMaterial, Number, Initial Value: 0, Required, and System
  • Override Other: Column: OverrideOther, Number, Initial Value: 0, Required, and System
Equipment FEMA Rates
  • UserID: cgEquipmentFEMARates
  • Table: wdEquipmentFEMARates
  • System

Fields

  • Cost Code, Column: CostCode, Text (50), Unique, Required, and System
  • Capacity: Column: Capacity, Text (50),  and System
  • Effective On: Column: EffectiveOn, Date, and System
  • Equipment: Column: Equipment, Text (100), and System
  • Horsepower: Column: Horsepower, Text (50), and System
  • Notes: Text (Memo), Column: Notes, and System
  • Rate: Column: Rate
    • Required and System
    • Quantity
      • Unit Category: EquipmentRate
      • Default Unit: $/hr
  • Specifications: Column: Specifications, Text (Memo), and System

Fields

Operator

  • Recordset: Equipment Logs
  • Table: wdEquipmentLog
  • Lookup to Labor/ID

Equipment Cost Estimated

  • Recordset: Tasks
  • Table: wdTaskMainGeneral
  • Currency and Read-only

Labor Cost Estimated

  • Recordset: Tasks
  • Table: wdTaskMainGeneral
  • Currency and Read-only

Labor Hours Estimated

  • Recordset: Tasks
  • Table: wdTaskMainGeneral
  • Currency and Read-only

Material Cost Estimated

  • Recordset: Tasks
  • Table: wdTaskMainGeneral
  • Currency and Read-only

Other Cost Estimated

  • Recordset: Tasks
  • Table: wdTaskMainGeneral
  • Currency and Read-only

Total Cost Estimated

  • Recordset: Tasks
  • Table: wdTaskMainGeneral
  • Currency and Read-only

Total Equipment Cost Estimated

  • Recordset:Work Orders
  • Table: wdWOMainGeneral
  • Currency and Read-only

Total Labor Cost Estimated

  • Recordset:Work Orders
  • Table: wdWOMainGeneral
  • Currency and Read-only

Total Labor Hours Estimated

  • Recordset:Work Orders
  • Table: wdWOMainGeneral
  • Number and Read-only

Total Material Cost Estimated

  • Recordset:Work Orders
  • Table: wdWOMainGeneral
  • Currency and Read-only

Total Other Cost Estimated

  • Recordset:Work Orders
  • Table: wdWOMainGeneral
  • Currency and Read-only

Total Cost Estimated

  • Recordset:Work Orders
  • Table: wdWOMainGeneral
  • Currency and Read-only

Deferred Activity

  • Recordset: Scenarios/Activity List
  • Table: pwpActivityList
  • Lookup to Activities/Activity

Deferred Cost

  • Recordset: Scenarios/Activity List
  • Table: pwpActivityList
  • Currentcy

Recommended Activity

  • Recordset: Scenarios/Activity List
  • Table: pwpActivityList
  • Lookup to Activities/Activity

Unit Cost Difference

  • Recordset: Scenarios/Activity List
  • Table: pwpActivityList
  • Currency

Years Remaining Activity

  • Recordset: Scenarios/Activity List
  • Table: pwpActivityList
  • Number and Read-only

Building Context

As part of the addition of the ability to manage assets by building or floor, all Recordsets now have a Building Context field that can have one of four values: None, Building, Floor, or Floor Aware. The value can be changed in Structure Manager. If the recordset already has fields with this name that a user created, then an error message is shown to the user letting them know they must rename existing fields before changing the Building Context field value.

WWTP represents Wastewater Treatment Plan and WTP represents Water Treatment Plant

These asset types' Building Context field is automatically set to Building:

  • Facilities
  • WTP Facilities
  • WWTP Facilities

These three new asset types' Building Context field is automatically set to Floor:

  • Facility Floors
  • WTP Facility Floors
  • WWTP Facility Floors

These asset types' Building Context field is automatically set to Floor Aware:

  • Electrical Generators
  • Facility Lighting
  • Fire Protection
  • HVAC Equipment
  • Plumbing Fixtures
  • Roofing System
  • WTP Blowers
  • WTP Compressors
  • WTP Electrical Generators
  • WTP HVAC Equipment
  • WTP Instrumentation
  • WTP Motors
  • WTP Pumps
  • WTP Screens
  • WTP Structures
  • WTP UV
  • WTP Valves
  • WWTP Blowers
  • WWTP Compressors
  • WWTP Conveyors
  • WWTP Electrical Generators
  • WWTP HVAC Equipment
  • WWTP Instrumentation
  • WWTP Motors
  • WWTP Presses
  • WWTP Pumps
  • WWTP Screens
  • WWTP Structures
  • WWTP UV
  • WWTP Valves

Building

When a recordset has its Building Context set to Floor, the recordset will automatically get a new field named Building. This is a read-only text field.

Floor

If Building Context is set to Floor Aware, the recordset gets two new fields: Building and Floor. These are read-only text fields.

Distribute Cost Using

  • Added to all Asset Types, manual lookup to Asset Type recordset's Quantity field fo Length/Area category
  • Text field (254 max length)
  • Required

The initial value for each asset type is listed below:

  • Parks: Acreage
  • Athletic Spaces: Area
  • Facility Floors: Area
  • Landscape Areas: Area
  • Park Structures: Area
  • Pavement Areas: Area
  • Playgrounds: Area
  • Roofing System: Area
  • Storm Basins: Area
  • WTP Floors: Area
  • WWTP Floors: Area
  • WTP Facilities: Facility Size
  • WWTP Facilities: Facility Size
  • Facilities: Facility Size
  • Bridges: Length
  • Fences: Length
  • Floodwalls: Length
  • Guardrails: Length
  • Levee Embankments: Length
  • Markings: Length
  • Pavement: Length
  • Sewer Force Mains: Length
  • Sewer Laterals: Length
  • Sewer Mains : Length
  • Sidewalks: Length
  • Storm Channels: Length
  • Storm Culverts: Length
  • Storm Pipes: Length
  • Water Laterals: Length
  • Water Mains: Length
  • Everything Else: None

Changes

Recordsets

Electrical Generators: Table: genMainGeneral and component of Facility Floors

Facilities: Table: faciMainGeneral, and container to Facility Floors

Facility Lighting: Table: fligMainGeneral and component of Facility Floors

Fire Protection: Table: fireMainGeneral and component of Facility Floors

HVAC Equipment: Table: hvacMainGeneral and component of Facility Floors

Plumbing Fixtures: Table: pfixMainGeneral and component of Facility Floors

Roofing Systems: Table: roofMainGeneral and component of Facility Floors

WTP Blowers: Table: wtpBlowerMainGeneral and component of: WTP Floors

WTP Compressors: Table: wtpCompMainGeneral and component of WTP Floors

WTP Electrical Generators: Table: wtpGenMainGeneral and component of WTP Floors

WTP Facilities: Table: wtpFaciMainGeneral and container to WTP Floors

WTP HVAC Equipment: Table: wtpHvacMainGeneral and component of WTP Floors

WTP Instrumentation: Table: wtpInstrMainGeneral and component of WTP Floors

WTP Motors: Table: wtpMotorMainGeneral and component of WTP Floors

WTP Pumps: Table: wtpPumpMainGeneral and component of WTP Floors

WTP Screens: Table: wtpScreenMainGeneral and component of WTP Floors

WTP Structures: Table: wtpStruMainGeneral and component of WTP Floors

WTP UV: Table: wtpUVMainGeneral and component of WTP Floors

WTP Valves: Table: wtpValveMainGeneral and component of WTP Floors

WWTP Blowers: Table: wwtpBlowerMainGeneral and component of WWTP Floors

WWTP Compressors: Table: wwtpCompMainGeneral and component of WWTP Floors

WWTP Conveyors: Table: wwtpConvMainGeneral and component of WWTP Floors

WWTP Electrical Generators: Table: wwtpGenMainGeneral and component of WWTP Floors

WWTP Facilities: Table: wwtpFaciMainGeneral and container to WWTP Floors

WWTP HVAC Equipment: Table: wwtpHvacMainGeneral and component of WWTP Floors

WWTP Instrumentation: Table: wwtpInstrMainGeneral and component of WWTP Floors

WWTP Motors: Table: wwtpMotorMainGeneral and component of WWTP Floors

WWTP Presses: Table: wwtpPressMainGeneral and component of WWTP Floors

WWTP Pumps: Table: wwtpPumpMainGeneral and component of WWTP Floors

WWTP Screens: Table: wwtpScreenMainGeneral and component of WWTP Floors

WWTP Structures: Table: wwtpStruMainGeneral and component of WWTP Floors

WWTP UV: Table: wwtpUVMainGeneral and component of WWTP Floors

WWTP Valves: Table: wwtpValveMainGeneral and component of WWTP Floors

Fields

Estimated Cost

  • Recordset: Tasks
  • Table: wdTaskMainGeneral
  • Field label changed to Scenario Estimated Cost

New Asset Types

Facility Floors

  • Asset Shape: Polygon
  • Component of Facilities
  • Container to:
    • Electrical Generators
    • Facility Lighting
    • Fire Protection
    • HVAC Equipment
    • Plumbing Fixtures
    • Roofing Systems
  • Overall Ratings:
    • Excellent – 81
    • Good – 61
    • Average – 41
    • Fair – 21
    • Poor – 1
    • Failed – 0
Recordsets and Libraries

Name

Type

ID

Table

Notes

Facility Floors

Recordset

cgFacilityFloors

faciFloorMainGeneral

 

Attachments

Recordset

cgAttachments

faciFloorAttachments

Child to Facility Floors

Facility Lighting

Recordset

cgFacilityLighting

fligMainGeneral

Child to Facility Floors

Inspections

Recordset

cgInspections

faciFloorInspections

Child to Facility Floors

Performance Curve

Recordset

cgPerformanceCurve

faciFloorPerformanceCurve

Child to Facility Floors

Roofing Systems

Recordset

cgRoofingSystems

roofMainGeneral

Child to Facility Floors

Facility Floor Condition Categories

Library

cgFacilityFloorConditionCategories

faciFloorCondCategories

Child to Facility Floor Inpsections

Facility Floor Condition Groups

Library

cgFacilityFloorConditionGroups

faciFloorConditionGroups

 

Facility Floor Overall Ratings

Library

cgFacilityFloorOverallRatings

faciFloorOverallRatings

 

Facility Floor Prediction Groups

Library

cgFacilityFloorPredictionGroups

faciFloorPredictionGroups

 

Key Fields

Name

UID

Column Name

Field Type

Read-Only

Is Required

Floor Name

cgFloorName

cgFloorName

Text

 

x

Level

cgLevel

cgLevel

Integer

 

x

Building

cgBuilding

cgBuilding

Text

x

 

Building Class

cgBuildingClass

cgBuildingClass

Text

x

 

Area

Area

Area

Quantity  (ft2)

 

 

WTP Floors

  • Asset Shape: Polygon
  • Component of WTP Facilities
  • Container to:
    • WTP Electrical Generators
    • WTP HVAC Equipment
    • WTP UV
    • WTP Valves
    • WTP Instrumentation
    • WTP Motors
    • WTP Pumps
    • WTP Screens
    • WTP Blowers
    • WTP Compressors
    • WTP Structures
  • Overall Ratings:
    • Excellent – 81
    • Good – 61
    • Average – 41
    • Fair – 21
    • Poor – 1
    • Failed – 0
Recordsets and Libraries

Name

Type

ID

Table

Notes

WTP Floors

Recordset

cgWTPFloors

wtpFloorMainGeneral

 

Attachments

Recordset

cgAttachments

wtpFloorAttachments

Child to WTP Floors

Inspections

Recordset

cgInspections

wtpFloorInspections

Child to WTP Floors

Performance Curve

Recordset

cgPerformanceCurve

wtpFloorPerformanceCurve

Child to WTP Floors

WTP Floor Condition Categories

Library

cgWTPFloorConditionCategories

wtpFloorCondCategories

Child to WTP Floor Inpsections

WTP Floor Condition Groups

Library

cgWTPFloorConditionGroups

wtpFloorConditionGroups

 

WTP Floor Overall Ratings

Library

cgWTPFloorOverallRatings

wtpFloorOverallRatings

 

WTP Floor Prediction Groups

Library

cgWTPFloorPredictionGroups

wtpFloorPredictionGroups

 

Key Fields

Name

UID

Column Name

Field Type

Read-Only

Is Unique

Is Required

Floor Name

cgFloorName

cgFloorName

Text

 

 

x

Level

cgLevel

cgLevel

Integer

 

 

x

Building

cgBuilding

cgBuilding

Text

x

 

 

Building Class

cgBuildingClass

cgBuildingClass

Text

x

 

 

Area

Area

Area

Quantity (ft2)

 

 

 

WWTP Floors

  • Asset Shape: Polygon
  • Component of WWTP Facilities
  • Container to:
    • WWTP Electrical Generators
    • WWTP HVAC Equipment
    • WWTP Blowers
    • WWTP Compressors
    • WWTP Instrumentation
    • WWTP Motors
    • WWTP Presses
    • WWTP Pumps
    • WWTP Screens
    • WWTP UV
    • WWTP Valves
    • WWTP Conveyors
    • WWTP Structures
  • Overall Ratings:
    • Excellent – 81
    • Good – 61
    • Average – 41
    • Fair – 21
    • Poor – 1
    • Failed – 0

Recordsets and Libraries

Name

Type

ID

Table

Notes

WWTP Floors

Recordset

cgWWTPFloors

wwtpFloorMainGeneral

 

Attachments

Recordset

cgAttachments

wwtpFloorAttachments

Child to WWTP Floors

Inspections

Recordset

cgInspections

wwtpFloorInspections

Child to WWTP Floors

Performance Curve

Recordset

cgPerformanceCurve

wwtpFloorPerformanceCurve

Child to WWTP Floors

WWTP Floor Condition Categories

Library

cgWWTPFloorConditionCategories

wwtpFloorCondCategories

Child to WWTP Floor Inspections

WWTP Floor Condition Groups

Library

cgWWTPFloorConditionGroups

wwtpFloorConditionGroups

 

WWTP Floor Overall Ratings

Library

cgWWTPFloorOverallRatings

wwtpFloorOverallRatings

 

WWTP Floor Prediction Groups

Library

cgWWTPFloorPredictionGroups

wwtpFloorPredictionGroups

 

Key Fields

Name

UID

Column Name

Field Type

Read-Only

Is Unique

Is Required

Floor Name

cgFloorName

cgFloorName

Text

 

 

x

Level

cgLevel

cgLevel

Integer

 

 

x

Building

cgBuilding

cgBuilding

Text

x

 

 

Building Class

cgBuildingClass

cgBuildingClass

Text

x

 

 

Area

Area

Area

Quantity  (ft2)

 

 

 

​​​​​​​