{
 "currentVersion": 10.51,
 "id": 1,
 "name": "CWHONOLULU.azteca.INSPECTION",
 "type": "Table",
 "description": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "INSPTEMPLATENAME",
 "typeIdField": null,
 "subtypeFieldName": null,
 "fields": [
  {
   "name": "INSPECTIONID",
   "type": "esriFieldTypeDouble",
   "alias": "INSPECTIONID",
   "domain": null
  },
  {
   "name": "WORKORDERID",
   "type": "esriFieldTypeString",
   "alias": "WORKORDERID",
   "length": 60,
   "domain": null
  },
  {
   "name": "INSPTEMPLATEID",
   "type": "esriFieldTypeDouble",
   "alias": "INSPTEMPLATEID",
   "domain": null
  },
  {
   "name": "INSPTEMPLATENAME",
   "type": "esriFieldTypeString",
   "alias": "INSPTEMPLATENAME",
   "length": 30,
   "domain": null
  },
  {
   "name": "ENTITYUID",
   "type": "esriFieldTypeString",
   "alias": "ENTITYUID",
   "length": 50,
   "domain": null
  },
  {
   "name": "ENTITYTYPE",
   "type": "esriFieldTypeString",
   "alias": "ENTITYTYPE",
   "length": 50,
   "domain": null
  },
  {
   "name": "INSPDATE",
   "type": "esriFieldTypeDate",
   "alias": "INSPDATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "INSPECTEDBY",
   "type": "esriFieldTypeString",
   "alias": "INSPECTEDBY",
   "length": 100,
   "domain": null
  },
  {
   "name": "LOCATION",
   "type": "esriFieldTypeString",
   "alias": "LOCATION",
   "length": 256,
   "domain": null
  },
  {
   "name": "OBSERVATIONSUM",
   "type": "esriFieldTypeString",
   "alias": "OBSERVATIONSUM",
   "length": 900,
   "domain": null
  },
  {
   "name": "REPAIRSMADE",
   "type": "esriFieldTypeString",
   "alias": "REPAIRSMADE",
   "length": 900,
   "domain": null
  },
  {
   "name": "FOREMANRECOMND",
   "type": "esriFieldTypeString",
   "alias": "FOREMANRECOMND",
   "length": 900,
   "domain": null
  },
  {
   "name": "REQUESTID",
   "type": "esriFieldTypeInteger",
   "alias": "REQUESTID",
   "domain": null
  },
  {
   "name": "PRJSTARTDATE",
   "type": "esriFieldTypeDate",
   "alias": "PRJSTARTDATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "PRJFINISHDATE",
   "type": "esriFieldTypeDate",
   "alias": "PRJFINISHDATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "ACTFINISHDATE",
   "type": "esriFieldTypeDate",
   "alias": "ACTFINISHDATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "DATECLOSED",
   "type": "esriFieldTypeDate",
   "alias": "DATECLOSED",
   "length": 8,
   "domain": null
  },
  {
   "name": "CLOSEDBY",
   "type": "esriFieldTypeString",
   "alias": "CLOSEDBY",
   "length": 100,
   "domain": null
  },
  {
   "name": "CLOSESR",
   "type": "esriFieldTypeSmallInteger",
   "alias": "CLOSESR",
   "domain": null
  },
  {
   "name": "CANCEL",
   "type": "esriFieldTypeSmallInteger",
   "alias": "CANCEL",
   "domain": null
  },
  {
   "name": "DATECANCELLED",
   "type": "esriFieldTypeDate",
   "alias": "DATECANCELLED",
   "length": 8,
   "domain": null
  },
  {
   "name": "CANCELLEDBY",
   "type": "esriFieldTypeString",
   "alias": "CANCELLEDBY",
   "length": 100,
   "domain": null
  },
  {
   "name": "CANCELREASON",
   "type": "esriFieldTypeString",
   "alias": "CANCELREASON",
   "length": 100,
   "domain": null
  },
  {
   "name": "STATUS",
   "type": "esriFieldTypeString",
   "alias": "STATUS",
   "length": 50,
   "domain": null
  },
  {
   "name": "INSPX",
   "type": "esriFieldTypeDouble",
   "alias": "INSPX",
   "domain": null
  },
  {
   "name": "INSPY",
   "type": "esriFieldTypeDouble",
   "alias": "INSPY",
   "domain": null
  },
  {
   "name": "INITIATEDBY",
   "type": "esriFieldTypeString",
   "alias": "INITIATEDBY",
   "length": 100,
   "domain": null
  },
  {
   "name": "INITIATEDATE",
   "type": "esriFieldTypeDate",
   "alias": "INITIATEDATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "ENTITYSID",
   "type": "esriFieldTypeInteger",
   "alias": "ENTITYSID",
   "domain": null
  },
  {
   "name": "FEATUREUID",
   "type": "esriFieldTypeString",
   "alias": "FEATUREUID",
   "length": 50,
   "domain": null
  },
  {
   "name": "FEATUREID",
   "type": "esriFieldTypeInteger",
   "alias": "FEATUREID",
   "domain": null
  },
  {
   "name": "FEATURETYPE",
   "type": "esriFieldTypeString",
   "alias": "FEATURETYPE",
   "length": 50,
   "domain": null
  },
  {
   "name": "DOMAINID",
   "type": "esriFieldTypeInteger",
   "alias": "DOMAINID",
   "domain": null
  },
  {
   "name": "SHOP",
   "type": "esriFieldTypeString",
   "alias": "SHOP",
   "length": 100,
   "domain": null
  },
  {
   "name": "MAPPAGE",
   "type": "esriFieldTypeString",
   "alias": "MAPPAGE",
   "length": 100,
   "domain": null
  },
  {
   "name": "TILENO",
   "type": "esriFieldTypeString",
   "alias": "TILENO",
   "length": 50,
   "domain": null
  },
  {
   "name": "DISTRICT",
   "type": "esriFieldTypeString",
   "alias": "DISTRICT",
   "length": 50,
   "domain": null
  },
  {
   "name": "RESOLUTION",
   "type": "esriFieldTypeString",
   "alias": "RESOLUTION",
   "length": 100,
   "domain": null
  },
  {
   "name": "PRIORITY",
   "type": "esriFieldTypeString",
   "alias": "PRIORITY",
   "length": 50,
   "domain": null
  },
  {
   "name": "STREETNAME",
   "type": "esriFieldTypeString",
   "alias": "STREETNAME",
   "length": 50,
   "domain": null
  },
  {
   "name": "CONDRATING",
   "type": "esriFieldTypeDouble",
   "alias": "CONDRATING",
   "domain": null
  },
  {
   "name": "TEXT1",
   "type": "esriFieldTypeString",
   "alias": "TEXT1",
   "length": 100,
   "domain": null
  },
  {
   "name": "TEXT2",
   "type": "esriFieldTypeString",
   "alias": "TEXT2",
   "length": 100,
   "domain": null
  },
  {
   "name": "TEXT3",
   "type": "esriFieldTypeString",
   "alias": "TEXT3",
   "length": 100,
   "domain": null
  },
  {
   "name": "TEXT4",
   "type": "esriFieldTypeString",
   "alias": "TEXT4",
   "length": 100,
   "domain": null
  },
  {
   "name": "TEXT5",
   "type": "esriFieldTypeString",
   "alias": "TEXT5",
   "length": 100,
   "domain": null
  },
  {
   "name": "TEXT6",
   "type": "esriFieldTypeString",
   "alias": "TEXT6",
   "length": 100,
   "domain": null
  },
  {
   "name": "TEXT7",
   "type": "esriFieldTypeString",
   "alias": "TEXT7",
   "length": 100,
   "domain": null
  },
  {
   "name": "TEXT8",
   "type": "esriFieldTypeString",
   "alias": "TEXT8",
   "length": 100,
   "domain": null
  },
  {
   "name": "TEXT9",
   "type": "esriFieldTypeString",
   "alias": "TEXT9",
   "length": 100,
   "domain": null
  },
  {
   "name": "TEXT10",
   "type": "esriFieldTypeString",
   "alias": "TEXT10",
   "length": 100,
   "domain": null
  },
  {
   "name": "NUM1",
   "type": "esriFieldTypeDouble",
   "alias": "NUM1",
   "domain": null
  },
  {
   "name": "NUM2",
   "type": "esriFieldTypeDouble",
   "alias": "NUM2",
   "domain": null
  },
  {
   "name": "NUM3",
   "type": "esriFieldTypeDouble",
   "alias": "NUM3",
   "domain": null
  },
  {
   "name": "NUM4",
   "type": "esriFieldTypeDouble",
   "alias": "NUM4",
   "domain": null
  },
  {
   "name": "NUM5",
   "type": "esriFieldTypeDouble",
   "alias": "NUM5",
   "domain": null
  },
  {
   "name": "DATE1",
   "type": "esriFieldTypeDate",
   "alias": "DATE1",
   "length": 8,
   "domain": null
  },
  {
   "name": "DATE2",
   "type": "esriFieldTypeDate",
   "alias": "DATE2",
   "length": 8,
   "domain": null
  },
  {
   "name": "DATE3",
   "type": "esriFieldTypeDate",
   "alias": "DATE3",
   "length": 8,
   "domain": null
  },
  {
   "name": "DATE4",
   "type": "esriFieldTypeDate",
   "alias": "DATE4",
   "length": 8,
   "domain": null
  },
  {
   "name": "DATE5",
   "type": "esriFieldTypeDate",
   "alias": "DATE5",
   "length": 8,
   "domain": null
  },
  {
   "name": "CONDSCORE",
   "type": "esriFieldTypeDouble",
   "alias": "CONDSCORE",
   "domain": null
  },
  {
   "name": "UPDATEMAP",
   "type": "esriFieldTypeString",
   "alias": "UPDATEMAP",
   "length": 1,
   "domain": null
  },
  {
   "name": "SUBMITTOEMPLOYEESID",
   "type": "esriFieldTypeDouble",
   "alias": "SUBMITTOEMPLOYEESID",
   "domain": null
  },
  {
   "name": "SUBMITTONAME",
   "type": "esriFieldTypeString",
   "alias": "SUBMITTONAME",
   "length": 100,
   "domain": null
  },
  {
   "name": "DATESUBMITTO",
   "type": "esriFieldTypeDate",
   "alias": "DATESUBMITTO",
   "length": 8,
   "domain": null
  },
  {
   "name": "EFFORT",
   "type": "esriFieldTypeDouble",
   "alias": "EFFORT",
   "domain": null
  },
  {
   "name": "PARENTINSPID",
   "type": "esriFieldTypeInteger",
   "alias": "PARENTINSPID",
   "domain": null
  },
  {
   "name": "CYCLETYPE",
   "type": "esriFieldTypeString",
   "alias": "CYCLETYPE",
   "length": 20,
   "domain": null
  },
  {
   "name": "CYCLEFROM",
   "type": "esriFieldTypeString",
   "alias": "CYCLEFROM",
   "length": 30,
   "domain": null
  },
  {
   "name": "CYCLEINTERVALNUM",
   "type": "esriFieldTypeInteger",
   "alias": "CYCLEINTERVALNUM",
   "domain": null
  },
  {
   "name": "CYCLEINTERVALUNIT",
   "type": "esriFieldTypeString",
   "alias": "CYCLEINTERVALUNIT",
   "length": 1,
   "domain": null
  },
  {
   "name": "CREATEDBYCYCLE",
   "type": "esriFieldTypeSmallInteger",
   "alias": "CREATEDBYCYCLE",
   "domain": null
  },
  {
   "name": "FROMDATE",
   "type": "esriFieldTypeDate",
   "alias": "FROMDATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "INITIATEDBYAPP",
   "type": "esriFieldTypeString",
   "alias": "INITIATEDBYAPP",
   "length": 50,
   "domain": null
  },
  {
   "name": "INSPECTEDBYSID",
   "type": "esriFieldTypeInteger",
   "alias": "INSPECTEDBYSID",
   "domain": null
  },
  {
   "name": "CANCELLEDBYSID",
   "type": "esriFieldTypeInteger",
   "alias": "CANCELLEDBYSID",
   "domain": null
  },
  {
   "name": "INITIATEDBYSID",
   "type": "esriFieldTypeInteger",
   "alias": "INITIATEDBYSID",
   "domain": null
  },
  {
   "name": "CLOSEDBYSID",
   "type": "esriFieldTypeInteger",
   "alias": "CLOSEDBYSID",
   "domain": null
  },
  {
   "name": "FACILITY_ID",
   "type": "esriFieldTypeString",
   "alias": "FACILITY_ID",
   "length": 256,
   "domain": null
  },
  {
   "name": "LEVEL_ID",
   "type": "esriFieldTypeString",
   "alias": "LEVEL_ID",
   "length": 256,
   "domain": null
  },
  {
   "name": "PROJECTSID",
   "type": "esriFieldTypeDouble",
   "alias": "PROJECTSID",
   "domain": null
  },
  {
   "name": "PROJECTPHASEID",
   "type": "esriFieldTypeInteger",
   "alias": "PROJECTPHASEID",
   "domain": null
  },
  {
   "name": "METADATA",
   "type": "esriFieldTypeString",
   "alias": "METADATA",
   "length": 2147483647,
   "domain": null
  },
  {
   "name": "INSPZ",
   "type": "esriFieldTypeDouble",
   "alias": "INSPZ",
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "PK_AZTECA_INSPECTION",
   "fields": "INSPECTIONID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "IX_WORKORDERID",
   "fields": "WORKORDERID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "IX_REQUESTID",
   "fields": "REQUESTID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "IX_ENTITYUID_ENTITYTYPE",
   "fields": "ENTITYUID,ENTITYTYPE",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "IX_ENTITYTYPE_ENTITYUID",
   "fields": "ENTITYTYPE,ENTITYUID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "IX_PROJECTSID",
   "fields": "PROJECTSID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [],
 "capabilities": "Data,Map,Query",
 "maxRecordCount": 1000,
 "supportsStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON, AMF",
 "useStandardizedQueries": true,
 "advancedQueryCapabilities": {
  "useStandardizedQueries": true,
  "supportsStatistics": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsPagination": true,
  "supportsTrueCurve": false,
  "supportsReturningQueryExtent": true,
  "supportsQueryWithDistance": true,
  "supportsSqlExpression": true
 },
 "dateFieldsTimeReference": null
}