{ "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 11, "name": "User Table", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "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 }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "USER_FNAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "USER_LOGIN", "type": "esriFieldTypeString", "alias": "Login Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "USER_LOGIN" }, { "name": "USER_FNAME", "type": "esriFieldTypeString", "alias": "First Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "USER_FNAME" }, { "name": "USER_LNAME", "type": "esriFieldTypeString", "alias": "Last Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "USER_LNAME" }, { "name": "USER_TYPE", "type": "esriFieldTypeString", "alias": "User Type", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": "USER", "modelName": "USER_TYPE" }, { "name": "USER_POSITION", "type": "esriFieldTypeString", "alias": "Position", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "USER_POSITION" }, { "name": "USER_ORGANIZATION", "type": "esriFieldTypeString", "alias": "Organization", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "USER_ORGANIZATION" }, { "name": "AD_JURISDICTION", "type": "esriFieldTypeString", "alias": "Address Jurisdiction", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "AD_JURISDICTION" }, { "name": "RD_JURISDICTION", "type": "esriFieldTypeString", "alias": "Road Jurisdiction", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "RD_JURISDICTION" }, { "name": "ENV_LBA", "type": "esriFieldTypeDouble", "alias": "Length Between Addresses", "domain": null, "editable": true, "nullable": true, "defaultValue": 25, "modelName": "ENV_LBA" }, { "name": "ENV_SIDE", "type": "esriFieldTypeString", "alias": "Default Even Side", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": "RIGHT", "modelName": "ENV_SIDE" }, { "name": "RULE_AD_DUP", "type": "esriFieldTypeString", "alias": "Rule Address Duplicate", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": "HARD", "modelName": "RULE_AD_DUP" }, { "name": "RULE_AD_ZERO", "type": "esriFieldTypeString", "alias": "Rule Address Zero", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": "HARD", "modelName": "RULE_AD_ZERO" }, { "name": "RULE_AD_OEM", "type": "esriFieldTypeString", "alias": "Rule Address OE Mismatch", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": "HARD", "modelName": "RULE_AD_OEM" }, { "name": "RULE_AD_OOR", "type": "esriFieldTypeString", "alias": "Rule Address Out of Range", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": "HARD", "modelName": "RULE_AD_OOR" }, { "name": "RULE_RD_OVRLP", "type": "esriFieldTypeString", "alias": "Rule Road Range Overlap", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": "HARD", "modelName": "RULE_RD_OVRLP" }, { "name": "RULE_RD_ZERO", "type": "esriFieldTypeString", "alias": "Rule Road Zero Ranges", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": "HARD", "modelName": "RULE_RD_ZERO" }, { "name": "EDIT_ENABLE_DELETE", "type": "esriFieldTypeString", "alias": "Enable Delete Address", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "EDIT_ENABLE_DELETE" }, { "name": "EDIT_ENABLE_MASS", "type": "esriFieldTypeString", "alias": "Enable Mass Calculate", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "EDIT_ENABLE_MASS" }, { "name": "EDIT_ENABLE_AUTO", "type": "esriFieldTypeString", "alias": "Enable AutoAddress", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "EDIT_ENABLE_AUTO" }, { "name": "EDIT_ENABLE_LINK", "type": "esriFieldTypeString", "alias": "Enable Link", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "EDIT_ENABLE_LINK" }, { "name": "EDIT_ENABLE_SBDV", "type": "esriFieldTypeString", "alias": "Enable Subdivion Edit", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "EDIT_ENABLE_SBDV" }, { "name": "EDIT_ENABLE_NAME", "type": "esriFieldTypeString", "alias": "Enable Street Name Edit", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "EDIT_ENABLE_NAME" }, { "name": "EDIT_ENABLE_ERROR", "type": "esriFieldTypeString", "alias": "Enable Error Checks", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "EDIT_ENABLE_ERROR" }, { "name": "EDIT_ENABLE_DELETE_ROAD", "type": "esriFieldTypeString", "alias": "Enable Delete Road", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "EDIT_ENABLE_DELETE_ROAD" }, { "name": "EDIT_ENABLE_DELETE_NAME", "type": "esriFieldTypeString", "alias": "Enable Delete Name", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "EDIT_ENABLE_DELETE_NAME" }, { "name": "EDIT_ENABLE_DELETE_SUBDIV", "type": "esriFieldTypeString", "alias": "Enable Delete Subdivision", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "EDIT_ENABLE_DELETE_SUBDIV" }, { "name": "EDIT_ENABLE_ANOMALY_ADDR", "type": "esriFieldTypeString", "alias": "Enable Anomaly Address", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "EDIT_ENABLE_ANOMALY_ADDR" }, { "name": "EDIT_ENABLE_ANOMALY_ROAD", "type": "esriFieldTypeString", "alias": "Enable Anomaly Road", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "EDIT_ENABLE_ANOMALY_ROAD" }, { "name": "EDIT_ENABLE_MASS_DELETE", "type": "esriFieldTypeString", "alias": "Enable Mass Delete", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "EDIT_ENABLE_MASS_DELETE" }, { "name": "EDIT_ENABLE_ADD_ADDRESS", "type": "esriFieldTypeString", "alias": "Enable Add Address", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "EDIT_ENABLE_ADD_ADDRESS" }, { "name": "EDIT_ENABLE_MOVE_ADDRESS", "type": "esriFieldTypeString", "alias": "Enable Move Address", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "EDIT_ENABLE_MOVE_ADDRESS" }, { "name": "EDIT_ENABLE_EDIT_ADDRESS", "type": "esriFieldTypeString", "alias": "Enable Edit Address", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "EDIT_ENABLE_EDIT_ADDRESS" }, { "name": "EDIT_ENABLE_ADD_ROAD", "type": "esriFieldTypeString", "alias": "Enable Add Road", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "EDIT_ENABLE_ADD_ROAD" }, { "name": "EDIT_ENABLE_VERTEX_ROAD", "type": "esriFieldTypeString", "alias": "Enable Vertex Road", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "EDIT_ENABLE_VERTEX_ROAD" }, { "name": "EDIT_ENABLE_SPLIT_ROAD", "type": "esriFieldTypeString", "alias": "Enable Split Road", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "EDIT_ENABLE_SPLIT_ROAD" }, { "name": "EDIT_ENABLE_MERGE_ROAD", "type": "esriFieldTypeString", "alias": "Enable Merge Road", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "EDIT_ENABLE_MERGE_ROAD" }, { "name": "EDIT_FIELDS_ROAD", "type": "esriFieldTypeString", "alias": "Editable Road Fields", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "EDIT_FIELDS_ROAD" }, { "name": "EDIT_FIELDS_ADDRESS", "type": "esriFieldTypeString", "alias": "Editable Address Fields", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "EDIT_FIELDS_ADDRESS" }, { "name": "EDIT_ENABLE_EDIT_ROAD", "type": "esriFieldTypeString", "alias": "Enable Edit Road", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "EDIT_ENABLE_EDIT_ROAD" }, { "name": "ACTIVE", "type": "esriFieldTypeString", "alias": "Active", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": "Y", "modelName": "ACTIVE" }, { "name": "USER_ROLE", "type": "esriFieldTypeString", "alias": "Role", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "USER_ROLE" }, { "name": "USER_LOCAL_NAME", "type": "esriFieldTypeString", "alias": "Local Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "USER_LOCAL_NAME" }, { "name": "FEATURE_LAYERS", "type": "esriFieldTypeString", "alias": "Feature Lyaers Visible", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "FEATURE_LAYERS" }, { "name": "BACK_LAYERS", "type": "esriFieldTypeString", "alias": "Back Layers Visible", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "BACK_LAYERS" }, { "name": "BASEMAPS", "type": "esriFieldTypeString", "alias": "Base Maps Visible", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "BASEMAPS" }, { "name": "EDIT_ENABLE_ROAD_COMMENT", "type": "esriFieldTypeString", "alias": "Enable Road Extended Comments", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "EDIT_ENABLE_ROAD_COMMENT" }, { "name": "EDIT_ENABLE_ADDR_COMMENT", "type": "esriFieldTypeString", "alias": "Enable Address Extended Comments", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "EDIT_ENABLE_ADDR_COMMENT" }, { "name": "EDIT_ENABLE_NAME_COMMENT", "type": "esriFieldTypeString", "alias": "Enable Name Extended Comments", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "EDIT_ENABLE_NAME_COMMENT" }, { "name": "USER_EMAIL", "type": "esriFieldTypeString", "alias": "eMail", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "USER_EMAIL" }, { "name": "USER_ADDR_ISSUE", "type": "esriFieldTypeString", "alias": "Handle Address Issues", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "USER_ADDR_ISSUE" }, { "name": "USER_ADDR_REQUEST", "type": "esriFieldTypeString", "alias": "Handle Address Requests", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "USER_ADDR_REQUEST" }, { "name": "USER_ROAD_ISSUE", "type": "esriFieldTypeString", "alias": "Handle Road Issues", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "USER_ROAD_ISSUE" }, { "name": "USER_ROAD_REQUEST", "type": "esriFieldTypeString", "alias": "Handle Road Requests", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "USER_ROAD_REQUEST" }, { "name": "EDIT_ENABLE_ADD_NAME", "type": "esriFieldTypeString", "alias": "Enable Add Name", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "EDIT_ENABLE_ADD_NAME" }, { "name": "EDIT_ENABLE_EDIT_NAME", "type": "esriFieldTypeString", "alias": "Enable Edit Name", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "EDIT_ENABLE_EDIT_NAME" }, { "name": "EDIT_ENABLE_ADD_ALIAS", "type": "esriFieldTypeString", "alias": "Enable Add Alias", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "EDIT_ENABLE_ADD_ALIAS" }, { "name": "EDIT_ENABLE_EDIT_ALIAS", "type": "esriFieldTypeString", "alias": "Enable Edit Alias", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "EDIT_ENABLE_EDIT_ALIAS" }, { "name": "EDIT_ENABLE_DELETE_ALIAS", "type": "esriFieldTypeString", "alias": "Enable Delete Alias", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "EDIT_ENABLE_DELETE_ALIAS" }, { "name": "EDIT_ENABLE_ADD_BASE", "type": "esriFieldTypeString", "alias": "Enable Add Base", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "EDIT_ENABLE_ADD_BASE" }, { "name": "EDIT_ENABLE_EDIT_BASE", "type": "esriFieldTypeString", "alias": "Enable Edit Base", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "EDIT_ENABLE_EDIT_BASE" }, { "name": "EDIT_ENABLE_DELETE_BASE", "type": "esriFieldTypeString", "alias": "Enable Delete Base", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "EDIT_ENABLE_DELETE_BASE" } ], "indexes": [ { "name": "R152_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "types": [], "templates": [ { "name": "User Table", "description": "", "prototype": { "attributes": { "EDIT_ENABLE_EDIT_BASE": "N", "EDIT_ENABLE_DELETE_BASE": "N", "USER_LOGIN": null, "USER_FNAME": null, "USER_LNAME": null, "USER_TYPE": "USER", "USER_POSITION": null, "USER_ORGANIZATION": null, "AD_JURISDICTION": null, "RD_JURISDICTION": null, "ENV_LBA": 25, "ENV_SIDE": "RIGHT", "RULE_AD_DUP": "HARD", "RULE_AD_ZERO": "HARD", "RULE_AD_OEM": "HARD", "RULE_AD_OOR": "HARD", "RULE_RD_OVRLP": "HARD", "RULE_RD_ZERO": "HARD", "EDIT_ENABLE_DELETE": "N", "EDIT_ENABLE_MASS": "N", "EDIT_ENABLE_AUTO": "N", "EDIT_ENABLE_LINK": "N", "EDIT_ENABLE_SBDV": "N", "EDIT_ENABLE_NAME": "N", "EDIT_ENABLE_ERROR": "N", "EDIT_ENABLE_DELETE_ROAD": "N", "EDIT_ENABLE_DELETE_NAME": "N", "EDIT_ENABLE_DELETE_SUBDIV": "N", "EDIT_ENABLE_ANOMALY_ADDR": "N", "EDIT_ENABLE_ANOMALY_ROAD": "N", "EDIT_ENABLE_MASS_DELETE": "N", "EDIT_ENABLE_ADD_ADDRESS": "N", "EDIT_ENABLE_MOVE_ADDRESS": "N", "EDIT_ENABLE_EDIT_ADDRESS": "N", "EDIT_ENABLE_ADD_ROAD": "N", "EDIT_ENABLE_VERTEX_ROAD": "N", "EDIT_ENABLE_SPLIT_ROAD": "N", "EDIT_ENABLE_MERGE_ROAD": "N", "EDIT_FIELDS_ROAD": null, "EDIT_FIELDS_ADDRESS": null, "EDIT_ENABLE_EDIT_ROAD": "N", "ACTIVE": "Y", "USER_ROLE": null, "USER_LOCAL_NAME": null, "FEATURE_LAYERS": null, "BACK_LAYERS": null, "BASEMAPS": null, "EDIT_ENABLE_ROAD_COMMENT": "N", "EDIT_ENABLE_ADDR_COMMENT": "N", "EDIT_ENABLE_NAME_COMMENT": "N", "USER_EMAIL": null, "USER_ADDR_ISSUE": "N", "USER_ADDR_REQUEST": "N", "USER_ROAD_ISSUE": "N", "USER_ROAD_REQUEST": "N", "EDIT_ENABLE_ADD_NAME": "N", "EDIT_ENABLE_EDIT_NAME": "N", "EDIT_ENABLE_ADD_ALIAS": "N", "EDIT_ENABLE_EDIT_ALIAS": "N", "EDIT_ENABLE_DELETE_ALIAS": "N", "EDIT_ENABLE_ADD_BASE": "N" } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }