{
 "currentVersion": 11.5,
 "cimVersion": "3.5.0",
 "id": 5,
 "name": "Water Project SAP Project Description",
 "type": "Table",
 "description": "This table provides the project system project name, description, and project manager information from SAP. It is intended to be a short term solution to provide agency access to SAP project systems information through a relationship on PS-ID. ",
 "copyrightText": "SFWMD, Geospatial Services: Geospatial Services is a unit within the South Florida Water Management District\u2019s Information Technology Bureau (ITB). Geospatial Services manages and maintains enterprise geospatial services, products, and data and is governed by the ITB's Policies and Procedures.",
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "SAP_PROJ_NAME",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "SAP_PS_ID",
   "type": "esriFieldTypeString",
   "alias": "SAP PS ID",
   "length": 30,
   "domain": null
  },
  {
   "name": "SAP_PROJ_NAME",
   "type": "esriFieldTypeString",
   "alias": "SAP Project Name",
   "length": 150,
   "domain": null
  },
  {
   "name": "ALIAS",
   "type": "esriFieldTypeString",
   "alias": "Alias",
   "length": 255,
   "domain": null
  },
  {
   "name": "PROJ_MANAGER",
   "type": "esriFieldTypeString",
   "alias": "Project Manager",
   "length": 100,
   "domain": null
  },
  {
   "name": "PROJ_DESC",
   "type": "esriFieldTypeString",
   "alias": "SAP Project Description",
   "length": 1073741822,
   "domain": null
  },
  {
   "name": "APPLICATION_NUM",
   "type": "esriFieldTypeInteger",
   "alias": "Application Number",
   "domain": null
  },
  {
   "name": "APPLICANT",
   "type": "esriFieldTypeString",
   "alias": "Applicant Name",
   "length": 50,
   "domain": null
  },
  {
   "name": "START_DATE",
   "type": "esriFieldTypeDate",
   "alias": "Start Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "FINISH_DATE",
   "type": "esriFieldTypeDate",
   "alias": "Finish Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "PROJ_TYPE",
   "type": "esriFieldTypeString",
   "alias": "Project Type",
   "length": 50,
   "domain": null
  },
  {
   "name": "LOCATION",
   "type": "esriFieldTypeString",
   "alias": "Location",
   "length": 30,
   "domain": null
  },
  {
   "name": "FUNC_AREA",
   "type": "esriFieldTypeString",
   "alias": "Functional Area",
   "length": 10,
   "domain": null
  },
  {
   "name": "PROJ_PROFILE",
   "type": "esriFieldTypeString",
   "alias": "Project Profile",
   "length": 10,
   "domain": null
  },
  {
   "name": "PIC_URL",
   "type": "esriFieldTypeString",
   "alias": "PIC_URL",
   "length": 256,
   "domain": null
  },
  {
   "name": "THUMB_URL",
   "type": "esriFieldTypeString",
   "alias": "THUMB_URL",
   "length": 256,
   "domain": null
  },
  {
   "name": "GlobalID",
   "type": "esriFieldTypeGlobalID",
   "alias": "GlobalID",
   "length": 38,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "GDB_123_SAP_PS_I",
   "fields": "SAP_PS_ID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "UUID_65",
   "fields": "GlobalID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "gdb_ct3_65",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 1,
   "name": "NVEP.BDWMD_WATER_PROJ_COMPONENT",
   "relatedTableId": 1,
   "role": "esriRelRoleDestination",
   "keyField": "SAP_PS_ID",
   "cardinality": "esriRelCardinalityOneToOne",
   "composite": false,
   "catalogID": "{232AABF0-7C63-44B5-84FD-37A28FE2C530}"
  },
  {
   "id": 3,
   "name": "NVEP.BDWMD_WATER_PROJ_COMPONENT",
   "relatedTableId": 2,
   "role": "esriRelRoleDestination",
   "keyField": "SAP_PS_ID",
   "cardinality": "esriRelCardinalityOneToOne",
   "composite": false,
   "catalogID": "{232AABF0-7C63-44B5-84FD-37A28FE2C530}"
  }
 ],
 "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": {
  "timeZone": "Eastern Standard Time",
  "timeZoneIANA": "America/New_York",
  "respectsDaylightSaving": true
 },
 "preferredTimeReference": {
  "timeZone": "Eastern Standard Time",
  "timeZoneIANA": "America/New_York",
  "respectsDaylightSaving": true
 },
 "datesInUnknownTimezone": false,
 "hasMetadata": true,
 "isDataArchived": true,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": true,
  "startArchivingMoment": 1759228154000
 },
 "serviceItemId": "c821aac139bf4a8d9df92e09e84a81bc"
}