{
 "currentVersion": 11.1,
 "cimVersion": "3.1.0",
 "id": 1,
 "name": "GIS.BuildingProcessAsset",
 "type": "Table",
 "description": null,
 "hasAttachments": true,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "NAME",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "PARENTID",
   "type": "esriFieldTypeString",
   "alias": "Parent ID",
   "length": 12,
   "domain": null
  },
  {
   "name": "PARENTGUID",
   "type": "esriFieldTypeString",
   "alias": "Parent GUID",
   "length": 75,
   "domain": null
  },
  {
   "name": "ASSETID",
   "type": "esriFieldTypeString",
   "alias": "Asset ID",
   "length": 12,
   "domain": null
  },
  {
   "name": "NAME",
   "type": "esriFieldTypeString",
   "alias": "Name",
   "length": 255,
   "domain": null
  },
  {
   "name": "ASSETSYSTEM",
   "type": "esriFieldTypeString",
   "alias": "Asset System",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "BPA_AssetSystem",
    "description": "Asset System",
    "codedValues": [
     {
      "name": "EIC (Electrical, Instrumentation, and Controls)",
      "code": "EIC"
     },
     {
      "name": "Mechanical",
      "code": "MECHANICAL"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "ASSETTYPE",
   "type": "esriFieldTypeString",
   "alias": "Asset Type",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "BPA_AssetType",
    "description": "Asset Type",
    "codedValues": [
     {
      "name": "Aeration / Odour Control",
      "code": "AERATION / ODOUR CONTROL"
     },
     {
      "name": "Controller",
      "code": "CONTROLLER"
     },
     {
      "name": "Dewatering Equipment",
      "code": "DEWATERING EQUIPMENT"
     },
     {
      "name": "Flow Measuring Equipment",
      "code": "FLOW MEASURING EQUIPMENT"
     },
     {
      "name": "GAS Detector",
      "code": "GAS DETECTOR"
     },
     {
      "name": "Instrumentation",
      "code": "INSTRUMENTATION"
     },
     {
      "name": "Miscellaneous PM Asset",
      "code": "MISCELLANEOUS PM ASSET"
     },
     {
      "name": "Mixer",
      "code": "MIXER"
     },
     {
      "name": "Motor",
      "code": "MOTOR"
     },
     {
      "name": "Other Instrumentation",
      "code": "OTHER INSTRUMENTATION"
     },
     {
      "name": "Other Process Mechanical",
      "code": "OTHER PROCESS MECHANICAL"
     },
     {
      "name": "Pump",
      "code": "PUMP"
     },
     {
      "name": "Starter",
      "code": "STARTER"
     },
     {
      "name": "Switchgear",
      "code": "SWITCHGEAR"
     },
     {
      "name": "Transformer",
      "code": "TRANSFORMER"
     },
     {
      "name": "UV Equipment",
      "code": "UV EQUIPMENT"
     },
     {
      "name": "Valve",
      "code": "VALVE"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "DECISIONLEVEL",
   "type": "esriFieldTypeString",
   "alias": "Decision Level",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "BPA_DecisionLevel",
    "description": "Decision Level",
    "codedValues": [
     {
      "name": "Maintenance Management",
      "code": "MAINTENANCE MANAGEMENT"
     },
     {
      "name": "Minor Capital",
      "code": "MINOR CAPITAL"
     },
     {
      "name": "Minor Critical Capital",
      "code": "MINOR CRITICAL CAPITAL"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "PARTSAVAILABILITY",
   "type": "esriFieldTypeString",
   "alias": "Parts Availability",
   "length": 40,
   "domain": {
    "type": "codedValue",
    "name": "BPA_PartsAvailability",
    "description": "Parts Availability",
    "codedValues": [
     {
      "name": "<1 Month",
      "code": "<1 MONTH"
     },
     {
      "name": ">6 Month",
      "code": ">6 MONTH"
     },
     {
      "name": "1-2 Month",
      "code": "1-2 MONTH"
     },
     {
      "name": "3-6 Month",
      "code": "3-6 MONTH"
     },
     {
      "name": "Unknown",
      "code": "UNKNOWN"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "CRITICALPARTSFLAG",
   "type": "esriFieldTypeString",
   "alias": "Critical Parts Flag",
   "length": 20,
   "domain": {
    "type": "codedValue",
    "name": "P_YesNoUnknown",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "YES"
     },
     {
      "name": "No",
      "code": "NO"
     },
     {
      "name": "Unknown",
      "code": "UNKNOWN"
     },
     {
      "name": "Not Applicable",
      "code": "NA"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "CONDITION",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Condition",
   "domain": {
    "type": "codedValue",
    "name": "P_Condition",
    "description": "",
    "codedValues": [
     {
      "name": "Good",
      "code": 1
     },
     {
      "name": "Satisfactory",
      "code": 2
     },
     {
      "name": "Fair",
      "code": 3
     },
     {
      "name": "Poor",
      "code": 4
     },
     {
      "name": "Critical",
      "code": 5
     },
     {
      "name": "Unknown",
      "code": 0
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "CONDITIONCOMMENT",
   "type": "esriFieldTypeString",
   "alias": "Condition Comment",
   "length": 255,
   "domain": null
  },
  {
   "name": "CONDITIONDATE",
   "type": "esriFieldTypeDate",
   "alias": "Condition Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "PMINTERVAL",
   "type": "esriFieldTypeString",
   "alias": "PM Interval",
   "length": 15,
   "domain": {
    "type": "codedValue",
    "name": "BPA_PMInterval",
    "description": "PM Interval",
    "codedValues": [
     {
      "name": "Date",
      "code": "DATE"
     },
     {
      "name": "Hours",
      "code": "HOURS"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "REPLACEMENTTYPE",
   "type": "esriFieldTypeString",
   "alias": "Replacement Type",
   "length": 12,
   "domain": {
    "type": "codedValue",
    "name": "BPA_ReplacementType",
    "description": "Replacement Type",
    "codedValues": [
     {
      "name": "Different",
      "code": "DIFFERENT"
     },
     {
      "name": "Equivalent",
      "code": "EQUIVALENT"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "LOCATION",
   "type": "esriFieldTypeString",
   "alias": "Location",
   "length": 100,
   "domain": null
  },
  {
   "name": "MODEL",
   "type": "esriFieldTypeString",
   "alias": "Model",
   "length": 50,
   "domain": null
  },
  {
   "name": "SERIALNO",
   "type": "esriFieldTypeString",
   "alias": "Serial No",
   "length": 50,
   "domain": null
  },
  {
   "name": "DESCRIPTION",
   "type": "esriFieldTypeString",
   "alias": "Description",
   "length": 50,
   "domain": null
  },
  {
   "name": "MANUFACTURERREF",
   "type": "esriFieldTypeString",
   "alias": "Manufacturer O&M Reference",
   "length": 50,
   "domain": null
  },
  {
   "name": "AMGROUP",
   "type": "esriFieldTypeString",
   "alias": "AM Group",
   "length": 25,
   "domain": {
    "type": "codedValue",
    "name": "Fac_AMGroup",
    "description": "",
    "codedValues": [
     {
      "name": "Building",
      "code": "BUILDING"
     },
     {
      "name": "Communication Network",
      "code": "COMMUNICATION NETWORK"
     },
     {
      "name": "Computing Infrastructure",
      "code": "COMPUTING INFRASTRUCTURE"
     },
     {
      "name": "Drainage Network",
      "code": "DRAINAGE NETWORK"
     },
     {
      "name": "Equipment",
      "code": "EQUIPMENT"
     },
     {
      "name": "Land",
      "code": "LAND"
     },
     {
      "name": "Sewer Network",
      "code": "SEWER NETWORK"
     },
     {
      "name": "Site Improvement",
      "code": "SITE IMPROVEMENT"
     },
     {
      "name": "Transportation Network",
      "code": "TRANSPORTATION NETWORK"
     },
     {
      "name": "Water Network",
      "code": "WATER NETWORK"
     },
     {
      "name": "N/A",
      "code": "N/A"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "ACQUIREDATE",
   "type": "esriFieldTypeDate",
   "alias": "Acquire Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "ACQUIRESOURCE",
   "type": "esriFieldTypeString",
   "alias": "Acquire Source",
   "length": 10,
   "domain": {
    "type": "codedValue",
    "name": "Fac_AcquireSource",
    "description": "",
    "codedValues": [
     {
      "name": "Purchased",
      "code": "PURCHASED"
     },
     {
      "name": "Donated",
      "code": "DONATED"
     },
     {
      "name": "Leased",
      "code": "LEASED"
     },
     {
      "name": "Not Applicable",
      "code": "N/A"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "DEPRECIATIONLIFE",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Depreciation Life",
   "domain": {
    "type": "codedValue",
    "name": "Fac_DepreciationLife",
    "description": "",
    "codedValues": [
     {
      "name": "5",
      "code": 5
     },
     {
      "name": "10",
      "code": 10
     },
     {
      "name": "12",
      "code": 12
     },
     {
      "name": "15",
      "code": 15
     },
     {
      "name": "20",
      "code": 20
     },
     {
      "name": "25",
      "code": 25
     },
     {
      "name": "30",
      "code": 30
     },
     {
      "name": "40",
      "code": 40
     },
     {
      "name": "50",
      "code": 50
     },
     {
      "name": "60",
      "code": 60
     },
     {
      "name": "75",
      "code": 75
     },
     {
      "name": "0",
      "code": 0
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "ACQUIRECOST",
   "type": "esriFieldTypeInteger",
   "alias": "Acquire Cost",
   "domain": null
  },
  {
   "name": "BUDGETFUNCTION",
   "type": "esriFieldTypeString",
   "alias": "Budget Function",
   "length": 4,
   "domain": {
    "type": "codedValue",
    "name": "Fac_BudgetFunction",
    "description": "",
    "codedValues": [
     {
      "name": "100-Solid Waste",
      "code": "100"
     },
     {
      "name": "140-Environmental Services",
      "code": "140"
     },
     {
      "name": "150-Cemetery",
      "code": "150"
     },
     {
      "name": "200-Police",
      "code": "200"
     },
     {
      "name": "250-Fire Protection",
      "code": "250"
     },
     {
      "name": "300-Infrastructure Maintenance",
      "code": "300"
     },
     {
      "name": "350-Public Transit",
      "code": "350"
     },
     {
      "name": "400-Parks, Recreation and Cultural Services",
      "code": "400"
     },
     {
      "name": "500-Community Development",
      "code": "500"
     },
     {
      "name": "600-Legislation & Enforcement",
      "code": "600"
     },
     {
      "name": "700-Corporate Administration",
      "code": "700"
     },
     {
      "name": "820-Water",
      "code": "820"
     },
     {
      "name": "840-Sewer",
      "code": "840"
     },
     {
      "name": "Not Applicable",
      "code": "N/A"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "FINANCIALASSETFLAG",
   "type": "esriFieldTypeString",
   "alias": "Financial Asset Flag",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "Fac_YesNoNAZZZ",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "YES"
     },
     {
      "name": "No",
      "code": "NO"
     },
     {
      "name": "N/A",
      "code": "N/A"
     },
     {
      "name": "ZZZ",
      "code": "ZZZ"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "ASSETSTATUS",
   "type": "esriFieldTypeString",
   "alias": "Asset Status",
   "length": 15,
   "domain": {
    "type": "codedValue",
    "name": "Fac_AssetStatus",
    "description": "",
    "codedValues": [
     {
      "name": "In Service",
      "code": "IN SERVICE"
     },
     {
      "name": "Out of Service",
      "code": "OUT OF SERVICE"
     },
     {
      "name": "Disposed",
      "code": "DISPOSED"
     },
     {
      "name": "Not Applicable",
      "code": "N/A"
     },
     {
      "name": "Merge",
      "code": "MERGE"
     },
     {
      "name": "Preliminary",
      "code": "PRELIMINARY"
     },
     {
      "name": "To Be Disposed",
      "code": "TO BE DISPOSED"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "WORKORDERNO",
   "type": "esriFieldTypeString",
   "alias": "Workorder No",
   "length": 10,
   "domain": null
  },
  {
   "name": "CAPITALPROJECTNO",
   "type": "esriFieldTypeString",
   "alias": "Capital Project No",
   "length": 15,
   "domain": null
  },
  {
   "name": "AGE",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Age",
   "domain": null
  },
  {
   "name": "USEFULLIFE",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Useful Life",
   "domain": null
  },
  {
   "name": "REMAININGLIFE",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Remaining Life",
   "domain": null
  },
  {
   "name": "CURRENTREPLACEMENTCOST",
   "type": "esriFieldTypeInteger",
   "alias": "Current Replacement Cost",
   "domain": null
  },
  {
   "name": "CURRENTREPLACEMENTCOSTDATE",
   "type": "esriFieldTypeString",
   "alias": "Current Replacement Cost Date",
   "length": 4,
   "domain": {
    "type": "codedValue",
    "name": "D_Year",
    "description": "",
    "codedValues": [
     {
      "name": "1999",
      "code": "1999"
     },
     {
      "name": "2000",
      "code": "2000"
     },
     {
      "name": "2001",
      "code": "2001"
     },
     {
      "name": "2002",
      "code": "2002"
     },
     {
      "name": "2003",
      "code": "2003"
     },
     {
      "name": "2004",
      "code": "2004"
     },
     {
      "name": "2005",
      "code": "2005"
     },
     {
      "name": "2006",
      "code": "2006"
     },
     {
      "name": "2007",
      "code": "2007"
     },
     {
      "name": "2008",
      "code": "2008"
     },
     {
      "name": "2009",
      "code": "2009"
     },
     {
      "name": "2010",
      "code": "2010"
     },
     {
      "name": "2011",
      "code": "2011"
     },
     {
      "name": "2012",
      "code": "2012"
     },
     {
      "name": "2013",
      "code": "2013"
     },
     {
      "name": "2014",
      "code": "2014"
     },
     {
      "name": "2015",
      "code": "2015"
     },
     {
      "name": "2016",
      "code": "2016"
     },
     {
      "name": "2017",
      "code": "2017"
     },
     {
      "name": "2018",
      "code": "2018"
     },
     {
      "name": "2019",
      "code": "2019"
     },
     {
      "name": "2020",
      "code": "2020"
     },
     {
      "name": "2021",
      "code": "2021"
     },
     {
      "name": "2022",
      "code": "2022"
     },
     {
      "name": "2023",
      "code": "2023"
     },
     {
      "name": "2024",
      "code": "2024"
     },
     {
      "name": "2025",
      "code": "2025"
     },
     {
      "name": "2026",
      "code": "2026"
     },
     {
      "name": "2027",
      "code": "2027"
     },
     {
      "name": "2028",
      "code": "2028"
     },
     {
      "name": "2029",
      "code": "2029"
     },
     {
      "name": "2030",
      "code": "2030"
     },
     {
      "name": "2031",
      "code": "2031"
     },
     {
      "name": "2032",
      "code": "2032"
     },
     {
      "name": "2033",
      "code": "2033"
     },
     {
      "name": "2034",
      "code": "2034"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "REPLACEMENTYEAR",
   "type": "esriFieldTypeString",
   "alias": "Replacement Year",
   "length": 4,
   "domain": {
    "type": "codedValue",
    "name": "D_Year",
    "description": "",
    "codedValues": [
     {
      "name": "1999",
      "code": "1999"
     },
     {
      "name": "2000",
      "code": "2000"
     },
     {
      "name": "2001",
      "code": "2001"
     },
     {
      "name": "2002",
      "code": "2002"
     },
     {
      "name": "2003",
      "code": "2003"
     },
     {
      "name": "2004",
      "code": "2004"
     },
     {
      "name": "2005",
      "code": "2005"
     },
     {
      "name": "2006",
      "code": "2006"
     },
     {
      "name": "2007",
      "code": "2007"
     },
     {
      "name": "2008",
      "code": "2008"
     },
     {
      "name": "2009",
      "code": "2009"
     },
     {
      "name": "2010",
      "code": "2010"
     },
     {
      "name": "2011",
      "code": "2011"
     },
     {
      "name": "2012",
      "code": "2012"
     },
     {
      "name": "2013",
      "code": "2013"
     },
     {
      "name": "2014",
      "code": "2014"
     },
     {
      "name": "2015",
      "code": "2015"
     },
     {
      "name": "2016",
      "code": "2016"
     },
     {
      "name": "2017",
      "code": "2017"
     },
     {
      "name": "2018",
      "code": "2018"
     },
     {
      "name": "2019",
      "code": "2019"
     },
     {
      "name": "2020",
      "code": "2020"
     },
     {
      "name": "2021",
      "code": "2021"
     },
     {
      "name": "2022",
      "code": "2022"
     },
     {
      "name": "2023",
      "code": "2023"
     },
     {
      "name": "2024",
      "code": "2024"
     },
     {
      "name": "2025",
      "code": "2025"
     },
     {
      "name": "2026",
      "code": "2026"
     },
     {
      "name": "2027",
      "code": "2027"
     },
     {
      "name": "2028",
      "code": "2028"
     },
     {
      "name": "2029",
      "code": "2029"
     },
     {
      "name": "2030",
      "code": "2030"
     },
     {
      "name": "2031",
      "code": "2031"
     },
     {
      "name": "2032",
      "code": "2032"
     },
     {
      "name": "2033",
      "code": "2033"
     },
     {
      "name": "2034",
      "code": "2034"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "GLOBALID",
   "type": "esriFieldTypeGlobalID",
   "alias": "GLOBALID",
   "length": 38,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R5525_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "UUID_5525",
   "fields": "GLOBALID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 2,
   "name": "GIS.CityBuilding",
   "relatedTableId": 0,
   "role": "esriRelRoleDestination",
   "keyField": "PARENTID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{A4E3B4AA-DAFF-4D98-8AE9-A07EAF308A0F}"
  }
 ],
 "capabilities": "Query,Map,Data",
 "maxRecordCount": 2000,
 "supportsStatistics": true,
 "supportsExceedsLimitStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON, PBF",
 "isDataVersioned": false,
 "useStandardizedQueries": true,
 "advancedQueryCapabilities": {
  "useStandardizedQueries": true,
  "supportsStatistics": true,
  "supportsPercentileStatistics": true,
  "supportsHavingClause": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsCountDistinct": true,
  "supportsPagination": true,
  "supportsTrueCurve": false,
  "supportsReturningQueryExtent": true,
  "supportsQueryWithDistance": true,
  "supportsSqlExpression": true,
  "supportsTimeRelation": true,
  "supportsSqlFormat": false,
  "supportsQueryAnalytic": true
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": false,
  "supportsPercentileAnalytic": true
 },
 "dateFieldsTimeReference": null,
 "preferredTimeReference": null,
 "datesInUnknownTimezone": false,
 "hasMetadata": true,
 "isDataArchived": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 },
 "serviceItemId": "63397ce2d20c4b15af1118aae725003a"
}