{ "layers": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 0, "name": "CityLimit", "type": "Feature Layer", "description": "This data set contains a polygon layer depicting the political boundary of the City of Greensboro, NC. The boundary is determined from various source data by digitizing features from site plans, cadastral layers, and legal descriptions of recent annexations. In some cases, planametrics and county tax maps are used as reference points for digitizing new city limit boundary changes.", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 5.120000004768374E-4, "zTolerance": 2, "mTolerance": 2, "falseX": -1.2184189999975929E8, "falseY": -9.365899999984714E7, "xyUnits": 3906.2499963620194, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "City of Greensboro Planning Department", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 0, 0, 0, 0 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 0, 0, 255 ], "width": 1 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 1699283.9391694665, "ymin": 810850.0688067973, "xmax": 1819461.1445293874, "ymax": 898126.2739440799, "spatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 5.120000004768374E-4, "zTolerance": 2, "mTolerance": 2, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3.6365718124241434E7, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "DATA", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "DATA", "type": "esriFieldTypeString", "alias": "DATA", "length": 30, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "SHAPE.STArea()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STArea()", "domain": null }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R2619_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_2619", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_2619", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S2021_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "SHAPE.STArea()", "shapeLengthFieldName": "SHAPE.STLength()", "units": "esriFeet" }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true } ], "tables": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 1, "name": "FIN_OperatingExpenseFiveRecentFYs", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "AccountUnit", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ID", "type": "esriFieldTypeInteger", "alias": "ID", "domain": null }, { "name": "AccountUnit", "type": "esriFieldTypeString", "alias": "AccountUnit", "length": 15, "domain": null }, { "name": "Account", "type": "esriFieldTypeInteger", "alias": "Account", "domain": null }, { "name": "FullAccountNumber", "type": "esriFieldTypeString", "alias": "FullAccountNumber", "length": 27, "domain": null }, { "name": "FiscalYear", "type": "esriFieldTypeInteger", "alias": "FiscalYear", "domain": null }, { "name": "Fund", "type": "esriFieldTypeString", "alias": "Fund", "length": 30, "domain": null }, { "name": "Department", "type": "esriFieldTypeString", "alias": "Department", "length": 30, "domain": null }, { "name": "Division", "type": "esriFieldTypeString", "alias": "Division", "length": 30, "domain": null }, { "name": "Section", "type": "esriFieldTypeString", "alias": "Section", "length": 30, "domain": null }, { "name": "LineItemDescription", "type": "esriFieldTypeString", "alias": "LineItemDescription", "length": 60, "domain": null }, { "name": "LineItemCategory", "type": "esriFieldTypeString", "alias": "LineItemCategory", "length": 8000, "domain": null }, { "name": "Budget", "type": "esriFieldTypeDouble", "alias": "Budget", "domain": null }, { "name": "ActualYTD", "type": "esriFieldTypeDouble", "alias": "ActualYTD", "domain": null }, { "name": "ESRI_OID", "type": "esriFieldTypeOID", "alias": "ESRI_OID", "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 2, "name": "FIN_OperatingRevenueFiveRecentFYs", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "AccountUnit", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ID", "type": "esriFieldTypeInteger", "alias": "ID", "domain": null }, { "name": "AccountUnit", "type": "esriFieldTypeString", "alias": "AccountUnit", "length": 15, "domain": null }, { "name": "Account", "type": "esriFieldTypeInteger", "alias": "Account", "domain": null }, { "name": "FullAccountNumber", "type": "esriFieldTypeString", "alias": "FullAccountNumber", "length": 27, "domain": null }, { "name": "FiscalYear", "type": "esriFieldTypeInteger", "alias": "FiscalYear", "domain": null }, { "name": "Fund", "type": "esriFieldTypeString", "alias": "Fund", "length": 30, "domain": null }, { "name": "Department", "type": "esriFieldTypeString", "alias": "Department", "length": 30, "domain": null }, { "name": "Division", "type": "esriFieldTypeString", "alias": "Division", "length": 30, "domain": null }, { "name": "Section", "type": "esriFieldTypeString", "alias": "Section", "length": 30, "domain": null }, { "name": "LineItemDescription", "type": "esriFieldTypeString", "alias": "LineItemDescription", "length": 60, "domain": null }, { "name": "LineItemCategory", "type": "esriFieldTypeString", "alias": "LineItemCategory", "length": 8000, "domain": null }, { "name": "Budget", "type": "esriFieldTypeDouble", "alias": "Budget", "domain": null }, { "name": "ActualYTD", "type": "esriFieldTypeDouble", "alias": "ActualYTD", "domain": null }, { "name": "ESRI_OID", "type": "esriFieldTypeOID", "alias": "ESRI_OID", "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 3, "name": "FIN_PurchaseOrderDetailSpend", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "PONumber", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "PONumber", "type": "esriFieldTypeString", "alias": "PONumber", "length": 14, "domain": null }, { "name": "POType", "type": "esriFieldTypeString", "alias": "POType", "length": 21, "domain": null }, { "name": "PODate", "type": "esriFieldTypeDate", "alias": "PODate", "length": 8, "domain": null }, { "name": "POLineNumber", "type": "esriFieldTypeInteger", "alias": "POLineNumber", "domain": null }, { "name": "Item", "type": "esriFieldTypeString", "alias": "Item", "length": 32, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 30, "domain": null }, { "name": "Quantity", "type": "esriFieldTypeDouble", "alias": "Quantity", "domain": null }, { "name": "ExtendedAmount", "type": "esriFieldTypeDouble", "alias": "ExtendedAmount", "domain": null }, { "name": "InvoiceDate", "type": "esriFieldTypeDate", "alias": "InvoiceDate", "length": 8, "domain": null }, { "name": "FiscalYear", "type": "esriFieldTypeString", "alias": "FiscalYear", "length": 21, "domain": null }, { "name": "DistributedAmount", "type": "esriFieldTypeDouble", "alias": "DistributedAmount", "domain": null }, { "name": "ID", "type": "esriFieldTypeInteger", "alias": "ID", "domain": null }, { "name": "ESRI_OID", "type": "esriFieldTypeOID", "alias": "ESRI_OID", "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 4, "name": "FIN_PurchaseOrderSpend", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "PONumber", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "PONumber", "type": "esriFieldTypeString", "alias": "PONumber", "length": 14, "domain": null }, { "name": "POType", "type": "esriFieldTypeString", "alias": "POType", "length": 21, "domain": null }, { "name": "PODate", "type": "esriFieldTypeDate", "alias": "PODate", "length": 8, "domain": null }, { "name": "POAmount", "type": "esriFieldTypeDouble", "alias": "POAmount", "domain": null }, { "name": "InvoicePostDate", "type": "esriFieldTypeDate", "alias": "InvoicePostDate", "length": 8, "domain": null }, { "name": "FiscalYear", "type": "esriFieldTypeString", "alias": "FiscalYear", "length": 21, "domain": null }, { "name": "InvoiceAmount", "type": "esriFieldTypeDouble", "alias": "InvoiceAmount", "domain": null }, { "name": "ID", "type": "esriFieldTypeOID", "alias": "ID", "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 5, "name": "FIN_UncashedChecks", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "PayeeName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "TransactionType", "type": "esriFieldTypeString", "alias": "TransactionType", "length": 255, "domain": null }, { "name": "CheckNumber", "type": "esriFieldTypeString", "alias": "CheckNumber", "length": 255, "domain": null }, { "name": "IssueDate", "type": "esriFieldTypeString", "alias": "IssueDate", "length": 255, "domain": null }, { "name": "Amount", "type": "esriFieldTypeDouble", "alias": "Amount", "domain": null }, { "name": "TransactionDescription", "type": "esriFieldTypeString", "alias": "TransactionDescription", "length": 255, "domain": null }, { "name": "VendorNumber", "type": "esriFieldTypeString", "alias": "VendorNumber", "length": 9, "domain": null }, { "name": "PayeeName", "type": "esriFieldTypeString", "alias": "PayeeName", "length": 30, "domain": null }, { "name": "Addr1", "type": "esriFieldTypeString", "alias": "Addr1", "length": 30, "domain": null }, { "name": "Addr2", "type": "esriFieldTypeString", "alias": "Addr2", "length": 30, "domain": null }, { "name": "Addr3", "type": "esriFieldTypeString", "alias": "Addr3", "length": 30, "domain": null }, { "name": "Addr4", "type": "esriFieldTypeString", "alias": "Addr4", "length": 30, "domain": null }, { "name": "City", "type": "esriFieldTypeString", "alias": "City", "length": 18, "domain": null }, { "name": "State", "type": "esriFieldTypeString", "alias": "State", "length": 2, "domain": null }, { "name": "ZipCode", "type": "esriFieldTypeString", "alias": "ZipCode", "length": 10, "domain": null }, { "name": "ID", "type": "esriFieldTypeOID", "alias": "ID", "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 6, "name": "IT_18MonthProjections", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Year_Month", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ID", "type": "esriFieldTypeOID", "alias": "ID", "domain": null }, { "name": "Calendar_Date", "type": "esriFieldTypeDate", "alias": "Calendar_Date", "length": 8, "domain": null }, { "name": "Year_Month", "type": "esriFieldTypeString", "alias": "Year_Month", "length": 35, "domain": null }, { "name": "Year", "type": "esriFieldTypeInteger", "alias": "Year", "domain": null }, { "name": "Month", "type": "esriFieldTypeString", "alias": "Month", "length": 30, "domain": null }, { "name": "Tier_I_Projected", "type": "esriFieldTypeInteger", "alias": "Tier_I_Projected", "domain": null }, { "name": "Tier_II_Projected", "type": "esriFieldTypeInteger", "alias": "Tier_II_Projected", "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 7, "name": "IT_TotalDeploys", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Year_Month", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ID", "type": "esriFieldTypeOID", "alias": "ID", "domain": null }, { "name": "Calendar_Date", "type": "esriFieldTypeDate", "alias": "Calendar_Date", "length": 8, "domain": null }, { "name": "Year_Month", "type": "esriFieldTypeString", "alias": "Year_Month", "length": 35, "domain": null }, { "name": "Year", "type": "esriFieldTypeInteger", "alias": "Year", "domain": null }, { "name": "Month", "type": "esriFieldTypeString", "alias": "Month", "length": 30, "domain": null }, { "name": "Total_Deploys", "type": "esriFieldTypeInteger", "alias": "Total_Deploys", "domain": null }, { "name": "Under_30_Calendar_Days", "type": "esriFieldTypeInteger", "alias": "Under_30_Calendar_Days", "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 8, "name": "IT_LockoutsAndPWResets", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Calendar_Date", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ID", "type": "esriFieldTypeOID", "alias": "ID", "domain": null }, { "name": "Calendar_Date", "type": "esriFieldTypeString", "alias": "Calendar_Date", "length": 35, "domain": null }, { "name": "Year_Month", "type": "esriFieldTypeString", "alias": "Year_Month", "length": 35, "domain": null }, { "name": "Year", "type": "esriFieldTypeInteger", "alias": "Year", "domain": null }, { "name": "Month", "type": "esriFieldTypeString", "alias": "Month", "length": 30, "domain": null }, { "name": "Lockouts", "type": "esriFieldTypeInteger", "alias": "Lockouts", "domain": null }, { "name": "PW_Resets", "type": "esriFieldTypeInteger", "alias": "PW_Resets", "domain": null }, { "name": "Total_Closed_Calls", "type": "esriFieldTypeInteger", "alias": "Total_Closed_Calls", "domain": null }, { "name": "Other_Calls", "type": "esriFieldTypeInteger", "alias": "Other_Calls", "domain": null }, { "name": "Lockouts_Percentage_Calls", "type": "esriFieldTypeDouble", "alias": "Lockouts_Percentage_Calls", "domain": null }, { "name": "PWRESET_Percentage_Calls", "type": "esriFieldTypeDouble", "alias": "PWRESET_Percentage_Calls", "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 9, "name": "FreshServiceTickets", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "AgentName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ID", "type": "esriFieldTypeOID", "alias": "ID", "domain": null }, { "name": "Service_ID", "type": "esriFieldTypeString", "alias": "Service_ID", "length": 20, "domain": null }, { "name": "Priority", "type": "esriFieldTypeString", "alias": "Priority", "length": 20, "domain": null }, { "name": "LastUpdatedDate", "type": "esriFieldTypeDate", "alias": "LastUpdatedDate", "length": 8, "domain": null }, { "name": "AgentName", "type": "esriFieldTypeString", "alias": "AgentName", "length": 100, "domain": null }, { "name": "Urgency", "type": "esriFieldTypeString", "alias": "Urgency", "length": 20, "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 20, "domain": null }, { "name": "FirstResponseDate", "type": "esriFieldTypeDate", "alias": "FirstResponseDate", "length": 8, "domain": null }, { "name": "Category", "type": "esriFieldTypeString", "alias": "Category", "length": 20, "domain": null }, { "name": "ItemCategory", "type": "esriFieldTypeString", "alias": "ItemCategory", "length": 50, "domain": null }, { "name": "AgentGroupName", "type": "esriFieldTypeString", "alias": "AgentGroupName", "length": 50, "domain": null }, { "name": "ChildTicketsCount", "type": "esriFieldTypeInteger", "alias": "ChildTicketsCount", "domain": null }, { "name": "Impact", "type": "esriFieldTypeString", "alias": "Impact", "length": 20, "domain": null }, { "name": "AssignedDate", "type": "esriFieldTypeDate", "alias": "AssignedDate", "length": 8, "domain": null }, { "name": "PublicNotesCount", "type": "esriFieldTypeInteger", "alias": "PublicNotesCount", "domain": null }, { "name": "AgentReplyCount", "type": "esriFieldTypeInteger", "alias": "AgentReplyCount", "domain": null }, { "name": "TotalQuantity", "type": "esriFieldTypeInteger", "alias": "TotalQuantity", "domain": null }, { "name": "Subject", "type": "esriFieldTypeString", "alias": "Subject", "length": 1000, "domain": null }, { "name": "FtContactResolutionViolated", "type": "esriFieldTypeString", "alias": "FtContactResolutionViolated", "length": 20, "domain": null }, { "name": "FtResponseEscalated", "type": "esriFieldTypeString", "alias": "FtResponseEscalated", "length": 20, "domain": null }, { "name": "CustomerReplyCount", "type": "esriFieldTypeInteger", "alias": "CustomerReplyCount", "domain": null }, { "name": "ResolutionTimeinBhrs", "type": "esriFieldTypeDouble", "alias": "ResolutionTimeinBhrs", "domain": null }, { "name": "AgentReassignCount", "type": "esriFieldTypeInteger", "alias": "AgentReassignCount", "domain": null }, { "name": "GroupReassignCount", "type": "esriFieldTypeInteger", "alias": "GroupReassignCount", "domain": null }, { "name": "TotalCost", "type": "esriFieldTypeDouble", "alias": "TotalCost", "domain": null }, { "name": "SubCategory", "type": "esriFieldTypeString", "alias": "SubCategory", "length": 50, "domain": null }, { "name": "PrivateNotesCount", "type": "esriFieldTypeInteger", "alias": "PrivateNotesCount", "domain": null }, { "name": "Dueby", "type": "esriFieldTypeDate", "alias": "Dueby", "length": 8, "domain": null }, { "name": "TaskCount", "type": "esriFieldTypeInteger", "alias": "TaskCount", "domain": null }, { "name": "Source", "type": "esriFieldTypeString", "alias": "Source", "length": 20, "domain": null }, { "name": "FtResponseTimeinChrs", "type": "esriFieldTypeDouble", "alias": "FtResponseTimeinChrs", "domain": null }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type", "length": 50, "domain": null }, { "name": "FirstResponseduein", "type": "esriFieldTypeDate", "alias": "FirstResponseduein", "length": 8, "domain": null }, { "name": "ResolutionEscalated", "type": "esriFieldTypeString", "alias": "ResolutionEscalated", "length": 20, "domain": null }, { "name": "ReopenCount", "type": "esriFieldTypeInteger", "alias": "ReopenCount", "domain": null }, { "name": "AvgResponseTimeinBhrs", "type": "esriFieldTypeDouble", "alias": "AvgResponseTimeinBhrs", "domain": null }, { "name": "MergedTicket", "type": "esriFieldTypeString", "alias": "MergedTicket", "length": 20, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "AvgResponseTime", "type": "esriFieldTypeDouble", "alias": "AvgResponseTime", "domain": null }, { "name": "FtResponseStatus", "type": "esriFieldTypeString", "alias": "FtResponseStatus", "length": 50, "domain": null }, { "name": "FtResponseTimeinBhrs", "type": "esriFieldTypeDouble", "alias": "FtResponseTimeinBhrs", "domain": null }, { "name": "AssociatedAssetsCount", "type": "esriFieldTypeInteger", "alias": "AssociatedAssetsCount", "domain": null }, { "name": "ApprovalStatus", "type": "esriFieldTypeString", "alias": "ApprovalStatus", "length": 50, "domain": null }, { "name": "ResolvedDate", "type": "esriFieldTypeDate", "alias": "ResolvedDate", "length": 8, "domain": null }, { "name": "ClosedDate", "type": "esriFieldTypeDate", "alias": "ClosedDate", "length": 8, "domain": null }, { "name": "AlternateContactNumber", "type": "esriFieldTypeString", "alias": "AlternateContactNumber", "length": 20, "domain": null }, { "name": "ResolutionStatus", "type": "esriFieldTypeString", "alias": "ResolutionStatus", "length": 50, "domain": null }, { "name": "Tags", "type": "esriFieldTypeString", "alias": "Tags", "length": 50, "domain": null }, { "name": "ElpTimeinCalendarHours", "type": "esriFieldTypeDouble", "alias": "ElpTimeinCalendarHours", "domain": null }, { "name": "ElpTimeSinceSLABreachinCalrs", "type": "esriFieldTypeDouble", "alias": "ElpTimeSinceSLABreachinCalrs", "domain": null }, { "name": "AgentGroupAssignmentTime", "type": "esriFieldTypeDouble", "alias": "AgentGroupAssignmentTime", "domain": null }, { "name": "AgentGroupCreatedDate", "type": "esriFieldTypeDate", "alias": "AgentGroupCreatedDate", "length": 8, "domain": null }, { "name": "AgentGroupTicketAssigType", "type": "esriFieldTypeString", "alias": "AgentGroupTicketAssigType", "length": 100, "domain": null }, { "name": "AgentEmails", "type": "esriFieldTypeString", "alias": "AgentEmails", "length": 100, "domain": null }, { "name": "RequesterName", "type": "esriFieldTypeString", "alias": "RequesterName", "length": 100, "domain": null }, { "name": "RequesterEmails", "type": "esriFieldTypeString", "alias": "RequesterEmails", "length": 100, "domain": null }, { "name": "DepartmentName", "type": "esriFieldTypeString", "alias": "DepartmentName", "length": 100, "domain": null }, { "name": "RequestedForName", "type": "esriFieldTypeString", "alias": "RequestedForName", "length": 100, "domain": null }, { "name": "RequestedForEmails", "type": "esriFieldTypeString", "alias": "RequestedForEmails", "length": 100, "domain": null }, { "name": "AssocSurveyRating", "type": "esriFieldTypeString", "alias": "AssocSurveyRating", "length": 20, "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 10, "name": "IT_StatisticsSecurity", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "note", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ID", "type": "esriFieldTypeOID", "alias": "ID", "domain": null }, { "name": "whenCreated", "type": "esriFieldTypeDate", "alias": "whenCreated", "length": 8, "domain": null }, { "name": "createdBy", "type": "esriFieldTypeInteger", "alias": "createdBy", "domain": null }, { "name": "effectiveDate", "type": "esriFieldTypeDate", "alias": "effectiveDate", "length": 8, "domain": null }, { "name": "accountsCreated", "type": "esriFieldTypeInteger", "alias": "accountsCreated", "domain": null }, { "name": "accountsDeleted", "type": "esriFieldTypeInteger", "alias": "accountsDeleted", "domain": null }, { "name": "internalPIRTs", "type": "esriFieldTypeInteger", "alias": "internalPIRTs", "domain": null }, { "name": "externalPIRTs", "type": "esriFieldTypeInteger", "alias": "externalPIRTs", "domain": null }, { "name": "criticalVulnerabilities", "type": "esriFieldTypeInteger", "alias": "criticalVulnerabilities", "domain": null }, { "name": "highVulnerabilities", "type": "esriFieldTypeInteger", "alias": "highVulnerabilities", "domain": null }, { "name": "externalAttacks", "type": "esriFieldTypeInteger", "alias": "externalAttacks", "domain": null }, { "name": "phishingAttacks", "type": "esriFieldTypeInteger", "alias": "phishingAttacks", "domain": null }, { "name": "helpdeskRequests", "type": "esriFieldTypeInteger", "alias": "helpdeskRequests", "domain": null }, { "name": "securityRequests", "type": "esriFieldTypeInteger", "alias": "securityRequests", "domain": null }, { "name": "phishingTests", "type": "esriFieldTypeDouble", "alias": "phishingTests", "domain": null }, { "name": "inactiveUsers", "type": "esriFieldTypeInteger", "alias": "inactiveUsers", "domain": null }, { "name": "inactiveComputers", "type": "esriFieldTypeInteger", "alias": "inactiveComputers", "domain": null }, { "name": "note", "type": "esriFieldTypeString", "alias": "note", "length": 32, "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 11, "name": "IT_SolarWinds_VPN_Connections", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Calendar_Date", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ID", "type": "esriFieldTypeOID", "alias": "ID", "domain": null }, { "name": "Calendar_Date", "type": "esriFieldTypeString", "alias": "Calendar_Date", "length": 36, "domain": null }, { "name": "Year_Month_Day", "type": "esriFieldTypeString", "alias": "Year_Month_Day", "length": 40, "domain": null }, { "name": "Year", "type": "esriFieldTypeInteger", "alias": "Year", "domain": null }, { "name": "Month", "type": "esriFieldTypeString", "alias": "Month", "length": 30, "domain": null }, { "name": "Day", "type": "esriFieldTypeInteger", "alias": "Day", "domain": null }, { "name": "MaxRate", "type": "esriFieldTypeSingle", "alias": "MaxRate", "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 12, "name": "IT_CallsClosedByAgent_AvgCloseHours", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "AgentName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ID", "type": "esriFieldTypeOID", "alias": "ID", "domain": null }, { "name": "Calendar_Date", "type": "esriFieldTypeDate", "alias": "Calendar_Date", "length": 8, "domain": null }, { "name": "Year", "type": "esriFieldTypeInteger", "alias": "Year", "domain": null }, { "name": "Month", "type": "esriFieldTypeString", "alias": "Month", "length": 30, "domain": null }, { "name": "Year_Month", "type": "esriFieldTypeString", "alias": "Year_Month", "length": 35, "domain": null }, { "name": "Average_ResolutionHours", "type": "esriFieldTypeDouble", "alias": "Average_ResolutionHours", "domain": null }, { "name": "Average_DaysOpen", "type": "esriFieldTypeInteger", "alias": "Average_DaysOpen", "domain": null }, { "name": "AgentName", "type": "esriFieldTypeString", "alias": "AgentName", "length": 100, "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 13, "name": "IT_Telecomm_WorkOrders", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Month", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ID", "type": "esriFieldTypeOID", "alias": "ID", "domain": null }, { "name": "Calendar_Date", "type": "esriFieldTypeDate", "alias": "Calendar_Date", "length": 8, "domain": null }, { "name": "Year", "type": "esriFieldTypeInteger", "alias": "Year", "domain": null }, { "name": "Month", "type": "esriFieldTypeString", "alias": "Month", "length": 30, "domain": null }, { "name": "Year_Month", "type": "esriFieldTypeString", "alias": "Year_Month", "length": 35, "domain": null }, { "name": "Counts", "type": "esriFieldTypeInteger", "alias": "Counts", "domain": null }, { "name": "Request", "type": "esriFieldTypeString", "alias": "Request", "length": 15, "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 14, "name": "IT_StatisticsFiveG", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Project", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ID", "type": "esriFieldTypeOID", "alias": "ID", "domain": null }, { "name": "Counts", "type": "esriFieldTypeInteger", "alias": "Counts", "domain": null }, { "name": "DateHold", "type": "esriFieldTypeDate", "alias": "DateHold", "length": 8, "domain": null }, { "name": "Project", "type": "esriFieldTypeString", "alias": "Project", "length": 20, "domain": null }, { "name": "Category", "type": "esriFieldTypeString", "alias": "Category", "length": 60, "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 15, "name": "IT_StatisticsFranchise", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Project", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ID", "type": "esriFieldTypeOID", "alias": "ID", "domain": null }, { "name": "StartDate", "type": "esriFieldTypeDate", "alias": "StartDate", "length": 8, "domain": null }, { "name": "EstimatedCompletionDate", "type": "esriFieldTypeDate", "alias": "EstimatedCompletionDate", "length": 8, "domain": null }, { "name": "Project", "type": "esriFieldTypeString", "alias": "Project", "length": 64, "domain": null }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 1024, "domain": null }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type", "length": 255, "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 64, "domain": null }, { "name": "Priority", "type": "esriFieldTypeString", "alias": "Priority", "length": 255, "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 16, "name": "IT_StatisticsTelecomm", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Project", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ID", "type": "esriFieldTypeOID", "alias": "ID", "domain": null }, { "name": "StartDate", "type": "esriFieldTypeDate", "alias": "StartDate", "length": 8, "domain": null }, { "name": "EstimatedCompletionDate", "type": "esriFieldTypeDate", "alias": "EstimatedCompletionDate", "length": 8, "domain": null }, { "name": "Project", "type": "esriFieldTypeString", "alias": "Project", "length": 64, "domain": null }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type", "length": 255, "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 64, "domain": null }, { "name": "Priority", "type": "esriFieldTypeString", "alias": "Priority", "length": 255, "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 17, "name": "IT_TotalDeploysbyTech", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "AgentName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ID", "type": "esriFieldTypeInteger", "alias": "ID", "domain": null }, { "name": "Calendar_Date", "type": "esriFieldTypeDate", "alias": "Calendar_Date", "length": 8, "domain": null }, { "name": "Year_Month", "type": "esriFieldTypeString", "alias": "Year_Month", "length": 35, "domain": null }, { "name": "Year", "type": "esriFieldTypeInteger", "alias": "Year", "domain": null }, { "name": "Month", "type": "esriFieldTypeString", "alias": "Month", "length": 30, "domain": null }, { "name": "Total_Deploys", "type": "esriFieldTypeInteger", "alias": "Total_Deploys", "domain": null }, { "name": "Under_30_Calendar_Days", "type": "esriFieldTypeInteger", "alias": "Under_30_Calendar_Days", "domain": null }, { "name": "AgentID", "type": "esriFieldTypeInteger", "alias": "AgentID", "domain": null }, { "name": "AgentName", "type": "esriFieldTypeString", "alias": "AgentName", "length": 200, "domain": null }, { "name": "ItemNumber", "type": "esriFieldTypeInteger", "alias": "ItemNumber", "domain": null }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 5000, "domain": null }, { "name": "ESRI_OID", "type": "esriFieldTypeOID", "alias": "ESRI_OID", "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 18, "name": "IT_LeaseRequests", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Month", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ID", "type": "esriFieldTypeOID", "alias": "ID", "domain": null }, { "name": "Calendar_Date", "type": "esriFieldTypeDate", "alias": "Calendar_Date", "length": 8, "domain": null }, { "name": "Year", "type": "esriFieldTypeInteger", "alias": "Year", "domain": null }, { "name": "Month", "type": "esriFieldTypeString", "alias": "Month", "length": 30, "domain": null }, { "name": "Year_Month", "type": "esriFieldTypeString", "alias": "Year_Month", "length": 35, "domain": null }, { "name": "OrdersSubmitted", "type": "esriFieldTypeInteger", "alias": "OrdersSubmitted", "domain": null }, { "name": "OrdersApproved", "type": "esriFieldTypeInteger", "alias": "OrdersApproved", "domain": null }, { "name": "ItemsRequested", "type": "esriFieldTypeInteger", "alias": "ItemsRequested", "domain": null }, { "name": "ItemsApproved", "type": "esriFieldTypeInteger", "alias": "ItemsApproved", "domain": null }, { "name": "AvgItemsRequestedPerOrder", "type": "esriFieldTypeDouble", "alias": "AvgItemsRequestedPerOrder", "domain": null }, { "name": "Est_Minimum_Minutes", "type": "esriFieldTypeInteger", "alias": "Est_Minimum_Minutes", "domain": null }, { "name": "Est_Average_Minutes", "type": "esriFieldTypeInteger", "alias": "Est_Average_Minutes", "domain": null }, { "name": "Est_Maximum_Minutes", "type": "esriFieldTypeInteger", "alias": "Est_Maximum_Minutes", "domain": null }, { "name": "Est_Minimum_Hours", "type": "esriFieldTypeInteger", "alias": "Est_Minimum_Hours", "domain": null }, { "name": "Est_Average_Hours", "type": "esriFieldTypeInteger", "alias": "Est_Average_Hours", "domain": null }, { "name": "Est_Maximum_Hours", "type": "esriFieldTypeInteger", "alias": "Est_Maximum_Hours", "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 19, "name": "IT_EquipmentReceived", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Month", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ID", "type": "esriFieldTypeOID", "alias": "ID", "domain": null }, { "name": "Calendar_Date", "type": "esriFieldTypeDate", "alias": "Calendar_Date", "length": 8, "domain": null }, { "name": "Year", "type": "esriFieldTypeInteger", "alias": "Year", "domain": null }, { "name": "Month", "type": "esriFieldTypeString", "alias": "Month", "length": 30, "domain": null }, { "name": "Year_Month", "type": "esriFieldTypeString", "alias": "Year_Month", "length": 35, "domain": null }, { "name": "EquipmentType", "type": "esriFieldTypeString", "alias": "EquipmentType", "length": 2000, "domain": null }, { "name": "EquipmentModel", "type": "esriFieldTypeString", "alias": "EquipmentModel", "length": 2000, "domain": null }, { "name": "Qty", "type": "esriFieldTypeInteger", "alias": "Qty", "domain": null }, { "name": "Est_Minimum_Minutes", "type": "esriFieldTypeInteger", "alias": "Est_Minimum_Minutes", "domain": null }, { "name": "Est_Average_Minutes", "type": "esriFieldTypeInteger", "alias": "Est_Average_Minutes", "domain": null }, { "name": "Est_Maximum_Minutes", "type": "esriFieldTypeInteger", "alias": "Est_Maximum_Minutes", "domain": null }, { "name": "Est_Minimum_Hours", "type": "esriFieldTypeInteger", "alias": "Est_Minimum_Hours", "domain": null }, { "name": "Est_Average_Hours", "type": "esriFieldTypeInteger", "alias": "Est_Average_Hours", "domain": null }, { "name": "Est_Maximum_Hours", "type": "esriFieldTypeInteger", "alias": "Est_Maximum_Hours", "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 20, "name": "IT_EquipmentPickups", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Month", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ID", "type": "esriFieldTypeOID", "alias": "ID", "domain": null }, { "name": "Calendar_Date", "type": "esriFieldTypeDate", "alias": "Calendar_Date", "length": 8, "domain": null }, { "name": "Year", "type": "esriFieldTypeInteger", "alias": "Year", "domain": null }, { "name": "Month", "type": "esriFieldTypeString", "alias": "Month", "length": 30, "domain": null }, { "name": "Year_Month", "type": "esriFieldTypeString", "alias": "Year_Month", "length": 35, "domain": null }, { "name": "Qty", "type": "esriFieldTypeInteger", "alias": "Qty", "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 21, "name": "IT_TicketsClosedWithin5Days", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Month", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ID", "type": "esriFieldTypeOID", "alias": "ID", "domain": null }, { "name": "Calendar_Date", "type": "esriFieldTypeDate", "alias": "Calendar_Date", "length": 8, "domain": null }, { "name": "Year", "type": "esriFieldTypeInteger", "alias": "Year", "domain": null }, { "name": "Month", "type": "esriFieldTypeString", "alias": "Month", "length": 30, "domain": null }, { "name": "Year_Month", "type": "esriFieldTypeString", "alias": "Year_Month", "length": 35, "domain": null }, { "name": "Average_ResolutionHours", "type": "esriFieldTypeDouble", "alias": "Average_ResolutionHours", "domain": null }, { "name": "TicketsUnder5", "type": "esriFieldTypeInteger", "alias": "TicketsUnder5", "domain": null }, { "name": "Closed_Tickets", "type": "esriFieldTypeInteger", "alias": "Closed_Tickets", "domain": null }, { "name": "Percent_Within_5_Days", "type": "esriFieldTypeDouble", "alias": "Percent_Within_5_Days", "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 22, "name": "IT_CurrentNetworkItems", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Year_Month", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ID", "type": "esriFieldTypeOID", "alias": "ID", "domain": null }, { "name": "Install_Date", "type": "esriFieldTypeDate", "alias": "Install_Date", "length": 8, "domain": null }, { "name": "Year_Month", "type": "esriFieldTypeString", "alias": "Year_Month", "length": 35, "domain": null }, { "name": "TotalItems", "type": "esriFieldTypeInteger", "alias": "TotalItems", "domain": null }, { "name": "Quantity", "type": "esriFieldTypeInteger", "alias": "Quantity", "domain": null }, { "name": "AverageDays", "type": "esriFieldTypeInteger", "alias": "AverageDays", "domain": null }, { "name": "TotalDays", "type": "esriFieldTypeInteger", "alias": "TotalDays", "domain": null }, { "name": "PercentUnder90Days", "type": "esriFieldTypeDouble", "alias": "PercentUnder90Days", "domain": null }, { "name": "PercentUnder60Days", "type": "esriFieldTypeDouble", "alias": "PercentUnder60Days", "domain": null }, { "name": "PercentUnder30Days", "type": "esriFieldTypeDouble", "alias": "PercentUnder30Days", "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 23, "name": "BUD_ProjectInvestments", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Contract", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ID", "type": "esriFieldTypeOID", "alias": "ID", "domain": null }, { "name": "Project_ID", "type": "esriFieldTypeInteger", "alias": "Project_ID", "domain": null }, { "name": "Contract", "type": "esriFieldTypeString", "alias": "Contract", "length": 9, "domain": null }, { "name": "CouncilDistrict", "type": "esriFieldTypeString", "alias": "CouncilDistrict", "length": 28, "domain": null }, { "name": "ProjectCount", "type": "esriFieldTypeInteger", "alias": "ProjectCount", "domain": null }, { "name": "ProjectCategory", "type": "esriFieldTypeString", "alias": "ProjectCategory", "length": 14, "domain": null }, { "name": "ProjectTitle", "type": "esriFieldTypeString", "alias": "ProjectTitle", "length": 255, "domain": null }, { "name": "ContractType", "type": "esriFieldTypeString", "alias": "ContractType", "length": 30, "domain": null }, { "name": "ProjectType", "type": "esriFieldTypeString", "alias": "ProjectType", "length": 50, "domain": null }, { "name": "AwardDate", "type": "esriFieldTypeDate", "alias": "AwardDate", "length": 8, "domain": null }, { "name": "ProjectStatus", "type": "esriFieldTypeString", "alias": "ProjectStatus", "length": 255, "domain": null }, { "name": "Department", "type": "esriFieldTypeString", "alias": "Department", "length": 30, "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 24, "name": "BUD_ProjectInvestmentsContractSpend", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Project_ID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ID", "type": "esriFieldTypeOID", "alias": "ID", "domain": null }, { "name": "Project_ID", "type": "esriFieldTypeString", "alias": "Project_ID", "length": 50, "domain": null }, { "name": "Contract", "type": "esriFieldTypeString", "alias": "Contract", "length": 9, "domain": null }, { "name": "CouncilDistrict", "type": "esriFieldTypeString", "alias": "CouncilDistrict", "length": 28, "domain": null }, { "name": "Percentage", "type": "esriFieldTypeDouble", "alias": "Percentage", "domain": null }, { "name": "ProjectTitle", "type": "esriFieldTypeString", "alias": "ProjectTitle", "length": 255, "domain": null }, { "name": "AmountSpentToDate_Contract", "type": "esriFieldTypeDouble", "alias": "AmountSpentToDate_Contract", "domain": null }, { "name": "AmountSpentToDate_District", "type": "esriFieldTypeDouble", "alias": "AmountSpentToDate_District", "domain": null }, { "name": "TotalContractValue_Contract", "type": "esriFieldTypeDouble", "alias": "TotalContractValue_Contract", "domain": null }, { "name": "TotalContractValue_District", "type": "esriFieldTypeDouble", "alias": "TotalContractValue_District", "domain": null }, { "name": "AmountRemaining_Contract", "type": "esriFieldTypeDouble", "alias": "AmountRemaining_Contract", "domain": null }, { "name": "AmountRemaining_District", "type": "esriFieldTypeDouble", "alias": "AmountRemaining_District", "domain": null }, { "name": "ContractType", "type": "esriFieldTypeString", "alias": "ContractType", "length": 30, "domain": null }, { "name": "AwardDate", "type": "esriFieldTypeDate", "alias": "AwardDate", "length": 8, "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 25, "name": "IT_ReturnedNetworkItemsLifecycle", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Receiver_Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ID", "type": "esriFieldTypeOID", "alias": "ID", "domain": null }, { "name": "TotalItems", "type": "esriFieldTypeInteger", "alias": "TotalItems", "domain": null }, { "name": "Equipment_Type", "type": "esriFieldTypeString", "alias": "Equipment_Type", "length": 60, "domain": null }, { "name": "Qty", "type": "esriFieldTypeInteger", "alias": "Qty", "domain": null }, { "name": "LessThan90", "type": "esriFieldTypeInteger", "alias": "LessThan90", "domain": null }, { "name": "LessThan60", "type": "esriFieldTypeInteger", "alias": "LessThan60", "domain": null }, { "name": "LessThan30", "type": "esriFieldTypeInteger", "alias": "LessThan30", "domain": null }, { "name": "Receiver_Name", "type": "esriFieldTypeString", "alias": "Receiver_Name", "length": 30, "domain": null }, { "name": "Current_Item", "type": "esriFieldTypeInteger", "alias": "Current_Item", "domain": null }, { "name": "New_Item", "type": "esriFieldTypeInteger", "alias": "New_Item", "domain": null }, { "name": "ShippingTimeDaystoCOG", "type": "esriFieldTypeInteger", "alias": "ShippingTimeDaystoCOG", "domain": null }, { "name": "TurnaroundTimeDaystoNWS", "type": "esriFieldTypeInteger", "alias": "TurnaroundTimeDaystoNWS", "domain": null }, { "name": "LifeCycleYears", "type": "esriFieldTypeInteger", "alias": "LifeCycleYears", "domain": null }, { "name": "OrderedDate", "type": "esriFieldTypeDate", "alias": "OrderedDate", "length": 8, "domain": null }, { "name": "ReceivedDate", "type": "esriFieldTypeDate", "alias": "ReceivedDate", "length": 8, "domain": null }, { "name": "CompletedDate", "type": "esriFieldTypeDate", "alias": "CompletedDate", "length": 8, "domain": null }, { "name": "ScannedInDate", "type": "esriFieldTypeDate", "alias": "ScannedInDate", "length": 8, "domain": null }, { "name": "Current_Lease_Expiration_Date", "type": "esriFieldTypeDate", "alias": "Current_Lease_Expiration_Date", "length": 8, "domain": null }, { "name": "Year_Month", "type": "esriFieldTypeString", "alias": "Year_Month", "length": 35, "domain": null }, { "name": "Install_Date", "type": "esriFieldTypeString", "alias": "Install_Date", "length": 35, "domain": null }, { "name": "DaysBetweenExpirationAndReplacement", "type": "esriFieldTypeInteger", "alias": "DaysBetweenExpirationAndReplacement", "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } } ] }