{ "layers": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 0, "name": "Application", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryMultipoint", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": 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, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": false, "extent": { "xmin": -62632.930499999784, "ymin": -4035786.7904000003, "xmax": 5623305.7447999995, "ymax": 45.55000000074506, "spatialReference": { "wkid": 4148, "latestWkid": 4148, "xyTolerance": 2.0E-4, "zTolerance": 2, "mTolerance": 2, "falseX": -349371.80842000013, "falseY": -4237578.40742, "xyUnits": 1.439518713372191E9, "falseZ": 0, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 4148, "latestWkid": 4148, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5623200, "falseY": -10002100, "xyUnits": 10000, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 155, 176, 0, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } } }, "scaleSymbols": false, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "CreatedUser", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "AppID", "type": "esriFieldTypeInteger", "alias": "AppID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AppID" }, { "name": "CreatedUser", "type": "esriFieldTypeString", "alias": "CreatedUser", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CreatedUser" }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "DateCreated", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateCreated" }, { "name": "ReferenceNumber", "type": "esriFieldTypeString", "alias": "ReferenceNumber", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ReferenceNumber" }, { "name": "FileNumber", "type": "esriFieldTypeString", "alias": "FileNumber", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "FileNumber" }, { "name": "Decision", "type": "esriFieldTypeString", "alias": "Decision", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Decision" }, { "name": "TownplannerID", "type": "esriFieldTypeInteger", "alias": "TownplannerID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TownplannerID" }, { "name": "ApplicantID", "type": "esriFieldTypeInteger", "alias": "ApplicantID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ApplicantID" }, { "name": "SystemModuleID", "type": "esriFieldTypeInteger", "alias": "SystemModuleID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SystemModuleID" }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "domain": null, "editable": true, "nullable": true, "length": 3000, "defaultValue": null, "modelName": "Description" }, { "name": "Step", "type": "esriFieldTypeInteger", "alias": "Step", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Step" }, { "name": "ApplicantAgentID", "type": "esriFieldTypeInteger", "alias": "ApplicantAgentID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ApplicantAgentID" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SHAPE" }, "indexes": [ { "name": "R296_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I1891ApplicantID", "fields": "ApplicantID,SystemModuleID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I1891Townplanner", "fields": "TownplannerID,SystemModuleID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I1891AppID2", "fields": "AppID,SystemModuleID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S67_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Application", "description": "", "prototype": { "attributes": {} }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 1000, "tileMaxRecordCount": 1000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "ae2d807b2a544b85bbc269044a63d425" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 1, "name": "ApplicationProperty", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolygon", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": 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": true, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape__Area", "shapeLengthFieldName": "Shape__Length", "units": "esriDecimalDegrees" }, "hasMetadata": false, "extent": { "xmin": -64958.59159999993, "ymin": -3802399.6706, "xmax": 889970.9797999999, "ymax": -22.68530000001192, "spatialReference": { "wkid": 4148, "latestWkid": 4148, "xyTolerance": 2.0E-4, "zTolerance": 2, "mTolerance": 2, "falseX": -349371.80842000013, "falseY": -4237578.40742, "xyUnits": 1.439518713372191E9, "falseZ": 0, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 4148, "latestWkid": 4148, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5623200, "falseY": -10002100, "xyUnits": 10000, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 221, 247, 208, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.4 } } }, "scaleSymbols": false, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "ErfNumber", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "ErfNumber", "type": "esriFieldTypeString", "alias": "ErfNumber", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ErfNumber" }, { "name": "Allotment", "type": "esriFieldTypeString", "alias": "Allotment", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Allotment" }, { "name": "FarmNumber", "type": "esriFieldTypeString", "alias": "FarmNumber", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "FarmNumber" }, { "name": "SgCode", "type": "esriFieldTypeString", "alias": "SgCode", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SgCode" }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "Address" }, { "name": "ErfSize", "type": "esriFieldTypeInteger", "alias": "ErfSize", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ErfSize" }, { "name": "TitleDeed", "type": "esriFieldTypeString", "alias": "TitleDeed", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "TitleDeed" }, { "name": "Subdivision", "type": "esriFieldTypeString", "alias": "Subdivision", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Subdivision" }, { "name": "TotalValue", "type": "esriFieldTypeDouble", "alias": "TotalValue", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TotalValue" }, { "name": "OwnerID", "type": "esriFieldTypeInteger", "alias": "OwnerID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OwnerID" }, { "name": "AppID", "type": "esriFieldTypeInteger", "alias": "AppID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AppID" }, { "name": "ApplicationPropertyID", "type": "esriFieldTypeInteger", "alias": "ApplicationPropertyID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ApplicationPropertyID" }, { "name": "BuildingFloorArea", "type": "esriFieldTypeInteger", "alias": "BuildingFloorArea", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BuildingFloorArea" }, { "name": "SystemModuleID", "type": "esriFieldTypeInteger", "alias": "SystemModuleID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SystemModuleID" }, { "name": "IsDummy", "type": "esriFieldTypeString", "alias": "IsDummy", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "IsDummy" }, { "name": "UpdateGeometry", "type": "esriFieldTypeString", "alias": "UpdateGeometry", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "UpdateGeometry" }, { "name": "Shape__Area", "type": "esriFieldTypeDouble", "alias": "SHAPE.STArea()", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "SHAPE.STArea()" }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "SHAPE.STLength()" }, { "name": "LocalMunicipality", "type": "esriFieldTypeString", "alias": "LocalMunicipality", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "LocalMunicipality" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SHAPE" }, "indexes": [ { "name": "R293_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I1888Application", "fields": "ApplicationPropertyID,SystemModuleID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I1888OwnerID3", "fields": "OwnerID,SystemModuleID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I1888AppID2", "fields": "AppID,SystemModuleID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S66_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "ApplicationProperty", "description": "", "prototype": { "attributes": {} }, "drawingTool": "esriFeatureEditToolPolygon" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 4000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "ae2d807b2a544b85bbc269044a63d425" } ], "tables": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 2, "name": "ApplicationZoning", "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, "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": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Zoning", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "AppID", "type": "esriFieldTypeInteger", "alias": "AppID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AppID" }, { "name": "ApplicationPropertyID", "type": "esriFieldTypeInteger", "alias": "ApplicationPropertyID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ApplicationPropertyID" }, { "name": "Zoning", "type": "esriFieldTypeString", "alias": "Zoning", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Zoning" }, { "name": "SystemModuleID", "type": "esriFieldTypeInteger", "alias": "SystemModuleID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SystemModuleID" } ], "indexes": [ { "name": "R292_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I1887AppID1", "fields": "AppID,SystemModuleID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "ApplicationZoning", "description": "", "prototype": { "attributes": { "Zoning": null, "SystemModuleID": null, "AppID": null, "ApplicationPropertyID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "ae2d807b2a544b85bbc269044a63d425" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 3, "name": "ApplicationType", "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, "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": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "ApplicationType", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "AppID", "type": "esriFieldTypeInteger", "alias": "AppID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AppID" }, { "name": "ApplicationType", "type": "esriFieldTypeString", "alias": "ApplicationType", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "ApplicationType" }, { "name": "SystemModuleID", "type": "esriFieldTypeInteger", "alias": "SystemModuleID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SystemModuleID" } ], "indexes": [ { "name": "R295_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I1890AppID1", "fields": "AppID,SystemModuleID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "ApplicationType", "description": "", "prototype": { "attributes": { "ApplicationType": null, "SystemModuleID": null, "AppID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "ae2d807b2a544b85bbc269044a63d425" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 4, "name": "SystemStepMeta", "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, "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": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "StepName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "StepName", "type": "esriFieldTypeString", "alias": "StepName", "domain": null, "editable": true, "nullable": false, "length": 1073741822, "defaultValue": null, "modelName": "StepName" }, { "name": "Metadata", "type": "esriFieldTypeString", "alias": "Metadata", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "Metadata" }, { "name": "SystemModuleID", "type": "esriFieldTypeInteger", "alias": "SystemModuleID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SystemModuleID" } ], "indexes": [ { "name": "R119_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "SystemStepMeta", "description": "", "prototype": { "attributes": { "Metadata": null, "SystemModuleID": null, "StepName": " " } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "ae2d807b2a544b85bbc269044a63d425" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 5, "name": "SystemUserRoles", "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, "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": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Username", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Username", "type": "esriFieldTypeString", "alias": "Username", "domain": null, "editable": true, "nullable": true, "length": 300, "defaultValue": null, "modelName": "Username" }, { "name": "Roles", "type": "esriFieldTypeString", "alias": "Roles", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "Roles" } ], "indexes": [ { "name": "R154_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "SystemUserRoles", "description": "", "prototype": { "attributes": { "Username": null, "Roles": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "ae2d807b2a544b85bbc269044a63d425" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 6, "name": "ApplicationJobLink", "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, "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": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "JobID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "JobID", "type": "esriFieldTypeInteger", "alias": "JobID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "JobID" }, { "name": "AppID", "type": "esriFieldTypeInteger", "alias": "AppID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AppID" }, { "name": "SystemModuleID", "type": "esriFieldTypeInteger", "alias": "SystemModuleID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SystemModuleID" } ], "indexes": [ { "name": "R212_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "idx_AFLA_Applica", "fields": "AppID,SystemModuleID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "ApplicationJobLink", "description": "", "prototype": { "attributes": { "AppID": null, "SystemModuleID": null, "JobID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "ae2d807b2a544b85bbc269044a63d425" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 7, "name": "ApplicationNotes", "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, "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": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Username", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Date", "type": "esriFieldTypeDate", "alias": "DateTime", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateTime" }, { "name": "Username", "type": "esriFieldTypeString", "alias": "Username", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Username" }, { "name": "Note", "type": "esriFieldTypeString", "alias": "Note", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "Note" }, { "name": "AppID", "type": "esriFieldTypeInteger", "alias": "AppID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AppID" }, { "name": "SystemModuleID", "type": "esriFieldTypeInteger", "alias": "SystemModuleID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SystemModuleID" } ], "indexes": [ { "name": "R211_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "idx_AFLA_Applica", "fields": "AppID,SystemModuleID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "ApplicationNotes", "description": "", "prototype": { "attributes": { "AppID": null, "SystemModuleID": null, "Date": null, "Username": null, "Note": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "ae2d807b2a544b85bbc269044a63d425" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 8, "name": "ApplicationStatus", "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, "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": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "TimeoutName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "TimeoutReminderSent", "type": "esriFieldTypeString", "alias": "ReminderSent", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "TimeoutReminderSent" }, { "name": "TimeoutExpired", "type": "esriFieldTypeString", "alias": "Expired", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "TimeoutExpired" }, { "name": "AppID", "type": "esriFieldTypeInteger", "alias": "AppID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AppID" }, { "name": "PercentageComplete", "type": "esriFieldTypeSmallInteger", "alias": "PercentageComplete", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PercentageComplete" }, { "name": "AssignedTo", "type": "esriFieldTypeString", "alias": "AssignedTo", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "AssignedTo" }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "CreatedBy" }, { "name": "WorkflowSection", "type": "esriFieldTypeString", "alias": "WorkflowSection", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "WorkflowSection" }, { "name": "TimeoutID", "type": "esriFieldTypeInteger", "alias": "TimeoutID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TimeoutID" }, { "name": "TimeoutName", "type": "esriFieldTypeString", "alias": "TimeoutName", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "TimeoutName" }, { "name": "DaysUntillReminder", "type": "esriFieldTypeSmallInteger", "alias": "DaysUntillReminder", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DaysUntillReminder" }, { "name": "DaysUntilExpired", "type": "esriFieldTypeSmallInteger", "alias": "DaysUntilExpired", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DaysUntilExpired" }, { "name": "TimeoutStatus", "type": "esriFieldTypeString", "alias": "TimeoutStatus", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "TimeoutStatus" }, { "name": "SystemModuleID", "type": "esriFieldTypeInteger", "alias": "SystemModuleID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SystemModuleID" } ], "indexes": [ { "name": "_dta_index_AFLA_APPLICATIONSTATUS_c_5_138483572__K2_K14", "fields": "AppID,SystemModuleID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R210_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "idx_AFLA_Applica_1", "fields": "TimeoutID,SystemModuleID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "ApplicationStatus", "description": "", "prototype": { "attributes": { "TimeoutStatus": null, "SystemModuleID": null, "TimeoutReminderSent": null, "TimeoutExpired": null, "AppID": null, "PercentageComplete": null, "AssignedTo": null, "CreatedBy": null, "WorkflowSection": null, "TimeoutID": null, "TimeoutName": null, "DaysUntillReminder": null, "DaysUntilExpired": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "ae2d807b2a544b85bbc269044a63d425" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 9, "name": "Attachment", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "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, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": 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": false, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "AttachmentType", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Date", "type": "esriFieldTypeDate", "alias": "DateAdded", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Date" }, { "name": "AppID", "type": "esriFieldTypeInteger", "alias": "AppID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AppID" }, { "name": "AttachmentType", "type": "esriFieldTypeString", "alias": "AttachmentType", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "AttachmentType" }, { "name": "ComponentType", "type": "esriFieldTypeString", "alias": "ComponentType", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ComponentType" }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "domain": null, "editable": true, "nullable": true, "length": 300, "defaultValue": null, "modelName": "Description" }, { "name": "AttachmentID", "type": "esriFieldTypeInteger", "alias": "AttachmentID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AttachmentID" }, { "name": "RecipientID", "type": "esriFieldTypeInteger", "alias": "RecipientID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RecipientID" }, { "name": "UploadedBy", "type": "esriFieldTypeString", "alias": "UploadedBy", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "UploadedBy" }, { "name": "SystemModuleID", "type": "esriFieldTypeInteger", "alias": "SystemModuleID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SystemModuleID" }, { "name": "SharePointURL", "type": "esriFieldTypeString", "alias": "SharePointURL", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "SharePointURL" } ], "indexes": [ { "name": "R213_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "idx_AFLA_Attachm", "fields": "AppID,SystemModuleID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "idx_AFLA_Attachm_1", "fields": "AttachmentID,SystemModuleID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "idx_AFLA_Attachm_2", "fields": "RecipientID,SystemModuleID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Attachment", "description": "", "prototype": { "attributes": { "SystemModuleID": null, "SharePointURL": null, "Date": null, "AppID": null, "AttachmentType": null, "ComponentType": null, "Description": null, "AttachmentID": null, "RecipientID": null, "UploadedBy": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": false }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "ae2d807b2a544b85bbc269044a63d425" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 10, "name": "AuditAction", "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, "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": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "UserName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "AppID", "type": "esriFieldTypeInteger", "alias": "AppID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AppID" }, { "name": "AuditActionID", "type": "esriFieldTypeInteger", "alias": "AuditActionID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AuditActionID" }, { "name": "Date", "type": "esriFieldTypeDate", "alias": "Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Date" }, { "name": "UserName", "type": "esriFieldTypeString", "alias": "UserName", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "UserName" }, { "name": "Action", "type": "esriFieldTypeString", "alias": "Action", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "Action" }, { "name": "Component", "type": "esriFieldTypeString", "alias": "Component", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Component" }, { "name": "ComponentIdentifier", "type": "esriFieldTypeString", "alias": "ComponentIdentifier", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "ComponentIdentifier" }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "Description" }, { "name": "SystemModuleID", "type": "esriFieldTypeInteger", "alias": "SystemModuleID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SystemModuleID" } ], "indexes": [ { "name": "R208_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "idx_AFLA_AuditAc", "fields": "AppID,SystemModuleID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "idx_AFLA_AuditAc_1", "fields": "AuditActionID,SystemModuleID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "AuditAction", "description": "", "prototype": { "attributes": { "Description": null, "SystemModuleID": null, "AppID": null, "AuditActionID": null, "Date": null, "UserName": null, "Action": null, "Component": null, "ComponentIdentifier": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "ae2d807b2a544b85bbc269044a63d425" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 11, "name": "Checklist", "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, "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": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "ChecklistName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "AppID", "type": "esriFieldTypeInteger", "alias": "AppID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AppID" }, { "name": "ChecklistName", "type": "esriFieldTypeString", "alias": "ChecklistName", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ChecklistName" }, { "name": "TaskName", "type": "esriFieldTypeString", "alias": "TaskName", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "TaskName" }, { "name": "Complete", "type": "esriFieldTypeString", "alias": "Complete", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Complete" }, { "name": "LastChangedUser", "type": "esriFieldTypeString", "alias": "LastChangedUser", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LastChangedUser" }, { "name": "SystemModuleID", "type": "esriFieldTypeInteger", "alias": "SystemModuleID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SystemModuleID" } ], "indexes": [ { "name": "R209_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "idx_AFLA_Checkli", "fields": "AppID,SystemModuleID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Checklist", "description": "", "prototype": { "attributes": { "LastChangedUser": null, "SystemModuleID": null, "AppID": null, "ChecklistName": null, "TaskName": null, "Complete": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "ae2d807b2a544b85bbc269044a63d425" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 12, "name": "Communication", "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, "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": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "CommunicationType", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "CommunicationID", "type": "esriFieldTypeInteger", "alias": "CommunicationID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CommunicationID" }, { "name": "AppID", "type": "esriFieldTypeInteger", "alias": "AppID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AppID" }, { "name": "CommunicationType", "type": "esriFieldTypeString", "alias": "CommunicationType", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "CommunicationTypeID" }, { "name": "CommunicationMechanism", "type": "esriFieldTypeString", "alias": "CommunicationMechanism", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "CommunicationMechanismID" }, { "name": "Date", "type": "esriFieldTypeDate", "alias": "Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Date" }, { "name": "Direction", "type": "esriFieldTypeString", "alias": "Direction", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Direction" }, { "name": "RelatedCommunicationID", "type": "esriFieldTypeInteger", "alias": "RelatedCommunicationID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RelatedCommunicationID" }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "domain": null, "editable": true, "nullable": true, "length": 4000, "defaultValue": null, "modelName": "Description" }, { "name": "SystemModuleID", "type": "esriFieldTypeInteger", "alias": "SystemModuleID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SystemModuleID" } ], "indexes": [ { "name": "R204_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "idx_AFLA_Communi", "fields": "AppID,SystemModuleID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "idx_AFLA_Communi_1", "fields": "CommunicationID,SystemModuleID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "idx_AFLA_Communi_2", "fields": "RelatedCommunicationID,SystemModuleID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Communication", "description": "", "prototype": { "attributes": { "Description": null, "SystemModuleID": null, "CommunicationID": null, "AppID": null, "CommunicationType": null, "CommunicationMechanism": null, "Date": null, "Direction": null, "RelatedCommunicationID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "ae2d807b2a544b85bbc269044a63d425" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 13, "name": "CommunicationAttachmentLink", "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, "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": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "CommunicationID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "CommunicationID", "type": "esriFieldTypeInteger", "alias": "CommunicationID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CommunicationID" }, { "name": "AttachmentID", "type": "esriFieldTypeInteger", "alias": "AttachmentID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AttachmentID" }, { "name": "SystemModuleID", "type": "esriFieldTypeInteger", "alias": "SystemModuleID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SystemModuleID" } ], "indexes": [ { "name": "R205_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "idx_AFLA_Communi", "fields": "CommunicationID,SystemModuleID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "idx_AFLA_Communi_1", "fields": "AttachmentID,SystemModuleID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "CommunicationAttachmentLink", "description": "", "prototype": { "attributes": { "AttachmentID": null, "SystemModuleID": null, "CommunicationID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "ae2d807b2a544b85bbc269044a63d425" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 14, "name": "CommunicationRecipientLink", "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, "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": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "CommunicationID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "CommunicationID", "type": "esriFieldTypeInteger", "alias": "CommunicationID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CommunicationID" }, { "name": "RecipientID", "type": "esriFieldTypeInteger", "alias": "RecipientID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RecipientID" }, { "name": "SystemModuleID", "type": "esriFieldTypeInteger", "alias": "SystemModuleID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SystemModuleID" } ], "indexes": [ { "name": "R199_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "idx_AFLA_Communi", "fields": "CommunicationID,SystemModuleID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "idx_AFLA_Communi_1", "fields": "RecipientID,SystemModuleID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "CommunicationRecipientLink", "description": "", "prototype": { "attributes": { "RecipientID": null, "SystemModuleID": null, "CommunicationID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "ae2d807b2a544b85bbc269044a63d425" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 15, "name": "Invoice", "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, "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": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "VerifiedUsername", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "TotalExclVat", "type": "esriFieldTypeDouble", "alias": "TotalExclVat", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TotalExclVat" }, { "name": "TotalInclVAT", "type": "esriFieldTypeDouble", "alias": "TotalInclVAT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TotalInclVAT" }, { "name": "InvoiceID", "type": "esriFieldTypeInteger", "alias": "InvoiceID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "InvoiceID" }, { "name": "InvoiceDate", "type": "esriFieldTypeDate", "alias": "InvoiceDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InvoiceDate" }, { "name": "AppID", "type": "esriFieldTypeInteger", "alias": "AppID", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "AppID" }, { "name": "PaymentReceived", "type": "esriFieldTypeString", "alias": "PaymentReceived", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PaymentReceived" }, { "name": "Verified", "type": "esriFieldTypeString", "alias": "Verified", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Verified" }, { "name": "VerifiedUsername", "type": "esriFieldTypeString", "alias": "VerifiedUsername", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "VerifiedUsername" }, { "name": "ContactPersonID", "type": "esriFieldTypeInteger", "alias": "ContactPersonID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ContactPersonID" }, { "name": "CreatedUsername", "type": "esriFieldTypeString", "alias": "CreatedUsername", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "CreatedUsername" }, { "name": "PaymentDue", "type": "esriFieldTypeDate", "alias": "PaymentDue", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PaymentDue" }, { "name": "SystemModuleID", "type": "esriFieldTypeInteger", "alias": "SystemModuleID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SystemModuleID" }, { "name": "PersonResponsibleID", "type": "esriFieldTypeInteger", "alias": "PersonResponsibleID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PersonResponsibleID" } ], "indexes": [ { "name": "R200_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "idx_AFLA_Invoice", "fields": "AppID,SystemModuleID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "idx_AFLA_Invoice_1", "fields": "InvoiceID,SystemModuleID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "idx_AFLA_Invoice_2", "fields": "ContactPersonID,SystemModuleID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "idx_AFLA_Invoice_3", "fields": "SystemModuleID,PersonResponsibleID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Invoice", "description": "", "prototype": { "attributes": { "SystemModuleID": null, "PersonResponsibleID": null, "TotalExclVat": null, "TotalInclVAT": null, "InvoiceID": null, "InvoiceDate": null, "AppID": 0, "PaymentReceived": null, "Verified": null, "VerifiedUsername": null, "ContactPersonID": null, "CreatedUsername": null, "PaymentDue": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "ae2d807b2a544b85bbc269044a63d425" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 16, "name": "InvoiceItems", "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, "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": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Rebate", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Rate", "type": "esriFieldTypeDouble", "alias": "Rate", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Rate" }, { "name": "VATExempt", "type": "esriFieldTypeString", "alias": "VAT", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "VAT" }, { "name": "Amount", "type": "esriFieldTypeDouble", "alias": "Amount", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Amount" }, { "name": "InvoiceID", "type": "esriFieldTypeInteger", "alias": "InvoiceID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "InvoiceID" }, { "name": "Rebate", "type": "esriFieldTypeString", "alias": "Rebate", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Rebate" }, { "name": "VoteNo", "type": "esriFieldTypeString", "alias": "VoteNo", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "VoteNo" }, { "name": "Tariff", "type": "esriFieldTypeString", "alias": "Tariff", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "Tariff" }, { "name": "Quantity", "type": "esriFieldTypeInteger", "alias": "Quantity", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Quantity" }, { "name": "UnitOfMeasurement", "type": "esriFieldTypeString", "alias": "UnitOfMeasurement", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "UnitOfMeasurement" }, { "name": "AppID", "type": "esriFieldTypeInteger", "alias": "AppID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AppID" }, { "name": "Calculation", "type": "esriFieldTypeString", "alias": "Calculation", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "Calculation" }, { "name": "RebateTariffID", "type": "esriFieldTypeInteger", "alias": "RebateTariffID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RebateTariffID" }, { "name": "Minimum", "type": "esriFieldTypeString", "alias": "Minimum", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Minimum" }, { "name": "Maximum", "type": "esriFieldTypeString", "alias": "Maximum", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Maximum" }, { "name": "TariffID", "type": "esriFieldTypeInteger", "alias": "TariffID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TariffID" }, { "name": "ManualCalculation", "type": "esriFieldTypeString", "alias": "ManualCalculation", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ManualCalculation" }, { "name": "SystemModuleID", "type": "esriFieldTypeInteger", "alias": "SystemModuleID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SystemModuleID" } ], "indexes": [ { "name": "R201_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "idx_AFLA_Invoice", "fields": "AppID,SystemModuleID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "idx_AFLA_Invoice_1", "fields": "InvoiceID,SystemModuleID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "InvoiceItems", "description": "", "prototype": { "attributes": { "ManualCalculation": null, "SystemModuleID": null, "Rate": null, "VATExempt": null, "Amount": null, "InvoiceID": null, "Rebate": null, "VoteNo": null, "Tariff": null, "Quantity": null, "UnitOfMeasurement": null, "AppID": null, "Calculation": null, "RebateTariffID": null, "Minimum": null, "Maximum": null, "TariffID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "ae2d807b2a544b85bbc269044a63d425" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 17, "name": "Lookup", "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, "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": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Name" }, { "name": "Content", "type": "esriFieldTypeString", "alias": "Content", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "Content" }, { "name": "SystemModuleID", "type": "esriFieldTypeInteger", "alias": "SystemModuleID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SystemModuleID" } ], "indexes": [ { "name": "R202_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Lookup", "description": "", "prototype": { "attributes": { "Content": null, "SystemModuleID": null, "Name": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "ae2d807b2a544b85bbc269044a63d425" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 18, "name": "RecipientGroup", "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, "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": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Groupname", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Groupname", "type": "esriFieldTypeString", "alias": "Groupname", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Groupname" }, { "name": "RecipientID", "type": "esriFieldTypeInteger", "alias": "RecipientID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RecipientID" }, { "name": "GroupType", "type": "esriFieldTypeString", "alias": "GroupType", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "GroupType" }, { "name": "SystemModuleID", "type": "esriFieldTypeInteger", "alias": "SystemModuleID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SystemModuleID" } ], "indexes": [ { "name": "R196_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "idx_AFLA_Recipie", "fields": "RecipientID,SystemModuleID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "RecipientGroup", "description": "", "prototype": { "attributes": { "GroupType": null, "SystemModuleID": null, "Groupname": null, "RecipientID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "ae2d807b2a544b85bbc269044a63d425" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 19, "name": "Template", "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, "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": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "StepName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "TemplateID", "type": "esriFieldTypeInteger", "alias": "TemplateID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TemplateID" }, { "name": "StepName", "type": "esriFieldTypeString", "alias": "StepName", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "StepName" }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Type" }, { "name": "Template", "type": "esriFieldTypeString", "alias": "Template", "domain": null, "editable": true, "nullable": true, "length": 4000, "defaultValue": null, "modelName": "Template" }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Description" }, { "name": "AttachmentID", "type": "esriFieldTypeInteger", "alias": "AttachmentID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AttachmentID" }, { "name": "SystemModuleID", "type": "esriFieldTypeInteger", "alias": "SystemModuleID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SystemModuleID" }, { "name": "EmailSubject", "type": "esriFieldTypeString", "alias": "EmailSubject", "domain": null, "editable": true, "nullable": true, "length": 300, "defaultValue": null, "modelName": "EmailSubject" } ], "indexes": [ { "name": "R197_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I1395TemplateID", "fields": "TemplateID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Template", "description": "", "prototype": { "attributes": { "SystemModuleID": null, "EmailSubject": null, "TemplateID": null, "StepName": null, "Type": null, "Template": null, "Description": null, "AttachmentID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "ae2d807b2a544b85bbc269044a63d425" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 20, "name": "Timeout", "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, "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": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "TimeoutName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "AppID", "type": "esriFieldTypeInteger", "alias": "AppID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AppID" }, { "name": "TimeoutID", "type": "esriFieldTypeInteger", "alias": "TimeoutID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TimeoutID" }, { "name": "StartDate", "type": "esriFieldTypeDate", "alias": "StartDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "StartDate" }, { "name": "ReminderDate", "type": "esriFieldTypeDate", "alias": "ReminderDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ReminderDate" }, { "name": "ReminderAction", "type": "esriFieldTypeString", "alias": "ReminderAction", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "ReminderAction" }, { "name": "EndDate", "type": "esriFieldTypeDate", "alias": "EndDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EndDate" }, { "name": "TimeoutAction", "type": "esriFieldTypeString", "alias": "TimeoutAction", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "TimeoutAction" }, { "name": "ReminderActioned", "type": "esriFieldTypeString", "alias": "ReminderActioned", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "ReminderActioned" }, { "name": "TimeoutActioned", "type": "esriFieldTypeString", "alias": "TimeoutActioned", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "TimeoutActioned" }, { "name": "TimeoutName", "type": "esriFieldTypeString", "alias": "TimeoutName", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "TimeoutName" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Status" }, { "name": "SystemModuleID", "type": "esriFieldTypeInteger", "alias": "SystemModuleID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SystemModuleID" } ], "indexes": [ { "name": "R198_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "idx_AFLA_Timeout", "fields": "AppID,SystemModuleID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "idx_AFLA_Timeout_1", "fields": "TimeoutID,SystemModuleID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Timeout", "description": "", "prototype": { "attributes": { "Status": null, "SystemModuleID": null, "AppID": null, "TimeoutID": null, "StartDate": null, "ReminderDate": null, "ReminderAction": null, "EndDate": null, "TimeoutAction": null, "ReminderActioned": null, "TimeoutActioned": null, "TimeoutName": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "ae2d807b2a544b85bbc269044a63d425" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 21, "name": "ApplicationPropertyRecipientLinkTable", "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, "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": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "SystemModuleID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "SystemModuleID", "type": "esriFieldTypeInteger", "alias": "SystemModuleID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SystemModuleID" }, { "name": "AppID", "type": "esriFieldTypeInteger", "alias": "AppID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AppID" }, { "name": "PropertyID", "type": "esriFieldTypeInteger", "alias": "PropertyID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PropertyID" }, { "name": "RecipientID", "type": "esriFieldTypeInteger", "alias": "RecipientID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RecipientID" } ], "indexes": [ { "name": "R294_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "ApplicationPropertyRecipientLinkTable", "description": "", "prototype": { "attributes": { "PropertyID": null, "RecipientID": null, "SystemModuleID": null, "AppID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "ae2d807b2a544b85bbc269044a63d425" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 22, "name": "TimeoutTimer", "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, "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": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Action", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "AppID", "type": "esriFieldTypeInteger", "alias": "AppID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AppID" }, { "name": "SystemModuleID", "type": "esriFieldTypeInteger", "alias": "SystemModuleID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SystemModuleID" }, { "name": "TimeoutID", "type": "esriFieldTypeInteger", "alias": "TimeoutID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TimeoutID" }, { "name": "Action", "type": "esriFieldTypeString", "alias": "Action", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Action" }, { "name": "Actioned", "type": "esriFieldTypeString", "alias": "Actioned", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "Actioned" }, { "name": "StartDate", "type": "esriFieldTypeDate", "alias": "StartDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "StartDate" }, { "name": "EndDate", "type": "esriFieldTypeDate", "alias": "EndDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EndDate" }, { "name": "TimerType", "type": "esriFieldTypeString", "alias": "TimerType", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "TimerType" } ], "indexes": [ { "name": "R237_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "idx_AFLA_Timeout", "fields": "AppID,SystemModuleID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "idx_AFLA_Timeout_1", "fields": "TimeoutID,SystemModuleID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "TimeoutTimer", "description": "", "prototype": { "attributes": { "EndDate": null, "TimerType": null, "AppID": null, "SystemModuleID": null, "TimeoutID": null, "Action": null, "Actioned": null, "StartDate": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "ae2d807b2a544b85bbc269044a63d425" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 23, "name": "Report", "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, "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": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Groupname", "type": "esriFieldTypeString", "alias": "GroupName", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "Groupname" }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "Name" }, { "name": "Metadata", "type": "esriFieldTypeString", "alias": "Metadata", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "Metadata" }, { "name": "URL", "type": "esriFieldTypeString", "alias": "URL", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "URL" }, { "name": "SystemModuleID", "type": "esriFieldTypeInteger", "alias": "SystemModuleID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SystemModuleID" } ], "indexes": [ { "name": "R236_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Report", "description": "", "prototype": { "attributes": { "URL": null, "SystemModuleID": null, "Groupname": null, "Name": null, "Metadata": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "ae2d807b2a544b85bbc269044a63d425" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 24, "name": "Result", "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, "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": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "ResultType", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "AppID", "type": "esriFieldTypeInteger", "alias": "AppID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AppID" }, { "name": "ResultID", "type": "esriFieldTypeInteger", "alias": "ResultID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ResultID" }, { "name": "RecipientID", "type": "esriFieldTypeInteger", "alias": "RecipientID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RecipientID" }, { "name": "ResultDate", "type": "esriFieldTypeDate", "alias": "ResultDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ResultDate" }, { "name": "ResultType", "type": "esriFieldTypeString", "alias": "ResultType", "domain": null, "editable": true, "nullable": true, "length": 300, "defaultValue": null, "modelName": "ResultType" }, { "name": "ResultStatus", "type": "esriFieldTypeString", "alias": "ResultStatus", "domain": null, "editable": true, "nullable": true, "length": 300, "defaultValue": null, "modelName": "ResultStatus" }, { "name": "Result", "type": "esriFieldTypeString", "alias": "Result", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "Result" }, { "name": "LoggedBy", "type": "esriFieldTypeString", "alias": "LoggedBy", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "LoggedBy" }, { "name": "SystemModuleID", "type": "esriFieldTypeInteger", "alias": "SystemModuleID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SystemModuleID" }, { "name": "CapturedDate", "type": "esriFieldTypeDate", "alias": "CapturedDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CapturedDate" } ], "indexes": [ { "name": "R238_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "idx_AFLA_Result_", "fields": "AppID,SystemModuleID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "idx_AFLA_Result__1", "fields": "ResultID,SystemModuleID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "idx_AFLA_Result__2", "fields": "RecipientID,SystemModuleID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Result", "description": "", "prototype": { "attributes": { "SystemModuleID": null, "CapturedDate": null, "AppID": null, "ResultID": null, "RecipientID": null, "ResultDate": null, "ResultType": null, "ResultStatus": null, "Result": null, "LoggedBy": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "ae2d807b2a544b85bbc269044a63d425" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 25, "name": "ResultAttachmentLink", "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, "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": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "ResultID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "ResultID", "type": "esriFieldTypeInteger", "alias": "CommunicationID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CommunicationID" }, { "name": "AttachmentID", "type": "esriFieldTypeInteger", "alias": "AttachmentID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AttachmentID" }, { "name": "SystemModuleID", "type": "esriFieldTypeInteger", "alias": "SystemModuleID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SystemModuleID" } ], "indexes": [ { "name": "R239_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "idx_AFLA_ResultA", "fields": "ResultID,SystemModuleID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "idx_AFLA_ResultA_1", "fields": "AttachmentID,SystemModuleID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "ResultAttachmentLink", "description": "", "prototype": { "attributes": { "AttachmentID": null, "SystemModuleID": null, "ResultID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "ae2d807b2a544b85bbc269044a63d425" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 26, "name": "NonWorkDays", "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, "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": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Description", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "domain": null, "editable": true, "nullable": true, "length": 300, "defaultValue": null, "modelName": "Description" }, { "name": "FromDate", "type": "esriFieldTypeDate", "alias": "FromDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "FromDate" }, { "name": "ToDate", "type": "esriFieldTypeDate", "alias": "ToDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ToDate" }, { "name": "SystemModuleID", "type": "esriFieldTypeInteger", "alias": "SystemModuleID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SystemModuleID" } ], "indexes": [ { "name": "R283_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "NonWorkDays", "description": "", "prototype": { "attributes": { "ToDate": null, "SystemModuleID": null, "Description": null, "FromDate": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "ae2d807b2a544b85bbc269044a63d425" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 27, "name": "SystemModules", "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, "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": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "SystemModuleID", "type": "esriFieldTypeInteger", "alias": "SystemModuleID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SystemModuleID" }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Name" }, { "name": "MapServiceName", "type": "esriFieldTypeString", "alias": "MapServiceName", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MapServiceName" }, { "name": "Metadata", "type": "esriFieldTypeString", "alias": "Metadata", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "Metadata" }, { "name": "Configuration", "type": "esriFieldTypeString", "alias": "Configuration", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Configuration" }, { "name": "SystemPrefix", "type": "esriFieldTypeString", "alias": "SystemPrefix", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SystemPrefix" } ], "indexes": [ { "name": "R314_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "SystemModules", "description": "", "prototype": { "attributes": { "Configuration": null, "SystemPrefix": null, "SystemModuleID": null, "Name": null, "MapServiceName": null, "Metadata": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "ae2d807b2a544b85bbc269044a63d425" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 28, "name": "SystemModuleSetting", "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, "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": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "ObjectID", "globalIdField": "", "displayField": "Value", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "ObjectID", "type": "esriFieldTypeOID", "alias": "ObjectID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "ObjectID" }, { "name": "SystemModuleID", "type": "esriFieldTypeInteger", "alias": "SystemModuleID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SystemModuleID" }, { "name": "Value", "type": "esriFieldTypeString", "alias": "Value", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "Value" }, { "name": "ItemKey", "type": "esriFieldTypeString", "alias": "ItemKey", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ItemKey" } ], "indexes": [ { "name": "R266_SDE_ROWID_UK", "fields": "ObjectID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "SystemModuleSetting", "description": "", "prototype": { "attributes": { "Value": null, "ItemKey": null, "SystemModuleID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "ae2d807b2a544b85bbc269044a63d425" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 29, "name": "MunicipalAdministrator", "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, "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": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Username", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "MunicipalAdministratorID", "type": "esriFieldTypeInteger", "alias": "MunicipalAdministratorID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MunicipalAdministratorID" }, { "name": "Email", "type": "esriFieldTypeString", "alias": "Email", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Email" }, { "name": "MunicipalID", "type": "esriFieldTypeInteger", "alias": "MunicipalID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MunicipalID" }, { "name": "IsActive", "type": "esriFieldTypeString", "alias": "IsActive", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "IsActive" }, { "name": "Username", "type": "esriFieldTypeString", "alias": "Username", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Username" }, { "name": "SystemModuleID", "type": "esriFieldTypeInteger", "alias": "SystemModuleID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SystemModuleID" } ], "indexes": [ { "name": "R319_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "MunicipalAdministrator", "description": "", "prototype": { "attributes": { "Username": null, "SystemModuleID": null, "MunicipalAdministratorID": null, "Email": null, "MunicipalID": null, "IsActive": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "ae2d807b2a544b85bbc269044a63d425" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 30, "name": "MunicipalUser", "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, "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": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "MunicipalUserID", "type": "esriFieldTypeInteger", "alias": "MunicipalUserID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MunicipalUserID" }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Name" }, { "name": "Surname", "type": "esriFieldTypeString", "alias": "Surname", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Surname" }, { "name": "Email", "type": "esriFieldTypeString", "alias": "Email", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Email" }, { "name": "IsActive", "type": "esriFieldTypeString", "alias": "IsActive", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "IsActive" }, { "name": "SystemModuleID", "type": "esriFieldTypeInteger", "alias": "SystemModuleID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SystemModuleID" }, { "name": "Username", "type": "esriFieldTypeString", "alias": "Username", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Username" } ], "indexes": [ { "name": "R322_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "MunicipalUser", "description": "", "prototype": { "attributes": { "SystemModuleID": null, "Username": null, "MunicipalUserID": null, "Name": null, "Surname": null, "Email": null, "IsActive": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "ae2d807b2a544b85bbc269044a63d425" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 31, "name": "MunicipalDocuments", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "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, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": 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": false, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Name" }, { "name": "Category", "type": "esriFieldTypeString", "alias": "Category", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Category" }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "Description" }, { "name": "SystemModuleID", "type": "esriFieldTypeInteger", "alias": "SystemModuleID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SystemModuleID" }, { "name": "MunicipalID", "type": "esriFieldTypeInteger", "alias": "MunicipalID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MunicipalID" } ], "indexes": [ { "name": "R323_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "MunicipalDocuments", "description": "", "prototype": { "attributes": { "SystemModuleID": null, "MunicipalID": null, "Name": null, "Category": null, "Description": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": false }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "ae2d807b2a544b85bbc269044a63d425" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 32, "name": "SystemLookupNames", "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, "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": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": false, "length": 255, "defaultValue": null, "modelName": "Name" }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Type" }, { "name": "SystemModuleID", "type": "esriFieldTypeInteger", "alias": "SystemModuleID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SystemModuleID" } ], "indexes": [ { "name": "R287_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "SystemLookupNames", "description": "", "prototype": { "attributes": { "Type": null, "SystemModuleID": null, "Name": " " } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "ae2d807b2a544b85bbc269044a63d425" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 33, "name": "Recipient", "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, "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": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "PostalAddress", "type": "esriFieldTypeString", "alias": "Postal_Address", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Address" }, { "name": "StreetAddress", "type": "esriFieldTypeString", "alias": "Street_Address", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "StreetAddress" }, { "name": "StreetSuburb", "type": "esriFieldTypeString", "alias": "Street_Suburb", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "streetsuburb" }, { "name": "StreetCity", "type": "esriFieldTypeString", "alias": "Street_City", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "streetcity" }, { "name": "StreetProvince", "type": "esriFieldTypeString", "alias": "Street_Province", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "streetprovince" }, { "name": "StreetCode", "type": "esriFieldTypeString", "alias": "Street_Code", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "streetcode" }, { "name": "PostalSuburb", "type": "esriFieldTypeString", "alias": "Postal_Suburb", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "postalsuburb" }, { "name": "PostalCity", "type": "esriFieldTypeString", "alias": "Postal_City", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PostalCity" }, { "name": "PostalProvince", "type": "esriFieldTypeString", "alias": "Postal_Province", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PostalProvince" }, { "name": "PostalCode", "type": "esriFieldTypeString", "alias": "Postal_Code", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PostalCode" }, { "name": "RecipientID", "type": "esriFieldTypeInteger", "alias": "RecipientID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RecipientID" }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Name" }, { "name": "Surname", "type": "esriFieldTypeString", "alias": "Surname", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Surname" }, { "name": "Workphone", "type": "esriFieldTypeString", "alias": "Workphone", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Telephone" }, { "name": "Email", "type": "esriFieldTypeString", "alias": "Email", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Email" }, { "name": "AppID", "type": "esriFieldTypeInteger", "alias": "AppID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AppID" }, { "name": "Designation", "type": "esriFieldTypeString", "alias": "Designation", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Designation" }, { "name": "Organisation", "type": "esriFieldTypeString", "alias": "Organisation", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Organisation" }, { "name": "Active", "type": "esriFieldTypeString", "alias": "Active", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": "Yes", "modelName": "Active" }, { "name": "SystemModuleID", "type": "esriFieldTypeInteger", "alias": "SystemModuleID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SystemModuleID" }, { "name": "Homephone", "type": "esriFieldTypeString", "alias": "Homephone", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Homephone" }, { "name": "IDNumber", "type": "esriFieldTypeString", "alias": "IDNumber", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "IDNumber" }, { "name": "OrganisationRegistrationNumber", "type": "esriFieldTypeString", "alias": "OrganisationRegistrationNumber", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OrganisationRegistrationNumber" }, { "name": "Representative", "type": "esriFieldTypeString", "alias": "Representative", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "Representative" }, { "name": "Fax", "type": "esriFieldTypeString", "alias": "Fax", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Fax" }, { "name": "Cellphone", "type": "esriFieldTypeString", "alias": "Cellphone", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Cellphone" }, { "name": "ProfessionalRegistrationBody", "type": "esriFieldTypeString", "alias": "ProfessionalRegistrationBody", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "ProfessionalRegistrationBody" }, { "name": "ProfessionalRegistrationNumber", "type": "esriFieldTypeString", "alias": "ProfessionalRegistrationNumber", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "ProfessionalRegistrationNumber" } ], "indexes": [ { "name": "R203_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "idx_AFLA_Recipie", "fields": "AppID,SystemModuleID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "idx_AFLA_Recipie_1", "fields": "RecipientID,SystemModuleID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Recipient", "description": "", "prototype": { "attributes": { "ProfessionalRegistrationBody": null, "ProfessionalRegistrationNumber": null, "PostalAddress": null, "StreetAddress": null, "StreetSuburb": null, "StreetCity": null, "StreetProvince": null, "StreetCode": null, "PostalSuburb": null, "PostalCity": null, "PostalProvince": null, "PostalCode": null, "RecipientID": null, "Name": null, "Surname": null, "Workphone": null, "Email": null, "AppID": null, "Designation": null, "Organisation": null, "Active": "Yes", "SystemModuleID": null, "Homephone": null, "IDNumber": null, "OrganisationRegistrationNumber": null, "Representative": null, "Fax": null, "Cellphone": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "ae2d807b2a544b85bbc269044a63d425" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 34, "name": "MunicipalContactPerson", "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, "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": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "MunicipalContactPersonID", "type": "esriFieldTypeInteger", "alias": "MunicipalContactPersonID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MunicipalContactPersonID" }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Name" }, { "name": "Surname", "type": "esriFieldTypeString", "alias": "Surname", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Surname" }, { "name": "Email", "type": "esriFieldTypeString", "alias": "Email", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Email" }, { "name": "IsActive", "type": "esriFieldTypeString", "alias": "IsActive", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "IsActive" }, { "name": "SystemModuleID", "type": "esriFieldTypeInteger", "alias": "SystemModuleID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SystemModuleID" }, { "name": "Username", "type": "esriFieldTypeString", "alias": "Username", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Username" } ], "indexes": [ { "name": "R328_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "MunicipalContactPerson", "description": "", "prototype": { "attributes": { "SystemModuleID": null, "Username": null, "MunicipalContactPersonID": null, "Name": null, "Surname": null, "Email": null, "IsActive": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "ae2d807b2a544b85bbc269044a63d425" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 35, "name": "Municipal", "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, "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": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "StreetProvince", "type": "esriFieldTypeString", "alias": "Street_Province", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "StreetProvince" }, { "name": "StreetAddress", "type": "esriFieldTypeString", "alias": "Street_Address", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "StreetAddress" }, { "name": "StreetSuburb", "type": "esriFieldTypeString", "alias": "Street_Suburb", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "StreetSuburb" }, { "name": "StreetCity", "type": "esriFieldTypeString", "alias": "Street_City", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "StreetCity" }, { "name": "PostalProvince", "type": "esriFieldTypeString", "alias": "Postal_Province", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PostalProvince" }, { "name": "PostalAddress", "type": "esriFieldTypeString", "alias": "Postal_Address", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PostalAddress" }, { "name": "PostalSuburb", "type": "esriFieldTypeString", "alias": "Postal_Suburb", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PostalSuburb" }, { "name": "PostalCity", "type": "esriFieldTypeString", "alias": "Postal_City", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PostalCity" }, { "name": "PostalCode", "type": "esriFieldTypeString", "alias": "Postal_Code", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PostalCode" }, { "name": "MunicipalID", "type": "esriFieldTypeInteger", "alias": "MunicipalID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MunicipalID" }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Name" }, { "name": "Enabled", "type": "esriFieldTypeString", "alias": "Enabled", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Enabled" }, { "name": "MayorName", "type": "esriFieldTypeString", "alias": "MayorName", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MayorName" }, { "name": "CityManagerName", "type": "esriFieldTypeString", "alias": "CityManagerName", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CityManager" }, { "name": "WorkPhoneNumber", "type": "esriFieldTypeString", "alias": "WorkPhoneNumber", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "WorkPhoneNumber" }, { "name": "FaxNumber", "type": "esriFieldTypeString", "alias": "FaxNumber", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "FaxNumber" }, { "name": "SystemModuleID", "type": "esriFieldTypeInteger", "alias": "SystemModuleID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SystemModuleID" }, { "name": "MayorTitle", "type": "esriFieldTypeString", "alias": "MayorTitle", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MayorTitle" }, { "name": "MayorSurname", "type": "esriFieldTypeString", "alias": "MayorSurname", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MayorSurname" }, { "name": "CityManagerTitle", "type": "esriFieldTypeString", "alias": "CityManagerTitle", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CityManagerTitle" }, { "name": "CityManagerSurname", "type": "esriFieldTypeString", "alias": "CityManagerSurname", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CityManagerSurname" }, { "name": "StreetCode", "type": "esriFieldTypeString", "alias": "StreetCode", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "StreetCode" } ], "indexes": [ { "name": "R318_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Municipal", "description": "", "prototype": { "attributes": { "CityManagerSurname": null, "StreetCode": null, "StreetProvince": null, "StreetAddress": null, "StreetSuburb": null, "StreetCity": null, "PostalProvince": null, "PostalAddress": null, "PostalSuburb": null, "PostalCity": null, "PostalCode": null, "MunicipalID": null, "Name": null, "Enabled": null, "MayorName": null, "CityManagerName": null, "WorkPhoneNumber": null, "FaxNumber": null, "SystemModuleID": null, "MayorTitle": null, "MayorSurname": null, "CityManagerTitle": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "ae2d807b2a544b85bbc269044a63d425" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 36, "name": "MunicipalTimeout", "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, "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": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "SystemModuleID", "type": "esriFieldTypeInteger", "alias": "SystemModuleID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SystemModuleID" }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "Name" }, { "name": "Timeout", "type": "esriFieldTypeInteger", "alias": "Timeout", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Timeout" } ], "indexes": [ { "name": "R343_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "MunicipalTimeout", "description": "", "prototype": { "attributes": { "Name": null, "Timeout": null, "SystemModuleID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "ae2d807b2a544b85bbc269044a63d425" } ] }