{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 3, "name": "SW_VoiceMail_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": "VM_Num", "type": "esriFieldTypeString", "alias": "VM_Num", "length": 25, "domain": { "type": "codedValue", "name": "SW_VM_Number", "description": "StormWater Advertising-Awareness Voicemail Number", "codedValues": [ { "name": "New", "code": "NEW" }, { "name": "636-4349", "code": "4349" }, { "name": "636-6721", "code": "6721" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Caller_Num", "type": "esriFieldTypeString", "alias": "Caller_Num", "length": 25, "domain": null }, { "name": "Call_Date", "type": "esriFieldTypeDate", "alias": "Call_Date", "length": 8, "domain": null }, { "name": "Recd_Date", "type": "esriFieldTypeDate", "alias": "Recd_Date", "length": 8, "domain": null }, { "name": "Call_Concern", "type": "esriFieldTypeString", "alias": "Call_Concern", "length": 50, "domain": { "type": "codedValue", "name": "SW_VM_CallConcern", "description": "StormWater Advertising-Awareness Caller Concern", "codedValues": [ { "name": "Other", "code": "OTHER" }, { "name": "SW Fee Concern", "code": "SW_Fee" }, { "name": "SW Courtesy Letter", "code": "SW_CL" }, { "name": "SW Ed-Promo Request", "code": "SW_EdPr" }, { "name": "SW Other", "code": "SW_Other" }, { "name": "SW Pollution Concern", "code": "SW_PC" }, { "name": "Code Concern", "code": "CODE" }, { "name": "Drain Mt Concern", "code": "DM" }, { "name": "MLGW Concern", "code": "MLGW" }, { "name": "Hang Up", "code": "HU" }, { "name": "Solid Waste Concern", "code": "TRASH" }, { "name": "Env Mnt Concern", "code": "SEWER" }, { "name": "No Action", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Call_Notes", "type": "esriFieldTypeString", "alias": "Call_Notes", "length": 200, "domain": null }, { "name": "MATERIAL", "type": "esriFieldTypeInteger", "alias": "MATERIAL", "domain": { "type": "codedValue", "name": "SWMATERIAL", "description": "SWMATERIAL", "codedValues": [ { "name": "UNKNOWN", "code": 0 }, { "name": "TRASH", "code": 1 }, { "name": "CONSTRUCTION MATERIALS", "code": 2 }, { "name": "PETROLEUM PRODUCTS", "code": 3 }, { "name": "PAINT", "code": 10 }, { "name": "SOAP DETERGENT AMMONIA", "code": 15 }, { "name": "ANIMAL WASTE", "code": 19 }, { "name": "SANITARY SEWER", "code": 20 }, { "name": "FOOD WASTE", "code": 23 }, { "name": "LAWN WASTE", "code": 26 }, { "name": "SILT GRAVEL SEDIMENT", "code": 27 }, { "name": "CHEMICALS", "code": 29 }, { "name": "OTHER", "code": 99 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Action_Sum", "type": "esriFieldTypeString", "alias": "Action_Sum", "length": 75, "domain": { "type": "codedValue", "name": "SW_VM_Action_Sum", "description": "StormWater Advertising-Awareness Action Summary", "codedValues": [ { "name": "Other", "code": "OTHER" }, { "name": "Called Back", "code": "CB" }, { "name": "Called Back- Ref2CorrectDept", "code": "CB-Refer" }, { "name": "Called Back- LeftMessage", "code": "CB-LM" }, { "name": "Called Back- No Message Opt", "code": "CB-NMO" }, { "name": "Referred to SW Staff", "code": "SW_Refer" }, { "name": "SW Ref2CorrectDept", "code": "SW-RefDept" }, { "name": "None", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Promo_Item1_Qty", "type": "esriFieldTypeInteger", "alias": "Promo_Item1_Qty", "domain": null }, { "name": "Promo_Item2_Qty", "type": "esriFieldTypeInteger", "alias": "Promo_Item2_Qty", "domain": null }, { "name": "Promo_Item3_Qty", "type": "esriFieldTypeInteger", "alias": "Promo_Item3_Qty", "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 }, { "name": "Promo_Item1", "type": "esriFieldTypeString", "alias": "Promo_Item1", "length": 255, "domain": { "type": "codedValue", "name": "SW_PromoItems", "description": "List of StormWater Promo Items", "codedValues": [ { "name": "A NEW ITEM", "code": "A NEW ITEM" }, { "name": "ADOPT_DownstreamFriend", "code": "ADOPT_DownstreamFriend" }, { "name": "ADOPT_Keychain", "code": "ADOPT_Keychain" }, { "name": "CL_Drain Placards", "code": "CL_Drain Placards" }, { "name": "CL_Gloves", "code": "CL_Gloves" }, { "name": "CL_Trash Bags", "code": "CL_Trash Bags" }, { "name": "CL_Trash Grabber", "code": "CL_Trash Grabber" }, { "name": "CL_T-Shirt_ awareness", "code": "CL_T-Shirt_ awareness" }, { "name": "DBI_LED Fan", "code": "DBI_LED Fan" }, { "name": "DFI_Auto Trash Cans", "code": "DFI_Auto Trash Cans" }, { "name": "GEN_16 pg booklet", "code": "GEN_16 pg booklet" }, { "name": "GEN_Brochures", "code": "GEN_Brochures" }, { "name": "GEN_Collapsible Straws", "code": "GEN_Collapsible Straws" }, { "name": "GEN_Fans", "code": "GEN_Fans" }, { "name": "GEN_Flyers", "code": "GEN_Flyers" }, { "name": "GEN_Keychain-General", "code": "GEN_Keychain-General" }, { "name": "GEN_Keychain-watershed", "code": "GEN_Keychain-watershed" }, { "name": "GEN_Lanyard", "code": "GEN_Lanyard" }, { "name": "GEN_Notebooks", "code": "GEN_Notebooks" }, { "name": "GEN_Outdoor Spray Kit", "code": "GEN_Outdoor Spray Kit" }, { "name": "GEN_Raffle Item", "code": "GEN_Raffle Item" }, { "name": "GEN_Reusable bottle", "code": "GEN_Reusable bottle" }, { "name": "GEN_Stress ball", "code": "GEN_Stress ball" }, { "name": "GEN_Stylus Pens", "code": "GEN_Stylus Pens" }, { "name": "GEN_ThumbDrive", "code": "GEN_ThumbDrive" }, { "name": "GEN_Totes-General", "code": "GEN_Totes-General" }, { "name": "GEN_Umbrella", "code": "GEN_Umbrella" }, { "name": "GEN_Vinyl Campaign Stickers", "code": "GEN_Vinyl Campaign Stickers" }, { "name": "GREEN_Backpack", "code": "GREEN_Backpack" }, { "name": "GREEN_Keychain", "code": "GREEN_Keychain" }, { "name": "GREEN_Tshirt", "code": "GREEN_Tshirt" }, { "name": "GREEN_Waterbottle", "code": "GREEN_Waterbottle" }, { "name": "JWW_Pen", "code": "JWW_Pen" }, { "name": "JWW_ThumbDrive", "code": "JWW_ThumbDrive" }, { "name": "JWW_Waterbottle", "code": "JWW_Waterbottle" }, { "name": "KIDS_Button Craft", "code": "KIDS_Button Craft" }, { "name": "KIDS_Coloring Book", "code": "KIDS_Coloring Book" }, { "name": "KIDS_erasers", "code": "KIDS_erasers" }, { "name": "KIDS_Notebooks", "code": "KIDS_Notebooks" }, { "name": "KIDS_Pencil Pouch", "code": "KIDS_Pencil Pouch" }, { "name": "KIDS_pencils", "code": "KIDS_pencils" }, { "name": "KIDS_Pollution Preventer Sticker", "code": "KIDS_Pollution Preventer Sticker" }, { "name": "KIDS_Prize", "code": "KIDS_Prize" }, { "name": "KIDS_Project Supplies", "code": "KIDS_Project Supplies" }, { "name": "KIDS_Puzzle", "code": "KIDS_Puzzle" }, { "name": "KIDS_sharpeners", "code": "KIDS_sharpeners" }, { "name": "KIDS_Sticker Sheet", "code": "KIDS_Sticker Sheet" }, { "name": "KIDS_Tattoos", "code": "KIDS_Tattoos" }, { "name": "KIDS_Vinyl Campaign Stickers", "code": "KIDS_Vinyl Campaign Stickers" }, { "name": "LPP_Medal", "code": "LPP_Medal" }, { "name": "LPP_Trophy", "code": "LPP_Trophy" }, { "name": "RRR_Coasters", "code": "RRR_Coasters" }, { "name": "RRR_Totes", "code": "RRR_Totes" }, { "name": "RRR_Waterbottle", "code": "RRR_Waterbottle" }, { "name": "SP_Collapsible bowl", "code": "SP_Collapsible bowl" }, { "name": "SP_Keychain", "code": "SP_Keychain" }, { "name": "SP_Pet Bandana", "code": "SP_Pet Bandana" }, { "name": "SP_Pet Waste Bags", "code": "SP_Pet Waste Bags" }, { "name": "SP_Signs Stakes", "code": "SP_Signs Stakes" }, { "name": "WS- Watershed Magnet", "code": "WS_Bumper Magnet" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Promo_Item2", "type": "esriFieldTypeString", "alias": "Promo_Item2", "length": 255, "domain": { "type": "codedValue", "name": "SW_PromoItems", "description": "List of StormWater Promo Items", "codedValues": [ { "name": "A NEW ITEM", "code": "A NEW ITEM" }, { "name": "ADOPT_DownstreamFriend", "code": "ADOPT_DownstreamFriend" }, { "name": "ADOPT_Keychain", "code": "ADOPT_Keychain" }, { "name": "CL_Drain Placards", "code": "CL_Drain Placards" }, { "name": "CL_Gloves", "code": "CL_Gloves" }, { "name": "CL_Trash Bags", "code": "CL_Trash Bags" }, { "name": "CL_Trash Grabber", "code": "CL_Trash Grabber" }, { "name": "CL_T-Shirt_ awareness", "code": "CL_T-Shirt_ awareness" }, { "name": "DBI_LED Fan", "code": "DBI_LED Fan" }, { "name": "DFI_Auto Trash Cans", "code": "DFI_Auto Trash Cans" }, { "name": "GEN_16 pg booklet", "code": "GEN_16 pg booklet" }, { "name": "GEN_Brochures", "code": "GEN_Brochures" }, { "name": "GEN_Collapsible Straws", "code": "GEN_Collapsible Straws" }, { "name": "GEN_Fans", "code": "GEN_Fans" }, { "name": "GEN_Flyers", "code": "GEN_Flyers" }, { "name": "GEN_Keychain-General", "code": "GEN_Keychain-General" }, { "name": "GEN_Keychain-watershed", "code": "GEN_Keychain-watershed" }, { "name": "GEN_Lanyard", "code": "GEN_Lanyard" }, { "name": "GEN_Notebooks", "code": "GEN_Notebooks" }, { "name": "GEN_Outdoor Spray Kit", "code": "GEN_Outdoor Spray Kit" }, { "name": "GEN_Raffle Item", "code": "GEN_Raffle Item" }, { "name": "GEN_Reusable bottle", "code": "GEN_Reusable bottle" }, { "name": "GEN_Stress ball", "code": "GEN_Stress ball" }, { "name": "GEN_Stylus Pens", "code": "GEN_Stylus Pens" }, { "name": "GEN_ThumbDrive", "code": "GEN_ThumbDrive" }, { "name": "GEN_Totes-General", "code": "GEN_Totes-General" }, { "name": "GEN_Umbrella", "code": "GEN_Umbrella" }, { "name": "GEN_Vinyl Campaign Stickers", "code": "GEN_Vinyl Campaign Stickers" }, { "name": "GREEN_Backpack", "code": "GREEN_Backpack" }, { "name": "GREEN_Keychain", "code": "GREEN_Keychain" }, { "name": "GREEN_Tshirt", "code": "GREEN_Tshirt" }, { "name": "GREEN_Waterbottle", "code": "GREEN_Waterbottle" }, { "name": "JWW_Pen", "code": "JWW_Pen" }, { "name": "JWW_ThumbDrive", "code": "JWW_ThumbDrive" }, { "name": "JWW_Waterbottle", "code": "JWW_Waterbottle" }, { "name": "KIDS_Button Craft", "code": "KIDS_Button Craft" }, { "name": "KIDS_Coloring Book", "code": "KIDS_Coloring Book" }, { "name": "KIDS_erasers", "code": "KIDS_erasers" }, { "name": "KIDS_Notebooks", "code": "KIDS_Notebooks" }, { "name": "KIDS_Pencil Pouch", "code": "KIDS_Pencil Pouch" }, { "name": "KIDS_pencils", "code": "KIDS_pencils" }, { "name": "KIDS_Pollution Preventer Sticker", "code": "KIDS_Pollution Preventer Sticker" }, { "name": "KIDS_Prize", "code": "KIDS_Prize" }, { "name": "KIDS_Project Supplies", "code": "KIDS_Project Supplies" }, { "name": "KIDS_Puzzle", "code": "KIDS_Puzzle" }, { "name": "KIDS_sharpeners", "code": "KIDS_sharpeners" }, { "name": "KIDS_Sticker Sheet", "code": "KIDS_Sticker Sheet" }, { "name": "KIDS_Tattoos", "code": "KIDS_Tattoos" }, { "name": "KIDS_Vinyl Campaign Stickers", "code": "KIDS_Vinyl Campaign Stickers" }, { "name": "LPP_Medal", "code": "LPP_Medal" }, { "name": "LPP_Trophy", "code": "LPP_Trophy" }, { "name": "RRR_Coasters", "code": "RRR_Coasters" }, { "name": "RRR_Totes", "code": "RRR_Totes" }, { "name": "RRR_Waterbottle", "code": "RRR_Waterbottle" }, { "name": "SP_Collapsible bowl", "code": "SP_Collapsible bowl" }, { "name": "SP_Keychain", "code": "SP_Keychain" }, { "name": "SP_Pet Bandana", "code": "SP_Pet Bandana" }, { "name": "SP_Pet Waste Bags", "code": "SP_Pet Waste Bags" }, { "name": "SP_Signs Stakes", "code": "SP_Signs Stakes" }, { "name": "WS- Watershed Magnet", "code": "WS_Bumper Magnet" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Promo_Item3", "type": "esriFieldTypeString", "alias": "Promo_Item3", "length": 255, "domain": { "type": "codedValue", "name": "SW_PromoItems", "description": "List of StormWater Promo Items", "codedValues": [ { "name": "A NEW ITEM", "code": "A NEW ITEM" }, { "name": "ADOPT_DownstreamFriend", "code": "ADOPT_DownstreamFriend" }, { "name": "ADOPT_Keychain", "code": "ADOPT_Keychain" }, { "name": "CL_Drain Placards", "code": "CL_Drain Placards" }, { "name": "CL_Gloves", "code": "CL_Gloves" }, { "name": "CL_Trash Bags", "code": "CL_Trash Bags" }, { "name": "CL_Trash Grabber", "code": "CL_Trash Grabber" }, { "name": "CL_T-Shirt_ awareness", "code": "CL_T-Shirt_ awareness" }, { "name": "DBI_LED Fan", "code": "DBI_LED Fan" }, { "name": "DFI_Auto Trash Cans", "code": "DFI_Auto Trash Cans" }, { "name": "GEN_16 pg booklet", "code": "GEN_16 pg booklet" }, { "name": "GEN_Brochures", "code": "GEN_Brochures" }, { "name": "GEN_Collapsible Straws", "code": "GEN_Collapsible Straws" }, { "name": "GEN_Fans", "code": "GEN_Fans" }, { "name": "GEN_Flyers", "code": "GEN_Flyers" }, { "name": "GEN_Keychain-General", "code": "GEN_Keychain-General" }, { "name": "GEN_Keychain-watershed", "code": "GEN_Keychain-watershed" }, { "name": "GEN_Lanyard", "code": "GEN_Lanyard" }, { "name": "GEN_Notebooks", "code": "GEN_Notebooks" }, { "name": "GEN_Outdoor Spray Kit", "code": "GEN_Outdoor Spray Kit" }, { "name": "GEN_Raffle Item", "code": "GEN_Raffle Item" }, { "name": "GEN_Reusable bottle", "code": "GEN_Reusable bottle" }, { "name": "GEN_Stress ball", "code": "GEN_Stress ball" }, { "name": "GEN_Stylus Pens", "code": "GEN_Stylus Pens" }, { "name": "GEN_ThumbDrive", "code": "GEN_ThumbDrive" }, { "name": "GEN_Totes-General", "code": "GEN_Totes-General" }, { "name": "GEN_Umbrella", "code": "GEN_Umbrella" }, { "name": "GEN_Vinyl Campaign Stickers", "code": "GEN_Vinyl Campaign Stickers" }, { "name": "GREEN_Backpack", "code": "GREEN_Backpack" }, { "name": "GREEN_Keychain", "code": "GREEN_Keychain" }, { "name": "GREEN_Tshirt", "code": "GREEN_Tshirt" }, { "name": "GREEN_Waterbottle", "code": "GREEN_Waterbottle" }, { "name": "JWW_Pen", "code": "JWW_Pen" }, { "name": "JWW_ThumbDrive", "code": "JWW_ThumbDrive" }, { "name": "JWW_Waterbottle", "code": "JWW_Waterbottle" }, { "name": "KIDS_Button Craft", "code": "KIDS_Button Craft" }, { "name": "KIDS_Coloring Book", "code": "KIDS_Coloring Book" }, { "name": "KIDS_erasers", "code": "KIDS_erasers" }, { "name": "KIDS_Notebooks", "code": "KIDS_Notebooks" }, { "name": "KIDS_Pencil Pouch", "code": "KIDS_Pencil Pouch" }, { "name": "KIDS_pencils", "code": "KIDS_pencils" }, { "name": "KIDS_Pollution Preventer Sticker", "code": "KIDS_Pollution Preventer Sticker" }, { "name": "KIDS_Prize", "code": "KIDS_Prize" }, { "name": "KIDS_Project Supplies", "code": "KIDS_Project Supplies" }, { "name": "KIDS_Puzzle", "code": "KIDS_Puzzle" }, { "name": "KIDS_sharpeners", "code": "KIDS_sharpeners" }, { "name": "KIDS_Sticker Sheet", "code": "KIDS_Sticker Sheet" }, { "name": "KIDS_Tattoos", "code": "KIDS_Tattoos" }, { "name": "KIDS_Vinyl Campaign Stickers", "code": "KIDS_Vinyl Campaign Stickers" }, { "name": "LPP_Medal", "code": "LPP_Medal" }, { "name": "LPP_Trophy", "code": "LPP_Trophy" }, { "name": "RRR_Coasters", "code": "RRR_Coasters" }, { "name": "RRR_Totes", "code": "RRR_Totes" }, { "name": "RRR_Waterbottle", "code": "RRR_Waterbottle" }, { "name": "SP_Collapsible bowl", "code": "SP_Collapsible bowl" }, { "name": "SP_Keychain", "code": "SP_Keychain" }, { "name": "SP_Pet Bandana", "code": "SP_Pet Bandana" }, { "name": "SP_Pet Waste Bags", "code": "SP_Pet Waste Bags" }, { "name": "SP_Signs Stakes", "code": "SP_Signs Stakes" }, { "name": "WS- Watershed Magnet", "code": "WS_Bumper Magnet" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R186_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_186", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G3318A_ID", "fields": "A_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "PW_GDB.PWGISEDITOR.PW_SW_Awareness_Ad_Map", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "A_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{03A36F5B-966E-4A83-9084-F8A1BB208866}" } ], "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" }