{
 "currentVersion": 10.91,
 "id": 35,
 "name": "SIGNAL",
 "type": "Table",
 "description": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "ASTRUCTURENAME",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "CREATIONUSER",
   "type": "esriFieldTypeString",
   "alias": "Creation User",
   "length": 50,
   "domain": null
  },
  {
   "name": "DATECREATED",
   "type": "esriFieldTypeDate",
   "alias": "Date Created",
   "length": 8,
   "domain": null
  },
  {
   "name": "DATEMODIFIED",
   "type": "esriFieldTypeDate",
   "alias": "Date Modified",
   "length": 8,
   "domain": null
  },
  {
   "name": "LASTUSER",
   "type": "esriFieldTypeString",
   "alias": "Last User",
   "length": 50,
   "domain": null
  },
  {
   "name": "IPID",
   "type": "esriFieldTypeString",
   "alias": "Item Of Plant ID",
   "length": 90,
   "domain": null
  },
  {
   "name": "PARENTSIGNALIPID",
   "type": "esriFieldTypeString",
   "alias": "PARENTSIGNALIPID",
   "length": 90,
   "domain": null
  },
  {
   "name": "SIGNALSTATUS",
   "type": "esriFieldTypeString",
   "alias": "Signal Status",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "FiberStatus",
    "description": "Fiber and Signal Status",
    "codedValues": [
     {
      "name": "Available",
      "code": "1"
     },
     {
      "name": "Dark",
      "code": "2"
     },
     {
      "name": "Broken",
      "code": "3"
     },
     {
      "name": "Dead to Field",
      "code": "4"
     },
     {
      "name": "In Use",
      "code": "5"
     },
     {
      "name": "Unknown",
      "code": "6"
     },
     {
      "name": "Assigned",
      "code": "ASSIGNED"
     },
     {
      "name": "Stranded",
      "code": "STRANDED"
     },
     {
      "name": "Free",
      "code": "FREE"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "ACIRCUITID",
   "type": "esriFieldTypeString",
   "alias": "A Circuit ID",
   "length": 50,
   "domain": null
  },
  {
   "name": "ZCIRCUITID",
   "type": "esriFieldTypeString",
   "alias": "Z Circuit ID",
   "length": 50,
   "domain": null
  },
  {
   "name": "CIRCUITNAME",
   "type": "esriFieldTypeString",
   "alias": "Circuit Name",
   "length": 50,
   "domain": null
  },
  {
   "name": "ASEGMENTID",
   "type": "esriFieldTypeString",
   "alias": "A Segment ID",
   "length": 90,
   "domain": null
  },
  {
   "name": "ZSEGMENTID",
   "type": "esriFieldTypeString",
   "alias": "Z Segment ID",
   "length": 90,
   "domain": null
  },
  {
   "name": "AFIBERIPID",
   "type": "esriFieldTypeString",
   "alias": "A Fiber IPID",
   "length": 90,
   "domain": null
  },
  {
   "name": "ZFIBERIPID",
   "type": "esriFieldTypeString",
   "alias": "ZFIBERIPID",
   "length": 90,
   "domain": null
  },
  {
   "name": "AFIBERID",
   "type": "esriFieldTypeInteger",
   "alias": "A Fiber ID",
   "domain": null
  },
  {
   "name": "ZFIBERID",
   "type": "esriFieldTypeInteger",
   "alias": "Z Fiber ID",
   "domain": null
  },
  {
   "name": "AISFROMEND",
   "type": "esriFieldTypeString",
   "alias": "A Is From End",
   "length": 5,
   "domain": {
    "type": "codedValue",
    "name": "YesNoText",
    "description": "Yes\\No Text Values",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Y"
     },
     {
      "name": "No",
      "code": "N"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "ZISFROMEND",
   "type": "esriFieldTypeString",
   "alias": "Z Is From End",
   "length": 5,
   "domain": {
    "type": "codedValue",
    "name": "YesNoText",
    "description": "Yes\\No Text Values",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Y"
     },
     {
      "name": "No",
      "code": "N"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "ASTRUCTUREID",
   "type": "esriFieldTypeString",
   "alias": "A Structure ID",
   "length": 100,
   "domain": null
  },
  {
   "name": "ZSTRUCTUREID",
   "type": "esriFieldTypeString",
   "alias": "Z Structure ID",
   "length": 100,
   "domain": null
  },
  {
   "name": "ASTRUCTURENAME",
   "type": "esriFieldTypeString",
   "alias": "A Structure Name",
   "length": 100,
   "domain": null
  },
  {
   "name": "ZSTRUCTURENAME",
   "type": "esriFieldTypeString",
   "alias": "Z Sructure Name",
   "length": 100,
   "domain": null
  },
  {
   "name": "AEQUIPMENTID",
   "type": "esriFieldTypeString",
   "alias": "A Equipment ID",
   "length": 100,
   "domain": null
  },
  {
   "name": "ZEQUIPMENTID",
   "type": "esriFieldTypeString",
   "alias": "Z Equipemnt ID",
   "length": 100,
   "domain": null
  },
  {
   "name": "AEQUIPMENTNAME",
   "type": "esriFieldTypeString",
   "alias": "A Equipment Name",
   "length": 100,
   "domain": null
  },
  {
   "name": "ZEQUIPMENTNAME",
   "type": "esriFieldTypeString",
   "alias": "Z Equipment Name",
   "length": 100,
   "domain": null
  },
  {
   "name": "APORTID",
   "type": "esriFieldTypeInteger",
   "alias": "A Port ID",
   "domain": null
  },
  {
   "name": "ZPORTID",
   "type": "esriFieldTypeInteger",
   "alias": "Z Port ID",
   "domain": null
  },
  {
   "name": "AUNIQUEPORTID",
   "type": "esriFieldTypeString",
   "alias": "A Unique Port ID",
   "length": 50,
   "domain": null
  },
  {
   "name": "ZUNIQUEPORTID",
   "type": "esriFieldTypeString",
   "alias": "Z Unique Port ID",
   "length": 50,
   "domain": null
  },
  {
   "name": "APORTTYPE",
   "type": "esriFieldTypeString",
   "alias": "A Port Type",
   "length": 10,
   "domain": {
    "type": "codedValue",
    "name": "PortType",
    "description": "Port Type",
    "codedValues": [
     {
      "name": "Input",
      "code": "1"
     },
     {
      "name": "Output",
      "code": "2"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "ZPORTTYPE",
   "type": "esriFieldTypeString",
   "alias": "Z Port Type",
   "length": 10,
   "domain": {
    "type": "codedValue",
    "name": "PortType",
    "description": "Port Type",
    "codedValues": [
     {
      "name": "Input",
      "code": "1"
     },
     {
      "name": "Output",
      "code": "2"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "APORTNAME",
   "type": "esriFieldTypeString",
   "alias": "A Port Name",
   "length": 50,
   "domain": null
  },
  {
   "name": "ZPORTNAME",
   "type": "esriFieldTypeString",
   "alias": "Z Port Name",
   "length": 50,
   "domain": null
  },
  {
   "name": "FIBER_STATUS",
   "type": "esriFieldTypeString",
   "alias": "Fiber Status",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "SignalFiberStatus",
    "description": "Signal Fiber Status",
    "codedValues": [
     {
      "name": "Assigned",
      "code": "ASSIGNED"
     },
     {
      "name": "Free",
      "code": "FREE"
     },
     {
      "name": "Stranded",
      "code": "STRANDED"
     },
     {
      "name": "Spare",
      "code": "SPARE"
     },
     {
      "name": "Not Available",
      "code": "NOTAVAILABLE"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "OPTICAL_LENGTH",
   "type": "esriFieldTypeDouble",
   "alias": "Optical Length",
   "domain": null
  },
  {
   "name": "ASSIGNED_TO",
   "type": "esriFieldTypeString",
   "alias": "Assigned to",
   "length": 255,
   "domain": null
  },
  {
   "name": "CUSTOMER",
   "type": "esriFieldTypeString",
   "alias": "Customer",
   "length": 255,
   "domain": null
  },
  {
   "name": "COMMENTS",
   "type": "esriFieldTypeString",
   "alias": "Comments",
   "length": 255,
   "domain": null
  },
  {
   "name": "THREEGISID",
   "type": "esriFieldTypeGUID",
   "alias": "3-GIS ID",
   "length": 38,
   "domain": null
  },
  {
   "name": "GlobalID",
   "type": "esriFieldTypeGlobalID",
   "alias": "GlobalID",
   "length": 38,
   "domain": null
  },
  {
   "name": "EDITTRACKINGUSER",
   "type": "esriFieldTypeString",
   "alias": "EDITTRACKINGUSER",
   "length": 255,
   "domain": null
  },
  {
   "name": "EDITTRACKINGDATE",
   "type": "esriFieldTypeDate",
   "alias": "EDITTRACKINGDATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "CIRCUITID",
   "type": "esriFieldTypeString",
   "alias": "CIRCUITID",
   "length": 255,
   "domain": null
  },
  {
   "name": "ABLOCKNAME",
   "type": "esriFieldTypeString",
   "alias": "ABLOCKNAME",
   "length": 100,
   "domain": null
  },
  {
   "name": "ZBLOCKNAME",
   "type": "esriFieldTypeString",
   "alias": "ZBLOCKNAME",
   "length": 100,
   "domain": null
  },
  {
   "name": "auniquestructureid",
   "type": "esriFieldTypeString",
   "alias": "auniquestructureid",
   "length": 50,
   "domain": null
  },
  {
   "name": "zuniquestructureid",
   "type": "esriFieldTypeString",
   "alias": "zuniquestructureid",
   "length": 50,
   "domain": null
  },
  {
   "name": "status",
   "type": "esriFieldTypeString",
   "alias": "status",
   "length": 50,
   "domain": null
  },
  {
   "name": "complement",
   "type": "esriFieldTypeString",
   "alias": "complement",
   "length": 50,
   "domain": null
  },
  {
   "name": "attenuation",
   "type": "esriFieldTypeString",
   "alias": "attenuation",
   "length": 50,
   "domain": null
  },
  {
   "name": "ASTRUCTUREIPID",
   "type": "esriFieldTypeString",
   "alias": "ASTRUCTUREIPID",
   "length": 50,
   "domain": null
  },
  {
   "name": "ZSTRUCTUREIPID",
   "type": "esriFieldTypeString",
   "alias": "ZSTRUCTUREIPID",
   "length": 50,
   "domain": null
  },
  {
   "name": "assigned_virtualterminal",
   "type": "esriFieldTypeString",
   "alias": "assignedterminal",
   "length": 225,
   "domain": null
  },
  {
   "name": "planningid",
   "type": "esriFieldTypeGUID",
   "alias": "Planning Id",
   "length": 38,
   "domain": null
  },
  {
   "name": "isdelete",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Is Delete",
   "domain": null
  },
  {
   "name": "timestamp",
   "type": "esriFieldTypeDate",
   "alias": "Timestamp",
   "length": 8,
   "domain": null
  },
  {
   "name": "clonetype",
   "type": "esriFieldTypeString",
   "alias": "Clone Type",
   "length": 50,
   "domain": null
  },
  {
   "name": "isplanning",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Is Planning",
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R51_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "UUID_51",
   "fields": "GlobalID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "I141IPID",
   "fields": "IPID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "I141PARENTSIGNAL",
   "fields": "PARENTSIGNALIPID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "I141ASTRUCTURENA",
   "fields": "ASTRUCTURENAME,ASEGMENTID,AISFROMEND,AFIBERID,APORTTYPE,APORTID,AEQUIPMENTID,ASTRUCTUREID,AEQUIPMENTNAME",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "I141ZSTRUCTURENA",
   "fields": "ZSTRUCTURENAME,ZSEGMENTID,ZISFROMEND,ZFIBERID,ZPORTTYPE,ZPORTID,ZEQUIPMENTID,ZSTRUCTUREID,ZEQUIPMENTNAME",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "TGS_SIGNAL",
   "fields": "THREEGISID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 117,
   "name": "WAVELENGTHS",
   "relatedTableId": 64,
   "role": "esriRelRoleOrigin",
   "keyField": "IPID",
   "cardinality": "esriRelCardinalityManyToMany",
   "composite": false,
   "relationshipTableId": 105,
   "keyFieldInRelationshipTable": "SIGNAL_IPID"
  },
  {
   "id": 114,
   "name": "Contracts",
   "relatedTableId": 31,
   "role": "esriRelRoleOrigin",
   "keyField": "threegisid",
   "cardinality": "esriRelCardinalityManyToMany",
   "composite": false,
   "relationshipTableId": 104,
   "keyFieldInRelationshipTable": "SIGNAL_threegisid"
  }
 ],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 1000,
 "supportsStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON",
 "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
}