{
 "currentVersion": 11.3,
 "cimVersion": "3.3.0",
 "id": 4,
 "name": "SW_Digital_and_Traditional_Ad_Activity_Table",
 "type": "Table",
 "description": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "A_ID",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "A_ID",
   "type": "esriFieldTypeString",
   "alias": "A_ID",
   "length": 25,
   "domain": null
  },
  {
   "name": "SumCode",
   "type": "esriFieldTypeString",
   "alias": "SumCode",
   "length": 25,
   "domain": {
    "type": "codedValue",
    "name": "SW_SumCode_AdAwareness",
    "description": "StormWater Advertising-Awareness Summary Code",
    "codedValues": [
     {
      "name": "New",
      "code": "NEW"
     },
     {
      "name": "Digital Ad",
      "code": "DG"
     },
     {
      "name": "Traditional Ad",
      "code": "TR"
     },
     {
      "name": "Press Release",
      "code": "PR"
     },
     {
      "name": "Mailing",
      "code": "M"
     },
     {
      "name": "Voice Mail",
      "code": "VM"
     },
     {
      "name": "Website",
      "code": "WWW"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "A_Type",
   "type": "esriFieldTypeString",
   "alias": "A_Type",
   "length": 25,
   "domain": {
    "type": "codedValue",
    "name": "SW_A_Type_AdAwareness",
    "description": "StormWater Advertising-Awareness Specific Ad Type",
    "codedValues": [
     {
      "name": "New",
      "code": "NEW"
     },
     {
      "name": "BillBoard",
      "code": "BB"
     },
     {
      "name": "Digital-Social",
      "code": "DG_S"
     },
     {
      "name": "Digital-Targeted",
      "code": "DG_T"
     },
     {
      "name": "Flyers",
      "code": "F"
     },
     {
      "name": "Guerilla",
      "code": "G"
     },
     {
      "name": "Letter",
      "code": "L"
     },
     {
      "name": "Print Ad",
      "code": "P"
     },
     {
      "name": "Radio Ad",
      "code": "R"
     },
     {
      "name": "TV",
      "code": "TV"
     },
     {
      "name": "Yard Sign",
      "code": "YS"
     },
     {
      "name": "Vehicle Wrap",
      "code": "VW"
     },
     {
      "name": "CleanMemphisStormWater.com",
      "code": "CMScom"
     },
     {
      "name": "MemphisStormWater.com",
      "code": "MSWcom"
     },
     {
      "name": "EZine",
      "code": "EZ"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Publisher",
   "type": "esriFieldTypeString",
   "alias": "Publisher",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "SW_PublisherType_AdAwareness",
    "description": "StormWater Advertising-Awareness Publisher Name (if applicable)",
    "codedValues": [
     {
      "name": "New",
      "code": "NEW"
     },
     {
      "name": "Contemporary Media",
      "code": "CM"
     },
     {
      "name": "Clean Memphis",
      "code": "CLM"
     },
     {
      "name": "City of Memphis",
      "code": "CMEM"
     },
     {
      "name": "CMEM StormWater",
      "code": "CMEM_SW"
     },
     {
      "name": "JabbeBlabber",
      "code": "JB"
     },
     {
      "name": "Mendelson and Associates",
      "code": "M"
     },
     {
      "name": "Commercial Appeal",
      "code": "CA"
     },
     {
      "name": "LaPrensa Latina",
      "code": "LPL"
     },
     {
      "name": "LocalIQ",
      "code": "LIQ"
     },
     {
      "name": "Memphis Parent",
      "code": "MemParent"
     },
     {
      "name": "Memphis Flyer",
      "code": "MemFlyer"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Campaign_AdDescription",
   "type": "esriFieldTypeString",
   "alias": "Campaign_AdDescription",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "SW_CampaignType_AdAwareness",
    "description": "StormWater Advertising-Awareness Campaign Type",
    "codedValues": [
     {
      "name": "New",
      "code": "NEW"
     },
     {
      "name": "Scoop the Poop",
      "code": "SP"
     },
     {
      "name": "Don't Blow It",
      "code": "DBI"
     },
     {
      "name": "Don't Flick It",
      "code": "DFI"
     },
     {
      "name": "Reduce Recycle Reduce",
      "code": "RRR"
     },
     {
      "name": "Fats Oils Grease",
      "code": "FOG"
     },
     {
      "name": "Wipes",
      "code": "WIPES"
     },
     {
      "name": "Litter",
      "code": "LITTER"
     },
     {
      "name": "Pesticides-Fertilizers",
      "code": "PF"
     },
     {
      "name": "Chemicals",
      "code": "CHEM"
     },
     {
      "name": "Paint Disposal",
      "code": "PAINT"
     },
     {
      "name": "Christmas Tree Recycle",
      "code": "TreeRecy"
     },
     {
      "name": "FireWorks",
      "code": "FireW"
     },
     {
      "name": "Hazardous Waste Disposal",
      "code": "HazDisp"
     },
     {
      "name": "Car Washing",
      "code": "CarWash"
     },
     {
      "name": "Adopt a Storm Drain",
      "code": "AD"
     },
     {
      "name": "Watersheds",
      "code": "WS"
     },
     {
      "name": "Only Rain Down Drain",
      "code": "OnlyRain"
     },
     {
      "name": "LilPP_Contest ad",
      "code": "LilPP1"
     },
     {
      "name": "LilPP_Wining Art",
      "code": "LilPP2"
     },
     {
      "name": "LilPP_with Adopt Drain",
      "code": "LilPP3"
     },
     {
      "name": "Junior Water Warrior",
      "code": "JWW"
     },
     {
      "name": "Green Camp",
      "code": "GC"
     },
     {
      "name": "Gurgle Strip",
      "code": "Gurgle"
     },
     {
      "name": "Gurgle and LPP Contest Ad",
      "code": "Combo1"
     },
     {
      "name": "Gurgle and Contest Art",
      "code": "Combo2"
     },
     {
      "name": "Gurgle and Adopt Drain",
      "code": "Combo3"
     },
     {
      "name": "Gurgle and Activity",
      "code": "Combo4"
     },
     {
      "name": "ContestAd-Art and Activity",
      "code": "Combo5"
     },
     {
      "name": "Adopt and Activity",
      "code": "Combo6"
     },
     {
      "name": "PR and Gurgle",
      "code": "Combo7"
     },
     {
      "name": "PR and difCampaign",
      "code": "Combo8"
     },
     {
      "name": "Public Meeting",
      "code": "PM"
     },
     {
      "name": "Petroleum Products",
      "code": "Oil"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Description",
   "type": "esriFieldTypeString",
   "alias": "Description",
   "length": 200,
   "domain": null
  },
  {
   "name": "Metric",
   "type": "esriFieldTypeString",
   "alias": "Metric",
   "length": 100,
   "domain": null
  },
  {
   "name": "Dg_Link",
   "type": "esriFieldTypeString",
   "alias": "Dg_Link",
   "length": 200,
   "domain": null
  },
  {
   "name": "Tr_QR",
   "type": "esriFieldTypeString",
   "alias": "Tr_QR",
   "length": 200,
   "domain": null
  },
  {
   "name": "Start_Date",
   "type": "esriFieldTypeDate",
   "alias": "Start Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "End_Date",
   "type": "esriFieldTypeDate",
   "alias": "End_Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "Total_TV_Ads",
   "type": "esriFieldTypeDouble",
   "alias": "Total_TV_Ads",
   "domain": null
  },
  {
   "name": "DMA_RTG_less1",
   "type": "esriFieldTypeDouble",
   "alias": "DMA_RTG_less1",
   "domain": null
  },
  {
   "name": "DMA_RTG_1to2",
   "type": "esriFieldTypeDouble",
   "alias": "DMA.RTG_1-1.9",
   "domain": null
  },
  {
   "name": "DMA_RTG_2to3",
   "type": "esriFieldTypeDouble",
   "alias": "DMA_RTG_2-2.9",
   "domain": null
  },
  {
   "name": "DMA_RTG_3to4",
   "type": "esriFieldTypeDouble",
   "alias": "DMA_RTG_3-3.9",
   "domain": null
  },
  {
   "name": "DMA_RTG_4to5",
   "type": "esriFieldTypeDouble",
   "alias": "DMA_RTG_4-4.9",
   "domain": null
  },
  {
   "name": "DMA_RTG_5andUp",
   "type": "esriFieldTypeDouble",
   "alias": "DMA_RTG_5andUp",
   "domain": null
  },
  {
   "name": "Dg_Impressions",
   "type": "esriFieldTypeDouble",
   "alias": "Dg_Impressions",
   "domain": null
  },
  {
   "name": "Dg_Clicks",
   "type": "esriFieldTypeDouble",
   "alias": "Dg_Clicks",
   "domain": null
  },
  {
   "name": "Dg_CTR",
   "type": "esriFieldTypeDouble",
   "alias": "Dg_CTR",
   "domain": null
  },
  {
   "name": "Dg_Engagement",
   "type": "esriFieldTypeDouble",
   "alias": "Dg_Engagement",
   "domain": null
  },
  {
   "name": "Dg_Likes",
   "type": "esriFieldTypeDouble",
   "alias": "Dg_Likes",
   "domain": null
  },
  {
   "name": "GlobalID",
   "type": "esriFieldTypeGlobalID",
   "alias": "GlobalID",
   "length": 38,
   "domain": null
  },
  {
   "name": "created_user",
   "type": "esriFieldTypeString",
   "alias": "created_user",
   "length": 255,
   "domain": null
  },
  {
   "name": "created_date",
   "type": "esriFieldTypeDate",
   "alias": "created_date",
   "length": 8,
   "domain": null
  },
  {
   "name": "last_edited_user",
   "type": "esriFieldTypeString",
   "alias": "last_edited_user",
   "length": 255,
   "domain": null
  },
  {
   "name": "last_edited_date",
   "type": "esriFieldTypeDate",
   "alias": "last_edited_date",
   "length": 8,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R185_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "UUID_185",
   "fields": "GlobalID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "G3317A_ID",
   "fields": "A_ID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 2,
   "name": "PW_GDB.PWGISEDITOR.PW_SW_Awareness_Ad_Map",
   "relatedTableId": 1,
   "role": "esriRelRoleDestination",
   "keyField": "A_ID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{F978FA7D-F8E5-4E7A-833B-F1C05D5BD41C}"
  }
 ],
 "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
 },
 "serviceItemId": "fa8a01e4acf447838e0ee1dab2757577"
}