{
 "currentVersion": 10.7,
 "id": 123,
 "name": "SOMASTER.SO_Maintenance_History",
 "type": "Table",
 "description": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "NAME_OF_WORK",
 "typeIdField": "SUBTYPE",
 "subtypeFieldName": "SUBTYPE",
 "subtypeField": "SUBTYPE",
 "defaultSubtypeCode": 0,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "SUBTYPE",
   "type": "esriFieldTypeSmallInteger",
   "alias": "SUBTYPE",
   "domain": null
  },
  {
   "name": "SC_R_NO",
   "type": "esriFieldTypeString",
   "alias": "Street connection reference no.",
   "length": 10,
   "domain": null
  },
  {
   "name": "LINE",
   "type": "esriFieldTypeString",
   "alias": "Line identifination",
   "length": 100,
   "domain": null
  },
  {
   "name": "WORK_DATE",
   "type": "esriFieldTypeDate",
   "alias": "Survey or job application date(dd-mm-yyyy)",
   "length": 8,
   "domain": null
  },
  {
   "name": "NAME_OF_WORK",
   "type": "esriFieldTypeString",
   "alias": "Name of work",
   "length": 255,
   "domain": null
  },
  {
   "name": "PO_NUMBER",
   "type": "esriFieldTypeString",
   "alias": "PO Number",
   "length": 100,
   "domain": null
  },
  {
   "name": "EXECUTING_AGENCY",
   "type": "esriFieldTypeString",
   "alias": "Executing agency",
   "length": 100,
   "domain": null
  },
  {
   "name": "CATEGORY_OF_UPDATION",
   "type": "esriFieldTypeString",
   "alias": "Category of updation",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "SO_CATEGORY_OF_UPDATION\n",
    "description": "CATEGORY OF UPDATION\n",
    "codedValues": [
     {
      "name": "SURV_ST",
      "code": "0"
     },
     {
      "name": "SURV_GT",
      "code": "1"
     },
     {
      "name": "SURV_SCL",
      "code": "2"
     },
     {
      "name": "RPR_ST",
      "code": "3"
     },
     {
      "name": "RPR_GT",
      "code": "4"
     },
     {
      "name": "RPR_SCL",
      "code": "5"
     },
     {
      "name": "CONST_ST",
      "code": "6"
     },
     {
      "name": "CONST_GT",
      "code": "7"
     },
     {
      "name": "CONST_SCL",
      "code": "8"
     },
     {
      "name": "OTHER",
      "code": "99"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "REMARKS",
   "type": "esriFieldTypeString",
   "alias": "Remarks",
   "length": 255,
   "domain": null
  },
  {
   "name": "ED_OPERATOR",
   "type": "esriFieldTypeString",
   "alias": "Last updated by",
   "length": 50,
   "domain": null
  },
  {
   "name": "ED_DATETIME",
   "type": "esriFieldTypeDate",
   "alias": "Last updated on(dd-mm-yyyy)",
   "length": 8,
   "domain": null
  },
  {
   "name": "DOWN_NODE_NO",
   "type": "esriFieldTypeString",
   "alias": "DOWN_NODE_NO",
   "length": 50,
   "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": "CATEGORY_OF_WORK",
   "type": "esriFieldTypeString",
   "alias": "Category of Work",
   "length": 50,
   "domain": null
  },
  {
   "name": "NODE_NO",
   "type": "esriFieldTypeString",
   "alias": "Node No",
   "length": 50,
   "domain": null
  },
  {
   "name": "DLP_END_DT",
   "type": "esriFieldTypeDate",
   "alias": "Defect Liability End Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "NIS_NO",
   "type": "esriFieldTypeInteger",
   "alias": "NIS NO",
   "domain": null
  },
  {
   "name": "LINE_NEW",
   "type": "esriFieldTypeString",
   "alias": "LINE_NEW",
   "length": 30,
   "domain": null
  },
  {
   "name": "NODE_NO_NEW",
   "type": "esriFieldTypeString",
   "alias": "Node No (New Format)",
   "length": 15,
   "domain": null
  },
  {
   "name": "DOWN_NODE_NO_NEW",
   "type": "esriFieldTypeString",
   "alias": "Down Node No (New Format)",
   "length": 15,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R1175_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "types": [
  {
   "domains": {
    "CATEGORY_OF_UPDATION": {"type": "inherited"}
   },
   "id": 0,
   "name": "NA"
  },
  {
   "domains": {
    "CATEGORY_OF_UPDATION": {"type": "inherited"},
    "CATEGORY_OF_WORK": {
     "type": "codedValue",
     "name": "SO_MH_Maintenance",
     "description": "SO_MH_Maintenance",
     "codedValues": [
      {
       "name": "Raising of Buried Manhole",
       "code": "RBM"
      },
      {
       "name": "Fixing of Manhole Cover",
       "code": "FMC"
      },
      {
       "name": "Reconstruction of Manhole",
       "code": "RCM"
      },
      {
       "name": "Construction of new Manhole",
       "code": "CNM"
      },
      {
       "name": "Not Available",
       "code": "NA"
      },
      {
       "name": "Others",
       "code": "OTH"
      },
      {
       "name": "Cleaning data by comparing BIT map data from main sewer department",
       "code": "CCBD"
      },
      {
       "name": "Condition Assesment of Manhole",
       "code": "CNA"
      },
      {
       "name": "Repairs to Manhole",
       "code": "RTM"
      }
     ],
     "mergePolicy": "esriMPTDefaultValue",
     "splitPolicy": "esriSPTDefaultValue"
    }
   },
   "id": 1,
   "name": "Manhole"
  },
  {
   "domains": {
    "CATEGORY_OF_UPDATION": {"type": "inherited"},
    "CATEGORY_OF_WORK": {
     "type": "codedValue",
     "name": "SO_SL_Maintenance",
     "description": "SO_SL_Maintenance",
     "codedValues": [
      {
       "name": "Replacement / Repairs of Sewerline",
       "code": "RSL"
      },
      {
       "name": "Providing and Laying of Sewerline",
       "code": "PSL"
      },
      {
       "name": "Enlargement of Sewerline",
       "code": "ESL"
      },
      {
       "name": "Condition Assessment of Sewerline",
       "code": "CNA"
      },
      {
       "name": "Pipe Bursting of Sewer Line",
       "code": "PBS"
      },
      {
       "name": "Others",
       "code": "OTH"
      },
      {
       "name": "Not Available",
       "code": "NA"
      },
      {
       "name": "Cleaning data by comparing BIT map data from main sewer department",
       "code": "CCBD"
      },
      {
       "name": "REHAB by machine wound spiral linning",
       "code": "MWSL"
      },
      {
       "name": "Providing and Laying of Sewerline by microtunneling method",
       "code": "PSLM"
      },
      {
       "name": "REHAB by Cured-in Place Pipe",
       "code": "CIPP"
      },
      {
       "name": "REHAB by Glass Reinforced Plastic",
       "code": "GRFP"
      }
     ],
     "mergePolicy": "esriMPTDefaultValue",
     "splitPolicy": "esriSPTDefaultValue"
    }
   },
   "id": 2,
   "name": "Sewerline"
  },
  {
   "domains": {
    "CATEGORY_OF_UPDATION": {"type": "inherited"},
    "CATEGORY_OF_WORK": {
     "type": "codedValue",
     "name": "SO_VC_Maintenance",
     "description": "SO_VC_Maintenance",
     "codedValues": [
      {
       "name": "Others",
       "code": "OTH"
      },
      {
       "name": "Construction of New Vent Shaft",
       "code": "CVS"
      },
      {
       "name": "Shifting of Vent Shaft",
       "code": "SVS"
      },
      {
       "name": "Replacement of Vent Shaft",
       "code": "RVS"
      }
     ],
     "mergePolicy": "esriMPTDefaultValue",
     "splitPolicy": "esriSPTDefaultValue"
    }
   },
   "id": 3,
   "name": "Vent Shaft"
  }
 ],
 "subtypes": [
  {
   "domains": {
    "CATEGORY_OF_UPDATION": {"type": "inherited"}
   },
   "defaultValues": {
    "SUBTYPE": null,
    "SC_R_NO": null,
    "LINE": null,
    "WORK_DATE": null,
    "NAME_OF_WORK": "Street connection survey",
    "PO_NUMBER": "SO4-14-001",
    "EXECUTING_AGENCY": null,
    "CATEGORY_OF_UPDATION": null,
    "REMARKS": null,
    "ED_OPERATOR": null,
    "ED_DATETIME": null,
    "DOWN_NODE_NO": null,
    "CREATED_USER": null,
    "CREATED_DATE": null,
    "LAST_EDITED_USER": null,
    "LAST_EDITED_DATE": null,
    "CATEGORY_OF_WORK": null,
    "NODE_NO": null,
    "DLP_END_DT": null,
    "NIS_NO": null,
    "LINE_NEW": null,
    "NODE_NO_NEW": null,
    "DOWN_NODE_NO_NEW": null
   },
   "code": 0,
   "name": "NA"
  },
  {
   "domains": {
    "CATEGORY_OF_UPDATION": {"type": "inherited"},
    "CATEGORY_OF_WORK": {
     "type": "codedValue",
     "name": "SO_MH_Maintenance",
     "description": "SO_MH_Maintenance",
     "codedValues": [
      {
       "name": "Raising of Buried Manhole",
       "code": "RBM"
      },
      {
       "name": "Fixing of Manhole Cover",
       "code": "FMC"
      },
      {
       "name": "Reconstruction of Manhole",
       "code": "RCM"
      },
      {
       "name": "Construction of new Manhole",
       "code": "CNM"
      },
      {
       "name": "Not Available",
       "code": "NA"
      },
      {
       "name": "Others",
       "code": "OTH"
      },
      {
       "name": "Cleaning data by comparing BIT map data from main sewer department",
       "code": "CCBD"
      },
      {
       "name": "Condition Assesment of Manhole",
       "code": "CNA"
      },
      {
       "name": "Repairs to Manhole",
       "code": "RTM"
      }
     ],
     "mergePolicy": "esriMPTDefaultValue",
     "splitPolicy": "esriSPTDefaultValue"
    }
   },
   "defaultValues": {
    "SUBTYPE": null,
    "SC_R_NO": null,
    "LINE": null,
    "WORK_DATE": null,
    "NAME_OF_WORK": "Street connection survey",
    "PO_NUMBER": "SO4-14-001",
    "EXECUTING_AGENCY": null,
    "CATEGORY_OF_UPDATION": null,
    "REMARKS": null,
    "ED_OPERATOR": null,
    "ED_DATETIME": null,
    "DOWN_NODE_NO": null,
    "CREATED_USER": null,
    "CREATED_DATE": null,
    "LAST_EDITED_USER": null,
    "LAST_EDITED_DATE": null,
    "CATEGORY_OF_WORK": null,
    "NODE_NO": null,
    "DLP_END_DT": null,
    "NIS_NO": null,
    "LINE_NEW": null,
    "NODE_NO_NEW": null,
    "DOWN_NODE_NO_NEW": null
   },
   "code": 1,
   "name": "Manhole"
  },
  {
   "domains": {
    "CATEGORY_OF_UPDATION": {"type": "inherited"},
    "CATEGORY_OF_WORK": {
     "type": "codedValue",
     "name": "SO_SL_Maintenance",
     "description": "SO_SL_Maintenance",
     "codedValues": [
      {
       "name": "Replacement / Repairs of Sewerline",
       "code": "RSL"
      },
      {
       "name": "Providing and Laying of Sewerline",
       "code": "PSL"
      },
      {
       "name": "Enlargement of Sewerline",
       "code": "ESL"
      },
      {
       "name": "Condition Assessment of Sewerline",
       "code": "CNA"
      },
      {
       "name": "Pipe Bursting of Sewer Line",
       "code": "PBS"
      },
      {
       "name": "Others",
       "code": "OTH"
      },
      {
       "name": "Not Available",
       "code": "NA"
      },
      {
       "name": "Cleaning data by comparing BIT map data from main sewer department",
       "code": "CCBD"
      },
      {
       "name": "REHAB by machine wound spiral linning",
       "code": "MWSL"
      },
      {
       "name": "Providing and Laying of Sewerline by microtunneling method",
       "code": "PSLM"
      },
      {
       "name": "REHAB by Cured-in Place Pipe",
       "code": "CIPP"
      },
      {
       "name": "REHAB by Glass Reinforced Plastic",
       "code": "GRFP"
      }
     ],
     "mergePolicy": "esriMPTDefaultValue",
     "splitPolicy": "esriSPTDefaultValue"
    }
   },
   "defaultValues": {
    "SUBTYPE": null,
    "SC_R_NO": null,
    "LINE": null,
    "WORK_DATE": null,
    "NAME_OF_WORK": "Street connection survey",
    "PO_NUMBER": "SO4-14-001",
    "EXECUTING_AGENCY": null,
    "CATEGORY_OF_UPDATION": null,
    "REMARKS": null,
    "ED_OPERATOR": null,
    "ED_DATETIME": null,
    "DOWN_NODE_NO": null,
    "CREATED_USER": null,
    "CREATED_DATE": null,
    "LAST_EDITED_USER": null,
    "LAST_EDITED_DATE": null,
    "CATEGORY_OF_WORK": null,
    "NODE_NO": null,
    "DLP_END_DT": null,
    "NIS_NO": null,
    "LINE_NEW": null,
    "NODE_NO_NEW": null,
    "DOWN_NODE_NO_NEW": null
   },
   "code": 2,
   "name": "Sewerline"
  },
  {
   "domains": {
    "CATEGORY_OF_UPDATION": {"type": "inherited"},
    "CATEGORY_OF_WORK": {
     "type": "codedValue",
     "name": "SO_VC_Maintenance",
     "description": "SO_VC_Maintenance",
     "codedValues": [
      {
       "name": "Others",
       "code": "OTH"
      },
      {
       "name": "Construction of New Vent Shaft",
       "code": "CVS"
      },
      {
       "name": "Shifting of Vent Shaft",
       "code": "SVS"
      },
      {
       "name": "Replacement of Vent Shaft",
       "code": "RVS"
      }
     ],
     "mergePolicy": "esriMPTDefaultValue",
     "splitPolicy": "esriSPTDefaultValue"
    }
   },
   "defaultValues": {
    "SUBTYPE": null,
    "SC_R_NO": null,
    "LINE": null,
    "WORK_DATE": null,
    "NAME_OF_WORK": "Street connection survey",
    "PO_NUMBER": "SO4-14-001",
    "EXECUTING_AGENCY": null,
    "CATEGORY_OF_UPDATION": null,
    "REMARKS": null,
    "ED_OPERATOR": null,
    "ED_DATETIME": null,
    "DOWN_NODE_NO": null,
    "CREATED_USER": null,
    "CREATED_DATE": null,
    "LAST_EDITED_USER": null,
    "LAST_EDITED_DATE": null,
    "CATEGORY_OF_WORK": null,
    "NODE_NO": null,
    "DLP_END_DT": null,
    "NIS_NO": null,
    "LINE_NEW": null,
    "NODE_NO_NEW": null,
    "DOWN_NODE_NO_NEW": null
   },
   "code": 3,
   "name": "Vent Shaft"
  }
 ],
 "relationships": [],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 1000,
 "supportsStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON, AMF",
 "isDataVersioned": false,
 "useStandardizedQueries": true,
 "advancedQueryCapabilities": {
  "useStandardizedQueries": true,
  "supportsStatistics": true,
  "supportsHavingClause": true,
  "supportsCountDistinct": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsPagination": true,
  "supportsTrueCurve": false,
  "supportsReturningQueryExtent": true,
  "supportsQueryWithDistance": true,
  "supportsSqlExpression": true
 },
 "dateFieldsTimeReference": null
}