{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 6, "name": "PPMS MW Phase Table", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "RCEUsername", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "ID", "type": "esriFieldTypeInteger", "alias": "ID", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "ID" }, { "name": "PhaseNumber", "type": "esriFieldTypeString", "alias": "PhaseNumber", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PhaseNumber" }, { "name": "ProjectID", "type": "esriFieldTypeInteger", "alias": "ProjectID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ProjectID" }, { "name": "ProjectNumber", "type": "esriFieldTypeString", "alias": "ProjectNumber", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ProjectNumber" }, { "name": "PhaseStatusDescription", "type": "esriFieldTypeString", "alias": "PhaseStatusDescription", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "PhaseStatusDescription" }, { "name": "TPMSID", "type": "esriFieldTypeInteger", "alias": "TPMSID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TPMSID" }, { "name": "PCN", "type": "esriFieldTypeString", "alias": "PCN", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "PCN" }, { "name": "FundingType", "type": "esriFieldTypeString", "alias": "FundingType", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "FundingType" }, { "name": "FundingCodeDescription", "type": "esriFieldTypeString", "alias": "FundingCodeDescription", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FundingCodeDescription" }, { "name": "PhaseProgramYear", "type": "esriFieldTypeString", "alias": "PhaseProgramYear", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "PhaseProgramYear" }, { "name": "ProgramAmount", "type": "esriFieldTypeDouble", "alias": "ProgramAmount", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ProgramAmount" }, { "name": "InflatedCostEstimate", "type": "esriFieldTypeDouble", "alias": "InflatedCostEstimate", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "InflatedCostEstimate" }, { "name": "District", "type": "esriFieldTypeInteger", "alias": "District", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "District" }, { "name": "ProjectManager", "type": "esriFieldTypeString", "alias": "ProjectManager", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ProjectManager" }, { "name": "RuralUrban", "type": "esriFieldTypeString", "alias": "RuralUrban", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "RuralUrban" }, { "name": "LettingDate", "type": "esriFieldTypeDate", "alias": "LettingDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "precision": 1, "modelName": "LettingDate" }, { "name": "PlanTurnInDate", "type": "esriFieldTypeDate", "alias": "PlanTurnInDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "precision": 1, "modelName": "PlanTurnInDate" }, { "name": "BeginMilePost", "type": "esriFieldTypeString", "alias": "BeginMilePost", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "BeginMilePost" }, { "name": "EndMilePost", "type": "esriFieldTypeString", "alias": "EndMilePost", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "EndMilePost" }, { "name": "ProjectStatus", "type": "esriFieldTypeString", "alias": "ProjectStatus", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ProjectStatus" }, { "name": "AssignedTo", "type": "esriFieldTypeString", "alias": "AssignedTo", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "AssignedTo" }, { "name": "BridgeDesigner", "type": "esriFieldTypeString", "alias": "BridgeDesigner", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "BridgeDesigner" }, { "name": "RoadDesigner", "type": "esriFieldTypeString", "alias": "RoadDesigner", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "RoadDesigner" }, { "name": "RCE", "type": "esriFieldTypeString", "alias": "RCE", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "RCE" }, { "name": "RCEUsername", "type": "esriFieldTypeString", "alias": "RCEUsername", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "RCEUsername" }, { "name": "RCECompanyName", "type": "esriFieldTypeString", "alias": "RCECompanyName", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "RCECompanyName" }, { "name": "BidOrderNo", "type": "esriFieldTypeString", "alias": "BidOrderNo", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "BidOrderNo" }, { "name": "ContractID", "type": "esriFieldTypeString", "alias": "ContractID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "ContractID" }, { "name": "WorkGroup", "type": "esriFieldTypeString", "alias": "WorkGroup", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "WorkGroup" }, { "name": "WorkCode", "type": "esriFieldTypeString", "alias": "WorkCode", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "WorkCode" }, { "name": "WorkCodeDescription", "type": "esriFieldTypeString", "alias": "WorkCodeDescription", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "WorkCodeDescription" }, { "name": "ProjectType", "type": "esriFieldTypeString", "alias": "ProjectType", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "ProjectType" }, { "name": "ProjectCode", "type": "esriFieldTypeString", "alias": "ProjectCode", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "ProjectCode" }, { "name": "Active", "type": "esriFieldTypeString", "alias": "Active", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "Active" }, { "name": "Corridor", "type": "esriFieldTypeString", "alias": "Corridor", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Corridor" }, { "name": "DistrictProjectManager", "type": "esriFieldTypeString", "alias": "DistrictProjectManager", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "DistrictProjectManager" }, { "name": "PhaseLocation", "type": "esriFieldTypeString", "alias": "PhaseLocation", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "PhaseLocation" }, { "name": "PhaseLocationPrimaryCounty", "type": "esriFieldTypeString", "alias": "PhaseLocationPrimaryCounty", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "PhaseLocationPrimaryCounty" }, { "name": "PhaseLocationCounties", "type": "esriFieldTypeString", "alias": "PhaseLocationCounties", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PhaseLocationCounties" }, { "name": "PhaseLocationPrimaryRoute", "type": "esriFieldTypeString", "alias": "PhaseLocationPrimaryRoute", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "PhaseLocationPrimaryRoute" }, { "name": "PhaseLocationRoutes", "type": "esriFieldTypeString", "alias": "PhaseLocationRoutes", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "PhaseLocationRoutes" }, { "name": "PhaseLocationMiles", "type": "esriFieldTypeDouble", "alias": "PhaseLocationMiles", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PhaseLocationMiles" }, { "name": "ProjectLocationPrimaryCounty", "type": "esriFieldTypeString", "alias": "ProjectLocationPrimaryCounty", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "ProjectLocationPrimaryCounty" }, { "name": "ProjectLocationCounties", "type": "esriFieldTypeString", "alias": "ProjectLocationCounties", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "ProjectLocationCounties" }, { "name": "ProjectLocationPrimaryRoute", "type": "esriFieldTypeString", "alias": "ProjectLocationPrimaryRoute", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "ProjectLocationPrimaryRoute" }, { "name": "ProjectLocationRoutes", "type": "esriFieldTypeString", "alias": "ProjectLocationRoutes", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "ProjectLocationRoutes" }, { "name": "ProjectLocationMiles", "type": "esriFieldTypeDouble", "alias": "ProjectLocationMiles", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ProjectLocationMiles" }, { "name": "IsWorkflowAssociated", "type": "esriFieldTypeString", "alias": "IsWorkflowAssociated", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "IsWorkflowAssociated" }, { "name": "WorkflowStatus", "type": "esriFieldTypeString", "alias": "WorkflowStatus", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "WorkflowStatus" }, { "name": "ProjectLocation", "type": "esriFieldTypeString", "alias": "ProjectLocation", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "ProjectLocation" }, { "name": "PrimaryCounty", "type": "esriFieldTypeString", "alias": "PrimaryCounty", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "PrimaryCounty" }, { "name": "PrimaryCountyName", "type": "esriFieldTypeString", "alias": "PrimaryCountyName", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "PrimaryCountyName" }, { "name": "CountyCode", "type": "esriFieldTypeString", "alias": "CountyCode", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "CountyCode" }, { "name": "PrimaryRoute", "type": "esriFieldTypeString", "alias": "PrimaryRoute", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "PrimaryRoute" }, { "name": "DoTContactName", "type": "esriFieldTypeString", "alias": "DoTContactName", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "DoTContactName" }, { "name": "DoTContactPhone", "type": "esriFieldTypeString", "alias": "DoTContactPhone", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "DoTContactPhone" }, { "name": "DoTContactEmail", "type": "esriFieldTypeString", "alias": "DoTContactEmail", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "DoTContactEmail" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "Location" }, { "name": "WorkDescription", "type": "esriFieldTypeString", "alias": "WorkDescription", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "WorkDescription" }, { "name": "WorkGroupDescription", "type": "esriFieldTypeString", "alias": "WorkGroupDescription", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "WorkGroupDescription" }, { "name": "ProgrammedAmount", "type": "esriFieldTypeDouble", "alias": "ProgrammedAmount", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ProgrammedAmount" }, { "name": "DevEstimate", "type": "esriFieldTypeDouble", "alias": "DevEstimate", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DevEstimate" }, { "name": "FHWABridgeNo", "type": "esriFieldTypeString", "alias": "FHWABridgeNo", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "FHWABridgeNo" }, { "name": "RR_Involved", "type": "esriFieldTypeString", "alias": "RR_Involved", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "RR_Involved" }, { "name": "RR_Agreement", "type": "esriFieldTypeString", "alias": "RR_Agreement", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "RR_Agreement" }, { "name": "Metric", "type": "esriFieldTypeString", "alias": "Metric", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "Metric" }, { "name": "PlanType", "type": "esriFieldTypeString", "alias": "PlanType", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "PlanType" }, { "name": "UserName", "type": "esriFieldTypeString", "alias": "UserName", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "UserName" }, { "name": "ParenNumber", "type": "esriFieldTypeString", "alias": "ParenNumber", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "ParenNumber" }, { "name": "FileNumber", "type": "esriFieldTypeString", "alias": "FileNumber", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "FileNumber" }, { "name": "BaseCostEstimate", "type": "esriFieldTypeDouble", "alias": "BaseCostEstimate", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BaseCostEstimate" }, { "name": "TotalAmount", "type": "esriFieldTypeDouble", "alias": "TotalAmount", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TotalAmount" }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "CostCenter", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "CostCenter" }, { "name": "ContractorID", "type": "esriFieldTypeString", "alias": "ContractorID", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "ContractorID" }, { "name": "ContractDescription", "type": "esriFieldTypeString", "alias": "ContractDescription", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "ContractDescription" }, { "name": "ContractorName", "type": "esriFieldTypeString", "alias": "ContractorName", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "ContractorName" }, { "name": "District435", "type": "esriFieldTypeDate", "alias": "District435", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "precision": 1, "modelName": "District435" }, { "name": "District436", "type": "esriFieldTypeDate", "alias": "District436", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "precision": 1, "modelName": "District436" }, { "name": "Materials436", "type": "esriFieldTypeDate", "alias": "Materials436", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "precision": 1, "modelName": "Materials436" }, { "name": "Latitude", "type": "esriFieldTypeDouble", "alias": "Latitude", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Latitude" }, { "name": "Longitude", "type": "esriFieldTypeDouble", "alias": "Longitude", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Longitude" }, { "name": "CentralOffice", "type": "esriFieldTypeString", "alias": "CentralOffice", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "CentralOffice" }, { "name": "Completed", "type": "esriFieldTypeDate", "alias": "Completed", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "precision": 1, "modelName": "Completed" }, { "name": "BRISWorkCode", "type": "esriFieldTypeString", "alias": "BRISWorkCode", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "BRISWorkCode" }, { "name": "ProgramCategory", "type": "esriFieldTypeString", "alias": "ProgramCategory", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ProgramCategory" }, { "name": "LastWarehouseUpdated", "type": "esriFieldTypeDate", "alias": "LastWarehouseUpdated", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "precision": 1, "modelName": "LastWarehouseUpdated" } ], "indexes": [ { "name": "R257_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Central Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "PPMS MW Phase Table", "description": "", "prototype": { "attributes": { "ProgramCategory": null, "LastWarehouseUpdated": null, "ID": 0, "PhaseNumber": null, "ProjectID": null, "ProjectNumber": null, "PhaseStatusDescription": null, "TPMSID": null, "PCN": null, "FundingType": null, "FundingCodeDescription": null, "PhaseProgramYear": null, "ProgramAmount": null, "InflatedCostEstimate": null, "District": null, "ProjectManager": null, "RuralUrban": null, "LettingDate": null, "PlanTurnInDate": null, "BeginMilePost": null, "EndMilePost": null, "ProjectStatus": null, "AssignedTo": null, "BridgeDesigner": null, "RoadDesigner": null, "RCE": null, "RCEUsername": null, "RCECompanyName": null, "BidOrderNo": null, "ContractID": null, "WorkGroup": null, "WorkCode": null, "WorkCodeDescription": null, "ProjectType": null, "ProjectCode": null, "Active": null, "Corridor": null, "DistrictProjectManager": null, "PhaseLocation": null, "PhaseLocationPrimaryCounty": null, "PhaseLocationCounties": null, "PhaseLocationPrimaryRoute": null, "PhaseLocationRoutes": null, "PhaseLocationMiles": null, "ProjectLocationPrimaryCounty": null, "ProjectLocationCounties": null, "ProjectLocationPrimaryRoute": null, "ProjectLocationRoutes": null, "ProjectLocationMiles": null, "IsWorkflowAssociated": null, "WorkflowStatus": null, "ProjectLocation": null, "PrimaryCounty": null, "PrimaryCountyName": null, "CountyCode": null, "PrimaryRoute": null, "DoTContactName": null, "DoTContactPhone": null, "DoTContactEmail": null, "Location": null, "WorkDescription": null, "WorkGroupDescription": null, "ProgrammedAmount": null, "DevEstimate": null, "FHWABridgeNo": null, "RR_Involved": null, "RR_Agreement": null, "Metric": null, "PlanType": null, "UserName": null, "ParenNumber": null, "FileNumber": null, "BaseCostEstimate": null, "TotalAmount": null, "CostCenter": null, "ContractorID": null, "ContractDescription": null, "ContractorName": null, "District435": null, "District436": null, "Materials436": null, "Latitude": null, "Longitude": null, "CentralOffice": null, "Completed": null, "BRISWorkCode": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 4000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Update,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 4000, "maxRecordCountFactor": 1, "serviceItemId": "73221d0d63af4ed880a1adf765f76ffb" }