{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 5, "name": "SW_WWW_Ad_ActivityTable", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 1, "name": "PW_GDB.PWGISEDITOR.PW_SW_Awareness_Ad_Map", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "A_ID", "composite": false, "catalogID": "{2541B549-567C-4428-98F7-861C3CA18958}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "A_ID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "A_ID", "type": "esriFieldTypeString", "alias": "A_ID", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "A_ID" }, { "name": "Start_Date", "type": "esriFieldTypeDate", "alias": "Start_Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Start_Date" }, { "name": "End_Date", "type": "esriFieldTypeDate", "alias": "End_Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "End_Date" }, { "name": "TS_Direct", "type": "esriFieldTypeInteger", "alias": "TS_Direct", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TS_Direct" }, { "name": "T_Search", "type": "esriFieldTypeInteger", "alias": "T_Search", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "T_Search" }, { "name": "TS_Referral", "type": "esriFieldTypeInteger", "alias": "TS_Referral", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TS_Referral" }, { "name": "TS_RefQR", "type": "esriFieldTypeInteger", "alias": "TS_RefQR", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TS_RefQR" }, { "name": "TS_RefNotes", "type": "esriFieldTypeString", "alias": "TS_RefNotes", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "TS_RefNotes" }, { "name": "TS_Social", "type": "esriFieldTypeInteger", "alias": "TS_Social", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TS_Social" }, { "name": "TS_SocNotes", "type": "esriFieldTypeString", "alias": "TS_SocNotes", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "TS_SocNotes" }, { "name": "TS_DisplayAds", "type": "esriFieldTypeInteger", "alias": "TS_DisplayAds", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TS_DisplayAds" }, { "name": "TS_Email", "type": "esriFieldTypeInteger", "alias": "TS_Email", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TS_Email" }, { "name": "TS_GoogleAnalyt", "type": "esriFieldTypeDouble", "alias": "TS_GoogleAnalyt", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TS_GoogleAnalyt" }, { "name": "TS_Notes", "type": "esriFieldTypeString", "alias": "TS_Notes", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "TS_Notes" }, { "name": "TS_QR_Promo_DBI", "type": "esriFieldTypeInteger", "alias": "TS_QR_Promo_DBI", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TS_QR_Promo_DBI" }, { "name": "TS_QR_Promo_DFI", "type": "esriFieldTypeInteger", "alias": "TS_QR_Promo_DFI", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TS_QR_Promo_DFI" }, { "name": "TS_QR_Promo_RRR", "type": "esriFieldTypeInteger", "alias": "TS_QR_Promo_RRR", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TS_QR_Promo_RRR" }, { "name": "TS_QR_Promo_ASD", "type": "esriFieldTypeInteger", "alias": "TS_QR_Promo_ASD", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TS_QR_Promo_ASD" }, { "name": "TS_QR_Promo_ASDA", "type": "esriFieldTypeInteger", "alias": "TS_QR_Promo_ASDA", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TS_QR_Promo_ASDA" }, { "name": "TS_QR_Promo_SP", "type": "esriFieldTypeInteger", "alias": "TS_QR_Promo_SP", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TS_QR_Promo_SP" }, { "name": "TS_QR_Promo_MSWcom", "type": "esriFieldTypeInteger", "alias": "TS_QR_Promo_MSWcom", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TS_QR_Promo_MSWcom" }, { "name": "TS_QR_Promo_LPP", "type": "esriFieldTypeInteger", "alias": "TS_QR_Promo_LPP", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TS_QR_Promo_LPP" }, { "name": "TS_QR_Promo_JWW", "type": "esriFieldTypeInteger", "alias": "TS_QR_Promo_JWW", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TS_QR_Promo_JWW" }, { "name": "TS_QR_Promo_GC", "type": "esriFieldTypeInteger", "alias": "TS_QR_Promo_GC", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TS_QR_Promo_GC" }, { "name": "TS_QR_Promo_WS", "type": "esriFieldTypeInteger", "alias": "TS_QR_Promo_WS", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TS_QR_Promo_WS" }, { "name": "TS_QR_Promo_GI", "type": "esriFieldTypeInteger", "alias": "TS_QR_Promo_GI", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TS_QR_Promo_GI" }, { "name": "TS_QR_Promo_FOG", "type": "esriFieldTypeInteger", "alias": "TS_QR_Promo_FOG", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TS_QR_Promo_FOG" }, { "name": "TS_QR_Promo_FOGwipes", "type": "esriFieldTypeInteger", "alias": "TS_QR_Promo_FOGwipes", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TS_QR_Promo_FOGwipes" }, { "name": "TS_QR_Promo_B", "type": "esriFieldTypeInteger", "alias": "TS_QR_Promo_B", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TS_QR_Promo_B" }, { "name": "TS_QR_AwFlyer", "type": "esriFieldTypeInteger", "alias": "TS_QR_AwFlyer", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TS_QR_AwFlyer" }, { "name": "TS_QR_FOGAwFlyer", "type": "esriFieldTypeInteger", "alias": "TS_QR_FOGAwFlyer", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TS_QR_FOGAwFlyer" }, { "name": "TS_QR_PressR", "type": "esriFieldTypeInteger", "alias": "TS_QR_PressR", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TS_QR_PressR" }, { "name": "TS_QR_Mailing", "type": "esriFieldTypeInteger", "alias": "TS_QR_Mailing", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TS_QR_Mailing" }, { "name": "TS_QR_Ad_LPL", "type": "esriFieldTypeInteger", "alias": "TS_QR_Ad_LPL", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TS_QR_Ad_LPL" }, { "name": "TS_QR_Ad_MF", "type": "esriFieldTypeInteger", "alias": "TS_QR_Ad_MF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TS_QR_Ad_MF" }, { "name": "TS_QR_Ad_MP", "type": "esriFieldTypeInteger", "alias": "TS_QR_Ad_MP", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TS_QR_Ad_MP" }, { "name": "TS_QR_Ad_JB", "type": "esriFieldTypeInteger", "alias": "TS_QR_Ad_JB", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TS_QR_Ad_JB" }, { "name": "TS_QR_Ad_FOG", "type": "esriFieldTypeInteger", "alias": "TS_QR_Ad_FOG", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TS_QR_Ad_FOG" }, { "name": "TS_QR_Ad_Notes", "type": "esriFieldTypeString", "alias": "TS_QR_Ad_Notes", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "TS_QR_Ad_Notes" }, { "name": "TD_Desktop", "type": "esriFieldTypeInteger", "alias": "TD_Desktop", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TD_Desktop" }, { "name": "TD_Mobile", "type": "esriFieldTypeInteger", "alias": "TD_Mobile", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TD_Mobile" }, { "name": "TD_Tablet", "type": "esriFieldTypeInteger", "alias": "TD_Tablet", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TD_Tablet" }, { "name": "TD_Other", "type": "esriFieldTypeString", "alias": "TD_Other", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "TD_Other" }, { "name": "T_PageViews", "type": "esriFieldTypeInteger", "alias": "T_PageViews", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "T_PageViews" }, { "name": "T_Visits", "type": "esriFieldTypeInteger", "alias": "T_Visits", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "T_Visits" }, { "name": "T_UniqueV", "type": "esriFieldTypeInteger", "alias": "T_UniqueV", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "T_UniqueV" }, { "name": "T_Page_Views", "type": "esriFieldTypeInteger", "alias": "T_Page_Views", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "T_Page_Views" }, { "name": "PC_1", "type": "esriFieldTypeString", "alias": "PC_1", "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" }, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "PC_1" }, { "name": "PC_2", "type": "esriFieldTypeString", "alias": "PC_2", "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" }, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "PC_2" }, { "name": "PC_3", "type": "esriFieldTypeString", "alias": "PC_3", "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" }, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "PC_3" }, { "name": "PC_Pg_View_Percent", "type": "esriFieldTypeString", "alias": "PC_Pg_View_Percent", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "PC_Pg_View_Percent" }, { "name": "PC_Seconds_on_Pg", "type": "esriFieldTypeDouble", "alias": "PC_Seconds_on_Pg", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PC_Seconds_on_Pg" }, { "name": "PC_Bounce_Rate", "type": "esriFieldTypeDouble", "alias": "PC_Bounce_Rate", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PC_Bounce_Rate" }, { "name": "PC_Exit_Rate", "type": "esriFieldTypeDouble", "alias": "PC_Exit_Rate", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PC_Exit_Rate" }, { "name": "F_ID", "type": "esriFieldTypeInteger", "alias": "F_ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "F_ID" }, { "name": "F_Appeal", "type": "esriFieldTypeInteger", "alias": "F_Appeal", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "F_Appeal" }, { "name": "F_ItemEv", "type": "esriFieldTypeInteger", "alias": "F_ItemEv", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "F_ItemEv" }, { "name": "F_Fee", "type": "esriFieldTypeInteger", "alias": "F_Fee", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "F_Fee" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "SW_WWW_Ad_ActivityTable", "description": "", "prototype": { "attributes": { "F_Fee": null, "F_ItemEv": null, "A_ID": null, "Start_Date": null, "End_Date": null, "TS_Direct": null, "T_Search": null, "TS_Referral": null, "TS_RefQR": null, "TS_RefNotes": null, "TS_Social": null, "TS_SocNotes": null, "TS_DisplayAds": null, "TS_Email": null, "TS_GoogleAnalyt": null, "TS_Notes": null, "TS_QR_Promo_DBI": null, "TS_QR_Promo_DFI": null, "TS_QR_Promo_RRR": null, "TS_QR_Promo_ASD": null, "TS_QR_Promo_ASDA": null, "TS_QR_Promo_SP": null, "TS_QR_Promo_MSWcom": null, "TS_QR_Promo_LPP": null, "TS_QR_Promo_JWW": null, "TS_QR_Promo_GC": null, "TS_QR_Promo_WS": null, "TS_QR_Promo_GI": null, "TS_QR_Promo_FOG": null, "TS_QR_Promo_FOGwipes": null, "TS_QR_Promo_B": null, "TS_QR_AwFlyer": null, "TS_QR_FOGAwFlyer": null, "TS_QR_PressR": null, "TS_QR_Mailing": null, "TS_QR_Ad_LPL": null, "TS_QR_Ad_MF": null, "TS_QR_Ad_MP": null, "TS_QR_Ad_JB": null, "TS_QR_Ad_FOG": null, "TS_QR_Ad_Notes": null, "TD_Desktop": null, "TD_Mobile": null, "TD_Tablet": null, "TD_Other": null, "T_PageViews": null, "T_Visits": null, "T_UniqueV": null, "T_Page_Views": null, "PC_1": null, "PC_2": null, "PC_3": null, "PC_Pg_View_Percent": null, "PC_Seconds_on_Pg": null, "PC_Bounce_Rate": null, "PC_Exit_Rate": null, "F_ID": null, "F_Appeal": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "f06fa64d351d436e9aa37a4bb92c5e9b" }