| | ||||||
|---|---|---|---|---|---|---|
| Table Description | ||||||
| Table Jurisdiction | ||||||
| Column Sort | Column Name | Column Alias | Column Type | Column Size | Domain Value(s) | Column Description | 1 | GmlID | GmlID | String | 255 | | | 1 | PrimaryKey | PrimaryKey | Integer | 4 | | | 1 | LinkID | LinkID | Integer | 4 | | | 1 | ModelLinkID | ModelLinkID | Integer | 4 | | | 1 | ModelLinkName | ModelLinkName | String | 255 | | | 1 | GlobalID | GlobalID | Integer | 4 | | | 1 | CompKey | CompKey | Integer | 4 | | | 1 | InBESCollectionSystem | InBESCollectionSystem | String | 255 | | | 1 | LinkOperation | LinkOperation | String | 255 | | | 1 | Diameter | Diameter | Numeric | 8 | | | 1 | UnitType | UnitType | String | 255 | | | 1 | LayerGroup | LayerGroup | String | 255 | | | 1 | SymbolGroup | SymbolGroup | String | 255 | | | 1 | DetailSymbol | DetailSymbol | String | 255 | | | 1 | ServStatus | ServStatus | String | 255 | | | 1 | CrossSectionID | CrossSectionID | Integer | 4 | | | 1 | HansenMaterial | HansenMaterial | String | 255 | | | 1 | ModelMaterial | ModelMaterial | String | 255 | | | 1 | MappingCombinedMaterial | MappingCombinedMaterial | String | 255 | | | 1 | UpstreamDepth | UpstreamDepth | Numeric | 8 | | | 1 | DownstreamDepth | DownstreamDepth | Numeric | 8 | | | 1 | PipeHasInspections | PipeHasInspections | String | 255 | | | 1 | CurrentInspectionDate | CurrentInspectionDate | Date | 36 | | | 1 | InspectionCurrent | InspectionCurrent | String | 255 | | | 1 | ValidInspection | ValidInspection | String | 255 | | | 1 | StructuralRating | StructuralRating | Numeric | 8 | | | 1 | InspectionAge | InspectionAge | Integer | 4 | | | 1 | RootRating | RootRating | Numeric | 8 | | | 1 | FailureYear | FailureYear | Numeric | 8 | | | 1 | Age | Age | Numeric | 8 | | | 1 | ModelLinkGlobalID | ModelLinkGlobalID | Integer | 4 | | | 1 | ModelID | ModelID | Integer | 4 | | | 1 | SimulationID | SimulationID | Integer | 4 | | | 1 | SimulationDescription | SimulationDescription | String | 255 | | | 1 | ModelLinkSymbology | ModelLinkSymbology | String | 255 | | | 1 | ModelLinkPipeFlowRatio | ModelLinkPipeFlowRatio | Numeric | 8 | | | 1 | UpstreamSurchargeTime | UpstreamSurchargeTime | Numeric | 8 | | | 1 | UpstreamSurchargeDepthFt | UpstreamSurchargeDepthFt | Numeric | 8 | | | 1 | ML_IsUSNodeSurcharged | ModelLinkIsUpstreamNodeSurcharged | String | 255 | | | 1 | ML_IsHydraulDef | ModelLinkIsHydraulicallyDeficient | String | 255 | | | 1 | ModelLinkIsBrickPipeSurcharged | ModelLinkIsBrickPipeSurcharged | String | 255 | | | 1 | ML_ExceedsSurchargedDepthCrit | ModelLinkExceedsSurchargedDepthCriteria | String | 255 | | | 1 | ML_ExceedsSurchargeDurCrit | ModelLinkExceedsSurchargeDurationCriteria | String | 255 | | | 1 | SmallDiamRehabStatusInProject | SmallDiameterRehabStatusInProject | String | 255 | | | 1 | LargeDiameter | LargeDiameter | String | 255 | | | 1 | LargeDiameterInRehabDatabase | LargeDiameterInRehabDatabase | String | 255 | | | 1 | LargeDiamRehabStatusInProject | LargeDiameterRehabStatusInProject | String | 255 | | | 1 | LargeDiameterRehabBPW | LargeDiameterRehabBPW | Numeric | 8 | | | 1 | LifeCycleBPW | LifeCycleBPW | Numeric | 8 | | | 1 | LifeCycleAPW | LifeCycleAPW | Numeric | 8 | | | 1 | LifeCycleCost | LifeCycleCost | Numeric | 8 | | | 1 | LifeCycleNBCR | LifeCycleNBCR | Numeric | 8 | | | 1 | WatchMe | WatchMe | String | 255 | | | 1 | LifeCycleRecommendedMethod | LifeCycleRecommendedMethod | String | 255 | | | 1 | LifeCycleEmergencyMethod | LifeCycleEmergencyMethod | String | 255 | | | 1 | BPW | BPW | Numeric | 8 | | | 1 | Shape_STLength__ | Shape_STLength__ | Numeric | 8 | | |