Name: PPMS MW Projects Phases Table
Display Field: RCEUsername
Type: Table
Geometry Type: N/A
Description: null
Service Item Id: e693b77d59b84d1d9940220ac2dddc8c
Copyright Text: N/A
Default Visibility: false
MaxRecordCount: 4000
Supported Query Formats: JSON, PBF
Supports Advanced Queries: true
Supports Statistics: true
Use Standardized Queries: true
Extent:
Drawing Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Type ID Field: null
Fields:
-
prjNumber
(
type: esriFieldTypeString, alias: prjNumber, length: 45
)
-
prjID
(
type: esriFieldTypeInteger, alias: prjID
)
-
CreationDate
(
type: esriFieldTypeDate, alias: CreationDate, length: 8
)
-
LastModifiedDate
(
type: esriFieldTypeDate, alias: LastModifiedDate, length: 8
)
-
District
(
type: esriFieldTypeString, alias: District, length: 5
)
-
Manager
(
type: esriFieldTypeString, alias: Manager, length: 100
)
-
RuralUrban
(
type: esriFieldTypeString, alias: RuralUrban, length: 100
)
-
Miles
(
type: esriFieldTypeDouble, alias: Miles
)
-
BeginMilepost
(
type: esriFieldTypeString, alias: BeginMilepost, length: 20
)
-
EndMilepost
(
type: esriFieldTypeString, alias: EndMilepost, length: 20
)
-
Status
(
type: esriFieldTypeString, alias: Status, length: 20
)
-
Corridor
(
type: esriFieldTypeString, alias: Corridor, length: 50
)
-
HighwayClass
(
type: esriFieldTypeString, alias: HighwayClass, length: 20
)
-
Type
(
type: esriFieldTypeString, alias: Type, length: 30
)
-
ParksInstitutionType
(
type: esriFieldTypeString, alias: ParksInstitutionType, length: 5
)
-
MitigationType
(
type: esriFieldTypeString, alias: MitigationType, length: 5
)
-
PermitRequired
(
type: esriFieldTypeString, alias: PermitRequired, length: 10
)
-
Location
(
type: esriFieldTypeString, alias: Location, length: 200
)
-
PrimaryCounty
(
type: esriFieldTypeString, alias: PrimaryCounty, length: 50
)
-
PrimaryRoute
(
type: esriFieldTypeString, alias: PrimaryRoute, length: 20
)
-
ProgrammedAmount
(
type: esriFieldTypeDouble, alias: ProgrammedAmount
)
-
DevelopmentEstimate
(
type: esriFieldTypeDouble, alias: DevelopmentEstimate
)
-
DirectoryNumber
(
type: esriFieldTypeString, alias: DirectoryNumber, length: 20
)
-
RailroadInvolved
(
type: esriFieldTypeString, alias: RailroadInvolved, length: 5
)
-
IsWorkflowAssociated
(
type: esriFieldTypeString, alias: IsWorkflowAssociated, length: 10
)
-
PhaseID
(
type: esriFieldTypeInteger, alias: PhaseID
)
-
PhaseNumber
(
type: esriFieldTypeString, alias: PhaseNumber, length: 50
)
-
PhaseStatusDescription
(
type: esriFieldTypeString, alias: PhaseStatusDescription, length: 30
)
-
TPMSID
(
type: esriFieldTypeInteger, alias: TPMSID
)
-
PCN
(
type: esriFieldTypeString, alias: PCN, length: 30
)
-
ExFundingTypePhase
(
type: esriFieldTypeString, alias: ExFundingTypePhase, length: 2300
)
-
FundingCodeDescription
(
type: esriFieldTypeString, alias: FundingCodeDescription, length: 100
)
-
PhaseProgramYear
(
type: esriFieldTypeInteger, alias: PhaseProgramYear
)
-
ProgramAmount
(
type: esriFieldTypeDouble, alias: ProgramAmount
)
-
InflatedCostEstimate
(
type: esriFieldTypeDouble, alias: InflatedCostEstimate
)
-
DistrictPhase
(
type: esriFieldTypeString, alias: DistrictPhase, length: 5
)
-
ProjectManager
(
type: esriFieldTypeString, alias: ProjectManager, length: 100
)
-
RuralUrvanPhase
(
type: esriFieldTypeString, alias: RuralUrvanPhase, length: 50
)
-
LettingDate
(
type: esriFieldTypeDate, alias: LettingDate, length: 8
)
-
PlanTurnInDate
(
type: esriFieldTypeDate, alias: PlanTurnInDate, length: 8
)
-
BeginMilePostPhase
(
type: esriFieldTypeString, alias: BeginMilePostPhase, length: 20
)
-
EndMilePostPhase
(
type: esriFieldTypeString, alias: EndMilePostPhase, length: 20
)
-
AssignedTo
(
type: esriFieldTypeString, alias: AssignedTo, length: 100
)
-
BridgeDesigner
(
type: esriFieldTypeString, alias: BridgeDesigner, length: 100
)
-
RoadDesigner
(
type: esriFieldTypeString, alias: RoadDesigner, length: 100
)
-
RCE
(
type: esriFieldTypeString, alias: RCE, length: 50
)
-
RCEUsername
(
type: esriFieldTypeString, alias: RCEUsername, length: 10
)
-
RCECompanyName
(
type: esriFieldTypeString, alias: RCECompanyName, length: 10
)
-
BidOrderNo
(
type: esriFieldTypeString, alias: BidOrderNo, length: 5
)
-
ContractID
(
type: esriFieldTypeString, alias: ContractID, length: 20
)
-
WorkGroupPhase
(
type: esriFieldTypeString, alias: WorkGroupPhase, length: 5
)
-
WorkCode
(
type: esriFieldTypeString, alias: WorkCode, length: 5
)
-
WorkCodeDescription
(
type: esriFieldTypeString, alias: WorkCodeDescription, length: 100
)
-
ProjectType
(
type: esriFieldTypeString, alias: ProjectType, length: 50
)
-
ProjectCode
(
type: esriFieldTypeString, alias: ProjectCode, length: 50
)
-
Active
(
type: esriFieldTypeString, alias: Active, length: 3
)
-
CorridorPhase
(
type: esriFieldTypeString, alias: CorridorPhase, length: 50
)
-
DistrictProjectManager
(
type: esriFieldTypeString, alias: DistrictProjectManager, length: 30
)
-
PhaseLocation
(
type: esriFieldTypeString, alias: PhaseLocation, length: 150
)
-
PhaseLocationPrimaryCounty
(
type: esriFieldTypeString, alias: PhaseLocationPrimaryCounty, length: 3
)
-
PhaseLocationCounties
(
type: esriFieldTypeString, alias: PhaseLocationCounties, length: 50
)
-
PhaseLocationPrimaryRoute
(
type: esriFieldTypeString, alias: PhaseLocationPrimaryRoute, length: 20
)
-
PhaseLocationRoutes
(
type: esriFieldTypeString, alias: PhaseLocationRoutes, length: 2200
)
-
PhaseLocationMiles
(
type: esriFieldTypeDouble, alias: PhaseLocationMiles
)
-
ProjectLocationPrimaryCounty
(
type: esriFieldTypeString, alias: ProjectLocationPrimaryCounty, length: 3
)
-
ProjectLocationCounties
(
type: esriFieldTypeString, alias: ProjectLocationCounties, length: 200
)
-
ProjectLocationPrimaryRoute
(
type: esriFieldTypeString, alias: ProjectLocationPrimaryRoute, length: 20
)
-
ProjectLocationRoutes
(
type: esriFieldTypeString, alias: ProjectLocationRoutes, length: 4000
)
-
ProjectLocationMiles
(
type: esriFieldTypeDouble, alias: ProjectLocationMiles
)
-
IsWorkflowAssociatedPhase
(
type: esriFieldTypeString, alias: IsWorkflowAssociatedPhase, length: 10
)
-
WorkflowStatus
(
type: esriFieldTypeString, alias: WorkflowStatus, length: 30
)
-
PrimaryCountyPhase
(
type: esriFieldTypeString, alias: PrimaryCountyPhase, length: 20
)
-
CountyCode
(
type: esriFieldTypeString, alias: CountyCode, length: 3
)
-
PrimaryRoutePhase
(
type: esriFieldTypeString, alias: PrimaryRoutePhase, length: 100
)
-
LocationPhase
(
type: esriFieldTypeString, alias: LocationPhase, length: 200
)
-
WorkGroupDescription
(
type: esriFieldTypeString, alias: WorkGroupDescription, length: 50
)
-
ProgrammedAmountPhase
(
type: esriFieldTypeDouble, alias: ProgrammedAmountPhase
)
-
DevEstimate
(
type: esriFieldTypeDouble, alias: DevEstimate
)
-
RR_Involved
(
type: esriFieldTypeString, alias: RR_Involved, length: 5
)
-
RR_Agreement
(
type: esriFieldTypeString, alias: RR_Agreement, length: 5
)
-
Metric
(
type: esriFieldTypeString, alias: Metric, length: 5
)
-
PlanType
(
type: esriFieldTypeString, alias: PlanType, length: 20
)
-
UserName
(
type: esriFieldTypeString, alias: UserName, length: 30
)
-
ParenNumber
(
type: esriFieldTypeString, alias: ParenNumber, length: 10
)
-
FileNumber
(
type: esriFieldTypeString, alias: FileNumber, length: 150
)
-
BaseCostEstimate
(
type: esriFieldTypeString, alias: BaseCostEstimate, length: 30
)
-
TotalAmount
(
type: esriFieldTypeString, alias: TotalAmount, length: 20
)
-
CostCenter
(
type: esriFieldTypeString, alias: CostCenter, length: 100
)
-
ContractorID
(
type: esriFieldTypeString, alias: ContractorID, length: 5
)
-
ContractorName
(
type: esriFieldTypeString, alias: ContractorName, length: 100
)
-
District435
(
type: esriFieldTypeString, alias: District435, length: 50
)
-
District436
(
type: esriFieldTypeString, alias: District436, length: 50
)
-
Latitude
(
type: esriFieldTypeDouble, alias: Latitude
)
-
Longitude
(
type: esriFieldTypeDouble, alias: Longitude
)
-
CentralOffice
(
type: esriFieldTypeString, alias: CentralOffice, length: 30
)
-
Completed
(
type: esriFieldTypeString, alias: Completed, length: 30
)
-
BRISWorkCode
(
type: esriFieldTypeString, alias: BRISWorkCode, length: 5
)
-
ProgramCategory
(
type: esriFieldTypeString, alias: ProgramCategory, length: 50
)
-
LastWarehouseUpdated
(
type: esriFieldTypeDate, alias: LastWarehouseUpdated, length: 8
)
-
OBJECTID
(
type: esriFieldTypeOID, alias: OBJECTID
)
-
hyperProject
(
type: esriFieldTypeString, alias: hyperProject, length: 400
)
-
hyperPhase
(
type: esriFieldTypeString, alias: hyperPhase, length: 400
)
Supported Operations:
Query
Query Attachments
Query Analytic
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata