{ "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 2, "name": "DM Documents Not in GIS", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "DOCNAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SYSTEM_ID", "type": "esriFieldTypeInteger", "alias": "SYSTEM_ID", "domain": null }, { "name": "DOCNUMBER", "type": "esriFieldTypeInteger", "alias": "DOCNUMBER", "domain": null }, { "name": "DOCNAME", "type": "esriFieldTypeString", "alias": "DOCNAME", "length": 240, "domain": null }, { "name": "TYPIST", "type": "esriFieldTypeInteger", "alias": "TYPIST", "domain": null }, { "name": "AUTHOR", "type": "esriFieldTypeInteger", "alias": "AUTHOR", "domain": null }, { "name": "DOCUMENTTYPE", "type": "esriFieldTypeInteger", "alias": "DOCUMENTTYPE", "domain": null }, { "name": "LAST_EDITED_BY", "type": "esriFieldTypeInteger", "alias": "LAST_EDITED_BY", "domain": null }, { "name": "LAST_LOCKED_BY", "type": "esriFieldTypeInteger", "alias": "LAST_LOCKED_BY", "domain": null }, { "name": "LAST_ACCESS_ID", "type": "esriFieldTypeInteger", "alias": "LAST_ACCESS_ID", "domain": null }, { "name": "APPLICATION", "type": "esriFieldTypeInteger", "alias": "APPLICATION", "domain": null }, { "name": "FORM", "type": "esriFieldTypeInteger", "alias": "FORM", "domain": null }, { "name": "STORAGETYPE", "type": "esriFieldTypeString", "alias": "STORAGETYPE", "length": 1, "domain": null }, { "name": "RETENTION", "type": "esriFieldTypeInteger", "alias": "RETENTION", "domain": null }, { "name": "PROCESS_DATE", "type": "esriFieldTypeDate", "alias": "PROCESS_DATE", "length": 8, "domain": null }, { "name": "CREATION_DATE", "type": "esriFieldTypeDate", "alias": "CREATION_DATE", "length": 8, "domain": null }, { "name": "CREATION_TIME", "type": "esriFieldTypeDate", "alias": "CREATION_TIME", "length": 8, "domain": null }, { "name": "LAST_EDIT_DATE", "type": "esriFieldTypeDate", "alias": "LAST_EDIT_DATE", "length": 8, "domain": null }, { "name": "LAST_EDIT_TIME", "type": "esriFieldTypeDate", "alias": "LAST_EDIT_TIME", "length": 8, "domain": null }, { "name": "LAST_ACCESS_DATE", "type": "esriFieldTypeDate", "alias": "LAST_ACCESS_DATE", "length": 8, "domain": null }, { "name": "LAST_ACCESS_TIME", "type": "esriFieldTypeDate", "alias": "LAST_ACCESS_TIME", "length": 8, "domain": null }, { "name": "ARCHIVE_DATE", "type": "esriFieldTypeDate", "alias": "ARCHIVE_DATE", "length": 8, "domain": null }, { "name": "ARCHIVE_ID", "type": "esriFieldTypeInteger", "alias": "ARCHIVE_ID", "domain": null }, { "name": "KEYSTROKES", "type": "esriFieldTypeInteger", "alias": "KEYSTROKES", "domain": null }, { "name": "EDITING_TIME", "type": "esriFieldTypeInteger", "alias": "EDITING_TIME", "domain": null }, { "name": "TYPE_TIME", "type": "esriFieldTypeInteger", "alias": "TYPE_TIME", "domain": null }, { "name": "BILLABLE", "type": "esriFieldTypeString", "alias": "BILLABLE", "length": 1, "domain": null }, { "name": "FULLTEXT", "type": "esriFieldTypeString", "alias": "FULLTEXT", "length": 1, "domain": null }, { "name": "FULLTEXT_DATE", "type": "esriFieldTypeDate", "alias": "FULLTEXT_DATE", "length": 8, "domain": null }, { "name": "STATUS", "type": "esriFieldTypeInteger", "alias": "STATUS", "domain": null }, { "name": "DEFAULT_RIGHTS", "type": "esriFieldTypeInteger", "alias": "DEFAULT_RIGHTS", "domain": null }, { "name": "ABSTRACT", "type": "esriFieldTypeString", "alias": "ABSTRACT", "length": 2000, "domain": null }, { "name": "PATH", "type": "esriFieldTypeString", "alias": "PATH", "length": 128, "domain": null }, { "name": "DOCSERVER_LOC", "type": "esriFieldTypeString", "alias": "DOCSERVER_LOC", "length": 64, "domain": null }, { "name": "DOCSERVER_OS", "type": "esriFieldTypeInteger", "alias": "DOCSERVER_OS", "domain": null }, { "name": "KEYWORDS_DISPLAY", "type": "esriFieldTypeString", "alias": "KEYWORDS_DISPLAY", "length": 254, "domain": null }, { "name": "ADDR", "type": "esriFieldTypeString", "alias": "ADDR", "length": 75, "domain": null }, { "name": "ORD_NO", "type": "esriFieldTypeString", "alias": "ORD_NO", "length": 5, "domain": null }, { "name": "CHAP_BOOK", "type": "esriFieldTypeString", "alias": "CHAP_BOOK", "length": 30, "domain": null }, { "name": "DEV_OWNER", "type": "esriFieldTypeString", "alias": "DEV_OWNER", "length": 200, "domain": null }, { "name": "FINAL", "type": "esriFieldTypeString", "alias": "FINAL", "length": 1, "domain": null }, { "name": "LICENSE", "type": "esriFieldTypeString", "alias": "LICENSE", "length": 50, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 200, "domain": null }, { "name": "DOCUMENT_NO", "type": "esriFieldTypeString", "alias": "DOCUMENT_NO", "length": 15, "domain": null }, { "name": "PERMITS", "type": "esriFieldTypeString", "alias": "PERMITS", "length": 30, "domain": null }, { "name": "APPROVAL_DATE", "type": "esriFieldTypeDate", "alias": "APPROVAL_DATE", "length": 8, "domain": null }, { "name": "BOARDS", "type": "esriFieldTypeInteger", "alias": "BOARDS", "domain": null }, { "name": "DIVISIONS", "type": "esriFieldTypeInteger", "alias": "DIVISIONS", "domain": null }, { "name": "MEETING_DATE", "type": "esriFieldTypeString", "alias": "MEETING_DATE", "length": 18, "domain": null }, { "name": "MAIL_MSG_ID", "type": "esriFieldTypeString", "alias": "MAIL_MSG_ID", "length": 100, "domain": null }, { "name": "MAIL_MSG_IDX", "type": "esriFieldTypeInteger", "alias": "MAIL_MSG_IDX", "domain": null }, { "name": "READONLY_DATE", "type": "esriFieldTypeDate", "alias": "READONLY_DATE", "length": 8, "domain": null }, { "name": "RELATED", "type": "esriFieldTypeString", "alias": "RELATED", "length": 1, "domain": null }, { "name": "PD_OBJ_TYPE", "type": "esriFieldTypeString", "alias": "PD_OBJ_TYPE", "length": 2, "domain": null }, { "name": "PD_DOC_BARCODE", "type": "esriFieldTypeInteger", "alias": "PD_DOC_BARCODE", "domain": null }, { "name": "PD_FILE_PART", "type": "esriFieldTypeInteger", "alias": "PD_FILE_PART", "domain": null }, { "name": "PD_BOX", "type": "esriFieldTypeInteger", "alias": "PD_BOX", "domain": null }, { "name": "PD_SUSPEND", "type": "esriFieldTypeString", "alias": "PD_SUSPEND", "length": 1, "domain": null }, { "name": "PD_ACTIONBY_DATE", "type": "esriFieldTypeDate", "alias": "PD_ACTIONBY_DATE", "length": 8, "domain": null }, { "name": "PD_FAVOURITES", "type": "esriFieldTypeInteger", "alias": "PD_FAVOURITES", "domain": null }, { "name": "PD_SUPSEDED", "type": "esriFieldTypeString", "alias": "PD_SUPSEDED", "length": 1, "domain": null }, { "name": "PD_SUPSEDES", "type": "esriFieldTypeString", "alias": "PD_SUPSEDES", "length": 1, "domain": null }, { "name": "PD_VITAL", "type": "esriFieldTypeString", "alias": "PD_VITAL", "length": 1, "domain": null }, { "name": "PD_MEDIA_TYPE", "type": "esriFieldTypeString", "alias": "PD_MEDIA_TYPE", "length": 2, "domain": null }, { "name": "PD_ORGANIZATION", "type": "esriFieldTypeString", "alias": "PD_ORGANIZATION", "length": 100, "domain": null }, { "name": "PD_FILE_DATE", "type": "esriFieldTypeDate", "alias": "PD_FILE_DATE", "length": 8, "domain": null }, { "name": "PD_DATE_CREATED", "type": "esriFieldTypeDate", "alias": "PD_DATE_CREATED", "length": 8, "domain": null }, { "name": "PD_PUBLISH_DATE", "type": "esriFieldTypeDate", "alias": "PD_PUBLISH_DATE", "length": 8, "domain": null }, { "name": "PD_EMAIL_BCC", "type": "esriFieldTypeString", "alias": "PD_EMAIL_BCC", "length": 100, "domain": null }, { "name": "PD_EMAIL_CC", "type": "esriFieldTypeString", "alias": "PD_EMAIL_CC", "length": 100, "domain": null }, { "name": "PD_EMAIL_DATE", "type": "esriFieldTypeString", "alias": "PD_EMAIL_DATE", "length": 40, "domain": null }, { "name": "PD_ADDRESSEE", "type": "esriFieldTypeString", "alias": "PD_ADDRESSEE", "length": 100, "domain": null }, { "name": "PD_ORIGINATOR", "type": "esriFieldTypeString", "alias": "PD_ORIGINATOR", "length": 200, "domain": null }, { "name": "PD_CLASSIFICATION", "type": "esriFieldTypeString", "alias": "PD_CLASSIFICATION", "length": 240, "domain": null }, { "name": "PD_SUPSEDED_DATE", "type": "esriFieldTypeDate", "alias": "PD_SUPSEDED_DATE", "length": 8, "domain": null }, { "name": "PD_DOC2CSGMT_LINK", "type": "esriFieldTypeInteger", "alias": "PD_DOC2CSGMT_LINK", "domain": null }, { "name": "PD_ATTACH_CHANGE", "type": "esriFieldTypeString", "alias": "PD_ATTACH_CHANGE", "length": 1, "domain": null }, { "name": "PD_ACTIONED", "type": "esriFieldTypeString", "alias": "PD_ACTIONED", "length": 1, "domain": null }, { "name": "PD_VREVIEW_DATE", "type": "esriFieldTypeDate", "alias": "PD_VREVIEW_DATE", "length": 8, "domain": null }, { "name": "PD_PRTO_ACTION", "type": "esriFieldTypeInteger", "alias": "PD_PRTO_ACTION", "domain": null }, { "name": "PD_PRTO_AUTHORITY", "type": "esriFieldTypeInteger", "alias": "PD_PRTO_AUTHORITY", "domain": null }, { "name": "PD_STATUSES", "type": "esriFieldTypeInteger", "alias": "PD_STATUSES", "domain": null }, { "name": "MAIL_ID", "type": "esriFieldTypeString", "alias": "MAIL_ID", "length": 300, "domain": null }, { "name": "PARENTMAIL_ID", "type": "esriFieldTypeString", "alias": "PARENTMAIL_ID", "length": 300, "domain": null }, { "name": "THREAD_NUM", "type": "esriFieldTypeInteger", "alias": "THREAD_NUM", "domain": null }, { "name": "ATTACH_NUM", "type": "esriFieldTypeString", "alias": "ATTACH_NUM", "length": 20, "domain": null }, { "name": "MSG_ITEM", "type": "esriFieldTypeInteger", "alias": "MSG_ITEM", "domain": null }, { "name": "DELIVER_REC", "type": "esriFieldTypeInteger", "alias": "DELIVER_REC", "domain": null }, { "name": "DOC_DATE", "type": "esriFieldTypeDate", "alias": "DOC_DATE", "length": 8, "domain": null }, { "name": "REOCRED", "type": "esriFieldTypeString", "alias": "REOCRED", "length": 1, "domain": null }, { "name": "SUBDIVISION", "type": "esriFieldTypeInteger", "alias": "SUBDIVISION", "domain": null }, { "name": "SUBDIVISIONS", "type": "esriFieldTypeString", "alias": "SUBDIVISIONS", "length": 100, "domain": null }, { "name": "DISPOSITION", "type": "esriFieldTypeString", "alias": "DISPOSITION", "length": 1, "domain": null }, { "name": "LOAN_GIFT", "type": "esriFieldTypeString", "alias": "LOAN_GIFT", "length": 1, "domain": null }, { "name": "LOAN_DATE", "type": "esriFieldTypeDate", "alias": "LOAN_DATE", "length": 8, "domain": null }, { "name": "NARRATIVE", "type": "esriFieldTypeString", "alias": "NARRATIVE", "length": 254, "domain": null }, { "name": "ORIGINAL", "type": "esriFieldTypeString", "alias": "ORIGINAL", "length": 1, "domain": null }, { "name": "PREV_SERVER_LOC", "type": "esriFieldTypeString", "alias": "PREV_SERVER_LOC", "length": 64, "domain": null }, { "name": "PREV_SERVER_OS", "type": "esriFieldTypeInteger", "alias": "PREV_SERVER_OS", "domain": null }, { "name": "EMAIL_RECEIVED", "type": "esriFieldTypeDate", "alias": "EMAIL_RECEIVED", "length": 8, "domain": null }, { "name": "EMAIL_SENT", "type": "esriFieldTypeDate", "alias": "EMAIL_SENT", "length": 8, "domain": null }, { "name": "ORG", "type": "esriFieldTypeInteger", "alias": "ORG", "domain": null }, { "name": "DEPT", "type": "esriFieldTypeInteger", "alias": "DEPT", "domain": null }, { "name": "INH_LUP_SEC_FROM", "type": "esriFieldTypeInteger", "alias": "INH_LUP_SEC_FROM", "domain": null }, { "name": "NOTEID", "type": "esriFieldTypeString", "alias": "NOTEID", "length": 128, "domain": null }, { "name": "MATTER", "type": "esriFieldTypeInteger", "alias": "MATTER", "domain": null }, { "name": "LAST_PRF_EDITED_BY", "type": "esriFieldTypeInteger", "alias": "LAST_PRF_EDITED_BY", "domain": null }, { "name": "LAST_PRF_EDIT_DATE", "type": "esriFieldTypeDate", "alias": "LAST_PRF_EDIT_DATE", "length": 8, "domain": null }, { "name": "READONLY", "type": "esriFieldTypeString", "alias": "READONLY", "length": 1, "domain": null }, { "name": "RECORD", "type": "esriFieldTypeString", "alias": "RECORD", "length": 1, "domain": null }, { "name": "RECORD_DATE", "type": "esriFieldTypeDate", "alias": "RECORD_DATE", "length": 8, "domain": null }, { "name": "SECURITY_LINK", "type": "esriFieldTypeInteger", "alias": "SECURITY_LINK", "domain": null }, { "name": "SEC_REASON_LINK", "type": "esriFieldTypeInteger", "alias": "SEC_REASON_LINK", "domain": null }, { "name": "ITEM_TYPE", "type": "esriFieldTypeString", "alias": "ITEM_TYPE", "length": 1, "domain": null }, { "name": "NOTE", "type": "esriFieldTypeString", "alias": "NOTE", "length": 128, "domain": null }, { "name": "IS_SHARED", "type": "esriFieldTypeInteger", "alias": "IS_SHARED", "domain": null }, { "name": "CALC", "type": "esriFieldTypeDate", "alias": "CALC", "length": 8, "domain": null }, { "name": "RETEN", "type": "esriFieldTypeString", "alias": "RETEN", "length": 10, "domain": null }, { "name": "DOCTYPE", "type": "esriFieldTypeString", "alias": "DOCTYPE", "length": 32, "domain": null }, { "name": "ADDRESS_SYSID", "type": "esriFieldTypeInteger", "alias": "ADDRESS_SYSID", "domain": null }, { "name": "PARCEL_SYSID", "type": "esriFieldTypeInteger", "alias": "PARCEL_SYSID", "domain": null }, { "name": "GRID", "type": "esriFieldTypeInteger", "alias": "GRID", "domain": null }, { "name": "ASBUILT_TAG", "type": "esriFieldTypeInteger", "alias": "ASBUILT_TAG", "domain": null }, { "name": "ASBUILTTAG", "type": "esriFieldTypeString", "alias": "ASBUILTTAG", "length": 100, "domain": null }, { "name": "GRID1", "type": "esriFieldTypeString", "alias": "GRID1", "length": 32, "domain": null }, { "name": "ADDRKEY", "type": "esriFieldTypeInteger", "alias": "ADDRKEY", "domain": null }, { "name": "PIN", "type": "esriFieldTypeString", "alias": "PIN", "length": 20, "domain": null }, { "name": "DOC_TYPE_ID", "type": "esriFieldTypeString", "alias": "DOC_TYPE_ID", "length": 10, "domain": null }, { "name": "DOC_DESC", "type": "esriFieldTypeString", "alias": "DOC_DESC", "length": 60, "domain": null } ], "indexes": [ { "name": "R740_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Mountain Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }