{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 18, "name": "UAGIS.ADMIN.ProjectStatus", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "Projects", "relatedTableId": 17, "cardinality": "esriRelCardinalityOneToOne", "role": "esriRelRoleDestination", "keyField": "ProjectNumber", "composite": false } ], "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, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "ProjectName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "ProjectNumber", "type": "esriFieldTypeString", "alias": "Project Number", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "ProjectNumber" }, { "name": "ProjectName", "type": "esriFieldTypeString", "alias": "Project Name", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "ProjectName" }, { "name": "LastChecked", "type": "esriFieldTypeDate", "alias": "Last Checked?", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LastChecked" }, { "name": "GISUser", "type": "esriFieldTypeString", "alias": "GIS User", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "GISUser" }, { "name": "SitePlanDocumentsStatus", "type": "esriFieldTypeString", "alias": "Site Plan Document Status", "domain": { "type": "codedValue", "name": "ProjectDocumentStatus", "description": "Status of document submission for PDC projects", "codedValues": [ { "name": "N/A", "code": "N/A" }, { "name": "No Plans Submitted", "code": "No Plans Submitted" }, { "name": "Non-Compliant Document Submitted", "code": "Non-Compliant Document Submitted" }, { "name": "Partially Compliant Document Submitted", "code": "Partially Compliant Document Submitted" }, { "name": "Fully Compliant Document Submitted", "code": "Fully Compliant Document Submitted" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "SitePlanDocumentsStatus" }, { "name": "ConstructionDocumentsStatus", "type": "esriFieldTypeString", "alias": "ConstructionDocumentsStatus", "domain": { "type": "codedValue", "name": "ProjectDocumentStatus", "description": "Status of document submission for PDC projects", "codedValues": [ { "name": "N/A", "code": "N/A" }, { "name": "No Plans Submitted", "code": "No Plans Submitted" }, { "name": "Non-Compliant Document Submitted", "code": "Non-Compliant Document Submitted" }, { "name": "Partially Compliant Document Submitted", "code": "Partially Compliant Document Submitted" }, { "name": "Fully Compliant Document Submitted", "code": "Fully Compliant Document Submitted" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "ConstructionDocumentsStatus" }, { "name": "CloseoutDocumentsStatus", "type": "esriFieldTypeString", "alias": "Closeout Documents Status", "domain": { "type": "codedValue", "name": "ProjectDocumentStatus", "description": "Status of document submission for PDC projects", "codedValues": [ { "name": "N/A", "code": "N/A" }, { "name": "No Plans Submitted", "code": "No Plans Submitted" }, { "name": "Non-Compliant Document Submitted", "code": "Non-Compliant Document Submitted" }, { "name": "Partially Compliant Document Submitted", "code": "Partially Compliant Document Submitted" }, { "name": "Fully Compliant Document Submitted", "code": "Fully Compliant Document Submitted" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "CloseoutDocumentsStatus" }, { "name": "DocumentDeliverableNotes", "type": "esriFieldTypeString", "alias": "Document Deliverable Notes", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "DocumentDeliverableNotes" }, { "name": "BuildingLayersStatus", "type": "esriFieldTypeString", "alias": "Building Layers Status", "domain": { "type": "codedValue", "name": "ProjectFeatureStatus", "description": "Status of GIS features associated with a project", "codedValues": [ { "name": "Not Started", "code": "Not Started" }, { "name": "In Progress", "code": "In Progress" }, { "name": "Completed", "code": "Completed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "BuildingLayersStatus" }, { "name": "BuildingLayersComments", "type": "esriFieldTypeString", "alias": "Building Layers Comments", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "BuildingLayersComments" }, { "name": "BasemapLayersStatus", "type": "esriFieldTypeString", "alias": "Basemap Layers Status", "domain": { "type": "codedValue", "name": "ProjectFeatureStatus", "description": "Status of GIS features associated with a project", "codedValues": [ { "name": "Not Started", "code": "Not Started" }, { "name": "In Progress", "code": "In Progress" }, { "name": "Completed", "code": "Completed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "BasemapLayersStatus" }, { "name": "BasemapLayersComments", "type": "esriFieldTypeString", "alias": "Basemap Layers Comments", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "BasemapLayersComments" }, { "name": "OtherFeaturesStatus", "type": "esriFieldTypeString", "alias": "Othe rFeatures Status", "domain": { "type": "codedValue", "name": "ProjectFeatureStatus", "description": "Status of GIS features associated with a project", "codedValues": [ { "name": "Not Started", "code": "Not Started" }, { "name": "In Progress", "code": "In Progress" }, { "name": "Completed", "code": "Completed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "OtherFeaturesStatus" }, { "name": "OtherFeaturesComments", "type": "esriFieldTypeString", "alias": "Other Features Comments", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "OtherFeaturesComments" }, { "name": "ProjectStatus", "type": "esriFieldTypeString", "alias": "ProjectStatus", "domain": { "type": "codedValue", "name": "ProjectStatus", "description": "Status values for PDC projects", "codedValues": [ { "name": "Conceptual Design", "code": "Conceptual Design" }, { "name": "Schematic Design", "code": "Schematic Design" }, { "name": "Construction", "code": "Design Development" }, { "name": "Complete/Closeout", "code": "Complete/Closeout" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ProjectStatus" } ], "indexes": [ { "name": "R13269_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "UAGIS.ADMIN.ProjectStatus", "description": "", "prototype": { "attributes": { "OtherFeaturesComments": null, "ProjectStatus": null, "ProjectNumber": null, "ProjectName": null, "LastChecked": null, "GISUser": null, "SitePlanDocumentsStatus": null, "ConstructionDocumentsStatus": null, "CloseoutDocumentsStatus": null, "DocumentDeliverableNotes": null, "BuildingLayersStatus": null, "BuildingLayersComments": null, "BasemapLayersStatus": null, "BasemapLayersComments": null, "OtherFeaturesStatus": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Extract", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }