{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 12, "name": "PROPERTYCARDDSCOMMITSTATES", "type": "Table", "description": null, "copyrightText": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "PARCEL", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PARCEL", "type": "esriFieldTypeString", "alias": "PARCEL", "length": 20, "domain": null }, { "name": "FK_WorkflowID", "type": "esriFieldTypeInteger", "alias": "FK_WorkflowID", "domain": null }, { "name": "FK_Dataset", "type": "esriFieldTypeInteger", "alias": "FK_Dataset", "domain": null }, { "name": "FK_OriginCommit", "type": "esriFieldTypeInteger", "alias": "FK_OriginCommit", "domain": null }, { "name": "FK_ParentCommit", "type": "esriFieldTypeInteger", "alias": "FK_ParentCommit", "domain": null }, { "name": "FK_MergedCommit", "type": "esriFieldTypeInteger", "alias": "FK_MergedCommit", "domain": null }, { "name": "CommitType", "type": "esriFieldTypeSmallInteger", "alias": "CommitType", "domain": { "type": "codedValue", "name": "PRS_Dataset_CommitType", "description": "PRS_Dataset_CommitType", "codedValues": [ { "name": "NoCommit", "code": 0 }, { "name": "Origin", "code": 1 }, { "name": "Change", "code": 2 }, { "name": "Merge", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CommitRowCount", "type": "esriFieldTypeInteger", "alias": "CommitRowCount", "domain": null }, { "name": "ClientUser", "type": "esriFieldTypeString", "alias": "ClientUser", "length": 255, "domain": null }, { "name": "ClientDate", "type": "esriFieldTypeDate", "alias": "ClientDate", "length": 8, "domain": null } ], "indexes": [ { "name": "R14_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G21FK_Dataset", "fields": "FK_Dataset", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G21FK_WorkflowID", "fields": "FK_WorkflowID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I21PARCEL", "fields": "PARCEL", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 166, "name": "PROPERTYCARD_09_VALUEHISTORY", "relatedTableId": 25, "role": "esriRelRoleOrigin", "keyField": "OBJECTID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{6E364242-F464-4F2A-9BE7-E72CCB0325E7}" }, { "id": 158, "name": "PROPERTYCARD_10_SALESHISTORY", "relatedTableId": 18, "role": "esriRelRoleOrigin", "keyField": "OBJECTID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{D4D2716C-9DCF-4D3A-BC67-4A68B61A6A3D}" }, { "id": 162, "name": "PROPERTYCARD_05_IMPROVEMENTS", "relatedTableId": 22, "role": "esriRelRoleOrigin", "keyField": "OBJECTID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{112E8371-5391-409E-9CDD-9B0988D94514}" }, { "id": 164, "name": "PROPERTYCARD_08_MARKETVALUE", "relatedTableId": 17, "role": "esriRelRoleOrigin", "keyField": "OBJECTID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{D695ECD1-C78C-469F-88EC-D231E2F3096D}" }, { "id": 167, "name": "PROPERTYCARD_01_PARCEL", "relatedTableId": 15, "role": "esriRelRoleOrigin", "keyField": "OBJECTID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{8E23D71F-10E2-434A-83B1-EB46D1974B75}" }, { "id": 161, "name": "PROPERTYCARD_07_LANDS", "relatedTableId": 23, "role": "esriRelRoleOrigin", "keyField": "OBJECTID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{3F58EDE1-6A64-4A95-8798-52B7834643C4}" }, { "id": 160, "name": "PROPERTYCARD_02_OCCUPANCY", "relatedTableId": 19, "role": "esriRelRoleOrigin", "keyField": "OBJECTID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{9090AFB0-1DEB-453D-B21F-504D89A12F7E}" }, { "id": 165, "name": "PROPERTYCARD_04_FEATURES", "relatedTableId": 21, "role": "esriRelRoleOrigin", "keyField": "OBJECTID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{2E5A12B7-342C-4906-B67C-DD726736F9DA}" }, { "id": 163, "name": "PROPERTYCARD_11_NOTES", "relatedTableId": 16, "role": "esriRelRoleOrigin", "keyField": "OBJECTID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{E3D37DE4-C39E-4CAD-A404-9C95D56C52E6}" }, { "id": 157, "name": "PROPERTYCARD_06_CAUV", "relatedTableId": 24, "role": "esriRelRoleOrigin", "keyField": "OBJECTID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{DE694A6C-B064-453B-B1F5-1651F83A00D8}" }, { "id": 159, "name": "PROPERTYCARD_03_DWELLINGS", "relatedTableId": 20, "role": "esriRelRoleOrigin", "keyField": "OBJECTID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{D31A3B61-8F14-4245-9C4D-4E8A4E58A8BA}" }, { "id": 145, "name": "PROPERTYCARD", "relatedTableId": 10, "role": "esriRelRoleDestination", "keyField": "FK_Dataset", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{3B536738-571F-499F-9E7F-1B2B5EE91454}" }, { "id": 6, "name": "WORKFLOWS", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "FK_WorkflowID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{9805EC19-D433-49A8-BAD3-524887E422C3}" }, { "id": 24, "name": "WORKFLOWS", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "FK_WorkflowID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{9805EC19-D433-49A8-BAD3-524887E422C3}" }, { "id": 42, "name": "WORKFLOWS", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "FK_WorkflowID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{9805EC19-D433-49A8-BAD3-524887E422C3}" }, { "id": 60, "name": "WORKFLOWS", "relatedTableId": 3, "role": "esriRelRoleDestination", "keyField": "FK_WorkflowID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{9805EC19-D433-49A8-BAD3-524887E422C3}" }, { "id": 78, "name": "WORKFLOWS", "relatedTableId": 4, "role": "esriRelRoleDestination", "keyField": "FK_WorkflowID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{9805EC19-D433-49A8-BAD3-524887E422C3}" }, { "id": 96, "name": "WORKFLOWS", "relatedTableId": 5, "role": "esriRelRoleDestination", "keyField": "FK_WorkflowID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{9805EC19-D433-49A8-BAD3-524887E422C3}" }, { "id": 114, "name": "WORKFLOWS", "relatedTableId": 6, "role": "esriRelRoleDestination", "keyField": "FK_WorkflowID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{9805EC19-D433-49A8-BAD3-524887E422C3}" }, { "id": 132, "name": "WORKFLOWS", "relatedTableId": 7, "role": "esriRelRoleDestination", "keyField": "FK_WorkflowID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{9805EC19-D433-49A8-BAD3-524887E422C3}" } ], "capabilities": "Query,Map,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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }