Name: SW_WWW_Ad_ActivityTable

Display Field: A_ID

Type: Table

Geometry Type: N/A

Description:

Service Item Id: f06fa64d351d436e9aa37a4bb92c5e9b

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• A_ID ( type: esriFieldTypeString, alias: A_ID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: A_ID )
• Start_Date ( type: esriFieldTypeDate, alias: Start_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Start_Date )
• End_Date ( type: esriFieldTypeDate, alias: End_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: End_Date )
• TS_Direct ( type: esriFieldTypeInteger, alias: TS_Direct, editable: true, nullable: true, defaultValue: null, modelName: TS_Direct )
• T_Search ( type: esriFieldTypeInteger, alias: T_Search, editable: true, nullable: true, defaultValue: null, modelName: T_Search )
• TS_Referral ( type: esriFieldTypeInteger, alias: TS_Referral, editable: true, nullable: true, defaultValue: null, modelName: TS_Referral )
• TS_RefQR ( type: esriFieldTypeInteger, alias: TS_RefQR, editable: true, nullable: true, defaultValue: null, modelName: TS_RefQR )
• TS_RefNotes ( type: esriFieldTypeString, alias: TS_RefNotes, editable: true, nullable: true, length: 200, defaultValue: null, modelName: TS_RefNotes )
• TS_Social ( type: esriFieldTypeInteger, alias: TS_Social, editable: true, nullable: true, defaultValue: null, modelName: TS_Social )
• TS_SocNotes ( type: esriFieldTypeString, alias: TS_SocNotes, editable: true, nullable: true, length: 200, defaultValue: null, modelName: TS_SocNotes )
• TS_DisplayAds ( type: esriFieldTypeInteger, alias: TS_DisplayAds, editable: true, nullable: true, defaultValue: null, modelName: TS_DisplayAds )
• TS_Email ( type: esriFieldTypeInteger, alias: TS_Email, editable: true, nullable: true, defaultValue: null, modelName: TS_Email )
• TS_GoogleAnalyt ( type: esriFieldTypeDouble, alias: TS_GoogleAnalyt, editable: true, nullable: true, defaultValue: null, modelName: TS_GoogleAnalyt )
• TS_Notes ( type: esriFieldTypeString, alias: TS_Notes, editable: true, nullable: true, length: 200, defaultValue: null, modelName: TS_Notes )
• TS_QR_Promo_DBI ( type: esriFieldTypeInteger, alias: TS_QR_Promo_DBI, editable: true, nullable: true, defaultValue: null, modelName: TS_QR_Promo_DBI )
• TS_QR_Promo_DFI ( type: esriFieldTypeInteger, alias: TS_QR_Promo_DFI, editable: true, nullable: true, defaultValue: null, modelName: TS_QR_Promo_DFI )
• TS_QR_Promo_RRR ( type: esriFieldTypeInteger, alias: TS_QR_Promo_RRR, editable: true, nullable: true, defaultValue: null, modelName: TS_QR_Promo_RRR )
• TS_QR_Promo_ASD ( type: esriFieldTypeInteger, alias: TS_QR_Promo_ASD, editable: true, nullable: true, defaultValue: null, modelName: TS_QR_Promo_ASD )
• TS_QR_Promo_ASDA ( type: esriFieldTypeInteger, alias: TS_QR_Promo_ASDA, editable: true, nullable: true, defaultValue: null, modelName: TS_QR_Promo_ASDA )
• TS_QR_Promo_SP ( type: esriFieldTypeInteger, alias: TS_QR_Promo_SP, editable: true, nullable: true, defaultValue: null, modelName: TS_QR_Promo_SP )
• TS_QR_Promo_MSWcom ( type: esriFieldTypeInteger, alias: TS_QR_Promo_MSWcom, editable: true, nullable: true, defaultValue: null, modelName: TS_QR_Promo_MSWcom )
• TS_QR_Promo_LPP ( type: esriFieldTypeInteger, alias: TS_QR_Promo_LPP, editable: true, nullable: true, defaultValue: null, modelName: TS_QR_Promo_LPP )
• TS_QR_Promo_JWW ( type: esriFieldTypeInteger, alias: TS_QR_Promo_JWW, editable: true, nullable: true, defaultValue: null, modelName: TS_QR_Promo_JWW )
• TS_QR_Promo_GC ( type: esriFieldTypeInteger, alias: TS_QR_Promo_GC, editable: true, nullable: true, defaultValue: null, modelName: TS_QR_Promo_GC )
• TS_QR_Promo_WS ( type: esriFieldTypeInteger, alias: TS_QR_Promo_WS, editable: true, nullable: true, defaultValue: null, modelName: TS_QR_Promo_WS )
• TS_QR_Promo_GI ( type: esriFieldTypeInteger, alias: TS_QR_Promo_GI, editable: true, nullable: true, defaultValue: null, modelName: TS_QR_Promo_GI )
• TS_QR_Promo_FOG ( type: esriFieldTypeInteger, alias: TS_QR_Promo_FOG, editable: true, nullable: true, defaultValue: null, modelName: TS_QR_Promo_FOG )
• TS_QR_Promo_FOGwipes ( type: esriFieldTypeInteger, alias: TS_QR_Promo_FOGwipes, editable: true, nullable: true, defaultValue: null, modelName: TS_QR_Promo_FOGwipes )
• TS_QR_Promo_B ( type: esriFieldTypeInteger, alias: TS_QR_Promo_B, editable: true, nullable: true, defaultValue: null, modelName: TS_QR_Promo_B )
• TS_QR_AwFlyer ( type: esriFieldTypeInteger, alias: TS_QR_AwFlyer, editable: true, nullable: true, defaultValue: null, modelName: TS_QR_AwFlyer )
• TS_QR_FOGAwFlyer ( type: esriFieldTypeInteger, alias: TS_QR_FOGAwFlyer, editable: true, nullable: true, defaultValue: null, modelName: TS_QR_FOGAwFlyer )
• TS_QR_PressR ( type: esriFieldTypeInteger, alias: TS_QR_PressR, editable: true, nullable: true, defaultValue: null, modelName: TS_QR_PressR )
• TS_QR_Mailing ( type: esriFieldTypeInteger, alias: TS_QR_Mailing, editable: true, nullable: true, defaultValue: null, modelName: TS_QR_Mailing )
• TS_QR_Ad_LPL ( type: esriFieldTypeInteger, alias: TS_QR_Ad_LPL, editable: true, nullable: true, defaultValue: null, modelName: TS_QR_Ad_LPL )
• TS_QR_Ad_MF ( type: esriFieldTypeInteger, alias: TS_QR_Ad_MF, editable: true, nullable: true, defaultValue: null, modelName: TS_QR_Ad_MF )
• TS_QR_Ad_MP ( type: esriFieldTypeInteger, alias: TS_QR_Ad_MP, editable: true, nullable: true, defaultValue: null, modelName: TS_QR_Ad_MP )
• TS_QR_Ad_JB ( type: esriFieldTypeInteger, alias: TS_QR_Ad_JB, editable: true, nullable: true, defaultValue: null, modelName: TS_QR_Ad_JB )
• TS_QR_Ad_FOG ( type: esriFieldTypeInteger, alias: TS_QR_Ad_FOG, editable: true, nullable: true, defaultValue: null, modelName: TS_QR_Ad_FOG )
• TS_QR_Ad_Notes ( type: esriFieldTypeString, alias: TS_QR_Ad_Notes, editable: true, nullable: true, length: 200, defaultValue: null, modelName: TS_QR_Ad_Notes )
• TD_Desktop ( type: esriFieldTypeInteger, alias: TD_Desktop, editable: true, nullable: true, defaultValue: null, modelName: TD_Desktop )
• TD_Mobile ( type: esriFieldTypeInteger, alias: TD_Mobile, editable: true, nullable: true, defaultValue: null, modelName: TD_Mobile )
• TD_Tablet ( type: esriFieldTypeInteger, alias: TD_Tablet, editable: true, nullable: true, defaultValue: null, modelName: TD_Tablet )
• TD_Other ( type: esriFieldTypeString, alias: TD_Other, editable: true, nullable: true, length: 200, defaultValue: null, modelName: TD_Other )
• T_PageViews ( type: esriFieldTypeInteger, alias: T_PageViews, editable: true, nullable: true, defaultValue: null, modelName: T_PageViews )
• T_Visits ( type: esriFieldTypeInteger, alias: T_Visits, editable: true, nullable: true, defaultValue: null, modelName: T_Visits )
• T_UniqueV ( type: esriFieldTypeInteger, alias: T_UniqueV, editable: true, nullable: true, defaultValue: null, modelName: T_UniqueV )
• T_Page_Views ( type: esriFieldTypeInteger, alias: T_Page_Views, editable: true, nullable: true, defaultValue: null, modelName: T_Page_Views )
• PC_1 ( type: esriFieldTypeString, alias: PC_1, editable: true, nullable: true, length: 200, defaultValue: null, modelName: PC_1 , Coded Values: [NEW: New] , [HM: Homepage] , [AB: About] , ...10 more... )
• PC_2 ( type: esriFieldTypeString, alias: PC_2, editable: true, nullable: true, length: 200, defaultValue: null, modelName: PC_2 , Coded Values: [NEW: New] , [HM: Homepage] , [AB: About] , ...10 more... )
• PC_3 ( type: esriFieldTypeString, alias: PC_3, editable: true, nullable: true, length: 200, defaultValue: null, modelName: PC_3 , Coded Values: [NEW: New] , [HM: Homepage] , [AB: About] , ...10 more... )
• PC_Pg_View_Percent ( type: esriFieldTypeString, alias: PC_Pg_View_Percent, editable: true, nullable: true, length: 100, defaultValue: null, modelName: PC_Pg_View_Percent )
• PC_Seconds_on_Pg ( type: esriFieldTypeDouble, alias: PC_Seconds_on_Pg, editable: true, nullable: true, defaultValue: null, modelName: PC_Seconds_on_Pg )
• PC_Bounce_Rate ( type: esriFieldTypeDouble, alias: PC_Bounce_Rate, editable: true, nullable: true, defaultValue: null, modelName: PC_Bounce_Rate )
• PC_Exit_Rate ( type: esriFieldTypeDouble, alias: PC_Exit_Rate, editable: true, nullable: true, defaultValue: null, modelName: PC_Exit_Rate )
• F_ID ( type: esriFieldTypeInteger, alias: F_ID, editable: true, nullable: true, defaultValue: null, modelName: F_ID )
• F_Appeal ( type: esriFieldTypeInteger, alias: F_Appeal, editable: true, nullable: true, defaultValue: null, modelName: F_Appeal )
• F_ItemEv ( type: esriFieldTypeInteger, alias: F_ItemEv, editable: true, nullable: true, defaultValue: null, modelName: F_ItemEv )
• F_Fee ( type: esriFieldTypeInteger, alias: F_Fee, editable: true, nullable: true, defaultValue: null, modelName: F_Fee )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )

Templates:

• Name: SW_WWW_Ad_ActivityTable
  Description:
  Prototype:
  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
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• PW_GDB.PWGISEDITOR.PW_SW_Awareness_Ad_Map (1) -- Related To: SW_Advertisements (1)

Capabilities: Query,Create,Update,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata