Name: PPMS MW Phase 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:
-
OBJECTID
(
type: esriFieldTypeOID, alias: OBJECTID
)
-
ID
(
type: esriFieldTypeInteger, alias: ID
)
-
PhaseNumber
(
type: esriFieldTypeString, alias: PhaseNumber, length: 50
)
-
ProjectID
(
type: esriFieldTypeInteger, alias: ProjectID
)
-
ProjectNumber
(
type: esriFieldTypeString, alias: ProjectNumber, length: 50
)
-
PhaseStatusDescription
(
type: esriFieldTypeString, alias: PhaseStatusDescription, length: 30
)
-
TPMSID
(
type: esriFieldTypeInteger, alias: TPMSID
)
-
PCN
(
type: esriFieldTypeString, alias: PCN, length: 20
)
-
FundingType
(
type: esriFieldTypeString, alias: FundingType, length: 30
)
-
FundingCodeDescription
(
type: esriFieldTypeString, alias: FundingCodeDescription, length: 255
)
-
PhaseProgramYear
(
type: esriFieldTypeString, alias: PhaseProgramYear, length: 4
)
-
ProgramAmount
(
type: esriFieldTypeDouble, alias: ProgramAmount
)
-
InflatedCostEstimate
(
type: esriFieldTypeDouble, alias: InflatedCostEstimate
)
-
District
(
type: esriFieldTypeInteger, alias: District
)
-
ProjectManager
(
type: esriFieldTypeString, alias: ProjectManager, length: 50
)
-
RuralUrban
(
type: esriFieldTypeString, alias: RuralUrban, length: 40
)
-
LettingDate
(
type: esriFieldTypeDate, alias: LettingDate, length: 8, precision: 1
)
-
PlanTurnInDate
(
type: esriFieldTypeDate, alias: PlanTurnInDate, length: 8, precision: 1
)
-
BeginMilePost
(
type: esriFieldTypeString, alias: BeginMilePost, length: 20
)
-
EndMilePost
(
type: esriFieldTypeString, alias: EndMilePost, length: 20
)
-
ProjectStatus
(
type: esriFieldTypeString, alias: ProjectStatus, length: 50
)
-
AssignedTo
(
type: esriFieldTypeString, alias: AssignedTo, length: 50
)
-
BridgeDesigner
(
type: esriFieldTypeString, alias: BridgeDesigner, length: 100
)
-
RoadDesigner
(
type: esriFieldTypeString, alias: RoadDesigner, length: 60
)
-
RCE
(
type: esriFieldTypeString, alias: RCE, length: 1000
)
-
RCEUsername
(
type: esriFieldTypeString, alias: RCEUsername, length: 20
)
-
RCECompanyName
(
type: esriFieldTypeString, alias: RCECompanyName, length: 200
)
-
BidOrderNo
(
type: esriFieldTypeString, alias: BidOrderNo, length: 10
)
-
ContractID
(
type: esriFieldTypeString, alias: ContractID, length: 20
)
-
WorkGroup
(
type: esriFieldTypeString, alias: WorkGroup, length: 5
)
-
WorkCode
(
type: esriFieldTypeString, alias: WorkCode, length: 5
)
-
WorkCodeDescription
(
type: esriFieldTypeString, alias: WorkCodeDescription, length: 100
)
-
ProjectType
(
type: esriFieldTypeString, alias: ProjectType, length: 40
)
-
ProjectCode
(
type: esriFieldTypeString, alias: ProjectCode, length: 30
)
-
Active
(
type: esriFieldTypeString, alias: Active, length: 5
)
-
Corridor
(
type: esriFieldTypeString, alias: Corridor, length: 50
)
-
DistrictProjectManager
(
type: esriFieldTypeString, alias: DistrictProjectManager, length: 50
)
-
PhaseLocation
(
type: esriFieldTypeString, alias: PhaseLocation, length: 200
)
-
PhaseLocationPrimaryCounty
(
type: esriFieldTypeString, alias: PhaseLocationPrimaryCounty, length: 2
)
-
PhaseLocationCounties
(
type: esriFieldTypeString, alias: PhaseLocationCounties, length: 50
)
-
PhaseLocationPrimaryRoute
(
type: esriFieldTypeString, alias: PhaseLocationPrimaryRoute, length: 200
)
-
PhaseLocationRoutes
(
type: esriFieldTypeString, alias: PhaseLocationRoutes, length: 40
)
-
PhaseLocationMiles
(
type: esriFieldTypeDouble, alias: PhaseLocationMiles
)
-
ProjectLocationPrimaryCounty
(
type: esriFieldTypeString, alias: ProjectLocationPrimaryCounty, length: 2
)
-
ProjectLocationCounties
(
type: esriFieldTypeString, alias: ProjectLocationCounties, length: 60
)
-
ProjectLocationPrimaryRoute
(
type: esriFieldTypeString, alias: ProjectLocationPrimaryRoute, length: 15
)
-
ProjectLocationRoutes
(
type: esriFieldTypeString, alias: ProjectLocationRoutes, length: 1073741822
)
-
ProjectLocationMiles
(
type: esriFieldTypeDouble, alias: ProjectLocationMiles
)
-
IsWorkflowAssociated
(
type: esriFieldTypeString, alias: IsWorkflowAssociated, length: 5
)
-
WorkflowStatus
(
type: esriFieldTypeString, alias: WorkflowStatus, length: 30
)
-
ProjectLocation
(
type: esriFieldTypeString, alias: ProjectLocation, length: 200
)
-
PrimaryCounty
(
type: esriFieldTypeString, alias: PrimaryCounty, length: 20
)
-
PrimaryCountyName
(
type: esriFieldTypeString, alias: PrimaryCountyName, length: 60
)
-
CountyCode
(
type: esriFieldTypeString, alias: CountyCode, length: 2
)
-
PrimaryRoute
(
type: esriFieldTypeString, alias: PrimaryRoute, length: 200
)
-
DoTContactName
(
type: esriFieldTypeString, alias: DoTContactName, length: 100
)
-
DoTContactPhone
(
type: esriFieldTypeString, alias: DoTContactPhone, length: 20
)
-
DoTContactEmail
(
type: esriFieldTypeString, alias: DoTContactEmail, length: 60
)
-
Location
(
type: esriFieldTypeString, alias: Location, length: 200
)
-
WorkDescription
(
type: esriFieldTypeString, alias: WorkDescription, length: 30
)
-
WorkGroupDescription
(
type: esriFieldTypeString, alias: WorkGroupDescription, length: 30
)
-
ProgrammedAmount
(
type: esriFieldTypeDouble, alias: ProgrammedAmount
)
-
DevEstimate
(
type: esriFieldTypeDouble, alias: DevEstimate
)
-
FHWABridgeNo
(
type: esriFieldTypeString, alias: FHWABridgeNo, length: 25
)
-
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: 40
)
-
ParenNumber
(
type: esriFieldTypeString, alias: ParenNumber, length: 15
)
-
FileNumber
(
type: esriFieldTypeString, alias: FileNumber, length: 200
)
-
BaseCostEstimate
(
type: esriFieldTypeDouble, alias: BaseCostEstimate
)
-
TotalAmount
(
type: esriFieldTypeDouble, alias: TotalAmount
)
-
CostCenter
(
type: esriFieldTypeString, alias: CostCenter, length: 100
)
-
ContractorID
(
type: esriFieldTypeString, alias: ContractorID, length: 10
)
-
ContractDescription
(
type: esriFieldTypeString, alias: ContractDescription, length: 200
)
-
ContractorName
(
type: esriFieldTypeString, alias: ContractorName, length: 100
)
-
District435
(
type: esriFieldTypeDate, alias: District435, length: 8, precision: 1
)
-
District436
(
type: esriFieldTypeDate, alias: District436, length: 8, precision: 1
)
-
Materials436
(
type: esriFieldTypeDate, alias: Materials436, length: 8, precision: 1
)
-
Latitude
(
type: esriFieldTypeDouble, alias: Latitude
)
-
Longitude
(
type: esriFieldTypeDouble, alias: Longitude
)
-
CentralOffice
(
type: esriFieldTypeString, alias: CentralOffice, length: 20
)
-
Completed
(
type: esriFieldTypeDate, alias: Completed, length: 8, precision: 1
)
-
BRISWorkCode
(
type: esriFieldTypeString, alias: BRISWorkCode, length: 1
)
-
ProgramCategory
(
type: esriFieldTypeString, alias: ProgramCategory, length: 50
)
-
LastWarehouseUpdated
(
type: esriFieldTypeDate, alias: LastWarehouseUpdated, length: 8, precision: 1
)
Supported Operations:
Query
Query Attachments
Query Analytic
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata