{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 5, "name": "SW_WWW_Ad_ActivityTable", "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": "Start_Date", "type": "esriFieldTypeDate", "alias": "Start_Date", "length": 8, "domain": null }, { "name": "End_Date", "type": "esriFieldTypeDate", "alias": "End_Date", "length": 8, "domain": null }, { "name": "TS_Direct", "type": "esriFieldTypeInteger", "alias": "TS_Direct", "domain": null }, { "name": "T_Search", "type": "esriFieldTypeInteger", "alias": "T_Search", "domain": null }, { "name": "TS_Referral", "type": "esriFieldTypeInteger", "alias": "TS_Referral", "domain": null }, { "name": "TS_RefQR", "type": "esriFieldTypeInteger", "alias": "TS_RefQR", "domain": null }, { "name": "TS_RefNotes", "type": "esriFieldTypeString", "alias": "TS_RefNotes", "length": 200, "domain": null }, { "name": "TS_Social", "type": "esriFieldTypeInteger", "alias": "TS_Social", "domain": null }, { "name": "TS_SocNotes", "type": "esriFieldTypeString", "alias": "TS_SocNotes", "length": 200, "domain": null }, { "name": "TS_DisplayAds", "type": "esriFieldTypeInteger", "alias": "TS_DisplayAds", "domain": null }, { "name": "TS_Email", "type": "esriFieldTypeInteger", "alias": "TS_Email", "domain": null }, { "name": "TS_GoogleAnalyt", "type": "esriFieldTypeDouble", "alias": "TS_GoogleAnalyt", "domain": null }, { "name": "TS_Notes", "type": "esriFieldTypeString", "alias": "TS_Notes", "length": 200, "domain": null }, { "name": "TS_QR_Promo_DBI", "type": "esriFieldTypeInteger", "alias": "TS_QR_Promo_DBI", "domain": null }, { "name": "TS_QR_Promo_DFI", "type": "esriFieldTypeInteger", "alias": "TS_QR_Promo_DFI", "domain": null }, { "name": "TS_QR_Promo_RRR", "type": "esriFieldTypeInteger", "alias": "TS_QR_Promo_RRR", "domain": null }, { "name": "TS_QR_Promo_ASD", "type": "esriFieldTypeInteger", "alias": "TS_QR_Promo_ASD", "domain": null }, { "name": "TS_QR_Promo_ASDA", "type": "esriFieldTypeInteger", "alias": "TS_QR_Promo_ASDA", "domain": null }, { "name": "TS_QR_Promo_SP", "type": "esriFieldTypeInteger", "alias": "TS_QR_Promo_SP", "domain": null }, { "name": "TS_QR_Promo_MSWcom", "type": "esriFieldTypeInteger", "alias": "TS_QR_Promo_MSWcom", "domain": null }, { "name": "TS_QR_Promo_LPP", "type": "esriFieldTypeInteger", "alias": "TS_QR_Promo_LPP", "domain": null }, { "name": "TS_QR_Promo_JWW", "type": "esriFieldTypeInteger", "alias": "TS_QR_Promo_JWW", "domain": null }, { "name": "TS_QR_Promo_GC", "type": "esriFieldTypeInteger", "alias": "TS_QR_Promo_GC", "domain": null }, { "name": "TS_QR_Promo_WS", "type": "esriFieldTypeInteger", "alias": "TS_QR_Promo_WS", "domain": null }, { "name": "TS_QR_Promo_GI", "type": "esriFieldTypeInteger", "alias": "TS_QR_Promo_GI", "domain": null }, { "name": "TS_QR_Promo_FOG", "type": "esriFieldTypeInteger", "alias": "TS_QR_Promo_FOG", "domain": null }, { "name": "TS_QR_Promo_FOGwipes", "type": "esriFieldTypeInteger", "alias": "TS_QR_Promo_FOGwipes", "domain": null }, { "name": "TS_QR_Promo_B", "type": "esriFieldTypeInteger", "alias": "TS_QR_Promo_B", "domain": null }, { "name": "TS_QR_AwFlyer", "type": "esriFieldTypeInteger", "alias": "TS_QR_AwFlyer", "domain": null }, { "name": "TS_QR_FOGAwFlyer", "type": "esriFieldTypeInteger", "alias": "TS_QR_FOGAwFlyer", "domain": null }, { "name": "TS_QR_PressR", "type": "esriFieldTypeInteger", "alias": "TS_QR_PressR", "domain": null }, { "name": "TS_QR_Mailing", "type": "esriFieldTypeInteger", "alias": "TS_QR_Mailing", "domain": null }, { "name": "TS_QR_Ad_LPL", "type": "esriFieldTypeInteger", "alias": "TS_QR_Ad_LPL", "domain": null }, { "name": "TS_QR_Ad_MF", "type": "esriFieldTypeInteger", "alias": "TS_QR_Ad_MF", "domain": null }, { "name": "TS_QR_Ad_MP", "type": "esriFieldTypeInteger", "alias": "TS_QR_Ad_MP", "domain": null }, { "name": "TS_QR_Ad_JB", "type": "esriFieldTypeInteger", "alias": "TS_QR_Ad_JB", "domain": null }, { "name": "TS_QR_Ad_FOG", "type": "esriFieldTypeInteger", "alias": "TS_QR_Ad_FOG", "domain": null }, { "name": "TS_QR_Ad_Notes", "type": "esriFieldTypeString", "alias": "TS_QR_Ad_Notes", "length": 200, "domain": null }, { "name": "TD_Desktop", "type": "esriFieldTypeInteger", "alias": "TD_Desktop", "domain": null }, { "name": "TD_Mobile", "type": "esriFieldTypeInteger", "alias": "TD_Mobile", "domain": null }, { "name": "TD_Tablet", "type": "esriFieldTypeInteger", "alias": "TD_Tablet", "domain": null }, { "name": "TD_Other", "type": "esriFieldTypeString", "alias": "TD_Other", "length": 200, "domain": null }, { "name": "T_PageViews", "type": "esriFieldTypeInteger", "alias": "T_PageViews", "domain": null }, { "name": "T_Visits", "type": "esriFieldTypeInteger", "alias": "T_Visits", "domain": null }, { "name": "T_UniqueV", "type": "esriFieldTypeInteger", "alias": "T_UniqueV", "domain": null }, { "name": "T_Page_Views", "type": "esriFieldTypeInteger", "alias": "T_Page_Views", "domain": null }, { "name": "PC_1", "type": "esriFieldTypeString", "alias": "PC_1", "length": 200, "domain": { "type": "codedValue", "name": "SW_WWW_PopularContent", "description": "StormWater Advertising-Awareness Website PopularContent", "codedValues": [ { "name": "New", "code": "NEW" }, { "name": "Homepage", "code": "HM" }, { "name": "About", "code": "AB" }, { "name": "Regulatory", "code": "REG" }, { "name": "Fees and Billing", "code": "FB" }, { "name": "Community-GreenCamp", "code": "C-GC" }, { "name": "Community- Junior WW", "code": "C-JWW" }, { "name": "Community- Art Contest", "code": "C-LPP" }, { "name": "Community- Public Meeting", "code": "C-PM" }, { "name": "Community", "code": "C" }, { "name": "Take Action- Pollution Prev", "code": "TA-PP" }, { "name": "Take Action", "code": "TA" }, { "name": "Kids", "code": "KIDS" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PC_2", "type": "esriFieldTypeString", "alias": "PC_2", "length": 200, "domain": { "type": "codedValue", "name": "SW_WWW_PopularContent", "description": "StormWater Advertising-Awareness Website PopularContent", "codedValues": [ { "name": "New", "code": "NEW" }, { "name": "Homepage", "code": "HM" }, { "name": "About", "code": "AB" }, { "name": "Regulatory", "code": "REG" }, { "name": "Fees and Billing", "code": "FB" }, { "name": "Community-GreenCamp", "code": "C-GC" }, { "name": "Community- Junior WW", "code": "C-JWW" }, { "name": "Community- Art Contest", "code": "C-LPP" }, { "name": "Community- Public Meeting", "code": "C-PM" }, { "name": "Community", "code": "C" }, { "name": "Take Action- Pollution Prev", "code": "TA-PP" }, { "name": "Take Action", "code": "TA" }, { "name": "Kids", "code": "KIDS" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PC_3", "type": "esriFieldTypeString", "alias": "PC_3", "length": 200, "domain": { "type": "codedValue", "name": "SW_WWW_PopularContent", "description": "StormWater Advertising-Awareness Website PopularContent", "codedValues": [ { "name": "New", "code": "NEW" }, { "name": "Homepage", "code": "HM" }, { "name": "About", "code": "AB" }, { "name": "Regulatory", "code": "REG" }, { "name": "Fees and Billing", "code": "FB" }, { "name": "Community-GreenCamp", "code": "C-GC" }, { "name": "Community- Junior WW", "code": "C-JWW" }, { "name": "Community- Art Contest", "code": "C-LPP" }, { "name": "Community- Public Meeting", "code": "C-PM" }, { "name": "Community", "code": "C" }, { "name": "Take Action- Pollution Prev", "code": "TA-PP" }, { "name": "Take Action", "code": "TA" }, { "name": "Kids", "code": "KIDS" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PC_Pg_View_Percent", "type": "esriFieldTypeString", "alias": "PC_Pg_View_Percent", "length": 100, "domain": null }, { "name": "PC_Seconds_on_Pg", "type": "esriFieldTypeDouble", "alias": "PC_Seconds_on_Pg", "domain": null }, { "name": "PC_Bounce_Rate", "type": "esriFieldTypeDouble", "alias": "PC_Bounce_Rate", "domain": null }, { "name": "PC_Exit_Rate", "type": "esriFieldTypeDouble", "alias": "PC_Exit_Rate", "domain": null }, { "name": "F_ID", "type": "esriFieldTypeInteger", "alias": "F_ID", "domain": null }, { "name": "F_Appeal", "type": "esriFieldTypeInteger", "alias": "F_Appeal", "domain": null }, { "name": "F_ItemEv", "type": "esriFieldTypeInteger", "alias": "F_ItemEv", "domain": null }, { "name": "F_Fee", "type": "esriFieldTypeInteger", "alias": "F_Fee", "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": "R187_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_187", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G3319A_ID", "fields": "A_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "PW_GDB.PWGISEDITOR.PW_SW_Awareness_Ad_Map", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "A_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{2541B549-567C-4428-98F7-861C3CA18958}" } ], "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" }