{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 64, "name": "sde_geopipe.GNG.PPM_TASK", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "CreatedBy", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJEKTID", "domain": null }, { "name": "GID", "type": "esriFieldTypeGlobalID", "alias": "Globalt ID", "length": 38, "domain": null }, { "name": "CreationDate", "type": "esriFieldTypeDate", "alias": "Skapad datum", "length": 8, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "Skapad av", "length": 256, "domain": null }, { "name": "ModificationDate", "type": "esriFieldTypeDate", "alias": "Uppdaterad datum", "length": 8, "domain": null }, { "name": "LastModifiedBy", "type": "esriFieldTypeString", "alias": "Senast uppdaterad av", "length": 256, "domain": null }, { "name": "Location", "type": "esriFieldTypeInteger", "alias": "Plats", "domain": { "type": "codedValue", "name": "WS6_PPM_LOCATION", "description": "", "codedValues": [ { "name": "EDSVALLA", "code": 1 }, { "name": "HYNBOHOLM", "code": 2 }, { "name": "KARLSTAD", "code": 3 }, { "name": "MOLKOM", "code": 4 }, { "name": "SKATTKÄRR", "code": 5 }, { "name": "SKÅRE", "code": 6 }, { "name": "VALLARGÄRDET", "code": 7 }, { "name": "VÅLBERG", "code": 8 }, { "name": "VÄSE", "code": 9 }, { "name": "ÄLVSBACKA", "code": 10 }, { "name": "LINDFORS", "code": 12 }, { "name": "BLOMBACKA", "code": 11 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LocationAddress", "type": "esriFieldTypeString", "alias": "Adress", "length": 110, "domain": null }, { "name": "LocationRealEstate", "type": "esriFieldTypeString", "alias": "Fastighet", "length": 110, "domain": null }, { "name": "LocationDescription", "type": "esriFieldTypeString", "alias": "Lägesbeskrivning", "length": 100, "domain": null }, { "name": "RegistrationDate", "type": "esriFieldTypeDate", "alias": "Registrerat datum", "length": 8, "domain": null }, { "name": "TaskNo", "type": "esriFieldTypeString", "alias": "Åtgärdsnummer", "length": 20, "domain": null }, { "name": "TaskType", "type": "esriFieldTypeInteger", "alias": "Åtgärdstyp", "domain": { "type": "codedValue", "name": "WS6_PPM_TASKTYPE", "description": "", "codedValues": [ { "name": "För-V-ROV-Renovering", "code": 55 }, { "name": "För-V-ROV-Rörspräckn+infodring", "code": 56 }, { "name": "För-V-TRS-Trycksteg.stn", "code": 57 }, { "name": "För-V-ÖVF-Övrig förnyelse", "code": 58 }, { "name": "För-A-KOM-Lägga dagvattenled", "code": 59 }, { "name": "För-A-KOM-Lägga spillvattenled", "code": 60 }, { "name": "Utr-V-BES-Besiktning, Provning", "code": 67 }, { "name": "Utr-V-PKM-Punktvis mät/kontr.ins", "code": 68 }, { "name": "Utr-V-TRS-Trycksteg.stn, Utred", "code": 69 }, { "name": "Utr-V-URE-Fältmätning, Utredni", "code": 70 }, { "name": "Utr-V-ÖVU-Övrig utredning", "code": 71 }, { "name": "För-A-KOM-Komplettering, Nybyggn", "code": 61 }, { "name": "För-A-KOM-Utbyte hela brunnen", "code": 62 }, { "name": "För-A-PST-Pumpstation", "code": 63 }, { "name": "För-A-ÖVF-Övrig förnyelse", "code": 64 }, { "name": "För-A-ROV-Infodring, relining", "code": 65 }, { "name": "För-A-ROV-Renovering", "code": 66 }, { "name": "BAK", "code": 1 }, { "name": "BAN", "code": 2 }, { "name": "BAS", "code": 3 }, { "name": "BES", "code": 4 }, { "name": "BPS", "code": 5 }, { "name": "DAG", "code": 6 }, { "name": "FRE", "code": 7 }, { "name": "FYS", "code": 8 }, { "name": "HTS", "code": 9 }, { "name": "INN", "code": 10 }, { "name": "JUS", "code": 11 }, { "name": "KOM", "code": 12 }, { "name": "LVS", "code": 13 }, { "name": "LÄÖ", "code": 14 }, { "name": "MAK", "code": 15 }, { "name": "MEK", "code": 16 }, { "name": "OML", "code": 17 }, { "name": "OMS", "code": 18 }, { "name": "OSV", "code": 19 }, { "name": "RAT", "code": 20 }, { "name": "REL", "code": 21 }, { "name": "REP", "code": 22 }, { "name": "ROV", "code": 23 }, { "name": "RÅT", "code": 24 }, { "name": "SER", "code": 25 }, { "name": "SPR", "code": 26 }, { "name": "URE", "code": 27 }, { "name": "UTB", "code": 28 }, { "name": "VAB", "code": 29 }, { "name": "VEV", "code": 30 }, { "name": "ÖVH", "code": 31 }, { "name": "ÖVU", "code": 32 }, { "name": "DoU-V-JUS-Tillsyn, Justering", "code": 33 }, { "name": "DoU-V-JUS-Underhåll brandpost", "code": 34 }, { "name": "DoU-V-JUS-Reparation", "code": 35 }, { "name": "DoU-V-MEK-Luft/vattenspolning", "code": 36 }, { "name": "DoU-V-MEK-Spolning/rensning", "code": 37 }, { "name": "DoU-V-UPR-Underh PST/Reservoa", "code": 38 }, { "name": "DoU-V-VAB-Vattenbehandling", "code": 39 }, { "name": "DoU-V-ÖVH-Övrigt underhåll", "code": 40 }, { "name": "DoU-A-JUS-Tillsyn, justering", "code": 41 }, { "name": "DoU-A-KEM-Råttbekämpning", "code": 43 }, { "name": "DoU-A-MAK-Mekan rensn ovan mark", "code": 44 }, { "name": "DoU-A-MEK-Högtryck.spol, slamsug", "code": 45 }, { "name": "DoU-A-MEK-Rotskärning", "code": 46 }, { "name": "DoU-A-UPU-Underhåll Pstn", "code": 47 }, { "name": "DoU-A-ÖVH-Övrigt underhåll", "code": 48 }, { "name": "För-V-KOM-Lägga vattenled", "code": 49 }, { "name": "För-V-KOM-Komplettering, Nybyggn", "code": 50 }, { "name": "För-V-KOM-Utföra ny servis", "code": 51 }, { "name": "För-V-KOM-Sätta ny ventil", "code": 52 }, { "name": "För-V-OML-Omläggning", "code": 53 }, { "name": "För-V-ROV-Infodring, relining", "code": 54 }, { "name": "Utr-A-BES-Besiktning, Provning", "code": 72 }, { "name": "Utr-A-FLI-Flödeskontroll-manuell", "code": 73 }, { "name": "Utr-A-FRE-Flödeskontroll, Regist", "code": 74 }, { "name": "Utr-A-HYD-Hydrolo/Geohydrol.Kont", "code": 75 }, { "name": "Utr-A-PST-Pumpstation, utredning", "code": 76 }, { "name": "Utr-A-URE-Fältmätning, utredning", "code": 77 }, { "name": "Utr-A-ÖVU-Övrig utredning", "code": 78 }, { "name": "DoU-A-JUS-Reparation", "code": 79 }, { "name": "DoU-A-KEM-Kemisk/Termisk rens", "code": 42 }, { "name": "Skadestånd, avslag", "code": 102 }, { "name": "Skadestånd, utbetalt", "code": 101 }, { "name": "Ingen insats - IIS", "code": 100 }, { "name": "Råttbekämpning - RÅT", "code": 99 }, { "name": "Provtagning - KOK", "code": 98 }, { "name": "Info till invånare - UHÅ", "code": 97 }, { "name": "Kravställande på FÄ - UHÅ", "code": 96 }, { "name": "Utredning, drift - TIL", "code": 95 }, { "name": "Utredning, ej drift - TIL", "code": 94 }, { "name": "Tillsyn - TIL", "code": 93 }, { "name": "Filma - TIL", "code": 92 }, { "name": "Fräsning - BHA", "code": 91 }, { "name": "Byte av anordning - BAN", "code": 90 }, { "name": "Omkoppling/proppning - PRO", "code": 89 }, { "name": "Rotskärning - RAT", "code": 88 }, { "name": "Luft/vattenspol/mek rens - LVS", "code": 87 }, { "name": "Slamsugning/Spolning - HTS", "code": 86 }, { "name": "Underhållsspolning - SPR", "code": 85 }, { "name": "Repmuff/svep - RMU", "code": 84 }, { "name": "Reparation - REP", "code": 83 }, { "name": "Reelining - ISL", "code": 82 }, { "name": "Omläggning, del av sträcka - INF", "code": 81 }, { "name": "Omläggning, hel sträcka - OML", "code": 80 }, { "name": "Borttag föremål/Rensning - UHÅ", "code": 103 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Title", "type": "esriFieldTypeString", "alias": "Titel", "length": 60, "domain": null }, { "name": "StartDate", "type": "esriFieldTypeDate", "alias": "Startdatum", "length": 8, "domain": null }, { "name": "EndDate", "type": "esriFieldTypeDate", "alias": "Slutdatum", "length": 8, "domain": null }, { "name": "EventID", "type": "esriFieldTypeInteger", "alias": "Driftstörning ID", "domain": null }, { "name": "Priority", "type": "esriFieldTypeInteger", "alias": "Prioritet", "domain": { "type": "codedValue", "name": "WS6_PPM_PRIORITY", "description": "", "codedValues": [ { "name": "1", "code": 1 }, { "name": "2", "code": 2 }, { "name": "21", "code": 3 }, { "name": "22", "code": 4 }, { "name": "Mycket Hög prioritet", "code": 5 }, { "name": "Hög prioritet", "code": 6 }, { "name": "Normal prioritet", "code": 7 }, { "name": "Akutinsats", "code": 8 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Status", "type": "esriFieldTypeInteger", "alias": "Status", "domain": { "type": "codedValue", "name": "WS6_PPM_STATUS", "description": "", "codedValues": [ { "name": "Föreslagen", "code": 0 }, { "name": "Stängd", "code": 2 }, { "name": "Utförd", "code": 3 }, { "name": "Beslutad", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Responsible", "type": "esriFieldTypeInteger", "alias": "Ansvarig", "domain": { "type": "codedValue", "name": "WS6_PPM_RESPONSIBLE", "description": "", "codedValues": [ { "name": "ABS", "code": 1 }, { "name": "BAS", "code": 2 }, { "name": "BIP", "code": 3 }, { "name": "BOH", "code": 4 }, { "name": "EBS", "code": 5 }, { "name": "GEM", "code": 6 }, { "name": "GOH", "code": 7 }, { "name": "H.S", "code": 8 }, { "name": "H:S", "code": 9 }, { "name": "HH.", "code": 10 }, { "name": "HKN", "code": 11 }, { "name": "H-S", "code": 12 }, { "name": "IB", "code": 13 }, { "name": "JN", "code": 14 }, { "name": "JW", "code": 15 }, { "name": "KAA", "code": 16 }, { "name": "KEB", "code": 17 }, { "name": "KGE", "code": 18 }, { "name": "LS", "code": 19 }, { "name": "PB", "code": 20 }, { "name": "RAB", "code": 21 }, { "name": "SOA", "code": 22 }, { "name": "TG", "code": 23 }, { "name": "TH", "code": 24 }, { "name": "TU", "code": 25 }, { "name": "HKSM00", "code": 26 }, { "name": "KFEN00", "code": 27 }, { "name": "JMNM00", "code": 28 }, { "name": "HKSR00", "code": 29 }, { "name": "JNWN00", "code": 30 }, { "name": "TMKN00", "code": 31 }, { "name": "Beredskap", "code": 33 }, { "name": "HNAN15", "code": 32 }, { "name": "LARN14", "code": 35 }, { "name": "AAAN81", "code": 34 }, { "name": "DAHMN00", "code": 36 }, { "name": "Tidigare handläggare", "code": 37 }, { "name": "CNRG02", "code": 38 }, { "name": "LEFJ00", "code": 40 }, { "name": "MARR02", "code": 39 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SentDate", "type": "esriFieldTypeDate", "alias": "Skickat datum", "length": 8, "domain": null }, { "name": "AssignedTo", "type": "esriFieldTypeInteger", "alias": "Tilldelad", "domain": { "type": "codedValue", "name": "WS6_PPM_DONEBY", "description": "", "codedValues": [ { "name": "PKBT00", "code": 0 }, { "name": "KFEN00", "code": 1 }, { "name": "PoS", "code": 2 }, { "name": "VAD", "code": 3 }, { "name": "HSEN04", "code": 4 }, { "name": "Beställare", "code": 5 }, { "name": "LAMN20", "code": 6 }, { "name": "Anläggning", "code": 8 }, { "name": "Beredskap", "code": 7 }, { "name": "Teknik-VA", "code": 9 }, { "name": "Avlopp", "code": 10 }, { "name": "Lab - Sjöstad", "code": 11 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DoneBy", "type": "esriFieldTypeInteger", "alias": "Utförd av", "domain": { "type": "codedValue", "name": "WS6_PPM_DONEBY", "description": "", "codedValues": [ { "name": "PKBT00", "code": 0 }, { "name": "KFEN00", "code": 1 }, { "name": "PoS", "code": 2 }, { "name": "VAD", "code": 3 }, { "name": "HSEN04", "code": 4 }, { "name": "Beställare", "code": 5 }, { "name": "LAMN20", "code": 6 }, { "name": "Anläggning", "code": 8 }, { "name": "Beredskap", "code": 7 }, { "name": "Teknik-VA", "code": 9 }, { "name": "Avlopp", "code": 10 }, { "name": "Lab - Sjöstad", "code": 11 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FinishedDate", "type": "esriFieldTypeDate", "alias": "Avslutad datum", "length": 8, "domain": null }, { "name": "ApprovedBy", "type": "esriFieldTypeInteger", "alias": "Godkänd av", "domain": { "type": "codedValue", "name": "WS6_PPM_APPROVEDBY", "description": "", "codedValues": [], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ApprovedDate", "type": "esriFieldTypeDate", "alias": "Godkänt Datum", "length": 8, "domain": null }, { "name": "DocumentedBy", "type": "esriFieldTypeInteger", "alias": "Dokumenterad av", "domain": { "type": "codedValue", "name": "WS6_PPM_DOCUMENTEDBY", "description": "", "codedValues": [ { "name": "Används inte", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DocumentedDate", "type": "esriFieldTypeDate", "alias": "Dokumenterad", "length": 8, "domain": null }, { "name": "Account", "type": "esriFieldTypeInteger", "alias": "Konto", "domain": { "type": "codedValue", "name": "WS6_PPM_ACCOUNT", "description": "", "codedValues": [], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "EstimatedManTimeCost", "type": "esriFieldTypeDouble", "alias": "Uppskattad mantimmekostnad", "domain": null }, { "name": "EstimatedMachineCost", "type": "esriFieldTypeDouble", "alias": "Uppskattad maskinkostnad", "domain": null }, { "name": "EstimatedMaterialCost", "type": "esriFieldTypeDouble", "alias": "Uppskattad materialkostnad", "domain": null }, { "name": "EstimatedTotalCost", "type": "esriFieldTypeDouble", "alias": "Uppskattad totalkostnad", "domain": null }, { "name": "ActualManTimeCost", "type": "esriFieldTypeDouble", "alias": "Aktuell mantimmekostnad", "domain": null }, { "name": "ActualMachineCost", "type": "esriFieldTypeDouble", "alias": "Aktuell maskinkostnad", "domain": null }, { "name": "ActualMaterialCost", "type": "esriFieldTypeDouble", "alias": "Aktuell materialkostnad", "domain": null }, { "name": "ActualTotalCost", "type": "esriFieldTypeDouble", "alias": "Aktuell totalkostnad", "domain": null }, { "name": "InspectionTemplateID", "type": "esriFieldTypeInteger", "alias": "Kontrollmall ID", "domain": null }, { "name": "ResourceSetID", "type": "esriFieldTypeInteger", "alias": "Resurs ID", "domain": null }, { "name": "RemarkSetID", "type": "esriFieldTypeInteger", "alias": "Anmärkning ID", "domain": null }, { "name": "UserTask", "type": "esriFieldTypeSmallInteger", "alias": "Användaråtgärd", "domain": { "type": "codedValue", "name": "WS6_PPM_BOOLEAN", "description": "", "codedValues": [ { "name": "Falskt", "code": 0 }, { "name": "Sant", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PlanID", "type": "esriFieldTypeInteger", "alias": "PlanID", "domain": null }, { "name": "Workgroup", "type": "esriFieldTypeInteger", "alias": "Arbetsgrupp", "domain": { "type": "codedValue", "name": "WS6_PPM_WORKGROUP", "description": "", "codedValues": [ { "name": "Beställare", "code": 0 }, { "name": "Utförare", "code": 1 }, { "name": "Skadeståndshandläggare", "code": 2 }, { "name": "Miljöingenjör/Lab-personal", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ResponsibleWorkgroup", "type": "esriFieldTypeInteger", "alias": "Ansvarig arbetsgrupp", "domain": { "type": "codedValue", "name": "WS6_PPM_WORKGROUP", "description": "", "codedValues": [ { "name": "Beställare", "code": 0 }, { "name": "Utförare", "code": 1 }, { "name": "Skadeståndshandläggare", "code": 2 }, { "name": "Miljöingenjör/Lab-personal", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RegistrationTime", "type": "esriFieldTypeString", "alias": "Registrerat tid", "length": 5, "domain": null }, { "name": "AcceptedDate", "type": "esriFieldTypeDate", "alias": "Kvitterad datum", "length": 8, "domain": null }, { "name": "FinishedTime", "type": "esriFieldTypeString", "alias": "Avslutad tidpunkt", "length": 5, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Beskrivning", "length": 2000, "domain": null } ], "indexes": [ { "name": "R3018_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_3018", "fields": "GID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G2388EventID", "fields": "EventID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G2388InspectionT", "fields": "InspectionTemplateID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G2388PlanID", "fields": "PlanID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G2388RemarkSetID", "fields": "RemarkSetID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G2388ResourceSet", "fields": "ResourceSetID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I2388TaskNo", "fields": "TaskNo", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "Punkt", "relatedTableId": 62, "role": "esriRelRoleOrigin", "keyField": "GID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{6B478CBB-2EA2-4396-BCAF-DABA3291CCE2}" }, { "id": 3, "name": "Punkt", "relatedTableId": 63, "role": "esriRelRoleOrigin", "keyField": "GID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{6B478CBB-2EA2-4396-BCAF-DABA3291CCE2}" }, { "id": 4, "name": "Driftstörning", "relatedTableId": 65, "role": "esriRelRoleDestination", "keyField": "EventID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{9F98B8E1-BCCB-4B46-9E3B-7087F7F0EF84}" } ], "capabilities": "Map,Query,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 } }